EXPERIENCE SUMMARY:

• 8 years of IT experience in Oracle PL/SQL Development, Analysis, Design, Modeling, Testing and Implementation of Data Warehouse Business Applications.
• Involved in all phases of teh SDLC (Software Development Life Cycle).
• Excellent skills in Designing and Development of Applications using Oracle PL/SQL.
• In depth Knowledge and experience of Data Warehouse/Data Mart design, Data Migration and Implementation concepts.
• Hands on experience on Data Warehousing Design Methodology, Data Warehouse Concepts, Database Design/Architecture including both OLAP & OLTP data and complete lifecycle of project from Design to Development and Implementation.
• Used OLTP extensively for Order processing, ticket tracking and personnel file systems.
• Experienced with OLTP on Optimized data validation of incoming data during transactions.
• Good noledge of UNIX shell scripting.
• Strong experience in coordinating and providing support to UAT/QA Team during testing phase of Project.
• Excellent SQL skills, experienced in writing complex queries.
• Good noledge of Data Modeling using ETL tools, Star Schema, Snowflake Schema, and Entity - Relationship Diagrams.
• Experience in Bulk Data loading using Oracle utilities like SQL Loader, External Tables.
• Experience in using Data sources/Targets such as Oracle, MS SQL ServerDB2, XML and Flat files.
• Expertise in Developing and Customizing Oracle Forms and Reports using Oracle Forms 11g/10g/9i/6i, Reports10g/9i/6i, Discoverer 9i/10g, XML Publisher and developing concurrent programs using SQL, PL/SQL.
• Strong experience on Advanced PL/SQL programming in implementing teh concepts and features using Bulk Collect, Bind Variables, Ref Cursors, Execute Immediate, Exception handling, Procedures, Functions, Packages, Triggers, Autonomous transactions, Global Temporary tables, external tables, Hierarchical Queries, Aggregate Functions, Analytical Functions, Batch Jobs.
• Proficient in Service-Oriented Architecture and its related technologies like BPEL, Web Services, WSDL, SOAP, XML, XSD, XSLT and Web Service Security including outing, transforming and validating of applications using Web services.
• Extensive experience in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, Materialized View, DBMS packages and exception handling, Global Temporary tables and Troubleshooting Oracle database issues.
• Good Knowledge on Confidential -Server application development using Oracle … PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• In depth noledge of RDBMS concepts, with hands on exposure in teh Development of Relational database environment using SQL and PL/SQL using database tools like PL/SQL developer, SQL developer, Toad, SQL Navigator.
• Experience in providing noledge transfer and support to teh team.
• Production support experience across various projects.
• Proficient noledge of PL/SQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects and Collections.
• Developed Oracle Forms and Oracle Reports using 10g, 11g depending on teh functional requirement document.
• Highly Organized and Efficient to prioritize and manage multiple tasks.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Server Management Studio,Hyperion BI, SQL Profiler, SQL Server Analysis Service (SSAS), Oracle SQL Developer, PL/SQL Developer, Toad, SQL Navigator.

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Oracle Data Integrator(ODI)

Reporting Tools: SQL Server Reporting Services (2014/2008/2005/2000), MS Access, MS Excel, Crystal Reports, Business Objects4.0, Tableau.

Database: MS SQL Server 2012/2008/2005/2000, MS Access,Oracle 10g/11g/12c.

Programming: T-SQL, PL/SQL, C

Web Technologies: HTML, DHTML, CSS, AJAX, jQuery, XML, XSL, Java Script (Validation), CSS

Operating Systems: Windows (95/98/2000), Windows 2003/2008 Server, Windows XP, Linux, Windows Vista

PROFESSIONAL EXPERIENCE

Confidential, Duluth, GA

Application Developer

Responsibilities:

• Worked with teh project Stakeholders and Users in understanding teh Business requirements for teh project.
• Planning development timelines, Tracking development status and Delivering all deliverables on time.
• Participated in day to day agile processes like scrums and sprints.
• Design and Develop Oracle Packages, Functions, and Procedure and Postgres functions.
• Install Postgres and Clone Production databases to Lower environments.
• Participated in teh Analysis phase, Preparing teh technical specification, Development and Testing documents.
• Responsible for System/Software upgrades configuration.
• Responsible for Code reviews.
• Involved in User Acceptance testing and Post production support. Ensured dat all defects are resolved by team within time.
• Trained new joiners with System architecture, Project guidelines and Development processes.
• Created and modified several UNIX Shell Scripts according to teh changing needs of teh project and Confidential requirements.
• Build and maintain Oracle PL/SQL packages and stored procedures (using TOAD and PL/SQL developer), Workflows, and SQR reports as requested by Confidential, for Processing and Analysis.
• Used Ref cursors and Collections for accessing complex data through joining many tables.
• Extensively involved in Performingdatabase, SQL's, API's tuning and optimization.
• Handled Exception extensively for teh ease of debugging and displaying teh error messages in teh application.
• Coordinated with front-end Developers for Implementing logic in stored procedures and functions for faster retrieval of data.
• Performed need based DBA activities like DB schema creating and maintenance for Development, QA, QC and Staging environments, Jobs scheduling in Scheduler, Data Import from production for QA/QC, DB Objects Creation and validation.
• Interacting with UI development team to Develop in tandem back-end solutions with front-end web executions.
• Designed and developed teh data migration Scripts and Programs to upgrade teh Development, QA, UAT and Production DB schemas upgrade to Oracle 12c from Oracle 11g in Development and Production Environments.
• Analyzing and prioritizing teh production issue tickets and moving them from development to scheduled releases.
• Worked as teh Production support engineer for more TEMPthan 15 Universities.
• Developed test cases dat were used in conjunction with teh Quality Assurance team to validate code.
• Interacted with Business Users in creating Unit and System Test cases for enhancements in teh existing application.
• Application support in resolving production problems for existing application and ensure all issues get resolved accordingly.
• Delivered tasks accurately in time provided.
• Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic SQL.
• Developed Oracle partitions, and performance tuning/query tuning.
• Experience in creating ETL transformations and jobs using Oracle using dynamic packages and procedures using oracle code.
• Used Git and Jira as our versions control and ticket submission tools.

Environment:Oracle 11g/12c, MongoDB, SQL, PL/SQL, TOAD, Oracle Developer, SQL*LoaderSQL*PLUS

Confidential, Denver, CO

Oracle PL/SQL Developer

Responsibilities:

• Design and Development of complex PL/SQL scripts for business requirements, mappings, stored procedures, Packages and batch jobs Using Oracle 10g & 11g.
• Developed ETL jobs for Data Extraction, Data Mapping and data Conversion from OLTP and OLAP schemas using SQL, PL/SQL in OWB.
• Developed and Implemented PL/SQL Functions, Triggers, Procedures and Packages fordatabase maintenance.
• Changed existing logic within teh packages for better performance using Oracle Hints, Explain Plans.
• Prepared all required documentation - Technical Specification, Impact Analysis document, Test cases document.
• Providing solutions for SQL queries, complex joins, Expertise in PL/SQL, Procedures, Functions and Packages.
• Worked on SQL Query Optimization & Performance tuning using Oracle PL/SQL Developer.
• Developed teh Parallel Running Batch Programs using DBMS Scheduler API.
• Design and Development of complex PL/SQL scripts for Business requirements, Mappings, Stored procedures and batch programs for BOD and EOD schedules.
• Developed PL/SQL Packages, Functions and Procedures to implement teh Business Logic using Bulk collect, bind variables, Ref cursors, dynamic SQL's to convert teh legacy system data to normalized data.
• Experience in working with IMPLICIT CURSORS, EXPLICIT CURSORS, and REF CURSORS.
• Worked in unit testing teh Stored Procedures and performance tuning teh queries to obtain fine results.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Supported unit testing, system testing and UAT testing.
• Involved in teh continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams.
• Involved in troubleshooting issues, fixing bugs, and fulfilled teh new business requirements.
• Interacted with users to resolve any issues during development, production, and enhancement phases.

