SUMMARY

• Around 8+ years of experience in ETL mechanisms using Ascential DataStage 4.x/5.x/6.x/7.x/PX/EE and IBM Infosphere DataStage V9.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 the 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 Healthcare 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 DataStage developer

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 the 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/manag e 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 DBAs 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

ETL Datastage Developer

Responsibilities:

• Involved in conversion of Informatica 7.1.3 code on AIX server to Datastage 11.0 on Linux server.
• Involved in the 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 gave recommendations to resolve issues.
• 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, MI

Data Analyst/Developer

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 the onshore-offshore model as a lead for 12 Testers.
• Assigned the ETL tasks to offshore team and monitor, verify the code designed by the 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 the personal schema and replicated/generated data for the 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.