| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name - Green Card
Phone: PHONE NUMBER AVAILABLE
Email:EMAIL AVAILABLE
Street Address
Sr. Oracle PL/SQL Developer
Summary:
Professional programmer, well-versed working on applications forms and databases. Expertise includes data modeling
tools and report development tools. Team-oriented and hardworking with good verbal and written skills.
Designing database schemas, creating PL/SQL procedures, functions, and batch scripts.
Manage all phases of the SDLC from analysis, design, development, testing, implementation and maintenance.
Involve in developing, testing, compiling, debugging and maintaining the data using oracle, PL/SQL, UNIX, LINUX.
Version Control using Git / Change request method.
Client coordination and enhancement for business requirements and updates.
PROD SUPPORT for continuous data fabrication and mentoring team members.
Skill Summary:
Operating Systems Windows 98, 2000,Visa,10, 11 - MS Dos - Unix, Linux
Programming Languages/Tools C,C++, SQL, PL/SQL, TSQL, Procedure,Functions, Collections, Bulk Collect, Triggers,
Unix Scripting, Java, Oracle SQL Developer, Java, Toad, Putty, SQL * Loader , SQL
integration with Java, ETL using Informatica, Python
Databases Oracle, 9i,10g, 11g, 12c, 19c - SQL Server
Front End HTML, XML, Oracle Forms, Oracle Reports
Other Software Utilities Version Control (Version one, Git), TFS branching/ATC/Appwit), Autosys job scheduler,
Excel Macros, Visual Studio, AWS, CI/CD Pipelines, API s
Cognizant LLC Tampa, FL 10/2021 to 05/2024
Sr. Associate Project (Oracle PL SQL Developer)
Description:
PRODUCTION SUPPORT (onsite) feeds into Database using files, tables, Mviews and db links using Jobs.
Writing UNIX commands for server management and cleanups.
Database management, cleanup of legacy database tables, partitioning and auditing tables.
Skilled in Code Optimization and Performance Tuning of the new and existing application using Explain Plan, Hints,
Indexing and Partitioning of tables.
Upgrading NFS mount server after decommissioning.
Oracle Migration from 12c to 19c pre and post activities and configuration.
Modified/Rebuild views to utilize existing indexes.
Good in Complex SQL queries and PL/SQL procedures and functions to extract data from various source tables and
feeds.
Data Modeling and BRD are key aspects of the project.
Developed extensive PL/SQL packages creating and using Local and Global Tables.
Used Bulk operations, Collections to load large data sets.
Maintaining CI/CD pipelines along with Datalake communication.
Mentoring team for complex code development and integration testing.
Awards and Achievements:
Product Excellence Award : A feature enhancement for product availability in interactive graphic view and more
readable and understandable 3x to customers.
Feeds lag reduced to ever low and highest availability due to quick monitoring and corrective measures.
Resolving 12c to remote 19c connectivity issue. Processing issue resolution from Unix/Linux server to DB server.
MSTECH USA 03/2021 to 07/2021
PL/SQL Optimizer / Developer
Description:
Oracle database full life cycle development including data modeling, database architecture, SQL and PL/SQL
development, unit testing, Import & export, Bulk Collect, Collections and support of legacy databases.
Developing detailed technical analysis and design specifications based on functional requirements.
Collaborating with fellow developers, designers, and analysts to solve problems.
Created technical designs after analyzing database and business requirement documents
Having completed the designing of ETL processes (Batch Jobs).
Document program specs, system design, system test plan, unit design, unit test plans and test cases.
Developed new features in PL/SQL packages based on tech design docs (Oracle 10g) using SQL Navigator as main
development tool
Analyzed and modified ETL procedures in DataStage 7.5 and monitored them for any failures
Creating and improving existing reusable database objects. Optimize and tune SQL queries to maximize speed and scale
as per set and follow coding standards.
NTT Data / Centene Corporation, Tampa FL 03/2020 to 08/2020
Oracle PL/SQL Developer
Description:
Tampa, Florida Working with Complex Queries Analysis, Performance and tuning in a delivery Environment using
different tools Oracle 12c. Specially EDI, Healthcare and Medicaid environment using Visual Studio17, (TFS, Branching,
Manifest, Jenkins). Working with SQL *Loader and batch files for data loading.
Interacting with business users, gathering and analyzing requirements.
Writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
Developed ETL process for Data Extraction, Data Mapping and Data Conversion using SQL, PL/SQL and various shell
scripts.
Migrated the files and the Oracle data into the present system using SQL Loader.
Designed Star and Snowflake schema using dimensional modeling to extract data from various source tables.
Created PL/SQL packages, procedures, cursors and exception handling.
Loading data from flat files into the database tables using SQL*Loader.
Tuned SQL and application and added Indexes as required for performance and involved in testing through test scripts
and test plans.
Oracle capacity planning and data analysis for warehouse setup of the schema.
Extracted data from excel sheets and other resources to convert data into the SQL tables.
Data Purge and data duplication removal of millions of data and keeping log track development of Cursor, Types.
Hands on experience usage of Collections, BULK Binds (Bulk Collects and FORALL) for SELECT, INSERTs, UPDATEs, and
DELETEs and Partitioning tables (Range/List), Joins and extensive experience with Aggregate and Analytical Functions.
Tools:
SQL Developer, UNIX Script, Visual Studio, SQL * Loader, Sub-Version Control TFS, EDI, Jenkins, Appwit, AWR, Real Time
Monitoring.
Verizon Corporate office Tampa, Florida 11/2019 to 02/2020
PL/SQL Developer
Description:
Working as a part of Oracle Development/DBA team (3GIS, ArcGIS, Migration).Query Optimization and Performance, DB
Trigger generation, Duplication or Repetition, Cursors, indexes, Bulk Process and duplicate data was the primary role.
Tracking and monitoring of slow queries, table partitions, table clustering, data pump and generation of explain plan,
execution plan and also Monitory of queries using Query monitoring tools AWR, ASH, ADDM.
Data migration using informatica for different feeds.
Tools:
SQL Developer, Unix Script, Visual Studio, SQL * Loader, Sub-Version Control Git, Reporting tools as AWR, Real Time
Monitoring and Enterprise manager.
J&K State Property, LHR 03/2007 to 10/2014
Computer Programmer (Oracle Developer PL/SQL)
Description:
Over 7 years of programming experience as a PL/SQL Developer in Analysis, Design and Implementation of Business
Applications using (RDBMS). Involved in all phases of the SDLC (Software Development Life Cycle) from analysis,
design, development, testing and implementation.
Experience with DFD, Data dictionary, Database normalization, ERP and design techniques.
Create Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based) Developed Complex database objects like
Stored Procedures, Functions. Good knowledge on logical and physical Data Modeling using normalizing techniques.
Technical and analytical skills with clear understanding of design goals of ERmodeling for OLTP and dimension
modeling for OLAP.
Better communication, interpersonal, analytical skills and ability to perform as part of a team.
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.
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 the data from staging area to data mart.
Created scripts to create new tables, views, queries for new enhancement in the
application using TOAD.
Involved in data loading and calling UNIX scripts to download and manipulate files. Performed SQL and PL/SQL tuning
and applications tuning using various tools like EXPLAIN PLAN and AUTOTRACE.
Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
GCG Gojra 03/2001 to 02/2007
COMPUTER Engineer
Description:
Designed classes on Computer fundamentals and basic database concepts for
college level students.
Developed activities and integrated technology to diversify instruction.
Developed small computer programs to work with students and increase interest
in higher learning in computer sciences.
Education:
Master of Science |Computer Science University Of Agriculture, FSD, Pak. 1997-2000
Bachelor of Science |Science University Of The Punjab, LHR, Pak. 1994-1997
Websites, Portfolios:
https://LINKEDIN LINK AVAILABLE
|
