Summary

Over 16 years of IT experience in Data Warehousing, Business Intelligence BI , Data Management and Systems Integration projects out of which 10 years on client-facing roles. Have in-depth experience with data warehouse technologies, data integration, data modeling, master data management, data governance and business intelligence applications. Provided strong leadership and guidance across cross-functional teams. Successfully delivered custom and packaged analytics solutions such as OBIA Oracle BI Applications to diverse clients. Full Life Cycle experience with both ERP Enterprise Resource Planning and BI projects. Delivered BI solutions for Financial Management, Human Resources, Claims Management, Student Information, Higher Education Institutional Research, Planning, Budgeting and Forecasting applications. Certified Project Management Professional PMP with experience using Agile Methodology.

EXPERIENCE

Confidential

BI Project Manager

• BI Tools: Oracle Business Enterprise Edition OBIEE 11.1.1.7 , OBIA 7.9.6.3, Informatica 9.1
• Applications: Oracle BI Applications for Financial Analytics, and Procurement Spend.
• Responsibilities includes providing strategy, leadership, organization, coordination of day to day operations, review of project deliverables and advise to support Health and Human Services, Office of Financial Policy and Oversight with project management of FBIS Financial Business Intelligence System . All BI project are being implemented using Agile Methodology and releases are rolled out in six weeks sprints. Responsible for key activities such as planning, governance, data management, scope management, change management, project management, and risk and issue management. Have been coordinating weekly operational and release deployment status meetings between the Systems Integrator and the System Maintenance teams, tracking change requests and program risks. Performing independent verification and validation, and advising to ensure program adheres to best practices and promoting acceptance of global department-wide BI solutions.

Confidential

BI Manager/Solution Architect

• BI Tools: Oracle Business Enterprise Edition OBIEE Cognos Framework Manager
• Applications: Enterprise Data Warehouse and Performance Management for ECM Enterprise Content Management , CRM Customer Relationship Management , Campus Solutions Warehouse, Pension Payroll, Pension Plan Members and Retirees and Finance, Student Information, Institution Academic Advancement.
• Project manager and BI lead for the University of Miami. Led the BI User Committee meetings and provided a demonstration of Campus Solutions Warehouse to potential users. Gathered business requirements, conducted data analysis that involved identifying data sourcing and comparing against STTM documentation, provided gap analysis, and coordinated technical tasks with offshore Oracle On-Demand team. Managed priorities, lead change management and overall project implementation. Established a data governance and data quality improvement process.
• Conducted assessment for University of Pittsburgh data warehouse capabilities and provided recommendations on further expansion to meet department-wide business needs. This included gathering requirements and providing recommendations on including additional data elements and additional data sourcing such as BlackBoard data for institutional advancement analysis. Identified and escalated issues related to data governance and put closures to such issues by engaging with data stewards and system owners.
• As a solution architect and strategist created implementation strategy, project schedule and solution design for the State of Mississippi Public Employees' Retirement System. Conducted interactive sessions with customers to capture business requirements, mapped them into functional and technical requirements, coordinated fit-gap analysis and provided solution design to the client.

Confidential

Manager

• BI Tools: Oracle Business Enterprise Edition OBIEE , BI Publisher Informatica for ETL
• Applications: Oracle BI Applications for Financial Analytics, Procurement Spend, Sales Analytics HR Analytics, Student Enrollment Analytics
• As a manager for BI and Data Management team at K12 served as a lead point of contact for enterprise business intelligence solutions. Interacted with executives and directors across departments to align BI with strategic initiatives and develop BI Roadmap. Managed and mentored a technical team of FTEs, contractors and collaborated with business leaders and SMEs subject matter experts in the design and development of KPIs Key Performance Indicators and reporting metrics for departmental dashboards. Conducted requirements gathering sessions, organized intake requirements into project roadmap, worked with the business and steering committee to prioritize requirements and defined project scope. Designed enterprise architecture, provided hardware estimates, recommended newer softwares, developed project roadmaps and project plans. Managed delivery of application releases, budget, risks and issues, end user trainings, and relationships across departments and stakeholders. Implemented Oracle BI applications for Financial Analytics, Procurement and Spend Analytics, Sales Analytics for Salesforce. Custom business Intelligence application implementations include monitoring student enrollments against targets and analysis of student assessment data. Responsible for vendor management and software evaluations. Acted as a Change Agent to promote adoption of Business Intelligence across the departments. Introduced 'Agile' methodology and significant process improvements to reduce life cycle time of development and align better to user needs. Prioritized queue of user request and defect tickets.

