We provide IT Staff Augmentation Services!

Etl Team Lead Resume

St Louis, Mo

PROFESSIONAL SUMMARY

  • Over 10+ years of experience in Various Databases and file systems which includes VSAM, IMS DB, DATACOM, Oracle 10G, DB2 UDB 8.0 databases. Strong applied knowledge on SQL, PL/SQL technologies.
  • Over 6+ years of experience in Datawarehousing, Data Integration and Application Information Life science Management Projects involving Informatica, IBM OPTIM, IBM info Sphere DATASTAGE.
  • Strong experience in Extraction/Transformation/Loading (ETL) design and implementation includes Requirements gathering and business rules analysis, Source to target mapping design, and also implemented various Performance Tuning techniques.
  • Extensive experience in supporting and maintaining Mainframe Applications on IBM mainframe environment.
  • Knowledge on HADOOP big data technologies including HDFS, HBASE, HIVE. Applied knowledge on Informatica ILM assistant.
  • Over 8+ of experience in American HealthCare Industry and involvement in various Industry level initiatives and assessments. Certified FAHM from AHIP organization. Completed following certifications to achieve fellowship. AHM250 – Basic Concepts in healthcare, AHM510-Governance and regulation, AHM520-Risk Management, AHM530-Network management, AHM540-Medical Management in Health Plans.
  • Over 2+ years of experience working in various J2EE middleware/backend technologies – Hibernate/Java/Servlets/JSP/Spring MVC supporting client portals and extended connectivity using web services.
  • Ability to build and maintain strong working relationship with all levels of management along with Cross- Functional team of Engineers, Financial Specialists, and Sales Support.
  • Strong leadership skills coupled with excellent verbal, written, interpersonal and people management skills.
  • Strong analytical and problem solving skills. Deadline and team oriented, comfortable working in a fast paced environment.

TECHNICAL SKILLS:

Databases, DBMS/RDBMS : Oracle 10g/11g, DB2 UDB 8.0, VSAM,
MySQL, CA-DATACOM, IMS-DB. SQL,
PL/SQL
ETL/ILM : IBM OPTIM (Data Growth Solution)/
Oracle HSODBC/DB2 Express C/ IBM
OPTIM Connect (Attunity). Informatica
Power Center 8.6/9.1, IBM Info-sphere
Data Stage 8.5, Erwin 9.2
J2EE Technologies : JSP/Servlets, Hibernate, Spring, JAVA
5/6
Programming Languages : SQL, Oracle PL/SQL, COBOL, CICS, CA-
IDEAL, JCL, MQ Series, Assembler, CLIST.
Servers : CICS Transaction Server 4. Apache Tomcat
6.
Web services : MQ server, WSDL/ SOAP, REST
Tools : IDE: Eclipse, CM: Endeavor, Scheduler:
Control-M, CA-7, Abend Analysis –
ABENDAID, Dumpmaster. File analysis:
Insync, FileMaster.
Project Management : Rational Portfolio Management. CA Clarity,
Microsoft Project Plan. OPAL for CMMI
Requirements Management : Rational composer, Rational Unified Process.
MicrosoftVISIO
BA /Requirements Mgmt : FP, COCOMO, Rational Method Composer.
Rational Unified Process, Business Modeling,
Data analysis. Microsoft Visio, Microsoft
Office- Word, Excel, powerpoint.
PROFESSIONAL EXPERIENCE:
Confidential , St Louis, MO
Role: ETL Team Lead

Description: Confidential are one of the leading Pharmacy benefit management. Daily feeds from Legacy systems to data Warehouse and Data marts are established to support the enterprise decision support systems.

