Professional Snapshot

• A senior database developer with over 8 years of experience in Development, Data Warehouse Design, Architecture and experience in interface/conversion/data migration in client/server and OLAP/OLTP environments
• An Oracle Developer and Architect with extensive experience in Data Transformations, Data Loading, Database Modeling and Performance Tuning
• Have in-depth knowledge in Data analysis, Data warehousing and ETL techniques, Business Objects, Unix Shell Scripting, SQL/PLSQL scripts, Windows Batch Scripting, ODBC, C, C++ and SAS Programming
• Extensively Worked on Packages, Procedures, Functions, Views, cursors, ref cursors, table functions and Triggers in Oracle PL/SQL 8i/9i/10g/11g
• Experience in working with high volume data and Performance Tuning using various types of Hints, Partitioning and Indexes
• Experienced in Partitioning Administration. Creating and Managing Partitioned Tables and Indexes
• Involved in managing and maintaining critical Database, Interface and Web servers that run the system
• Involved in real-time support by simulating the user’s work to handle production issues
• Involved in entire life cycle of the project. Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes
• Worked extensively with Starteam and PVCS, used for release code base repository and version control
• Played a core role as a release coordinator and change management lead during release deployments
• Worked extensively with Windows batch programming and Unix Shell scripts to write maintenance script for Oracle for script automation
• Experienced in ETL development and Data Migration using native tools of Oracle (SQL Loader, PL/SQL)
• Hands-on experience with ETL processes including Data migration, validation and cleansing using IBM Datastage and Ab Initio
• Familiarity with Oracle data warehousing features such materialized views, bitmap indexes, Index Organized Tables, external tables etc
• Worked extensively with Dimensional Modeling (Data Marts, Facts and Dimensions), Data modeling and Design and ER Diagrams. Worked on Star and Snowflake schema
• Excellent analytical skills, logical reasoning, interpersonal skills and attitude to lead
• Excellent communications skills, fast & enthusiastic learner, excellent work ethics and a good team player
• Strong management, administrative and leadership skills to work in a team

Databases: Oracle 8i/9i/10g/11g, Sybase, MS Access, MySql, SAS, MS SQL Server
Scripting: SQL, PL/SQL, Unix Shell Scripting, SAS Programming, Windows Batch Scripting, Perl Scripting, XML
Languages: SQL, PL/SQL, C, C++, Visual Basic, Microsoft .NET
Reporting Tool: Business Objects XI 3.1, Oracle Forms 9i, Oracle Reports 9i
ETL Tools: Ab-Initio, IBM Datastage 8.0.1, SQL Loader
Query Tools: Toad, SQL Plus, SQL Navigator, Aqua Data, SAS, SQL Developer, PL/SQL Developer
Operating Systems: Windows NT/2000/XP/2003/Vista/2008 Professional/7, Apple Mackintosh, HPUX, Solaris 7.0/8.0, UNIX, LINUX, IBM Mainframe
Communication Tools: MS-Outlook, IBM Lotus Notes, Remedy, HP Quality Center, Webex, MS Net meeting, MS Live Meeting
Other Tools: Tivoli, Autosys, Starteam, PVCS, Remote Desktop Connector, Dameware, WS FTP, FTP Edit, Win Grep, Beyond Compare, Erwin, Ganglia, Control-M, Power Builder, MS Office(Word, Excel, Power Point, Visio), MATLAB

Experience

Confidential, OH Sr. Oracle Programmer Dec 2009 to Present
Project Technologies:

Currently working as an Oracle PL SQL lead for the design and development of Price Volume Mix (PVM), an online reporting system that calculates and aggregates critical sales and product profitability information for various Owens Corning’s global business nodes. PVM is an analytical approach to understand change in customer product profitability between an analysis and base period involving factors such as price, volume, product mix, customer mix and cost. The processed sales information is propagated to the end user group through Business Objects reporting tool.

Responsibilities:

• Creation and development of Oracle PL/SQL packages, stored procedures, functions, anonymous blocks, views and used them for report design
• Developed and tuned the complete complex reporting architecture and data flow involving up to 20 variable inputs right from scratch under tight deadlines
• Performed complex scripting and querying in both the development, testing as well as production environment
• Extensively used global temporary tables and ref cursors to store and process data
• Created functions for complex data parsing of multiple input parameters in Oracle
• Actively involved in database capacity planning, creating indexes and partitions on tables for Optimization and Tuning for enabling maximum db efficiency
• Experience with Oracle package pinning and caching tables to the SGA
• Set up and monitor Oracle Jobs using Oracle DBMS_Job package
• Experience with Oracle 11g new features such as parallel query and table sub-partitioning
• Co-coordinated ETL processes including data validation and data scrubbing using Datastage from SAP BW environment into Oracle
• Coordinating with the Development, Testing and the DBA team to compile, run, test and install the developed code onto the testing as well as production environments
• Created Universes in Business Objects that interfaced with the Oracle backend
• Performed extensive query tuning to reduce turnaround time by 40 to 70 percent
• Documentation of all modules for user level and system level maintenance
• Created unit test cases and performed unit testing on developed projects before clearing code for User Acceptance Testing
• Worked with the project DBA in assigning tablespaces, grants and roles.
• Involved in work on Business Objects for reporting and analysis.
• Environments:Oracle 10g/11g, SQL*PLUS, TOAD, SQL Developer, SQL*Loader, IBM Datastage 8.0.1, Business Objects XI 3.1 and Web Intelligence Rich Client, MS Office, Windows XP Professional / 7

Confidential, OH Sr. Oracle Programmer Oct 2009 to Dec 2009
Project Technologies:

Worked as an Oracle Developer and Production Support Analyst with UNIX batch scripting responsibilities for the homegrown Analyst and ODW data warehouse systems. These systems store, process and archive sales and inventory information from various worldwide Luxottica Retail eyewear stores. The processed sales information is propagated to the end user group through PowerBuilder and Business Objects reporting systems.

Responsibilities:

• Creation and development of Oracle PL/SQL packages, stored procedures, functions, anonymous blocks and views
• Development and execution of batch programming scripts that automate critical production data processes under tight deadlines
• Performed complex scripting and querying in both the development as well as production environment.
• Coordinating with the Development, Testing and the DBA team to compile, run, test and install the developed code onto the testing as well as production environments
• Played a major role in managing and maintaining all the development, test and production databases. Worked closely with the DBA group to administer the performance and content of all databases owned by the Analyst / ODW team
• Created PL/SQL packages, procedures and extensively used PL/SQL tables, cursors, user defined object types and exception handling along with loading data from flat files into to database tables using SQL* loader.
• For Optimization Process, actively involved in performed database capacity planning, created materialized views, partitions, tables, views, indexes etc as. Tuned and optimized SQL statements
• Documentation of all modules for user level and system level maintenance.
• Created unit test cases and performed unit testing on developed projects before clearing code for User Acceptance Testing
• Worked extensively with Starteam for maintaining the critical Oracle and Unix code repository.
• Involved in work on Business Objects for reporting and analysis.
• Experience with PowerBuilder as the main Integrated Development Environment tool
• Experience with Ganglia Monitoring System as a tool for monitoring and analysis of Unix based database servers
• Experience with Control-M as a scheduling software for workload automation for Unix batch jobs
• Experience with Project Portfolio management (PPM) and Remedy as ticketing and task management tools
• Environments:Oracle 9i, SQL*PLUS, TOAD, SQL Developer, SQL*Loader, Korn Shell Scripts, Starteam, Control-M, Ganglia, PPM, Remedy MS Office, Windows XP Professional

Confidential, OH Oracle Developer and Admin June 2008 to Sep 2009
Project Technologies:

Worked as a Senior Programmer Analyst and Developer for the Benefits Enhancements and Tracking System (BETS) team in Kaiser Permanente. BETS is an extensive Contracts and Benefit Administration module that processes critical Benefits, Sales, Marketing and Pricing information for the users. It has a wide repertoire of Interface, Web and Database server system that interacts and processes user information. This processed information is sent to Kaiser’s various downstream applications used in the Claims, Membership and Clinical divisions.

Responsibilities:

• Creation and development of Oracle PL/SQL packages, stored procedures, functions, Views and triggers
• Development and execution of batch programming scripts that automate critical production data processes
• Performed complex scripting and querying in both the development as well as production environment.
• Coordinating with the Development, Testing and the DBA team to compile, run, test and install the developed code onto the testing as well as production environments
• Played a major role in managing and maintaining all the development, test and production databases. Worked closely with the DBA group to administer the performance and content of all databases owned by the BETS team
• Round the clock monitoring and maintaining the major interface, web and database servers that store and process data for Kaiser Business
• Worked extensively with Starteam as an administrator for maintaining the critical Oracle, Visual Basic and .NET code repository. Responsible for release code management and code merges that determined the quality of all BETS production code releases
• Extensively involved in a BETS front end application code migration from VB to .NET. Involved in complete life cycle of the .NET code development, testing and production deployment
• Experience with Oracle, VB and .NET application forms in having them compiled, built and maintained on various application and web servers for test as well as production
• Worked on Oracle reports for their setup and maintenance on various application, database and web servers for both test and production
• Owned sole rights in the whole team to update code in Production environments
• Involved in maintaining and protecting user access on various database roles and application form security
• Created PL/SQL packages, procedures and extensively used PL/SQL tables, cursors, user defined object types and exception handling along with loading data from flat files into to database tables using SQL* loader.
• For Optimization Process, actively involved in performed database capacity planning, created materialized views, partitions, tables, views, indexes etc as. Tuned and optimized SQL statements
• Involved in round the clock production support and system maintenances
• Environments: Oracle 10g/8i, Sql*Plus, Toad, SQL Developer, Windows Batch Scripts, IBM Mainframe, Starteam, Visual Basic, Microsoft .NET, MS Office, Windows XP Professional

Confidential, VA Oracle Developer and Support Lead Mar 2007 to May 2008
Project Technologies:

Worked as an Oracle Developer and Production Support lead in the Data Migration Project for the DPOM Team at Time Warner Cable. TWC migrated their digital phone customers from one backbone system to another. Played a key role in the backend data and account migration process that supported the system’s existing front end application (DPOM) maintaining every customer’s status and record. Involved in ETL, Data Validation, and Deployment in production and Support. Responsible for back-end code development and runtime support using PL\SQL and Perl Scripts

Responsibilities:

• Involved in the creation PL/SQL packages, stored procedures, functions, indexes
• Helped develop and run Perl Scripts that automated the process
• Coordinated with the development team to compile, run, test and install the developed code onto the testing as well as production environments. Responsible for performing code reviews
• Performed and front end and code functionality monitoring using XML and log data.
• Performed complex scripting and querying in both the development as well as production environment.
• Involved in round the clock production support, and on-call shift work.
• Responsible for data loading, security, performance monitoring and
  tuning, capacity planning and backup and recovery.
• Worked on ETL tools as part of data transformation and loading.
• Involved in work on Business Objects for reporting and analysis.
• Helped the QA team to develop test scripts for the validation of the process. Also performed unit testing and system testing.
• Also worked on Erwin to understand the complete database structure and design for the project.
• Worked actively in the Data Modeling of the target database used for customer migration.
• Involved in round the clock production support by interacting with the users and their environment in order to help debug production issues.
• Documentation of all modules for user level and system level maintenance.
• Involved in debugging and tuning the SQL code, queries and optimization for the Oracle database.
• Worked with the project DBA in assigning tablespaces, grants and roles.
• Interacted with data modelers for construction of logical and physical data modeling.
• Involved in DDL creation, data profiling and data architecture and data centric development
• Active involvement in issue resolution and monitoring day to day progress of the project, Customization, Live Company Setup, etc.
• Attended meetings and review to discuss current issues and processes to tackle critical issues
• Environments:Oracle 10g/9i, SQL*PLUS, TOAD, SQL Navigator, Korn Shell Scripts, Perl, UNIX, MS Office, Windows 2003/XP Professional

Confidential, VA Oracle Developer and Analyst Sep 2006 to Mar 2007
Project Technologies:

Worked as an Oracle Developer in the Asset Tracking Team for Sprint-Nextel. Responsible for PL\SQL back-end code development that helped run vital front-end tools that are used to track the company’s assets and inventories as a result of the Sprint-Nextel corporate merger. Also supported the testing team in maintaining the successful functioning of the front-end applications. Worked on Oracle forms and Reports. Involved in Product Development and Support, Data Validation and Deployment in production and development environments used for various cellular communication applications.

Responsibilities:

• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, indexes and collections. Developed Back-end interfaces.
• Coordinated with the development team to compile, run, test and install the developed code onto the testing as well as production environments. Responsible for performing code reviews.
• Coordinate with the front end design team to provide them with the necessary stored procedures and packages that help run the front end applications and provide the necessary insight into the data.
• Helped the QA team to develop test scripts for the validation of the process. Also performed unit testing and system testing.
• Worked on Import/Export, complex scripting and querying in both the development as well as production environment.
• Developed Unix Shell scripts to automate repetitive database processes.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Involved with DBA in creating schema and related privileges and roles.
• Extensively used SQL*Loader to load data from flat files obtained from various facilities every day.
• Involved in Extraction, Transformation and Loading (ETL) of the data in the data warehouse for Oracle 9i/8i database.
• Used external tables to manipulate data obtained daily before loading them into the tables.
• Designed and generated database objects and Oracle Forms, Reports, and Libraries through Oracle Designer
• Involved in round the clock production support by interacting with the users and their environment in order to help debug production issues
• Interacting with Business users, gathering and analyzing requirements.
• Documentation of all modules for user level and system level maintenance
• Environments:Oracle 10g/9i, SQL*PLUS, TOAD, SQL Navigator, MS Access, SQL*Loader, Korn Shell Scripts, PVCS, MS Office, Windows 2003/XP Professional

Confidential, DC Oracle Developer and Analyst Apr 2006 to Sep 2006
Project Technologies:

Worked as an Oracle and SAS Developer in the Reverse Mortgage and Reserve Accounting team of the Fannie Mae Restatement division. Responsible for data extraction, migration, query generation, scripting, optimization, and reporting results for restatement purposes. Generated reports of data pertaining to customers, loans, its principal amounts, interests, balance and other financial data that are used by executives in several departments.

Responsibilities:

• Managing all the activities related to Database Development and Reporting in the Restatement Project.
• Involved in Extraction, Transformation and Loading (ETL) of the data in the data warehouse for Oracle 9i/8i database using AbInitio.
• Worked on Import/Export, complex scripting and querying in both the development as well as production environment.
• Migrated Data from raw text, excel and CSV files into MS Access and SAS.
• Expertise in SAS programming, Oracle SQL and MS Access for all extraction, development and reporting.
• Performance tuning of SQL and SAS queries for data warehouse consists of many tables with millions of rows of data.
• Undertook Code Optimization and Performance tuning of the Oracle and SAS applications.
• Worked on table partitioning and deploying various methods of indexing like local indexes and global indexes on partitioned tables.
• Involved in debugging and tuning the SQL code, queries and optimization for the Oracle database.
• Experience with TCA in Oracle Apps 11i to manage complex and hierarchical information.
• Active involvement in issue resolution and monitoring day to day progress of the project, Customization, Live Company Setup, etc.
• Attended meetings with business users and review to discuss current issues and processes to tackle critical issues
• Environments:Oracle 10g/9i, MS SQL, SAS, SQL*PLUS, TOAD, Aqua Data, MS Access, Microsoft Visio 2003, MS Office, Windows XP Professional

Confidential, NC Oracle Developer Aug 2004 to Apr 2006
Project Technologies:

Involved in building an interface to convert/migrate legacy customer data to Oracle financials AR tables. Also involved in Data warehouse/Database Development for Oracle 9i/8i databases. Worked on multiple projects in Product Development, Data Migration, Deployment, validation in Production and Development environments for various applications on UNIX and Windows NT/2000 platforms.

Responsibilities:

• CUSTOMERS Interfaces/conversion:
• Developed conversion mapping that maps legacy customer master data (customer accounts, profiles, contacts and telephone data) to Oracle financials customer interface.
• Created SQL*Loader scripts to load legacy data into Oracle temporary tables.
• Created staging tables necessary to store validated customer data prior to loading data into customer interface tables.
• Created PL/SQL procedures and functions necessary for customer record validations before loading records into customer interface tables.
• Validation includes organizations, customers and addresses validation like duplicates and nulls, ship to and bill to validation, checking customer profile classes are setup in oracle and site use code exists in oracle etc.
• Through interface program ran the import process by calling the customer import process (RACUST) for different business groups separately.
• Analyzed Business Documents, Internal & External Source systems and Reporting Requirements to develop Transport Spending Data warehouse LOGICAL AND PHYSICAL MODEL (Facts and Dimensions) and Business Process Model.
• Extensively worked on Performance tuning by using Explain plans and various hints.
• Worked on table partitioning and deploying various methods of indexing like local indexes and global indexes on portioned tables.
• Involved in Extraction, Transformation and Loading (ETL) of the data in the data warehouse for Oracle 9i/8i database.
• Used Oracle 9i features such as merge for various transformations.
• Involved in creating procedures for Raw Data Reports using PL/SQL.
• Used UNIX Shell scripts (KORN) for Extracting and Parsing data from the files.
• Used stored procedures in Oracle for retrieving the data from the database for solving complex queries. Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
• Involved in writing complex scripts for Data Transformation, ETL process (Extract, Transform & Load)
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Used Business Objects for reporting and analysis
• Involved in Oracle Advanced Queuing techniques (Enqueue and Dequeue)
• Used extensively Cursor Expressions for data retrieval and manipulation in Oracle Database
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL)
• Creating Test scripts for the generated final Reports.
• Attended meetings and review to discuss current issues and processes to tackle such issues
• Environments:Oracle 9i/8.x, SQL*PLUS, PL/SQL, SQL*Loader, Korn Shell Scripts, Business Objects, Windows NT/2000/XP, TOAD

