SUMMARY:

• Proactive goal oriented and cross functional Business/Data Analyst and Scrum Master with over 7 years of experience in Banking, Finance and Retail domains dealing with LOS and LSS systems with a focus on designing, development and implementation of business processes and system solutions with addition of an in - depth domain understanding of the entire banking business operations
• Outstanding experience working as a liaison between business and technical sides to convey the business needs to the system architect.
• Excellent experience with various methodologies including SDLC, Iterative Software Development Life Cycle as per Agile-SCRUM and Project Management Life Cycle.
• Excellent skills in Business Analysis, Data Analysis, Requirement Analysis, Business Process Modeling and Use Case development using UML methodology.
• Experience in requirement gathering techniques like JAD Sessions, Interviews, Story Boarding and Structured Questionnaires.
• Extensive experience in Loan Servicing Modules.
• Experience in Data Modeling with good exposer to creation Star & SnowFlake Schemas, Dimensional Tables and FACT, Physical and Logical Data Modeling.
• Extensive experience in Gap Analysis to analyze and compare actual performance against potential performance and identify the key areas, which need to be improved.
• Strong Experience in conducting Impact Analysis to analyze and identify the key business processes that need to be changed to promote system efficiency.
• Excellent experience working with QA teams and developing test cases.
• Proficient in identifying and training business users for UAT.
• Excellent communication skills to deal with people at all levels and ensuring successful communication via actively listening and probing questions.
• Outstanding Problem Solving skills to resolve queries in a methodological manner and find appropriate resolutions.
• Refined Planning & Organizing skills that balance work and responsibility in a professional manner.

TECHNICAL SKILLS:

Team Foundation Server (TFS)

JIRA

Adobe Experience Manager

Confluence

MS Access

MS Project

MS VISIO

Tableau

BluePrint

Clarity

HP ALM, Quality Centre and QTP

BPM

Visual Studio

SQL Server Management Studio

MS SQL SERVER 2012/2008/2005/2000

Rational Requisite Pro

Rational Clearquest

Quality Center

.Net Framework 2.0,3.0,3.5

C#

HTML

AJAX

XML

LINQ to SQL

Entity Framework

Web Services

Agile - SCRUMRational Unified

Process(RUP)

Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, TX

Product Owner/Business Analyst

Responsibilities:

• Coordinating Daily Scrum, Sprint Planning, Backlog Grooming and Sprint Retrospective sessions.
• Utilizing TFS to generate Agile metrics such as Sprint Burndown, Capacity planners, Sprint Velocity Projections metrics etc.
• Leading requirements gathering meetings such as JAD sessions with Business Users, Technical architects and other stakeholders to efficiently define the project requirements, scope and limitations.
• Performing Extensive GAP analysis between the legacy InTouch and the upcoming Online InTouch application to efficiently layout the Epic Level requirements for other downstream impacted teams.
• Performing Cross Impact analysis to understand and define development impact on other applications within Confidential .
• Converting (Epic Level) requirements into functional user stories.
• Conducting Sprint Planning session with the Development teams and Business stakeholders to prioritize user stories for upcoming Sprint Cycle and also to prioritize items for the ongoing Sprint Backlog.
• Generating Monthly SQL and Tableau reports for MK-Ecards and Online Agreements by executing SQL Stored Procedures and writing SQL statements.
• Utilizing Adobe Experience Manager tool for dynamic content management.
• Working with the Program Manager to manage Business Change Requests in between a given Sprint Cycle.
• Liaison between Creative (Front-End), ETL(Informatica), Legal and Product Design teams.
• Creating Use Case Diagrams, Activity Diagrams and Sequence Diagrams utilizing UML methodology by utilizing MS Visio.
• Defining rules and SLA for the extraction of information from the database for Informatica ETL Jobs
• Utilizing MS Access for Data Base management
• Writing manual Test Cases in Visual Studio (MTM).
• Executing Manual Test Cases and documented defects in TFS.
• Leading the Defect Triage meetings to prioritize defects for Product Backlog and Technical Debt Buckets.
• Authoring Manual Test Cases for User Acceptance testing.
• Creating release documents and ITSM’s for Staging and Production releases.
• Working as a release manager for regular Sprint releases and HotFixes(Expedited release).
• Performing verification and validation in production environment to provide signoff post release.

Confidential, TX

SCRUM MASTER/BUSINESS ANALYST

Responsibilities:

