SUMMARY:

• Accomplished Business Analyst skilled in achieving operational efficiency through detailed analysis to develop, document, and deliver process innovations that drive business goals.
• Strong ability to determine user needs and develop tailored solutions that transform company/client practices to foster growth.
• Solid expertise in a variety of Confidential and platforms, and able to communicate complex data and concepts to a diverse client audience.

TECHNICAL SKILLS:

Operating Systems: Microsoft Windows /XP/VISTA/7, UNIX

BI Tools: SAP HR, SAP FI, SAP SD, Oracle Hyperion, IBM Cognos

Quality Management: IBM Rational Manual Tester, Quality Center, QTP

Business Modeling Tools: Rational Rose, Microsoft Visio

Version Control: Rational Clear Case

Change Management Tools: Rational Clear Quest7.1, Requisite Pro v7.1

Reporting Tools: Crystal Reports, Business Objects, Cognosv8.0

Project Management: Microsoft Project Professional

SDLC Methodologies: Water Fall, Prototyping, Spiral, Rational Unified Process (RUP), Agile

Miscellaneous: MS Office Suite, Lotus Notes

PROFESSIONAL EXPERIENCE:

Confidential, Livonia, MI

Business Analyst

Responsibilities:

• Provide detailed reviews and analysis of client business needs and recommend corrective actions designed to improve service quality and value for their customers.
• Perform data audits for clients, requirements/gap analysis, author summaries, and collaborate with internal teams on content and scheduling of client deliverables.
• Serve in a key role on various teams through all project phases to ensure business objectives are met and draft requirements for review and approval by senior leadership from both company and client sides.
• Develop and maintain business requirements, technical/functional specifications, process workflows, use case diagrams/documents, and traceability matrix documentation.
• Author test cases to review applications, design and implement basic SQL queries for QA testing and report/data validation.
• Participate in Joint Application Development (JAD) meetings with IT and project team members to conduct gap analysis tasks and develop use case and user story documentation.

Confidential,Auburn Hills,MI

Business Analyst

Responsibilities:

• Handled Monthly, Managerial, and Security closing and forecasting processes.
• Designed Essbase applications with balance of Dense and Sparse Dimensions.
• Developed comprehensive reports with Hyperion Financial Reports, Excel Add - in, and Smart View, created cubes leveraging a variety of storage options, and retrieved data to analyze cube outlines for data integrity.
• Granted user access based on established needs and assigned them to specific groups for preservation of confidential data.
• Author test cases to review applications, design and implement basic SQL queries for QA testing and report/data validation.
• Optimized outline structure, loading, and calculations through development of appropriate dense and sparse settings of dimensions, storage allocations, and dynamic calculations.
• Created Rules files to migrate data from client’s financial database Essbase cubes, and built linked and transparent partitions between source and target cubes.

Confidential,Farmington Hills,MI

Business Systems Analyst

Responsibilities:

• Created new cubes and migrated existing ones from older Essbase server to an upgraded Windows environment with all historical data intact.
• Ensured data integrity through all security and change management phases.
• Leveraged a migration wizard program to port cubes from Essbase 7.1.3 to System9.
• Developed report scripts to export data files and compare with Informatica files.
• Installed, configured, and maintained Hyperion System 9 environment and Shared/Analytical Provider Confidential platforms.
• Fabricated SQL scripts, indexes, and complex queries to perform quality assurance and server environment testing.
• Supported business users in the retrieval of critical data in Smart View format.
• Created a variety of documents for installation of Smart View and to stop/restart Essbase Confidential .
• Maintained and monitored individual and group users in Shared Confidential .
• Developed web forms, business rules, and sequences for authorized users.

Confidential,Ann Arbor,MI

Business Analyst/Analyst Reporting

Responsibilities:

• Retrieved data from SAS into Essbase and prepared daily reports for review by authorized users.
• Copied and migrated exported data into various technical environments.
• Added and provisioned users and groups into the LDAP directory.
• Created and modified report scripts designed to extract and migrate data for cube balancing.
• Prepared Maxl scripts to rename applications and subsequent provisioning of users.
• Developed and modified .Property and .CFG files in Essbase and Provider Confidential .

Confidential, Lisle, IL

Essbase Analyst

Responsibilities:

• Provided high-level support to resolve production issues, including eradication of bugs in Intranet applications and Essbase cubes.
• Maintained cubes to display Essbase Status in easily identifiable views.
• Performed database administrative activities including, but not limited to, user and group creation, setting of passwords, and establishment of filters.
• Modified and redeployed applications in development, test, and production servers.
• Authored and distributed user documentation.