Manager Data

****************@*****.*** Kumar Ritesh

612-***-**** Sr. Business Analyst

AVAILABILITY:

ASAP

TOOLS/METHODS:

RUP, UML

JIRA

Agile, Waterfall

MS Visio

MS Office (Word, Excel, PowerPoint, Project, Outlook, Access)

MS SQL Server

Mock-Up Screen

MS SharePoint

IBM Cognos

.NET

Tableau

HP ALM

Informatica Metadata Manager

Data Mapping

SOAP

Salesforce CRM

SAP PowerDesigner

Six Sigma

RELEVANT CLIENTS:

Capital One

Bank of America

Dept. of Administrative & Financial Services

American Express

Cigna Health Insurance

EDUCATION:

MS in Information Systems

RELEVANT EXPERIENCE

Sr. Business Analyst professional with over 8 years of expertise in the Healthcare, Financial, Banking, and Public Sector domains. Most recently wrapped up with Capital One as a Sr. Business Analyst and involved in enhancing web applications and mobile app’s features. Highly experienced in working with the development as well as the business side to create complete technical and functional specifications.

SKILLS INVENTORY

Analysis/Design:

In-depth knowledge and practical experience of using Waterfall, Agile, Scrums, Rational Unified Process, Business Process Reengineering, Unified Modeling Language, System Requirements Specification and Functional Requirements Specification, Rapid Application Development, and MS Visio.

Highly qualified in changing the needs of business users and stakeholders to the functional/technical requirements.

Served as a critical resource and liaised between subject matter experts and technologists throughout the project life cycle.

Excellent conceptual and technical skills to create Business Requirements Document, Functional Specifications Document, Process Flow Diagram, and Detailed Design Document.

Experience conducting JAD (Joint Application Development) sessions with Stakeholders and Business Partners to resolve issues.

Performed Scope Analysis, Stakeholder Analysis, Gap Analysis, and Traceability Matrix and used Visio for Business Process Modeling adopting UML standards.

Proficient in Business Requirement Gathering, Process Re-Engineering, Change Management, Risk Management, Transaction Processing, Documenting Enhancement Requests, Business Process Flow and Process Modeling.

Expertise in Product Backlog Prioritization Techniques (MoSCoW, Business Value, Kano, Walking Skeleton and Technical Risk) and estimation techniques (Planning Poker, T-shirt sizing and Relative mass evaluation).

Extensive experience in the field of Business Analysis, Risk Analysis, Software Validations in Banking projects, multi-tier, and web-based application for various horizontal and vertical industries.

Experienced in creating Business Process Procedure Documents and providing system training to business and end-users.

Solid project execution track record with good leadership, strong communication, and analytical skills.

Prioritized work requests from project team.

Identified and communicated risks and with possible solutions.

CHRONOLOGICAL SUMMARY OF EXPERIENCE

Sr. Business Analyst

Capital One, Minneapolis, MN November 2015 – Present

This project was about enhancing Web Application and Mobile App’s features such as temporary passwords, adding modules, sure swipes, and other transactional features for Web Application.

Led the project from inception through to deployment by establishing and adhering to time boxed project plans, proactively identifying and resolving risks, and regularly communicating progress against defined milestones.

Conducted GAP and SWOT Analysis by identifying AS-IS and TO-BE business process models and process flows.

Used Sig sigma tools like SIPOC, Control Chart, Control Plan and Fish Bone diagrams to get a control over product management.

Effectively incorporated Business Process Re-engineering (BPR) for faulty features.

Collaborated with SME’s and Stakeholders to elicit and analyze requirements for prioritization.

Conducted questionnaires and facilitated JAD Sessions with Business Users, Developers and Database Design Team to deal with backend synchronization problems accompanied with interviews and document analysis.

Designed prototype Mock UI screens for each template of Web/Mobile application using Balsamiq Mockups.

Worked in close conjunction with the architecture team to design the Conceptual and Logical Model of the system.

Created Use Case Diagrams, Activity Flow Diagrams and Business Process Flow Diagrams in MS Visio.

Maintain data virtualization models in a case tool, such as ERWin, SAP PowerDesigner or ERStudio.