• Facilitated and led all Scrum meetings including daily scrum, sprint planning, sprint retrospectives, sprint reviews and backlog refinement
• Initiated and participated in Scrum of Scrum meetings to identify and resolve cross-impacts
• Coordinated with Product Owners and Application development managers to ensure critical roadmap items are listed in the product backlog
• Tracked and reported all Agile metrics using TFS during a particular sprint.
• Functioned as Scrum/Agile Coach/mentor for all scrum teams with goal of alignment and adoption of Agile principles
• Proactively communicated and collaborated with external & internal business stakeholders and external Vendors to analyze the functional requirements.
• Performed extensive Gap Analysis between the Company's Legacy System and the Proposed System.
• Gathered and Maintained Functional, Non-Functional and Legal Document related requirements in TFS.
• Created Project cross impact matrix using BPM tools
• Defining and documenting high level and functional requirements into Agile stories.
• Created detailed Use Cases with components such as, but not limited to Main Case Scenarios (MCSs), Exception paths and Alternate paths - with a heavy emphasis on analysis.
• Created detailed Use Case diagrams using Visio to help the team analyze end to end solution.
• Created and Maintained Change Requests in TFS to keep the evolving Functional requirements intact.
• Identified weaknesses in User Story estimation/ Pointing process and fostered team’s agreement for Definition of Ready to address this weakness
• Conducted JAD sessions with the Testing, Application Development, Platform, Accounting, Finance and Legal teams.
• Worked as a Liaison between Accounting, Accounting Integration, Data warehousing (ETL) and their individual QA teams.
• Worked independently with Business Stakeholders to define concepts
• Reviewed Product backlogs and prioritize Agile stories accordingly for every upcoming sprint.
• Collaborate with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs.
• Assisted QA teams with Triage, Test case design and manual execution of test cases to keep the project timelines intact.
• Worked as a liaison between QA and Development team and reviewed test plans and test scripts developed by development team and QA teams to make sure all requirements have been covered in scripts and tested properly.
• Supported the completion of UAT and Production validation with the different business teams including coordinating testing of report changes, gathering test scripts.
• Managed Production Releases by conducting release meetings and maintain Production Release/ Play Books

Confidential, TX

BUSINESS ANALYST

Responsibilities:

• Utilized Agile-SCRUM and Waterfall methodology for the entirety of the projects.
• Heavily interacted with product owners and line of business to gather user stories to design the product backlog.
• Participated in Sprint Planning, Sprint Review and Sprint Retrospective meetings to achieve project objectives in a more efficient manner.
• Assisted in defining rules for the extraction of information from the database.
• Assisted in defining business rules for transferring loan information between the Loan Origination System (LOS) and the Loan Servicing System (LSS).
• Assisted in defining business rules for the extraction of information from XML files sent by credit report agencies, REO, payment recovery and collection agencies.
• Designed and implemented Modules for Data integration related to Extract/Transfer/ Load.
• Defined the key Identifier for each mapping and interface.
• Worked closely with the Control M team to optimize the SLA for INFORMATICA ETL jobs and maintained templates.
• Created concept design documents (CDD) for project scoping purposes.
• Used Clarity reporting tool for maintaining the Planning, Scoping and Actual hours of the project.
• Created Impact Matrix documents to layout the high level project scope impacts for various teams.
• Coordinated with Business users and Stakeholders via JAD sessions to gather and analyze functional requirements.
• Analyzed and worked on IEFs (Information Exchange Format) and STMs (Source to Target Mapping) for the seamless transition of all extracted data to required internal systems.
• Created detailed Use Cases with components such as, but not limited to Main Case Scenarios (MCSs), Exception paths and Alternate paths - with a heavy emphasis on analysis.
• Used BluePrint requirement management tool to create and maintain FSD (Functional specification document) for waterfall projects.
• Implemented and delivered business processes in iterations (Sprints) using Agile-Scrum Development methodology.
• Conducted JAD sessions with extensive involvement fromBusiness, Development team, Testing teams, Architects, SMEs, Managers, Project Owners and Sponsors.
• Worked with various teams in the Backlog Release Planning and Sprint Planning.
• Drafted user stories for each iteration and maintained the product backlog for all agile projects.
• Used HP ALM and JIRA to maintain traceability of requirements and defects.
• Assisted QA teams with test plan and test strategy documents.
• Trained UAT testers on the newly developed ETL interface and coordinated between various UAT teams.
• Worked with the developers and project manager to draft RUN books and Play Books for seamless production deployments.
• Created change management & risk management documentation to keep a track of assumptions and dependences from the old and the new system.
• Performed weekly milestone meetings along with the Developer and the QA teams to provide the management information on the progress of the transition.
• Updated management about project development in weekly meetings using MS Project.

