SUMMARY

• Over six years of diverse experience in the Information Technology field with the ability to work independently and in a team, and manage business expectations with a delivery - focused approach to work.
• Real time experience in Database Management, Business analysis and Software Development Life Cycle (SDLC) using Agile and waterfall.
• Capable of working with cross-functional teams like stakeholders, upper management, developers, upstream and downstream partners and QA teams to achieve business goals.
• Participated in Object Oriented Analysis and Design (OOAD) in UML with emphasis on use case diagrams, state diagrams, sequence diagrams and activity diagrams
• Co-ordinated testing with Developer and QA teams including User Acceptance Testing (UAT) and researched and assigned defects.
• Actively involved in conducting GAP analysis and Risk analysis
• Involved in creating Dashboards, reports as needed using Tableau Desktop and Tableau Server.
• Experience in analyzing documents like project plans, business cases and scope documents and Experience in preparing different documents like the User Requirement List/document (URL/URD), Business Requirement List/document (BRL/BRD), Test Case Scenarios & Test Plan documents, Requirements Traceability Matrices (RTM), Use Cases, Issue Logs and other documents as needed
• Proficient in Microsoft Excel (Pivot Tables, Vlookup, Hlookup, VBA, etc.)and Strong accomplished experience in creating and managing MS Access databases.
• Responsible for gathering andanalyzing business requirements,tagging and tracing requirements usingtraceability matrixin Rational Requisite Pro.
• Analyzed and optimized the existing business processes usingthe conceptual modelingmethods(Data Logical Modules)and documented the business process through DFD narratives.
• Provided guidance on software engineering standards and produced the followingtemplates: Functional Design Documents, Various Test Analysis Report.
• Conducted JAD sessions between users and development team to make them understand the project scope and project deliverables.
• Mapped business data nameto back end data name to help DBAs to come up withER diagram.
• Performed in-depth Gap analysis, generated reports and maintained documentation of the Gaps captured during the Gap Sessions.
• Utilized object-oriented techniques forcreating use cases, Business process flows.
• Facilitated working sessions with developersto understand the requirements and use cases; helped them to gather additional information to produce development design document.
• DevelopedBusiness Lifecycle Modelsand interaction diagrams using MS Visio.
• Involved inDefining and granting rolesand access to users to manage the business hierarchy in application.
• Documented technical interface designdocument to specify data files, control files, trigger files, receiving and sending systems, etc.
• Ability to work under minimal supervision, adheres to deadlines, and motivated to excel.
• Excellent problem-solving skills with a strong technical background and good interpersonal skills, Detail-oriented, responsible, enthusiastic and highly flexible to changing priorities
• Excellent communication skills and analytical skills.

TECHNICAL SKILLS

Methodologies: Agile (Scrum), Rational Unified Process (RUP), Waterfall

Requirement Management: Rational Requisite Pro, Rally, Team Foundation Server (TFS), MS Excel

Project Management Tools: MS Office, MS Project, MS SharePoint, MS Dynamics, MS One Drive, MS Visio, Service Now, Sales force, Adobe Experience Manager (AEM), WebEx, Jabber, Lync

Modeling Tools: Microsoft Visio, Power Designer, Sparx Enterprise Architect

Data Analysis: ETL, MS- SQL, Toad, Minitab, SAP (PP, MM, ABAP, PS), IBM BPM

Testing Tools: Clear Quest, HP ALM, JIRA, QTP, SAAS

Reporting, BI Tools: Tableau, Qlikview, Micro Strategy, Cognos

Languages: C, C++, Java, Linux, VB, XML, Core .Net, PL SQL, Python

Operating Systems: Windows, XP, Vista, MSDOS, Mac

Database: MS Access, SQL Server, Oracle 8i/9i/10g and DB2

Business Skills: Business Definition Requirements, Business Process Reengineering, Object Oriented Analysis and Design, User Acceptance testing, Use Case Testing, Release Management & End user Training, Case Management System, Business process management, Executive and end user presentations, Business Process Analysis, Gap Analysis, Business Acumen, Use Case Modeling & Analysis, Data Analysis

