SUMMARY

• A Technology driven IT professional wif 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 wif 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 wif Oracle SQL and PL/SQL programming and used Database utility tools like SQL Navigator, SQL Plus, TOAD, SQL Developer.
• Expertise in working wif 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 wif DBA’s to suggest valuable ways to fix teh problem.
• Coordinated wif DBAs, QA, Release Management and external team for technical needs and to ensure teh 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 wif teh Business analysts and teh 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 teh information of cron entries.
• Involved in creation of Conceptual Modeling covering all teh business requirements.
• Loaded teh data into database tables using SQL*loader from text and excel files.
• Worked wif teh Data mart team and involved in teh development process.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Extensively used Ref cursors.
• Used external hints during teh SQL optimization to fast up teh SQL process. worked wif bulk collect to Implement teh 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 teh 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 teh data in to teh TM1 cube.
• Extensively used TI processes to load teh TM1 cube.
• Created several Dimensions using teh 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 wif master tables, insert teh valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying teh errors.
• Worked wif 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.
• TEMPHas 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, TEMPhas 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 teh query performance.
• Strong experience to analyze teh 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 wif business analyst and software developers for bug reviews and participated in QA meetings.
• Used Explain Plan and AWR reports to tune teh complex queries and debug teh queries to provide exact solution.
• Conducted brainstorm meetings and suggested performance improvement techniques and proposed designs.
• Review teh 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