SUMMARY:

• Over 7+ years of experience in Business and Systems Analysis working in various domains - Financial, Mortgage, Retail
• Thorough knowledge and maturity in all the phases of Software Development Life Cycle (SDLC) and familiarity with industry standard best practices and frameworks such as Waterfall, Rational Unified Process (RUP), ITUP and Agile Methodology (Scrum).
• Well versed with on-shore, off-shore model preparing all the requirements in clear and complete integration application requirements documents such as AIM (Application Integration Mapping), Error Mapping, Transformation details, Translation requirements, Connectivity specifications (REST, SOAP, JDBC)
• Developed Acceptance scenarios including expected inputs, expected results and test data.
• Strong knowledge in importing/exporting data across various database platforms to perform analyses.
• Hands-on experience in creating Use Cases, Activity Charts, Sequence Diagrams, Data Flow Diagrams and ER Diagrams using Rational Rose and MS-Visio thus defining the Business Process Model and preparing complex functional requirement documents.
• Experience producing Project Documentation like Project Charter, Project Initiation Document, Statement of Work, Business Systems Analysis Report and artifacts like BRD, FRD and SRD.
• Experience in developing multiple SQL queries (including joins, DDL and DML).
• Experienced in conducting performance analysis for APIs, have exposure to tools such as JMeter, Log Stash/Elastic Search (for log analysis), and Kibana for generating dashboards
• Experienced in generating detailed API reports consisting of API metrics such as daily count, average response times etc.
• Experienced in monitoring all phases of testing, presentations to the impacted teams and coordinating with all business teams.
• My strength lies in gathering and documenting requirements based on functionality, workflow and business rules. Establishing Business Cases, preparing specification documents and Use Cases and effectively managing the requirements
• Experienced with JIRA, RALLY and HP-ALM to capture user stories, requirements and velocity, progress using burn-up and burn-down charts
• Excellent analytical skills and ethical working style along with excellent communication, written and interpersonal skills describing a dedicated team player
• Proven display of leadership and command in interacting with senior technological and management executives

TECHNICAL SKILLS:

Operating System: Windows, Unix, Sun Solaris and Linux

Methodologies/ Frameworks: Waterfall, Agile-Scrum, Extreme Programming (XP),TDD,RUP,Kanban

Business Analysis: Rational Suite (Requisite Pro, Clear Case, Rational Clear Quest,) MS Visio, MS Project 2016, UML, JIRA, RALLY, Erwin, Tableau, Tableau Desktop 9.3, Crystal Reports, Cognos 10 (report & query studio), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Balsamiq, TOAD Data Modeller

FrontEnd Tools: MS Office Suite (Word, Excel, Access, PowerPoint)

Database: SQL Server Management Studio, Oracle 8i-9i, MS SQL Server 2012, SQL Dev

Testing Tools: CODED UI 3, QTP, UFT, Selenium, Microsoft Test Manager 2013

Project Management Tools: MS Project professional, MS Project Server, and SharePoint 2010

Data warehousing: Data Marts, OLTP, OLAP, ROLAP, DOLAP, MOLAP, HOLAP, Teradata, Query/Reporting, Multidimensional Analysis, Data Mining, Slicing/dicing, Drill Down/Roll Up, MDM, Data quality(DQ), Data cleansing, Data governance (DG)

Web Technologies & Tools: Java, JavaScript, HTML, CSS, XML, HTML, REST, SOAP, SOA, Visual Studio 2012/2010/2008/2005, MS SQL Server, MySQL, C, C++

ETL: SAP Data Services, SAS Data Management, Informatica

Defect Tracking Tools: HP ALM QC 11.0, Team Foundation

WORK EXPERIENCE:

Confidential, OH

Bu siness Analyst/Scrum Master

