We provide IT Staff Augmentation Services!

Data Warehouse Program Management Consultant Resume

5.00/5 (Submit Your Rating)

FL

PROFESSIONAL SUMMARY:

  • 17 Yrs of strong Program / Project Management experience with Global Delivery Model, Customer Relations Management, Program / Project Planning, System Analysis, System Design, Data Modeling, Database Design, Data Warehouse Design and Build, Business Intelligence, Analytics Solutions, System Performance and Tuning, Software Development, Documentation, Delivery and Implementation.
  • Exceptional organizational ability, communication skills, analytical problem solving skills, ability to facilitate discussions and conflict resolution.
  • Provides senior level resolution to internal client issues.
  • 17 Yrs Program / Project Management
  • 6 Yrs Agile Program / Project Management

TECHNICAL SUMMARY:

Platforms: Windows 7 Windows XP, UNIX IBM Mainframes

Database: SQL Server Oracle 11g

Programming: .NET XML, ASP.NET Visual Basic, Java COM, PL/SQL COBOL

Software & Tools: Guidewire Rally, Daptiv PPM MS Project Server 2007, Agile/Scrum Methodology Primavera P6, JAD SDLC, MS SharePoint MS Office Suite 2007, Visio Professional Xcelsius, Business Objects Enterprise XI R2, Summit - PM PRISM, ERWIN/ERX Rational Rose, UML RUP Designer2000 Waterfall Methodology, JIRA Visual SourceSafe, HP ALM Planview

PROFESSIONAL EXPERIENCE

Confidential, FL

Data Warehouse Program Management Consultant

Responsibilities:

  • Developing and implementing the delivery strategy and plans, forecasting, budgeting and capacity planning.
  • Communicating key performance information at the c-level executives in the organization.
  • Defining and creating overall data management and data warehouse strategy that takes advantage of Guidewire software and business process environment.
  • Directing and Integrating the Guidewire products for the Billing Center, Claims Center, Policy Center, and Contact manager for the data warehouse program.
  • Directing the planning, design, development, testing, production deployment and management of Data Warehouse program using Agile/Scrum methodology
  • Created the integrated program plan in the Rally for sprint wise tracking of the program progress.
  • Created the Change Management Strategy for Data Warehouse which included Benefits Realization, Communications Strategy, HR Strategy, Process Documentation Strategy, Quality Assurance Strategy, Training Strategy, and Transition Management Strategy as part of the Organizational Change Management Strategy.
  • Conducting the Agile planning meetings including sprint planning, and program planning, daily stand-ups, reviews and retrospectives. Tracked and communicated team velocity, and sprint progress.
  • Full life cycle Project Management of Data Warehouse projects.
  • Analyze and improve the data warehousing reporting and business analytics for Accounting, Actuarial, Claims, Consumer and Agent Services, and Underwriting business operations.

Confidential, IL

Program Manager

