Udayan Sil Email & Phone Number

Mumbai, Maharashtra, India

Project & Assignment DescriptionClient is a nonprofit health care company and/or investor in more than 20 healthcare companies in the U.S.As Solution Architect my responsibilities included:1) Work with onshore client to understand their data strategy and implement the same.2) Build prototypes, solutions to create the final architecture of the DWH.3) Setup team to run as Agile project and implement Snowflake as the datawarehouse.4) Create technical documents as per client requirements sessions.5) Learn and implement Snowflake database and DBT Tool6) Work with leadership to leverage the knowledge gained from this implementation to identify the learnings for future project setup where similar needs are envisioned for better client engagement.

Mumbai, Maharashtra, India

Project & Assignment DescriptionClient is a pharmacy benefit manager and care services group operating across 150 countries in North America, South America, Europe, Asia Pacific and the Middle East.As Solution Architect my responsibilities included:1) Work with onshore client to understand their business and gathering requirements for Datawarehouse modernization.2) Provide questionnaire to client for client current system exploration and identify modernization opportunities and suitability for cloud migration.3) Setup discovery session with client based on the answers received for the questionnaire.4) Create functional and technical documents as per client requirements/discovery sessions.5) Setup team to run as Agile project and start with Sprint 0.

Mumbai, Maharashtra, India

Technical Consultant

Mumbai Area, India

Project & Assignment Description Client is the premier beverage distributor for world-class wines and leading spirits brands in The United States. This is a Data Migration & Analytics project with end to end implementation.As ETL and Production Support Lead responsibilities include:1) Work with onshore client to understand their business and gathering requirements for data reconciliation programs.2) Create technical documents as per their functional requirements.3) Lead the ETL team (consisting of 5 members) to create various Informatica Mappings and Workflows for data migration operations.4) Create of tables/indexes/queries for various ETL/application use.5) Create of complex postgresql SQL queries for various SQL Server queries conversion.6) Setup production support for job monitoring to detect failures and fix them. 7) Code fix of the defects/enhancements raised in UAT/Production.Tools Used:Informatica Powercenter 10.0 (ETL tool).Hadoop is used as staging database.Hue is used as Web interface for Hadoop.Datawarehouse is built on cloud based Amazon Redshift platform. WinSCP/Putty

Racine, Wisconsin

Project & Assignment Description Client is one of the largest consumer goods and products company in The United States. They are in this business for over 125 years. Global manufacturer of household cleaning supplies, pest control, shoe care and other consumer chemicals. This is a Data Analytics project with end to end implementation.As Data Quality Lead responsibilities include:1) Defining Data Quality processes and creating templates for the same.2) Working with onshore clients to understand their business and gathering requirements for improving the quality of Client data.3) Creation of profiles using Informatica Analyst for Data Profiling.4) Creation of Business Rule to validate the client data for anomalies.5) Creation of Data Quality scorecard to monitor the quality of data over a period of time. 6) Creation of Informatica Powercenter/Developer mappings/workflows/applications as per requirements.Tools Used:Informatica Analyst (Data Quality Tool).Informatica Developer Big Data Edition 9.6.1 (ETL tool).Hadoop is used to store and process big data.Hue is used as Web interface for HadoopDatawarehouse is built on Teradata platform. Informatica Powercenter 9.5.1WinSCP/Putty

Mumbai Area, India

Project & Assignment Description Client is US based investment and insurance company that is part of Fortune 500 list. The company’s earnings are divided between property-and-casualty operations, group benefits and mutual funds and sells its products primarily through a network of agents and brokers (Third Party Administrators). It is a 200 year old company and the 12th-largest property & casualty company in the United States.As Senior Data Analyst responsibilities included:1) Work with onshore client to understand their business and gathering requirements for data reconciliation programs.2) Create technical documents as per their functional requirements.3) Lead the ETL team (consisting of 5 members) to create various Informatica Mappings and Workflows for Data reconciliation operations.4) Create of tables/indexes/queries for various ETL/application use.5) Create of complex SQL queries for various ETL/Java/MSBI use.6) Code fix of the defects/enhancements raised in UAT/Production in Testing/Prod Fix environment.7) Debug performance issues related to the Oracle SQL queries developed across the project.8) Establish Data Quality process for the client and end to end Data Governance framework. 9) Profile the data to understand the data format and quality.10) Create Business Rules to validate the client data.Tools Used:Informatica Powercenter 9.5.1 Informatica Analyst (Data Quality Tool).informatica Developer BDE 9.6.1 Oracle 11g database PuttyToad

