Ing. Pankaj Dhole

-Applications SME of Private banking Intra, EOD data delivering through ETL Inforamtica/UC4/Automic batch jobs on Daily/Monthly/Yearly basis. -Working with Automic scheduling for dynamic passing of parameters to Automic job, creating job -Expertise in web application server like Apache Tomacat/Weblogic Technology. -Expertise in Informatica Powecenter ETL Process, SQL, Oracle , work on variables, FTP connections and relational connections -Expertise into handling File issue in Unix and windows servers.

• Handling ETL job through Tidal scheduling tool, restart and schedule jobs. • Manage Informatica/SAP BO services and keep active to run production • Direct manage L1 team to support and provide solutions in the form of knowledge sharing

Client - United Bank Of Switzerland Using UC4/Automic scheduling tool manage jobs for wealth management application EOD. Using UNIX shell scripting mange daily data load jobs, error handling and modification in existing shell script jobs. Handing End of Day activities and resolving critical issues within SLA.

Handling ETL, Reporting production incident and changes at Level 2 and level 3. Using UNIX shell scripting mange daily data load jobs, error handling and modification in existing shell script jobs. Extensively tested PL/SQL batch processes, SQL programs - Packages, Functions, Stored Procedures, Cursors, and Triggers. Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in preparing the documents.

Expert in resolve Incidents, changes and problem raised in the SDM12 ticketing portal. Testing and analysis of ETL mappings which are used to load data from various sources to single data warehouse. Extensively tested PL/SQL batch processes, SQL programs - Packages, Functions, Stored Procedures, Collections, Cursors and Trigger. Analyzed and tested Informatica mappings with OLTP source data, staging and target data.

Information Technology, Programming, All computer languages, Database languages.