SUMMARY

• 8 years of experience in Oracle 8i, 9i, 10g, 11g developing back - end modules, such as Packages, Functions, Procedures, Triggers, Object types, Collections, Indexes, sequences and Views for multi-tier business applications, both Data Warehouses and OLTP systems, in SQL and PL/SQL.
• 4 years of using Informatica Powercenter(9.0) for Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions.
• Around 4 Years of Experience in Perl Scripting & UNIX Shell scripting.
• Comprehensive Experience in Analysis, Design and Development (Coding, Testing & Maintenance) of various types of oracle technology based projects in multi-tier environment for sectors like HealthCare, Banking and Insurance.
• Good knowledge of supporting development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, SQL developer and TOAD.
• Excellent knowledge of data warehousing concepts like star schema and snowflake schema, data marts used in relational and dimensional modeling.
• Good knowledge on working with DB Links and also creating materialized views like Read Only, Updatable, and Writeable.
• Proficient in advance features of Oracle for PL/SQL programming like using cursors, variables, Ref. cursors, Varrays, nested tables, associative array, Dynamic SQL, query optimizer and nested loops.
• Strong working experience in Query construction, Stored Procedures and Application based Triggers and User Defined Functions using SQL, PL/SQL and SQL Plus.
• Good knowledge of key Oracle performance-related features, such as cost-based optimizer, execution plans, hints, indexes, clusters and partitioning.
• Experience in Performance Tuning & Optimization of SQL statements.
• Expert in tuning complex Stored Procedures for faster execution and Developed database structures, according to the requirements in Oracle data warehousing.
• Extensively used Informatica Powercenter as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Excellent in created Sessions using Work Flow Manager and Monitored the performance of the session through Gantt chart, Task View in Work Flow Monitor.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Experienced in creating Transformations and Mappings using Informatics Designer and processing tasks using Workflow Manager to apply business logics and to move data from multiple sources into targets.
• Experienced in preparing Technical design document, Mapping documents, data definition documents, Detail design document for the Source/Target mapping.
• Experienced in business modeling of Client/Server systems, Distributed Applications and other custom-built projects on UNIX and Windows.
• Expert in writing shell scripting on different type of shells (Bourne shell, Korn shell) using Unix/Linux and scheduling jobs using Crontab in UNIX environment.
• Familiar working in fast paced AGILE environment & attended daily scrum meeting.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring complex business logics and detail-level data analysis.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills. Team player, Motivated, able to grasp things quickly with analytical and problem solving skills. Comprehensive technical, oral, written and communicational skills.

TECHNICAL SKILLS

• Oracle 10g
• PL/SQL
• TOAD
• PL/SQL Developer
• Microsoft Office
• SQL Query Analyzer
• DTS
• ERwin 4.0/4.1/4.2
• MS Visual Basic 6.0
• Crystal Reports 9
• STATA 10/11
• SPSS
• SAS
• MATLAB
• Data Integrator (ETL) 11.0
• HTML
• XML
• XHTML
• C#
• .NET
• VB.NET
• JavaScript
• MS Visio 2003
• Microsoft Office FrontPage
• Windows 2000/2003 Advanced Server/Professional
• Bloomberg
• Morning Star
• KMV.

PROFESSIONAL EXPERIENCE

Confidential, NEW YORK

Senior Developer

Responsibilities:

• Participated in design discussions with the application architects and suggest design changes for improved database performance.
• Provided technical leadership in system analysis, design and development.
• Worked on database design and development of major functionalities and organized meetings for requirement gathering and project status.
• Used data modeling concepts for the Entity Relationship Diagram and followed the normalization concepts to design the database.
• Prepared document for data flow process from different source systems to target system
• Created and reviewed Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, lookups, Stored Procedures.
• Created custom PL/SQL procedures to read data from flat files to dump to Oracle database using SQL Loader.
• Created B-tree, Bitmap and function-based indexes for the null values.
• Loaded data with SQL Loader having different file formats and loaded them into multiple database tables in the same session.
• Developed and implemented complex views, materialized views, correlated sub-queries, nested sub-queries, triggers (row and statement level), Procedures and Functions in Oracle to meet the business requirements.
• Written Procedures and database triggers for the validation of input data and to implement business rules.
• Created user defined Exceptions while handling exceptions.
• Used Autonomous transactions to deal with mutating table issues.
• Created PL/SQL procedures using cursors and ref-cursors.
• Implemented the process for assessing and reviewing interface and data integration design and source code as well as for validating interface results.
• Used Oracle-defined exceptions, Non-predefined oracle exceptions and created user-defined exceptions for error-trapping.
• Created Pl/SQL packages integrating the related procedures and functions together for better performance and used nested table and Bulk processing for better performance.
• Used oracle supplied packages like UTL MAIL, DBMS JOB, DBMS OUTPUT and DBMS SQL.
• Performed Oracle Performance tuning using SQL Trace and EXPLAIN PLAN. Identified the queries performing the full table scan and considered them for the tuning purposes.
• Developed batch programs using UNIX shell scripts.