PROFESSIONAL EXPERIENCE

Senior Business Analyst

Confidential, Dorado Hills, CA

Responsibilities:

• Responsible for meeting with Business Process Owners, SME (Subject Matter Experts) and Marketing Team for Requirement gathering.
• Conducted Joint Application Discussion (JAD) sessions with the development team to develop and understand the business system requirements.
• AuthoredBusiness Requirements Document (BRD) and Functional Design Specifications (FDS) document.
• Involved inproviding technical expertise to define defect remediation processfor production support team for and provided detailed estimates for the changes control process.
• Interacted with the customer and program team to evaluate and prioritize the stated user requirements.
• Collaborated with the QA team todevelop the test (plans/scenarios/cases/data)to be used in testing based on different business requirement.
• Provided technical assistance in identifying, evaluating and developing systems and procedures that are cost effective and met Business Requirements
• ProducedSystem Flow Diagramand System Context Diagramto communicate with business and technical stakeholders.
• Prepared attribute mapping across multiple data sources and performed complex analysis on legacy data to validate business requirements.
• CreatedRTM (Requirements traceability matrix)mapping Requirements to Design Artifacts to SIT Cases to UAT Cases.
• Wrote andexecuted SQL queriesfor reporting.
• Helped the UAT team identify process related issues with the functionality of the invoicing application.
• Developed Service Level Agreements between different business areas and developed K Performance Indicators and management reports.

Environment: Business Objects (BO), Microsoft Office SharePoint 2007, Agile, JIRA, Rational Requisite Pro, Sparx Enterprise Architect, Visio, MS Office, SQL Server 2005, MS Project

Business Analyst

Confidential, Bethesda, MD

Responsibilities:

• Analyzed business processes to gather user requirements for the development of requirement specifications in addition to assisting business users in prioritizing requirements for enhancements/rewrite of existing applications, systems migration and data conversions.
• Performed extensive requirement analysis, Manage and traced the requirements usingDoors.
• DocumentedFunctional Requirement Specifications (FRS)based on Business Requirement document (BRD) to rewrite the FRS application.
• ConductedJAD sessionsbetween users and development team to make them understand the project scope and project deliverables.
• Analyzed, defined and documented thebusiness processes.
• ProducedSystem Flow Diagram and System Context Diagramto communicate with business and technical stakeholders
• Createduse casesbased on the transaction flows with detailed user requirements, describing how the system should behave and specifications for development of the functionality described in the use case.
• Responsible for developing and maintaining qualityreport procedures and ensuring that appropriate documentation was in place.
• Identified andimplemented design changesto improve functionality and query performance
• Worked on providing details and coordinating with Data base team to implement variousdata base modificationsinto the production.
• Provided technical expertise in defining templates for Data modifications.
• Documented an onlineuser guideto support the user console.
• Prepared attributemappingacross multiple Loan Delivery data elements and the legacy system data fields.
• CreatedSQL Scriptsand submitted them to the DBA for execution based onSOX policy.
• Involved in providing technical expertise indefect remediationprocess for FRS production support team.
• Produced Testing bug report while communicating with developers for additional testing.
• Involved inData Preparationfor theUAT effort and interacted with the business area, technical team and the Data Analyst on a consistent basis to ensure accuracy of the data being setup.
• Lead,create and Execute system test scriptsto validating the newest Pricing rules and changes to Amendments for GFPS and Jumbo Loans.
• Arrange and lead meetings with developers and other testers to discuss thelogged bugs and issues.
• Researched, analyzed the code to rewritevarious managementAdhoc reportsand to understand the proper functioning and fix the ongoing issues with theData representation.
• Analyzed UATTest scriptsand scenarios for functional testing of new development, reports and issues resolution and created training material for users and QA group.

