SUMMARY

BI strategist, administrator, with over 15 years of extensive experience in Business Intelligence technologies, such as SAP BI, MicroStraegy, Tableau, Qlikview, Cognos. Supported clients in pharmaceutical, consumer product goods, retail sales, marketing, financial services, and government, automotive fleet management. Past Experience includes: program management, project management, request for proposals, statement of work, requirements gathering, design, data modeling, development, testing and subject matter insight on life sciences, and consumer packaged goods.

EXPERIENCE

Confidential

Director of Business Intelligence

• Fostered relationships with key strategic partners within the Business and IT community.
• Participated in development and execution of strategic plans.
• Provided program management oversight and delivery in a P L environment.
• Evaluated, implementation and deployment of technology focused around Business Intelligence.
• Worked collaboratively with the business operations, business development, VPs and CXOs to craft innovative solutions to address current IT needs and new opportunities in the marketplace.
• Drove policies and procedures that monitor and support the organization's portfolio of projects to meet operational and financial business objectives.
• Responsible for the creation, and enforcement of program quality controls including governance, metrics and reporting, and issue/risk management.
• Participated in planning sessions with business and technology leaders to better understand project objectives and ensure proper planning and processes are in place to achieve business objectives along with overall strategy.
• Provided ad hoc project/program management support to senior CXO leadership.
• Developed and managed strategic plans and projects/initiatives for the business.
• Coordinated with business, technology, finance, operations and HR as required.
• Responsible for evaluating and analyzing key business decisions and working with senior management to determine the recommended strategy meets the business challenges while minimizing risk to the business and overall organization.
• Involved in new hires, training, coaching, counseling, and evaluating performance of direct reports.
• Reporting to VP of Technology.

Confidential

Business Intelligence IT Strategist

• Instrumental in developing the strategic SAP BI solution and roadmaps to retain PHH business as a Fleet industry leader in innovative consulting to its clients.
• Actively involved in vendor selection, vendor management and evaluation of service level agreements.
• Worked with VP of Customer Experience, and CIO to envision a Business Center of Excellence, along with a 3-year rollout plan based on various vendor evaluations of what is the best Business Intelligence and visual platform of choice for current needs.
• Developed overall strategic data provisioning direction to provide a comprehensive road map for the corporate data requirements.
• Instituted best practices, and standards with regard to Master Data, Meta Data, Data Quality, and Data Governance.
• Involved in all levels of vendor negotiation from price, licensing, training and support to ensure an optimal purchase that meets the business and budgetary needs of the organization. Successful in a purchase of 3 Million in sales and service for the initial roll out.
• Post strategic plan and purchase, helped with the implementation planning details and facilitating to ensure best practices were being followed, and appropriate resources, both onsite and off shore were appointed.
• Acted as liaison between the business users and the project team to ensure the users requirements are understood and interpreted correctly per vision.
• Identified resource needs based on relevant roles and responsibilities and negotiated with third party-agencies to ensure proper skill sets were hired.
• Recommended in-memory database technologies such as SAP HANA along with SAP BI, Dashboards and Predictive Analysis.

Confidential

Senior Manager, SAP Operational Reporting Genesis Consulting Partners

• Instrumental in developing the strategic SAP BI solution and roadmaps to achieve FAS at USDA's current and future objectives, which entailed the introduction of SAP HANA into their existing ECC environment running SAP BW.
• Responsible for managing scope, requirements, analysis as well as road map for deploying SAP Business Objects for the office of the Chief Operating Officer in collaboration with the Office of the Chief Financial Officer, planning out the vision of reporting and dashboards along with the integration of multiple SAP and non-SAP sources into SAP HANA as the end goal.
• Involved in full life cycle planning of the functional and technical implementation of SAP Business Objects including Dashboards, Web Intelligence, Data Universes, Crystal Reports, SAP BW and the Data Services suite.
• Involved in identify skill set requirements and roles and responsibilities in order to build out the project team
• Identified resource needs and negotiated with third party-agencies to ensure proper skillsets were hired.
• Assign and monitor work of technical personnel, ensuring that project steps are in alignment with business objectives, on-time and within budget
• Established relationships within the matrixed team, and addressed conflict resolution in order to remain on track for deliverables.

