Summary

Professional Experience

Confidential

Business Analyst

• Built a Monthly Score Card analytical package for State Partners providing a financial health check.
• Analyze data for trends and anomalies and then prepare reports for senior management.
• Lead and executed on reporting automation, metrics processing and analysis.
• Effectively communicate change and drive adoption of new reports with project needs
• Ability to manage stakeholder expectation and requirement, despite organizational challenges obstacles, imperfect data, and tight timelines.
• Support forecast and analysis efforts to arrive at business solutions.
• Provide business and Analytical solutions to end users in operations teams.
• Responsible for utilizing data from WIMS Warehouse Information Systems / FBS Food Beverage Systems / POS Point Of Sale systems to drive continuous improvement profit maximization by providing mock ups, samples and Prototypes.
• Design develop repeatable reporting solutions by leveraging BI and SQL Analytical tools.
• Participated as an internal audit team to perform the risk assessment, documented and provided feedback for improvement.
• Ensure proper requirement elicitation to meet business requirements.
• Provide requirement traceability matrix for business sign-off.
• Compile data in a presentable form for decision making.
• Provide Adhoc Reports to Directors and senior staff to shape the business according to the corporate strategic vision.
• Develop metrics to measure the strategic goals and KPI's using Business Objects Reporting suite.
• Lead and participate in a cross functional team to understand data needs and create business solutions.
• Create user requirement, interviews, mockups, requirement traceability.
• Provide ad hoc financial analysis and present facts from Fingate, SAP and POS system.
• Continually improve management reporting processes and systems to automate and simplify business requirements.
• Develop alerts to timely detect critical business issues by identifying the KPI's to be flagged.

Confidential

Analyst SAP-MM,

• Provided requirements for MOW material availability to Procurement.
• Implemented Project Stock feature available in SAP for material traceability for MOW Project Managers.
• Ensured scheduled material availability based on unique business requirements of Engineering production gangs.
• Provided analytical view of material availability to be merged with TLM production gangs.
• Provided inventory planning and management of Project and unrestricted Stock for Capital Projects.
• Prepared strategic methodologies and documented procedures for the Inventory planning and implementation in the new SAP environment.
• Provided a platform for co-coordinated efforts for Project Stock implementation between, Engineering, Procurement, Materials Management and Finance.
• Trained warehouse manager and Procurement management personnel on the SAP-MM-Project Stock initiative.
• Presented Project Stock initiative to a 40 member team during a Procurement Staff meeting, while explaining and convincing the benefits to Senior Management and warehouse managers.
• Presented a mock up with the help of SAM Project Managers and tested the functionality with Ariba, SAP in conjunction with Engineering Project Managers to validate approval flow to approve the proof of concept.
• Researched different approaches to maintain supply of high dollar material while maintaining high turn ratio.
• Provided strategic guidelines for the group to analyze and provide better service to internal and external customers.

Confidential PMO Support Analyst

• Analyzed Supply Chain data in Materials Management module.
• Provided support in PMO initiatives in SAP-MM data.
• Pre-loaded data using macros/Excel.
• Provided data validation prior to data load into SAP MM from various legacy systems.

Confidential ERP Business Analyst

• Supported Program Manager in the SAP Implementation status updates.
• Worked on segregation of duty and role assignments for providing access to various functional areas of SAP.
• Successfully completed knowledge transfers from contractors while maintaining an excellent professional relationship.
• Worked closely with program managers and project managers to support the successful development and implementation of project schedules based on release schedule.
• Updated and maintained project schedule as per customer requirements through interfacing with the Program Manager, Leads and various Program Team Members.
• Facilitated on-time and efficient completion of projects by understanding critical activities and alerts.
• Facilitated weekly Release Management activities and coordinated necessary checks and balance to meet audit requirements for code migration.
• Coordinated code release with SAM SAP team and supported after release activities.
• Prepared and distributed various cost and progress summary reports throughout the project life cycle to allow senior management and owner representatives to evaluate project performance.
• Acted promptly to resolve critical production release issues with minimal supervision by acting as a backup to the team lead by coordinating necessary actions by the Functional teams.
• Requested explanation of weekly release from Developers to avoid issues in Production.
• Maintained open ticket history for reporting purposes and provided a performance metrics.
• Collected status reports from all Functional leads and compiled a Project Status deck for a bi-weekly presentation.
• Worked with WMS Material Analysts user community to replicate and support existing reports by providing data feed to their SQL Server.
• Guide and communicate production release issues to Call Center personnel, enabling them to effectively handle questions from the end user population.

Confidential SAP Training Co-coordinator

• Recognized for outstanding achievement award Golden Spike Award for my training efforts in the SAM Project.
• Provided a supportive and satisfactory class atmosphere, by explaining the change from the legacy system to SAP. Audience group varied from warehouse foreman to management staff Project Managers, Budget Managers and Analyst who presented various business challenges.
• Trained the entire division from New York, Boston, Albany in SAP General Display, BI and offered Offer advanced computer skills training in MS Office Suite and other applications along with the certified SAP instructor for 4 months.

