Pankaj Thorat Email & Phone Number

Total 7+ years of experience in Information Technology (IT) industry using ETL (Informatica, SSIS) ,Oracle and Microsoft SQL SERVER, UNIX ,Autosys ,Shell Scripting .Informatica Experience in designing and developing of complex mappings, used various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter, joiner and sorter transformations. Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation. Involved in testing the ETL modules, plans, deploys, and tests the ETL mappings, etc Performance tuning with ETL transformation Provide L3 support in Production for Informatica PowerCenter. Provide impact analysis whenever there are any changes and production events happen that may affect target system. Oracle & SQL Server Write Stored Procedures, triggers, views, materialized views, Functions, synonyms, sequence and Packages for complex business logic. Worked on large data sets and distributed database. Database partitioning, performance tuning. UNIX & Autosys Create shell script to avoid repeating task. Work on file operation. Scheduling jobs on Autosys. SSIS Creation of SSIS packages using different Control Flow tasks, Containers, Data Flow task and transformations. Used SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse. Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer. SSRS Used SSRS features like charts, data grouping and aggregation, Page orientation, text orientation and formatting for creation of reports. Revenue report development using SSRS features like data grouping, calculated fields, Matrix, formatting, collapsible. Row and Column groups, drill-down chart reports. Expertise in development of complex Reports and dashboard. Created, implemented and maintained Standard reports while also customizing many reports to meet individual client needs. Created list reports, Sub-Report, Drill through reports, chart reports, complex Dashboards DBA Have worked on database administrator task such as backups, restores, recovery models, DBCC commands, Database mirroring, Replication.

Listed skills include C, C++, C#, Visual Basic, and 21 others.