Business Analyst Sql Server

HIRANMAYEE POLASANI

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

Phone: 408-***-****

SUMMARY:

A detail-oriented Data and Business Analyst with over 12 years of experience in data collection, analysis, and reporting. Expertise in Business Analysis, Project Management and Quality Testing.

4 years of experience in Healthcare and Federal domain.

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, implementation, unit testing, functional testing, systems integration and user acceptance testing.

Proficient in agile methodologies such as Scrum, Behavior-Driven Development (BDD) and SAFe.

Proficient in requirements gathering and change management with a proven track record of successfully leading and implementing developments and enhancements.

Adept at collaborating with cross-functional teams and stakeholders to deliver projects on time and within scope.

Acted as a bridge between business users and the technical team, ensuring continuous alignment and timely issue resolution, while also coordinating regular project status updates for business stakeholders.

Experienced in managing and querying relational database systems, such as Oracle, Microsoft SQL Server, and SAP HANA, with a strong background in practical implementation.

Expert in SQL programming, with capability to design, query, and optimize databases to enhance data storage efficiency and retrieval performance.

Experienced with Business Intelligence tools like SSRS, Tableau, Power BI.

Skilled in developing and managing data warehousing solution, including ETL processes, to efficiently extract, transform, and load data from multiple sources into Data Warehouses and Data Marts using SSIS and Informatica.

Proficient in quality testing, with experience in ensuring the accuracy and reliability of systems through comprehensive test planning and execution.

Hands-on experience with AWS Cloud technologies, leveraging cloud infrastructure

Excellent communication, analytical, and problem-solving abilities.

Quick to comprehend and master new concepts and standards, with a strong aptitude for adapting to evolving requirements.

EDUCATION:

Master of Science in Information Systems August 2009 - May 2011

George Mason University, Fairfax, VA

Bachelor of Technology in Information Technology July 2005 - May 2009

Jawaharlal Nehru Technological University, Hyderabad, India

SKILLS:

Languages

SQL, PL/SQL, Java, JavaScript, HTML, XML, UML

Databases

Oracle 12c/11g, Microsoft SQL Server, SAP HANA

ETL Tools

SSIS, Informatica

Reporting tools

SSRS, Tableau, Microsoft Power BI

Quality and Change Management

Confluence, JIRA, VersionOne, HP Quality Center, TestLink, TestRail

Version Control

GitHub, SVN, Maven

Operating Systems

HP-UX, Microsoft Windows, iOS

IDE Tools

SQL Developer, Microsoft SQL Server Management Studio (SSMS), Eclipse, IntelliJ, DBeaver

Automation

Selenium Web Driver, TestNG, Jenkins

Agile Methodologies

Scrum, Behavior-Driven Development (BDD), SAFe.

Other

Microsoft Visio, Postman, Web Services

WORK EXPERIENCE:

SERCO, Herndon, VA Aug 2019 – June 2023

Senior Business Data Analyst

Contributed to a federal healthcare project for the Centers for Medicare & Medicaid Services (CMS).

Led the implementation of one of the key projects, the Audit Automation Tool (AAT), for the client CMS and worked on multiple other projects.

Worked with business stakeholders to perform comprehensive requirements gathering and documentation for data-driven projects and ensure requirements were accurately translated into functional deliverables.

Conducted sprint planning, daily scrum and retrospective meetings, guiding the team in prioritizing sprint goals, task prioritization and progress updates.

Engaged in Program Increment (PI) planning meetings, contributing actively to the strategic planning and coordination of project milestones and objectives.

Developed and maintained detailed project plans, schedules, resource allocations, and risk management strategies.

Identified and mitigated risks, resolved issues proactively, and ensured project continuity through change management and contingency planning.

Acted as the primary point of contact for stakeholders, facilitating regular status meetings, reporting progress, and managing expectations throughout the project lifecycle.

Experienced in designing mockups through close collaboration with developers.

Created detailed data mapping documents to define data flows and transformations, ensuring accurate data integration and alignment between systems.

