OVERVIEW:

• Over 1 5 years of experience in the IT industry in the US in different stages of Software Development Life Cycle ( Architecture, Analysis, design, development, testing, implementation, documentation and post implementation support) as an Oracle Data Architect /DBA/Developer.
• Extensive Experience with database design, architecture and leading data teams on multiple projects .
• Expert in troubleshooting performance issues on Oracle OLTP/Warehouse, XML databases and Oracle Financials, Oracle Forms, Concurrent Manager.
• Extensive experience using the AD utilities to maintain Oracle Applications.
• Worked on multiple projects for analyzing the architectural design and making recommendations per the industry best practices.
• Experience with data modeling tools like Erwin, Microsoft Visio 2000, TOAD Data Modeler, SQL Developer Data Modeler.
• Extensive experience using Oracle Enterprise Manager, SQL Loader, Toad, SQL Developer, PLSQL Developer, SQL Navigator.
• Experience writing backend Stored Procedures, Triggers, Packages, Functions on Oracle 8i/9i /10g/11g/12c using PL/SQL.
• Knowledge of Java and Angular JS. Experience with HQL.
• Extensive experience configuring new database installs on Oracle 11g / 12c on linux Platforms.
• Experience performing db backup and recovery for the database refreshes from Prod to lower env.
• Experience doing performance Tuning of SQL Queries on Oracle 8i/9i/10g /11g/12c
• Extensive experience with leading analysis and understanding of client business requirements. Converting those functional specs into technical design.
• Expert in Oracle Performance Tuning.
• Define and initiate projects, and assign Project Managers to manage cost, schedule and deliverables.
• Vast experience on Extraction, Transformation and Load (ETL) strategy, design and implementation. Includes ETL across different platforms.
• Extensive knowledge of Relational Databases. Suggested many cost saving solutions for corporations using new compression/storage and migration best practices to AWS cloud both on EC2 and RDS.
• Responsible for developing Confidential ’s Enterprise Database Creation Standards to ensure that the database was FISMA (Federal Information Security Management Act) compliant.
• Extensive experience implementing Oracle Streams.

SKILL SUMMARY

Designer, Visio, Discoverer, Forms, Reports, Shell Scripting, Flyway, Oracle Applications 11.0.3/11i, Oracle 7/8.x/9i/10g/11g/12c, Oracle Grid Control 12c, PostrgeSQL, Oracle Application Server 9i, PRO*C, Enterprise Manager, Toad, Oracle 9i Application Server, JavaScript, HTML, Oracle Database 8i, 9i, 10G,11G,12c, Oracle Apps Server 10g, SQL, PL/SQL, ERWin, TOAD Data Modeler, Oracle XML, Oracle Streams. Golden Gate.

PROFESSIONAL EXPERIENCE:

Confidential

Lead DBA / Applications Developer

Responsibilities:

• Lead Oracle DBA for a team of 6 members. Managed, coordinated and reviewed the oracle solutions proposed by other team members.
• Architected multiple database solutions for Financial / Mortgage Regulation Systems.
• Documented Oracle Server configuration standards for the Enterprise on 11g / 12c
• Documented database refresh procedures and standards using RMAN.
• Expert in Oracle performance tuning and oracle internals. Resolved multiple prod issues by optimizing the SQL Expert in using AWR Reports, SQL Plan Baselines, SQL Profiles, Histograms, Optimizer Parameters, statistics.
• Extensive experience Installing and configuring Oracle database in Linux environment on 11g and 12c
• Extensive experience creating complex Oracle Text Indexes for full text search performance.
• Configured Oracle Grid Control 12c.
• Responsible for data migration from legacy systems to the newly designed systems.
• Responsible for working with Enterprize teams to integrate the data across various systems.
• Wrote Unix Shell Scripts to automate backup and scheduled database jobs via dbms scheduler and Unix cron.
• Developed solutions to reduce db storage footprint. Consolidated multiple databases on a single server using 12c Pluggable technology.
• Experience managing the Oracle Databases on Amazon EC2 Cloud Servers.
• Responsible for heavy performance tuning of very complex oracle SQL queries and dynamic PLSQL Packages.
• Supported the Java / .Net Application Team to troubleshoot issues with Hibernate queries, JDBC connectivity issues
• Responsible for designing an Oracle XML database and wrote several packages to Extract and Load the XML data into relational tables using SQLX.
• Recommended XML best practices and removed deprecated XML constructs.
• Architected oracle replication solutions using Oracle Streams / Materialized View Logs / Oracle Golden Gate.
• Setup replication using oracle streams for capturing delta changes between 2 source and target databases and also within the same database. Created DML Handler to do data transformation. Wrote custom scripts to handle errors due to spillage. Created capture and apply rules to transform table structure between source and target.
• Recommended oracle patches related to streams known issues and changed the default streams parameters for better capture and apply performance.
• Created scripts to easily deploy the streams configuration to new environments.
• Used Oracle Streams on 11.2.0.3 and Golden Gate versions 11.2.1 / 12.1.2. Setup both uni and bidirectional (Active - Active) replications using Oracle GG.
• Experience with various components of Golden Gate: Extract, Repliat, Data Pump, Trail Files, Collector.
• Experience handling conflicts in a Bi-Directional GG setup.
• Experience setting up parameters to handle Extract / Replicat Errors.
• Experience Performance tuning of Golden Gate. Experience Setting up Monitoring for Oracle Golden Gate Processing.
• Developed Data warehouse ETL scripts and optimized the ETL jobs.
• Responsible for verifying the database packages written by other developers for any issues that might lead to performance.
• Responsible for doing analysis on problem SCRs and suggesting the possible alternatives for solution.
• Responsible for monitoring the Database from a performance perspective and suggesting any improvements.
• Responsible for creating and verifying deployment scripts.
• Responsible for managing production deployments.
• Responsible for Data Modeling using ERWIN 9.
• Responsible for database upgrade planning.
• Responsible for writing new Database packages that generate XML output using Oracle 9i new inbuilt packages like SQLX, DBMS XMLGEN, DBMS XMLQUERY and XQUERY.
• Responsible for monitoring init.ora parameter settings and suggesting any changes in those parameters that might help in performance.
• Responsible for suggesting indexing strategies.
• Responsible for creating test harnesses for complex database packages.
• Responsible for mentoring junior team members.
• Implemented Failover solutions using Oracle Data Guard on 12c
• Responsible for performing analysis on complex technical issues and suggesting solutions.
• Extensive experience of Oracle Performance Tuning utilities like SQLTRACE TKPROF, DBMS XPLAN
• Extensive experience doing Response Time Profiling.
• In depth knowledge of Oracle v$views to diagnose Performance Issues.
• Extensively used both Oracle command line and OEM Grid Control 10g.
• Supported and Managed SQL Server Databases for internal projects.
• Responsible for installing Oracle binaries, upgrading the db, maintenance of multiple production systems.
• Directly worked with Users to deliver complex Data Feed Reports using Oracle's XML Technology.
• Provided solutions to successfully migrate multiple Confidential dbs from onsite to AWS cloud from Oracle - Oracle and Oracle to PostgreSQL with minimal impact to existing application and minimal downtime.
• Configured AWS cloud deployments for FINPRO team using Flyway and integrated it with Jenkins.
• Extensive experience in implementing database level security solutions: Transparent Data Encryption for data at rest, obfuscation, data redaction and data masking for PII and RCI data, network encryption, VPD ( Virtual Private Database involving both row and column level encryption, Database level auditing.
• Analyzed the System with Stress Testing team and generated AWR/ASH reports to get the list of offending SQL
• Analyzed each SQL via DBMS XPLAN to reduce the logical and physical I/O.
• Suggested creation of XML Indexes and Oracle TEXT Indexes to reduce the response times of queries performing free text searches on the XML Documents
• The XML Structure is nested, DML operations on these XML tags make the index fragmented, Recommended weekly index maintenance on some of the key context indexes.
• Modified the queries to remove the deprecated XML features on 12c.
• Implemented PARALLEL processing of large XML batch jobs via DBMS SCHDULDER and processing jobs in batches.
• Recommended to use Oracle SecureFiles and Binary XML which reduced the db storage footprint and improved the XML INSERT and QUERY operations.
• Suggested Use to Oracle XMLTABLE to generate XML Views on XML data. This provided the flexibility to query XML documents in a relational format and allowing the use of XMLINDEX to optimize the query performance.
• Suggested the use of DELETEXML(),UPDATEXML(), INSERTCHILDXML(), INSERTCHILDXMLBEFORE(), and INSERTCHILDXMLAFTER(), when the XPath can be evaluated directly using the underlying relational tables and columns of the structured storage
• Used XMLOPT IMIZATIONCHECK ON|OFF ” to get the optimized rewritten query in the trace file to see what underlying queries are executed on the underlying internal tables created for XML storage and index models
• Configured Active Data Guard for Max Performance on ASM using Oracle TEXT and XMLDB on Oracle 12 version 12 .1.0.1.
• Configured Oracle Data Guard Broker on 12c for easy manageability of the Oracle Data Guard Configuration, and troubleshooting Oracle performance and Firefighting critical production issues.
• Optimized database via initialization parameter changes and SQL tuning, and recommended best db development practices to the development team members.
• Recommended best configuration architecture for AWS EC2 instances
• Created new ASM instances from scratch on EC2 and configured new DAS databases. Extensive experience in troubleshooting critical oracle issues both in prod and non-prod environments.
• Worked extensively with Oracle SEV1 support teams to get a resolution on new bugs identified on Oracle 12.1.0.1 and apply the one off patches.
• Scheduled database RMAN compressed backups via UNIX Cron Jobs.
• Optimized OPA export routines to ensure weekly export completes within the Confidential SLA.
• Optimized data intake module queries.
• Used New Oracle 12c partitioning features to improve the performance of batch jobs.

Environment: AGILE Methodologies -SCRUM, Waterfall Methodology, Oracle 9i/10g/11g/12c, RMAN, PL/SQL,, Streams and Golden Gate, OEM 12c, Active Data Guard, RAC, ASM, Hibernate, JAVA, Oracle XMLDB Oracle Text, ERWIN, SQL Server 2012 Oracle Spatial, XMLDB, Unix Shell Scripting VB.net, ODP.net, TOAD, Flyway, Jenkins, TFS, JIRA, PostrgeSQL,Git/Stash, RMAN.

Confidential

Senior Oracle Developer

Responsibilities:

• Responsible for Automating the Batch Jobs on HP UX version 11.
• Wrote extremely complex shell scripts that did a lot of validations.
• Wrote FTP scripts in UNIX shell.
• Wrote Shell Scripts to send email and pager notification to the SOLAR production support team.
• Included the day of the month calculation to perform some specific operations on a specific day of the month.
• Wrote Data Load Scripts in UNIX Shell.
• Developed custom UNIX shells for doing date calculations as UNIX can’t handle date calculations.
• Wrote Ftp Scripts in UNIX Shell.
• Responsible for Requirement gathering with the users.
• Used AWK and SED in the UNIX Shell scripts.
• Responsible for Design Documentation.
• Worked on the Preprocessor Module of SOLAR system.
• Used Dynamic PL/SQL code to develop an object oriented code for Preprocessor.
• Wrote UNIX scripts to send out emails and Pager Notifications.
• Made sure that the same code can be used for different subsystems by passing a different parameter.
• Developed Forms and Reports on Oracle Apps 11i.
• Customized Oracle Apps 11i Forms using Oracle Apps Standard Libraries.
• Responsible for writing Stored Procedures, Triggers, Cursors, Packages using SQL and PL/SQL.
• Developed complex views making use of DECODE statements to make sure that all the logic can be handled in the views itself and the code need not be touched.
• Used Autosys to schedule the UNIX batch jobs.
• Fine-tuned the Preprocessor Packages by using SQL*TRACE and TKPROF utilities.
• Designed Logical and Physical data models using ERIWN and VISIO.
• Responsible for UNIT level and Integration Level testing.
• Wrote Test Plans and Test Cases.
• Responsible for writing ETL scripts for the data warehouse.
• Worked with the DBAS to configure the Oracle 9i AS.
• Responsible for DBA activities like Performance tuning, creation of database objects, Applying Patches, user and role creation.
• Responsible for production support issues with Business Objects reports.

Environment: Oracle 9i, Forms 6/6i, Reports 6/6i, Oracle Developer Suite, Oracle Designer 2000, Erwin / Microsoft Visio, Toad, SQL Navigator, SQL*Plus, Oracle Apps 11i, SQL* Plus, Enterprise Manager, HP UX 11, Windows 2000.

Confidential

Senior Oracle Developer

Responsibilities:

• Responsible for requirement gathering.
• Responsible for writing design Document.
• Responsible for creation Data Flow Diagrams using Microsoft Visio.
• Managed a team of 3 developers to coordinate the development work.
• Extensively used PVCS version manager for Version management and creating new builds.
• Responsible for writing complex import validation scripts using SQL and PL/SQL Procedures, Packages, Functions, Cursors.
• Responsible for Writing Hierarchical Queries using START WITH CONNECT BY.
• Fine-tuned complex queries for processing millions of rows.
• Used Oracle 8is New Functional Index feature for resolving the performance issue with hierarchical queries,
• Wrote Import Validation Routines for Migrating large Volume of Data using BULK BINDS and BULK INSERTS.
• Created control files for doing initial imports from spread sheets.
• Designed complex hierarchical query forms using the new forms Hierarchical Tree Feature.
• Wrote Batch Programs to load data into the Oracle Applications 11i Interface tables.
• Designed and developed Security Forms for managing the PowerPAC users.
• Developed Custom forms with Search Blocks for querying data giving a combination of search criterion.
• Developed Custom Menus using Forms and Tool Bars.
• Wrote complex Libraries and attached them to the forms.
• Developed forms to pass dynamic where clauses across forms through user defined triggers.
• Wrote web based reports using PL/SQL Cartridges (oracle web tool kit).
• Used Java Scripts and HTML to create web reports using Oracle Web Tool Kit.
• Configured the Oracle Apps Server 9i AS for installing the PL/SQL web tool kit.
• Created some web based forms for users to enter data directly from their sites.
• Used Native Dynamic SQL “Execute Immediate” and DBMS SQL.
• Responsible for writing Stored Procedures, Triggers, Cursors, Packages using SQL and PL/SQL.
• Developed custom reports using Oracle Discoverer. Worked on both Administration Edition and User Edition.
• Created Materialized Views for resolving issues with joins in a Hierarchical Query.
• Created some complex views for some forms that were supposed to query only.
• Fine Tuned SQL Queries and PL/SQL programs.
• Used DBMS JOB to handle multi threads.

Environment: Oracle 8i, Oracle Applications 11.03/ 11i, Oracle Apps Server 9i, Forms 6i, Reports 6i, Discoverer 3.1(Administration / User Edition), Java Script / HTML, Microsoft Visio, Erwin, SUN Solaris 2.7 and Windows NT, SQL and PL/SQL, Enterprise Manager, PVCS.

Confidential

Oracle Applications Developer

Responsibilities:

• Requirements gathering, designing and documentation.
• Responsible for complex forms creation using forms 9i/6.i. / 4.5 based on complex views using Transactional Triggers on Oracle Apps 11i.
• Responsible for creating ad-hoc reports using Reports 3.0 and Reports 6i on Oracle Apps 11i.
• Included all the standard security features of Oracle Apps 11i in forms 6.x.
• Data modeling and design using Designer 6.0, Microsoft Visio 2000, and Erwin.
• Data imports from three different legacy systems into CIF system.
• Worked with D.B.As and developers to install configure and fine tune Oracle 9i Database on digital UNIX servers.
• Responsible for configuring the 9i Application Server Forms Services / Reports Services / HTTP Server.
• Writing stored procedures and packages, triggers, functions on backend Oracle 8.i., 9i using PL/SQL.
• Writing UNIX scripts for Data Migration from Legacy Systems and Running batch jobs, responsible for FTP file creation.
• Responsible for Oracle DBA activities such as capacity planning, installation, database configuration, database creation, database reorganization, space management, backup procedures, Standby Database Creation and Maintenance.
• Responsible for developing ad-hoc reports using Oracle Discoverer 3.1/4.1
• Responsible for hot and cold backups using 'RMAN'.
• Strong experience in performance tuning of various Oracle components e.g., SGA, Background Processes, Redo logs, UNDO Segments, I/O, SQL Query optimization and PL/SQL tuning and tuning of SPFILE and PFILE.
• Extensive experience with setting database and application tuning goals and using various tuning methodologies.
• Responsible for setting up End User Layer for Oracle Discoverer 4.1 using Administration Edition.
• Responsible for SQL tuning using EXPALIN PLAN, TKPROF.
• Responsible for Developing Entity Relationship Diagrams using Erwin/ Designer.
• Responsible for creation of import and validation scripts from external legacy systems into CIF.
• Ad hoc report generation using Discoverer 3.1 (Administrator Edition / User Edition).
• Creation of Custom Forms on Oracle Apps 11.0.3 and integrate them with Apps. 11.0.3.
• Responsible for creating comparison reports among 4 different legacy systems using PL/SQL and Oracle Discoverer 3.1.
• Unit and Integration Level Testing using test scripts.
• Supporting daily batch jobs.
• Performance tuning of financial report queries.
• Data Migration from Ingress to Oracle, Access to Oracle, Excel to Oracle.
• Integrating Oracle forms 4.5 with Oracle Apps 11.0.3

Environment: Oracle 8i, Oracle 9i, Oracle Applications 11.03/ 11i, Oracle Apps Server 9i, Forms 9i/6i / 4.5, Reports 3.0/6i, Oracle Apps 11.0.3 / 11i, Erwin, Designer 2000, Discoverer 3.1(Administration / User Edition), Microsoft Visio, AIX UNIX 4 and Windows NT, SQL and PL/SQL, Enterprise Manager, Toad.