M V KUMAR

Business Systems Analyst

ac39gz@r.postjobfree.com

+1-505-***-****

Self-Driven Business Analyst with more than 12+ years of experience leading cross-functional projects, programs within domain expertise in Banking, Retail / Energy, Healthcare, WCM (Manufacturing), EDI, Education etc. Adept at navigating and solving complex issues and drive change, believes in Continuous Learning. Talented communicator with analytical thinking and good R&D, able to strengthen relationships with peers and senior leadership, build consensus with excellent interpersonal skills, and elicit clear decisions from clients and all levels of stakeholders.

SKILL SET

Methodologies

Agile (SCRUM), Waterfall

Documentation Tools

MS Excel, Word, PPT, JIRA, Confluence, Draw.IO, VSS

Databases

SQL SERVER 2008R2, 2012

ETL Technologies

MSBI (SSIS, SSRS)

Web Technologies/ API

ASP.NET, ADO.NET, Web Services, Postman, DotNetNuke

Data Format

XML, JSON, HTML

Testing

Manual Testing, Knowledge on JMETER and Selenium.

Certification

Lean Certified from HSBC

PROFESSIONAL SUMMARY

Work experience: Business Systems Analyst (5years)/ QA (3years)/ Developer (3years) and in MIS (1year) roles.

Possess strong Domain expertise in Banking (Credit Cards, Payments), Retail / Energy, WCM (World Class Manufacturing), Wellness (HealthCare), Education and knowledge on Capital Markets, Insurance and DevOps.

Have Strong working experience in Client-Server Technology, Web applications and DW/BI.

Highly proficient in eliciting Requirement Gathering, As-is Study (Current State) and To-be Analysis (Future State), Gap Analysis, conducting interviews, work/ Business flows/process flow charts (UML), Developing Prototypes, Design Wireframes, Documentation, development and Testing of application for business and functional requirements.

Strong in Database - writing and executing complex queries using SQL SERVER (Stored Procedures, Joins etc.) & Data Integration using SSIS & Reporting using SSRS and MS Excel.

Strong knowledge of SDLC in Agile(Scrum) & Waterfall methodologies

Responsible for Product/ Sprint backlog management, daily stand-up meetings, Burndown Charts, reviews, and retrospectives.

Good working experience with Technical (Developers/ Testers/ QA) and Non-Technical teams - Business & IT Stakeholders (Internal and External) and Vendors to validate and clarify the requirements.

Served as liaison for business units and technology teams to ensure technical solutions meet user needs.

Developed and Maintained Decks & Reports for management review.

Worked in close partnership with development team to analyse product requirements to meet business goals and involved in translating Functional requirements and Business logic.

Have strong experience in data mapping, preparing data dictionary and Layouts.

Have expertise in preparing Flowcharts, effective User Stories/ Acceptance Criteria, Use Case, Class Diagrams, POC’s, Mock-ups, Walkthrough, Requirement Traceability Matrix and Data Modelling.

Created, Reviewed and executed Functional Tests – Smoke Testing, Integration Testing, System Testing, Regression Testing and User Acceptance Testing (UAT).

Well versed in analysing and working on Defect Management, detecting bugs and classifying them based on the severity and priority in JIRA Bug tracking system.

Well versed with Documenting and evaluating test results and defects, track and manage defects and work with Development team to troubleshoot issues.

Developed and Documented Test Scenarios/ Test cases, test steps/scripts, communicate the test results to the QA team.

Good experience in preparing Test Data, Data Mapping and EDI map testing for Transaction sets 810, 820, 867, 814, 248, 837, 835 and 834.

Possess exceptional analytical and communication skills and ability to work independently and a good team player.

ACADEMIC QUALIFICATIONS

MBA in Marketing from Andhra University

Bachelor of Sciences from Andhra University

ACHIEVEMENTS

Prestigious YSYE award Winner (from COO of HSBC).

Yellow Belt/ Lean Six sigma certified from HSBC- Supported a Black Belt Project – First Time Resolution.

Received AVP Special Recognition Award for stream lining the Commercial cards and Customer Telephony Services procedures.

Developed a macro using MS Excel for the Credit Cards Teams so that they can verify the unclear credit card number that reduced the error percentage and call back money from other banks.

