Manager Data Analyst

Sai Kiran Konda

adhvm0@r.postjobfree.com 248-***-****)

SKILLS

SKILL

YEARS USED

LAST USED

SDLC knowledge & Sprint Planning

6

2020

Project Management & Quality Assurance (QA)

6

2020

Requirements Elicitation and Documentation

6

2020

Project Maintenance & Account Management

6

2020

Subject Matter Expert & Life Origination System (LOS)

4

2020

Supply chain and Logistics (FedEx Experience Included)

2

2019

Budget forecasting & Risk Management

5

2020

CRM and ERP

6

2019

Agile/Scrum Experience / Scrum Master

6

2020

Analytical Skills & Microsoft tools (Office 365)

6

2020

Business processing management tools and Product owner

6

2020

HIGHLIGHTS

I have more than 6 years of experience in Project Management & Business System Analyst.

I have strong experience in Project Maintenance, Account Management, Requirements Elicitation / Documentation, Customer Service, System Documentation and Agile/Scrum.

I have extensive experience in Systems Infrastructure, Software Development Life Cycle (SDLC), Waterfall, Agile/Scrum, User Cases, Storyboards, Scenarios, UML, Joint Application Development (JAD) and ERP.

Master in writing user stories. Elicit story requirements from business and technical stakeholders.

I have experience in Business Process Modeling, Business Process Improvement, MS-Project, MSOffice, MS Visio, MS (Excel, Word, PowerPoint), Eclipse and MS SharePoint 2010, SQL and PL SQL.

Assessed and Implemented new ERP system (PLEX manufacturing could) to upgrade all operational and accounting system.

I have experience in Elicitation, Evaluation, Analysis & Management of User and System Requirements, closely with the Inventory Analysts on Projects by Providing Direction and Assistance.

Supported Divisional Information Security Officers, and Operational Risk Managers with the implementation of the operational risk framework and ensures alignment with Data Protection

5 years of experience in JIRA & Top-Team (Confluence administration involving creation and management of custom, complex projects, workflows, security schemes, custom fields, dashboards and reports configurations)

EXPERIENCE SUMMARY

Project Management & Technical Business Data Analyst with six years of experience in elicitation, evaluation, analysis & management of User and System Requirements, Business Process Modeling, and Business Process Improvement. Acted as liaison between Technical and Non-technical users.

Extensive experience in the Software Development Life Cycle (SDLC): analysis, design, development, testing, and implementation of projects.

In-depth knowledge of Project Life Cycle, User Interface Designing, Testing, Quality Assurance, implementation, and support within Agile/Scrum, Waterfall & Kanban environments.

Managing co-ordination of the partners and working groups engaged in project work. Detailed project planning and control, including Developing and maintaining a detailed project plan.

Supporting in managing vendor relationships, the project team in the development of project plans, project schedule, and budget to meet deliverables.

Competent in transforming Business Requirements into Functional Requirements and designing business models using UML diagrams - Use Case diagrams, Activity diagrams, and Sequence diagrams.

Developed and implemented ERP customizations. Organize and prioritize ERP systems development work effectively to meet critical milestones and business objectives

Proficient in conducting Joint Application Development (JAD) Sessions with IT Groups and Project Team Members, conducting Gap Analysis and documentation of Use Cases, User Stories, and Logical relationships among the data, process, or events.

Strong subject matter knowledge in the Insurance and investment banking industry, including financial and trend analysis, training, and reporting and project management functions.

Improved all areas of Project’s KPI performance through consistent focus and follow up.

Traced requirements through the development process and verified adherence using the Requirements Traceability Matrix. Strong Documentation Skills- Process Flows, Use Cases, BRD, FRD, Technical Design Document, Project Plans.

Well versed with Object Oriented Analysis and Design using UML, Rational Unified Process (RUP), Rational Rose, and MS Visio.

Strong analytical and problem-solving skills, excellent planning and multi-tasking abilities, with proven experience in utilizing people and process knowledge to help enterprise make critical decisions.

Worked closely with the inventory analysts on projects by providing direction and assistance

Effective Communicator with good Interpersonal and Client Relational skills.

Strong organization skills with the ability to work on multiple projects/assignment simultaneously.

Strong interpersonal and communication skills with the ability to express technical and business concepts.

Proficient in preparing Test Plans, designing Test Scenarios and formulating Testing Strategies.

