SUMMARY

• Over 8 years of experience in various phases of Software Development Life Cycle involving Analysis, Design, Development and Maintenance of Business Applications using Oracle Relational Database Management System.
• Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, and Database Triggers for Oracle Relational Databases.
• Proficient in the Data Manipulation using SQL for the retrieval of data from the Relational Database (inner joins, outer join, group by, order by, cursors etc).
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Extensively worked in Client - Server application environment using Oracle 10g/9i/8i/7.x on Windows, UNIX/LINUX platforms and profound knowledge on Oracle 11g.
• Very Good experience with UNIX Cron Jobs, shell scripting, Batch Processing with highly complex data model.
• Good Knowledge on Technical architecture and functional flow of Oracle Applications modules such as General Ledger, Account Payables, Account Receivables, Purchasing, Inventory and Order Management.
• Implemented performance tuning techniques at application, database and system levels
• Experience in data extraction from heterogeneous sources using Informatica Power center
• Experience in UNIX shell programming.
• Solid understanding of Relational (ROLAP) and Multidimensional (MOLAP) modeling, broad understanding of data warehousing concepts, star and snowflake schema database design methodologies and Meta data management.
• Expert in coding complex and advanced PL/SQL programs using Oracle’s Object-Oriented programming, collections, records, index-by tables, object types and methods.
• Well-acquainted in working with complex SQL queries with joins, date functions, inline functions, sub-queries to generate reports, Functions, Procedures, Exception handling, Views, Packages, Triggers and Ref Cursors.
• Good experience in designing Entity Relationship Diagram (ERD), Schema, Logical and Physical data models and Data Flow Diagram (DFD) for different database applications.
• Extensive experience in using PLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects, Bulk Load, Regular Expressions, FORALL, Merge etc
• Excellent proficiency in Data Transformations and loading using Export/Import and SQL*Loader and worked on External tables and Transportable table spaces.
• Experience in Query optimization & Performance tuning using Explain Plan, Performance Monitor.
• Experience in developing user interface for database applications using the Oracle Apex.
• Strong experience in developing SQL/PLSQL Scripts/Programs for Data Analysis, Extraction, Transformation and Loading (ETL) mechanism
• Experience in Oracle Apps 11i General Ledgers, Account Payables, Account Receivables, Order Management modules.
• Good knowledge of DataMarts, DataWarehousing, Operational DataStore (ODS), OLAP, Data Modeling.
• Expert in Oracle11i E-business implementation ofInventory, Purchasing, iProcurement, Order Management, BOM, WIP.
• Having knowledge on the Oracle Exadatafor the extreme performance of the database.
• Worked on Oracle development tools like SQL Developer, Oracle Enterprise Manager, PL/SQL Developer, and used TOAD in many development projects.
• Experience in Agiledevelopment environment.
• Experience with leveraging Hadoop ecosystem components including Pig and Hivefor data analysis, Sqoop for data migration, Oozie for scheduling and HBase as a NoSQL data store.
• Expertise in working with different data sources like flat files, XML, Teradata, DB2, and Oracle.
• Experience in using Informatica to populate the data into Teradata DWH.
• Created various BI reports, dashboard using SQL Server Reporting Services (SSRS), PIVOT Tables, SAP BO, QlikView, Microstrategy, Tableau.
• Knowledge with using serialization, de-serialization and delegates features of .NET.
• Experience in SQL tuning using Hints, Materialized Views.
• Expertise in understanding Fact Tables, Dimension Tables, Summary Tables
• Experience in using Automation Scheduling tools like Autosys and Control M.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x

Databases: Oracle 11g/10g/9i/6i, Teradata 12.0/13.x/14.10, DB2, SQL Server 2005/2000

Reports: Oracle Forms 11g/10g/9i/6i, Oracle Reports 11g/10g/9i/6i

Programming Languages: C, SQL, ASP.NET, PL/SQL, C++, Shell Scripting.

Scheduling tools: Control-M, Maestro Tivoli, Autosys

Operating System: Windows 9x/NT/2000/XP, UNIX/LINUX

Others: Toad, Teradata SQL Assistant, ERWin, Exadata, Tableau, View point, MS Word, MS Excel, MS PowerPoint, Outlook.

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Sr. Oracle PL SQL Developer

Responsibilities:

• Involved in getting the User Requirements, Data Modeling & Development of the system
• Writing (Back-end) PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor or TOAD.
• Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements.
• Created PL/SQL Packages for easier application design and improved Performance.
• CreatedRecords, Tables, Objects, Collections, Views,Materialized viewsand Global temporary tables(Nested Tables and Varrays), and performed Error Handling.
• Extensively usedCursors, Ref Cursors, Dynamic SQL and Functions.
• Participated inPerformance TuningusingExplain Plan.
• Tested, Installed, Documented and provided On Call Support for the Applications.
• Developed UNIX Shell Script as required.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable.
• Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
• Performed De-Normalization of aggregated data for the large set of rows in EXADATAEnvironment to improve the performance and handle billions of rows.
• Performed Data replication and Data transformation.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Involved in Periodical backups of Databases using RMAN.
• Involved in database Restoration and Recovery.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Migrated data from Flat Files to Oracle database using SQL*Loader.
• Encapsulated PL/SQL procedures and functions in packages to organize application.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Performed complex data manipulation using foreign functions written in C and PL/SQL language.
• Created and managed primary data base objects such as Tables, Indexes, Sequences, and Synonyms, materialized views.
• Developed aConceptual modelusing Erwin based on requirements analysis.
• Implemented Data loading process using UNIX Korn shell scripts resolved application issues in UNIX production environment. Read and interpreted UNIX logs.
• Developed stored procedures & functions in DB2, incorporating business logic
• Developed Informatica mappings and Workflows for some of the sqlldr control files which are actively called in current shell scripts to update staging and master tables.
• Involved in trouble-shooting production database problems and report problems.
• Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.
• Developed Informatica Workflows as the part of the project as old BODI tool to be eliminated and all Acta jobs to be converted to latest ETL Informatica.
• Informatica workflows are successfully incorporated inside shell scripts to run accordingly when the control - M triggers the shell scripts based on the schedule.
• Designed and developed several complex database procedures, packages. Extensively used features like Cursors, autonomous transactions, distributed transactions, exception handling, Dynamic, pl/sql tables, bulk load methods, optimizer Hints, Cursor variables and returning of multi record set from procedures and functions
• Generated DDL scripts and Created and modified database objects such as tables, views, sequences, functions, synonyms, indexes, packages, stored procedures using TOAD tool.

Environment: Oracle 11g, SQL*Plus, PL/SQL, Toad, SQL Loader, DB2, EXADATA, Sun Solaris, ERWin, Informatica Power Center 9.1, Clear Quest, MS VSS, ETL, SVN, JIRA, Perl, XML, Crystal Reports.

Confidential, Los Angeles CA

Sr. Oracle PL SQL developer

Responsibilities:

• Experience in writing Technical design documents and developing unit test documents.
• Created or Modified the SQL Script (.sql file) to point to the current source.
• Experience in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of data.
• Interact with business analysts to develop modelingtechniques.
• Created the tables and sequences for the experimental data load capture.
• Wrote Packages to store the business rules and exceptions and wrote PL/SQL code to load data from the flat file to the tables.
• Involved in support and maintenance activities of the Data warehouse, datamart Applications and Informatica up gradation from 8.6 to 9.1
• Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
• Integrate various data sources such as Oracle, DB2, Legacy Systems, Web Services, XML and Flat files into data marts and operational systems.
• System analysis, physical data model design and logical data model design using SAP PowerDesigner, Database administration and database tuning in Oracle RAC, Oracle Exadata.
• Modified the queries by using less functions in the Where condition for reduction of time for Performance issues.
• Creating and enhancing daily, monthly, yearly jobs using Perland UNIX shell Scripting.
• Loading the Data into tables using SQL loader and using PLSQL Package UTL FILE (ETL).
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Wrote the Unix scripts for scheduling or running the scripts for day to day transactions.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX Shell scripting, SQL, PL/SQL and SQL Loader.
• Modifying the queries by using BULK COLLECT and FOR ALL to reduce the time for performance issues.
• Used golden gate and oracle data integrator for data ingestion into foundation layer/raw zone.
• High End-Client Interactions for solving User Acceptance Testing (UAT) issues.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL Enhanced it with creating exceptions for error handling.
• Extensively worked with third party database tools like TOAD & PL/SQL Developer.
• Hands on Exposure on 2010 TFS Version Control. This includes splitting and merging of code branches in various Release and Version Management. Experience in Checking in checking out the code in TFS (Team Foundation Server).
• Worked Fine-tuned existing Informatica mappings for performance optimization.
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Indexes, Sequences, Union All, Intersect & Minus set operators.
• Designed entity relation diagrams (ERD) using Erwin.
• Rich experience in writing SQL queries, Anonymous blocks, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
• Created materialized view on remote database and automated scheduler of refreshing of materialized view on source side.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect.
• Experience in using the Trace files and TK proof whenever required for performance issues.
• Responsible for Unit, System and UAT testing the data.
• Involved in UAT testing, Bugs fixing and the code was sent to Production.
• Resolving the Tickets and pulling the data from the Transactional database and Archive database for the reports.

Environment: Oracle 10g, 11g, Informatica Power Center 8.6/9.1, PL/SQL, SQL*Plus, PL/SQL Developer 6.0, Toad, ERWin, DB2, PERL/UNIX Scripting, LINUX, TFS.

Confidential, Minneapolis, MN

Oracle Developer

Responsibilities:

• Created detailed design and requirements documentation with logic to help better understanding of the system
• Continuously interacted with Business Analysts and end users to gather business requirements
• Performed design/code reviews to make sure that the design/code adheres to customers’ standards and meets industry’s best practices
• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Involved in getting the User Requirements, Data Modeling& Development of the system
• Designing system work flow diagrams using UML and Visio.
• Involved in ERD Design for Enterprise Application building.
• Creation of database objects like Tables, Views, Materialized views Procedures, Packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader.
• Written SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Involved in development of ETL process using SQL* LOADER, PL/SQL Package.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), and Error Handling.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database.
• Worked on maintenance of Oracle 10g/11g RAC EXADATAdatabases on Linux and Configured 2/3 Node RAC on Grid Infrastructure.
• Involved in Performance tuning and Query Optimization.
• Interacted with DBA to discuss database design and modeling, index creations and SQLtuning issues.
• Documented the errors and solutions to fix them for future use.
• Provided SQL tuning, table indexing, data migration, project migration, program debugging.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis.
• The procedures are built to generate reports with dynamically varying conditions based on the input parameters passed.
• Scheduling Execution of PL/SQL Procedures using UNIX Shell scripts for updating of Base tables from Transaction Tables.
• Worked on Shell Scripts like Perlto transform data using FTP to all UNIXservers at a time.

Environment: Oracle 11g, SQL*PLUS, PL/SQL developer, TOAD, FTP, Unix sun Solaris(5.8/5.9), ERWIN, ETL, EXADATA, Oracle ware house builder(OWB),Oracle Enterprise Manager (OEM), Unix/Perl Shell Scripts, JAVA,SSIS,SSRS, Windows XP

Confidential, NY

Oracle PL SQL Developer

Responsibilities:

• Developed interface to load Invoice data into Account Payables. Developed validations programs to load the data into AP INVOICE INTERFACE, AP INVOICE LINES INTERFACE.
• Data was loaded into temporary table from flat file and then into AP INVOICE INTERFACE and AP INVOICE LINES INTERFACE tables.
• Worked with the Business users in Vendor reconciliation process between Great Plains system and Oracle System.
• Involved in Development of Oracle forms user interface related to GE Energy.
• Wrote SQL scripts to insert the vendor data into PO VENDOS ALL, PO VENDOR SITES ALL, PO VENDOR CONTACTS.
• Wrote SQL scripts to create temporary tables and developed SQL*Loader Control files to load the data into the temporary tables.
• Data was loaded into temporary table from a flat file and then into RA INTERFACE SALESCREDITS ALL and RA INTERFACE LINES ALL tables.
• Customized and developed reports as per client's requirements using Reports 6i and PL/SQL and registered them with APPS.
• Develop SQL* Loader scripts for data extraction and transformation.
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
• Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
• Created some Custom reports and Formsfor the end users to check the details and errors.
• Generated and customized reports using thereports builder.
• Managed day-to-day activities and ran desiredreports.
• Responsible for Purging and archiving the production databases by interacting DBA.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Project Development is done on Iterative and Incremental Software development life cycle methodology.
• Responsible for troubleshooting the errors that occurred when the production group hit a roadblock (Production Support).
• Executed Unix Korn shell scripts, directory structures and I/O file handling in Production.
• Developed reports using complex queries as per client request as a part of production support
• Responsible for performing code reviews and Incident Management working through critical incidents.
• Resolving Production Severity Issues in time and meeting the SLA.
• Writing high quality and well documented code per standards.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed InformaticaWorkflows and sessions associated with the mappings using Workflow Manager
• Provide 24/7 on call production support and resolve production issues immediately.
• Developed database compare tool to negate manual intervention for database object comparison during data copy to data warehouse/reporting environment. It provides a list and DDLs of Tables, Indexes and Views, which are different among the source and target systems, thus saving considerable time.
• Did Unit testing, System testing for the Data Integrity and the functionality of the newly created business requirements.

Environment: Oracle Applications 11.5.10.2(AP, AR, GL, PO), Informatica Power center 8.1, Service Now, Oracle 10g, TOAD, UNIX Shell Scripts

Confidential

Software Engineer

Responsibilities:

• Developed technical design documents (MD70s) using AIM methodology by reviewing MD50s and interacted with functional team to build technical extensions.
• Developed new reports as per Oracle Applications development standards and customized existing reports in the PO module according to the client’s requirements.
• Privileged Identity management team works on Oracle Identity and Access Management issues.
• On call duties for development, staging and production environment.
• Investigating, determining the cause and fixing all production problems.
• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Designing system work flow diagrams using UML and Visio.
• Involved in ERD Design for Enterprise Application building.
• Creation of database objects like Tables, Views, Materialized views Procedures, Packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader.
• Using SSRS delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Written SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Involved in development of ETL process using SQL* LOADER, PL/SQL Package.
• Created Records, Tables, Objects, Collections and Error Handling.
• Participated in Performance Tuning using Explain Plan and TkProf
• Written stored procedures, functions and packages for application development.
• Copying of data from development to test and production by using utilities like Export/Import.
• Developed and optimized database structures, stored procedures, dynamic management views, DDL triggers and user defined functions.
• Developed several formsusing Forms6i in OM, AR and AP modules
• Automating data loading, extraction, report generation using PL/SQL coding.
• Expert in analyzing/troubleshooting and providing technical support for Unix/Oracle applications and their interfaces.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Scheduling Execution of PL/SQL Procedures using UNIX Shell scripts for updating of Base tables from Transaction Tables. Utilized tools like TOAD during development of the application.

Environment: Solaris 10, Oracle 9i, Forms 6i, HP Quality Center, SQL Plus, Putty, GE Service Now, HP Server Automation Tool