SUMMARY

• Performance oriented Oracle Database developer/Data Analyst with proven success in developing multiple projects for Financial, banking, e - commerce industries.
• Over Five years of hands-on experience in Database administrative and PL/SQL code development tasks for development and performance tuning on very large databases.
• 10+ years of experience with Oracle 8i, 9i, 10g, 11g R1, 11g R2,12c working as Oracle Developer and Oracle dba, developing back-end modules, such as packages, functions, procedures, triggers, object types, views, and snapshots for multitier business applications, both Data Warehouses and OLTP systems, in SQL and PL/SQL.
• Expert in writing Stored Procedures, Functions, Database Triggers and Packages using PL/SQL.
• Creating and Managing the Database Objects Such as Tables, Indexes and Views.
• Good Experience in using Dynamic SQL, FORALL, BULK COLLECT for Bulk operations and for bulk Updates in the pl/sql to handle Large Volume of Data.
• Good Experience in using Cursors, SYS REFCURSOR, SYS CONTEXT and PL/SQL logging in the oracle procedure and packages.
• Good working Experience In Data ware Housing (Data Mart)-Environment and Generating the Daily Reports using the Tableau Visualization Tool.
• Extensively Having Experience in Unit testing by Understanding the Existing application and Performing the Unit testing the of the application end to end.
• Having good Experience in Validating the Data in production systems and loading those data in lower Environments like qa and pse and validating the Data as for requirements.
• Good Experience conducting Unit Testing and functional Testing of the application after the fixing the Defects/CQS/Jira’s In Development Environment Before releasing into QA/PSE.
• Having 3 + years of Good Experience in production support for GTR-Rates Application Databases and supporting the Rates Databases.
• Experience in data loading, export/import, Data Pump and backup/restore, session monitoring, providing technical support to Oracle users, Oracle Client installation, and network environment setup.
• Good Experience in Clearing and Settlement Process between two Derivatives.
• Performance Tuning - Database and OS and Explain plan, Execution plan, plan table, hints, sql tuning, Index tuning, AWR, ASH, SQL Profiles, and tkprof.
• DBA activities including creation, management, startup and shutdown of Oracle databases, management of data files, redo log files, control files, table spaces, segments, extents and data blocks & physical storage, creation, monitoring and management of database users, granting/revoking of system/object privileges, management of roles & resources and setting of init.ora parameters.
• Good Experience in using Tableau/Crystal Reports/OBIEE/ODI for Generation of Different Daily reports (Submission and Activity report) using sql quarries for Analysis and Business Rules.
• Good Experience in Different Software Development life cycles (SDLCs) like water fall, Agile.
• Experience in Migration from Development Environment to SAT/INTG/QA/PSE AND PROD.
• Good Experience of using Oracle Application Express (APEX) for Generation of Reports and increasing response time for APEX reports.
• Designed application framework and developed Oracle APEX Application.
• Having good Production Support Experience in Different projects and Troubleshooting the Issues by finding the root cause of the issues.
• Good Experience in Generation of Daily Reports and Dashboards Using data visualization tool tableau.
• Good Experience of Generating reports by applying filters, actions and Calculation using Tableau.
• Good Experience of understating the Dimensions and Measures from oracle tables connection to Tableau visualization tool.
• Experience in managing OLTP databases in a 24X7 production support for Different Databases and different Environments to handle large volume of data.
• Good Experience in work Environment with Different Technologies Like Java, J2ee, .Net, and Mainframe.
• Good Experience in using SQL*Loader, Export, Import and Data Pump.
• Extensive usage of Autosys Tool for the scheduling the Extract Jobs and monitoring the jobs which are scheduled and running.
• Extensively used the Data Pump Utility to export/Import the tables from one schema to other schema and Different Environments.
• Having Good Experience of using External Tables as a file to read the. csvs and fpmls.
• Having Good Experience of Generating the Explain plan and execution plan for tuning the top SQLs and reduce the cost for Cost Based optimizer.
• 5+ years of concentrated experience of Performance Analysis and SQL query tuning, response time reducing, while designing scalable applications from scratch and maintaining existing ones, using AWR, ADDM, Profiler, EXPLAIN PLAN, TKPROF and OEM.
• Good Experience in Understand the Existing data models like Conceptual, logical (LDM), and physical (PDM) and entity relationship diagrams (E-R) of the Different Databases and projects.
• Good Understanding and Implementing the DataModelling Concepts in DataWarehousing Environment like Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Good Understanding of using ERdiagram, Dimensionaldatamodeling, Logical/PhysicalDesign, StarSchemamodeling, Snow-flakemodeling using tools like Erwin and ER Stuido and Proficient in business analysis, end-user analytics, development lifecycle, ETL, QA and testing, production support, performance tuning.
• Good Under standing of Oracle architecture and data modeling Concepts of the application.
• Good knowledge of key Oracle performance-related features, such as cost-based optimizer, execution plans, hints, indexes, clusters, partitioning, temporary tables, v$-views.
• Experience involving Software Design and Development of Client/Server applications and n-tier architectures in ITIL Standards.
• Good exposure in working with ETL tools like Data stage.
• Experience in working with Reporting tools like Business Objects and Crystal Reports.
• Maintenance and Documentation, configuration management.
• Good Experience in using .csv and xmls (FPMLS) files as Input and validate the client Data.
• Good Experience in testing the web services using SOAP and editing the xmls in Oxygen editor.
• Experience in module development and security of the databases.
• Developed complex triggers using PL/SQL for data integrity and enforcing business rules.
• Extensive and very intense SQL coding, database modeling, and development experience for OLTP database and OLAP database.
• Experience using SQL*Navigator and TOAD for query building and analysis and manipulations of databases for checking compatibility and integrity of RDBMS.
• Involved for Writing Redhat Linux/Unix Shell Scripts for backups and batch/job scheduling and Understanding the Perl scripts for batch jobs and extract reports.
• Experience in supporting the various production issues addressed by the users from the client side and providing them with required solutions.
• Extensive experience in working with end users and documentation of business process.

