SUMMARY:

• ETL Tech Lead with 12 years of experience in Data warehousing systems comprising Teradata, Informatica, Mainframe and Unix etc.,
• Experience in all aspects of SDLC including analysis, design, build, testing, deployment and production support.
• Proficient in understanding business processes/requirements and translating them into technical requirements, translate them to design specifications and implement those requirements.
• Experience in leading onsite teams and offshore teams. Liaison between onsite and offshore teams.
• Meeting the tight timelines by driving the onshore and offshore teams and coordinating with both shore teams
• Acted as client SPOC from the team perspective and responsibility for representing the team before client.
• Make sure of setting up client expectations and meeting those expectations.
• Proficient in Data Modeling concepts using Erwin, Star Schema, Facts & Dimension tables for Logical & Physical data modeling.
• Worked on Teradata Utilities BTEQ, Fast load, Multi Load, TPump, FastExport and writing of Teradata SQL code.
• Performance tuning of Teradata queries by identifying the bottlenecks with queries from the aspects of skewed Redistributions, optimizer statistics. In - depth knowledge of Teradata Explain plan.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited using Informatica.
• Well acquainted withInformatica DesignerComponents - SourceAnalyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer. Worked extensively with complex mappings using multiple transformations likeSource Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Stored Procedures, Rank and Normalizer.
• Trouble shooting of the runtime problems and identifying the bottlenecks in the processing and provided solutions for the same in Informatica workflows.
• Knowledge of dimensional modeling/data modeling
• Experience in UNIXshell scripting, CRON, FTP, connect direct(C:D)and file management in various UNIX environments.
• Good experience in using the bug tracking tools-BMC Remedy, JIRA, HP-Quality Control.
• Strong leadership and mentoring skills. Adept Confidential building teams suiting the project needs.
• Skilled in delivering quality deliverables and meeting project objectives in tight deadlines.
• Expertise in handling multiple projects with different technologies involving varied technologies. Experience in handling the projects involving different technologies like mainframe, client server and web-based.
• Experienced in coordinating with multiple teams in resolving the issues by engaging the right team.
• Strong client management skills
• Expert in team management skills
• Building the teams by identifying the right resource and grooming them

TECHNICAL SKILLS:

Programming: Teradata BTEQ and Loading Utilities(MLoad, Fast Load, Tpump), UNIX Shell Scripting, SQL, PL/SQL, COBOL, FOCUS, WebFOCUS, Coldfusion, JCL, REXX, HTML, EXEC, EXEC2, VSQL

ETL Tools: PowerCenter 9.1/8.x/7.x(Designer, Workflow Manager, workflow Monitor, Rep. Server, Repository Manager, Mappings/ Mapplets/ PowerCenter transformations)

Data Modeling: Erwin data modeler

BI Tools: Business Objects 6.5.1

Data bases: Teradata 12.0/13.10/14.0 , DB2, Oracle 8i, 9i,10g,11g, FOCUS, Vertica

DB & other tools: Queryman, SQL Assistant, Teradata viewpoint, Toad, SQL* Plus, Teradata Loader Utilities (BTEQ, FastLoad, MultiLoad, Tpump), FastExport, SQL* Plus, SQL*Loader, EDA Query Tool, HTTP listener, C:D(Connect Direct), Oracle Golden Gate

OS: UNIX, WINDOWS XP/NT/ 2000/98/95, MVS/XA/ESA,z/390

Scheduling: TWS 8.2/8.5, CRON

EMPLOYMENT CHRONOLOGY:

Confidential

Tech Lead/Onsite Coordinator

Technologies: Teradata, Unix, Shell Scripting, Informatica, Control M, TWS 8.2/8.5, Oracle 10g, Teradata viewpoint, toad, SQL Assistant, BMC Remedy, C:D(Connect Direct) and Oracle Golden Gate.

Responsibilities:

• Creating ECRs for working on data cleaning and emergency change requests and leading the implementation of the same.
• Configuring C:D(Connect Direct) for sending files/receiving files to/from the downstream/upstream systems.
• Evaluating the Extractions and loads to make sure that the performance of the schedules are good enough to meet the everyday SLAs and as well as accommodating the future loads.
• Tuning of Teradata long running queries using Explain and analyzing the data distribution among AMPs and index usage, collect statistics, definition of indexes etc.
• Developing Architecture framework to load the Data warehouse and control the batch flow using Scheduling Tools TWS scheduler.
• Map the data from different sources to the Common Transaction Format (CTF) and then create the Teradata tables/objects and load it into the Final Target.
• Used BTEQ, MLOAD, FastLoad, TPump, FastExport utilities to extract data from different sources and load into Teradata stage/target tables.
• Design ETL processes using Informatica tool to load data from Golden Gate Oracle source systems and Flat files into Oracle Target database/Flat files.
• Developing workflows with Worklets, event wait, assignment tasks, conditional flows and email using Workflow manager.
• Reusing the single workflow for loading data from various regions’ files with similar file structure using indirect loading as source type in session properties
• Modified/created Unix shell scripts for automating the tasks.
• Working with different stakeholders for resolving the issues within timeframe
• Worked as Deployment Lead for the IT Wide releases and update the reporting tool for reporting Deployment Progress to the Confidential & Confidential management.
• Conducting weekly meetings with offshore team members.
• Driving the KT sessions for bringing up the team members up to speed

Confidential

Tech Lead

Technologies: Teradata, Informatica, SQL Assistant, ORACLE, TOAD, Vertica, Unix, Shell Scripting, TWS 8.5, BMC Remedy, C:D(Connect Direct), Teradata Viewpoint, Vertica, VSQL, Erwin Data Modeller

