Ruchi Shivhare

• Tools Used – IICS Informatica, HCM Connect, SQL Server 2018

Responsibilities (Informatica)-

• Collaborated with project managers to select ambitious, but realistic coding and Production Promotion milestones for release of new features.
• Deliver new data integration solutions using IICS – used Source (csv, excel), Target, Joiner, Expression, Router, Filter, Union, Java transformations.
• Enhanced the existing Integration Mappings using IICS - uploaded parameters to Cloud to remove variable coded in the Interface.
• Worked on Implementation documents to document mapping changes, Testing (Reconciliation) documentation with test results and Production Promotion documents.
• Designed and Implemented Reconciliation and Production Promotion documents that became a part of process at GCE.
• Documented technical workflows and knowledge to educate newly hired employees.

Responsibilities (HCM Connect)-

• Coordinated HCM refreshes and testing.
• Took care of post refresh validations and changes - Banner, Logo, setting environment etc.
• Worked on enhancing and creating Custom HCM Reports.
• Used ELE Expressions to hide Connect features.

• Tools Used - SSAS, PowerCenter Informatica, SQL Server 2012/2016

Responsibilities -

• Delivered ETL packages to import data into the database tables.
• Run SQL queries or Stored Procedures to investigate data issues. Communicate with Business to get the data fixed.
• Writing SQL scripts to get data fixed.
• Responsible for upkeep of Informatica workflows. Debugging and problem resolution in the workflows if any issue came up.
• Work on SQL Server migrations between servers. Responsible for end point identification, configuration file changes, verifying if job was successful, fixed errors if any
• Responsible for ETL-SSIS job upgrade to run on new SQL Server 2016, which included upgrading the SQL driver version in packages as well as configuration files, building and executing the packages from visual studio, fixing any errors and saving the package on server.

• Tools Used - SSIS, MS-SSAS, SQL, Tableau, Azure

Responsibilities -

• Created automated packages on Business Intelligence tool SSIS that imports data, applies business logic and stores output files as per client specification
• Created OLAP cubes using Microsoft SSAS to create data marts for different teams that helps them verify the data easily without accessing database
• Worked with Azure blob storage & Tableau
• Worked on Stored procedures to implement repeatedly used SQL queries.

• Excel, SQL
• Lead a team of 2 interns to solve business problems
• Created Problem statements
• Created Anylogic simulation models, to simulate the current and proposed situations to help management compare these systems without investing capital on changes on a real time
• Created documents for the tasks undertaken
• Well versed with using process mining tool; Disco; to map business processes which helped us learn about the roadblocks in the current established process