Sr. Bi/dw Project Resume Profile
4.00/5 (Submit Your Rating)
SUMMARY
- Deeply experienced IT professional with 30 years of IT technical and project management skills seeking a FULL-TIME Sr. Business Intelligence Data Warehouse BI/DW Manager/Director position leveraging my most recent BI/DW technical skills including EDW Solutions and Data Architecture, Enterprise Data Warehousing, EDW management, Business Intelligence Reporting, Project/Program Management and Data Governance skills. Scrum Master Certified 9/26/14
- Experience includes Data Governance strategy IBM Infosphere , heavy technical software application full life cycle development, BI/DW Technical Project/Program Management PMI/PMBOK/WBS , Managing ETL Reports Developers, Business Analysts, hands-on applications design/development, DBA and production applications support. Current skills include hands-on SQL Server 2008, MS Project 2013, Evaluating/prototyping dashboards in Tableau, QlikSense and SiSense Cognos10, IBM Datastage 11, IBM Infosphere, SAP, Oracle 11g, Sharepoint, Power Steering/MS PM.
- Current skills focus on Enterprise Business Intelligence Data Warehousing BI/EDW data integration, BI Reporting, Visualization and strong people management skills with emphasis on Data Governance, Leading ETL /Reporting development efforts in Cognos8/10, IBM Datastage, SAP Business Objects/BW, Reporting, Database Logical/Physical data modeling and software testing, Full SDLC, Project and Program Management.
- Worked in Accenture's Business Intelligence practice as a Solutions Architect/PM as well as Fortune 500 companies including AT T, Home Depot, IBM Global Services, EDS, Georgia-Pacific, Northrop Grumman, E.I. du Pont and others. Expert problem solving/analytical skills, solid team player and strategic BI governance roadmap visionary.
- Extremely reliable IT professional dedicated to superior results and total client satisfaction. Exceptional analytical, problem solving and people skills and enjoy all aspects of Business Intelligence BI/DW, especially technical solutions and data architecture design, MDM and reporting analytics.
- Comfortable communicating across all levels of organizations ranging from business users up to CIO. Professional goals are to continue building Business Intelligence BI/DW related technology skills in EDW Strategy, Data Analytics/Governance, Solutions Architecture, Project Management and Engagement Management capabilities while providing outstanding results and professionalism to clients.
- Past DoD Secret Level security clearance - eligible for government related IT work.
Technical Skills
- Business Intelligence BI tool evaluation for Project Portfolio data management project prototyping/modeling project data and dashboards in Tableau, QlikSense and SiSense and others for Executive Leadership use. Data Analysis/modeling/preparation and prototyping in BI tools.
- MS Project 2013, PowerSteering Program/Project Management , SQL Server 2008 Management Studio, Tableau 8.2, Oracle 11g, IBM Datastage, IBM Infosphere Business Glossary/MDM, Cognos 10, Teradata 12,13 AT T , Oracle BI Publisher 10g, 11g, SAP Business Objects XI, SAP Data Integrator, MS SharePoint. Managing 3 BI/DW ETL developers and 2 Report Developers on EDW BI Team BI Data Integration projects, Technical Solution Architect, Environment: SQL Server 2012 Management Studio, IBM Infosphere Datastage, Cognos10 Report Studio/Business Insight, TM1 Cubes.
- Basecamp Agile Project Management Chick-fil-a corporate tool used for managing projects, PowerSteering Project Management, MS Project 2010.
- SAP Data Integrator 11.7 and 12.3 developing ETL jobs, regression testing, data analysis
- Hummingbird Genio ETL designing and developing data transformation/loading projects.
- MicroStrategy 9 BI Desktop/Web, Project Design, Reports, Documents, Dashboards MCD 03/10 . Project creation, Logical/Physical Data Modeling, Object Metadata management, Metrics definition. Kimball Data Warehousing design methodologies, dimensional star/snowflake schema.
- SiSense Prism and Tableau BI. Sisense Prism is a rapid deployment business intelligence tool for small and mid-sized businesses for creating your dashboards, reports and analytics.
- Cognos8, 9 Express 2 years Certified Report Authoring I, II, Cognos Series 7 Version 3 Powerplay Explorer and Report Building Cognos8 Reports Developer training , Framework and Map manager, Dimensional Data Modeling, Star Schema, Cube design and development.
- Actuate e.Reporting 7/8/9 5 years . Advanced SQL, Complex Reports Design/Development, Testing/Documentation, Trouble-shooting reports, PL/SQL ETL programming, Oracle DBA applications manager as well as development and support. Financial, Enterprise Incentive Mgt 5 years' experience .
- Oracle 8, 9x, 10g utilizing TOAD - Tool for Oracle Application Development and Query Performance Tuning, ERWin data modeling. Applications DBA in Oracle 8i/9i environment. AquaData DB query tool. Interfacing between PeopleSoft Financials and Oracle ERP Financials. 10 years' experience .
- Oracle PL/SQL, ETL Procedures, Triggers, Functions, Packages, SQL Plus, VB .NET, IIS, C , Reporting and Analysis Services, Websphere, Apache Tomcat Servers. Java VisualAge, JavaScript.
- Informatica Powermart Server Manager, ETL data modeling/design/mapping, DataStage/Ascential, Ab-Initio data ETL analysis. Data Mapping, Data Conversion/Data Architecture general design, JAD workshop sessions, Business Objects 4x Query Analysis Reporting.
- PeopleSoft - Peopletools 7/8/9, PS Application Designer, HR, SQR programming in DB2 and Oracle DB systems. Unix shell scripting in HP-UX, IBM environments. 3 years' experience .
- MS SQL Server 2005/2008, DB2/UDB, BI Reporting, Data Warehouse design, development 1 yr .
- Callidus Trucomp Enterprise Incentive Management - TrueComp 3.1, 3.7, 4.2, Datamart, TrueInformation 4.x, TruePortal 4.x, TC Configuration, Data Integration, full life-cycle implementation of Front-end Compensation Planning, Informatica ETL, and Actuate Datamart reporting backend. Trouble-ticket monitoring and resolution via Remedy, Mercury. 3 years experience .
- VB .NET, Actuate Management Security Console, ActivePortal, Websphere, DB2/UDB, Actuate Administrator Desktop, Actuate e.Reporting over Sales Commission System. Software Unit/System testing.
- SAP ABAP/4, FI/CO in Warehouse Management Systems Georgia-Pacific, Stanley Proto Tools
- Crystal Reports 8/9 reports authoring, design, development in financial accounting/telecom environment. Business Objects XI training 9/09
- Autosys - Unix Scheduler, Unix Calendar, Cron scheduler, Unix kornshell scripting, Sun Solaris
- Mercury Test Director Control-M Scheduler , IBM MVS TSO, IBM DB2
- CCC/Harvest code repository, SourceSafe, Softbench/SourceEdit edit environments, VSS code repositories
- Expert Analytical/Troubleshooting skills. Strong Telecom, Financial and Payroll/ Incentive Compensation and Telecom applications experience
Work Experience
Confidential
Position: Contract Sr. BI/DW Project/Program Manager/Technical Architect
Responsibilities
- March 2013 present Contract BI/DW Sr. Program/Project Manager/Sr. Business Analyst/BI Architect Sr. BI PM responsible for managing seven 7 BI EDW Data Integration Projects plus one major Global Trade Compliance BI/EDW Project, Chemical Sales Consolidated Reporting JDE, ROSS, SAP ERP data, Electronic Health Safety history data project. Daily/Weekly project tracking, primary business client and technical/IT communication, semi-managing three 3 ETL resources and two 2 Cognos reports developers. BI technical design/architecture design/review, Business Analysis/Data Requirements Analysis SQL Server 2008, and technical documentation, Hands-on SQL Server 2012 data queries/analysis, Cognos 10 reports design/testing, JDE, ROSS, SAP ERP FI/CO,MM,PP,SD,PM Data Integration via IBM Infosphere/DataStage to EDW Enterprise SAP BW ERP Master Data Management MDM technical data architect.
- Manage MS Project Plans, Manage Project issues and task tracking Power Steering , Daily/Weekly project status, Communication of Requirements and Status with Business/Technical staff, Technical Issues resolution, and Meeting planning/leading/coordination. Data Warehouse MDM/Integration Strategy
Confidential
Position: Contract Sr. BI/DW Project Manager/Technical Architect
Responsibilities
- Sr. Technical Project/Program Manager and Sr. Solutions/Data Architect for Data Governance Metadata Management MDM program AT T , Informatica PowerCenter SE 8x, Golden Gate, , iLOG, ActiveVOS Workflow Mgmt , CA-Repository, IBM Infosphere v8.5/7, Teradata 12x/13 over CIM Customer Info Mangement System , Oracle 11g environments AT T , Oracle Data Relationship Mgmt DRM11.1.2 . Manage DRM/ActiveVOS Project/Team
- Accomplishments: CIM Customer Information Mgmt deep-dive analysis for Data Strategy Director/Team and built Impact Checklist for the Program Mgmt Office Front Door to facilitate project impacts to CIM evaluation. Successfully gathered requirements and created Solution Approach/High-Level Design for Data Governance project working with 8 cross-functional teams. Created Solution Approach/Design for ActiveVOS Oracle DRM Hierarchy Management Workflow Integration project.
- Data Governance Initiatives: Advocated Data Governance framework/approach at Northrop Grumman DIMHRS project 2009-TDWI Maturity, Researched numerous Data Governance approaches/white papers: TDWI, HP BI Master Plan, DataFlux, Talend, Trillium, Informatica, IBM, Teradata . Sr. Solutions/Data Architect 2011-present One AT T in Alliance Data Governance for eCDW Enterprise Consolidated Data Warehouse program: DPLR Data Profile Lineage Repository projects Phase I, II Technical and Operational Metadata technical, operational, reporting/audit/compliance, data quality project to link eCDW business metadata using IBM's Information Workbench. Executed special project for Data Strategy Team analysis of Teradata tables/data analysis. Created project impact checklist for use by DS team.
Confidential
Position: Sr. BI/DW Architect/PM
Responsibilities:
- PROJECT: Develop/convert SAP Business Objects XI and Oracle OBIEE 10 BI Publisher sales/financial performance reports for Corp HQ Atlanta, GA Key Skills: SAP Data Integrator /Oracle 10g/11g, Genio ETL design/development, Oracle OBIEE, BI Publisher heavy SQL , Business Objects heavy SQL . Base Camp Agile Project Management,
- Accomplishments: Successfully converted 27 key Business Objects XI Restaurant KPI/Location Financial Comparison reports complex SQL queries ranking/percentiles, 100 pg. data templates, report bursting into Oracle BI Publisher/Oracle Answers ad hoc reports 10g for web deployment on company portal. Analysis/design/develop subset of above for Mobile sales reports in BO XI and BI Publisher.
- PROJECT: Manage/Develop automated Menu Price updating project in Genio ETL tool on team of 3 developers, 1 PM. Running SAP Data Integrator/Netweaver ETL jobs, regression testing and MDM data analysis for upgrade v11 to v12.
- Key Skills: SAP Data Integrator /Oracle 10g/11g, Genio ETL tool, Base Camp Agile PM
Accomplishments: Successfully Managed/developed ETL project to automate restaurant Menu Pricing changes previously taking 1-2 weeks to do manually now in minutes via automated process.