PROFILE:

• I am seeking a local permanent or long term role as a Business Systems Analyst where my technical and analytical expertise with database Report Writing, Business Analysis and SharePoint development can contribute to the success of the business.
• SharePoint development and System and Business analysis using Access, Excel, SQL Server and VBA to provide data analysis using custom list, views, web parts, forms and surveys.
• Systems Analyst Power User with PeopleSoft 8.9 HR, Payroll and Benefits modules; ability to derive technical solutions from end user requirements primarily with Payroll, Benefits and Compensation; advanced experience with PeopleSoft reporting tools (PS/Query, Crystal Reports, SQL and SQR)

TECHNICAL SKILLS:

Highly computer literate; strong skill set with: MS Office Suite including SharePoint, SharePoint Designer, Crystal Reports, Project Manager, Visio, Report Smith, Oracle XML Publisher and relational databases such as MS Access, PeopleSoft/Oracle, SQL Server Mgmt Studio and their interface with web applications utilizing SQL language and ODBC; expert MS Access user; novice VBA developer, TOAD, SAS and Tableau

WORK EXPERIENCE:

Sr. Workday Reporting Analyst

Confidential

Responsibilities:

• Develop, maintain, schedule and distribute Workday Human Resource reports and analytic data sets for all of Human Resources
• Ad - hoc reporting including calculated fields, web query, pivot tables, macros, v-lookups and VBA
• Supported HR Strategic Workforce and Talent Analytics team and initiatives
• Built data centralization repository for one source critical HR Data.
• Gather data from business units for the purpose of creating reports, dashboards and implementing enhancements to support projects.
• Worked independently while managing prioritization of projects and/or deliverables based on management’s and customers expectations

Environment: Workday, MS Access, VBA, Excel and SQL Server

Mortgage Reporting Analyst

Confidential

Responsibilities:

• Create and maintain mortgage operational analytics reporting and dashboards primarily using SQL (Oracle / SQL Server), SAS and Business Objects and secondarily Excel, Tableau, PowerPoint and Visio
• Implement and support ad-hoc weekly, monthly and quarterly mortgage reporting
• Gather data from business units for the purpose of creating reports, dashboards and implementing enhancements to support projects.
• Manage prioritization of projects and/or deliverables based on management’s expectations

Environment: SQL Server Studio Management 2008, Oracle 11, Equator Mortgage System, TOAD, SAS, Tableau

Business Analyst / SharePoint Developer

Confidential

Responsibilities:

• Capture mortgage reporting requirements using interviews, document analysis, joint design sessions, business process descriptions, Worked closely with internal technology groups to communicate reporting business requirements and validate results
• Worked with the business to collect SharePoint goals/objectives, document requirements, and design/test/deploy solution based on requirements; create SharePoint 2007 workflow, automation, notifications, dashboards, data view web parts, page customization, and forms within SharePoint sites
• Successfully engaged in multiple initiatives simultaneously including 3 major projects. 1) Servicer Logging Metrics 2) Business Rules Repository and 3) Scripting Fees Report

Environment: MS Access 2007, MS SharePoint Designer 2007, InfoPath 2007

Data Consultant / SQL Programmer

Confidential

Responsibilities:

• Supported Breach and Solicitation audit team with pre-foreclosure mortgage data for auditing breach letters being sent to borrowers; each state letter template had to be audited before released for production
• Extensive SQL Server script development including creating and dropping tables
• Used extensively as a resource for SharePoint development for other teams to support different pre-foreclosure projects including custom list, views, workflow and site development
• Worked independently from home 4 days a week

Environment: SQL Server 2008, MS SharePoint Designer, MS Access

Benefits Programmer/Analyst

Confidential

Responsibilities:

• Support Client Services Team Leader and client contacts as a subject matter expert and as technical systems resource for the benefit plans and employee populations of their assigned clients through the daily administration of programming, case management and project work
• Manage administrative and case management issues as well as data processing activities
• Test and analyze system configuration against requirement documents during implementation and administration in a development environment
• Use of proprietary Oracle database (Benefits Workstation) of tools to setup a client’s healthcare & group benefits database; define data fields, import data, design screens and create advanced queries and reports.

Environment: Benefits Workstation, SQL, Oracle, Sybase/Data Junction, Excel

HRIS Program. Mgr - HR Data Resources

Confidential

Responsibilities:

• Responsible for Core Data tables and Configuration tables in HR/Payroll/Benefits PeopleSoft modules: earnings codes, fed, state and local tax location tables, security tree maintenance
• Coordinated with Finance to be involved with all routine and ad hoc system and data modifications made in the Finance modules to ensure HR system stability; requested Finance combo codes and maintained Accounting earnings codes department charge changes
• Supported home-grown Global HR SQL server site that provided automated specialized data and reports from daily PeopleSoft feed

Environment: MS Access, SharePoint, VBA; Excel, PeopleSoft v8.9, ASP and SQL server

IT Data Analyst

Confidential

Responsibilities:

• Provided development, integration and report automation of desktop systems and servers both online and locally through raw feeds, Access databases and SharePoint lists.
• Engineered cross functional solutions using custom web parts, data views and templates
• Worked closely with VP of Desktop Shared Services and team of IT Systems Administrators in tracking out of scope systems using inventory systems and removing them from the network

Environment: MS Access, SharePoint, SharePoint Designer; Excel and Excel web services

HRIS Programmer / Data Steward

Confidential

Responsibilities:

• Engineered cross functional solutions, designs and develops solution interfaces, integrates solutions, supports solution design, and supports bought & built application software.
• Developed and oversee the production of HR and Payroll reports.
• Supported Compensation and HRIS department through reporting and automation of reporting processes
• Coded and configured diverse and complex programs from technical specifications to be used in-house.
• Documented system specifications, including job flows and data flows.

Environment: PeopleSoft, MS Access, SQL Server, Share Point; VB Scripting (Macro) for Excel, ODBC, PS/Query