OBJECTIVE :

To seek a challenging position as a developer in Data Warehousing using ETL tools.

SUMMARY:

• Over Twenty years of experience in Analysis, Design, Development, Implementation and Maintenance of database and software in Client/Server environment using Object Oriented Techniques with Relational Databases, Data Warehousing and Application Development.
• Experience includes Fourteen years of Data Warehousing and Business Intelligence applications using IBM InfoSphere Information Server 11.7/11.5/11.3/9.1/8. x/7.x/6 Server/Parallel environments.
• Proficient in data warehousing techniques for Data Cleansing, Slowly Changing Dimension phenomenon, Surrogate key Generation.
• Worked extensively on different types of Datastage stages like ODBC, Dataset File, Database, Aggregator, Transformer, Change capture stage, Merge, Join, Lookup, Sort, Pivot, Funnel, Shared Containers for developing jobs.
• Used Information Analyzer for data profiling, Quality stage for Data Quality Standardizations and DataStage Director extensively to run, schedule, monitor, debug and test the application on development, and to obtain the performance statistics.
• Has Four years of experience in Oracle Applications (Financials and Manufacturing) v 10.7 SC/11i customization of OE, INV, AR, PO and GL modules. Created and monitored many Packages and Stored procedures through Oracle Enterprise Manger. GUI Forms and Reports were generated using Oracle Development tools Oracle*Forms4.5/6i and Oracle*Reports 2.5/6i
• Good experience in working with data modeler to create/design the data model and Identify/analyze the Source data.
• Experience in creating Mapping documents with business transformations from source to Confidential by coordinating with Business analysts and getting signoff on various Documents from Business team.
• Proficient in Re - Engineering and developing existing ETL jobs/mappings.
• Used Agile Methodology in various projects. Implemented Agile with scrum and Sprints using JIRA, Rally, and clarity software. Conducted weekly staff meetings and daily stand-ups to monitor the progress of the projects. Participated in sprint backlog grooming and refinement meetings.
• Expertise in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Good working knowledge of various Databases like Oracle 12C/10g/9i/8i/7.x, SQL Server, DB2 and Netezza.
• Created jobs and scheduled these jobs through different scheduling tools.
• Good knowledge of Change control process using Service Now.
• Ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem solving skills.

TECHNICAL SKILLS:

ETL Tools: IBM Infosphere Datastage 7.x/8.x/ 9.1/11.3/11.7 , Informatica, OBIEE 10g, Oracle Data

Integrator, HADOOP 1.0.3:

Data Modeling: ERwin 4.0/4.1

Languages: SQL, PL/SQL, C, FORTRAN, COBOL, Basic, HTML, Shell Scripts, JAVA

Databases: Oracle 12C/10g/9i/8i/7.x, Oracle Applications server v10.7/11i, DB2, Netezza, Sybase

Operating Systems: Windows95/97/NT/98/2000/7/XP/10, UNIX, MS-DOS, Sun Solaris 2.5, Linux

GUI Tools: Power Builder 4.0, Developer-2000, Oracle *Forms 4.5/6i, Oracle *Reports 2.5/6iSQL Loader, Toad 9, SQL Developer, DBVisualizer, Eclipse

Software: ServiceNow, Rally, Clarity, JIRA, SouceTree/Bitbucket, Vantive, AutoCAD, Visio

EXPERIENCE:

Confidential, Milwaukee, WI

ETL/Data Warehouse Consultant

Responsibilities:

• Design, develop and support the Data Warehousing applications for BlueKC Migrations Project using IBM Infosphere Datastage 11.5.
• Created files for Service Provider, Patient Claims and Eligibility containing general case and clinical case management information, to be switched from Facets (Sybase) to Guiding care database in DB2.
• The files generated will be sent to Altruista Health Care Management System shortly before each go-live date during the implementation process for Historical and incremental data.

Environment: IBM Infosphere Datastage 11.5, Sybase, DB2, AQT (Advance Query Tool v 10.1.0), Zena Scheduler, SQL Server 14.0, Jira (Agile), Windows 10.

Confidential, Minneapolis, MN

Senior Data Integration Engineer

Responsibilities:

• Designed and developed the Integration applications for Data Warehouse and reporting solutions to enhance BI capability needs across various departments.
• Developed and deployed the Jobs into various environments using Service Now and Source Tree capabilities.
• This includes data analysis, mappings, data integration, data profiling and reporting for projects by providing documentation to the monitoring team, as well as providing level 3 production support duties.
• As part of the production support team monitored Jobs and Sequences through web based IBM InfoSphere Information server Operations Console.
• In this role, was also responsible for defining standards and models for Data integration by applying best practices for source control, testing and deployment of jobs using IBM Infosphere Datastage 11.3. Identified inefficiencies in current data integration and leverage solutions; not limited to optimization for PL/SQL, or current ETL jobs.
• Scheduled and monitored Jobs through SQL Server 14.0.1000.169 Scheduling Agent.

Environment: IBM Infosphere Datastage 11.3/11.7, Oracle 12c, Jira (Agile), SQL Developer, ServiceNow, SourceTree, SQL Server 14.0.1000.169 , Windows 10.

Confidential, Lyndhurst, NJ

Senior Data Governance/ETL Developer

Responsibilities:

• Data Profiling was done on Patient Laboratory Information using Information Analyzer 9.1/11.5 in conjunction with Quality Stage for validation, measurement and baseline reporting of data quality through shared analytical metadata.
• Helped the stake holders to identify inconsistencies, redundancies, and anomalies in data at the column, table, and cross-domain level for Patient Registrations and Transactions.
• Familiar in working with PHI data.
• Developed Datastage jobs to calculate the metrics for various Measures for Patient laboratory testing results and address information in Infosphere Information server 9.1/11.5 using Datastage. Automated the flow of job execution order by using Sequencers and scheduler.
• Implemented Agile Methodology during the project development.
• Implemented Agile with scrum and Sprints using Rally and Clarity software.
• Conducted weekly staff meetings and daily stand-ups to monitor the progress of the different tasks.

Environment: IBM Infosphere Information Server 9.1/11.5, Oracle 12c, Clarity, Rally (Agile), SQL Developer, Linux, Windows 7/10.

Confidential, Spring Field, MO

Data Architect/ETL Developer

Responsibilities:

• The Customer and Address Standardization is performed in order to replace all Confidential, iseries and other software with InfoSphere suite components.
• This process assisted in providing more transparent customer scrubbing process and allow business to pull mail files directly from Netezza and need no further attention to cleanse addresses. Data was compared to CASS, SERP, NCOA and Satori software.
• Also migrated some jobs that were developed in Cognos Data manger to InfoSphere Information server 11.3 using Datastage and Quality Stage.
• Developed Map Reduce programs using HADOOP 1.0.3 Framework in 150 Node architecture for the web based customer information.
• Used Scoop, Pig and Hive to translate data from database tables to HADOOP Cluster Framework.
• Implemented Agile Methodology during the project development using JIRA software.

Environment: IBM Infosphere Information Server 9.1/11.3, Netezza, DB2, Aginity Workbench, Cognos Data Manager, HADOOP 1.0.3, Eclipse, JIRA (Agile), JAVA, Windows 7.

Confidential, Raleigh, NC

ETL/ Data Stage Consultant

Responsibilities:

• Created new jobs to load data from various sources into common Data Repository using Datastage 8.5 and later migrated to Datastage 9.1. Used Netezza Stage extensively to write data to database Tables along with other processing stages, like Sequential File, Merge, Join, Sort, Remove duplicate, Transformer, Lookup, Funnel, Filter, Aggregator, Copy and Custom-Op stage.
• Created Objects in Netezza database.
• Automated the data flow processes using Sequencers so as to manipulate the source files using various Datastage Jobs and write data to different custom phases of Temp, Transaction, Raw, Base and Norm.

Environment: IBM Infosphere Datastage 8.5/9.1, Netezza, DB2, Unix- AIX 6.1 DBVisualizer, Windows 7.

Confidential, Mettawa, Illinois

Data warehouse / Data Stage Consultant

Responsibilities:

• Modifications were made to the existing Jobs to include new sources and new jobs were developed with changes to key assumptions and Constraints.
• Used various file, processing, database and debugging stages.

Environment: IBM Infosphere Datastage 8.5, DB2, Unix- AIX 6.1 TL9, Windows 7.

Confidential, Minneapolis, MN

ETL/Data Stage Consultant

Responsibilities:

• Developed and supported the Extraction, Transformation and Load process (ETL) for the data warehouse from various data sources using DataStage Designer.
• Designed and developed Job Sequencers for the ETL jobs.
• Prepared Specification Documents for DataStage Jobs.
• Performed Unit testing and integration testing to compare data with production data.
• Used Quality Stage for data quality analysis and operations. Dataset rule sets were implemented for standardizations. In the re-engineering lifecycle, various processes were developed like conditioning/standardizing, matching and survivorship of data.
• Worked with data modeler in creating and designing the data model, Identify and analyze the Source data.
• Created mapping document with business transformations from source to Confidential by coordinating with Business analysts and getting signoff for Design Document from Business team.
• Multiple projects were built and maintained within the existing Data Warehouse, each project effectively integrates data from multiple sources into a fully customized Data marts. The main scope of these project is to create and distribute canned and ad-hoc reports to provide information for Sales, Commercial Finance, Marketing Position Analyses, Health Systems Group and monitor the business performance against its competitors.

Environment: IBM Infosphere Information Server 8.1, DB2, Unix- AIX 6.1 TL9, Oracle 10g, SQL Developer, Linux, Windows 7.

Confidential, Lake Forest, IL

DataStage Consultant

Responsibilities:

• A real time DW project, EDW houses all the sales, financial data and metrics for Grainger and is used to store and analyze costs, revenue and customer centric information.
• The EDW team provides hundreds of statistical and business analysts, marketing managers, and customers with next-day access to complete information on customers, retail sales, inventory, shipments and forecast. This DW project has significant involvement in data extraction and migration from/to variety of RDBMS.
• Currently, all the existing server jobs, software have been changed to DataStage Parallel Jobs.
• Used the DataStage Director to run, schedule, monitor, and test the application on development, and to obtain the performance statistics. Configured Oracle, SQL Server in DataStage for accessing and reading from database.
• Worked with Data Stage Administrator to create/modify/delete projects.
• Worked closely with Project lead/Manager, Architects, and Data Modelers to understand the business process and functional requirements..

Environment: Ascential DataStage 6, IBM InfoSphere DataStage 7.0.1/8.1, Oracle 9i, SQL, Windows 2000/XP, UNIX, TOAD 9, Erwin.