PROFESSIONAL SUMMARY:

• Around 8+ years of experience in ETL mechanisms using Ascential DataStage 4.x/5.x/6.x/7.x/PX/EE a n d IBM Infosphere DataStage V 9.1 /8.5 (Parallel Engine)
• Around 6+ years of experience in RDBMS using ORACLE 9i/8x, SQL Server, Sybase, DB2, Teradata in client/server and mainframe environments.
• Good knowledge in implementation of IT in Retail, Banking, Finance and Insurance Industries.
• Expertise in Enterprise Application Integration (EAI) Tools akin to Data Power and IBM Web sphere MQ.
• Worked on Health care decision support systems and health insurance domains.
• Excellent knowledge and experience in data warehouse development life cycle, SDLC, repository management and administration, dimensional modeling, implementation of Star and Snowflake schemas.
• Building Data Marts using IBM Information Server 8.0 & IBM WebSphere Data Stage and Informatica 8.
• Worked on code and executables migration from Informatica 8.0 to DataStage V8.1( Parallel Engine)Monitoring and optimizing the performance of the PostgreSQL databases.
• In - depth knowledge of PostgreSQL 9 X versions.
• Extensively used parallel processing stages like Change Data Capture, Data Set, SAP Connector, File Set, Aggregator, Filter, Funnel, FTP, Join, Merge, Lookup, Modify, Sort, Transformer.
• Expert in using Information Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis. Experience in scheduling tools like Autosys and Mainframes CA7.
• Expertise in doing Usage Analysis using Ascential Data Stage and MetaStage for many Data stage projects
• Allocating system storage and planning future storage requirements for the database system.
• Involved in migration of ETL code from testing environment to Production environment
• Involved in writing the test plans, test cases and test scripts based on Functional Requirement and Business Requirement

TECHNICAL SKILLS:

RDBMS: MS SQL SERVER 2008, Oracle 11g/10g/,PL/SQL,Teradata V2R12,PL/SQL, Greenplum DataBase 3.3, DB2 UDB 9.0

DB Modeling Tools/ Business Intelligence Tools: MS-VISIO, Business Object 6.5, Crystal Reports 6.x, Cognos 8.4,OBIEE, Netezza 6.0.8

ETL Tools & MDM Tool: IBM Information Server 11.3 & IBM WebSphere Data Stage V9.1 with Parallel Extender and experience IIS Suite (Information Analyzer), Pentaho Data Integration, Quality Stage 7.51 A, Informatica 7.0/8.1 (Power Center / Power Exchange), Abintio GDE( ) Abinitio Co>Opsys(3.0 to 2.12)

Languages: C++, UNIX Shell Scripting (Korn /KSH), Linux Scripting, C, HTML, PL/SQL, Java 5.

WEB Technology: ASP, VB Script, JavaScript, MS-Visual InterDev, ADO, HTML, DHTML, XML, IIS

Operating systems: Unix, Windows Vista/XP, Linux, AS/400

PROFESSIONAL EXPERIENCE:

Confidential, Rochester, MN

ETL Data-Analyst

Responsibilities:

