SUMMARY

• Over 8 years of IT experience in Oracle 8i,9i,10g,11g as an Oracle PL/SQL Developer in Finance, Insurance and Health Care industries.
• Over 5 years of experience in Data Warehousing and ETL using tools such as Informatica Power Center.
• Over 3 years’ experience in writing shell scripts in UNIX/LINUX environment.
• Extensive experience in all phases of Software Development Life Cycle (SDLC) such as Requirement gathering, Analysis, Development, Testing, Implementation and Maintenance of applications.
• Excellent experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relational modeling and design techniques.
• Excellent technical and analytical skills with clear understanding of design goals of Dimension Modeling for OLAP, and expertise in implementing star/Snowflake schema, data mart, Fact and Dimensions tables.
• Strong work experience with tools like Toad, SQL Developer, PL/SQL Developer and SQL Plus.
• Expert in writing complex SQL queries, PL/SQL functions, procedures, triggers and packages and creating database objects such as Sequences, Synonyms, Materialized view.
• Highly experienced in advanced PL/SQL concepts like Collections, Bulk Collects, Exception Handling and Dynamic SQL.
• Strong experience in using Table Function, Indexes (B - tree, Bitmap and Function based), Table Partitioning, Global Temporary table, Analytical Functions, Query Re-Write and Transportable table space.
• Highly experienced in using Oracle Supplied Packages such as DBMS SQL, DBMS JOB, DBMS SCHEDULER, UTL FILE and UTL SMTP.
• Strong hands on experience in writing, maintaining, testing and debugging code in applicable programming languages.
• Expert in Performance Tuning by using various Oracle utilities, including Explain Plan, Hints, SQL Trace, TKprof and DBMS Profiler, Partitioning, Parallel processing, pipelining, managing locking scenarios for multiple users.
• Excellent experience in writingShell Scriptingon different type of shells (Bash shell, Korn shell) usingUnix/Linuxand scheduling jobs usingAutoSys and Crontab and monitoring the batch processing.
• Expert in data migration techniques using Oracle External Tables, SQL * Loader, Import/Export Utilities, UTL File Package and batch processing.
• Extensive experience in using Informatica as an ETL tool to create Source/Target definitions, Mappings and Sessions to extract, Transform and Load data into staging tables from various sources.
• Strong hand on experience in using Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Union, Update Strategy, Rank, Aggregator, SQL, XML, Stored Procedure, Sorter, and Sequence Generator.
• Solid experience in generating reports using Oracle Reports 10g/9i, fixing the bugs, customization reports according to the changing client’s requirements.
• Excellent Writing, Presentation, Documentation and Communication skills for the management, development.
• Highly experienced with Database Backup and Recovery, and provided Production Support.
• Excellent team player, highly self-motivated, strong software background and ability to take challenges.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, MS SQL Server 2008

Languages: C++, Core Java, J2EE, JDBC, Visual Basic, SQL, PL/SQL, Shell Script

Web: HTML, XML, Java Script, Front Page

Operating Systems: Windows, Linux, UNIX

Applications: Visual Studio, Eclipse, MyEclipse, Microsoft Office (Word/Excel/PowerPoint)

DB Dev. Tools: TOAD, SQL Developer, SQL*Plus, PL/SQL Developer, SQL* Loader, Informatica PowerCenter 8.x/9.x, MS Visio, Putty, Erwin

PROFESSIONAL EXPERIENCE

Confidential, Glenmont, NY

Sr. Oracle PL/SQL Developer

Responsibilities:

• Collaborated with the application design team to work on Logical and Physical design phase of Data Modeling process utilizing modeling software package of Erwin and MS Visio.
• Involved in writing and managing PL/SQL complex Stored Procedures, Functions and Packages to meet the business requirements, update the existing objects based on change requests and do daily and monthly loading process.
• Developed complex system and application triggers using PL/SQL for data integrity, enforcing business rules and perform automatic updates and insertions in OLTP.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Utilized Database Links to accommodate cross-database transactions.
• Developed Materialized Views and Ref Cursors for reporting purpose.
• Utilized Bulk Binding to improve overall performance of large data processing tasks.
• Enhanced performance of large complex SQL queries with sub-queries, analytical functions, and inline views based on information gathered.
• Involved in tuning complex queries and performance bottlenecks using Explain plan, SQL Trace, TKProf utility, SQL Profiler, optimizer hints and using Analyze to compute statistics on tables.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views and partitioning.
• Designed and created ETL processes to transfer data from multiple operational data sources to Data warehouse Tables based on business requirements.
• Handled XML files for data loading purposes.
• Worked with the utilities like SQL*Loader, External Tables, Import/Export to extract and load large volume of data.
• Created and worked with GTT (Global Temporary Table) during data transformation.
• Extensively worked in UNIX Shell scripts for clean-up, logging, and file manipulation, regular maintenance.
• Involved in testing the application in all stages, like unit testing, system testing and integration testing.

Environment: Oracle 11g, SQL* Loader, MS SQL Server 2008, PL/SQL, UNIX/Linux, Toad, Erwin, MS Visio.

Confidential, Parsippany, NJ

Sr. Oracle PL/SQL Developer

Responsibilities:

• Developed complex packages, procedures and functions to meet business requirements.
• Created triggers to automatically populate auditing tables.
• Utilized dynamic SQL technique to construct general purpose procedures for routine administrative tasks.
• Extensively utilized oracle collection types to improve performance, enhance readability and maintainability.
• Utilized bulk binding techniques to reduce context switching.
• Utilized function result caching feature to improve performance.
• Worked on partitioning large Tables using Range Partitioning.
• Reviewed long running queries with explain plan, auto trace and DBMS STATS package.
• Tuned queries to address performance issues by adding applicable hints for faster data retrieval for user interactive tasks, and devising Indexing strategy to maximize index utilization.
• Debugged programming issue with DBMS UTILITY package.
• Implemented compound triggers to avoid mutating table errors.
• Coordinated with front end application development team to provide them with necessary insight of data structures and valuable inputs on optimizing data manipulation process.
• Involved in DESIGNING & CREATING an ETL Framework that works based on a table driven approach.
• Involved in queries diagnostics using explain plan, auto trace and database statistics.
• Customized SQL*Loader control for data loading process.
• Performed Unit Testing, Integration Testing and Performance Testing.
• Used PRAGMA AUTONOMUOS TRANSACTIONto implement error logging mechanism.
• Created and modified Shell scripts to perform desired tasks according to business plan.
• Provided support to the production database team.

Environment: Oracle 10g/11g, UNIX, Export, Import, ETL, SQL* loader, Toad, Java, Informatica PowerCenter 8.6, Erwin.

Confidential, Melville, NY

Oracle PL/SQL Developer

Responsibilities:

• Developed stored procedures, functions, packages, data base triggers and cursors.
• Collaborated with the application design team. Worked on Logical and Physical design phase of Data Modeling process utilizing modeling software package of Erwin and MS Visio.
• Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables.
• Created database objects likepackages, procedures, functions, and triggersand handled errors using Exceptions for implementing role based securityaccess for VIAONE reporting system.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Handled XML Files for data loading purposes.
• Utilized bulk binding techniques to improve query performance.
• Tuned the queries usingExplain Plan and packages, procedures and functionsusing SQL trace.
• Extracted data fromFlat filesand transformed it in accordance with the Business logic mentioned by the client using SQL*Loader.
• Created indexes which improve overall performance.
• PerformedETLProcess by using Informatica Power Center.
• Created Mappings by using theInformaticaDesigner and applied the joiner, aggregate, expression, rank, filter, router Transformations.
• Developed mappings usingInformaticato convert TPA data of different clients into JURIS claim management system.
• Converting 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.
• Debugged themappings using debuggeroption in Informatica tool to validate the data conversion mapping.
• Created workflows usingworkflow Managerfor loading the converted data into the target tables.
• Packages are created fordata validationsto make the data supportedby JURIS claim management system.
• DevelopedUnix Shell Scriptsto create parameters to automatically connect mappings to defined sources and targets of different schemas.
• Createdshell scriptsto maintain the log files of the target tables, to know whether the data inserting into the target tables is according to the JURIS standards and weather the data is meeting client's requirements.

Environment: Oracle 9i/10g, SQL*Plus, Perl, TOAD 8.6.1, Informatica Power Center 8.5, UNIX, Power Term, Conversion Tool.

Confidential, PA

Oracle PL/SQL Developer

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering Built complex queries using SQL and wrote stored procedures using PL/SQL.
• Worked in Data modeling, Data mapping and Data flow.
• Involved in Requirement gathering and writing Functional and Technical documents.
• Responsible for writing and modification of PL/SQL stored procedure, functions, packages and triggers.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
• Created materialized views, Inline Views & normal views where business requirements needed.
• Created management analysis reporting using Parallel Queries, Java stored procedure, HTP Package and WEB.SHOW DOCUMENT. Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
• Tune the SQL queries and complex procedures to improve performance.
• Created database triggers for data security & Consistency.
• Involved in testing the scripts by performing Unit testing, System integration testing, Regression testing and helped them deploy from AutoSys box.
• Experienced in writing procedures, functions and packages for new requirements.
• Used advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for better performance.
• Developed PL/SQL and web PL/SQL stored procedures.
• Implemented Advanced PL/SQL Concepts for better performance of PL/SQL Applications.
• Wrote PL/SQL backed stored procedures for database access and tuned them efficiently.
• Worked in Production Support Environment testing for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Extensively used EXPLAIN PLAN utility to leverage SQL queries.
• Performance tuning of Oracle Databases and User applications.
• Constant interaction with Java Developers for tuning of SQL statements, embedding them in Java code using SQL and for unit testing and other test sequence comparisons.
• Generated dynamic web-reports using java, Jsps, HTML, DHTML & Javascript.
• Good understanding of Oracle Data Dictionary and Normalization Techniques.
• Involved in solving day-to-day problems, giving support to the users.

Environment: Oracle 10g, 11g, J2EE, TOAD, Windows

Confidential

Jr. Oracle PL/SQL Developer

Responsibilities:

• Involved in Discussions with the Business Requirements.
• Installation, Creation and support of Oracle 9i database environments.
• Involved in the maintenance and enhancement of the application.
• Maintained Logical and Physical structure of the database.
• Created table spaces, tables, views, scripts for automatic operations of the database activities.
• Coded various stored procedures, packages and triggers to in corporate business logic into the application.
• Used the technical document to design the database tables.
• Monitored database and system backups, developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports.
• Developed UNIX shell scripts to administer the system.
• Used UTL JOB to automate the PL/SQL procedures and packages.
• Involved in Interacting with users, error fixing by enhancing PL/SQL packages, stored procedures & functions.
• Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Involved in Unit Testing Stored Procedures and Functions
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Worked on various backend procedures and functions using PL/SQL.
• Documented the whole process flow, PL/SQL packages, locations and descriptions, and possible error messages.

Environment: Oracle 9i,10g, Toad, Sql Developer Visual Basic 6.0, PL/SQL, SQL, Shell Scripting Linux, Windows, Crystal Reports.