Resume

Sign in

Data Test

Location:
Princeton, NJ
Posted:
March 21, 2019

Contact this candidate

Resume:

Venkata Kantamaneni

*** ***** **

Plainsboro NJ - 08536 Cell: 201-***-****

ac8u0i@r.postjobfree.com

Summary

Looking for an opportunity as a Business Analyst

Experience Summary

Seasoned IT Professional having 18 years of experience with excellent leadership and technology expertise in the areas of System Analysis, Design, Development, Implementation, Testing and Delivery of data-intensive applications backed by functional expertise in the areas of Media, Logistics, Banking, Financial Services and Inventory Management.

Skills Summary

A result-oriented individual with 10 years of diversified experience in Business Analysis, Requirement Gathering, Scrum process and Delivery Management.

8 years’ experience working within a software development and testing environment

Created, reviewed and validated the supported business process models, Business Requirements, System Requirements, operational and technical integration requirements.

Experienced in working with Product Owners, Scrum Masters, Business Partners, Senior Executives, Project Managers, Development Team, Business Analysts, QA Team and End-Users.

Expertise in requirement elicitation, creating functional specifications and data flow diagrams.

Leading sessions with Business Partners and Senior Executives for gathering requirements and liaise with Development Team.

Deep knowledge of Ecommerce space including User Interface processes and tools

Ability to create and design of information architectures, wireframes, using user-centric design techniques

Experience in developing source to target item mapping documents to migrate data from transactional system to accounting and data warehouse

Collected, analyzed data and created meaningful reports to drive business decisions

Proficient in data modeling, developing strategies for Extraction, Transformation and Loading (ETL) mechanism for Data Warehouse implementation.

Expertise in translating user requirements into technical specifications and mapping the process design, work flows for SDLC with documenting and managing business requirements using waterfall and Agile methodology.

Comprehensive understanding of the Organizational Framework that help to map the AS-IS and TO-BE model using the GAP Analysis.

Excel in project leadership roles – managing/coordinating complex projects involving enhancements to existing product platforms

Strong listening and interpretative skills for facilitating understanding of issues and solution designs

Maturity and dispute resolution skills, able to address conflicting requirements required

Good knowledge of Waterfall, AGILE and SCRUM and QA Methodologies.

Worked closely with PMO, IT Service Management, IT Development, IT Infrastructure Development and IT Operations to manage and coordinate the cut-over of IT Infrastructure.

Tools & Technologies

CRM & ERP

JD Edwards Enterprise One, SAP

ETL

Informatica 9.1/8.6, DataStage 8, Sunopsis/Oracle Data Integrator 10.

BI

Cognos 8, Microstrategy10.0/9.5/9.4, Crystal Reports 11.

RDBMS

Oracle 10g/11g, MS SQL Server 2005, MS Access 2016

PM

MS Project 2016, Rally 2014, MS Office, MS Viso

Technologies

Java, .Net. B2B, EDI, Web Services, JD Edwards Enterprise One, SAP, XML, IIS, 5.0, SQL Server 2006, Oracle, DB2, Gemstone, Small Talk, Quick Test Professional 8.0, Selenium, Office 365, MS Share Point, ServiceNow, Jira, Azure DevOps and Windows XP/10, UNIX

Professional Background

Business Analyst 2017 - Present

WestWood One, New York

Project: Netric

Westwood One, is an American mass media company specializing in radio syndication and audio content. Westwood One distributes hundreds of programs to radio stations and partners across the United States. Westwood One produce content and services to thousands of radio stations and digital partners across the U.S., including music and entertainment; talk; and sports programming, including coverage of the NFL on Westwood One Sports.

Netric is an Ecommerce application which supports WestWood One Agencies and sales team to create advertisement orders, schedule programs, accounting transactions and performance reports.

Analyze client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.

Use systematic techniques for specifying requirements - like data analysis, use-case scenarios, process modeling, and data-flow diagramming

Define, plan, coordinate and obtain information requirements to support and launch new products and software releases

Created Business Requirements Documents, Functional Specification Documents, Data Mapping Documents, Data Flow Diagrams, Use Case Documents, Test Plans and Test Cases.

Designed wireframes for sales and billing pages

Created extensive SQL queries on staging, portfolio and model databases for analysis and validation of test data and responsible to complete system gap analysis and prepare various design artifacts like High Level Design Documents.

Worked with Product Owners, Scrum Masters, Business Partners, Senior Executives, Project Managers, Development Team, Business Analysts, QA Team and End-Users.

Created Data Model, Database Components such as Tables, Views, Relationships and Constraints for the Integration Layer.

Coordinate with multiple resources efficiently and effectively throughout the development lifecycle so as to ensure that the projects are completed on time, meet requirements, are implemented accurately and the full impact is understood by the business owner

