SUMMARY:

• Seasoned professional with more than 16 years experience in Information Technology. Adept in organizational leadership, problem solving, strategic tactical approaches, project and people collaborations. Demonstrate excellence expertise in Enterprise Data Warehousing and implementation of large - scale systems in multiple industries. Versed in system methodologies, design techniques and technical hands on leadership.

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

Responsibilities:

• Managing day-to-day operations including accounting, sales, marketing, human resources and contracts.
• Performing business development duties by responding to RFP’s and marketing the company’s abilities for subcontracting opportunities and teaming agreements to effectively grow the organization and ensure financial strength.

Confidential

Data Warehousing Subject Matter Expert (SME)

Responsibilities:

• Manage client satisfaction and expectations.
• Conducted JAD Sessions with large groups of executives illustrating DW Mythologies, techniques and cost.
• Preformed a hardware and software architecture cost and resource analyst plan comparing in-house versus outsourced IT infrastructure.
• Provide the scope and deliverable documents witch included timelines, labor and pricing for DOT to forecast\allocate project funding.
• Provided experience and knowledge in OLAP, BI and Data Mining Methods.
• Provided technical leadership and proof of concept for the large complex enterprise data warehouse utilizing airline information.
• Preformed the current system analysts, identified, analyzed and translated business requirements from the SOP’s to design the conceptual, logical and physical data models utilizing ERWIN.
• Wrote the SQL code for the data migration process moving data from ( a Sybase database) to the new Oracle11g environment.
• Identified and documented challenges such as duplicate, non-conformed, unclean data and data integration issues associated with the merging of the multiple airline sources.
• Designed the ETL process and data mart tables to handle the initial data migration and incremental data loading process.
• Created migration, staging tables and conforming type 2 and 3 Dimensions to support subjects based data marts. The data marts consisted of airline information from these major areas. (On-Time, Traffic, Origin & Destination, Financial)
• Wrote SQLoader scripts, SQL, Pl/SQL and TOAD to support all ETL code and processes.
• Utilized ERWin to create documentation and the data dictionary of all the Data Marts.
• Instructed the DBA team on indexing, partitioning and backup strategies for performance, and data loading issues in an Oracle 11g data warehouse environment.
• Created documentation for the Data Migration process and incremental ETL processes, source to target mappings, security, DQ and data models.
• Wrote data validation scripts to verify the Migrated data.
• Created and maintain the project plan to assure all time lines are met.

Confidential

Data Warehousing Subject Matter Expert (SME)

Responsibilities:

• Manage the Design and Release Management Teams.
• Created and Maintain the Design and Release Management team Project Plans, tasks and resources.
• Wrote the release management process for deploying code using MKS.
• Provided technical Data & Information architecture leadership on a large complex enterprise class SDLC Health care industry project.
• Identifying, analyzing and translating business requirements into conceptual, logical and physical data models in a complex, multi-application environment.
• Created, reviewed and presented Source Systems Analysis and Source To Target mapping documents across Staging, Integration and Presentation layers.
• Identified and documented data integration issues, challenges such as duplicate, non-conformed, unclean data from multiple source.
• Designed and built incrementally models for Staging, Operation Data Stores and Dimensional data marts.
• Managed and delivered quality work on time with multiple competing priorities.
• Provided experience with application integration architecture with package (COT), interface development with MicroStrategy.
• Performed data analysis using SQL, TOAD or SQL Developer tool.
• Utilized ERWin to create the data modeling, documentation and data dictionary.
• Worked with the DBA team by provided indexing, partitioning and backup strategies for performance, data loading issues for Oracle 11g and Teradata.
• Provided experience and knowledge in Data Modeling, OLAP, BI and Data Mining Methods.
• Lead and mentor team members.

Confidential

VP of Data Warehousing Daily Office

Responsibilities:

• Managed office administrations and day-to-day operations including sales, human resources & recruiting; Designed and developed employee and development programs.
• Monitored daily progress of operations and personnel to effectively grow the organization, ensure financial strength and operational efficiency.
• Increased organizational efficiency and productivity through reengineering, teambuilding, and leadership expertise resulting in reduced cost, improved profit, streamlining operations and resource allocations.
• Oversaw and audit all company DoD Data warehousing projects. Main responsibly (DOD INSCOM)
• Manage and perform full spectrum business development including proposal writing.
• Managed, reviewed and audited all hardware and software purchases according to budget.
• Established and implemented short and long term strategic goals, objectives, policies and operating procedures for the corporation. Monitored and evaluated operational effectiveness.
• Served as communication liaison among operating business units to ensure a continuous flow of information among all functional areas.
• Conducted monthly operation and strategy meetings resulting in strategic goal-setting for operating budget checkpoints and P&L forecasting.
• Created, implemented and directed operational and project initiatives utilizing supply chain management growing the organization from 2 to 100plus employees.
• Contribute to and support the corporation’s quality initiatives by planning, communicating, and encouraging team and individual contributions toward the corporation’s quality improvement efforts.

