Business Analyst Sql Server

Priya Mantry

Business Analyst

Email:**************@*****.***

Phone: +1-404-***-****

Technical Skills

Certifications

Certified ScrumMaster® by Scrum Alliance

SDLC Methodologies

Agile/Scrum, SAFe (Scaled Agile Framework), Waterfall, Kanban, Scrumban, Water Scrum Fall, eXtreme Programming (XP)

Programming Languages

MY SQL, HTML

Database & Data Analysis tools

SQL server, Oracle 8/9/10, MS Access, Informatica Power Center 9.6.1, Data Mining, MS SSRS (SQL Server Reporting Service), Tableau, Power BI, JIRA, Azure DevOps, Soap UI, Selenium, ETL Tools

Modeling Designing

MS Visio, Smart Draw,, Lucid Chart

Requirements, Test & Defect Management

JIRA, Azure, MS Visual Studio, Confluence, Cucumber, Load Runner, Rational Requisite Pro.

Productivity tools

MS Office, MS Project, MS SharePoint, MS Word, MS PowerPoint, MS Excel

Operating Systems

Windows XP, Windows 8, Windows 10, LINUX, UNIX, IOS

Professional Experience

Google Inc. (Consultant) Oct 2023 – Till date

Sr. Business System Analyst

Responsibilities:

Collaborated with project teams and business stakeholders to understand and document business processes and pain points.

Developed expertise in source system datasets and data lifecycle.

Defined, documented, and maintained business processes and requirements, ensuring alignment with organizational goals.

Managed and supported operations-related initiatives, identifying opportunities for process improvements and making recommendations.

Coordinated and supported project and monthly metrics, providing detailed reports and insights.

Led system testing for new functionalities and bug fixes, ensuring smooth rollouts and minimal disruption to users.

Provided prompt support to end-users and consulting ecosystem, resolving issues and addressing questions efficiently.Created conceptual prototypes and mock-ups.

Performed Quality Analyst functions, including defining test objectives, plans, and cases.

Coordinated and facilitated User Acceptance Testing (UAT) with business users.

Axis Bank-Hyderabad, India Apr 2022- May 2023

Business System Analyst

Responsibilities:

●Analyzed and documented business processes, identifying pain points and areas for improvement.

●Maintained Salesforce.com systems, providing administrative support and ensuring optimal performance.

●Implemented project coordination skills to manage stakeholder expectations and deliver results.

●Conducted thorough documentation, guidance, and instruction for users to enhance system utilization.

●Researched solutions to emerging issues, maintaining high customer service standards.

●Conducted source data profiling and compared data structure to dataset requirements.

●Managed metadata elicitation, recording, and documentation.

●Created and maintained process flows, context diagrams, and data flow diagrams.

●Developed user stories and technical specifications, ensuring clarity and ease of implementation.

●Assisted in maintaining product and sprint backlogs, organizing user stories into themes and documenting dependencies.

●Collaborated with internal and external stakeholders to test and implement solutions.

●Performed Quality Analyst functions, including test case execution and UAT coordination.

VITECH Systems, India Aug 2020 – Mar 2022

Senior Business System Analyst

Responsibilities:

Developed solution specifications and detailed requirements for the application.

Defined and documented business processes, continuously looking for ways to improve procedures.

Supported operations initiatives and provided metrics coordination for the Professional Services management team.

Prioritized and managed field requests, ensuring timely resolution and support.

Conducted system testing for new functionalities, collaborating with technical teams for effective implementations.

Provided end-user support and consulting, addressing issues promptly and effectively.

Supported Quality Analyst functions, including test case execution and UAT coordination.

Hindustan Times Media Ltd (Shine.com)-Hyderabad, India Dec 2018- Jul 2020

Business Analyst

Responsibilities:

Worked closely with project teams and stakeholders to understand and document business requirements.

Developed and maintained expertise in source system datasets and data lifecycle.

Managed business process documentation and requirements, ensuring clarity and accuracy.

Identified and recommended business process improvements, driving efficiency and effectiveness.

Coordinated project and monthly metrics, providing comprehensive support and insights.

Worked closely with the team to prioritize and manage field requests, delivering prompt and effective support.

Conducted system testing and provided end-user support, ensuring smooth operation and issue resolution.

Performed Quality Analyst functions, including defining test objectives and executing test cases.

Monster.Com, Hyderabad Sep 2014- Sep 2018

Business Analyst-Enterprise Solutions

Responsibilities:

Interviewed clients, SMEs & business users to understand their Business & Functional Requirements and gathered their future needs & transformed them to technical requirements and technical specifications

Collaborated with client partners to gather requirements. Designed and created user stories & acceptance criteria

Applied all the phases of SDLC during the project to develop and enhance the product under the B2C Application.

Converted the Business Requirement Documents (BRD) into Functional Requirement document (FRD)

Worked on all Scrum ceremonies like backlog refinement, release and sprint planning, standups and review

Played a major role along with Scrum Master in retrospective meeting to inspect and adapt the team’s process

Efficiently prioritized and maintained the detail functional requirements and design specifications for the website while translating the business requirement into the web development analysis

Performed GAP analysis between the “As-IS” model of the legacy system & the “To-Be” model to identify the gaps logged issues relating to the identified gaps & worked with SME to get clarifications

Performed benchmarking and market analysis based on the various features that are need to be refurbished

Extensively involved in data mapping, conceptual and logical data modeling and creating ER diagram

Used Structured Query Language to filter data within SQL database server

Assisted in selecting the type of extract, transform and load process and helped in implementing them

Assisted in creating User Interface document to express UI component design and its navigation.

Created process flow diagrams & use cases template using MS Visio

Wrote test plans, test strategies, test cases using MS Excel and reviewed it with the business requirements for manual testing, unit testing, systems testing, smoke & sanity testing, regression and User Acceptance testing

Prepared & maintained Requirements Traceability Matrix to keep track of all the requirements and test cases

Tracked and documented change requests and monitored the workload along with the schedule

Involved in unit, functional, regression and system Testing, Facilitated User Acceptance testing (UAT)

Citibank N.A, Hyderabad Feb 2008 - June 2013

Relationship Manager

Responsibilities as an Assistant Manager/ Suvidha Service Manager-Corporate:

Assisted in managing and growing a portfolio of corporate salary accounts, contributing to a 15% increase in account acquisition.

Supported senior relationship managers in client meetings, account reviews, and the implementation of banking solutions tailored to corporate clients' needs.

Handled client inquiries and resolved issues related to salary disbursement, account management, and banking products, maintaining high client satisfaction.

Participated in the development of marketing campaigns and promotional activities to attract new corporate clients and increase product awareness.

Analyzed client feedback and market data to recommend improvements to banking products and services, enhancing overall client experience.

Handling escalations received from the Corporate Channel- Management & Individual

Taking care of corporate desk in order so as to help the employees with SPOT services

Administrating the regulatory report aspects like FCTRS/FCGPR/ECB efficiently, timely follow up and

submissions of all to the RBI

Ensuring maximum client satisfaction by providing resolution to the queries/raised by the customer

responsible for cross selling of liabilities and the assets of the bank.

Education Qualification:

MBA-Marketing - 2005- 2007, Dhruva College of Management, India

B.Sc Computers - 2002-2005, Andhra University India

Business Systems Analyst with 11+ years of experience in analyzing and improving business processes. Extensive experience in Salesforce.com (3 years) with a proven track record of delivering high-quality solutions in dynamic and fast-paced environments. Adept at collaborating with cross-functional teams, documenting business requirements, and implementing process improvements. Strong project coordination skills with excellent communication and problem-solving abilities.

Contact this candidate