Udayan Sil Email and Phone Number
Udayan Sil work email
- Valid
- Valid
Udayan Sil personal email
- Valid
Udayan Sil phone numbers
I have more than 12 years of experience as Informatica ETL, DWH and Data Quality Analyst with a good understanding of the Oracle PLSQL. I'm currently H1B visa enabled with a valid visa till Jan 2024. I've been involved in variety of ETL implementations like Data Migration, Data Reconciliation, Datawarehouse Build and Data Analytics. I've built complex mappings, workflows, database objects, data profiles and scorecards. I have delivered successful results with multiple clients and my forte is working independently towards short term goals with quick results. Quick learner and never shy away from taking up new/challenging scope of work, I give my best to achieve the goals of my client. I'm actively seeking full time opportunities for taking up new role in my career.Scope of work done:• Implemented Single Source of Truth/DWH solution on Cloud using Snowflake with Data Analytic capabilities.• Implemented Data Governance framework and Data Quality Strategies in SDLC management.• Established Data Quality processes in end to end implementations.• Extensive Data Profiling work done on client data.• Involved in 8 Informatica/PL SQL implementations.• Lead 2 end to end Data Quality implementations.• Performed Data Cleansing operations on client data.• Lead end to end delivery of Predictive Data Analytics efforts. • Extensive experience in client interactions for understanding business processes.KEY SKILLS/TOOLS USED• Informatica Powercenter 10.1.1(ETL Tool) - Informatica Certified Specialist• Informatica Analyst (Data Quality Tool)• Informatica Developer Big Data Edition 10.0.1(ETL tool)• Oracle PL SQL• SQL / Postgresql• Amazon Redshift
Citiustech
View- Website:
- citiustech.com
- Employees:
- 2968
-
Solutions ArchitectCitiustech Feb 2020 - PresentMumbai, Maharashtra, IndiaProject & 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.
-
Technical Lead IiCitiustech Feb 2020 - PresentMumbai, Maharashtra, IndiaProject & 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.
-
ConsultantDeloitte India (Offices Of The Us) Jan 2018 - Feb 2020Mumbai, Maharashtra, IndiaTechnical Consultant -
Etl And Production Support LeadAccenture Apr 2017 - Dec 2017Mumbai Area, IndiaProject & 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 -
Data Quality LeadAccenture Aug 2015 - Mar 2017Racine, WisconsinProject & 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
-
Senior Etl & Data Quality AnalystAccenture Jan 2015 - Jul 2015Mumbai Area, IndiaProject & 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
-
Data ModelerAccenture Apr 2014 - Jan 2015Mumbai Area, IndiaProject & 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
-
Senior AnalystAccenture Jan 2013 - Apr 2014Mumbai Area, IndiaProject & 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
-
Senior DeveloperAccenture Apr 2012 - Dec 2013Mumbai Area, IndiaProject & 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
-
Technical Support EngineerAccenture Dec 2009 - Mar 2012Mumbai Area, IndiaProject & 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
Udayan Sil Skills
Udayan Sil Education Details
-
South Indian Education Societys College Of Arts Science And Commerce Sion West Mumbai 400 022Distinction -
New English School, KalwaMatriculation
Frequently Asked Questions about Udayan Sil
What company does Udayan Sil work for?
Udayan Sil works for Citiustech
What is Udayan Sil's role at the current company?
Udayan Sil's current role is Solution Architect at CitiusTech.
What is Udayan Sil's email address?
Udayan Sil's email address is si****@****ail.com
What is Udayan Sil's direct phone number?
Udayan Sil's direct phone number is (877) 889*****
What schools did Udayan Sil attend?
Udayan Sil attended K. J. Somaiya Institute Of Engineering And Information Technology, South Indian Education Societys College Of Arts Science And Commerce Sion West Mumbai 400 022, New English School, Kalwa.
What skills is Udayan Sil known for?
Udayan Sil has skills like Informatica, Data Quality, Pl/sql, Sql, Requirements Analysis, Business Analysis, Sdlc, Microsoft Sql Server, Oracle, Unix, Project Management, Data Warehousing.
Who are Udayan Sil's colleagues?
Udayan Sil's colleagues are Sumit Lambe, Nitesh Patel, Omkar Shinde, Faiyaz Dalvi, Anmol Sao, Vijayadarshan Reddy Algari, Shishir Bhagade.
Not the Udayan Sil you were looking for?
-
-
1gmail.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial