SUMMARY

• Over 7.5 Years of IT experience in all phases of software development life cycle which includes analysis, designing, implementation and testing in various domains like insurance, retail, banking and health care.
• Strong Consulting experience in Implementing Full Life Cycle Data Warehousing Projects.
• Extensive Data warehousing experience using IBM Datastage 9.1/8.x/7.x (Datastage designer, manager, director and administrator).
• Designed both server and parallel using various stages like ODBC, transformer, join, merge, look up, funnel, aggregator, copy, and filter.
• Experienced in using advance datastage plug in stages like XML input and XML output.
• Experienced wif Quality stage for data profiling, standardization, matching and survivorship.
• Used information analyzer for columns analysis, primary key analysis, foreign key analysis and cross - domain analysis.
• Extensive experience in IBM DB2 UDB 9.7/9.0/8.0, Oracle 10g/9i/8i, Microsoft SQL Server 2005/2000, Teradata, Netezza databases
• Strong experience in coding using SQL, SQL*plus, PL/SQL stored procedure/functions, triggers and packages.
• Strong hands on experience usingTeradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man), Teradata parallel support.
• Proficient in coding of optimizedTeradata batch processing scriptsfor data transformation, aggregation and load usingBTEQ.
• Extensive experience inShell Scripting
• Developed interfaces using UNIX Shell Scripts to automate teh process of loading, pushing and pulling data from and to different servers.
• Expert wif working on various operating systems IBM AIX 5.2/5.1,sun solaris, windows.
• Sound Knowledge ofData Warehousing concepts,E-R model&Dimensional modeling(3NF) likeStar Schema, Snowflake Schemaand database architecture forOLTPandOLAP applications, Data Analysis and ETL processes.
• Extensively ImplementedError Handling Concepts, Testing, Debuggingskills and Performance tuning of targets, sources, transformation logics.
• Involved in understanding Business Process and coordinating wif Business-users to get specific user requirements. Involved in source data analysis and identified business rules for data migration and for developing data warehouse data marts.
• Quick adaptability to new technologies and zeal to improve technical skills.
• Good analytical, programming, problem solving and troubleshooting skills.

TECHNICAL SKILLS:

ETL: IBM IIS DataStage/Quality Stage 9.1/8.7/8.5/8.1 (Administrator, Designer, Director), Fast Track, Information Analyzer, DataStage 7.5.2/7.0 (EE). SQL Server Data Transformation Services (DTS)

Programming Lang.: SQL, PL/SQL, Transact SQL, XML, UNIX Shell Scripting

Modeling Tools: Erwin, ER Studio, Power Designer, Microsoft Visio

Reporting Tools: Cognos, Business Objects, EXCEL Reporting, Crystal Reports.

Databases and Tools: Oracle 11g/10g/9i/8i, DB2 UDB 9.0/9.7, Teradata V2R3/V2R4.1/ V2R5/V2R6, MS SQL Server 2008/2005/2000, Netezza, Toad, Rapid SQL, SQL Explorer etc

Specialized Tools: SQL*Loader, BCP, MS-Office, CAD/CAM, Pro-E, Matlab

Operating systems: Windows 7/XP/NT, Unix (AIX/HP-UX/Sun Solaris), Linux

Version control/Scheduling: PVCS, DS Version Control, ESP, UC4, AutoSys,Control M,Crontab

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, Georgia

Sr ETL Datastage Developer

Responsibilities:

• Involved in system analysis and design of teh Data warehouse.
• Responsible for Requirement Gathering Analysis and End user Meetings.
• Developed Functional (Business terms) and Technical Design documents.
• Worked closely wif data modeler and database administrator to understand teh business process and participated in gathering of business requirements to load teh data warehouse which is designed on teh Star schema.
• Migrated jobs from Ascential DataStage (7.5) to IIS DataStage (9.1)
• Extensively worked wif Parallel Extender. Using Parallel Processing (Pipeline and partition parallelism) techniques to improve job performance while working wif bulk data sources.
• Worked on theTeradata stored proceduresand functions to confirm teh data and have load it on teh table.
• Developed procedures to populate teh customer data warehouse wif transaction data, cycle and monthly summary data, and historical data.
• Worked on optimizing and tuning theTeradataviews andSQL’sto improve teh performance of batch and response time of data for users.
• Prepared low level technical design document and participated inbuild/reviewof theBTEQ Scripts, FastExports, MultiloadsandFast Load scripts, Reviewed Unit Test Plans&System Test cases.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Created BTEQ scripts to extract data from warehouse for downstream applications.
• Worked on Teradata Query man to validate teh data in warehouse for sanity check.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
• Provided support during thesystem test, Product IntegrationTesting andUAT.
• Verified implementation is done as expected i.e. check teh code members are applied in teh correct locations, schedules are built as expected, dependencies are set as requested.
• Done teh impact assessment in terms of schedule changes, dependency impact, code changes for various change requests on teh existingData Warehouseapplications dat running in a production environment.
• Provided quick productionfixesand proactively involved in fixing production support issues.
• Involved in running Generic Scripts for Feed Validation and Change Detection.
• Extensively used Lookup Stage to perform look up on Cross Reference Tables.
• Developed Parallel jobs, which maintains Surrogate key generation in multiple run.
• Extracting/Loading Data from/into Database tables using DB2 stage.
• Files (Fixed Width) & XML files to staging database & from staging to target Data Warehouse database.
• Used Websphere MQ explorer for data transfer between different platforms.
• Developed Sequence jobs for Data Separation, History Processing, Load and Post Process Routine.
• Participated in Daily stand-up meetings wif project manager, Team Lead, co-developers, communicated wif testers and resolved trackers.
• Created shell script to run data stage jobs from UNIX and tan schedule this script to run data stage jobs through scheduling tool.
• Modified UNIX shell script to run Job sequencer from teh mainframe job.
• Create parameter set to assign a value to job at run time.
• Documented every job (proper Naming convention, Standards, Annotation etc.) as per DataStage Design standards set by IBM.
• Involved in Unit testing and UAT testing.
• Checking of data in live as part of post implementation support.

Environment: IBM InfoSphere DataStage 9.1,Mainframe, Teradata, Autosys, Erwin, TOAD, SQL Developer, PVCS, MS Visio Business Objects, Shell Scripts, HP Unix, Windows XP.

Confidential, Lower Manhattan, NY

Sr. DataStage Developer

Responsibilities:

• Developed ETL procedures to ensure conformity, compliance wif Emblem Health standards and to translate business rules and functionality requirements into ETL procedures.
• Created and Maintained DataStage projects along wif Job Migration and Scheduling.
• Migrated jobs from Ascential DataStage EE (7.5) to IIS DataStage (8.5).
• Administered and Designed ETL jobs for Claims, Membership Coverage and Member Status Tracking Jobs Using Ascential DataStage EE (7.5)/Information Server (8.5).
• Suggested and implemented enhancements to existing Server Jobs to be implemented in parallel using partitioning and Parallel Stages.
• Documented and Maintained Data Dictionaries wif teh updated Data Model Enhancements.
• Worked wif advanced PL/SQL concepts PL/SQL objects and records used them in building procedures and functions.
• Extensive noledge in performance tuning teh queries and development, built indexes as part of tuning and optimization.
• Implemented Complex Designs using parallel Stages like Join, Lookup, Pivot, Change Capture and Surrogate Key.
• Parameterized teh Server/Parallel Jobs using Environmental variables, Parameter Sets and Job Parameters.
• Created teh Environmental Variables and Set up teh default values in DataStage Administrator.
• Designed Jobs involving Complex Flat File (CFF) Stage to extract Data from Mainframes (Cobol Copybooks) and load it to Oracle Tables.
• Handled teh Retro Member records using Current to Previous Row Comparison using Stage variables along wif PL/SQL Code.
• Designed Jobs involving PIVOT Stage for loading teh multiple occurrences from teh COBOL Copybook (Mainframes).
• Extensively worked in UNIX, writing Shell Scripts for data cleansing and scheduling.
• Worked on data export and import wizard to transfer data between different schemas in oracle using TOAD, MySQL.

Environment: IIS DataStage 8.5, Ascential DataStage EE 7.5x2 (Designer, Director, Manager, Administrator), Mainframes, Erwin, Oracle 11g, SQL Server, PL/SQL, T-SQL, TOAD, UNIX, IPSwitch WS FTP Professional, Shell Scripting, Autosys, HP Quality Center.

Confidential Corporation, Boston

Sr. DataStage Developer

Responsibilities:

• Designing, Developing, Documenting and Testing teh Different Jobs according to Business Requirements (ETL Specification)
• Developed Server Jobs which loads Dimension Tables and maintains Surrogate key generation in multiple run
• Migration of data from Staging Area into Marketing and Sales Data Marts to store reliable data for decision support system using DataStage as ETL tool
• Familiar wif import/export of DataStage Components (Jobs, DSRoutines, DSTransforms, and Table Definitions) between DataStage Projects
• Created mappings according to teh specification using various transformations like Aggregator, Lookup, Update strategy transformation etc.
• Created Workflows using various tasks like session, timer, control, event wait, event raise tasks etc.
• Used Shared container for simplifying design and maintenance
• Experienced in fine tuning, troubleshooting, bug fixing, defect analysis in DataStage Jobs
• Used DataStage Director to unlock jobs (Recourses clean up), monitoring jobs and managing logs
• Designed and developed jobs using Link Partioner and Link Collector for splitting bulk data in to subsets and to dynamically distribute teh data to achieve best job performance
• Extensively worked on Hash file in Server jobs for faster reference look up
• Documented teh development process and performed noledge transfer to Business Intelligence team
• Documented every job (proper Naming convention, Annotation etc.) as per DataStage Design standard set by NYCHA.
• Developed Packages and customized functions and Triggers based upon teh business logics.
• Involved in Performance tuning of complex queries.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate functionality for various modules.

Environment: DataStage 7.5.2 Server (Designer, Manager, Director, Administrator), DB2 UDB 8.2, IBM AIX 5.2, SQL, PL/SQL, UNIX Shell Scripting.

Confidential

Sr. DataStage Developer

Responsibilities:

• Worked closely wif Business analysts and Business users to understand teh requirements and to build teh technical specifications.
• Responsible to create Source to Target (STT) mappings.
• Responsible to design, develop and built DataStage parallel jobs using DataStage designer.
• Developed and supported teh Extraction, Transformation and Load process (ETL) for a data warehouse from various data sources using DataStage Designer.
• Designed and developed Parallel jobs to extract data, clean, transform, and to load teh target tables using teh DataStage Designer
• Designed developed job sequential to run multiple jobs
• Used DataStage Designer for importing teh source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
• Designed and developed teh Routines and Job Sequence for teh ETL jobs
• Involved in Unit testing and integration testing.
• Responsible for running jobs using Job Sequencers, Job Batches.
• Developed Parallel jobs using various stages like Join, Merge, Funnel, Lookup, Sort, Transformer, Copy, Remove Duplicate, Filter, Peek, Column Generator, Pivot and Aggregator stages for grouping and summarizing on key performance indicators used in decision support systems
• Extensively worked on Teradata MLoad, Teradata Enterprise Stage, and Teradata API Stage to extract, transform and load data.
• Extensively used Reject Link, Job Parameters, and Stage Variables in developing jobs
• Used teh DataStage Director to run, schedule, monitor, and test teh application on development, and to obtain teh performance statistics.
• Developed Packages and customized functions and Triggers based upon teh business logics.
• Involved in Performance tuning of complex queries.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate teh functionality for various modules.

Environment: IBM InfoSphere DataStage/Quality Stage 8.1.1 (Designer, Director and Administrator), Teradata V2R12, AIX 5.3, SQL Server, SQL Assistant, Windows XP, Visio, Erwin.

Confidential

DataStage Consultant

Responsibilities:

• Involvement in drafting teh ADS (Application Design Specifications) and PGS (Program Specification) of teh existing Jobs in teh Project CBOR such as Member Number Reassignment, Pricing Extract, SOBI Extract, Developed Test Scripts, Test Procedures, and testing standards for DataStage Jobs.
• Developed and Executed SQL and UNIX generated test.
• Involved in gathering teh business requirements and preparation of Technical design specs for ETL projects.
• Prepared mapping documents, conceptual design, and testing documents for ETL jobs.
• Developed various Unix Shell scripts for teh checking teh "status of claims", "Job run scripts", fix of teh existing scripts and designing various validation jobs. Involved in Designing Regressive Testing and production support for DataStage jobs in various projects involving in load teh source data to teh staging area, created teh update strategy, transformation, lookup, column export filter and slowly changing Dimensions,
• Designed and developed Procedures, Functions, Routines and Sequence for business logic as required.
• Review of Unit test cases, Integration test cases of all teh assigned modules.
• Review of Unit test cases, Integration test cases of all teh assigned modules.
• Created jobs sequences, Batch Jobs, Developed DataStage Custom routines.
• Performance Tuned DataStage jobs to significantly reduce teh run time.
• Developing teh Job Sequences and batch jobs run & control set of jobs and also used looping functionality for mail generation.
• Working on writing Procedures and Packages in PL/SQL.
• Knowledge of Built-in, Plug-in and Custom Stages in DataStage.
• Lead and mentored onsite/offshore resources to deliver successful projects.
• Performance tuning (SQL and PL/SQL) critical queries wif procedures, create Tables, Indexes, Views, triggers and programs

Environment: IBM DataStage 8.1/7.5, Oracle 9i,Mainframe ACF2, TWS, XML files, PL/SQL, AIX 5.3, Windows 2000, Microsoft Office, Toad.