Dinesh Sharma

Seasoned IT professional with over 20 years of experience in project management and cloud architecture. Proven track record in building client relationships, driving profitable growth, and leading global teams. Demonstrates strong financial management, operational oversight, and a commitment to enhancing customer satisfaction.

• At Atos Syntel Limited, HCA (Hospital Corporation of America), Client : Hospital Corporation of America, Nashville U.S.A, ETL Tool : DMEexpress, Reporting Tool : MicroStrategy, PowerBI, Business Objects, Database : Teradata, GCP BQ, OS : Windows, Team : 14 members, Duration : Aug'17 – Till Date, Role : Senior Project Manager, Work Location : Nashville/Pune (Onsite/Offshore), Project Details, HCA is one of the largest Health care Insurance providers in USA., Contributions :, Interaction with clients and business teams for the reporting requirements and to co-ordinate the efforts with the on/offshore team, Generated a revenue of $3.5 million in the DW BI space for Atos Syntel, To Assist in Functional and Technical Design and Understanding customer requirements for Retail Business intelligence and Data warehousing requirements to meet their business growth, Creation of Design documents and conveying functional & Technical requirements to offshore team and ensuring offshore team understanding the requirements well enough to proceed with Report application construction, Regularly monitor of the construction of Reports progress and provide periodic status updates to Syntel and Customer stakeholders and also Unit Testing of the BI Report and Defect fixing of any design in the reports
• At Atos Syntel Limited, THD (The Home Depot), Client : The Home Depot, Atlanta U.S.A, ETL Tool : Ablinitio, Reporting Tool : MicroStrategy 9.4.1, Database : Teradata, OS : Windows, Team : 14 members, Duration : Sep'11 – Jul'17, Role : Project Manager, Work Location : Atlanta/Chennai (Onsite/Offshore), Project Details :, The Home Depot is one of the largest home improvements retailers in USA., Contributions :, Interaction with clients and business teams for the reporting requirements and to co-ordinate the efforts with the on/offshore team, Generated a revenue of $2.5 million plus every year from 2012 in the EDW BI space for Syntel, To Assist in Functional and Technical Design and Understanding customer requirements for Retail Business intelligence and Data warehousing requirements to meet their business growth, Creation of Design documents and conveying functional & Technical requirements to offshore team and ensuring offshore team understanding the requirements well enough to proceed with Report application construction, Regularly monitor of the construction of Reports progress and provide periodic status updates to Syntel and Customer stakeholders and also Unit Testing of the BI Report and Defect fixing of any design in the reports.
• At Atos Syntel Limited, MFI (Musician's Friend), Client : Guitar Center Corporation, U.S.A, ETL Tool : Datastage, Reporting Tool : MicroStrategy, Database : Netezza, OS : Windows, Team : 11 members, Duration : Nov'09 – Sep'11, Role : Senior Project Lead, Work Location : Chennai (Offshore), Project Details :, It's a USA's largest music retail outlet with around 219 chains of stores across US. Guitar Center is divided into GC, MAC (Music & Arts Company) and MF (Musician's Friend)., Contributions :, Working on the performance tuning for some of the MSTR Complex Reports., Interacting with the Business/clients on day to day basis and understanding their requirement and passing it to team members., Efficiently creating and interacting with the client and business users in the project right from scratch to production and migration., Started off with a one member and brought up to 26 member team with short span of 11 months.
• At Accenture Services Private Limited, WCH-BI - Wyeth Consumer Health Care – Business Intelligence, Client : Wyeth, USA, ETL Tool : Informatica, Reporting Tool : MicroStrategy, Database : Oracle, OS : Windows, Team : 6 members, Duration : Jul'08 – Nov'09, Role : Senior MicroStrategy Report and Project Developer, Work Location : Bangalore (Offshore), Project Details :, Created reports in MicroStrategy for Wyeth the Worlds No 5 Pharma & Health Care. Was coordinating of three applications like SRS, WIN and Kalido. Thoroughly involved with onshore while creating reports and continuously interacting for the built stage. There will be a number of business users for the narrowcast Services in the Wyeth business and finance who will utilize the reporting., Contributions :, Involved in creating ETL Design Deliverables, Technical design, source to target mapping document for Pinnacle Point Advance Reporting under Rebates & Reward Program as an ETL Developer., Involved in schema objects and report development and in project migration., Involved in MicroStrategy administration, security design and development., Involved in the WEB, Desktop development., Involved in creating security filters, users, project settings and WEB settings., Business Event Qualifier, Client : AMEX, USA, ETL Tool : Informatica, Reporting Tool : MicroStrategy, Database : DB2, OS : UNIX, Team : 6 members, Duration : Apr'07 – Jul'08, Role : Senior MicroStrategy Report and Project Developer, Work Location : Mumbai (Offshore), Project Details :, BEQ DW automates promotional bonusing capabilities and facilitates scalability in promotion execution, flexibility in calculation and fulfillment, timely bonus delivery to card members., Contributions :, Involved in creating Report Design Deliverables, functional design, layout & mapping document for BEQ DW Reporting under Rebates & Reward Program as Senior MicroStrategy Report Developer., Involved in schema objects and report development., Involved in MicroStrategy administration, security design and development., Involved in the Narrowcast Server development., Involved in the design of Narrowcast Server development., Involved in the WEB, Desktop, Narrowcast Administration., Involved in creating security filters, users, project settings and WEB settings., Involved in development as well as modification to reports of various releases of BEQ DW like USMR, Co Brand, Statement Credit, Acquisition Phase1, RTB, Acquisition Phase2 and MRAB., Acquired strong understanding of:, The requirement of Automated Promotional Bonusing and BEQ DW various releases like USMR (US Membership Rewards), Cobrand, Statement Credit and Acquisition Phase1., The requirement for new releases like Acquisition Phase2 and MRAB (Membership Reward Account Level Bonusing)., Conducted the regression testing for release5 of RRDW application i.e. RTB Real Time Bonusing., Delivered the key design deliverable for RRDW application releases Acquisition Phase2 and MRAB (Membership Reward Account Level Bonusing), Actively involved in:, Driving the build and test activities of ETL components in Informatica., The Implementation phase of Rebates and Rewards Data warehousing (RRDW) application release 3 (Statement Credit)., Integration testing, user acceptance test and implementation plan activities for Rebates and Rewards Data warehousing (RRDW) application release 4 (Acquisitions phase 1).
• At Covansys India Private Limited, GAP, Client : GAP, USA, ETL Tool : Informatica, Reporting Tool : MicroStrategy, Database : Oracle, OS : Windows, Team : 6 members, Duration : Dec'06 – Apr'07, Role : Senior MicroStrategy Report and Project Developer, Work Location : Chennai (Offshore), Project Details :, GAP one of the largest retail outlets in USA. Project involve building a data warehouse to analyze the total stock quantity from various warehouse which it has across globe and different vendors from various different countries and related to stocking of the products and overall details of the GAP retails stores which is spread across 5 countries This tool also tells the user the complexity of the code., Contributions :, Understood the GAP Application as part of the analysis phase of SDLC (Software Development Life Cycle) and worked on the design document of Visio module., Understanding the database., Interacting with onshore and client on day to day basis, Logical dimensional Modeling and Physical dimensional Modeling and build the data warehouse., Configured and designed analytical reports through MicroStrategy 8.0, Build reports in MicroStrategy 8.0Web, Delivered one successful release.
• At OBSI Technologies Private Limited, ACMA CHINA, Client : ACMA (Automotive Component Manufacturer's Association), ETL Tool : Informatica, Reporting Tool : MicroStrategy, Database : Oracle, OS : Windows, Team : 5 members, Duration : Jun'06 – Dec'06, Role : MicroStrategy Report and Project Developer, Work Location : Delhi (Offshore), Project Details :, This ACMA Project Involve Building a data warehouse to analyze the Total Sales and Total Production Quantity for the China data related to Whole Vehicle (Passenger Car, MPV, SUV, Mini van, Light Bus, Light Truck, and Mini Truck), Semi-Tractor Vehicle and Chassis. (Heavy Duty Truck, Large Bus, Medium Truck, Medium Bus), Contributions :, Understanding the database., Logical dimensional Modeling and Physical dimensional Modeling and build the data warehouse., Build BI Project through MicroStrategy 8.0, Configured and designed analytical reports through MicroStrategy 8.0, Developed the web parts and established the environment at offshore., Reports through mail by Narrowcast Server and created scorecard and dashboards, Imported the Knowledge Transfer back to offshore teams., Created statistical tables for the project.
• At OBSI Technologies Private Limited, CRIS Chennai, Client : CRIS (Centre of Railway of Information System), Chennai, ETL Tool : Informatica, Reporting Tool : MicroStrategy, Database : Oracle, OS : Windows, Team : 4 members, Duration : Oct'05 – Jun'06, Role : MicroStrategy Report and Project Developer, Work Location : Chennai (Offshore), Project Details:, CRIS wanted Reports for Southern and South Western region and built reports on Dropped Passengers Data, Passengers and Earning Data, Extra Coaches Added, Cancellation, Booking Patterns, Utilization and Special train's. The Goal of the project is to build an Enterprise Data warehouse and perform analytical reporting on the warehouse using Micro strategy 7.5.3., Contributions :, Understanding the database., Developing PL/SQL procedures to load from staging tables to fact tables and Other Data warehouse tables., Logical dimensional Modeling and Physical dimensional Modeling and build the Data warehouse., Build BI Project through MicroStrategy 7.5.3, Configuring and designing analytical reports through MicroStrategy 7.5.3, Building reports in MicroStrategy 7.5.3 Web
• At MMC Infotech Services Private Limited, CBOL (Citibank Online), Client : CBOL (Citibank Online), Chennai, Reporting Tool : MS Excel, Database : Oracle, OS : Windows, Team : 8 members, Duration : Aug'03 – Oct'05, Role : Developer/Tester, Work Location : Chennai (Offshore), Project Details :, Electronic Banking Application is a net banking application (CBOL), which has the following features transaction Report, Balance Enquiry, Utility Payments. Preparing test cases to solve the customer queries with regard to credit card transactions and implementing with automated tools like winrunner and load runner. Testing the performance of the letter quality, which is being sent to customers with zero defects. Checking the resolution quality (RQ) and letter quality (LQ). Preparing Test execution and Test log preparation from the Test cases and finally handling the defect tracking to store the defects and preparing the Test reports., Contributions :, Design of Test case, Test case Execution and Test Reporting., Defect Tracking and Reporting, Maintenance of Quality Systems, Part of TQM (Total Quality Management) Team, Preparation of Test Cases, Functional & Performance testing of existing application.