SUMMARY

• Sudeep has 13+ years of total software experience in Information Technology Industry. As part of his assignments, he has been in working as a Sr. Technical Database Consultant and has worked in implementation, support and enhancements projects. He also has a hands - on experience using ETL development & has knowledge of data warehouse concepts.
• Expert in Developing, Customizing, Maintaining and Supporting Oracle Forms, Reports, Oracle PL/SQL, BI Publisher and Oracle DB 10g/11g/12c.
• Extensively experienced in development, testing, and data migration/validation, loading data from legacy system to target system.
• Proficient in developing Reports, Interfaces, Conversions & Extensions components.
• Good knowledge in designing Relational Data Structures, writing Stored Procedures, Packages and Functions using SQL and PL/SQL.
• Strong programming experience in creating Procedures, APIs, Packages, Functions, Triggers, Indexes, Views, Collections (nested tables and arrays), Record types, Sequences, Materialized views, Constraints and other database objects using SQL and PL/SQL.
• Created partitions and sub partitions in a table for performance reasons.
• Designed and developed Informatica mappings using diverse transformations like Unconnected/Connected Lookup, Expression, Filter, Router, Union, Joiner, Sorter, Aggregator, Stored Procedure, Normalizer, Transaction control, SQL & Source Qualifier transformations.
• Experience in scheduling jobs using Autosys.
• Experience in writing Unix Shell scripts to automate the processes.
• Worked with various data sources like relational tables & flat files (fixed/delimiter).
• Excellent learning skills and ability to adapt quickly to rapidly changing/new technologies.
• Ready to take the challenges with a positive attitude and dedication towards the task in hand.
• Strong analytical, problem solving, communication and presentation skills.
• Experience in various industry vertical like Technology, Banking, Travel & Hospitality and Retail.
• Experience in data warehouse/data mart development life cycle and employed ETL procedures to load data from different sources into data warehouse.

TECHNICAL SKILLS

Oracle ERP: Oracle Applications E-Business

Tools: Toad, Sql Developer, PL/SQL Developer, Oracle Forms, Oracle Workflow, BI Publisher Report, SVN, Win CVS, WinScp, Perforce, Autosys, Informatica

Prog Languages: Python

Databases: Oracle 10g/11g/12c

Integration Tool: Informatica 8.x, 9.x

OS: Windows, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential

Application Developer

Responsibilities:

• I am responsible understanding the current logic of Dual Post and Recon and propose changes as the feed would be generated from Oracle Cloud rather than from FGI (current EBS 11i system).
• Understanding how the various steps in the entire process work together.
• Understanding the MView refresh of the FDW data warehouse (legacy system) and how it would be impacted with the Cloud upgrade.
• POC activities on the outbound feeds that were generated from FDW and then send to ECC via FIG which uses Informatica.
• Developed data mapping spreadsheet/specification to present the transformation process that needs to be converted to Informatica Mappings.
• Worked on integrating the Cloud source systems data to Oracle and scheduling jobs using Autosys.

Confidential

Sr. Database Consultant

Responsibilities:

• Working closely with the architecture team to understand the data model and the associated attributes and dependencies in the legacy source system.
• Developed data mapping spreadsheet/specification to present the transformation process that needs to be converted to Informatica Mappings.
• Involved in the development/optimization of the Informatica mappings and the workflows.
• Analyzing and providing solutions for complex issues faced by the business users and provided various custom views to test the data while the development was in progress.
• Was responsible for supporting the EBS Finance modules.
• Handling and resolving the issues related to the day-to-day transactions in P2P cycle.
• Providing support during the Month End activities and ensuring smooth closing of the period.
• Taking care of functional and technical requirements by interacting closely with business users, analyzing change requests, doing impact analysis and incorporate the new enhancements in the current application.

Confidential

Oracle COE Team

Responsibilities:

• I was responsible for supporting the EBS Finance modules and the custom integrations with LRM.
• Responsible for doing setups in EBS for integrating 3 divisions from legacy LRM system with EBS.
• Expertise on designing and implementing Oracle Alerts and Lookups and profile options.
• Interfacing AP Invoices and GL Interfaces, and fixing interfaced invoice related bugs.
• Custom reports development, enhancement and fixing existing report issues.
• Resolving various integration interfacing issues.
• Developed new Concurrent Programs, Custom Forms and Flex Field Customizations.
• Providing support during the Month End activities and ensuring smooth closing of the period.
• Analyzing and providing solutions for complex issues faced by the business users.
• Taking care of functional and technical requirements by interacting closely with business users and incorporate the new enhancements in the current application.
• Interacting with Business Users, analyzing change requests, impact analysis, and implementation of the same.