Summary:

• 11 years of experience in Design, Development, Enhancement and Maintaining applications in Oracle 8i/9i/10g using SQL, PL/SQL in Windows 9x/NT/2000/XP and UNIX environments.
• Fair understanding of Oracle 11g.
• Experience in all phases of the Application Development cycle - Design, Coding, Testing, Maintenance and Documentation, configuration management
• Extensive and very intense SQL coding, database modeling, and development experience for OLTP database and OLAP database.
• Detailed in-depth knowledge in Oracle Architecture, Data Dictionary and DBMS Packages and Normalization techniques.
• Experience with E/R, relational, dimensional, star, snowflake models
• Expert in writing Stored Procedures, Functions, Database Triggers and Packages using PL/SQL.
• Enforcing data integrity using integrity constraints database triggers.
• Experienced in SQL Loader, Export, Import and SQL Plus.
• Enforcing security by creating roles, granting system and object privileges on the tables, stored procedures.
• Exposure in Essbase cube development, Analytical Integration Services AIS , Financial Reports and Interactive Reports.
• Exposure in Oracle Data Integrator 11g ELT
• Worked with very large tables and databases which are sized in Terabytes.
• ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center 7.1.1 using Designer Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer , Repository Manager, Workflow Manager Workflow Monitor
• Fair understanding working knowledge in UNIX Shell Scripts.
• Domain experience: Telecommunications, Pharmaceutical, Hotel Management, Manufacturing, and Health care industries insurance.

Technical Skills:

• RDBMS: Oracle 7.x, 8.x, 9i, SQL Server 2005, MS Access,
• OS: Windows 9x/NT/2000, Windows XP, UNIX HP, SCO , MS-DOS
• Languages: C, C , COBOL, Java, J2EE, FORTRAN, Pascal, Perl, UNIX shell Scripting
• Graphics: Adobe Photoshop 5.0
• Testing Tools: Win Runner, Load Runner and Test Director
• Tools: SQL PLUS, Erwin, PL/SQL Developer, Oracle forms and reports, Informatica Power Center 7.1.1 , ODI Developer 11g, SQL Navigator, TOAD, Visual Source Safe, XML SPY, Dream Weaver, Essbase, Financial Reports, PVCS,IR Reporting

PROFESSIONAL EXPERIENCE

Confidential

Oracle Developer

Responsibilities

• Re-Engineered the existing CDR Model and create detailed Data model documents.
• Identified the procedures and packages and scripts for each process and document.
• Developed the ODI mapping for full load to populate source data into target tables.
• Knowledge of customizing the knowledge Modules as required by business design.
• Developed the ODI mapping for incremental update for the Production Schema.
• Developed the CDC for capturing the changes in Baseline to update the Production.

Environment: Oracle 11g, PL/SQL, HP-Unix, Toad, ODI Developer 11g, CVS Subversion

Confidential

PL/SQL Developer

Responsibilities

• Designed, created and tested enhancements to a high performance OLTP client server system processing for both daily and scheduled financial transactions.
• Involved in designing Technical Design Documents based on health care Business requirements.
• Extensively used advanced PL/SQL concepts e.g., varrays, PL/SQL tables, cursors, user defined object types, exception handling, database packages, nested tables to manipulate data
• Created indexes on tables to improve performance of the queries
• Used BULK COLLECT to improve the performance in batch processing.
• Used Control M a third party tool to schedule various others batch processing jobs.
• Used Explain Plan to improve the performance of database queries.
• Used EXECUTE IMMEDIATE to execute dynamic SQL.
• Designed and implemented file transfer mechanisms, using FTP, Secure FTP in support of file transfers between internal corporate systems and external vendors.
• Used SQL LOADER to load flat files in to tables.
• Used analytical functions to compute cumulative, moving, centered, and reporting aggregates.
• Involved in creating the interface between Oracle and Java platform.
• Used XML DB options for generating XML from the database
• Developed and implemented dozens of automated batch processing jobs, running in numerous development, test and production environments, involving hundreds of UNIX shell scripts, UNIX utilities and occasional short SQL scripts.

Environment: Oracle 11g/10g/9i, SQL Navigator 5.5, Rational Clear case 7.0, Quality Center 9.2, UNIX, Win 2000/XP.

Confidential

Sr.Oracle Developer /PL/SQl developer

Responsibilities:

• Involved in Performing analysis of existing system's efficiency and suggesting improvements.
• Made necessary changes to existing Database Objects and added new whenever required.
• Subversion technology used to maintain the source code.
• Extensively worked with table partitioning
• Used UTL File Packages to Load data from Excel Sheet to Oracle Tables.
• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
• Made necessary changes to existing Database Objects and added new whenever required.
• Checked the data for data cleansing purpose for data consistency
• Used TOAD for faster application design and developments
• Creating UNIX shell scripts for Data loading.
• Store data from flat files using SQL Loader.

