Business Systems Analyst III Resume Example Oracle Corporation

BUSINESS SYSTEMS ANALYST III

Summary

Accomplished business analyst with 2+ years of expertise in Business process improvement and data analysis. Skilled in achieving operational efficiency and increasing revenue.Employs root cause analysis to identify issues and develop process improvements that lead to cost savings.exceptional planning and implementation capabilities.

Highlights

Business process analysis and improvement
Forecasting and Planning
Advanced Excel Modeling
Expert in PL/SQL language
Advanced Data analysis MS Excel
Business Systems analysis
Clear result Oriented
Strategic and analytical oriented

Budgeting
Project management
Project life cycle
Agile software development& RUP
System development life cycle (SDLC)
IS change management
Strong communication skills written and oral

Accomplishments

Promoted to Lead Analyst after just 9 months of employment.
Led a four person team of multi-country analysts in completing the $500,000 budget HSGBU SaaS project at Oracle Corporation.
Completed urgent ad-hoc reporting requests for various levels of management within required time frame and with 96% accuracy
Automated repeatable tasks where possible to increase efficiency.

Experience

Oracle Corporation January 2014 to Current Business Systems Analyst III
Dallas, TX

Act as Subject Matter Expert of business processes and facilitate day to day operational infrastructure and systems needs
Analyze and collect business requirements identified system interfaces and create the requirements specification document.
Involved in a range of scenarios such as data discovery and data mining, understanding and providing data requirements to development groups, and data issue resolution with support groups
Identify current limitations in existing operations/workflows and areas of redundancy within the existing systems and define, document and present requirements for integration/improvement of these systems
Perform requirement analysis by gathering both functional and nonfunctional requirements based on interactions with the process owners. Performed user interviews, JAD sessions.
Write Functional Requirements Specification (FRS) documents as per the business requirements and process flow.
Pull data from multiple sources including SAS data sets, SQL Server, Teradata and Oracle tables.
Use MS Visio to create data flow diagrams and context diagrams for the developers and business stakeholders.
Create the use-case document, use-case realization and functional spec document for the lead management system. Support the rules analyst for the creation of data mapping document.
Manage and track change control process of requirements and design changes using Rational Requisite Pro.
Provide documentation such as requirements management plans, operational risk management plans, functional requirements, test plans and test cases.
Support the assigned project manager with creating detailed project plans and assisting in developing, scheduling and tracking project timeline.
Extensive knowledge of UML modeling, drawing sequence diagrams and activity diagram using tools such as Microsoft Visio and Rational Rose.
Function as User Acceptance Testing Coordinator and monitor business testing and interfaced with the development team regarding defect status and fixes on daily basis.
Skilled in coordinating and communicating between Developers, QA Teams, management, QA and project leads and stakeholders to keep them informed at all the times about the development and the open issues.

JP Morgan Chase January 2013 to January 2014 Business/Data Analyst
NYC, NY

Integrated the SDLC process into the team tracking tool, created reports to track progress.
Ran queries and pulled data from Oracle tables and Teradata to compare data integrity.
Created reports using Toad and MS Excel for executive review each week to track weekly submissions and completions in the change control workflow.
Maintained team SharePoint site, created reports for change control workflow and shared document library.
Conducted extensive meetings to understand the business model and processes, documented and gathered the business requirements and carried out implementation of new derivative products.
Worked extensively with business users and SMEs including heads in areas of fixed income derivatives, options, foreign exchange (FX),Finance control, product control futures and risk managers in understanding, extracting, refining and documenting the User and Business Requirement Specifications in the BRDs.
Consolidated and reconciled trade date from across multiple settlement platforms likes equity, bond market, derivatives and commodity market.
Gathered the necessary information to document and/or develop strategic plans and business requirements via agile methodologies.
Used Crystal Reports to generate reports from different databases of different asset classes like equities, bonds, derivatives, commodities, for all business needs.
created use case scenarios and maintained the use cases (business use cases, system use cases) and modeled use case diagrams, activity diagrams, business flow diagrams, revised functional specifications and other core materials throughout the system life cycle making all necessary revisions for defect correction and requirement clarification and refinement.
Performed gap analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
Collaborated with product owners, business analysts and development managers to plan releases and managed feature backlog.

Education

Gannon University May 2011 MBA: Finance & Economics Erie, PA, USA

Finance & Economics

Veer Narmad South Gujarat University April 2006 Bachelor of Science Bharuch, Gujarat, India

Skills

Data base management system software: Microsoft SQL Server; Oracle PL/SQL; Oracle software; Relational database software
Data base reporting software: SAP BusinessObjects Crystal Reports; SAP BusinessObjects software
Data base user interface and query software:IBM DB2; Microsoft Access; Oracle Essbase; Transact-SQL
Data mining software:Data warehouse software; Informatica Data Explorer; SAP Netweaver Business Warehouse

Resume Overview

Create a job alert for [job role title] at [location].

About About

Help & Support Help & Support

Languages Languages

Customer Service Customer Service

Business Systems Analyst III Resume Example

Resume Score: 85%