TECHNICAL SKILLS

Oracle Tools: SQL*PLUS, TOAD, ORACLE, SQLDeveloper, Putty, Erwin, SOAP, Oxygen Editor, oracle APEX

Oracle Utilities: Export/Import, Data Pump, SQL*LOADER, AWR, ADDM, OEM, RAC

Languages: C, C++, HTML, Shell Scripting, Perl script, bash, SQL, PL/SQL, T-SQL, COBOL, JCL, CICS, Java.

Databases: MS Access, Oracle 12c/11g/10g/9i, Vectorwise, SQL Microsoft SQL Server 2012 and 2014, Teradata

Microsoft Tools: MS- Visio, MS-Office, Autosys, ITIL

Internet Tools: XML, XSL, JavaScript, Fpmls, CSS, JQUERY, CCAR

Operating System: UNIX, Red Hat Linux, AIX, Solaris, Windows 9x/XP, MVS.

ETL and Reporting TOOLS: Informatica, Autosys, SSIS, SSRS, Data Stage, cogon’s, Crystal Reports-2013, OBIEE, ODI, Essbase,Tableau, Business Object

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NY

Oracle Database Developer/Data Analyst

Responsibilities:

• Extensively created the External tables, Tables and Stage tables in the development Environment for Different DMO system Like Countries Argentina, CITG and all.
• Extensively created The Procedures for Reading the External Tables and loading the Data into Stage Tables.
• Worked extensively on creating tables, ExternalTables, Indexes, Views, stored procedures, functions, and packages as for the Business Logic of the FT-GLOBAL DMO-systems and application.
• Extensively working as Oracle 12c for developing the oracle Database Objects in development and qa Environment.
• Creating and supporting the Database for oracle 11g and oracle 12c.
• Good Experience in Generation of Daily Reports and Dashboards Using data visualization tool tableau.
• Good Experience of Generating reports by applying filters, actions and Calculation using Tableau.
• Good Experience of understating the Dimensions and Measures from oracle tables connection to Tableau visualization tool.
• Fixing the Exceptions which occurred on QA/prod Databases by identifying root cause of the Exceptions.
• Monitoring the Daily cron Jobs and Monitoring the Data Load for all the DMO-Systems.
• Coordinated with ETL(Informatica and Vectorwise) Team for Data Extraction as part of End of the Day Report Generation process In the Tableau.
• Extensively Used the shell and Perl scripts to run the Extract jobs for Generating the Daily Report for Firms.
• Also, Involved with ETL Team for Data Accuracy purpose.
• Involved with Informatica Team to generate the Daily reports for Rates.
• Good Experience in using SQL*Loader, Export, Import and Data Pump.
• Extensively used the Data Pump Utility to export/Import the tables from one schema to other schema and Different Environments like from qa to dev and Integration.
• Having Good Experience of using External Tables as a file to read the. csvs .
• Creating the Database objects (Tables, views, Indexes, packages, functions and procedures) In development Environment and making sure all the db objects sync with Integration environment.
• Implemented the Unit test by posting the .csv and fpml files and validating the Data into the tables and making sure trades working as for requirement and products.
• Finding the db Exceptions in all environments (qa/prod) by querying Exceptions table and Finding the root cause for
• Interacting with client Management and product management for Data fixes and schedules for JIRAS release to production databases.
• Writing the sqls for Data fixes and implementing the sqls through dbas and production databases.

