SUMMARY

• 7+ years of experience in software development life cycle (SDLC) analysis, design, development, maintenance in IT industry with extensive experience in Data Warehouse applications using Informatica, Oracle, DB2, MS SQL server on Windows, IBM and UNIX platforms.
• Developed tactical and strategic plans to implement technology solutions and effectively manage client expectations.
• Developed effective working relationships with client team to understand support requirements.
• Experienced in using ETL tools like Informatica (Power Center) Designer, Repository Manager, Administration console and Workflow
• Manager.
• Experienced to work in Development team, Production support teams in handling critical situations to meet the deadlines for successful completion of the tasks/projects.
• Developed ETL processes to load data from Flat files, Cobol Files, Oracle, SQL Server, XML Files to Target systems by applying business rules.
• Analyze and design EDI (Electronic Data Interchange) specifications to be used for enhancements for EDI applications, interfaces, and mappings.
• Excellent interpersonal and communication skills, technically competent and result - oriented with problem solving skills and ability to work independently and use sound judgment.
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 9.x/8.x/7.x/6.x ETL tool.
• Expertise in Data Modeling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling using ERWIN 4.x/3.x.
• Experience in documenting High Level Design, Low level Design, STM's, Unit test plan, Unit test cases and Deployment documents.
• Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center 8.x/7.x/6.x.
• Familiar with HIPPA EDI Transactions such as 835, 837(P, D, I) 276, 277, 278 and experienced in creating maps in inbound and outbound EDI interfaces for 810, 850, 855 etc.
• Have solid hands-on experience in UNIX systems administration, hardware and software troubleshooting, and systems installation.
• Verified the Inbound and Outbound 834 generated for CHIP, Medicaid, APTC and QHP flavors scenarios.
• Experience in enrolling with commercial managed care coverage are excluded from enrollment in Medicaid MCOs, while TPL for other enrollees with private health insurance or Medicare coverage.
• Analyzing and troubleshooting allEDI issues to maintain accuracy.
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Experienced in integration and transforming of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat-files, COBOL files, XML, etc.
• Experience in filing and dealing new health policies and procedures.
• Trouble shooting in health care related issues, clearing pending checks, payments and frequent monitoring, updating health care data for data mart applications.
• Review critical errors fromEDIsubmissions, research and correct data in system.
• Experience in Oracle and MS SQL Server environments using Triggers, functions, SQL, T-SQL and PL/SQL.
• Expertise in scheduling Informatica jobs using Informatica, Windows scheduler and with Unix.
• Expertise in creating Unix shell scripts.
• Experienced in working for the post development cycle and applications in Production Support.

PROFESSIONAL EXPERIENCE

ETL Developer

Confidential - Madison, WI

Responsibilities:

• Perform systems analysis and programming tasks to maintain and control the use of computer systems software as a systems programmer.
• Analyze business requirements and work closely with various application teams and business teams to develop ETL procedures across all applications and system.
• Design, develop, configure, integrates, tests and maintains existing and new business applications and/or information systems solutions including databases through integration of technical and business requirements.
• Write ETL design documents, establish ETL coding standards and perform mapping reviews.
• Document flowcharts for the ETL (Extract Transform and Load) flow of data using Microsoft Visio and created metadata documents
• Critique the source data coming from different sources
• Develop complex Mappings, reusable Mapplets and Transformations for different types of tests in research studies on daily.
• Write, update, and maintain computer programs or software packages to handle specific jobs such as tracking inventory, storing or retrieving data, or controlling other equipment.
• Implement mapping level optimization with best route possible without compromising with business requirements.
• Create Sessions, reusable worklets and workflows in Workflow Manager and Schedule workflows and sessions at specified frequency.
• Write, analyze, review, and rewrite programs, using workflow chart and diagram, and applying knowledge of computer capabilities, subject matter, and symbolic logic.
• Create UNIX shell scripts to generate reports.
• Perform backend coding and testing using database SQL and PL/SQL queries.
• Develop and maintain the shell script for data loading and extracting.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Perform Data profiling for data quality purposes.
• Accountability including professional documentation and weekly status report.
• Applications and infrastructure solutions include both 3rd party software and internally developed applications and infrastructure.
• Responsibilities include, but are not limited to, analysis of business requirements, coding of modifications or new program, creation of documentation, testing and maintenance of applications, infrastructure, and information systems including database management systems.
• Conduct trial runs of programs and software applications to be sure they will produce the desired information and that the instructions are correct.