Confidential, MA Oracle Developer April 2003 to July 2004
Project Technologies:

Worked as an Oracle Developer in the Data Warehouse group. Responsible for logical and physical design of components, Query optimization, Performance tuning, automating Data extraction and cleansing from data warehouse, generating daily, weekly and monthly reports of customers, sales, Usage, promotions data that are used by executives and several departments.

Responsibilities:

• Interacting with Business users, gathering and analyzing requirements.
• Involved in design of logical and physical data model of the components.
• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse.
• Designed star schema using dimensional modeling and created fact tables and dimensional tables.
• Performance tuning of SQL queries for data warehouse consists of many tables with millions of rows of data.
• Created PL/SQL packages, procedures and extensively used Varrays, PL/SQL tables, cursors, user defined object types, exception handling.
• Loading data from flat files into to database tables using SQL* loader.
• Automating data loading, extraction, report generation using UNIX shell scripting.
• Responsible for the production support and bug fixing
• For Optimization Process actively involved in performed database capacity planning, created materialized views, partitions, tables, views, indexes etc as. Tuned and optimized SQL statements.
• Designed ETL to extract external data source (Oracle, Excel file)
• Responsible for code migration of existing application from SQL Database to Oracle Database.
• Worked on BO to deploy various reports onto production.
• Developed ETL for Data Extraction, Data Mapping and Data Conversion for various application and processes.
• Using ERWIN for Logical and Physical database Modeling.
• Applied heavy formatting for reports and developed reports with necessary Formulas and Parameter fields and exported these reports to various formats.
• Environments:Oracle 9i/8.x, SQL Server 2000, SQL, PL/SQL, SQL Server Enterprise Manager, Shell Scripts, HP 11.0,SUN-SOLARIS 2.8, TOAD, Erwin.

Confidential, OR Oracle Developer Jun 2002 – March 2003
Project Technologies:

Worked as an Oracle Developer in the Intel Billing department. Purpose of this project was to load the various daily data feeds from various sources includes billing, usage, customer and handsets data. This data is rolled up and summarized in the system and reports are displayed against different parameters to support business user’s requests.

Responsibilities:

• Developed backup and recovery strategy for Oracle 8 database.
• Wrote UNIX shell script to automate nightly backup of Oracle 8 database.
• Created the required Forms and Reports for module.
• Developed PL/SQL procedures that handle key business logic
• Created Procedures using Dynamic PL/SQL.
• Migrated Data from MS Access to Oracle.
• Wrote PL/SQL Procedures/Packages, Functions and Triggers
• Developed Database Triggers, which checks the data integrity.
• Monitored the System Table space and adding additional data files to the Table spaces in Oracle Storage Manager.
• Responsible for writing simple Unix Shell Scripts for base automation of processes for loading and testing.
• Identified and mapped the various entities, referential integrity constraints and relationships.
• Database designing (Logical and Physical design) and creation
• Wrote various PL/SQL procedures that retrieve and modify data used to create reports
• Assisted in the implementation of applications used by the Quality Assurance Department and the Accounting Department.
• These implementations included PL/SQL Procedures, SQL*Loader scripts, UNIX shell scripts
• Environment:Oracle 9i/8.x, SQL Server 2000, MS SQL, SQL, PL/SQL, SQL Server Enterprise Manager, Shell Scripts, HP 11.0,SUN-SOLARIS 2.8, TOAD, Erwin.

Education:

MS in Electrical Engineering
BE (BS) in Electrical Engineering

References:

Available upon request