SUMMARY

• Over 8+ 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. SQLPL/SQL

ETL/ILM/DM tools: 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.

Programming Languages: SQL, Oracle PL/SQL, COBOL, CICS, CA-IDEAL, JCL, MQ Series, AssemblerCLIST

OLAP/Reporting: Cognos 7 Framework Manager, Cognos Report.net, OBIEE 10.1.3.3.

J2EE Technologies: JSP/Servlets, Hibernate, Spring, JAVA 5/6

Servers: CICS Transaction Server 4. Apache Tomcat 6.

Web services: MQ server, WSDL/ SOAP, REST

Development Tools: SQL PLUS,SQL Developer, Oracle TOAD 8.6. CM EndeavorABENDAID, Dumpmaster. File analysis Insync, FileMaster.

Scheduler: AUTOSYS, Control-M, CA-7.

Project Management: Rational Portfolio Management. CA Clarity, Microsoft Project Plan. OPAL for CMMI

Requirements Management: Rational composer, Rational Unified Process. Microsoft VISIO

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

ETL Developer/Analyst

Responsibilities:

• Involved in gathering business requirements in liaison with business users and technical teams. Created requirement specification documents and identified data sources and targets.
• Performed legacy mainframe data analysis and identified optimized solutions to perform data cleansing including normalizing the legacy data structures.
• 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.
• Worked in Agile Scrum development methodology and RUP methodology.

Environment: Informatica Power center 9.5, Power Center Data Analyzer, Erwin 4.x, Oracle 11g, PL/SQL scriptsDB2 UDB 8.0.Oracle TOAD 9.7,Cognos 7 Framework Manager, Impromptu 7.x/6.0,, Power Shell 1.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

Senior Application Developer/ TTL

Responsibilities:

• As Senior Application Developer/ TTL for Analysis, design, development, testing and implementation of Mainframe/J2EE batch Applications for Regence Confidential 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

Senior ETL Developer

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

Application DW/ETL Developer

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, Salt Lake City, UT

Application DW/ETL Developer

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.