Confidential

System Architect/Data Modeler

Responsibilities:

• Architected, designed and data modeled a federated advanced dimensional data warehousing structure to accommodate unstructured data for intelligence processing.
• Developed the Enterprise Data Dictionaries (EDD) and Data Governance process and documents for the Enterprise data warehouse solution.
• Designed and implemented first phase in data load scenarios (ETL) while leveraging archived data corpus and live feed ingestion processing.
• Outlined performance based query strategies for mining applications while taking into account system’s operational readiness.
• Managed both requirements and expectations by coordinating with lead INSCOM data engineers and system user base.

Confidential

Data Architect

Responsibilities:

• Architected an Enterprise Financial data warehouse for the GL and Loan applications.
• Operated as client liaison for the business analysis, technical decision making, business process reengineering, service level agreements (SLA), project plans, and resource management.
• Designed and wrote system specs, technical design and functional requirements to support customer current and future data warehousing and reporting needs.
• Designed and Modeled the star schemas, meta data tables (Logical and physical) and the enterprise data dictionary (EDD) using Erwin.
• Lead the EDM team meetings.
• Designed and wrote the ETL technical specifications according to the business needs and star schemas.
• Wrote source to target mapping documents which included business logic, data transformations and cleansing for the ETL process. (Source PeopleSoft to the Data Mart Star Schema).
• Post all documentation using Share Point and Clear Case.
• Provided hands on technical assistance, as needed to the Oracle DBA’s with scripts and PLSQL. Oracle10g
• Created/debugged Ab Initio graphs to assist in ETL development .
• Act as the backup Business Objects Admin/Report developer when needed.
• Performed database and Business Objects OLAP report performance tuning when necessary to meet (SLA) requirements.

Confidential

Data Warehouse Project Manager/Data Architect/Modeler

Responsibilities:

• Perform a current system analyst to help the customer determine needs for a Federated Flight Data Warehouse.
• Wrote the proposal for the Data warehouse project
• Provided system specs, technical design and functional requirements to satisfy customer current and future data and reporting needs
• Created the project plan using MS project incorporating a Data Warehouse lifecycle methodology
• Wrote all documents needed for project success. ”Functional Spec, Data Mapping, Data flow and ETL requirements, EDD, TRM, etc…”
• Designed the logical, physical and meta-data model “Star Schema” EDD using Erwin
• Created partition tables, aggregation tables and index strategies to enhance performance and maintenance abilities.
• Designed and wrote the ETL process using PLSQL and Unix shell.
• Performed DBA tasks.
• Designed and created the backup strategy
• Created current and new reports using Discoverer 4i and SQL
• Performed QA test for production readiness

Confidential

Data Warehousing Lead /Oracle Reports and MicroStategy Lead

Responsibilities:

• Lead for the offshore team responsible for reporting, development and UAT testing of new and existing scripts and RETEK modules.
• Establish a development methodology in Manila.
• Coordinated status, UAT, Development and business requirement meeting regularly with onshore team.
• Mentor the Manila team on Retek’s RMS and RDW model for Ross Stores.
• Mentor the Manila team on Oracle report, MircroStategy, RDW system architecture and Data warehousing concepts.
• Mentor the Manila team on data modeling techniques, how to develop and review aggregation tables, and reporting based off of specifications documents assigned by the onshore teams.
• Help developers with Pl/sql, Sql and performance tuning when coding problems occur.
• When necessary developed MircroStategy and Oracle reports to help with the time constraints.
• Estimate work to completion.
• Assign tasks to the Manila team and track task and deliverables accordingly.

Confidential

Data Architect Consultant

Responsibilities:

