Tushar Pandit

Phone: 508-***-**** © Email: adhut9@r.postjobfree.com

Linkedin: linkedin.com/in/contact2tusharpandit

Professional Summary

Data warehouse/Business Intelligence professional with 12 + years of experience; Worked in all phases of project like Business Requirements Gathering/Analysis, Development, ETL Testing, Implementation, Deployment, Maintenance and Production Support.

Extensive experience in Health Care, Banking and Insurance domains.

Expertise in Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica Power Center 10.1/9.6/9.1/8.1/7.1 (Administrator activities, Repository Manager, Mapping Designer, Workflow Manager, Workflow Monitor, Worklet, Mapplets, Transformations, Partitions, version control and performance tuning).

Involved in Dimensional modeling of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.

Sound knowledge on Data Warehouse concepts - Data Modeling using Star Schema/Snowflake Schema, Normalization, OLAP, ODS, EDW, Data Marts, Facts & Dimensions tables.

Involved in Performance tuning at source, target, mappings, sessions, and system levels. Also Involved in Performance tuning Oracle level using advance techniques for faster execution.

Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Developed mapping parameters and variables to support SQL override.

Created User defined functions, reusable transformation, Mapplets to use them in different mappings. Also created reusable task and worklets to use in different workflow.

Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.

Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.

Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

Extensively used SQL* loader to load data from flat files to the database tables in Oracle.

Modified existing mappings for enhancements of new business requirements.

Used Debugger to test the mappings and fixed the bugs.

Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.

Expertise in scheduling BI/ETL job using UC4, Control-M, AutoSys job and Informatica Scheduler.

Strong skills in Oracle Programming which includes SQL, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers.

Experience in visualization tools like Business Object and OBIEE.

Basic Knowledge of Big Data technologies like Hadoop –Hadoop Architecture, JobTracker, TaskTracker, NameNode, Data Node, Map Reduce, manage and external tables.

Basic Knowledge of Tableau.

Experience in Production Support (rotational On-Call) for ETL and Reporting jobs - debugging issues and fixing within SLAs. Also involved in maintenance work, coordinating with other teams and managing services for all BI Servers.

Experience in working closely with business product owners within the Agile/Scrum development process to deliver as per business requirements.

Experience in documenting High Level Design, Low level Design, STM's, Unit test plan, Unit test cases and Deployment documents.

Quick learner and ability to work in a team as well as individually, who likes to work on cutting edge technologies, problems and leverage opportunity to enhance skills.

Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment and is experienced in working with senior level managers, business team and developers across multiple disciplines.

Worked with client directly. Almost 4 years of experience to work with client at onsite USA.

Technological Skills:

ETL : Informatica 10.1, 9.x, 8.x, 7.x, SQL Loader, Informatica Cloud

Big Data : Hadoop, Hive, Sqoop, pig, Oozie

Cloud : VPC, S3, Redshift

OLAP : OBIEE, Business Objects, Tableau

RDBMS : Oracle 9i/10g/11g/12c, Teradata, DB2, SQL Server, Netezza

Languages : Shell Script, SQL, PL/SQL

Scheduling : Control-M, Cron, Autosys

Version control : GIT, Stash, Perforce, WinCVS

Other Tools : MS Office, TOAD, SQL Developer, IDQ, Rapid SQL, Jira, HP Quality center, Visual Studio TFS (Team Foundation Server), Jenkins

Technical Certification

Oracle Certified Associate with 1Z0-051 94% and 1Z0-144 95%.

Big Data Fundamentals certified from Big Data University.

Work Experience

TCS, Kansas, MO Dec-2019 – Till Date

Role: Senior Project Lead Client: American Century Investments

Responsibilities:

Working as ETL Project Lead using Informatica as ETL tool. Lead onshore, nearshore, offshore team of eight ETL developer.

Consolidate inputs from developers and provide inputs on tasks, task estimates, schedule, dependencies, risks etc.

Working with Business team, data architect team and respective stake holder for requirement gathering and define scope of team in the project.