• Involved in Building Quality metrics based on Minnesota community measures for chronic and Cancer screenings.
• Involved in building Diabetes, Vascular, Asthma, Hypertension metrics screenings for office of population and health management.
• Involved in building cervical cancer, Breast cancer and colon cancer metrics screenings for office of population and health management.
• Worked extensively with ICD-9,ICD-10 and snomed codes to identify the diagnosis, Procedures and surgeries.
• Helped the transition from ICD-9 to ICD-10 codes for all the quality metrics.
• Worked with Business users in understanding the requirements and creating the Source to target mappings using excel and IBM fast track.
• Worked with legacy systems like Cerner, MICS lastword, to query and Identify the source data.
• Set up the deployment process for code migration from Development to UAT and Production.
• Integrated the Legacy systems to UDP DB2 database.
• Used the Datastage11.0 to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Monitored, recognized, and reported by doing a detailed observation of the tables between the Source and Target for any discrepancy with respect to the table attributes and definition.
• Designed Parallel jobs using various stages like DB2 Enterprise, DB2 connector, Transformer, Join, Merge, Remove Duplicates, Sort, Filter, Dataset, Lookup, Funnel stage, Column Generator, Peek stages.
• Designed requirements traceability matrix to trace/manage business requirements.
• Researched best industry practices and implemented best practices via template and process improvement
• Used to interact with the client and BA’s to understand the ETL requirements.
• Assigned the ETL tasks to offshore team and monitor, verify the code designed by offshore team.
• Used to interact with DBA’s and Migration team for code migration and.
• Enhanced the re usability of the jobs by making and deploying shared containers and multiple instances of the jobs.
• Built sequence jobs to run parallel jobs in a batch process and scheduled sequences using Autosys scheduler.
• Test on multiple handheld devices
• Construct testing environments simulate real world environments
• Extract appropriate logs and gather diagnostic information for issues encountered during testing
• Construct test cases for the defined test plan; modify the existing test cases as the test requirements change
• Collaborate daily with the QA, Development, and Product team to ensure that quality standards are met
• Research, identify, reproduce, isolate and report defects
• Learned the application by thoroughly reading the documents
• Communication with Developers and Product Engineers
• Conducted Regression Testing to ensure that no new problem goes undetected
• Tested Functionalities of the application

Environment: IBM InfoSphere Information Server Datastage 11.0, DB2 v10.5.0.7, Rapid SQL 8.7.5, Toad for DB2, SFTP, Oracle 10g, Linux, AS400, Microsoft Excel 2010, Erwin 4.2, XML .

Confidential, New York

ETL Test lead

Responsibilities:

• Involved in conversion of Informatica 7.1.3 code on AIX server to Datastage 11.0 on Linux server.
• Involved in conversion of mainframe (CA7) scheduling to Autosys Scheduling.
• Worked with Business users in explaining the conversion advantages and issues, so as to get their approvals for production migrations.
• Ran Informatica Workflow's and Tasks, to compare the results between converted DataStage jobs and Informatica.
• Worked as onshore lead and managed team of 15 developers working on onshore-offshore Model.
• Worked on PostgreSQL internals, to get data for performance issue and give recommendation to resolve issue.
• Set up the deployment process for code migration from Development to UAT and Production.
• Extensively worked on Parallel Jobs Datastage 11.0
• Used the Datastage to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Monitored, recognized, and reported by doing a detailed observation of the tables between the Source and Target for any discrepancy with respect to the table attributes and definition.
• Designed Parallel jobs using various stages like DB2 Enterprise, DB2 connector, Transformer, Join, Merge, Remove Duplicates, Sort, Filter, Dataset, Lookup, Funnel stage, Column Generator, Peek stages.
• Designed requirements traceability matrix to trace/manage business requirements.
• Researched best industry practices and implemented best practices via template and process improvement
• Used Rational Clear Case and Clear Quest as Configuration Management and Change control tools.
• Written postgres Plsql scripts to pull and insert data.
• Used to interact with the client and BA’s to understand the ETL requirements.
• Assigned the ETL tasks to offshore team and monitor, verify the code designed by offshore team.
• Used to interact with DBA’s and Migration team for code migration and.
• Enhanced the re usability of the jobs by making and deploying shared containers and multiple instances of the jobs.
• Built sequence jobs to run parallel jobs in a batch process and scheduled sequences using Autosys scheduler.
• Test on multiple handheld devices
• Construct testing environments simulate real world environments
• Extract appropriate logs and gather diagnostic information for issues encountered during testing
• Construct test cases for the defined test plan; modify the existing test cases as the test requirements change
• Collaborate daily with the QA, Development, and Product team to ensure that quality standards are met
• Research, identify, reproduce, isolate and report defects
• Learned the application by thoroughly reading the documents
• Communication with Developers and Product Engineers
• Conducted Regression Testing to ensure that no new problem goes undetected
• Tested Functionalities of the application

