Vikas Prajapati

Software Engineer

Delhi, India3 yrs 11 mos experience

Key Highlights

  • Reduced report generation time by 70% with automation.
  • Improved data accuracy by 80% through validation.
  • Designed dashboards enhancing fraud detection accuracy.
Stackforce AI infers this person is a Data Analyst with expertise in SaaS and Fintech industries.

Contact

Skills

Core Skills

Data AnalysisBusiness IntelligenceData Visualization

Other Skills

Python (Programming Language)Data ArchitectsMicrosoft Power BISnowflakePythonSQLPandasNumPyPower BIAnalytical SkillsInterpersonal SkillsExcelData LoadingTableauMacros

About

I’m a data analyst who loves turning numbers into clear stories that help people make better decisions. Over the past few years, I’ve worked on projects that improved how teams understand their data, saving time and uncovering insights that were easy to miss. I enjoy working with tools like SQL, Python, Power BI, and Excel to find patterns, clean messy data, and create dashboards that actually make sense to everyone and not just technical folks. At Baker & Taylor, I’ve had the chance to work on both finance and operations data, helping teams track performance, manage payments, and spot trends early. I believe good data work is not about fancy charts, but about making life easier for others. Outside of work, I’m always learning , exploring new ways to solve problems, automate small tasks, and share what I learn with others. let’s connect.

Experience

3 yrs 11 mos
Total Experience
1 yr 8 mos
Average Tenure
6 mos
Current Experience

Confidential

Analytics Engineer

Nov 2025Present · 6 mos · Hyderabad, Telangana, India · Remote

Python (Programming Language)Data Architects

Baker & taylor

Data Analyst

Jun 2024Oct 2025 · 1 yr 4 mos · Noida, Uttar Pradesh, India · Hybrid

  • 1. Optimized data processing pipelines, reducing execution time by 40% through efficient use of Python, Pandas, and NumPy.
  • 2️⃣ Developed an automated reporting system using Python and SQL, improving report generation speed by 70% and reducing manual effort.
  • 3️⃣ Designed and developed Power BI dashboards for AML monitoring and compliance reporting, improving fraud detection accuracy.
  • 4️⃣ Enhanced code efficiency by 30% by refactoring legacy Python scripts, reducing redundancy and improving maintainability.
  • 5️⃣ Implemented data integrity constraints and triggers in SQL, preventing 90% of erroneous entries in transactional databases.
  • 6️⃣ Designed SQL-based risk assessment models, identifying transaction anomalies and enhancing due diligence in KYC/AML analytics.
  • 7️⃣ Automated missing value imputation using Python, improving dataset completeness by 40% for predictive models.
  • 8️⃣ Created advanced SQL reports with CTEs and window functions, reducing reporting time by 40% and improving business insights.
  • 9️⃣ Optimized SQL queries, boosting ERP software performance by 20%, and implemented indexing & partitioning, achieving 35% faster query execution.
  • 🔟 Collaborated with US-based clients to develop and optimize 20+ Power BI reports, cutting manual reporting time by 80%.
  • 1️⃣1️⃣ Reduced KYC processing time by 25% by collaborating with risk, compliance, and tech teams to streamline workflows.
  • 1️⃣2️⃣ Collected, cleaned, and validated large datasets, increasing data accuracy and quality by 80% using Python and SQL.
  • 1️⃣3️⃣ Built and maintained real-time dashboards to track key business KPIs, enabling faster decision-making.
  • 1️⃣4️⃣ Developed Excel-based pricing models, refining pricing strategies and improving financial decision-making.
  • 1️⃣5️⃣ Conducted process training for teams, empowering them to derive deeper insights from data.
  • 1️⃣6️⃣ Automated data consolidation with Excel macros and VBA scripts, improving financial reporting accuracy by 20% and efficiency by 30%.
Microsoft Power BISnowflakePythonSQLPandasNumPy+2

Integral infogen technologies pvt ltd

Data Analyst

Mar 2022Apr 2024 · 2 yrs 1 mo · Gurugram, Haryana, India · Hybrid

  • 1️⃣ Transforming 9️⃣0️⃣% raw data into actionable insights on Microsoft Excel, increasing informed decision-making within the organization.
  • 2️⃣ Collecting, cleaning, and validating large datasets from various sources, which increased data accuracy and quality by up to 9️⃣5️⃣%.
  • 3️⃣ Analyzed 🔟,0️⃣0️⃣0️⃣+ entry datasets in Excel, driving a 1️⃣6️⃣% improvement in client outcomes.
  • 4️⃣ Actively collaborated with cross-functional teams, translating technical findings into actionable strategies and recommendations that contributed to the company's growth and efficiency.
  • 5️⃣ Created macros that reduced the time in the data cleaning process by up to 8️⃣0️⃣%.
  • 6️⃣ Optimized 1️⃣0️⃣0️⃣+ SQL queries, increasing ERP software performance by 2️⃣0️⃣%.
  • 7️⃣ Worked extensively on procedures and functions.
  • 8️⃣ Migrated 🔟,0️⃣0️⃣0️⃣+ objects from Oracle database to PostgreSQL.
  • 9️⃣ Contributed significantly to end-to-end product development, steering 3️⃣ successful launches.
  • 🔟 Led 4️⃣+ members of diverse teams.
  • 1️⃣1️⃣ Collaborated with stakeholders for dedicated software implementation, leading to a 3️⃣0️⃣% increase in project efficiency.
  • 1️⃣2️⃣ Liaised between business and technical personnel to ensure a mutual understanding of processes and publications.
  • 1️⃣3️⃣ Conducted data audits that identified 1️⃣0️⃣0️⃣+ errors, inconsistencies, or gaps in data.
Analytical SkillsInterpersonal SkillsSQLData AnalysisBusiness Intelligence

Education

Guru Gobind Singh Indraprastha University

BCA

Aug 2017Jul 2020

Stackforce found 100+ more professionals with Data Analysis & Business Intelligence

Explore similar profiles based on matching skills and experience