Responsibilities:

  • Created business cases to plan the programs/projects on an agreed and achievable set of business objectives.
  • Directed the planning, design, development, testing, production deployment and management of Data Warehouse projects using Agile/Scrum, and waterfall approach
  • Conducted Agile planning meetings including sprint planning, and program planning, daily stand-ups, reviews and retrospectives. Tracked and communicated team velocity, and sprint progress. Communicated key performance information at the organization level.
  • Developed and implemented the delivery strategy and plans, forecasting, budgeting and capacity planning.
  • Managed and executed Encompass R&A Program - The program was executed using agile methodology. The program implementation achieved the following goals - Reliable information to the users with better quality of the data; increased user satisfaction with dashboard and reports; reduced time to implement changes to reports and dashboards; flexible data ware house design will allow additional functionality for future growth; reduce the current business cost of different departments sourcing their own data; intuitive visualization allow better insights and decision making; easier access to dashboard, reports, and analytics.
  • Managed and executed Integrated Dimensional Model Program using agile methodology - Achieved advanced analytic and business intelligence inquiries in a timelier manner with greater self-service capability. The program implementation established the key performance indicators and metrics those are been leveraged across Confidential protection; it created an integrated set of data structures for faster and more accurate insights through advanced analytics and business intelligence solution; it provided greater self service capability permitting more time to be spent on the analysis rather than data collection.
  • Managed and executed Premium Refund Audit Migration to ADW - Achieved objectives of reducing mainframe MIPS usage and annual computer related expenses, reduce the overall time taken to code and execute audits, move the execution of audits from legacy mainframe platform to a client server environment. The project implementation reduced cost by $8.2 million annually, and processing time by 83 days for each corrective action project.
  • Managed and executed the Confidential Drive Wise project - Confidential partnered with a vendor to provide the Telematics device. Focus of the program was on safety and savings. Telematics based insurance offering that benefits both customers and Confidential through insurance discounts and improved pricing sophistication. The vendor managed to get data from vehicle to Confidential and Confidential is responsible for warehousing data and data analysis. Several Telematics features are provided to the customers including - Event Alerts, Monitoring of driving behavior, online reports and recommendations, etc.
  • A separate website is created to cater the needs of the Telematics customers of the Confidential .
  • Managed and executed Commercial Dashboard project - Developed a dashboard using business objects for New business, and quotes for current term and prior term to provide on-line analysis to field managers to monitor activity by agent, rolling up to the market, regional, territorial and countrywide levels
  • Managed and executed Property Inspection Reporting project - Migration of the property service data into the Confidential corp data warehouse and developing ad hoc reporting tools using the business objects. This effort saved $465K annually for the property service business area.
  • Interacted with business stakeholders, project architects, subject-matter experts, vendors and multiple functional teams/groups to identify, document, resolve and plan application and project related Risks, Issues and Change Management.
  • Prepared program plans and budgets, scheduled, monitored, tracked and prioritized tasks to meet milestones and deliverables.
  • Prepared program documentation for the program agreement, program definition report, business systems analysis reports during program definition and analysis phases.
  • Implemented quality standards, processes and guidelines to evaluate program performance and effective and successful deliveries of the projects and programs.
  • Planned, directed, supervised, and controlled project management resources. Assigned responsibilities to execute project plans to project managers and assesses how to best utilize their qualifications and strengths
  • Monitored and reported to senior management on the progress of Confidential key projects, including significant milestones, project financial indicators, and conditions/risks which could negatively impact project cost, scope, and/ or schedule
  • Created and implemented PMO rules, policies, and procedures based on recognized industry standards
  • Promoted project management excellence as well as the implementation of the best Project Management Practices at Confidential .
  • Developed and conducted multi-disciplinary business reviews to monitor progress, measure success, evaluate departmental efficiencies and recommend corrective initiatives where required
  • Created the Change Management Plan which included, Communications Plan, Quality Assurance Plan, Training Plan, and Transition Management Plan.

Confidential, MI

Project Manager

Responsibilities:

  • Directed the planning, design, production and management of online publishing applications for online services using Agile/Scrum.
  • Conducted Agile planning meetings, daily stand-ups, reviews and retrospectives.
  • Created and presented the forecasting, budgeting and capacity planning.
  • Created detailed project plan to launch OpenURL project upgrade and Counter/Usage compliance.
  • Met regularly with interdepartmental work group to monitor and evaluate the portal, discuss policy issues and recommend service improvements.
  • Interacted with business stakeholders, project architects, subject-matter experts, vendors and multiple functional teams/groups to identify, document, resolve and plan application and project related Risks, Issues and Change Management.
  • Prepared project plans and budgets, scheduling, monitored, tracked and prioritized tasks to meet milestones and deliverables.
  • Prepared project documentation for the project agreement, project definition report, business systems analysis reports during project definition and analysis phases.
  • Implemented quality standards and guidelines to evaluate project performance.
  • Directed the technical team to Build, Test, and Implement compliance reports.

Confidential, IL

Program / Project Management Consultant

Responsibilities:

  • As the single point of accountability for program delivery, monitored the delivery of program through liaison with management team, implemented an effective review, reporting and presentation structure, and conducted program evaluations to communicate whether project objectives (time, quality, cost, and adoption goals) are met.
  • Executed, Implemented the Customized Enterprise Claims Systems over span of four years with $60 million in budget - the applications related to claims processing included were - Claims Assignments, Loss Reporting, Auto Salvage Register, Medical Bill Payment, Filenet - Imaging, Claims Payment, Fire Content Inventory, Premier Services
  • Worked with Business Partners and sponsors to negotiate and manage scope, cost and scheduling of several large projects spanning multiple areas and monitored dependencies between projects.
  • Managed offshore resources to effectively use their time.
  • Created a baseline schedule and provided general direction to maintain the program/project schedule.
  • Created and Managed Program/Project Schedule.
  • Documented and Managed Change Requests when changes occurred.
  • Communicated the status of the program/project to the Program/Project Sponsors and Business Partners.
  • Worked with team members to resolve disputes and engaged management as necessary.
  • Planned and executed a product roll-out working thru Confidential the issues.
  • Managed team sizes of 10 to 90 technical resources as well as authored Statement of Work for Waterfall and Agile/Scrum projects.
  • Managed the Financial Management including Budget Management for the program/projects.
  • Managed and accounted for the coordinated management of multiple related projects including P&C area directed toward strategic business and other organizational objectives.
  • Completed and managed infrastructure projects for 13 zonal VP offices nationwide.
  • Created program/project plans while working with a finite and defined project life cycle that is flexible and repeatable
  • Managed the P&C program/projects delivery in a practical way and kept the changes to the minimum.
  • Created the test planning for P&C programs/projects as part of the overall integrated program/project plan.
  • Created the Change Management Strategy which included Communications Plan, Quality Assurance Plan, Training Plan, and Transition Management Plan as part of the Organizational Change Management Strategy.
  • Ensured that the appropriate policies, plans, and programs are in place to meet anticipated organizational needs in the areas of functional responsibility and ensured compliance with corporate policies and guidelines, ISO/CMMI standards, and applicable regulatory requirements
  • Established issue escalation and resolutions process to address key operational issue and needs.
  • Directed PMO personnel performance reviews, development plans, resource planning/staffing.
  • Promoted project management excellence as well as the implementation of the best Project Management Practices at Confidential Insurance

