Prathiksha Shetty Email & Phone Number

Greater New York City Area

Working with the IT software solution team to conduct research to provide application software support utilizing the application databases.Responsibilities include working across several database technologies and related tools including Oracle SQL Developer, SQL Server Database, Oracle Database Integrator (ODI) and Oracle Business Intelligence tools (OBIEE) to provide software solutions and improve the user experience of the users.Developed SQL functions, packages and PL/SQL scripts using database development tools in order to enhance the functionality of the Oracle EBS application Responsible for developing interactive dashboards and reports using Oracle based business Intelligence tools to support business needs for management and state reporting needs.Working with complex data structures that are minimally documented to develop reporting solutions.Designed and Developed integration solutions to load the data from multiple sources like Relational databases, flat files into oracle and SQL databases.

New Jersey

• Developed an understanding of business flows and underlying technical architecture of Oracle E-Business Finance Suite – R12.• Involved in PL/SQL code review and modification for the development of new requirements.• Developed various Reports, Interactive Dashboards with drill-down capabilities, charts and views using OBIEE (Oracle based Business Intelligence tool). • Assisted project manager in scheduling, coordinating status meetings and updating dashboards.

Bangalore , India

• Identified business rules of the client’s data and determined data requirements based on the client’s business objectives• Review requirements and business specifications by performing impact and feasibility analysis• Catalogued the technical specification document for design and implementation of the right solution and get stakeholder sign off• Administered project management office (PMO) activities such as work breakdown structure and effort estimation, maintained the query tracker, sprint and product backlog• Designed and developed stored procedures, Functions and Triggers in PL/SQL and mainframe platforms to implement business rules.• Led a team of 3 junior developers and responsible to delegate different development tasks assigned by the stakeholders• Validate development work by junior resources and perform unit, integration, user acceptance and end to end testing• Set up testing environments for the stakeholders to complete user acceptance testing and get sign off if test successfully completed

Master'S Degree, Information Technology

Related Course work : Business Intelligence using R programming tool Marketing Research(Exploratory Data Analysis, Data Analysis/Data.

Bachelor'S Degree, Information Technology