SUMMARY

• Over 8 years of extensive IT experience working with the Oracle Database as a Developer, SQL Analyst and production support specialist. Involved in system analysis, design, development and production support of OLTP applications and Data warehouse systems.
• Working knowledge of both E - R Modeling and Dimensional modeling principles, techniques and the design trade-offs for each of the systems.
• Worked with Oracle database versions 8.1.7 through 11gR2. Designed, created and maintained Database objects such as tables, Indexes, sequences, views, synonyms, MVs, DB Links and so on.
• Created and maintained Oracle PL/SQL objects such as stored procedures, functions, packages and triggers. Good working knowledge on how to effectively use PL/SQL features to build robust, efficient and secure Oracle database applications.
• Worked with large Data Warehouse environments. Implemented ETL Loads using Oracle, UNIX shell scripting. Worked with Oracle Partitions, Bulk Collect, Parallel loads, Indexes and Materialized views to ensure optimal query performance, maintainability and availability.
• Performed basic Oracle Database administration activities such as Creating users, schemas, Oracle Database objects, Physical Database planning (size estimates, table space allocation, partition maintenance) and running automated database builds.
• Worked on Oracle Database tuning using the various tools in Oracle’s performance tuning toolkit (Explain Plan, SQL Trace, DBMS PROFILER and 10053 trace file outputs).
• Hands-on knowledge of Oracle Utilities such as SQL Loader, export/import, and tools such as SQL developer and Toad for Oracle.
• Good Korn Shell scripting (KSH) experience and beginner with Python and Perl. Worked on developing automation scripts, ETL loads (using ash/Perl and Oracle), loading external partner files (using both SQL Loader and Oracle External files) and monitoring existing loads as part of support.
• Worked in multiple client-server environments involving Java, J2EE, Hibernate, Oracle ADF and other enterprise software. Aware of the issues usually faced when interacting with Oracle Database.
• Created multiple productivity applications using Oracle Application express and reduced the workload of tech teams by developing forms and reports using Oracle Apex 2.2 and 3.1.
• Worked extensively with Oracle analytic functions, during data analysis and data profiling.

TECHNICAL SKILLS

Operating Systems: Linux, WinNT, 95, 98, UNIX, Sun Solaris.

Languages: Oracle SQL, PL/SQL, UNIX KSH, Perl, C, Java, DB2, JCL, XML

Databases: Oracle 11g/10g/9i/8i, DB2, Teradata.

Tools: Oracle SQLPlus, Quest Toad, Oracle SQL Developer, ERWin, Informatica

Version Control: CVS, Bit Bucket.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Database Developer

Responsibilities:

• Prepare detailed design and technical design documents and work with project management teams and business stakeholders to make any modifications necessary.
• Work with Compliance business and reporting groups in identifying and prioritizing existing defects, new regulatory requirements and the timeframes to deploy these changes.
• Modify and enhance the reporting data model (both dimensional and transactional) for incorporating new features as per the Technical design. Review with Architecture team and in corporate their reviews.
• Create oracle database objects such as tables, views, synonyms, materialized views, partitions and PL/SQL objects such as Procedures, functions and packages to implement ETL Data flow.
• Design and implement Oracle Database indexing and partitioning strategy to process and query large volumes of Order and Trade data.
• Create and maintain Data loading scripts using UNIX KSH, Oracle SQL Loader and post-processing using Oracle SQL and PL/SQL.
• Work on end-of-day reports, ad-hoc claim activity reports, all activity reports, and automate the frequently requested reports, based on project plans.
• Performance tune reports and data load processes using Oracle PL/SQL profiler, Auto Trace, explain plan information. Make changes to Partition structure, indexes, logical and physical design, ETL/ELT logic as necessary to obtain reasonable response time for reports and throughput for load processes.

Confidential, Memphis, TN

Sr. Oracle Developer

Responsibilities:

• Analyze and document existing data models in each system, working closely with Business users and Data analysts. Document database and data warehouse tables and subject areas that need to be integrated and the impact of each of this on the final application flows and reports.
• Work with data architects and design the initial rules for feed conversion and define how the attributes in each system merge into the new integrated management system.
• Create and modify Oracle database tables and views to accommodate new attributes and changes to existing ones. Create/modify existing Oracle PL/SQL Packages, Stored Procedures, Functions and other Database objects to accommodate for Conversion Rules.
• Develop new processes to load data from each property to the new system as part of the property conversion. This is done primarily using Oracle SQL scripts, PL/SQL Packages, Database Links and Oracle Golden Gate replication software.
• Work with Database maintenance team to deploy all database changes including DDLs, one-off ETLs, and Partition maintenance scripts to QA, Stage and Production environments.
• Extensively used Oracle database partitions for optimal load speeds by using partition exchange and parallel loads, thereby implementing a ELT approach.
• Develop UNIX shell scripts (Korn Shell) to automate various tasks including Database partition creation, post-audit activities and trigger files.
• Tune database code based on the information from log files and bug reports. Built initial test cases and then use Oracle EXPLAIN PLAN, SQL Trace, TKProf and DBMS PROFILER as necessary to do root-cause analysis and come up with the appropriate solution.
• Work on various production support issues, typically related to data integrity, data consistency, application performance and tuning load time for a wide variety of loading processes.

Confidential

Software Engineer

Responsibilities:

• Develop and maintain ~200 reports for multiple telecom clients using Oracle Database 9i, IBM Mainframe OS 390, COBOL, JCL, CICS and Teradata.
• Prepare technical design documents, detailed design documents, unit and system test cases and test scripts for automated loads.
• Schedule ETL processes using IBM's Job Control Language (JCL) and monitored the output files and logs for data errors and data quality.
• Work on developing complex reports using Teradata SQL using large tables (in TBs) taking into consideration important factors such as join Orders, access paths and indexes.
• Make recommendations and changes to the existing ETL and business processes to reduce load and process times. Involved in SQL optimizations for Teradata SQL to reduce the report generation time, thereby increasing availability of the reports to business.
• Monitoring production systems, scheduling automatic alerts (based on log files) on errors and fixing issues as part of the production support team as and when required.
• Document business knowledge of Telecom billing and transaction systems and various reporting issues when working with large data warehouse tables.
• Maintain Teradata data warehouse system which generates the data for reporting.
• Production support, Bug fixes, Release and Deployment.

Confidential

SQL Analyst

Responsibilities:

• Work with business users and development leads to analyze, understand and document existing systems and Data.
• Prepare MDR documents and Database Design documents and review it with the Architecture team.
• Develop and modified PL/SQL objects such as Packages, Procedures, functions, triggers to retrieve data from the new centralized ODS.
• Create external tables based on flat files and use them to load data into the final target tables.
• Create and modify UNIX shell scripts (and SQL Loader control files) that load data from other systems into Chase schemas, for operational reporting.
• Performance tuning procedures/Queries (taking more than expected times) using Oracle DBMS PROFILER, SQL Trace and DBMS XPLAN.
• Develop UNIX shell scripts (ksh) to implement event wait-like functionality to wait on load status table entries instead of an event wait file. (for Informatica - based workflows)
• Made use of PL/SQL functions such as Bulk Collect and SQL constructs such as append hints, parallel loads to implement faster loads to meet data load SLAs in place.
• Troubleshoot and fix any production support issues.
• Tune long running jobs using job run logs and historical times.