Planning and reviewing the Test cases for Functionality, Security, Performance, Ad-Hoc Database and User Acceptance testing.

CORE COMPETENCES

Scrum Master

JAD Sessions

Quality Assurance

ERP

Requirement Elicitation

Use Cases and User Stories

GAP Analysis

UAT & Test Planning

Business process management (BPM)

Project Management

Requirement Analysis

Data Flow & Process Mapping

Technical/Writing (Manuals/System Specs)

SharePoint Developer

Master Data Management (MDM)

Agile (Scrum) & Waterfall

Data Analyst

LOS

SQL Queries & Data Modeling

ServiceNow

Google Analytics

Data Mapping & Analysis

EDUCATION

Master’s Degree in PMBA (June 2020- April 2021) Campbellsville University

Master’s Degree in Information Technology (May2017) Lawrence Tech University Detroit, MI.

Bachelor's Degree in Computer and Science (May 2015) JNTUH Hyderabad, India.

PROFESSIONAL EXPERIENCE

Softura (Farmington, MI) January 2020- Present

IT Project Manager/Business lead analyst

Project: Access to SQL Data Migration & SCMP

Responsibilities:

Managed a project for the data migration and tracked the Data Migration project plan, cutover plan, and resource assignments. Manage end-to-end complex data migration, conversion, and data modeling.

Effectively communicated project scope, schedule, and budget with both customers and contractors. Provide timely status reporting (WSR) to the Clients.

Monitoring projects on an ongoing basis, evaluating progress and quality, managing issue resolution, and taking corrective action as necessary

Work with VP of Engineering to report day to day activities of 2 key business units to understand project status, critical path activities, open risks / issues, and mitigation / resolution plans.

Identifying the data migration impact of all proposed changes. Owning the quality of the migrated data and the validity of the migration processes and operation.

Managing a Team, data and reporting analysis.

Sprint planning for SCMP Project. Conducting daily standups.

Overseeing and ensuring delivery of all aspects of coding and testing.

Acting as a liaison between offshore team and onsite team.

Environment: SharePoint, .NET, Azure DevOps, SQL, MS Office, Agile/Scrum.

Client: Hilton (Memphis,TN) July 2019 – January 2020

Project Manager/SAP Business Analyst

Project: Project Information Management & Opportunity to Opening (O2O)

Responsibilities:

Translating business requirements into SAP functional requirements and created Functional Design Specifications

Wrote business cases, requirements, mock-ups, test plans, and documentation for new reports in SAP to cover gaps between initially delivered SAP functionality and business needs.

Creating news field in Project Information Management and O2O applications.

Generating Reports Weekly, Bi-Weekly and Monthly for PiM & O2O Applications.

Executing SQL queries in SQL servers to determine the data in internal database.

Defined key performance indicators (KPIs) required by all departments; procurement, retail, finance and distribution.

Interpreted business requirements in order to facilitate the design, implementation, maintenance, optimization, and roll-out of application features and functionality enabling the business operations.

Conducting JAD sessions to determine the progress and daily updates on projects.

Performed integration testing, regression testing and documented software defects.

Actively collaborate with strategic decision makers and end users to define and design reporting requirements and compose functional design documents.

Execute presentations to the users on BI features and actively participate in the meetings with the users to provide training plans.

Environment: SAP, SQL, MS Office, Visio, Data mapping, SharePoint, Jira, Agile/Scrum.

Client: FedEx WTC ( Memphis,TN) July2018 - May 2019

Project Lead Engineer

Project: Access Points Replacements project

Responsibilities:

Processing rates evaluation. Coordinated the implementation of special projects affecting US Export operations

Extensive worked in JAD sessions with End Users through one on one and group interviews to better understand the user requirements

Worked on scripting tools and ServiceNow functionality, create script to automate routine tasks being done in ServiceNow.

Contribute to projects to implement, test and design ERP applications and system upgrades and changes. Able to use multiple language to develop ERP application, SQL for data analyzing, C# for application function, HTML/XML for application view, RESTful API/ JavaScript for web service.

Established and implemented equipment inventory database and inspection program, creating a detailed record of mechanical and electrical systems on site, and normal operating parameters.

Responsible for Salesforce.com inquiries regarding issue resolution from all parts of the Sales and Product Marketing organization.

Maintained and utilized internal equipment inventory tracking systems.