Environment: Oracle 11g, Oracle 12c, SQL Developer, Toad, Informatica, Vectorwise, Production support, Erwin, Putty, Tableau, MS Access, Linux/Unix, shell script, Java, XML, SOAP, Oxygen editor, Auto sys, clear Quest Defect Tracking, my Jira.

Confidential, NYC/NJ

Oracle Database Developer

Responsibilities:

• Study and Understand the Existing data model like logical (LDM), physical (PDM) and entity relationship diagrams (E-R) for rates USDC, NLDC AND SGDC Databases.
• Using Sybase Power Designer and ERWIN for Logical and Physical database modeling, and UML methodology and Use Case design approach using Rational Rose Unified Process.
• Extensively created the tables, views and Indexes in the development Environment for US Datacenter, Netherland Datacenter and Singapore Data center.
• Worked extensively on creating tables, ExternalTables, Indexes, Views, stored procedures, functions, and packages as for the Business Logic of the application.
• Extensively working as Oracle 12c for Developing the oracle Database Objects in development and qa Environment.
• Worked extensively in using Dynamic SQL, FORALL, BULK COLLECT for Bulk operations and for bulk Updates in the pl/sql.
• Worked extensively in using Cursors, SYS REFCURSOR, SYS CONTEXT and PL/SQL logging in the oracle procedure and packages.
• Having 3 + years of Good Experience in production support for GTR-Rates Application Databases and supporting the Rates Databases.
• Providing the production support for GTR-Rates Databases and fixing the Defects, Bugs, dB-exceptions and providing the root cause analysis and providing the solutions for defects.
• Extensively moving and Migrating the Database objects which are created in oracle 11g to oracle 12c.
• Creating and supporting the Database for oracle 11g and oracle 12c.
• Generating the AWR Report and Identifying the top SQL’s In the Database.
• Understanding and Analyzing the AWR report and Explain plan/Execution plan and Tuning the sqls by applying the Hints.
• Study and Understanding of the AWR Report and Identifying the Physical and logical Reads, Gets/Reads, wait events of the Database.
• Good Experience in Generation of Daily Reports and Dashboards Using data visualization tool tableau.
• Good Experience of Generating reports by applying filters, actions and Calculation using Tableau.
• Good Experience of understating the Dimensions and Measures from oracle tables connection to Tableau visualization tool.
• Fixing the Exceptions which occurred on pse/prod Databases by identifying root cause of the Exceptions.
• Extensively doing the Unit testing by Posting the (FPML and .CSV files) the Trades to making sure the Fixed Jiras and CQ Defects working as for business of the application.
• Extensive usage of Autosys Tool for the scheduling the Extract Jobs and monitoring the jobs which are scheduled and running.
• Good Experience of using Oracle Application Express(APEX) for Generation of Reports and increasing response time for APEX reports.
• Designed application framework and developed Oracle APEX Application.
• Monitoring the scheduled Jobs in the Autosys and Identifying for the Job Delays and Issue for root cause Report Generation.
• Monitoring the Extract and ETL jobs in the Autosys and Estimating the Daily Reports generation
• Coordinated with ETL(Informatica) Team for Data Extraction as part of End of the Day Report Generation process.
• Extensively Used the shell and Perl scripts to run the Extract jobs for Generating the Daily Report for Firms.
• Also, Involved with ETL Team for Data Accuracy purpose.
• Involved with Informatica Team to generate the Daily reports for Rates.
• Extensively worked for Confidential Database Migrations form Dev to QA/PSE/PROD According to scheduled Dates.
• Working with entire Rates team members and collecting the db changes which are planed for qa and higher environments as for releases.
• Creating the arps by executing on db changes on Integration Environments and validating the changes by checking the pre-check logs.
• Good Experience in using SQL*Loader, Export, Import and Data Pump.
• Extensively used the Data Pump Utility to export/Import the tables from one schema to other schema and Different Environments like from qa to dev and Integration.
• Having Good Experience of using External Tables as a file to read the. csvs and fpmls.
• Having Good Experience of Generating the Explain plan and execution plan for Tuning the top SQLs and reduce the cost for Cost Based optimizer.
• Experience and supporting the Existing crystal reports of the for generation of Daily Reports.
• Support and making the required changes in the crystal Reports/OBIEE for Generation of Submission, position, warning, activity Reports for Rates.
• Co-coordinating with team members and fixing the errors which occurred on Integration Environment and making sure those should not occur in Higher Environments (qa/pse/prod).
• Extensively worked for all the Datacenter (USDS, NLDC and SGDC) Migrations for Rates by creating the Arps Accordingly with client requirement and schedules.
• Creating the Database objects (Tables, views, Indexes, packages, functions and procedures) In development Environment and making sure all the db objects sync with Integration environment.
• Working with different release operators for creating the arps for different databases and different regions.
• Creating the Serena forms for db changes and including the arp numbers and pre-check logs and getting the approvals from my Manager, dbas team and scm team.
• Working closely with dba and scm team and deploying (through scm) the db changes to different environments like qa/pse and prod and validating the required db changes present or not.
• Worked for Emergency db changes (OEMRS and EMRS) for different environments like pse and prod and deployed the changes through dbas.
• Implemented the Unit test by posting the .csv and fpml files and validating the Data into the tables and making sure trades working as for requirement and products.
• Finding the db Exceptions in all environments (qa/pse/prod) by querying Exceptions table and Finding the root cause for Exceptions.
• Finding the Failed/Exceptional trades in the log files by connecting the Linux servers and Identifying the failed trades for root cause.
• Worked for start to end of the Migration process for rates and deployed the changes in Different regions (qa/pse and prod).
• Worked with dbas for long running manual forms and regular manual forms and deployed or released the changes in pse and prod Databases.
• Providing the USI/UTI transactional History from the Database as for the client request exporting the Data into excel sheet and proving them.
• Creating the table backups before creating the partitions on the database tables which required partitions.
• Applying Indexes and database Hints for Database objects and tuning them for performance.
• Implementing the better Explain plan for long running sqls by applying the oracle hints and order of execution.
• Identifying the sessions (SIDS) which holds Migration for tables and packages and requesting dbas to kill the SIDs and preform the migration.
• Interacting with client Management and product management for Data fixes and schedules for JIRAS release to production databases.
• Writing the sqls for Data fixes and implementing the sqls through dbas and production databases.

