SUMMARY

• 8 years of experience in IT industry with emphasis on Analysis, Design, Development, Implementation and Management of projects using Oracle (SQL, PL/SQL).
• Solid experience in translating business requirements into creation of Database Objects.
• Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects.
• Proficient in developing the Data mart in Star Schema and Snowflake Schema, Flat files and building the Data warehouse, Efficient in developing the Logical & Physical Data model, OLTP/OLAP, ER Diagrams and organizing the data as per the Business requirements
• Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS.
• Good knowledge of Performance tuning - TKProf, Query Plan, TOAD.
• Strong knowledge in reporting tools QlikView, Tableau, TIBCO Spotfire, MicroStrategy, Crystal Reports.
• Good understanding on Data Modeling.
• Possess very good knowledge of Data Warehousing concepts and strong understanding of Informatica Power Center.
• Expertise in Dynamic SQL, Records, Arrays and Exception Handling.
• Expertise in Export, Import and SQL * Loader Utilities.
• Experience in understanding complicated performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
• Well versed with version control tools - CVS, Git, Tortoise SVN.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.
• Significant experience in 24/7 Production Environment.

TECHNICAL SKILLS

Languages: PL/SQL, SQL * Plus, UNIX Shell Scripting - AWK

RDBMS: Oracle 11g/10g /9.x/8. x.

Application Server: Apache, WebLogic.

Tools: OBIEE, TOAD, SQL Developer

ETL Tools: Informatica Power Center, Cognos

Operating System: Windows 7, 8, UNIX/ Linux

BI Reporting Tools: QlikView, Tableau, TIBCO Spotfire, MicroStrategy

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Sr. PL/SQL/ Database Developer

Responsibilities:

• Managed requirement gathering, Estimation, Data Model, database scripts, functional & technical design and ETL development of integrating data into data Warehouse
• Logical and physical Data modeling and Design of the system
• Developed stored procedures and complex packages extensively using PL/SQL and shell programs.
• Developed and Created Database Objects in OLTP and OLAP Systems by Creating triggers, packages, procedures and functions using PL/SQL.
• Optimal in loading data from various Flat files using SQL* Loader and implementing Data Cleansing Procedures.
• Well Experienced in Tuning SQL queries, database objects on OLTP Systems by Creating Indexes, Optimizers, hints and analyzing the Explain Plan.
• Building Data warehouse by summarizing the Data on Yearly Granularity and Populating the Data in Star Schema and Snowflake Schema
• Maintaining and organizing the Data Warehouse Building in Hierarchical level as per the Business Rules of data management.
• Performing Performance Tuning on the SQL Queries.
• Developing the Scrips by Using UNIX Shell Scripting.
• XML file generation from database based on demand web service input, Consumer database
• Delegating the task to the Team and preparing the check list for the same.
• Participating in the daily status call with the offshore team to work in sync with the team on their understanding level by each individual item.
• Used SQL Loader to load data from flat files to the testing databases by using Oracle R12.
• Evaluated BI solutions from vendors. (OBIEE, QlikView)
• Created materialized views (snapshot) for remote instances.

Environment: Oracle 11g, SQL, PL/SQL, Informatica9.0, TOAD, PL/SQL Developer tool, UNIX Shell Scripting.

Confidential, San Francisco, CA

Sr. PL/SQL/ Database Developer

Responsibilities:

• Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions and Triggers.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24-hour production support.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Utilized SQL*Loader to load flat files into database tables.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Partitioned tables and indexes for better performance of application.
• Contacting Application Team and clients to gather the information for migration. Reviewed architecture.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Involved in handling the changes in compiling scripts according to the database changes.
• Developed reports using complex queries as per client request as a part of production support.
• Provided on call support, solved the user issues and made necessary changes.
• Resolving Production Severity Issues in time and meeting the SLA.

Environment: Oracle 11g, SQL, PL/SQL, SQL*plus, SQL*Loader, Shell Scripting, JIRA, TOAD and PL/SQL Developer tool.

Confidential, Phoenix, AZ

Programmer Analyst/PL/SQL

Responsibilities:

• Requirement gathering from Business partners and translate into software needs
• Preparing high Level and Low-level design documents.
• Involved in development of validation Program.
• Developed SQL queries, procedures, functions, packages and triggers.
• Involved in Data Analysis and reducing Data Discrepancy for the source and Target schemas.
• Oracle PL/SQL Functions, Procedures, Shell Scripts were used for staging transformation and loading of the data from flat files to target.
• Involved in writing Technical Specification Document.
• Also worked on Migration from UNIX to Linux for cloud environment, tested Linux scripts after migration.
• Developed Database Triggers to enforce security.
• Designed and Developed Automation process for Data Conversions.
• Actively involved in analyzing the old database system and mapping tables, relationships and columns.
• Support for System Integration testing and UAT.
• Participating in the daily status call with the offshore team to work in sync with the team on their understanding level by each individual item.

Environment: Oracle 11g/10g, UNIX Shell Scripting.

Confidential, Malvern, PA

Database Programmer

Responsibilities:

• Installation, Creation and support of Oracle 8i database environments.
• Involved in the maintenance and enhancement of the application.
• Maintaining Logical and Physical structure of the database.
• Creating tablespaces, tables, views, scripts for automatic operations of the database activities.
• Coded various stored procedures, packages and triggers to in corporate business logic into the application.
• Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Monitor database and system backups, developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Done thorough Design & Code review for the development work like PL/SQL program units,
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures and Worked on various backend Procedures and Functions using PL/SQL.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Developed complex SQL queries for data retrieval from various database objects including tables &views.

Environment: Oracle 8i, TOAD, PL/SQL, SQL Scripting and UNIX Shell Scripting.

Confidential

Oracle SQL and PL/SQL Developer

Responsibilities:

• Responsibilities include, interacting with the business users at the bank for gathering and managing the requirements.
• Performing gap analysis activity to understand and document the gaps between the source and the target system.
• Preparing Business Requirement Document based on the gap analysis activity for capturing the business requirement for all the missing functionality in the target system.
• Understanding all the interfaces in the source system and helping the technical team in preparation of interface & layout specification document.
• Charting out different impact analysis on the migration activity with an alternate strategy for system conversion.
• Prepared the High Level -Technical Design Document for offshore team to proceed with the Code Development.
• Review of code changes, test procedure, test plans and modification of stored procedures.
• Involved in comparing Production data with Test data for identifying and cleaning corrupted data.

Environment: Oracle 8i, SQL, PL/SQL, SQL*Loader, Toad, Windows NT/XP.