SUMMARY:

• Expert in developing database applications with 8 years of experience in Pharmaceuticals, Health Care, Banking, Retail and Telecom industries.
• Expertise in building and developing high quality database applications with Oracle SQL and PL/SQL with proficiency in Oracle 11g/10g/9i and UNIX Shell Scripting.
• Data warehousing application developed by using Informatica Power Center Tools, me.e. Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Informatica Server and Repository Server manager.
• As an ETL developer, me have expertise in Data Warehouse and reporting tools like Informatica, Cognos and OLTP and OLAP implementations and normalized data structures.
• Experience across all stages of Software Development Life Cycle (SDLC) including Requirement gathering, Design, Development, Unit Testing, Systems Integration and User Acceptance Testing and preparing technical design documents.
• Proficient in developing and maintaining PL/SQL Packages, Procedures, Functions, Triggers, Joins, Sub Queries, Correlated Sub Queries, Views, Partitioning, Cursors and Ref - Cursors, Constraints, Transactions, Tables, Views, Materialized Views, DB links and Indexes.
• Excellent skills in writing different types of SQL Advanced queries like sub queries, nested sub queries and co-related sub queries along with set operators.
• Good in debugging the code by using TOAD and SQL Developer tools.
• Good experience in Erwin data modeler while working on ER diagrams.
• Worked with advanced concepts like Nested Tables, Varrays, Records, Types, Bulk Collects and Bulk Variables.
• Expert to work with partitioning of tables and indexes for better data retrieval performance from large datasets.
• Extensively used various techniques in Performance Tuning and Optimization like Hints, Indexes, Explain Plan, Trace Utility and TKPROF.
• Good experience in Data Migration techniques using Oracle External Tables, SQL* Loader, Import/Export and Batch Processing.
• Extensive working with Incident management tool (ITSME), service center and other tools for problem managements while working as Production support executive for TTSL project.
• Extensive hands on experience in tools like Toad, SQL Developer, TRU Console, TRU Migrate, TRU Compare, PDF Generator, Power center, Putty, Autosys, UC4, HP Service center, Control-M, ITSME... etc.
• Worked on developing and maintaining UNIX/LINUX Shell Scripts and schedule them using crontab.
• Worked extensively on various UNIX commands and vi editor on daily basis.
• Knowledge on Core Java, concepts in Java like struts, Hibernate and some advanced concepts as well. Have some noledge on multidimensional database Essbase, Big data, HDFS framework, Mapreduce, Pig, Hive, Hbase concepts.
• Expertise in migrating Clinical and non-clinical data from documentum to Veeva Vault.
• Strong debugging skills, and expertise as a Production support work as well.
• Proven ability to handle multiple tasks with strong Technical Aptitude and Learning Skills.
• Possess strong communication, interpersonal and problem solving skills developed through variety of projects over a period of time.

TECHNICAL SKILLS

Databases: Oracle 11g, 10g, 9i, SQL Server 2012, Essbase.

ETL Tools: Informatica Power Center 8.X/ 9.X (Designer, Workflow Manager, Workflow Monitor, Repository Manager and Informatica Server), Cognos

Languages: Oracle PL /SQL, SQL, Unix Shell Scripting, C, Core Java, DQL, VQL

Tools: Toad V10.0, SQL Developer, Putty, SQL * PLUS, Filezilla, Win Scp, UC4, Autosys, Control M, HP Service Center, Hyperion Essbase, Crontab, ITSME tool, Power Center, HDFS framework, ERWIN data modeler, TRUConsole, TRU Migate, TRU Compare, Dqman, PDF Generator, Documentum, Veeva Vault

Operating Systems: Windows server 2010, windows 7, HP UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Basking Ridge, NJ

Oracle Developer/Migration Specialist

Responsibilities:

• Analyze the user requirements and prepare proper technical design documents relevant to proceed for the development.
• Need to handle lead activities like coordinated with my team regarding the work to be shared by strictly keeping the deadlines in mind.
• Created and maintained database objects like Tables, Views, Sequences, Synonyms, Indexes, Stored Procedures, Triggers, Transactions, Functions and Packages.
• Created materialized views to load the data by refreshing it in regular intervals so dat it can be useful for the downstream users.
• UsedBulk Collectionsforbetter performanceby reducing context switching between SQL and PL/SQL Engines.
• Extensively used the advanced features of PL/SQL Records, Tables, Object Typesand Dynamic SQL.
• Developed Database Triggers for audit and validation purpose.
• Wrote complex SQL Statements, Complex Joins, Co-related Sub-queries and SQL Statements with Analytical Functions.
• Creating user interface views as per the downstream user’s requirement.
• Worked onSQL*Loader and Import/Exportto load data from flat files obtained from various facilities every day.
• UsedException Handlingtechniques extensively for the ease of debugging and displaying the error messages in the Application.
• Migrating the data coming from the reports to Veeva Vault environment by using TRU tools.
• Responsible for deploying the code to production environment on timely releases.

Environment: Oracle 11g, .Net, TOAD, Putty, Documentum, Veeva Vault, MS Access, UNIX, Batch Jobs, TRU tools, PDF Generator utilities.

Confidential, Miami, FL

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Created and modified severalUNIX shell Scriptsaccording to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• 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 packagesusing 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.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesandDynamic SQL.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

Environment:Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Confidential

Senior PL/SQL & ETL Developer

Responsibilities:

• Handled the requirement gathering by participating in meetings with the clients on regular intervals.
• Closely worked with my Business Analyst and Project manager for the proper requirements gathering.
• Analyze the user requirements and prepare proper technical design documents relevant to proceed for the development.
• Did the Impact analysis on the existing data objects available in the GRW environment.
• Need to handle lead activities like coordinated with my team regarding the work to be shared by strictly keeping the deadlines in mind.
• Created and maintained database objects like Tables, Views, Sequences, Synonyms, Indexes, Stored Procedures, Triggers, Transactions, Functions and Packages.
• Created materialized views to load the data by refreshing it in regular intervals so dat it can be useful for the downstream users.
• Responsible for implementing the functionality to load data from PeopleSoft environment to GRW (DB).
• UsedBulk Collectionsforbetter performanceby reducing context switching between SQL and PL/SQL Engines.
• Extensively used the advanced features of PL/SQL Records, Tables, Object Typesand Dynamic SQL.
• Developed Database Triggers for audit and validation purpose.
• Wrote complex SQL Statements, Complex Joins, Co-related Sub-queries and SQL Statements with Analytical Functions.
• Worked by partitioning table techniques when table is having huge data for data accessing and performance improvements.
• Creating user interface views as per the downstream user’s requirement.
• Worked onSQL*Loader and Import/Exportto load data from flat files obtained from various facilities every day.
• UsedException Handlingtechniques extensively for the ease of debugging and displaying the error messages in the Application.
• Extensively worked with DBAs towards Performance Tuning and Access Control.
• Created and modified UNIX shell Scriptsaccording to the changing needs of the project.
• Monitored the scheduled scripts run using UC4 tool.
• Resolving the tickets dat raised through service center tool.
• Developed and maintained cognos reports according to client requirements.
• Developed test cases and performedUnit Testing and Integration Testingof the Repositories.

Environment: Oracle 11g, PL/SQL, TOAD, SQL plus, Putty, UNIX, Shell Scripting, Cognos, UC4, HP Service center, People soft HRMS

Confidential

PL/ SQL Developer

Responsibilities:

• Responsible for proper orders and purchase related data loading into smart-ops optimizer from different inbound systems and similarly processed data back to those out bound systems.
• Worked in PLSQL code tuning SystemAnalysis, Design, Coding, Testing, Developmentand documentation.
• Worked on both proactive and reactiveSQL TuningandQuery OptimizationTechniques for complex SQL Statements. UsedPerformance MonitorandSQL Profilerto optimize queries and enhance the performance of databases.
• Created and maintained all databaseobjectssuch asTables, views, indexes, sequences, constraints, procedures, functions.
• Created materialized views to load the data by refreshing it in regular intervals so dat it can be useful for the downstream users.
• Designed and DevelopedTriggers and Packages using PL/SQL.
• Createdindexeson tables andOptimizingStored procedure queries.
• Wrote Scripts for batch processing and data loading usingSQL * Loader.
• Monitored the batch processing with the help of Control M tool.

Environment: Oracle 10g, PL/SQL, Autosys, SQL plus, Putty, Toad, SQL Developer, UNIX Shell Scripting, Control M

Confidential

Informatica &PL/SQL Developer

Responsibilities:

• Analyzed the requirements and framed the business logic for the ETL Processes.
• DesignedConceptual Modelas an architectural migration target for newODS modeland redesigned the key structures of theData Warehouse(tables, MVs, Indexes).
• DevelopedData AnalysisforErwin LogicalandPhysical modeldesign and worked on ER diagrams.
• UsedErwin relationaltool forlogicalandphysical modelfor targetODSmodel.
• Document and communicate changes to theOLTP, OLAPsystems and data warehouse teams, includingData Modeling, ETLand Database teams.
• Created database objects like Tables, Views, Sequences, Synonyms, Stored Procedures, Functions, Packages, Cursor, Ref Cursor and Triggers.
• Developed Database Triggers for audit and validation purpose.
• Wrote complex SQL Statements, Complex Joins, Co-related Sub-queries and SQL Statements with Analytical Functions.
• Extensively used Hints to direct the optimizer to choose an optimum query Execution Plan.
• Extensively used Bulk Collection in PL/SQL Objects for improving the performance.
• Handled errors using Exception Handling extensively for debugging and maintainability.
• Created Mappings using Designer, Extracted the data from the flat files and other RDBMS databases into staging area and loaded onto Data Warehouse.
• Developed the Informatica Mappings by using Aggregator, SQL Overrides by using Lookups, source filter by using Source Qualifiers and Data Flow Management into multiple targets using Router.
• Performed Unit Test and Integration Test to make sure the deliverable is match with business requirement.

Environment: Oracle 11g, PL/SQL, Informatica Power center, Erwin data modeler, SQL plus, Putty, Toad, UNIX, Shell Scripting.

Confidential:

Production Support Executive

Responsibilities:

• Maintaining the TIPPS frontend application which was developed by using Oracle Forms and Reports.
• Generating Daily, Weekly and monthly Reports using UNIX Scripts for the end users.
• Monitoring the daily, weekly and monthly jobs in Autosys tool.
• Resolving the tickets raised by clients through ITSME tool interface.
• Working on FTP to transfer files from remote servers to local system and vice versa.
• Creating Cursors and Ref cursors as a part of the stored procedures to retrieve the selected data.
• Extensively used partitioning of tables when working with tables having huge historical data.
• UsedBulk Collections andBulk Variables forbetter performanceand easy retrieval of data by reducing context switching between SQL and PL/SQL engines.
• Used Oracle External Tables, SQL* Loader, Import/Export to read Flat Files and apply business logic before saving these transactions.
• Creating UNIX shell scripts to automate the loading of data from vendors through SQL* Loader and to connect to SQL plus and execute the packages and procedures dat are created.
• Worked with complex queries to retrieve information from database depending on the user requirements (AR’s).
• Debugging and resolving of the production fixes (PFs).
• Worked on resolving different Analysis requirements ARs, Business requirements BRs and Change requirements CRs.

Environment: Oracle 10g, PL/SQL, TOAD, SQL * Loader, UNIX, Autosys, Putty, FTP and ITSME tool.