SUMMARY

• 18+ Years of hands on systems team management and consulting experience focusing on data enterprise architecture business intelligence for application software implementation, Working with large user bases per environment, Data mining and integrity, development, design and coding. Data goverence solutions and business glossary implementations.
• Business Data Analysis focusing on ERP financials for PeopleSoft, OBIEE, Oracle EBS, SAP, Infinium, CODA Financials, Specializing in integration with SalesForce and Anaplan for Salesforce.
• Business Intelligence planning and implementation focusing on verticals such as finance, pharmaceutical, and manufacturing
• 8+ years of IT industry experience in implementation, Upgrade of PeopleSoft Finance and HRMS. Proficiency in upgrade, development & maintenance of PeopleSoft Applications
• Design, develop, test and maintain software to support the PeopleSoft Finance (AP, GL, AR, CM and PO) / PeopleSoft HRMS (Core HR, Payroll, Benefits Administration and Base Benefit).
• Strong RDBMS skills and hands on experience in Oracle 8i/9i/10g and SQL Server 2012, DB2 using tools like SQL Navigator, Toad for performing SQL and PL/SQL programming.
• Complete system technical specs and documentation using Visio and the full suite of Microsoft Tools, ERwin data modeling
• Consulting For Systems Design and Implementation
• Global IT Project Management

TECHNICAL SKILLS

• SQL, PSQL, DB2, Database Management and development. Projects completed with SSIS, SSRS and SSAS - using Visual Studio current version 2012. Projects also completed with Data Manager, Datastage, and Infomatica.
• Windows Server 2012, Windows 2007 Professional, Windows Vista, Windows XP Professional/Server 2003/2008 Enterprise Windows IIS, proficient AS/400 Administration
• IBM Cognos Certified TM1 10.1.1, 9.5.1, 9.4, 8.1 Cognos 10.2.1 - Full implementations successfully completed, IBM Stack platform, Linux Configuration, InfoSphere Business Glossary and Server, TM1 Perspective, Turbo Integrator, Architect, CAFÉ, Performance Modeler
• IBM SPSS Modeler, Cognos 10.2 Planning and BI specializing in upgrading from Cognos 8 and Series 7. Cognos Enterprise Planning, Cognos Controller Cognos Metrics Manager, Cognos Finance, Cognos Report Studio, Oracle, Oracle OBIEE, SAP
• MS SQL, MicroStrategy Business Intelligence, CODA Financials, People Soft 9.0, JD Edwards, Best Fixed Assets, Jack Henry Banking Integrated with Cognos Suite, JDA I2 Demand Planning, Cincom Manufacturing
• MS Office, Real World, HMS, Peachtree, Quicken, Kronos, Informatica, Decision Stream, MS Project, Viso, IBM Clarity v7, Hyperion, Datawatch, Tableau visualization

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

Responsibilities:

• Cognos Administrator responsible for EFBI (Enterprise Financial Business Intelligence) for global company worldwide.
• SQL Server and Taradata database environments. Responsible for full BI Cognos Suite of tools including TM1 and Transformer.
• Responsible for upgrade projects, Content Store Reduction, Retirement and combination of Cognos TM1 environments. Responsible to maintain, develop and upgrade all TI Processes and schedules and all related data issues.
• Documented reports and data issues with a resolution plan - Created Framework Manager Model to accurately reflect the tables and joins for the global consolidation.
• Oracle OBIEE and Oracle EBS development with new TM1 models for the Financial Business Intelligence group. Project management and development of full software life cycle - total 8 month project finished on time and under budget.
• Ongoing responsibilities: Complete environment review for performance, documented correct configuration and deployment methodology. Upgraded Development, QA and Production to all be in sync and to have proper deployment. Decommissioned 48 active production servers while upgrading all Cognos suite software and migrated all data to new environment.

BI Consultant

Confidential, Dallas TX

Responsibilities:

• BI Project specialized in financial reporting for the Confidential . Client brought me in due to numerous failures on this project. Utilizing both my accounting skills and BI skills to accurately create BI reporting for tax reporting use. Extensive data research using SQL Server tools to determine POS data issues and tax related data issues. Documented reports and data issues with a resolution plan - Created a model in Framework Manager to accurately reflect the tables and joins for the Tax data using the existing EDW.
• Complete environment review for performance, documented correct configuration and deployment methodology. Upgraded Development, QA and Production to all be in sync and to have proper deployment.

Team Lead

Confidential, Dallas TX

Responsibilities:

• BI Inform Project - Used Enterprise Architecture techniques to design and implement a complete data warehouse using repeatable ETL processes.
• Full System documentation including technical specs and diagrams. PeopleSoft Upgrade to 9.2, SAP Implementation for Supply Chain and Accounting including Integration. SAP Supply Chain integration.
• Directed the team to upgrade the suite of Cognos tools from 8.3 to 10.1.2 including redesigning the framework models and the datamart using Oracle PLSQL and Stored Procedures. Oracle OBIEE development using TM1 control group.
• Designed and implemented IBM Cognos Reporting and Dashboards for Supply Chain VPs, IT and the Directors. Integrated with SPSS Modeler for statistic analytics, Linked directly to the JDA I2 software data and reported on it. Worked with data extraction from Ariba software and joined it with the I2 data output to create complex dashboards. In all there were 17 feed systems. CRM integration with SalesForce.
• Full implementation of IBM Cognos Suite from requirements to final delivery