Tools: & Technologies: Oracle 11g, C, C++, SQL, PL/SQL, Autosys, UNIX Shell Scripting, Dimensional Data Modeling, Star Schema Modeling, Snowflake Schema and Dimensions Tables, Physical and Logical Data Modeling, ER Diagrams, Erwin.

Sr. ETL Developer

Confidential - Nashville, TN

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle. Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Implemented full custom programmed EDI Audit and Control add on module to track document flow of all EDI related processes and provide details to users on EDI Dashboard.
• Troubleshoot EDI Files & processes and implement solutions to service our internal and external customers.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Developed ETLProcessesusing Informatica, Parameterizing attributes using Batch Frame work and developing Health Checks.
• Created digital data mart for online banking and mobile banking.
• Worked on web service transformations to get the data from third party applications.
• Provided an assessment of the existing EDI landscape.
• Maintain existing EDI processes by creating and reviewing daily processing reports.
• Experience in filing and dealing new health policies and procedures.
• Extensively worked on EDI 837 and 835 for claims while analyzing and troubleshooting allEDI issues to maintain accuracy.
• Strong experience in using FACETS which includes the Membership, Product Provider, components Billing, Claims Processing, Commissions, Claims Processing, Customer Service, Utilization Management, Electronic Data Interchange (EDI).
• Trouble shooting in health care related issues, clearing pending checks, payments and frequent monitoring, updating health care data for data mart applications.
• Familiar with HIPPA EDI Transactions such as 835, 837(P, D, I) 276, 277, 278 and experienced in creating maps in inbound and outbound EDI interfaces for 810, 850, 855 etc.
• Have solid hands-on experience in UNIX systems administration, hardware and software troubleshooting, and systems installation.
• Verified the Inbound and Outbound 834 generated for CHIP, Medicaid, APTC and QHP flavors scenarios.
• Experience in enrolling with commercial managed care coverage are excluded from enrollment in Medicaid MCOs, while TPL for other enrollees with private health insurance or Medicare coverage.
• Analyzing and troubleshooting allEDI issues to maintain accuracy
• Review critical errors fromEDIsubmissions, research and correct data in system.
• Involved in Performance Tuning of mappings in Informatica.
• Good understanding of source to target data mapping and Business rules associated with the ETL processes.

Environment: Informatica 9.1, Oracle 11g, SQL server 2008 R2, SQL, T-SQL, PL/SQL, Toad 10.6, SQL Loader, EDI, Claims, Tidal Enterprise Scheduler 5.3.1, Accurev, Unix, Flat files.

ETL/Informatica Developer

Confidential, MO

Responsibilities:

• Involved in building theETLarchitecture and Source to Target mapping to loaddataintoData warehouse.
• Extensively used SQL* loader to loaddatafrom flat files to the database tables in Oracle.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Provided EDI and Technical support to internal users, customers, governmental authorities, vendors, out-ports and other external partners on EDI issues.
• Incorporated and implemented all the HIPAA standards, Electronic Data Interchange (EDI), transaction syntax like ANSI X12, ICD-9, ICD-10 coding.
• Converted the XML files into X12 and X12 to XML files on GIS for sending and receiving the EDI files.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Wrote complex SQL Queries involving multiple tables with joins.
• Implemented best practices as per the standards while designing technical documents and developing Informatica ETL process.
• Worked with application teams to install operating system, Hadoop updates, patches, version upgrades as required.
• Created Teradata Database Macros for Application Developers which assist them to conduct performance and space analysis, as well as object dependency analysis on the Teradata database platforms