Environment: Oracle 11g, Oracle 12c, SQL Developer, Toad, Informatic, Production support, Erwin, Putty, Autosys, SQL plus, crystal reports, Tableau, oracle APEX, ODI COBOL, OBIEE, MS Access, Linux/Unix, Perl script, shell script, Java, XML, SOAP, Oxygen editor, Auto sys, CCAR, Data stage, clear Quest Defect Tracking, my Jira.

Confidential, Harrisburg, PA

Oracle Database Developer

Responsibilities:

• Involved extensive interaction with the users to determine their requirements.
• Requirement gathering, analysis, designing, programming and unit testing.
• Study and Understand the Existing data model like logical (LDM), physical (PDM) and entity relationship diagrams (E-R).
• Created, Monitored and implemented the solutions as required in a Service Request (SR’s).
• Created the Control Files to load the data (Mainframe Systems) from flat files (Mainframe files) to open systems Using SQL LODER.
• Worked with Import and Export of the Database Utilities for taking the backup of the tables and loading into Different environments.
• Created the explain plan for long running sqls and applied hints and changed for better plan.
• Extensively used the shell and Perl scripts to run the for-Batch jobs for generating the Daily Reports.
• Good Experience in using SQL*Loader, Export, Import and Data Pump.
• Extensively used the Data Pump Utility to export/Import the tables from one schema to other schema and Different Environments.
• Having Good Experience of using External Tables as a file to read the Mainframe flat files.
• Having Good Experience of Generating the Explain plan and execution plan for tuning the top SQLs and reduce the cost.
• Modified the PL/SQL Stored Procedures, Packages, and Functions & Database Triggers to support and Enhancements or changes in the Existing Open systems Application.
• Worked extensively on creating tables, Indexes, Views, stored procedures, functions, triggers and packages As for the Business Logic of the application.
• Worked extensively in using Dynamic SQL, FORALL, BULK COLLECT for Bulk operations and for bulk Updates in the pl/sql.
• Worked extensively in using Cursors, SYS REFCURSOR, SYS CONTEXT and PL/SQL logging in the oracle procedure and packages.
• Written the Complex SQL Queries As for the data Request from the client and Open System Developers.
• Extensive usage of Autosys Tool for the scheduling the Extract Jobs and monitoring the jobs which are scheduled and running.
• Monitoring the scheduled Jobs in the Autosys and Identifying for the Job Delays and Generating the Daily Reports.
• Written SQL and PL/SQL Involving in Tuning Complex SQL Queries for Better Performance in Database Objects.
• Generating the AWR Report and identifying the top SQL’s In the Database.
• Understanding and Analyzing the AWR report and Explain plan/Execution plan and tuning the sqls by applying the Hints.
• Experience and supporting the Existing ETL tool and crystal reports of the for generation of Confidential daily Reports.
• Support and making the required changes in the crystal Reports/obiee for Generation of Submission, position, warning, activity Reports for Rates.
• Study and Understanding of the AWR Report and Identifying the Physical and logical Reads, Gets/Reads, wait events of the Database.
• Good Exposer and Involved for Writing Unix/Linux Shell Scripts for Scheduling the oracle jobs and Batch jobs and backups.
• Involved in creating and modifying the existing database packages stored procedures and Functions as for the Enhancements and changes for the application.
• Experience in Migration from Development Environment to SAT/INTG/QA/PSE AND PROD.
• Performed database tuning with Stats pack and AWR Report.
• Written complex queries and stored procedures using sql *plus and monitored databases using TOAD.
• Experienced in creating Materialized views and tuning them.
• Created tables, indexes, views, sequence, synonyms.
• Implemented the code involved in modifying the database records using nested queries and PL/SQL routines.
• Supported Advance PL/SQL using Cursor, REF Cursor, and Native dynamically created SQL within Procedures Dynamic SQL.
• Developed Complex system and application triggers using PL/SQL for data integrity and enforcing business rules.
• Improved performance of Application using PL/SQL Packages and Oracle in built Packages.
• Manipulated Complex Data types within PL/SQL using collections.

