Senior Oracle Etl/plsql Developer Resume

PROFESSIONAL SUMMARY

• Database Development with Around 6+ Years of experience in ETL/Oracle environment as Programmer Analyst/ Developer using most of the Oracle related tools under UNIX and Windows environments.
• 4 Years of extensive experience in the Data Warehousing Environments.
• 6 Years of experience in Oracle Development.
• Good understanding of database client/server configuration on Oracle 8i/9i/10g, SQL Server 2005/2008 and DB2.
• Very strong in Client/Server Architecture, Relational Databases (RDBMS), Data Modeling and Design and build the Data Warehouse, Data marts using Star Schema for faster and effective Querying for the Metadata Management solutions.
• Extensive and proven experience using Oracle 8i/9i/10g/11g, SQL, PL/SQL, SQL* Plus, SQL*Loader, Informatica.
• 5+ Years Extensive experience writing Database Triggers, Stored Procedures, Functions and Packages using PL/SQL.
• 2+ Years Experience in creating and modifying forms using Oracle Forms 6i for data manipulation purpose and reports using OracleReports.
• Experience in Requirement capturing, System analysis, Logical and Physicaldata modeling, Development and Implementation of software applications.
• Strong PL/SQL programming for data population and table alterations, Oracle Performance tuning/ SQL tuning and query optimization skills.
• Data Migration using SQL *Loader and TOAD Utility. 2+ Years Experience in using Data warehousing tools like Informatica for ETL process 2+ Years Experience in working with Unix Shell scripts.
• Experience in other DBA activities like creating Tables, Complex Views, PublicSynonyms, and Database Links.
• Experience working on Onsite/Offshore Model.
• Experience in advanced PL/SQL concepts like Bulk collect and FORALL.
• Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
• Possess excellent oral / written communication and interpersonal skills.
• Good ability to quickly grasp and master new concepts and technologies.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.
• Experience in writing Test Plans, Defining Test Cases, Developing and Maintaining Test scripts.
• Expertise in Unit Testing, Integration, Functional, System, Performance, Load, Regression Testing and Validation Testing.
• Strong Coding and debugging skills. Self motivated team player with good communication skills. Strong analytical and problem solving skills coupled with excellent written, verbal and inter-personnel communication skills.
• Worked in both OLTP and Data warehouse Environments
• Proficient in preparing Technical Design Documents and Unit Test Documents
• Having Good expertise in all the stages of Full software development life cycle implementation (SDLC)
• Good and Thorough understanding of system development process, from Initial planning through Deployment
• Good working experience in Reports, PL/SQL,Oracle Databases8i/9i/10g and RDBMS Concepts
• Extensive experience indeveloping PL/SQL Procedures, Functions, Packages and Database Triggers and debugging

TECHNICAL SKILLS

Functional Areas

Health, Insurance and retail Domain, Credit Card Data Warehousing

Roles and Responsibilities

T-SQL, SQL, PL/SQL Developer, ETL Developer, Java Developer

Platforms

Windows NT/2002/2007, LINUX, UNIX

Databases

Oracle 9i/10g, SQL Server 2005/2008

Programming Languages

C/C++, T-SQL, SQL, PL/SQL, UNIX and SHELL Scripting, J2SE, J2EE (Servlets & JSP), HTML

Development/Productivity Tools

SQL*Plus Editor, Microsoft Management Studio, Business Intelligent Studio (SSRS 2005/2008 R2), Oracle Developer, TOAD, iSQL*Plus, Informatica PowerCenter 7.x, 8.6, Visual Studio 2008, TURBO C++ IDE

Application Packages

MS Word, MS EXCEL, MS Outlook Express, MS One Notebook

• Proficient in Unix shell and awk scripting
• Good interpersonal, Analytical and communication skills

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN
(PLSQL) Developer May 2012- Till now

Consumer Pricing Initiate (CPI) has several work streams. Confidential, is one of the top 1000 sites in the world and is in the Retailers category. The primary objectives of the Data work stream are to create one common version of Quote and Policy data for Auto. Today in PL (Personal Lines) Applications, policy and quote data reside in multiple data marts, making itdifficult to analyze performance without significant manual intervention to pull all of the data, even prior to analysis. This project is a great example of Operational Excellence, as it takes the basic quote data 'manufacturing' process out of the hands of Marketing and other functions, and creates an automated and centralized source for the quote data. Creating this common source for quote data meansthat leveraging the same data resulting in much more consistency around respective analytic processes and reporting. Additionally, this project willalso result in common definitions of the various data points (ie : responses, quotes, conversions, issues) which will continue to support consistency across functions. In addition to these operational efficiencies, this new data source will include attributes that marketing have not previously had access to, therebyallowing for potentially greater analysis opportunities to understand various program results.

CPI-CAQ (COMMON AUTO QUOTE)
This Project is consolidating 3 data marts in to single data mart using Oracle PLSQL/Informatica

CPI-CAP (COMMON AUTO POLICY)
This Project is consolidating 3 data marts in to single data mart using Oracle PLSQL/Informatica

