Data Analyst Business

Raja Komatireddy 248-***-****

********@*****.***

OBJECTIVE

Highly motivated and a compassionate individual seeking for a challenging position as a Software Business Analyst/ Data Analyst to grow as an individual and become an asset to the company.

PROFESSIONAL SUMMARY

Over 20 years of extensive IT experience in Business, Data Analysis and Software Quality Assurance Testing with Mobile, Connected Vehicles, Client Server, Web based and ERP (Financial & Supply Chain) applications using:

Big Query, Hadoop (HQL)

Java & VB (.Net)

SAP R/3(MM/SD/PP)

Oracle Financials 11i (AP, AR, GL, FA)

Peoplesoft & WINSOL

5 Years of Hands-on experience in Data Analytics using Google Cloud Platform components like Big Query, Cloud SQL & BIG Data ecosystem components like Hadoop, Hue, Oozie, Hive & Pyspark and Involved in developing dash boards using QlikView and Transformed the data from Hadoop source system to target using Informatica and data profiling and data analysis using Alteryx.

Worked closely with the Product Owners, Product Managers, Product Designers, and team to work on user stories.

Participated in various phases of Testing Life Cycle on GL, AP, AR, CM, INV, AM, MM and OM Modules of SAP, Oracle Applications, PeopleSoft, Winsol

Developed manual/automated unit tests to confirm functionality for both functional and non-functional requirements.

Experience in developing BRD (Business Review), TSD (Technical Specification), Test Strategy, Test Plan, Test Scenario’s, Test Case & Traceability matrix documents

Experienced in Manual Testing, Data warehouse Testing and Automated Testing Tools.

Performed different types of Tests like SmokeTest, White Box, Black box, Integration, Stress, System, Backend, Volume, Load, Performance, Functional, Regression & UAT

Extensive experience in SDLC & STLC involving in various stages from Requirements Analysis to Test Cycle Closure and deployment to production.

Extensive knowledge and experience in all stages of the Software Development Life Cycle (SDLC) beginning from requirement specification to deployment and support.

Wrote functional tests to confirm user story acceptance and to detect regression defects.

SKILLS

Strong analytical ability, effective problem solving and decision-making skills.

Has ability to learn new technologies and apply them.

Positive team attitude, able to take initiative & originate new ideas.

Good interpersonal and communication skills, both verbal and written.

Commitment towards work and willingness to take up additional responsibilities.

Share knowledge among the team members, helped and guided when needed.

EDUCATION

BS in Engineering

Masters in Information Systems

CERTIFICATES

Certified Scrum Master from Scrum Alliance

Google Cloud Big Data and Machine Learning Fundamentals

Google Cloud Fundamentals- Core Infrastructure

Modernizing Data Lakes and Data Warehouses with Google Cloud

Certified in Perfecto Overview, Manual & Mobile Automation

Certificate in Oracle 11i General Ledger

Certificate of Appreciation to the GOTD program for OPSS application in Ford Motor Company

Certificate of Appreciation to the launch of release 4 in Connected Vehicle, Ford Motor Company

TRAININGS

Learnt Machine Learning Language using R-Studio

Learnt BigQuery, Cloud SQL

Learnt Hadoop (Hue, Oozie, Hive, Pyspark)

Learnt QlikView, Alteryx, Python, Informatica, Tableau, Power BI

TECHNICAL SKILLS:

ERP:

Oracle Financials Release 11.0.3/11i (GL, AP, AR, CM, Inventory, OM, AM, AOL, SYS ADMIN), SAP 10.7 (MM, SD, PP), Winsol (4.0.3), People Soft 8.9/9.1 (AP, GL)

Big Data Ecosystem: Data Warehouse:

GCP (Big Query), Hadoop, Hive, Oozie, QlikView, Alteryx, Python, R, DB2, SQL Server, STAR, Micro Strategy, Informatica

Languages:

SQL, PL/SQL, C, Java (Servlets, JSP), VB (.Net), ASP, VB Script

GUI/tools:

Developer2000 (Oracle Forms 4.5, Oracle Reports 2.5,Oracle

Graphics 2.5), Discoverer 4i. Toad, Azure, Mobile (iOS, Android)

