SUMMARY:

• Over 8 years experience of Database Development experience using various RDMS databases including Oracle 11g/12c and SQL Server 2008/2012.
• Strong Experience in designing and developing database objects: Tables, Views, Indexed/Materialized views, Indexes, PL/SQL Packages, Functions, Stored Procedures, and Triggers in both Oracle and SQL Server
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Collections, Nested Tables, VARRAYS, Records, Types, and Dynamic SQL and Analytical functions.
• Strong knowledge in Oracle Cursor management, Exception Handling, REF Cursors.
• Good Knowledge in Relational Data Modeling.
• Expertise in using tools such as TOAD, SQL developer, PL/SQL developer and SSMS.
• Knowledge of working with the Oracle Application server for the Forms and Reports application in various projects.
• Extensively worked on PL/SQL features like Forms, Triggers, Data blocks, Report Layout, Parameter forms, Report Triggers.
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization techniques.
• Experience with database query optimization and performance tuning using Explain Plan, Execution plan, SQL - Trace, TK-Prof oracle utilities and creating relevant system and user’s documentation.
• Strong working experience in use of SDLC methodologies, standards and Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources into dimensions and facts.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6/7/8.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, T-SQL, C++, HTML, JavaScript, XML, JAVA, ProC, C#

Databases: Oracle 12c/1 1g/1 0g/9i/8i, SQL Server 20, MySQL, IBM DB2

Database Tools /Utilities: SQL*Plus, SQL developer, TOAD 9.1/8.5/8.0/7.1, PL/SQL Developer, SQL Navigator, VSS, Autosys Discover 2000, Erwin, winSCP

ETL Tools: SQL*Loader, UTL FILE, InformaticaPowerCenter 9.1/9.5, SAP Data Integrator

GUI: Visual Studio.NET, Visual Basic 6.0, Forms 9i/10g, Reports 9i/10g,Crystal Reports, JAVA, OBIEE

Designing/Other Tool: MS-Office suite

Operating Systems: Windows 95/98/2000/NT/XP/Vista/7, UNIX( Linux )

Version Control Tools:: MS Visual Source Safe (VSS), PVCS, Clear Case, Clear Quest

PROFESSIONAL EXPERIENCE:

Confidential, GA

Sr. Database Developer

Responsibilities:

• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Extensively used Erwin data modeler in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Work with HPCC big data platform to provide input data.
• Involved closely in transforming data and developing internal ad hoc packages to standardize names, address and assign LexID to individuals.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Involved in table redesigning with implementation of Table Partitions and Partition Indexes to make Database Faster and easier to maintain.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Worked on ODI Designer for designing the interfaces, defining the data stores, interfaces and packages, modify the ODI Knowledge Modules (Reverse Engineering, Journalizing, Loading, Check, Integration, Service) to create interfaces to cleanse, Load and transform the Data from Sources to Target databases, created mappings and configured multiple agents as per specific project requirements.
• Created ODI Packages, Jobs of various complexities and automated process data flow.
• Implemented advanced visualizations in Roxie and Esp.
• Worked with python for data analysis.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.

Environment: Oracle12c, Toad, SQL*Plus, HPCC, ROXIE, ODIEE, SQL, PL/SQL, ECL, Python, UNIX

Confidential, CA

Sr. Database Developer

Responsibilities:

• Analyzed requirements, designed, developed, deployed and documented software components.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.
• Developed the SQL*Loader script, and most of PL/SQL stored procedures, Triggers, and views to handle the Online and Batch processes.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in creating INDEXES to avoid the need for large - table, full-table scans and for fast retrieval of data from database objects.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Designed, developed and tested various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
• Developed Shell scripts to compare data between multiple data sources.
• Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
• Involved in Migrating of data Base server from Oracle 11g to 12c.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Fixing bugs according to the software change requirement.
• Developed test plan documents for all back-end database modules.