Responsibilities :

• Involved in gathering elements from different data marts to consolidate in to single data mart.
• Involved in analysis of data marts to understand feasibility and complexity.
• Developed PLSQL Packages/Procedures/Functions to populate data in to stage tables.
• Developed Informatica mappings to move data from stage to target tables.
• Wrote complex SQL queries on oracle tables to pull data for analysis purpose.
• Experience in Working with fact and dimension tables.
• Worked on dimensional modeling.
• Involved in ETL Development using native Oracle tools (SQL*LOADER, Oracle PL/SQL, Informatica).
• Involved in full Software Development Lifecycle (SDLC)
• Perform ETL Testing by validating data.
• Created Tables, Complex views, Materialized views, Force views, synonyms, Indexes.
• Created Partition tables by range using date column to increase the performance.
• Created public database links to access the data from remote databases.
• Scheduling Jobs through Crontab.
• Wrote database triggers for automatic updating the tables.
• Worked on SharePoint portals to share documents (check in/check out) Process.

Environment:
C, C++, UNIX Shell Scripting, Forms , PL/SQL, Oracle 10g,11g. Informatica-8.6, SQL, PLSQL, Toad.

Confidential, Tulsa, Oklahoma
Senior Oracle ETL/PLSQL Developer Oct 2010- Apr 2011

Confidential, is headquartered in Tulsa, Oklahoma. Driven by the mission, "Value Every Time", the Company\'s brands, Dollar Rent A Car and Thrifty Car Rental, serve value-conscious travelers in over 80 countries. Scope of the project is to create an EDW for 4 business units available and provide BI functionality to their sites. Project is divided into multiple interfaces like Location, Product, Product Hierarchy, Store Plans, Merch Plans, and Allocation. Source is called JESTA for all the interfaces is Oracle Database with Front end Forms. Data from JESTA is Moved into Views and Data is Populated into ODS from the Views. Data from ODS is sent to EDW and EP (Enterprise Planning).

• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Created Materialized Views and partitioning tables for performance reasons.
• Worked on various backend Procedures and Functions using PL/SQL..
• Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
• Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
• Developed Informatica mappings to move data from stage to target tables
• Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
• Development of C modules for activation, deactivation and modification of these plans in Clarify Front End
• Created SQL*Loader scripts to load data into the temporary staging tables
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Developed procedures using Dynamic SQL..
• Developed database objects including tables, Indexes, views, sequences, packages,triggers and procedures to troubleshoot any database problems
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• Created Materialized Views and partitioning tables for performance reasons.
• Resolving the issues on priority basis.
• Responsible for Analyzing and Implementing the Change Requests .
• Involved in handling the changes in compiling scripts according to the database changes.

Environment:

Confidential, Houston TX Feb 10 to Oct 10
Oracle Developer (SQL, PLSQL, UNIX)

Through its innovative Relationship Developer Intervention (RDI) Program, RDIConnect Gained a worldwide reputation for Designing Family - based programs. Currently, RDI Connect provides program for an entire range of developmental Difficulties

Accomplishments:

• Manage SQL server database hosted on the IIS remote server
• Develop backend modules (procedures, functions and triggers) meeting business requirements using SQL and PL/SQL
• Designing and building of business reports using SQL Server Reporting Services, SSRS 2005
• Scheduling and running jobs in the background, and taking regular backups of the systems and recover data during failures
• Involved in the extraction of data from different sources like OLTP server, flat files, excel and legacy databases
• Design and develop mappings with required transformations and load the data into the warehouse server for analysis using Informatica Power Center 8.6.1, IDE (Informatica Data Explorer), IDQ (Informatica Data Quality)
• Writing test cases for the code analysis and bug issues before deployment on to the production server
• Investigating and solving payment, registration, customer and business related backend issues
• Customization and maintenance of company's web site built using Telligent API 5.6 hosted on the remote server IIS 6/7.

Environment

Confidential, Albuquerque, NM Oct 09 to Jan 10

Programmer Analyst II

• Installation, Creation and support of Oracle 8i database environments.
• Involved in the maintenance and enhancement of the application.
• Maintaining Logical and Physical structure of the database.
• Creating tablespaces, tables, views, scripts for automatic operations of the database activities.
• Coded various stored procedures, packages and triggers to incorporate business logic into the application.
• Used the technical document to design the database tables.
• Data conversion from flat file to intermediate tables using SQL*Loader,Data mapping
• Created control files for SQL*Loader.
• Gather Database and User Level Statistics and Analyze Overall System Performance.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Monitor database and system backups, developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports.
• Develop UNIX shell scripts to administer the system.
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
• Responsible for purging and archiving the production databases.
• Used UTL_JOB to automate the PL/SQL procedures and packages.
• Involved in Interacting with users, error fixing by enhancing PL/SQL packages, stored procedures & functions.
• Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.

Environment:

Confidential, Vizag AP Aug'07 - Sept'09
Oracle PL/SQL Developer,

Responsibilities: