SUMMARY:

• 9 years of full software development in Oracle RDBMS, PL/SQL development, database performance tuning, and Data modeling.

TECHNICAL SKILLS:

RDBMS: ORACLE 11G, ORACLE 10G, ORACLE 9i, Oracle Exadata.

PROGRAMMING LANGUAGES: PL/SQL, SQL, Hadoop MR, MySQL, Java 7, Perl, Unix shell script.

OPERATING SYSTEMS: Sun Solaris 8, HP - UX 10, IBM-AIX, RHEL 5.

TOOLS: Quest TOAD, Eclipse IDE, Informatica PowerCenter, Er-Win Data Modeler, SQL* PLUS, SQL Loader, Remedy, Clearcase.

PROFESSIONAL EXPERIENCE:

Confidential, Concord, CA

Sr. Applications Analyst

Responsibilities:

• Developed PL SQL/packages for data loading, ETL, database design, data correction routines, installed hot patches from vendors, baseline and performance testing for PG&E SmartMeter 5 Million electric and 5 Million gas customer meter readings and re-mediate/generate meter usage.
• Performance tuning of SQL statements by using AWR reports, explain plan.
• Used partitioning, materialized views, table functions, and Oracle hints to improve data processing.
• Developed Unix shell scripts for automation.

Lead/Sr. Oracle Developer

Responsibilities:

• Developed high volume scalable custom PL/SQL custom packages to extract and load billions of rows (~50 TB) from raw data/XML files into raw tables and aggregating into production tables on Oracle 11G RAC for measuring Verizon Wireless LTE network performance and calculating key performance indicator (KPI).
• Used Oracle partitioning logic, partition pruning to load from raw tables to staging tables.
• Increased database performance by optimizing database backend code, using materialized views, using partitioning, compression, updating statistics, AWR reports, ASH reports, and DBMS Scheduler. Developed core Java scripts, Developed Unix shell scripts for calling scripts in cron, developed Oracle expdp/impdp scripts for schema DDL for new schema deployments.
• Provided method of procedures (MOP) for deploying database changes to production and worked closely with production support/cross functional teams to debug business issues and develop root cause resolution.
• Identified functional requirements and translated into PL/SQL code and created unit test for each test scenarios.
• Maintained code base for multiple platforms including Verizon Terremark cloud infrastructure and LTE, CDMA applications installed nationwide. Working knowledge of Big data Hadoop stack and used Pig, Hive and Hbase to analyze LTE switch data.

Sr. Oracle-Java Developer

Responsibilities:

• Developed PL/SQL procedures for updating medical lookup data NDC, ICD-9 codes, NPI, Zip code, Bill Code. Developed Unix shell scripts for automating the process.
• Developed PL/SQL ETL scripts, Data model, table partitions, exchange partition scripts, tables indexes and scripts for performance improvements for batch jobs. Developed Java-JDBC to auto update new medical codes.

Assoc Manager Engineering Support

Responsibilities:

• Production support for Order Management Systems and Finance application for Confidential .
• Confidential global ecommerce application. Maintained or exceeded production SLA for trouble tickets from business and triage production issues by identifying existing processes and PL/SQL and Java application for various ordering channels available for customers in Confidential .
• Confidential site. Recommend specific alarms and monitors to business to avoid issues and development of dashboards in PL/SQL for recurring database cleanup.
• Participate in emergency bug fixes and develop SQL, PL/SQL for data cleanup.

Sr. Oracle Developer

Responsibilities:

• Developed PL/SQL packages, procedures, indexes, table partition for Confidential Business Direct (BD) Datawarehouse application.
• Re-engineer existing sql code and converted into Oracle PL/SQL packages/procedures, SQL statements tuning, data load using sql loader.
• Developed Unix shell scripts to call SQL sessions and sql loader sessions. Develop Functional system document, Technical design document and associated data model for HAMP functionality in Bank Collection application.

Sr. Developer

Responsibilities:

• Created PL/SQL packages, procedures, functions, triggers for retail supply chain areas of Pricing, Costing, Stock Ledger, Inventory, Promotion and Order Management.
• Developed applications for supply chain for Retail Ver 10 using Oracle RDBMS 10G R2, 9i R2, Java, JDBC, Informatica ETL, Crystal reports, Unix shell scripting and Pro C.
• Created physical data models and implemented physical database schema and scripts to create database objects. Knowledge of data warehouse architecture and data marts.
• Analyzed data inconsistency and performed corporate wide data cleanup using SQL, PL/SQL. Analyzed and tuned SQL for optimal run using Oracle hints, Materialized views, Table partitioning, parallel queries, Bulk DML loading/retrieval and using Oracle trace.
• Analyzed batch process and batch integration and be a subject matter expert in certain areas to help defect tracking and triage issues for answering internal and external customer quires.
• Supported and executed tasks during a major application roll-out and major enhancements. Created scripts for database DDL, DML related changes and diagnosed database issues after application upgrades.
• Created and modified batch schedules in BMC Control-M by managing job dependencies, timing, exit condition for hourly, daily, monthly, half-yearly, yearly schedules.
• Tier two 24/7 production support for enterprise supply chain applications for merchandize ordering, allocation, promotion, pricing, forecasting and inventory system.