Oracle Tools:

SQL* Plus, SQL* Loader, Workflow Builder 2.62

RDBMS:

Oracle11g, 7.x/8.x, MS Access, MS SQL Server 7.0/2005/2008, DB2

Operating Systems:

UNIX (Sun Solaris), Linux, Windows 95/98, 2000, Windows NT, XP, MS-DOS, IBM Mainframe

Internet Tech:

HTML, XML. Microsoft Visio, Project

Testing Tools:

Load Runner(12.55/12.02/11.04),Test Director, Jira, HP QC (10, 11), SOAP UI

PROFESSIONAL TECHNICAL EXPERIENCE:

Ford Motor Company, Dearborn, MI, USA: Mar-2014 to Oct-2024

Data Analyst/ Business Analyst

Ford Motor Company is one of the major Big 3 Motor Companies and has plants worldwide. Maintains great quality from design and manufactures to sales and service.

Projects:

Build and enhancement of Connected Vehicle Echo System data products using GCP (Big Query) & (Hadoop (Big Data))

Integration testing of Echo system products including Load & Performance

Ford Pass (Android, iOS)

EV (Electric Vehicle)

WIG (Wi-fi Gate Way)

IoT Hub Migration

Integration Validation Testing-GOTD (OMCC, CVOS, OBM, ESB, SI, OMS/SOB, GForce, OGMF, SAP (CRM), GOE, GTS)

WAS 8.0 Migration

OPSS (Order Production Scheduling & Sequencing)

SVS System Algorithm Optimization

Responsibilities:

Involved in data migration from On-Prem systems to GCP (Google Cloud Platform)

SME for data products such as Strategy Part Number, Master Vin Summary & Vehicle Meta Info.

Developed and administered SCA-V data operations mobility portal

Involved in GitHub administrator activity/roles

Developed Business/technical review documents and UAT specification documents

Involved in new data product implementation, Migration and feature enhancement projects

Transformed the data from Hadoop source system to target using Informatica and productionized the product for the downstream systems consumption

Involved in data profiling and data analysis using Alteryx

Developed dashboard for the Distinct Vin Authorized Vin count by Month, Vehicle Volume analysis, VSDN Prod Growth Graph, TPS, Daily/Hourly Trend and Message type (Connection Status, Vehicle Health Data, Vehicle Position, Motive Mode begin/end, Remote start begin/end, Ignition on/off and periodic vehicle data) using QlikView

Created Test Scenario’s, Test Cases and Defect Summary Status

Performed test data setups in ‘QA’ & ‘UAT’ for NA, EU, AP regions.

Involved in end user and production support

Env: GCP (Big Query), Hadoop (HQL, Hive), Informatica, Alteryx, Tableau, QlikView

Load & Performance Test Lead:

Coordinating work and ensuring timely and high-quality delivery of the performance testing and engineering activities by the offshore team.

Conducting meeting with technical architects and project managers for understanding, discussing and reporting the issues and tracking the progress of the sprints/different stages of the project.

Developing Web protocol test scripts using HP Load Runner 12.55/12.02/11.04 and testing of web services through Postman

Executed Load, Stress tests to check applications for response time and bottlenecks.

Monitoring the System performance of the server using Performance Monitoring tools like Dynatrace/Pivotal Cloud App Manager.

For deep down analysis of the response time break down across different layers and to identify bottleneck areas, Super Simulator server logs are downloaded through the use of MS SQL queries and stored procedures. The response times across different components are analyzed, and root cause and pain areas are highlighted to the Dev team for further troubleshooting and resolution.

Analyzed test results sharing with project team (developers, architects and delivery leads).

Involving in the Performance Engineering Activities like results analysis, CPU - Memory - Thread Analysis, Root Cause Analysis.

Created Mobile (Android & iOS) scripts in Perfecto

Env: Load Runner, Dynatrace, Perfecto

Integration Test Lead:

Performed test data setups for end to end EV testing features for NA, EU, AP

Validate the completeness & accuracy of the scheduled, unscheduled orders, reason codes, and various counts from scheduling run that meets Op Plan required volumes

Performed Data setup for the PLC constraints and scheduled more dealer priority orders and provided transportation cost savings

