SUMMARY:

• Excellent knowledge and experience in Extraction, Transformation, and Loading (ETL) using Designer, Workflow Manager, and Repository Manager with various versions of Informatica PowerCenter
• Strong problem solving skills; complex PL/SQL packages, functions, stored procedures, cursors, triggers, views, and materialized views
• Technically proficient in identifying and resolving performance bottlenecks in various levels such as target, mapping, and session
• Documented design details of ETL mappings and businesses rules/transformations and also conducted design reviews with peers
• Experience in Worklets and Mapplets for solution to complex design.
• Strong in data warehousing concepts such as Star schema and Snowflakes schema
• Worked extensively on performance tuning and query optimization
• Utilized Debugger to troubleshoot some critical mappings to check the data flow from instance to instance for root cause analysis and troubleshooting.
• Developed standard and re - usable mappings and mapplets using various transformations such as Expression, Aggregator, Joiner, Source Qualifier, Lookup, Update Strategy, Router, and filter, etc.
• Highly Proficient in maintaining ETL accuracy in terms of ETL standards and coding efficacy
• Strong knowledge of dimensional modeling, data migration, data cleansing, and ETL processes for data warehouse
• Well versed in all phases of Software Development Life Cycle (SDLC) as a Data Warehouse Developer
• Proven ability to efficiently manage time and resources and prioritize tasks in order to work on multiple projects simultaneously in a given timeline
• Proven ability to work in dynamic environment
• Excellent communication and interpersonal skills

TECHNICAL SKILLS:

Data Warehousing: Informatica PowerCenter 9.1.0/8.6/8.5/8.1.1 (Designer, Workflow Manager, and Repository Manager), Power Exchange 8.1.1,9.1.0, TOAD 9.7/8.6/7.5, ERStudio 7.2, Oracle 11i/10g, Teradata, First Logic. IDQ

Data Modeling: RDBMS, Star and Snowflake schema modeling, Fact and Dimensions

Languages: SQL, PL/SQL, UNIX, Linux, Hands on exp with Microsoft SQL server Management Studio 2005, 2008

EXPERIENCE:

Confidential, West Trenton, NJ

ETL Developer

• Currently involved in setting up 9.1.0 environment on server and client level and do the testing in D, Q, U env. for power center, IDQ and Power exchange.
• For this Informatica upgrade I am responsible for maintaining Informatica services, bat scripts, env files and do workflow based migration with repository and sandbox backup, parameter other required files migration, change environment variables etc.
• I am currently involved in fixing 9.1 upgrade problems such as power exchange low value issue, DTLUMO mainframe utility, XML (supressNill) setting at server by using SR tickets opened with Informatica support Team.
• Responsibilities include functional analysis, design, development, impact analysis, resolution of defect tickets raised by testing team
• Analyze the functional specs provided by the data architect and create ETL technical specification documents for all the mappings.
• Create datamaps separately for historical and daily mainframe files such as vsam, KSDS, sequential and tape by using DSN and copybook provided by legacy developers and then extract and transform the data using Informatica after importing it using Powerexchange.
• Implement DSN and copybook changes and its filter criteria by Informatica and power exchange with correct Indicator files for NJM claims recon process.
• Create new ETL standards such when to use bulk insert stored procedures, parmeterizing the ETL process, truncate table procedure etc.
• Increased the Performance of a mapping by eliminating the lookups on large tables & coded the complex logic with expression transformation and SQL transformation’s override ability.
• Current Task is to Integrate IDQ with Power center and tweak the code to match the result First logic one.

Environment: Informatica 8.1.1 (Versioning), Power Exchange, SQL server Management Studio 2005, Mainframe, First Logic, SAS, Java, XML.  

Confidential, Albany, NY

Informatica Developer 