Confidential

Senior Manager, Business Intelligence -National Data Warehouse Program Center for Medicare and Medicaid

• Directed the design, development, maintenance and support of BI solutions that meet business needs in a matrix-managed organization
• Managed the day-to-day production support for all NDW application, including managing entire teams consisting of project managers, business/systems analysts, architects, and application developers, team sizes of 10-40 individuals.
• Mentored staff, approve timesheets, manage to budget.
• Attended Weekly PM/Finance meetings to review on track budget and assess EVM.
• Maintain weekly status, adjust resource staffing per overall lifecycle requirements and budgetary needs in consultation with PMO.
• Responsible of developing of BI roadmaps to achieve current and future reporting needs
• Communicate and set expectations for program deliverables by senior stakeholders and program team.
• Monthly review Program risks and issues ensuring processes are in place to mitigate any risks.
• Provide direction and leadership regarding business system solution planning, systems analysis, systems design, database modeling, systems testing, and training.
• Ensure the use of best practices for application and data warehouse design, configuration, integration, programming, data, testing, change control and release management.
• Supported second and third level application support and application enhancement delivery to agreed upon SLAs and metrics
• Involved in all aspects of SDLC with on time, on budget deliverables. Helped resolve road blocks along the SDLC.
• Led Business Process Improvements throughout the program to increase efficiency, cut costs, improve morale.
• Focused to recruit, develop, retain and motivate teams operating at a high performance level
• Conducted new hire interviews as well as performance reviews.
• Mentored and assisted Testing, Training Teams on impact of BI role out

Confidential

Business Intelligence SME, Life Sciences

• Performed analysis using IMS data DDD wholesale distribution and sale
• Provided recommendations for optimal business intelligence design
• Suggested best practices for a pharma sales data ad hoc BI environment.

Confidential

Consulting Manager, East Region Life Sciences

• Involved in all aspects of project management, resource planning, requirements gathering, project tracking and project costing.
• Participated in pre-sales activities including business needs analysis and proposal development
• Assisted Client Partner in closure of SOW and services delivery.

Pharmaceuticals

• Engaged in the design and development of a business intelligence framework for Shire's financial business initiative framework, which included areas of Governance, Testing, User Needs, Universe Design, Data Model, Data Integration, Master Data Management, Data Validation, ETL, Reporting Analysis, Tools used, and Security and Training.
• Conducted a health check on client's Commercial Business Objects Universe to ensure best practices and to highlight any major concerns in regards to universe design.

CRO Clinical Trials

• Responsible for the delivery of a Clinical Operations Analytics Dashboard, queries, universe and reports.
• Provided overall strategy for the design and delivery of a dimensional data mart and Xcelsius Dashboards using best practices.
• Assisted in Universe Design Build, and Migration of universes among multiple environments, development, test..
• Managed in planning, design and build of an Investigator database that would load Investigator, site and trial data from Genesis / Investigator Surveys, IVRS, Trial Tracker, and CLS source systems.
• Managed and coordinated for a DQ/DI Demo with actual client data sources.
• Assessed number of data sources, quality of data, data definitions and commitment to what fields shall be incorporated into deliverable.
• Managed resource utilization
• Provided weekly team status, as well as management status reports.
• Documented User requirements and technical specifications.

Confidential

Business Intelligence Project Lead

• Prepared work plans, staffing plans, and estimates for application design and implementations
• Facilitated requirements gathering sessions for new initiatives with business clients.
• Formulated recommendations for process improvements
• Worked with backend ETL team to understand Informatica mappings for any new requests.
• Involved in Microstrategy Architecture of new development requests.
• Worked closely with the various client RM teams to implement best practices as defined by the clients' requirements. As well as with Wyeth SAP teams in the support of the enterprise solution for data warehousing.
• Translated functional / business requirements into technical solutions and set priorities for implementation.
• Developed strong relationships with IS staff in other Wyeth divisions
• Set User expectations for project deliverables.
• Contributed to governance of the all Data Warehouse center standards.
• Managed consultants to ensure internal best practices and standards are adhered.
• Provided guidance to project team members, managing problem resolution for successful and timely implementation
• Worked in collaboration with Siebel Analytics for Wyeth Planning / forecasting needs, incorporating all forecasts into SRS.
• Accommodated Wal-Mart's new business processes to reduce inventory-carrying costs at its distribution centers.
• Subject Matter Expert for Wal-Mart Canada Project

