Oracle Developer Information Technology

Shalini Vadlapatla

Phone: 631-***-**** Email: *******.**********@*****.***

PROFESSIONAL SUMMARY

Experienced Oracle developer and technical architect with 15 years of experience in delivering information technology projects from concept to launch. Extensive experience in the full life cycle of the software design process including requirements definition, prototyping, proof of concept, design, interface, implementation, testing and maintenance. Specialties include enterprise scale in building custom business applications platforms and portals using oracle databases and development tools in Linux, UNIX and Windows environments. Energetic self-starter with excellent analytical and organizational skills. Achieves goals, objectives and milestones in an accurate and consistent manner.

CORE COMPETENCIES

●Strong skills in Oracle server-side programming which includes SQL, SQL*Plus, PL/SQL, Object Oriented PL/SQL Programming, SQL*Loader, Stored Procedures and expert level knowledge in Oracle 10g Developer Suite.

●Expert in report development with tools like Oracle Report Builder, BI Publisher and Jasper Reports.

●Proficient in building HTML reports using XSL and XSL-FO schemas.

●Adequate knowledge of Oracle E-Business Suite R12 technical stack.

●Expertise in design and development of Reports, Interfaces, Conversions and Extensions (RICE) Objects.

●Hands on experience in Oracle warehouse builder to design and build the ETL process

●Good knowledge in creating Cubes with multiple fact measures and multiple dimension hierarchies in Oracle Analytic Workspace Manager

●Experienced in performance tuning using various types of Hints, Partitioning, Indexes, Explain Plan and TK Prof.

●Good at writing Ant, UNIX shell scripts to automate business processes.

●Experience in creating ER Diagrams, Data Modeling, Process Flow Diagrams and preparing Design Documents.

●Experience with SalesForce customization, Security Access, creating profiles, roles, users, page layouts, and email services.

●Strong Knowledge of SFDC standard Data structures and familiarity with designing custom objects and Force.com platform and Force.com Sites.

TECHNICAL SKILLS

●Languages: SQL, PL/SQL, XML, XSL, XSL-FO, HTML, Java, JavaScript, Unix Shell Scripting, Ant script

●RDBMS: Oracle (9i, 10g, 11g)

●GUI & Reporting Tools: Oracle Developer Suite 10g/6i, BI Publisher, Jasper Reports, SalesForce.com, Analytic Workspace Manager

●ETL Tools: Oracle Warehouse Builder

●Enterprise & webserver: Apache Tomcat 6.0/5.0/4.1

●Source Control: WINCVS, PVCS, SVN, TFS

●IDE tools: Toad, SQL Developer, PLSQL Developer, Eclipse

●Operating systems: Linux, Unix, Windows 10/2000/XP

EXPERIENCE

Infosys Consulting Inc.

Apple Inc Remote

Dec’ 20 - May’ 21

●Support applications in production. Note interruptions or bugs in operation and perform problem solving exercise to determine problem and ensure continued use of the application

●Attended KT sessions for Application support. Attended calls with the business and offshore team on daily basis for requirement clarifications

●Used UNIX shell scripts to automate and systemize the load process

●Prepared knowledge transfer documents to help navigate through the system.

Infosys Consulting Inc.

Carrier Corporation Hartford, CT

Technology Lead Sep’ 19 – Jul’ 20

●Worked mainly on production support issues for Employee Self Service (ESS) System

●Worked on providing access to users to ESS System which includes HR and Payroll systems

●Documented interfaces from Workday system to ESS System and ESS System to Workday.

●Provided KT to the Offshore team for incidents that are handled and resolved.

●Created documentation for Process Watcher, which lists the status of jobs that are scheduled to run or which have already run.

●Created a cron job which is scheduled to create reports and ftp to the MFT server.

●Documented various inbound and outbound feeds between ESS and other external or internal systems.

●Worked on encrypting and decrypting files while sending or receiving files from external systems.

●Worked extensively on troubleshooting data issues for pay adjustment reports

●Documented how the Transaction Processing System works for Executive Files, Incentive Files and Other Files including file validations that are being done.

●Followed the change management process for incident creation and for migrating changes to production.

Infosys Consulting Inc.

Fiserv Inc. Hartford, CT Technology Lead Dec’ 18 - July’ 19

●Served as technical contact between IT developers and business partners.

●Maintained close connection with project personnel to quickly identify and resolve problems.

●Identified, addressed and either resolved or escalated project issues.

●Followed Agile methodologies to efficiently manage project needs.

