Resume of IT Professional

Title
IT Professional

Primary Skills
Project Management, Systems/Data Analysis

Location
US-NY-Bellmore

Posted
Aug-16-07

PROFESSIONAL SUMMARY
Hands on manager with over thirteen years of experience in the area of data warehousing and application development. Full life cycle experience on enterprise-wide projects. Strong team leader and results-focused manager. Demonstrated ability to understand business problems, goals, IT strategy, issues and priorities.

PROFESSIONAL EXPERIENCE:
The NPD Group, Inc. (Port Washington, NY)2004 -- Aug 2007
Senior Manager, HRIS
Responsible for automating and streamlining the human resource function through process redesign and new technology. Manage all aspects of project delivery including scope definition, project plan development, analysis/requirements gathering, design, construction, testing and implementation. Conduct resource planning, budgeting and cost tracking to ensure adherence to budget limitations. Collaborate with internal clients, third-party software vendors, and senior management on project implementations.
•Planned and communicated a strategic roadmap for global human resource information system development.
•Reconfigured existing Lawson HRIS to support global processes/users.
•Implemented Lawson HR Portal (web-based front end for administrative users).
•Implemented ADP Time and Attendance.
•Implemented Lawson eRecruiting.
•Implemented custom HR data mart application using SQL Server, Access and Crystal Reports.
•Developed and implemented various interface applications.
•Implemented Lawson employee manager self service (in progress).
•Provide training and ongoing guidance to users for all HR-related applications.
•Manage team to support day-to-day operations of existing applications and related processes.
•Provide leadership and guidance to other team members.

IBM Business Consulting Services (NYC, NY) 2001-2004
Senior Consultant, HCM Practice
Project and business development lead in a consulting practice that delivers data warehousing technology in the area of human capital management.

Client Project Experience:

Home Depot (Peoplesoft HR ERP and DW Implementation)
DW Project Manager/Lead Architect
•Developed and communicated HR data warehouse strategy and development roadmap.
•Lead database architecture design effort for enterprise data warehouse application:
- Defined data staging and reporting stores.
- Designed and developed logical and physical data models.
- Documented data transformation specifications.
•Managed the development of all HR-related reporting applications:
- Peoplesoft SQR reporting.
- DW reporting using Oracle and Cognos front-end.
•Acted as liaison between business unit management, IT departments and external consultants.
•Communicated status and managed issues with Home Depot's Project Management Office.
•Provided subject matter expertise of Peoplesoft application design, data content, and configuration.
•Conducted quality assurance for all human resource reports and analytics (Peoplesoft and DW).
•Trained business intelligence team on proper SQL logic for all reports and analytics.
•Developed data quality program for enterprise HR.
•Managed and developed IBM team members.

Capital One (Global Corporate Real Estate DW Project)
Lead Data Architect
•Lead implementation of a data warehouse that linked human resource and real estate data to deliver lease management and property management reporting/analytics.
•Designed and constructed data models including staging data stores, operational data store and the enterprise reporting store.
•Defined the extract, transform and load processing for all stages of the architecture.
•Managed teams through entire system development lifecycle:
- Lead Analysis and Design phases.
- Lead Construction/Implementation phase:
- Managed data extraction and transformation development team;
- Managed report development team to deliver business intelligence solution;
- Lead system/unit testing effort.

Mellon Bank (Global HRDW Start-Up Project)
Lead Data Architect
•Developed functional requirements and a proposed data warehouse strategy for supporting employee compensation and compliance reporting/analytics.
•Defined analytical cubes to support the functional requirements.
•Developed an architecture design that supported the data extract, transform and load requirements for the data warehouse.
•Developed and managed project plan that covered all tasks related to the design, construction, testing and implementation of the application.

PricewaterhouseCoopers Management Consulting Services (NYC, NY) 1997-2001
Principal Consultant, HCS Practice
Lead consultant within human capital data warehouse and information systems development practice.

Client Project Experience:

International Paper (Global SAP Implementation and HRDW Project)
Lead Data Architect
•Defined and developed overall data architecture for the HRDW.
•Defined and developed logical and physical HRDW data models.
•Designed business rule transformation logic from several disparate sources (SAP, custom mainframe HRIS/Payroll, JD Edwards, Lawson and Peoplesoft).
•Organized and facilitated workshops with key HR business people to develop a new organizational reporting structure for the enterprise.
•Performed database tuning and maintenance to ensure efficient and accurate database performance.
•Designed and constructed aggregate tables and views to satisfy report/cube requirements.
•Created sql guidelines for cube and report development.
•Managed development teams during each phase of system development lifecycle.
•Managed unit testing effort.
•Managed and developed team members.

Citigroup (HR System Re-engineering Business Case Project)
Data Architect
•Developed business case for a Human Resource Data Warehouse.

Goldman Sachs Data Warehouse Start-Up Project
Data Architect
•Developed data architecture design for Enterprise Data Warehouse.
•Developed data standards dictionary of over 700 terms and definitions.

State Farm Insurance (Global Financial Data Warehouse Project)
Business Analyst/Programmer
•Defined business requirements and developed ETL programs to populate DW.

Robert Plan Insurance Corporation (Bethpage, NY) 1993-1997
Lead Data Analyst/Programmer
•Developed and maintained various data marts for a national assigned risk insurance company.

Bergdorf Goodman (NYC, NY) 1991-1993
Credit Analyst
•Credit card analyst in credit and fraud department.
EDUCATION
B.S. Management/Finance, State University at Albany, May 1991

TECHNICAL
•Development Tools: Informatica, Ab Initio, Crystal, Cognos, Hyperion, Business Objects, Microstrategy, Erwin, Visio, MS Access, TOAD, Winsql
•Database: MS Access, Oracle, DB2, Sybase, SQL Server
•ERP: Peoplesoft, SAP, SAP BW, JD Edwards, Lawson, ADP
•Programming: SQL, PL/SQL, SAS, Cobol

TRAINING
•Pricewaterhouse's System Management Methodology (MITIS)
•PricewaterhouseCooper's Ascendant Methodology - Data Warehousing Methodology
•PricewaterhouseCooper's Data Warehouse Project Management
•IBM's BI Method

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-NY-Bellmore »
View all resumes in US-NY »

View other IT Professional resumes, IT Manager resumes