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