PROFESSIONAL SUMMARY

Over * years of experience in Software Development (Analysis, design & development) of enterprise, level data warehouses using Data Integration tools like DataStage and Informatica.

Over 5 plus years experience in Health Care domain- EPIC, Cancer Registries and IHIS.Experienced in Front end Use of Electronic Medical Records (IHIS) and extraction of EPIC data from chronicles to Clarity tables to Desired Target database.

Certified in EPIC 2015 Radiant/Cupid/IHIS Ambulatory Modules, Crystal Reporting in IHIS and Clarity Database. UHC Core Measures Certified.

Served as IBM DataStage Administrator and Cisco Tidal Job Scheduler Administrator.

Independent handling of project ideas from scratch to fruition including documentation and Support.

Mentored and coached New Team Members on best and secure practices of ETL tool use.

Experience with SQL/PLSQL, UNIX and Data Warehouse best practices, especially in Extract, Load Transform ELT methodologies.

Possess strong debugging skills to identify the issues, good knowledge of performance tuning.

Experience in Data Extraction, Transformation, and Loading from multiple relational databases like Oracle, DB2, SQL Server, Teradata and created reports using OBIEE, Crystal and Sql Server.

Experience in writing complex SQL queries and stored procedures and worked with data modeler in designing Logical & Physical Data model in accordance with the Business Rules.

Worked with Automated Monthly and Nightly loads with Delta data.

Provided excellent documentation of ETL support.

Hands on experience with complex mappings from varied transformation logics using Normalizer, Stored Procedure, Router, Aggregator, Joiner, Update Strategy, and Re-usable transformations.

Expertise in implementing complex Business rules, creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.

Experience in performing unit testing, integrated system testing, and debugging of mappings, mapplets and sessions.

Motivated and focused team player with strong problem solving, Detail –oriented, analytical and a quick learner of new technologies. Excellent diagnostic and problem solving skills.

Organized and effective in delivering high-quality solutions using Oracle

TECHNICAL SKILLS

ETL Tools :DataStage11.5/9.1/8.5.x/7.5.x, Informatica Power Center 8.x/7.x, Workflow Manager, Cisco Tidal Enterprise Job Scheduler

Databases :Sql server 2005/2008/2012, Oracle 11g/10g/9i, DB2, MySQL,Netezza

Data Modelling Tool : ER studio 9.7

DB Utilities :SQL*PLUS,TOAD,SQL*Loader,MLoad, TPump, FastExport

Reporting Tools: Crystal Reports,OBIEE,Business Objects

Scripting :PowerShell, Korn Shell Scripting (KSH)

Languages :C, C++,XML, shell script, PL/SQL

Other Tools : MS Office, MS Visio, MS OneNote, Clarity(Project Management tool), Service Now.

EXPERIENCE

Sr. ETL Datawarehousing Consultant 06/2012 - 01/2018

The Ohio State University Wexner Med Center; Columbus OH

Senior member of the Information Warehouse (IW) ETL team. Provided data integration, management, mining, training, and development services to a diversity of customers across the clinical, education, and research sectors .

Officially trained in DataStage 9.1 Server Administration; Agile Methodology; Tidal Enterprise Job Scheduler Administrator; Caboodle DW.

Performed end-end Impact analysis for column/data type changes before epic version upgrades using ER studio tool and provided business glossaries for universal use by clinicians, Analysts, ETL and data users.

Engineered and Automated Full file feeds and daily delta /monthly/quarterly files to OSU Health Plan,Vizient(UHC), and VQI external Vendors through ftp and sftp.Users are notified about the data feeds acceptance rate through email from Job Scheduler Tool.

Adhoc data requests to facilitate clinical and Epic Users decision-making and process Improvements in Hospital setting. Documentation in SharePoint and Service Now.

Technical Lead for Radiant Datamart, for sourcing legacy data from Image cast and Epic clarity Database. Participated in requirement definitions, time estimates, code reviews.

Created Ambulatory/Access Dashboard for physician scheduling and lag days. Trained clinical users on using the dashboard.

As DataStage Administrator: upgraded DS server to 11.5, did code reviews, coordinated with IBM care and controlled code promotions.

As Tidal Administrator: Integrated coordinated run of windows jobs, sql server, Oracle DB, Datastage 11.5/8.7,Unix Scripts through Tidal Job scheduler. We were able to reduce Manual intervention of ELT jobs. Minimized total ETL daily batch run time from 16 to 7 hours making on-call support a breeze.

