SUMMARY

• Certified Scrum Master with overall 8+ years of Information Technology (IT) industry experience, 6+ years working as a Business Systems Analyst in various domains and 2+ years working as an ETL Developer.
• Expertise in Business Requirement gathering, Business Process Modeling and Business Analysis and understanding Business Process Flow.
• Strong knowledge of all the phases of Software Development Life Cycle (SDLC) and methodologies such as Agile - Scrum, Waterfall, Waterfall-Scrum Hybrid and Rational Unified Process (RUP).
• Well versed with all the phases of the SDLC phases such as Planning, Analysis/Design, Development, and Testing for the software/system development process.
• Highly skilled as a Scrum Master in conducting and facilitating the Scrum process. Well versed with agile scrum process like facilitation of scrum ceremonies and managing Requirements Churn.
• Proficient in conducting GAP analysis of AS-IS and TO-BE systems, SWOT analysis, Impact analysis, Feasibility analysis, Cost-benefit analysis, Cause & Effect analysis and Risk analysis.
• Experienced in facilitating Joint Application Development (JAD) sessions involving stakeholders, SME’s, project managers, business sponsors and business users as well as conducting one on one interviews, survey/questionnaires, brainstorming sessions, document analysis for requirement elicitation.
• Adept in creating various project artifacts like Business Requirements Document (BRD), Functional Specifications Document (FSD/FRD) and Systems/Technical Requirements Specifications (SRS/TRS).
• Proficient in translating business needs, processes and procedures into a workable system, and articulating specific software requirements by communicating these requirements with technology experts and business stakeholders.
• Excellent analytical, problem solving, communication, documentation and leadership skill.
• Good understanding in preparing Responsible, Accountable, Consulted and Informed RACI matrix.
• Expertise in gathering SMART (Specific, Measurable, Attainable, Realistic, Timely) requirements and transforming them into functional specifications focusing on workflow/user interface analysis and design.
• Proficient in creating UML diagrams like Use-Case diagrams, Sequence diagrams, Activity diagrams and Class diagrams using MS Visio, Rational Rose.
• Good knowledge of database relationships and concepts; worked on RDBMS like Oracle and MS SQL Server.
• Worked in all phases of Data Warehousing project like Data Cleansing, Data modeling for Operational Data Stores & Data Mart, ETL, Quality Assurance, Data updating plan, and Data presentation to business users.
• Expertise in designing schemas, creating databases as well as generating DDL and DML queries in SQL.
• Excellent skills in analysis, design, development and implementation of ETL tools like Abinitio, Informatica and reporting tools like Tableau, IBM Cognos and SSRS.
• Proficient in analyzing data for Master Data Management across various functional domains.
• Skilled with Data Analysis concepts of Data Modeling, Data Dictionary, Data Mapping and Normalization. Also worked on extracting data through writing complex SQL queries.
• Experienced in project management tools such as Microsoft Project, HP Application Lifecycle Management (HP ALM), Atlassian JIRA, Team Foundation Server (TFS) and VersionOne.
• Knowledge and experience with widely successful agile techniques: User Stories, Velocity, Story Points, Product/Sprint Backlog, Burndown/Burnup Charts, Test Driven Development, Extreme Programming (XP).
• Proficient in Blackbox Testing, Integration Testing, Regression Testing and User Acceptance Testing (UAT).
• Experience in creating and executing test plans for functional tests, QA tests, regression tests, smoke tests and UAT using HP Quality Center.
• Experience in reviewing documentation of developed solutions and authoring of basic instructions guides, and help files to assist in end user training and support.
• Comprehensive understanding of Web-Services like REST and SOAP using XML, WSDL and UDDI using internet protocol suite like HTTP under Three-Tier Architecture and Service Oriented Architecture (SOA).
• Proficient in writing business rules for Client-Side Validation and Server-Side Validation.
• Hands on expertise with collaborative tools like Sharepoint and Confluence for content management and knowledge sharing.
• Vast experience working with a mix of onsite-offshore Global Delivery model.
• Ability to adapt to new developments in the world of technology and working environment and prioritize & schedule multiple tasks on a day-to-day basis.