Environment: Oracle 12c/11g, SQL*Loader, Oracle SQL Developer, Informatica 9.1, and Unix Shell Scripting, SQL Navigator, Oracle Forms and Reports 12c and Toad.

Confidential, NY

Oracle PL/SQL Developer

Responsibilities:

• Gathered business requirements to facilitate the planning and implementation of OLAP system.
• Used Toad data modeler for creating the data model and for validating designs.
• Maintained referential integrity, domain integrity and column integrity by utilizing constraints.
• Implemented error handing using Try Catch blocks to create robust T-SQL code.
• Utilized dynamic SQL, temporary tables and table variables for user customizable queries to be answered by the OLTP/OLAP Server.
• Worked with Dynamic Management Views for implementing/dropping Indexes and recognizing poorly performing stored procedures.
• Used performance tuning utilities like Execution Plans, SQL Trace and SQL Profilerto improve the performance by reducing the reads of queries on the database.
• Developed Complex SQL queries using various Joins, Sub-Queries, Window Functions and developed various dynamic SQL’s thorough out the projects.
• Created packages with multiple transformations to cleanse data and apply business rules.
• Implemented a master-child package environment to manage large ETL projects efficiently.
• Utilized advanced features of SSIS such as Event Handlers, Loggings, Breakpoints and Data Viewers for effective debugging of packages per business requirements.
• Automated the ETL process with SSIS package execution schedules utilizing jobs.
• Created design specification documents for the new reports developed through SSRS.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Formulated Tabular Matrix reports, Charts and graphs as per customer requirements using SSRS.
• Implemented TFS for BI application and SQL code source control.

Environment: SQL Server 2012, T-SQL, SSMS, MS Excel, Erwin, SSIS, SSRS, TFS, SQL Profiler, Power BI

Confidential, Albany, NY

SQL Server Database Developer

Responsibilities:

• Created Stored Procedures, Triggers, Functions, Indexes, Views, Joins and T-SQL code for applications.
• Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files and load data into destination databases for further Data Analysis and Reporting.
• Experience in using multiple data flow transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.
• Scheduled and executed SSIS Packages using SQL Server Agent.
• Assisting in SQL Server optimization including indexing and query optimization.
• Introduced Maintenance plans to keep the database server in a healthy state.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Implemented error handling in stored procedures for graceful exit from stored procedure execution.
• Used Service Broker for invoking long running stored procedures asynchronously which in turn helped complete a mission critical process in a stipulated time frame.

Environment: SQL Server 2012, T-SQL, SSMS, MS Excel, MS Visio, SSIS, SSRS, Power BI, SharePoint, Perforce, SQL Profiler.

Confidential

PL/SQL Developer

Responsibilities:

• Designed and developed the interface program to Import item master using SQL*Loader, PL/SQL package and Import through Concurrent program.
• Developed Entity Relationship diagrams/Dimensional Diagrams for business requirements using ERWIN.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Extensive experience in writing and modifying SQL*LOADER, PL/SQL codes including Packages, Materialize Views, Nested tables, Triggers, and Functions.
• Created Database triggers and wrote database triggers to avoid mutation of tables.
• Developed ODI interfaces, packages, variables, procedures and scenarios to load data.
• Developed OLAP reports writing complex SQL scripts, PL/SQL packages, procedures, functions for Business Objects reports on the operating system Unix and Windows2008/2012.
• Written queries using aggregate functions, joins, sub-queries, etc.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Understanding the Requirements and performing the development scope analysis.
• Development of the customizations using PowerBuilder 12.0 as front end, and Oracle 11g as backend databases.
• Coordinated between management, users and technical teams for Requirement gathering.
• Involved in various activities like preparation of Technical Documentation, Client discussions for purposed solution and User Acceptance Testing.
• Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Developed Reports using complex queries as per client request as a part of production support.

Environment: Oracle 10g, SQL*Plus, MS Access, UNIX, PowerBuilder 12.0, Oracle SQL Developer, SQL*Loader