Responsibilities:
  • Involved in gathering business requirements in liaison with business users and technical teams. Created requirement specification documents and identified data sources and targets.
  • Involved in Data discovery and Data analysis using Informatica developer to identify the relevant data.
  • Responsible for Managing, monitoring and validating the data extraction, transformation, movement, loading, cleansing and updating processes into the DW environment.
  • Responsible for testing and implementing innovative technical design solutions based upon the observed pain points within and outside Informatica domain boundaries.
  • Responsible for data modeling utilizing Conceptual, logical and Physical Database Designs and Implementation for the Staging and the Data Mart databases using Erwin 9.2 forward/reverse engineering with Oracle 10g.
  • Designed mappings, Mapplets and transformations using Informatica Power center Designer. Utilized Java transformation, Normalizer Transformation, SQL transformation, XML transformation and other available transformations to ensure data cleansing and data quality with performance enhancement.
  • Involved in Informatica 9.5 Server-side software Installation, Client-side software Installation, Metadata reporter Installation and applying the SP1 & SP2 patches to the environment by supporting Informatica Admin.
  • Responsible for performance tuning of the Informatica mappings using various components and techniques likes Parameter files, Variables and Dynamic Cache and other set procedures.
  • Involved in testing the development environment and data validation using SQL queries/ERwin and SQL scripts.
  • Lead the warehouse design and integration effort, including data sourcing and transformation.
  • Handled a team of 6 members and Developed, mentored and trained Other ETL staff providing day to day guidance and pointers for issue resolution.
  • Define development and coding standards and procedures in Informatica and implement technology improvements.
  • Defined standards and procedures to ensure that the client's business goals and objectives are met by the proposed data warehouse architecture and design.
  • Assisted the team in Design, Development and performing peer reviews as per the checklist.
  • Created users, folders & defined roles using Informatica Repository Manager
  • Involved in data analysis using Data Analyzer and Data Profiling and Poses knowledge on IDQ (Informatica Data Quality).
  • Tuned the reporting tables by creating table partitioning, materialized views, logs and adding function – based indexes, bit-mapped indexes, usage of hints and making use of Oracle 11g features
  • Designed and developed efficient Error handling methods and implemented throughout the mappings.
  • Strategically thinking and consulting organization on ETL best practices based on detailed knowledge of industry trends.
  • Designed and developed Tasks (Sessions, Commands), Workflows using Workflow Manager Tools that involved email generation, Command interface and flagging option based on file availability.
  • Responsible for implementing performance tuning for Repository Server and Repository Agent.
  • Wrote Power Shell Scripts for pre/post session commands and command tasks.
Environment: Informatica Power center 9.5, Power Center Data Analyzer, Erwin 4.x,
Oracle 11g, PL/SQLScripts,DB2 UDB 8.0.Oracle TOAD 9.7,Cognos 7 Framework
Manager, Impromptu 7.x/6.0, , Power Shell1.0, Cognos 8 Report Net. Mainframe
Technologies – JCL/COBOL/MVS/CA-7/9/CICS TS 4.0 etc,SQL Developer.
Confidential, Salt Lake City, UT
Role: Team Lead/ TTL
Description: Confidential is one of the leading Payor side healthcare services in Midwest Region providing a range of health Care benefit products. Operating from four different states Utah, Oregon, Washington and Idaho, the archival process is established for each system to support their mainframe decommission after Open system migration.
Responsibilities:
  • As Senior Application Developer/ TTL for Analysis, design, development, testing and implementation of Mainframe/J2EE batch Applications for Regence Blue Cross Blue Shield of UTAH.
  • Analyze entire mainframe data components, inter and intra application interfaces, data structures , composition, supported business, critical process and perform data profiling to derive data models for archival/migration - conceptual model utilizing MS VISIO ER diagrams/ Logical and physical model utilizing Attunity.
  • Develop and maintain sophisticated product architecture for application data archival/retrieval. IBM data archival product constitutes IBM OPTIM + Oracle HS (heterogeneous Service) ODBC (open database connectivity) + IBM Optim Connect server + mainframe Daemons and extended mainframe data sources.
  • Map Cobol copybook data structures with the Attunity server data types and extract and transform data to third form Normalized RDBMS schemas from legacy unorganized/less organized file structures (IMS DB/DATACOM/VSAM/FLAT Files).
  • Transform VSAM files/IMs file to relational tables utilizing OPTIM Connect and perform normalizations on the files
  • Create Archival requests combining various data source models and schedule jobs for regular archival and maintain job request flows with performance tuning utilizing OPTIM Tool.
  • Support end user connectivity with OPTIM ODBC connection assistant and provide end user query management facility to Oracle TOAD application.
  • Plan for validation techniques/ generate use cases and execute use cases using Optim Query facility to obtain Business Sign –off.
  • Coordinate with various Clients cross functional teams on a daily basis as part of Project governance, information and communication management. Cross functional teams include Scheduling, Contract management, Project Sponsors, Mainframe system management functioning during US day time and requires through system and technical knowledge for effective communication and information flow.
  • Assist Client analyst to derive project cost benefit analysis and decision making.
  • Handled a Team of 7 members working towards three different system plan to undergo decommission and assisted them for technical and project issues.