Created Order sequencing by creating profile set, importing into Optessa, assigning rotation#, pre-assignment sets, sequencing rules then approve and commit runset.

Performed required volume calculation (RV) for different VL (Superduty,Expedition etc)

Performed end-to-end testing for the US, Canada, Mexico and Lincoln China markets

Verify in GF& GZ Flow that Moved an Unscheduled order to a Scheduled state and Scheduled Order state is progressed to another Scheduled State

Amending the order with a duplicate Item number- expected -the order should be updated with the Item number sent by OMS

Create Mapping between the market and the WERS market code (WSPAD) for different model year (2016) and vehicle lines (MKZ, MKX, MKC, Navigator).

Involved in build & deployment process to QA, Pre-Prod and Prod using Jenkins (CICD)

Env: Agile Methodology, Java, SQL Server, SOAP UI, TDK, FTCP, CAN Bus, Azure, Carrier Simulator, Postman, MultiComm, DET, CVFMA, CVFTA, NGSDN, TCU, GIVIS, TCU, CDR, SYNC, CONTI,FB2, FB4, HMI, Mobile (Android, iOS, Perfecto), Jenkins (2.164.3)

Erie Insurance, Erie, USA Oct’13 – Dec’13

Software Analyst

Erie Insurance offers a range of services to meet family insurance needs, including a variety of home and tenant (renters) insurance policies and boat Insurance Erie Family Life offers a complete line of products to meet individual and business life insurance needs.

Responsibilities:

1099 CCR (Credit Card Reversal) Payment Processing & Premium Receivables:

Created single, multiple vouchers, single line, multiple & mixed lines---single payment- post withholding activity—run the custom process and validate that payment would be created for voucher and review withholding, payment tables to determine if the correct paid amount captured.

Void-Re-Open/Re-Issue Voucher-Pay voucher, post payment, post withholding- run the custom process and validate that payment would be created for vouchers and review that withholding, payment tables to determine if the correct paid amount captured

Verify that count of policies, premium should match between 2 files at the Master Company, policy number and policy module levels and verify that current premium of PMS and Premium master files balance when ACCOUNT-ENTER-Month-ENTERED

Env: PeopleSoft (9.1) (General Ledger, Accounts Payable), IBM Mainframe (Z/OS 1.6), Oracle (11g), ACR, Java, SQL Developer (3.0.2), SQL

Rogers, Brampton, Canada Feb’13 – Sept’13

Software UAT Analyst

Canada's telecommunications leader, keep everyone informed, connected and entertained, with our exciting array of products and services.

Maestro Application:

Developed UAT Test plans on the basis of BRD and DSD and Involved in Test execution process for UAT & Regression of the Maestro Program Release 0713.

Developed SQL statements to validate the successful execution of a single/multiple iteration of the script on different databases such as CRMPET, ABP PET, OMS PET

Created Service Order tickets and created Miscellaneous Orders from CRM

Created Search Payments, Add Authorized Contact, Change Case Status, Search Contact and Service Order ticket, CC9 B2B Link, New Identifier, Change Case status and tested address sharing issue via Web services using SOAP UI

Env: CRM, OMS, EIF, WOM, OBI, V21, SOAP UI (4.5.1), XML, Java, Oracle (10), CQ (7.1.2.4), HP QC (ALM), TOAD, SQL, Agile Test.

Amerisource Bergen Corporation, Mississauga, Canada, Sept’ 11 – Jan’ 13

Software Analyst

ABCC is a leading pharmaceutical services provider focused on supply chain including drug distribution, technology solutions for pharmaceutical and health care community.

Project: Flyer & Promotions (Web Site & ERP based Applications):

Initiated Quality Assurance Standards, Processes and methodologies in the organization

Tested Web services against various modules of ABBC Website - Security Verification, Pre-book catalog calls, and Pre-book Order confirmations against specific PO.

Tested web reporting functionality for user defined and standard reports for web services calls.

Created Pre-book, Replenish and Forecast Orders for the Promo and Non-Promo items and validated the Pre-book, Replenish Orders pricing.

Setup Customers, Sponsors, Groups and tested Promotion Order release schedule option.

