Munir Muhammad

Senior Oracle Database Developer

** ***** ** ********** ** Oracle

Phone: 302-***-****

Email: ad2v4m@r.postjobfree.com

Profile

I have more than 15 years of experience in information technology. I have significant expertise in Oracle Databases, extensive experience in Oracle PL/SQL development, Performance Tuning, Data Architect, Data Modeling and implementing business technology solutions.

Summary

Overall 15+ Years of experience in Information Technology

Eight years extensive experience in Oracle PL/SQL development (Packages, Stored Procedures, Functions and Triggers) in accordance with coding standards

Two Years’ experience in Database Administration with Oracle and SQL Server

One Year experience in Data Modeling and System Designing

Three Years experience in Oracle Forms and Reports

Worked on different projects involving System Studies, Data Analysis, Development, Design, Coding, Debugging, Testing, and Implementation of Business Application Software

Two Years extensive experience with ER Studio by created data models, solution designs and data architecture documentation for complex information systems.

Expertise in using Stored Procedures, Triggers, Constraints, Oracle Packages, Shell Scripting, MS Access, MS Office, MS Visio, VBScript, and Crystal Reports

Proficient in Databases Conversions, Migration Application Tuning, Environment Setups, Security Backup, Restore, Indexes, ETL, UNIX, LINUX, SQL Loader, TOAD, FTP, Data warehouse.

Excellent experience in Development, QA, Test and Production environment.

Excellent experience in Tuning, Performance and Optimization of queries.

Extensive experience in Data Conversion, Migration, and Integration.

Extensive experience working on Waterfall and an Agile development environment.

Extensive experience in high volume of data processing and fast paced database environments.

Worked in close cooperation with project managers and other team members.

Worked independently and part of a group, to deliver under pressure and tight schedules.

Excellent Problem Solver, Committed to Work, Good Team Player and Target Oriented Acosta, FL, USA

Data Conversion Consultant October 2022– To-Date

Acosta provides sales, marketing, and commercial solutions to drive the client businesses. Acosta is the sales and marketing powerhouse behind the most recognized brands and a proven resource for top retailers across the U.S. and Canada. They offer flexible services that maximize efficiency. Acosta has a big client list like Kellogg’s, KEN’S, Nestle, Sabra, Tyson, Coca-Cola, Barilla etc.

I am working as a Sr. Data Conversion Consultant to convert and migrate data from different legacy systems of Core HR, Payroll, and Absence Management to Oracle Fusion.

Role:

Working as a Sr. Data Conversion Consultant for Oracle Fusion conversion project.

Involved in data conversion from Legacy system to Oracle Fusion

Heavily involved to develop PL/SQL stored procedures, functions, and packages for converting data from legacy systems to Oracle Fusion

Involved in creating internal and external tables, views, and indexes.

Extensively used PL/SQL tables, analytical functions, cursors, and exception handling.

Use SQL Developer for database design, changes, generate new queries, and tune the SQL.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Extensively involved in using hints to direct to optimizer to choose an optimum query execution plan.

Worked on Git, SharePoint, and different tools during this project.

Involved in writing complex queries to generate ad-hoc reports as per client request as a part of Conversion.

Worked closely with DBAs, Development, QA, Testing and Production team to implement projects successfully.

Excellent working relationships with different teams and users in the conversion project and solution of databases and applications.

Accomplishments:

Successfully completed Core-HR and Payroll conversion project CGI Client: CIGNA Health Insurance, FL, USA

Sr. Consultant September 2021 – September 2022 The Cigna Group is a global health company committed to improving health and vitality. Cigna global workforce of more than 70,000 colleagues work through Cigna Healthcare and Ever north Health Services to fulfil the mission to improve the health, well- being, and peace of mind of the more than 190 million customer relationships and serve in more than 30 countries and jurisdictions. Role:

Worked in the Agile environment and met all deadlines during sprint and PI.

Use TOAD for database design, changes, generate new queries, and tune the SQL.

Worked on UC4 job, Jenkins, UDeploy, Git, Jira, and different tools during this project.

Involved in writing complex queries to generate ad-hoc reports as per client request as a part of production support.

Involved in the analysis, design, development, customization, testing and implementation of the system.

Developed PL/SQL stored procedures, functions, and packages for moving the data from staging area to data mart.

Involved in Oracle forms and reports customization in dental platform.

