Pragya Singh
Bengaluru,KA
Summary
Versatile leader with 10 years of experience in Leadership & Data Engineering, adept at navigating diverse roles from Developer, Data Analyst, Business Analyst to Data Engineer. Demonstrated expertise in mentorship, seamlessly transitioning across domains. Encouraging manager and analytical problem-solver with talents for team building, customer relations, and independent decision-making. Dedicated to streamlining operations, enhancing employee engagement, and promoting organizational efficiency
Overview
10
10
years of professional experience
8
8
Certification
Work History
Assistant Manager
KPMG Global Services, KGS
03.2020 - Current
- Led cloud projects on Azure ETL ecosystem (Azure Data Factory, Azure Storage Account Gen 2, Azure SQL Database, Azure DevOps).
- Contributed to stakeholder management, requirement analysis, estimation, architectural design, cost optimization, data retention, operational management, clear communication, delivery excellence, and continuous process improvement.
- Drove six production deployments in 10 months, enhancing Power BI Dashboards and Azure SQL database.
- Created and deployed Power BI dashboards with complex data modeling, DAX, and optimization techniques for various business domains and stakeholders with customized requirements, including Tableau migration.
- Developed ADF pipelines and data flows and excelled in SQL scripting for database optimization and maintenance, managing Azure SQL Database operations.
- Managed Azure DevOps board for sprint maintenance, task tracking, and continuous integration/deployment.
- Designed and implemented 150+ Alteryx Workflows, optimizing existing apps and simplifying complex logic.
- Developed presentation videos and Python utilities for campus hiring posters.
- Actively involved in training programs, hiring, business cultivation, and employee engagements, etc.
- Planned, designed, and scheduled phases for large projects
- Analyzed project performance data to identify areas of improvement
- Aligned project goals with organizational objectives for consistent strategic direction across all initiatives
- Established strong working relationships with key stakeholders by maintaining open lines of communication, demonstrating empathy, and collaborating on mutually beneficial solutions
- Established performance goals for employees and provided feedback on methods for reaching those milestones.
Senior Business Analyst
Ameriprise Financials LLC
12.2017 - 02.2020
- Led 15+ strategic projects, saving 1.4K hours with SAS, VBA, Power BI, Alteryx, and MS Access.
- Maintained 85% success rate in understanding requirements and drafting use cases.
- Involved in mailbox handling activities, financial adjustments, reporting, and QA.
- Analyzed competitive landscape, prioritized customers, and implemented feedback-driven changes.
- Executed risk analysis and identified mitigation strategies.
- Built complex SAS scripts for precise payouts and automation, saving 1.5K hours and $52K.
- Automated 6 utilities, identified opportunities for process improvements.
- Engaged in Salesforce Migration Metrics Program, developed user-friendly Excel and VBA tools.
- Translated SAS scripts into SOPs, migrated manual reports to automation.
- Created dashboards for non-selling profiles, summarized dealer commissions and asset management.
- Delivered various Power BI dashboards for elite program and practice ranking calculations.
- Estimated performance for cost-effective solutions using Alteryx, explored Big Data strategies.
- Analyzed data to identify root causes of problems and recommend corrective actions
- Collaborated with cross-functional teams, ensuring a cohesive approach to business analysis
Programmer Analyst
Cognizant Technology Solutions
04.2015 - 11.2017
- Delivered diverse reports, including Sales, Activity, Prescriber, and Patient levels, utilizing analytical platforms.
- Managed customer data integrity, ensuring synchronization across SQL server and Master Data Management (MDM) systems.
- Led client deliveries, adapting to dynamic business changes and contributing to data management.
- Automated processes, such as transitions and Excel dashboard migration, enhancing operational efficiency.
- Cleansed sales data and streamlined analytics by storing essential fields using SQL.
- Enhanced user experience through UI component pagination and JSP development.
- Prepared comprehensive documentation and test cases for application modifications and updates.
- Implemented Spring Batch to streamline database record updates, ensuring data accuracy and consistency.
Technical Support Specialist
IBM India Pvt Ltd
08.2014 - 12.2014
- Handled client IT issues via ITES skills, call handling, Outlook check, and MS Office.
- Promptly responded to support requests, guiding users through basic troubleshooting.
- Contributed to internal knowledge base for faster issue resolution.
- Diagnosed and resolved client issues via call/email after standard troubleshooting.
- Created procedural documents for efficient ticket resolution and met targets.
- Emphasized empathy while addressing client concerns.
- Utilized standard questions to troubleshoot and understand issues.
- Monitored pending tickets regularly to prevent backlog.
- Maintained detailed documentation of interactions for reference.
- Enhanced customer satisfaction by resolving issues promptly.
- Evaluated user problems using test scripts and probing questions.
Education
B. Tech/B.E - Electronics/Telecommunications
GLBITM
Greater Noida, UP08.2014
Skills
- Databases: Microsoft SQL Server
Cloud: Azure Data Factory, Azure Synapse Analytics, Azure Data bricks, Azure SQL Database, Azure DevOps - Programming Skills: SQL, VBA, Base SAS
- Visualization Tools: Power BI
- Data Management Tool: Alteryx
- Microsoft Suite: Advance MS Excel, Access, Word, PowerPoint
- Project and Team Management
- Stakeholder Management
- Effective Communication and Documentation
- Recruitments and Business Operations
Certification
- Alteryx – Micro Credential (Data Analyst and ML), Core and Advance
- Microsoft Azure – AZ900, AI900
- Certified Scrum Master (CSM)
Languages
English
Advanced (C1)
Hindi
Bilingual or Proficient (C2)
Timeline
Assistant Manager
KPMG Global Services, KGS
03.2020 - Current
Senior Business Analyst
Ameriprise Financials LLC
12.2017 - 02.2020
Programmer Analyst
Cognizant Technology Solutions
04.2015 - 11.2017
Technical Support Specialist
IBM India Pvt Ltd
08.2014 - 12.2014
B. Tech/B.E - Electronics/Telecommunications
GLBITM
- Alteryx – Micro Credential (Data Analyst and ML), Core and Advance
- Microsoft Azure – AZ900, AI900
- Certified Scrum Master (CSM)
Similar Profiles
Miruthula NehruMiruthula Nehru
Audit Associate at KPMG (KGS)Audit Associate at KPMG (KGS)
Akshay SachdevaAkshay Sachdeva
Senior Audit Associate at KPMG Resource Centre Pvt Ltd/ KPMG Global Services (UK Division)Senior Audit Associate at KPMG Resource Centre Pvt Ltd/ KPMG Global Services (UK Division)
Ammar FaruqiAmmar Faruqi
Senior Merchandiser at GLOBAL SUSITABLE SOURCING(FORMER NAME KGS)Senior Merchandiser at GLOBAL SUSITABLE SOURCING(FORMER NAME KGS)