PROFESSIONAL SUMMARY

• 6 years of experience in data warehousing and Business Intelligence applications using ETL and BI tools with Teradata, DB2 and Oracle as backend on Windows and UNIX platforms.
• Very good communication skills complemented with ability to drive new initiatives to desired objectives are my forte.
• Worked under different roles as Team Leader, Developer, Test Leader and Tester.
• Strong experience in ETL using Ascential Data stage (V7.5x, V8.0x, V8.5x), and Performance Tuning in various levels like sources, targets, mappings, transformations and sessions.
• Experience in ETL using Informatica Power Center v8.x (Designer, Workflow Manager, Workflow monitor, Warehouse Designer, Source Analyzer, and Repository Manager).
• Experience working with dimensional models (Star and Snowflake Schemas), implementation of normalization techniques and slowly changing dimensions.
• Experience in tracking and reporting upon test results, test case coverage, required resources, defects status, performance baseline testing activities.
• Proficient in converting logical data models to physical database designs in Data warehousing Environment.
• Very good knowledge in Teradata architecture, AMPs, Primary and Secondary index mechanism, Symmetric Multiprocessing (SMP) and Massive parallel processing (MPP).
• Experience in writing complex SQLs for ETL processing and proficient knowledge in Query performance tuning by doing performance analysis, monitoring and SQL query tuning, while designing effective jobs for reduction of response time.
• Worked on scheduling and executing the Workflows using Citrix/Control - M scheduler for scheduling the jobs.
• Involved in different Testing cycles (System, Performance, Integration, UAT Testing) as part of delivery
• My current and previous roles involve client coordination with daily/weekly client interactions, handling escalations and concerns along with leadership team.

TECHNICAL SKILLS

Software: Teradata V2R6, db2, Oracle, SQL Server, SQL,PL/SQL,UNIX

Tools: Ascential Datastage (V7.5x, V8.0x, V8.5x), Informatica Power Center (v8.x.1), Mercury Quality Center v9.0, v9.2), Control-M Enterprise Manager V6.3x, Control-M Desktop V6.3x, Share Point, CVS

PROFESSIONAL EXPERIENCE

Team Leader

Confidential

Responsibilities:

• Maintaining Knowledge Repository with current training materials and other documents
• Conducting weekly status review meetings and sharing status of project with stakeholders as needed.
• Coordinating with project manager in resolving any issues/road blocks
• Managing the build phase and quality assure (peer review) the code to ensure that it meets the requirements and adheres to the architecture
• Reviewing estimates with the team and management
• Understanding the Source system and the mapping of the data from sources into the warehouse through the flow of the jobs as per the business transformation rules.
• Updating/Validating the mapping sheets to reflect the business rules mentioned in the business requirement document.
• Validating the business rules document and suggested necessary changes, required to design jobs.
• Involved in developing the designs of ETL datastage jobs as per the business requirements.
• Understand the business logic for developing ETL datastageJobs, making necessary changes in the job as per ad-hoc requirements.
• Created master-sequence jobs to run jobs in parallel as per dependency.
• Creating the Technical specification document and Job design documents
• Creating unit test cases of the developed jobs and testing the jobs and monitoring.
• Time to time analysis of performance of jobs and making performance tunings as and when required.

Developer

Confidential

Responsibilities:

• Involved in developing the designs of ETL datastage jobs as per the business requirements.
• Analyzing the business requirements and data mapping and loading the data from sources into the warehouse through the flow of the jobs as per the business transformation rules.
• Understand the business logic for enhancements, making necessary changes in the job as per ad-hoc requirements.
• Unit testing the ETL datastage jobs and preparing the unit test cases publishing the test results.
• Creating and Updating the job design and Overview documents.
• Analyzing the performance of jobs and making performance tunings as and when required.
• Actively involved in CR (Change Requests) and done necessary fixes in jobs and responsible to monitor the changes up to deployment.
• Actively Supported ST/SIT cycles from the development team.
• Defect management in coordination with testing team.

Confidential

Developer

Responsibilities:

• Understand the functionality and the data flow.
• Gathering and validating the information from source systems based on the requirements.
• Prepared the high level and detail design document based on the LDM and Source system analysis.
• Created/Updated mapping sheets as per the physical data model.
• Designed and developed ETL datastage jobs to Load data into data warehouse according to business rules.
• Responsible for code migration to QA and addressing the defects during the QA Phase.
• Resolved the issues raised by testing team and closed the defects.
• Worked on Teradata Utilities such as BTEQ, Fast Load, Multi Load, Fast Export as a part of data warehouse development
• Review of test plan and test strategy.
• Review of test cases and ensure scope matrix is covered.
• Defect Management through Quality Centre.
• Review of status report, test summary report, Test matrix and provide signoff.
• Impact assessment review of new Change Requests and business rules modifications.
• Mentoring team

ETL Tester

Confidential

Responsibilities:

• Involved in creation of test plan, testing strategy.
• Preparation and review of test cases, testing applications aligning to environment and business changes from time to time.
• Regression and Progression System Integration Testing.
• Defect management which includes Analyzing, Raising defects.
• Interacting with Source System(CC&B) and providing solution for fixing the defects,
• Reviewing documents and upgrading them whenever required.
• Preparation of status report, test summary report, Test matrix.
• Loading source file to tables to verify and validate data and business rules
• Doing assessment for impact on existing application/system because of new Change Requests and modification of business rules.
• Executing test plan & testing strategy for new CRs.