SUMMARY:

• Over 15 years’ experience including operational, financial and information technology.12+ years’ project and technical management including design, development, production and support, successfully led on - shore and off-shore developers.
• Experience in communicating complex technical concepts in easier to understand models and examples for requirements and common understanding.
• Experience in managing, coaching,, facilitating and leading technical and business teams in a variety of projects.

TECHNICAL SKILLS:

DBMS: MS SQL Server, Oracle, IBM’s UDB/DB2, Access.

Business Intelligence: Business Objects, Brio Query, ProClarity.

Packages: Microsoft suite, Microsoft Project, Visio, ERwin, Informatica (Power Center 9.0), Workday Studio.

Languages/protocols: COBOL, XML, HTML, C, BASIC.

Methodologies: PMI Project Management, Function Point Analysis, SummitD (project management), Larissa Moss Spiral, Gavroshe Seven Streams, Accenture Delivery Management.

PROFESSIONAL EXPERIENCE:

Workday Architect

Confidential, Arlington, VA

Responsibilities:

• Workday - Salesforce data integration lead. Identify business requirements and document. Create mapping documents and identify APIs required to meet business needs.
• Support creation of addition fields in Salesforce for business requirements. Analyze customer addresses and specify mappings and logic to meet Workday address validations for the integration.
• Reviewed data migration from Great Plains to Workday Financial.

Conversion Lead

Confidential, Bridgewater, NJ

Responsibilities:

• Workday Conversion Lead for global retailer. Data quality, data validation, communication processes and procedures to ensure the implementation partner, conversion, data integration and business SMEs are all in sync and conversion meets project schedules and quality metrics.
• Data audit, validation and metrics to document accuracy and completeness of conversion. Data migration from legacy systems to Workday. Converted performance data from legacy system to Workday.

Manager, Data Management

Confidential, Baltimore, MD

Responsibilities:

• Managed data architecture, data integration and data management. Implementing an operational data store, manage developers, data analyst and off-shore contractors. Coordination and management of third party data suppliers.

Sr. Conversion Consultant

Confidential, Bellevue, WA

Responsibilities:

• Workday conversion and implementation. Data validation and data integration for global web services company. Data management, transformation, formatting. Report review, security audit and testing. EIBs for supervisory organizations and other HCM updates. Data migration from legacy systems to Workday.

Sr. Consultant

Confidential, Canonsburg, PA

Responsibilities:

• Workday reporting and headcount validation for a global pharmaceutical company 29,000+ employees. Create custom reports, run ad hoc reports on request, talent management reports, EEOC reporting, create and maintain calculated fields for reporting, report inconsistencies and anomalies to HRIS for data standardization and correction. Maintain and create custom databases in Access for reporting and analysis.
• Create custom reports for Excel pivot tables, charts and dashboards for monthly and quarterly reporting to executive management. Extract reports for data integrations with vendors. Requirement gathering and prototyping. HR IT. Planned and conducted Advanced Excel Brown Bag sessions for business analysts. Reported on Talent and Performance from Workday, created integration reports for talent.

Sr. Business Analyst

Confidential, Chicago, IL.

Responsibilities:

• Data conversion lead - Workday conversion for media company, HCM, Benefits, Absence, Payroll. Led team of two developers to create full set of conversion extracts from PeopleSoft.

Sr. Manager

Confidential

Responsibilities:

• Data conversion co-lead - Workday conversion for large university, 30K+ employees. HCM, payroll, benefits. Mentoring client and project staff, data validation, data integration, and facilitating test requirements meetings
• The least amount of conversion problems. HR IT. Data migration from legacy systems to Workday. Converted performance management data from legacy to Workday.

Data Architect

Confidential

Responsibilities:

• MDM - architecture and facilitate meetings to standardize data & resolve issues.
• Data Validation - created procedures, resolution of issues.
• Mentoring, best practices, data governance.
• Relational, dimensional/star schema modeling.
• Job and master data harmonization and standardization.

Project Manager

Confidential

Responsibilities:

• Project management - Enterprise data warehouse assessment for Human Cap Mgmt.
• Requirement interviews, data profiling, relational and dimensional modeling.
• Assessment and report of Cognos BI implementation - performance, architecture, supporting data infrastructure.
• Client - State government. OAKS project, Ohio. HR IT.

Sr. Consultant / Project Manager / Data Architect

Confidential

Responsibilities:

• Data architecture - enterprise data warehouse, full life-cycle including requirements, scoping, project management, ETL, MDM, testing and OLAP.
• Data Warehouse methodologies, Gavroshe Seven Streams and Larissa Moss Spiral.
• Mentoring new data governance group, procedures, processes and testing.
• Requirements gathering and architecting processes for additional data sources for the warehouse.
• Change management. Data archival requirements and implementation.
• Metadata repository, data governance, data quality/MDM, product & vendor evaluations.
• SQL Server 2005, Data Flux, Kalido DIW and MDM, ProClarity.

Information Warehouse Architect

Confidential

Responsibilities:

• Architected and built an enterprise information factory, operational data store (ODS) and dimensional data warehouse for easy to use and understand reporting for managerial, actuarial, accounting, fraud analysis and regulatory requirements.
• Project management - WBS, requirements gathering, data profiling, data modeling, architecture for ODS, ETL and warehouse. Third normal form and dimensional modeling.
• SQL Server 2005, Trillium.

Sr. Consultant

Confidential

Responsibilities:

• Successfully completed an officer code conversion / standardization. Four state banks with inconsistent and overlapping officer codes in 12 separate applications which we standardized including coordinated application changes, database changes and change management. Confidential Bank.
• Identify risks of changing the officer codes in each system. Determine how to mitigate or eliminate the risks. Evaluate source system data and steps to convert and load data to target system. Evaluate the amount of overlap, duplication and consistency already existing in the data to enable least impact change procedure.
• Created a work breakdown structure (WBS) for changes and coordinated with operations for data updates for all systems across all applications across all banks.
• Prepared and presented the work plan to management and PMO for approval.
• Ran weekly project meetings to ensure the tasks and milestones were completed.
• Created test cases and processes to test conversion programs and conversion data.
• Ran SQL queries to ensure data was converted completely and correctly.
• Coordinated process changes and changes for all application input streams to ensure new officer code creation was correct.
• Oracle database, Toad, Ascential data quality tool.

Project Manager

Confidential

Responsibilities:

• Project planning; create WBS, requirements gathering, coordination of infrastructure, business and database requirements to meet reporting needs. Client - National Confidential .

Project Manager

Confidential

Responsibilities:

• Develop clinical data warehouse, create reports and data for SAS programmers.
• Three-month fast-track project with compressed time frame. Assessed work scope, negotiated scope change to meet year-end deadline.
• Acquired necessary resources to meet deadline and provided support and guidance to developers to meet scope and deadline.
• Six Informatica developers, two test leads and three testers. Updated enterprise standards and data definitions. Led testing efforts for ETL.
• Created data stewardship procedures to fit client. Managed three other consultants.
• Client - Eli Lilly. Facilitated ‘fit’ of separate projects and resources to ensure optimal resource usage and interoperability of project components.
• Oracle database, Informatica, SASS. Database and ETL architecture.