We provide IT Staff Augmentation Services!

Senior Business Systems Analyst Resume

San Francisco, CA


14 plus years of experience as Business Analyst/Product Manager with diversified and progressive expertise in various industries, efficient in interacting with senior management, business and technical groups. Competent professional with strong sense of initiative, able to work independently and manage projects successfully from inception to completion.


  • Extensive experience in Business Analysis, Project Management, Product Management, Database, Data Ware house, QA, covering retail, healthcare, telecom, and financial services industry.
  • Strong experience working in the area of Ecommerce, Marketing & Sales, Merchandising, Finance.
  • Extensive experience in defining and documenting application business and system requirements, which are in alignment with business unit strategy.
  • Experience in designing and documenting various process flows, architectural diagrams and wireframes.
  • Experienced in association & interaction with users during entire life cycle of application development process (SDLC) using Waterfall and Agile Methodology.
  • Experience in formulating and authoring use case, user stories and user specifications.
  • Strong knowledge and experience in modeling tools like UML diagrams and RUP.
  • Experience working with Business Intelligence tools using Business Objects and Cognos.
  • Experience working with mobile applications using i Phone, i Pad and Android in the digital marketing area.
  • Experience in Developing and Managing UAT and System Test Cases and programming specification.
  • Experience managing onshore and offshore QA resources and provide them guidance.
  • Experience working as a Project Manager managing timelines and resources.
  • Strong experience extracting data using SQL under Oracle and SQL Server Platform.
  • Strong experience working with Enterprise Database and Data Warehouse Projects.
  • Strong experience in Data Modeling using ERWin and Visio.
  • Experience working with various CRM and ERP applications in retail and healthcare.
  • Strong experience working with web content management system.
  • Possess outstanding interpersonal communication and documentation skills with ability to communicate clearly with peers, managers and customers


Languages: SQL, T - SQL, PL/SQL

DBMS: Oracle, MS SQL Server, MS Access, Visual Basic

Data Modeling: ERWIN, Visio

Business Process: Visio, Balsamiq

Web: XML, VB Script, Sharepoint

Reporting: Tableau, Google Analytics

BI Tools: Business Objects, Cognos, OBIEE

QA: Quality Center, Rally, Test Director, WinRunner

Statistical Tool: SAS

CRM: Oracle CRM, JDA Merchandise Management


Confidential, San Francisco, CA

Senior Business Systems Analyst (Contractor)

  • Worked as business analyst for digital payments group involving various payment processing systems (money transfer, bill pay, wire transfer etc.)
  • Worked on documenting requirements and use cases related to payments system for desktop, mobile and tablet.
  • Worked with business and product managers to get user need and requirements and transform those into technical specifications.
  • Worked with product managers to formulate requirements related to regulatory reporting.

Confidential, Pleasanton, CA

Senior Business Systems Analyst/Product Manager (Contractor)

  • Worked as business analyst in a $2m project to build and manage a new 3 rd party application related to item management process for marketing and e commerce team.
  • Worked on documenting requirements and use cases related to item management process.
  • Worked on various process flow diagrams on item related applications using UML methodology.
  • Worked with 3 rd party vendor to ensure that all the requirements are clearly addressed and various issues resolved.
  • Worked on providing solutions to various issues in collaboration with vendor and development team and come up with revised process, as needed.
  • As a product manager ensured that product planning roadmaps areclearly defined and aligned with business objective.
  • As a Product Manager worked on a solution to synchronize item informationbetween vendor application and the ecommerce site.
  • Generated reports on item data and other retail supplier data on Oracle and Business Objects platform using SQL.
  • Documented test cases and test scripts and provided guidance to the business team on performing UAT validation on various areas of functionality.

Confidential, San Jose, CA

Senior Business Analyst/Data Analyst (Contractor)

  • Worked with various business team to extract requirements and business rulesrelated to data need from various ERP systems for Marketing & Sales.
  • Work on authoring various process flow diagram related to data from various ERP sources into Oracle based Data Mart/Data Warehouse.
  • Worked with ETL developers to ensure that data mapping occurs accurately between various source systems and Data Mart/Data Warehouse related to financial and planning data.
  • Worked on formulating requirements for the Marketing Web application tocater to the need of the marketing and sales team.
  • Liaised with various source system owners to ensure that they understand the data need of the end users.
  • Provided direction to Informatica ETL developers on the business rules to be used for transforming data.
  • Involved in writing test plan and test scripts for performing UAT.
  • Performed detailed UAT data validation to ensure that all the data is following specifications.

Confidential, San Francisco, CA