Environment: Oracle 11g, SQL Developer, Toad, Putty, Erwin, Autosys, ODI, Linux, Informatica, Crystal Reports, OBIEE, Cognos, SQL plus, PL/SQL Developer, Autosys, clear case, mainframes, Java, .NET, Oracle Enterprise Manager (OEM), RMAN.

Confidential, Washington, DC

Oracle Database Developer

Responsibilities:

• Involved extensive interaction with the users to determine their requirements.
• Requirement gathering, analysis, designing, programming and unit testing.
• Involved in the design of the flow and entity relationship diagrams.
• Develop PL/SQL Stored Procedures, Packages, and Functions & Database Triggers to support the upgrades in the application.
• Worked extensively in using Dynamic SQL, FORALL, BULK COLLECT for Bulk operations and for bulk Updates in the pl/sql.
• Worked extensively in using Cursors, SYS REFCURSOR, SYS CONTEXT and PL/SQL logging in the oracle procedure and packages.
• Good Exposer and Involved for Writing Unix/Linux Shell Scripts for scheduling the oracle jobs and making Schedules for logical backups using Export/Import Utilities.
• Performed database tuning with Stats pack and AWR.
• Written complex queries and stored procedures using sql *plus and monitored databases using TOAD.
• Performed User Management, and enhanced server security using roles, profiles and privileges.
• Worked extensively on creating tables, Views, stored procedures, functions, triggers and packages using PL/SQL.
• Involved in creating and modifying the existing database packages stored procedures and triggers.
• Created tables, indexes, views, sequence, synonyms.
• Created and validated Dimensional Model based on the requirements
• Support and development of OLAP database system with Customer account information.
• Planning and implementation of security user access and privileges for database objects/application data, Control user privileges within a database.
• Implemented the code involved in modifying the database records using nested queries and PL/SQL routines.
• Supported Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL.
• Developed Complex system and application triggers using PL/SQL for data integrity and enforcing business rules.
• Improved performance of Application using PL/SQL Packages and Oracle in built Packages.
• Manipulated Complex Data types within PL/SQL using collections.

