Business Analyst
Resume:
Rafiq Keshwani
*****.***@*****.***
Business Analyst
PROFESSIONAL SUMMARY:
●Over 6 years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Translating Requirements into Specifications.
●Proficient in Technical and Business Writing, Business Process Flow, Business Process Modelling, Business Analysis.
●Strong experience in all phases of Software Development Lifecycle (SDLC) using Waterfall, RUP (Rational Unified Process).
●Experience in conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
●Outstanding knowledge & working experience of slice & dice Looker, Power BI & Cognos.
●Competent in Creating Unified Modelling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
●Proficient in using Agile Scrum methodologies and used Excel extensively to write user stories and reviewed defects.
●Full working knowledge of the RUP, UML models and associated methodologies including Six Sigma.
●Experience in preparing and documenting the User Acceptance test (UAT) plan and obtaining the necessary signoffs from the concerned business units.
●Extensive experience in developing Use Cases, creating Screen Mock-ups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
●Great ability to interact with diverse group of people and get group tasks accomplished efficiently.
●Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artefacts produced by the teams across the deliverables for a project
●Created projects in Confluence/Chalk with job boards in Jira in aligning working groups network operations, product engineering i.e. Rally, financial i.e. Oracle and service management i.e. Jira ServiceDesk, SalesForce systems
●Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
●Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
TECHNICAL SKILLS:
Automation Tools: MS Visio, Rational Rose, Rational Clear Case, SharePoint, Rational Requisite Pro, Confluence
Bug Tracking Tools: Mercury Test Director, Rational Clear Quest
Utility Tools: MS Office Suite, MS Project, Adobe Photoshop
Software Development Lifecycle: Waterfall, Agile methodologies and Rational Unified Process (RUP),
Reporting Tools: Crystal Reports, Looker
Project Management Methodologies:SDLC, Rational RUP, Agile
Data warehousing Tools: Business Objects, Crystal Reports
Testing Tools: Quick TestPro (QTP), Quality Center, Test Director, Win Runner
Technologies: Visual Studio 2008, Microsoft .Net 3.0, ASP.Net 3.0, VB.NET, C#, C++, JavaScript, HTML
Defect Management Tool: JIRA
Monitoring tools: Splunk, Sitescope
EDUCATION AND CREDENTIALS :
Masters of Science in Information Systems
January 2018- May 2020
Touro College,
Graduate School of Technology (Manhattan, New York)
Project Management & Data Science Certification
January 2016- September 2016
(University of California, Irvine Campus (Irvine, California)
Bachelors in Management Studies
June 2010-April 2013
Mumbai University (Mumbai, India)
●PROFESSIONAL EXPERIENCE
Bank of America Trenton NJ July 2020 – Till Date
Role: Business Analyst
Bank of America is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina. It is the second largest bank holding company in the United States by assets. The aim of the project was implementation and deployment of Hardware Security Modules across the Bank to increase the security around the public key infrastructure across the globe
Responsibilities:
●Gathered requirements and worked with application teams to design applications in a way best suited to utilize HSM functionality
●Created manuals and support documentation after the project implementation
●Created and updated Software Development Life Cycle (SDLC) documentation, such as a Business Process Description (BPD) and Functional Requirements Document (FRD) and Software Requirements Specifications (SRS)
●Interacted with users, developers, project manager and process analysts to understand the business process, identify enhancements and gather business requirements.
●Captured meeting minutes from requirement gathering sessions and additional tenant meetings and documented the high-level discussion points, decisions and action items.
●Participated in the peer review process of FRD documents and other work products prior to client submission.
●Reviewed test case documents for multiple processes by researching and analyzing the finalized FRD documents.
●Plans, staffs, and oversees work creating projects in Jira, delineating work items from larger epics and volumes of work.
●In Jira and Resource Guru perform the creation, development of work items and tasks, prioritization and times lines from customer business requirements, volumes of work, user stories and use cases required to develop or update module based systems of the enterprise.
●Actively involved in vendor selection from process for HSM acquisition.
●Experienced with reporting tools, software, and other applications, including SQL Database, Looker, Tableau and Salesforce dashboards (reports designing tool) and Data warehouse.
●Extensive practical knowledge in importing data for use in reporting software (Tableau & Looker) graphs, and flowcharts.
●Managed changes to base-lined requirements through effective application of change control processes, peer review processes as well as managing versions using SharePoint.
●Co-ordinate HSM tenant meetings, facilitate JAD sessions and workgroup sessions to gather and get final approval on onboarding to HSMaaS;
Tools/Software: MS Project, MS Access, MS Excel, MS Visio, MS SharePoint.
Progressive Group, NYC, NY June 2019 – June 2020
Sr. Business System Analyst
The project involved establishing a Finance Warehouse. It was designed to be the source of central Property Casualty Finance data. The main goal of the Finance Warehouse was to deliver an answer for Property Casualty Global FP A actual, expense analytics, reporting, and other FP A business processes on a single data source platform. Experienced in insurance models such as life and annuity and P C. Progressive Group is the world's largest insurance organization with more than 88 million customers around the globe. Progressive Group corporate headquarters are in New York City. The project followed Agile Scrum methodology.
●Performed on the ETL mappings, analysis and documentation of OLAP reports requirements.
●Formulated the ER diagrams of Property and Casualty data and data flow diagrams in order to interact with database developers.
●Implemented UML, Use Case diagrams by using MS Visio in order to conduct a more effective and healthy communication with stakeholders and clients.
●Conducted JAD sessions, group workshops, individual and small team meetings, and conference calls with Property Casualty FP A teams, stake holders and developers to gather functional and nonfunctional requirements of the system including requirements and processes for life and annuity products.
●Involved annuity performance data process.
●Involved in scrum sprint planning sessions, backlog grooming, sizing, spring retrospectives and reviews, daily stand ups, user stories and acceptance criteria.
●Created and prioritized the back log in rally, coordinated planning sessions and maintained user stories and acceptance criteria.
●Communicated with product owner for organization and prioritizing the back log in rally, lead spring planning sessions to control and update user stories.
●Provided training to users and involved in conducting UAT sessions to gain user confidence and approval.
●Examined key Performance Indicators KPI for Property and Casualty such as Loss Ratio, General Operating Expense Ratio.
●Analyzed as-is and to-be systems to perform GAP Analysis and make recommendation for system enhancement.
●Extensively worked BI /BOBJ for multidimensional expenses actual reports.
●Extensively worked Cognos BI for international data.
●Documented report layouts and report mapping documents for ad hoc reporting based on Property Casualty FP A team's needs.
●Assisted and directly involved with QA team in creation of Test Cases and tests implementations.
Information Mantra, Sunnyvale, CA Oct 2016 – May 2019
Data Analyst
●Conducted business process analysis and identified critical issues, gaps, and needs given by the clients.
●Developed Key Performance Indicators (KPI) and presented it to the management and led to the execution plan.
●Developed data reports by writing simple to complex SQL queries in SQL Server Management Studio and presented to business intelligence team.
●Led training sessions on the software developed and presented it to the management team for approval of deployment.
Netreca Inc., Orange, California June 2016 – Sept 2016
Data Analyst Intern (Course Curriculum)
●Interpret data from primary and secondary sources using statistical techniques and provide ongoing reports.
●Developed and Initiated more efficient data collection procedures.
●Worked with managing leadership team to prioritize business and information requirements.
●Used advanced Excel functions to generate spreadsheets and pivot tables.
●Assists managing team in identifying opportunities to streamline and improve process.
Aga Khan Development Network, Mumbai, India May 2012 – Nov 2015
Business Process Analyst/ Business Data Analyst
●Analyzed business process requirements, technical requirement specification and functional requirement specification documents.
●Designed and developed application wireframes and prototypes with the help of developers using MS Visio.
●Conducted JAD sessions with management, SME, vendors, users, and other stakeholders of the project to understand the business requirement document.
●Designed conceptual and logical data model of Data Warehouse and tables
●Worked closely with Business Intelligence team to create reports and dashboards for clients using Power BI and Tableau.
●Assisted QA team in writing test cases and reports and executed test scenarios of the software and reports bugs and errors to the development team.
●Created workflow scenarios, designed new process flow, and documented the business process and business scenarios and activities of the business from conceptual to procedural level.
●Created, documented, and maintained complex ETL jobs, SQL stored procedures and data flow process with database administrator team.
Contact this candidate