Confidential

Manager

• BI Tools: Oracle Business Enterprise Edition OBIEE Informatica for ETL
• Applications: Oracle BI Applications for Financial Analytics, Procurement Spend, and Sales Analytics
• As a BI functional specialist involved in gathering user requirements, testing and conducted data validation for Financial Analytics pilot project for FDA Food and Drug Administration. Source data for initial phase of this project was UFMS Unified Financial Management System that consisted of General Ledger, Budget Execution, Accounts Receivables and Accounts Payables. Built management dashboards that provided more efficient tactical reporting solution for federal agency. Documented user requirements, functional design, designing user dashboards and reports, and coordinating with technical team on data design and system performance. Developed test scripts for CRP sessions and User Acceptance Testing. Developed reports and dashboards for General Ledger, Accounts Receivables, Accounts Payables and Procurement/ Spend subject areas.

Confidential

ERP Specialist

• BI Tools: Oracle Business Enterprise Edition OBIEE Ascential Datastage for ETL
• Applications: PeopleSoft EPM 9.0 Financial/ Supply Chain Analytics Data Warehouse Project
• Lead architect, master data management and BI specialist at the Office of Business Affairs. Phase 1 of the implementation involves Financial and Supply Chain Fusion Analytics using Oracle Business Intelligence Enterprise Edition OBIEE . Designed the technical architecture for business intelligence and ETL Extract, Transformation and Load tools. Presented solution architecture and recommendations on hardware upgrade and data governance to the upper management. Developed project roadmap and designed migration flows for both data and BI applications. Primary role involved functional design and project planning. Installed and configured OBIEE version 10.1.3.4 on Windows 2003 servers. Configured PeopleSoft EPM 9.0 application and developing reports using Answers and Dashboards.

Confidential

Senior Principal Consultant

• Project Manager for a large PeopleSoft 9.0 ERP implementation for Lee County Public Schools Administration. PeopleSoft financial modules implemented were General Ledger, Commitment Control, Accounts Payables, Purchasing, Accounts Receivable, Billing, Asset Management, Projects, Cash Management, Grants. Other modules included PeopleSoft HCM Human Capital Management , PeopleSoft ELM eLearning Management and Supply Chain modules. Being a project manager and part of PMO Program Management Office conducted project planning, project/budget tracking, coordinating with functional and technical leads and status reporting to upper management.
• Functional Lead for Human Capital Management data warehouse for Johnson Diversey. The data warehouse included integration of payroll data for 10 different countries to provide a global view of the company's payroll expenses and benefit spending trends. The payroll data was further integrated with human resources data to provide further analysis of trends. I designed PeopleSoft EPM configuration, payroll and financial data integration. The analytic reporting tool used was OBIEE v 10.1.3.3.2 .
• Functional Lead for Planning and Budgeting analytic application for Canadian college La Cite Collegiale and a state agency Virginia Information Technology in Richmond, Virginia. Conducted weekly status reporting, project planning, issues and risk management meetings. Worked closely with technical consultants on the Extract, Transform and Load ETL requirements and testing. Gathered requirements, designed configured, conducted testing and knowledge transfer sessions for the client. Configured and implemented PeopleSoft Commitment Control for La Cite Collegiale and coordinated the development of financial reports for General Ledger.
• Functional lead for PeopleSoft GL and Asset Management upgrade for Hilton Hotels and for Star Tribune projects. For Star Tribune created trim criteria for isolation of interunit transactions corresponding to the company from which Star Tribune was separating. Conducted unit and system testing and was involved in resolving functional issues and reporting issues. Resolved issues related to PSnVision reports.
• Project Lead for a Planning and Budgeting analytic application for Virginia Technology Agency public sector . Analyzed user requirements, created project roadmap and conducted fit-gap sessions with business users. Created design and configuration document for multi-year budget model and application security. Designed a custom solution for integration of position data HCM from third party non-PeopleSoft System PMIS. Implemented Line Item, Asset and Position Budgeting. Created customization specifications for integration with HCM data by mapping the non-PeopleSoft data to PeopleSoft HCM tables. Designed logic and mapping to load Job, Position, Personal and Compensation data into Planning and budgeting module. Delivered ETL Extract Transformation and Load program was used to send the budget data into PeopleSoft General Ledger. The solution designed was flexible to work with commitment control as well as when commitment control was turned off.

