PROFILE:

• 12 years of Oracle experience
• 12 years of PL/SQL Programming experience
• 6 years of DW experience using Oracle Warehouse Builder/ Informatica

SUMMARY:

• Total IT: 12 years of IT Experience with of Oracle Development experience including analysis, modeling, design, administration and maintenance of Oracle Database systems on both UNIX and NT platforms.
• Oracle: 12 years of solid database experience on Oracle 10G/9i/8i/8.0/7.3, DBArtisan 5.1, SQL Loader, Physical database design, Logical database design, Data Modeling Designer 2000 , Gap Analysis, Data Mapping, Cleansing, Massaging, Transformations, Data Exports Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Security Administration, Resource Management, Software Maintenance, User Security Management, Oracle Tuning Optimization.
• Reports: 6 years of strong front-end programming experience using Oracle Forms 6i/5.0/4.5, Oracle Reports 6i/3/2.5, Oracle Report Writer, Oracle Developer 2000, SQR 3.0, Crystal Reports and Oracle Discoverer.
• Database: 12 years of Database experience working on Oracle Warehouse Builder, Oracle 10g/9i/8i/8.0/7.3, SQL Server 2000/7.0/6.5, IBM DB2 8.0/7.0, Teradata V2R5/V2R4, MS Access.
• Programming: 12 years of strong back-end programming experience using PL/SQL, SQL, MS SQL, SQL Loader, SQL Plus, TOAD, T-SQL, Pro C, C, C , Java, VB, HTML, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, Ad-hoc queries using SQL.
• UNIX: 8 years of UNIX experience on Unix Shell Scripting, CGI/PERL, Pro C, Autosys, Clearcase, Sun Solaris, Windows 2000, Windows NT 4.0, Windows 98/95/3.1, MS DOS 6.22, Novell Netware, IBM Compatibles, Sun Classic, Sun Sparc Sun Ultra.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Data Specialist

This role is a data analyst position and involves PL/SQL development. Most of the work is supporting existing infrastructure and updating data in production.

Responsibilities:

• Writing sql queries and PL/SQL code for updating the existing and new database tables.
• Involves performance tuning of the existing code for improving performance of the scripts.
• Writing custom PL/SQL code to for loading data, in initial load and incremental scenarios.
• Created documents with step by step instruction for data archiving and masking the data.
• Unit testing and promotion of code into QA and Production.
• Uploading data into production using sqlldr scripts.
• Writing korn shell scripts to execute different processes keeping dependencies in mind.

Confidential

Sr ETL Developer

Worked on several projects for building the Enterprise Repository. Worked on Mapping Migration, new mapping creation and updating existing mappings.

Responsibilities:

• Developed mappings to capture the incremental changes and as well as store history.
• Created mappings for extracting data from various Sources into Repository, Repository to Data mart/ ODS.
• Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL Loader and PL/SQL.
• Version Control and Code migration was performed.
• Applied Day forward logic on Data mart for fact and Dimensions to capture the daily changes.
• Worked with DBA for analyzing Performance tuning techniques such as indexes, partition etc.
• Developed synonyms, Views and Materialized Views for transformation requirements.
• Used functions and Procedures to cater to Business Requirements.
• Created Workflows and sessions to run the mappings and send emails.
• Used Workflow Monitor for monitoring.
• Analyzed complex workflows and identified root cause and provide resolutions
• Created shell scripts for integrating processes and adding pre and post processes to the workflow.

Confidential

Sr. DWH Informatica Developer/ Data masking Developer

Worked on Several Projects including the ACT 129, Smart Meter Projects. Wrote several Unix routine and Oracle packages to read meters remotely, Connect, Disconnect and resolve Voltage issues using TWACS Software. Extracted data from various systems that helped in studying Power consumption processes. Supported existing Billing and Inventory management Data Marts. Informatica which replaced OWB and PL/SQL packages was used for extraction, transformation and loading of data and several packages were written to implement Act 129 Smart Meter projects.

Responsibilities:

• Used Oracle Data Masking pack for masking Sensitive data across the database.
• Identify prioritize sensitive data within a table based on user input.
• Implemented masking using Enterprise Manager 11g.
• Created masking rules to be implemented across 8 databases.
• Designing of schema included dimensions, relational and fact table.
• In depth knowledge of Informatica 9.0 Powercenter architecture as a developer.
• Experience in designing and developing of mappings, transformations, sessions and workflows in PowerCenter
• Developed mappings to capture the incremental changes and as well as store history.
• Created mappings for extracting data from various Sources into Repository, Repository to Data mart/ ODS.
• Strong knowledge of coding in and troubleshooting SQL and PL/SQL.
• Used Agile Development methodologies.
• Did systems analysis, development enhancement, maintenance and support of Oracle based Data Warehouse Applications
• Used the warehouse metadata, naming standards and warehouse standards for future application development.
• Developed synonyms, Views and Materialized Views for transformation requirements.
• Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL Loader and PL/SQL.
• Coordinated with source system owners, monitored day-to-day ETL progress, performed Data warehouse target schema Design Star Schema and maintenance.
• Used Maestro Tivoli Job Scheduling software to schedule jobs.
• Used ITEAM for creating Maestro Stubbs used in the scheduling of Jobs.
• Production support and off hours pager rotation.

Enviornment: Oracle 11g, IBM Netezza 6.0, Sql server 2008 R2, Informatica 9.0, Toad, IBM Tivoli Workload Scheduler 8.0 , ITeam, Unix, Cognos.

Confidential

Sr. BI/DWH Oracle Developer

The project involves building of various Data Marts. It involves extraction of Data from SAP into their Data warehouse and then into Data Marts. Various reports are produced that define the consumption and sales pattern during particular season. The project used Informatica 8.6 as an ETL tool, and OBIEE as the reporting tool.

Responsibilities:

• Gathering Requirements and preparing Requirement Documents.
• Did systems analysis, development enhancement, maintenance and support of Oracle based Data Warehouse Applications
• Used the warehouse metadata, naming standards and warehouse standards for future application development.
• Designing of schema included dimensions, relational and fact table.
• Data cleansing and Data profiling using Trillium for better quality.
• Developed mappings to capture the incremental changes and as well as store history.
• Created mappings for extracting data from various Sources into Repository, Repository to Data mart/ ODS.
• Data was extracted from Flat files, SAP, Oracle and Sql server and loaded into SAP environment.
• OBIEE Repository design, development and maintenance.
• Building Reports and Dashboards using Oracle Answers
• Developed Fact for analyzing the measures.
• Applied Day forward logic on Data mart for fact to capture the daily changes.
• Used UNIX scripting to create a process flow for executing various steps to load data into the staging tables to Data mart.
• Enviornment: Oracle 10g, SAP R/3 Enterprise Release 4.6C, Sql server 2006, Informatica 8.6, Toad, Red hat Linux, OBIEE.

Confidential

LEAD ETL DEVELOPER

This application involved building of Revenue data mart for reporting Brokerage earned. Data was extracted from various Heterogeneous sources such as AS400, SQL Server, Oracle, Excel sheets, Flat files. The project was initiated using OWB as a primary tool and later Informatica was used for loading the data warehouse and data marts, and Cognos was used as the primary reporting tool.

Responsibilities:

• Installed and configured OWB Client Server architecture for POC, Development, UAT and Production
• Worked with the DBA to setup OHS connectors for connecting to HS sources using third party connectors for accessing SQL Server, AS400 and Sybase.
• Extracted data from heterogeneous data sources such as AS400, SQL Server, Oracle, Excel sheets, Flat files for loading them into target tables.
• Did systems analysis, development enhancement, maintenance and support of Oracle based Data Warehouse Applications
• Used the warehouse metadata, naming standards and warehouse standards for future application development.
• Designing of schema included dimensions, relational and fact table.
• Data cleansing and Data profiling for better quality.
• Developed mappings to capture the incremental changes and as well as store history.
• Created mappings for extracting data from various Sources into Repository, Repository to Data mart/ ODS.
• Worked on several complex mappings.
• Developed Fact for analyzing the measures.
• Applied Day forward logic on Data mart for fact to capture the daily changes.
• Worked with DBA for analyzing Performance tuning techniques such as indexes, partition etc.
• Developed synonyms, Views and Materialized Views for transformation requirements.
• Used functions and Procedures to cater to Business Requirements.
• Created process flows and added procedure to populate tables.
• Installed Workflow server 2.6.4 and monitor for thorough monitoring of process flows.
• Created scripts for scheduling Job using DBMS Job Scheduling.

