Security Clearance Data Science

Mustafa Lakdawala

Pembroke Pines, FL *****

Cell : 954-***-****) Email:*********@*******.***

LinkedIn: https://www.linkedin.com/in/mustafalakdawala44b1a2/

Professional Summary:

I am a PL/SQL Certified Senior Oracle Developer with over 23 years of experience in developing intermediate, database objects including Tables, Views, Sequences, Packages, Procedures, and Functions to be used prior to loading Oracle Applications.

Well-versed in developing customized APIs for interacting with the Price/Fee Engine of Oracle Applications EBS and have expertise in designing and developing tables, views, various SQL queries, stored procedures, functions, and complex PL/SQL packages for ETL. Oracle Exadata, Cloud.

Extensive experience with OLTP and OLAP (Data Warehouses)

Proficient in writing complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators and oracle analytics.

Hands-on experience in database modeling using DB Visualizer, TOAD, and SQL Developer and designed interfaces to Oracle EBS, SSMS, SSIS, and SSRS.

Very well versed in Pro*C/C++ batch programming.

Have a Bachelor’s Degree and am immediately available for the interview.

Proficient with CI/CD tools like JIRA/Rally to meet CMRs (Change Management Requests).

Extensive work in Agile Scrum/Kanban and Waterfall environments.

Worked with databases like SQL Server, MySQL & PostgreSQL

Python & Django.

MongoDB

Version Control tools like SVN, Github, Mov’zart, Totoise

Professional Experience:

Bank of America, Addison, TX – Feb 2024 – Jan 2025

Application Programmer V (Senior Database Consultant thru Synechron)

Agile environment and worked in direct liaison with Managers/BA towards requirements analysis to final development and delivery of modification of existing system to incorporate new functionality

Designing/developing tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages.

Desgin & Development of Payments Recovery from SQL Server to Oracle

Design & Development of non-monthly payments(weekly, bi-weekly, semi-monthly) for loans.

Environment: Oracle 12c, 19c, PL/SQL, SQL*Plus, SQL*Loader, PL/SQL, SQL*Loader, Toad 9.1

Prime Therapeutics, Remote – May 2023 – Nov-2023

Sr. IT Developer (Senior Database Consultant thru York Solutions)

Agile environment and worked in direct liaison with Managers/BA towards requirements analysis to final development and delivery of modification of existing system to incorporate new functionality

Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.

Involved in PL/SQL code review and modification for the development of new requirements of Data Warehouse.

Optimization & tuning of Oracle SQL, External Tables

Design development and modifications of Oracle objects to meet new requirements with minimum impact to existing production system.

Tuning Oracle Queries/Processes to meet performance requirements.

Environment: Oracle 19c, PL/SQL, SQL*Plus, SQL*Loader, PL/SQL, External Tables, Toad, Python, JIRA, Agile Scrum/Kanban, SQL Kanban, XML Tables, JSON Tables

Florida Blue, Jacksonville, FL - November 2019 – Feb 2023

Sr. IT Developer (Database)

Agile environment and worked in direct liaison with Managers/BA towards requirements analysis to final development and delivery.

Performed discussions with data modeler to update the data model for new requirements.

Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.

Involved in PL/SQL code review and modification for the development of new requirements.

Optimization & tuning of Oracle SQL, External Tables, Partitioning

Design development and modifications of Oracle objects to meet new requirements with minimum impact to existing production system.

Tuning Oracle Queries/Processes to meet performance requirements of Data Warehouses.

Identifying enhancements when moving from Oracle 12c to 19c.

Environment: Oracle 12c, 19c, PL/SQL, SQL*Plus, SQL*Loader, PL/SQL, SQL*Loader, Toad 9.1, Rally, GitHub, Agile Scrum/Kanban, SQL Server, T-SQL, SSMS, SSIS, SSRS, Toad.

CVS Health/ Bank of America - January 2019 – Oct 2019

Architect/Team Lead (Consultant thru Infosys)

Involved in various stages of SDLC like Requirement gathering, high level design, low-level design, Coding.

Performed discussions with data modeler to update the data model for new requirements.

Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.

Involved in PL/SQL code review and modification for the development of new requirements.

Optimization & tuning of SQL. External Tables, Partitioning for Data Warehouses.

Environment: Oracle 12c, Oracle Exadata, PL/SQL, SQL*Plus, SQL*Loader, PL/SQL, SQL*Loader, Toad 9.1, JIRA, Team Tracker, Agile Scrum, SQL Navigator XML Tables, JSON Tables.

The Sphere - April 2018 – Nov 2018

Senior Oracle Developer (Corp to Corp thru MHUS Enterprises)

Gathered requirements from Business users and created a Low-level technical design document using high level design document.

Wrote Stored Procedures, Functions, Packages, and triggers using PL/SQL to implement business rules and processes.

Encapsulated PL/SQL procedures and functions in packages to organize application.

Used Views, Cursors, Store procedures, Packages, Collections and Triggers.

Wrote complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.

External Table file loading into BLOB, CLOB columns for JSON data.

Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.

