Sumit Sinha Email & Phone Number

Hyderabad, In

Pleasanton, Ca, Us

Oakland, California, Us

• Utilized Informatica migration tool – RPA Utility and worked towards converting KPWA Power Center assets to IDMC(IICS) assets• Converted IDMC assets to ensure the logic remains unchanged as in Power Center code• Involved in Data Testing which involved the running of Power Center Code and converting IDMC code with same set of source data and compare the results of both the runs• Additionally worked towards handling Weekly/Monthly status report, Cost estimates for resources and their forecast.• Developed the architecture for Master/Reference Data, Data Warehouse and Integration for data processing• Ensured adherence to ETL Architecture by developing phase and quality assure code to ensure fulfilling requirements • Led end to end ETL process and worked towards architecture improvements.• Analyzed the requirements and sketched them with possible timelines for moving to Production• Provide effort estimation and resource planning for multiple projects• Established excellent liaison with business users, senior managers, testing teams and cross-functional teams• Ensured on time delivery by spearheading the offshore team and delegated work to them• Created advanced data integration workflows by sourcing data from multiple sources using Informatica Power Center, enhancing data consolidation and accessibility.• Engineered and implemented a Data Mart for the NIS Sales Team, utilizing Informatica Power Center to effectively load data from diverse sources, thereby improving data management and analysis capabilities.• Conducted extensive performance tuning to optimize long-running jobs and SQL queries, significantly improving processing efficiency and reducing execution time.• Prepared and presented weekly/monthly status reports, estimated resource costs, and conducted resource forecasting to ensure project alignment and efficient resource allocation.

Data Modeler• Acted as Data Modeler & developed data mart for Interval data based on the new reporting requirements• Developed logical and physical data models for interval data using ERwin• Created data warehouse and data mart models, enabling efficient data analysis and reporting for business intelligence purposes.• Developed and implemented database objects such as tables, views and stored procedures.Informatica Lead• Developed phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture. • Involved in resource planning and liaised with business users, senior managers, testing teams and cross functional teams• Created PL/SQL Packages, Procedures, Functions, Triggers & accountable for performance tuning the long running Informatica jobs • Worked toward proper implementation of standard data quality checks, validation rules and error handling mechanism in Informatica mappings/mapplets to ensure data integrity • Developed High Level Design (HLD) and Low-Level Design(LLD) Document of Informatica processes and inventory details.

Toronto, Ontario, Ca

• Adhered to ETL architecture, monitored Informatica code and Unit test cases • Mentored a team of 8 members and worked towards detailed technical design and provided KT to functional testing team• Organized daily technical discussions with the Onsite team including the individual offshore developers and set expectations for offshore delivery.• Managed Weekly/Monthly status report and contributed towards Cost estimates for resources and their forecast

Johannesburg, Gauteng, Za

• Developed Master Data and Usage Stream with 6 members offshore/onsite. Created ETL processes according to business requirements and incorporated all business requirements into design specification document.• Served as Point of contact for any changes related to Master Data and Usage subject area and worked towards performance tuning • Monitored Informatica code, Unit test cases and results with developers• Served as Data Modeler for Master Data and Usage Stream and developed Logical and Physical data models using best practices to ensure high data quality and reduce redundancy

Prague, Czech Republic, Cz

• Managed detailed technical design and developed complex ETLs & Technical Specification documents from the provided Business Requirement Document• Contributed towards data modelling and target table design• Worked towards reporting tool, Business Object development & preparation of the other technical documentation including the design documents, test plans and Implementation plans.

Bachelor Of Science (Bsc) In Computer Applications, Computer Science

Master Of Computer Applications - Mca