Analyst Programmer Resume

SUMMARY

8 Years of experience in IIS DataStage 9.1, IIS DataStage 8.5, DataStage 8.1 & Ascential DataStage 7.5 EE (PX) with various roles and responsibilities.
Excellent experience on IBM Information Analyzer.
Good work experience in UNIX Shell Scripting.
Good work experience in Teradata, DB2, Oracle and SQL.
Good Knowledge on Data Warehousing Concepts.
Have work experience on Control - M Scheduling tool, MKS and RTC.
Excellent Interpersonal Skills, Communication Skills, Technical and Management Skills, Strong Logical & Analytical Skills and a quick learner.
Expertise in Extraction, Transformation and Loading with various operational sources like Oracle and Flat Files into a Data Warehouse.
Knowledge on Tableau.

TECHNICAL SKILLS

ETL: IBM IIS DataStage 9.1, IBM IIS DataStage 8.5, WebSphere DataStage 8.1, DataStage Version control, Data Stage SE 7.5

Languages: SQL, PL/SQL Programming, HTML and UNIX Shell Scripting

Database: Teradata, DB2, SQL, Oracle

Operating System: Unix, Linux

Scheduling Tools: Control - M

Others Tools: Information Analyzer, MKS and RTC

Learning’s: Tableau

PROFESSIONAL EXPERIENCE

Confidential

Analyst Programmer

Responsibilities:

Involved in analyzing the data through Information Analyzer. Extract the data from Flat files and load into Staging tables and perform the business logic in Transformation and later load in Target Teradata tables.
Involved in Developing and testing the data. And providing KT to UAT team in explaining the business requirements.
Designed Parallel jobs using Sort, Join, Lookup, funnel, Transformer, Filter processing stages.
Created monthly data load extracts from all SBA loan servicing agencies for the Data Analytics team. The file sources were several thousands of CSV, Access, SQL, Flat files.
Wrote extensive backend SQL Scripts to scrub and load data files in to a DB2 Database for each months Analytics reporting services.
Designed ETL technical specs performed analysis.
Conducted live sessions for demonstrating prototypes, UAT labs and issue resolution.
Involved in Defect Analysis.
Involved in preparing a test cases document and writing test cases in Quality Centre(QC).

Confidential

Designing and Testing

Responsibilities:

Producing high quality work product and deliverables on-time (zero roll-back, backout) within budget and allowable Delivery Excellence Metrics, adhering to Process.
Taking additional team responsibilities and flexibility for the benefit of the project.
Ensure timely and prompt reporting of risks / issues / Dependencies.
Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Funnel, Transformer.
Designing Reusable components (Parameter set, Job Sequencer) which can be used across the project.
Creating UNIX Shell Scripting for audit process.
Expert in working with DataStage Manager, Designer, and Director.
Involved in Performance tuning to improve the performance of the Data stage jobs.
Involved in Unit Testing, System Testing and UAT.
Involved in creating Data lineage report and Metadata Work bench.
Involved in deployment of code in UAT.
Involved in defect analysis.
Involved in analyzing the data through Information Analyzer.
Involved in creating Test case documents.
Involved in interacting with testing team for any correction of Data.
Involved in writing Test cases in QC.
Providing KT to the team in required area.