Successfully handled Migration of MiVision on Lotus Notes(customer correspondence tool on Lotus Notes)

Received many Top Performer and Top Gun Awards.

PROFESSIONAL EXPERIENCE SYNOPSIS

Working with Benefitalign LLC from July 2017 to till date

Worked with Znalytics Business Solutions from Feb 2016 to Jun 2017

Worked with Covalence Technologies Pvt Ltd from Dec 2014 to Feb 2016

Worked with ESoft Consulting Ltd from Aug 2012 to Dec 2014

Worked with HSBC from Feb 2004 to July 2012

PROFESSIONAL EXPERIENCE:

Client: Benefitalign, Albuquerque, NM Jul 2017 to Till Date

Project Name: HealthplanEngage/ Shop Simply Ecommerce

Role: Business Analyst/ QA

Environment: C#, ASP.NET, Web API, AngularJS, SSRS, SQL Server 2014, Postman, EDI

Shop Simply: This Ecommerce application provides a platform for customer to purchase product from different merchants by comparing product prices and its ratings. “Shop Simply” helps merchants by directly crawling the product information from their website and placing order on merchant website.

Crawl product information directly from merchant website.

List all the products on Shop Simply- UI crawled from different merchant website.

Categorization of product crawled from merchant website.

Checkout functionality to place order directly on merchant website.

HealthplanEngage: This is a Healthcare Product. As healthcare costs continue to rise, employers are increasingly looking to new contribution options to help keep costs down and get their employees more involved in managing expenses. A Defined Contribution model provides employers a way to manage both their costs and offer their employees’ greater choice in their health care spending. This Ecommerce Product is a Framework that is developed and that suits for both B2B and B2C types of businesses.

Responsibilities

Responsible for requirement Analysis/Clarification from the Subject Matter Experts (SME’s) to produce artifacts and transform Functional/ Business Requirements.

Primary point of contact for the Product Owner (PO), development and testing teams.

Prepared User Stories, Use Case Diagrams and Class Diagrams and Defined acceptance criteria.

Analysed, defined, and documented system requirements for data, workflow, logical processes, and interfaces with other systems.

Prioritized and developed user scenarios for EDI transactions along with document preparations.

Responsible for EDI translation (x12 to JSON), EDI Map testing.

Interacted with technical teams to understand and document system workflows, data flows, rules, functional specifications and data integration specifications.

Responsible for Change Request Documentation and communicate changes to relevant stakeholders.

Designed process flows/ test scripts for the business process and business scenarios.

Executed SQL queries to validate the data by looking at the tables.

Supported applications and processes documentation.

Coordinated with Testing Validation team in developing testing scenarios and solving deviations and responsible for Defect Triage and Issue Resolution and End to End Testing.

Client: North American Power, Norwalk, CT Feb 2016 to Jun 2017

Project Name: AmpZ

Role: Sr Business Analyst/QA

Environment: C#, ASP.NET, Web API, AngularJS, SSIS, SSRS, SQL Server 2014, Postman, EDI

This Ecommerce project was initiated to overcome the drawbacks with the existing applications in the market, used by various Suppliers in Retail energy market. This developed application called “Ampz”, helps Retailers, Suppliers and end customers in Pre-Enrolments, Enrolments, Tracking the Historical Usage, Invoice Generation, Purchase and distribution of Meters, Payments, Required changes etc. This application is more user friendly over the existing applications in the market and hence increases the User Experience for Suppliers/ Customers, Management of the application for Admin and with loads of Reports for Analysis.

Responsibilities

Responsible for Requirement gathering and Analysis and understand the criticality of the business from Product Owner.

Managed communication with the Product Owners to customize, clarify requirements and communicate the same to development, testing teams without ambiguity.

Facilitated Daily stand ups, scrum meetings, Sprint planning and Sprint retrospective.

Worked with Product owner on Artifacts Such as Product Backlog, Spring Backlog and Sprint Burn down.

Responsible for managing Team of seven (Dev/Testers) and reporting to onsite Product Owner and ensured quality goals were achieved for application developed and enhancements.

Represented the team daily at the Scrum meeting to report impediments for escalation.

Publicized the team's progress and successes to make sure they are highly visible to product owner/ stakeholders.

Responsible for Functional Testing and UAT’s of the Developed Application/Reports.