Responsibilities:

• Tuned the Teradata load queries using better indexes, stats and volatile and temporary tables.
• Prepared Mload Load scripts for loading the data from flat files into target tables.
• Made Tpump scripts for loading the data into Teradata tables
• Used VSQLs for loading data into vertica tables
• Map the data from 6 zone flat files and segregated the files into 33 different markets files.
• Reusing the single workflow for loading data from 6 zones flat files from landing zone and prepared the 33 markets.
• Used persistent cache for reusable workflows.
• Interacting with the clients for gathering the requirements and translate them into technical requirements, HLD, LLD, DD and code with the help of offshore team.
• Estimating the work requests, tracking the work request via RTM and make sure that work is completed within the schedule and effort.
• Involved in unit testing and coordinate with testing teams.
• Involved in code reviews and code implementations.
• Conducting code implementation activities required by following the clients quality process.
• Involved in forward and reverse engineering with
• Tracked the defects via Quality Center(QC).
• Document the functionality of the code for better maintenance and readability

Confidential

Tech Lead

Technologies: Teradata, Informatica, JCL, COBOL, Oracle, DB2, FOCUS, SQL Assistant, Changeman, ESPMENU, MAINFRAME, Microsoft SQL Server, ORACLE, TOAD

Responsibilities:

• Participated in discussions with end users in gathering the requirements
• Preparing Technical requirements and HLD and getting the approvals from all the stakeholders
• Work with offshore team in preparing the LLD, DD preparation
• Involved in code changes and code reviews and unit testing
• Coordinate with testing teams for the Integration, System and load testing.
• Fixing the issues testing team identified.
• Offshore onsite coordination
• Conducting code implementation activities required by the clients quality process
• Assisting offshore team to understand the requirements so that code changes can be made
• Involved in testing and reviewing the changes.
• Involved in code implementations.
• Knowledge transfer toteam.
• Mentoring offshore team members
• Conducting internal and external weekly meetings

Confidential

Onsite Coordinator/Tech Lead

Responsibilities:

• Participated in discussions with end users in gathering the requirements
• Preparing Technical requirements and HLD and getting the approvals from all the stakeholders
• Work with offshore team in preparing the LLD, DD preparation
• Involved in code changes and code reviews and unit testing
• Coordinate with testing teams for the Integration, System and load testing.
• Fixing the issues testing team identified.
• Offshore onsite coordination
• Conducting code implementation activities required by the clients quality process
• Assisting offshore team to understand the requirements so that code changes can be made
• Involved in testing and reviewing the changes.
• Involved in code implementations.
• Knowledge transfer toteam.
• Mentoring offshore team members
• Conducting internal and external weekly meetings

Confidential

Onsite Coordinator

Technologies: FOCUS, BTEQ, COBOL, TERADATA, Queryman, REXX, ORACLESQL+, JCL, COBOL, MVS FOCUS, FOCUS DB, Coldfusion, HTML, Sitemover, Espmenu

Responsibilities:

• Maintenance and production support of the applications
• Learnt Fast Load, Mload, BTEQ and FastExport utilities and implemented the same based on the client recommendations.
• Worked with TDBAs for fine tuning the Mloads which were executing for more than 9 hours.
• Worked on FastExport changes to fit into the client requirements.
• Learned web-based technologies like Coldfusion, HTML and made the changes to the existing code for the modified client requirements as well as for fixing the issues.
• Learnt VMFOCUS and EXEC and EXEC2 and involved in code changes
• Made table changes for blocking the 900/976 number so that number allocation will start.
• Involved in VMFOCUS schedule changes via EXEC.
• Worked on making FOCUS code changes to fit reports changes required.
• Created Focus databases for implementing the new functionality
• Performed FOCUS database fine tuning
• Involved in testing the code for version upgrades.
• Worked with Information Builders Inc. for resolving the issues arising out of upgrades.
• Introduced the code changes for early detection of the production instead of finding out the issue Confidential the end.
• Engage with the clients for gathering requirements and convert those requirements into functional specs.
• Worked with offshore team to prepare the HLD, LLD and Detailed design from the functional requirements
• Involved in coding and unit testing and reviewing the code. Review of the code is to make sure that the code follows the standards.
• Review the code changes done by team members.
• Engage with testing team to support the testing cycle from the development team scope.
• Conducting code implementation activities required by following the clients quality process.
• Track the Sending weekly report to the client via weekly status reports.
• Attend weekly meetings with client and explain the status of the projects.
• Mentoring new offshore team members, perform the knowledge transfer sessions and bringing them up to speed.
• Tracked the defects via Quality Center(QC).

Confidential

Programmer Analyst

Technologies: WEBFOCUS, Developer Studio, EDA Server, Windows NT ServerEDA Query Tool, HTTP Listener, FOCUS DB

Responsibilities:

• Application maintenance and production support for the CAS application from offshore
• Interacting with Business Managers for adhoc reports and providing the reports within the available timelines which will mostly be within short span of time preparing corresponding technical requirements based on the business requirements and getting the approval of onsite project manager
• See the logs if the execution is of the application by the user are correct. If there is any problem in the execution then diagnose the problem and let them know.
• See the reports whether they executing properly. See the report dates for their correctness.
• Execute the some reports to ensure that the balancing is done properly.
• See the databases whether they are correctly transferred the archive folders from the same server and different servers.
• Check the daily database through HTTP Listener for the correctness of the database updating.
• Check the Lockup and Line databases for their correct updating by the user.
• Solve any production issues.
• Assisted Release Manager in Release management activities