Resume

Sign in

Oracle pl/sql developer

Location:
Dallas, TX, 75243
Posted:
February 19, 2015

Contact this candidate

Resume:

Imtiyaz Ahmed

SUMMARY

Over **+ years of hands on experience working with Oracle 10g/9i, Unix

Shell Scripting, Reports 6i, PL/SQL, tuning, Data modeling, and expert in

writing UNIX Shell Programming on Oracle Database running on UNIX

environment.

. Extensive experience in analysis, design, development, testing and

implementation as Oracle PL/SQL and Forms/Reports Developer.

. Worked on client-server application development using Oracle 11g, 10g,

9i, 8i, PL/SQL.

. Expertise in Writing SQL Queries and Optimizing SQL Queries.

. Excellent understanding of the Oracle Architecture

. Relational database schema, Functional dependencies, Normalization of

tables (2NF, 3NF).

. Extensive experience in building Client Server Applications using Oracle,

PL/SQL, Stored Procedures, Packages and Database Triggers working with

partitions, creating, modifying and sizing database objects.

. Involved in Installation of Informatica PowerCenter 6.2.

. Used various levels of triggers and procedures to validate the data at

each level.

. Good hands on experience in writing various UNIX shell scripts.

. Experience in UNIX administration, Shell scripts, Crontab.

. Experienced working on data modeling, requirement collection and business

process mapping.

. Proficient in legacy data conversions and interface development using

SQL, PL/SQL, UNIX, TOAD, SQL Developer, Pl/Sql Developer and SQL*Loader.

. Created logical and physical relational data models (using PowerDesigner

8) for all new and modified processes, from start to finish.

. Experienced in developing batch programs by using PL/SQL and shell

scripts.

. Conversion of data into XML using SQL Prompt as per client's requirement.

. Designed ETL process using Informatica Tool to load from Sources to

Targets through data transformation.

. Experience in SQL query, PL/SQL package, function, stored procedure,

triggers to implement business logics of oracle database

. Widely used Oracle Enterprise Manager (OEM) for administering databases.

. Performance tuning by resolving users issues and problems, monitoring

production database by using SQL*Plus and performed refinement of the

database design leading to significant improvement in system response

time and efficiency using EXPLAIN PLAN and TKPROF.

. Resolved stored procedure conflicts between PowerBuilder 9.0 and Oracle

9i client software. Documented the solutions, and communicated them to

DBA and development groups to reduce impact on development schedules.

. Deep rooted concepts in Data Extraction, Transformation and Loading from

databases, flat files and XML files.

. Experienced in DBA concepts like Creating Indexes, Tables and database

physical extensively used Erwin for data modeling and Dimensional Data

Modeling by ERWIN.

. Developed and customized reports in applications using Oracle reports 6i.

. Extensively worked on Oracle partitioning to improve the performance.

. Created and managed database object like tables, views, sequences,

synonym, index, trigger, user, roles, DB link and Materialize view (M-

view).

. Experience in full Software Development Life Cycle (SDLC) i.e.

requirements analysis, detailed design, development, unit testing and

integration.

. Highly motivated & conceptually strong individual with outstanding oral

and excellent communication, analytical and interpersonal skills.

TECHNICAL SUMMARY

Languages SQL, PL/SQL, Unix-shell scripting.

Database Tools Oracle SQL*Plus, SQL*Loader, SQL Navigator, Toad, Oracle

Designer, Power Builder, SQL Developer, Pl/Sql Developer

Data Modeling Erwin 3.5.2, MS Visio.

RDBMS Servers Oracle10g/9i/8i, MS Access, MS SQL Server 2000

GUI Tools Oracle Forms 3.0, 4.5, 6i, Apex 3.0, 3.2, Oracle Reports

6i.

ETL Tools Informatica Power Center.

Operating UNIX (Solaris 8/2.x, Red Hat Linux 7.x/6.x), Windows NT.

Systems

EDUCATION

Bachelor of Science in Computer Science (BCS)

PROFFESIONAL EXPERIENCE

Oracle Developer

ETCC Richardson, TX

Jul 13 - Present

