TECHNICAL SKILLS:

Microsoft: Excel (PIVOT, VLOOKUP, Other Macros), Access, PowerPoint, Word, Outlook

ERP: SAP ECC, Vistex, Hyperion Enterprise, Hyperion Planning, Platinum, Macola,Great Plains, Oracle 11i, Oracle FDM, Oracle HFM, Oracle Essbase, Oracle EPM

BI Apps: SAP BW/BI, SAP BEx, Business Objects (Web Intelligence), Cognos Finance, Data Mart, Siebel,Sharepoint Sites, EPM/HFM Smart View

Others: HP ALM Quality Center, Cransoft, SQL, Database Query

PROFESSIONAL EXPERIENCES:

Confidential, Eagan, MN

Senior MASTER DATA ANALYST / BUSINESS ANALYST

• Completed Confidential Canada SAP rollout under Catalyst project
• Ensured conversion projects / site locations follows EBS business model and SAP standards
• Collaborated with local businesses and functions to align properly to EBS’s structures in certain areas f master data components
• Participated in ongoing process improvement initiatives for EBS and Catalyst programs
• Primary functions supporting: Finance (ECC - FI,CO) and Pricing (SD-ECC, VISTEX)
• Defined and Integrated Intracompany and Intercompany business processes on SAP.
• Performed business process reviews, data requirements gathering, data migration activities, resolve issues with the businesses and functions for above data objects.
• Worked in collaboration with cross functional teams to resolve defects, help define and test solutions to issues raised by the business / functional teams related to above functions.
• Developed Master Data Validation test scripts (ALL cycles) for above functions.
• Conduct detail reviews with functional team members for execution and post testing results validation and analysis.
• Documented going forward business processes in assigned areas / functions above.
• Provided and lead business and functional SAP training for above functions.

Confidential, St Paul, MN

Lead BUSINESS SYSTEMS ANALYST

• Worked on various assigned process improvement projects (local and global) involve different ERP sources and target systems (EBS global account mappings, SG&A harmonization)
• Assessed and ensure proper processes and solutions are in place to achieve end results with current and future state.
• Worked with various business groups and users on testing and validating new or additional functionalities between ERP source systems and Oracle HFM/EPM.
• Provided system supports including new enhancements deployed to the CP&A group, other business groups, and various finance users.
• Configured moderate to complex dimension mappings from source systems (ERPs) to target systems.
• Completed full testing, validation, deploy updates / changes to selected systems for business users.
• Communicated to business users on successful updates and recommendations on potential issues.
• Documented business and systems processes for internal controls and training.
• Ensured business requirements are met with various business groups / users in a timely manner.
• Processed improvement initiative - Documenting, analyzing and reporting on how entities utilize systems globally for potential areas of system/process improvements.
• Developed and tested new Oracle HFM application to support new, improved business reporting need.

Confidential, Golden Valley, MN

FINANCIAL BUSINESS ANALYST 

• Worked with HBS finance team and Center of Excellence (COE) IT team on SAP ECC 7.0 implementation project complete life cycle from planning to post go-live supports.
• Functional/Technical specs - Worked with IT (COE) team member(s) with specific business requirements (MM-inventory valuation, product costing, and FICO-cost transfers/Intercompany).
• Data Mapping / Configuring - FI - Fixed Assets; CO - Cost Elements, Product Cost Collectors,
• Production Orders, Internal Orders; MM - Product Costs, Product Hierarchy.
• Worked closely with manufacturing business team, FI (AR/AP/CO), MM, Supply Chain, SD, PP, PS,
• FSCM and Logistics functions for business process requirements, data cleansing, process flows mapping and scenarios testing.
• Data Validation / Cleasing - Validated fixed assets, MM, product costs and inter-company selling prices, vendors, banks information, cost and profit centers, companies codes.
• Business User Acceptance Testing - Developed assigned FI/CO and MM test scripts for end-to-end test cases and tested various cross functional scripts and business scenarios including test data, validation rules to address business requirements for both current and future states.
• Raised BMC Remedy tickets for failed tests and logged all testing results in Quality Center (Mercury) systems. Worked with technical team to resolve these issues.
• Master Data (MDM) - Validated and ensured data are set up correctly for FI, CO and MM areas.
• Reviewed and documented process gap analysis related to manufacturing finance or MM area.
• Analyzed affected business processes / workflows and made updates wherever applicable.
• Process Flows - Assisted with “As-Is” and “Future-To-Be” business processes documentations.
• Training – Developed training documentations and trained business users in the area of manufacturing finance, and the usage of admin, internal projects.
• Post go-live supports – Monitored and obtained resolution for any issues arise after go-live n SAP for MM-material masters, product costing, FICO and PS-internal projects.
• BI Reporting – Obtained reporting requirements from the business, worked with technical reporting team to solution, design, test and set up required reports in SAP BW/BI.
• Partnered with cross functions and COE teams on testing and solutioning new or additional issues raised by the business to support optimal performance and business results.
• Provided on going communication to CP/S program management and business users with respect to issues encountered and recommended solutions to mitigate issues.