Environment: Oracle 11g, Oracle 12c, Oracle Exadata, Cloud, External Tables, Oracle 18c, SQL, PL/SQL, SQL*LOADER, Pro*C, JSON, TOAD, Linux, JIRA, GitHub, Agile Scrum, Toad XML Tables, JSON Tables.

Independent Living Systems, Miami, FL - Aug 2016 – Jan 2018

Senior Developer SQL Server & BI

Analyzed Business Requirements with BA's.

Developed database objects including Tables, Views, Sequences, Procedures to troubleshoot any database problems.

Bulk load of external files from Health Care Organizations into Database using SSIS.

Involved in uploading of the data from flat files into Databases and Validated the Data with PL/SQL procedures.

Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.

Environment: SQL Server Release 12, SSMS, SSIS, SSRS, T-SQL, JIRA, Agile Scrum, C#, .NET, Firebird, Razor SQL.

World Fuel Services, Miami, FL - May 2015 – Jul 2016

Oracle Developer III

Developed Customized APIS for interacting with the companies Price/Fee Engine of Oracle Applications EBS

Developed intermediate, database objects including Tables, Views, Sequences, Packages, Procedures, Functions to be used prior to loading Oracle Applications.

Optimization & tuning of database APIS.

Environment: Oracle 11g, 12c, SQL, PL/SQL, Collections, Oracle EBS, Agile Scrum, Movz'art, Toad.

LexisNexis, Boca Raton, FL - Aug 2011 – Mar 2015

Software Engineer

Developed MySQL/Oracle database, procedures/packages for automated deployment of datasets.

Designed, developed, and implemented UNIX shell scripts, Perl for automated deployment of ECL packages.

Environment: Perl, MySQL, Oracle, ECL, PL/SQL Packages, Triggers, SVN Version Control, Ab Initio, SQL Developer.

Soleo Communications, Florida - April 2004 – Jun 2011

Senior Software Developer/DBA (Oracle/SQL)

Managed & Administered databases on Oracle, SQL Server, MySQL, PostgreSQL for national & international clients.

Did Data Modelling and recommended & implemented generic solutions for YP & WP listing systems.

Environment: DBA/Developer, Oracle 10g, Enterprise Manager, Oracle RAC, ASM, RMAN, Replication, SQL, SQL*PLUS, PL/SQL, Packages, Procedures, Functions, Triggers, Pro*C, T-SQL, ETL MySQL 5.125, MySQL Clusters 7.1.3, Packages, MySQL triggers, PostgreSQL, TOAD, SQL, PostgreSQL, iReports (Jasper Reports)

Grace Kennedy Remittance Services, Miami, FL - April 2002 – Apr 2004

Software Engineer (Oracle)

Designed processes for transfer of custom data to Oracle applications using Oracle Interfaces.

Customized various application modules for Oracle Reports.

Environment: Oracle E-Business Suite 11i, GL, HR, AP, AR, Inventory, Sales Compensation, Cash Management, Oracle 9i,

Oracle 8i, Oracle Forms, Oracle Reports, SQL, SQL*PLUS, PL/SQL, Packages, Procedures, Functions, Triggers, TOAD,

Java, JDBC, C/C++, Windows NT Servers, Windows 2000.

Materialized Views

Vital Computers, Fort Lauderdale, FL - Aug 1997 – Mar 2002

Consultant

Consulted for Citicorp, Nations Rent, Nortel, Teleware Global, Equitrac, Norwegian Cruise Lines

Environment: Oracle 8i, 9i, DBA, Developer, SQL, SQLPLUS, PL/SQL, Oracle Replication, Packages, Procedures,

Functions, Oracle Forms, Oracle Reports, Triggers, Pro*C, Developer 2000, Oracle Forms, Oracle Reports, TOAD, Oracle

Applications 11g, 10.7, GL, Inventory, AP, AR, Cash Management, Billing, UNIX shell scripting, Perl, Java, VB, MS Access,

MS Excel, Lawson, Linux, AIX, Sun, Solaris, HP-UX, Windows NT

Superior Insurance, AT&T Capital, New York - Feb 1996 – Jul 1997

Consultant

Consulted for Superior Insurance, AT&T Capital.

Environment: Oracle 7.2 - 7.3, Developer 2000, Forms & Reports, SQL, PL/SQL, Packages, Procedures, Functions, Triggers, Pro *C, C/C++, UNIX, Shell Script, HP-UX servers, WINDOWS 95 workstations.

Technical Skills:

Database, Database Modeling, Data Model, JDBC, MS SQL Server, SQL Server, MySQL, Oracle, Oracle 19c thru 7, Oracle Forms, PL/SQL, Toad, SQ Navigator, PostgreSQL, SQL Queries, Stored Procedures, Pro*C, Agile, Scrum, .NET, C#, C/C++, Developer 2000, HTML, JSON, PERL, Python, Shell Scripting, XML, AIX, Linux, UNIX, UX, JIRA, Rally, Microsoft SSRS, SSRS, T-SQL, Data Warehouses, ETL, Star/Snowflake Schema, AB Initio.

Education & Certifications:

PL/SQL certified – Oracle.

Python, ML/AI - University of Texas, Austin.

Introduction to programming with Python - CS50, Harvard University

Bachelor of Technology: Indian Institute of Technology, Chennai, India 1992

Contact this candidate