Mukesh Gupta Email & Phone Number

Pune, Mh, In

• As Regional Delivery Head for a location, manages a team of around 60-70 professionals, ensuring timely delivery of high-quality solutions and driving overall project success.• Project planning, resource allocation and stakeholder management, ensuring alignment with business objectives.• Responsible for the gathering business requirement from external clients and understanding their business process, needs and pain points.• Collaborate across multiple stakeholder groups and… Show more • As Regional Delivery Head for a location, manages a team of around 60-70 professionals, ensuring timely delivery of high-quality solutions and driving overall project success.• Project planning, resource allocation and stakeholder management, ensuring alignment with business objectives.• Responsible for the gathering business requirement from external clients and understanding their business process, needs and pain points.• Collaborate across multiple stakeholder groups and multiple product line for system integration analysis to help in translating business requirement .• Responsible for reviewing and understanding the business requirements of our clients and the ability to convert business requirements into detailed functional specifications for use by the development team.• Designing ETL requirements, data mapping, Data warehouse concepts and experience in writing advanced SQL queries.•Creating Business Requirement Document , Functional Requirement Document, business process flow, performing data analysis, UI design, high-level data models and data entity relationship models, interface designing.• Collaborated with various teams including PO, developers, DBA, Support, Architect, Business Analyst and PM team; led fast-track product releases with onshore and offshore team members. • Expertise in full software life-cycle implementation, upgrades, production support, rollout & enhancement from business analysis, testing, cut-over & migration, go-live assistance till post implementation support.• Good team management skill and led many successful sprint teams.• Maintained HIPAA Compliance while conducting business with vendors, clients, and members Show less

Bhopal, Madhya Pradesh, India

Handling Business Analyst team. Requirement gathering from customers and analyzing it.Translating business requirement into functional requirement.Coordinating with other product line stakeholders, dev team, QA team, Architect, DBA, Product owner, project management team, support team.Developing business process flow, performing data analysis, UI design, high-level data models and data entity relationship models, interface designing.Handling… Show more Handling Business Analyst team. Requirement gathering from customers and analyzing it.Translating business requirement into functional requirement.Coordinating with other product line stakeholders, dev team, QA team, Architect, DBA, Product owner, project management team, support team.Developing business process flow, performing data analysis, UI design, high-level data models and data entity relationship models, interface designing.Handling day-to-day operational problems. Involved in preparing product manual and training materialsSupporting upgrades, production support, rollout & enhancement from business analysis, testing, cut-over & migration, go-live assistance till post implementation supportInvolved in whole Agile Sprint process starting from pre planning, Kick Off, Delivery till DemoWriting SQL queries to validate business scenarios and data validationInvolved in Sprint Estimation.Helping team to early identification of impediments and taking proper steps to resolve itUser Acceptance TestingLead QA team and coordinate project activities with onshore and offshore stake holder.Involved in development of Test cases, Test scripts from the data mapping documents, functional specification documents and mapped the test cases with the requirements for generating the Requirement Trace ability Matrix (RTM). Show less

Pune, Maharashtra, India

Translating business requirement into functional requirement.Coordinating with other product line stakeholders, dev team, QA team, Architect, DBA, Product owner, project management team, support team.Developing business process flow, performing data analysis, UI design, high-level data models and data entity relationship models, interface designing.Handling day-to-day operational problems. Involved in preparing product manual and training… Show more Translating business requirement into functional requirement.Coordinating with other product line stakeholders, dev team, QA team, Architect, DBA, Product owner, project management team, support team.Developing business process flow, performing data analysis, UI design, high-level data models and data entity relationship models, interface designing.Handling day-to-day operational problems. Involved in preparing product manual and training materialsSupporting upgrades, production support, rollout & enhancement from business analysis, testing, cut-over & migration, go-live assistance till post implementation supportInvolved in whole Agile Sprint process starting from pre planning, Kick Off, Delivery till DemoWriting SQL queries to validate business scenarios and data validationInvolved in Sprint Estimation.Helping team to early identification of impediments and taking proper steps to resolve itUser Acceptance TestingLead QA team and coordinate project activities with onshore and offshore stake holder.Involved in development of Test cases, Test scripts from the data mapping documents, functional specification documents and mapped the test cases with the requirements for generating the Requirement Trace ability Matrix (RTM). Show less

Pune Area, India

