SUMMARY:

• Information Technology developer wif experience in full life cycle development in mid - tier, client/server, and mainframe technical environments.
• ETL and data warehouse analyst under star and snowflake schema in slowly changing dimension and aggregates.
• Systems experience in Federal health care - Center for Medicare and Medicaid systems, AMSA, part of the U.S. Army Center for Health Promotion and Preventive Medicine (USACHPPM)
• Software change management (SCM) expertise in dynamic and multi-platform environments.
• Excellent communication, interpersonal, strong problem solving and teamwork skills.

TECHNICAL SKILLS:

Operating Systems: Windows 2000 Pro, Windows XP Pro, Unix (Sun Solaris)

ETL Tool: Informatica Power center 6.1/7.1/8.1/8.5/8.6, 9.0.1,9.5 /10.1, JIRA for Development

Change Control Tool: MKS Integrity Client 2009

Help Desk: REMEDY

RDBMS / Database: Oracle 8.0/8i/9i,10G, 11G, My SQL, MS-Access, Microsoft SQL Server Management Studio,2008, Oracle OFSAA, Oracle SQL Developer 2.1.164,Toad 10.1.1.8, Teradata 12, Teradata SQL Assistant.

Office Productivity: MS-office 2010, Visio 2010, MS-Outlook.

Languages: C, C++, Java, Korn Shell, PL/SQL, Teradata SQL

PROFESSIONAL EXPERIENCE:

Confidential

ETL Informatica Admin/Developer

Responsibilities:

• Designed and created various ETL codes for end to end process for the Data validation for DC1 and DC2 env.
• Preform Informatica Administration activity (by using Admin console and Linux) for Data Center1.
• Worked on the Business Glossary populating the full glossary wif the data mart and tasks for Data Center2.
• Suggested best practice for Informatica logs approval and worked on several tickets wif Informatica Support.
• Performance tuning of Informatica ETL process by running it parallelly at PL/SQL procedures and Packages.
• Maintenance of daily and weekly Patch and ETL runs.
• Production support to trouble shoots various ETL issues.
• Provide the suggestions for better performance.

Environment: Tools: Informatica 9.6.1, SQL Developer. Business Glossary, IDQ. Power Exchange, PowerCenter. OS: Windows 7 Enterprise, Red Hat Linux 6.9 Database: Oracle 12c.

Confidential

ETL Informatica Admin/Developer/Serena CM

Responsibilities:

• Designed and created various ETL codes for end to end process.
• Informatica Administration activity (by using Admin console and Unix)
• Performance tuning of Informatica ETL process, PL/SQL procedures and Packages.
• Maintenance of daily and weekly ETL runs.
• Production support to trouble shoots various ETL issues.
• created various Oracle procedures and packages overrides for daily process ETLs.

Environment: Tools: Informatica 9.6.1, SQL Developer. Attachmate Reflection, Serena Dimensions OS: Windows 7 Enterprise, Red Hat Linux 6.9 Database: Oracle 12c.

Confidential

ETL Informatica Admin/Developer

Responsibilities:

• ETL Application Registration (Fully Hosted/Evaluation Only/Review the config file/Create Unix
• File system/Create an opportunity in SFDC)
• Informatica SCM (software control management) (Folder Level migration/Object Level
• Migration)
• Informatica object Migration using Repository Manager
• Informatica Administration activity (by using Admin console)
• Hotfix Implementation
• Performance tuning of Informatica application and also Informatica mapping.
• Code review of mappings of various application across plant
• Give expert solution to the users for problem in Informatica
• Weekend recycling procedures
• Outage Handling (Escalation Procedure, running metadata queries and procedures, checking
• Database blocking, creating outage log)
• Troubleshooting user's problems (application and infrastructure related)
• Contact wif Informatica tech support group regarding the unnon problem

Environment: Tools: Informatica 9.6, SQL Developer, Putty, MS Excel2013, MS Word2013. OS: Windows 7 Enterprise, Red Hat Linux Database: Oracle 11g, DB2