Assess and identify system, planning, operational, training and reporting gaps associated with the successful deployment. Performing quality assurance. Define and implement solutions and enhancements. Responsible for evaluating reporting and monitoring business needs for U.S. operations and AGFS

Worked closely with the inventory analysts on projects by providing direction and assistance

Designed and revised configurations and customization of NetSuite as needed to meet evolving needs of the business including the creation of fields, workflow rules, custom reports, and dashboard.

Identifies the key information security risk scenarios and supports the identification of the critical controls required within the functions.

Reviewed and approved product purchases for payment ensuring correct general ledger coding. Oversaw monitoring and matching of inter-company billing invoices to corresponding work receivers identifying timing differences.

Develops and maintains the Company’s architecture blueprints for the assigned site segments, including software architecture documents, technical design documents. Consistently analyzes and documents the current architecture designs and develops the target architecture states.

Assisted with manual and periodic inventories including preparation, cutoffs, audit of counts and reconciliations.

Ensure that client satisfaction is met and exceeded through regular sampling of client feedback through direct contact i.e. regular client interaction.

Responsible for the management of multiple projects regarding international operations, regulatory and system form changes, service improvements, and new product and services offerings

Provided on-site engineering support for Walmart-FedEx (Collaboration) Gathering all functional requirements and Operations regarding Networking and IT requirements, load position utilization, contingency planning,

Prepared the Business Workflow using MS-Visio with input, output, pre and post conditions.

Worked with the clients on final signing process in the User Acceptance Testing (UAT) stages.

Environment: MS Office, ERP,NetSuite, SharePoint, Salesforce,ServiceNow Agile, Microsoft SQL Server, JIRA, PL/SQL, Quality Center, Win Runner, TFS, Visual Studio, Windows.

Client: Bank of America (Detroit, MI) May’17-June’18 Positions: Technical Business Analyst

Bank of America Corporation is a financial services company, the largest bank holding companyhttp://en.wikipedia.org/wiki/Bank_holding_company in the United States, by assets, and the second largest bank by market capitalization. Worked in payment domain extensively. We were responsible for launching new software for mortgage unit. I was also involved in designing various annuities from fixed income and Equity portfolio.

Responsibilities:

The Objective of this project is to cover the following Objectives: Mortgage Loans-Replace existing LOS System with MortgageBot (LOS tool). Enhance the POS Process to meet the new regulatory requirements.

Consumer Loans- Replace existing tools with ConsumerBot BA Responsibilities (LOS): Understanding of loan origination Lifecycle (end-end) from lead generation to POS to closing.

Perform GAP analysis on the current state business process and system documented process flows, Current state, Future state, AS-IS to To-Be process of LOS documented product backlogs, User stories under Agile/Scrum methodology participated in all sprint (Iterations), Scrum, Daily Stand-ups and review meeting to make sure assign task are completed on Time.

Analyze business requirements and segregated them into high level and lowlevel Use Cases, Activity and Sequence Diagrams using Rational Rose according to UML methodology.

Responsible for overseeing all incoming and outgoing annuity paperwork from Bank of America financial advisors across the Michigan. Servicing up to 15 different insurance carriers.

Responsible for managing the daily tasks of the Annuity Operations Cash Team.

Analyzed financial performance of equity fund holdings in USA, Asia and Eastern Europe.

Liaison between Client and Business Partner’s. Conducted JAD sessions and Brain Storming Sessions with Client.

Provide subject matter expertise related to payment systems infrastructure projects completed in partnership with key external vendors

Derived Functional Requirement Specifications (FRS) based on User Requirement Specification (URS). Understand and articulate business requirements from user interviews and then convert requirements into technical specifications.

Extensive use of SQL server for data querying purpose and analysis provider relation data

Responsible for SQL queries, PL/SQL scripts to validate the data and performance of the database.

Coordinated the new rules that have been implemented into the system that handles the web orders: (Cyber Source) in order to detect and eradicate fraudulent activity.

Documentation of Business Requirements and Coordinated of approvals support of development and Testing Teams. Used Agile systems and strategies to provide quick and feasible solutions, based on agile system, to the organization.

Interviewed multiple stakeholders and defined the compelling Use cases for Enterprise Client Onboarding.

Analyze vendor account to maintain clear balances (by clearing debit/credit, removing blocks, following up and solving issues, etc.)