Environment: Business intelligence (BI), Business Objects (BO), Microsoft Office SharePoint 2007, Agile, Rational Requisite Pro, MS Visio, MS Office, SQL Server 2005, MS Project, MS Access, HP Quality Center.

Business Analyst

Confidential, MO

Responsibilities:

• Act as a liaison between internal Key Account Managers (KAM) and developers in IT department to meet client demands and requirements
• Familiar with EDI processes used between multiple systems; track root cause of data related issues by checking SQL tables
• Manage projects per client/account by gathering business needs, creating project workflow, and interacting with IT team to create technical specifications
• Use SQL server daily to check for database updates and maintain various tables; familiar with queries such as Select, Update, Join, Delete, Insert, etc.
• Write technical documentation for each account to highlight specific backend processes
• Assist our support team with IT troubleshooting for our online order system
• Provide training and assistance regarding E-Platform to clients and colleagues
• Involved in Joint Child Support Application Development sessions for requirements gathering, analysis, design and Application Development to converge early towards a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change.
• Involved in Requirements traceability matrix of mapping the test cases to requirements and design documents.
• Prepare the System Integration System test cases and execute them for system verification of requirements.
• Performed regression testing every time deployment is done.
• Create defects and retest them after the development fixes.
• Prepare and communicate the weekly work status reports.

Environment: MS Office Suite, UML, SQL, Tableau, MS Visio, MS Dynamics, IBM, MS One Drive, Rally, XML

Business Analyst

Confidential

Responsibilities:

• Involved in all phases of software development life cycle (SDLC).
• Facilitated JAD sessions to gather requirements.
• Applied Unified Modeling Language (UML) methodologies to design Communication Diagram, Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
• Extensively interacted with both user group and development team.
• Worked MS Office products including MS Excel, MS Access and MS Word.
• Incorporated the best practice methodologies as advocated by the Rational Unified Process.
• Designed and analyzed business process model, use case model and test procedures based on RUP methodology.
• Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owners stake holders and document analysis. Performed user interviews.
• Wrote user requirements specification (URS) and functional requirements specification (FRS) documents as per the business requirements and process flow.
• Designed and developed project templates based on SDLC methodology.
• Developed UML use cases for the application and prepared the detailed workflow diagram based on the proposed enhancement for the system.
• Wrote SQL short SQL modules based on the functional design and technical specifications of the project.
• Implemented improvements in existing models in framework manger and development of any new reports.
• Conducted user acceptance testing (UAT), unit testing and system testing.

Environment: Rational Rose Enterprise, MS shares point, MS Visio,Businessobjects-data integrator, SQL server SQL server, MS Excel

Junior Business Analyst

Confidential

Responsibilities:

• Successfully defined functional business requirements, analyzed client requirements,and generated workflow processes.
• Responsible for coordinating JAD sessions withbusinessusers to analyze, gather and define the key performance indicators, document and present the requirements specifications
• PreparedBusinessRequirement Document (BRD)and then convertedbusinessrequirements into Functional Requirements Specification (FRS).
• Analyzed to identify which system would utilize the least development time. Assisted in project management activities like planning, development, task allocation, project execution. Provided full projectlifecycle flowcharting,analysis and documentation.
• Interacted withbusinessusers and performed Gap Analysis of Client requirements.
• Worked extensively with MS- Visio to document requirements, create the AS-IS and TO-BE process flow diagrams.
• Review Child Support Business Requirements and develop Design Documents for system functionality.
• Validate Design and System documents and provide review comments.
• Support development and testing teams for clarifications on Design Specification Documents.
• Perform analysis of current Child Support business processes and suggest recommendation for improvements.
• Involved in Joint Child Support Application Development sessions for requirements gathering, analysis, design and Application Development to converge early towards a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change.

Environment: Agile Scrum Methodology, MS Office Suite, UML, SQL, Tableau, MS Visio, ETL (Informatica), MS Dynamics, IBM, MS One Drive, Rally, XML