PROFESSIONAL SUMMARY

• 6.5+ years of profound working experience in SQL, PL/SQL programming, System Analysis, Design,
• Development, and Support of Oracle Database in Production, Staging, Development, and Testing Environments
• Expertise in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, Confidential, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL
• Created various types of database objects Indexes, tables, Sequences, Synonyms
• Proficiency to create composite data types such as PL/SQL records and PL/SQL collections
• Ability to manage objects dependencies in the Oracle database
• Strong ability to handle Oracle Exceptions
• Strong knowledge of Oracle utilities like SQL*Loader and External Table
• Experience in query optimization, performance, and tuning (PL/SQL) using Explain Plan, Indexing, Hints, Bulk Collect, Creation of global temporary tables and table partitioning
• Worked heavily with relational database models, schemas & entity - relationship diagrams (ERMs) to create technical/system design documents
• In-Depth Knowledge of Oracle Architecture, data dictionary, to understand Schema Objects, Schema Objects Relations, Schema Privileges, Roles, and Restrictions
• Strong knowledge of PL/SQL Wrapper to protect the PL/SQL procedures or packages
• Expertise in handling errors using Exceptions
• Experience in working with SQL Server Integration (SSIS)
• Expertise in using tools such as Oracle SQL Developer
• Very good knowledge and hands on Sybase Iq/Ace
• Knowledge of the system analyzes and gathering information
• Good team player, quick learner, target oriented individual with excellent communication and interpersonal skills, also possess the ability to work independently
• Sound ability to provide training and teaching to team members about database

SKILLS & EXPERTISE

Operating Systems: Windows 7/8/10, Unix

Languages: SQL, PL/SQL, Free marker, JSF

Databases: Oracle, MS SQL Server, Sybase IQ/ACE

Development Tools: SQL Developer, Squirrel, PL/SQL Developer

Designer Tool: SQL Developer

Internet Technology: HTML, CSS

Scripting: UNIX Shell Script

PROFESSIONAL EXPERIENCE

Confidential, NJ

senior DATABASE DEVELOPER

Responsibilities:

• Designed and Developed Entity Relationship diagram from business specification or narrative
• Worked and developed many procedures and functions per the requirement and developed brand new packages with cursors
• Developed all types of Explicit cursor and used in the packages and procedures
• Created scripts to load the data into tables from another database
• Debugged, maintained and made changes to existing systems
• Retrieved data from Oracle and Sybase tables for generating customize report in Citigroup approved reporting tool for financial and regulatory requirement
• Extensively used for DDL, DML, and DCL statements
• Tuned database SQL statements and procedures by monitoring Explain plans and system statistics
• Inserted hints and rewrote the SQL statements code as required for tuning SQL statements
• Wrote complex SQL queries and Subqueries for faster data retrievals
• Used different types of Join condition in the queries
• Combined multiple queries result with set operators (UNION, UNION ALL, INTERSECT, MINUS)
• Created Dynamic SQL statements at runtime
• Developed code engine and dynamic reporting using SQL, Free marker and Groovy for Financial and Regulatory Reporting Citigroup approved reporting tool
• Performance tuning of PL/SQL queries using cache feature of Oracle 11g. Tuning also performed via indexing, partitioning, pipelines table functions and hints
• Lead the migration of Financial reporting from Sybase database to MemSQL for Inquiry Framework
• Work with Finance Business users to implement the standard reporting and analysis solution / processes and technologies
• Effectively engages the team to successfully complete multiple and diverse deliverables; for completeness and accuracy of the work product
• Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning

Environment: Oracle 11g/12c, SQL and PL/SQL, SQL Loader, Sybase IQ/ACE

Confidential

DATABASE DEVELOPER

Responsibilities:

• Wrote complex SQL queries and PL/SQL functions and procedures
• Performance tuning of the execution of the Billing batch to calculate and fetch data reports for payment to business associates using materialized view concepts.
• Automated the download excel data feature of the billing information of associates from static to dynamic user input for various geographies.
• Developed strategies for fetching data reports of the business associates for organization’s audit and compliance purpose.
• Implemented various concepts of manipulation of SQL joins and keys for faster performance/tuning.
• Performed month-end implementation functions, analysis and resolution.
• Involved in the documentation of the system.

Environment: Oracle 11g, SQL and PL/SQL, MS SQL Server 2012

Confidential

DATABASE DEVELOPER

Responsibilities:

• Automated the execution time of provision, invoice and claim batch by more than 90 percent using indexing and partitioning concepts on base table/temporary tables in MS SQL Server
• Developed automated email delivery system of batch monitoring sheet using SSIS Packages.
• Implemented SSIS packages to gather table statistics, index rebuild, full/differential backups of server log and data files.
• Improvised strategies for scheduling database and log backups and restoration in MS SQL Server 2012
• Performed the Provisioning data flow from SQL Server 2008 to Oracle 11g.
• Coordinate projects and provide guidance on applicable impacts and specifications as required.
• Interacts with stakeholders from within and outside of team to respond in an accurate and timely fashion to ad hoc requests related to the group’s activities
• Worked on resolving the production issues. Developed a lot of new scripts and updated existing scripts to solve the issues.
• Performed month-end implementation functions, analysis and resolution.

Environment: Oracle 11g, SQL and PL/SQL, MS SQL Server 2012