Confidential, St Paul, MN

BUSINESS INTELLIGENT ANALYST (CONSULTANT)

• Maintained and enhanced MS Access databases, OLAP, SQL queries as needed to support current and on-going reporting requirements related to sales commissions processing.
• Assisted with the identification and development of business applications that work effectively with the company’s ERP systems and business needs.
• Prepared sales commission reports for all in-house and external sales completed.
• Worked with company’s ERP systems and BU users to ensure related data are accurate and accounted for.
• Downloaded sales data to Access databases from ERP system – Great Plains, resolved errors from exception validations occurred during download runs.

Confidential, Eagan, MN

OPERATIONS ANALYST

• Dashboard Reporting (Access) - Obtained and consolidated financial, sales by product line and other key performance metrics (KPI) from various global regions for GOIS BU senior management.
• BU Reporting (BO) - Developed standard and ad-hoc reports in Business Objects (Web Intelligence) for various operation managers and users within BU.
• Financial Analysis Performed monthly variance analysis to forecasts and operating plan for assigned business groups, and KPI metrics variation from industry standards.
• Process improvement (global) Identified inconsistencies and worked with corporate finance with change / update to the accrual procedure for T&M contractors companywide.
• Global cost allocations - Advised GOIS managers with best method for shared costs pool allocations (for cRIM, Secured Clouds, etc) that aligned with company current business processes.
• Ensured all appropriate charge outs (JVs) to various user groups (direct clients and internal projects) for certain products or services utilized occur monthly.
• Assisted project and finance managers with new product / service business cases analysis.
• Worked closely with project managers and PMO team on capital and non-capital project requests, financials monitoring, tracking and reporting from start to finish.
• Provided project accounting functions for various internal, admin and R&D projects.

Confidential, Richfield, MN

GLOBAL CONSOLIDATION & REPORTING ANALYST (contract)

• Full system administrator for Cognos Finance including user access set up, user training, all modules, master data mappings, report writing, execution, data loading and validation.
• Maintained reporting structures and hierarchies in Cognos Finance.
• Performed routine system month - end tasks such as all dimensions and cubes validation, foreign currency rates updates, region submission template and reporting readiness.
• Received financial data from various entities/companies, verified for completeness and accuracy, and uploaded into Cognos.
• Consolidated all entities financials in Cognos for reporting.
• Identified and provided relevant, critical reports to business managers and senior management.
• Established and maintained communications with the various regional entities with respect to reporting needs, system access and monthly financial variances from forecasts / budgets.
• Updated Sarbanes-Oxley documentation for consolidation and reporting, inter-company reconciliations and continuing process improvements companywide.
• Conducted various accounts and statement analysis for divisions and/or entities/companies.
• Main contact for remote users and provided assistance with coding, mapping as required.

Confidential, Shoreview, MN

FINANCIAL SYSTEMS ANALYST

• 2 SAP ECC full - life cycles implemented from planning to post go-live support including data requirements collection from BU and users, data mapping, validation, testing and conversion.
• Worked with various business managers and users to gather requirements and analyze needs with other cross functions including MM, SD, PS and FICO.
• Data mapping / Configuring completed for: FI - General ledger accounts, Fixed Assets, Intercompany;
• CO - Profit and Cost centers, internal orders; MM - Product types, Product costs, Production orders.
• Master Data (MDM) Validated and worked with shared services for customers, vendors, profit and cost center changes and adds maintenance. Set up and maintained internal orders (CO), production rders (CO), internal projects (PS), product types and product costs (MM).
• Business Acceptance Testing - tested FI/CO scripts and validated results / impacts to other modules.
• Ensured successful tested scenarios met business requirements and provided knowledge transfers.
• Completed all financial data conversion activities for SAP FI/CO area.
• BI Reporting - Worked with IT (CSC) to develop, design and execute new reports in SAP
• BW / BEx to standardize and simplify reporting processes per business requirements.
• Implemented new procedures for recording employees and contractors time and material costs.
• Lead and power user for the finance modules (FI/CO, COPA) of the SAP system.
• Documented overall SAP FI/CO workflow processes used for training material and current use.
• Provided training to BU managers and users on overall SAP system functionalities related to FI/CO and MM.
• Troubleshoot, resolved and provided solutions for the FI/CO areas in SAP system.
• Provided on-going support and maintained SAP system including communication with parent company regarding changes / enhancements for processes, mapping, etc.
• Worked with BU s existing BI tools SAP BW, Siebel and Data Mart set up various operational reports, ensured business needs are met and provided on-going support for these areas.
• Ensured recognized revenue on projects and expenses / costs are allocated correctly.