Roles and Responsibilities:

. Developed procedure for the conversion of data into XML using SQL Prompt,

Oracle utilities as per client's requirement.

. Created and managed database object like tables, views, sequences,

synonym, index, trigger, user, roles, DB link and Materialize view (M-

view).

. Working on troubleshooting defects, Query optimization in timely manner.

. Create Cron job for schedule the tasks

. Developed triggers, Indexes, PL/SQL packages, procedures, functions,

using SQL Developer, Pl/Sql Developer Tools. Generated server side PL/SQL

scripts for data manipulation and validation of data for remote

instances.

. Involved in creating UNIX shell Scripting. Defragmentation of tables,

partitioning, compressing and indexes for improved performance and

efficiency. Involved in table redesigning with implementation of

Partitions Table to make Database Faster and easier to maintain.

. Experience in database Application Development, Query Optimization,

Performance Tuning and DBA solutions and implementation experience in

complete System Development Life Cycle.

. Create DB Link

. Participated in change and code reviews to understand the testing needs

of the change components.

. Extracted data from the XML file and loaded it into the database.

. Good team player

. Have strong analytical skills including troubleshooting.

Environment: SQL Developer, Pl/Sql Developer, Toad, JAVA, Oracle

10g/11g, PL/SQL, SQL*LOADER, SQL PLUS, HTML, XML, UNIX shell

scripting,

Oracle Developer

MachB, Irving TX

Oct 12 - Jul 13

Roles and 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.

. Created management analysis reporting sing Parallel Queries, Java stored

procedure, HTP Package and WEB.SHOW_DOCUMENT. Participated in change and

code reviews to understand the testing needs of the change components.

Working on troubleshooting defects in timely manner.

. Involved in creating UNIX shell Scripting. Defragmentation of tables,

partitioning, compressing and indexes for improved performance and

efficiency. Involved in table redesigning with implementation of

Partitions Table and Partition Indexes to make Database Faster and easier

to maintain.

. Experience in database Application Development, Query Optimization,

Performance Tuning and DBA solutions and implementation experience in

complete System Development Life Cycle.

. Used SQL Server tools to build high performance data integration

solutions, including extraction, transformation and load packages for

data warehousing. Extracted data from the XML file and loaded it into the

database.

. Designed and developed Oracle forms & reports

. Have strong analytical skills including troubleshooting.

Environment: JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER, SQL PLUS, HTML,

XML, HP-UNIX shell scripting, SQL Developer, Pl/Sql Developer,

Toad

Oracle Developer

Blueciate Inc. Dallas TX

Aug 11 - Oct 12

Roles and 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.

. Participated in change and code reviews to understand the testing needs

of the change components. Working on troubleshooting defects in timely

manner.

. Involved in creating UNIX shell Scripting. Defragmentation of tables,

partitioning, compressing and indexes for improved performance and

efficiency. Involved in table redesigning with implementation of

Partitions Table and Partition Indexes to make Database Faster and easier

to maintain.

. Experience in database Application Development, Query Optimization,

Performance Tuning and DBA solutions and implementation experience in

complete System Development Life Cycle.

. Used SQL Server tools to build high performance data integration

solutions, including extraction, transformation and load packages for

data warehousing. Extracted data from the XML file and loaded it into the

database.

. Designed and developed Oracle forms & reports generated up to 60 reports.

. Performed modifications on existing form as per change request and

maintained it.

. Used Crystal Reports to tracked logins, mouse over, click-through,

session durations and demographical comparisons with SQL database of

customer information.

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

facilities every day. Used standard packages like UTL_FILE, DMBS_SQL,

PL/SQL Collections and used BULK Binding involved in writing database

procedures, functions and packages for Front End Module.

. 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.

. 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, SQL*LOADER, Oracle

Streams 10g (Replication), SQL PLUS, HTML, SQL Server 2008,

TOAD, XML, HP-UNIX shell scripting.

Oracle Developer

KIA Inc. Richardson, TX

Mar 09 - Aug 11

Roles and Responsibilities:

. Participated in gathering the user requirements and involved in writing