Created scripts to create new tables, views, queries for new enhancements in the application using SQL Developer.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Extensively involved in using hints to direct to optimizer to choose an optimum query execution plan.

Collaborated with product owner, scrum master and technical team to design, build and test system.

Developed code fixes and enhancements of inclusion in future code releases. Worked on Agile environment. Accomplishments:

Tuned annual production job and reduced time from 30 hours to less than 1 hour by using Global temporary session level table by replacing external table and by using proper indexing and conditions. CGI Client: Merck, West Point, PA, USA

Sr. Technical Analyst April 2020 – August 2021

Merck is an American multinational pharmaceutical company. The company is ranked 69th on the 2021 Fortune 500 and 92nd on the 2021 Forbes Global 2000, both based on 2020 revenues. The company develops medicines, vaccines, biologic therapies, and animal health products. Merck has 74K employees all over the world and spend $13.6 Billion in research and development investment in 2020.

Project #1: RPA Returns Repricing Automation

The goal of the Return Repricing Automation is to streamline and automate the process of determining the correct refund amount with RPA.

Role:

Developed PL/SQL packages & procedures for the RPA project.

Created scripts to create new tables, queries for new enhancements in the application using SQL Developer. Created indexes on the tables for faster retrieval of the data to enhance database performance.

Extensively involved in using hints to direct to optimizer to choose an optimum query execution plan.

Handled errors using Exception handling for the ease of debugging and displaying the error messages in the applications.

Involved in designing the logical and physical model of database objects related with RPA project.

Working closely with business and the other team members to resolve the issues. Project #2: Project Unify – iHUB

Integration Hub (iHub) is a serverless ETL solution built using AWS Cloud technologies. The solution is a managed data lake that is architected to provide easy transition from traditional approaches to ETL management using relational database sources and targets. constructs for databases. All these constructs function similarly to how they do in a relational database, but they are loosely coupled and provide a flexible, abstracted framework for building solutions that leverage the inherent strength of AWS Cloud infrastructure.

Role:

Involved in creating database objects and ETL Jobs development.

Involved SIT and production testing.

Involved data validation analysis after postproduction.

Working closely with business and the other team members to resolve the issues.

AWS Cloud, TM1 and Python, few trainings have been completed during this project. Wells Fargo, Virginia, USA

Sr. Database Developer / Data Analyst __ _ April 2019 – March 2020 Wells Fargo (NYSE: WFC) is a diversified, community-based financial services company with $1.9 trillion in assets. It is the world's fourth-largest bank by market capitalization and the fourth largest bank in the US by total assets. Wells Fargo provides banking, investment, and mortgage products and services through 7,400 locations and has offices in 32 countries. Wells Fargo & Company was ranked No. 29 on Fortune’s 2019 rankings of America’s largest corporations. Role:

Worked on SQL*Loader to load data from flat files from various facilities.

Developed PL/SQL triggers and master tables for automatic creation of master 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 enhancements in the application using SQL Developer. Created indexes on the tables for faster retrieval of the data to enhance database performance.

Involved in Data Quality lifecycle, developed and maintained data management dashboards that generated visibility of Data Quality across dimensions resulting in improved data quality and integrity.

Evaluated data elements to identify and manage potential risks resulting in improved data quality and integrity.

Extensively involved in using hints to direct to optimizer to choose an optimum query execution plan.

Used Bulk Collections for better performance and faster retrieval of data by reducing context switching between SQL and PL/SQL engines. I used the advanced features of PL/SQL like Records, Tables, Object Types and Dynamic SQL to improve the database and query performance.

Collaborated with product management to design, build and test system. Developed code fixes and enhancements of inclusion in future code releases. Worked on Agile environment. SEI, Pennsylvania, USA

Sr. Database Developer / Data Architect October 2016 – March 2019 SEI (NASDAQ: SEIC) is a leading global provider of asset management, investment processing, and investment operations solutions for institutional wealth management. SEI serves about 8,200 clients, including banks, trust institutions, wealth management organizations, retirement plan sponsors, corporations, investment managers and hedge fund managers. SEI offices are all over the world including USA, Canada, Hong Kong, Ireland, the Netherlands, South Africa, the United Arab Emirates, and the United Kingdom.

I was working as a Senior Database Developer / Data Architect to support ongoing projects in Wealth Management Solutions. Role:

Worked heavily with relationship database models, schemas & entity-relationship diagrams using ER Studio to create technical/system design documents.

Involve Creating Oracle Tables, Partitions, Views, Triggers, Constrains, Synonyms, Sequences.

Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Oracle Enterprise Manager, SQL Tuning, Explain Plan, Dyna Trace etc.

Supporting multiple applications in the Wealth Management System.

Involved to Monitor Control-M jobs and production support.

Worked closely with DBAs, Development, QA, Testing and Production team to implement projects successfully.

Involved in designing the logical and physical model of database objects.

Extensively used PL/SQL tables, analytical functions, cursors, and exception handling.

Involved in data governance to guarantee that data integration policies and standards are followed throughout the organization and involved data quality checks.

Worked closely with the team members, trained them to maintain development standards recommended by Oracle.

Experience in designing data modelling and dimensional modelling. Accomplishments:

Created multiple physical and logical designs related with different modules of Portfolio Management

Tuned production job and reduced time from 3 hours to 25 minutes by using GIT, proper indexing and set baseline and tuned another production job to 500% performance improvement.

Tuned multiple jobs and improved more than 800% performance.by using different database performance techniques. JP Morgan Chase, Wilmington Delaware, USA

Sr. Database Developer / PL SQL Developer August 2014 - July 2016 JPMorgan Chase & Co. is an American multinational banking and financial services holding company. It is the largest bank in the United States, with total assets of US$2.515 trillion. It is a major provider of financial services and according to Forbes magazine is the world's third largest public company based on a composite ranking. The hedge fund unit of JPMorgan Chase is the second largest hedge fund in the United States.

I was working as a senior database developer to support ongoing projects in Card Services to support different lines of business including Oracle E-Business Suit.

Role:

Supporting multiple applications in the Card Services.

Involved in the tech refresh project for several applications by using Linux, Oracle, PL/SQL, Control-M, batch servers and implemented successfully.

Involved to implement Oracle E Business Suit for Supply Management System

Involved in database development by creating Oracle PL/SQL Packages, Stored Procedures, Functions & Database Triggers.

Rewrite lot of applications codes to improve the performance of the query.

Involved to Monitor Control-M jobs & create Oracle Concurrent jobs and make schedule.

Involved in tune with Discoverer Reports and Apex Application.

Involved in writing complex queries to generate ad-hoc reports as per client request as a part of production support.

Worked closely with Development, QA, Testing and Production team to implement projects successfully.

Extensively used PL/SQL tables, analytical functions, cursors, and exception handling.

Created high level detailed design documents. Involved Technical Documentation, Unit testing and Integration Testing.

Involved in production support and On-call.

Worked closely with the team members, trained them to maintain development standards recommended by Oracle.

Created database links to access data from remote databases.

Provide technical / programming support in developing various business solutions.

Excellent working relationships with application teams and users in the design, development, tuning and problem resolution of databases and applications.

Accomplishments:

Successfully implemented several applications for tech refresh project by using Linux, Oracle, PL/SQL, Control-M, batch servers from older version to the new versions.

Implemented Successfully Oracle E Business Suit for Supply Management System for Chase’s internal project with the help of Oracle Corporation.

Tune long running packages to reduce time and applied table partitions on large Tables.

Successfully Migrated 10 years of data for another Chase’s internal project, inserted around Five hundred million records successfully based on the business logic.

Barclays Bank, Wilmington Delaware, USA

Data Warehouse Developer / ETL Developer August 2012 - June 2014 Barclaycard US is a member of Barclay’s group of Barclays Capital, Barclays Wealth, Barclays Commercial, offering world-class solutions to various segment partners. System maintained accounts of all the customers and implemented a solution for providing standardized Accounting Reports and automates the process of providing the data to business without manual intervention. Role:

Involved in loading data from File to Stage and different layers like Source, ODS, ADS and DMA and finally to main legacy data warehouse to support different lines of business.

Involved in database development by creating Oracle PL/SQL Packages, Stored Procedures, Functions and Database Triggers.

Rewrite lot of applications codes to improve the performance of the query.

Extensive Knowledge and working of Bulk Collect for data retrieval and data loading.

Create and maintain Shell scripts to run Oracle Stored Procedures and Packages.

Use TOAD for database design, changes, generate new queries, format, and tune the SQL.

