ASHWINI KADAYINTI

Professional Summary

More than 8+ years of Business Analysis experience with Bachelor’s Degree.

Good mix of onsite and remote work experience in diverse domains including Finance, Pharmaceutical and Healthcare.

Highly experienced in all forms of documentation – drafting Business Requirements Document (BRD), Functional Requirements Document (FRD), Meeting Minutes, Style Guide, Training Manual and other project related Communication Material.

Strong experience in Business Process Management tools such as ServiceNow

Experienced in gathering requirements, using business modeling tools like MS Visio and SnagIt software for creating Business Processes, Use case diagrams and Work flow diagrams.

Strong experience in SDLC (Software Development Life Cycle) in Agile & Waterfall Methodologies.

Strong experience in the following Microsoft tools: MS Project, Excel, Word, PowerPoint, Visio, and Access.

Strong with UAT (User Acceptance Testing) and Quality Assurance. Experienced in providing detailed test plans, test cases and scripts for testing projects.

Diversified Domain expertise implementing solutions to Data Warehousing Projects.

Practical understanding and experience with Data Mapping, Data Validation and Data Modeling (Dimensional & Relational) concepts such as Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Experienced in RDBMS design and data modeling.

Worked on Hadoop applications Hive and Impala for a unix to KUDU upgrade changes.

Effectively communicate with Business Users, Developers, Business Analysts, Project Managers and team members.

Hands on experience using basic SQL querries on applications such as Oracle SQL, MSSQL, Teradata etc.

Excellent problem solving skills and a motivated team player with excellent inter-personal skills.

Extensive experience in migrating Data Warehouse projects.

Excellent hands on experience in monitoring bug status using Jira and maintaining project documentation using Share Point.

Effective, independent team player and self-starter with high adaptability to new technologies and a penchant to learn new things.

Excellent written and verbal communication skills.

Professional Experience

Client:Zimmer Biomet, Warsaw, IN (Remote) 07/2018 – Present

Role: Senior Business Analyst

Responsibilities:

Brought onboard for data migration of GCMR PH 3 project, gathered initial requirements, prepared project Design Document and Technical Specifications documents

Conducted daily SCRUM/status meetings with offshore/onshore to help understand the requirements and track the development status on SharePoint tracker sheet.

Used both Waterfall and Agile methodologies during multiple project implementations.

Helped define project scope, perform SWOT analysis and objectives while designing the future state systems.

Created specs for Informatica Powercenter Designer to extract Medical sales data from various sources like power exchange tables, oracle tables,JDE,flat files,SQL Server etc and loading to SAP BW (Hana).

Prepared Business process models, which included modelling of all activities of the business form conceptual to procedural level.

Developed current and future Process flow, Sequence diagrams using MS Visio and Visual basic.

Coordinate with Dev teams & PM during all phases of project lifecycle and helped baseline project plan using MS Project. Identified project milestones and assigned budget accordingly.

Solid experience in Informatica Power Center (versions 10.1/9.6/8.6/ 7.1) including Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Admin console and Oracle

Wrote test cases, did test script signoff, finalized test plans and timelines with lead QA and conducted UAT and QA tests.

Used excel tracker to track requirements, defects, test cases and follow up on the defects during SDLC.

Worked with various teams like BSA, DBA, Business users and environment technical leads through different SDLC phases

Worked on enhancements like adding new columns, updating column data types and lengths at Database

Responsible for updating documents in Confluence including test cases, expected results, and reports.

Extensively worked on UNIX/Windowsscripting for creating and maintaining the parameter files, executing database procedures, calling Informatica workflows, and job scheduling.

Production Support, Manage production issues, which include the escalation process.

Provide detail data-analysis of issues and communicate to the different impacted Operations Groups including IT partners.

Individually managed Change Requests/Records in ServiceNow and responsible for CAB approvals.

Issue tracking, reporting, and monitoring.

Coordinate mass clean-up and workarounds.

Facilitated and participated in JAD sessions with business leads -Brand Marketing teams in US, Germany & Japan to do end to end Requirement Gathering. Determined operational objectives and evaluated output requirements and formats.

Drafted Business Requirements & Functional requirements document -BRD & FRD. Created process flow diagrams and Use Cases using Visio.

Actively participated in status update meetings with the Client for timely and effective communication of issues and developed appropriate remedial action plans.

Did Visual modeling and Business process modeling with Visio. Wrote Use cases and developed Use Case Models for the development of the website. Drafted style guide for the US customer facing new website.

Worked on the continuous improvement of UAT Process by reviewing and evaluating existing practices with standard testing guidelines. Managed the QC and defect tracking.

Coordinated with IT and Business Stakeholders and communicated changes in project during each phase of project lifecycle.

Client:Vantiv Inc, Cincinnati,oh 08/2016-05/2018

Role:ETL Business Analyst

Responsibilities:

Front end used for HR and Payroll processing with Oracle Peoplesoft and Analytical database was Oracle.

Research, Analyze, Plan, and Define project charter.

Worked with Informatica Big Data Management (BMD) team to help pull test tables out of Hadoop applications Hive and Impala

Worked on supporting a unix scripts to KUDU upgrade changes on Hadoop.

Define business, functional, and end-user requirement, IT requirements.

Determine and quantify risks and analyze constraints.

Lead, coordinate and define cross-functional team activities, milestones, and deliveries for the site development and implementation as an intranet centric-information website. Lead the project during its life cycle until completion.

Responsible for Project Tracking, Reporting, and Plan Execution, Conduct Kick-Off and Status in Jira, meetings with Agile method.

Use SQL querries to extract files from Hadoop cloud environments tools such as Impala and Hive

Management and in testing and implementation.

Lead large-scale project initiatives as part of a team that supports Oracle Finance business units.

Act as a liaison between Finance Business groups and IT owing lifecycle projects and other Global Finance Groups.

Monitored project progress by tracking activities and resolved issues effectively. Also published periodic Progress Reports to Senior Management and recommended suitable actions.

Oversaw project deployment with Users and created Training Manual and marketing activities for the site evolution.

Conducted system, integration, stress and performance, functional, and UAT testing. Wrote test scripts and planned test execution with QA lead

Created user Interface screens and Style Guide in SnagIt software and coordinated with external Graphics Vendor for HTML screens, overseeing the graphics treatment process and coordinating with Dev teams

Gather the Customer Invoice Line-Level Description Data, Analyze, Create and Implement the Oracle Invoicing matrix model currently used in the testing process.

Test Coordination for system enhancements in large project initiatives.

Client:TD Ameritrade Omaha, NE 08/2014-07/2016

Role;Business Analyst

Responsibilities:

Involved in gathering requirements from business users. Participated in the detailed requirement analysis for the design of data marts.

Actively interface with other teams to gather requirements, design, code, debug, document, implement and maintain various DB projects.

Worked according to the specifications and restrictions of the company by strictly maintaining data privacy.

Created mapping documents to outline data flow from sources to targets.

Coordinate with QA teams for test script signoff, finalized test plans and timelines with lead QA and conducted UAT and QA testing.

Prepared migration document to move the mappings from development to testing and then to production repositories

Coordinate with Dev teams & PM during all phases of project lifecycle and helped baseline Project Plan using MS Project.

Certifications

ITIL Foundation Certified

Six Sigma Yellow Belt Certified

Education

Bachelors in Computer Science in Information Technology- 2002-2006 ( JBIET)

Masters in Marriage and Family Therapy – 2011 to 2013 (ARGOSY UNIVERSITY)

Contact this candidate