ETL has been introduced recently to transfer data from all data sources into DW and then analytic would be running on this data to help business to come up with strategies to increase company revenue and to make future decisions.ROLES:-• Lead team and coordinate project activities with onshore and offshore stake holders• Worked with Architect, Requirement Analysts, Developers and other testers to resolve issues with requirements/mapping transformations.• Extensively… Show more ETL has been introduced recently to transfer data from all data sources into DW and then analytic would be running on this data to help business to come up with strategies to increase company revenue and to make future decisions.ROLES:-• Lead team and coordinate project activities with onshore and offshore stake holders• Worked with Architect, Requirement Analysts, Developers and other testers to resolve issues with requirements/mapping transformations.• Extensively tested PL/SQL batch processes, PL/SQL programs - Packages, Functions, Stored Procedures, Cursors, and Triggers according to the requirements.• Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.• Worked with the ETL processes to extract the data from sources like Oracle, Flat files thereby loading the data into the target Data warehouse.• Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.• Reviewed database business and functional requirements, reviewed mapping transformations.• Scheduling and automating jobs to be run in a batch process.• Responsible in testing Initial and daily loads of ETL jobs.• Interacted with design team to decide on the various dimensions and facts to test the application.• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.• Prepared Test Scenarios by creating Mock data based on the different test cases.• Extensively tested several Micro Strategy Reports for data quality.• Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Trace ability Matrix (RTM). Show less

Project Description:- Retail Pharmacy System is an ideal software solution for chain pharmacies and high-volume independents. Roles And Responsibilities :• Involved in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios, estimation.• Involved in whole Agile Sprint process starting from pre planning, Kick Off, Delivery till Demo.• Writing SQL queries to validate… Show more Project Description:- Retail Pharmacy System is an ideal software solution for chain pharmacies and high-volume independents. Roles And Responsibilities :• Involved in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios, estimation.• Involved in whole Agile Sprint process starting from pre planning, Kick Off, Delivery till Demo.• Writing SQL queries to validate business scenarios and data validation.• Helping team to early identification of impediments and taking proper steps to resolve it• Handling the issues found during Test Case Design and Test Execution and communicating it to Client.• Mentoring and knowledge transfer session to team members. Show less

Pune Area, India

Client :- AT & TProject Desciption :-Light Speed is an AT & T’s initiative for providing customer the facility of IP TV, High speed internet (HISA broadband) and Voice over IP (CVOIP) at the same time through optical fiber so that the customers can have more options and more flexibility to choose from. This Project has many systems which are interlinked with each other like Amdocs CRM (customer relationship management) known as Amdocs CLARIFY, OMS (order management system) and AMSS… Show more Client :- AT & TProject Desciption :-Light Speed is an AT & T’s initiative for providing customer the facility of IP TV, High speed internet (HISA broadband) and Voice over IP (CVOIP) at the same time through optical fiber so that the customers can have more options and more flexibility to choose from. This Project has many systems which are interlinked with each other like Amdocs CRM (customer relationship management) known as Amdocs CLARIFY, OMS (order management system) and AMSS (Amdocs self service) and many of the middle ware involved.Roles And Responsibilities :• Involved in UAT phase.• Involved in end to end testing of AT & T Lightspeed service. • Experience in Amdocs CRM (customer relationship management), OMS (order management system) and AMSS (Amdocs self service) and Billing system• System Testing and Production support Testing• Analyzing and Understanding Functional Specification documents.• Involved in Test Case Design and Review. • Involved in Test Case Execution and peer review of Test Case Execution.• Defect Reporting & Tracking in Quality Center.• Handling the issues found during Test Case Design and Test Execution and communicating it to Client. Show less

Pune Area, India

Client : CCH - Workflow Management & PracticeProject Desciption:-CCH ProSystem fx is a professional software system that integrates and manages tax processing and office administration smoothly and efficiently. This software has many modules which are interlinked with each other like Tax Prep, FAM, WFM, Production Processing, and Practice. Workflow Management lets you track workflow, allocate resources, and monitor due dates. You do this by setting up projects and, if… Show more Client : CCH - Workflow Management & PracticeProject Desciption:-CCH ProSystem fx is a professional software system that integrates and manages tax processing and office administration smoothly and efficiently. This software has many modules which are interlinked with each other like Tax Prep, FAM, WFM, Production Processing, and Practice. Workflow Management lets you track workflow, allocate resources, and monitor due dates. You do this by setting up projects and, if applicable, the tasks associated with the project. Roles And Responsibilities :• Writing SQL queries to validate business scenarios and data validation• System Testing and Production support Testing• Analyzing and Understanding Functional Specification documents.• Test Case Design. • Test case Design Review • Test Case Execution.• Performed Re-testing and Regression Testing• Manual and Exploratory Testing. Show less