Extensively used the advanced features of PL/SQL like Analytical functions, Performance hints, Subtypes, PLSQL Records, PLSQL Tables, Bulk Collect and Dynamic SQL.

Involved in Tuning, Performance, Optimization of queries and standardization of the code.

Involved in designing the logical and physical model of database objects using Toad.

Extensively used PL/SQL tables, cursors, and exceptional handling.

Involved in writing complex queries to generate ad-hoc reports as per client request as a part of production support.

Created database links to access data from remote databases.

Involved in conversion of data from one platform to another platform.

Created high level detailed design documents. Involved in Gathered Requirements Technical Documentation, Unit testing and Integration Testing.

Accomplishments:

Successfully Migrated 7 years of data for Barclay’s internal project, inserted around Eight hundred and eleven million records successfully.

Successfully Migrated 5 years data to monthly snapshots from daily snapshots.

Tune the long running package to reduce time from 46 hours to 6 hours.

Successfully Migrated 10 years of data for another Barclay’s internal project, inserted around three hundred and sixty-eight million records successfully.

Drop database objects and their dependent objects to free up 1 TB space.

Dropped around 1800 views and synonyms which are invalid or greater than last 60 days and enhancement on the existing procedure and package to add drop view functionality in the main common package and free up 350 GB space. Department of Correction, State of Delaware

Sr. PL/SQL Developer / Data Analyst July 2005 – August 2012 CNT Infotech provides services for IT solution deliver to Department of Correction, State of Delaware. The State Department has different Software Application modules running on LINUX environment with Oracle 11g Database, 11g Application Server and Oracle 11g Developer Suit.

I was working with the client ‘State of Delaware – Correction Department’ during this period. Role:

Develop and use server coded objects like stored Procedures, Functions, Packages and Database triggers.

Generate new queries, reports, and regenerate the graphs.

Normalization of the Data Models for the applications.

Rewrite multiple applications codes to improve the performance of the query.

Use TOAD for database design, changes, generate new queries, format, and tune the SQL.

Involved in the process of migration from Oracle Forms 5 and Reports to Oracle Developer Suit 10g being upgraded to be web deployed J2EE using Oracle 10gAS as part of the Oracle 10g Conversion project on the LINUX environment.

Involved in writing complex queries to generate ad-hoc reports as per client request as a part of production support.

Involved in conversion of data from one platform to another platform.

Used Database trigger for making history of insertion, updating and all kind of Audit routines.

Involved in the analysis, design, development, customization, testing and implementation of the system. City of Edmonton, Edmonton, AB, Canada

Oracle Developer October 2004 – April 2005

The City of Edmonton provides a variety of municipal programs and services. I was working with City of Edmonton at the Emergency Response Department (ERD) is reengineering the current documentation of patient care for the Emergency Medical Services (EMS).

Role:

I worked as an Oracle Developer. My job responsibility was being upgraded to be web deployed J2EE using Oracle 10gAS as part of the Oracle 10g Conversion project and involved in the conversion of over 150 Reports and 45 Forms using Oracle Developer 2000

Education

Master of Business Administration

Two Years Advanced Diploma in Computer Sciences

Trainings and Certifications

AWS Advance Training

Oracle Certified Professional

Certificate of Merit - Over all first prize in Second Software Exhibition from PETROMAN Industry experience

Financial Finance

Health Care Industry

Investment Portfolio

Technical specializations

Oracle Databases

PL/SQL

Performance Tuning

Data Modellingbases /SQLL

De

Areas of expertise

Oracle Databases

PL/SQL

Performance Tuning

s

Environnements

Windows

Linux

Unix

Tools & software

Toad

SQL Developer

Oracle Enterprise Manager

UC4 Job

UDeploy

, Db Artisan, Toad, SVN, Jenkins, ALM

Languages

English

n

Skills Summary Number of years Skill level*

Technical skills

SQL 14

PL/SQL 8

Oracle Database Development 12

Data Design and Modeling 6

Performance Tuning 6

Application knowledge

Toad 8

Oracle Developer 6

ER Studio 3

Industry knowledge

Financial Institutions 0

Health Card Industry 0

Other relevant skills

Oracle Discoverer (BI Tool) 3

ER Studio (Data Modeling Tool) 2

*Skill Level: = Basic, = Intermediate, Advanced, Expert

Contact this candidate