Mumbai Area, India

Project & Assignment Description Client is one of the the largest drug retailing chain in the United States. I was working independently on this role as a Data Modeler. As Data Modeler my responsibilities include:1) Working with onshore client to understand their business and gathering requirements for data modeling.2) Create Logical data model and Physical data model documents to showcase the DB design to the client and the developers.3) Create DB change request document based on the requirements gathered in above step.4) Create tables/indexes/queries for various ETL/application use.5) Being a single POC for coordinating between the DBAs and the ETL/App team to make sure the migration is done smoothly.Tools Used:Toad, Erwin Tool

Mumbai Area, India

Project & Assignment Description Client is one of the largest electric power holding company in the United States with assets also in Canada and Latin America. Project team consisted of 4 ETL members and I also had to work independently on PL SQL deliverables. As Data Modeler my responsibilities include:1) Working with onshore client to understand their business and gathering requirements for conversion and interfaces2) Create functional document based on the requirements gathered in this step.3) Create technical documents to align our technical understanding as per their functional requirements.4) Created PLSQL Stored Procedure to call soap based web services by sending xml request and parsing the xml response.5) Create SQL queries for various Informatica / PL SQL use.6) Use Informatica Tools to create various Mappings and Workflows.7) Migration of Informatica using client specific tool.8) Testing and logging resolution in HP Quality Centre.9) Conducting Unit Testing of SPs/ ETLs in development environment.10) Code fix of the defects/enhancements raised in User Acceptance Testing in Testing environment.11) Code fix of the defects/enhancements raised in Post Production Testing in Production environment.12) Ad Hoc PLSQL script creation for making Production changes.13) Creating/ updating numerous Conversions / Interfaces as required by the business.Tools Used:Toad, MS SQL Server, Informatica PowerCenter 9.5.1

Mumbai Area, India

Project & Assignment Description Client is an American multinational banking corporation of securities, investments and retail. Project team consisted of 8 members who were responsible for providing client with different business objects per release as per business requirements within the given estimates and strict timelines.As Senior Developer my responsibilities included:1) Meeting with client to understand their business and gathering requirements for various reports we needed to prepare for them. Create functional document based on the requirements gathered in this step.2) Create technical documents to align our technical understanding as per their functional requirements.3) Create SQL queries which will be used to create folders in Discoverer.4) Use Discoverer Tools to create various reports from the SQL queries created.5) Migration of Discoverer reports using Cleartool (Clearcase)6) Testing and logging defects in Quality Centre.7) Creating Informatica Mappings/Workflows as per business requirement.8) Ad Hoc PLSQL script creation for making Production changes.Tools Used:Informatica PowerCenter 9.1, Toad, Oracle Discoverer Tools, SQL Developer, Cleartool, Putty, WinSCP

Mumbai Area, India

Project & Assignment Description Client is one of the largest providers of data storage platforms in the world. It supplies storage devices, routers, etc. through its network spread across various geographic locations. Project team consisted of 15-17 members who were responsible for providing technical support to the client by resolving tickets which had attached SLA. Also, bug fixes or enhancement solution in the system was also developed and implemented by the team as per business requirements.As Technical support my responsibilities included:1) Provide Break/Fixes and Enhancements in the system as per request from the Business.2) Build Concurrent Programs, Data Scripts to resolve similar issues cropping up frequently.3) Provide end user training if the incidents don’t involve technical issues.4) Monitoring Control-M to check if the Batch Processes fail and provide technical support to resolve such failures.5) Creating/Updating Informatica mappings/tasks/workflows to resolve issues. 6) Comply with stringent SLA’s for various categories of Service Request (Meeting 100 % SLA’s).7) Preparing documents for the end user / team on the resolved issues.8) Receive incident from the end user and verify if the incident are technical in nature and provide technical support for the same.9) Custom PLSQL stored procedure development as per business requirements.10) Debug existing Stored Procedures to fix issues raised by users.Tools UsedInformatica PowerCenter 8.6, Toad, Putty, WinSCP, Harvest

Engineer’S Degree, Information Technology, Distinction

Activities and Societies: Computer Society of India, IEEE- My degree in Bachelors of Engineering in Information Technology has helped me.

High School, Science, Distinction

Completed my Higher Secondary Certificate

High School, Matriculation

Completed my Secondary School Certificate