SUMMARY

• A Technology driven IT professional with over 3+ years of experience in designing and developing Complex applications, developing Reports for Internet/Intranet based applications using Oracle..
• Experience using SQL in a large - scale relational database environment.
• Expertise in writing SQL Queries, PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Materialized Views, SQL Trace on Oracle 10g/11g databases.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Extensive experience in database programming using SQL and PL/SQL.
• Experience in developing UNIX Shell scripts, SQL and PL/SQL coding.
• Managed many database tables using Views and Sequences.
• Involved in handling large volumes of data.
• Experience in Dynamic SQL, PL/SQL Collections and Exception handling.
• Experience with Cognos TM1 tool.
• Involved in data loading by using Turbo Integrator (TI) in to TM1 cubes.
• Connected to different data sources from TI.
• Created replication process in TM1.
• Experience in Table Partitioning, creation of indexes for faster database access and better query performance.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and different file formats utilizing oracle Utility tools SQL *Loader, Import and Export.
• Worked on Performance Tuning and SQL optimization.
• Expertise in using Excel spreadsheets.
• Expertise in writing Pipeline functions.
• Extensive experience in using Compound triggers.
• Planned, Designed and Implemented Table Partitioning for improving performance.
• Expertise in utilizing oracle Utility tools SQL *Loader, Import and Export.
• Experience with Oracle SQL and PL/SQL programming and used Database utility tools like SQL Navigator, SQL Plus, TOAD, SQL Developer.
• Expertise in working with Oracle built-in packages such as DBMS SCHEDULER, UTL FILE, UTL MAIL, DBMS SQL, DBMS JOBS.
• Experience of building and maintaining Microsoft Excel Spreadsheets, Pivot tables and Macros.
• Excellent Analytical, Programming and Reporting skills.
• Experience in Understanding complex performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Coordinated with DBAs, QA, Release Management and external team for technical needs and to ensure the timely release of project.
• Good communication skills, inter personal skills and proven ability to perform both as an individual and as a team player.

TECHNICAL SKILLS

Scripting: PL/SQL, SQL, C, UNIX, TI

Web Technologies: HTML, HTML5, XML

Database: Oracle 9i/10g/11g, SQL Server, Ms Access 2000.

Operating Systems: Windows 95/98/NT/XP/Vista, Windows 2007, UNIX, Linux

Tools: /Utilities/IDE: SQL Developer, Putty, SQL Navigator, SQL*Plus, SQL*Loader, TOADAQT (Advanced Query Tool), Oracle forms and reports 9i, Cognos TM1 Architect, Perspective and TM1 Web.

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Oracle Pl/Sql Developer

Responsibilities:

• Collaborated with the Business analysts and the DBA for requirements gathering, business analysis, testing and project coordination
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in developing CRONTAB to schedule the information of cron entries.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Worked with the Data mart team and involved in the development process.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Extensively used Ref cursors.
• Used external hints during the SQL optimization to fast up the SQL process. worked with bulk collect to Implement the performance of multi row queries
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems using PL/SQL and SQL*Loader.
• Remediate Oracle application Custom object components like Forms, report and Concurrent Program (PLSQL code).
• Involved in development of Oracle Forms/Reports, New Screen designs, Modifications.
• 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.
• Connected to Oracle database from Turbo Integrator and written SQL queries to get the data in to the TM1 cube.
• Extensively used TI processes to load the TM1 cube.
• Created several Dimensions using the Cognos TM1 tool.
• Implemented SQL and PL/SQL stored procedures.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• 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.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, Oracle Forms 10g,Reports10g,UNIX, Windows XP/2000.owb 10g, Cognos TM1

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Hands on experience for performance tuning on existing SQL to improve application performance.
• Involved in all phases of SDLC as active participant.
• Has a very good exposure on technical documentation.
• 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.
• Strong drive and determination to meet targets and deadlines.
• Works quite well under pressure, has a can do attitude.
• Involved in project plan and Risk plan.
• Created Materialized views for summary reports and extracts for better query performance.
• Used various Indexing and partition techniques to improve the query performance.
• Strong experience to analyze the existing and proposed systems.
• 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.
• Review the test cases and code developed by team members.

Environment: Oracle 10g, UNIX, PL/SQL, Shell Script, Windows XP, Clear Case, Clear Quest, Unix Shell scripts, SQL navigator, SQL * Loader, Microsoft Visual web developer 2009