Confidential

SAP BI-BOBJ Report Developer/Functional Analyst

• Liaison with Engineering WEE , Human Resource, Materials Management and the Finance department to gather business requirements for the Business Objects reports.
• Performed GAP Analysis for the legacy system Finance-FI and Materials Management-MM , and performed comparative analysis between legacy and the new system.
• Analyzed the data flow and report calculations for Demand Forecast and supply chain reports for Material Availability.
• Cross validated BW data FI and MM by identifying and running ECC reports during UAT process.
• Analyzed and understood the existing SAP architecture by reviewing Multiproviders, Info providers and Info cubes to meet testing and validating needs.
• Created Functional Documents for BI Reports with input from Business users.
• Used BEx analyzer to test Inventory and ABC classification SAP-MM reports and facilitate data analysis using filters, navigational attributes, calculated and restricted key figures.
• Requirements gathered from other internal data sources like SAP MM, FI to meet external system requirements.
• Created Test scripts in HPQC and tested the requirements.
• Co-ordinated and conducted end user training for Business Objects Web reports SAP-BI- MM, FI and PR.
• Provided post go-live Level 2 support to end-users.
• Help setup BW security for user roles and Co-ordinated user access/security requests.
• Involved as a key member of project team through all phases of realization, go-live, post implementation support of SAP-BW in FI, MM.

Confidential

Work Element Explorer Officer

• Worked with Project Managers, Financial Managers in providing the Project Status Report explanation on an ongoing basis.
• Created a SQL based Stored Procedure to distribute the Corporate Lodging Invoice cost enabling efficient cost recovery by accurate cost allocation to each project.
• On a regular basis worked with Maximo team members in providing Summarized labor cost with detailed data from a Program Level.
• Worked with Maximo and mainframe team to investigate and data issues prior to upload.
• Loaded Primavera and Timberline data into Web Wee application and reconciled successful load.
• Supported data analysis needs of the Engineering business community.
• Worked on loading data from Mainframe to in-house costing software in a SQL Server database.
• Analyzed line item Labor cost in Maximo labor cost management for project managers.
• Involved in the data validation using Excel and access and testing of the new SQL Server.
• Provide adhoc reports labor and material cost to senior management to show project status using Business Objects.
• Prepared and submitted with approval journal entries for project cost allocation.
• Provide large adhoc data sets for OIG for investigative purposes, using new SQL report.
• Create and assign Reimbursable Work Element Numbers for Engineering Workforce for charging project cost.
• Extracted raw data from General Ledger mainframe , to validate the data displayed in In-house software.
• Provide technical and financial data support to Work Element Explorer and Web Wee users.
• Documented different processes like daily reconciliation, Cost allocation into easy to follow steps for team members.
• Performed TDR Time Distribution Report to allocate Project Manager Salary to relevant projects to recover reimbursable cost.

Confidential

Material Analyst

• Member of WMS Work Management System supported the forecasting module of materials requirement.
• Created BOM Bills of Material to be connected against the work order in WMS to capture project cost.
• Assisted WMS Implementation team with EMR Electronic Material Requirement Implementation in New York, Boston and
• Albany.
• Assisted in proposing the business need for Vending machine to stock and supply parts.
• Assisted in validating the WMS labor and material codes for issues, returns, and cost and location codes.
• Conducted cross departmental meetings for productive material availability and balanced the
• Demand and Supply between Mechanical and Supply Chain management team.
• Responsible for creating Crystal reports for Production Labor and Material scheduling teams and Material Analyst to
• Support the back shops carryout the scheduled maintenance work.
• Assisted Budget Manager with Material and labor Financcial data analysis for decision making.
• Created custom reports in SQL WMS data source for the Master Mechanic on locomotive performance.
• Performed Ad hoc analysis on Labor data using LMS- BRIO, material using BPC and SQL.
• Performed EMR testing on Work Management Systems material requisitioning process.

Confidential

Report Analyst

• Created Crystal reports for monitoring sales and revenues.
• Produced monthly revenue projections.
• Monitored and manage Logistics/ warehouse operations by creating decision support sales reports.
• Acted as a liaison to the controller on accounting and audit functions.
• Reviewed sales and commission contract calculations between suppliers and the parent company.

Confidential

Quality Assurance Consultant

• Validated Sales Force Automation data.
• Developed test plan and test scripts using PL-SQL.
• Documented of Sales Force Automation process.
• Validated the data based on FDA regulations.
• Analyzed Clinical Data and provided financial statistics.
• Validated requirements by creating a requirement matrix.

Confidential

Healthcare Quality Assurance Analyst

• Clinical data validation and testing of Sales Force Automation data.
• Audit data files from multiple sources to the destination systems for accuracy.
• Investigate and answer questions Sales force pertaining to published sales reports.
• Load data from flat files to SQL server via automated scripts.
• Create individual Databases for analysis and review by JACOH and Hospitals.
• Documentation of Sales Force Automation process.
• Review and manipulate the ICD-9 code data for reporting.
• Provide ADHOC request per JACOH inspections within the time allowed for passing the inspection.