• Responsible to build ETL interfaces for Vendors requirements as per business logic
• Wrote PL/SQL packages to calculate Missing Information and determining eligibility in the processing of a Medical/Health Families Application.
• Interfaced with Business Analysts for gathering the business requirements and designed user-friendly templates to communicate any further enhancement needed
• Created complex mappings using various transformations such as Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, and Router for populating target table in efficient manner
• Developed various mapplets and reusable transformations and was responsible for validating and fine-tuning the ETL logic coded into mappings to improve data quality
• Involved in complete system development life cycle, starting from requirement specifications to delivering the tested pro.
• Responsible for ETL administration as well as testing/validating data process
• Extensive web development on Oracle Web Application Server 3.0 using PL/SQL’s web enabled toolkit to generate web-forms, and Oracle Reports 3.0 to deploy reports on the web.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions
• Worked with memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Sorter, Joiner, and Aggregator Transformations
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
• Fixed issues with the portal and discoverer to leverage Oracle 11i database for complex business logic to retrieve content, and utilizes Oracle Web Cache to cache and render dynamic web pages personalized for each user.

 Environment: Informatica 8.6 (Versioning), TOAD 9.7.2, Oracle 11i, Crystal Reports XI, Sybase, Oracle Fusion Middleware, Tidal Schedular, Java scripts, HTMLDB, Fusion chart, SAS, Java, XML, Oracle Portal 3.02, 9.04   

Confidential, Albany-NY

ETL Developer

Roles and Responsibilities:

• Identify source systems, connectivity, tables, and ensure data suitability/translation for mapping.
• Involved in Requirement gathering and business analysis with consistent focus on the SDLC of the Medicaid and its re-designed project.
• Managed Medicaid ETL projects, developed complex ETL to transform Medicaid data as per users (PSYCKES, PME, Finance) need
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions
• Extensively used SAS dataset translation for Recipient status data and perform procedures conversions into ETL
• Performed tuning of SQL queries/functions for better performance
• Tested important ETL processes and its architecture in Informatica SANDBOX/Tinf environment to confirm its migration from 8.5 to 8.6 B2B exchange
• Design Medicaid Test Plan to test Re-Feed data batches as per its processing cycles
• Worked with data modeler for creating new Medicaid logical and physical models.
• Handled data with mandatory HIPAA rules and regulations both while investigating Methodology/ETL and Investigating Medicaid data processes.
• Involved in fixing/testing ETL process, coding, functions, sessions, batches, and the target data and most importantly fixed ETL production issues
• Developed and Investigated a new methodology and ETL process for netting of claims, netting of encounters
• Involved in Medicaid data re-design and its process in EDW and MDM

Environment: Informatica Power center 8.6 (B2B), Oracle 11g, SAS 9.1.3, SQL/Pl-SQL, UNIX, ER/Studio, BiQuery / QueryMan with TERADATA 7.2 (eMedNY data-warehouse tool designed and operated by CSC)

PRIOR WORK EXPERIENCE SUMMARY:

Confidential

I.T System/Database Engineer

• Performed decommissioning and building /rebuilding of workstations
• Built thin Linux RDP clients in connection with main servers
• Created user accounts, troubleshoot/resolved client and network/Database issue
• Worked on SQL database for Dental health plans.
• Execute SQL procedures and instructed department staff for accessing the database and portal site using simple SQL queries.
• Outline the possible ETL staging/process with I.T Integration department of university to transform Preventive medicine dept. data into practical format by using Informatica as data warehouse tool.
• Prepared technical/architectural specifications, end user technical documentation
• Maintained network and database connections over TCP/IP, domain, and NAS.
• Videoconferencing, VPN, and Desktop/Laptop support

Confidential, Birmingham, Alabama

Teaching assistant

• Instructed undergraduate engineering laboratory sessions and graded assignments
• Constructed computer simulation on VLSI data/Design using Altera Software
• Helped student by solving computer related problems
• Performed analog to digital data conversion

Confidential

Trainee-Electrical Engineer

• Maintenance of electrical and computer systems
• Provided customer service and troubleshoot electrical and computer related problems.

Confidential

Project Intern

• Designed components of power system
• Devised remote testing panel for high voltage routine testing
• Performed operations on systems by using terminal server
• Worked on quality design aspects related to systems