SUMMARY:

• Lead ETL and Data Analyst with 9.5 years of hands on experience on Development, Enhancement & Maintenance of Data warehousing & Data Analytics projects like Credit Cards, Personal loans & Email Campaigns projects etc.
• Experience of working on business requirements gathering, analysis, application design, data modeling, development, implementations, testing and project coordination of Data Warehousing projects in Scrum Agile Methodology and Water fall Methodology to the highest standards.
• Highly skilled in Project Documentation, Test Strategy, Test plan, Functional Specifications, Technical specifications, execution of development activities and project implementation.
• IBM Certified Solution Developer - InfoSphere DataStage v9.1 and DataStage v8.5 and familiar with Ab Initio ETL tool.
• Ability to work with business user or analyst to resolve/analyze data errors. Experince in Leading the Team and co - ordinating with Offshore.
• Expertise in doing the Datastage Jobs Performace Tuning. Troubleshoot and resolve production data/code issue related with ETL components.
• Expertise in writing & tuning the complex SQL/PLSQL queries. Strong at writing Shell Scripting, Built various reconciliation, audit, archive, automation, FTP & Job run scripts and Exprtise in Control-M scheduling tool. Posses good knowledge on Data modeling tool- ERWIN 7.3
• Exposure to installation, configuration of DataStage and good understanding of Hadoop file system & architecture.

TECHNICAL SKILLS:

ETL Tools: IBM Infosphere DataStage v11.x, v9.x, v8.x. (Certified)

Scheduling Tools: Datastage Scheduler, UNIX Crontab/at, Control M

Data Modeling Tools: ERwin 7.3

Databases: DB2, Oracle, Teradata.

Tools: Jira, Squirrel, SQL Assistant, SQL developer, Putty, SQL*Plus, SQL*Loader, Toad 9.5

Operating Systems: Linux, Windows

Programming Languages: SQL, PL/SQL, Unix Shell Scripting, C, C++, Core Java, Python.

PROFESSINAL EXPERIENCE:

Confidential, IL

Sr Datastage Developer & Lead

Responsibilities:

• Collaborate with stake holders on Business requirements gathering, Data requirement workshops and translate business needs into technical and system design specifications, create source-to-target mappings and document the business rules for HSBC’s US Credit Cards Data Warehouse applications.
• Identify the risk and areas of improvements with respect to process & technology in current applications like Consumer & Commercial Credit Cards, Originations, Account Performance, First Track (Fraud) and Rewards & Risk systems and Critical Data Elements which support the business analytical requirements and Design data warehouse schema & data model using prior experiences and knowledge of current client systems.
• Perform ‘as-is/to-be’ analysis of business processes and enabling the transformation of Credit Cards applications with improved process by providing relevant capabilities from both technical & function aspect.
• Define and demonstrate all the dimensions of the data quality and this includes standards around valid ranges of values, acceptable error rates and metadata management.
• Responsible for design, implementation of end-to-end Confidential US Credit Cards Data Warehouse solution which develops a repository for improved analytical capability and reference to support data-driven decision making and forecasting.
• Developing and testing of complex jobs using Datastage ETL (Extract Transform Load) tool, Unix/SQL program which involves the implementation of mapping logic of various applications like Consumer & Commercial Credit Cards, Originations, Account Performance, First Track (Fraud) and Rewards & Risk systems along with processing/loading Compliance & Regulatory reporting data into Confidential US Credit Cards Data Warehouse.
• Design and develop the Snowflake schema and Star schema to organize data marts using relational databases, Build the warehouse using Facts and slowly changing Dimension concepts, developing the advanced Unix/SQL programing and automation with Control M scheduling tool.
• Develop solutions for data storage structures, data munging, data validation, data cleansing, data scraping and parsing.
• Develop business driven data control check points, custom transformation rules, various edit checks on data elements to verify the acceptance of data as per rules and ensure data quality and reliability.
• Detect data anomalies and identify root cause of data problems. In-depth review of each data element for accuracy and recommend remediation for edit check failures.
• Support UAT efforts with users by creating various Reconciliation reports like source to database reconciliation, finance Income statement and balance sheet metrics reconciliation to verify the acceptance of data processed and loaded into HDW Database as per mapping rules.
• Work with various source and downstream systems to integrate the data as per to the required formats for extraction and loading into database.
• Work on Production Implementation Activities like preparing the Implementation Plan, Back out to ensure smooth deployment of the work product.
• Perform historical data conversion and backfill there by enhancing the data reporting timeframe and system capabilities.
• Investigate, analyze, document and correct and reported defects in the Work Products.
• Responsible for Credit Cards Data Warehouse support activities: Includes Post Implementation validation, assistance with Post Implementation Testing, Post Implementation Monitoring and Root Cause analysis, Issue tracking, escalation and resolution.
• Ensure all documentation is kept complete and up to date.

Environment: InfoSphere Datastage 11.5 (Director, Designer), DB2 Client, Winscp, Control M, Teradata

Confidential

DataStage Sr Developer Global Data Management

Responsibilities:

• Worked extensively on Designer, Director and Administrator of the InfoSphere Datastage.
• Design and development of Extract, Transform, and Load (ETL) processes for extracting data from a various legacy systems and loading into target tables using SQL, DataStage Enterprise Edition.
• Understanding the entire business flow of the project form beginning to ending.
• Having adequate knowledge on quality stages that are used in the existing jobs. Using Sequential file, DB2, Join, Lookup, transformer, datasets, filter, Merge, Sort, remove duplicate stage for designing the jobs in the Data Stage Designer.
• Extensively used File set stage like Sequential file for extracting and reading data.
• Using the advanced techniques in the jobs to improve the performance.
• Involved in analyzing and modifying the existing scripts
• Coordinated the code and data movement to production in production implementation activities. Also involved in the effort of integration testing of Datastage and shell code with scheduler.
• Defined test cases as a part of user testing and drove testing cycle execution of both SIT and UAT. Also documented the results for test cycles.
• Enhancements are made to jobs as per the requirements and Unit testing of the jobs.
• Fix the QA defects within the time lines.
• SAS Layout creation and conversion.
• Control M draft creation for Staging area(Daily and Monthly)

Environment: InfoSphere Datastage 8.5, DB2 Client, Winscp, SAS, Control M, MKS, ARS

Confidential, SA

DataStage Developer & Data modeler

Responsibilities:

• Involved in the design discussions to formulate a Confidential design for development of parallel jobs for various functionalities in FODS.
• Developed Medium and Complex parallel jobs for new batches as per requirements
• Testing of Customized ETL batches and new batches
• Design Documentation for the ETL Batches.
• Data Modeling for new batches using ERWIN 7.3
• Installing new parallel Project in UAT and Production Environment on Datastage 8.5.
• DataStage Project creation, configuration and environment variable setup.
• Involved in activities for Migrating data from exiting Database to new database.
• Triggering daily EOD using Control-M tool.
• Providing training and presentation to the Client

Environment: IBM Datastage v8.1 and v8.5, Oracle 11g, Erwin v7.3, Control M.