Created Forecast order for all Alternate Whses and not for exempted Whse of Alternate Whse and verified OEZ1 Cancels promo orders that have reached their cancellation date.

Verified email Confirmations for Pre-book and Replenish Orders as configured in SU13

Validated Terms by WHSE Split (Alt Whse), different zones for Promo and Non-Promo Items for Pre-book and Replenishment Orders

Tested Android and Mobile devices by creating Purchase and Sales Orders using Scanner.

Env: SAP Supply Chain (MM, SD), Winsol (WMS), Web Services, SQL Server, SQL, HP Quality Center (ALM), Web Logic, MDM, Java, ASP.Net, Agile

407 ETR Concession Company, Toronto, Canada Jun’ 11 – Sept’ 11

Software ERP Analyst

407 ETR is the world’s first all-electronic open access toll highway which extends 108 kilometres east-west, just north of Toronto. 407 ETR benefits all users with a barrier free system so anyone.

Responsibilities:

Involved in requirements gathering, analysis, documentation, maintain traceability, serve as a liaison between technical development teams and non-technical stakeholders and Participated in the quality assurance process by reviewing and validating functionality against requirements

Collaborate with quality assurance teams to design test cases, scenarios, and test plans based on documented requirements and Manage and document changes to project scope, requirements, and priorities, ensuring transparency and minimal project disruption.

Tested depreciation for certain assets that depreciate based on usage (VKT, Revenue)

Tested an asset through Asset Basic/Express Information with new Depreciation Method.

Tested Fully/partially retire an asset with no proceeds with new Depreciation Method.

Calculated depreciation value for an asset with multiple additions e.g. Jan, Mar, Apr and Prepared SQL Queries to identify assets within environment that meet each test case

Tested Asset addition through Accounts Payable (AP) and verified accounting entries generated in GL through AM and assets through AP through AM.

Env: PeopleSoft (8.9) (General Ledger, Asset Management, Accounts Payable), IBM Mainframe (Z/OS 1.6), DB2 (8.2), Test Link, Mantis, Toad (2.7)

BMO (Davis + Henderson), Toronto, Canada Feb’11–Mar’11

Software UAT Analyst

BMO Bank of Montreal and Davis Henderson, a leading solutions provider to the Canadian financial services industry.

Project: BMO Retail Client Implementations (Web Site Changes):

To provide a more seamless and efficient process to replace the current manual flow with fax and email

Created the Master UAT test plan for the Web site changes project

Prepared the detail test cases on the basis of Functional requirement document.

Provided QA estimates for the management and involved in peer review process.

Performed walk through meetings with business, developers, Project management team

Involved in test execution process, test results review and test status meetings

Conducted meetings to ensure the tasks are delivered on time and co-ordinated tests among team

Involved in maintaining test cases in QC and defect management process

Env: Java, SQL Server 2008, SQL, SQL Navigator, HP Quality Centre

AEGON, Canada Jan’ 09 – Dec’10

Software Analyst

AEGON Canada Inc. provider of life insurance, Property & Casualty, Health Insurance, RRSP, guaranteed investments, segregated funds, Mutual Funds and offers investment solutions through imaxxFunds™.

Responsibilities:

Worked on various projects such as HST, Fusion, IFRS, and TGIF. Financial System Upgrade

Performed Functional, UAT, System, Regression and Integration testing with JDE and Khalix

Conducted the Test Plan, Test Case, Test Results and Defect Triage review meetings.

Created the Testing Analysis Summary Report, Purchase Order, Voucher entry, review the exemption codes for ON, BC, NS, NB, NL

Verify the Tax rate allocation such as HST, GST, PST, QST applied to Purchase Orders and ensure that it does not affect the existing and closed PO.

Made sure that reports (RBC Wire summary & GIC Fund movement) will read this table and allocate the appropriate amounts and allocation of direct investments and fund on fund investments within mixed investment funds

Verify that Journal entries sent to JDE and UL statements and reports are generated.

Pre-Pared Requirement Traceability Matrix by working closely with Business Analysts.

Created and Modified UNIX Shell Script for the file Extraction and imported the file from Unitrax, Lifetrax server to JD Edwards financial system

