SUMMARY

• Over Seven (7+) years of IT experience in Oracle development, analysis, design, modeling, testing and implementation of data warehouse business applications.
• Well versed in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Excellent skills in designing and development of applications using Oracle PL/SQL.
• In depth Knowledge and experience of Data Warehouse/Data Mart design and implantation concepts.
• Very good understanding of 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.
• Strong experience in coordinating and providing support to UAT/BAT/QA Team during testing phase of Project life cycle.
• Excellent SQL skills, experience writing complex queries and working with database objects like tables, views, sequences, synonyms.
• Experience with Ellucian Banner, Power Campus and Campus Vue.
• 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 … Reports10g/9i/6i, Discoverer 9i/10g, XML Publisher and developing concurrent programs using SQL, PL/SQL.
• Expertise on Advanced PL/SQL programming in implementing the 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 of Data Modeling using ETL tools, Star Schema, Snowflake Schema, and Entity- Relationship Diagrams.
• Good Knowledge on Client-Server application development using Oracle PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• In depth knowledge of RDBMS concepts, with hands on exposure in the development of relational database environment using SQL and PL/SQL using database tools like Pl SQL developer, SQL developer, Toad, SQL Navigator.
• Good knowledge of UNIX shell scripting.
• Experience in providing knowledge transfer and support to the team.
• Production support experience across various projects.
• Proficient knowledge of PLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects and Collections and creation of database objects like tables, views, synonyms, sequences, Indexes, Triggers, Table partitions, Sub-partitioning, Database links etc.
• Developed Oracle Forms and Oracle Reports using 10g, 11g depending on the 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) Reporting Tools SQL Server Reporting Services … MS Access, MS Excel, Crystal Reports, Business Objects4.0, Tableau

Database: MS SQL Server … Oracle 10g/11g, MS Access

Programming: T-SQL, PL/SQL, C

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

Operating Confidential: Windows … Windows … Server, Windows XP, Linux, Windows Vista

Data Visualization & Analytics: Tableau, R (w Rattle), SAS (E-M) Weka

PROFESSIONAL EXPERIENCE

Confidential, Duluth, GA

Sr ORACLE PL /SQL Developer

Responsibilities:

• Interacted project stakeholders and Users in understanding the business requirements for the project.
• Worked directly with Project Managers and taking complete ownership of the project starting from requirement till post production support.
• Worked on Student, Financial and Registration module APIs.
• Worked on Banner Database, Banner Batch Processing (job submission) Server, Internet Native Banner
• (INB) & Self-Service Banner (SSB).
• Worked on Student Application module and Attendance module.
• Supported the Application term as required.
• Developed a generic process to unmerge duplicate Ids from the modules like Student, Financial Aid, Finance, and Payroll as well as universities custom modules.
• Provide Applications Support for Ellucian Banner Finance module and other software.
• 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 the analysis phase, preparing the technical specification, development and testing documents.
• Responsible for code reviews.
• Involved in User Acceptance testing and post production support. Ensured that 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 the changing needs of the project and client requirements
• Created database objects like tables, views, procedures, packages, and cursor using TOAD, PL SQL developer, SQL developer and SQL navigator.
• Build and maintain Oracle PL/SQL packages and stored procedures (using TOAD and Pl SQL developer), Workflows, and SQR reports as requested by client, for processing and analysis.
• Used Ref cursors and Collections for accessing complex data through joining many tables.
• Extensively involved in Performing database, SQL's, API's tuning and optimization.
• Handled Exception extensively for the ease of debugging and displaying the error messages in the application.
• Coordinated with front-end developers for implementing logic in stored procedures and functions for Faster retrieval.
• 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.
• Interacted with UI development team to develop in tandem back-end solutions with front-end web executions.
• Designed & developed the data migration Scripts and Programs to upgrade the Development, QA, UAT and Production DB schemas upgrade to Oracle 12c from Oracle 11g in Development and Production Environments.
• Analyzing and prioritizing the production issue tickets and moving them from development to scheduled releases.
• Worked as the production support engineer for more than 15 Universities.
• Developed test cases that were used in conjunction with the Quality Assurance team to validate code.
• Interacted with Business Users in creating Unit and System Test cases for enhancements in the 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.
• Created 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: Oracle12c,Oracle11g,SQL,PL/SQL,TOAD,OracleDeveloper,SQL*Loader,SQL*Plus, Postgres9.4, MongoDB, SQL, PL/SQL, T-SQL, VBA, Excel. Perl, PHP, CSS, HTML, GIT.

Confidential, Warren,NJ

Oracle PL/SQL Developer

• 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 for database maintenance.
• Changed existing logic within the 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 Explain Plan and
• DBMS XPLAN.
• Developed the 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 the Business Logic using Bulk collect, bind variables, Ref cursors, dynamic SQL's to convert the legacy system data to normalized data.
• Monitored Indexes (XML Type: XML Index) and analyzed their status for performance tuning and query optimization.
• Worked with IMPLICIT CURSORS, EXPLICIT CURSORS, and REF CURSORS.
• Worked in unit testing the Stored Procedures and performance tuning the 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 the 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 the new business requirements.
• Interacted with users to resolve any issues during development, production, and enhancement phases

Environment: PL/SQL,DataModels,AWRreports,ADDMreports,MSExcel,SQL*Navigator,Teradata,SQL*Plus, Web Forms, ad-hoc, TOAD, PowerBuilder, Power Shells

Confidential, NJ

Oracle PL/SQL Developer

• Worked closely with the Business Analysts and Users in understanding the business requirements for the 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 the procedures and packages.
• Tested new enhancements and bug fixes before deployment into the production environment.
• Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL's thorough out the 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 the test results.
• Responsible for documentation of all the project developments and modulations as per the standards defined and the system requirements.

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

Confidential

Oracle PL/SQL Developer

• Involved in Database 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 the 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 the trace files.
• Written many database triggers for automatically updating the 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 the application.
• Created Materialized Views to reduce the network load.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Modified PL/SQL procedures, functions, and packages for data population and manipulation as per user requirements.
• Improved the performance of the application by rewriting the 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

• Actively interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Involved in the development of custom stored procedures, functions, triggers with PL/SQL, T-SQL.
• Developed Database triggers, Functions and Procedures to implement Business rules.
• Designed developed various types of reports using Oracle Reports.
• Wrote stored procedures to get the fields required for the 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 the project.
• Involved in Technical Documentation, Unit testing, and Integration testing and writing the 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 Loader, SQL*Plus