SOMMYA MEHTA
Data Analytics And Integration Engineer
Gurgaon
Summary
Sales performance management techno-functional consultant with 7+ years of experience, working on projects across Digital Transformation and Sales and Marketing Transformation. Adept at transforming, receiving and monitoring data from multiple data streams, bringing forth the ability to synthesize quantitative and qualitative information. Experience in working with leadership of Fortune 500 companies across sectors including Technology, Telecom and FMCG, projects across US, across various project phases including requirement gathering, offshore and onshore.
Overview
10
10
years of professional experience
5
5
years of post-secondary education
Work History
Senior Consultant
Deloitte US
Gurgaon
12.2014 - Current
- Analyzed existing functionality of compensation systems, and problematic areas to provide recommendations and solutions that could increase revenue, thus offering optimized solutions, that saves money and effort
- Developed multiple functional and technical design documents as part of Offshore/Onshore requirement gathering, through constant client interaction (hold valid work visa for US)
- Worked on Informatica and SQL, developing multiple mappings for data flow between multiple upstream and downstream systems, apart from designing extremely flexible payroll system integrations
- Worked on Web IDE for HANA to automate multiple manual commission calculation processes and territory management
- Worked on Mulesoft and GitHub. Created mappings for data flow between various transaction, order management and payee management tools like Zuora, Workday and NetSuite and connected them to downstream Sales Compensation toll like Varicent and Callidus.
- Extensively worked on developing stored procedures and creating pipelines in ADF (Azure data factory), apart from co-designing overall data architecture.
- At multiple instances, lead team of 6+ members while working on enhancements and support post Go Live.
- Developed solutions using Service Oriented Architecture Patterns and cloud-based services
- Active member of innovation team, came up with various accelerators that can help speed up project planning and staffing, and additionally analyze complexity of any client based on market trends
- Worked with complex datasets and trained new hires to work with them as well
- Served as primary point of contact for multiple client service teams for several projects
- Improved performance, hiring practices and management systems to facilitate success of client's and own organization.
- Delivered outstanding service to clients to maintain and extend relationship for future business opportunities.
- Aligned closely with business owners and employees to gather information and gain operational insight.
Software Engineering Analyst
Accenture Services Private Limited
Gurgaon
01.2013 - 12.2014
- Performed in-depth data validation on data from various upstream sources.
- Worked with Power Center tools like Designer, Workflow Manager, Workflow Monitor and Repository Manager.
- Extracted data from Oracle database, SAP sources and other sources and staged into single location and applied business logic to load them into central SAP system.
- Worked on Toad for executing SQL scripts, loading data in intermediate tables and validation of data. Worked on complex queries that had embedded logic for 4+ interfaces.
- Implemented performance tuning logic on source, workflows and mappings to provide maximum efficiency and performance.
- Worked with Business Managers, Team Leads and end users to correlate business logic and Specifications for ETL development.
Education
Bachelor of Technology - Computer Science
Uttarakhand Technical University
Dehradun 08.2008 - 08.2012
Senior Secondary - Mathematics And Computer Science
Kendriya Vidyalaya
Pithoragarh 04.2007 - 05.2008
Skills
SAPC (Callidus Cloud)Web IDE HANAInformatica-Power Center
Azure Data Factory
PL/SQL
Microsoft Visio
Microsoft Excel
Requirement Gathering
Data Analytics
Mulesoft
Timeline
Senior Consultant
Deloitte US
12.2014 - Current
Software Engineering Analyst
Accenture Services Private Limited
01.2013 - 12.2014
Bachelor of Technology - Computer Science
Uttarakhand Technical University
08.2008 - 08.2012
Senior Secondary - Mathematics And Computer Science
Kendriya Vidyalaya
04.2007 - 05.2008