technical design documents.

. Proactively monitor, diagnose and rectify database-related issues.

. Responsible for definition and management of schemas and objects and

monitoring, tuning and troubleshooting of Oracle databases.

. Responsible for coding stored procedures, functions and triggers and

other scripts based on functionality of the domain and as per business

requirements using PL/SQL.

. Designed and developed various types of Reports as per the requirements.

. Developed and customized reports in applications using Oracle reports 6i.

. Designed, developed and tested Applications using Apex 3.2 and 4.0

. Run batch jobs for loading database tables from flat files using

SQL*Loader.

. Create database links between production databases.

. Resolved stored procedure conflicts between Power Builder 9.0 and Oracle

9i client software. Documented the solutions, and communicated them to

DBA and development groups to reduce impact on development schedules.

. Create extensions using Oracle recommended frameworks. Report against

Applications data model.

. Designed ETL process using Informatica Tool to load from Sources to

Targets through data Transformations.

. Used SQL Server for data integration solutions, including extraction,

transformation and load packages for data warehousing. Extracted data

from the XML file and loaded it into the oracle database.

. Involved in Migration of tables and indexes to different table spaces.

. Extensively involved in Fine-tuning the Informatica Code (mapping and

sessions), Stored Procedures, SQL to obtain optimal performance and

throughput.

. Experience in writing UNIX shell scripts (Wrapper scripts) to automate

batch jobs and Oracle Backups to store in the appropriate tables using

PL/SQL and Shell Scripts.

. Wrote Test scripts for Unit, involved in System, and Integration testing.

. Created logical and physical relational data models (using PowerDesigner

8) for all new and modified processes, from start to finish.

. Refresh development and test database with data from the production

databases.

Environment: Oracle 9i/10g/11g, SQL, PL/SQL, TOAD, Power Builder, SQL

Loader, Reports 6i, Informatica Power Center, SQL Server 2008, MS Visio,

Erwin, UNIX Shell Scripts, Windows NT, UNIX.

Oracle PL/SQL Developer

WellPoint Inc. North Haven, CT.

Jan 08 - Mar 09

Roles and Responsibilities:

. Analyses and discuss the business requirements with the clients.

. Responsible for the development, implementation and support of the

database of the server.

. Managed a team of 2 personnel for the development of the database,

procedures, functions, etc

. Optimized and modified the triggers, complex store functions, procedures,

user base data type etc.

. Responsible for the dealing with the problems, bug fixing and

troubleshooting

. Designed and created an interface between custom application and

accounting application, Summit.

. Mentored junior programmers in Oracle database design and development

. Upgraded 6i client server Oracle Forms and Reports application to web

based 10g and ran the application through Oracle Portal and Single Sign-

on.

. Assisted in setting up the Forms and Reports Services on standalone 10g

App Server.

. Wrote Advanced Queuing database package to send messages to clients based

on events.

. Lead the upgrade process of Oracle Forms and Reports 6i to 10g including

the setup of the 10g Oracle Development environment

. Assisted in setting up the Forms and Reports Services on standalone 10g

App Server.

. Member of the team that setup the project standards for development.

. Used Designer for design and database object generation.

. Coded and implemented PL/SQL packages to perform Application Security and

batch job scheduling.

. Designed and developed Web-enabled Oracle Forms & Reports. Including

Forms based on stored procedures

. Generated Oracle Forms and database objects through Designer.

. Wrote PL/SQL packages to calculate Missing Information and Determining

Eligibility in the processing of a Medical/Health Families Application.

. Created Oracle Reports with Java Barcodes.

. Assisted in setting up the Forms and Reports Services on 9iAS.

. Documented business rules, functional and technical designs, test cases,

and user guides

Environment: Oracle 9i/10g SQL, PL/SQL, Forms 9i, Reports 9i,

SQL*Loader, SQL Navigator, Crystal Reports, TOAD.

Oracle PL/SQL Developer

Citi Group Inc., New York, NY Apr

07 - Dec 07

Citibank Financial Data Warehouse (FDW) is a reporting system built to

support financial analysis and strategic decision-making process. Various

