SUMMARY

• Over 7+ years of experience in Data Warehouse Design, Development experience in client/server environment.
• Acquired extensive experience in Data Transformations, Data Loading, Database Modeling and Performance Tuning.
• Technologies used were Oracle database, Oracle Developer 2000 and TOAD.
• Have in - depth knowledge in Data analysis, Data warehousing and ETL techniques, UNIX Shell Scripting, SQL, PL/SQL scripts.
• Extensively Worked on Packages, Procedures, and Functions in PL/SQL.
• Experience in Performance Tuning using various types of Hints, Partitioning, and Indexes.
• Extensive experience with Data Extraction, Transformation, and Loading(ETL) from disparate Data sources like Multiple Relational Databases like Oracle, SQL Server, MS Access, Teradata, and Worked on integrating data from flat files, CSV files, and XML files into a common reporting and analytical Data Model.
• 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, OLAP.
• Experience with Star Schema Modeling and knowledge of Snowflake Dimensional modeling.
• Experience with XML Packages to parse the data from XML and loading in to Oracle tables.
• Extensively worked on KORN Shell scripts to write maintenance script for Oracle.
• Experience with Data Architecting by using ERWIN.
• Experience in Performance tuning and debugging for Extraction Transformation and Loading (ETL) processes.
• Extensive experience in loading high volume Data and Performance tuning.
• Worked extensively with Dimensional Modeling (Data Marts, Facts and Dimensions), Data Migration, Data Cleansing, ETL Processes Knowledge of Start and Snow Flake Schema Design.
• Excellent analytical skills, logical reasoning, and interpersonal skills.
• Excellent communications skills, fast & enthusiastic learner, excellent work ethics and a good team player.
• Strong management, administrative and leadership skills to work in team.

TECHNICAL SKILLS

Databases: Oracle 10g/11g, MS-SQL Server 7/2000, MS Access, Sybase, DB2.

Scripting: SQL, PL/SQL, UNIX Shell Scripting .

Languages: C, C++, Java, J2EE, XML, PERL .

Reporting Tool: Business Objects, Crystal Reports, Oracle Forms/Reports 10g/9i.

ETL Tool: DataStage, Informatica.

Query Tools: TOAD, SQL Navigator, SQL* PLUS.

Operating Systems: HPUX, Solaris 7.0/8.0, Windows, LINUX 9.2/9.3.

Other Tools: SQL*Loader, Erwin, MS-Visio, Clear Case, Clear QuestJIRA, Tortoise, Sybase Power Designer, SOA.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Oracle/ETL Developer

Responsibilities:

• Gathered the requirements from the data analysts and architects and performed technical analysis to reach a viable solution.
• Used the DataStageDesigner to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Used DataStage Parallel Extender parallel jobs for improving the performance of jobs.
• Used Parallel ExtenderDevelopment/Debugging stages like Row generator, Column Generator, Head, Tail and Peek.
• Designed database structures for effective data extraction, validation, run detail notification and error logging.
• Used DataStage Director to validate schedule run and monitor the data stage jobs.
• Developed user defined Routines and Transformations by using Universe Basic.
• Used Before/After Job-Subroutines in Job Properties.
• Coded conversion scripts to and data model patches and coordinated with DBAs for their execution and validation.
• Created custom packages and procedures to perform ETL processes like dataloading, transformation, extraction, validation and reporting.
• Utilized UTL FILE packages to create flat files and used SQL loader to load tables for downstream users.
• Modified existing modules by using Bulk Collect, PL/SQL tables, Varrays and other collection types to improve the performance of the system.
• Supported Teamwork developers and created views and stored procedures to aid with their reporting needs.
• Created custom reports such as Missed Closing Reasons, Loan Tag History etc using Report Builder and Discoverer.
• Used the Data Stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Used Data Stage for developing, programs for scheduling data loading and transformations.
• Created custom packages using XML packages like dbms xml parser, dbms xslprocessor, dbms xmldom, etc. to parse the XML data and loading into Oracle tables.
• Performance tuned the PL/SQL modules using Explain Plan and SQL Trace.
• Performed unit testing and user acceptance testing and provided support to QA and other downstream systems.
• Wrote technical documents giving an outline of job flows and the process involved.
• Worked with various tools like CDTS (Clear Quest), JIRA, Tortoise etc for defect tracking and version management.

Environment: Oracle 11g, Flat files, Sequential files, TOAD, SQL*Plus, UNIX, LINUX, XML, STAR Team, Data stage, Autosys, UNIX, Sybase Power Designer and JIRA.

Confidential, FL

Oracle/ETL Developer

Responsibilities:

• Interacting with stakeholders, gathering requirements, assigning priorities to each of them and analyze the impact on existing business process.
• Understanding business requirements and discuss with functional team to define the scope of work.
• Analyzed requirements from the users and created, reviewed the specifications for the ETL.
• Developed Mappings including transformations: Aggregator, Joiner, Lookup (Connected & Unconnected), Filter, Update Strategy, Stored Procedure, Router, Expression, SQ and Sorter.
• Designed Incremental strategy, Created Reusable Transformations, Mapplets, Mappings, Sessions and Workflows.
• Developed re-usable transformations, mappings and Mapplets confirming to the business rules.
• Created workflows and tested mappings and workflows in development and production environment.
• Thoroughly involved in all the phases of testing Unit Testing, Performance Testing, Bug Fixing etc
• Used Tools to monitor database performance and took various steps to improve database performance using Oracle Enterprise Manager.
• Using SQL Plus and PL/SQL to query and analyze data and perform basic DML and DDL operations in the Oracle Database.
• Responsible to write scripts which identify the legacy data and the valid data.
• Created Database Objects such as Tables, Views and Synonyms to provide data access to subscribing parties.
• Created/modified various Packages, Stored Procedure & Functions as part of the data validation and cleansing process.
• Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Supporting production issues and performance issues.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate according to the user requirements.

Environment: Informatica Power Center, PL/SQL Developer, Greenplum, Oracle 11g, XML, Unix Shell Scripting, Autosys, Putty, WinSCP, HP ALM Quality Center.

Confidential, Evansville, IN

ETL Developer

Responsibilities:

• Worked closely with Client to gather and understand the project requirements.
• Worked on creating tables, sequences, indexes and views.
• Worked on creating complex functions, procedures and packages by using MS SQL Server based on the business rules.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008.
• Assisted in building the ETL Source to Target specification documents by understanding the business requirements.
• Created Informatica mappings using various Transformations like Joiner, Aggregate, Expression, Filter, update Strategy.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load data into Datamarts, Enterprise Data warehouse (EDW).
• Created interface stored procedures used in SSIS to load/transform data to the database.
• Involved in optimizing sql query performance by analyzing database objects and creating suitable indexes.
• Worked on SQL Tuning by using EXPLAIN PLAN.
• Worked onad-hoc queries to extract data as per Business Requirements.
• Worked on tuning the PL/SQL packages in the existing modules to reduce the execution time by using Bulk Collect and FORALL.
• Extensively used cursors, user-defined object types, records, and tables in PL/SQL Programming.
• Used exception handling extensively for ease of debugging and displaying error messages in the application.
• Fixed the bugs and implemented fixes & enhancements within tight deadlines.
• Worked on Creating Materialized views for reporting purpose.
• Used SFTP mechanism to transfer the data files between Production server and External servers.
• Developed the UNIX shell scripts for monitoring, to run batch processes and reports that are were written in SQL and PL/SQL.

Environment: MS SQL Server 2008, Informatica, UNIX, WINDOWS 7, SQL, PL/SQL, TOAD, SQL *Loader, SQL developer, SSIS, SSRS, PVCS.

Confidential, Richmond, VA

Oracle Developer

Responsibilities:

• Extensively worked on Performance tuning by using Explain plans and various hints.
• Worked on table partitioning (Range and List) and deploying local indexing on portioned tables.
• Used Informatica for extraction, loading and transformation (ETL) of data in the data warehouse.
• Involved in Extraction, Transformation and Loading (ETL) of the data in the data warehouse for Oracle 9i database.
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation.
• Develop several complex mappings in Informaticausing various transformations, Mapping Parameters, Mapping Variables and Mapplets.
• Created reusable transformations and Mapplets and used them in mappings.
• Experienced in performance tuning of Informatica code.
• Involved in extracting Data from the Heterogeneous databases residing on Mainframe, UNIX.
• Used Oracle 9i features such as merge for various transformations.
• 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.
• Created Stored Procedures, functions and Packages in Oracle 9i using SQL and PL/SQL for the Audit Trail using Oracle 9i as backend.
• Involved in writing complex scripts for Data Transformation, ETL process (Extract, Transform & Load).
• Knowledge in the development of Web services to implement Service Oriented Architecture (SOA).
• Analyzed Business Documents, Internal & External Source systems and Requirements to develop Health Insurance Claims Data warehouse LOGICAL AND PHYSICAL MODEL (Facts and Dimensions) and Business Process Model.
• Coding of new report programs based on criteria to extract data from DB2 tables using join and inner queries.
• 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.
• Strong Knowledge in Oracle,DB2, Sybase, MySql and UDB.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Worked on Performance tuning by using Explain Plan, hints and also worked on Partition tables using Range method.
• This involves converting data from non xml format to xml format.
• Worked on Partitioning and indexing concepts (Local and Global) indexes on partition tables.
• Creating Test scripts for the generated final Reports.
• Attended meetings and review to discuss current issues and processes to tackle such issues.

Environment: Oracle 9i/10g, SQL PLUS, PL/ SQL, SQL*Loader,DB2,UDB, XML, Korn Shell Scripts, Business Objects, Sybase,Informatica,SQL Navigators, Ab Initio,Windows XP, MS-Excel, Solaris and HP-UX, TOAD.