Environment: IBM InfoSphere Information Server Datastage 11.0, Netezza 6.0.8, SQL navigator 6.4, Microsoft studio R2, Toad for DB2, SFTP, Postgres SQL 9.4, DB2 - UDB Version 9, Oracle 10g, Linux, AS400, Microsoft Visio 2003, Erwin 4.2, XML .

Confidential, Denver, CO

DataStage Testing Lead

Responsibilities:

• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Was responsible for loading, extracting and validation of client data.
• Liaising with end users and 3rd party suppliers.
• Analyzed raw data, drawing conclusions & developing recommendations
• Wrote TSQL scripts to manipulate data for data loads and extracts.
• Developed data analytical databases from complex financial source data.
• Data entry, data auditing, creating data reports & monitoring all data for accuracy.
• Designing, developing and implementing new functionality.
• Worked as lead and guided team of 12 developers to achieve project goals and time lines.
• Advising on the suitability of methodologies and suggesting improvements.
• Carried out specified data processing and statistical techniques.
• Supplying qualitative and quantitative data to colleagues & clients.
• Skilled at performing Gap analysis, Risk analysis, and Cost/Benefit analysis, along with good knowledge of process workflow tools and techniques
• Adept at preparing business requirements documents (BRD’s), defining project plans, writing system requirements specifications, and delivering project/status reports.
• Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using Rational Rose and MS
• Used DataStage 11.0 to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Monitored, recognized, and reported by doing a detailed observation of the tables between the Source and Target for any discrepancy with respect to the table attributes and definition.
• Designed Parallel jobs using various stages like DB2 Enterprise, DB2 connector, Transformer, Join, Merge, Remove Duplicates, Sort, Filter, Dataset, Lookup, Funnel stage, Column Generator, Peek stages.
• Consulted with and advises staff DBA’s on database management issues, influencing the PostgreSQL database.
• Worked on onshore offshore model as a lead for 12 Testers.
• Assigned the ETL tasks to offshore team and monitor, verify the code designed by offshore team.
• Built sequence jobs to run parallel jobs in a batch process and scheduled sequences using DataStage director.
• Performed Unit testing on designs developed to get rid and recognize any abnormalities or errors to meet the desired business rule.
• Created and modified tables in personal schema and replicated/generated data for testing purpose, with a view to be creative and recognize any loop hole in the design.
• Involved in creating, testing, proofing and updating technical documentation for source to target mapping procedures to facilitate better understanding of the process and in corporate changes as and when necessary.

Environment: IBM InfoSphere Information Server DataStage 11.0(Quality Stage, Information Analyzer), Abintio 3.0/2.15, PL/SQL developer, Pentaho Data Integration, Postgres SQL 9.4, Toad for DB2, DB2 - UDB Version 9, Oracle 10g, Linux, AS400, Microsoft Visio 2003, Erwin 4.2, XML .

Confidential, Charlotte, NC

ETL Lead

Responsibilities:

• Extensively worked on Data Extraction, Transforms, Loading and Analysis.
• Ran job sequencers from Director to execute Datastage jobs.
• Involved in batch integration of Datastage jobs through CA7
• Involved in code migration from Development environment to SIT and resolved deployment issues.
• Worked as onshore Datastage lead consisting of 6 developers.
• Provided support in executing various test cases and helped in resolving the pending code defects.
• Worked with core Unix support team to configure parallel algorithms to optimize the server performance.
• Conducted daily triage calls with testing and development teams.
• Conducted Swat calls to resolve Datastage and CA7 integration issues.
• Conducted Datastage server performance monitoring in daily basis
• Involved in various Data Stage Admin related activities like DS Engine recycle, importing Project level environment variables.
• Created Daily, weekly server performance reports to be circulated to top level management.
• Involved in ad-hoc executions of Datastage jobs through CA7.
• Involved in Database schema migration from Development to SIT.
• Ran Jobs, Job monitoring using UNIX command line and modified existing shell and UNIX scripts to suit the present functional requirements.
• Created and modified tables in personal schema and replicated/generated data for testing purpose, with a view to be creative and recognize any loop hole in the design.
• Involved in creating, testing, proofing and updating technical documentation for source to target mapping procedures to facilitate better understanding of the process and in corporate changes as and when necessary.
• Worked on troubleshooting, performance tuning and performance monitoring for enhancement of Datastage jobs.