WCH ERP Global SAP Implementation

• Involved in the upgrade to the new Wyeth global model and enabled low touch/ no touch order processing.
• Ensured resulted in minimal disruption to divisional analytics and key business metrics within Sales Reporting System SRS .
• Wal-Mart POS Upgrade - POS Data Warehouse, used by the Wal-Mart team to support the Category Development and Sales organizations contributing to the Replenishment, Demand Planning, Marketing, and Business Research organizations in a self service method of operation. Wal-Mart's new business processes to reduce inventory-carrying costs at its distribution centers.
• Worked in providing a daily snapshot of store POS/inventory to make timely, accurate store level forecasts.
• Upgraded in order to provide the daily information required for the WCH business teams as current system was designed to report with time snapshots at the weekly level

Confidential

Microstrategy Project Lead Architect

• Knowledge of data modeling methodologies star schema, OLTP, etc.
• Translated reporting requirements into logical data models
• Managed as well as advised Microstrategy developers and architects on how to restructure their current IAR Inventory Activity Reporting project.
• Designed both functional and technical specifications

Confidential

Senior Consultant

• Assisted Wells Fargo Bank's Internet Services Group in enhancing their Teradata data mart C2T to provide a more comprehensive consumer data picture.
• Worked with the business units to define and deliver on their reporting requirements,
• Understood the data and its complex relationships. Performed GAP Analysis.
• Trained super-users in ad-hoc report creation

Confidential

Technology Consultant

• Responsible for internal support of pre- and post-sales initiatives.
• Assist with lead generation by conducting research using Hoovers Online data, help update pertinent leads into Goldmine software for effective sales.

Vendor Management

• Acted as the primary interface between the executive team and vendor for the corporate website redesign.
• Involved as Project Manager for pre and post vendor selection for website initiative.
• Communicated all vendors dealings in regards project status, and of any issues that may arise to Management
• Responsible for communicating the roles and responsibilities to the developers involved
• Updated the decision makers of any issues or costs that arose for the initial rollout of the website.

Confidential

Production Consultant

• Responsible for managing full life cycle SDLC, both long-and short-term to ensure project goals and objectives are met.
• Involved in design, implementation, and management of the project. Proactive contribution of insights and ideas to the Consulting and Technology bases, leveraging of the existing corporate knowledge across engagements, and driving the MicroStrategy's product and consulting strategies through product feedback, testing, and competitive bench marking.

Confidential

Consultant for various start ups.

Worked closely with the Chief Operating Officer as well as assisted in setting up the internal company-training site.

EDS/GM Canada:

• Involved in the successful delivery of an order tracking application for coordination between the distributors and suppliers for auto parts.
• Designed user interface by gathering customer requirements.
• Learned the Ptech product, Framework, used for Integrated Business modeling strategic planning, enterprise modeling, process modeling, business analysis, knowledge capital capturing and automation for training users.

TECHNICAL

• SKILLS Systems /DB /Applications: Oracle, NCR Teradata, SQL Server, Tableau, Qlikview, SAP HANA, SAP ECC 6.0, SAP BI, Sybase ASE, Sybase IQ, Nettezza, IMS Health, Vision Chain 3.2 , Orchestro.
• Methodologies: UML Rational Rose , Data warehousing, Dimensional Data modeling, DSS, OLAP, ROLAP DSS/: RDBMS, Web, Client/ Server, CRM applications. Lean Six Sigma Training. Agile, Waterfall
• Certifications: Kalido DIW Version 8 Certification SAP BW Navigation