Developer Sql
Resume:
Rizwan Mohammed, Programmer Analyst
**** ****** ******** ** #**-107 940-***-****(M) *********@*****.**.**
PROFESSIONAL SUMMARY
. More than 6 years of IT experience with strong business and technical
skills.
. Experience in creating data dictionary, tables, packages, stored
procedures, advanced queries, triggers, views, indexes and functions
for databases.
. Extensively worked on PL/SQL Object Types, Dynamic SQL, Collections,
Autonomous transaction, Compound triggers, Materialized Views and
Table Partitioning.
. Excellent communication skills and have experience working with people
from different nationalities and cultures.
. Best authority, establish relationship and maintain stakeholder's
Communications at the different levels.
. Extensively worked with collections to reduce the overhead and improve
the performance using bulk collect and bulk bind. Also handled
exceptions in collections using Save Exception and %BULK_EXCEPTIONS
for bulk operations.
. Experienced with DBA activities like creating users, granting and
revoking privileges on database objects.
. Experience with Oracle Forms and reports.
EDUCATION
Master of Science in Computer Science and engineering, University of North
Texas Aug'08-May'11
Bachelor of Science in Computer Science and engineering, KLU, India
Jun'05-Apr'09
TECHNICAL SKILLS
Databases Oracle 11g/10g/9i, MYSQL, DB2, MS ACCESS, SAAS, Teradata,
Netezza.
Languages SQL, PL/SQL, C, C++, Java, .net, JCL, COBOL, FORTRAN, PERL,
Java, XML, HTML, PHP, UNIX shell scripting
Operating Systems UNIX, LINUX, Windows 7/XP/2000/98/95, MAC
OS X, Sun Solaris.
Tools TOAD, SQL Developer, SQL*Plus, SQL*Loader, PL/SQL Developer,
Putty, WINSCP, Oracle Forms & Reports 10g
PROFESSIONAL EXPERIENCE
DISH NETWORK, Denver, CO
Dec' 13 - Present
Senior Analyst and Developer
. Worked with different teams for gathering requirements for projects,
create TRD's for other developers and testers.
. Provide on call support if necessary to resolve prod broke issues
which would result in revenue loss for the company or the partners of
the company.
. Create and maintain database objects to satisfy the ever changing
business need and to make sure their performance is optimal.
. Implemented multithreading to bring down their processing time for
processes which have been performing for several hours.
. Perform data analysis for prod broke issues and data analytics to
provide new business solutions which would benefit the company.
. Maintain and perform minor tweaks in the front end ORACLE ADF code
when necessary.
. Develop reports to monitor the databases and send out an alert to the
developers and dbas when necessary.
. Worked on the database upgrade project from 10g to 11g and played a
crucial role for my team with the R12 upgrade.
. Experience with creating shell scripts for scheduling through autosys.
Xavient Information Systems, Denver, CO
Jun' 11 - Nov' 13
Programmer Analyst
. Worked with the Business analysts for gathering requirements and
business analysis.
. Involved in meetings with end users on enhancement issues for
gathering the requirements, documenting and communicating the same to
development teams.
. Developed packages, procedures, functions to maintain the customers,
equipment record information.
. Developed packages for logging the flow in other packages using
pragma autonomous
. Testing of production fixes in the test environments to ensure they
have resolved given issue as well as ensure production fixes do not
cause other issues.
. Providing on call support for production issues and coming up with
solution when needed.
. Effective exception handling by creating user defined errors using
pragma exception_init and raise_application_error for the ease of
debugging and displaying the error messages.
. Manage open issues queue on an hourly basis and resolving the issues
before SLA.
. Extensively used Version management tools like Serena while deploying
scripts into production
. Involved in code reviews and performed unit/end to end testing on the
developed modules and documenting the test cases.
. Performed end to end flow using the front end apps used in the
organization and debugged business implementation issues which has
provided me with knowledge on SOA model.
. Good Experience with SQL loader, Imports & UTL files based on file
formats using KORN shell jobs.
. Developed the UNIX scripts using KORN shell to automate jobs.
. Resolved mutating table errors using the new functionality in Oracle
11g through Compound triggers
. Worked on data warehouse projects for data analysis and research.
. Monitor operational environment to ensure internal and customer
Service Level Agreements are meet.
. Patient dealing with demanding users coming from different cultures
and countries.
Environment: Oracle 11g, SQL, PL/SQL, SQL Developer 3.0, UNIX, Serena,
Putty, WINSCP, Sun Solaris.
INSIGHT, Dallas, TX
May'10- Apr'11
INTERN
. Generated DDL queries for creation of new database objects like
tables, views, sequences, functions, synonyms, indexes, roles, and
granting privileges.
. Created stored procedures, packages, functions to maintain the
subscription plans of the customers.
. Created Function based indexes and Bit Mapped Indexes to minimize
query time and achieve better performance.
. Developed UNIX shell scripts to manage batch order processing and
scheduled them using Crontab.
. Created views pointing to different databases to get the data from
interface modules.
. Created indexes for avoiding full table scans and disks sorts, and
improved the performance and tuned the oracle queries.
. Created triggers to apply complex business logic and for auditing.
. Optimized critical queries to eliminate full table scans using explain
plan, TKPROF.
. For Optimization Process actively involved in creating views,
materialized views, partitioning tables and creating indexes etc.
. Created SQL Loader scripts and External tables to load the data from
flat files and validated the data with PL/SQL procedures.
. Developed user interface screens using Oracle Forms.
. Involved in code reviews and performed unit/end to end testing,
developed test suites on the developed modules and documenting the
test cases.
Environment: Oracle 10g, SQL, PL/SQL, TOAD, SQL Developer 1.5.3, UNIX shell
scripts, Oracle Forms 10g, UNIX
. UNT
Jan'10-Apr'10
Teaching Assistant
. Worked as a teaching assistant for Object Oriented Programming at the
College of Business Administration.
. Worked under various professors helping them grade papers, filling up
for them when needed.
. Helping students with their projects and helping them understand the
course work.
INFOSYS - Mysore, India
Jan'2008 - April'2009
Oracle PL/SQL Developer
Responsibilities
. Worked with Business Users to gather requirements for developing new
Reports and also Changes in the existing Reports.
. Designed and developed Reports according to user specification. Used
advanced SQL like analytical functions, aggregate functions for
mathematical and statistical calculations.
. Extensively Involved in Performance tuning and Optimization of the SQL
queries.
. Wrote Stored Procedures, Functions, Packages and triggers using PL/SQL
to implement business rules and processes and also performed code
debugging using TOAD.
. Created Shell scripts to access and setup runtime environment, and to
run Oracle Stored Procedures, Packages
. Designed processes to extract, transform, and load data to the Data
Mart. And extensively used SQL*LOADER method to load data from flat
files.
. Designed and developed Reports according to user specification. Used
advanced SQL like analytical functions, aggregate functions for
mathematical and statistical calculations.
. Optimized SQL used in Reports and Files to improve performance to
higher extent.
. Extensively used IMPORT utility to load the exported files.
. Automating data loading, extraction, report generation using UNIX
shell scripting.
. Responsible for the production issues and bug fixing.[pic]
Contact this candidate