SUMMARY

• Highly proficient Business Analyst with over 12 years of experience in business analysis, business requirement gathering, Microsoft Office Applications, risk mitigation plans, Excel Modeling, business documentation, and SQL.
• Extensive expertise in creating business requirement documents, functional requirement specifications, and test cases
• Worked on Microsoft Office, Microsoft Access, Microsoft VISIO, Oracle ERP and PL/SQL at Confidential and other clients
• Created the As - is model of the processes, performed gap analysis to identify problems in the existing process, evaluated risks and provided recommendations for to-be model at Confidential Tax LLP
• Created automated reports in Excel and Access using VBA and PL/SQL Confidential Financial Services (EFS)
• Streamlined and simplified existing processes and designed new automated processes at Confidential Financial Services

AREAS OF EXPERTISE

• Business Analysis
• Business Documentation
• Requirement Gathering
• Client Management
• Business Intelligence Reporting
• Business Process Analysis
• Business Process Design
• Business Improvement
• Business Objects
• Supply Chain Management
• Project Management

TECHNICAL SKILLS

• MS Office Excel / Word
• MS Visio
• Oracle ERP
• Oracle PL/SQL
• Oracle Reports

PROFESSIONAL EXPERIENCE

Senior Tax Consultant

Confidential, Houston, TX

Responsibilities:

• Assisted clients with business process improvements and streamlining, data mapping and blueprinting, development of process flow diagrams using Visio, process automation and reporting using Excel models
• Developed Oracle PL/SQL scripts for data validations and assisted in creating test script for Oracle R12 Fixed Assets
• Responsible for documents processing, vendor selection process and Tax sensitization of ERP
• Created the As-is model of the processes, performed gap analysis to identify problems in the existing process, evaluated risks and provided recommendations for to-be model
• Developed excel models to automate complex tax calculations and business processes
• Created Excel spreadsheets with complex excel models, metrics, and formula
• Worked with the project manager for planning and organizing the project activities
• Performed user acceptance testing (UAT) to validate user requirements and expectation
• Assisted clients with developing methodology for inclusion of Oracle cost segregation study results in Oracle fixed assets and mass updating assets in Oracle fixed assets tax books
• Worked on setup of Oracle FSG reports, Oracle tax sensitization and blueprinting
• Implemented OneSource Tax Provision application for various clients
• Assisted clients with advanced OneSource Tax Provision functionalities including Global Access module
• Led internal project to develop interface between Zuora subscription application and Taxware SUT
• Collaborated with multiple teams and managed various project phases and delivery
• Conducted user trainings on tax processes

Business Analyst

Confidential, Stamford, CT

Responsibilities:

• Assisted the Confidential EFS tax department with their reporting needs during US Tax Cycle
• Involved in developing processes and PL / SQL code for retrieving relevant data in local database post Oracle GL upgrade
• Created automated reports in Excel and Access using VBA and PL/SQL and worked on process scheduling using Appworx, regression testing, quarter and year end processes.
• Created PL/SQL for retrieving data from Oracle GL to local Oracle database for reporting needs
• Worked on Oracle GL, Discoverer, Infolease, US Tax Cycle and Accounting concepts
• Developed automated reports in Excel and Access to pull data from Oracle database and format
• Streamlined and simplified existing processes and designed new automated processes
• Built automated process with Excel and Access connection cutting the turnaround time from over 2 days to 2 hours

Senior Functional Analyst

Confidential

Responsibilities:

• Assisted with Oracle lease management data conversion and developed PL/SQL code for data conversion and reconciliation
• Developed PL/SQL procedures and SQL Loader scripts for testing setups.
• Managed PL/SQL coding for Oracle lease management and worked on setup of Oracle finance modules OLM, AP, AR, GL and FA
• Created process to test converted data, reviewed mappings and developed mapping and installation components documentation and ran Informatica workflow for data conversion.
• Assisted with upgrade of Oracle applications to have a single global instance and involved in setup using BR100, validation and documentation for accounts receivable, accounts payable, general ledger and fixed assets modules
• Worked on Oracle Discoverer and Informatica Workflow
• Trained on Oracle lease management functional concepts

Technical Developer

Confidential

Responsibilities:

• Worked on various Oracle ERP modules such as order management, inventory, shipping, process manufacturing, bill of material and costing
• Developed Oracle reports and PL/SQL packages for custom self-service web application based on order management module.
• Worked on various applications like TOAD, PL/SQL Developer, Appworx, Unix, FTP, Oracle Reports 6i, business objects, clarify
• Responsible for Oracle setups for customized reports and code as well as key flex fields
• Developed enhancements for complex packages and procedures and worked on all phases of SDLC
• Developed parameterized shell script for shipment document set functionality of Oracle applications and PL/SQL query for hierarchy functionality
• Led support of Oracle inventory components and created data load scripts to automate complex data load processes
• Worked as site coordinator for Europe business processes to apply freight and duty, warranty, commission, organization level category and installation of PBRR for new items
• Coordinated production support team for creation of items and categories, developed user documentation and trained Confidential business teams