Assisted in drafting the Artifacts by collaborating with Technical Teams and Stakeholders.

Worked with the product owner and development team in deciding and negotiating the definition of done and acceptance criteria for Potentially Shippable Product Increment (PSPI).

Participated in scrum ceremonies such as sprint planning, daily scrum meetings, sprint review, sprint retrospective and backlog refinement with cross functional scrum development team.

Assisted the Product Owner in prioritizing the product backlog in the backlog grooming meeting using various prioritization techniques such as Moscow, Kano Analysis, Walking Skeleton and Business Value.

Assisted senior managers in the development of RFPs.

Assisted BI developers in creating various types of reports/sub-reports and drilldown like standard and cross tab-reports with bar chart, pie chart, and line-chart graph representation reports using Cognos.

Coordinated and communicated with Scrum Masters to relegate dependencies during the sprint.

Assisted in removal of impediments and monitoring defect logs, which in turn assisted in velocity and capacity calculation for superior planning of upcoming sprints.

Responsible for decomposing EPICS into manageable User Stories by applying the INVEST criteria.

Worked with the UI team verifying the completeness of client side validations by developing exhaustive Test Cases and Test Scenarios and assisted in the automation of the UI testing process using tools like Selendroid and HP QTP.

Created and maintained the Requirement Traceability Matrix (RTM) throughout the project execution.

Incorporated Change Management to control organizational change efforts, with the goal of maximizing benefits and minimizing negative impact.

Responsible for business and functional requirements in the test strategy and participated extensively in User Acceptance Testing at the client environment.

Assisted Project Manager in automating the Contract Management Process as an add on project.

Environment: Scrum methodology, Rally, .NET, JIRA, MS Office Tools (Word, Excel, PowerPoint), MS Visio, MS Project, JIRA, Informatica Metadata Manager, Mock-Up Screen, SAP PowerDesigner, MS SQL Server, SharePoint, UML

Business Systems Analyst

Bank of America, Baltimore, MD February 2014 – November 2015

The scope of the project was to develop standard reports Using Cognos from various source systems by extracting and developing a Data Warehouse. This helped the organization to meet the technology needs and facilitated the increasing customer data. Developed complex databases, program models to extract data and use databases to provide statistical and financial modeling. Oversees the data design, analysis of portfolio trends, concerning credit score cutoffs, loss trends, portfolio dynamics, and bureau scoring criteria.

Studied and understood the state of art processes by interacting with stakeholders and in-depth documents analysis.

Worked closely with business groups to gather requirements, define business strategy, and created a centralized reporting capability for users to perform analytical reports.

Responsible for production and review of FR Y-14Q schedules, including data acquisition and validation, compliance with reporting instructions, review and analysis, and alignment with other external regulatory reporting disclosures.

Effectively incorporated Business Process Re-engineering (BPR) for faulty features.

Facilitated JAD sessions and questionnaires as moderator and conducted interviews with various Subject Matter Experts (SMEs) and Stakeholders.

Prepared Business Requirement Document (BRD) and assisted in preparing system requirement specification (SRS).

Performed SWOT Analysis of business rules, business and system process flows, user administration and business requirements. Mapped the requirements to the new system and thoroughly documented the same in the BRD.

Assisted the business intelligence team in providing the insights on types of reports to be extracted.

Implement target state operating model, including standard data sources for all FR Y-14Q/M schedules.

Liaise with reporting Subject matter experts within regulatory reporting to drive centralized control framework.

Oversee the preparation of business review packages and present to senior stakeholders which includes governance processes that ensure the accuracy, completeness and relevance of CCAR as well as variance analyses that explain fluctuations in terms of business events.

Develop control reports for internal and external edit checks; review and validate business responses.

Identified the attributes that were vital based on the reporting requirements and ensured they were available.

Worked on gathering requirements for different Relational Database Management Systems (RDBMS) in extracting the data into staging area and populating them onto Data Warehouse.

Maintain data virtualization models in a case tool, such as ERWin, SAP PowerDesigner or ERStudio.

Assisted and worked with ETL developers and data modelers to make sure that the model being developed was according to the business requirements.

