SUMMARY:

• Data Analyst/Oracle developer with 12+ years of experience of leading & delivering software projects. I am having strong technical background of software development using oracle, pl/sql and informatica. I have exposure working on data analysis using various reporting tools. Committed to professionalism, able to see the big picture while paying attention to small details, and excellent communication skills.
• Expert in leading both development and support projects using Oracle and PL/SQL.
• Worked on both OLTP and data warehousing projects.
• Worked on Data Modeling in various projects.
• Worked on performance tuning the database by using xplans, gather stats etc. to tune long running queries in database.
• Worked on partition exchange to update billions of rows of data.
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views and Query Re - Write.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Creating UTPL SQL for unit testing the code and to follow test driven development approach.
• Set and continually manage project expectations with team members and other stakeholders.
• Strong documentation and project adherence to industry quality standards and reporting skills.
• Excellent interpersonal, collaboration, and problem solving skills.
• Strong understanding of SDLC.

TECHNICAL SKILLS:

Database: - Oracle 10g, 11g, 12c

ETL Tool: - Informatica

Languages: - SQL, PL/SQL

Unit Test tool: UTPLSQL

Version control tools: GIT Stash, SVN, Clear Case etc.

Build & Release tool: - Jenkins and HUDSON

PROFESSIONAL EXPERIENCE:

Confidential, NC

Database consultant

Responsibilities:

• Interacting with product owners/SMEs to understand requirements.
• Coding for the requirements which require deep understanding of oracle, pl/sql.
• Improvise the old code while modifying it using new features of oracle.
• Working with Procedures/packages using bulk collect feature for better performance.
• Working with collections - associate arrays, nested tables and varrays.
• Working with dynamic SQL features using execute immediate.
• Working with materialized views to improve performance.
• Partition large tables using range partitioning to improve performance/availability.
• CreatedPackagesandProceduresto automatically drop table indexes and create indexes for the tables.
• Tuning the long running jobs which require looking into the old table structures and modify them using partitioning/indexes etc.
• Unit testing of the code using UT PLSQL.
• Create data visualization reports and dashboards using Tableau to help business understand the data to make inferences, see trends and forecasting.
• Build and install process using Stash and Jenkins.
• Working on the CI-CD approach and helping team members to learn and implement the same.

Tools: Control-M, UNIX, JIRA, Stash, Jenkins, UT PLSQL, Tableau

Confidential

Senior Associate

Responsibilities:

• Interacting with client to gather requirements.
• Working on data modelling for new piece of requirements.
• Coding the framework and working on oracle packages/procedures, pl/sql collections.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

Confidential, NC

Responsibilities:

• The project used informatica for Master Data Management which helps creating one common Master data file having all the critical business related information (both data and analytical data). Data from this file can be loaded in different tables in database to differentiate data from analytical data which is used by end users for making business decisions.

Confidential, MA

Responsibilities:

• It is a data warehousing project for research team in which we migrated from 5 point rating to 6 point rating for clients. Client used to do their research for selling or buying the stocks based on 5 point rating whether it is a strong buy/sell, weak buy/sell or hold kind of stock. Now the rating will be changed to 6 Points so as to make the research better and more accurate.

Confidential

Senior System Analyst

Responsibilities:

• I was working as Project Lead in the project. I was responsible for HLL design and creation of tech specs.

Confidential

Software Engineer

Responsibilities:

• Worked as Software Engineer on the GMAC Canada project. Involved in Knowledge Acquisition Process (KAP) and development and support of the project.

Confidential

Software Engineer

Responsibilities:

• Worked as software engineer for the project of GMAC Thailand and GMAC China. Involved in Analysis, Design, Coding and Unit Testing. Fully familiar with complete SDLC cycle and quality processes.

Confidential

Software Developer / Programmer

Responsibilities:

• Member of the technical team for Development & Implementation also involved in the final testing and Implementation of the developed modules. Responsible for the periodical Backups. Continuous interactions with the end users so as to make the system more users friendly.