SUMMARY

• Over 7+ years of professional experience in Data Analysis, Data Modeling, Data Cleansing, ETL Development/Testing, Migration, Conversions, Performance Tuning, and Process Documentation for Enterprise Data Warehouses (EDW), Star Schema Dimensional Data Marts and Operational Data Stores (ODS) for IT industry.
• Proficient working experience in SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers and Indexes.
• Involved in the development, Enhancement and Maintaining of applications in Oracle 8i/9i/10g using SQL, PL/SQL, Oracle Forms and Reports in windows and Unix environments.
• Extensively worked on PLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects, Collections, Table Partitioning, Bulk Binds and Bulk Collects.
• Proficient knowledge in building database applications using SQL and PLSQL.
• Excellent proficiency in Data Transformations and Loading using Export, Import and SQL* Loader.
• Experience in Porting/migration of data from Legacy system to Oracle Database and also involved in the upgrades.
• Expertise in writing PLSQL ETL routines in data warehousing applications.
• Very good experience at HTML and JAVA scripting skills.
• Hands - on experience in all stages of system development efforts, including requirement analysis, design, testing and implementation.
• Having Good knowledge of Linux, and Shell Scripting.
• Experienced with Autosys job scheduler including jil scripting, virtual machines and custom calendars.
• Hands on experience on creating database model for Asset and Risk Management application.
• Performance Tuning of Legacy Systems assisting the organizations in greatly reducing their maintenance costs over the Business Systems.
• Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques, and Indexes.
• Expertise in Unix/Linux Scripting for Database Extraction and filtering, automating routine tasks using CRONTAB and DBMS JOBS.
• Experience in preparing technical documentation and user manuals.
• Has good knowledge of overall process of rapid application development (RAD).
• Excellent analytical skills, logical reasoning, and interpersonal skills.
• Strong team player, ability to work independently and in a team as well, ability to adapt to a rapidly changing environment, commitment towards learning, Possess excellent communication, project management, documentation, interpersonal skills.
• 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, 10g, Oracle 9i, Oracle 8i, MS SQL Server 6.5/7.x.

Scripting: SQL, PL/SQL, UNIX/Linux Scripting, PERL scripting

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

ETL/BI Tools: TOAD, SQL* PLUS, Cognos, Business Objects, Informatica, Crystal reports.

Data Modeling: Erwin, ER/Studio, Visio, TOAD

Operating System: Windows 2000/XP/95/98, Windows vista, Windows NT, Unix, MAC, Linux.

Methodologies: Star, Snowflake and multi-dimensional data modeling, MDM, CDI, OLAP

GUI: Oracle Developer - Forms 6i/9i/10g, Reports 6i/9i/10g

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

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. Pl/Sql Developer

Responsibilities:

• Wrote Sql queries to pull data as per business needs.
• Creating work around for critical production issues.
• Created UNIX shell scripts to monitor production servers.
• Investigating and raising defects in production servers.
• Created UNIX (Korn) shell scripts, which call the PL/SQL scripts.
• User management.
• Updating data in production servers.
• Modifying XML’s to remove invalid characters.
• Helped in deployment of patches and monitoring the production servers after deployment.
• Ensuring smooth flow of business operations and order provisioning.

Confidential, Freeprot, NY

Sr Oracle Pl/Sql Developer

Responsibilities:

• Wrote Sql, procedures, functions and packages to develop reports as per business need.
• Worked on query optimization used in report to improve performance.
• Tuned and optimized the complex SQL queries.
• Solved critical production issues.
• Created LINUX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources
• Created UNIX(Korn) shell scripts, which call the PL/SQL scripts and scheduled them using Autosys.
• Developed Teradata Export Scripts in Linux environment using various (LOGMECH, BTEQ & FEXP.etc.,).
• Migration of production report from old schema (10g) to new schema (11g).
• Helped in data quality check, data validation of migrated reports.
• Design and develop procedure and sql script to facilitate the data validation process.

Confidential, Reston, VA

Sr Oracle Developer

Responsibilities:

• Built batch Jobs which includes Stored Procedures, Functions, Packages.
• Involved mainly in loading claims (ETL) in to the system from different sources.
• Loaded Data from flat file in DB through SQL Loader.
• Extensively involved in Performance Optimization of long running Queries.
• Designed some the core processes required as per business need.
• Used Oracle Parallelism for optimization.
• Created Shell Scripts for the batch jobs which run on a regular basis.
• Solved critical Production batch job issues.
• Wrote documentation detailing the custom reporting processes and created diagrams documenting Autosys job changes.
• Worked on defects of the newly built project.
• Created various LINUX Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Linux Shell Scripts
• Used Bulk Collect, Bulk binding for performance.
• Used EXPLAIN PLAN, TKPROF to improve the efficiency of the code.

Confidential

Sr Oracle Pl/Sql Developer

Responsibilities:

• Wrote Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes.
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Optimized SQL used in reports to improve performance dramatically.
• Tuned and optimized the complex SQL queries.
• Had to design database model risk management application.
• Worked with Business users to gather requirements for developing new Reports or changes in the existing Reports.
• Developed Linux Shell scripts to automate table creation, execute procedures. Created some oracle objects for OLAP.
• Extensively used SQL*Loader scripts to load legacy data into Staging tables and relevant Packages to validate and cleanse data.
• Created Cursors, Collections and DB Triggers.
• Created INDEX BY Table Method to Fetch Records in Random Selection.
• Fine-Tuned and optimized number of SQL queries and performed code debugging using TOAD.
• Set up batch and production jobs through Autosys.
• Created Shell scripts to access and setup runtime environment, and to run Oracle Stored Procedures, Packages.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Worked with HTML, JavaScript pages in order to create web pages and fix bugs for the Rhapsody web site.
• Developed site according to client specifications with HTML and JavaScript.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Tuned SQL queries, performed refinement of the database using tools like EXPLAIN PLAN, and TKPROF to significantly improve the system response, time and efficiency.
• Developed stored procedures, functions and packages for updating, inserting and deleting data from the tables.

Confidential, Irvine, CA

Oracle Pl/Sql Developer

Responsibilities:

• Designed complex data model and designed tables to automate a process by giving extreme flexibility to the code.
• Designed and developed data validation, and loaded processes using PL/SQL, Stored Procedures, Functions, Triggers, and Packages using Oracle 8i.
• Used Toad Pro for developing Stored Procedures as IDE to interact with the Oracle 9i/8i Database.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling.
• Created LINUX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources
• Created Control Files and used SQL *Loader to upload bulk data.
• Involved in Performance Tuning and monitoring.
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Produced Scripts to cleanse source data, ETL process (Extract, Transform & Load) data with business rules, and built re-usable Mappings.
• Provided 24/7 support for ETL and Oracle PL/SQL processes that were automated and scheduled through Autosys.
• Optimized critical queries to eliminate Full Table scans.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and kept logs.
• Analyzing Business requirements with product management for new release cycles.
• Wrote Integrity Checks to clean erroneous data using PL/SQL procedure and Shell Scripts.
• Used Rational Unified Process in obtaining the generic code samples and determining the key processes.

Confidential, Louisville, KY

Oracle Developer

Environment: PL/SQL, Oracle 8i, Toad, Forms 6i, Reports 6i, and Windows NT

Responsibilities:

• Meeting with end user, collecting requirements and converting into technical specification.
• Developed Stored Procedures, Functions and Packages for implementing complex business logic.
• Created and maintained Oracle schema objects like Table spaces, Tables, Rollback segments, Indexes, Sequences and Synonyms.
• Created SQL*Loader scripts to load data from external system to oracle.
• Created UNIX Shell script for sending email to alert users for erroneous records.
• Responsible for performance tuning of SQL queries written in procedures and functions at the back end which are called from the front end forms.
• Involved in Technical Documentation, Unit test, Integration Test and writing Test plan.
• Created data entry Forms using oracle Forms 6i for entering data related to Order Information and inventory.
• Assisted in the development of a standardized batch processing environment utilizing UNIX Korn shell scripting and the Autosys job scheduler
• Built custom forms using Oracle Forms 6i Builder to fulfill the business requirements of the client.
• Created and customized analytical reports for existing system using Reports 6i.