SUMMARY

• Certified Scrum Master (CSM), 6+ Years of in - depth knowledge in business/project planning/PMO processes.
• In-depth knowledge of standard methodologies like Software Development Life Cycle (SDLC), Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP), Capability Maturity Models (CMM) and rational tools used during various phases of RUP.
• Extensive experience in developing Business Requirement Document (BRD), Functional Requirement Document (FRD), Software Requirement Specification (SRS), Use Case Specification Documents and Product Design Document (PDD).
• Strong competency in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, Assisting Joint Application Development (JAD) sessions with IT Groups for CRM systems enhancements and maintenance. Excellent understanding of Business Requirements Elicitation/Gathering, Translating Requirements into Specifications and Application Design.
• Hands-on experience in Profit & Loss sheet preparation for T&M, FPP & RFB projects.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis and Risk Analysis.
• Facilitated Scrum events such as Backlog Grooming, Sprint Planning, Daily Scrum Meeting, Sprint Review and Sprint Retrospective Meetings for every Sprints as a Scrum Master
• Involved in writing test plan, test case, test scenario and performing test execution, test result analysis, Software Quality Assurance and Quality Control using HP Quality Center 11 ALM Edition and JIRA.
• Worked with Sales, Delivery and Finance teams for monthly, quarterly and annual revenue budgeting & forecasting and tracking actual performance.
• Strong understanding in finance project profitability calculations and prepared account level profit analysis & report leadership.
• Possess good knowledge in Capex-Opex processes and responsible for account level procurement process.
• Provided project planning, milestone management, scope management, resource forecasting, revenue forecasting, financial management, change management across the project portfolio.
• Possess strong knowledge in MSA, SOW and amendment document preparation and securing both party signatures.
• Responsible for supervising the project scope documentation, requirements gathering, high level application/business flow diagrams, project plans, meeting co-ordination and facilitating internal business and technology groups.
• Acted as a liaison with HR department in the areas of open positions, on boarding process and highly sensitive performance and compensation reporting.

TECHNICAL SKILLS

Project Management Tools: MS-Project, MS Share Point, JIRA, Rally, Team Foundation Server

Languages: C#, SQL, Python C++, R, HTML, VB 6.0, VB.NET and VBA

Requirement Management: MS Office, JIRA, Version-One, HP ALM, Blue Print

Data Profiling and Scrubbing: DQ Analyzer, DataFlux Management Studio

Reporting Tools: MS office Suite, Tableau, IBM Cognos, Power BI, Crystal, OBIEE

Modeling Tools: Rational Rose, MS Visio, Gliffy, Erwin, Balsamiq, JustInMind, Invision

ETL Tools: Informatica Power Centre 7.x/8.x/9.x, SSIS, IBM Data Stage

Databases: MySQL, SQL Server, H-base, MS Access, Oracle, Teradata, IBM DB2

Office Tools: MS Word, MS Excel, MS SharePoint, MS Project, MS Visio, MS Access

Version Control Tools: BitBucket, GitHub, Source Tree

Testing Tools: Testrail, JIRA, Load Runner, Selenium, HP ALM

Analytics Tools: MS Excel, MS Access, Power BI, Tableau 9.1

Defect Tracking Tool: Test Director, HP ALM, JIRA

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Technical Business Analyst

Responsibilities:

• Lead the daily scrums as a Scrum Master to ensure the seamless project progression.
• Work with Production team for the Production support.
• Work with Triage team to analyze the agent calls which comes in the XML format to understand and document the issues.
• Involved in preparing Logical Data Models/Physical Data Models.
• Worked in entire life-cycle beginning from Requirements gathering, Data Model Design, ETL Design, Report Design, Testing, and Migration to Production and Post Production Support.
• Designed & Developed logical & physical data model using data warehouse methodologies, including Star schema - Star-joined schema, conformed dimensions’ data architecture, early/late binding techniques, data modelling, designing & developing ETL applications using Informatica.
• Used python-baseddatamanipulation tools such as Pandas, Matplotib, PostgreSQL to clean corrupteddatabefore generating business requested reports
• Involved in preparing Logical Data Models/Physical Data Models.
• Worked with reversed engineer Data Model from Database instance and Scripts.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes
• Researched and analyzed data, made appropriate recommendations based on findings.
• Extract and filter data from various source to load in to MySQL database. Developed ER Diagrams to design RDBMS.
• Developing SSIS packages to migratedatafrom OLTP to OLAP servers
• Responsible forSQLtuning and optimization using Analyze, Explain Plan and optimizer hints.
• Experience in buildingDataIntegration, Workflow Solutions, and Extract, Transform, and Load (ETL) solutions fordatawarehousing usingSQLServer Integration Service (SSIS).

