KARTHIKA GADDAM
Business Analsyt/BI Analyst
PROFILE SUMMARY
An accomplished Business Intelligence Analyst with 7 years’ experience with strong verbal, written, interpersonal skills. Highly proactive, result oriented professional that has successfully delivered clear measurable bottom line improvement results dealing with both internal and external stakeholders. Extremely competent in Analysis, Requirement Gathering, skilled in using UML tools, Reporting tools, SQL and proficient with the project management methodologies, systems requirements specifications, work scopes and business case justifications.
PROFESSIONAL EXPERTISE
- Excellent skills in translating complex business concepts/strategies into deliverable product requirements and software requirement specifications.
- Expertise in Data mining, Data Management and Statistical Analysis.
- Experienced in creating Business Requirement Document (BRD), other functional and non-functional documents.
- Worked extensively on UML diagrams (use case diagrams, process flow diagram, state diagrams, sequence diagrams, and activity diagrams using Visio.)
- Experience in gathering requirements, GAP analysis, SWOT analysis and participating in all phases of SDLC.Experience in conducting Joint application development (JAD) sessions for gathering requirements and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to customer
- Experience working with different software methodologies like Agile and Waterfall.
- Good at writing SQL queries. Expertise in using Excel and pivot tables.
- Created Traceability Metrics among requirements
- Good understanding of configuration and change management within the corporate environment.
- Experience in creating Dashboard, scorecard and metric reports using reporting tools.
- Experience with analyzing and transforming large amounts of data into high-level deliverables.
- Proficient and involved in manual testing and facilitatedUAT to get the sign-off for testing.
- Expertise in preparing test strategy, test cases, test summary reports and test scripts.
- Excellent analytical skills, result oriented, verbal, communication skills, collaborative team player/leader with proven ability to communicate with peers and building strong customer relations.
- Effective time management skills, prioritizing work and multi-tasking many assignments.
TECHNICAL EXPERTISE
Methodology / Techniques: Waterfall, Agile, JAD, RAD
Process / Model Tool: MS Visio, UML, Enterprise Architect, iRise
Project Management: MS Project, MS Office Suite (Excel, Word, PowerPoint, Access)
Databases: Oracle SQL, Microsoft SQL, MS Access
Defect Tracking Tools: Quality Center, Test Director
Change Management Tools: Share Point
QA Tools Win Runner, Quick test Pro, Mercury Load Runner
Reporting Tools : Tableau
PROFESSIONAL EXPERIENCE
Safe-Guard Products International, Atlanta, Georgia December 2014 – Present Business Analyst/Business Intelligence Analyst Company Description: Safe-Guard Products International, LLC is the leading provider of Finance and Insurance (F&I) products in the automotive aftermarket industry. The Company develops markets and administers the highest-quality Finance and Insurance programs. Safe-Guard is a proud partner to more than half the country’s top 500 dealers.
Responsibilities include:
- Gathering requirements from various departments like Operations, Marketing, Billing, Cancellations, Accounting for various clients like Toyota, Hyundai, Benz and Porsche document them in a BRD, write SQL queries and perform UAT before releasing to the clients.
- Conduct and review competitive, segmentation, financial analysis of key metrics to support corporate development and strategic planning to improve market share.
- Coordinate with offshore team in day to day activities and verify system changes.
- Support the development of tracking mechanisms to gauge the success of various consumer product, product trends and sales initiatives.
- anage ticketing system in Jira, Task tracker and Sales force.
- Generate adhoc reports as requested by senior management, internal and external clients and maintain good relationship to perform job effectively.
- Efficient with database like SSMS, PostgreSQL using PG Admin.
- Using SQL Server Reporting Services (SSRS) created stack and Metric reports.
- SSMS – created procedures and functions with help of development team.
- Using the Tableau desktop tool, creating the Data Dashboard to visualize the data and publishing it on the web.
- Using excel and pivot tables connected to the data cubes to create slice and dice the data model to meet the Enterprise Analytical needs.
- Prepare power point presentations, attend meetings, prepare management status reports and attend user group forums. Work independently with individuals belonging to all level of organization.
Zahdoo Technologies, Atlanta, Georgia Business Analyst January 2014 – November 2014
Project Description: CADIE’ is a mobile based Application and it currently work on Android devices. It captures and retrieves your stuff along with recommendations precisely when you need and where you need. Capture your world of information - notes, pictures, events, reminders and just about anything with Cadie. Get recommendations on your notes, events, reminders, To Dos and link them to your notes. Sync your information with Dropbox and make it available across devices. Share your notes, reminders etc. thru email or as PDF documents.
Responsibilities Included:
- Configure software to meet end user needs.
- Plan test schedules or strategies in accordance with project scope or delivery dates.
- Use agile Scrum methodology and participate in all phases of the iterative process.
- Design and execute test plans, scenarios and scripts.
- Deliver high quality high quality product and used positive, negative and regression testing techniques.
- Collaborate with developers and BA & QA leads to improve testability.
- Document software defects, using a bug tracking system, and report defects.
- Monitor bug resolution efforts and track successes.
- Define test parameters, design tests, interpret test results and analyze test trends.
- Define and implement testing and verification strategies.
- Execute test scripts in "Touch-Optimized" devices such as tablets and smart phones.
- Tested on iPhone, iPad, Android devices, Blackberry devices and web based applications.
- Develop test summary reports and provide inputs to project team.
- Research for solutions and provide good quality documentation.
Environment: Cadie Mobile App, Android, Campfire, Zoho Bug tracker
Harris Corporation, Melbourne, Florida Business Analyst February 2012 – July 2013
Project Description: The project involved configuration and customize Expo Supply Chain application for Harris Finance/Purchasing/Procurement department. This application provides better, faster, lower cost and flexible solutions for customers and business partners. It provides seamless communication that serves the entire value chain involving suppliers, supply chain and engineering. Harris is an international communications and information technology company serving government and commercial markets in more than 125 countries
Responsibilities Included:
- Preparing and analyzing ‘as is’ and ‘to be’ of the existing architecture using Gap Analysis
- Facilitating JAD sessions with IT designers, developers, users and other stakeholders and preparing post session reports
- Designing workflow scenarios and process flows and documenting business process and business scenarios at conceptual and procedural level in share point.
- Acting as primary liaison between IT and business personnel facilitating proper understanding of the business needs and criticality of business workflow.
- Developing functional design specifications that adhere to design standards to meet defined business requirements
- Performing end-to-end analysis and design of business systems including needs assessment, requirements gathering, prioritization, estimating and risk assessment
- Interacting with Subject Matter Experts and establishing a business analysis and design methodology around Agile.
- Facilitating change management across entire process from project conceptualization to testing through software development, implementation and support.
- Design various management reports.
- Developed test plans, designed, and developed test cases after thorough requirement analysis
- Worked on black box testing, system testing and regression testing.
- Developed and executed several SQL queries as a part of backend testing and involved in data validation and verifying data-integrity.
- Identify requirements and recommend solutions and work around.
- Identified several bugs, Logged and tracked the defects using Quality Center.
Environment: Expo Application, Microsoft Dynamics, MS-Project, MS-Visio, Quality Center, iRise, UML, SQL.
Norris Home Furnishing, Fort Myers, Florida Business Analyst April 2009 – January 2012
Project Description: The objective of this Eclicktic package is to provide an automated system of maintaining all the manually operated activities in the furniture stores and warehouse. Eclicktic is single-point management software covering all functions in the area of sales, inventory, vendors, finance and customers. This software also been customized to handle activities related to interior design.
Responsibilities Included:
- Co-ordinate, manage and maintain good relationship with Vendors.
- Upload new furnishing Items and disable discontinued items from the catalog.
- Prepare Microsoft word documents and assist with sending new Inventory arrival communication to interested parties.
- Provided ad-hoc reports/spreadsheets for Management.
- Collect catalog Information from different vendors.
- Worked on the Vendor setup and Catalog module setup.
- Mapping the vendors catalog with our companies catalog.
- Setup workflow notifications rules for Catalog Module.
- Using SQL Server to create monthly reports for home and business delivery.
- Updating and conveying weekly progress reports to management, facilitating conference calls and meetings.
- Understand and analyze customer needs and give feedback to management.
- Work with all team members to resolve issues.
- Ensuring that deliverables are met within a timely manner.
- Researching Freight Bill Invoices to identify discrepancies of Rates provided.
- Created queries to obtain relevant Inventory data.
- Responded to, researched, and resolved questions and problems presented by various stores’ personnel and customers.
- Designed and created PowerPoint Presentations for Sales Merchants to use during Meetings.
- Worked in collecting requirements for Catalog page enhancements.
- Expert in identifying alternatives and workarounds for each issue, risk or defects.
- Created test plan and test scripts for testing.
- Intermediate level of excel experience including Pivot table, VLookup, HLookup and filtering data.
- Import /export of data from various catalog files to excel.
Environment: Eclicktic Java Application,MS-Project, MS-Visio, Quality Center, iRise, UML, SQL.
Regions Financials/Union Planters Bank, Memphis, TN
QA Tester July 2008 - February 2009
Project Description: Regions Mortgage is one of the leading Mortgage Company in mid-south. Worked as a QA Consultant in testing an Online Mortgage Loan Application. This application allows creating loans from beginning and closing the loan by Funding. Using this application, Credit can be pulled from Credit Vendors directly which interacts with various interfaces. Can issue online appraisals and titles without interacting with outside vendors/clients. Involved with various access levels from an account executive to funding specialty groups.
Responsibilities Included :
- Analyzed Requirements document from Black Box testing perspective and reviewed the requirements document for testability.
- Used Test Director for maintaining requirements and maintained the Traceability matrix between the requirements and Test cases.
- Involved in setting up Test Environment and Test Automation tool.
- Involved in creating the Testing plan, Testing resources, Testing strategy, and testing of end-to-end scenarios.
- Planned Test strategy on how to automate the testing. Planning also involves selecting the Test cases for Regression Testing, Deciding the Test cases for Automation and selecting the Test cases for Sanity Testing.
- Created Test Strategy, Test plan, Test case, Test scripts and Test summary reports.
- Checked the Entry and Exist criteria in each phase of the testing. Phases include Pre-testing, Acceptance testing, Product testing.
- Created verification points in Test scripts and performed Data driven testing using flat files.
- Performed Low-level recording for tracking mouse movements and keyboard actions. Captured the hyperlinks at the object level and Initialized the size of the browser page to a fix size for each test.
- Interacted with developers to resolve the defects. Performed Regression testing to verify that bug fixes did not break some other parts of the system.
Environment: Mercury Interactive Tools (Test Director, Load Runner, Winrunner, Quick Test Pro (QTP)), Windows NT/2000, HTML, Web Applications, Java, J2EE, SQL, Web sphere, XML, MS-Word, MS-Excel.
Global Hospital, India
Health Care, Test Engineer February 2007 – May 2008
Project Description: The basic objective of this package is to provide an automated system of maintaining all the manually operated activities in the hospital. The HMS is single-point management software covering all functions in the area of Outpatient, In-patient, Central & the back office management
Responsibilities Included:
- Developing the test cases.
- Performed functional, GUI, regression testing.
- Preparation of the defect report.
- Performed the UAT at customer’s location.
Environment: Windows NT, Visual Basic 6.0, MS SQL Server 2000 and Crystal Reports
- Bachelor of Chemical Engineering from Osmania University, India.
- PG Diploma in Business Administration from Nalanda College of Advance studies.
- PG Diploma in Computer Science.