SUMMARY

• 7 years of diversified experience as Oracle SQL/PLSQL Developer, Data warehouse developer
• Hands on experience in all stages of system development efforts, including requirement analysis, design, testing and implementation.
• Ability to interact with end users and analyze existing systems, conceptualize new ones, design systems Integration, and deploying innovative ETL and client - server based business solutions using the highest standards of quality control.
• Proficient working experience in developing OLTP, Data Warehousing applications and DATA Marts.
• Thorough knowledge of Data Warehousing concepts like Star Schema and Snowflake Schema, Slowly changing dimensions, foreign key concepts, referential integrity, and Cubes.
• Proficient knowledge in creation of database objects like tables, views, synonyms, sequences, Indexes, Triggers, Table partitions, Sub-partitioning, Database links etc.
• Extensive experience in using PLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects, Regular Expressions, FORALL, Merge, Multiple Table Inserts, Global Temporary tables, Collections, DBMS packages and exception handling.
• Excellent knowledge on using dynamic Sql and creating complex PLSQL packages involving them.
• Sound knowledge on analytical functions partition by, rank, dense rank, lead, lag.
• Excellent proficiency in Data Transformations and loading using Export, Import and SQL*Loader and worked on External tables and Transportable table spaces.
• Extensively worked on Query Optimizations and Performance monitoring using Explain Plan, TK-prof, Sql trace and AWR.
• Extensive experience in UNIX (Korn) Shell Scripting and scheduling jobs using CRONTAB and DBMS JOBS.
• Good Knowledge of Erwin and TOAD Data modeling tools, experienced in creating logical and physical data models for ODS (Operational Data Store/Transactional Data Store) and Data warehouse Projects.
• Responsible for helping in creating reports using Business Objects and Cognos in very large size data warehouse environment.
• Proficient experience in working on conceptual, physical and logical data models.
• Involved in interacting with the users and converting business requirements into technical documents.
• Extensively provided production and on-call support.
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Strong personal drive and ability to work individually and in team environments.

TECHNICAL SKILLS

Databases: Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i, MS Access.

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

Languages: C, C++, HTML, XML.

Operating Systems: Windows 2000/XP/95/98, Windows vista, Windows NT, UNIX, MAC, Linux.

Tools: TOAD, SQL* PLUS, SQL loader, Erwin, PVCS, Clear case, OWB, SQL navigator, BI Cognos, Business Objects, Clear Quest, Mantis, Embarcadero, Informatica GUI Oracle Forms 4.0, Reports 4.5, JIRA.

Others: MS Word, MS Excel, MS PowerPoint, Outlook

PROFESSIONAL EXPERIENCE

Confidential, Bethesda, MD

Oracle PLSQL/ETL Developer

Responsibilities:

• Involvement in the design, development, testing and implementation of applications.
• Responsible for development of applications using latest features of Merge/Multiple Table Insert/Loading and logging error in a single statement/Grouping sets, Rollup & Advanced features of Analytical functions.
• Responsible to create functions, procedures packages and triggers to enable data movement from source to target.
• Worked on creating SQL loader scripts to load data received from sources like Guide star, Acxiom, DB, foundations etc.
• Created PLSQL objects to take the data from staging tables, parsing, cleansing and assigning Ids for people, address and organizations.
• Worked on query optimization and performance tuning of SQL and PLSQL scripts using explain plan and AWR reports.
• Involved in creating master tables for people, address and organizations using complex business logic.
• Responsible for creating data migration scripts.
• Closely working with business team on gathering requirements and converting them to technical specifications.
• Involved in creating test scripts and documents them.
• Responsible to provide rotational on-call support.

Environment: Oracle 11g/10g, SQL, PLSQL, SQL * Loader, SQL Developer, TOAD, clear Quest, SVN, JIRA, UNIX, LINUX, windows

Confidential, R.T.P, NC

Oracle PLSQL Developer

Responsibilities:

• Involved in designing conceptual, logical and physical data models using ERWIN Data modeling tool.
• Involved in getting requirements from the users and preparing ETL design and technical specifications for the ETL process of the project.
• Configured OLAP to employ and perform a multidimensional analysis of business data and provide the capability for complex calculations, trend analysis, and sophisticated data model and allowing for complex analytical and ad-hoc queries with a rapid execution time.
• Created SQL script to create/drop database objects via: tables, views, indexes, constraints, triggers, views, materialized views, sequences and synonyms.
• Developed PL/SQL Procedures, Packages, Functions, and Triggers and also performed Bulk Loading and ETL.
• Performed aggregation of data at different levels to populate OLAP Cubes and summary tables and worked on slowly changing dimensions type-2.
• Developed PLSQL packages involving external tables that moves the files of different structures across the folders, extract, transform, validate and loads the data to oracle tables
• Developed PLSQL ETL process that combines the invoices, monthly forecast and yearly budget at product and transaction level.
• Developed Unix Shell and Perl scripts to launch the ETL batch process in scheduled manner.
• Involved in tuning ETL PLSQL packages and SQL queries, views by passing hints and analyzing them using plan table and TK-Prof also created indexes if needed.

Environment: Oracle 10g, SQL, PLSQL, SQL * Loader, Toad 9.0.0.160, SQL developer, PVCS, Clear Quest, clear case, BI Cognos, UNIX-Solaris, windows

Confidential, GA

Pl/Sql Developer/ETL developer

Responsibilities:

• Involved in building Enterprise wide conceptual, Logical and Physical database design using ERWIN.
• Written PL/SQL stored procedures, functions and Packages to retrieve relevant information from various tables into intermediate tables.
• Involved in coding & designing of SQL, PL/SQL procedures and functions.
• Created various types of views to project the data based on front end Requirement.
• Developed the data load layer using Bulk Collect technology involving Oracle PLSQL Collections.
• PL/SQL coding for Exception Handling and Duplicate Data maintaining.
• Wrote PL/SQL scripts for data uploading from one schema to another. Involved in creation and usage of stored procedures and loading of data into data marts using PLSQL on Monthly basis.
• Used ETL to extract data from IBM Main Frame to Oracle and then provide the outbound data file for the data warehouse electronically to another server and load the data into target database-using SQL LOADER.
• Worked with DBAs to correct problems with sequence, grants.
• Created UNIX (Korn) shell scripts, which call the PL/SQL scripts and scheduled those using Autosys.

Environment: Oracle 10g, SQL, PL/SQL, SQL Loader, SQL Developer, TOAD, Erwin, OWB 9i, Autosys, Reports 6i, Clear Quest, clear case, UNIX, and Win NT.

Confidential

Oracle Developer

Responsibilities:

• Involved in developing the capacity plan for the database, estimating the table sizes.
• Job responsibilities included creating database objects like tables, indexes, views etc.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Run batch files for loading database tables from flat files using SQL*loader.
• SQL programs to load data from temporary table into database Tables.
• Performance monitoring and Tuning of SQL developed by various developers.
• Developed PL/SQL packages to update and delete records from existing databases and indexes.
• Developed PL/SQL Procedures, Packages, Functions and Triggers and also performed Bulk Loading.
• Developed various Process and scheduled them using CRON.
• Developed forms using forms 4i for the purpose of online orders
• Generated monthly sales report for manager’s review using reports 4.5.
• Involved in designing and coding of the oracle reports as well as modified the oracle reports to meet the new requirements.
• Developed various UNIX Shell Scripts to automate the routine tasks.
• Developed the shell script to send the monthly invoice through email retrieved from database

Environment: UNIX, PERL AND WINDOWS, SQL DEVELOPER, TOAD, OWB 9I, SVN, ORACLE 9I/10G, PL/SQL, SQL, SQL PLUS, SQL LOADER