Confidential, MA

Systems Project Manager

Responsibilities:

  • Managed and implemented the Customer Relations Management project using Oracle Database, Designer 2000, Designer 6i, and XML.
  • Documented project charter working with the business partners and other stakeholders.
  • Facilitated planning sessions for Project planning.
  • Created Work Breakdown Structure (WBS) for the project.
  • Created and Managed Project Plan and Release Plan using Microsoft Project.
  • Managed scope, schedule, risks and issues of the project.
  • Managed, and implemented eDatabase for SQL Server project.

Confidential, NY

Project Manager

Responsibilities:

  • Established Project Management Office for the Medsite.
  • Led, managed and implemented the Promotions Tool - Coupons using .NET, ERwin/ERX, Rational Rose, and RUP.
  • Managed the implementation of Tell a Friend utilizing .NET, ERwin/ERX, Rational Rose, and RUP.
  • Managed and implemented the Promotions that resulted in a cost savings of $1.5 million using .NET, ERwin/ERX, Rational Rose, and RUP.

Confidential, MI

Project Manager

Responsibilities:

  • Directed and supervised project teams consisting of system analysts, programmers, web designer, database manager, QA test analyst, accounting and other internal Project staff located at on-site, offshore, and offsite.
  • Led and managed the Project Management System: This application took care of resource management including employee database maintenance, resource requisition allocation and release. It interfaces with MS Project 98 for project scheduling.
  • Managed Personnel Information System: for salary processing, tax planning, annual benefits, address book and employee database maintenance.
  • Built credibility, established rapport and maintained communication with stakeholders at multiple levels, including those external to the organization.
  • Utilized MS Office Project Server 2003/Primavera P6 to ensure the success and acceptance of the program.
  • Maintained continuous alignment of program scope with strategic business objectives and made recommendations to modify the program to enhance effectiveness toward the business result / strategic intent.
  • Coached, mentored and led personnel within a technical/management team environment on PDLC, and PMLC.
  • Presented periodic Dashboard reports on the current program, future opportunities and client issues.
  • Provided business consulting, knowledge expertise in strategic performance management methodologies, process assessment work, and the application of technologies to business.
  • Managed the development and maintenance of implementation portions of project.
  • Executed and maintained program management processes and disciplines in the areas of: program schedule and quality management, communications management, human resource management, cost management, procurement management, risk/issue management, change management for Waterfall, and Agile/Scrum projects using PMLC.
  • Mentored staff in methodology and consulting excellence and encouraged best practice in project management, agile project management and project planning using PMLC.
  • Managed budget for the organization to influence organization's financial profitability.
  • Managed systems development, implementation and risk via the use of SDLC and PMLC.
  • Developed Project plans using MS Office Project Server 2003 (EPM)/Primavera P6 and assumed responsibility for project profit and loss.
  • Worked with clients to assist in moving their organization from SEI CMM level 2 or higher.
  • Monitored Project activities using MS Office Project Server 2003 (EPM)/Primavera P6 and advised staff of issues due to resource availability.
  • Managed cost budget to allocate overall cost estimate to individual tasks using MS Office Project Server 2003 (EPM)/Primavera P6.
  • Managed Project plan development, execution, and change control, Project initiation, scope planning, scope definition, scope verification, scope change control, Project activity definition, activity sequencing, activity duration estimating, schedule development, schedule control, Risk identification, risk quantification, risk response development, risk response control, quality assurance, Organizational planning, staff acquisition, team development using various tools including MS Office Project Server 2003 (EPM)/Primavera P6.
  • Produced project status reports using MS Office Project Server 2003 (EPM)/Primavera P6, managed the team and resolved day-to-day issues with emphasis on SDLC and PMLC.
  • Tracked software customization, defects and issues via the use of SDLC using the Lotus Notes, and MS SharePoint.

We'd love your feedback!