Environment: IBM OPTIM, OPTIM Connect, Oracle HS-ODBC, IBM Mainframes, DB2, CA-Datacom, VSAM, IBM DB2, Flat Files, Oracle 10g, Oracle Toad 8.6.
Confidential, LA, CA
Role: Senior ETL Developer
Description: Confidential is a leading Payor side healthcare company selling various healthcare products. Supporting their EDW following were the responsibilities.
Responsibilities:
  • Involved in gathering business requirements in liaison with business users and technical teams. Created requirement specification documents and identified data sources and targets.
  • Used relational sources and flat files to populate the data mart. Translated the business processes into Informatica mappings for building the data mart.
  • Coordinated with the offshore team for reviewing the ETL code and provided development support.
  • Worked with various Informatica Server and Client tools like Designer, Workflow Manager, Workflow Monitor and Repository manager.
  • Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner and Sequence generator.
  • Used Normalizer transformation for importing and working with COBOL files.
  • Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
  • Used Update Strategy Transformation and configured the mappings to handle the updates, to preserve the existing records.
  • Created tasks, sessions, worklets and workflows in the Workflow Manager and gathering status updates using Workflow Monitor.
  • Involved in dealing with performance issues at various levels such as target, sessions, mappings and sources.
  • Involved in fixing invalid Mappings and performed Unit testing and Integration Testing.
  • Involved in customizing the Physical Layer, Business Model & Mapping Layer and Presentation Layer in Analytics Repository (RPD) using OBIEE Administration Tool.
  • Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts in OBIEE Answers to design the dashboards.
  • Created PL/SQL stored procedures to perform data validation on the business data.
  • Developed UNIX shell scripts to automate the data warehouse loading.

Environment: Informatica Power Center 8.1/8.5, OBIEE 10.1.3.3, Oracle 9i/10g, PL/SQL, TOAD 8.6,Embarcadero Data modeler, SQL *plus, UNIX, Windows XP, Mainframes, JAVA 6.
Confidential, Salt Lake City, UT
Role: Application DW/ETL Developer
Description: Confidential is one of the leading Payor side healthcare services in Midwest Region providing a range of health Care benefit products. Operating from four different states Utah, Oregon, Washington and Idaho, they have centralized EDW to accommodate reporting and DSS systems.
Responsibilities:
  • Support monthly Mainframe jobs sending feeds to the data warehouse, monitoring and resolving any Job run failures.
  • Enhance Mainframe applications source for any change data cleansing requests. s
  • Change transformations in infosphere Data Stage for all the enhancement requests.
  • Perform Cleaning and cleansing data in Data Stage based on the Mainframe job runs for requested enhancements.
  • Run queries in Oracle TOAD to validate various system reports and the load statistics.
  • Prepare documentation for ETL standards, procedures and naming conventions- Involved in performance tuning.
Environment/Tools: IBM Infosphere Data stage 8.5, Oracle TOAD, DB2V8, Oracle 10g, UNIX shell scripts, Oracle PL/SQL. SQL developer.

Confidential, India
Role: Application DW/ETL Developer

Description: Confidential is one of the leading Payor side healthcare services in Midwest Region providing a range of health Care benefit products. Cambia Operates from four different states Utah, Oregon, Washington and Idaho. Their mainframe applications and Web portals residing on different Lpars and servers were being supported for enhancements, Projects and problem tickets.
Responsibilities:
  • Responsible for, work item status reporting monitoring and providing timely updates to the customer. Generate Status reports.
  • Perform Requirement analysis and document Requirement Specifications.
  • Follow water fall SDLC model and Design Develop and Unit/System test mainframe applications using COBOL/JCL/CICS/DB2/Datacom and various other tools.
  • Assist Team for technical issues and guide team members throughout Build.
  • Follow Release management principles and plan for implementation using Action Remedy System
  • Analyze Mainframe to web connect applications and provide support in problem identification and problem resolution using available tools –Trace master/eclipse IDE/Oracle 10g SQL*plus.
  • Design and develop Java Middleware Application enhancements supporting DB2 UDB 8.0 database access services using Spring Framework/Hibernate/Oracle 10g.
  • Unit test enhanced java applications in test environment, document results and obtain sign-off for implementation – Java (Servlets-JSP)/ JQuery /Apache tomcat 6/ Spring MVC/Hibernate/ Spring/Oracle 10g
Environment: COBOL II, TSO/ISPF, CA-DATACOM, JCL, CICS, Super BMS, Ezytrieve, Macro4 Tools, Top down, Endeavor, CA-IDEAL, IMS-DB. J2EE technologies- Hibernate, Apache Tomcat, JSP/Servlets, spring, Oracle 10g, DB2.8.0/ HTML, JQuery.

Hire Now