TECHNICAL SKILLS

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

Project Management Tools: JIRA, VersionOne, HP Application Lifecycle Management (ALM)s, Team Foundation Server (TFS), MS Project Professional 2013, Rally

Requirement Tools: IBM Rational DOORS, IBM Rational Requisite Pro

Languages: SQL, HTML/CSS, Java, JavaScript, XML, Unix, Korn Shell Scripting, PL/SQL

Databases/ Query Tools: Oracle, MS SQL Server, IBM DB2, Oracle SQL Developer, Toad

DW/ MDM Tools: Abinitio GDE 3.1.5, Abinitio Co-op, TRMC, Informatica Power Center, IBM MDM Initiate

Reporting Tools: Tableau, SQL Server Reporting Services (SSRS), IBM Cognos 10

Modelling Tools: MS Visio, Rational ROSE, Balsamiq

Testing Tools: HP QC, Bugzilla, LoadRunner

Miscellaneous Tools: MS Office, MS Sharepoint 2013/2010, Confluence

Domain Knowledge: Retail, Master Data Management, Data warehousing, ETL, Customer Flow Management System, Cashback Reward System, E-commerce.

PROFESSIONAL EXPERIENCE

Confidential, Mount Laurel, NJ

Sr. Business System Analyst/ Scrum Master

Responsibilities:

• Involved in preparing the project scope, objectives and gathered business requirements by conducting interviews, JAD sessions with subject matter experts (SME’s), stakeholders and development team for clarifying requirements and facilitating better communication and reaching consensus
• Conducted the GAP analysis to understand the shortcomings of the existing system and evaluated the benefits of the new system. Assisted in modeling the AS-IS and TO-BE business workflow.
• Prepared Business Requirement Document (BRD) and Functional Requirement Document (FRD) to provide details of each business, functional requirement and implementation plan of these requirement.
• Conducted interviews and group discussions with SMEs to comprehend retail domain knowledge and understand the existing applications & processes.
• Involved in Business Process Modeling (BPM) using BPMN and UML diagrams including Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and Data Flow Diagrams using MS Visio.
• Performed data analysis and data mapping and created Data Mapping documents and test casescenarios.
• Used MS Share Point 2013 for sharing documents, calendars and other artifacts between users in different locations.
• Involved in monitoring of Ab Initio Batch graphs for extracting data from different source systems.
• Facilitated the whole ETL process, packaged as part of a large Master Data Management (MDM) application.
• Facilitated standard scrum meetings and acted as servant leader to the team.
• Coached, trained and mentored team members, individually and in groups, on Scrum and general agile best-practices to help teams perform better and be more self-managing.
• Instructed and modeled core agile principles of collaboration, prioritization, team accountability and visibility. Ensured consistent application of scrum methodologies across the team.
• Created Requirements Traceability Matrix (RTM) for tracing the test cases back to the requirements, ensuring requirements are met in all the phases of the project using Rational RequisitePro.
• Worked on VersionOne for continues update with project schedules, quality, issues and managing resources.
• Authored data artifacts like Data Models, KPIs, ETL traceability mapping and Data transformation rules.
• Employed Business Intelligence (BI) to perform Data Analysis, created initial and minimum validation rules for Data Cleansing and identified the source-target transformations for correct Data Mapping.
• Used Abinitio for Extraction, Transformation and Loading from source database to target database.
• Used Agile Scrum methodology for the iterative development of the application.
• Removed internal and external impediments that hinder team’s productivity. Worked with the team in the grooming and prioritization of product backlog using technique such as planning poker.
• Organized and facilitated sprint planning, review, retrospective and daily SCRUM meeting. Created burn down charts, sprint & release backlogs for effective project management.
• Assisted the scrum development team in making appropriate commitments through story selection, story sizing and task definition.
• Served as liaison between the scrum team and the client, earning their confidence with reliable follow-through.
• Created User stories and then acceptance criteria for the PSPI (Potentially Shippable Product Increment).
• Worked with the Product Owner, Development/QA team for product increment demo sessions.
• Tracked Team Velocity and Sprint Progress using Sprint Burndown Chart and Product Burndown Chart.
• Assisted Product Owner in identifying right prioritization techniques (MoSCoW analysis) for prioritizing the backlog.
• Helped the QA team to develop the test plans and test cases to perform the blackbox, performance, load, regression and user acceptance testing (UAT).
• Created and reviewed test scenarios, test cases and executed them along with documenting test report for the project. Conducted User Acceptance Testing (UAT) and verified performance, reliability and fault.
• Removed team’s roadblocks on a daily basis and stimulated the team to deliver the committed sprint goals and deliverables. Managed product backlog as per business requirements.
• Collected feedback from the various stakeholders and product owner during sprint review meeting.

