SUMMARY:

• PL/SQL developer with over 10 years of experience in Development, Maintenance and Enhancement of various projects using Oracle PL/SQL,
• Proficient in SQL, PL/SQL coding including DDL, DML and fine tuning those queries for better performance.
• Strong experience in Oracle PL/SQL - Cursors, Procedures, Functions, Packages, and Triggers.
• Proficient in Database Performance Tuning, Performance Monitoring and Query Optimization using Oracle Hints and Table partitioning.
• Multicast, Union All, Merge Join, Merge and Slowly Changing dimension to load data into SQL Server destination Proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, sort, data Conversion,
• Designed, developed and went live after migrating several MS Access & SQL Server databases for corporate developers, resolving typical database issues.
• Strong experience with SQL Server and T-SQL in constructing stored procedures, DDL /DML triggers, tables, user functions, joins, views, indexes, user profiles, relational database models, data dictionaries, exceptional handling, and data integrity.
• Experience in using export and import utilities.
• Knowledge of DBA activities such as Performance Tuning, Backup and Recovery.
• Experience in writing UNIX, Perl, Python, Shell scripts.
• Efficient in creating Sub-Queries and Joins for complex queries linking multiple tables and Exception Handlers.
• Experience in a fast-paced Agile Development Environment including Extreme Programming.
• Experience in writing SQL Queries for pulling large volume of records from Facts and claims database using stored procedures, and Extraction, Transformation, and Loading (ETL) process using SSIS.
• Excellent problem solving, multitasking, business analytical and critical thinking with the ability to work on fast based environment.

TECHNICAL SKILLS:

Operating System(s): Windows 2000/XP/Vista/Windows 7, Macintosh OS, Linux

Programming Languages: PL/SQL, Perl, Python

Software/Databases: MS SQL Server /7.0, Oracle 9i,10g and 11g

Version Control: Visual SourceSafe (VSS) and GIT

IDE & BI Tools: MS Visual Studio 2003/2005/2008, PL-SQL, Tableau

Domain Knowledge: Advertising and Marketing

PROFESSIONAL EXPERIENCE:

Sr Data Analyst,

Confidential, Norwalk, CT

Responsibilities:

• Managed 3 data analysts and also mentored them. Assign the tasks to the team and also monitor them on daily basis by conducting the team meetings. Initiated and organized knowledge sharing/transfer sessions with the team.
• Migrated data processing from Oracle database to Azure Data warehouse and from PL/SQL to SQL Server.
• Developed a functional strategy to perform ETL activities on large data files for onboarding to Demand Side Platforms including LiveRamp for segment distribution to external partners (LiveRamp Data Store and other DMPs).
• Update procedures, functions, DB triggers, and packages based on the change requests.
• Assisted DBA in export/import of database objects.
• Created materialized views and partition tables.
• Involved with DBA in creating schema and related privileges and roles.
• Involved in data migration from Oracle 9i to 10g.
• Analyzed tables and indexes for performance.
• Extensively used SQL*LOADER to load data from flat files obtained from various facilities every day.
• Created materialized views and partition tables.
• Created some test tables and also Provided test data to the QA team for performing testing.
• Wrote complex SQL queries using joins and correlated sub queries.
• Involved in writing UNIX and Python scripts to automate repetitive database processes.
• Created stored procedures to process the data, and temporary tables as back up for transaction failures.
• Created dashboards to replace existing reports with dynamic visualization using Tableau.
• Created Datasets, Data Frames. Implemented Automation, actions, data visualization, and Web Scraping using Python.
• Interpret results and deliver insights in PowerPoint and Excel presentations for client and executive communication, review and

Environment: Oracle 9i,10g,11, SQL*LOADER, UNIX, Python, Shell scripting, PL/SQL, Pearl Scripts, Tableau, MS Excel, MS Powerpoint, tableau

Project Analyst

Confidential

Responsibilities:

• Extensively used ETL processes to load data from various source systems such as Oracle, SQL Server and Flat Files, XML files into target system by applying business logic on transformation mapping for inserting and updating records.
• Created complex mappings to load the data and provide support. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.
• Maintained the target database in the production and testing environments.
• Supported migration of ETL code from development to QA and QA to production.
• Implemented slowly changing dimensions to maintain current and historical information in dimension tables.

Environment: Oracle 9i,10g,11, SQL*LOADER, XML, SQL Server, Shell scripting, PL/SQL, Pearl Scripts, Tableau, MS Excel, MS Powerpoint

Confidential,

Responsibilities:

• Analyzed tables and indexes for performance.
• Rebuild Indexes.
• Created and used Table Partitions to improve performance of the tables containing large number of columns and rows.
• Understand the business logic and modify existing SQL Code and do Performance Tuning if required.
• Tuned SQL queries using EXPLAIN PLAN and HINTS for better performance.
• Extensively used SQL*LOADER to load data from flat files obtained from various facilities every day.
• Involved in writing procedures, functions, DB triggers, and packages for new requirements.

Environment: Oracle 9i,10g,11, SQL*LOADER, XML, SQL Server, MS Excel, MS Powerpoint

Confidential,

Responsibilities:

• Created PLSQL queries based on the ad-hoc requirements by client and reported the output to the client.
• Tuned the SQL queries using Explain Plan and Indexes.
• Designed and developed a custom database (Tables, Views, Functions, Procedures, Packages)
• Analyzed tables and rebuilt indexes to fine tune the queries.
• Understand the business logic to modify existing SQL Code and do Performance Tuning if required.
• Tuned SQL queries using EXPLAIN PLAN and HINTS for better performance.

Environment: Oracle 9i,10g,11, PL SQL, MS Excel, MS powerpoint