SUMMARY

• Data Warehouse/BI Manager with a proven track record of leadership, organizational and managerial skills, project management, technical skills, problem and analytical solving skills and history of delivering enterprise wide data warehouse solutions.
• Supervised culturally diverse teams to excel; build strong team by providing support, setting clear expectations, treating others fairly and with dignity and lead by example.
• Result, detail oriented and customer focus Project Manager skilled in managing multi - million Information Technology projects through effective planning, team management, scope and cost management, risk mitigation, open communication, and monitoring and control.
• Lead project throughout the Project Management Life Cycle and Software Development Lifecycle (SDLC).
• Skilled in Analysis and Design, Relational Database Design, Data Modeling

TECHNICAL SKILLS

Software: Erwin, Rational Rose, Microsoft Project, Microsoft Office

Database Platform: Oracle, SQL Server

Data Warehouse/BI Landscape: Informatica, Cognos, Hyperion Essbase, Microsoft BI Suite (SSRS), Microsoft Power BI

Programming Languages: PL/SQL, SQL, Powerbuilder, SAS, C, C++, Cognos Powerhouse

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Data Warehouse Manager/Data Architect

Responsibilities:

• Lead team and architect the data warehouse data migration solution from SAP to home grown enterprise data warehouse with self service capability using Microsoft business intelligence suite, Microsoft Power BI
• Managed overall portfolio of data warehouse projects - generate initial estimates, requirements generation and review, prioritizing, resource allocation and stakeholder management to achieved corporate objectives
• Lead team to build and transform a mainframe environment to a business intelligence environment using BI technologies like SAP BW
• Recruit and build a team of professional personnel who are skilled in business intelligence and data warehouse.
• Recommend to upper IT management and set direction on data warehouse technologies.
• Driving enhancements and defect resolution for enterprise data warehouse
• Architect the data warehouse environment to interface with SAP R/3 Sales and Finance module, Order Management System, Microsoft CRM, PeopleSoft, SalesForce, Waste Management Tracking System, Callidus

Confidential, Plano, TX

IT Manager/Project Manager

Responsibilities:

• Recruit and build a team of project managers resulting in projects being professionally managed, achieved 80% PMP certifications by the team.
• Coach project managers on project delivery methodology and ensure project management standards are followed achieving high marks 90+ percentile from PMO in areas of project delivery and quality.

Senior Project Manager

Confidential

Responsibilities:

• Managed numerous complex projects i.e. convert corporate financial reporting from period to month for COGNOS/ORACLE data warehouse spanning across business division and countries; Logistic and Control subject data mart to capture operational metrics; customer channel reporting combining POS and internal sales data to generate customer P&L; physically separate entire business applications landscape that are shared by beverage and confectionery business in preparation for spin-off.
• Responsible for development and management of budgets, determining and managing project scope, creating project schedule, manage resource allocation, mitigate issues and risk, act as liaison between clients and staff throughout project lifecycle, monitoring and control and ensuring project met objectives.
• Managed development team throughout SDLC - driving requirements definition, developing detailed design, development and testing, conducting user acceptance testing, and implementation plan for production rollout.
• Managed diverse development teams spanning multiple countries and utilized onsite-offshore resources for project resulting in project cost reduction and shorter development time frame.

Business Intelligence/Data Warehouse IT Manager

Confidential

Responsibilities:

• Led a 10 person IT team working on a $4 million project to design and build a new sales information data warehouse from initiation through completion following acquisition of Pfizer Adams. Design the back-end ETL process (relational database models and dimensional data models). Developed reporting layer to allow sales and finance to build customize and ad-hoc reports and performed analytical analysis on daily sales volume. Project was completed on time and within budget.
• Created business intelligence (BI) support organization, establish design and documents standards achieving 100% system availability and exceeding SLA.
• Architect data integration data quality solution using Informatica PowerCenter to extract data from SAP and multiple client server legacy applications; Informatica Data Quality (IDQ) to profile and cleanse data i.e. customer, address, and products before loading into a Common Information Model database and achieving one version of the truth. Team was awarded the Innovation Award from Informatica.
• Managed and prioritize requirements, work orders, enhancements, with business resulting in better communications and expectations from business.

Application Development IT Manager

Confidential

Responsibilities:

• Led a 12 person IT team to design and developed Powerbuilder sales and marketing OLTP system. System is still being used today though the organization has gone through multiple acquisition and reorganization and technology modernization.
• Utilized onsite-offshore model to develop business application systems achieving 65% reduction in implementation cost.
• Built 10 member support organization with less than 10% employee turnover.
• Balanced a $4 million department budget through renegotiating consultant rates, staff reduction, controlling consultant overtime, uncover charges to business.
• Implemented release management resulting in better communication with business, focused delivery by development team achieving high on-schedule issues resolution.
• Led team to evaluate and select enterprise BI tool resulting in tool reduction and reducing cost of software and support operation.

Confidential, Dallas, TX

Technical Team Lead

Responsibilities:

• Led software development team and responsible for analysis and design, software maintenance, software development using a 4GL (Cognos Powerhouse), and support of various Medicaid projects.
• Reviewed and recommended technical solution to team
• Managed resources to conduct requirements analysis, design and development