SUMMARY:

Extensive experience in design and development of Data Warehousing, BI and CRM systems. Recognized for delivering systems that far exceed expectations within agreed upon timeframes and budgets. An experienced negotiator, team builder and role model.

AREAS OF EXPERTISE:

Data Warehouse: Full SDLC support from Requirements gathering, Architecture, Design, Development, Testing and Implementation.

Business Intelligence: KPI/Measures definition, OLAP cube design, Dash Boarding.

Data Mining/Analysis: Data Profiling, Data Integrity.

Project Management: Create/Manage WBS, Change Control, Risk Management, Budget, Onshore/Offshore experience.

CRM: Campaign Management supporting retention, acquisition, up sell/cross sell.

Actionable Results: Out of the box functionality giving instant ROI.

TECHNOLOGIES:

Databases: SQL Server 2012, Oracle 10g, Sybase, Informix, DB2, Access, Teradata, Greenplum, Netezza

ETL: Informatica, SSIS

Data Mining: SSPS(Clementine)

Business Intelligence: PowerBI, Tableau, SSMS, SSAS, SSRS, Cognos, Brio, Siebel Analytics, Microstrategy, Business Objects

Operating Systems: Windows, Unix, Solaris, OS/MVS

Tools: /Languages: SQL, Toad, Erwin, Epiphany, Shell, HTML, XML, Cobol, C, SAS, Webtrends, Fidler, HTTP Analyzer, Jira, Confidential Dynamics Marketing

PROFESSIONAL EXPERIENCE:

Confidential

Technical Project Manager

Responsibilities:

• Quickly came up to speed on using Confidential Dynamics CRM to test and deliver a POC within a very short time frame.
• Fleshed out organizational workflow using Visio and documented usage of Dynamics CRM screen input fields and definitions.
• Exploratory work with Confidential Dynamics Marketing to determine whether an existing marketing process can be used to showcase this product and in doing so would there be gains in user efficiencies. Examining features of the product by doing research and creating sample workflows.
• Looked into integration with other tools such as Marketo (Marketing Workflow Automation) to investigate what extended capabilities exist.
• The goal of the project was to initially flesh out a roadmap documenting the current and proposed architecture for Demand Planning of the Supply Chain Management Pipeline.
• This effort involved source data analysis, KPI/metrics definition, gathering of business requirements and DW schema design.
• Deliverables were a roadmap to implement proposed features with associated costs and a source to target mapping document for the initial phase.
• Supported CRM Campaign Management data collection and reporting in SAP HANA HEC (Analytic Cloud Environment).
• Maintained data integrity by querying data looking for anomalies, gathered requirements ( Confidential ) for new Business Objects reports and validated report output prior to deployment.

Confidential

BI Architect/PM

Responsibilities:

• Designed and built a rules engine to systematically generate address book titles in the Global Address Book for Outlook.
• The HR Taxonomy Project was to gain better insight into where resources were geographically and what function they fulfilled.
• Once the rules engine was built and deployed an Audit process was built to check/monitor compliance of the rules.
• Exceptions to the audit process were flagged for updates or automatically changed by the process.
• Worked on a concurrent project for the SSO organization within MSIT to build an application using Power BI for reporting and analysis.

Confidential

Web Analytic PM

Responsibilities:

• Responsible for defining and maintaining the clickstream metrics for att.com Support, Search, Forum and Video player components.
• Based on business requirements specified the Webtrends tagging ( Confidential ) for the data to be collected to support defined metrics.
• Queried/analyzed data to define what the target structure should be based on expected utilization.
• Project managed the implementation of new data into the data warehouse using Informatica and front end tool Business Objects.
• Worked on a POC of Tableau to determine the feasibility of integrating the product into the current reporting environment.

Confidential

BI Program Manager

Responsibilities:

• Responsible for establishing a framework for a consolidated Operations Portal to view infrastructure data in support of the MS Online site.
• The queried data reported on was revenue, orders and application response rates for various integration points.
• A second project was to evaluate a solution for replacing the current Content Management System (CMS).
• The evaluation led to a proposed re - architecture ( Confidential ) of CMS with a recommendation to establish a CMS Ecosystem where systems of record are identified and an overall scalable/sustainable environment can be defined and supported.

Confidential

Technical Project Manager

Responsibilities:

