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 coding, Windows Batch Scripting, PERL 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

Skills

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, Sr. Oracle Programmer Lead Dec 2009 to Present

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, Sr. Oracle Programmer Oct 2009 to Dec 2009

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 Confidential 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 UNIX 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, UNIX Korn Shell Scripts, Starteam, Control-M, Ganglia, PPM, Remedy MS Office, Windows XP Professional

Confidential, Oracle Developer and Admin June 2008 to Sep 2009

Worked as a Senior Programmer Analyst and Developer for the Benefits Enhancements and Tracking System (BETS) team in Confidential. 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, Oracle Developer and Support Lead Mar 2007 to May 2008

Worked as an Oracle Developer and Production Support lead in the Data Migration Project for the DPOM Team at Confidential. CONFIDENTIAL 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.
• Worked on UNIX shell scripting as a part of account and data migration and clean up processes
• 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 Scripts, UNIX, MS Office, Windows 2003/XP Professional

Confidential, Oracle Developer and Analyst Sep 2006 to Mar 2007

Worked as an Oracle Developer in the Asset Tracking Team for Confidential. 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 Confidential 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, Oracle Developer and Analyst Apr 2006 to Sep 2006

Worked as an Oracle and SAS Developer in the Reverse Mortgage and Reserve Accounting team of the Confidential 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, Oracle Developer Aug 2004 to Apr 2006

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

Education:

MS in Electrical Engineering

BE (BS) in Electrical Engineering