SUMMARY

• Specializing in integrating IT solutions for business data analysis with emphasis upon Procurement, Payroll, Budgeting and Accounting functions in a training, call center help desk, and management consulting capacity at varying stages of the project life cycle in a PMO environment with PMP methodology.

TECHNICAL SKILLS

• Business Analysis
• Data modeling
• MS Project Server
• PMI Project Management and ITIL certificates. Cognos
• MS Project
• Visio
• Macintosh OS Systems 10.1
• SQL
• Meditech
• ICD 9
• ICD 10 medical coding. Agency Systems and CMHC4 medical applications. Medicare and Medicaid FAMIS applications. Agile
• SRUM
• Active Directory
• BMC Remedy
• SAP (Business Objects
• SAP plant maintenance material management production and planning sales and distribution
• FICO
• HR Management System FMS 2
• FMS 3)
• Oracle OBIEE
• Oracle Siebel CRM
• MS Dynamics 365 CRM Module
• PMI Project Management Concepts
• SSRS
• PeopleSoft NYCAPS
• Amber Pro POS
• JD Edwards POS
• SharePoint
• ADP
• Check Systems
• SAGE Abra HRMS
• UAT
• IITL
• Payment Information Portal
• City Time
• Citrix
• Juniper
• NYC Application Payroll System
• HTML
• Evolve
• Software As A Service
• Service Level Agreements
• Vendor Source
• Vendex
• DMS
• PMS
• Clear Quest
• Wages
• Loops
• DABS
• FAMIS
• UAP. Archer vendor sourcing
• Crystal Reports
• Oracle SQL
• Visual Basic
• C++
• Application Testing and Training.

PROFESSIONAL EXPERIENCE

Confidential

PMO Regional Business Analyst

Responsibilities:

• Managed Human Resource, IT, staffing, Office openings, promotion and community liaison and inter government relations to support local area managers within North East region.
• Managed and monitored Service Now with BMC Remedy and SharePoint integration.
• Monitored infrastructure server room and supervised new wiring installation.
• Administered agile methodologies on developers in JIRA by UAT of fixes and enhancements for Business Requirement Documents and technical designed documents with version control presented to various stakeholders.
• Performed Quality assurance monitoring while work was in process to insure standardize requirements were met with sustainability.
• Produced Project and test plans, application rationalization proof of concept, dashboard, SQL reports, business requirements and process flow for ongoing operations from regional to local offices which included as is and as is to be models.
• Produced budget forecast from various department reports in Excel and Tableau.
• Updated SharePoint application for change management and produced PowerPoint Presentations and Excel Pivot tables of regional outputs.
• Managed HR applications Oracle PeopleSoft DAPPS, WebTa, payroll, time keeping, comp time, premium pay requests, annual leave, paid time off, and health and retirement benefits applications. Worked with hiring certification lists.
• Administered recruitment activities through MOJO within designated geographical territories displayed by dashboards, score cards, tables graph and charts.
• Worked with lease assets and Information technology automation to open new regional offices providing phone, internet, remote citrix access, keys, alarm codes, furniture and office supplies.
• Managed Remedy and SharePoint to track projects, access, training, standard operating procedures, and goal projections.
• Process pay roll through Oracle People Soft financials 9.2 DAPPS and Web Ta, reconciled accounting functions AP, AR, GL, and Procurements.
• Provided in person and computer - based training for managers in partnership, recruiting, field operations, human resource administrations, lease real estate assets, and information technology and automation.
• Managed purchase and procurement of supplies and furniture through out supply chain from warehousing to distribution and collection and close out.
• Produced high level SQL and other reports from various systems in addition to Excel, Visio, and PowerPoint presentations.
• Process travel expenses through E2 solutions while assisting various offices.
• Provided diverse assistance to local office managers to meet goals and deadlines.

Confidential

Business Data Analyst

Responsibilities:

• Created and executed change management project work plan, standard operating procedures and data governance for various executive management staff out of which included directors and vice presidents to be viewed on Project Tracker and MS Project for Enterprise and Governance analysis.
• Managed action items from Goto live meetings and Webx minutes.
• Produced SWOT analysis with application rationalization and proof of concept while monitoring and observing stakeholder sites.
• Produced Visio Process flows and data analytics for dashboard and technical design documents and requirements.
• Admin for SharePoint collaboration, OBIEE reports analysis and Innotas resource management for budget time and scope.
• Customized Oracle Siebel OBIEE reports with business subjects, data dictionary, and site mapping.
• Utilized Agile Methodology for enhancements and fixes with Jira to track business and technical requirements for Oracle Siebel CRM and MS Dynamics CRM.
• Implemented ETL with fetch XML for Microsoft CRM Dynamics 365 with SQL server and SharePoint 365.
• Managed team that linked point of inspection scanners with Point of Real estate sales applications through the CRM. Tool.
• Liaison between IT, Business, PeopleSoft POS, Finance Oracle PeopleSoft GL, Legal and HR Depts with BMC Remedy Service Now for change management upon enhancements and builds within Oracle CRM Siebel.
• Developed Data modeling, wireframes, dashboards, scorecards, SQL and business object reports from data dictionary to integrate ERP platforms for quality assurance, data warehousing analytics, and data governance.
• Provided human resource management utilizing Kronos time keeping and NYCAPS PeopleSoft Payroll for procurement management.
• Facilitated disaster and recovery with fail over testing and security fire wall assessments documented SOP and governance plan for SQL Server and CRM applications.
• Produced requirements for MS Dynamics 365 in an agile environment with SCUM sessions and updated development in JIRA and project management plan in both Project tracker and MS Project.
• Produced MS Dynamics 365 Reports for specific demographics utilizing Fetch XML.
• Performed quality assurance on GIS property maps, inspections scanners, and recertification process.
• Documented Siebel Architecture and entity relationships utilizing Visio and updated SharePoint Site with Oracle CRM Siebel and Office 365 documents in which included Excel pivot tables and VLOOKUP.
• Provided Quality Assurance and data analytics with Customized SQL Oracle OBIEE and OBAI Business Intelligence reports and Tableau dashboards.
• Identify resource needs by meeting within the field staff, technical managers, business directors and vice presidents.
• Facilitated network failover testing and updated progress in MS Project Server.
• Facilitated JAD and Scrum sessions for Siebel CRM and .Net development in an Agile environment.
• Facilitated Office 365 and SharePoint migration with metalogic tool. Functioned as Share Point Admin.
• Analyze Housing Choice Voucher program rent calculations, eligibility requirements, landlord calculations and government regulations so that the technology applications can execute those compliances.
• Performed SWAT analysis for Lease Housing program, procedures, and technology to mitigate risks.
• Liaison between Finance Business and Technical teams
• Analyze and documented (BRD) business requirement documents and technical requirements for Oracle CRM Siebel Database.
• Provided resource demand management via Kronos and tracked ROI per allocation.
• Collaborate with Siebal Developers and admin to enhance business needs and technical process flows with design documents and data models across the SDLC.
• Carry out business analysis and assist developers with business knowledge.
• Write and publish IT technical documentation (i.e. Functional Specifications, process flows, and use cases) in line with the systems development life cycle process developing both written and visual depictions of requirements and Visio process flows.
• Conduct gap analysis between applications and stated requirements.
• Define exception report requirements for process completion.
• Perform data analysis for generating reports on a daily and/or periodic basis.
• Participate in business redesign sessions, to provide insight during solution development.
• Report status to key stakeholders - project team, internal management.
• Review and validate test cases.
• Form strong relationships and interface closely with all functional areas, e.g. Business Staff, IT and Quality Assurance to gather data and ensure the final work product meets expectations.
• Participate in issue management and tracking.
• Make consultant recommendations that improve effectiveness, efficiency, customer service, compliances, and other benefits as determined through the diagnostic process.

Confidential

ERP/ Business Data Center Analyst

Responsibilities:

• Capacity and Performance Monitoring and Planning - Met with management of Server, Storage, and DBA teams to ensure quality assurance and risk mitigation.
• Pinged virtual and hard servers after fail over testing with outside vendors.
• Updated patches for servers and mapped out network infrastructure process flows.
• Managed Data modeling for various applications and servers including data dictionary and site mapping and other process flows.
• Managed Office 365 and Windows 10 with Metalogic migration tool and Epic migration for global users in Windows 2012 server environment.
• Linked Office 365 with SharePoint and MS CRM Dynamics for Change, Incident and Knowledge Management content with Metalogic Migration tool.
• Produced Dynamics CRM reports on redundancy, departments, and costs.
• Created application rationalization proof of concept for asset management and software as a service with version control and other specs.
• Managed the Material Infrastructure Asset Management tool the SMART Portal to track technical inventory and Request for Proposals for Data Center. Executed Excel and Access reports from the SMART application to validate data integrity.
• Managed External vendor projects out of which included asset inventory, storage split, and sever migration and resource allocation with Plainview Innotas and MS project server.
• Compared data center servers in Excel for costs, duplicates, IP addresses and expiration dates on service level agreements utilizing pivot tables and vertical lookups.
• Created functional, technical and business requirements form statement of Work and updated SharePoint site.
• Monitored and Controlled Procurement process and Asset Management via SAP plant maintenance module and MS Dynamics CRM.
• Administered functional technical and business requirements for Data Center merger and spits.
• Monitor server, storage and database capacities updated dashboard to track milestones.
• Prepare monthly report on Core Infrastructure capacity utilization and projections
• Compile reports on projected infrastructure growth
• Perform analysis on capacity utilization of technical assets via Tableau.
• Contract and Finance
• Produced Business Requirements for migration of Seletica to PeopleSoft Financials.
• Performed user application testing and training for PeopleSoft Financials.
• Performed user application testing and training for HEAT Front Range service now application for change management purposes.
• Maintain infrastructure budget spreadsheet with contract dates, balances and annual maintenance agreements.
• PeopleSoft Financials Liaison with Contract management and IT Finance on the progress of contract and requisitions.
• Assist in Preparation of annual Capital and Operating budgets via Selectica, PeopleSoft Financials, Excel and Access.
• Updated budget detail fund Spread Sheet for Data Center Procurements.
• Inventory Management
• Maintain Excel Core Infrastructure equipment inventory, licenses, contracts/licenses start and end dates - review automation strategy
• Perform annual reconciliation of equipment maintenance and license agreements with outside vendors.
• Perform financial analysis (ROI) on equipment refreshes and hardware/software selections
• Maintain record of equipment, licenses decoms/purchases for reconciliation with vendors. Workflow Optimization
• Perform Innotas analysis on management resources and on where staff is spending their time.
• Tracked project progress in Planview Innotas.
• Track and report on number of change tickets, service requests and outages. -
• Compile reports weekly/monthly for review with managers on the projects against which staff log their time.
• Help to review operational procedures/processes to determine where improvements can be made.
• Orchestrated Change Management and ITAM process within Service Now and monitored outages with assessment of root cause analysis.

Confidential

Project Manager /Business Analyst

Responsibilities:

• Created functional, technical, and business-related requirements for the Evolve application migration from Facets and customization and updated project plan.
• Help to facilitate migration from Windows 8 to Windows 10 and Office 365 performed QA on Issue log.
• Analyzed business requirements for report, form, formset, event log, event, category, billing, medical coding ICD 9 and ICD 10, Procurement, Finance, Account Receivable and Account Payable, Legal, HR staff and Payroll functions, patient and client treatment and enrollment, education, child youth services, foster care, adoption, and other services.
• Analyzed data dictionary and developed SQL queries for the customization of databases in which includes tables, groups, fields, forms, and reports utilizing Net Smart Evolve Application, MS SQL Server, Excel, Access, Crystal Reports and Electronic Health records.
• Functioned as Excel expert with Macros, formulas, pivot tables, vertical lookups, delimiters, and concatenation for various departments.
• Assisted in usability application testing, creation of training manuals and software training to update project plan migration for presentations for change management and executive management.
• Transformed Stakeholder Business Requirements into data reporting tools after UAT testing and application rationalization proof of concept .
• Developed SQL reports, pivot tables, access queries for senior level management and quality assurance and human resources departments.
• Updated project management plan within time, scope and budgetary constraints utilizing SharePoint.
• Assisted finance departments with budget queries relating to payables, receivables, procurements, donations, grants, HR payroll, and equities.
• Performed quality assurance and risk assessment on various excel reports utilizing pivot tables, vertical lookups, delimiters, and concatenation.
• Advised CFO on vendor procurement, service level agreements and standard operating procedures for Information Technology, Risk Analysis and Quality Assurance departments.
• Updated resolved issues in BMC Remedy.
• Facilitated application development, testing, training during migration and upgrade of Evolve from FACETs.

Confidential

PROJECT BUSINESS SYSTEMS ERP PMO ANALYST

Responsibilities:

• Administered and managed business process model and requirements for consolidation of business units into PMO Project Plan.
• Facilitated the installation and migration of MS Office 365 with user application testing and training.
• Produced PowerPoint presentation with integrated applications for C level and executive management and staff.
• Developed technical SDLC requirement plans for active directory via Windows Exchange 2013 on Windows 2012 server set up
• Catalogued MS Office and technical inventory in SAP Plant Maintenance Module.
• Produced SQL reports from various departments and uploaded to SharePoint groups for migration and change management for online viewing.
• Updated Marketing and Sales info in MS CRM Dynamics. Customized regional sales groups and their stats.
• Administered comparative analysis of Banking Procedures and Payroll out of which included PeopleSoft, SAP, Check Systems, ADP and Quick Books for corporate change over and consolidation throughout the enterprise.
• Analyzed commercial lease agreements, common area maintenance costs, utilities, storage etc. for merger of assets for C Level and Executive Management with SAP plant maintenance module.
• Analyzed Data Analytics with Excel pivot tables and SQL queries. Visualization Infrastructure and ETL projects for business consolidation.
• Administered SOP, business and technical requirements for Human Resources, Marketing, Finance departments and IT Software as Service departments.
• Developed Business requirement plans from pay roll applications SAP, Check Systems, ADP, and PeopleSoft to quick books for CPA.
• Developed financial requirement plans for operating budget forecasting out of which included historical, estimated vs. actual values.
• Analyzed logistical and supply chain distribution of good and services channels for merger of Business Systems.
• Provide functional and technical support for the Access and Excel Project module and all other modules that interface with it (HRMS, Quote to Order, CRM procurements, GAAP for AP, AR and GL, Workflow, Order service Management, and Time and Labor to be migrated to Oracle and SAP.
• Produced ODBC SQL reports from various sources out of which included Cognos, Access, SAP and Oracle for PMO Senior Management assessment.

Confidential

PROJECT SYSTEMS Analyst

Responsibilities:

• Facilitated ETL global migration of SAGE Abra Human Resources Management Systems Data to JD Edwards and validated data via Excel and various reports.
• Performed UAT testing of legacy and live application resulting in cleanup of SAGE HR and implementation of JD Edwards respectively for PMO.
• Helped to facilitate mapping business requirements from Human Resources to technical requirements for change management.
• Assisted benefit manager in cross referencing null and replicated data values via Excel pivot tables.
• Cross referenced both payroll systems with process flow documents to validate calculations.
• Helped to administered collaborative stakeholder meetings using Power Point presentations.
• Produced SQL Access reports for data validation.

Confidential

Business Analyst

Responsibilities:

• Analyzed senior management PMO and ITO weekly and monthly reports process business models, dashboards from various branch and vendor locations to assess trends, forecasts, compliance, service level agreements, risks, security, quality assurance and process improvements for service and asset management for Network Data Support and Network Data Security Divisions. Procurement upgrade through Archer and Ariba
• Utilized Microsoft Access SQL Queries, Visual Basic Scripts, Excel Pivot Tables, Vertical Look Ups, Oracle ETL, HPSM help desk management systems, knowledge-based articles, VPN and Remote access for Data Analysis and Access Validation for project server.
• Procured Office 365, Windows Exchange Server and Windows Server 2012 via Archer and Ariba.
• Analyzed Global Supply chain of technical Assets.
• Created Incident management, change management, Knowledge Based, Dash Boards, and various charts and graphs from HP Service Management Systems in Visio and Excel.
• Reviewed vendor data via requisitions and purchase orders funneled from Ariba to Archer, Excel and HPSM for analysis.
• Reviewed technical Procurements in SAP Material and Maintenance, FICO modules from Vendors AT&T and Verizon Consortium PMOs.
• Tracked vendor sourcing, Microsoft Office upgrade and service level agreements through RSA Archer and Ariba.
• Gathered requirements for GAP, Pareto and SWOT analysis via JAD Sessions, vendor and management reports and Stakeholder meetings and updated info in MS Project.
• Made sure info was in compliance with SOX / Sarbanes Oxley, Dodd Frank and other government regulations.
• Utilized SharePoint as Global resource management tool to interact with on shore and offshore geo teams who worked on knowledge-based Content Management Systems.
• Analyzed Human Resource Management reports for mean time to recovery, down time, severity levels, customer impacted and service cost outs.