SUMMARY

Mission Statement: Provide cost effective and time sensitive business solutions exceeding company goals using effective project management methodologies on ERP, distributed, and mainframe legacy business information systems.

Skills

• Planview Project Management
• SAP ABAP - SAP FICO (4 years)
• UNIX, Tidal Scheduler (8 years)
• Oracle – MS SQL (8 years)
• Hyperion Reporting (5 years)
• Vertex Sales/Use Tax
• Informatica Data Integration
• TSO, JCL, Manugistics
• Natural 2/Adabas

Professional Experience

Confidential, NC August 2011 - Present
Informatica ETL Analyst/Developer Consultant

Analysis, ETL design, and ETL implementation of new Data Mart for Financial reporting system. Conduct data profiling using Informatica Data Explorer and Toad. Analyze existing DB2 databases and tables, incoming data sources from external systems, and MS SQL database repository to create detailed source-to-target mappings. Extract, transform and load in house and external data objects and elements to newly designed fact and dimension tables on a DB2 platform using Informatica PowerCenter. Design and analyze data load validations using Toad for DB2. Use a CDC process to capture dimension changes. Analyzed functional requirements and the developed detailed data warehouse data mapping documentation. Created transformation rule identification, detailed ETL design documentation, unit test plans, and SIT integration test plans.

Confidential, Tx May – July 2011
Business Analyst Consultant

Partner with business users to analyze Income Statements, Balance Sheets, and Cash Flow statements of parent and sub companies to create business intelligence application reporting requirements based on fact and dimension tables. Responsible for the creation of Business Requirements Documents, High Level Design documents and LOEs.

Confidential, 2004 - 2010
Senior ERP Business Analyst – Finance, Tax, Supply Chain, Data Modeling 2006 - 2010

Managed and implemented 15+ projects communicating with multiple managers, business clients, middleware, and technology resources for Tax and Treasury business systems, and SAP FICO AP, AR, and GL modules. Projects included:

• With a very aggressive timeline, partnered with business clients and guided technical consultants in the successful implementation of an automated system to track Excise Tax payments in the SAP MM system utilizing UNIX, Tidal, and ABAP customized programs and parameters. Analyzed complex business data stores and designed high level and detailed specifications for Informatica ETL mappings and workflows to transform and load mainframe and distributed system data to SAP Oracle database resulting in personnel time savings of $100K per year and increased audit tracking.
• Acquired and managed across multifunctional and multidisciplinary teams to complete and implement the SAP FICO bolt-on Vertex Sales and Use Tax system, a $750K capital project. Created a Hyperion based reporting and auditing system solution and integrated dependencies with other projects and activities. Teamed with business clients to redefine business objectives and goals and administered the communication and tracking of tasks for the project team resulting in the business streamlining two managers to one manager.
• Gathered business requirements, documented all phases of the project, performed cost-benefit analysis, risk mitigation, SOX compliance and coordinated with business partners, vendors, infrastructure resources in the successful design and implementation of a hosted Treasury system resulting in a yearly cost savings of $150K+ and a reduction of staffing needs by 1 person.

Lead Business Systems Analyst – Finance, Tax, Supply Chain, Data Modeling 2004 - 2006

Analyzed, designed, and implemented multiple projects communicating with multiple managers, both business and IT, business clients, vendors, and technology resources for Tax, order entry, and manufacturing business systems.

• Directed the conversion of the Confidential organizational structure and data from a mainframe database to a MS SQL database data warehouse. Deconstructed business data stores, determined requirements, and designed specifications for Informatica mappings and workflows to transform and load mainframe and distributed system data to the data warehouse using Informatica. Analyzed functional requirements and the developed detailed data warehouse data mapping documentation. Created detailed source-to-target mappings for the data warehouse, transformation rule identification, detailed ETL design documentation, unit test plans, and SIT integration test plans.
  Based STAR schema database design on invoice and invoice line items as FACTs with product, customer, and organizational data as dimension tables. With the intersection of SAP data had to redesign the database schema, but this entailed minimal changes because of the original design. Added delivery and sales documents as FACTs and added a new dimension intersection table which contained all business organizational data. Used Informatica mappings and workflows to extract, transform, and load new dimension and fact tables from old system.
• Maintained and enhanced mainframe and distributed systems interfaces from and to SAP ERP using Informatica mappings and workflows. Scheduled Informatica ETL tasks to transfer data from mainframe to distributed systems with extensive unit and integration testing.
• Multi tasked and supervised several projects including a Procurement Contract Lifecycle K2 Workflow Sharepoint solution, an Informatica data transformation of four business systems to and from SAP, and the Global Products Inc. data warehouse and reporting project.
• Defined dependencies and scheduled work tasks in the successful analysis and implementation of the Income Tax and Property Tax systems to new hosted architecture solutions resulting in increased support for the business and decreased costs with no outsourcing required.
• Planned and executed the archival of several mainframe legacy and distributed systems applications to include reporting and data extraction.

Confidential, 2000- 2004
Senior Systems Analyst –Transportation Management and Freight Pay, Supply Chain, Order Entry

• Analyzed complex problems, identified critical issues, and delivered the solution in the automation of tracking replies for incoming shipments to determine outgoing carriers saving the company $5K+ dollars a month of freight charges.
• Managed, designed, and implemented a what-if decision support system to support business clients in making decisions on what transportation carriers to use and what warehouses to close. Project on time and within budget involving three business clients and one technical consultant. Developed technical specifications and assigned duties to programmers.

Consulting 1992 – 2000

Penske Logistics, NASA, Newell Corp, Thomas and Betts, Workers’ Compensation Bureau of MA,
Waste Management, ANR Pipeline, Inland Steel, Bradford Exchange

Analyzed, designed, and implemented multiple projects for multiple business systems including order entry, transportation management, and EDI.

United States Air Force E-5 Staff Sergeant

Managed a 7 by 24 Telecommunications facility at HQ Tactical Air Command.

Managed the training and development of 30+ subordinate personnel.

EDUCATION

Computer Information Science

Professional Development

• Planview Project Management
• Manugistics Transportation and Freight Pay
• Property Tax Management System (TCI)
• SAP ABAP - SAP FICO
• Vertex Sales and Use Tax Returns
• Hyperion Web Reporting – Beginning, Advanced
• UNIX – Beginning, Advanced, Scripting
• Informatica ETL – beginning, advanced