We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

4.00/5 (Submit Your Rating)

Santa Clara, CA

Profile:

  • Excellent Business Analyst/Project/Product Manage taken the role of hub between Business Stakeholders, IT Development team, End User Community and Third Party Vendors.
  • Excellent organizational, communication and interpersonal skills.
  • Strong documentation skills and attention to detail .(Functional Docs­­, Technical Doc, Business Requirement Doc & Business Process and procedural Doc)
  • Proficient in all aspects of Software Development Cycle. Ability to juggle multiple projects and tasks. Ability to effectively form and motivate cross-functional teams. Ability to effectively plan initiatives, generates task lists, and set priorities. Excellent Team Player.
  • Technical skill in the area of reverse engineering and querying relational databases and data warehousing concept/tools and proven capability to build adhoc queries using SQL, Excel Pivot tables and Business Intelligence tool for advanced quantitative and qualitative analysis of trends and key performance.
  • Creative problem-solving skills.
  • Ability to work with deadlines and in a fast paced environment.
  • Ability to learn quickly in a dynamic environment and deliver on commitments in a timely manner.
  • Excellent business knowledge, model and rules in the blue chip and banking sectors in the Marketing, Sales, Services and Management Information System Group.
  • Recipient of Legendary Service Cash Award from Wells Fargo and performance award twice from Cisco Systems.

Contributions / Accomplishments :

Confidential,Santa Clara, CA – Sr. Business Systems Analyst Jan’11 – Aug’11

  • Identify gap between old vs new PeopleSoft(EPM) system.
  • Data Analysis to reconcile source system vs Datawarehouse vs Peoplesoft(EPM).
  • Trend Analysis to identify the gap between the old GL based source system and Peopleosft(EPM).
  • Coordinated with Business Stakeholders (FP&A) to redefine the requirements and testing.
  • Managed the designing, development and deployment of Business Object Reports.
  • Validated all the Business Objects Reports (BOXI) (GL Reconciliation Reports(8 tabs), Client Profitability Reports(4 reports and each having average 4 tabs, Segmentation Report(2 tabs), Bench Mark Report(single tab with 150 line items).
  • Reconciliation of Business Objects Reports with Essbase based old GL based production systems.
  • As a part of IT Delivery team co-ordinate with Business, App support, EDW team, Business Intelligence team and offshore development team.
  • Instrumental for designing the report access based on the legal entity and sales hierarchy.
  • Prepared and published reference guide based on rules built in the Business Object Reports to be used by Business Users, Production Support Engineers, Datawarehouse team and developers for impact analysis, estimation for future enhancements and troubleshoot the production issues.

Confidential,San Mateo, CA – Sr.Business Systems Analyst/Prod.Support Mgr Jul’10 – Jan’11

  • Prepared and Published Business Release document that has half yearly major product releases, Reporting Capabilities and migrations.
  • Managed the weekly enhancements and emergency software releases.
  • Support the VROL, TRP, TRA and AP applications in terms of production support, migration and Data Quality.
  • Administered user Access creation and Training new users.
  • Weekly Primary for managing the user requests of all portfolio.
  • Building adhoc reports using Microstrategy tool for Analysis.
  • Managed Product enhancements for US and Asia Pacific Region.

Confidential,SFO, CA – Business Analyst – Jan’10 – Apr’10

  • Developed Business Objects Report for system reconciliation between Source System and General Ledger.
  • Developed Business Objects Report for calculating Allowances and Reserves.
  • Gathered, Designed, Developed, Documented and Deployed 60 Business Processes and procedures for monthly and quarterly financial reports.

Confidential,SFO, CA – Business Analyst – Aug’06 – Feb’09

  • Gap Analysis of old Financial reporting system vs New Business Object based Reporting system.
  • Documenting as-is process from scratch by interviewing Subject Matter Experts, going through old emails and gathering information from various team members, and to be business process for all corporate financial reports published by the Credit Portfolio Information Systems.
  • Designed and Developed to-be process.
  • Instrumental for migrating / Testing all the reports from old system that used Access Data base /Excel/Manual entries into Automated reporting platform using SQL, Business Object 6.2 Version initially and XI version subsequently and constantly coordinating and communicating with Quality Assurance Group.
  • Production support for running monthly reports and deliverables using Business Objects.
  • Prepared Business Requirement, Functional and Use case doc in building the Bank’s Executive Dashboard & Blue Book, designed and developed prototype & tested.
  • Kay member of Audit & Sox compliancy team to certify all the financial reports using Business Objects and defining the controls and approval process.
  • Strategized and managed many short, medium and long term projects for successful migration, implementation and stabilization.
  • Prepared project plan and identified resource requirement, mitigated risk, logged issues and identified resolutions. Used Water fall approach for new enhancements and Agile for developing Executive Dashboard & Blue Book.

Confidential,Business Systems Analyst- IV – Jan’05– March’06

  • Maintained / enhanced daily financial reports using Business Objects.
  • Identified the gap between source system vs Data Warehouse using SQL query covering mainly data element used for the MIS report or for Market Campaigning of new products and services or cross-selling of the products.
  • Established trouble free and secured Partner file processing for credit payment (weekly/monthly). Files were received in Excel / Access format and loaded them into Relational database using SQL for processing.
  • Participated in project initiatives tracked them and updated the provided weekly status on all projects. Prepared project Plan and resource allocation.
  • Shortest time learnt the Banking Sector Business and Business Rules and utilized for developing reports
  • Acted as a hub between MIS team, Data warehouse team, third party (Phone bank) to integrate the data and manage the web based application enhancements.
  • Received Legendary Service Cash Award

Confidential,CA - Sr. Business Analyst – Feb’03-Jul’04

  • Managed the current product engineering of Content Management System used for HP internal and external partners for sales and marketing and for product performance model.
  • As Business Analyst acted as a hub between Business Team, IT development team (on shore/off shore) and external partners.
  • Lead adhoc teams for multiple mini projects. Prepared the project plan and maintained them for giving weekly status to upper Management.
  • Reduced the number of open issues and established strategy for all enhancements
  • Prepared Business Requirement Document consists of Business goal, Business Rules and use cases, Business process and Business criticality and prioritization for minor to major projects.
  • Designed, Established & Maintained Business Process for various business and operations area(Cross Assets interface, Current product Engineering, Attribute/Product Fallouts, Content Quality, Publishers Deployment / Migration, Change Management (Content, system, UI, Functionality, Human Resource), Inbound / Outbound Content file Processing, Production Support process)
  • Developed Metrics to measure Business Performance
  • Reduced turn around time of executing the Business Process.
  • Prepared the test plan/data for every release of the project.
  • Responsible for Data quality (content quality).

Confidential,CA – Sr. Business Analyst – Mar’02 – Jul’02

  • Identified the Gap between Legacy application vs Lawson Application
  • Strategize the migration process
  • Prepared the Test Plan and Test scripts for the usability test for the business team
  • Part of testing team tested the application after migration and produced the test results.
  • Substituted the Project Lead
  • Initiated Oracle Financials Interface
  • Migration of functionality and data from Legacy to Lawson Application

Confidential,CA – Oracle Functional Consultant – May’01-Nov’01 months

  • Requirement gathering for Customization and migration
  • Documentation of all customization of Oracle Applications
  • Modules wise user setup and Application Setup
  • Prepared the Design document
  • Training of Oracle Application users in 11.0.3
  • Co-coordinating with off-site development team for all customization

Confidential,CA – IT Engineering / Analyst - May’96 – May’01

  • Developed Web based Inventory Dashboard for Cisco Systems
  • Instrumental for developing the Client and web based Network Design Tool for Cisco Field Engineers. Received performance award.
  • Instrumental for developing the Cisco E-Learning portal. Received Performance Award.
  • Developed the portal for Cisco Reseller interface
  • Understood the Rosettanet concepts, PIPS (Partner Interface Process) and analyzed the possibilities of implementing them.

Education:

  • Bachelor of Engineering (Specialization in Industrial Engineering)

We'd love your feedback!