Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Birenkumar Mistry

Odessa,FL

Summary

  • Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
  • Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
  • 10+ 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 19c/12c/11g/10g/9i/8i, PL/SQL, SQL PLUS, TOAD and SQL LOADER. Effectively made use of Table Functions, Indexes, Table Partitioning, 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 modeling concepts. Strong experience in creating Tables, Views, Constraints, Index. 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. 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, UTL_HTTP and UTL_FILE.
  • Good experience working with JSON and XML on sending and receiving data to/from Oracle. Expertise in Dynamic SQL, Collections, Ref Cursor, External Tables and Exception handling.
  • 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 AUTOTRACE. Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Overview

16
16
years of professional experience
1
1
Certification

Work History

Oracle Development Lead

Covius Holdings, Inc.
08.2015 - Current
  • Implemented and enhanced PerfectDocs application with supporting 4 offshore and 1 on-premise teams.
  • Collaborated with product specialists to understand requirements and align business processes to product features and capabilities.
  • Determined and implemented innovative and industry best practices using modern designs and tools.
  • Worked on SaaS application project called PerfectDocs to allow clients to process mortgage related services at their own.
  • Created packages to handle large objects with Oracle 12c Release 2 using JSON and built in JSON functions
  • Involved and executed many projects 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 .NET 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 Sr.Financial Development Manager
  • Worked on third party planet press application packages to generate .txt and xml files to generate Loan Documents
  • Worked closely with Project Manager, BA’s, QA Testers and DBA’s to carry out project with agile-scrum methodology as well as SDLC.
  • Proven skills to handle multiple projects simultaneously.
  • Environment: Oracle 12c/11g, SQL Plus, Oracle Forms 6i (Form Builder), Oracle Reports R6i, SQL Developer, EXPLAIN PLAN, AUTOTRACE, SQLTrace, PL/SQL, Oracle Scheduler, Windows 10, Windows Team Foundation (TFS), Win Merge, Win SCP.

Oracle PL/SQL Developer

DTE Energy
10.2014 - 07.2015
  • 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 PL/SQL procedures.
  • Design and developed modified Oracle 6i Forms as per requirements.
  • Wrote Unix Shell Scripts to process 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, SQLPlus, TOAD, Oracle Forms 6i (Form Builder), SQL Developer, Oracle JDeveloper 11g R2, EXPLAIN PLAN, AUTOTRACE, SQLTrace, Apache Server, PL/SQL, Shell Scripts, UNIX, Windows 7, Relational Clear Case, Win Merge, Putty, SOAP UI, Maestro TWS Web admin.

Oracle PL/SQL Developer

AT&T
01.2012 - 09.2014
  • Coordinated with front-end design team to provide them with necessary stored procedures and packages and necessary insight into 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 file, extracting date from file, unzipping file and remove junk characters from file before loading them into 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.
  • Created PL/SQL stored procedures, functions and packages for moving data from staging area to data mart.
  • Created scripts to create new tables, views, queries for new enhancement in application using TOAD.
  • Developed invoice-printing reports for consolidated invoices.
  • Run PL/SQL anonymous blocks, PL/SQL stored procedures with oracle scheduler.
  • Created indexes on tables for faster retrieval of data to enhance database performance.
  • 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 data from operational database into simple flat text files using UTL_FILE package.
  • 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.
  • Environment: Oracle 10g/11g, SQLPlus, 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.

Oracle PL/SQL Developer

ABC Supply
09.2009 - 12.2011
  • 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 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 testing needs of change components.
  • Worked on troubleshooting defects in timely manner.
  • Designed and modeled data warehouse in normalized schema (ERWin).
  • Run executables that are external to database (external executables), such as applications, shell scripts, and batch files by Oracle Scheduler.
  • 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.
  • Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle (SDLC)
  • Involved in 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, SQL LOADER, Oracle Forms 10g/11g, Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server, TOAD, XML, shell scripting

Oracle PL/SQL Developer

Embellish Group
11.2008 - 08.2009
  • 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 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.
  • Designed and developed Oracle forms & Reports.
  • Responsible for 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 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.
  • Provided user training and production support
  • Improved performance of application by rewriting SQL queries.
  • Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links
  • 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.

Oracle PL/SQL Developer

Saurabh Web Solution
05.2007 - 08.2008
  • Involved in interacting with end-user (client) to gather business requirements.
  • Resolved application problems to maintain high level of customer satisfaction.
  • Involved in performance fine-tuning of queries/report using PL/SQL and SQL Plus
  • Developed Unix Shell Scripts to automate backend jobs, loading data into Database using SQL Loader.
  • Managed tables, indexes, constraints, views sequences, synonyms and stored program units.
  • Developed database triggers required for Integrity constraints.
  • Performed performance tuning and query optimization
  • Participated in Performance Tuning of SQL queries using Explain Plan to improve performance of application.
  • Coded complex SQL queries to retrieve data from database depending on need and Created Cursors and Ref cursors as a part of the procedure to retrieve selected data.
  • Written Packages, stored Procedure, Functions for intricate Reports.
  • Created Data Visualization using Open Source BIRT Tool.
  • Written Queries for 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 tables to improve performance and 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

Masters in Computer Science Application - Computer Science

G H Patel P G Dept. of Computer Science And Tech.
Anand, Gujarat, India
04.2009

Post Graduate Diploma - Post Graduate Diploma in Comp. Sci. & Applications

G H Patel P G Dept. of Computer Science And Tech.
Anand, Gujarat, India
04.2005

Bachelor’s - Computer Science & Application

Anand Mercantile College of Sci., Mgt. & Tech.
Anand, Gujarat, India
05.2004

Skills

  • TECHNICAL SKILLS:
  • Oracle 19c/12c/11g/10g/9i/8i (SQL, PL/SQL, Functions, Stored Procedures, Triggers), Oracle Reports 6i/9i/10g/11g, Oracle Scheduler, Oracle Enterprise Manager, SQL, PL/SQL, Unix shell scripts, XML, Java Script Object Notation, C, , AutoSys, Control-M, Oracle Scheduler, GitHub – SourceTree, UNIX (Sun Solaris, LINUX), Windows 10/8/7/XP/2000, MS Access/Word/Power Point, Azure – Team Foundation Server

Certification

  • Oracle Certified Professional - Oracle 10g Database Administrator - June 2014
  • Oracle Certified Associate - Oracle 10g Database Administrator - May 2014
  • Oracle Certified Expert - Oracle Database SQL - Jan 2014

Timeline

Oracle Development Lead

Covius Holdings, Inc.
08.2015 - Current

Oracle PL/SQL Developer

DTE Energy
10.2014 - 07.2015

Oracle PL/SQL Developer

AT&T
01.2012 - 09.2014

Oracle PL/SQL Developer

ABC Supply
09.2009 - 12.2011

Oracle PL/SQL Developer

Embellish Group
11.2008 - 08.2009

Oracle PL/SQL Developer

Saurabh Web Solution
05.2007 - 08.2008

Masters in Computer Science Application - Computer Science

G H Patel P G Dept. of Computer Science And Tech.

Post Graduate Diploma - Post Graduate Diploma in Comp. Sci. & Applications

G H Patel P G Dept. of Computer Science And Tech.

Bachelor’s - Computer Science & Application

Anand Mercantile College of Sci., Mgt. & Tech.

Similar Profiles

CREATE PROFILE
Birenkumar Mistry