We provide IT Staff Augmentation Services!

Analyst Resume

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

Hire Now