Confidential

Lead Analyst/ Track Lead

• BI Tools: Business Objects
• Lead analyst for Human Resource Data Warehouse and Workforce Scorecard implementations for BlueCross BlueShield. The data source was PeopleSoft HCM 8.8. Conducted requirements analysis fit-gap analysis and impact analysis helping the client make informed decisions. Proposed technical architecture and security design. Responsibilities included project plan, scope definition, design, configuration, test plans, test strategy and migration strategy. Provided both technical and functional leadership to these projects.

Confidential

Senior Functional Analyst

• Senior functional analyst for PeopleSoft EPM Human Resources data warehouse implementation for the Defense Integrated Human Resources System. DIMHRS
• Data Warehouse Specialist SEPT-2003 to FEB-2004 :
• Client: Department of Treasury Enterprise HR Data Store using PeopleSoft HCM as source
• BI Tools: Business Objects
• Joined the HR Reporting team at the Office of Workforce Technology at the Deputy Assistant Secretary of Management for the Department Of Treasury. Successfully contributed to the formal initiation and government funding for an enterprise HR Data Store. Created the technical architecture for HR Data Store project.

Confidential

Manager

BI Tools: Oracle Discoverer, Oracle Express, SAS

Responsibilities included leading and directing the data warehouse team of ten developers, one DBA/system administrator, metadata lead, one team leader and two technical consultants. Organized work, managed priorities, and distributed and balanced workload. The VBA data warehouse provided an integration of data from disparate sources like Veteran Claims, Gulf War Information System, Human Resources Analytics and Activity Based Cost Models. Fraudulent Payments Detection on veteran claims was an application built using a combination of data warehousing and data mining technologies. The data warehouse provided 25 different applications. Some of them were activity based cost management, workforce analytics, balanced scorecard, inventory management and workload management systems. Gathered requirements, conducted requirements analysis, created and managed project plans. Designed star schema/ snow flake models for major applications, established data sourcing, developed source to target mapping STTM , mentored team members and managed priorities with the client. The data warehouse used common dimensions as well as application specific dimensions. Administered Oracle Discoverer for new applications. This included scheduling, building business layer and end user layers. Involved in hiring, career development, training plans and performance reviews for team members. Created annual capacity plans, project estimates, budgets, resource plans and reviewed technical architecture. Conducted software and hardware evaluations.

Senior Consultant Confidential

• BI Tools: Oracle Discoverer, Oracle Express
• Gathered requirements, conducted requirements analysis, designed, and successfully led and managed the development of some major projects like the Human Resources Analytic Reporting System, Pending Claims Tracking System, and Completed Cases Tracking System. Creating star schema and multidimensional design and have worked extremely well with team members in resolving sticky issues.
• Technical lead and developer for PeopleSoft implementation projects for PeopleSoft Financial and Human Resources modules.

Experience/ Skills