Confidential, GA

BUSINESS/DATA ANALYST

Responsibilities:

• Utilized Agile-SCRUM methodology for the entirety of the project.
• Heavily interacted with Product Owners to gather user stories and design a product backlog.
• Participated in Sprint Planning, Sprint Review and Sprint Retrospective meetings to achieve project objectives in a more efficient manner.
• Assisted in defining rules for the extraction of information from the database using XML format for transmission to third banks.
• Developed the XML schema for transferring loan information between the Loan Origination System (LOS) and the Loan Servicing System (LSS).
• Assisted in defining business rules for the extraction of information from XML files sent by credit report agencies.
• Designed and implemented Modules for Data integration related to Extract/Transfer/Load.
• Defined the key Identifier for each mapping and interface.
• Defined Source to Target Data Mappings and Definitions.
• Coordinated with BUs and Stakeholders via JAD sessions to gather and analyze functional requirements.
• Created Business Rules for the required scenarios within the LOS and LSS.
• Created detailed Use Cases with components such as, but not limited to, Main Case Scenarios (MCSs), Exception paths and Alternate paths - with a heavy emphasis on analysis
• Inserted identified requirements, risks and considerations on Rational Requisite Pro, informing project development for the management.
• Created and maintained FRS (Functional Requirement Specifications), IEFs (Information Exchange Format) and STMs (Source to Target Mapping) for the seamless transition of all extracted data to required systems (internal and from third party banks).
• Conducted GAP analysis and change management & risk management documentation, keeping track of assumptions and dependences from the old and the new system.
• Assisted in the Digital Marketing effort of the new system and managed content using Adobe Experience Manager.
• Created Use Cases, developed scripts and scheduled and participated on testing cycles with the Development and QA Teams.
• Wrote SQL queries for the validation of data.
• Performed weekly milestone meetings along with the Developer and the QA teams to provide the management information on the progress of the transition.
• Assisted in Updating management about project development in regular meetings using MS Project.

Confidential, IL

BUSINESS/DATA ANALYST

Responsibilities:

• Utilized Agile-SCRUM to standardize all requirement-gathering procedures and change management as well.
• Conducted JAD sessions to efficiently get to a consensus on project requirements and limitations.
• Led requirements gathering meetings with business users, technical staff and other stakeholders.
• Created data trace map and data quality mapping documents.
• Performed Data Profiling and Data Quality.
• Worked with Data warehousing developers to assess the impact on the current implementation and design of ETL Logic.
• Developed Business Requirement Documents (BRD) as well as use case scenarios using MS office suite.
• Created Use Cases, Use case Diagrams, Activity Diagrams and Sequence Diagrams utilizing UML methodology.
• Constructed optimized page layouts for Salesforce standard objects.
• Worked closely with the Fraud detection team.
• Associated custom objects reports to the dashboard.
• Participated in meetings with the Quality Assurance team to design and develop test plans and test cases.
• Created tests cases that included making changes to the term of the loan or restructuring the loan with a different interest rate.
• Assisted QA Team in training end users for UAT.
• Validated data using SQL Queries.

Confidential

.Net DEVELOPER/ Systems Analyst

Responsibilities:

• Developed Data Access Layer using Entity Framework & LINQ
• Developed Front end Layer using ASP.NET (HTML and CSS).
• Developing Optimized SQL queries/ Stored Procedures to enhance the performance of the application
• Supported Production Support team during the deployment & troubleshooting the production issues during deployment
• Utilizing MS Access for Data Base management
• Acted as a liaison between stakeholders: system users, clients and managers, who have a business problem, and software development team to gather requirements.
• Followed Agile methodology throughout the project and conducted Scrum meeting with the team members on day to day basis for the update on project status.
• Conducted a detailed ‘As Is’ Analysis and documented the existing process and data flow diagrams.
• Analyzed the existing processes to identify areas for automation and created an improved and detailed ‘To Be’ Process and Data flow.
• Analyzed data and created class diagrams and ER diagrams for designing databases.
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Designed UI screen mockups for the proposed system, using MS Visio, to provide a user friendly front end for the proposed system.
• Created UI Specification document to detail out each and every field for the new system.
• Prepared detailed Use Cases based on screen mockups for the proposed system.
• Participated in design sessions with Tech lead and developers to come up with a fully automated solution meeting all requirements.