Enviornment: Oracle 10g, OWB 10.2, AS400, Sybase , Sql server 2006, Informatica 8.6, Toad, Unix, ITeam, Cognos

Confidential

DW ETL ARCHITECT

This application was part of a software development project that included BI features. The application includes developing mappings and giving the user the permission to add fields, columns, and groups. The application uses CDC for near real-time change data capture.

Responsibilities:

• Extracted data from heterogeneous data sources for loading them into target tables.
• Used Change Data Capture and Partition Exchange for near real time data access thus enabling access to an updated Data Warehouse several times during a day
• Designing of schema included dimensions, relational and fact table.
• Data cleansing and Data profiling for better quality.
• Developed mappings to capture the incremental changes and as well as store history.
• Developed Fact for analyzing the measures.
• Did systems analysis, development enhancement, maintenance and support of Oracle based Data Warehouse Applications
• Used the warehouse metadata, naming standards and warehouse standards for future application development.
• Developed synonyms, Views and Materialized Views for transformation requirements.
• Procedures for creating udd's, udf's and udg's in the post mapping process of process flows.
• Designed the mappings to capture multiple updates with the same business key in the same load from CDC for implementing SCD type 2 logic.
• Created process flows and added procedure to populate tables according to the udd's, udf's and udg's.
• Performance Tuning was done at mapping, session and workflow level.
• Cache memory was
• Setup smtp server service from Oracle 10g database for syncing it with the company's mailing system.
• OBIEE Repository design, development and maintenance.
• Building Reports and Dashboards using Oracle Answers
• Installation of Delivers for iBots, Caching etc.
• Creating scheduling iBots according to user requirements.
• Cache Management using iBots and manual caching.

Enviornment: Oracle 10g, 9i, OWB 10.2, Sql server 2004, Informatica 8.6, 7, Toad, Unix, OBIEE, Revenue DM 1.0.

Confidential

DW PL/SQL Developer

This application maintained the database and provided new capabilities for supporting the Incremental Logic. This application maintained the existing mappings that the company was using and adding Incremental logic to that. It involves designing of mappings, applying Incremental logic to the existing mappings, testing and migration into different database.

Responsibilities:

• Reengineer the Data Warehouse to enable new capabilities such as Change Data Capture and Partition Exchange for near real time data access thus enabling access to an updated Data Warehouse several times during a day.
• Worked with IT staff to build 8 Star Schema's and 22 Dimensions using Oracle Warehouse Builder Release 2 for the implementation of client data warehouses. Provide Support during the migration of mappings from one environment to another.
• Responsible for systems analysis, development enhancement, maintenance and support of Oracle based Data Warehouse Applications
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• ETL Migration process from legacy scripts to Oracle warehouse Builder 10.2/10.1.
• Created Oracle PL/SQL queries and Stored Procedures.
• Worked on data loads using Oracle PL/SQL and SQL Loader.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Researched Sources and identified necessary Business Components for Analysis.
• Involved in Data Quality Analysis to determine cleansing requirements.
• Designed and developed Oracle Warehouse Builder mappings for data loads.
• Writing PL/SQL code using the technical and functional specifications.
• Implemented Explain Plan and SQL Trace for improving the performance of SQL queries.
• Tuned most of the queries and drastically reduced the response time to less than 6 seconds.
• Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL Loader and PL/SQL.
• Coordinated with source system owners, monitored day-to-day ETL progress, performed Data warehouse target schema Design Star Schema and maintenance.
• Generated reports using Crystal Reports.
• Provided production support by monitoring the processes running daily.

Environment: Oracle Warehouse Builder 10.2/10.1, Oracle 10g/9i, PL/SQL, SQL Loader, Toad, Seibel Analytics, HTML, XML, SQL Plus, SQL Developer, SQL, Crystal Reports, JAVA, Visual Basic 6.0, Red hat Linux, Kintian, PVCS Version Management, Mercury Quality Center 6.0, Developer 2000 Forms5.0, Reports 3.0 , Control M

Confidential

Senior Oracle PL/SQL Developer

Dynamic Life sales project was developed for analyzing and reporting the historical and time variant data of the company. Database was maintained with consumable items required in each workstation. As per the monthly production of consumable items, reports were generated for the purchase department

