Uploaded File
add photo
Ronak
Ronakpanjabi999@gmail.com
510-516-4819
Austin, TX 73301
Business System Analyst
13 years experience W2
0
Recommendations
Average rating
133
Profile views
Summary

  • § Highly motivated and result oriented with 7 years of industry experience as Business Analyst
  • A self-starter with leadership qualities, interpersonal and communication skills
  • In-depth domain knowledge of Telecom and Retail Industry
  • Strong organizational, communication, leadership, planning and vendor management skills.
  • Excellent knowledge of industry standard methodologies like Software Development Life Cycle (SDLC), Project Life Cycle, Rational Unified Process (RUP) and Capability Maturity Models (CMM).
  • Excellent Analytical skills to understand the business process and Functionality, Requirements and to translate them to system requirement specifications. Developing functional specifications for business process refinement and automation, data modeling, system architecture, conducting feasibility studies, scope.
  • Experience in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change
  • Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
  • Systems Analysis involved Data Flow and the System Interfaces from Web Interfaces to Legacy systems that included Utilities, Middleware layers, Data Bases Layers, Web Interface and Web Service Layers.
  • Extensive use of MS Office tools like MS Access, MS Word, MS Excel MS Project for data migration in to the CI System Knowledge Data Base in Microsoft SharePoint Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
  • Extensive experience with process modeling using UML, flow charts, task diagrams, Sequence Diagrams, Activity Diagrams and Use Cases.
  • Has good knowledge and exposure of application model to develop web-based solutions using Java, Servlets, JDBC Web Services, Oracle, Teradata, and PL/SQL.
  • Experience in writing queries/scripts for data analysis and QA report testing.
  • Excellent communication and presentation skills. Experience working with business users as well as senior management.
  • Experienced in creation of Test Cases and Test-Plans, different QA Testing Methods, building, Templates, Graphical analysis charts and Statistical reports using MS Excel
  • Academic Experience in conducting SWOT analysis, Gap analysis, Impact analysis, Risk analysis, Net present value (NPV) analysis, Return on investment (ROI) analysis.
  • In Depth understanding of the AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.
  • Ability to work cross-functionally and with all levels of the organization
  • Creative and Aggressive person capable of forming and maintaining positive and productive team environments and with integrative thinking skills.
  • Fostered Agile principles and methods for requirement gathering
  • Provided business requirements within an AGILE software development AGILE SCRUM environment
  • Provided AGILE project management controls, project plans, timeline schedules, facilitate JAD sessions, and review software defects

Experience
Business System Analyst
Information Technology
Jan 2015 - present
  • Bigcommerce has been mainly involved in web site design. The wide range of services offered are e-commerce solutions, custom web designing, website development, web analytics, logo design, flash designing, SEO, CRM, search engine marketing, graphic designing and other web application services. Worked on multiple projects and teams to deliver projects against agreed scope, budget, schedule and client expectations.

Responsibilities:

  • Lead business analyst for multiple projects and systems across the Library analyzing requirements and specifications to determine the feasibility of proposed projects and solutions, to include risk assessment of current production systems, project estimation using agile methodology, writing communication and technical documentation.
  • Coached and developed a distributed team of business executives and technical professionals regarding Agile roles, routines and responsibilities resulting in a more thorough understanding of Scrum and a faster start up time to developing software.
  • Working with functional teams in an agile environment, analyze factors and components of systems and processes to manage interrelationships and facilitate change. Detects inefficiencies or conflicts in systems and processes and helps to identify effective improvements. Facilitates communications between customers, SME's and Technical staff. Participate in various testing functions (i.e. string and acceptance tests) to verify that results are correct.
  • Product Owner on projects and manage and ensure that all required meetings are running under the Scrum/ Agile process.
  • Elicit business requirements from project sponsors and stakeholders through research, focus groups, interviews, process flow creation, surveys, or other methods and Validate, prioritize, and organize requirements.
  • Prepare documentation at each of stage of the requirements phase, including deliverables like Vision and Scope Reports, Requirements Work Plans, Business Requirements Documents, Use Cases, Process Flows, Technical Specifications or Functional Design Documents.
  • Work closely on the project plan, benchmarking, risk analysis and disaster recovery. Act as a mediating link between the developers, Web Analytics team and the customers (Product/ Service Owners and Stakeholders).
  • Created and executed test cases within MS Team Foundation Server (TFS), and validated backend data utilizing integrity manager tools
  • §Entered product backlog items, bugs and tasks into Team Foundation Server for the Agile SDLC
  • Worked on the application and also performing Data Model cleanups utilizing CA Erwin tool
  • Gathering and analysis of complex technical information; Erwin diagrams, SQL statements and queries.
  • Created and managed work items (change requests, bugs, enhancements) using Team Foundation Server.
  • Captured Requirements through detailed discussion with client and project managers.
  • Established Traceability between the Requirements and the Tests cases in Traceability Matrix.
  • Created and reviewed Business Use Cases and test cases.
  • Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server environment.