Involved in daily exceptions item processing reports including incoming and outgoing returns,

Verified the Customer profiles and verified Items that have been deposited twice are charged back against depositor accounts and the required substitute checks, customer notices, applicable fees

Env: Oracle Apps 11i (GL, AP, AR, Procurement), Unitrax, Lifetrax, PATS, ReCon++, SQL Server 2008, HP QC (10.0), SQL, Java, Linux, Shell Script, DB2, AS400

Honda Finance, Canada Feb’08- Dec’08

Team Co-Ordinator

Honda Financial Services, goal is to help to lease or finance the Honda Vehicles

Project: My Acura, My Honda & Finance Website:

Developed (BRD, DSD, FRD) based on System Use Cases, Activity diagrams, User Interface Specifications),Functional, Integration, System, UAT and Regression test plans, test cases

Conducted meetings with team members to collect test dependencies & scripts.

Assigned the tasks to the team and scheduled the execution of the test scripts.

Organized the defect management & status meetings among different groups.

Performed the defect analysis and generated the reports for the management.

Used SQL Queries to verify the data from the database.

Env: VB (.Net), SQL Server 2005, IBM Main Frame, DB2, SQL, Quality Centre, Agile

Investors Group, Winnipeg, Canada Sept’ 07 – Dec’07

Software QA Lead

IG Wealth Management is a Canadian leader in providing personal financial products and services, and is dedicated to building lasting client relationships

Developed (BRD, DSD, FRD) based on System Use Cases, Activity diagrams, User Interface Specifications),Functional, Integration, UAT and Regression test plans, test cases

Created Traceability matrix for Disaster Recovery Testing and reported defects in HP QC

Created customer master, customer number range and assign to customer account groups

Create partner stock and verified material stock, customer material info record,

Created and verified Inquiry, Quotation, Sales Order, Credit and Debit Memo, Sales type document

Verified by creating shipping point, picking, packing, returns, free of charge &sub-sequent delivery.

Verified Consignment process(Consignment fill-up, consignment issue, return, consignment pickup)

Create bill of materials, correct invoice, defining item category, billing blocking reasons

Tested pricing by item category, involved in testing tax calculation procedures

Tested item categories, create accounting key, create quotations, post goods receipt

Create chart of account, GL account, and post to GL, opening and closing periods.

Create vendor master data, one time vendor, purchase invoice posting

Tested various reports such as GL account list and balances, AR customer balances, AR customer line items, AR customer payment history, AP vendor balances and line items.

Env: SAP (MM, SD, FI/CO), Oracle 10g, SQL, HP Quality Centre

Dell, Texas, USA Feb ’07 – June ‘07

Software ERP Analyst

Dell is a multinational technology company specializing in the development and sale of computers, laptops, servers etc.

Reviewed requirement documentation (BRD, DSD, FRD,

Developed System, UAT and Regression Test plans on the basis of BRD and DSD

Documented the test scripts and detailed defect reports in HP QC

Created, applied and reversal of Manual Receipts in AR

Created Transactions, Customers, Invoices, Customer Profiles, Misc.Cash Receipts

Created Account Code Combinations, Manual JE and post JE

Involved in testing the Secure Approval Transmission Application verifying IT Administrator, Payroll Administrator roles, approvals for reviewers and senders

Generated and verified Account analysis, Accounts Payable, Accounts Receivables, Journals general, Trial balance details, Journals voucher reports, General Ledger, Chart of accounts, Budget, Average Balance Audit, Summary detail budget reports.

Analyzed test results (Pass/Fail Criteria) and reported defects

Env: Oracle 11i (AP, AR, GL), Oracle 8i

Mercer HR Consulting, Toronto, Canada May’05-Nov’06

Software Analyst

Provides services on HR and related financial advice and services. Retirement, Health Care & Benefits, Investment Consulting, Property & Casualty, Payroll and Global Investments.

Project: Web Time Entry System

Developed (BRD, DSD, FRD) based on System Use Cases, Activity diagrams, User Interface Specifications),Functional, Integration, System, UAT and Regression test plans, test cases

Created Traceability matrix for Disaster Recovery Testing and reported defects in HP QC

