SUMMARY:

• 7+ years of experience and Excellent expertise in Extraction, Transformation, and Loading (ETL) using Designer, Workflow, and Repository Manager wif various versions of Informatica Power Center, Power Exchange, IDE,IDQ, First Logic, MelissaData and DQXI
• Certified Informatica Data Quality (IDQ) Developer and exp. on Informatica analyst tool
• Strong problem solving skills along wif expertise on Oracle DB, SQL server2005/2008 R2 - DB2,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 wif 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 noledge of dimensional modeling, data migration, data cleansing, data integration, and ETL processes for data warehouse
• Hands on Experience on creating Logical, physical, and reverse engineering data models in ER Studio design wif standards
• 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 9.1.0/8.1.1, TOAD 9.7/8.6/7.5, CA ERStudio 8.2/7.2, Oracle 11i/10g, Teradata, First Logic. IDQ, MelissaData, and Informatica Analyst tool

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

Languages: SQL, PL/SQL, UNIX, LINUX, Windows scripting, Hands on exp wif Microsoft SQL server Management Studio 2005, 2008

PROFESSIONAL EXPERIENCE

Confidential, West Trenton NJ

ETL Data Integration specialist/Architect

Responsibilities:

• Currently involved in setting up 9.1.0 environment on server and client level and do the testing in D, Q, and UAT environments for power center, IDQ and Power Exchange
• For dis Informatica upgrade I is responsible for maintaining Informatica services, bat scripts, env files and do workflow based migration wif repository and sandbox backup, parameter other required files migration, change environment variables etc.
• I is 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 wif Informatica support Team.
• Created SOAP 2.5 interface wif web logs, XML,JSOL to execute Informatica objects wifout having Client install on machine
• Worked on Melissa Data wif Java and .net oriented front-end website
• Create data maps separately for historical and daily mainframe files such as VSAM, KSDS, sequential and tape by using DSN and copybook provided by legacy developers and tan extract, transform and transform the data using Informatica after importing it using Power exchange connection.
• Implement DSN and copybook changes and its filter criteria by Informatica and power exchange wif correct Indicator files for NJM claims recon process.
• Created huge process called SIS (Stake Holder Information Store) for its master data file full load in ETL after creating CDC data maps at power exchange level to capture change data ( only read changed fields and process it after its full load)
• Create new ETL standards such as when to use bulk insert stored procedures, parmeterizing the ETL process, truncate table procedure etc.
• Processed XML as target and as source for choice point interface
• Designed new success/failure ETL e-mails handling process in 9.1.0 by replacing outlook groups, used metadata queries (using metadata manager)to find all email contacts
• Increased the Performance of a mapping by eliminating the lookups on large tables & coded the complex logic wif expression transformation and SQL transformation’s override ability, pushdown optimization etc.
• Current Task is to Integrate IDQ, MelissaData (replacing First logic and DQXI) wif Power center and tweaks the code to match the result First logic and DQXI one.

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

Confidential, Albany NY

Informatica Developer

Responsibilities:

• 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 wif 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
• Responsibilities include functional analysis, design, development, impact analysis, resolution of defect tickets raised by testing team
• Unix shell scripting and parameterization of ETL process
• Maintained privacy standards before providing data to vendors by applying appropriate ETL encryption and data masking for sensitive data such as SSN, driving license no., etc.
• Worked wif memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Sorter, Joiner, and Aggregator Transformations
• Used metadata queries to find impacted WFs/objects, runtime of process executions etc.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling for SSIS.
• Fixed issues wif 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), SSIS, TOAD 9.7.2, Oracle 11g, Crystal Reports XI, Sybase, Oracle Fusion Middleware, SOX,Tidal Schedular, Java scripts, HTMLDB, Fusion chart, SAS, Java, XML, Oracle Portal 3.02, 9.04

Confidential

ETL Developer

Responsibilities:

• Identify source systems, connectivity, tables, and ensure data suitability/translation for mapping.
• Involved in Requirement gathering and business analysis wif 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
• Designed and updated data modeling in ER studio as per new eMedNY DW tables and their key relationships to achieve accurate data re-feed.
• Performed tuning of SQL queries/functions for better performance
• Used Teradata Fast import and Vertica to get data re-feed between OMH and NY state DW.
• 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 wif data modeler for creating new Medicaid logical and physical models.
• Handled data wif 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 OLTP 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 wif TERADATA 7.2 (eMedNY data-warehouse tool is designed and operated by CSC)

Confidential

I.T System/Database Engineer

Responsibilities:

• Performed decommissioning and building /rebuilding of workstations
• Built thin Linux RDP clients in connection wif 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 wif I.T Integration department of university to transform Preventive medicine dept. data into practical format by using Informatica as data warehouse tool.
• Created UNIX scripting on large platform for implementing security parameters
• 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

Teaching assistant

Responsibilities:

• 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
• Maintenance of electrical and computer systems
• Provided customer service and troubleshoot electrical and computer related problems.
• Created Design aspects of various components of power system
• Devised computerized remote testing panel for high voltage routine testing
• Performed operations on systems by using terminal server methodology
• Worked on quality design aspects related to systems