Performed Smoke Testing to ensure that the compiled software components of the Applications adhere to Project Standards, Performance Criteria and Functional specifications to ensure feasibility of testing effort.

Facilitated User Acceptance Testing (UAT) with the stakeholders and the business users, and the errors discovered were fixed and then verified via regression testing.

Frequently updated the requirement and defect status as per the current status of the testing project in the Clear Quest.

Used Rational Clear Case as Version Control System for any changes to common documents related to project like Use Case documents and Activity/Sequence Diagrams.

Project management update and controlling to ensure on time delivery using MS project

Derived Functional Requirement Specifications (FRS) based on User Requirement Specification (URS). Understand and articulate business requirements from user interviews and then convert requirements into technical specifications

Environment: MS Visio,LOS, MS Project, MS Office, HP Quality Center, JIRA, Windows 7/10, MS- Access.

Client: Webbusinesslook (Houston, TX) Jan’16-Mar’17

Technical Business Analyst

Webbusinesslook provides customized financial analysis and risk management plans for individuals, families, and businesses for more than 28 years in the financial services industry such as, estate planning, retirement and education planning, special needs, insurance, annuities, and wealth management. Webbusinesslook offer a variety of investment choices including fee-based plans.

Responsibilities:

Reviewed online investing banking documents/case files.

Analyzed and collected business requirements, identified system interfaces and created the requirements specification document.

I support the valuation team of a leading Life & Annuity Reinsurer in the U.S market.

Primary Responsibilities Assisting the team in preparing various Experience Analysis reports such as Actual v/s Expected dashboard & Cash Cost of Funds report.

Performed multiple audits of Google Analytics accounts.

Redesigned website while reducing overall bounce rate by 10% with Google Analytics.

Worked as part of the W3C Systems Team to help develop and maintain Web applications (Front-end development for w3.org, server-side web development, usability design and testing) to facilitate the work of the W3C community.

Performed Requirement Analysis to Develop Use Cases, Activity Diagrams and Sequence Diagrams using MS Visio.

Prepared templates, charts, diagrams, workflows, and visual media for targeted audiences in support of business requirements gathering and other key business communications.

Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.

Create test case documents that detailed the preconditions of screen page, action performed, and the expected results.

Designed and developed test cases for putting the application on manual testing.

Responsible for the creation of custom objects, page layouts, record types, workflow rules, approval processes and customized fields.

Worked with the team to create a project road map/blueprint ensuring effective remediation of all applications

Environment: Windows, Google Analytics, SQL Server 2000, W3C, Agile/Scrum, UML, MS Visio, MS Project, MS Office, HP Quality Center.

NIMSME & IBM, Hyderabad June’14 – May’15 Technical Business Analyst

Projects:

“Necessary Requirements of Criminal Intelligence System.” (NIMSME)

“IBM CE project- Enterprise Application Development using Java/J2EE – Bookworm” (IBM)

Responsibilities:

Worked on Software development life cycle (SDLC) methodology, Framing out Business

Transaction rules and related Documentation, creating Test Plans based on Functionality and Business rules.

Conducted Surveys and Brainstorming sessions with SMEs for requirement gathering and prepared User Requirement Specifications Documents Created & managed project templates, Use Case templates, requirement types & traceability relationships in Requisite Pro.

Performed Gap Analysis of the As-Is and Should-Be process within the organization to analyze and fill the existing gaps in the business processes.

Documented Use Cases and Activity diagrams using MS Visio to understand the requirements and communicate them to the development team.

Examined, analyzed and modeled Test plans & Test procedures based on RUP methodology.

Conducted feasibility study and performed impact for proposed enhancements.

Verified the functional aspect as per the Business Process and validated the interfaces with the other systems and taken care of data conversion from legacy system.

Involved in walkthroughs and meetings with development team to discuss related issues.

Used Rational Rose to visually determine the proper structure, key elements and optimal design for the database and to aid in efficient creation of tables and storing procedures.

Wrote clear, concise system requirements specification (SRS) documents and user documentation in accordance to guidelines and standards of a level where developers can interpret, design and develop the application with minimum guidance.

Involved with auditors to build test scenarios & manage user acceptance test.

Performed User Acceptance Testing (UAT) to test the functionality of the application.

Coordinated with the development team in documenting End User Manual.

Environment: Windows, Eclipse, Java/J2EE, HTML, Struts, Agile/Scrum, UML, MS Visio, MS

Contact this candidate