• Responsible for implementing an MPP/BI hardware platform for a large telecom company.
• Developed and maintained the timeline, managed subcontracted vendor, wrote high-level architecture document.
• For the BI aspect of the project, wrote the Statement of Work, co-authored the Business Requirements document and developed the timeline.
• BI project was to identify churners regarding social networking within a calling network of friends.
• Began work on a best practices CRM implementation by performing data analysis on existing data and their sources.

Confidential

Responsibilities:

• Develop and maintained a reporting mechanism for weekly/monthly reporting of web traffic and revenue for the numerous partnership offerings using the Bing “search toolbar”.
• Collect and analyze data (cube, Omniture, Cosmos), define new reporting requirements and QA data.
• The tool developed helped to increase productivity and accuracy of data within the workgroup and beyond doing so with minimal manual intervention.

Confidential

Project Manager

Responsibilities:

• Responsible for developing a strategy roadmap and implementing it as a solution for the Radio Frequency Forecast group.
• The group’s function was to forecast cellular network growth based on usage.
• This forecast projects equipment needed resulting in a budget.
• The end goal was to produce a more accurate forecast and improve the forecasting turn around time.
• To support this effort, it required standardizing on corporate sources of data, eliminating local databases, construction of a data warehouse (requirements gathering, architecture, design, testing ( Confidential, automating and systematizing the existing manual processes in the initial phase.
• Monthly Excel Dashboards were created to monitor the trending and accuracy of the forecast and budget.
• Business case annual savings were projected to be $100M (million) per year.

Confidential

Project Manager

Responsibilities:

• Involved in the design and development of an interim data warehouse solution for a Worldwide Sales and Quota reporting system.
• The application reported on revenue and sales attainment data sourced from several systems.
• The application was a series of Dashboards in Excel that extracted worldwide sales and quota from upstream databases which were the systems of record.
• Responsible for the functional design of a data warehouse and CRM (Epiphany) system that supports consumer campaign management.
• These systems were used primarily for retention and acquisition of consumers. Specific duties were to gather requirements, create data models, wrote technical specifications, UAT and project manage the process.
• Managed onshore/offshore resources.
• Responsible for the functional design, prototyping and UAT for a data warehouse system that supports business campaign management.
• This system was used as the source data for Siebel Analytics reporting to report on product registrations, survey responses, and event registrations.
• Managed onshore/offshore resources.

Confidential

Data Warehouse Project Manager

Responsibilities:

• Responsibilities are to support the Corporate Travel and Lodging lines of business.
• Duties were to assess and analyze business requirements; system impacts, system requirements and project manage the development effort.

Confidential

Project Manager

Responsibilities:

• Project Manager for the design and implementation of a Health Care data warehouse.
• The data warehouse collects data from numerous health care facilities in varying formats and then standardizes the data into a common format.
• The data is then edited and loaded into the data warehouse.
• Clients have web access to process their data as well as check on the status and view Data Quality reports.
• The data warehouse uses Informix, Informatica and the .net platform.

Confidential

Data Warehouse Manager

Responsibilities:

• Project Manager of Data Warehousing, initial responsibilities were to design and implement a web click stream data warehouse to support one to one targeted marketing.
• Developed and managed the timeline, wrote deign and tagging requirements document, participated in the Logical Data Model design, wrote the test plan/cases, status reporting, vendor management, budgeting, change control.
• Since implementation, responsibilities have been to develop and maintain ETL mappings, maintain the integrity of the data warehouse, develop and maintain Cognos OLAP cubes and Dashboards.
• Additional responsibilities have been to educate Sales and Marketing on the strategic value that can be gained by using the data within the data warehouse.
• The data warehouse was implemented using Informatica (ETL), Oracle 8i in a star schema design and Cognos (reporting).

Confidential

Marketing Data Warehouse Manager

Responsibilities:

• As Marketing Database Manager for Worldnet Internet Services, built and maintained the marketing DSS for reporting and data mining activities.
• Introduced OLAP and data mining technologies to the organization to improve effectiveness of marketing managers, executives, and other key decision makers.
• CRM capabilities (i.e. segmentation by demographics, profitable customers) were provided to Marketing, Advertising and the Customer Care organization.
• Integrated overlay data (i.e. Confidential ) to enhance the internal data.
• Environment consisted of Unix, Oracle, Brio Query (OLAP) and Clementine (data mining).
• Authored requirements document and reviewed it with stakeholders, developed and managed the timeline, created the testplan/cases, managed the budget, vendor negotiation, gave in-house training, client organization liaison (SME), change control.