SUMMARY:

• Highly qualified senior level consultant with proven track record of more than 13 years of Delivery, Techno functional and architecture design experience.
• Core expertise in delivering complex SQL Server logics, ETL, Data warehousing and Data Quality solutions within Insurance, HR and aviation domain.
• Building and leading successful delivery teams. ed and recognized many times for business and delivery of complex projects.
• Good Communication skills and ability to work in team as ‘Floating Consultant’ with same spirit when work independently.
• Talent for communicating and solving complex problems, leading development teams, improving data management, automating and integrating systems as well as delivering projects on time.
• Experience in working on RFP (Response for Proposal) & POC (Proof of concept).
• Knowledge Upgrades and Grooming Team Members
• Multiple End to End product development experience in workforce analytics.
• Creating user stories, conceptual screens for the requirement analysis of products solution spanning over technologies like SSIS, SQL, QlikView.
• Continuous clarifications/feedbacks to the development team.
• Manage the stakeholder expectation on delivery timelines and outcomes.
• Experience in gathering the Business Requirements and converting them into Technical Specification/ Sub Stories and tasks.
• Designed a generic data ingestion tool that can load any format file to Raw/Staging layer.
• Designed Data Validation and Reconciliation Engine.
• SME of ETL (data integration) designing, development, optimization, configuration, debugging, documentation as well as deployment SSIS.
• Design the stored procedures, views and functions for consumption of .Net and QlikView purposes.
• Requirement Analysis with Client interaction.
• Hands on experience of designing and implementing enhancement DWH used to support Major Client in Aviation Domain (Data warehouse, ETL, Cube, incremental data loading in cube db, reporting using SSRS).
• Extensively worked and designed Interfaces between Warehouse and Financial Systems.
• Performance Optimizations for Client Loads.
• Part of various technical upgrades that involved upgrading of SSIS packages from .

TECHNICAL SKILLS:

• Databases: Microsoft SQL Server 2000, 2005, 2008 R2, 2012,2014
• ETL Tool: SSIS and DTS
• Languages: VB6,VB.net,C#
• Reporting Tools: Power BI and Qlikview

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Work with client in understanding the requirements.
• Lead the team of KPMG resources deployed on the project.
• Implementing and optimizing the complex logic in SQL, developing stored procedures and views.
• Create detail design, work on development and perform code reviews of self and team.
• It is a visualization tool which determines the gap pay gap between genders.
• The front end is a Qlikview dashboard which displays the pay gap based on various dimensions e.g. location, age band, Length of service band, job level etc. it calculates mean and median of pay and provides flexibility to user to view data based on various components f pay such as overtime, bonus.
• Work directly with client in understanding the requirements
• Implementing and optimizing the complex logic in SQL, developing stored procedures and views.
• Share daily status of the offshore team with the onshore team
• Create detail design, work on development and perform code reviews.

Confidential

Responsibilities:

• Three roles of leading the delivery, business analyst, product owner and data architect on the project.
• Established client’s confidence by streamlining the processes using scaled agile and delivering in tight deadlines with less pressure on team.
• Generate BRD and user stories for sprints.
• Design conceptual pages for the user journey flow.
• Writing technical specification.
• Designing overall architecture and data model for the tool.
• Implementing and optimizing the complex logic in SQL and SSIS.

Confidential

Responsibilities:

• Writing technical specification.
• Designing overall architecture and data model for the tool.
• Implementing and optimizing the complex logic in SQL and SSIS.
• Design automated validation and reconciliation modules.

Confidential

Responsibilities:

• Work directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements.
• Design SSIS packages and stored procedures/views/functions as per requirement of the client.
• Share daily status of the offshore team with the onshore team
• Create detail design, work on development and perform code reviews.
• Support existing data warehouse reporting platform and applications to ensure operational availability.

Data Warehouse

Confidential

Responsibilities:

• Work directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements.
• Design SSIS packages and stored procedures/views/functions as per requirement of the client.
• Share daily status of the offshore team with the onshore team
• Create detail design, work on development and perform code reviews.
• Provide 24/7 support for existing data warehouse reporting platform and applications to ensure operational availability.

Confidential

Responsibilities:

• Work directly with business users in understanding the information needs of the business and developing new tools to meet these requirements.
• Design DTS packages and stored procedures/views/functions as per requirement of the tool.
• Coding in C#,VB6,VB.net and ASP.net