SUMMARY

• 9+ years of experience in analysis, design, development, and testing of business applications in OLTP, web based, Client/Server architectures.
• Strong Knowledge on oracle architecture and database design. Excellent conceptual knowledge of Oracle 9i/10g/11g/12c, SQL, PL/SQL. Expertise in designing a database from ER/Diagrams and in normalizing the database.
• Proficiency in creating stored procedures, functions, packages and triggers to perform specialized functions and enhancements on Oracle Application.
• Extensively used advanced PL/SQL concepts like Collections, Indexes, Record types, Cursors, REF cursors, Partitions and Bulk collect operations.
• Expertise in loading data from legacy systems using SQL*Loader and Oracle External tables. Worked with various performance tuning techniques using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE, HINTS, DBMS PROFILER, PARALLEL queries etc.
• Used pl/sql tables, pragma autonomous transaction to avoid mutating problem in database trigger.
• Collaborate with Developers, Business Analysts, Product Owners, and Architects to successfully implement and maintain the data integration layer.
• Experience in Database modeling and database object definitions using tools like Oracle Designer.
• Good understanding of Oracle database architecture and design and have performed few DBA duties (export, import, data pump, SQL performance and tuning).
• Experience in Query Optimization, Debugging and Tuning and Improvising performance of the applications.
• Have in - depth knowledge in Data analysis, Data warehousing and Extraction Transformation and Loading (ETL) techniques, Business Objects, UNIX Shell Scripting.
• Extensive Experience on Views, Materialized views, Global temporary tables, Nested Tables, Objects, Autonomous Transactions, Dynamic SQL.
• Worked on UTL FILE extract data from the tables and create files in oracle directories and used various sub programs of UTL FILE package for file operations.
• Actively participated in regular code reviews and maintenance of code and process documentation.
• Knowledge on OLAP components development. Experience in writing Technical design documents and developing Unit test documents. Supported integration and end user testing with efficient defect management process.
• Worked on complete SDLC (System Development Life Cycle) including system analysis, high level design, detailed design, coding and application testing.
• Well versed in Agile and Waterfall methodologies. Proficiency in Agile scrum review and planning sessions.
• Strong Analytical, Problem solving skills with troubleshooting capabilities. Excellent communication and inter-personal skills at the technical and user level.
• Ability to work individually as well as in a team. Ability to learn and adapt to new tools, concepts and environments.

TECHNICAL SKILLS

Operating Systems: Windows, Windows Vista, XP, NT, UNIX, Linux, Sun Solaris

Database (RDBMS): ORACLE 12c/11g/10g/9i/8i, MS SQL server, Teradata

Internet Tools: HTML, HTML5, DHTML, CSS, XML, Java Script, JQuery, JSON

Languages: SQL, PL/SQL, UNIX Shell Scripting, Perl, SAS, C, C++, Java, Python

Database Tools: SQL Developer, TOAD, SQL*NAVIGATOR, SQL*PLUS, PLSQL Developer

Database Utilities: SQL*LOADER, External tables, UTL FILE, DBMS Packages, TKPROF, Explain Plan, SQL*TRACE

Ticketing Systems: JIRA, SMART, HP Quality Center, Service Center, Smile, SYSAID

Version Control Software: GIT, VSS, Tortoise SVN, PVCS

Data Modeling Tools: Dimensional Data Modeling, Physical and Logical Data ModelingMS Visio, ERWIN, ER Studio, Toad Data Modeler

PROFESSIONAL EXPERIENCE

Confidential, Whippany, NJ

Sr Oracle Developer

Responsibilities:

• Create and maintain complex Oracle PL/SQL programming environment (with clauses, aggregate functions, pivot functions, advanced analytical functions, inline queries and sub queries) involving stored procedures, triggers, functions, indexes, packages and perform Data modelling based on stake holder’s requirements using Oracle 12c.
• Troubleshoot MANTAS job failures and manage Mantas Batches and perform User administration setup and work on OFSAACONF tables.
• Develop OBIEE reports & dashboards, OBIEE repository, use OBI administration tool, free form SQLs, complex prompts and customizations (OBIEE 11g/12c) and involve in large scale data center operations with Enterprise Servers handling production systems.
• Work on Change request management, Incident management using Service First and Service Now tools and provide L3 production support for existing systems, identifying root causes, and troubleshooting data and/or system issues.
• Create Cron jobs and UNIX shell and Perl scripts for System Automation running the daily loads and work with AUTOSYS and other enterprise-wide schedulers.
• Use GIT, version control tool which helps multiple users to access and make changes to the collection of source code files. Support multi-platform UNIX / Linux server environment by performing patching, hardening, Performance tuning, and disaster recovery planning.
• Create complex SQL queries including with clause, aggregate function, pivot function, advanced analytical functions, inline queries and sub queries for faster data retrieval from multiple tables.
• Worked on Informatica 10.2 upgrade and configuration. Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Work on all phases of SDLC (System Development Life Cycle) including system analysis, high level detailed design, coding and testing.
• Perform Release planning & management creating work plans with users, test every enhancement and customized solution deployment.
• Develop UNIX Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Work with Bulk Collects to improve the performance of multi-row queries by reducing the context switching. Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Modified existing Perl, Python scripts per the changing needs of the project and client requirements.
• Implementation of automated code integration and deployments using DevOps - GIT, NEXUS, TeamCity, NOLIO.
• Strong knowledge in implementing database security by writing several triggers on database level, table level to know Login information to maintain, monitor, track user’s identities across all Databases (login, logout information).
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Extensively use Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions. Develop SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Create Indexes, passing hints, analyzing the table statistics and Table partitioning to improve the Query performance.

