Oraclel Developer
Resume:
Sowmya Garimella Email: *********@*****.*** Phone#: 732-***-****
PROFESSIONAL SUMMARY:
8+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
Experience with Data flow diagrams, Data dictionary and Database normalization theory techniques, Entity relation modeling and design techniques.
Experience in Client-Server application development using Oracle 12c/11g/10g, PL/SQL, SQL *PLUS, TOAD, SQL*LOADER.
Solid experience of creating PL/SQL Packages, Procedures, Functions, Triggers and Materialized Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions.
Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
Created Tables, Views, Sequences, Constraints, Indexes (B Tree, Bitmap and Function Based).
Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables and Exception Handling.
Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB, UTL_FILE.
Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
Worked extensively on Ref Cursor, External Tables, Collections (Nested Tables and Varray) in complex backend packages.
Experience in performance tuning and Query optimization using Explain Plan, TKPROF, HINTS and SQL Trace utilities.
Good knowledge of key Oracle performance related features, such as Query Optimizer, Execution Plans and Indexes, for faster execution.
Experienced in UNIX shell Scripting.
Experienced in scheduling,running and monitoring jobs using ETL tool IBM DataStage 8.5
Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
TECHNICAL SKILLS:
Databases : Oracle 12c/11g/10g/9i, SQL Server, MS access
Programming Languages : C, C++, HTML, C#, JavaScript, SQL, PL/SQL
Tools and Utilities : SQL*PLUS, SQL*LOADER, SQL Developer, Toad, SQL Navigator,
Datastage 8.5, PVCS, JAVA, JDBC, Hibernate, Oracle Forms 11g,
Oracle Reports 11g
Operating Systems : UNIX, Windows (98/2000/XP/VISTA), DOS
Data Modeling : ER Studio, Erwin and Visio 2007
EDUCATION BACKGROUND:
Bachelors in Computer Science and Engineering at Anna University, Chennai, India
Master’s in Computer Science at University of Alabama, AL, USA
PROFESSIONAL EXPERIENCE:
Client: SEI, Malvern, PA
Position: PL/SQL Developer Feb’17 – Till date
Description:
SEI (NASDAQ: SEIC) is a leading global provider of asset management, investment processing, and investment operations solutions for institutional and personal wealth management. The SEI Wealth Platform (the Platform) is an outsourcing solution for wealth managers encompassing wealth processing services and wealth management programs, combined with business process expertise. With the Platform, SEI provides wealth management organizations with the infrastructure, operations, and administrative support necessary to capitalize on their strategic objectives in a constantly shifting market.
Role: Worked as PL/SQL Developer for SEI Desktop Application in Fees/ Fees Returns.
Responsibilities:
Involved in the database design for better understanding the relations, associations and dependencies within the database.
Created DB objects using ER Studio as a Data Modeler/Architect for Fees Application.
Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
Created indexes on the tables for faster retrieval of the data to enhance database performance.
Developed and modified PL/SQL packages, procedures, functions as per customer requirement to make new enhancements or resolve problems.
Wrote PL/SQL Database triggers to implement the business rules in the application.
Used SQL loader to load the data from the files provided by the interfacing applications.
Used Exception Handling for validation of input and displaying the error messages in the application.
Wrote complex SQL queries to retrieve information from the databases depending on user requirement.
Loaded data into oracle database from flat files using SQL*Loader.
Used efficient Joins, Indexes and Correlated queries for Query optimization.
Effectively made use of Analytical functions while developing the code.
Extensively used advanced features of PL/SQL like Ref Cursors, Collections (Nested table and Varray) and Dynamic SQL.
Performed unit test on the developed code to ensure that its bug free.
Handled Production issues and manage the same in issue log.
Involved in writing Functional and Technical documents.
Environment: Oracle 11g, SQL Developer, ER/Studio Data Architect 11.0, SourceTree 2.1 (GIT)
Client: State of Arizona, Phoenix, AZ Jan’16 – Feb’17
Position: PL/SQL Developer
Description:
The Arizona Department of Environmental Quality (ADEQ) mission is to protect and enhance public health and the environment in Arizona. To achieve this, ADEQ administers the state’s environmental laws and delegated federal programs to prevent air, water and land pollution and ensure cleanup. ADEQ is composed of three environmental programs: Air Quality, Water Quality and Waste, with functional units responsible for technical, operational and policy support.
Role: Worked as PL/SQL Developer for AZURITE/myDEQ Applications in ADEQ.
Responsibilities:
Involved in documenting users requirements, technical specifications and Reporting manuals.
Involved in PL/SQL code review and modification for the development of new requirements.
Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions to perform data loading, error handling and logging.
Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
Created new Procedures, Functions, Triggers, Materialized Views, Packages, Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
Created external tables to handle huge volumes of data which is not used frequently.
Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
Worked on Oracle Forms/reports for AZURITE applications.
Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance
Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
Good understanding of database objects and ability to triage issues.
Environment: Oracle 12c, SQL Navigator, SQL loader, Oracle forms 11g, Oracle Reports 11g.
Client: Estée Lauder, Melville, NY June’15 – Dec’15
Position: PL/SQL Developer
Description:
The Estée Lauder Companies Inc. is an American manufacturer and marketer of high-end skincare, makeup, fragrance and hair care products. The North America Retail Operations System (NA ROS) will deliver high-touch retail experiences for our employees and consumers. The NA ROS mission is to stabilize, modernize, and advance the ELC retail technology environment. NA ROS will implement solutions that are viable and dependable, deploy systems that meet today’s consumer expectations, and enable brand flexibility and innovation in the retail system.
Role: Worked as PL/SQL Developer for NA ROS Applications in Portfolio Merchandise Management (PMM) Project.
Responsibilities:
Designed Technical design document based on the business requirements.
Worked on SQL*Loader to perform bulk data loads into database tables from external data files.
Designed and developed Oracle PL/SQL Procedures, Functions, Database Triggers and involved in creating and updating Packages to meet business requirements.
Wrote complex SQL queries to extract data from various source tables of data warehouse.
Extensively used Bulk Collections to insert and update huge amount of data into target databases.
Extensively used advanced features of PL/SQL like Ref Cursors, Collections (Nested table and Varray) and Dynamic SQL.
Used Oracle packages like DBMS_STATS to collect statistics of many different kinds as an aid to improve the performance.
Worked on Exception handling, to trouble-shoot PL/SQL code and to display the error messages in the application.
Used Explain Plan, SQL*TRACE, TKPROF for tuning the SQL statements by creating indexes.
Extensive usage of Oracle External Table Concept to extract Data from feed File sent to FTP feed file location.
Extensively involved in using HINTS to direct the optimizer to choose an optimum query execution plan.
Performed unit test on the developed code to ensure that its bug free.
Handled Production issues and manage the same in issue log.
Environment: Oracle 11g, SQL Navigator, FileZilla FTP tool, TOAD 10.6, SQL loader, UNIX
Client: Standard and Poor’s, NYC, NY Sep’14 - Apr’15
Position: PL/SQL Developer
Description:
Ratings Hub Dissemination is a technology simplification and advancement initiative to simplify the existing architecture of S&P’s complex credit rating services. The credit ratings are publically available at www.spratings.com and these ratings are derived based on ability and willingness of an issuer, such as a corporation or state or city government, to meet its financial obligations in full - and on time. The project started off with three tracks that focus on technology, data and rules simplification.
Role: Worked as PL/SQL Developer for MME report, MR Acknowledgement Article for SP.Com data services under Ratings Dissemination System Hub.
Responsibilities:
Interacted with Business Analysts and Users in requirement gathering, built complex queries using SQL and wrote stored procedures using PL/SQL.
Involved in the database design for better understanding the relations, associations and dependencies within the database.
Loaded data into oracle database from flat files using SQL*Loader.
Prepared program specification and development of PL/SQL packages, procedures and functions as required by the business users.
Created Materialized View for extracting the data from the remote databases.
Generated and maintained Keys, Constraints and Relationships between the tables for OLTP database.
Used Bulk Collection types such as bulk collect and for all to reduce context switching between SQL and PL/SQL engine and vice versa.
Used the Merge statement to select rows from one or more sources for update and insertion into one or more tables.
Created various Function Based Indexes to significantly improve performance.
Handled various Exceptions to trouble-shoot PL/SQL code.
Performed unit test on the developed code to ensure that its bug free.
Monitoring the schedules and timely escalations to the project management and client in case of any slippages.
Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
Played key role in prod support for on call issues for the developed participant reports.
Environment: Oracle 11g, PL/SQL, TOAD 10.6, UNIX, SQL loader, CVS.
Client: DTCC, Tampa, FL Jan’12 - Aug’14
Position: PL/SQL Developer
Description:
Depository Trust & Clearing Corporation (DTCC) is a US post-trade financial services company providing clearing and settlement services to the financial markets. DTCC, through its subsidiaries, provides clearing, settlement and information services for equities, corporate and municipal bonds, government and mortgage-backed securities, money market instruments and over-the-counter derivatives. In addition, DTCC is a leading processor of mutual funds and insurance transactions, linking funds and carriers with their distribution networks.
Role: Worked as PL/SQL Developer for Global Trade Repository (GTR) project for DTCC.
The DTCC Global Trade Repository (GTR) is the industry's provider of choice for global OTC derivatives reporting. GTR is the only non-commercial global provider of transaction reporting services and is uniquely positioned to help market participants address some of their most important operational and regulatory challenges in this ever-evolving environment.
Responsibilities:
Interacted with the end users for gathering of requirements and analyzed them.
Involved in the Analysis, Design, Coding and Testing of the application.
Created the Object Relational Database Tables with all the necessary Constraints.
Developed back end interfaces using PL/SQL Packages, Stored Procedures, Collections.
Used All Control Structures like IF, CASE, For, While Loops for standard PL/SQL programming.
Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
Created and managed primary data base objects such as Tables, Views, Sequences, and Synonyms.
Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.
Designed Database Triggers for audit and validation purpose.
Implemented multiple-table links requiring Complex Join statements, including outer-joins and self-joins.
Used the Data Stage Director for scheduling, validating, running and monitoring the jobs and to view log files for execution errors.
Processed data using both implicit cursors and explicit cursors and their attributes.
Loaded data from flat files to temporary tables in Oracle database using SQL*Loader, Collections for better performance.
Worked in Maintenance of the system and debugging of the code whenever necessary.
Used Explain plan, TKPROF to gather the statistics along with analyze command for performance tuning.
Tested, Installed, Documented and provided On Call Support for the Applications.
Environment: Oracle 11g, PL/SQL, TOAD, SQL loader, Oxygen XML Editor, DataStage 8.5
Client: UnitedHealth Care, Huntsville, AL Dec’10 - Nov’11
Position: Oracle PL/SQL Developer
Description:
UnitedHealth Care is a Health Care Insurance Company, which provides a competitive health insurance plans for individuals and families. This system maintains information about customer details, products supplied and warranty. Other important feature of this application is that it keeps track of the details of customer complaints and concerned action taken.
Responsibilities:
Discussed and analyzed business functionality with the client and the developers.
Involved in writing Functional and Technical documents.
Generated SQL scripts for creating Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
Created PL/SQL program units to implement DML, DDL statements using Dynamic SQL.
Wrote Database triggers for audit and to implement complex business logic.
Created Bitmap Indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
Wrote control files and loaded the data into the Oracle database with SQL*Loader.
Used PL/SQL Developer Tool to do the backend development.
Wrote complex Oracle SQL using joins, sub queries and correlated sub queries.
Implemented Materialized View for extracting the data from remote database.
Used PL/SQL Collections (Nested Tables and Varray) in complex backend packages.
Coded UNIX shell scripts to call SQL scripts and to manipulate the returned data.
Developed test plan documents for all back end database modules.
Extensively worked on Explain Plans and various hints for Performance tuning.
Environment: Oracle 10g, Windows XP, SQL, PL/SQL, SQL*Loader, PL/SQL Developer, UNIX, TOAD
Client: Bentley Systems Inc, Madison, AL Nov’09 – Aug’10
Position: Oracle Developer
Description:
Sales Information System is the strategic information system for the company’s sales data. It has been built to hold transactional data at invoice line item level. Various transactional systems, SAP and Main frames will act as source systems. These systems will send the data in the form of flat files. The data from the flat files will be extracted and transformed using PL/SQL procedures. The Oracle database will act as target database.
Responsibilities:
Interacted with the end users for gathering of requirements and analyzed them.
Developed ER Diagrams, Data flow diagrams based on the requirement.
Developed Model Diagrams and Input/Output structures for the data entry screens.
Used efficient Joins, Indexes and Correlated queries for Query optimization.
Developed Control files, SQL*Loader scripts, migration and backup of Oracle data.
Extensively used PL/SQL to implement cursors, triggers and packages and to develop stored procedures, functions.
Implemented Record Insert, Record update and also used Insert All to load the data into multiple tables.
Used Dynamic SQL to implement DDL statements in PL/SQL programs.
Used Collections like varrays, nested tables extensively.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Created SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
Created the Shell scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.
Involved in programming, debugging, unit test and system integration testing of modules.
Used SQL trace facility and TKPROF along with Explain Plan to accurately assess the efficiency of the SQL statements when the application runs.
Environment: PL/SQL, SQL, SQL*Plus, SQL Developer, SQL*Loader, Oracle 10g, Windows XP/2000.
Contact this candidate