SUMMARY:

• Over six years of IT experience in software development, analysis, design, production support and implementation with major focus on Databases and Data Warehousing, Business Intelligence and Database Applications.
• Excellent design, development and maintenance experience of applications using Oracle 12c,11g/10g/9i, SQL, PL/SQL, Oracle Forms 10g/9i/6i, Reports 10g/9i/6i.
• Expert in designing, developing, testing, and implementing PL/SQL triggers, cursors, stored procedures, packages, functions at database level and reporting level.
• Experience in development of complex query reports according to user requirement using Oracle Reports.
• Expertise in requirements gathering, software requirements specifications, systems development, testing (unit, performance), reporting, application maintenance, application / production support.
• Expertise with Data Migration, Bulk Data loading and exporting using SQL*Loader, Import/Export, and UTL File Utilities.
• Good understand of APEX.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Adept in key Oracle performance - related features such as Query Optimizer, Execution Plans, Hints, Indexes, Clusters, Partitioning.
• Proficient in tuning SQL queries using Explain Plan, Trace (TKPROF, SQL TRACE)
• Excellent data modeling skills. Good knowledge in using data modeling tools like ERWIN, and adept at Normalization Techniques for designing database with Relational technology on N-Tier Architecture.
• Great understanding of OLAP Data Warehousing processes and techniques on Oracle platform.
• In depth understanding of Dimensional Modeling techniques, Star and Snow Flake Schemas, Slowly Changing Dimensions, Late Arriving Facts.
• Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.
• Extensive experience with creating Oracle ETL Scripts utilizing SQL Loader, Import/Export, External Tables, DBLinks, Materialized Views, Merge command etc.
• Exposure to scheduling processes using UNIX Shell scripts, Cron jobs and other third party tools.
• Excellent understanding of SQL and OLAP functions for Business Intelligence purposes.
• Migration to Oracle Database from various data sources.
• Team player with excellent communication, problem solving organizational and interpersonal skills.
• Maintain positive communications and working relationships at all business levels.

TECHNICAL SKILLS:

Relational DBMS: Oracle 9i 10g 11g, 12c, MS SQL SERVER 2005, Teradata V2R5

Operating System: Red HAT LINUX, Windows

Programming Language: SQL PLSQL, Java, Java Script, C, HTML, XML

Oracle Tools: Oracle Developer, SQL Loader, Import/Export, SQL*Plus, SQL Developer, Toad, PL/SQL Developer 6.0, SQL Navigator, Oracle Discoverer 2000, Oracle Forms/Reports, ODI

Software Application: Microsoft Suite (Word, Excel, Power Point and Access), In Design, FrontPage and Dream weaver

PROFESSIONAL EXPERIENCE:

Confidential, Rosemont. IL

Sr. Oracle Developer

Responsibilities:

• Worked on designing, coding, testing and maintaining database objects, table, views, packages, functions, procedures, indexes, sequences and triggers using Oracle PL/SQL.
• Attending client meeting to discuss functional design for conversion programs.
• Worked on raising, handling and fixing defects in HP QC (Quality Centre).
• Created Oracle PL/SQL stored Procedures, Functions and Packages to develop.
• Worked on writing programs for Data Conversions.
• Worked on Bulk loader utilities like Sql loader for moving data from external files into the Oracle database.
• Extensive knowledge on HINTS and complex queries.
• Created database tables, indexes and partitioned existing tables.
• Performed unit, system and Integration testing.
• Design, develop and unit test new features, enhancements and interfaces for APEX web application
• Used Oracle APEX 4.0 for designing application structure.
• Expertise in Oracle APEX design and application.
• Created Oracle reports on demand.Enrollment count summary report, Billing report and other insurance/payroll/COBRA file transfer reports by using SSRS and SQL Server 2008/2012.
• Worked on checking log files on UNIX while working on support for production environment.
• Experienced on the tasks required to establish, to a high degree of assurance, that a system is performing its intended functions according to pre-defined specifications.
• Ensured timely completion of development projects within estimated costs and standards.
• Assisted in the implementation of programs to educate management and users in information processing and system capabilities, uses and requirements.
• Tasked to review and evaluate proposed system design resolutions (such as table structure, table relationships) and determine feasibility and practicability in real time environment.