Environment: Oracle 10g, PL/SQL, ERWIN, TOAD, PL/SQL Developer, Informatica Powercenter9.0

Confidential, DE

PL/SQL Analyst

Responsibilities:

• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL Loader.
• Created database objects like packages, procedures, functions, and triggers and handled errors using Exceptions for implementing role based security.
• Created database objects like views, Materialized views using Oracle tools PL/SQL and SQL Plus.
• Tuned the queries using Explain Plan and packages, procedures and functions using sql trace.
• Created indexes on the tables for increasing the performance by reducing the data retrieval timing.
• Performed ETL Process by using Informatica Power center.
• Created Mappings by using the Informatica Designer and applied the joiner, aggregate, expression, rank, filter, router Transformations.
• Developed mappings using informatica to convert TPA data of different clients into JURIS claim management system.
• Used conversion tool to know what sources are to be mapped to the targets to get required transformed data.
• Converted all the completed trades into flat file to send to back office, loading everyday customer accounts with stock position and cash balance using Perl DBI .
• Developed Unix Shell Scripts to create parameters to automatically connect mappings to defined sources and targets of different schemas.
• Created shell scripts to maintain the log files of the target tables, to know whether the data is meeting client's requirements.

Environment: Oracle 9i with PL/SQL, Oracle 10g, TOAD, Informatica Power center, Crystal Reports 10 and UNIX.

Confidential, Springfield, MA

SQL Server Developer

Responsibilities:

• Performed unit test on the developed code to ensure that its bug free.
• Handled Production issues and manage the same in issue log.
• Interacted with Business Analysts and Users in requirement gathering, built complex queries using SQL and wrote stored procedures using PL/SQL.
• Involved in the database design for better understanding the relations, associations and dependencies within the database.
• Worked on SQL*Loader to perform bulk data loads into database tables from external data files.
• Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements.
• Created UNIX 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 Materialized Views for extracting the data from remote database.
• Wrote complex SQL queries to extract data from various source tables of data warehouse.
• Created various Function Based Indexes to significantly improve performance.
• Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Used Oracle packages like DBMS STATS to collect statistics of many different kinds as an aid to improve the performance and UTL FILE to read and write operating system text files.
• Used Bulk Collections to insert and update huge amount of data into target databases.
• Used advanced features of PL/SQL like Ref Cursors, Collections (Nested table, associative array and Varray) and Dynamic SQL.
• Involved in using HINTS to direct the optimizer to choose an optimum query execution plan.

Environment: TOAD, SQL loader, PL/SQL, Oracle 10g, PL/SQL Developer.

Confidential

Responsibilities:

• Created table structures along with the triggers, indexes like bitmap and function based indexes
• Developed tables, views, stored procedures, functions, and user-defined data types
• Monitored indexes and analyzed their status for performance tuning and query optimization
• Maintained the data integrity and security using constraints and database triggers
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures
• Troubleshoot performance issues within packages and stored procedures using explain plan and DBMS OUTPUT
• Responsible for tuning the application with the help of team members & Oracle support
• Improved the query performance using better joins and hints appropriately
• Developed packages, procedures and functions for complex reports
• Used SQL*Loader for loading the data into the tables from files
• Participated in the design and code reviews and verified compliance with the project’s plan
• Documented the whole process flow, PL/SQL packages, locations and descriptions, and possible error messages

Environment: Oracle 10i, SQL*Plus, Windows 2000.

Confidential

Junior Developer

Responsibilities:

• Involved in the database design for better understanding the relations, associations and dependencies within the data base.
• Involved in writing functional and technical documents.
• Used the merge statements to select rows from one or more sources for update and insertion into one or more tables.
• Discussed and analyzed business functionality with the client and the developers.
• Created and maintained PL/SQL scripts and stored procedures.
• Coded many generic routines (as functions), which could be called from other procedures.
• Developed various Reports for the end users as per their requirements and created many reports to suit preprinted format of the company.
• Wrote stored procedures, Functions and Database triggers using PL/SQL.
• Identified and implemented programming enhancements.

Environment: Oracle 9i, SQL, PL/SQL, SQL Plus, windows2000