Developed Conceptual and Logical ER Diagrams identifying the entities, constraints, relationships and cardinality.

Responsible for creation of Use Cases and developed Use Case Diagram and Activity Diagram using MS Visio.

Prepared and maintained Data Dictionary, Meta Data Registry and Data Mapping Document for the data models.

Ensured Data Integrity using various techniques such as performing Data Normalization, Data Validation and Data Validity to enforce accuracy and effectiveness of data.

Assisted BI developers in creating various types of reports/sub-reports and drilldown like standard and cross tab-reports with bar chart, pie chart, and line-chart graph representation reports using Cognos.

Worked in Cognos report studio in extracting reports using filters and framework manager in creating data models.

Worked in dimensional modeling process such as Star Schema and Snowflake Schema.

Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries on MS SQL Server. Used JOINS and nested queries to export data from the database.

Managed and tracked requirements of the Application Life Cycle using HP ALM.

Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing, and Regression Testing.

Handled change requests by performing Impact Analysis on the business and technology fronts and submitted it for approval from the Change Control Board (CCB).

Incorporated Change Management to control organizational change efforts, with the goal of maximizing benefits and minimizing negative impact.

Served as a key liaison between the management, design and development team, and assisted the project manager in project tracking and completing tasks according to the project charter.

Environment: Waterfall, MS Office, .NET, Cognos, Informatica Metadata Manager, MS Visio, MS Project, HP ALM, Wireframes, Mock-Up Screens, SAP PowerDesigner, MS SQL Server, UML, ETL, SharePoint.

Business Systems Analyst

Dept. of Administrative & Financial Services, Augusta, ME May 2013 – January 2014

The project was aimed at modernizing and enhancing the State’s data warehouse by implementing a centralized, consolidated enterprise data warehouse to improve the user’s ability to access and utilize critical payroll, accounting, budget, and human resource information. The proposed enterprise data warehouse involves migration of the databases supporting the financial data warehouse. The goal was to make this migration as seamless as possible to all end-users and the users will continue to access data using the existing tools with no loss in functionality.

Worked to ensure that business process outcomes were in harmony with strategic goals and worked to help improve the management of a business process.

Effectively incorporated Business Process Re-engineering (BPR) for faulty features.

Conducted GAP Analysis to understand limitations of the existing system and contributed to design of future system.

Assisted in modeling the AS-IS and TO-BE business workflow.

Assisted in drafting the Business Requirement Document and Functional Requirement Document by collaborating with technical teams and stakeholders.

Facilitated JAD sessions, Questionnaires, Document Analysis and Interviews with the stakeholders for the requirements elicitation and documented Business Requirement Document (BRD) and Functional Requirement Document (FRD).

Created high fidelity mockup diagrams to understand the work flow in user interfaces.

Proposed and developed a Business Glossary to unify the definition of key attributes in the organization.

Proficient at generating Data Mapping Artifact and identified transformations to cleanse and improve Data Quality.

Assisted BI developers in creating various types of reports/sub-reports and drilldown like standard and cross tab-reports with bar chart, pie chart, and line-chart graph representation reports using Cognos.

Used Business Process Management Notation (BPMN) for managing and improving the business process efficiency.

Created ER Diagrams for one-to-one and one-to-many mapping relationships using SQL Server.

Performed various SQL query operations such as DML and DDL commands and was responsible for supervising the source to target mappings in Informatica Power Center. Responsible for performing Data Profiling and Data Mapping.

Developed Test Scenarios/Scripts and Test Plans. Prepared User Acceptance Test Cases (UAT), UAT issue log for tracking the defects and collaborated with system users to conduct the User Acceptance Test.

Assisted the ETL team in integrating various OLTP to the OLAP by using Informatica and Tableau for reporting.

Prepared and maintained Data Dictionary, Meta Data Registry and Data Mapping Document for the data models and also responsible for performing Data Profiling and Data Mapping.

Facilitated the team in performing ETL operations to load the data into data marts using Informatica Power Center.

Worked in dimensional modeling process such as star schema and snow-flake schema.

Performed SQL queries using Joins and Nested Queries to fetch data from MS SQL Server.

