SUMMARY:

• Six Years of overall IT experience in Analyzing, Designing, Developing, Testing, Implementing and Maintaining client/server business systems over six years of experience with Confidential InfoSphere/WebSphere Datastage (Designer, Director, Administrator and Manager) to implement ETL solutions and Data Warehousing projects
• Developed Parallel jobs using various stages like Join, Confidential, Confidential, Confidential, SCD, Funnel, Sort, Transformer, Copy, Remove Duplicate, Filter, Pivot and Aggregator stages for grouping and Confidential on Confidential performance indicators used in decision support systems.
• Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis, Physical and Logical design, Resource Planning, Coding and implementing business applications.
• Expertise in performing Data Migration from various Confidential systems to target database.
• Expertise in Data Modeling, OLAP/ OLTP Systems, generation of Surrogate Confidential, Data Modeling experience using Ralph-Kimball methodology and Bill-Inmon methodology, implementing Star Schema, Snowflake Schema, using Data Modeling tool Erwin.
• In Depth knowledge in Data Warehousing and Business Intelligence concepts with emphasis on ETL and Life Cycle Development including requirement Analysis, Design, Development, Testing and Implementation.
• Knowledge on Hadoop, working relational table structures can be used to extract information from unstructured data.
• Experience in Data Warehouse development, worked with Data Migration, Data Conversion, and (ETL) Extraction/Transformation/Loading using Ascential Datastage.
• Experience in implementing Confidential, DB2, DB2/UDB, Oracle 10.2/ 9i/ 8i/ 8.0, SQL Server, PL/SQL, and SQL *PLUS database applications.
• Good Knowledge on Agileand Waterfall methodologies.
• Experience in Confidential data sources like Oracle, Teradata, DB2, SQL Server into ODS and DWH areas.

TECHNICAL SKILLS:

ETL Tools: IBM InfoSphere Datastage 11.5/8.7/8.0/7.5.2 (Designer, Director & Administrator).

Database: Teradata V13., Oracle 10g/9i/8i, MS SQL Server 2005/ 2000, DB2, MS Access 97/ 2000/ 2007

Languages: SQL, PL/SQL, UNIX Shell Script, C/C++, .Net, XML.

Data Modeling Tools: Erwin 4.0/3.5, Star Schema, Snowflake Schema, OLAP, OLTP Tools TOAD, Win SQL, MS Office, Autosys, SQL Plus, SQL * Loader.

Operating Systems: Red Hat Linux, UNIX. HP-UX, Sun Solaris

PROFESSIONAL EXPERIENCE:

Datastage Developer

Confidential, MA

Responsibilities:

• Extensively involved in different Team review meetings, review & Analysis.
• Interacted extensively with clients during meetings.
• Developed the ETL Development Standards and best practices to design the Data Stage Parallel jobs consistently across the project.
• Extensively involved in Agile delivery environment.
• Did auditing/validation after each load and developed the code to perform actions according to the results.
• Extensively used Parallel Stages like Join, Confidential, Confidential, Filter, Aggregator, Copy, Sort,Funnel, Change Data Capture, Remove Duplicates, Confidential Generator, Row Generator, and Column Generator for development and de-bugging purposes
• Created several Job Sequences for the maintenance of Data Stage jobs using Wait for file, Job Activity.
• Worked on ODBC, to extract data from the tables which are from core tables and materialized view tables.
• Provide staging solutions for Data Validation techniques.
• Created smart SQL Queries for minimal resource use during data extraction from source.
• Created a technical document for ETL design for efficient stage use.
• Created universal parameter set for ETLs.
• Assisted in creation of a new database to monitor the growth and performance of different
• Instances.
• ETLs were designed and created based on performance, system availability and businessrequirements.
• Involved in Unit Testing with the jobs and date loaded in the Target database both in SIT and
• UAT.
• Manage scheduling and performance analysis of current jobs in production.

Environment: IBM WebsphereDatastage11.5, Oracle 10g, Quality Stage Designer, DirectorAdministrator), SQL, PL/SQL, UNIX Shell Scripting, DataStage Version Control, MS SQL server, Cognos, Framework Manager

Datastage Developer

Confidential, PA

Responsibilities:

• Involved in data modeling session, developed technical design documents
• Involved in performance tuning of long running jobs.
• Reviewing the code developed by the subordinates with respect to naming standards, best practices.
• Involved in creating and maintaining Sequencer and Batch jobs.
• Used the ETL Datastage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Creating the scheduling plan, job execution timings and sharing with scheduling team (Control-M)
• Developed Parallel Jobs using various Development / Debug Stages (Peek Stage, Head and Tail Stage, Row generator stage, Column generator stage, Sample stage) and Processing Stages (Aggregator, Change Capture, Change Apply, Filter, Sort and Confidential, Funnel Remove Duplicate Stage).
• Involved in production cutover and implementation plan.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Involved in developing test plans with Informatica, so that the developed programs can be verified to ensure its applicability and smooth operation.
• Worked on Autosys for job scheduling to define event dependencies.
• Involved in data discovery in profiling different source data.
• Creation of new instance for the Data warehouse.
• QlikView Connector can transform and validate Strings, Numbers, Dates, Postcode and Phone Numbers.
• Worked on different databases and joined the data with individual queries and then blend them on within Tableau.
• Participate in evaluating and analyzing utilities and tools offered by BI applications/tools vendors.
• Developed shell scripts and updated the log for the backups.
• Involved in Unit Testing with the jobs and date loaded in the Target database.