Developed complex SQL queries to extract, analyze, and validate large datasets from relational database, SQL Server to support business reporting and decision-making.

Experienced in using SQL Server Integration Services (SSIS) for ETL processes, including extracting, transforming, and loading data from spreadsheets, database tables, and other sources to deliver insights to managers and executives.

Created interactive dashboards and reports in Power BI to visualize data and support decision-making.

Developed and maintained interactive reports and dashboards using SQL Server Reporting Services (SSRS), delivering actionable insights and supporting data-driven decision-making across the organization.

Authored user stories, developed acceptance criteria and conducted project demos.

Supported functional and user acceptance testing (UAT) to ensure solutions met user requirements and expectations.

Environment: Microsoft SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft Power BI, JIRA, Confluence, TestRail

SAP SuccessFactors, Reston, VA June 2014 – April 2019

Business and Data Quality Specialist

Worked with the SuccessFactors Learning Management System (LMS) tool, contributing to its implementation and management.

Experienced in the Behavior Driven Development (BDD) process.

Engaged in requirements gathering and managed product backlogs in JIRA, including the creation and maintenance of epics, user stories, and acceptance criteria.

Actively participated in release planning, sprint, retrospective, demos, and other essential project meetings.

Adept at conducting thorough data validation and enhancing decision-making through data-driven analysis.

I participated in a migration project transitioning from Oracle to SAP HANA.

Experienced in developing stored procedures in Oracle, optimizing database operations and ensuring efficient data processing to meet business requirements.

Developed interactive dashboards using Tableau.

Created comprehensive mapping documents for the ETL process in Informatica.

Specialized in quality testing, including designing acceptance tests based on project requirements and executing test cases, with test documentation and management maintained in Test Link.

Dedicated to efficiently identifying and reporting defects, as well as conducting thorough gap analysis.

Created test data to facilitate UAT efforts and provided support for post-deployment testing activities, ensuring smooth transitions and validation of system functionality.

Participated in integration testing to ensure seamless interaction between different modules of the product.

Environment: Oracle, SAP HANA, SQL developer, DBeaver, Tableau, Informatica, GitHub, TestLink, JIRA, VersionOne

Trillion Technology Solutions, Reston VA December 2012 – May 2014

Software Quality Engineer

Performed requirements analysis and gained a thorough understanding of application functionality.

Participated in sprint planning and daily scrum meetings.

Developed and executed test plans, test scenarios, and test cases based on project requirements and specifications, with thorough documentation maintained in HP Quality Center.

Ensured traceability of test cases back to project requirements, guaranteeing alignment with project objectives and comprehensive coverage.

Facilitated review meetings with business analysts and the development team to evaluate test scenarios and test cases, ensuring complete test coverage.

Conducted functional, regression, and integration testing to validate software functionality and performance across various modules.

Conducted failure and root cause analysis and verified customer-reported defects to determine underlying issues.

Performed web services testing using Postman to validate API functionality and ensure its reliability.

Developed SQL queries to perform database testing using Microsoft SQL Server.

Identified, analyzed, and reported defects, prioritized them, and collaborated with the team to ensure their resolution and re-verification.

I am proficient in using JIRA for project tracking and defect reporting.

Environment: Microsoft SQL server, Web Services, Postman, HP Quality Center, JIRA

SWIFT, Manassas VA Aug 2011 – May 2012

Associate Quality Engineer

Participated in requirements discussions, code, test scenario and test case reviews with scrum team.

Developed automation scripts for functional test cases using automation tool Selenium.

Analyze and create test cases data for automation framework.

Involved in maintenance and execution of Automation scripts every release in an accurate and timely manner.

Maintained traceability between business requirements and test cases to ensure comprehensive test coverage, while managing test cases, executing test plans, and logging and tracking defects using HP Quality Center.

I participated in daily stand-up, sprint planning and retrospective meetings.

Environment: Java, Selenium, XML, IntelliJ IDE, TestNG, GitHub, SVN, Maven, Jenkins, Microsoft SQL server, HP Quality Center

Contact this candidate