SUMMARY:

• Versatile ETL and BI solution architect with expertise in data mapping, transformation, and integration
• Accomplished developer with extensive success in data modeling, design, transformation, and warehousing enabling the highest caliber of business intelligence.
• Contribute to end - to-end project life cycle, including planning, requirements analysis, solution design, development, testing, integration, and deployment for complex and heterogeneous data sources.
• Forge conceptual, logical, and physical designs featuring high scalability; extensive record of success converting and migrating data.
• Proven leadership abilities and outstanding communication skills with intuitive approaches to relationship management, teambuilding, and business consulting.

HIGHLIGHTS OF EXPERTISE:

• Data Modeling / Architecting
• Requirements Analysis
• Production Deployment
• Project Planning & Management
• Data Cleansing / Hygiene
• Data Conversion & Integration
• BI & DW / EDW Solutions
• Performance Optimization
• Stakeholder Relations

TECHNICAL PROFICIENCIES:

Platforms: Windows, Windows Server 2003, UNIX, Linux

ETL & BI: Informatica 6x / 7x / 8x / 9x, Oracle Warehouse Builder, Oracle Data Integrator 11g, DataStage 8.1, Oracle Essbase, Oracle BIEE 10g / 11g, Oracle Golden Gate, SQL, PL/SQL, SQL Developer, Java, Toad

RDBMS: Oracle 8 / 8i / 10g / 11g, SQL Server 2005 / 2008, Erwin Data Modeler, MySQL

Tools: SharePoint, Rational Rose, Hadoop, Business Objects

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, Virginia

Project Senior Analyst

Core Technologies: Oracle, SQL Server, Rational Rose, Erwin Data Modeler, Informatica, OBIEE, Oracle Golden Gate, Toad, BOBJ, UNIX, SharePoint

Responsibilities:

• Played instrumental role in conceptual, logical, and physical ODS design, using Erwin 9.5, to drive enterprise-scale data / database transformation, modernization, and standardization, serving in business analyst, data architect, and data warehouse modeler role.
• Collaborated on creation of ETL data staging strategy and processes to load slowly changing (type 1/2/3) data into ODS and data marts.
• Consulted on data architecting / re-architecting projects; developed metadata tables, EDW indexing and partitioning solutions, and data-driven reference and error tables.
• Enabled standard and ad hoc BI reporting via Business Objects.
• Engaged in support of enterprise data warehousing and business intelligence solution architecting to provide a single data repository for multiple FDA stakeholder organizations, including enablement of knowledge worker decision-making and streamlining of drug application / approval processes.
• Modeled data warehouse bus architecture to conform with define dimensions; diagrammed ETL process dependency flows and developed ETL processes to feed data into dimensional and fact start architecture.
• Contributed to development of bottom-up ETL solution using Informatica and tuned ETL processes.
• Authored complex data testing SQ queries to validate EDW data.

Confidential, San Jose, California

Partner & Informatica Developer

Core Technologies: Oracle, SQL Server, Rational Rose, Erwin Data Modeler, Informatica, OBIEE, UNIX, Linux

Responsibilities:

• Co-launched perishable goods exchange company and served in ETL development and BI / DW architect role.
• Led data acquisition, hygiene, ETL, and integration life cycle.
• Developed source maps and reference data tables, created data ETL processes in Informatica, tuned and optimized ETL batch processes, developed workflow objects, and created session scheduling; utilized Source Qualifier, Look up, Expression, Aggregator, Update Strategy, Sequence Generator, and Joiner transformation processes to populate DW environment and enable BI reporting.

Confidential, San Jose, California

ETL Developer

Core Technologies: Oracle, MySQL, Hadoop, Hive, Informatica, Business Objects, Linux

Responsibilities:

• Developed ETL data processing solutions to develop a central repository for complex, multi-source biological data.
• Designed data source maps for heterogeneous data types and Informatica-based data structures to establish a single, centralized data repository and view for distributed researchers.
• Developed, tested, and validated source maps, maps, reference data tables, functions, and ETL processes.

Confidential, Lombard, Illinois

Senior Consultant & ETL Developer

Core Technologies: Oracle, MS SQL Server, Ascential DataStage, SAP, Primavera, Ariba, Maximo, PeopleSoft

Responsibilities:

• Served on ETL group within project team launching cost planning, analysis, and reconciliation solution for turnaround modeling and management.
• Performed source system definition across CERs, Ariba, Maximo, Primavera, and SAP, defining ETL processes in Ascential DataStage informed by analysis of data warehouse data model, subject matter, and workflows.
• Collaborated on implementation of requirements-driven database changes with DBAs.
• Created ETL processes in precise alignment with technical specifications.
• Utilized DataStage Manager / Administrator / Director to import table definitions and metadata, create user-defined environmental variables, develop Shell scripts, and schedule jobs.
• Designed Data Stage jobs for sources such as Oracle, MS SQL Server, and text files; built parallel jobs for performance improvements and overall reduction of runtime for multiple jobs.
• Conducted unit testing for job scripts and processes.
• Consulted on ETL business requirements enabling human capital / workforce analysis; developed ETL solutions via Informatica, DAC, Oracle 10g.
• Conducted data quality analysis to identify and plan data cleansing needs.
• Mapped data in Informatica for loading from source to data mart; utilized Informatica Power Center to develop maps with embedded business logic.
• Created transformations in Informatica Designer, such as Lookup, Joiner, Rank and Source Qualifier; created maps—using unconnected Lookup, Sorter, Aggregator, Dynamic Lookup, and Router transformations; and created Mapplets.
• Led user documentation and mapping process knowledge transfer support efforts.

Confidential, Silver Spring, Maryland

Informatica & OBIEE Developer

Core Technologies: Informatica Power Center, OBIEE, BIP

Responsibilities:

• Consulted on and developed ETL solutions for marketing data provider engaged in list segmentation for targeted marketing.
• Collaborated with AMU data integration / reporting specialists to define consumer and business marketing data for conversion into a common repository for analysis, segmentation, and reporting.
• Utilized Informatica Power Center to develop ETL processes and transformation maps for warehousing of multisource data; leveraged Joiner, Aggregator, and Expression transformations.
• Defined Worklets workflows to schedule processes and sections.
• Deployed databases and applications in demonstration, QA, and production environments.
• Contributed to development of OBIEE repository’s physical, business model, and presentation layers, metadata objects, interactive dashboards, and security framework.
• Produced multisource dashboard reports via BIP and integrated OBIEE; enabled ad hoc reporting.