About 4+ Years of experience as Business Analyst.
Strong understanding of SDLC methodologies including Waterfall, Scrum, Agile.
Possess excellent Business writing skills in creating Business Requirements Document (BRD), Use-Case Specifications, Functional Specification Document (FSD), Systems Requirements Specification (SRS), and Test Case scenarios and reports.
Expert in tracking and managing requirements through Requirement Traceability Matrices (RTM).
Handled Change Request from Stakeholder’s and Product Owners initiating scope of project.
Worked closely with Project Stakeholders, SME’s, Project Manager and staff to understand the requirements and analyzing specifications for new applications along with modification of the existing application.
Excelled at conducting GAP Analysis using AS-IS and TO-BE business processes, to check the compatibility of the existing system infrastructure with the new business requirements.
Experienced in conducting JAD, JRP, JAR session, SWOT ANALYSIS, Cost Benefit Analysis and requirement workshops with business to gather requirements.
Skilled in documenting Unified Modeling Language (UML) diagrams like Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Class Diagrams, context diagrams, Wireframe Diagram, Data Flow and Business Flow Diagrams, Architectural Diagram.
Worked on Service-Oriented Architecture (SOA), REST, SOAP, XML, and API.
Expert in creating Specifications and designing Conceptual, Logical and Physical Entity-Relationship diagrams.
Extensive involvement with Data Warehousing, Dimensional Modeling, Data Analysis, Data Mapping and Data Modeling.
Strong experience in ETL used for data migration.
Extensive years of experience in Business Process Re-engineering, Business Process improvements, Historical Data Analysis.
Facilitated scrum ceremonies in Agile Scrum Methodology as Scrum Master and responsible for empowering teams to self-organize and grow cross-functionality, solving impediments and conducting the various ceremonies (Grooming, Sprint Planning, Daily Stand-Ups, Review, Retrospectives, etc.).
Switched the role as a Junior Project Manager and Business Analyst effectively whenever need arose.
Possess experience in Functionality Testing, System Testing, User Acceptance Testing (UAT), in different projects.
Experienced in reviewing Test Plans, Test Scripts, Test Requirements, Test Cases, Test Reports, and using defect-tracking tool to address bugs/issues as required by the project.
Excellent written and verbal communications skills, ability to interface with all levels of the organization, specific strength in influencing decision makers and managing expectations.
Strong communications and inter personal skills with the ability to Co-Ordinate and Network with Multiple Stakeholders to successfully deliver applications / solutions.
Analysis / Methodologies
RUP,UML, Agile methodology, Waterfall methodology, Cost/Benefit Analysis, Gap Analysis, Feasibility Analysis
Programming Languages and Web Technologies
Microsoft Visio, Microsoft Project, MS office Suite, MS SharePoint, MS visual Studio
Rational RequisitePro, Rational Rose, Rational Clear Case, Rational Clear Quest
Crystal Reports, MS Excel, Cognos
MS SQL Server 2005,Oracle
Quality Center, Load Runner, Quick Test Pro
Win 95/98/NT/2000/XP, Mac OS, Unix
Texas General Land Office (GLO), Austin, TX Nov '16 - Till Date
Business Systems Analyst
Project: Asset Management (Royalty Reporting & Controls (Government Project))
The Texas General Land Office (GLO) is responsible for four distinct external-facing strategies for the State of Texas along with the enterprise strategy for efficient and effectively running the GLO’s operations. The four external strategies are Asset Enhancement, Serving Texas Veterans, Coastal Protection and Alamo complex. In the Asset Enhancement strategy, GLO lease private lands for Oil & Gas production.
The primary objects of this project are to:
•Split the current application from a single portal to into two separate portals, one for the external users and done for the agency administrators.
Functioned as the liaison between the business line, operations, and the technical areas
throughout the project life cycle.
Interfaced with the client as part of requirements gathering and elicitation to finalize
the project scope.
Conducted development sessions with SME and Manager to understand business
processes, functionality detail.
Developed UI for internal and external applications and ensured usability during
Assisted to create Product Breakdown Structure (PBS).
Created Mock-up forms in Just in Mind for better visualization and understanding of the
Involved in gathering the requirements and analyzed the existing application.
Created the list of User Stories and shared it over to the Stakeholders.
Elicitation of the feature and the requirements with the stake holders
Coordinated the requirements walkthrough sessions with the Stakeholders.
Created Use-case documents, Requirements tracker documents, Requirements log and Change Request.
Extensively worked in a Customer - oriented environment.
Coordinated with the developers in addressing the requirements and change requests.
Updated the onsite and offshore on the ‘CR (Change Requests)’.
•Created Requirements Trace ability Matrix (RTM) to keep the stakeholders informed of the progress of the project.
•Used JIRA for bug tracking.
•Coordinated with the testing team in developing Test Case documents and Test plans.
•Involved in User Acceptance Testing (UAT) and validated the application for any deviations from the Business rules.
•Presented demos to the Client on the new RRAC system.
•Performed testing the application to be browser compatible and inline to the requirements.
•Updated the bugs in ‘TFS’ for the internal bug tracking.
•Worked on Users Guide and updated it as per the new systems functionalities.
Environment: Scrum Methodology, Blue Print, MS Project, MSOffice 2013(Word, Excel, Access), MS-Visio, JIRA, Rational Clear Quest, SharePoint 2007 Rational Clear Case, MS-SSIS.
Client: Fresh Direct, NY Mar ‘15 – Aug '16
Role: Business Systems Analyst
Project: Transportation Logistics (E-Commerce)
Project Description: My team worked on Supply Chain (Retail), logistics and transportation (E-commerce) of Fresh Direct delivery system. One of the first projects, I was assigned to, was SMS Alerts to customers. This project dealt with generating and sending out the alerts as well as providing user Interface to set up alerts. On front-end we have JSP custom tags to develop messages and alerts set up on account page. On the backend we have session beans and REST web services to send out SMS request to the third party which in-turn sends the SMS message to customers. The SMS alert web services were sent in bulk using a multi-threaded process using Executor framework. Third party relays any response from the customer to us and we process the response to send out the correct SMS message back.
The SMS opt-in process is a two-step process in which once the customer selects the alert trough website we send in an opt-in SMS. The customer has to respond in 1 hour to complete the opt-in process after which the opt-in expires. If the customer responds within the given window he will be successfully opted into the selected SMS alert.
We received the webby award for 2015 for our store front here is the link:
The other project I worked on is Muni-meter. This is an internal project to keep track of the truck parking receipts in New York City area, to reduce overhead every year in parking tickets. Administrators would scan a Muni-Meter Card and enter the amount on it into internal app while dispatching a route, and then again scan and enter the amount upon check-in. In the front end an overlay was developed into the app using jQuery-UI, in the backend Session beans and JDBC was used to store, process and retrieve the data. The third project was on Mobile API where we provide the APIs that send out the data for rendering the UX of Fresh Direct App on iPad and iPhone to our third party vendors developing the application. We won the 2015 webby award as well for our efforts (here is the link http://www.webbyawards.com/winners/2015/mobile-sites-apps/tablets/shopping-tablet-all-other-devices/freshdirect-for-ipad/). We also gather the metrics regarding the usage and functionalities requested and send in to our Core-Metrics team for analysis.
•Documented business functionality requirements in User Stories.
•Collaborate with the Product Owner on project/roadmap planning, facilitated daily stand-up meetings, reviews, retrospectives, sprint and release planning, demos and other Scrum-related meetings.
•Coordinated with the team working on ERP systems.
•Coordinated cross-functional process development and identified opportunities and improve process.
•Coordinated the applications Front-end, middle tier and backend systems.
•Coordinating with third Party Mobile UI/UX developers to brainstorm on performance issues such as minimizing the number of API calls made by third party by providing more robust and complete APIs.
•Assisted in backend implementation for Web-services and a way to store the information.
•Developed As-Is and To-Be Business Process Models for complex processes by analyzing the current processes, and gathering information from SME's.
•Arranged sprint grooming, planning, daily scrum, sprint demo, and sprint retrospectives.
•Managed the product backlog with user stories through progressive refinement applying business prioritization, solution approach, and technical delivery considerations.
•Conducted walk through sessions to discuss certain issues with stakeholders, architectures and design & development teams and also performed GAP Analysis.
•Involved in all phases of software development life cycle (SDLC) in Agile framework.
•Used MS-Visio for Flow-Charting, Use- Case process model and Architectural design of the application.
•Assisted in monitoring ancillary data transactions and addressed problems with HL7 Messages.
•Managed requirements and use cases with the help of Enterprise Architect.
•Used SQL, Toad, Data Warehousing and Data Cleansing for the arrangement of customer data.
•Queried database using Web focus and acted as a Liaison between end users and the data team (Business Intelligence Competency team).
•Performed analysis and data manipulation of source data from SQL Server and other data structures to support the business organization; these departments include planning, evaluation, programs, and administration.
•Used Tableau tool to generate visual reports and shared over to our SAP and Salesforce departments as per the requirements.
•Managed product backlog within JIRA.
•Tracked UAT issues/bugs and prepared reports.
•Regularly interacted with the Testing team for executing the Test Plans, providing Test Data, creating Test Cases, and resolving issues upon detection of bugs and collecting the Test Metrics.
•Create and run SQL queries for data analysis: add, delete, and modify Microsoft SQL database records.
•Assisted QA team with User Acceptance Testing, develop and maintain quality procedures ensuring that appropriate documentation is in place.
Environment: Jira, MS Office, HP ALM, UML, Oracle, MS Visio, SharePoint 2007 Clover-ETL, Crystal Report, MS Project, Windows 7.
Client: Teachers College Columbia University, NY Jan '14 – Jan '15
Role: Business Systems Analyst
Project: Retirement Plan & DM Standardization (Finance Project)
Project Description: My team worked on “Data and Metric Standardization” Finance project in Budget & Planning department. DMS holds details related to Faculty, Non-Faculty members and Students at TC. We handled Accounts Receivable, Retirement Plan & funds section (401K) and Banner Support Management. The funding data details are retrieved from centralized Database and the visual reports that displays the required data are generated.
•Researched, Analyzed, gathered, and defined business systems solutions and ensured technical "bottlenecks" were identified, reported, and resolved in a timely manner, analyzed the business and user requirements for clarity, completeness, and technical feasibility.
•Gathered Requirements by interacting with the business users and the system owners.
•Gathered and understood User Requirements through user interviews and Brainstorming sessions.
•Analyzed the requirements and created Business Requirements Document (BRD), Functional Specifications document (FSD) and Use Case specifications using Requisite Pro.
•Creating Functional Requirement Documents.
•Conducting Questionnaires, Interviews, JAD Sessions, Requirement Workshops, User Interface Mockups and Brainstorming to gather business user requirements.
•Monitored the UML-based methods to create: Use Cases, Activity Diagrams and Swim lanes.
•Performed GAP Analysis to develop business requirements, created Use Cases, functional requirements, Business Rules, developed wireframes using MS – Visio.
•Created Requirement Traceability Matrix to track requirement.
•Gather requirements and translate into business processes as well as UI wireframes.
•Conducted user interviews to understand end user needs and refine the user experience.
•Work with the User Experience team to design the GUI for the application.
•Experienced working with User Experience (UX) and User Interface (UI) teams while driving the Functional Requirements and Wireframes.
•Working with management, development staff and the end user to coordinate issues for rework, regression testing, and UAT testing.
•Developed the Test Plan/Strategy and oversaw the complete system testing process and ensured that tests results adhere to the functional specifications.
•Create and run SQL queries for data analysis: add, delete, and modify Microsoft SQL database records.
•Prepare data mapping documents to build the new data mart and Tableau reporting.
•Developed prototypes/screen mock-ups using MS Visio to facilitate interactive discussions with stakeholders and developers.
Environment: Agile- Scrum, Version One, UFT, ALM, Microsoft Office 365, Microsoft Visio, Windows 7, SQL Server, SharePoint 2010, Spunk, Jenkins.
•Masters of Science in Computer Science, Bradley University, Peoria, IL.
•Bachelors in Electronics & Communicational Engineering, GITAM University, Visakhapatnam, India.