SUMMARY

• 7+ years of overall experience in the IT Industry.
• 6+ years of experience in working with data warehouses and using Informatica Powercenter 6.1, 7.1, 8.1, 8.6, 9 (Designer, Repository Manager, Workflow Manager and Workflow Monitor).
• 6+ years of extensive experience with databases (MS SQL Server 2000/2005/2008 , Oracle 8i/9i/10g, Teradata, and IBM DB2).
• 4+ years of data modeling experience using ERWIN.
• 4+ years of UNIX shell scripting. Hands on exposure on UNIX environment and experience in using third party scheduling tools like Autosys.
• Experience with Medicare, Medicaid, Medigap/Medsupp & commercial insurances in HIPAA ANSI X12 4010, 5010 formats including 270,271, 276, 277, 835, 837, 997, NPI, ICD 9,ICD 10, NDC, DRG, CPT, NCPDP codes & NSF formats for interfaces & images to clearinghouses/ trading partners applications.
• Extensive knowledge with dimensional data modeling, star schema/snowflakes schema, fact and dimension tables.
• Experience in building of ODS, data marts, and enterprise data warehouses.
• Expertise in configuration, performance tuning, installation of Informatica, & in integration of various data sources like Oracle, Teradata, MS SQL Server, IBM DB2, XML and Flat files.
• Extensive work with PL/SQL, performance tuning of Oracle using Tkprof, SQL trace, SQL plan, SQL hints, Oracle partitioning, various indexes and join types.
• Understanding & working knowledge of Informatica CDC.
• Experienced in tuning Informatica mappings to identify and remove processing bottlenecks.
• Experienced with IDE/IDQ tools for Data Analysis / Data Profiling and Data Governance.
• Hands on experience on Informatica Power Exchange for loading/retrieving data from mainframe systems.
• Extensive experience with the Trizetto FACETS 4.60 Data models.
• Good working knowledge and experience with ODI.
• Experience in working with COBOL files, XML, and Flat Files.
• Written the scripts needed for the business specifications (BTEQ Scripts).
• Knowledge of Oracle Apps (Oracle Enterprise Business Intelligence).
• Proficient knowledge in ETL using SQL SSIS.
• Strong skills in data analysis, data requirement analysis and data mapping for ETL processes.
• Experience in mentoring and providing knowledge transfer to team members, support teams and customers.
• Reliable, proactive, responsible, hardworking and good team player.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.0/8.x/7.x/6.x, SSIS

BI Tools: Cognos BI Suit, SSRS, Business Objects 6.5

Databases: MS SQL Server 2005/2008, Oracle 8i/9i /10g, Teradata, IBM DB2, Sybase

Database Skills: Cursors, Stored Procedures, Functions, Views, Triggers, and Packages

Client Side Skills: SQL, T - SQL, PL/SQL, UNIX shell scripting, Java, HTML, XML, CSS, JavaScript, C, C++, VB 6.0

Web Servers: IIS v5.0/6.0, Apache Tomcat

OS: Windows 2000/2003/XP/Vista/Windows 7, UNIX/Solaris, Red Hat Linux, AIX

Version Control: Visual Source Safe 6.0, CVS

Methodologies: Data Modeling Logical / Physical, Star/ Snowflake Schema, FACT & Dimension Tables, ETL, OLAP, Agile, RUP, SDLC

Design/Process: UML

Tools: Toad, Erwin, Rational Rose, MS Project, JIRA, Test Director, Bugzilla, TestTrack Pro, MS Visio, Autosys, Turbo Data Generator, Advance Data Generator.

PROFESSIONAL EXPERIENCE

Confidential, Falls Church, VA

Informatica Consultant

Environment: - InformaticaPower Center 8.6.1/9.0.1 , Oracle 10g/11g, SQL Loader, ERWIN, Flat files, TOAD, PL/SQL, MS SQL Server 2005, Crystal Reports,Autosys, OBIEE 10g/11g, UNIX.

Responsibilities:

• Extracted the data from the Oracle, flat files, XML and loaded into Data warehouse.
• Provided support and assist toonshore and offshoreTeam members.
• Used various transformations like Source Qualifier,Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and Lookupto develop robust mappings in the Informatica Designer.
• Involved in analysis for ICD - 10 changes and HIPAA EDI 5010 changes.
• Involved in Dimensional modeling(Star Schema)of the Data warehouse and used Erwin to design the business process, grain, dimensions and measured facts.
• Used Type 1 SCD and Type 2 SCD mappings to update Slowly Changing DimensionTables.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage and ODS.
• Involved in migrating the mappings and workflows from Development toTestingand then to Production environments.
• Involved in Unit Testing,User AcceptanceTesting to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Extensively migrated data from different source system toODS, Data marts and Data warehouse.
• Maintained storeddefinitions, transformation rules and targets definitions using Informatica repository Manager.
• Standard izedparameter files to define session parameters such asdatabase connectionfor sources, targets, last updated dates for Incremental loads and many default values of fact tables.
• Created sessions, configured Workflow to extract data from various sources,transformed data, and loading into data warehouse.
• Used Debugger to test thedata flowandfixthe mappings.
• Involved in Performance tuningat source, target, mappings, sessions, and system levels.
• Tested the data and data integrity among various sources and targets.
• Used RapidSQLto test the SQL’S and to view the data coming from different systems.
• DevelopedUNIX shell scriptsto move Staging files toDB2 databaseusing DB2bulkloads.
• Prepared documentation describing development of mappings, coding, testing and designing of Autosys jobs and Developed Autosys Jobs to run theworkflows in batches.

Confidential, Minneapolis, MN

Informatica Developer

