Snehal Sonandkar

Big Healthcare Client in Paris- Senior IICS Developer

• Worked on IICS Chloe2.0 migration project as Senior IICS Developer.
• Analyzed existing IICS CDI & CAI Process and ERP Application Interfaces and updated design specification based on new target.
• Identified & Migrated IICS Cloud Data Integration assets, Cloud Application Integration assets, parameter files, script files components to newly developed platform for various critical applications and established connectivity with new applications setup.
• Involved in design discussions with core development team from to understand interface specifications as part of requirement gathering.
• Conducted End to End testing calls of all interfaces with all key stakeholders. helped team members as well as Vendor Partner team to debug issues.
• Supported on P1 issues as part of Hyper Care.
• Used postman to debug API related issues.
• Received appreciations from Client for turnaround time for important issues.

Technology used : IICS Cloud Data Integration, Cloud Application Integration, PostgreSQL database, Oracle, Unix Scripts, Control-M

• Client is one of the biggest Insurance companies in Australia.
• It is required to separate data from existing Oracle Datawarehouse to Azure based SQL server Datawarehouse based on certain functional data rules.
• Also, Data Marts are built to improve Data Quality and performance of Power BI reports over cloud.
• Responsibilities:
• Working with team size of 20+ people. Leading Multiple tracks with 6+ Team.
• Working on Cloud Datawarehouse Migration Project from SQL server Azure to Snowflake. It also includes re-engineering current IICS jobs to work efficiently without affecting any Business Process.
• Actively participated in getting requirements from reverse engineering team which is converting Oracle PL-SQL code into IICS requirements.
• Actively participated into development of complex IICS mappings using Hierarchy Parser, Hierarchy Builder in multiple tracks.
• Designed Master Taskflows to load complete data for different systems.
• Worked on different built-in APIs in Informatica and Implemented them into Project.
• Participated in multiple POCs to analyze performance of existing jobs in other Databases like Azure Synapse and Snowflake. Worked directly with Microsoft and Snowflake teams to get the necessary inputs.
• Independently performed complex troubleshooting, root-cause analysis and solution development.
• Implemented different Automations to reduce manual efforts and dependency by 50%.
• Technology used : IICS, SQL Server on Azure, Unix Scripts, Control-M

• German based Client manages financial assets on behalf of institutional and retail clients globally.
• To perform various analysis and take decisions, client needs data from various sources in the form of files.
• Informatica team is responsible to pull files from various sources and provide it to client server on scheduled time.
• Responsibilities:
• Worked as Lead of team size of 6 people.
• Actively participated in discussion sessions with international client for requirement gathering.
• Developed end to end solutions using Informatica to generate files from various sources to client server.
• Helped Higher level managers on Cloud Data Migration Proposal & Documentation(RFPs).
• Developed File error handling and file missing mechanism to avoid file/data loss. It helped end user to get quick notifications about the data/files missing issues.
• Applied various automations in Informatica to identify failures and recovery of the jobs which has improved efficiency by 20%.It has also reduced efforts of 1 FTE.
• Performed Analysis to ensure there is no gap in delivery of data files. Successfully delivered all the deliverables of Projects on Time.
• Identified ways to increase efficiency of production support - Find solutions that allow operations to better do their job without involving development resource time.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Identified problems in existing production data and developed one-time scripts to correct them.
• Received an Award for Outstanding Performance in IT from Client.
• Technology used: Informatica 10.1,SQL server,Unix scripts,encryption-decryption.

• European Client provides trade credit insurance, surety and collections services worldwide through a presence in more than 50 countries around the globe.
• Data is provided in the form of flat files as well as in oracle Database.
• Client is in need of building a data warehouse and data marts to analyze their business through various aspects by running Cognos queries on top of DataMarts.
• Responsibilities:
• Working with team size of 12 people.
• Actively participated in discussion sessions with BA to design ETL job flow.
• Compiled source to target mapping documents to design ETL jobs.
• Modified and tested Views and PL/SQL stored procedures.
• Created highly performance improved queries and Mappings.
• Performed Analysis to ensure there is no gap in previously built data marts.
• Technology used: Informatica 10.2 ,Oracle 11g ,MRF, PVCS, Control-M

• Ecoaxis - IOT projects & Time series Data
• REPORT initiative's objective was to provide a standardized means for transforming, calculating and reporting of the customer survey data received from various sources for client reporting purposes.
• This system will provide standardized reporting process for customer study data.
• The project objective was to integrate different departments/DB into new specialty department DSS data repository
• Responsibilities:
• Involved in all phases of IOT Project SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirements.
• Worked with Data Modeler and Architects to build the data model and table structures.
• Actively participated in discussion sessions to design ETL job flow. Compiled source to target mapping documents to design ETL jobs.
• Created highly performance improved Impala queries and Mappings.
• Extensively used Cloudera-HBase & Impala to analyze the data and also to debug any data related issue.
• Worked on database migration project for On Prem Oracle Database to BigQuery. Converted all the reports from Oracle PLSQL into High performance based ETL mappings.
• Technology used: Cloudera, HBase, Impala, MySQL, Informatica Powercenter 10.1, Pentaho DI-spoon, Pentaho CDE, BigQuery, Oracle.

• Worked as ETL-BI Developer.
• Analyzed Source Data and queries from SAP Business One.
• Design, Develop and Test ETL Mappings, Mapplets, Workflows, Worklets using Open source ETL tools- QuickReport and Pentaho.
• Generated Excel based reports on the top of Data Marts for different functions.
• Provided on call support in case of any issue reported by Client.
• Worked in fast-paced environment, under minimal supervision providing technical guidance from team members.
• Technology used: QuickReport, SAP Business One