ROHIT AGARWAL

Project Name 1: Life Sciences

Client: Pharma

Role: Assistant IT Consultant

Team Size: 6

Project Duration: Dec’19 – Till date

• Collaborated with pharmaceutical client to lead data integration efforts in Boston, MA.
• Worked with data warehousing SMEs to understand business needs.
• Led offshore team of 6 by providing task guidance and mentoring.
• Assigned user roles on IDMC Platform and managed account access.
• Applied advanced techniques to execute a range of transformations in IDMC data integration workflows.
• Developed code for data integration using various transformations in IDMC based on specific business needs.
• Utilized multiple transformation techniques in IDMC to construct efficient task flows, tasks, and mappings.
• Conceptual knowledge of APIs, working on processes, Service connectors, Swagger and WSDL files
• Utilized POSTMAN tool proficiently for checking outputs of various API requests.
• Providing operational support to the existing integrations of PowerCenter
• Collaborated on transforming legacy PC integrations into modern IICS task flows.
• Managing migration of approximately 2000+ assets using PC to IICS conversion tools.
• Engaged in development of test scripts and their execution.
• Delivered support for troubleshooting diverse technical problems.
• Engaged in discussions during scheduled client calls to resolve issues and communicate progress.
• Ensured adherence to defined SLA by overseeing and responding to ServiceNow ticket inquiries.

Project Name 2: Life Sciences

Client: Sunovion

Role: Assistant IT Consultant

Team Size: 6

Project Duration: Dec’18 – OCT'19

• Involved in Developing/ Enhancing application ETL code using IPC as per the client’s request.
• Currently involved in re-platforming existing integrations from Informatica Power center to IICS.
• Majorly involved in developing IICS CDI integrations.
• Involved in monitoring of jobs, provide RCA and fixes to the failures.
• Monitored user-raised tickets and delivered accurate solutions within defined priorities and SLA.
• Contributed to IPC 9.6 to 10.1 upgrades by testing code and migrating workflows of ongoing applications.
• Prepared comprehensive design and technical specification documents.
• Designed and developed various mappings, sessions, and workflows using Informatica PowerCenter and Unix.
• Analyzing issues and providing a quick and permanent fix for failures.
• Participated in process enhancement tuning/efforts to achieve time savings.

• Company Overview: Wipro Ltd (NYSE: WIT) is a global information technology, consulting, and outsourcing company with 170,000+ workforce serving clients in 175+ cities across 6 continents
• Genpact EDW Team is responsible for providing the support on various applications that are being used by the users, which help the users to ease their life
• Maintained HR data warehouse with historical and current data.
• All the details of their employees across all the regions are maintained in this warehouse
• It helps the high management to extract the reports from HR data warehouse as per their management needs and thus make it a powerful tool for analysis and decision making for their employees across all the poles
• Access and privileges to users for extracting different reports is also granted by the EDW team

Project Name: Enterprise Data Warehouse (EDW)

Client: Genpact

Role: Senior Software Engineer

Team Size: 7

Project Duration: Jul’16 – Aug’18

• Responsible for supporting and maintaining the applications under EDW team, so as the users does not face any challenges
• Participated in monthly and quarterly reconciliation activities to identify overlooked employee attritions.
• Monitored user-generated tickets to offer accurate solutions within set priority and SLA.
• Ensuring that the SLA does not miss of any incident to avoid any breach
• Used Informatica Workflow Manager & Monitor to Create, Schedule, Unscheduled and Monitor the jobs
• Performed optimization of mappings to enhance job performance and minimize execution time.
• Implementing new ideas (Alone/Team Activity) and sharing it with higher colleagues which can help improving the process further

• Company Overview: Mercer is a leading global provider of consulting, Outsourcing and investments services, and serving over 25,000 clients worldwide
• Mercer’s global network of 19,000+ employees, based in 42+ countries, help clients maximize the effectiveness of their employee health, welfare, and retirement programs, and optimize workforce performance while managing costs
• It is a reporting solution tool, helping them use their HR data to understand and analyze their workforce and to better utilize their data to spot and resolve issues and for decision making
• The solution contains dashboard, scorecards, and summary level interacting reports, plus employee level detail reports to back them up
• It provided a complete package based on HR knowledge, well thought of HR data warehouse and intuitive report designing to make a powerful analytics tool

Project Name: Enterprise Workflow Analysis (EWA)

Clients: HR data Management

Role: Lead Implementation Analyst

Team Size: 5

Project Duration: Sep’15 – Apr’2016

• Designed the ETL processes using Informatica tool to load data from File system, and Oracle into the target Oracle database
• Developed mappings/sessions using IPC for data loading
• Used most of the Transformations such as Source Qualifier, Aggregator, Expressions, Lookups, Stored Procedures, Filter, Joiner, and Sequence Generator etc
• Used Informatica Workflow Manager & Monitor to Create, Schedule, and Monitor and Send the Messages in case of process failures
• Test mapping to assure that data is loaded as per ETL Specification
• Involved in creation of monthly dashboard to showcase the in-sights and work done over the month to the senior management