Prepared and maintained the Requirement Traceability Matrix (RTM) and Monitored performance testing results for several modules within the application.

Incorporated Change Management to control organizational change efforts, with the goal of maximizing benefits and minimizing negative impact.

Performed Risk Management in the project by maintaining a risk register to identify and mitigate risks in the project development process.

Environment: Waterfall, MS Visio, MS Project, MS Office, UML 2.0, HP ALM, Informatica Power Center, Tableau, SharePoint, MS SQL Server, HTML5, CSS, Informatica Metadata Manager, Balsamiq, Selenium, Data Mapping, Data Transformation, SOAP, XML.

Business Analyst

American Express, Phoenix, AZ February 2012 – April 2013

The goal of the project was to strengthen the development and implementation of organization’s Salesforce CRM and SQL reporting systems for the alignment of the organization’s sales.

Participated in the system development process life cycle from concept through testing, implementation, and support.

Developed and introduced new features and capabilities in CRM application by analyzing information needs and functional requirements to deliver needed artifacts such as Business Requirement Document (BRD), Functional Requirement Document (FRD) and Use Case Document.

Created Activity and Sequence Flow Diagrams for the better understanding of the process.

Interacted with stakeholders and gathered requirements from the business and collected overall system requirement through JAD Sessions and Interviews.

Implemented security configurations, customizations and integration for profiles and OWDs.

Coordinated with the offshore development team on the progression and development of the requirements.

Worked on managed Accounts like receiving investments from a wide variety of professional investment managers and ongoing account reviews, selecting from several account types with different investment styles and tax management opportunities, payment of single fee based on the assets in your account versus multiple transactional fees.

Assisted BI developers in creating various types of reports/sub-reports and drilldown like standard and cross tab-reports with bar chart, pie chart, and line-chart graph representation reports using Cognos.

Facilitated with data engineers to conduct data validation and mapping from existing systems into data ETL systems to integrate data to the CRM object and business models.

Analyzed the defects in UAT and production and categorized/prioritized them and then assigned it to the right resource for fixing the defect.

Pioneered the company’s CRM software training program, curriculum and materials production. facilitated training for the junior staff on producing critical management sales performance insights.

Environment: Waterfall, Windows 7/8, Informatica Metadata Manager, MS Office Suite, MS Visio, SharePoint, Salesforce CRM, UML.

Business Analyst

Cigna Health Insurance, Bloomfield, CT March 2009 – December 2011

The scope of the project was to enhance web application by re-engineering with inclusion of new features and make the application user friendly.

Responsible for creating and reviewing Business Requirements, Functional Specifications, Project Schedules, Documentation and Test Plans.

Conducted GAP Analysis to understand limitations of the existing system and contributed to design of future system. Assisted in modeling the AS-IS and TO-BE business workflow.

Assisted in drafting the Business Requirement Document (BRD) by collaborating with technical teams and stakeholders.

Facilitated JAD sessions, Questionnaires, Document Analysis and Interviews with the stakeholders for the requirements elicitation.

Created High Fidelity Mockup Diagrams to understand the work flow in user interfaces.

Created and maintained Use Case Documents based on the system’s requirements. Explained the Business Process Flows and created detailed diagrams such as Use Case Diagrams, Data Flow Diagrams (DFD’s), Activity Diagrams, Sequence Diagrams, Entity Relationship (ER) Diagrams and Work Flow Diagrams using MS Visio.

Used Business Process Management (BPM) for managing and improving the business process efficiency.

Created ER Diagrams for one-to-one and one-to-many mapping relationships using SQL Server.

Used MS Access and Excel to extract, administer and manipulate large data.

Performed SQL queries using joins and nested queries to fetch data from MS SQL Server.

Prepared and maintained the Requirement Traceability Matrix (RTM).

Performed Risk Management in the project by maintaining a risk register to identify and mitigate risks in the project development process.

Involved in reporting status, milestones, and project plan tracking to project manager and product owner on a weekly basis.

Environment: Waterfall, JIRA, .NET, MS Project, MS Office, Mock-Up Screens, UAT, SharePoint.

Contact this candidate