Responsibilities:

• Responsible for systems analysis, development enhancement, maintenance and support of Oracle based Data Warehouse Applications.
• Responsible for the performance tuning tasks of the database.
• Extensively used explain plans to get the statistical data for the performance tuning of the sql queries and stored procedures.
• Responsible for the backup and recovery plans.
• Analyzed and improved performance of Associated Quality Safety Assurance AQSA system, an in-house application for monitoring field resources using SQL query performance tuning and optimization.
• ETL Migration process from legacy scripts to Oracle warehouse Builder.
• Developed a system to process data feeds from various organizations of GAP Footprint for report generation using PL/SQL. Data Files of different formats from Mainframe systems are loaded into staging environments using SQL Loader and then used PL/SQL code to perform data transformations and implement business logic. Build Reports using PL/SQL Procedures from the report table.
• Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL Loader and PL/SQL.
• Worked on TIBCO Database Adapter to establish the connection with Oracle database.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Conversions.
• Deployed applications on web using Oracle 9i Portal and Application Server Used Oracle JDeveloper to support JAVA, JSP, and HTML codes used in modules.
• Developed shell scripts to automate recurring processes and routine administration tasks. Responsible for maintaining cron jobs using Autosys.
• Integrated Crystal Reports into Web applications using Java/J2ee.
• Performance tuning of PL/SQL Scripts
• Developed Views and Materialized Views.

Environment: Oracle Warehouse Builder 10.2/10.1.0.4, Oracle 10g/9i, PL/SQL, SQL Loader, Oracle Developer 2000, DBArtisan 5.1, TIBCO, Autosys, JAVA, Sun Solaris 2.6/2.8, Shell Scripting, Perl/CGI.

Confidential

Sr. Oracle Developer

Thomson Financial is an arm of one of the world's leading information companies, focused on providing integrated information solutions to business and professional customers.

Responsibilities:

• Involved in building Enterprise wide Logical and Physical database design using the Designer 6i/2000
• Configured and deployed Forms and Reports to the Forms 6i and Reports Server
• Installation and set-up of Oracle 9i/8i database
• Created and modified Oracle Schema objects like Tables, Indexes
• Involved in process of normalization Developed Entity relational Diagrams ERD
• Involved in SQL PL/SQL programming for stored procedures
• Involved in extraction and loading of data from legacy system Mainframe to Oracle database
• Worked on performance tuning of SQL queries involved in the reports, indexes, partitioned tables to improve overall performance of system
• Extracting and Loading the data using SQL Loader, Import/Export, Batch programs and loading into temporary tables and cleaning/correcting data using PL/SQL and transferring to respective production tables.
• Client-side scripting using Java Scripting language
• Generated Triggers for data integrity, Created views to resolve complex queries.
• Designed/ created Oracle database objects, Roles/ Privileges and schemas.
• Used SQL Loader to load data from Mainframe into Oracle database.
• Wrote PL/SQL procedure, functions, Triggers to maintain data integrity
• Developed Oracle JOBS for executing the Stored Packages
• Fine tune SQL queries and resolve performance issues.

Environment: Oracle 9i/8i, PL/SQL, SQL, Designer 6i/2000, Erwin, Stored Procedures,

SQL Loader, Import/Export, Reports 6i, Forms 6i, Java, C , Shell Scripts, TOAD 7.4, UNIX

and Win NT.

Confidential

Oracle Developer

Was an Oracle Developer in a 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, promotions data that are used by executives and several departments

Responsibilities:

• Involved in gathering user requirements.
• The project involved detailed design using E-R Diagrams, Data Flow Diagrams, Data Dictionary, and System flow Charts.
• Wrote PL/SQL packages consisting of procedures and functions.
• Database Extraction and filtering using UNIX Shell Scripts. Shell Scripts were run through UNIX Corn scheduling Batch sessions.
• Created Views, Triggers, Sequences.
• Designed and developed full life cycle for data loads about terabyte size Data Warehouses Oracle Warehouse Builder.
• Involved in the Design of User interfaces
• Involved in tuning database and SQL statements and schemas for optimal performance.
• Query Optimization and tuning of database.
• Utilized tools like TOAD during development of the application.
• Involved in direct discussion with the End-Users to study the system requirement and develop Functional and Technical specifications to meet their requirements.

Environment: Oracle Warehouse Builder 9.i, Oracle 9i, JAVA, SQL, PL/SQL, UNIX Shell Scripting, SQL PLUS and TOAD, Windows 2000.

Confidential

Oracle Developer

Project was to automate the HR department of Stormont-Vail Healthcare. This aims at minimizing the paper work that needs to be maintained and makes the day to day operations of the department easier.

Responsibilities

• Analysis and Data Modeling of Logical to Physical Data models using Erwin.
• Design and Generation of Forms and Reports.
• Creation of SQL and PL/ SQL scripts, calling C external routines from within PL/ SQL for transfer of data between the databases.
• Design and Generation of Reports using REF Cursors.
• Integration and Implementation of the system Trouble Shooting.
• Involved during User Acceptance Testing of the application.
• Participated in Code and Design Reviews for the ODS project for backend Data population and reporting system.
• Participated in status meeting and walkthroughs.
• Generation of Forms using Developer 2000.
• Creating reports using Developer 2000.
• Created Stored Procedures, Functions, Packages, Triggers using SQL, PL/ SQL.
• Use of Shell Scripts for day-to-day use of queries on Data Dictionary and other common tasks on UNIX.
• Prepared the documentation of Forms and Reports
• Implementation at the Clients site and imparting user training.

Environment: Oracle 9i, SQL PLUS, Forms 4.5, Oracle report writer 2.5, PL/SQL, UNIX, Windows NT.

Confidential

Oracle PL/SQL Developer

The present application maintains the inventory details and takes care for continuous supply of parts to the company by Processing of parts Arrivals, classifying, Purchase Invoice, Order for Imported components, Documents transactions for Imported Orders, Receipts, issues, Receipt Return Issue Return, Receipt Bill Entry, etc. It involves reports for parts Consumption Statement, Pending Order Statements, Stock Statement

Responsibilities:

• Performed logical database design.
• Created logical and physical database objects - table spaces, tables, indexes, referential integrity constraints, and triggers to development needs.
• Developed PL/SQL packages for Customer tracking, summary of sales order, Shipment and invoice, Sales Order information by customer, order, PO number, part number etc
• Performed Fine Tuning of SQL, PL/SQL Procedures
• Various PL/SQL triggers were written to handle the automatic order issuing
• Created screens using Forms 5.0 for Order Entry, Stock availability, Sales history tracking with respect to part number, customer, order, PO number, Summary of sales orders were done using Developer 2000 suite of products.
• Developed executive level reports of using PL/SQL procedures for Inventory listing, Inventory wholesale value, Inventory retail value, Listing by quantity, listing by cost, listing by date, overall status, top level, Book bill, Credits, Booking details, Invoice details by customer, by item, by product type using Reports 3.0 - utilized materialized views
• Conducted performance tuning of applications through tuning pack and SQL Navigator,
• Implemented shell scripts for trouble shooting Oracle Errors with the help of trace files and scheduled them.
• Configured database performance tools such as Oracle Enterprise Manager, SQL Navigator and used them for tuning of applications.

Environment: UNIX, Windows NT 4.0/2000/98, Oracle 8.0.5/7.3.4, PL/SQL, Developer 2000 Forms5.0, Reports 3.0 , SQL Navigator, Erwin 3.5

Confidential

Oracle PL/SQL Developer

Sales Automation System

This Project was the development of a Sales Automation System for Stores, Marketing Sales, and Production departments. The Stores department manages the procurement of the raw material from regular suppliers, and the transportation of finished goods to outlets all over the country. The Marketing Sales department takes care of the projections, pricing, product promotions, and sales.

Responsibilities:

• Involved in the entire system development life cycle to support the needs of the Stores and Marketing Sales departments.
• Responsible for designing and developing the Graphical User Interface.
• Involved in writing PL/SQL Packages, Stored Procedures, Triggers and Functions.
• Involved in Unit and integration testing.
• Involved in Debugging and error handling.
• Responsible for developing reports per Client requirements.
• Developed training manuals and trained users.

Environment: Windows NT, Oracle 7.3, PL/SQL, Oracle Forms 4.5, and Reports 2.5