PROFESSIONAL SUMMARY:

• Over 6 +years of experience with 3 Full (SDLC) life cycles implementation and expertise in Data Base Design, Data ware house, Application Development and Production Support in Client/Server Environment using Oracle 11g/10g/9i/8.x, SQL, PL/SQL, Oracle Data Integration, AbInitio, Cognos, PeopleSoft SQR Unix Shell Scripting and Autosys.
• Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation.
• Designs, develops, codes, tests, and debugs complex new software products, or makes significant enhancements to existing.
• Researches and integrates design strategies, product specifications, development schedules, and user expectations into product capabilities.
• Resolves complex hardware/software compatibility and interface design considerations.
• Support Integration and configuration of MDIMS/MTESS.
• Experience in design and development using Oracle Forms/Reports 6i/10/11g.
• Experience in design and development using Oracle Forms/Reports 6i/10/11g.
• Excellent proficiency in Data Extraction, Transformation and Loading, Database Modeling and Data ware housing tools and technologies such as Ab Initio, ODI, SSIS and Erwin.
• Worked extensively with Dimensional Modeling (Data Marts, Facts and Dimensions), Data Migration, loading high volume of data, Data Cleansing, ETL Processes.
• Excellent track record in the implementation of business applications and in using RDBMS OLAP, OLTP and OOPS Concepts and effective utilization of the technologies viz. Ab - Initio, Oracle Database, ODI, Business Objects, and COGNOS 8.
• Profound Knowledge in Star Schema Modeling and Snowflake Dimensional Modeling. And diverse experience in understanding the logical & physical data models.
• Extensively worked on the ETL mappings, analysis and Performance Tuning of the Ab-Initio code by applying concepts of parallelism and multi file usage.
• Extensively worked on tools like Quality Centre, CA7, Control-M, ESP and Opalis.
• Extensive experience in developing and maintaining database objects - PL/SQL Stored Procedures, Functions, Packages, Tables, Materialized Views, Views, Cursors, Collections (Nested tables and V arrays), Records, Object types and Database Triggers, Indexes, Sequences, Synonyms, Database Links and Database Directories.
• Expertise in Performance Tuning of Legacy Systems assisting the organizations in greatly reducing their maintenance costs over the Business Systems using utilities like EXPLAIN PLAN, SQL Trace and TKPROF to improve the performance. And experience in Query Optimization using various types of Hints, Partitioning, Bulking techniques and Indexes.
• Strong experience in Oracle ETL data loading techniques like UTL FILE, SQL loader, Copy Command and External tables from various business source environments.
• Strong knowledge of UNIX Shell Script on Sun Solaris 2.8/2.7 and HP UNIX 12.x/11.x. and Autosys Jil Programming.
• Advance working skills in programming with ANSI SQL for Oracle Database, relational database theory and data modeling and should be experienced with Oracle..
• Worked on KORN Shell Scripts for maintenance and Application Support.
• Work closely with users to understand and prioritize business goals and information needs, then translate these needs into system requirements and design specifications; refine conceptual systems design requirements into the technical design.
• 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.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g, MS-SQL Server 7/2000, MS Access.

Scripting: SQL, PL/SQL, UNIX Shell Scripting, ASP, VB Scripts, Java Scripts and

Languages: C, C++, COBOL, Java, HTML/DHTML, XML, PERL, PRO*C, T-SQLReporting Tool: Business Objects, Crystal Reports, COGNOS 8

ETL Tool: Ab-Initio, ODI

Query Tools: TOAD, SQL Developer, SQL Navigator, SQL* Plus, ISQL * Plus

Operating Systems: HPUX, Solaris 7.0/8.0,MVS, Windows 2000/NT/XP, Window 95/98UNIX, LINUX 9.2/9.3

GUI: Developer 2000-Forms 6i/9i, Reports 6i/9i

Packages: Micro Soft Office Suite- MS-Word, MS-Excel, MS-Power point.

Other Tools: SQL*Loader, Erwin, MS-Visio, MS Project Professional 2003, PVCS

PROFESSIONAL EXPERIENCE:

Confidential - Plano, TX

Sr. ETL/ Data warehouse Developer

Responsibilities:

• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems.
• Designed and developed the ETL process for learning data mart and made use of database objects efficiently towards the fulfillment of business requirements.
• Extensively wrote the PL/SQL and SQL programs and Designed and developed the views, materialized views, functions, procedures, packages, triggers and cursors.
• Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Developed an End to End Data load process from ODS system to application reporting tables with all business rules implemented efficiently and effectively.
• Managed a reporting team of 4(onsite & offshore) with effective project plan for ELM 92 and successful met the timelines with a bug free efficient product release.
• Worked as secondary in the Rapid Disaster Recovery team providing high quality and efficient services for reporting data outages. And provided Level 3 Application Production support for the Enterprise Workforce Development reporting system.
• Provided continuous and efficient enhancement, optimization and permanent long lasting solution for production tickets. .
• Designed and Developed Cognos reports for Learning Survey Reporting using complex PL/SQL procedures and relational database theory and data modeling and should be experienced with Oracle. .
• Knowledgeable is Oracle Databases 9i/10g/11g with strong SQL skills.
• Proficient in developing interfaces/batch jobs using Pro*C.
• Created List Reports, Dash Board Reports, Cross-tab Reports, and Charts using Tabular SQL, Tabular s and Tabular Sets to reduce the load on the Framework Manager model and improve the report performance.
• Extensively worked on Performance tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques and Indexes
• Extensively worked on Unix Shell (Ksh) scripts for the support and server based tasks.
• Supporting and working closely with Application operations on call support team to address issues of failed jobs.
• Actively designed and prepared Functional design, Technical design and User manual Documentation and closely worked with customers giving on the application features and usage.
• Worked with business partners to create Test scenarios and helping Test scripts and also managed the UAT and migration processes until complete product release. And worked as an effective liaison between business users and reporting team.

Environment: Oracle 10g/11g,PL/SQL, SQL Loader, Cognos, SSIS, Visual Studio 2008, Windows NT 4.0/2000/XP,UNIX and ESP.

Confidential - Phoenix, AZ

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in gathering business requirements, clarification and system design.
• Extensively worked in End-to-End phases of the application design, development, testing, production deployment and documentation.
• Prepared proto-types for the system design & approach and participated in business users presentations.
• Ability to mentor/train USPS personnel on all documentation.
• Developed Complex UNIX shell scripts and Autosys jobs for the scheduling and automation of the application jobs execution.
• Developed efficient and effective Autosys Jil code for the TAXBUS Application with added troubleshooting and debugging features. Also added feature in Autosys for intermediate status email alerts which facilitate the monitoring of the jobs execution.
• Involved in Source code release to higher environments (QA, UAT and Production) using the IBM Rational ClearCase version control tool.
• Developed PL/SQL packages, procedures, functions, Indexes, sql scripts for the implementation of the very complex business requirements.
• Implemented the COPY command successfully to insert huge amounts of data into the target system from ADW (the source database).
• Improved performance of the extract - loads and existing applications for huge volumes of data by optimizing the queries, indexing and redesigning some of the scripts.
• Extensively supported production for all the UNIX, Autosys, Oracle and Reporting issues.
• Prepared test data and expected results for the system testing with possible business functional scenarios to make the system bug-free.
• Supported BOXI reports testing and prepared expected results using complex sql queries.
• Involved in System testing, Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and walkthroughs.

Environment: Oracle 10g,PL/SQL, SQL*Plus COPY, BOXI, SQL*Plus, Windows XP and UNIX, IBM Rational ClearCase.

Confidential - Irving, TX

Sr. Oracle PL/SQL Developer

Responsibilities:

• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems.
• Designed and developed a huge database of 350 tables and its data load process from flat files and also designed complex functional views for Staffing application.
• Extensively used SQL Loader, UTL FILE and External Table mechanisms to load legacy data, feed files data and data from various sources into the Oracle database tables.
• Designed and developed the Packages, procedures, functions efficiently in loading, validating and cleansing the data. Also worked on creating users and roles as needed for the applications.
• Extensively used UTL SMTP and windows blat techniques to develop the monitoring processes to automatically notify the source systems, administrators and users through email alerts on missing feed files, unsuccessful job runs and load status of scheduled load processes and backup jobs.
• Extensively wrote the PL/SQL and SQL programs and Designed and developed the views, materialized views, functions, procedures, packages, triggers and cursors.
• Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Worked on Performance tuning using the Partitioning and indexing concepts (Local and Global indexes on partition tables).
• Involved in the design and development of user interfaces and customization of Reports using ASP and as well as COGNOS.
• Worked on Cognos Cubes building and Framework modeling for Performance Management Systems Reporting.
• Used my strong experience to program in PL/SQL batch environment utilizing large database tables and high transaction throughput requirements.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems.
• Gained experience in Database migration, replication and conversion. Also had hands on experience in using ODI to load oracle tables from DB2 database.
• Worked on Windows Batch scripting and scheduling jobs and monitoring logs.
• Developed applications to automatically send the process logs and alerts the business users and data source group.
• Able to coordinate the creation Technical Requirement Documents (TRD), Rough Order of Magnitude (ROM), Requirement Traceability Metric (RTM)Worked on Production support for the backend database and reporting applications.
• Involved in importing Source Tables from the different databases.
• Worked on Mainframe Focus Code/ PeopleSoft SQR Conversion to Oracle PL/SQL as a part of PeopleSoft database retooling.
• Involved in Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and Walkthroughs.
• Created Developer’s Documentation and User’s Manual.
• Involved in continuous enhancement, optimization and fixing of problems.
• Provided technical support to the user with regard to operational aspects.

Environment: Oracle 10g/11g,PL/SQL, SQL Loader, Cognos, ODI, SQL*Plus, Windows NT 4.0/2000/XP and UNIX.

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Worked with Business Users to gather requirements for developing new Reports and also Changes in the existing Reports.
• Designed and developed Reports according to user specification. Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Extensively Involved in Performance tuning and Optimization of the SQL queries.
• Wrote Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes and also performed code debugging using TOAD
• Set up batch and production jobs through Autopsies.
• Support Implementation of upgrade projects of MDIMS/MTESS.
• Created Shell scripts to access and setup runtime environment, and to run Oracle Stored Procedures, Packages
• Created UNIX Shell Scripts for AbInitio feeds and to execute Oracle procedures.
• Created dynamic parameter files in UNIX Shell Scripts which is used in AbInitio.
• Designed processes to extract, transform, and load data to the Data Mart.
• Worked with Business Users to gather requirements for developing new Reports or Changes in the existing Reports.
• Designed and developed Reports according to user specification. Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Optimized SQL used in Reports and Files to improve performance drastically.
• Involved in AbInitio mappings development using Power Mart tools to create the tasks & workflows.
• Used various transformations like aggregator, Update strategy, Lookup, Expression, Stored procedure Filter, Source Qualifier, Sequence generator, Router, Update strategy etc.
• Involved in the tuning of AbInitio mappings and sessions also database routines wherever applicable.
• Created Abinitio mappings with PL/SQL procedures/functions to build business rules to Load data.

Environment: Oracle 9i, Oracle Reports 6i, SQL, PL/SQL, Erwin, TOAD, Unix, ETL, Abinitio Power Center 6/5.x, PVCS Version Manager, Exceed, Test Director.

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Interacting with Business users, gathering and analyzing requirements and Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
• Provided technical solutions in the form of MDD (Minor Development Document) for the Process Change Requests from Business.
• Involved in the design of database schemas and data mapping of client’s databases with DCX’s transactions databases.
• Involved in the design of logical and physical data modeling using ERWIN Tool. And also designed star schemas using dimensional modeling and created fact and dimensional tables.
• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse.
• Involved in Performance tuning and optimization of SQL queries for data warehouse consisting of many tables with large amount of data.
• Created PL/SQL packages, procedures and functions that extensively used PL/SQL cursors, user defined object types, exception handling.
• Extensively used IMPORT utility to load the exported files.
• Automating data loading, extraction, report generation using UNIX shell scripting.
• Responsible for the production issues and bug fixing.
• Active involvement in Optimization Process through database capacity planning, creation of materialized views, partitions, tables, views, indexes etc as.
• Designed ETL to extract external data (Oracle, Excel file) and load data using SQL*Loader.
• Analyzed and produced UML diagrams to reflect existing business models.
• Designed UML Models (Visio) and Relational data Models for applications.
• Worked on Business Objects (BO) to deploy various reports onto production.
• Developed ETL for Data Extraction, Data Mapping and Data Conversion for various application and processes..
• Extensively worked in the UNIX Environment using Shell Scripts, Technical Requirement Documents (TRD), Rough Order of Magnitude (ROM), Requirement Traceability Metric (RTM).
• Automating data loading, extraction, report generation using UNIX shell scripting.
• Created an induction manual for the ETL process and production support document

Environment: PL/SQL, Oracle 9i, Maestro Scheduler, ERWIN 3.5, AIX UNIX, Windows NT/2000, SQL Navigator, Windows NT/2000/XP.