Dipak Kumar Email & Phone Number

Sunbury, Oh, Us

Columbus, Ohio Metropolitan Area

• Discovered profitable suppliers and initiate procurement partnerships.• Negotiated with external vendors to increase the scope of work, deliverables, and secure advantageous terms.• Participated in J0/J1 events along Japan team to understand the requirement and created detailed design document with cost estimation.• Performed a full analysis of business processes and flows, map them onto Dynamics 365 capabilities, determine gaps and develop solutions to fill them• Developed detailed project plans using Clarity PPM, ensuring resource availability, task planning and delivering every project on time within budget and scope.• Collaborated with various system managers and technical personnel during all project phases, from initial development through implementation and participated J0/J1 events with Japan, Canada, Mexico team.• Worked closely with multiple vendors and facilitate regular checkpoint meeting to see the progress and making sure to be on project schedule and within SOW timeline.• Creating monthly cost plan and forecasting semi-annual budget for various projects under RE-X program.• Currently leading cross-departmental teams of subject manager experts (SMEs), business process analysts (BPAs), IT PIC Leads, quality assurance specialists, network, and infrastructure admin, and/or external vendor to assess the impact and provide guidance on regular basis.• Managed 30+ resources through proper project task planning & Jira stories and providing clear direction and guidance to team members, monitoring their progress, and addressing any issues or conflicts that may arise.• Scheduled and facilitated meetings between system manager to discuss 3-month schedules, and conflicts.• Responsible to share and walkthrough on weekly/monthly status report to leadership team highlighting risks/challenges/issues if any.• Ensure that all assumptions, risks (with mitigation strategies), are comprehensive and accurate prior to review with system Owner and stakeholders.

United States

Client: JPMorgan Chase• Delivered $5M Real Time Payment migration for Chase to enhance feature of request for payment and reduce timeline to support business banking customers.• Developed an implementation business case for each company including scope, budget, resources, and schedule using MS 365• Successfully executed complex & large size Agile program with 30+ Team members (3 Scrum teams) spread across multiple geographies.• Managed projects with top-down oversight throughout entire execution to ensure success as defined by adherence to standards of scope, budget, SOW, and timeline.• Managed large-scale projects and introduced new systems, tools, and processes to achieve challenging objectives.• Collaborated with various managers and technical personnel during all project phases, from initial development through implementation.• Managed 50+ resources through proper project task planning & Jira stories.• Scheduled and facilitated meetings between project stakeholders to discuss deliverables, schedules, and conflicts.• Met 100% of deadlines and project goals, earning kudos from Client upon completing $2M project.• Conducted performance evaluations, compensations and hiring to maintain appropriate staffing requirements.• Provided strong leadership to enhance team productivity and morale.• Identified cost improvement changes and cost savings plans to increase company savings.• Prepared and submitted project invoices for review and approval.• Experience to create project plan/schedule per defined objectives and scope in the statement of work (SOW).• Ensure that all assumptions, risks (with mitigation strategies), and proposals are comprehensive and accurate prior to review with Project Owner and stakeholders.• Experienced with planning, budgeting and handled finance related activities like Project Revenue, POC report and Profit Margin.

Warwick, Rhode Island, United States

Client: Cigna Healthcare, MetLife, The Hartford Insurance Group• Planned, designed, and scheduled phases for large projects.• Managed 30+ resources via proper project task planning and revenue over 1 million successfully.• Identified project's goals, objectives, and scope and created project plan that outlines tasks, timelines, and resources required.• Managed an ongoing portfolio and roadmap of ERP-related projects to continuously gain new value from Dynamics 365 beyond implementation• Head complex ETL requirements and design for the new and existing project.• Implement an Informatica based ETL solution fulfilling stringent performance requirements.• Met project deadlines without sacrificing build quality or workplace safety.• Provided detailed project status updates to stakeholders and executive management.• Monitored project performance to identify areas of improvement and made an adjustment.• Provided detailed technical and operational direction in project challenges, consistently meeting deliverables according to deadlines.• Developed and implemented project plans and budgets to ensure successful execution.• Executed appropriate staffing and budgetary plans to align with business forecasts.• Tracked project and team member performance closely to quickly intervene in mistakes or delays.• Identified plans and resources required to meet project goals and objectives.• Coordinated with cross-functional teams to resolve project issues and mitigate risks.• Scheduled and facilitated meetings between project stakeholders to discuss deliverables, schedules, and conflicts.• Maintained open communication by presenting regular updates on project status to customers.• Monitored project progress, identified risks and took corrective action as needed.• Onshore -offshore coordination.

Nashville, Tennessee, United States

Client: Hospital Corporation of America (HCA)• Reviewed and understand the business requirements and technical specifications. • Analyzed, written, reviewed, and rewrote programs, and ensured the delivery and codes according to the HCA Code standards.• Worked on fixing the issues reported by users by coordinating with various specialized HCA teams.• Responsibility to have production up and running for data availability to business users within defined SLAs.• Conducted quality check before promoting reports to test environment.• Prepared Test Cases to test the code under various environments (Development, QA and Production).• Onsite-Offshore coordination.• Managed and developed large number of SAP Business Objects reports and Universe which is spread across several business segments. • Developed and maintained worldwide sales reporting platform.• Created Web Trend analysis reporting for marketing managers (Europe and US).• Migration of Business Objects reports from BO 5.x version to BO XI R2.• Provided weekly status report to Client Business Intelligence Manager supporting SAP BO and Teradata applications.

Pune, Maharashtra, India

Client: American Express (AMEX)• Created Source to Target mapping for Informatica workflows and creating Unix shell script to support business logic.• Developed and trained junior team members by leveraging industry experience to achieve optimal project strategy.• Scheduled and facilitated meetings between project stakeholders to discuss deliverables, schedules and conflicts.• Created data Modeling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling using ERWIN tool.• Designed and developed Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 10.5.• Onshore -offshore coordination.

Mumbai, Maharashtra, India

Client: General Electric (GE), Proctor & Gamble (P&G)• Requirements gathering for the new and existing project.• Created High level and Low-Level Design documents for ETL.• Designed of the ETL Mappings in Informatica to apply the Business Logic.• Created impact analysis documents and prepared Code Move Checklists.• Handled the Change Request through the ClarifyCRM tool for the ETL process and enhancing the mappings using Informatica.• Created UNIX shell scripts to rename, move files and send email notification etc. As per business needs.• Prepared Test Cases to test the code under various environments (Development, QA and Production.• Used Mapping parameters and variables to make mappings more flexible.• Provided Run time support for reconciliation from ETL side which involves Auto Assignment process and running different interfaces for each business.• Conducted daily/weekly/monthly status call with business, client and onsite.• Provided Knowledge Transfer to the new team members.• Involved in the supporting Team for Monitoring the Region wise Jobs through Ctrl-M Server.• Handled the Change Request for the ETL process and enhancing the mappings using Informatica • Played an integral role in maintaining coordination with the Onsite team in getting the Issues resolved and identify the defects also, get them resolved at the earliest.• Prepared Test Cases to test the code under various environments (Development, QA, Production • Monitored the Production Jobs (daily/monthly/quarterly) i.e., re-executing the Production jobs if failed by taking corrective action and informing the concerned people to take care of the downstream applications /processes.• Find out the errors if any production job gets fail and resolve within stipulated timeline.• Analyzed the data quality of the files and perform analysis of the problems.