• Worked Closely with Different Zions Products like Multi-Tier Sweeps, RegCC Holds and Credit Holds General Holds, Products, Account Create, Account Amend & Inquiry Forms.
• Worked with Front Office & Back Office for Testing Purposes.
• Worked on IBM Rational Tool Creating Function specification document and updating Screen Design Configuration by Creating Artifacts, Collection & Modules.
• Did GAP Analysis & Implemented new Applications.
• Analyzed between Account Level, Product Level & Parameter Level requirements.
• Gathering Requirements from SMEs and making sure to implement changes as asked with 100% accuracy.
• Creating PPT presentation for Weekly Team Status and Presented it to Product Owner & Higher Authorities in order to keep everyone informed about the Progress of the Work done by my Team.
• Communicating With Small Teams(SMEs) on Regular basis both verbal and written.
• Functioned in a consultative role and managed a team & project.
• Worked Under Tight Deadlines in the Sprint Work Environment.
• Facilitated Daily scrum meetings, Sprint planning, Sprint review, and Sprint retrospective, involved in every scrum ceremony.
• Worked with Product owner On Artifacts Such as Product Backlog, Spring Backlog, Sprint Burn down, and Release Burn down.
• Worked with product owner and business team in prioritizing and grooming of product backlogs, and also helped in prioritizing the user stories using MoSCoW and Planning Poker techniques.
• Assisted the QA team by providing positive and negative test cases, prepared RTM to match used cases to all the test cases.
• Conducted Scrum meetings with technical and non-technical teams, SME’s to clarify business rules & solve impediments.
• Worked in Rally to generate User Stories out of the Functional Requirements.
• Coordinated with the product owner in backlog management/grooming and continuous delivery of features and also maintained burn down chart and team velocity.
• Facilitated Backlog Grooming, Daily scrum meetings, Sprint planning, Sprint review, and Sprint retrospective.

Environment: J2EE, JavaScript, SQL Queries, Microsoft Office tools, HTML, XML, Crystal Reports, Tableau,Share point, Oracle, web sphere, Rally, MS Visio

Confidential, FL

Business Systems Analyst

Responsibilities:

• Gathered both functional and non-functional requirements from both the business and technical team
• Updated the status quo of the project to the business for them to keep track of the progress
• Provided statistical analysis, process modeling and ROI for the business
• Obtained non-functional requirements- throughput requirements, stress requirements, availability requirements, back-up requirements and scalability from SMEs and developers
• Created static and dynamic prototypes using MS Visio and HTML/CSS respectively and communicated to the UI team on the screens (mock up and GUI) and navigations
• Assisted UI team in client side validations and used AngluarJS scripting and AJAX for interactive and dynamic web layout
• Established extraction/transformation rules for data from OLTP sources for data cubes and OLAP (online analytical processing) execution
• Assisted database team in developing analytics of the trading data using higher level access provision for the business to visualize parameters and make decisions
• Identified snowflake schema, fact tables, dimension tables, entities, relationship, attributes to communicate to development team
• Facilitated service level agreements (SLAs) along with the team to get to consensus on service requirements, network requirements, data archival and storage requirements
• Played an instrumental role in converting business rules to business logics and communicating them to developers and also identified the business changing rules to be included in the XML engine
• Maintained track of requirement traceability matrix (RTM) for various testing activities

Environment:: MSSQL, MS Visio, MS Office Suite, MS Project, Adobe Photoshop, SSAS, SSIS, Informatica, Teradata - SQL Server Assistant

Confidential, NY

Business Systems analyst

Responsibilities:

• Used various elicitation techniques to extract requirements from various sources-people, artifacts and application interfaces
• Gathered requirements using several elicitation techniques such as brainstorming, joint requirement planning (JRP) sessions with subject matter experts (SME), development leads and testing leads
• Involved in business process modeling BPM using BPMN and different UML diagrams like use case diagrams, activity flow diagrams and sequence flow diagrams using MS Visio
• Assisted in development of conceptual architectural model, logical architectural diagram (LAD) and physical architectural diagram (PAD)
• Developed data models, data flow models, event model, entity relationship diagrams and data dictionary
• Established extraction and transformation rules from various OLTP data sources
• Facilitated automation of extract transform and load (ETL) process transformations of OLTPs to maintain order of data inputs for data marts (DMs) and data warehouse (DWH)
• Monitored different levels of data warehousing like staging, integration, analysis and access
• Identified and recommended fact and dimensions tables to the developer for developing data cubes
• Well versed with slicing, dicing roll up and drill down functions performed
• Assisted in scripting business logic in web methods of the web services, application program interfaces (APIs) and documenting WSLA
• Provided business insights to business users based on data mining, data analysis and data visualization using Tableau
• Made use of Statistical analytical system (SAS) for data driven business decision making
• Tested OLAP cubes for ad-hoc data comparison and report generation on DOLAP from the database bus schema.
• Involved in creating test cases, test plans and test scenarios for testing along with quality analysts
• Solved business problems by using planning, data analysis, business knowledge, communication, logical and parallel thinking

Environment:: MS Visio, Rational Rose, MS Office Suite, MS Project, Adobe Photoshop, MSSQL, SSAS, SSIS, Informatica, SAS, SAS Enterprise Guide, Version One Control, Tableau, Teradata - SQL Server Assistant.

Confidential

Project Manager/Business Analyst

Responsibilities:

• Worked with different business teams like Prime Services, settlements team to understand the cash projections that they create when they book a trade in safe Orientation.
• Developed knowledge of Business Process Management (BPM), and cash Management.
• Developed understanding of the Reconciliation of cash flows to understand the scope of the project.
• Developed business requirement documents, use cases, functional and non-functional documents and process diagrams including context, dataflow and decomposition diagrams.
• Defining the scope of the project and identifying the major actors, using various elicitation techniques to gather requirements.
• Responsible for decomposing High Level Business requirement into functional specifications.
• Author Data Flow diagrams, Activity diagrams, Sequence diagrams and Business Process models with special detail to Sub-Processes.
• Design message formats, queues, systems interfaces, and worked with the traders though interviews, Questionnaire and JAD sessions.
• Liaise with all the stakeholders at all levels and worked closely with teams of BAs, developers, testers and product control throughout the entire development life cycle to ensure a quality product is delivered.
• Analyze, collected and prepared user requirements, definition, scope and expectations for deliverable plans. Delivered system documents, processes, diagrams, and test cases.
• Performed multiple SQL queries using Query Analyzer / TOAD for Data Analysis; created database driven reports with output to MS Excel and custom reports such as SQL file count, Ad-Hoc reports, and monthly migration reports
• Prepared master test plans with the help of QA team.
• Responsible for conducting the testing and defect analysis.
• Responsible for writing training manuals and training of the end

Environment: MS Project, Visual Studio, Crystal Reports, SharePoint, Web Services, MS SQL Server, HTML, XML, JIRA, Java platform, Jenkins Dev ops.

Confidential

Business systems analyst

Responsibilities:

• Conducted pre-analysis of gap analysis, risk analysis and cost analysis for the application’s viability and worthiness
• Worked with the business and technical stakeholders by planning and creating ITIL RACI matrix to keep track of subjects for requirement elicitation
• Conducted JAD (joint application development) sessions for the team to arrive at architectural consensus of the project and to purge problems relating to the same
• Performed reverse engineering techniques to obtain metrics and key performance indicators of the legacy application
• Understood the business process and the dependencies of the project to draw business flow diagrams (BFD) and process diagrams
• Assisted designing and developing work flow diagrams and process flow diagrams using MS Visio
• Worked with UI/UX design team in creating wireframes/mock-up screens
• Generated testing defect reports based on priority/complexity/time frame depending on the needs using quality center
• Welcomed change requests and verified whether the triple constraints boundary encompasses

Environment:: MS Visio, Rational Rose, MS Office Suite, MS Project, Adobe Photoshop, Tableau, SQL, MS SQL