SUMMARY

• Over 7+years of experience in analysis, design, development, testing and deployment of software applications using Oracle/9i/10/11g/12c
• Extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.
• Expertise includes evaluation of Data Warehouse, Oracle 10g/9i/8i, and MS Access databases on UNIX and Windows environment PL/SQL.
• Extensive experience in building Client Server Applications using Oracle, PL/SQL, Stored Procedures, Packages and Database Triggers and working with partitions
• Expertise in UNIX shell scripting and job scheduling.
• Expertise in design, development and deployment of end user screens and reports using OracleIDE tools, Oracle Forms 10g/9i/6i/4.5, Reports 10g/9i/6i/2.5.
• Experience in developing applications using Oracle APEX 3.2/4/4.2
• Proficient in oracle tools and utilities such as SQL Loader, SQL developer and TOAD.
• Involved in the design of Dimension Models, Star Schemas and Snowflake Schemas.
• Knowledge of bug fixing Informatica 9.1.5 ETL jobs.
• Experience in query optimization, PerformanceTuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Involved in Unit Testing, Integration testing and Performance Testing.
• Experienced in interacting with Business users, Business Analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• Experience in HR core modules and OAF.
• Experience in work flow.
• Created standard and best practices for Talend ETL components and jobs.
• Proven ability to plan, coordinate and implement SDLC and Agile software development and maintenance projects.
• Strong experience in SQL, SQL*PLUS, PL/SQL, back end programming using Packages, Functions, StoredProcedures, Exception handlers, Database triggers, Views, RefCursors, Record Types, UTL FILE and other built in packages.
• Able to work within an aggressive and demanding project schedule and environment.
• Highly motivated & conceptually strong individual with outstanding oral and excellent communication, analytical and interpersonal skills.Hands in experience with tableau for creating reports and trouble shooting issues associated with tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
• In - depth knowledge of XML and XSLT data and processing tools
• Knowledge of both Microsoft and Linux operating systems.
• Integrate XML XSLT OOP and types of programming into databases and applications.
• Strong knowledge of XML Schema, Experienced in working with XML processing tools.
• Extensive knowledge of data modeling inside XML.
• Interacting with QA teams to review and develop data standards, data exchange, XML data standard, and data sharing model. Offering support for monitoring and tracking success of process improvements

TECHNICAL SKILLS

Operating System: HP-UNIX, Linux, Windows 2003

RDBMS: Oracle 12c/11g/10g/9i, MS Access 7.0/2000

Data Warehousing: SQL Developer ETL Processes, InformaticaPowerCenter9.1

Data Modeling: Star-Schema Modeling, Snowflakes Modeling

Programming: C, C++,PL/SQL, UNIX Shell Scripting, .Net, Core Java and XML

Tools: MS Access Reports, Oracle APEX 3.2,4,4.2, MS Office, Tableau,TCC

Version Control: CVS, PVCS

Scheduler: Control M, DBMS

Web Technologies: HTML, APEX 3.2,4,4.2

Other Products: SQL*Loader, TOAD, FTP, TKPROF,SQL Server

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Created design documents to be reviewed by architect.
• Worked on the bulk uploading of huge amounts of statistical data to the database.
• Wrote loader scripts using SQL Loader/External tables to load large tables.Experience with SQL intergrateddevrlopment environment(IDE).
• Designed and developed the classes using core java for thread safety in money transactions using Multithreading.
• Responsible for developing and modifying several PL/SQL packages, procedures, functions, views and triggers using PL/SQL.
• Optimized queries by obtaining Explain Plan, analyzing tables, providing hints, and adding Indexes on tables where required
• Performed maintenance work on the database.
• Analyzed data integrity problems and provided assistance in giving solutions.
• Actively involved in troubleshooting database issues.knowledge on TCC
• Provided SQL and PL/SQL code tuning to improve database response time and performance for several applications.
• Experience in Techno-Functional Consultant with solid understanding of various functional setups, API's, Interfaces with 3rd party software TCC.
• Designed high level designs and To-Be process flows, identifying integrations with HR and 3rd party applications for Taleo Recruitment Application to Hire covering following areas - Requisition, Candidate
• Experience in risk identification and Hr core modules and Application frame work.
• Experience in functional knowledge in creation implementing large scale data using work flow.
• Knowledge of Payroll and hr process.
• Developed Oracle Stored Procedures, Functions and Packages to effectively incorporate Business rules
• Worked extensively with Composite data types, Cursors and Dynamic SQL
• Worked with Dynamic SQL, Global Temporary Tables
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day. Used standard packages likeUTL FILE, DBMS SQL, and PL/SQLCollections and usedBULKBinding
• Created materialized views, Inline Views & normal views where business requirements needed
• Worked in Oracle reports and forms version 6i and 10g.
• Worked on Pro*C programs and SQL Scripts to generate full extracts of large tables.
• Worked in customization of reports in GL and PO.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing
• Developed stored procedures and packages. Extensive work in PL/SQL.
• Developed Reports and forms using Oracle Designer.
• Worked with development of packages and procedures using PL/SQL and functions using ETL and PL/SQL.
• Worked on developing/supporting oracle APEX applications.
• Involved in analysis, development, testing, and 24 x 7 production support.
• Our group supports numerous Oracle APEX applications.
• Resources are needed to help support additional applications that will be acquired by our team. They will need to provide run the engine and production support.
• They will also be asked to perform risk assessments and add needed controls to close any control gaps.
• Experience in tableau for creating BI reports and for visualization.Hand on experience with trouble shooting of performance issues which are associated with tableau reports.
• Extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.
• In-depth knowledge of XML and XSLT data and processing tools.Involve in QA cycle and UAt cycles of finding an errors and researching for suspected data issues.
• Knowledge of both Microsoft and Linux operating systems.Experience in OLAP and OLTP concepts .
• Integrate XML XSLT OOP and other types of programming into databases and applications