Environment: Waterfall - Scrum Hybrid, MS Visio, MS Word, WMB/ESB, XML, UNIX, Shell Scripting, Web Services, Oracle, PL/SQL, VersionOne, Abinitio CO-op, Abinitio GDE, IBM MDM, Rational RequisitePro, MS Sharepoint 2013.

Confidential, Phoenix, AZ

Scrum Master/Sr. Business Systems Analyst

Responsibilities:

• Facilitated Joint Application Development (JAD) sessions and walk through sessions involving business unit stakeholders, technical analyst, project managers thereby utilizing strong interpersonal, oral and written communication skills.
• Performed Job Shadowing and Document Analysis to analyze existing business processes. Created Flow Chart and Swim Lane Diagram for activities associated with each department.
• Interviewed business users to gather requirements and analyzed the feasibility of their needs by coordinating with the business users and Technical Lead.
• Conducted GAP analysis to understand the current and desired system and interviewed users to understand their needs.
• Identified and analyzed, defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements.
• Contributed to the definition of scope, performed extensive requirement analysis and defined functional specifications.
• Involved in requirement scoping and identifying high priority requirements for implementation.
• Partnered with the business stakeholders, process owners, users to identify their requirements and documented in the form of BRD, FRD and SRS, planned the project deliverables with the software development team and had the documents base-lined from the business owners.
• Developed Use Case diagrams by analyzing the business process to describe system interaction and functional requirements of the system.
• Created mockup screens of the graphical user interface (GUI) and wireframes of the automated application demonstrated it to the stakeholders and business users and took feedback from them.
• Created system would enable transfer of captured data through Web Services like SOAP, WDL, XML and REST services using HTTP protocol.
• Assisted in designing & developing relational databases for collecting data, executed simple and complex SQL queries to filter, retrieve the desired data.
• Acted as a liaison between various remote groups and third party vendors in order to communicate business requirements to ensure the deliverable quality, schedule adherence and risk mitigation.
• Responsible for 3 C’s (Card, Conversation and Confirmation) of the scrum process. Wrote user stories and helped Product Owner in prioritizing the Product Backlog by using Kano and MoSCow technique. Facilitated the effort estimation by using Planning poker.
• Organized and facilitated sprint planning, review, retrospective and daily SCRUM meeting. Created burn down charts, sprint & release backlogs for effective project management.
• Involved in tracking, communicating team velocity, sprint/release progress, involved in the management of the Product Backlog, Release backlog, Sprint Backlog and weekly Burn down charts using HP ALM.
• Conducted meetings and discussions to protect team from over-commitment, manage backlog, and prioritize resolution of defects/bugs.
• Assisted with the System testing, Regression Testing, Integration Testing, Smoke Testing and UAT with the other Business analyst and the Quality assurance team.
• Involved in implementing deployment like authoring the user training schedules & conducted user training.

Environment: Waterfall - Scrum Hybrid, MS Office, MS Project, Rational RequisitePro, Rational ROSE, HP ALM, Oracle, SQL, HTML/CSS, JavaScript, Web Services, Unix, IIS.

Confidential, East Hartford, CT

Sr. Business Systems Analyst

Responsibilities:

• Identified and analyzed business needs using techniques such as JAD, Interface Analysis, Requirements Workshops and Interviews with SMEs and stakeholders.
• Performed Job Shadowing and Document Analysis to analyze existing business processes. Created Flow Chart and Swim Lane Diagram for activities associated with each department.
• Assisted Project Manager in scope estimation and work breakdown structure (WBS) to meet Project Milestones.
• Worked closely with Project Team, SME and Internal Business Partners to clarify business requirements and translate the requirements into technical specifications.
• Prepared high level Business Requirement Document (BRD) for business users and low level Technical Requirement Specification (TRS) in consultation with the technical team.
• Involved with design team in creation of Use Case diagrams by specifying the actors, normal flow, alternate flow and Activity Diagrams to depict process flow and data flow of the system.
• Worked on creating prototype and mockup screens for visual representation of the system to be developed.
• Performed data analysis using SQL queries and MS Excel to understand current data metrics and provided the information to the business users during the JAD sessions as inputs.
• Used MS Project Professional to manage schedules, deadlines, resources and the project tasks.
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
• Implemented CDC (change data capture) for inserting and updating slowly changing dimension tables in target for maintaining the history data.
• Assisted in design review meetings to ensure all the requirements are covered in the project scope.
• Validated ETL mappings and tuned them for better performance and implemented various Performance and Tuning techniques.
• Validated Job flows and dependencies used by Autosys scheduler to run Informatica workflows and other shell scripts and stored procedures.
• Analyzed requirements for various reports, dashboards and scorecards and created the same using Tableau.
• Created Test cases and Test scripts for System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.
• Managed and tracked the Requirements, defined the Test Scenarios, tracked the defect and monitored the status of the issues. Documented the changes, issues and their impact on the system design and delivery.
• Created the Requirement Traceability Matrix (RTM) to capture all requirements and their traceability in a single document during requirement change request using Rational RequisitePro.
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing.
• Coordinated with development team to define the batch flow for data validation process.
• Involved in Functional Testing, Integration Testing and User Acceptance Testing (UAT) with the QA team.

Environment: Waterfall, MS Word, MS Visio, MS Excel, MS SQL Server, SQL, Web Services, Informatica Powercenter, HTML/CSS, .Net, JavaScript, MS Visio, MS Project Professional, MS TFS, Tableau, Rational RequisitePro,.

Confidential, Riverwoods, IL

Business Systems Analyst

Responsibilities:

• Elicited requirements by conducting JAD sessions with key stakeholders from business area & application development team.
• Performed GAP Analysis of business rules and system process flows to define current processes and determine future business requirements, creating AS IS/TO BE mapping for all new enhancements.
• Worked extensively with stakeholders in defining the scope and requirements of the project.
• Provided technical assistance in identifying, evaluating, and developing systems and procedures that were cost effective and met business requirements.
• Interacted/interviewed the subject matter experts to understand the customer demands and how the requested features will add value to the company’s product line.
• Authored the Business Requirements Document (BRD), Functional Requirements Document (FRD) & System Requirements Specification (SRS) for the project.
• Served as liaison for other interfacing applications like Customer Data Information (CDI), Data Power and other third party applications.
• Created UML diagrams like Use Case Diagrams, Activity Diagrams and Process Flow Diagrams using MS Visio.
• Produced wireframes, UI mockups and functional prototype to demonstrate requirements to project stakeholders as well as the technical team.
• Involved in coming up with business rules in the middle-tier layer based on SOA architecture.
• Authored scenarios for the applying client-side validation rules using JavaScript.
• Presented meeting agendas and communicated progress of the project to the senior management.
• Authored test cases, and test plan, requirement traceability matrix with the help of QA team as well as ensuring testability, reliability, usability, maintainability and performance of the application.
• Extensively involved in Black Box testing, Systems testing and User Acceptance testing (UAT).

Environment: Waterfall, MS Office, MS Visio, GAP Analysis, Rational RequisitePro, UML, HTML/CSS, Web Services, SOAP, XML, JavaScript, IBM DB2, Balsamiq, Black Box Testing, UAT, MS Project Professional, HP QC, MS Sharepoint 2010 .

Confidential

Jr. Business Systems Analyst/ ETL Developer

Responsibilities:

• Conducted interviews with stakeholders for eliciting requirements.
• Gathered and analyzed business requirements from stakeholders and business users.
• Created the Business Requirement document (BRD) artifacts after gathering input from business owners and other stakeholders.
• Performed GAP Analysis of business rules and system process flows to define current processes and determine future business requirements, creating AS IS/TO BE mapping for all new enhancements.
• Analyzed scope and complexity of existing reports on packages, query subjects, query items, filters, dimensions, measures, in IBM Cognos through Report Studio.
• Used conditional formatting, sort data, calculations, drill-up and drill-down features in IBM Cognos for report analysis.
• Created Process flow diagrams and Information Flow Diagrams in MS Visio.
• Created data mappings from existing reports for migration and prepared Data Mapping Documents for further estimations.
• Created Dashboards to present critical company data in a single report and used joins in Report Studio.
• Manually modified theSQLin Report Studio to tune and to write complicated reports.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Provided assistance in identifying, evaluating, and developing systems and procedures that were cost effective and met business requirements.
• Created list reports, crosstab reports & charts and exported reports in pdf, excel, xml and CSV formats.

Environment: Waterfall, MS Excel, MS Word, MS Visio, Oracle, IBM Cognos Report Studio, Sharepoint, SQL ServerMS Project Professional, UML.

Confidential

ETL Developer

Responsibilities:

• Coordinated between client side and Offshore Development Team for ETL module.
• Designed and Developed the graphs using the GDE, with components partition by round robin, partition by key, rollup, sort, scan, dedup sort, reformat, join, merge, gather, read xml, write xml, Lookup, Input/output table components.
• Assisted in creation of Functional Requirement Document based on Business Requirement Document.
• Performed data analysis and data mapping and created Data Mapping documents and test casescenarios.
• Attended JAD sessions to gather business requirements from technical perspective and create high level and low level design documents.
• Involved in development of Ab Initio Batch graphs for extracting data from different source systems and validating it for primary conditions, transforming it according to the business rules and loading it into the DataMart.
• Worked with Multi-file systems, used partitioning and de-partitioning components to switch the depth to increase the parallelism and repartition data while joining.
• Tuned Abinitio graphs using parallelism, phasing, using lookup file components and other performance tuning techniques.
• Developed and facilitated the whole ETL process, packaged as part of a large DataMart application using Ab Initio,PL/SQL and Unix Scripts.
• Debugged various Ab-Initio Graphs using File Watchers for monitoring the intermediate results.
• Tuned Abinitio graphs using parallelism, phasing, using lookup file components and other performance tuning techniques.
• Developed UNIX scripts for performing data validation, data quality checks, exception handling and FTP.
• Performed Unit testing and assisted in White Box testing, Functional testing, and User Acceptance testing (UAT).
• Responsible for day-to-day ETL deliverables across the team & assisted other teammembers for deliveries in a timely manner.
• Worked on project tagging and migration of the code from one environment to another.

Environment: Ab Initio GDE 3.0.2, UNIX, Korn Shell Scripting, SQL, PL/SQL, Oracle, Toad, WinSCP, Putty, JAD, MS Office Suite (Word, PowerPoint, Access, Excel, Outlook), MS Visio, LoadRunner.

Confidential

PL/SQL Developer

Responsibilities:

• Understanding business requirements and defining business logic.
• Extensively used SQL*Loader for Data loading into Oracle from various data sources.
• Wrote cursors and control structures using PL/SQL.
• Developed DDL SQL scripts to create new tables and DML scripts to update, insert and delete records.
• Defined business mapping rules based on inputs provided by onsite in Offshore-Onshore Delivery model.
• Development of PL/SQL code for conversion of given data into SAP Load files based on business rules.
• Used Indexes, Views, Triggers, Stored Procedures and Packages for updating and cleaning the existing data and also for the efficient retrieval of data.
• Development of PL/SQL procedure for Quality Assurance/Quality Checks to ensure Data Integrity.
• Core Member of the QA team, responsible for Data Validation and Improvement.

Environment: PL/SQL, Oracle, SQL Developer, SQL*Plus, MS Office Suite (Word, PowerPoint, Access, Excel, Outlook), MS Project, MS Visio, Bugzilla.