Environment: Oracle 11g, Sql Navigator, Toad, Auto sys, Putty, Red Hat Linux5, Informatica, Crystal Reports, OBIEE, SQL Plus, PL/SQL Developer, Autosys, java, Oracle Enterprise Manager (OEM), RMAN.

Confidential, Dallas, TX

Oracle Pl/Sql Developer

Responsibilities:

• Responsibilities: Involved in requirements study technical analysis and database design & tasks identification.
• Good Exposer in using Data Modeling using tools such as ERWIN, and MS Visio.
• Using ERWIN for Logical and Physical database modeling, and UML methodology and Use Case design approach using Rational Rose Unified Process.
• Created tables PL/SQL procedures, functions, Triggers and packages wherever required for the application.
• Writing the stored procedures checking the code for efficiency Tuning SQL Queries to get the best Response Time.
• Performance tuning was extensively done using EXPLAIN PLAN and TK PROF to reduce the execution times of the queries.
• Responsible for documentation useful for training of end users on newly created applications.
• Developed Interfaces using PL/SQL.
• Involved for UNIX Shell Scripting to migrate objects and every day backup of database objects.
• Develop procedures, functions, packages using Inline views, Materialized views, Dynamic Sql to create reports and views for the Hyperion planning and Essbase system.

Environment: Oracle 9i/ 10g, PL/SQL, SOLARIS, AIX-UNIX, Redhat Linux, CITRIX, TOAD, MS Visual Studio, MS Office, MS Visio, Windows XP, oracle discoverer 10g

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Extensively involved in PL/SQL programming on Oracle 9i database engine.
• Provide database design support for new system development set.
• Set oracle standards for object names and usage.
• Using ERWIN for Logical and Physical database modeling, and UML methodology and Use Case design approach using Rational Rose Unified Process.
• Worked extensively on creating tables, Views, sql stored procedures, functions, triggers and packages using PL/SQL.
• Used TOAD as an Oracle developer tool.
• Extensively worked on database cursors and collections in Oracle database.
• Proficient in using SQL * Loader to transfer data from operating system flat files to the Oracle database.
• Tuning SQL queries & use of range/list partitioning and materialized views.
• Created Shell scripts for SQL Loader programs and to kick the concurrent programs as batch manager on regular basis.
• Involved for UNIX Shell Scripting for batch jobs and backups.

Environment: Oracle 9i/10g, AIX-UNIX, SOLARIS, TOAD, SQL * PLUS, PL/SQL, Java, Crystal Reports, MS Office, Windows XP.