Coordinated with Testing Validation team in developing testing scenarios and solving deviations.

Prioritized and developed user scenarios for EDI transactions, document preparations, transmitting formatted documents through EDI network.

Responsible for EDI translation (x12 to JSON), EDI Map testing and prepared Layouts from implementation guides.

Prepared the Data Dictionary and samples for Development and testing teams.

Created process maps and User Stories.

Coordinated with cross functional team to clarify queries, schedule walkthrough.

Designed process flows and documented the business process and various business scenarios.

Client: Unilever – Bangalore, India Aug 2015 to Jan 2016

Project Name: ESIM Market

Role: Business Analyst/QA

Environment: C#, ASP.NET, SSIS, SSRS, SQL Server 2012, SQL 2008R2

This Retail domain project was initiated to leverage skills and expertise of each part of ES Information Management to deliver one of the most complex information developments within Unilever. The Project reporting covered a blend of information for senior executive teams that includes Market Share, Media Spend, Finance data, and Innovation data. The project has also promoted the working relationships between the ES IM teams to deliver customer requirements.

Responsibilities

Interviewed SMEs and business users to consult on domain knowledge.

Worked with clients and consultants to understand and customise requirements.

Helped Developers / testers in transforming Business Requirements into Functional and Test Requirements respectively.

Developed User Stories, Acceptance Criteria, Process flow Diagrams, user stories for sprints.

Managed changes in scope with clients.

Closely monitored the defects/issues on regular basis. Executed SQL queries to verify and validate the data in the database.

Responsible for creating and tracking enhancement requests with the vendor.

Responsible for Documentation and communicate changes to relevant stakeholders.

Responsible for Functional Testing and UAT of the Developed Reports.

End user training.

Client: TWOA – New Zealand (www.tauora.co.nz), Wellington, NZ Feb 2015 to Jul 2015

Project Name: TAU ORA – WELLNESS

Role: Business Analyst/QA

Environment: DotNetNuke, C#, ASP.NET, Web API, SSRS, SQL Server, Active Directory

TauOra is a CMS that aims at "An opportunity to begin, continue or compete for the good of your well being". The site has been designed and developed in such a way that users are attracted to register themselves and start working towards their well being. The users take part in various competitions from time to time either individually or in a team. User or team competes with each other and with other teams, which encourages them to continuously work towards their well being. The company believes if the employees are healthy, the company would be healthy.

Responsibilities

Gathered Business Requirements, developed Use-Cases, prepared business models (BPM), and maintained training manuals.

Client interaction and understand their business requirements.

Developed documentation for functional requirements, business rules, and constraints.

Business Document analysis and SRS preparation.

Evaluated information gathered from multiple sources, reconcile conflicts and decompose high-level information into details.

Worked with UI developer to produce system prototypes based on requirements (BRD & SRS).

Managed QA Functional Testing efforts for application enhancements and software upgrades.

Developed reports using SSRS.

Assisted in Active Directory integration into Application.

Assisted in Deployment of application into Staging server and supported UAT.

Provided execution status updates during project meetings.

Client: Aditya Birla NUVO (Hi-tech Carbon) Aug 2013 to Dec 2014

Role: Business Analyst, Project Lead

Project Name: WCM (World Class Manufacturing)

Environment: C#, ASP.NET, Web API, SSIS, SSRS, SQL Server 2008R2, JavaScript

SKI Carbon – Ecommerce/ Retail project called “PMS Application” is a tool to measure, track and evaluate various Team’s performance through a structured automated system that provides higher visibility towards the Companies road map and to achieve Business Excellence. This application provides a Single platform to Plan, Assign, Execute, Schedule, Track, Review, Control and Manage – WCM/ISO related Processes and Audits. It also helps in preparation and conducting Survey, Quiz and Township, Purchase of raw materials, invoice generation, sale of by products, purchase of equipments and various goods.

Responsibilities

Requirement Gathering, Documentation, Functional analysis, design, coding and deployment.

Served as a liaison between developers, business end users and other departments

Involved in designing, development and Testing of the application.

Designed process flows and documented the business process and business scenarios.

Review test scenarios and test cases.

Developed Tabular, Matrix Reports, and Drill down Reports, Sub-Reports, and Parameterized Reports using SQL Server Reporting Services (SSRS).

