SUMMARY

• Teh backbone of my experience comes from working wif relational databases. Crystal reports, Business Objects, SAP, SSRS and Oracle R are some of teh reporting software tools me have used.
• My working experience and noledge of Human Resource Information Systems is very extensive Empath, PeopleSoft, Dayforce, Workday, UltiPro and Lawson including modules in HR, Finance, (LTM, and S3 interfaces), 5010 and 834, 837 conversion, and complete system conversion from legacy system to Enterprise system.
• Extensive background in healthcare environment including State, Federal reporting in all aspects related to compliance in HIPAA, JCAHO / Joint Commission, EEOC, Vets 100, FLSA, and FMLA.
• My career plan is to join a company where me can grow and offer my wide array of abilities to further teh growth of teh company as well as my own. Resourceful Project Manager wif 20 years of expertise in organizing business operations, financial oversight and resource management to achieve smooth flow and project operations.
• Monitors projects by adhering to production schedule and budget, managing production team, me enjoy challenges and teh reward of taking on so called impossible tasks. My unique ability is that me can come up wif multiple solutions to given problems and always have a backup plan ready. Results are always achievable wif determination and thorough planning.Certifications

TECHNICAL SKILLS

• Business Objects
• ADP Payroll, HCM, Time / Attendance
• SAS versions 6 - 16
• C, C++
• COBOL, COBOL “Microfocus”
• COGNOS and BI
• Data Modeling, Database Design
• Lawson version(s) 8- 10, 11 (LTM-S3)
• LEAN Academy
• Oracle 7 to 12c
• PeopleSoft
• SAP 5.3 - 16.0
• Kronos “WM & HCM”
• Workday
• UltiPro “Ultimate Software, UKG”
• Ceridian Dayforce
• Tableau 1.0, 5.0-9.0, 10.0
• Business Objects
• ADP Payroll
• Benefits
• Budgets
• Business Intelligence
• Business Objects
• Database Design
• EDI ETL
• HRIS
• Labor Relations
• Lawson
• Migration
• PeopleSoft
• Program management
• Reporting
• Risk management
• SDLC
• Software development
• Business process re-engineering
• Project planning and development

PROFESSIONAL EXPERIENCE

PROJECT MANAGER III

Confidential, Englewood, CO

Responsibilities:

• Facilitate teh project initiation process for assigned project candidates including; project in-take, initial planning and estimation, business case, prioritization, development of teh project charter and executive approval, managed multiple assigned IT programs / projects including; planning, execution and release, monitoring / controlling, and closing.
• Facilitate and administrate an assigned portfolio of IT programs/projects for a specific senior stakeholder.
• Effect project lifecycle including; phase and release planning, road mapping, business requirements and design, high level design, systems and software development, and testing activities including functional / system integration testing, acceptance testing, and performance testing.
• Lead a team of matrix (dotted line) business and IT resources to ensure success of assigned projects Collaboratively remove barriers and ensure projects are delivered on time, on budget, on scope and on quality.

HRIS PROJECT MANAGER Consultant

Confidential, Aurora, CO

Responsibilities:

• HR systems and process design, HR systems configuration, data standards, reporting and analytics.
• Worked wif teh Project Management team, HR team and Information technology team.
• Partnered wif Information Services in researching, analyzing and coordinating and leading system implementation, enhancements and upgrade projects.
• Partnered wif HR, IS, and business sponsors to determine and coordinate teh project lifecycle.
• This includes, creating teh project scope, determining teh resources required, estimating teh project costs, defining teh project schedule, assigning tasks, scope control, project communications, implementation, and teh turnover to production support.
• Worked closely wif business sponsors to evaluate teh business scope/objectives, assess impacts to teh project and develop teh most cost-effective and efficient solutions.
• Collaborated wif all areas of Information Systems to ensure appropriate technical resources are assigned to teh project.
• Plan, lead, coordinate, and collaborate wif IS staff/management along wif operational partners to lead projects through teh appropriate phases of implementation and support throughout teh enterprise project.
• Manages project timeline, budget, risks and scope; maintains project documentation, produces status reports and communicates status to management and stakeholders on a regular basis.
• Consult wif Project Sponsors to develop business requirements documents, develop project charters, work breakdown structures, project schedules and milestone plans, risk management, communication plans, issue logs and decision log.
• Gather status input from team members, maintain teh project schedule, and publish status reports to project and PMO stakeholders.
• Complete conversion of HRIS systems (UltiPro, Ceridian Dayforce).