Business Systems Analyst (Contractor)

  • Worked as a lead business analyst on various financial planning and Marketing CRM applications.
  • Worked with various vendor groups to ensure that technical development occurs as per business requirements.
  • As a Product Manager, responsible for coming up with solutions on displaying time critical item and store information in the ecommerce site.
  • Responsible for managing project related to transaction processing system and payment process.
  • Worked on formulating requirements for Planning application to cater to the need of retail promotions and item management.
  • Performed in depth UAT and integration testing of the enhancements and provide feedback to the off shore development team.
  • Obtained various data from marketing systems using SQL to ensure that those synchronize with Business Intelligence analytics.
  • Performed various analysis in Business Objects (HANA) to ensure that data is following requirement and users data need is fulfilled.
  • Responsible for managing Business Object development project with on shore and off shore team to ensure all the analytics defects are resolved and timeline maintained.

Confidential, Pleasanton, CA

Business Systems Analyst (Contractor)

  • Worked with product managers and business stakeholders to understand the need of the business and ensure requirements are accurately documented.
  • Worked on formulating and authoring use cases and user stories for various CRM based user interface for customers following agile methodology.
  • Worked as business analyst for various mobile products (using Android, i Phone and i Pad) for digital marketing team and provide guidance to the developers and QA team.
  • Responsible for managing projects for transaction processing system with subscription based web application.
  • Managed offshore QA team and provided them guidance on testing various web applications.
  • Reviewed and updated UAT test cases and testing plan prepared by off shore resources. Ensure that their testing is following the specification.
  • Responsible for making project plans for various deliverables in consultation with Release Management, Development team and QA.
  • Worked as a scrum master to get daily status update from all the project participants on the bi-weekly project sprint.

Confidential, Pleasanton, CA

Solution Management Consultant (Contractor)

  • Worked as Lead Consultant for various Health Care projects under Kaiser Health Plan.
  • Responsible for documenting functional requirements and use cases for various projects under Kaiser Health Plan.
  • Worked with business and stakeholders to formulate requirements on various mandated projects.
  • Worked on various regulatory reporting related to various mandated health plan requirements.
  • Worked on various process flow diagrams and architectural processes using UML diagrams.
  • Worked with HIPAA business groups to ensure that the data requirements are correctly fulfilled for benefit coverage.
  • Worked on authoring requirements for item management and pricing for pharmacy products.
  • Worked with developers and technical architects to come up with various system solution decision and solution alternatives.
  • Worked on creating various process flows, architectural diagram involving various membership systems and member record system.

Confidential, Oakland, CA

Senior Data Analyst, (Finance, Procurement and Systems)

  • Worked as Lead Data Analyst for writing requirements for automation of online contract management tool.
  • Involved in the UAT and system testing of the Items Data Mart price files tool automation project.
  • Involved in writing test cases and test scripts for UAT testing.
  • Utilized various SQL scripts to extract data from the development and test environment.
  • Responsible for handling Supply Chain Management Data Warehouse and related data base and online solutions.
  • Worked on writing use cases and requirements for Supply Chain Management data upload automation process.
  • Involved in maintenance of reporting tools and processes utilizing Data Warehouse data.
  • Responsible for generating pricing reports from Finance & Procurement Data Warehouse and Data Mart using Business Objects and OBIEE.
  • Worked on formulating the ETL tools using Informatica and Ab Initio.
  • Involved in generating spend validation report using Oracle Procurement module.
  • Worked on automating the spend validation for diversity vendors extracting data from Accounts Payable and General Ledger using Oracle AR, AP and GL.

Confidential, Walnut Creek, CA

Senior Business Systems Analyst (Contractor)

  • Worked as Lead Requirement Analyst for various ecommerce wireless projects for consumer customers.
  • Responsible for the walkthrough of the requirements documents with Project Managers, Developer(s), QA and Business Team.
  • Reviewed and Analyzed various Confidential systems (including Flex Technology) in order to comprehend various functionality and if applicable, utilize those into requirements.
  • Managed and wrote requirements for RSS Feeds Project using agile methodology.
  • Facilitated developers and Quality Assurance to ensure that they comprehend the business rules and development and testing are taking place as per the requirements document.
  • Involved in unit testing to ensure that all the business rules have been followed in developing the application.
  • Worked as a delegate for the project managers on a need basis.

Confidential, San Ramon, CA

Senior Business Analyst

  • Involved in writing business and technical system requirements for the wireless ordering tool in order to identify all the features associated with that.
  • Assisted in the design and implementation of various business process solutions for the wireless ordering tool.
  • Interviewed and gathered requirements and procedures from user support clients on wireless systems need.
  • Responsible for reviewing all the application download reports using Oracle CRM modules tools and if necessary work on any issues and find resolution.

Database Administration

  • Worked on redesigning the existing CRM database(s) in order to improve the existing CRM process.

Confidential, Richmond, VA

Business Analyst/Data Analyst

  • Interviewed and gathered requirements and procedures from various user support group involved in credit card lending and various regulatory reporting.
  • Worked on remodeling the whole database in order to maintain data integrity.
  • Design and creation of tables and stored procedures with E-R diagrams with extensive use of ERWIN.

Hire Now