Analyst Resume
2.00/5 (Submit Your Rating)
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