Mentored and Trained team and was the first support contact for on-call issues.

Modeled and Developed DataStage jobs for Optime,Resolutestar, Cadencestar modules. Improved performance tuning on project level and job level.

Extracted from EPIC and Non-Clarity sources and loaded to IW oracle Tables.

Performed Error Handling and data validation checks while data transforming the data from IHIS to Clarity (source) to IW (target).

Analyzing the business requirements and developing Data Model for OPTIME tables using ER studio.

Documented design documents. Prepared Reconciliation jobs to validate the statistics to ensure all ETL Processes are performing the expected results according to the Mappings design.

Provided technical expertise during requirements analysis, technical designs, support manuals and deployment processes

Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.

Demonstrated strong understanding of intersystem dependencies around primary, cross platform applications.

Environment: IBM Data stage 11.5/9.1/8.7/8.1,IHIS Epic, Clarity (SQL server 2008/2012), Oracle 11g, ER Studio, PL/SQL, UNIX /AIX, Cisco Workload Automation (Tidal Enterprise Job scheduler), OBIEE Answers Tool, Service now

Sr. ETL Developer 09/ 2011 - 06 / 2012

The Ohio Department of Taxation; Columbus OH

The ODT STARS project was a type 6 hybrid design model for all the dimension tables.

Used Parallel Extender Development/Debugging stages .Worked extensively with DataStage Designer, Director, and Administrator.

Used DataStage to load data, utilizing the available processors to achieve job performance, configuration management of system resources in Orchestrate environment.

Extensively used Lookup, Join, Merge stages for joining various information and used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Pivot, Row Generator to load to database using Oracle Enterprise connector.

Experience in Unix shell scripting and scheduled various ETL Batch processes using Tivoli.

Responsible for Performance Tuning of jobs to reduce system overhead.

Documented design and technical architecture documents for reject reload concept.

Prepared Unit Test cases and validation jobs to ensure correct data statistics is achieved per the business requirement.

Environment: IBM Data stage 8.5.0, Oracle 11g, PL/SQL, UNIX /AIX, Tivoli Job scheduler, and Quality Center.

Informatica Developer 10/2009 – 08/2011

Aventis Pharmaceuticals Inc; Bridgewater NJ

Designed the ETL Process using the Informatica Power Center to populate the Dimensions and Fact Tables.

Analyzed and extracted and loaded data into the SQL Server Database, from the AS/400 Systems.

Optimized the mappings to reduce the data load time.

Implemented various transformations (Source qualifier, Normalizer, Aggregators, Connected lookups, Filters, Sequence generator), per the business requirement.

Implemented SCD methodology to keep track of historical data.

Wrote PL/SQL stored procedures using Toad. Created partitions to load the data into targets concurrently.

Developed Unit Test/UAT Scripts for testing the application.

Performed QA of the Application and coordinated the UAT by the Users.

Coordinated with the offshore team for development of the Informatica Mappings.

Validated the Informatica mappings and performed System testing.Created Production Maintenance Documents.

Environment: Informatica Power Center 7.1.2, SQL Server 2000/7.0, DB2 8.0, PL/SQL, SQL*Plus, SQL*Loader, AIX 4.3.3, Shell Scripting

Informatica Developer 01/2008 – 10/2009

Nationwide Insurance;Columbus, OH

Migrated 200+ Informatica jobs to DataStage. The outsourced ETL based on Informatica 8.6.1 while in-house platform was DataStage 7.5 (Server).

Created Logical and Physical models for Staging, Transition and Production Insurance Data Warehouses using Erwin 4.5.

Used Repository manager to create user groups and users, and managed users by setting up their privileges and profile

Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval.

Excellent Development experience with OBIEE Reports development with cross subject areas/functional areas analysis.

Environment: DataStage 8.0/7.5,Informatica Work Flow Manager/Monitor, OBIEE 10.0, Erwin 4.5, Oracle 10g/9i, SQL, PL/SQL, Toad, SQL * Loader, UNIX Shell Scripting

EDUCATION/TRAINING

Bachelor of Technology in Engineering, JNT University, INDIA 2005

Professional Courses:

Agile Methodology,2014

Conflict Resolution,2013

UHC/Vizient Certified Data Analyst 2015

EPIC certified in Clarity Data Modules 2016-17

Datastage 9.1/11.5 Server Administration 2016

Contact this candidate