Involved in ETL coding, testing and peer review of sprint stories (ETL SRs and defects)

Define and implement ETL coding standards and development framework.

Prepare various documents like Technical, Low level design, Unit Test Case, Peer review, Deployment Document, Run book etc. Maintain and manage knowledge repository on SharePoint.

Provide 24 X 7 on call support. Monitor ETL process in production using UC4 scheduling tool and ServiceNow as defect management/ issue tracking tools

Coordinate call with customer and their vendors for data loads Oracle, DB2, Netezza, S3, Redshift and SFDC through ETL process.

Provide QA, UAT, System, Regression and Smoke testing support. Prepare test data for unit testing.

Prepare deployment document and migrate code to production.

Automation and Performance tuning of ETL code.

Analysis of the problem statement and suggest solutions. Provide ETL Architectural solution for repeated defects.

Prepare WSR (Weekly Status Report), Bi-weekly Sprint Report, Defect Management Report.

Involved in pre-sale activity, POC.

Atos Syntel Inc, Glen Allen, VA Mar 2018 – Dec-2019

Role: Sr. ETL Lead Client: Advantasure Inc.

Responsibilities:

Working as ETL Technical lead using Informatica as ETL tool

To assist Client in providing support function for incident management and problem resolution.

to their existing clients in the current platform.

Maintaining ETL support in defect management system for existing and new defects and SRs.

Pro-active monitoring for issues. Monitor ETL process in production on daily basis.

Coordinate call with customer and their vendors for data loads SQL Server, Oracle database and File Systems through ETL process.

Provide ETL L1 Support and L2 Support within SLA.

Perform ETL QA testing, Link Testing and Regression Testing.

Involved in Production Deployment and in Code Merge.

Performance tuning of ETL code. Performance Testing for SR/Defect related work.

Helping end user in UAT for defect fix and SRs.

Automation & Performance Testing for ETL SR/Defect related work.

Analysis of the problem statement and suggest solutions. Provide ETL Architectural solution for repeated defects.

Communicate with all stakeholders on problem statement, possible solutions, intermediate issues and overall status of work assigned.

Coordinate with Build teams for all changes, documentation and handover.

Use JIRA as defect management/ issue tracking tools.

Send Weekly, Monthly, Quarterly reports on ETL defects and SRs.

Resolve defect related to Tableau reports.

Atos Syntel Inc, Pune, MH, India May 2017 – Mar 2018

Role: Sr. ETL Developer Client: Advantasure Inc.

Responsibilities:

Worked as offshore ETL lead and handle team of five developer.

Collaborated with Business Users for requirements gathering, business analysis, functional and technical design.

Conducted meeting with onsite team and coordinated with offshore team to provide technical and functional direction to ensure quality deliverables.

Extensively used Informatica (ETL) to load data from wide range of sources such as Oracle database and flat files (fixed-width or delimited).

Developed Informatica mappings to process high volume of data and build a data warehouse from various sources like Oracle, SQL server, flat files and XML files.

Responsible for Extracting and transforming data from different source systems and loading to staging area using Informatica and PL/SQL.

Worked on Performance tuning and optimization using indexes, partitions, bulk collect, for all, explain plans, temporary tables, optimizer hints, SQL trace.

Utilized Informatica IDQ to complete initial data profiling and matching/removing duplicate data.

Created packages and procedures to load the data from source to staging and same called in Informatica.

Responsible for deploying the Informatica objects into another environment using deployment group.

Responsible for creating and importing all the required sources and targets to the shared folder.

Created Test Plan Document-UTC (Unit Test Cases) and executed them.

Extensively used the mapping parameter and variables in simplifying the code during development phase

Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems.

Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.

Atos Syntel Inc, San Francisco, CA Feb 2017 –May 2017

Role: ETL Consultant Client: Blue Shield of California

Responsibilities:

Worked as onsite Informatica Lead. Handled offshore team of three Informatica developer.

Determine the optimal approach for obtaining data from diverse source system platforms and moving it to the BI.