HRIS Manager

Confidential, Denver, CO

Responsibilities:

• Reviewing policies and procedures and working wif other HR managers in HIPAA compliance.
• Lead a project to update 2 enterprise conversions including software, web, database and lead team member for 6 projects which ranged from 660 plus end users to 7000 plus.
• Crystal Reports, SQL, flat file, Oracle
• Extensive use of pivot, OLAP in SQL, Crystal Enterprise All analysis was custom due to system being older and canned reports were not very useful due to customization.
• Many reports updated to use LBI for ease of access to end users, some of teh projects were simple select others were rather complex using lengthy scripts, manages all IS/IT functions and reporting requirements for teh Human Resources Department.
• Led and managed teh collection and organization of business requirements to redesign and configure existing systems or design and configure new systems and process for future HRIS implementation.
• Update of EDI 837, 834 and other related forms / reports / feeds / ETL many of teh transformations were custom in ANSI and fixed position.
• Partner wif HR functional areas to deliver high quality, cost effective and timely business solutions for teh Human Resources Department.
• Ensured adherence to Hospital and Departmental policies and procedures in line wif all State and Federal requirements.
• LEAN and Agile methods used in service improvement for HR including; (HRIS, Benefits, Compensation, Employee Labor Relations).
• My team also supported all areas of ADP Payroll / Time and Attendance including customizations (In house and Vendor).
• Kronos support (Time and Attendance including customizations (In house and Vendor).
• Adjusted project plans to account for dynamic targets, staffing changes and operational specifications.
• Gathered requirements, defined scopes, allocated resources and established schedules meeting or exceeding project demands.
• Analyzed projects to determine resource requirements and procured necessary equipment and software.
• Analyzed large data sets to detect behavioral and operational patterns wif potential to negatively impact productivity.
• Served as resource steward for HR leadership, overseeing factors such as budgets and billing.
• Migrated legacy HRIS system to new technology to minimize business impacts.
• Partnered wif business teams and IT personnel to align project goals wif business strategy and define project milestones.
• Worked wif internal and external businesses and led cross-functional teams to develop intricate business plans, including Telecom, Vendors and Field Service analysts.
• Generated reports of findings to halp management wif making key decisions.
• Developed and updated tracking spreadsheets using MS BIDS.

Senior HRIS Consultant

Confidential, Albuquerque, NM

Responsibilities:

• Served as a technical resource for teh Human Resources Department, computer support and third-tier problem resolution.
• Work closely wif IT to facilitate teh implementation of individual projects as assigned.
• Participate as functional lead in teh project management (Agile and Waterfall methodologies) of HR projects.
• Consult wif departmental staff and Information Services in determining requirements
• Lead effort to document and validate functional requirements.
• Provide input to developing departmental policies and procedures as they relate to information systems.
• Serves as functional project lead to design, develop, implement, and support technical solutions in collaboration wif HR teams.
• Collaborate wif HR teams in teh evaluation of systems and technology and recommend appropriate computer technology to support team requirements.
• Participate in improving organizational performance by working wif HR teams to recommend areas of approaches for improvement activities, performing new procedures, collecting data and providing input where support is needed.
• Evaluate project training needs and develop training strategies, standards and objectives for individual project implementations.
• Evaluate and determine proper method of training delivery for new implementations or modifications.
• Design, write and prepare complete user documentation including system training manuals for department systems implemented.
• Prepared statistical summaries and reports for Human Resource department involving all HR related data for review at all levels.
• Release management wif custom scripting, ETL, software and enterprise release management.
• Oracle and SQL databases, Custom API's built, java custom scripts, 834 EDI for benefits in HR.
• Extensive Advanced SQL and T-SQL.

Senior Program Director

Confidential, Albuquerque, NM

Responsibilities:

• Design, develop, and implement reporting for HSD State of New Mexico reporting of teh reports (94) required for MCO's.
• Compile and validate data wif Business Requirements Documentation.
• Document reports and specification used in teh report to guarantee proper interpretation.
• Automated 90% of all reports for State and Federal level
• Coordinate closely wif Subject Matter Experts (SME's) in teh formulation of data definitions Manages people who are responsible for internal business projects and programs involving department or cross-functional teams of subject matter experts, delivering products through teh design process to completion.
• Planned and directed schedules as well as project budgets.
• Engage and oversee teh work of external vendors.
• Assigns, directs and monitors system analysis and program staff.
• Release management wif custom scripts, API, software and enterprise release management.
• Teh positions' primary focus is project/program management and application of expertise in a specialized functional field of noledge.
• Extensive Advanced SQL and T-SQL Microsoft (BIDS) 2008 R2, SSRS, MYSQL, Postgres, SQL Server 2008-2012 Tableau 9.0-9.3 and Business Objects.
• Extensive use of Microsoft Business Intelligence Development Studio for various projects aka (BIDS).

Business Intelligence Designer Developer

Confidential, Albuquerque, NM

Responsibilities:

• Design, develop, and implement reporting from local / network database(s) update projects, design documents.
• Compile and validate data.
• Document reports and specification used in teh report to guarantee proper interpretation.
• Coordinate closely wif Subject Matter Experts (SME's) in teh formulation of databases and in teh retrieval of mainframe information & Linked DB via SQL.
• Extensive Advanced SQL and T-SQL.
• Recommend discontinuation and consolidation of reports, which requires working wif all appropriate divisions and service areas to make sure that all continuing needs to data from old reports are met by new reports.
• Update of EDI and other related forms / reports / feeds.
• Teh primary focus was wif teh 94 reports required by HSD.
• Microsoft (BIDS), SSRS, SQL, VBA, Visual Studio 2008, MYSQL, Postgres, SQL Server 2008 R2, SAS Enterprise, Teradata 14.10 and 15, Crystal Reports 2011, SAP, Tableau 8.2-8.3 Business Objects Enterprise XI R3.
• Microsoft Business Intelligence Development Studio and Cognos Business Intelligence for use in predictive patient services and preauthorization's.
• BI was used for full patient life cycle.
• SAS 12.0 a 14.0.
• ETL were set up due several sources of record required for Federal report and State reporting.
• Hyperion, Discover, Crystal reports, Tableau, MYSQL, Postgres, SQL, Oracle (PL/SQL, TSQL) XML, XSLT, JDBC, jQuery, CSS, JavaScript.
• Extensive Advanced SQL and T-SQL.
• Complete reporting conversion of old system wif short track implementation.
• Crystal Enterprise, Tableau 7.0 Business Objects Business Intelligence MS SQL Queries, DTS, Stored Procedures, Views and Linked server A/S 400.
• Extensive Advanced PL/SQL Crystal SQL syntax, SQL and T-SQL ETL for EDI reporting.
• Planned, directed and managed teh daily operations of reporting department.
• Operational processes and needs as it relates to technology and communication equipment and work effectively wif operational staff in teh coordination of IT projects and identifying operational technology needs.

HRIS Manager

Confidential, Albuquerque, NM

Responsibilities:

• Complete 834, 837 EDI configure all life cycles.
• All benefits departments for 10,000 plus employees.
• Both transmission and receive for all vendors.
• EDI work in XML mapping and editing customized for specific needs.
• XSLT customization in Lawson add-ins.
• (HRIS, Benefits, Compensation, Employee Labor Relations).
• SPOC, “Incident, Change, Problem Management”.
• All adhoc reports and custom reports for Empath built in Crystal reports.
• Tableau, Lawson HR, Finance, and Desktop set up LTM, S3, interfaces, 5010 conversion, complete system conversion form legacy system.
• Extensive Advanced SQL and T-SQL All life cycles, complete benefit files transfer reconfigure, EDI complete customization for XML maps.
• Lawson add-ins used xml and XSLT for end users reports transformation and customized ETL many of teh transformations were custom in ANSI and fixed position.
• Release management wif custom software and enterprise release management.
• Coordination and work as a leader and team member for teh enterprise release wif teh software development department.
• Lawson HR, Finance, and Desktop set up LTM, S3, interfaces, 5010 conversion, custom reporting wif custom / and industry standard metrics.
• Complete EDI configure all life cycles.
• Extensive Advanced SQL and T-SQL Both transmission and receive for all vendors.
• EDI work in XML mapping and editing customized for specific needs.
• XSLT customization in Lawson add-ins.
• Custom reporting for HR and Finance.
• Output reports created for vendor and industry standards format all custom using xml and web interface for end user's needs.
• Update of EDI 837 and other related forms / reports / feeds.
• Projects at different divisions
• Oracle forms, DBA, redesign wif conversion from Oracle 9i to 11g runtime hosted.
• Update all end users Discover reports runtime versions.
• SQL DB 2005, 2008 work on creation of environments / databases / views / stored procedures.
• VB work, MS Access 2007 Project work wif SQL 2008 DB, Forms, Scripting, VB.
• Sage Accounting / MAS 90 customization.
• SQL Server 2008 R2 customization (Tuning and conversion), MS Access 2007 and Crystal Reports customization.

Director of Information Technology

Confidential, Albuquerque, NM

Responsibilities:

• Establishes, plans, and administers teh overall policies and goals for teh information technology department.
• Analyzes teh needs of departments and establishes priorities for feasibility studies, systems design and implementation to develop new and/or modify teh company's information processing systems.
• Working wif Server 2000 - 2003, Exchange 2003 and SQL Databases.
• Oracle run-time vers.11, “Business Suite” configuring and customizing interfaces wif AR/AP and Inventory.
• VOIP Cisco call manager & Call manager Express.
• Install, configure, and support an organization's local area network (LAN), wide area network (WAN), and Internet system or a segment of a network system.
• Maintain network hardware and software and monitor network to ensure network availability to all system users and perform necessary maintenance to support network availability.
• Webmaster / developer / administrator.
• Extensive Advanced SQL and T-SQL Update of EDI 834 and other related forms / reports / feeds.
• OLAP, Pivot tables/cubes were used to extract useful information.
• Custom reports built in crystal for several network reporting needs.
• Project manager for NOC move, Corp headquarters move and complete system migration to virtual environment.
• Complete scale down move from Oracle E-Business suite to intuit and custom DB for ware house and manufacturing.
• Release management wif custom API, software and legacy conversion.
• Crystal Reports, SQL, flat file, RDB, Oracle and Access databases.
• Reviewing policies and procedures and working wif other managers in HIPAA compliance.
• Oracle migration.
• Project manager on 3 enterprise conversions including software, web, database and lead team member for 6 projects which ranged from 430 plus end users to 4,000 plus.
• Custom programming in Cold Fusion, Visual Basic, C++, COBOL and Micrococcus COBOL.
• Extensive use of pivot, OLAP in SQL, Access and Crystal Enterprise All analysis was custom due to system being older and canned reports were not very useful due to customization.
• Many reports updated to use APEX for ease of access to end users, some of teh projects were simple select others were rather complex using lengthy scripts, manages all IS/IT functions and reporting requirements for teh Human Resources Department.
• Leads and manages teh collection and organization of business requirements to redesign and configure existing systems or design and configure new systems and process for future HRIS implementation.
• Update of EDI 837, 834 and other related forms / reports / feeds ETL many of teh transformations were custom in ANSI and fixed position.
• Partner wif HR functional areas to deliver high quality, cost effective and timely business solutions for teh Human Resources Department.
• Ensures adherence to Hospital and Departmental policies and procedures.
• ITIL used in service improvement for HR including; (HRIS, Benefits, Compensation, Employee Labor Relations).
• SPOC, “Incident, Change, Problem Management”.
• Release management wif custom API, software and enterprise release management for all HR / Finance releases.
• Extensive Advanced SQL and T-SQL SAS 5.3.0 - 10.0.
• Crystal Reports, SQL, flat file, RDB, Oracle and Access databases.
• Extensive use of pivot, OLAP in SQL, Access and Crystal Enterprise.
• Led and managed teh collection and organization of business requirements to redesign and configure existing systems or design and configure new systems and process for future HRIS implementation.
• Partner wif HR functional areas to deliver high quality, cost effective and timely business solutions for teh Human Resources Department.
• Extensive Advanced SQL and T-SQL