• Provide technical leadership for the lifecycle development of enterprise/division projects, ensuring the integration of external data follows The Operational Data Store (ODS) and The Corporate Data Warehouse (CDW) technical architecture and model standards and strategies.
• Facilitated and collaborated with Information Architects, Application Architects, network engineers and other technology specialists in the implementation of projects and strategies.
• Lead the Historical Loan Processing (HLP) division/department level teams in report development, automated reconciliations and data extraction utilities that will be utilized as part of the quarterly Historical Loan Performance (HLP) submission to OFHEO. Championed the establishment of technical direction, corporate approach, and data warehousing methodologies.
• Identified, researched, and provided Erwin data model resolutions for data integration and architecture issues associated with mapping multiple source systems. Provided input and recommendations to senior management regarding technology direction and technological problems.
• Lead review meetings to communication system architecture and design to the organization business area, including ISS Senior, middle and project management, and senior technical staff.
• Lead and wrote technical requirement specifications for the ETL development team.
• Lead complex project problem and issue resolution efforts.

Confidential

Senior Programmer Analyst

Responsibilities:

• Created project plan that maintained requirements, tasks and resources associated to project needs and overall scope.
• Preformed capacity planning and benchmarks of the Retek RDW Data Warehouse.
• Lead data architect for data model enhancements associated with data requirements and reporting Data Marts issue.
• Provided module enhancement requirements to offshore development team of Retek.
• Perform code retrofits and patch updates of all new modules and etl enhancements
• Designed the system architecture for the Retek RDW data warehouse and backup & recovery policies using Oracle 9i functionality and concepts.
• Perform SQL tuning for Microstrategy Reporting, DataMart creation and snow flake data model changes for performance improvement.
• Wrote, Designed and performed performance tuning for new and existing RDW RFX 10.2.2.1 R-Etl programs, XML,shell scripts, Oracle Procedures and Sqlloader jobs loading external data.
• Perform code retrofits and patch updates of all new modules and etl enhancements.
• Design and created new interfaces and reports using oracle9i,6i forms and reports for Retek RMS, RDW application users, allowing the ability to view, manipulate and perform data entry via the RMS Web interface according to business rules and reporting needs.
• Created run book for batch jobs in nightly scheduler.

Confidential

Technical Lead, Data Architect

Responsibilities:

• Technical Lead for migrating from IRI to AcNeilson source data.
• Wrote the scope, data mapping, and data flow and data requirement documents.
• Preformed gap analysts.
• Designed the ETL process with Ab Initio and plsql to handle data change from the new provider.
• Designed validation reports for the data quality team.
• Gathered system, data and business requirements from existing systems which used ProC programs for data migration which populated Retek version 10 system retail data warehouse.
• Reviewed weekly status reports and held meetings viewing project plan and project concerns.
• Redesigned ProC programs, Ab Initio graphs, shell scripts and Plsql Procedures to decrease initial migration and nightly data loads time for Retek’s RMS and RDW modules.
• Rewrote project plan and technical documents illustrating the utilization of Ab Initio and new oracle8i functionality to meet deadlines and the use of available resources.
• Designed and wrote the Retek retail data warehouse purging process using Ab Initio and Plsql Procedures.
• Designed Data Marts and made snow flake data model changes to enhance reporting for MicroStrategy and Discoverer.

Confidential

Data Architect Consultant

Responsibilities:

• Gathered reporting and system requirements by interviewing users and performing a current system analysis to Develop Project Initiation documents.
• Developed project tasks and implementation plans according to system requirements and time constraints.
• Lead team in the designing staging tables, star schema and Data Marts using Designer2000 6i.
• Generate and document the data warehousing schemas and data dictionary using Oracle designer 6i .
• Designed and Developed the ETL process using SQLLoader for flat files and stored procedures for data transformation and cleansing during data loading of the star schema and data marts.
• Design and wrote procedures for aggregation tables according to reporting requirements.
• Preformed administration duties for Discoverer 4i and Viewer4i.
• Designed reports in Discoverer according to user specifications.
• Helped users and Mangers write validation scripts to balance system outputs.
• Generate and document data warehousing snow flake schemas using Erwin.
• Made ETL changes according to schema updates.
• Tuned Control files and procedures used in the data warehouse load process.
• Preformed database tuning to enhance quires performance.
• Preformed data integrity checks, created aggregation tables for OLAP tools and QA reports for data validation.
• Manage and developed project plan from design to implementation according to P+ standards.
• Team lead that designed, generated and documented database objects and star schema using Designer 2000.
• Scoped, wrote and implemented ETL process for data warehouse using SQL LOADER and PL/SQL.
• Performed database tuning to enhance load and quires performance.
• Designed and preformed unit testing to assure data integrity and quality according to use standards.

Senior Consultant /Project Lead /DPA Admin

Confidential

Responsibilities:

• Developed project plan, scope document, report requirements and implementation plan through meetings, client interviews and current reporting system reports for multiple countries.
• Designed multiple data marts from Oracle Financials using DPA.
• Wrote data conversion scripts to populate DPA schemas.
• Perform DPA administration duties.
• Perform database tuning to enhance DPA performance.
• Designed GL Financial reports using Crystal Reports.

Technical Lead

Confidential

Responsibilities:

• Performed current system analysis and proposed possible new solutions, time, and cost estimates.
• Wrote PL/SQL and SQL*Loader scripts for monthly loading process.
• Used Designer2000 to design a star schema based on Oracle Financials Inventory module.
• Collaborated with client and other consultants to design technical architecture for data warehouse project.
• Designed data base objects and data mart schema using Designer 2000.
• Designed and wrote ETL specs and code for PL/SQL developers.
• Worked with client and developers in an iterative process to developed reports specs and implementation plans.
• Developed Oracle reports according to spec documents.
• Developed QA and change request procedures for ETL and reports development in accordant to scope and time constraints.
• Built a Workers Compensation & Liability data mart for Boeing Corp to summarize data for analysis reporting in Oracle Financial Analyzer (OFA).
• Wrote control files to load data using SQL*Loader and Oracle Enterprise Manager.
• Wrote PL/SQL scripts (ETL) to load, transfer, and update data in the data warehouse.
• Designed star schema using Designer 2000.
• Performed Oracle administrator duties using Oracle Enterprise Manager.
• Wrote PL/SQL scripts and used Informatica to populate aggregation tables for OFA.
• Wrote data load programs for OFA.
• Wrote Oracle reports to validate data in the data mart and aggregation tables against the current system.
• Wrote UNIX shell scripts to automate the data warehouse monthly load and update process.
• OLAP administrator for team developing a ROLAP application using Information Advantage for a large commercial bank data warehouse.
• As a member of the database team analyzed business requirements and established consensus among end user departments on common data definitions and aggregations
• Trained client on Oracle 8.0.4 Data Warehouse capabilities.
• Built data base objects using Designer 2000.
• Wrote stored procedures and packages using PL/SQL to load and transfer data from the data staging area to the data warehouse and creating aggregation tables for the ROLAP tool.
• As the OLAP tool administrator developed, tested and documented reports, queries and filters for the OLAP application; tuned the database to improve performance of the OLAP tool.
• Developed and populated the metadata and dimension tables for the OLAP tool based on end-user requirements. Using Oracle Enterprise Manager and Oracle reports, monitored and produced reports to verify data quality in the warehouse and assure that data matched production reports from original systems.
• For the Department of Defense (DOD), helped design a large purchasing, custom-built, client-server application for the Defense Security Assistance Agency (DSAA). The application is expected to be deployed at 56 sites throughout the U.S. and Europe with a user base of 1,700 users.
• As the Data Modeling Team Lead (DOD), used an iterative approach to requirement analysis and design by facilitating discussion groups and client software reviews; tools used include Oracle RDBMS v7.3, Impromptu, Oracle Reports, CASE tools (Software Through Pictures, STP) and Oracle Designer to develop data base objects.
• Used Developer 2000 to develop forms for viewing data in different schemas for validating data integrity and reporting simplicity.
• As the Data Definition Team Lead (DOD) developed systems Entity Relationship Diagrams (ERD) and performing the Oracle Repository Administrator duties according to PriceWaterHouse life-cycle methodologies.

Confidential

Information Technology Consultant

Responsibilities:

• Designed and developed an on-line Internet inventory system using Microsoft Access to support the year 2000 efforts of Kmart Corporation.
• As a development team member developed a data warehouse using Financial and Human Resources Information System (FEIS) for The Department of Commerce. The system provides on-line access to financial and human resource databases that were normally received in delimited ASCII, dBASE files, MS EXCEL, and Lotus 123 formats.
• Formatted raw data from legacy systems into data files which were loaded via SQL*Loader, PL/SQL, and Impromptu into Oracle and Cognos PowerCubes; from which canned and user-developed ad hoc reports where created using Cognos PowerPlay. Also, at user request integrated GIS MapInfo with Cognos PowerPlay to show data geographically.
• Tuned the application with the database to improve database performance; Performed cold backup and recoveries for the Oracle database when errors occurred.
• Installed FEIS on user workstations under Windows NT, 95, and 3.11; trained initial users, and incorporated feedback to improve the overall system.
• Developed the GUI interface for FEIS using OLAP software, COGNOS Portfolio and Mapinfo.
• Helped market the system through product demonstrations to prospective clients and participated in technical trade shows.