Environment: Oracle 10g/11g/12c, PL/SQL, SQL Developer, Oracle Reports 10g, APEX, UNIX, MS Word, Ms Excel, Servers.

Confidential, Bingham Farms, MI

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.
• Created Oracle PL/SQL stored Procedures, Functions and Packages to support ETL process.
• Worked on SQL*loader to load data from flat files obtained from carious facilities every day.
• Created database External tables, views, and indexes and partitioned existing tables.
• Performed unit, system and Integration testing for a given task.
• Involved in the continuous enhancements and fixing of production problems.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Creation of database objects like tables, views, and materialized views using oracle tools like toad and PL/SQL developer.
• Ensured timely completion of development projects within estimated costs and standards.

Environment: Oracle 11g/10g, PL/SQL, SQL Developer, TOAD, UNIX, Forms Oracle Reports 10g, MS Word, Ms Excel.

Confidential, Seven Hills, OH

Oracle PL/SQL Developer

Responsibilities:

• Gathered the requirements and documented high level documentation for the project.
• Involved in the business requirements gathering and analysis, understanding client’s Data Warehousing requirements and system analysis.
• Designed Logical data model and Physical conceptual data model using Erwin.
• Developed user entry screens and master-detail forms using Oracle Forms.
• Created and designed reports based on complex queries using Oracle Reports according to the requirements.
• Responsible for overseeing all aspects of the databases. This includes installation, management, performance tuning, backup/restore, stored procedures.
• Worked with other developers in performance tuning of Databases and SSAS Cubes.
• Performed database design, tuning using Oracle Job Scheduler, Oracle Advanced Queuing.
• Applying constraints and writing triggers to apply the business rules.
• Involved in handling Errors and Transaction Processing in the Procedures.
• Created Records, Tables, Objects, and Error Handling.
• Performed Data Migration using SQL* Loader from flat files in to data base tables.
• Extensively involved in Writing PL/SQL Stored Procedures, Triggers, Functions, and Packages to meet the business requirements.
• Created custom partition tables for reporting.
• Created and maintained SSIS ETL packages to extract data from different systems, and load variety of large volume data into data warehouse from different sources like flat file, Excel file.
• Responsible for SQL tuning using explain plan and optimizer hints.
• Used Ref-cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Moved data from the old tables into the new tables using SQL*Loader.
• Handled exceptions for the ease of debugging and displaying the error messages in the application.
• Performed code reviews and acceptance testing of the application.

Environment: Oracle 10g/11g, PL/SQL, TOAD, UNIX, Oracle Forms 10g, Oracle Reports 10g, SQL*Loader, Oracle SQL Navigator, MS Word, Ms Excel.

Confidential, San Diego, CA

Responsibilities:

• Assisted in designing Logical data model and Physical conceptual data model using Erwin.
• Extracted data from different sources like flat files and loaded into Oracle data warehouse according to the specifications.
• Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
• Created stored procedures, triggers, tables, views.
• Documented all the packages, procedures and functions involved in ETL process.
• Developed Shell Scripts to automate file manipulation and data loading procedures.
• Unit and integration tested the target data.
• Worked with the team members in developing the Test Plan and Test cases for Unit testing for validation.
• Performance optimization, procedure definition, queries tuning, database design.
• Use SQL*Loader utility to upload data files into tables, Export and Import Oracle Utilities to move tables between Schemas.
• Gathered reporting requirements from business end users/clients. Identified key dimensions and facts for analytical reporting and decisions support reporting to develop custom reports.
• Developed forms and reports according to the specifications.
• Conducted technical/non-technical presentations to the management and training workshops for the clients.

Environment: Oracle 11g/10g, Toad for Oracle, Oracle Reports and Forms 10g, SQL*Loader, Windows, UNIX, Cron tab