Environment: PL/SQL, Data Models, AWR reports, ADDM reports, MS Excel, SQL*NavigatorTeradata, SQL *Plus, Web Forms, ad-hoc, TOAD, Power Builder, PowerShell scripting.

Confidential, NJ

Oracle PL/SQL Developer

Responsibilities:

• Worked with teh Business Analysts and Users in understanding teh business requirements for teh project.
• Creation of database objects like Tables, Indexes, Views, Stored Procedures, Functions, Triggers, and Synonyms.
• Used TOAD, PL/SQL developer tools for faster application development.
• Constructed standard and materialized views for viewing and extracting usable data from various sources to get a clear real-time view of business-critical information.
• Coordinated with DBA in creating and managing Tables, Indexes, Tablespaces, Triggers, DB Links and Privileges.
• Used SQL*Loader to load flat files database tables.
• Used Bulk Collect feature to improve performance and experience in performance tuning by table partitioning.
• Performed exception handling and analyzed table structures and integrity constraints for report-creation strategies.
• Production support for data fixes and debugging aborted processes.
• Extensively involved in Oracle query (SQL) tuning, PL/SQL execution optimization.
• Performed functional testing for teh procedures and packages.
• Tested new enhancements and bug fixes before deployment into teh production environment.
• Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL's thorough out teh projects.
• Involved Database Administration of database objects, including tables, clusters, Indexes, views, sequences, packages and procedures Troubleshoots with regards to database problems and QA defects.
• Test case/data preparation, execution and verification of teh test results.
• Responsible for documentation of all teh project developments and modulations as per teh standards defined and teh system requirements.

Environment:Oracle 11g, SQL, PL/SQL, TOAD, Oracle Developer, SQL*Loader, SQL*PLUS.

Confidential - Jersey City, NJ

Oracle PL/SQL Developer

Responsibilities:

• Experience inDatabase Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Extensively worked on Performance tuning by using Explain plans and various hints.
• Wrote Shell Scripts for Data loading and DDL Scripts.
• Worked on table partitioning (Range and List) and deploying local indexing on portioned tables.
• Worked with DBMS PROFILER to tune PL/SQL Procedures.
• Involved in teh design, data modeling and development and testing phases of various projects and enhancements.
• Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries).
• Created log on trigger and new user to run batch jobs for collecting teh trace files.
• Written manydatabase triggers for automatically updating teh tables.
• Used cursor, ref cursor, bulk collect and bulk insert (Bulk Binding) in procedure to reduce its execution time.
• Created packages and stored procedures for data conversion by using DBMS RANDOM package.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of teh application.
• Created Materialized Views to reduce teh network load.
• Performed teh uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning teh PL/SQL code, tuning queries, optimization for teh Oracledatabase.
• Modified PL/SQL procedures, functions, and packages for data population and manipulation as per user requirements.
• Improved teh performance of teh application by rewriting teh SQL queries.
• Post production support, Performance tuning and Query optimization for Reports and Interfaces using Explain plan.

Environment:Oracle 10g/11g, Oracle SQL Developer, TOAD, SQL*Loader, FTP, Linux, SQL.

Confidential

SQL Developer

Responsibilities:

• Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand teh requirements of teh system.
• Worked on teh Reports module of teh project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Conducted and automated teh ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into teh Multi-dimensional data warehouse.
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Involved in teh development of custom stored procedures, functions, triggers with PL/SQL, T-SQL.
• DevelopedDatabase triggers, Functions and Procedures to implement Business rules.
• Designed developed various types of reports using Oracle Reports.
• Wrote stored procedures to get teh fields required for teh reports.
• Involved in Analysis, Designing & coding. Analyzed customer requirements.
• Developed Daily Production Reports for our clients using Oracle Reports
• Involved in testing, review and code optimization for different Campaigns in teh project.
• Involved in Technical Documentation, Unit testing, Integration testing and writing teh Test plan.
• Created datasets using stored procedures and reports using multi value parameters.

Environment: Oracle 11g/10g, SQL Server 2008/2005, Reports 10g/6i/9i, T-SQL, PL/SQL, SQL LoaderSQL*plus.