Summary

*+ years of IT professional experience with MBA in Information Technology from Coventry University, United Kingdom (2013-2014).

Expertise: Warehouse Management System.

Core competent in Functional/technical Design and Implementation, Testing, Root Cause Analysis and Solutions.

Focused on business solutions for Enterprise Systems on Oracle Suite Applications for Merchandising, Warehouse Management System, Analytical Reporting along with in-depth understanding on over-all Business Planning from Procurement to Pay.

Skills:

Warehousing Applications: Oracle Warehouse Management System

Operating System: Windows, Unix, Linux

SDLC Model: Waterfall, agile

Database: Oracle 11g, DB2, MS SQL Server 2005/2008,2012, AWS

Reporting Tools: HP Quality Center/ALM, Tableau, IBM Cognos Reports, ITSM, JIRA, Rally.

Languages: SQL, PL/SQL, HTML, XML, VB Script

Others: Putty, WINSCP, Toad, Microsoft Office, Visio, Photoshop, Tortoise SVN.

Professional Experience

Vega Prosys, India

Senior Business Analyst June 2014 – Mar 2018

Requirements gathering, fit-gap analysis, implementation, upgrade, test planning document and end user training documents in Oracle Modules.

Transforming business requirements into functional design documents, Technical design documents using Oracle Applications and manage various phases of the project, participate in peer design and code reviews.

Support development team as well as QA and testing teams as subject matter expert (SME) for Warehouse Management System.

Extensive knowledge in all phases of STLC and SDLC.

Understanding of ETL concepts like extraction, transformation and loading.

Created tests related artifacts and test ware including test strategy, test data and test case documents. Performed different kinds of testing like functional, regression and smoke tests. Well-versed with HP Quality Center tool for Testing Management.

Key player in debugging the issue, issue resolution and root cause analysis using Oracle database 11g, Oracle SQL, PL/SQL.

Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.

Hands on experience working with implementation of dashboards, data and graphical visualizations, analytics using Tableau and Excel.

Analyzing BI requirements, and translating them into charts, graphs and reports.

Gained good knowledge about data relations, business applications as a result of frequent client interactions.

Actively participated in developing visualization solutions, developing statistical analysis using Tableau.

Vega Prosys, India

Business Analyst May 2011 – Dec 2012

Handling functional and technical tasks in identifying, evaluating, and resolving day-to-day issues on milestone-based task using SQL and PL-SQL.

Consulting IT functional teams and business team to identify and document business needs and map product functionalities.

Developed Health Check scenarios for warehouse activities and built the queries using Oracle database 11g, Oracle SQL, PL/SQL.

Worked closely with business analysts and clients for customer specific customizations and requirements to develop technical specifications and integration test documents.

Building reports for business statistics and sales visualization using SQL skills

Solid Back End Testing experience by writing and executing SQL Queries.

Expert in review and analyze requirements, use cases, technical specifications and database designs.

Experienced in supporting multiple projects simultaneously while maintaining strong quality and ability to meet deadlines.

Education

MBA in Information Technology, Coventry University - 2014, United Kingdom.

Bachelor of Technology in Computer Science - 2011, Andhra University, India.

Strengths

Versatile, Innovative and Adaptive.

Good Analytical and Technical skills.

Excellent verbal and written communication.

Team Player and possess critical thinking skills.

Work Authorization

H4 EAD

Contact this candidate