Environment: IBM WebSphere Datastage 8.7, Oracle 10.2, Quality Stage Designer, Director, Administrator), DB2 UDB 8, Teradata, Linux, SQL, PL/SQL, UNIX Shell Scripting, Datastage Version Control, MS SQL server, Mainframe, Autosys, Info analyzer.

Data stage Developer

Confidential, Texas

Responsibilities:

• Involved in complete Data Warehouse Life Cycle from requirements gathering to end user support.
• Provide day-to-day and month-end production support for various applications like Business Intelligence Center, and Management Data Warehouse by monitoring servers, jobs on UNIX.
• Worked in onsite-offshore environment, assigned technical tasks, monitored the process flow, conducted status meetings and making sure to meet the business needs.
• Involved in Designing, Testing and Supporting Datastage jobs.
• Developed Parallel jobs using various stages like Join, Confidential, Confidential, Confidential, SCD, Funnel, Sort, Transformer, Copy, Remove Duplicate, Filter, Pivot and Aggregator stages for grouping and Confidential on Confidential performance indicators used in decision support systems.
• Accomplished various development requests through mainframe utilities, CICS Conversation
• Meet the clients on a weekly basis to provide better services and maintain the SLAs.
• Redesigned, modified the existing jobs and shell scripts in production environment to fix the daily aborts.
• Developed plug-ins in C language to implement domain specific business rules
• Used Control-M to schedule jobs by defining the required parameters and monitor the flow of jobs.
• Automated the process of generating daily and monthly status reports for the processing jobs.
• Created Teradata Stored Procedures to generate automated testing SQLs
• Worked on exploring data set to demonstrate more data manipulation techniques.
• Drop indexes, remove duplicates, rebuilt indexes and rerun the jobs failed due to incorrect source data.
• Involved in the process of two client bank Confidential by taking care of the customer account numbers, bank numbers, and their respective applications

Environment: IBM Info Sphere Data stage 8.1 (Designer, Director, Administrator), Profile Stage, Quality Stage, Oracle 10g, Confidential DB2, Toad, Erwin 4.5.2, sequential files, flat files, Autosys.

Datastage Developer

Confidential

Responsibilities:

• Using Confidential InfoSphere Datastage software, extracting data from DB2, Oracle and Flat File and Load to target tables.
• Participated in Business Analysis and technical design meeting with business and technical staff to develop Entity Relationship / Data Models, requirements document, and ETL specifications.
• Creating and maintaining Datastage Parallel Jobs for every policy holder from HSBC Securities and Capital Markets.
• Extracted data from text files, using FTP Stage and loaded into different databases.
• Developed Parallel Jobs using various Development / Debug Stages (Peek Stage, Head and Tail Stage, Row generator stage, Column generator stage, Sample stage) and Processing Stages (Aggregator, Change Capture, Change Apply, Filter, Sort and Confidential, Funnel Remove Duplicate Stage).
• Designed Parallel jobs using various stages like Join, Confidential, Remove Duplicates, Filter, Confidential, Modify, Aggregator and Funnel stages.
• Using Datastage Software Development Confidential, Functions like DS Job Info, ICONV and OCONV, Transformers like Data Transform.
• Developed Test Cases and Performed Unit Testing, System, Integration Testing, UAT Testing.
• Used AUTOSYS to Schedule the Datastage ETL batch jobs on a daily, weekly and monthly basis.
• Designed the Datastage Integrity check jobs which check each Dimension ID and Fact table that has a corresponding ID in a Dimension table.
• Involved in developing and rewriting Investigation, Matching, Survivors rules and Standardization using Quality Stage.
• Used Datastage Director for Executing, Monitoring, analyzing logs and scheduling the jobs.

Environment: IBM Info Sphere Data stage 8.1 (Designer, Director, Administrator), Profile Stage, Quality Stage, Oracle 10g, Confidential DB2, Toad, Erwin 4.5.2, sequential files, flat files, Autosys.

Data stage Developer/ Data Analyst

Confidential

Responsibilities:

• Involved in complete Data Warehouse Life Cycle from requirements gathering to end user support.
• Provide day-to-day and month-end production support for various applications like Business Intelligence Center, and Management Data Warehouse by monitoring servers, jobs on UNIX.
• Worked in onsite-offshore environment, assigned technical tasks, monitored the process flow, conducted status meetings and making sure to meet the business needs.
• Involved in Designing, Testing and Supporting Datastage jobs.
• Developed Parallel jobs using various stages like Join, Confidential, Confidential, Confidential, SCD, Funnel, Sort, Transformer, Copy, Remove Duplicate, Filter, Pivot and Aggregator stages for grouping and Confidential on Confidential performance indicators used in decision support systems.
• Accomplished various development requests through mainframe utilities, CICS Conversation
• Meet the clients on a weekly basis to provide better services and maintain the SLAs.
• Redesigned, modified the existing jobs and shell scripts in production environment to fix the daily aborts.
• Developed plug-ins in C language to implement domain specific business rules
• Used Control-M to schedule jobs by defining the required parameters and monitor the flow of jobs.
• Automated the process of generating daily and monthly status reports for the processing jobs.
• Created Teradata Stored Procedures to generate automated testing SQLs
• Worked on exploring data set to demonstrate more data manipulation techniques.
• Drop indexes, remove duplicates, rebuilt indexes and rerun the jobs failed due to incorrect source data.
• Involved in the process of two client bank Confidential by taking care of the customer account numbers, bank numbers, and their respective applications

Environment: Data stage 7.5X2, SunOS 5.8, Control-M 6.4.01, PL/SQL Developer 7.1, Teradata 12, Erwin, Autosys, Toad, Microsoft Visual Studio 2008 (Team Foundation Server), Case Management System, Confidential, CA Harvest Change Management.