Conduct meeting with client and vender for requirement gathering. Conducting impact analysis of requirement.

Get knowledge on client’s business and requirement and provide technical solution to build Datawarehouse and report generation.

Prepare data field mapping document technical analysis and design document for deliverables.

Prepared Technical design document and reviewed with respective stakeholder.

Informatica Coding for development /enhancement/modification of new/existing ETL process.

Prepare test data for deliverables testing. Perform Unit testing and prepare unit testing related documentation.

Perform code review and Prepare code review document.

Mock runs and data file validations.

Conduct JAD sessions for team deliverables.

Coordinating quality assurance efforts and helping testing team to execute test validations for project changes in various Test phases i.e. SIT, UAT, Regression and Performance testing.

Business approval of mapping and design documents for deliverables.

Participating in all the release management activities and providing description of project, back out plans and implementation of enhancements into real time environment.

Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.

Atos Syntel Inc, Pune, MH, India Feb 2016 –Feb 2017

Role: ETL Tester Client: Independent Health

Responsibilities:

Lead a team of 4 members for ETL and BI report testing deliverables.

Formulating test plan and BI test strategies.

ETL testing for Informatica and EDW data.

ETL testing for BI Report.

Extensive use of HP ALM 12.0 tool for test management & Defect management.

Involved in SIT (Functional & Regression testing) and preparation of test data creation, test cases, test execution & RTM documentation.

Involved in estimation of change requests, new modules, peer reviews and quality audits for the project.

Tracks and reports daily and weekly status reports and other metrics on an ongoing basis.

Atos Syntel Inc, Pune, MH, India Sep 2015 –Feb 2016 Role: ETL Consultant Client: Independent Health

Responsibilities:

Worked as offshore ETL lead and handle team of five developer.

Collaborated with Business Users for requirements gathering, business analysis, functional and technical design.

Conducted meeting with onsite team and coordinated with offshore team to provide technical and functional direction to ensure quality deliverables.

Extensively used Informatica (ETL) to load data from wide range of sources such as Oracle database and flat files (fixed-width or delimited).

Developed Informatica mappings to process high volume of data and build a data warehouse from various sources like Oracle, SQL server, flat files and XML files.

Responsible for Extracting and transforming data from different source systems and loading to staging area using Informatica and PL/SQL.

Utilized Informatica IDQ to complete initial data profiling and matching/removing duplicate data.

Created packages and procedures to load the data from source to staging and same called in Informatica.

Responsible for deploying the Informatica objects into another environment using deployment group.

Responsible for creating and importing all the required sources and targets to the shared folder.

Created Test Plan Document-UTC (Unit Test Cases) and executed them.

Extensively used the mapping parameter and variables in simplifying the code during development phase

Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems. Also worked on performance tuning and optimization using indexes, partitions, bulk collect, for all, explain plans, temporary tables, optimizer hints, SQL trace

Documented High Level Design, Low level Design, STM's, Unit test cases and Deployment documents etc.

Provided Production Support for ETL and Reporting jobs.

Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.

Atos Syntel Inc, Louisville, KY Aug 2014 – Sep 2015

Role: ETL Consultant Client: Humana

Responsibilities:

Analyzed the systems, met with end users and business units in order to define the requirements.

Worked as onsite ETL lead and worked with Offshore team. Code review of the ETL code developed by offshore and performed testing.

Assisted with establishing and administering the Informatica and Unix environment.

Used Informatica Power Center 9.5 to extract, transform and load data from multiple input sources like Oracle, flat files to target Oracle database using various transformation.

Involved in Data Analysis, Data Validation and Data Cleansing.

Created reusable transformations and mapplets.

Created Sessions, reusable worklets and workflows in Workflow Manager.

Implemented efficient and effective performance tuning procedures.

Worked extensively on SQL, PL/SQL and UNIX shell scripting.

Created and scheduled workflows using Workflow Manager at specified frequency to load the data into the Target Database.

Documented High Level Design, Low level Design, STM's, Unit test plan, Unit test cases and Deployment documents etc.

