Oracle programmer
Resume:
Birenkumar Mistry
Email: *************@*****.*** Phone: 256-***-****
TECHNICAL SKILLS
Oracle 7.x/8/9i/10g/11g (SQL,
PL/SQL, Stored Procedures,
Triggers), MS SQL SERVER,
****/****/**08, DB2/UDB,
Teradata, SAP Tables, MS Access,
Informatica (Power Center
5.1/6.2/7.1/8.6.1/9.1.0, PowerMart
5.1, Power Connect/Power Exchange
for SAP R/3, MainFrame, Oracle
Change Data Capture (CDC), AB Initio
1.8, SQL*Loader, Business Objects
Developer Suite 5.1/BO XIR2, Cognos
Suite, Cognos Report Net 1.1MR2,
Crystal Reports, Oracle Reports 2.5,
Oracle Reports 6i/9i/10g/11g, Oracle
Scheduler, Business Objects Developer
Suite 5.1/BO XIR2, Open Source
Business Intelligence Reporting Tool
4.4.1,Cognos Suite, Cognos Report
Net 1.1MR2, Crystal Reports, Oracle
Reports 2.5, SQL, PL/SQL, Unix shell
scripts, Java, XML, C, Cobol, AutoSys,
Control-M, PVCS, WIN CVS,
Informatica Data Quality, B2B Data
Transformation, Informatica Power
Exchange Informatica 9.1.0
Developer/Analyst, TPump, Fast
Load, BTEQ, UNIX(Sun Solaris, LINUX,
HP UNIX, AIX), Windows
NT/98/95/2000, Windows XP.
EDUCATION
Masters in Computer Science
Application (M.C.A) from Gujarat,
INDIA.
Post Graduate Diploma in
Computer Science Application
(P.G.D.C.A) from Gujarat, INDIA.
Bachelor’s in Computer Science
Application (B.C.A) from Gujarat,
INDIA.
SUMMARY
8+ years of programming experience as an Oracle
PL/SQL Developer in Analysis, Design and
Implementation of Business Applications using the
Oracle Relational Database Management System
(RDBMS).
Involved in all phases of the SDLC (Software
Development Life Cycle) from analysis, design,
development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity
relation modeling and design techniques.
Expertise in Client-Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions,
Materialized Views, Query Re-Write and Transportable table spaces.
Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like Embarcadero ER Studio, ERWIN, Toad Data Modeler.
Very good experience in Data warehouse concepts, ETL.
Strong experience in creating Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
Developed Complex database objects like Stored
Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Used Oracle Scheduler to control various computing tasks that take place in the enterprise environment.
Developed materialized views for data replication in distributed environments.
Experience with Oracle Forms, Oracle Reports and BIRT Reports.
Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
Loaded Data into Oracle Tables using SQL Loader.
Partitioned large Tables using range partition technique.
Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.
Page 2 of 6
Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
Worked extensively on Ref Cursor, External Tables and Collections.
Expertise in Dynamic SQL, Collections and Exception handling.
Experience in SQL performance tuning using Cost-Based Optimization (CBO).
Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
Experience in working with ETL tools-informatica.
Hands on experience with the Reporting tools such as Cognos.
Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
CHRONOLOGICAL SUMMARY OF EXPERIENCE
Client: Nationwide Title Clearing, Clearwater, FL AUG 15 – Present Oracle Programmer
Responsibilities:
Involved and executed many project for new business requirements with advance oracle techniques like oracle nested tables, oracle collections and bulk collect.
Handled ongoing maintenance and enhancement on oracle database 10g, 11g, 12c and oracle forms and reports.
Created and scheduled oracle jobs for business report generation.
Worked closely with Front end developers for oracle XML generations and E-mail generation for in-house and clients.
Involved and worked on financial analysis and tracking system project with Snr Financial Development Manager.
Worked on planet press application packages to generate .txt and xml files to generate Loan Documents.
Wrote many procedures to read data from scan gun and process them to lead fast production and ease to end user processing.
Worked closely with Project Manager, BA’s, QA Testers, Database Architects and DBA’s to carry out project with agile methodology.
Contributed many packages, procedures and functions with data encapsulation techniques.
Have skills to handle multiple projects simultaneously. Environment: Oracle 10g/11g, RAC, SQL*Plus, Oracle Forms 6i (Form Builder), Oracle Reports R6i, SQL Developer, EXPLAIN PLAN, AUTOTRACE, SQL*Trace, PL/SQL, Oracle Scheduler, Windows 7, Windows Team Foundation (TFS), Win Merge, Win SCP.
Page 3 of 6
Client: DTE Energy, Detroit, MI OCT 14 – July 15
Oracle PL/SQL Developer
Responsibilities:
Worked on different packages where I developed new PL/SQL Records, Tables for oracle, Cursors, Ref Cursors.
Involved in enhancements of existing functionality as well as fixing of production problems.
Work with Oracle Application Development Framework migration team to migrate oracle forms 6i application modules to Oracle ADF.
Worked on E-Mail and Text Notifications involving Oracle Advance Queue and Dequeue.
Design, developed modified Oracle 6i Forms as per requirements.
Wrote Unix Shell Scripts to process the files on daily basis for Invoicing and Billing.
Wrote PL/SQL anonymous blocks, Wrappers for Unit Testing.
Written Advance Oracle SQL Queries for Web Service features Enhancement.
Monitored Jobs on Maestro TWS Web admin.
Wrote new procedures more on finance side.
Environment: Oracle 10g/11g, SQL*Plus, TOAD, Oracle Forms 6i (Form Builder), SQL Developer, Oracle JDeveloper 11g R2, EXPLAIN PLAN, AUTOTRACE, SQL*Trace, Apache Server, PL/SQL, Shell Scripts, UNIX, Windows 7,Relational Clear Case, Win Merge, Putty, SOAP UI, Maestro TWS Web admin. Client: AT&T, Richardson, TX Jan 12 – Sept 14
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.
Developed operational and transactional data models (logical and physical) using Erwin 7.3.
Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
Designed and developed Oracle forms & reports and also modified (.fmb) as per requirements.
Involved in the continuous enhancements and fixing of production problems.
Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
Developed PL/SQL triggers and master tables for automatic creation of primary keys.
Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
Used Oracle Streams Advanced Queue for performance and scalability.
Responsible for Calling from the surrounding Webpage into Forms
Developed invoice-printing reports for consolidated invoices.
Run PL/SQL anonymous blocks, PL/SQL stored procedures with oracle scheduler.
Created indexes on the tables for faster retrieval of the data to enhance database performance.
Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
Page 4 of 6
Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
Have Experience with AJAX.
Partitioned the fact tables and materialized views to enhance the performance.
Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Updated ERWin Meta model to support data quality and integration.
Generated XML’s for web service teams for different channel. Environment: Oracle 10g/11g, SQL*Plus, TOAD, Oracle Forms 10g/11g, SQL*Loader, Erwin 7.3, SQL Developer, EXPLAIN PLAN, AUTOTRACE, SQL*Trace, TKPROF, PL/SQL, Shell Scripts, AJAX, UNIX, Windows XP, BIRT Report.
Client: ABC Supply, Beloit, WI Sept 09 – Dec 11
Oracle PL/SQL Developer
Responsibilities:
Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation and load packages for dataware housing. Extracted data from the XML file and loaded it into the database.
Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
Used External Event to communicate with a Forms module from outside of Forms.
Created management analysis reporting using Parallel Queries, Java stored procedure, HTPPackage and WEB.SHOW_DOCUMENT. Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
Implemented Oracle Streams Advanced Queue that integrates with existing non-Oracle Database messaging systems IBM WebSphere MQ.
Designed and modeled data warehouse in normalized schema. (ERWin)
Designed and developed Oracle forms & reports generating up to 60 reports.
Run executables that are external to the database (external executables), such as applications, shell scripts, and batch files by Oracle Scheduler.
Generated Billing Reports.
Performed modifications on existing form as per change request and maintained it.
Used Crystal Reports to track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information. Page 5 of 6
Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle
(SDLC).
Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.
Environment: VB 6, JAVA, Oracle 10g/11g, PL/SQL, ERwin, Informatica, SQL*LOADER, Oracle Forms 10g/11g,Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server SSIS, TOAD, ETL, XML, HP- UNIX shell scripting,.
Client: Embellish Group, Gujarat, India Nov 08– Aug 09 Oracle PL/SQL Developer
Responsibilities:
Used Oracle JDeveloper to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API’s like Java, .Net and Hierarchical databases like Oracle and Access.
Developed and modified a number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
Wrote Shell Scripts for Data loading and DDL Scripts.
Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
Used Oracle JDeveloper to support JAVA, JSP and HTML codes used in modules.
Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
Worked on ERWin 7.2 Data Modeling.
Designed and developed Oracle forms & Reports.
Responsible for Convert Oracle Reports into BIRT (Business Intelligence & Reporting Tools) open source report tool.
Responsible for the Star schema data model (ERWin).
Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
Used Time-Based and Even-Based Scheduling to Run Shell Script and Batch Files.
Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.
Involved in Logical & Physical Database Layout Design.
Set-up and Design of Backup and Recovery Strategy for various databases.
Performance tuning of Oracle Databases and User applications.
Used SQL*Loader as an ETL tool to load data into the staging tables.
Used DTS Packages as ETL tool for migrating Data from SQL Server 2000 to Oracle 10g.
Provided user training and production support.
Improved the performance of the application by rewriting the SQL queries.
Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
Page 6 of 6
Environment: Oracle 8/9i, SQL, PL/SQL, Oracle Forms 6i/9i, ERWin 7.2, Visual Basic 6, BIRT Report, SQL*Loader, SQL Navigator, Crystal Reports, TOAD.
Client: Saurabh Web Solution, Gujarat, India May 07 – Aug 08 Oracle PL/SQL Developer
Responsibilities:
Involved in interacting with the end-user (client) to gather business requirements.
Resolved application problems to maintain high level of customer satisfaction.
Involved in performance fine-tuning of the queries/report using PL/SQL and SQL Plus.
Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
Managed tables, indexes, constraints, views sequences, synonyms and stored program units.
Developed database triggers required for the Integrity constraints.
Created Logical and Physical Models using ERWIN.
Performed performance tuning and query optimization.
Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
Coded complex SQL queries to retrieve data from the database depending on the need.
Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
Written PL/SQL cursors for transaction processing.
Written Packages, stored Procedure, Functions for intricate Reports.
Created Data Visualization using Open Source BIRT Tool.
Written Queries for the management in the form of stored procedures and packages.
Involved in writing complex queries to generate reports as per client request as a part of production support.
Developed batch programs in Pro*C and wrote Scripts to run them on Unix Cron Scheduler.
Created partitions on the tables to improve the performance.
Extracted data from Flat files, Oracle and SQL server sources. Environment: Oracle 8/9i, Oracle forms 6i/9i Solaris 5.9, SQL Developer 1.1, Serena PVCS, Oracle, Enterprise Manager and Windows 2000.
Education Qualifications:
1. Masters in Computer Applications.
G H Patel P G Department of Computer Science and Technology, Vallabh Vidhyanagar, Gujarat, INDIA.
2. Post Graduate Diploma in Computer Science.
G H Patel P G Department of Computer Science and Technology, Vallabh Vidhyanagar, Gujarat, INDIA.
3. Bachelors in Computer Applications
Anand Mercantile College of Science, Management & Computer Technology, Anand, Gujarat, INDIA.
Country of citizenship: United States of America
Contact this candidate