●Defined scope, managed resources and oversaw schedules in line with stakeholder and project owner specifications.

●Traveled to client sites and answered questions via phone and email so that issues were remedied quickly.

●Effectively handled the communications between in-house software team, clients, and stakeholders.

●Administered all process checks to ensure proper completion and accuracy.

●Prepared and presented technical proposals for clients through technical design specifications

●Responsible for database analysis and creating queries supporting processes.

●Modified existing PL SQL packages to modify the calculations for the Custodial Escrow module based on geographic location.

●Created a batch job using SQR to create a report of listings of accounts which have miscellaneous income as per IRS guidelines for deposits.

●Created Pre-Code analysis documents for various packages in the Loans Module.

Leviton Manufacturing Co., Melville, NY

Sr Oracle Developer/Software Engineer V May’ 06 – Sep’ 18

BEST SYSTEM:

●Requirement Gathering from the stakeholders, performing system analysis, coding and development for the sales application.

●Designed and architected a management reporting system for sales applications using Oracle Reports, BI Publisher and Actuate.

●Developed deployment screens for BEST standard reports using Java and JSP.

●Designed and developed the client interfaces, defined needed data validations and wrote client-side validation scripts using JavaScript.

●Developed html reports using xsl, sql and Java utilities

●Worked on various PL/SQL utility programs to develop sales API’s for data integration with legacy systems.

●Engineered the data model for the creation of enterprise data warehouse using 10g/11g Oracle Warehouse Builder ETL tool

●Involved in design discussions with the business on the interfaces for creating three dimensional cubes using Analytic Workspace Manager.

●Performance management and storage of extremely large datasets.

●Involved in mapping of dimensions, defining cubes and loading data from relational tables using 10g/11g Analytic Workspace Manager and expert in writing OLAP sql queries to extract data from OLAP cube.

●Hands-on experience in tuning SQL queries for performance.

●Created explain plan for sql statements.

Oracle E-Business Suite R12 Upgrade:

●Architected the pre-conversion process and performed the development work to migrate the Oracle E-Business Suite reports from 11.0.3 to R12.

●Delivered the solution by developing an Ant script to automate the code deployments from SVN (subversion) into production for the R12 upgrade project.

●Developed various complex reports, cross tab reports for Marketing and Sales using 10g Oracle Report builder and BI Publisher

●Developed XML Publisher reports with graphs for R12 quality module.

●Worked on various backend Packages, Procedures, functions and triggers using PL/SQL.

SalesForce.com:

●Designed a solution for the Leviton.com website to load the marketing and product catalog content using Oracle Content Manager.

●Hands on working experience in Role Hierarchy, Custom Profiles and public Groups creation and user management in salesforce.com

●Created Profiles, Roles based on Organization role hierarchy and implemented Record-Level and Field-Level security and configured their sharing settings.

●Developed field & page layout customization for the standard objects like Account, contact, Leads, Opportunities in Salesforce.com

●Created new custom objects, assigned fields, custom tabs, components, custom reports, report types in Salesforce.com

Jasper Reports:

●To reduce the Oracle licensing cost, migrating Oracle 10g reports to Jasper reports using Jasper soft studio.

●Hands on experience in configuring jasper server on Linux environment and extensively worked on publishing and scheduling Jasper reports in Jasper Server.

Global IT Inc. New York, NY

Oracle Developer/Reports Developer Oct 05–Mar 06

●Responsible for creating and developing highly complex applications using Oracle as back-end with expertise in design and development of Oracle PL/SQL Packages.

●Developed dynamic web-based reports, grids using Oracle/Html/DHTML/CSS/Java Script.

●Actively participated in Analysis & Design sessions of the Project, which is based on MVC (Model-View-Controller) Architecture.

●Developed XML parsers to read the application specific properties and database queries from XML documents.

●Developed various SQL, PL/SQL scripts and database triggers for verification and validation of the required business functionalities.

●Generated several reports for management to review for system functionality as against the old legacy system.

ITC LTD, INDIA Hyderabad, India

Oracle Developer Sep 04 -- Feb 05

●Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.

●Created PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application.

●Developed reports using Oracle Report builder based on the client requirement.

●Prepare technical documents for all the programs developed & generated.

●Responsible in coding, troubleshooting and debugging

EDUCATION

Master of Science in Information Systems Hyderabad, India

Princeton P.G. College

Bachelor’s in Computer Applications Hyderabad, India

Geetanjali Degree College

Contact this candidate