Created/Define Responsibility, profile options, Users, Suppliers, Invoices, Payments, Payment Formats, Payment Terms and created Transactions, Customers, Invoices, Customer Profiles, Misc Cash Receipts and define Aging buckets, Auto Lock Box and executed Revenue Recognition

Verify that AR Aged Trial Balance Report (unapplied, on account) for all customers

Verified the various reports such as AR Salesperson, Outstanding Debtors Listing report

Worked on Report Writer and generated custom Reports (Employee, Payroll, Audit, Performance).

Loading of Bank statements into Oracle Financials and verifying Bank statement interface table and comparing transactions with production system and test system

Setup notifications of items & modified business rules using Workflow in WFbuilder.

Tested and verified the Sub Inventory, Inter Org transfers and Re-Order point planning

Tested the Order Entry, Schedule Order, Returns, Shipping Transactions (Pick release, Ship Confirm) and various reports (Shipper, Invoice and Bill of Loading Reports)

Env: Oracle 11i (AP, AR, GL, OM, Inventory, Procurement), Java, Oracle 8i, SQL* Loader, SOX, Workflow 2.62, SQL, HP QC (10)

Loyalty Group, Toronto, Canada Jan’05-Feb’05

Data warehouse QA Analyst

Project is about Air Miles Rewards Program, analyze each and independent Customer usage.

Responsibilities:

Created and Built Segments, Metrics and Lists (12 Char, UPC) in STAR application

Worked with various SSOLTC, Collector Attribute, Collector Behaviour, Tbase, Redeem, Segment Expirations, Mega Cube reports and analyzed results with Database and Prepared SQL queries to retrieve data from DB2 database and compared with STAR generated results.

Wrote complex SQL queries and performed testing for the Transaction data Validation reports on SQL Data warehouse and master data from source systems

Created test plans, test cases and methods for daily activities.

Performed end-to-end defects testing and submitted the bug report.

Analyzed test results (Pass/Fail Criteria) and reported defects in Test Director

Created business scenarios in Micro Strategy and ran them through Various Reports.

Env: SQL, ETL, DB2, SQL Server 7.0, STAR, Micro Strategy, Data Junction, Data Mining

ADP, Toronto, Canada Aug’04-Oct’04

Software ERP Analyst

Provides a range of Payroll services and Human Resources systems to organizations of any size.

Payroll System: (Migration from Oracle Financials 11.0.3 to 11i)

Generated reports for Credit Process for Autopay and Paytech clients

Scheduled batch jobs in AS400 and extracted the file and interfaced into Oracle Financial system

Created, applied and reversal of Manual Receipts in AR

Verified Credit Tier Management Report, Over Threshold Report, Data and Time Exception Report, Outstanding Employee Checks Report, Summary of Unpaid Tax Invoices by Control Report, Client Payroll Submission Pattern Report, Funding Exception Report and Billing and Receipts History Report under the 11.0.3/11i.

Performed transactions in AP and AR (Invoices/Payments,Transactions,Receipts and Customers)

Scheduled Autopay and Paytech Wraps and Generated WRAP Balance Reports

Created & Confirmed Payment Batches and Validated the AR Transactions, AP invoices

Created Credit Memos, Debit Memos, Invoices and Receipts and applying to Invoices

Env: Oracle Fin 11i/11.0.3 (AP, AR, GL), AS400, DB2, Test Director, JAVA (1.1), Web Logic, Oracle7.1

Codify Inc, CA, USA Jan’01-Jan’02

Software Engineer

Inventory Management:

Process of managing inventories from raw materials to finished products and maintain customers order info and generate invoices and send to shipping area

Developed and maintained web pages for planning and forecasting, purchasing & ordering, receiving, storing, inventory tracking, packing and shipping

Env: Java, JSP, SQL,Oracle

BIT Tech, CA, USA Mar’00-Dec’00

Software Engineer

Warehouse: Provide info of nearest repair center to the customer

Maintain customer info with purchase details such as warranty, extended warranty, expiration date

Send the alerts to the customer when the warranty gets expires and find the nearest contact info if customer needs items to be repaired

Env: Java, JSP, SQL, SQL Server 7.0/8.0

Contact this candidate