TECHNICAL SKILLS

Programming languages: PL/SQL, SAS base programming, Unix shell scripting, HiveQL (basic)

Database: Oracle 11g, Oracle 10g, SQL Server 2008, Teradata, MySQL |

Architecture: Oracle 11g, Hadoop, Hive

Data Modeling: C A ErWin Data Modeler, star schema, snowflake schema, Kimball, Inmon, ETL

ETL & BI Tools: SQL Developer, TOAD, SSIS, Informatica 9.6, Tableau, Excel, SAS Base, SAS E - Miner, MS Visio

Domain: Supply chain, banking, healthcare |

Other: SQL Loader, Data pump, backup, recovery, SDL C, Agile

PROFESSIONAL EXPERIENCE

Confidential

Analyst

Responsibilities:

• Performed functional database testing and validated the output against business requirements and data models
• Analyzed and prepared test data & environment requirements, followed up with the respective teams

Confidential

Software Engineer

Responsibilities:

• Traveled onsite to client location in Sweden, to lead complex changes on large database for implementing a common data exchange model across the enterprise, acted as single point of contact for a critical application
• Coded using advanced SQL - stored procedures, functions, packages, triggers, indexes, dynamic SQL, cursors, DML, DDL to implement business logics and process bulk data on Oracle 11g and 10g database
• Optimized reports by 60% - performance tuning of SQL queries using EXPLAIN PLAN, index, hints, gathering stats
• Provided L2 monitoring governance - 24x7 production support for critical incidents, and post release support
• Trained incident management team on key issues, created knowledge database - reduced SLA violation by 70%
• Drove 40% decrease in completion time of recurrent data deployment activity - millions of rows per table - planning, SQL tuning, data forwarding strategy, avoid crashing of B2B servers - reduced maintenance cost
• Documented HLD, LLD for database changes on Oracle 11g, modified existing database architecture document
• Translated business requirements to 3NF normalized database - conceptual, logical, physical data models
• Implemented data management policies - naming standards, data dictionary, metadata management with ErWin
• Built generic SQL code as value add for Quality Assurance team - lowered testing errors in regression test by 80%
• Performed root cause analysis for recurrent incident - problem with purchase order cost reflected in few records – solved through re-sequencing jobs to maintain data integrity across enterprise – reduced operational cost
• Analyzed business requirements, test conditions to perform and document unit testing on database changes
• Earned numerous award, appraisals – Star Performer 2011, O2 League 2012, Live Wire Performer Q1 2012