Disaster Recovery SQL Business Analysis System Analysis BSA SQL Server
Remove Skill
Business Analyst
Information Technology
Apr 2013 - Dec 2014

Responsibilities:

  • Involved in preparing SDLC Documents such as Business Requirement document (BRD), Functional Specification document (FSD), Test Plan, Test Report.
  • Provided technical and business expertise during discussions with upper management and followed through with statements of work that described the project scope, resource requirements, and deliverable time lines.
  • Assessed project feasibility, estimate time, gathered business requirements, and executed project plans for various business groups.
  • Worked and coordinated with US and Ireland BAs, developers and managers to develop detailed business requirements; data architects to improve data access performance; and QA personnel to create end-to-end system tests to ensure that the application functioned in accordance with the specifications.
  • § Reverse engineered and reconciled the database to implement the changes in database using Erwin
  • Defining and documenting High level and Functional requirements into Agile stories.
  • Reviewed Product backlogs and prioritize Agile stories accordingly in every sprint.
  • Used the agile methodology guidelines to carry out every step of the business modeling process.
  • Used MS TFS and Rally for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
  • Managed requirements, defects, bugs through Microsoft Team Foundation Server (TFS) also responsible for Managing and executing Database Change requests using TFS
  • Worked with team members to develop, enhance, and maintain analytical tools (e.g., Team Foundation Server (TFS) for requirements specification and management) for use in designing and redesigning systems.
  • Involved in preparing Implementation Plan and conducted regular and off hour implementation.
  • Created training materials and provide training to system users.
  • Grouped the Use Cases and other diagrams into sequence and collaboration Diagrams using Rational Rose based on UML methods thereby defining the business process model.
  • Created Use Cases for the applications and facilitated QA group to develop Test Plan and Test scripts based on Used Cases.
  • Documented and Performed User Acceptance Testing (UAT).
  • Involved in Staples online store Production Support that included incident troubleshooting and resolving tickets

Environment: Rational Tools, MS Project, MS Visio, TFS, JAVA, TOAD, Oracle, Quality Center

Compliance UML Business Analysis Production Support HP QC TOAD Java
Remove Skill
Business Systems Analyst
Information Technology
Nov 2008 - Dec 2011

MIDFIRST is a financial service company offering a variety of banking products and financial solutions like personal banking, small business, retail banking, home financing and equity loans, asset management, wealth management, corporate and investment banking and credit card services to its customers. Personal Banking involves opening and maintenance of checking, savings, recurring deposit accounts and personal loans. The web-banking project was developed in .NET environment. It is an online banking application that enables customers to access their checking and savings accounts, and credit card account using the Internet.

Responsibilities:

  • Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case VOB
  • Used SQL queries for organizing and abstracting data from MS access data bases, created reports, forms on MS Access.
  • The project heads towards enhancing the existing online banking application by improving its GUI, making it user-friendlier.
  • Captured requirements for monthly SL to GL postings, calculating GL beginning and ending balances.
  • Captured Data flow diagrams and formatting of the data flowing through interfaces.
  • Accumulated system requirements from various departments like accounting, IS (Information Systems) through surveys and interviews.
  • Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
  • Developed business process models in RUP to document existing and future business processes.
  • Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
  • Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
  • Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
  • Created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
  • Facilitated user acceptance testing and test strategies with Information Systems Group.
  • Performed manual front-end testing to check all functionalities of different modules.
  • Suggested measures and recommendations to improve the current application performance with the aid of SCR’s (Small Change Requests)

UML System Analysis BSA SQL System Requirements ClearCase
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Engineering Management
Lamar University
ITM-Information Technology Management
Sardar Patel University
Skills
BSA
2021
7
System Analysis
2021
7
SQL
2021
6
Business Analysis
2021
5
SQL Server
2021
5
UML
2014
4
ClearCase
2011
3
Disaster Recovery
2021
3
System Requirements
2011
3
Compliance
2014
1
HP QC
2014
1
Java
2014
1
Production Support
2014
1
TOAD
2014
1
Continuous Integration
0
1
Microsoft Excel
0
1
Requirements Gathering
0
1