Environment: Oracle 12c, OBIEE 12c, SQL * Plus, TOAD, SQL*Loader, Informatica PowerCenter 10.1 & 10.2, Shell scripts, Perl, Python, SQL Developer, Nolio, GIT, NEXUS, TeamCity, Service First, Service Now, GIT, JIRA, UNIX, Windows XP.

Confidential

Sr Oracle PL/SQL Developer

Responsibilities:

• Worked on Implementing Marketing database for Nationwide insurance to support entire Affinity Solutions process supporting multiple groups which include alumni, Universities, financial cause professional organizations.
• Developed, implemented and maintained scripts, functions, stored procedures to handle hundreds of millions of data records at quarterly, monthly, weekly, daily along with handling of historical campaign data for direct mail and email campaigns.
• Implemented data handling, cleansing, standardization procedures and data transformation and mapping logic using Oracle 12c.
• Worked with project team to deliver OLAP solutions to provide robust high availability and performance of PLSQL Applications.
• Creation of database objects like tables, views, materialized views, database triggers using oracle tools like SQL developer, SQL*Plus .
• Monitored and recognized system deficiencies and executed all effective solutions collaborating with development team to resolve all design issues.
• Resolved all emergency production issues and ensure appropriate resolution of all issues within required timeframe.
• Wrote complex SQL queries including with clause, aggregate function, pivot function, advanced analytical functions, inline queries and sub queries for faster data retrieval from multiple tables.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Developed Procedures for efficient exception handling and transaction process by capturing errors into user managed tables.
• Used GIT, version control tool which helps multiple users to access and make changes to the collection of source code files. Used JIRA for ticketing system.
• Implemented Advanced PLSQL Concepts like Bulk Collects for better performance of PLSQL Applications.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Used AIM (Application Implementation Methodology) in documenting the development tasks.
• Used Data Stage, SQL* loader ETL tools for the successful extraction, transformation and loading of data from flat files to Oracle database.
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions. Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Creating Indexes, passing hints, analysing the table statistics and Table partitioning to improve the Query performance.
• Developed Unix Shell Scripts to Schedule complex Cron jobs to automate tasks of running daily loads into Staging tables using crontab format.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used the standard Oracle package DBMS SCHEDULER to automate / schedule jobs on daily, weekly and monthly basis and to run jobs in parallel to improve time-constrained performance.

Environment: Oracle 12c, SQL * Plus, TOAD, SQL*Loader, Shell scripts, SQL Developer, GIT, JIRA, UNIX, Windows XP.

Confidential, Billerica, MA

Sr Oracle Engineer

Responsibilities:

• Worked closely with Java and PowerBuilder based Oracle ADF Architecture development teams to design, implement and test the data integration tier leveraging database triggers, PL/SQL stored procedures, packages and functions.
• Developed and integrated automated database migration scripts with flywaydb to move application functions from legacy system to the new system. Created database links to retrieve data from multiple servers.
• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Created custom PL/SQL procedures to read data from flat files and dump to Oracle database using SQL * Loader.
• Involved in Index Monitoring for identifying the Unused Indexes.
• Extensively used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• Created Database triggers, Cursors, Indexes and SQL Scripts to create new tables, views for the validation of input data and to implement business rules.
• Create and run batch files on regular basis. Created records, tables, collections (nested tables and varrays) for improving Query performance by reducing context switching.
• Designed, developed and tested Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed List of Values, Record Groups, and triggers for different data blocks to improve the functionality of the forms using Oracle Forms 9i.

Environment: Oracle 11g, Oracle ADF, SQL * Plus, TOAD, Java, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP.

Confidential, Clark, NJ

Technical Analyst

Responsibilities:

• Analysed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Converted existing SAS application programs, macros and other statistical procedures to Oracle stored procedures to effectively interact with the database and increase the efficiency on production systems.
• Depending on the business requirements, created and modified database objects like tables, Indexes, views, stored procedures, functions, packages, Triggers, synonyms, Materialized views, to make new enhancements or resolve problems. Created various SQL and PL/SQL scripts as required.
• Used VI editor for PL/SQL scripts and UNIX Shell Scripting for regular maintenance and production support to load the data in regular intervals.
• Performed Performance Tuning using DBMS PROFILER package, this checks the run time behaviour and tunes the pl/sql programs.
• Involved in setting up the DBMS JOB package which allows a user to schedule a job to run at a specified time.
• Optimized Complex SQL and PL/SQL Query performance using Oracle utilities like Explain Plan, SQL-Trace and TKPROF. Worked with Bulk Collects to tune the performance of multi-row queries.
• Involved in Bulk loading of data from non-Oracle data sources, flat files using SQL * Loader.
• Created complex triggers for generating primary key values and for implementing the complex business logic.
• Involved in the deployment of code into QA and Production environment.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, Teradata, PL/SQL Developer, UNIX, Linux, Windows XP.

Confidential

Database developer

Responsibilities:

• Involved in SDLC including designing, coding and application testing. Involved in logical and physical database design and Star Schema design, Identified Fact Tables, Transaction Tables.
• Participation in weekly design reviews and walkthroughs with project manager and development team. Worked on database design with the team.
• Created Materialized Views and partitioning tables for performance reasons.
• Generated SQL and PL/SQL scripts to install create and drop database objects including tables, views, primary keys, Indexes, constraints, packages, sequences, grants and synonyms.
• Involved in writing PL/SQL Packages, Functions, Stored Procedures and Data Base Triggers.
• Developed complex queries to retrieve the data. Performance tuning of the SQL queries using Explain Plan. Documented business rules, functional and technical designs, test cases, and user guides.
• Monitored the database growth on daily basis. Wrote UNIX Shell scripts.

Environment: Oracle 9i, SUN Solaris, TOAD, SQL*Loader, PL/SQL, SQL*Plus.