Environment: IBM Infosphere Information Server DataStage 8.7,, Postgres SQL 9.0, DB visualizer, DB2 9.7, Oracle 11g, Linux, SQL server 10.5, Microsoft Visio 2003, Erwin 4.2, Mainframes CA7 scheduler .

Confidential, Denver, CO

Sr. DataStage Developer

Responsibilities:

• Involved in Installation of Infosphere Information server Datastage 8.5 on Linux server, AIX.
• Involved in Data Model analysis and creation of logical and physical data model creation.
• Set up the deployment process for code migration from Development to UAT and Production.
• Configured Datastage to connect to ODBC and DB2 databases.
• Extensively worked on Parallel Jobs InfoSphere DataStage 8.5.
• Used the DataStage to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Monitored, recognized, and reported by doing a detailed observation of the tables between the Source and Target for any discrepancy with respect to the table attributes and definition.
• Designed Parallel jobs using various stages like DB2 Enterprise, DB2 connector, Transformer, Join, Merge, Remove Duplicates, Sort, Filter, Dataset, Lookup, Funnel stage, Column Generator, Peek stages.
• Used Unix commands to do the Datastage administrator work.
• Used to interact with the client and BA’s to understand the ETL requirements.
• Assigned the ETL tasks to offshore team and monitor, verify the code designed by offshore team.
• Used to interact with DBA’s and QA lead for code migration and testing of the code.
• Enhanced the reusability of the jobs by making and deploying shared containers and multiple instances of the jobs.
• Built sequence jobs to run parallel jobs in a batch process and scheduled sequences using DataStage director.
• Used Sequence activity stages like wait for file, Job activity, Execute command, and email notification activity.
• Managed version control, meshed backups with IT backup scheme using UNIX shell scripts and cron.
• Used efficiently CVS to export and import DataStage jobs for backup purpose.
• Ran Jobs, Job monitoring using UNIX command line and modified existing shell and UNIX scripts to suit the present functional requirements.
• Developed ETL extraction routines to extract data from databases using DataStage XML input Stage.
• Performed Unit testing on designs developed to get rid and recognize any abnormalities or errors to meet the desired business rule.
• Created and modified tables in personal schema and replicated/generated data for testing purpose, with a view to be creative and recognize any loop hole in the design.
• Involved in creating, testing, proofing and updating technical documentation for source to target mapping procedures to facilitate better understanding of the process and in corporate changes as and when necessary.
• Worked on troubleshooting, performance tuning and performance monitoring for enhancement of DataStage jobs.

Environment: IBM InfoSphere Information Server DataStage 8.5(Quality Stage, Information Analyzer), PL/SQL developer, Toad for DB2, DB2 - UDB Version 9, Oracle 10g, Linux, AS400, Microsoft Visio 2003, Erwin 4.2, XML .

Confidential, Downers Grove, IL

Sr. DataStage Developer

Responsibilities:

• Involved in status meetings and interacted with the technical team and business analyst to get the business rules and understand the process.
• Imported/Exported table definitions, Repositories and attributes for the designing process.
• Extensively worked on Parallel Jobs InfoSphere DataStage 8.1.
• Used the DataStage to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Monitored, recognized, and reported by doing a detailed observation of the tables between the Source and Target for any discrepancy with respect to the table attributes and definition.
• Designed Parallel jobs using various stages like Oracle Enterprise, Transformer, Join, Merge, Remove Duplicates, Sort, Filter, Dataset, Lookup, Funnel stage, Column Generator, Peek stages.
• Enhanced the reusability of the jobs by making and deploying shared containers and multiple instances of the jobs.
• Used Information Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis.
• Imported and exported repositories across DataStage projects.
• Used IBM Infosphere Information Analyzer in data profiling process, Baseline analysis, deleting analysis results and created column analysis summary statistics reports.
• Used DataStage Director effectively to read through the logs and rectify the issues causing warnings and errors.
• Used efficiently PVCS to export and import designs for backup purpose.
• Migrated jobs from legacy to new systems using Unix scripts.
• Used Oracle10g PL/SQL Developer for data analysis of data and tables between source and target.
• Ran Jobs, Job monitoring using UNIX command line.
• Edited text files, moved and copied files using UNIX scripts.
• Modified existing shell and Unix scripts to suit the present functional requirements.
• Helped in migrating data from real time systems to Oracle 10g.
• Developed ETL extraction routines to extract data from databases using DataStage XML input Stage.
• Performed Unit testing on designs developed to get rid and recognize any abnormalities or errors to meet the desired business rule.
• Created and modified tables in personal schema and replicated/generated data for testing purpose, with a view to be creative and recognize any loop hole in the design.
• Involved in creating, testing, proofing and updating technical documentation for source to target mapping procedures to facilitate better understanding of the process and in corporate changes as and when necessary.
• Involved in the migration of DataStage jobs from development to production environment
• Worked on troubleshooting, performance tuning and performance monitoring for enhancement of DataStage jobs.

Environment: IBM InfoSphere Information Server DataStage 8.1(Quality Stage, Information Analyzer), PL/SQL developer, SQL Assistant, DB2 - UDB, Sybase 11, Informix IDS 9.4, Oracle 10g/11g, Linux, Unix, Microsoft Visio 2003, Erwin 4.2, PVCS 7.5.1.0, Quality Stage 7.5.1.0, XML, TeraD ata V 13, IBM Web sphere MQ 6.0 .

Confidential, Madison, SD

Sr. DataStage Developer

Responsibilities:

• Analyzed Business Requirements by working closely with Business Area.
• Prepared design documents and mapping documents.
• Extensively worked on Data Extraction, Transforms, Loading and Analysis.
• Ran job sequencers from Director to execute DataStage jobs.
• Designed and developed various jobs for Standardization, scheduling and running jobs under job sequencer and DataStage Director.
• Involved in batch integration of DataStage jobs through CA7
• Involved in code migration from Development environment to SIT and resolved deployment issues.
• Provided support in executing various test cases and helped in resolving the pending code defects.
• Conducted daily triage calls with testing and development teams.
• Conducted Swat calls to resolve DataStage and CA7 integration issues.
• Conducted DataStage server performance monitoring in daily basis
• Involved in various Data Stage Admin related activities like DS Engine recycle, importing Project level environment variables.
• Created Daily, weekly server performance reports to be circulated to top level management.
• Involved in ad-hoc executions of DataStage jobs through CA7.
• Involved in Database schema migration from Development to SIT.

Environment: IBM InfoSphere DataStage V8.0.1(Parallel Engine), SAP R/3 Pack, PL/SQL Programmer, DB2 - UDB, Sql Server 2005, Sybase 11, Informix IDS 9.4, IBM InfoSphere Information Analyzer 8.0.1, Greenplum DataBase 3.3, Linux, Unix, Oracle 10g, XML, COTS, Visio 2003, Java 5,PeopleSoft 8.8,Erwin 4.2, Quality Stage 7.51 A, XML, TeraD ata V2R12, IBM Web sphere MQ 6.0 .