Analyze existing system to meet minimum company standards and define functional and systems requirements.

Developed requirements for user types, roles and access level permissions

Develop Test Methodology, Test Plan, test Cases, Test Data, and generating Benchmark Reports.

Act as the point of contact between the business units and IT

Prepared application work flow diagrams and end user training manuals for each module

Business Analyst Nov 2014 – Dec 2016

NYK Line, Secaucus, NJ

Project: JD Edwards and Mercury Gate (TMS 2.0) integration

MercuryGate is a cloud based Transportation Management System which enables Yusen Logistics to perform following operational activities Freight forwarding, Transportation, Warehousing and Supply Chain Solutions. MercuryGate interface all operational data to warehouse and financial data to JDE financial data. This system rollout will bring greater efficiency to YLA customer service employees by helping them to make decisions more accurately and faster based on the existing information about the customer’s needs and the availability of transport / warehouse to meet these needs.

Responsible for setup functional requirements in JD Edwards Address Book for customers and suppliers

Responsible for setup functional requirements in JD Edwards Account receivable, Account payable, Accrual and deferrals

Set up formulas for determining GL accounting for certain P&L in JD Edwards

Responsible for managing the scrum process with the coordination of scrum team in Agile methodology

Aanalyzed requirements and developed source to target mapping to transfer accounting data from Mercury Gate to JD Edwards

Developed requirements to manage inventories in a supply chain

Developed reporting requirements to manage supply chain processes for shipping and warehousing

Analyze existing system to meet minimum company standards and define functional and systems requirements

Document and implement validation test plan, use cases and protocols

Ensure software programs meet business and technical requirements

Develop SQL/PLSQL Queries for data analysis and for verifying data integrity across the database

Create through system documentation helpful to technical, functional and user staff

Assisted JSOX team to conduct audit on accounting data

Created AR/AP test data for QA team and users to execute test cases

Develop Test Methodology, Test Plan, test Cases, Test Data, and generating Benchmark Reports

Other similar professional responsibilities as needed

Contribute to the data migration activities from legacy systems

Business Analyst Apr 2011 – Dec 2016

NYK Line, Secaucus, NJ

Project: OSCAR

OSCAR is a suite of integrated applications comprising an enterprise wide information system each supporting a coherent set of business processes. It consists of data management for vessel schedules, vendor costs, company assets, route specifications, customer relationships, including customized agreements, tracking, documentation, shipping and booking systems. The successful implementation of this initiative is critical to NYK‘s goal of providing premier end-to-end cargo delivery for its customers. This system rollout will bring greater efficiency to NYK’s customer service employees by helping them to make decisions more accurately and faster based on the existing information about the customer’s needs and the availability of transport to meet these needs. This system has been purchased by NYK from OOCL, an international container transport and logistics service provider based in Hong Kong.

Assess clients' needs, identify and document requirements to achieve business objectives

Partner with the business and IT groups to find solutions for projects and operational issues

Provide first-line problem resolution or escalation, as well as technical assistance

Analyze existing system to meet minimum company standards and define functional and systems requirements.

Worked with global business managers and implemented business process rules in OSCAR

Documented source to target mapping documents to transfer accounting data from OSCAR to SAP

Documented requirements to improve communication with customers and vendors in supply chain networks

Developed equipment availability charts for efficient utilization of resources

Documented data transformation rules to create AR, Revenue, AP and supplier records using ETL applications

Wrote complex SQL queries to test source tables (ODS) and targeted tables like CDW, Facts and dimension tables

Developing SQL/PLSQL Queries for data analysis and for verifying data integrity across the OSCAR System database. Analyze the production data and assist Global Business Teams in requirement gathering.

Create through system documentation helpful to technical, functional and user staff.

Performed Integration and Regression testing to check compatibility of new functionality with the existing functionalities

Developed SQL queries and Joins for validating data in Data Base and used Excel and XML files for Data Driven Automation testing.

Assisted JSOX team to conduct audit on accounting data

Support OSCAR Production systems in its maintenance activities.

Develop Test Methodology, Test Plan, test Cases, Test Data, and generating Benchmark Reports.

Planned and verified integrity between OSCAR and all other external systems

QA Lead /Analyst Jan 2010 – Mar 2011

Dow Jones, New York

Project: The Wall Street Journal Search application: Millions of WSJ users use this application to search for WSJ article content, WSJ Quotes, WSJ archived articles and WSJ articles aggregate search. This search application index all news articles, videos and photos which comes from following sources WSJ, Barron’s, DJ Newswire, Market watch, Associate press. All this content indexed in Autonomy search database engine. All WSJ applications use this search application to get accurate and more information as requested by user. This application is developed in using Autonomy search database engine, Autonomy Proxy services and web services to communicate with other applications.