Environment: UNIX, Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader, Microsoft Excel,TOAD, APEX 4.4.2 SQL, PL/SQL, SQL*Loader, Reports6i, Toad, CVS, Core Java, .Net (ASP), HP-UX UNIX, XML, SQL SERVER,Tablae7.1

Confidential, Rosemont, IL

Sr. Oracle Developer/Lead

Responsibilities:

• Created design documents to be reviewed by architect.
• Worked on the bulk uploading of huge amounts of statistical data to the database.
• Wrote loader scripts using SQL Loader/External tables to load large tables.
• Responsible for developing and modifying several PL/SQL packages procedures, functions, views and triggers using PL/SQL to effectively incorporate Business rules.
• Optimized/Tuned SQL/PLSQL by obtaining Explain Plan, analyzing tables, providing hints, and adding Indexes to improve database response time and performance for several applications.
• Analyzed data integrity problems and provided assistance in giving solutions.
• Worked extensively with Composite data types, Cursors and Dynamic SQL.
• Worked extensively with SQL Servers.
• Worked with Dynamic SQL, Global Temporary Tables, materialized views, Inline Views & normal views
• Worked onSQL*Loaderto load data from flat files obtained from various facilities/sources on daily/weekly/monthly/yearly basis. Used standard packages likeUTL FILE, DBMS SQL, and PL/SQLCollections and usedBULKBinding.
• Worked with developing data entry/reporting pages in APEX.
• Developed Page Rendering components like Page, Report, Items, computations and processing, Page Processing components like computations, validations, processes and branches and Shared Components like Tabs, List of Values, Breadcrumbs, Lists, Templates, Themes and Navigations in apex.
• Implemented advanced programming techniques like APEX COLLECTIONS, APEX MAIL etc., in APEX.Experience in reviewing JavaScripts.
• Working knowledge on CVS Tortoise versioning system.
• Knowledge of Oracle reports and forms version 6i and 10g.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing
• Experience with supporting existing APEX applications.
• Involved in analysis, development, testing, and 24 x 7 production support, with 5 members in team.
• Extensively worked on Mapping Variables, Mapping Parameters.ents.
• Extensively worked in the performance tuning of ETL mappings and sessions.
• Extensively used transformations like lookups (connected and unconnected), Update Strategy, Joiner, Router, Sorter, Aggregator, Expression, Rank, Sequence Generator and others.
• Extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.Experience in RDBMS concepts and OLAP and OLTP concepts.
• Strong knowledge of XML Schema, Experienced in working with XML processing tools.
• Extensive knowledge of data modeling inside XML.Interacting with QA teams to review and develop data standards, data exchange, XML data standard, and data sharing model. Offering support for monitoring and tracking success of process improvements.

Environment: UNIX, LINUX, Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader, Microsoft Excel,TOAD, APEX 3.2, SQL, PL/SQL Developer, SQL*Loader, Toad, CVS, JQuery, HP-UX UNIX, XML, SQL server

Confidential - New York, NY

PLSQL Developer

Responsibilities:

• Defined business requirements and developed Technical Design Document for programming
• Designed and Developed back-end routines using Oracle PLSQL, Stored procedures/Packages, Triggers and SQL*loader.
• Wrote UNIX Shell scripts to generate daily reports for credit class updates of customers.
• Automated jobs through Autosys for creating Mass Adjustment Files to find customer accounts to be charged for late payments.
• Worked on range partitioning of history tables in order to improve batch performance.
• Implemented modifications to the existing code to add a memo to a customer account through API.
• Created daily reports of customer accounts which needed to be notified for adding a memo.
• Worked on Pro*C programs and SQL Scripts to generate full extracts of large tables.
• Used advanced SQL and analytical functions in various queries.
• Used package like DBMS JOB to determine if there are any jobs that are to be performed, or any changes are made to the program or procedure.
• Created Parameterized Reports and Customized Existing Reports for presentations using Cross-Tab reports and Sub-reports and Running Totals/Formulas in crystal report.
• Used for all and bulk collect to fetch large volumes of data in PL/SQL objects.
• Automated repetitive processes by writing shell scripts.
• Worked on accessing the application interface that integrates the internal applications with the billing system.
• Developed complex procedures to handle errors and exceptions at the database level using PL/SQL.
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process
• Tested application in Unit Test and deployed applications into the production server.
• Consistently coordinated with production support and also responsible for estimating the time factor for several jobs depending upon the data volume size.
• The role required extensive interactions with Business Managers and Users

Environment: UNIX, Oracle 9i/10g, PL/SQL, SQL*Plus, SQL*Loader, TOAD, PL/SQL; SQL; SQL LOADER, Toad, Oracle database 10g; Oracle Application Server 10g