SUMMARY

• 7+ Years of experience as IT Professional in designing and developing Applications according to Business Requirements using Oracle RDBMS (Relational Database Management System).
• Involved in SDLC like analysis, design, development, testing, implementation and maintenance providing timely delivery against strict deadlines.
• Experience in using PL/SQL in writing complex queries, across multiple databases, stored procedures, user defined functions, triggers in large - scale relational database environment.
• Experience in developing complex database objects such as: Functions, Packages, Stored Procedures, Database, Materialized Views using SQL, PL/SQL.
• Experience in fine tuning of SQL Queries using Explain Plan, SQL Trace on Oracle 11g/10g/9i databases.
• Experience in reducing loop overhead by writing DML(Select, Insert, Update) Statements using FORALL statement
• Knowledge in using Normalization and De-Normalization Techniques for Data modeling (logical and Physical).
• Experience in End-End application development using Oracle11g/10g/9i, PL/SQL, SQL *PLUS
• Experience in retrieving the data by writing simple/complex SQL Queries
• Experience in utilizing oracle Utility tools SQL *Loader.
• Experience in writing the stored procedure to implement as per business requirement.
• Experience in Performance tuning of targets, sources, mappings and sessions, SQL Query Tuning, Creation of Indexes for faster database access and query performance.
• SQL Performance Tuning using Cost Based Optimization, Rule Based Optimization.
• Experience in handling various errors using exceptions
• Experience in application development of the database using TOAD.
• To improve performance: Planned, Designed and Implemented Table Partitioning.
• Worked on Informatica Power Center tools - Repository Manager, Designer, workflow Manager and Workflow Monitor.
• Good experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, XML, Oracle.
• Experience with Data Warehousing concepts -Star Schema, Dimensions and Fact tables.

TECHNICAL SKILLS

RDBMS: Oracle 11g, 10g, 9i

Operating Systems/Platforms: UNIX, Windows XP/7/8/8.1

ETL Tools: Informatica Power Center 9.0

Programming Languages: SQL, PL/SQL, C, C#.NET

Web Technologies: HTML, XML

Scripting Language: XML, Shell Scripting

Other Tools: SQL* PLUS, SQL*Loader, MS Visual Studios

PROFESSIONAL EXPERIENCE

Confidential, Virginia

Oracle PL/SQL Developer

Responsibilities:

• Hands on experience for performance tuning on existing SQL to improve application performance.
• Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
• Expertise in creating functional/technical specifications, testing scenarios, preparing test cases.
• Involved in project plan and Risk plan.
• Hands on experience on database design, detailed design, and ETL development.
• Created Materialized views for summary reports and extracts for better query performance.
• Used various Indexing and partition techniques to improve the query performance.
• Based on requirements estimations provided for new development and enhancements.
• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
• Implemented SQL and PL/SQL stored procedures.
• Exposed on UNIX scripts and environment.
• Hands on experience to create views, stored procedure, Packages.
• Interacted with business analyst and software developers for bug reviews and participated in QA meetings.
• Used Explain Plan and AWR reports to tune the complex queries and debug the queries to provide exact solution.
• Conducted brainstorm meetings and suggested performance improvement techniques and proposed designs.
• Prepared test case, test results and reviewed.

Environment: Oracle 11g, SQL, PL/SQL, SQL * Plus, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows.

Confidential, Pittsburg, PA

Oracle PL/SQL Developer

Responsibilities:

• Converted user requirements into formal Functional specifications while interfacing with the client.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Creation of database objects liketables, views, materialized views, procedures and packages using oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesand Dynamic SQL.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 10g, UNIX, PL/SQL, Shell Script, Windows, Clear Case, Clear Quest, Unix Shell scripts, SQL navigator, SQL * Loader.

Confidential, Omaha, NE

Oracle PL/SQL Developer

Responsibilities:

• Design and develop PL/SQL procedures/functions/triggers which carry out data flow to respective schemas meant for different clientdata models.
• Logical and Physical Data modeling and designing,writingserver side stored procedures/ triggers.
• Develop PL/SQL procedures to perform business validation checks on the data for master-detail, default value integrity constraints. Developed code using collections, cursors and file search.
• Analyze the Existing code and make new Enhancement as per different customer's request. Developed complicated SQL queries and database performance tuning. Bulk DML operation, Dynamic cursor, Ref Cursor, Partitioning, SQL tuning using explain plan, Tkprof and autotrace.
• Developed and maintained purging data for different level of pricing aspects by PLSQL developer and passed through the shell scripts in application level for user interface.
• Created several UNIX shell scripts calling various PL/SQL packages and procedures to perform the business rules.
• Create and manage work orders forms/reports .Allow customers to directly enter work requests online by web based application .Assign subcontractors to work orders and track status of work orders online
• On the job field benefits such as scan in customer signatures, work request reports, online document storage and more. Fully customizable applications available in addition for a complete business solution. The data in XML format transferred by JDBC connection to oracle.
• Developed Business objects with backend function in PL/SQL called by scheduled UNIX shell scripts.
• Implementation and Testing involved in data integration, unit testing and integration testing.

Environment: Oracle 10G, SQL, PL/SQL, UNIX, XML

Confidential, Lincoln, NE

Informatica Developer

Responsibilities:

• Developing the mappings using needed Transformations in Informatica tool according to technical specifications to populate the data into VDS tables from Source systems.
• Developing and implementing the coding of Informatica Mapping for the different stages of ETL (Extraction Transformation and Loading).
• Developing various Mappings to load the data from various sources by using different Transformations like Router, Aggregator, Joiner, Lookup, Update Strategy, Source Qualifier, Expression and Sequence Generator to load the feeds data.
• Fixing the invalid Informatica mappings and troubleshoot the technical problems of the database.
• Development of Informatica Mappings to accomplish Auditing and Error handling of VDS load.
• Developing Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Debugging the Informatica sessions by utilizing the logs of the sessions.
• Creating UNIX shell script for the start and stop procedures of the sessions. Performing unit testing at various levels of the ETL.
• Experience in identifying the bottlenecks and fine-tuned the mappings.
• Optimizing performance tuning at source, target, mapping and session level.

Environment: Informatica 9.0, Oracle 9i, SQL, PL/SQL, windows and UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Participated in analysis, design, development, testing, and implementation of various financial Systems using Oracle 8i, Developer 2000 and PL/SQL.
• This system consists of the various functional modules: Loan approvals, Deposition of Cash/ Withdrawal of Cash, Change of personnel Information, Bank Details, balance Sheet, Customer Information Database.
• Define database structure, mapping and transformation logic. Creation of External Table scripts for loading the data from source for ETL (Extracting Transforming and Loading) Jobs.
• Wrote UNIX Shell Scripts to run database jobs on server side.
• Developed new and modified existing packages, Database triggers, stored procedure and other code modules using PL/SQL in support of business requirements.
• Worked with various functional experts to implement their functional knowledge into business rules in turn as working code modules like procedures and functions.
• Used TOAD and SQL navigator extensively.

Environment: Oracle 8i, SQL, PL/SQL, UNIX, ERWIN