Business Systems Analyst
*+ years of experience as a Business Systems Analyst, working closely with business users, developers and subject matter experts through all phases of the SDLC. Strong Technical, Documentation and UML modelling skills. Worked with Scrum Master/ PO to create stories and participated in all scrum ceremonies – Daily Scrum, Sprint Planning, Review and Retrospective Meetings. Coordinated teams in different time zones while actively maintaining a healthy velocity.
Accomplished Business Analyst with 8+ years of experience working in an environment of Customer Interests, delivering process improvements utilizing latest technology.
Expertise in Elicitation, Analysis, Design and documentation techniques using Agile, SDLC & Waterfall methodology, Worked closely with Stakeholders, Product team and Business Users.
Have driven and lead structured meetings like JAD (Joint Application Development), JRP (Joint Requirement Planning) session.
Extensive experience in initializing feasibility studies and presenting business cases to the stakeholders, developing AS IS, Vision, GAP analysis documents, and risk & benefit analysis etc.
Worked on Change request using change management processes, doing Gap analysis, creating a roadmap, business rules and requirement analysis, Pain point analysis and prioritization.
Good working knowledge on Scrum concepts like Scrum Team Meeting, Product backlog, Sprint planning, User stories, Daily standup, Scrum Retro & Review Meeting, Grooming session, Burn down charts, Planning poker etc.,
Hands-on Experience in preparing Use Cases, Activity Diagrams, Sequence Diagrams, SQL Scripts and strong knowledge of Unified Modelling Language (UML), Data flow modelling, ER diagrams, Business rules identification and data analysis.
Successfully documented project scope, business requirements, business processes, test cases and user guides which resulted in accurate development and improved the overall quality of the deliverables.
Involved in Test Planning, Test Preparation, Test Execution and Issue Resolution and Report Generation to ensure that all aspects of a Project are fully complied
Conducted UAT (User Acceptance Testing) using Jira, Rally, VSTS and created user manual and conducted training sessions for the team.
Involved in executing excel macros for data analysis, used SQL queries and Toad Oracle queries for legacy system to validate and mapped dataflow through XML, schema, XSLT for data migration and business process compliance.
Worked closely with team (Developer, QA, PM) and DA (Design Architects) on many deployments of process and data from Legacy system to MI Cloud platform and customized system.
Excellent analytical & problem-solving skills and a team player with strong interpersonal and communication proficiency.
Unified Modelling Language (UML), SDLC, RUP, RAD, Agile, Waterfall
MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase
Rational Rose, Rational Clear Case, Rational Requisite Pro, Documentum
Linux, Windows 2000/XP/98/7/10
IBM WebSphere, ATG Dynamo, BEA WebLogic
MS Word, MS Excel, MS Project, MS Visio, Lucid chart, TOAD, Adobe Photoshop
Quick TestPro (QTP), WinRunner, LoadRunner
NCSBE -North Carolina State Board of Election Beyond Info Solutions
Business Analyst June 2018 – Till date
Worked as a Business Analyst for NC State Board of Elections (NCSBE). The objective of the project is to fully modernize and replace the current Statewide Election Information Management System (SEIMS), by leveraging the state’s existing use of Microsoft 365 and Microsoft cloud solutions. The new SEIMS application will replace legacy capabilities and also automate manual business processes for six major components that include voter registration, voting, election event management, voting site management, board administration and systems functions. It will result in leaner elections administration by consolidating the current thirteen separate applications into one core application as a centralized web-based solution using Agile Methodology.
Elicited requirements on Web Application, Dashboard, Business Logic, and types of Data and Reports from different Business Owners, Stakeholders and development teams by facilitating Interviews, Brainstorming, and JAD session
Performed Document Analysis to know the As-Is system and created To-Be system by conducting GAP Analysis
Created BRD, SRS, FRD, Non-Functional and Requirement documents
Created data flow diagram, use case diagram, sequence diagram, activity diagram, wireframe and mockup for a better visual understanding
Analyzed the requirement, and discussed with the stakeholders, to identify the data sources
Involved in modelling business scenario predictions like segmenting audiences based on their behavior, building customer profile, and providing simplified attribution insights
Involved in creation of User Acceptance Test cases and plans, defect tracking using Jira and validated reports and dashboards
Responsible for writing user stories in MS Excel and then import them into HP AGM
Environment: Microsoft Visio, MS Office, MS Project, UML, HTML, XML, SQL server, HP AGM, SharePoint 13.
T-Mobile, Bellevue, WA Beyond Info Solutions
Business / Data Analyst Feb 2017 – Mar 2018
Worked as a Business / Data Analyst for T-Mobile to develop a web application which can automate the ETL process used by various internal projects. The project deals with transactional data to provide analytical results to its as well as providing analytical solutions to clients. The purpose of the web application was to automate ETL process using DTS packages and SSIS services which can be consumed by most of the projects/clients in the company for their daily ETL requirements. Integrating their analytical tools in the application which can be used to generate analytical reports on the data. Creation of a dashboard in the application was one of the key features implemented using Agile Methodology.
Identified the business requirements from the stakeholders/SME’s keeping in mind their need for the application and prepared the Business Requirements Document and Functional Specifications Document.
Organized and moderated Joint Application Development (JAD) sessions identified system business and effectively utilized Document Analysis technique to frame system use cases, wrote use case narratives and used MS Visio to prepare the Use Case diagrams, Activity diagrams and System diagrams.
Scheduled meetings with developers, system analyst and QA to collaborate resource allocation and project completion using MS Project.
Involved in designing and developing Data Marts that support the Business Intelligence Data Warehouse.
Performed Data mapping and logical data modelling also prepared ER diagrams for the system.
Conducted ETL testing process for data quality, data integrity and data validation.
Acted as a liaison between the developers and user staff and was instrumental in resolving conflicts between the user and technical teams.
Worked closely with the QA team for drafting testing requirements, test plans and worked on documenting RTM (Requirement Traceability Matrix).
Utilized HP Quality Center for defect tracking and effectively communicated the defects between the development and the QA team conducting Triage calls.
Worked with testers, developers and other team members to validate and test complex system and with the maintenance of Quality Standards in projects.
Environment: Tableau, Informatica, TFS (Team Foundation Server), Microsoft Visio, MS Office, MS Project, UML, HTML, XML, SQL server, HP ALM, SharePoint 13.
Cisco, San Jose, CA GENPACT
Business Analyst Jan 2014 - Jul 2015
The project was to plan, design, assemble and configure a network infrastructure for a Call Center. Then to build a Call Center Management Application, which will enable the functional teams in the organization (Sales, Billing, Technical Help, Network Maintenance and Management) to work along with the call center teams. This is a Business Process Improvement project, to build a centralized system, to increase the performance and efficiency of the customer care & network service, and to reduce the customer churn by providing a good service.
Facilitated JAD sessions, Interviews, brainstorming sessions between Call Center team, Sales teams, Billing Team, Technical Help team, Network Management Team, Business Owners and other stakeholders to elicit the requirements
Performed document analysis, impact analysis and worked with SME, Developers and Administrators to understand the As-Is system, performed GAP Analysis and created the To-Be System document. Also, did the SWOT Analysis and Cost-Benefit Analysis
Created Business Requirement Document (BRD) for business requirements and Software Requirements Specification (SRS)
Created wireframe and mock-up screens using MS-Azure, to show the look and feel of the web application
Created use case diagram, sequence diagram and activity diagram using MS-Visio
Responsible for creating data flows and data models for system and Assisted architect team in designing data architecture that best suited for maintainability and usability
Worked with the Systems Architect to design the Logical Architecture of the system
Worked along with Network Engineer to design the Physical Architecture of the system
Assisted in designing of 3-tier architecture that was developed
Worked closely with UI team in developing the web application, XML documents and validated XML, HTML and Java Script Made a UI checklist to ensure the web application has easy usability, navigation, content and design
Validated basic SQL scripts to verify the application on database using MySQL
Assisted testing team in creating test plans, responsible for verifying test data and validating test results. Also, assisted testing team in performing unit, integration and user acceptance test
Helped in developing reports like Agent Performance Indicators, Resource Usage Report, Customer Satisfaction scale, Call Handling Analysis, Customer Experience Management System, Customer Relationship Management System, Document Management System and Workforce Management System
Assisted in configuring dashboard and reports using Micro Strategy
Wrote User Stories using INVEST criteria and decomposed epics using vertical slicing when required
Worked closely with Product owner to prioritize the product backlog, and while defining the acceptance criteria
Participated in Scrum ceremonies like Sprint Planning Meeting, Daily Scrum Meeting, Sprint Review Meeting, Sprint Retrospective Meeting and Backlog Grooming Meeting
ICICI, Mumbai GENPACT
Business Analyst Sep 2012 – Dec 2013
The project was to upgrade client website from Drupal frame work to Adobe CQ5 framework. It was a large website in multiple language for various locations. There were some new enhancements to be implemented like it was to be made a responsive website with 4 breakpoints and to launch it specific to device and language.
Involved in Probability and Risk Analysis to identify the business critical and high-risk in the application.
Worked on documenting requirements, preparing use cases, writing business documents and reports in SDLC phase.
Handled Change Request and working closely with Dev and QA team to facilitate sessions.
Identified the process flaws in the current system after analyzing and documenting the AS-IS system and recommended business process automation in the new system through the creation of the TO-BE system.
Developed data flow diagrams, illustrating the flow of data from the Legacy systems into the Application data base Tables, along with checkpoints for testing / verification.
Prepared use case documents and utilized MS Visio to create UML diagrams including use case, activity and class diagrams to extract business process flows and workflows, thereby assisting development and quality assurance teams in understanding the requirements.
Developed a user acceptance test plan and test case scenarios to guide end-users in testing the user interface and functionality of the application.
Environment: MS VISIO, Rational Requisite Pro, MS SharePoint, Windows, MS Office, XML, HTML, Win Runner, Load Runner, Adobe CQ5, Cross Browser testing, JIRA, Omniture, Selenium.
HSBC Global Technology, Pune, India GENPACT
Business/Quality Analyst Jul 2010 – Aug 2012
HSBC Technology India, previously called HSBC Global Technology (GLT), is part of HSBC Technology, the Bank's technology function. HSBC Technology India has been in existence for over 15 years, and currently supports majority of the software products that make up the Bank's technology eco-system.
The company needed to develop a Web-based lending platform with business process management and integration capabilities, enabling it to incorporate both best-practice business rules and third-party technologies into their processes. Modules cover origination through settlement, plus workflow management tools.
Interacted with client groups to determine user requirements and goals. Utilized Rational Unified Process (RUP) to configure and develop process, standards and procedures.
Created Need Analysis Documents of the requirements gathered through JAD and individual elicitation sessions using Rational Requisite Pro.
Analyzed business requirements into high level and low level Use Cases, Activity Diagrams / Sate chart Diagrams using Rational Rose following UML methodology.
Created URS-User Requirement Specifications and FRS- Functional Requirement Specifications documents
Suggested the indexing requirements based on the querying columns. Created the specs for the stored procedures and triggers, based on the business logic.
Assisted in preparation of Request for Proposal (RFP). Followed RUP quality Assurance and Testing Process. Interfacing with program management and executive teams regarding quality assurance goals.
Wrote extensively SQL scripts for validating the data generated by the UATs. Set up definitions and process for test phases including Product test, integration test, system test and user acceptance test (UAT).
Participated in entering, tracking system defects in Rational Clear Quest.
Environment: Requisite Pro, Rational Rose, Clear Quest, Test Manager, MS Visio, MS Project
Master Card International, St.Louis, MO Confai Solutions Pvt Ltd.,
Technical Writer Feb 2010 to May 2010
This project automates the operating in an insurance domain. This application maintained Life Insurance Information about the insured, spouse etc. It maintains the payment history of the members Insurance claims, monthly insurance premiums paid etc. The system keeps track of business generated by the Agents and Commissions paid to the agents under different Insurance schemes. Report generation capability for daily and monthly statements was provided. It contains 3 types of modules. Administrator, Agent, Policy holder. Agent act as bridge between the company’s policies and the policy holders who have taken the policies. Agency can login into his module with his unique user name and password
Proofreading, reviewing and editing documents
Writing assignments according to set standards, regarding order, clarity, style and terminology
Recommending revisions or changes in format, content
Reviewing Team’s work with respect to client’s set standards
Preparing Style Sheets for Templates
AP Tourism, Hyderabad, India Confai Solutions Pvt Ltd.,
Technical Writer Jun 2009 – Nov 2010
AP Tourism is a software tool used by Andhra Pradesh tourist Department which helps as a informative guide for the tourists who visit AP. This document is done in Microsoft Word which gives you a detailed description of various tourist places and the route map to the destination including the booking options for the stay of the tourist.
Documenting the AP Tourism guide
Magna Infotech Pvt Ltd, Hyderabad
Business Development Manager Jan 2005 – Jan 2009
Responsible for Account creation, Accounts Maintenance, defining resourcing strategy, team leading and initiate delivery mechanism.
Taking care of Entire Placement Cycle
Account Maintenance of Computer Science Corporation (CSC)
Handling Requirements of MNC’s Like Accenture, I-flex Solutions, IGate, KANBAY, Patni Computer System and IBM
Interacting with prospective clients, holding discussions with the project managers, Understanding the specifications in retrospect to candidate’s profile, job description, salary payable, start date and mode of Interview.
Maintaining the consultants, interacting with them on regular basis, flashing the requirements to them, analyzing about the requirement and getting the profiles in less turnaround time. Evaluating those profiles, giving early feedbacks.
Handling Walk-In Interviews individually. Experienced in conducting walk-In interviews even at clients place.
E-Recruitment – Working on Online recruitment solution, viz. job sites.
Screening the profiles, short-listing them basing on the requirement and the candidates experience, skills and selecting candidates in preliminary HR validation
Reference Check about the candidates experience, role in the previous organization, Interaction and Coordination with Clients & Candidates without delay of work
Sending mails about the Interviews, written tests to candidates by e-mails, tele calls.
Negotiate & convince the candidates to accept the offer and join at the earliest.
Co-ordination with the Clients with respect to Contracts, Invoices, Feedback, Interview schedules, Payments, etc. Responsible for collection and payments from clients (Raising Invoice, billing etc).
YCH Logistics Pte. Ltd - Singapore
Custom Relations Officer Jun 2002 – May 2004
Responsible for Dispatch of Goods for YCH Logistics.
Handled Inbound Calls from Customer Regarding Goods and Services Delivery.
Handling Business Communications and Business Enquiries
Co-ordinating day to day activities of office staff
Over all responsible for Customer Service Wing.
SkillTech Engineering Pte. Ltd - Singapore
Account Assistant Jan 2000 – May 2002
Maintained ledger entries for accounts payable and receivables
Monthly checking of account books
Filing of purchase bills
Getting bank statements and preparing bank reconciliation for the same
Data entry of invoices, sales returns etc
Sending reminders to customers whose payments are outstanding
MBA, Human Resource & Marketing, Osmania University – 2012
Diploma in Technical Writing and Business Communication, CONFAI Solutions - 2009
Bachelor of Commerce, Osmania University - 2002
Diploma in Software Engineering, CBSI – 1999