Import and export of data from Excel, SQL Server 2008R2.

Involved in designing SQL Databases, tables, joins and developed stored procedures.

Responsible for functional testing of the application.

Client: State Govt. Police Force/ Loyola Educational Institutions Sep 2012 to July 2013

Project Name: E- Recruitment/ EMS

Role: Business Analyst, Project Lead, Testing

Both the Ecommerce Applications are customizable as per the Client requirements and suitable to any of the Govt Projects/ Educational Institutions. Sophisticated technical mechanisms like RFID, Biometric were integrated with the application to ensure control on the selection process in the entire process.

E-Recruitment: Application handles diverse functions from enrolment to electronic screening, filtering, sorting and ranking.

EMS: Internal Application that handles from enrolment, classes management, exams, results generation, reports, memorandum prints etc.

Responsibilities:

End to end project Management.

Communicating with Client for requirement gathering and discuss with team members (on-going process) that includes maintenance of the project with enhancements.

UA Testing of the application and check the workflow.

Helped the team members through knowledge sharing sessions.

Reported to the concerned project manager/director.

Client: HSBC UK/Middle East Nov 2010 to Aug 2012

Project Name: One HSBC Development and Testing (Application Support)

Role: Business Analyst, Software Engineer, Testing

A major project for HSBC. All the processes at HSBC, across the Globe would use one common application for Maintenance of all the accounts through a common platform – ONE HSBC. My duties included development and testing the application on Login, account maintenance services like request for closing the account, limit maintenance, balance transfers, name amendment, annual fee, payment transfers, credit transfer to bank a/c, address amendment, statement addressee, merchant category codes, re-issue and stop cards etc. This product is dynamic in nature and new functionalities are added in every release.

Responsibilities:

Worked as Business Process Analyst to improve the process.

Communicated and validated requirements, and defined and driven business requirements from initiation through implementation.

Facilitated communication and translation of regulatory and IT requirements between departments.

Collaborated with Project Manager, Web Design Team, Back-End Developer, and Client to discuss requirements.

Conducted Gap Analysis and Feasibility Analysis to check the compatibility of the existing system infrastructure with new business requirements.

Developed and updated procedures, monitored all daily operations, and assisted Teams in Balance Transfers, Payments and Chargebacks (MIS).

Performed Root Cause Analysis on the defect & issues observed.

Testing process improvement applied for Integration & End to End testing.

Prepared test scripts for Balance Transfer and Business Cards Teams.

Involved in import and export of data from Excel, SQL Server 2008R2 and Text files using SSIS SQL Server Integration Services Packages.

Responsible for training the internal customers.

Client: HSBC UK Jun 2007 to Nov 2008

Project Name: ECHAMPS Development and Testing

Role: Development, Testing

ECHAMPS (Electronic Cardholder Accounts Management and Processing System) is a prestigious first in house product from HSBC for Cards. This is application is used for the data processing for HSBC-UK and Middle East customers who use Business Credit Cards. I have been a part of European Union cards processes, where in my duties includes testing the procedures to Login, account maintenance services like request for Balance Transfers (to other retailer cards and to other HSBC cards), Applying APRs, closing the cards, limit maintenance, merchant category codes, re-issue and stop cards etc.

Responsibilities

Involved in Designing User Interface and implementing Business rules.

Participate in internal (cross functional) and external client meetings.

Regular interaction with Client regarding CRF's.

Worked on Cognos BI to generate reports.

UAT's and Trouble Shooting.

Other KPI's at HSBC between Feb 2004 to Jul 2012

Ensured that there is minimum Gap between the expectations of the end users and the final Deliverables from the technical team.

Analysed performance metrics and evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs (MIS for the Business cards Section using MS Excel).

Worked on Internal Black Belt Project where I was awarded a Lean Certification.

Worked on Process Re-certification and Process Reengineering Projects for entire Commercial cards Department.

Part of Business Continuity Plan Team.

Prepared Data Flow diagrams and flowcharts.

Created dashboards and Decks for Senior Management.

Work with Cross-functional teams for implementation of projects.

Liaison with the Branches (UK/US/Middle East) and specialist team across various departments to ensure first time resolution for Account Maintenance (HNI).

Contact this candidate