PROFESSIONAL HIGHLIGHTS

Over 17 years of experience managing projects - Informatica ETL Development, data modeling, requirements analysis, design, development, implementation, configuration, and quality assurance. A highly people-oriented team player with project management experience and strong organizational and communication skills; Dedicated to efficient completion of multiple tasks within time constraints.

TECHNICAL SKILLS

Operating Systems: Windows 2008 Server Active Directory, Windows XP, UNIX / Solaris

Databases: Oracle 7.x, Oracle 8.x, Oracle 10g, Oracle 11g, SQL Server, PostgreSQL

Programming Languages: Oracle Discoverer, MS Access 2000 / SQL, PL/SQL, HTML, & HTML DB, SQL*Plus 8.0 & PL/SQL / Designer 2000, ODI, OBIEE, PostgreSQL, Photoshop 7, Adobe Acrobat Distiller, Adobe Illustrator 10, Flash, & My-SQL, Project Management

Software Packages / Business Intelligence: Informatica Power Center/Metadata Manager Project Management, Oracle HTML DB, OBIEE 10g, Oracle ODI 11g, SAS ETL Studio, SAS, Informatica Powers center,, Microsoft Office 2000, Microsoft Office 2003, MS Exchange 2003, MS Project, MS Access, Home site, Cold Fusion Studio, MS FrontPage, Dream Weaver MX 2004, SQL Server, FileMaker Pro, PostgreSQL, SQL 6.5 & 7.0 Enterprise Manager, My-SQL, Adobe Photoshop, FTP software, Microsoft Front Page, & Quest TOAD, ERWIN 6.5, SQL*Loader, Dame Ware Mini Remote Control, Informatica 9.5.1, Microstrategy

Methodologies: Project Management, Database and Application Development, Security Audit Controls & Countermeasures; Setup, Installation, Configuration, & Upgrade of Software & Hardware; Software Testing, Documentation & Reports; Security Monitoring, Testing & Training; Oral & Written Communication

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica ETL Developer

Responsibilities:

• Designs ETL solutions to automate loads based on client requirements
• Redesigns ETL mappings to optimize runtimes due to transformation bottlenecks
• Develops complex ETL mappings by transforming PL/SQL code into Informatica mappings
• Designs and creates mappings to extract data from numerous sources (Oracle and SQL server DB’s, flat file loads) to stage in Data warehouse for reporting
• Performs Informatica updates from PowerCenter version 9.6.1 to PowerCenter version 10.1.1
• Manages all admin related components including creating and/or updating repository services, integration services, model repository services, data integration service
• Manages XML migrations from lower environments through to Production (including deployment from Informatica developer into PowerCenter and vice-versa)
• Creates relational objects in DB2 to support Confidential secure flight program
• Develops Informatica sessions using Informatica workflow manager to run Powercenter mappings/mapplets
• Builds Data warehouse Staging and Target tables for data loads
• Creates Oracle DAC execution plans to support workflow scheduling and parameterized solutions
• Monitors Informatica jobs using Informatica Workflow Monitor to ensure successful completion of loads
• Troubleshoots and resolves any breakages/failed loads

Confidential

Sr. Informatica ETL Developer

Responsibilities:

• Developed complex ETL mappings using Informatica Powercenter Designer
• Designed and created mappings to extract data from numerous sources (Oracle and SQL server DB’s, PostgreSQL, flat file loads) to stage in Data warehouse for reporting
• Created tables, views, stored procedures, indexes and synonyms in order to support HR Reporting using Business Objects Web Intelligence reports
• Translated client requirements (complex queries) into appropriate ETL mappings using Powercenter Developer
• Installed and upgraded Informatica Powercenter from Versions 9.0.1 to version 9.5.4
• Managed administration tasks (Domain configuration, Repository Service configuration and content updates, Integration Service configuration and content updates, Reporting service configuration and content updates, User administration including creation and role assignments etc.)

Confidential

Sr. Informatica ETL Developer

Responsibilities:

• Managed strategic planning of CMS’ Enterprise Data Environment.
• Conducted impact analysis studies to determine needs of modifications to current enterprise architecture and databases
• Used Informatica Metadata Manager to load metadata from CA Repository into a Metadata Manager repository.
• Designed ETL solutions to automate loads based on CMS requirements using Informatica Power Center
• Built triggers and stored procedures logic during load cycles
• Tested and migrated of Informatica ETL mappings from Development and Test environments into the Production environment (using SDLC methodologies)
• Translated client requirements (complex queries) into appropriate ETL mappings using Informatica Powercenter Developer
• Created Microstrategy Schema objects and Application objects using Microstrategy Desktop and Architect
• Performed Business Analyst role interfacing with SME's to understand and define the functional and information requirements and documenting these in the Business Requirements Document (BRD).

Confidential

Project Lead / SAS ETL Data Modeler Lead

Responsibilities:

• Managed and built design diagram flow to depict the pattern of the data flow into the ONC Enterprise Data Warehouse
• Developed Data objects using Erwin 8.0, for data modeling and data ware housing.
• Created various Oracle tables, views, indexes, sequences, functions, database triggers and packages using SQL*Plus and Toad.
• Analyzed the source system to understand the source data and table structure along with deeper understanding of business rules and data integration checks.
• Implemented the Slowly changing dimension scheme (Type II) for most of the dimensions.
• Implemented the standard naming conventions for the fact and dimension entities and attributes of logical and physical model.
• Created the DDL scripts using ER Studio and source to target mappings (S2T- for ETL) to bring the data from JDE to the warehouse.

Confidential

Sr. Data Modeler/Oracle ODI / OBIEE TEAM LEAD

Responsibilities:

• Installed, administered and configured ODI software for ETL Development/System Test/Integration Test/Production environments.
• Designed & Developed ODI data model and subject areas for OCIS and Xrite sub systems of DMM BEN component to provide data for (dashboard, Answers requests, pages) development data model.
• Develop, implement and supported the ETL processes for real-time production reporting environment. Create connections to extract data from multiple source systems, ranging from flat files to databases to JMS queues. Facilitate deployment and testing of the ETL process.
• Customized the OBIEE Repository (physical, BMM, and presentation layers).
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.

Confidential

Project Lead / Senior SAS ETL

Responsibilities:

• Managed Decennial Management Division Enterprise Data Warehouse
• Managed team making sure that timesheets are approved and the teams are getting the work done within the deadline in order to keep the schedule ahead of time.
• Used SAS Data Integration Studio, integrated and manipulated internal and external data into the Oracle Enterprise Data Warehouse (EDW)
• Developed target data sets, OLAP cubes, information maps, and reports
• Used SAS Extract, Transformation, and Load (ETL) tools
• Created mappings to extract data from PostgreSQL to load into staging Data warehouse for reporting.

Confidential, Washington, DC

Project Manager / Applications Engineer

Responsibilities:

• Coached, mentored and led personnel within a technical team environment.
• Managed transition of client from Solutions Implementation to Client Support. Manage the development and maintenance of implementation portions of project.
• Managed and perform the process of Statement of Work and contract creation to secure new and follow-on work.
• Prepared feasibility studies, requirements analyses, and project plans for an Oracle Database and Aviation Human Resources (AHR) Accountability Board
• Managed and facilitated 21 separate Aviation Human Resources (AHR) applications Projects.
• Managed and supported various Business Units approximately 170 users with desktop, office software, and programming solutions.
• Designed logical and physical database designs for using Erwin 6.5 on the backend and ColdFusion on the front end, manipulated the database using TOAD
• Created an Oracle online application to record investigations of misconduct for the Accountability Board.
• Created the Workload database structure that Manages and measures the hiring process timeliness at Confidential Aviation Human Resources (AHR).
• Designed an Oracle HTML DB application and Oracle database for Starting from Yes (SFY) A Project Management software for capturing chronology of events.
• Balanced Scorecard - Designed and programmed a system to obtain aggregate data from Confidential 's 12 regions determining managers’ satisfaction and the length of time of new hires for personnel specialists to fill a position which is tracked against the Confidential Flight Plan and the Office of Personnel Management's baselines.
• Designed and created the Employment Relations Tracking System Application using Oracle 10G at the backend and ColdFusion at the front end. Employment Relations Tracking System - Manage and tracks discipline cases across Confidential ’s 12 regions.
• Supervisor's Mail List - Developed and manages comprehensive mail list application for Confidential 's 5,500 managers and supervisors to send out customized email messages from the Assistant HR Administrator to all or a subset of managers and supervisors. Before this application was built messages could only be sent out in broadcast mode to all users.
• Created an Aviation Human Resources (AHR) Tech Support Tracking System using ColdFusion at the front end and Oracle 10G at the backend. The Tech Support Tracking System - Tracks and manages technical support help requests and sends out an automated survey to selected users.

Confidential, Sacramento, CA

Project Manager / Senior Oracle Developer

Responsibilities:

• Managed team of five in developing and designed System architecture, and data modeling of the data requirements.
• Developed Data objects using Erwin 4.1.4, for data modeling and data ware housing.
• Created various objects like tables, views, indexes, sequences, stored procedures, functions, database triggers and packages using SQL and PL/SQL in SQL*Plus.
• Developed use cases, use cases diagram and business flows diagram of the Ticket to Work Systems
• Managed Maintenance of existing Systems, bug fixes and implementation of new functional requirement.

Confidential

Senior Oracle Data Architect / Project Manager

Responsibilities:

• Managed daily activities of team of data modelers, business analysts, DBAs, application developers, and reporting specialists
• Supervised team's commitment to quality and standardized processes. Represent the team in customer and management meetings, conveying technical status and issues in business-relevant terms.
• Designed and implements Data Warehouse for Marketing.
• Designed, developed, and implemented the Confidential Data Architecture and SAS Data Mart using SAS ETL tool for Incremental data upload from multiple clients.
• Executed procedures and packages on Solaris UNIX Box to load data into the Staging Databases
• Specified and implemented capacity planning. Experienced in normalizing and de-normalizing data.