Environment: Quick Test Professional 8.2, Quality Center 8.2, SQL Loader, PL/SQL, Pandas, Matplotlib, PostgreSQL, Share Point, Oracle, MS-Excel, Jira.

Confidential

Business Analyst

Responsibilities:

• Maintained the existing ETL (SSIS Packages and Store Procedures) accordingly to populate the new Metrics.
• Created SSIS packages for extracting data from databases like SQL, Oracle and load those data into tables in SQL server. Created package to handle reject data in customer tables. The package extracts reject records in those tables if the records are older than certain days.
• Designed and Developed analysis reports, charts, scorecards, and dashboards.
• Created Stored Procedures, User Defined Functions (UFD), Triggers, Indexes, Views, SQL joins to implement business rules.
• Used SQL Server profiler and Database Engine Tuning Advisor for complex stored procedures and strong SQL server query performance tuning. Worked with error handing by using TRY/CATCH statement.
• Loaded data from source to database by using T-SQL statement.
• Creation of tables, queries (including union statements), forms, reports, macros, and modules for performing daily, weekly, and monthly reporting needs.
• Developed ETL specification based on Business Requirements/Mapping Document.
• Prepared unit test cases and performed unit testing along with the team.
• Ensuring coding standards and practices are met in regards to coding and documentation.
• Involved in training of users
• Created and maintained technical documentation using defined technical documentation templates that meet SDLC standards
• Built tables, views, stored procedures, indexes, functions, and triggers in SQL Server
• Involved in the bug fixing and integration of modules helped coordinate SIT testing Used Control Flow Tasks like for Loop Container, For Each Loop Container, Sequential Container, Execute Task, Email Task, and Data Flow Task.
• Extensively used Derive Column, Row Count, Data Conversion, Conditional Split and Aggregate.
• Responsible for Monitoring and Tuning Report performance.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users at various levels using Report Manager
• Scheduled report and exported in PDF format.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server.
• Created various reports by comparing the growth of company based on each quarter by using bar charts.
• Responsible for generating annual reports based on the growth of company with respect to customers.
• Conducted user training sessions and supported the requests for enhancements, modifications and new reports.

Environment: Microsoft Office Suite, Quality Center 8.2, SQL Server 2014, Oracle 10g, Tableau 9.0, Rational Requisite Pro, Jira.

Confidential

Technical Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Conducted extensive requirement analysis and performed business using case wise modeler
• Thoroughly studied the requirements for the process re-engineering
• Developed business case which included results of the business-impact assessment, gaps identified, alternative solutions, risk assessment, preliminary work plans, resource requirements, and a budget for completing the initiative.
• Performed requirements gathering from the business users of the system while adhering to SDLC industry best practices.
• Involved in using Agile and XP methodologies performed roles of Scrum Master following sprint sessions and used Rally software extensively to write User Stories, assign tasks to individual team members.
• Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities.
• Mentored junior Analysts and programmers in the TPF programming design concepts.
• Involved in creating PNR records, passenger records, with unique reference number.
• Developed models to project revenue and costs to support budget forecasting and strategy development. Prepared standard monthly reporting.
• Ensured financial statements are accurately stated via in-depth review/analysis of system generated revenue and expense activity reports.
• Responsible for the initial development, implementation, and support of a TPF system for the client.
• Was responsible for indexing the tables in data warehouse.
• Created meaningful reports for analysis & integrated the Performance Testing in the SDLC.
• Reverse Engineered the existing ODS in to Erwin.
• Developed Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, Agile/Scrum.
• Responsible for testing Business Requirement Specifications, to capture functionalities at all E-Commerce touch points and assigned tasks among development team, monitored and tracked progress of project following Agile methodology.
• Involved in resolving problem tickets opened in TPF IT Database.
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Participated in the evaluation of several test tools to be used with the introduction of TPF/C code the online system.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Casewise modeler, Borland CaliberRM, Scrum, SDLC, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, J2EE, VBScript, C#. DOORS, C++, NET, ASP.NET, Business Objects.

Confidential, Sunnyvale, CA

Business Analyst

Responsibilities:

• Gathered & Elicited requirements using JAD sessions, Questionnaire, Interview sessions, Focus Groups and performed the feasibility analysis and GAP analysis to derive requirements for payment gateway processing.
• Conducted a detailed Feasibility check, Impact analysis, Cost Benefit analysis.
• Involved in implementing PCI-DSS level one compliance and coordinated in documentation of the same.
• Coached the team and Implemented software methodologies including Agile (Scrum), Scrum - waterfall Hybrid.
• Interacted with SME’s, asking detailed questions and carefully recording the requirements in a format that can be understood and reviewed by both technical and business people.
• Adopted Entity-relationship modeling technique and developed Conceptual and Logical data model for DFI tables.
• Logged Data mapping documents of various HTML field to XML tags and further onto tables stored in database.
• Conducted session for writing User Story, and Acceptance Criteria for Potentially Shippable Product Increment.
• Ensured good communication management among team members and product owner.
• Coached the team to improve their velocity over time by adopting best engineering practices.
• Helped the Product Owner to Prioritize the Product Backlog items for developing Sprint tasks
• Highly proficient in writing and prioritizing user stories in Product Back Log with Product Owner.
• Used JIRA for issue tracking, user story management and requirement traceability.
• Generated ad hoc SQL queries using joins, database connections and transformation rules to fetch data from the SQL Serverdatabase systems.
• Assisted with User Acceptance Testing, developing and maintaining quality procedures, and ensure that appropriate documentation is in place. Assisted in Black box testing, Integration testing, Load testing using Load Runner and Regression testing using UFT.

Environment: Waterfall Scrum Hybrid, MS Visio, MS Project, MS SQL server 2012, Visual studio 2013, JIRA 5.2, Tableau 8.3, Agile, MS Office Suite 2013, IAS 2012, Load Runner 12.02, UFT 12.02, HTML5, CSS3, Bootstrap, JavaScript, Angular JS, Java, HP-ALM, TFS, Visio, TFS, Jenkins, SharePoint.

Confidential

Business Analyst

Responsibilities:

• Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis.
• Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Used SDLC (System Development Life Cycle) methodologies like RUP and the waterfall.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Provided general TPF and Applications background to Independent Test Team for new Regression Test Enhancement project.
• Worked as an Interface between the Users and the different teams involved in the application development for the better understanding of the Business and IT Processes.
• Responsible for creating Business Requirement Specifications, to capture functionalities at all E-Commerce touch points.
• Implemented custom data collection systems. Systems allowed to move all online and IVR data collection in-house and managing personnel allocation and SDLC process for systems projects enhancements
• Analyzed the system for the effectiveness of the E- commerce operations
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Worked with the core team to design business requirement collection approach based on the project scope and SDLC Methodology.
• Verified data in XML messages using TPF-specific XML testing tools, verified XML structure through presence/absence of data, and verified triggering of pre-arrival message to customers based on business rule.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Responsible for providing analytical support in the Design, Development and Implementation of Project.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Visual Basic, SQL, SQL Server, Oracle, C#.Net, MS Office, MS Project, MS Visio, Scrum, DOORS, J2EE, Java, HTML, Windows Forms.

Confidential

Business Analyst

Responsibilities:

• Implemented Waterfall- Scrum Hybrid Methodology for the development of the application and facilitated sprints and daily stand up meetings.
• Elicited business requirements by participating in JAD sessions, conducting Interview sessions with business users and stakeholders, conducting sessions and consulting existing systems documents.
• Used document analysis to understand the AS-IS process and developed TO-BE process using GAP Analysis.
• Designed the Use Case Diagrams and coordinated with multiple resources in creation of Activity Diagrams and Sequence Diagrams.
• Worked on JIRA for bug tracking, issue tracking and project management functions.
• Coordinated with the development team to better define the functionalities of UI on front end and back end application programming interface (API).
• Used multiple prioritization techniques like MOSCOW, KANO and Walking Skeleton.
• Assisted the team to determine Story Points for User Stories using Estimation Techniques like Poker Planning, T-shirt sizing, Relative Mass Valuation and Dot Voting.
• Worked closely with Product management and Program manager in designing the change management plan and analyzed impact, incorporated feedback from business focus groups at each phase.
• Collaborated with Program manager, Product Management to revise User Acceptance criteria and change management plan by integrating the insights from focus groups and impact analysis.

Environment: Waterfall-Scrum hybrid, JIRA, MS Visio, SharePoint 13, UModel, Selenium, Informatica Power Center, Tableau, MS (Word, Excel, PowerPoint, Access), Fastlane, SharePoint.