Confidential

Sr.ETL Informatica Developer

Responsibilities:

• Created the Data Model in Ervin.
• Developed coding to extract data from different flat files to stage database and from stage database to production database.
• Created coding to load the oracle database for update and report purpose from different sources like flat files and relational database. And database used to generate data for the end user on web based application.
• Involved in the performance tuning of source & target, transformation and session optimization.
• Used Business-To-Business Data Transformation to generate the XML files and used the XML transformation to bring the data to percenter.

Environment: Tool: Informatica 9.5, SQL Developer, Putty, MS Excel2013, MS Word2013. OS: Windows 7 Enterprise, UNIX Database: Oracle 11g, DB2

Confidential /Herndon VA

Informatica /Data stage developer

Responsibilities:

• Used Unix Operating System and developed basic UNIX shell scripts. Total Informatica development.
• Using TOAD, SQL Developer as the oracle tool to separate the values from the source tables.
• Using Data stage to move data from Oracle to Oracle and CSV files via Data Stage version 7.5,8 and 9.1 including full SDLC.

Environment: Tools: Data Stage 9.1, Informatica 9.1, SQL Developer, Putty, MS Excel2010, MS Word2010 and MS Visio2010. OS: Windows 7 Enterprise, UNIX Database: Oracle 11g, DB2

Confidential, Washington DC

ETL Informatica Developer

Responsibilities:

• Using Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and code the process of data flow from source system to data warehouse.
• Used the Data Quality and Data Transformation Studio for creating the data report and loading the data to the staging area and EDW also used XML transformation.
• Worked on Source to Target Mapping document.
• Use .csv files as source and Oracle as the target database.

Environment: Tool: ETL Informatica Power Center 8.6.1/9.0.1, Toad, Putty, MS Excel2010, MS Word2010 and Visio2010. OS: Windows XP, UNIX Database: Oracle 11g, DB2

Confidential

ETL Informatica Developer

Responsibilities:

• Involved in daily scrum meetings and weekly review meetings to discuss timelines and status updates.
• Used Teradata as the source and the target database.
• Worked on Source to Target Mapping document.
• Used MKS Integrity Client 2009 as version control tool to comply wif audit requirements for Request for Change (RFC) and Help Desk ticketing and moving all the code to one environment to other.
• Extensively used different transformation in Informatica Power center wif Pre and Post SQL commands to get optimized solution. Also used Linux for a FTP, creating Parameter file and using PMCMD command.

Environment: OS: Windows XP, UNIX Database: Teradata SQL Tool: ETL Informatica Power Center 8.6.1/9.0.1, MKS Integrity Client 2009, Teradata Sql

Confidential, Tucson AZ

ETL - Informatica Developer

Responsibilities:

• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and code the process of data flow from source system to data warehouse. Used update Strategy, Sorter, Joiner, Source qualifier, Router in the mapping.

Environment: OS: HP - UX, Windows XP Database: Oracle 9.1 Tool: TOAD, ETL Informatica Power Center 8.6, Microsoft Visio 2003 & 2007Putty, WN SCP, MS-Excel, MS-Word.

Confidential, Washington DC

Informatica Admin/Developer, Data Analyst, Oracle Developer, Tester

Responsibilities:

• Informatica SCM (software control management) (Folder Level migration/Object Level
• Used Unix Operating System and developed basic UNIX shell scripts used Informatica Power center wif Pre and Post SQL commands to get optimized solution. Also used Unix Putty FTP, creating Parameter file and used PMCMD command.
• Determine the options and recommended solution for populating domain counts for the DMSSMT Tables.
• Using TOAD as the oracle tool to separate the values from the source tables and send).

Environment: OS: HP - UX, Windows XP Database: Oracle 9i/10G/11G, PL/SQL Tools: TOAD, ETL Informatica Power Center 6.1, 7.1,8.1,8.6, Microsoft Visio 2003