Involved in Code migration to different Repositories (Test /Prod).

Interacted with DBA’s, Informatica Admin team to resolve the issues.

Used Informatica Cloud to replicate PDI’s Salesforce.com CRM data into the company’s reporting infrastructure where it can be shared across the enterprise. Similarly, Informatica cloud is used to upload oracle data in Salesforce.com CRM.

Production Support & Maintenance.

Worked on Pricing Estimated and SOW documentation and review.

Prepared Project Plan, defined scope and worked for resource allocation.

Stakeholder Management and Escalation support.

Atos Syntel Inc, Pune, MH, India Apr 2011 – Aug 2014

Role: ETL developer Client: American Express

Responsibilities:

Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (Oracle DB and Flat files).

Designing the dimensional model and data load process using SCD Type II.

Extensively used Transformations like Static/Dynamic Lookup, Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.

Interacted with client and gathered requirement for further enhancement of project.

Deploying and monitoring the informatica workflows in UAT environment.

Created IDQ mappings and profiles for Source Data profiling and produced scorecard, charts etc to view number of null values, wrong date formats etc

Involved in identifying bottlenecks in source, target, mappings and sessions and resolved the bottlenecks by doing Performance tuning techniques like increasing block size, data cache size, sequence buffer length.

Developed UNIX shell scripts to create parameter files, rename files and compress files.

Developed low level Design, STM's, Code Review / Peer Review documents and Code migration documents.

Developed the unit test cases (UTC) and test scenarios to test the reports according to the business requirement.

Developed the various report with conditional formatting by using Presentation Services in OBIEE.

Developed hierarchies to support drill down reports in OBIEE.

SP Software (P) Limited, Hyderabad, AP, India Jun 2009 – Apr 2011

Role: ETL developer Client: American Express

Implementation Partner: Oracle Consulting

Responsibilities:

Worked as ETL Consultant.

I Was Responsible for monitoring and ensuring successful completion of Informatica related jobs.

Provided solution to customer within the SLA according to the severity.

Investigated and Provided Root cause analysis of informatica issues.

Performed Performance Testing on request.

Fixed the issues after replicating into test environment.

Performed testing in test environment for new mapping according to UTC plan.

Worked on Creating change management request to deploy new or changed code in production and QA environments.

Raised SR with Informatica product support for production issues.

Coordinated for non Informatica issue.

Enhanced and Maintained OBIEE RPD.

Developed new and enhanced existing OBIEE reports.

Analyzed existing OBIEE reports and improved performance.

Ebusinessware India Private Limited, Gurgaon, HR, India Apr 2008 – Jun 2009

Role: ETL developer Client: Credit Suisse

Responsibilities:

Worked as ETL Developer.

Performed data cleansing using Informatica transformation logic and mapping.

Developed mappings using Informatica to load into staging Tables.

Creating mappings using Transformations like Sequence Generator, Filter, Router, Joiner, Sorter, Look up, Expression, Update Strategy, Aggregator.

Developed mappings, sessions, workflows.

Tuning transformations and mappings for performance enhancements.

Creation of SQL script.

Helped in Batch loading.

Enhancement and support the existing mapping.

Worked on production issues.

Enhanced and Maintained Business Object Universe layers.

Developed new and enhanced existing Business Object reports connecting to single or multiple data sources.

Analyzed existing Business Object reports and improved performance.

Prepared technical specification documents for ETL process.

Developed the unit test cases (UTC) and test scenarios to test the reports according to the business requirement.

Education Qualifications:

Master of Business Administration (MBA) in Operations from Assam Downtown University, India in 2015.

Bachelor of Science (B.Sc.) from Pune University, Pune, Maharashtra, India in 2004

Personal Information:

Gender : Male

Date of Birth : 2nd Sep 1981

Nationality : Indian

VISA : I have both USA H1B and B1 VISA.

Address : 11516 Floyd Drive, Apt#2306, Overland Park, KS -66210, USA.

Contact this candidate