Environment: Oracle 10g PL/SQL, SQL Developer, PL/SQL Developer, Toad, Shell Scripting, UNIX

Confidential

Sr. Oracle Developer /PL/SQl Developer

Responsibilities:

• Worked on complete Project Life Cycle that includes requirement gathering, development, testing and production support for the finance Revenue and billing applications and order management departments.
• Developed Oracle PL/SQL stored procedures, triggers, functions, packages, materialized views, SQL scripts and database objects to facilitate the Extraction-Transformation-Loading ETL process.
• Designed and build OLAP processes using PL/SQL packages and triggers
• Extensively used Erwin tool for forward and reverse engineering adhering to the corporate standards in naming conventions using conformed dimensions whenever possible.
• Designed and Developed Logical and physical Data Model of Star Schema including Dimension and Fact tables
• Involved in analyzing and adding features like DBMS LOCKS, DBMS SHEDULER, DBMS JOBS and creating directory and Hirecharical queries and Indexes Bitmap and B-tree .
• Used Bulk Collect feature and Dynamic Sql to improve performance.
• Created the Partitions and Sub-Partitions on the Oracle tables dynamically.
• Involved in extracting large volumes of data from different data sources, performing transformations and loading that data and provided interface between Oracle and Hyperion tools.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain plan
• Troubleshooting and resolving issues in various aspects of the post production support
• Designed Essbase cube structure through user interaction and requirement gathering.
• Created dimension build and data load rule files for cubes.
• Used the VI editor to create korn shell scripts.
• Used file transfer protocol to transfer the files between production servers
• Automated the cube build process through Maxl and running those Maxl from UNIX shell scripting.
• Version control using PVCS, Managed delivery and deployment of the development objects to higher environments using deployment channel.
• Involved in optimizing and tuning Aggregate Storage/ Block Storage Databases.
• Developed Drill-to-Detail DTD functionality for users that acted as an interface between the Essbase cubes and Oracle tables. Through this functionality users were able to view detailed information from summarized data in the cube.
• Worked on overall architecture and coding for the data retention policy that eliminated the yearly maintenance cost.
• Automated the manual cost allocation model that significantly led to time savings for client from almost 2 months to 30 mins.
• Involved in the overall developments of project from start to end that involved technologies like Oracle, Essbase, Interactive Reports and UNIX.
• Achievements
• Post System 9, the users' required duplicate member names in the cube, a new feature introduced in System 9.
• Responsible in smooth transition between Essbase version 7.1x to 9.3.1 upgrade.
• Created the interface between Oracle and Master Data Management MDM , a Hyperion tool.
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Redesigned the E-T-L process and Essbase interface to reduce overall Processing times of the application
• Created and supported interface between oracle and Essbase for One of the project which have 46 dimensions,34 measures and 46 gb of extract file

Environment: Oracle 10g PL/SQL, SQL Developer, Sql Navigator,PL/SQL Developer, Toad, Shell Scripting, UNIX,VBA,Windows NT, Erwin, VI editor, F-Secure SSH, System 9/7 Essbase, Master Data Management DRM/MDM , Interactive Reporting, PVCS.

Confidential

System Design Engineer

Responsibilities:

• Prepared the technical specifications.
• Involved in the Design and development of script files for Tables creation, Procedures, Packages, Functions, and Triggers for the application.
• Involved in the development by working with the team under guidance of team leader in supplying customization rules and development of the project.
• Store data from flat files using SQL Loader
• Queries are run on the metadata that is migrated to Highview as searchable indexes
• Maintenance and Updating of Oracle database
• SQL query and PL/SQL programming Performance Tuning
• Preformed the analysis to determine to what extent data cleansing is needed for the data conversion
• Developed Oracle Forms and Reports for the user interface a data load using PL/SQL and SQL Loader and cron jobs calling Unix scripts to download and manipulate files
• Used TOAD for faster application design and developments
• Used the Objview program to extract images and image order
• Testing the whole system and documentation of the project.
• Creating perl script Unix shell scripts for Data loading

Environment: Oracle 9i, Sqlplus, Toad, Window NT, Oracle Forms 6i Oracle Reports 6i, Unisys Objview program,Perl,Unix, SQL Server 2005, .NET,PVCS

Confidential

Oracle Developer /PL/SQl developer

Responsibilities:

• Developed back end interfaces using PL/SQL packages, stored procedures Collections, Object types, triggers.
• Created tables, indexes, views, sequence, synonyms.
• Created and validated Dimensional Model based on the requirements
• Support and development of OLAP database system with Customer account information
• Developed Stored Procedures, Functions and Packages, database triggers.
• Planning and implementation of security user access and privileges for database objects/application data, Control user privileges within a database.
• Implemented the code involved in modifying the database records using nested queries and PL/SQL routines.
• Supported Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL.
• Developed Complex system and application triggers using PL/SQL for data integrity and enforcing business rules.
• Improved performance of Application using PL/SQL Packages and Oracle in built Packages.
• Manipulated Complex Data types within PL/SQL using collections.
• Performance tuning on sources, targets, mappings and SQL queries in the transformations
• Created reusable transformations and mapplets based on the business rules to ease the development
• Used various Informatica Error handling technique to debug failed session
• Store data from flat files using SQL Loader.
• Created global variables and cursors for procedures and functions through PL/SQL packages.
• Used UTL FILE package to write an outbound interface program
• Used PVCS as version control tool to migrate the code from environment to environment
• Checked the data for data cleansing purpose for data consistency
• Used TOAD for faster application design and developments
• Extensively wrote shell scripting

Environment: PL/SQL, Oracle 9, SQL, UNIX, Windows 2000, Informatica Power Center 7.1.1, Erwin, Windows NT, SQL LOADER, J2EE, Toad.

Confidential

System Design Engineer

Responsibilities:

• Involved with writing the specifications and Analyze the code and design document
• Designing the data entry forms
• End to End Software Development Life Cycle SDLC
• Wrote the import program for importing data from the text files into the database
• Involved in designing and developing business services components
• Involved in the design of Technical design document
• Worked extensively in Tuning SQL statements to optimize the performance.
• Extensively involved in gap analysis
• Wrote PL/SQL scripts for creation of procedures, triggers.
• Created oracle forms inbound screen, claim screen, claims report screen.
• Support of OLTP database system with claims information.
• Created stored procedures for adjudication purposes.
• Created balancing report.
• Creating Perl script for automation of data loading processes
• Performed user testing, load testing.

Environment: Windows NT 4.0, Oracle 8i, Java, SQL Time 5, PL/SQL, SQL Loader SQL PLUS, Mercury Interactive Loadrunner 7,Perl, Visual Basic

Confidential

Sr. Oracle Developer /PL/SQL Developer

Responsibilities:

• Based on Software Development Life Cycle standard, analyzed the business requirements
• Worked with the Business Analyst to define business needs, and delivered the comprehensive Functional Specifications
• Completed the logical data modeling and physical data modeling using Erwin
• Design and implement star-schema based data warehouse
• Sql coding and performance tuning the OLTP data warehouse performing 30-to-40-million database transactions
• Managed the database and performed the basic tasks like creating users, assigning roles and privileges, creating new tables etc.
• Modified the database, added new tables, and views to accommodate a new functionality as per the user requirements
• Developed the Unix shell script, SQL Loader script, and most of the stored procedures, triggers, and views to handle the Online and Batch process, as well as audit trail, interface recall process.
• Created forms screens using Sql forms and Sql menu
• Used crontab for scheduling the job
• Maintenance and Updating of Oracle database, Monitored daily activities and troubleshooting
• SQL query and PL/SQL programming Performance Tuning
• Performed unit test, system integration test to make sure the deliverables are match with business requirement
• Developed and maintained the system using Oracle Forms, Oracle Reports, SQL Plus and PL/SQL
• Actively communicated with users to identify their enhancement requirements and followed the SDLC guideline in each enhancement release
• Performed application documentation and provided technical support

Environment: Window NT, UNIX, Oracle 7, Erwin4.0, Sql forms 3.0,Sql Menu 3.0, PL/SQL, SQL Loader, FTP.

Confidential

Database Developer

Responsibilities:

• Participated in requirements gathering, requirements process analysis by attending key user meetings
• Reviewed the database solution and the customer requirement Specifications
• Completed logical and physical design specifications using Erwin
• Created various tables, views, indexes and sequences
• Created grants of roles and privileges to the users
• Developed SQL Loader Scripts for data extraction and transformation
• Evaluated the data quality using developed PL/SQL stored procedures and Unix shell scripts
• Wrote a number of control files to load data in to Oracle tables using SQL Loader
• Analyzed current procedures, recommended and implemented improvements as needed
• Monitored daily activities and troubleshooting
• Performed programming debug, unit and integration testing
• Implementation documentation and user training
• Worked with clients and the development team throughout the project life cycle and confirmed all documents

Environment: Windows NT, UNIX Oracle 6, Erwin 3.5, PL/SQL, SQL Loader