PROFESSIONAL EXPERIENCE:

Confidential

Software Development & Data Warehouse Project Manager & Scrum Master

Responsibilities:

• Create an Agile SCRUM Project Plan Template in MS Project that uses a Scaled agile framework (SAFe). It includes the tasks that support the benefits, principles, aspects, processes, and resources.
• Create a PMP Project Plan Template in MS Project. It includes the 10 knowledge areas: integration, scope, time, cost, quality, human resources, communications, risk, procurement, and stakeholder.
• For the above Agile SCRUM Project Plan Template and the PMP Project Plan Template, together with the Corporate Project Plan Template, create a Composite Project Plan, per the project charter and requirements. Use the Composite Project Plan for the project.
• Manage the design, software enhancements, testing, and implementation of the daily trading chart service of stocks and commodities / futures.
• Manage the data warehousing of the stocks and commodities / futures, which includes the real - time collection of the daily pricing activities, storage in a data warehouse, and the creation of investment charts from this data warehouse. It includes the master data management (MDM) of all symbols of these stocks and commodities / futures.

Confidential, Blue Ash, Ohio

On-line Banking Data Warehouse Project Manager & Scrum Master

Responsibilities:

• Coached 6 Scrum Masters in the agile methodology to satisfy the PMO requirements and their weekly project status slides for the PPM presentation as mentioned above.
• First project collects device print recognition information.
• Operate as a technical leader during the JAVA debugging development and testing process until all of the software, hardware, and infrastructure met the target on-line banking performance requirements and successfully interfaced with the on-line banking data warehouse management system.
• Tools / Languages / Databases: Iovation (an IT infrastructure product), JAVA.
• Second project perform anti-malware detection and response requirements.
• Operate as a requirements’ definitions’ leader during the requirements documentation creation process to build the Product Backlog. Ensured that the requirements included the interfaces with the on-line banking big data warehouse management system.
• Tools / Languages / Databases: IBM® Security Trusteer Rapport®, JAVA.
• For both projects, used the agile / scrum methodology to manage the sprints, product backlog, user stories, and impediments log. Groom the prioritized product backlog including the approval, estimation, and commitment of user stories. Also, demonstrate and validate the sprints prior to releasing deliverables.
• For both projects, ensure that it communicates with the banking Enterprise Big Data Warehouse management system for their Business Intelligence Reports for tracking and reporting malware occurrences on devices and their customers.
• Tools / Languages / Databases: MS Project, MS Office Suite, Planview Enterprise version 11.4, SharePoint.

Confidential, Blue Ash, Ohio

ATM Banking Data Warehouse & Business Intelligence Project Manager

Responsibilities:

• For the budget of $1.9 million, using a waterfall methodology, manage the entire SDLC for a Global ATM software/hardware project. First target country was Singapore.
• Project management tasks includes the creation and maintenance of the MS Project Plan, Milestone charts, Weekly Status Slides; and conducting team meetings, including Business Analysts, Developers, and Testers.
• Besides the PM role, operate as a Test Manager during the creation of the Test Plan document and the Test Cases’ Scenarios document.
• Coordinate efforts to create these two documents among the Business Analysts, Developers, and Testers.
• For ATM project, ensure that the ATM software communicates with the banking Enterprise Big Data Warehouse management system for their Business Intelligence Reports for all of the ATM functions.
• Tools / Languages / Databases: MS Project, MS Office Suite, Planview Enterprise version 11.4, SharePoint.

Confidential, Marlborough, Massachusetts

Enterprise Data Warehouse Project Manager

Responsibilities:

• For this retail giant, Confidential, took over an EDW project, picking up the torch, from the prior PM which chose to make a career path change.
• The goal of the EDW project was to consolidate the data from all of the merged / acquired retail companies within Confidential: T.J. Maxx, Marshalls, HomeGoods, Sierra Trading Post, Winners, HomeSense, and T.K. Maxx. It also includes the maintenance and management of the retails’ master data. (MDM)
• Monitor the issues and risks list and upgrade it to in corporate work effort estimate columns, update then by the team members. Team members includes data architects and ETL developers.
• Monitor QA team’s status on their test of the ODS and ADL for the respective source data streams.
• Work on the transition of the production cut-over ready work data streams to be monitored and corrected by the production support staff.
• Ensure Operational Data Store was successfully update with accurate data for their analytical reporting requirements for Tableau.
• Tools / Languages / Databases: MS Project, MS Office Suite, IBM WebSphere Datastage, Oracle, TOAD, Netezza, Tableau.

Confidential, Wilmington, Ohio

Web Design & Data Warehouse Project Manager

Responsibilities:

• Manage the creation of the web site, http://www. Confidential .com. There are 2 sub-web sites. One is for Project Management and the other is for a daily trading chart service of stocks and commodities / futures that have options.
• On the left of the main web site is the selection of Project Management. When a user clicks on it, it will pop up the Project Management web page. On this web page, when a user scrolls down to the bottom and clicks to view a 5 minute video, then the user will learn some powerful Project Management techniques.

Confidential, Peoria, Illinois

SAP / ERP & Enterprise Data Warehouse & Business Intelligence Project Manager / Data Leader

Responsibilities:

• For the SAP / ERP testing of the work streams, in their PMO office area: R2Report, E2R, OTC, Procure2Pay, Plan2Produce, Project & Assets, work on multiple projects often at the same time, for the various sites: Perkins Shibaura Engines, East Peoria, and various permutations of East Peoria, such as non-OTD, Release 4.2 ISS (Industrial Strength System), and Dual Maintenance. Work on various Mock Testing phases such as Mock 0, Mock 1, FDR (Full Dress Rehearsal), Cut-over into Production. This effort was all part of the merger and acquisition of various disparate manufacturers, including the acquisition of the Perkins Shibaura Engines.
• Monitor and manage, within their Lotus Notes ‘War Room’, the data load sequence schedule, using the site’s phase respective DLS (Data Load Sequence Diagram) and their related Project Plan containing their resources’ list. Ensure Predecessors were complete first, before successor loads.
• Tools / Languages / Databases: IBM Websphere Datastage, SAP / ERP, MS Project, MS Office Suite, Visio, HP Quality Center (HP QC / Mercury tool).

Confidential, Evansville, Indiana

Data Warehouse & Business Intelligence Project Manager

Responsibilities:

• With the separation of the company Confidential from Bristol-Myers Squibb, the goal was to separate all systems and data tied together between Bristol-Myers Squibb and Confidential .
• Became the first PM in their new PMO office, manage the software development, testing, and implementation of their ‘Business Intelligence Reporting and Analytics Global Data Warehouse management system’ using agile (SCRUM) methodology. Using single month sprints with target deliverables, daily frequency meetings were conduct to discuss progress, identify roadblocks, improve communications, and motivate individuals, and promote team work between all stakeholders. Deliverables occur by the end of each sprint, while managing the project budget. Complete the 2.65 million budgeted projects on time and $100k under budget. Planning for the next sprint was done by the end of each sprint with stakeholders’ participation.
• Tools / Languages / Databases: IBM Websphere Datastage, MS Project, MS Office Suite.

Confidential, Carmel, Indiana

Data Warehouse Project Manager

Responsibilities:

• Being one of their multiple PMs in their PMO office, manage their on-line Data Warehouse management system / Business Intelligence Project, Document Management Project using SharePoint, and the Dialer Improvements Project using agile (SCRUM) methodology.
• Tools / Languages / Databases: MS Project, MS Office Suite.

Confidential, Jersey City, NJ

ETL Developer & Data Warehouse Project Manager

Responsibilities:

• For Confidential, work as a Data Warehouse ETL Developer / Data Warehouse Project Manager in a very flat organizational structure for 2 projects from start to implementation, both at the same time. For an active global data warehouse, replace existing data feeds and data conversions with new ones, for their data subject areas: project 1: futures, options, over-the-counter trades (OTC), and project 2: Mortgages and Loans, to be populate into the IBM DB2 EDW using ETI*Extract.
• Tools / Languages / Databases: ETI*Extract, SQL, COBOL, DB2, OS/MVS JCL, Windows Commander, Visio, MS Office Suite.

Confidential, Dayton, Ohio

Data Warehouse & Business Intelligence Project Manager

Responsibilities:

• For Confidential, a retail POS provider, using the ‘Onsite-Offshore’ model, manage multiple projects at the same time with off-shore developers in India, using agile (SCRUM) methodology, and other team members’ onsite. The goal of all of the projects is to enhance their Enterprise Data Warehouse (EDW) to meet the needs of the corporate financial department and its goal of gaining complete confidence in the data within the EDW, its ability to match GL, and provide the ability to report by lines of business, such as retail, travel, gaming, and hospitality, banking, etc. The data warehouse is Teradata.
• Tools / Languages / Databases: Teradata, MS Project, MS Office Suite.

Confidential, Cincinnati, Ohio

E-Commerce Web, Data Warehouse Project Manager / Business Intelligence Architect & Developer

Responsibilities:

• For a merger and acquisition activity of Confidential with Cynergy, for their online Intranet Portal, participate as an ASP Web page developer and Cognos Impromptu Administrator in the redefinition of the General Ledger accounting fields in their web screens, reports, and ETL software. For ETL, create DTS packages within MS SQL Server. For these same web screens and reports, modify MS FrontPage ASP web pages including visual basic scripts, java scripts, html, and called stored procedures of SQL logic create within MS SQL Server. For other web screens and reports of their online Intranet Portal, recreate Impromptu catalogs and Impromptu reports. For all approve changes from the change management team, update design documents, create test documents, and approval documents.
• Tools / Languages / Databases: MS FrontPage, Visual Basic, Java, HTML, SQL, Stored Procedures, MS SQL Server

Confidential, Buffalo, NY

Enterprise Data Warehouse Project Manager, Business Intelligence Architect, & Developer

Responsibilities:

• Return to this client to work on the creation of their Marketing Analysis EDW.
• Research all IBM mainframe data source feeds and complete all data mapping to Marketing Analysis EDW worksheet specifications. To handle change data capture of source data, update and test template JCL and COBOL code.
• Tools / Languages / Databases: IBM Mainframe, COBOL, OS/MVS JCL, VSAM, MS Office Suite.

Confidential, Wilmington, Ohio

Data Warehouse Project Manager / Data Architect & Developer

Responsibilities:

• Help start-up a construction company for new construction and remodeling needs of clients. Obtain specific data to populate a construction contacts’ database, coach the creation and process usage of marketing phone scripts and letters. Ensure construction staff had all tools and supplies necessary to perform construction work. Ensure quotes were properly calculated for presentation to client. Ensure payroll, accounts receivable, and accounts payable system components were perform.
• Tools / Languages / Databases: MS Excel, MS Word, Classic Phone Tools, MS Media Player, QuickBooks.

Confidential

Data Warehouse Project Manager / Data Architect & Developer

Responsibilities:

• Achieve improved profit margins for a large rabbit and beef cattle breeder in Saskatchewan province of Canada.
• Create a data entry, data model, calculations and reporting system for tracking breeding processes to enable optimum continuous breeding while still monitoring health of babies, does (mothers), breeding males (fathers), and new does/calves.
• Tools / Languages / Databases: MS Excel, MS Word.

Confidential, Buffalo, NY

Enterprise Data Warehouse Project Manager / Business Intelligence Architect & Developer

Responsibilities:

• Perform Data Conversion efforts for Confidential, a global bank, required by a data warehouse management system project, using an ETL tool called ETI*Extract, wherein mainframe batch interface programs were created for this purpose.
• Create mapping worksheets by using Erwin data modeling tool to import entities’ attributes into data conversion specifications for mapping data from source files to target DB2 tables, and then in corporate necessary logic into these mapping worksheets.
• Tools / Languages / Databases: ETI*Extract, MS Excel, MS Word, MS Project, Erwin, COBOL, DB2.

Confidential, Dallas, Texas & Southwestern Ohio

Data Warehouse Project Manager / Business Intelligence Architect

Responsibilities:

• Design, create, and populate a Sales & Marketing data warehouse for Y2Marketing projects, including Prospective Customer Relationship Management (CRM) and Advertising Reviews.
• Design and create a generic Project Plan and Contracting Proposal specifically for the creation of CRM systems for prospective clients.
• Tools / Languages / Databases: MS FoxPro, MS Excel, MS Word, MS Project, MS PowerPoint.