Environment: -InformaticaPower Center 8.1.1/7.x, Oracle 8i/9g, PL/SQL, CVS, Maestro, Toad, SQL * Loader, MS SQL Server 2000, Sun Solaris 2.6, UNIX, Perl, Windows XP.

Responsibilities:

• Used Repository manager to create user groups and users, and managed users by setting up their privileges and profile
• Tuned performance ofInformaticasession for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created Complex mappings using Unconnected Lookup, Aggregate and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Created events and tasks in the work flows using workflow manager.
• Provided production support by monitoring the processes running daily.
• Created Schema objects like Indexes, Views, and Sequences.
• Wrote stored procedure to check source data with Warehouse data and if not present, wrote the records to spool table and used spool table as Lookup in Transformation.
• Involved in backing up and restoring of Repository.
• Designed and Developed Oracle, PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Used BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Worked with Business Objects Supervisor for creating repository, creating and managing the universes, creating categories, creating and managing the users, giving access permissions for Business Objects Reports.
• Created reports like Reports by Policy, Reports by Customer, Reports by Period, Demographic reports and Comparative reports.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Used Perl Scripting scheduling Informatica maps.

Confidential, Cincinnati, OH

Data Warehouse Developer

Environment: - InformaticaPower Center 8.1.1/7.1, Power Exchange,Erwin, Business Objects 6.5, Autosys, Oracle 8i/9i, DB2, XML, TSQL, MS SQL Server 2005, Teradata, UNIX (AIX), UNIX Shell

Responsibilities:

• Worked with business stakeholders and other technical team members to Gather and analyze application requirements.
• Involved in development of Logical and Physical data models that capture current state/Future state data elements and data flow usingErwin.
• Developed end-to-end ETL processes for Trade Management Data Mart Using Informatica.
• Worked on source analyzer, Ware House Designer, Mapping and Mapplet Designer, Workflow manager and Workflow Monitor.
• UsedJoiner, Aggregator, Expression, Router, Sequence Generator, Update Strategyand Lookup Transformation to manipulate data related to customers.
• Designed and developed Informatica Mappings, Mapplets and Sessions for data loads anddata cleansing.
• Developed and implemented various enhancements to the application in the form of Production and new production rollouts.
• Worked extensively onconfirmed Dimensions for the purpose of incremental loading of the target database. Tuning of the mappings and SQL Scripts for a better performance.
• Analyzed the various bottlenecksat source, target, mapping and session level.
• Generated ad-hoc reports as requested by the team lead using Business Objects free hand SQL. Helped in maintenance work related to reports.

Confidential, Gainesville, GA

Data Warehouse Developer

Environment: InformaticaPower Center 6.x/7.x, Oracle 8i/9i, MS SQL Server 2000, Erwin, UNIX, Business Objects 5.0.

Responsibilities:

• Involved in gathering, analyzing and documenting of the data mart system requirements.
• Designed and maintained logical and physical model for data mart schema using ERWIN
• Consolidated data from various sources into the marketing data mart by identifying common data and solving the discrepancy on data values.
• Developed ETL mappings using Informatica Power center 6.1.
• Extensively used Informatica client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer, Workflow Manager.
• Worked on reusable transformations and transformations like expression, aggregation, lookup, router, filter, update strategy.
• Created staging area tables connecting to relational and flat file sources in target designer.
• Scheduled batches using UNIX scripting.
• Worked on mapping performance issues and session failures.
• Interacted with business users to know their business views in developing and modifying universes and reports accordingly.
• Modified the existing business objects universes.
• Generated Master/Detail reports based on user specification(s).
• Worked towards optimal design of universes, removed loops using aliases and contexts.
• Scheduled and monitored reports using Broadcast Agent Server.

Confidential, Harrisburg, PA

ETL Developer

Environment: InformaticaPower Center 6.x, Oracle 8i, SQL Server, DB2,MS Access 2000, SQL, PL/SQL, MS SQL Server 2000, Erwin, Windows NT.

Responsibilities:

• Mapped business requirements to source systems to decide what data elements will be extracted.
• Created Logical and Physical Modeling of Star and Snowflake schemas based on the business rules inErwin.
• Developed Logical model by iteratively refining it based on user feedback to match analysis and reporting requirements.
• Worked extensively in the development of Extract,Transformationand Load routines.
• Coordinated between theonsite and offshoreETL teams as a lead offshore developer for meeting the scheduled project milestones and deadlines.
• Collected, normalized and integrated source data from its operational databases, as well as from third-party hospital, laboratory and physician disease reports.
• Developed transformations and mapping guidelines for loading different targets
• Used Informatica Power Centerto create maps and transform data.
• Created mappings using various active and passive transformations like source qualifier, lookup, router, procedure, aggregator, filter, joiner, expression and reusable mappings inInformatica.
• Documented all the mappings and the transformations involved in ETL process
• Unit and integration testedInformaticaSessions, Batches, Workflows and the Target data.
• Implemented optimization and performance tuning of mappings to achieve high response times.
• Developed Shell Scripts to automate file manipulation and data loading procedures

Confidential

Database Developer

Environment: Oracle, SQL*Plus, PL / SQL, Windows 2000

Responsibilities:

• Created database objects including tables, indexes, roles, clusters, sequence and privileges.
• Involved in Unit testing, Integration testing and Load testing of the interface.
• Involved in documenting the modifications and intended functionalities of the interface.
• Calculated and monitored size and space for tables, clusters and indexes.
• Created and maintained triggers, packages, functions and procedures.
• Helped in creating technical specifications by mapping the interface tables with the base tables.
• Helped Project Lead to develop various reports as needed by management.