Oracle PL/SQL Developer
A proud mother, who is persistent at hard work and systematic pursuit, aspiring for an enthralling career as a PLSQL Developer and have capability to give best out of time. Summary:
About 7+ years of experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of client/server and multi tired applications and Data warehouse environments using the Oracle Relational Database Management System (RDBMS), SQL, and PL/SQL.
Good experience of Performance Analysis and SQL query tuning using Query Optimizer, Indexes, Hints, Explain Plan.
Proficient in PL/SQL programming Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, Materialized Views, PL/SQL tables, Cursors, Nested tables, V arrays, Records, Types and Dynamic SQL for DML operations for better performance.
Proficient in Oracle 12c/11g/10g PL/SQL back-end applications development using Toad, SQL Plus, and PL/SQL Developer.
Excellence in advanced SQL concepts Merge, with clause, table partitioning, Analytical functions.
Experience with data flow diagrams, Entity relation modeling and design techniques, database normalization theory.
Extensively used the AutoSys scheduler tool to schedule the UNIX shell scripts that will run the Oracle jobs.
Experience in creating SQL loader scripts to load data from flat files into the database and also in creating External Tables to manage data which is stored at the OS level.
Good Knowledge about the ETL tool Informatica Power center for developing various mappings using different transformations.
Robust knowledge in STAR Schema, Snowflake Schema, Constellation Schema, FACT Tables and Dimension Tables.
Proficient in Slowly Changing Dimensional Modeling SCD1, SCD2.
Prepare FDSs (Functional Design Specification) and TDSs (Technical Design Specification) documents, detailing the functional and technical details for application development.
Well-versed with different stages of Software Development Life Cycle (SDLC) using Waterfall and Agile Methodology.
Highly motivated and energetic team player with learning new tools and business environments.
DATABASE Oracle 12c,11g/10g/9i.
PROGRAMMING LANGUAGES SQL, PL/SQL, UNIX Shell Script, ANSI C, C++, HTML. TOOLS & UTILITIES Toad, Oracle SQL Developer, PLSQL Developer, AutoSys, SQL Loader, SQL Plus
TICKETING TOOLS JIRA, ITSM
ETL Tools Informatica Power Center
REPORTING TOOLS Tableau
Academic Qualifications and Certifications:
QUALIFICATION YEAR UNIVERSITY
B Tech 2007-2011 JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY (JNTU) OCA 2013 Oracle Corporations
Client: NBC Universal, Englewood Cliffs, NJ Feb 2020 - Till Date Job Title: Oracle Developer
As part of the global Operations & Technology organization, the D&A is focused on data and analytics strategies for the future. It supports NBCU’s vast portfolio of brands - from broadcast, cable, news, and sports networks to film studios, world-renowned theme parks, and a diverse suite of digital properties.
Developed the Generic Framework by using PL/SQL Packages and Shell scripting to run various ETL process on daily basis.
Developed automated process to generate SQLLDR Control files to load data from flat files into Oracle tables as part of DB2 to Oracle migration project.
Developed the reconciliation process to check the differences between Teradata and Oracle Sql’s using SSIS packages.
Designed and developed the Dimensional Data model for reporting project.
Recognized for resolving many performance issues in the ETL process and tuning the Sql’s for better performance.
Involved in creating the Command line, Box and File watcher jobs using the scheduler tool AutoSys.
Involved in the design and development of the Purging data from Oracle tables on weekly basis.
Created various generic procedures for gathering statistics and Rebuild Index to improve the performance.
Participate in development sprints, demos, and retrospectives, as well as release and deployment
Responsible for preparing the migration and deployment scripts for SIT, UAT as well as Production environments.
Carry out comprehensive testing and test plan for changes in system.
Coordinated and helped other developers in the team to their development tasks. Environment: Oracle 12c, Teradata, DB2, AutoSys, Toad, Oracle SQL Developer, UNIX Shell Scripting, Putty, SVN, SSIS, SSRS, Power Center 10, Windows 7. Client: Nike, Beaverton, OR March 2019- Feb 2020
ETL- PLSQL Developer
NIKE, Inc. is the world’s leading designer, marketer and distributor of authentic athletic footwear, apparel, equipment and accessories for a wide variety of sports and fitness activities. International Reporting & Analytics (DWAR) involved in Creation of Datawarehouse from different sources which is used to build and deploy forecasts and report business key performance indicators (KPIs) for senior leadership and partner with the stakeholders to deliver relevant analysis and insights.
Developed PL/SQL Packages and Procedures accordance with Business Requirements and to extract the data from different sources and load it into datawarehouse.
Involved in redesign of the Application according to the new business requirements by creating the Partitioned tables and indexes for better performance of application.
Involved in tuning SQL queries by using EXPLAIN PLAN.
Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
Coordinate with the front-end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
Created various generic procedures using DBMS_STATS and Rebuild Index to generate the statistics of tables and improve the performance.
Involved in unit and integration testing of the jobs and prepared documentation.
Responsible for Analyzing and Implementing the Change Requests. Environment: Oracle 10g/11g, Oracle SQL Developer, SQL Navigator, SQL * Loader, SQL*PLUS, Solaris, AIX, UNIX Shell Scripting, Informatica Power Center, SSH Tectia, AutoSys 4.0 and AutoSys r11.3.
CLIENT: Cummins Finance, Indianapolis, IN Jan 2018 to March 2019 Oracle PL/SQL Developer
This project is developed to extract, transform, and load source raw information to Oracle server. Cummins is an American multinational corporation that designs, manufactures, and distributes engines, filtration, and power generation products. Cummins also services engines and related equipment, including fuel systems, controls, air handling, filtration, emission control, electrical power generation systems, and trucks.
Headquartered in Columbus, Indiana, United States, Cummins sells in approximately 190 countries and territories through a network of more than 600 company-owned and independent distributors and approximately 6,000 dealers.
Analyzed and over viewed the database design for better understanding the relations, associations and dependencies within the database.
Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
Created SQL*Loader scripts to load data into the temporary staging tables.
Used Dynamic SQL programming technique to build and process SQL statements
"on the fly" at run time.
Used TOAD, PL/SQL developer tools for faster application development.
Performed SQL tuning using Explain Plan, Tk-prof, Hints and indexes.
Wrote shell scripts to automate loading files into database using crontab, error handling and notification.
Developed reports using complex queries as per client request as a part of production support.
Environment: Oracle 10g, PL/SQL Developer, SQL* Plus, SQL * Loader, TOAD, Oracle Reports, HTML, XML, UNIX Editors and Debuggers.
Client: CA Technologies, New York, NY Jan 2016 - Dec 2017 Oracle PL/SQL Developer
Computer Associates International, Inc., is an American multinational corporation. It is primarily known for its business-to-business (B2B) software with a product portfolio focused on Agile Software Development.
Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
Designed logical and physical data models for star and snowflake schemas.
Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
Created indexes on the tables for faster retrieval of the data to enhance database performance.
Developed forms and reports from scratch and enhanced existing front ends as per client requirements.
Environments: Oracle 11g, AutoSys, Toad, Oracle SQL Developer, UNIX Shell, Scripting, Putty, Informatica, Windows 7.
Client: Target Corporation, Minneapolis, MN Mar 2015 – Dec 2015 Oracle PL/SQL Developer
Target is an iconic brand, a Fortune 50 company and one of America’s leading retailers. Target as a tech company? Absolutely. Were the behind-the-scenes powerhouse that fuels Target passion and commitment to cutting-edge innovation. Building of comprehensive end to end Global Supply Planning applications leveraging distributed system designs and workflow technologies. Creation, own and are responsible for the application architecture, development and automation that best serves the product in its functional and non-functional needs.
Assisted in building the ETL source to Target specification documents by understanding the business requirements, designed conceptual and logical data model.
Responsible for creating PDM (Physical Dimensional Modelling) and Development Document.
Developed mappings that perform Extraction, Transformation, and load of source data into Derived Masters schema using various PowerCenter transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer, and update strategy to meet business logic in the mappings.
Involved multi-dimensional data warehousing structure designing which helps to execute report timely manner.
Involved in Performance Tuning of existed SQL Queries. Environments: Oracle 11g, AutoSys, Toad, Oracle SQL Developer, UNIX Shell Scripting, Putty, Informatica, Windows 7.
Client: TECH MAHINDRA June 2011 – Jan 2014
End Client- Asian Development Bank
Oracle PL/SQL & ETL Developer
Asian Development Bank is a Social Development organization that is dedicated to reducing Poverty in Asia and Pacific through inclusive economic growth, environmentally sustainable growth, Regional integration.
Enterprise Data Repository (EDR) application is an authorized data repository in maintaining the HR data. Responsible for core HR project which is critical in loading data for Global HR reporting, and it is a primary resource for all other NON-Core HR verticals like Work Force Management, learning and Leadership Reporting etc... It processes the employee information of ADB employees/contractors and will have core details like employment status, employee salary, designation, effective date, payroll type, absence. This information flows through across the various verticals to complete the various daily activities. Responsibilities:
Involved in designing, development and maintaining the PL/SQL Packages, Procedures, Functions to extract the data from different sources as per the business requirements and load them to the target tables for further processing.
Loading data from various flat files into database tables using SQL* Loader.
Developed the Extract, Transform and Load (ETL) process using PL/SQL Packages, Procedures and implemented complex logics for merging the data from number of sources to process millions of records on daily basis.
ETL process was designed for best performance in such a way that even the Delta load also happens only by inserts and never uses deletes or updates for loading the entire operational flow data.
Responsible for Developing, Supporting and maintaining ETL loads which run every day in EDR.
Involved in the development of most complex workflow on different segments for the entire employee’s effective dates and converting them into flatten structure.
Created table partitions based on the reporting query requirements.
Involved in creating the Command line, Box and File watcher jobs using the scheduler tool AutoSys. Created High Level and low-level Design documents, Logical & physical data models using ER Studio.
Involved in development of downstream extracts and transferring them using FTP or NDM process.
Prepared Unit, Integration test case documents and involved in executing them.
Involved in resolving performance issues various reports of OBIEE.
Involved in support activities during the DR activity and also for any of the Database maintenance activity.
Able to co-ordinate well with team members in accomplishing the tasks. Environments: Oracle 11g, AutoSys, Toad, Oracle SQL Developer, UNIX Shell Scripting, Putty, Informatica, Windows 7.