Responsible for overall Quality for the product delivery (Level of confidence to respective client requirements, versions installation program, version documentation – installation manual, version release report and test report)

•Conducted requirements walkthrough with business teams. Also performed data analysis on Autonomy search engine to help business teams for capturing requirements.

•Involved in writing test plans (where ever applicable) and assisting / writing test data, test cases etc.

•Allocated tasks to on site and offshore teams. Assisting them to complete allocated tasks. Trained team members on application and requirements to execute test cases

•Coordinated with other functional groups beyond the immediate team members.

•Conducted triage meetings with business team and development team to resolve the issues and generated benchmark reports

•Interacted with business and technical teams to analyze the Enhancements and Bug Fixes

•Ensured all requirements are met, through population of a trace matrix

•Extensively tested Functional, Regression and END-to-END testing for the Application

•Verified indexed articles and XML files in autonomy database.

•Executed collection manager jobs by running UNIX shell script

•Wrote complex Autonomy queries to test indexed and articles and search results

•Planned and verified data integrity between WSJ publishing application and search application (Autonomy)

•Planned and implemented data migration from multiple legacy systems to Search application

•Performed cross browser/platform compatibility and also verified search application on mobile devices like iPad, iPhone and Blackberry.

Prepared business test scenarios for UAT and other administrative reports

Designed the test automation frame work and identified regression scenarios

Followed a hybrid framework to adopt key word driven, data-driven and script modularity methods

Automated the regression test cases using Quick Test Pro

Created repeatable user defined functions and stored them as function libraries (.vbs files)

Maintained and updated the scripts for every release either by updating the object property value for a specific object or by adding new objects to object repository

Customizing the QTP using VB scripts.

Developed Automated Scripts using Quick Test Pro for Functionality and System Testing.

Utility functions were written as part of external library

Prepared test data and test results (input / output files) for data driven method.

Prepared both action based and component based scripts using QTP. Component based scripts were stored in Quality Center

Required to use descriptive language at certain situations to complete the scripts

Parameterized the tests by entering different sets of data using QTP.

Extensively used Quality center to manage test suit (Test Plan, Test cases, scheduling, executing tests and defect management).

•Prepared Test Summary Reports and distributed to all the business stake holders.

•Prepared knowledge transition plan to offshore teams and implemented successfully.

QA Lead /Analyst May 2005 – Dec 2009

NYK Line, Secaucus NJ

Project: OSCAR

Responsible for overall Quality for the product delivery (Level of confidence to respective client requirements, versions installation program, version documentation – installation manual, version release report and test report)

Coordinated with software development team, release managers, system administrators and DBA’s team

Recording the minutes of software and PSO team meeting on Client requirements and delivery schedules.

Assisted the SCM team in construction of test-environments.

Coordinating with other functional groups beyond the immediate team members.

Responsibility of Defect Management Process, Benchmark reports and creating Test Environments

Involved in writing test plans (where ever applicable) and assisting / writing test data, test cases etc.

Identified risks and prepared mitigation plans

Ensures all requirements are met, through population of a trace matrix

Test team allocations and other administrative reports of them.

Coordinating with other functional groups beyond the immediate team members.

Responsibility of Defect Management Process, Benchmark reports and creating Test Environments using Test Director

Test team allocations and other administrative reports of them.

Prepared functional test specifications for components

Prepared Test data for Automation

Participated in both Manual and Automation testing for the entire application.

Extensively tested Functional, Regression and END-to-END testing for the Application

Interacted with the Clients to analyze the Enhancements and Bug Fixes

Tested Data base table’s data using SQL Analyzer for all the Queries that are associated to the test case scenarios.

Involved in extracting and loading of data from flat files using transformations in the mappings.

Extensively tested performance of the VB components using LoadRunner.

Prepared test scenarios for user acceptance test

Prepared Test Summary Report

Developer Mar 2004 – Feb 2005

I-Flex, Mumbai

Project: Citi Alerts

Developer Jul 2002 – Feb 2004

Agilisys, Mumbai

Project: Multiple Projects

Developer Apr 2000 – Jun 2002

Net Decisions, Mumbai

Project: McDonalds

Education

Certification

:

Certified Software Tester(CSTE)

Institute

:

QAI

Year of Passing

:

March 2004

Qualification

:

PGDCA (Post Graduate Diploma in Computer Applications)

Institute

:

IBM, Visakhapatnam, India

Year of Passing

:

June 1999

Qualification

:

Bachelor of Science

Institute

:

Andhra University, Visakhapatnam, India

Year of Passing

:

September 1996



Contact this candidate