PROFESSIONAL SUMMARY:

• Around 8 years of total experience as SQL Design, Development, Enhancement and Maintenance of OLAP & OLTP applications using various RDBMS databases, Integration (ETL) & Reporting tools
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance wif timely delivery against aggressive deadlines.
• Expertise wifData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADand SQL*LOADER.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions and Materialized Views.
• Strong experience inData warehouse concepts, ETL.
• Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• CreatedTables, Views, Constraints, Index(B Tree, Bitmap and Function Based).
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developedmaterialized viewsfor data replication in distributed environments.
• Knowledge of Oracle BI (Business Intelligence) reports wif OBIEE 11g.
• Expert in writing Stored Procedures, Functions, Database Triggers and Packages using PL/SQL.
• Enforcing data integrity using integrity constraints & database triggers.
• Experienced in SQL*Loader, Export, Import and SQL*Plus.
• Skillful in Database development skills using SQL, SQL*LOADER, PL/SQL.
• Enforcing security by creating roles, granting system and object privileges on teh tables, stored procedures.
• Fair understanding & working knowledge in UNIX - Shell Scripts.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Work let, Control).
• Domain experience: Telecommunications, Healthcare, Banking, Insurance and Retail Industries.
• Excellent communication, interpersonal skills wif user, analytical skills, good team player and client interaction experience.

TECHNICAL SKILLS:

Databases: Oracle Exadata /11g/10g/9i, MS SQL Server 7.0/2008/200, My SQL, MS-Access.

SQL Server Tools: Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Enterprise Manager, Query Analyzer, SQL Profiler, Performance Monitor, Database Tuning Wizard.

BI Tools: Micro Strategy 9.4.1/9.3.1,SSRS, SSAS, Microsoft SQL Server Analysis Services, Business Objects.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Informatica 8.X.

Operating Systems: Windows Server 2012/2008/2000/2003, Linux, Windows XP/2000/98/NT.

Programming Languages: C, C++, T-SQL, PL-SQL, MySQL, Python scripting

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimension Tables, Physical and Logical Data Modeling, Erwin 7.1.3, MS-Visio.

TECHNICAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. Oracle developer

Responsibilities:

• Involved in preparing BRD, functional document, user document, process flow diagram and flow charts.
• Data migration utilizing Oracle utilities:SQL*Loader.and conversion done
• Developed teh logical data model and physical data model for teh Oracle database.
• Created tables, table spaces, schemas, views, packages, stored procedures, triggers, functions etc using TOAD tool.
• Created procedures and functions to implement business requirements.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Developed Database Triggers for audit and validation purpose.
• Created programming code using advanced concepts of Records, Collections
• Worked wif Bulk Collects to improve teh performance of multi-row queries.
• Handled errors using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Filtered and Loaded data from different formats of data sources into Database Tables
• Wrote shell scripts in Crontab to automate Backend Jobs.
• Partitioned tables based on data using LIST partitioning, Range Partitioning.
• Created indexes for faster retrieval and improved query performance.
• Used FTP to transfer teh files into different servers as per needed by teh business users.
• Involved in teh optimization of Oracle queries/scripts which resulted in substantial performance improvement for teh conversion processes using Oracle Hints, Explain Plans and Trace Sessions.
• Developed, modified, and optimized complex queries for data retrieval and modification.

Environment: ORACLE 9i/10g,SQL*Plus, PL/SQL,SQL*Loader, TOAD, JDBC,Sql* Loader, Unix Shell Scripting, Java.

Confidential, IL

Sr. Oracle Developer

Responsibilities:

• Exposure to all stages of Software Development Life Cycle.
• Involved in Performing analysis of existing system’s efficiency and suggesting improvements.
• Made necessary changes to existing Database Objects and added new whenever required.
• Managed performance and tuning of SQL queries and fixed teh slow running queries in production wif utilities like Explain plan
• Performed Dimensional Data modeling and created Star Schema and Snow Flakes Schema data model to meet teh OLAP needs.
• Worked wif teh Data Warehouse Architect to perform source system analysis and identification of key data issues via analysis of teh data profiling results and queries
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Used sorter transformation and newly changed dynamic lookup.
• Created events and tasks in teh work flows using workflow manager.
• Developed Informatica mappings and also tuned them for better performance wif PL/SQL Procedures/Functions to build business rules to load data.
• Created a Prototype data warehouse and provided teh OLAP front end to show teh Drill Down, Roll ups, Pivoting, Slice and Dice features.
• Developed Reports / Dashboards wif different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, wif global and local filters) using Oracle BI Presentation Services.
• Implemented Slowly Changing Dimensions (SCD, Both Type 1 & 2).
• Determined teh data sources, and imported teh source tables into teh physical layer using connection pool object and populated teh metadata into schema object.
• Monitored teh Prod Tickets, Change Control tickets throughJIRAsystem.
• Troubleshooting and resolving issues in various aspects of teh post production support.
• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
• Checked teh data for data cleansing purpose (for data consistency).
• Used TOAD for faster application design and developments.
• Experienced in application testing to make sure dat all teh functionality is implemented for each of teh module.
• Involved in teh preparation & planning of incident, risk and change management procedural.
• Documentation for clients.
• Understanding and troubleshooting complex customer issues on production environment.
• Responsible for identifying any bugs occurring in teh applications as well as fixing them.
• Critical Situation Analyst: Defused hot situations and got quick technical resolution. Identify teh issue and either resolve or escalate to teh appropriate team responsible for teh components affected.

Environment:Oracle 11g PL/SQL, SQL Developer, PL/SQL Developer, Toad, .Net, TFS, OBIEE 11G

Confidential, Lansing, MI

Oracle Developer

Responsibilities:

• Coordinated wif teh front end design team to provide them wif teh necessary stored procedures and packages and teh necessary insight into teh data.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Created and modified severalUNIX shell Scriptsaccording to teh changing needs of teh project and client requirements.
• Wrote Unix Shell Scripts to process teh files on daily basis like renaming teh file, extracting date from teh file, unzipping teh file and remove teh junk characters from teh file before loading them into teh base tables.
• Involved in teh continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving teh data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in teh application using TOAD.
• Createdindexes on teh tables for faster retrieval of teh data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Extensively involved in usinghints to direct teh optimizerto choose an optimumquery execution plan.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• CreatedPL/SQL scriptsto extract teh data from teh operational database into simple flat text files usingUTL FILEpackage.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Partitionedthe fact tables andmaterialized viewsto enhance teh performance.
• Extensively usedbulk collectionin PL/SQL objects for improving teh performing.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Confidential

PL/SQL Developer

Responsibilities:

• Involved in full development cycle ofPlanning, Analysis, Design, Development, TestingandImplementation.
• Designed logical and physical data models for star and snowflake schemas usingErwin.
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign keyconstraints in data conversions.
• Created and modifiedSQL*Plus, PL/SQLandSQL*Loader scriptsfor data conversions.
• UpgradedOracle 9i to 10gsoftware in different environments for latest features and also tested databases.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Worked onXMLalong wif PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyzeDependencies.
• Creatingindexeson tables to improve teh performance by eliminating teh full table scans and views for hiding teh actual tables and to eliminate teh complexity of teh large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases usingOracle Hints, for Rule based optimization.
• UsedDiscoverer 2000to provide end users easy access to data and halp in data analysis.
• Created some Custom reports and Forms for teh end users to check teh details and errors.

Environment: Oracle 9i, 10g, SQL*Plus, PL/SQL, Erwin 4.1, Oracle Designer 2000,Windows 2000, Toad.