reports including custom built management reports and global performance

reports are generated from this system

Roles and Responsibilities:

. Developed Server side PL/SQL scripts for data manipulation and validation

and materialized views for remote instances.

. Created management analysis reporting sing Parallel Queries, Java stored

procedure, HTP Package and WEB.SHOW_DOCUMENT. Participated in change and

code reviews to understand the testing needs of the change components.

Working on troubleshooting defects in timely manner.

. Involved in creating UNIX shell Scripting. Defragmentation of tables,

partitioning, compressing and indexes for improved performance and

efficiency. Involved in table redesigning with implementation of

Partitions Table and Partition Indexes to make Database Faster and easier

to maintain.

. Experience in database Application Development, Query Optimization,

Performance Tuning and DBA solutions and implementation experience in

complete System Development Life Cycle.

. Used SQL Server SSIS tool to build high performance data integration

solutions, including extraction, transformation and load packages for

data warehousing. Extracted data from the XML file and loaded it into the

database.

. Used SQL Server SSIS tool to build high performance data integration

solutions, including extraction, transformation and load packages for

data warehousing. Extracted data from the XML file and loaded it into the

database.

. Designed and developed Oracle forms & reports generated up to 60 reports.

. Performed modifications on existing form as per change request and

maintained it.

. Used Crystal Reports to tracked logins, mouseovers, click-through,

session durations and demographical comparisons with SQL database of

customer information.

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

facilities every day. Used standard packages like UTL_FILE, DMBS_SQL, and

PL/SQL Collections and used BULK Binding involved in writing database

procedures, functions and packages for Front End Module.

. 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.

. 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: Oracle 10g, PL/SQL, ER-WIN, Toad.

Oracle PL/SQL Developer

Berger Paints Limited, Karachi Jun

01 - Mar 07

Roles and Responsibilities:

. Written PL/SQL Stored Procedures, Packages to implement Business Rules.

. Designed and created application using Apex 3.0

. Built complex queries using SQL.

. Extensively used dynamic SQL

. Created indexes for faster access the tables which was helpful for

performance tuning

. Created various views for better performance of the database.

. Debugged the Procedures, Views Enabling/Disabling & altering them as

required as per site requirements.

. Used explain plan to increase the performance of SQL statements.

. Was responsible for tuning the procedures for better performance.

. Modified SQL statements to increase the overall performance as a part of

performance tuning.

. Used PL/SQL developer tool as a front end to the database.

. Used SQL*Loader to load bulk utilities(subscriptions) used for moving

data from external files into the Oracle database

. Worked on UNIX for permissions and wrote server startup scripts to

production and development servers.

. Developed UNIX kern shell scripts.

. Designed, Developed and implement the Inventory Control Software for

Container Production Department.

. Participated in the detailed requirement analysis for the design of data

marts and schemas.

. Upgrade branch system and Accounts Receivable software application.

. Integrate Account Receivable System with Financial Accounting System.

. Integrate Cash Management System.

. Developed Reports for Management reviews.

. Forecast System Module for Production System by comparing the sales

volume of each quarter.

. Responsible for user maintenance and security parameters.

. Developed various crystal reports.

. Implement the ETL process to load the Products Data Mart, which helped

generate Business Intelligence and Performance Management reports

. Extracted Source Data using Informatica tools and Stored procedures from

Source Systems.

. Load data into Oracle tables using Database Links, and Oracle

Heterogeneous services.

. Participate in data sourcing, extract data investigation process, and

work with team to develop PL/SQL code to extract, clean and sort data.

. Created Scripts to Load data from External systems to oracle Database.

. Experience in writing UNIX shell scripts (Wrapper scripts) to automate

batch jobs and Oracle Backups to store in the appropriate tables using

PL/SQL and Shell Scripts.

. Involved in Migration of tables and indexes to different table spaces.

Environment: Oracle 10g, Unix, Forms, Report Writer, PL/Sql, SQL,,

SQL*Plus, MS Excel, MS Access, Informatica Power Center, Crystal Reports

7.0, SCO Open

Server.[pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic]



Contact this candidate