Environment: Informatica 8.6/9.1, Oracle 10g, SQL server 2005, SQL, T-SQL, PL/SQL, EDI, Claims, Toad, Erwin4.x, Unix, Tortoise SVN, Flat files, Hadoop

ETL/Database Developer

Confidential

Responsibilities:

• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
• Interaction with the Business Partners to understand the business of the application, gather requirements, analyzed and put into technical design documents (HLD & LLD).
• As an active team member, involved in the initial phases of the design and was taken part in the analysis of the product.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Designed B2B integration solutions for customers and suppliers EDI transactions.
• New EDI development and upgrading for existing trading partners.
• Involved in the creation of oracle Tables, Table Partitions, Materialized views and Indexes and PL/SQL stored procedures, functions, triggers and packages.
• Working with various sources such as Flatfiles, Relational, XML and Webservices as part of Informatica Mappings.
• Worked with Mapping and Workflow variables by using the value of mapping variables on the workflow level.
• Used concept of staged mapping to perform asynchronous Web Services request and response as part of Informatica Mappings
• Responsible to tune ETL mappings to optimize load and query Performance
• Wrote UNIX Shell Scripting for Informatica Pre-Session, Post-Session Scripts and to run the workflows.
• Worked on Shell Scripts to convert incoming Excel Flat files from .xls to .csv which helps importing into Informatica.
• On-Call Production support, for every 2 weeks - 24/7 on a scale of every 2 months.
• Using HP Quality Center for the Defects logs and clearing those within the timeline.
• Involved in Performance Tuning of the mappings.
• Worked on MAESTRO schedulers to schedule the Informatica Workflows.
• Worked on ADMINSERVER, which is the product associated with major coding part of the project and help generating some adminserver activities.
• Involved in XML and XSLT coding to create the Front-End screen insert activities.

Environment: Informatica Power Center 9.0/8.6 - (Designer, Repository Manager, Workflow Manager), Oracle 9i, Oracle 10g, SOAP UI, TOAD, SQL Developer, UNIX Shell Scripts, Microsoft Visio 2007, Adminserver, UNIX, Windows 2000/NT.

ETL/Informatica Developer

Confidential

Responsibilities:

• Analyzed the requirements and framed the business logic for the ETL process.
• Worked with heterogeneous sources from various channels like Oracle, SQL Server, flat files, XML and web logs.
• Involved in the creation of oracle Tables, Table Partitions, Materialized views and Indexes and PL/SQL stored procedures, functions, triggers and packages.
• Involved in analyzing and development of the Data Warehouse.
• Worked on Informatica power center tool - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformation Developer.
• Analyzed trading partner specifications and created EDI mapping guidelines
• Created various mappings using Aggregate, Filter, Join, Expression, Lookup, Update Strategy and Router.
• Extensively used ETL to load data from different databases and flat files to Oracle.
• Involved in the development of Informatica mappings and tuned them for better performance.
• Created and scheduled Sessions and Batches through the Informatica Server Manager.
• Worked with sessions and batches using Server Manager to load data into the target database.
• Testing for Data Integrity and Consistency.
• Analyze the source data structure and perform the Logical mappings.
• Monitoring nightly ETL batch flow and resolving the issues and directing it to concerned person.
• Generating the SQL queries for Cognos reporting and validating the reports.
• Loading Data into the staging tables every month from which the reporting and other related queries are used.
• Exposure to the Front-End development using Oracle - APEX. upgraded ETL Processes using Informatica latest version with 9.0.
• Worked on automating the ETL processes using Tivoli Scheduler.

Environment: Informatica Power Center 8.5.1/8.6.0. Oracle, PL/SQL, SOAP UI, APEX, SQL Developer, UNIX Shell Scripts, XML, UNIX, Web logs, SQL server Windows 2000/NT.