OBJECTIVE

To become a strategist who helps business grow exponentially streamlining the processes and systems using years of functional and technical experience in several industries. To be part of a result-oriented and challenging work environment where I can teach and learn at the same time contributing towards the success of employer and myself.

SUMMARY

Seasoned professional with around sixteen (16) years of experience and have been responsible for design, development and implementation of software applications using Oracle Database, Oracle Developer tools and Sun Solaris. Experience with data migration, SQL, Advance PL/SQL, Oracle Developer6i / 8i/ 9i / 10g / 11g, stored procedure and triggers, packages, Import/ Export Utility, SQL*Loader, Very good understanding of Business Process / System Analysis/Design, Data Modeling.

Experienced in customized application development using Advance PL/SQL APIs.

Experienced in data migration using SQL * Loader and external table.

Strong hands on Oracle Forms and Oracle Reports & PLSQL.

Experienced in Object Groups, Property Class, LOVs using OO techniques and template base programming.

Experienced in complex reports using Oracle Report Writer 6i, 9i, 10g, 11i.

Worked with Business Managers/Analysts and developers to correlate business logic, requirement specifications.

Delivered optimum benefits and has full life cycle implementation exposure: Business Requirements Definition, Modeling, Logical Database Design, Mapping, Data Conversion, Validation, Testing, Documentation, Production Migration, Post Implementation Support, Assessments, Enhancement and Refinements.

Experience in Client/Server development using different databases like MS Access 7.0/2000 and Oracle 9i, 8i / 8.x / 7.x on Windows and UNIX platforms.

Various projects analysis and designing in Manufacture, Pharmaceuticals, Health & Entertainment Industries.

Hands on experience in all aspects of System Development Life Cycle (SDLC).

Strong analytical, problem-solving, organizational, communication, learning and team skills.

Excellent interpersonal skills, motivated, energetic team player with demonstrated proficiency for learning new tools and business environment with excellent communication and analytical skills.

Experience in maintaining existing Java soap web services and Restful service API’s. Also experienced with designing reports in core Java. Knowledge of JSP and able to understand and debug J2EE applications.

Able to manage changing responsibilities and deliver time critical projects on schedule.

Migration/upgrading of Oracle8i database to Oracle9i database & from Oracle 9i to Oracle 10g.

Proven ability to accept challenges and produce results in a multitask environment.

Some experience with Crystal Reports.

Exposure to Informatica Power Center & MicroStrategy & Oracle DRM.

TECHNICAL SKILLS

Languages: Oracle Forms & Reports, Oracle Designer, SQL & PLSQL, Java, XML, HTML

ETL Tool: Informatica 6.x.

Reporting Tool: Crystal Reports.

Scripting languages: Korn, C shell programming.

Operating System: Windows, Sun Solaris UNIX.

Commercial packages: Oracle Developer Suite, SQL Loader.

Database Oracle 6/7/8i/9i/10g/11g, MYSQL & MS Access 97/2000.

Modeling Tools Visio, ERWIN

Internet Tools JDBC ODBC, IIS, Apache Tomcat, WebSphere 5.0, Eclipse

Methodologies Object Oriented, Structured, Waterfall, Agile

Other Utilities & Tools TOAD, MYSQL

Version Control PVCS, Subversion & SourceSafe

EMPLOYMENT HISTORY

Sr. Oracle Developer

ESPN Inc. (Full Time) March 2006 today

Responsibilities / Accomplishments

Bass Fishing Project

oPre-existing system was mostly manually entered data in production database.

oConduct data model reviews with Manager.

oCreate data objects (DDL).

oEnforce standards and best practices around data modeling efforts.

oLead project to analyze, design, and develop, Implement Event Registration System. Later Bass requested to do the same for their Athlete Profile and Registration System. This system was done in Oracle Forms, Reports & PL/SQL.

oDesigned multiple Oracle reports for registration systems and athlete profile data.

X Games Project

oAfter successfully deployment of Bass System. Manager requested to take a lead and incorporate X Games Event and Athletes Registrations System under same screens and separated by roles so Bass only see Bass data and X Games users only see X Games data. This development was also done in Oracle Forms, Reports & PL/SQL.

oResponsible to import data from SQL Server to Oracle for X Games Payments.

oDesigned Screen in Oracle Forms for athlete’s payment system that allow accounts department to modify payments and issue manual checks and generate some Oracle Reports for them as per their need.

Re-Architect Event and Athletes Registration System

oInteract with 3rd party vendor to fulfill their UI analysis needs.

oLead team to re-architect Event & Athletes Registration Schema and setup roles for end users which includes data modeling using ERWIN.

oConduct data modeling reviews with team members.

oGenerated SQL Scripts and created data objects (DDL).

oLead team and myself extensively involved in writing SQL & PL/SQL code to transform data from old schema to new schema.

oWorked with end-user to identify mandatory and nice to have reports which reduced from 180 to 100 reports and re-write 100 reports for new schema.

oHelped team to test third party vendor UI and worked on Java after they delivered incomplete project and made system stabilized and delivered to end-user, that include debug SOAP services

oMaintain existing web services developed in Java. Debug code to find issue and provide solutions to the issue and fix issue when needed and test service to verify results.

Migrated whole Events Database Schema, Oracle Forms & Reports from 9i to 10g and later from 10g to 11g. Find and fixed invalid objects and test all types of scripts and worked with end user to test their applications.

Outsourced Event & Athletes Registration to New Vendor.

oWorked with vendor to provide all UI information’s and business logics.

oHave vendor transferred data in JSON format wrapped around XML via Web Services to ESPN on each action.

oAtomized process of receiving data and updating tables by extracting data from Web Services and insert into Event Schema Tables.

Actively provided onsite and offsite support to each events (Bass / X Games).

Responsible to optimized preexisting queries and write optimized queries. Performed cost base optimization techniques.

BottomLine Project (Bottom ticker on all ESPN Channels)

oResponsible to setup new networks for BottomLine Project to show their data as per their requirement, such as ESPN Brazil, ESPN Argentina, ESPN Australia.

oResponsible to maintain over 4 schemas that mainly includes Packages (Procedure/Functions) for automated scores/messages, manual scores/messages, graphics and networks.

oCreated XML from data and extract data from XML.

oPerformed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

oExtensively involved in using HINTS to direct the optimizer to choose an optimum query execution plan.

oInteract with offshore staff (Bangalore, India) to discuss issues and worked together to resolved issues.

oResponsible to create project executables file of BottomLine project and deploy code in DEV and QA environment.

oWorked with system support team to deploy BottomLine project to production.

oTesting / Re-testing new code and write bugs in Jira application.

oHelped other teams in different groups on their Forms and Reports projects that includes designing screens and reports, writing queries, triggers, functions and procedures.

Technologies: Oracle Forms 9i & 10g, Reports 9i & 10g, PLSQL, PLSQL Developer, Java, PVCS, Oracle database 9i, 10g, 11g, Java, Citrix, Windows, UNIX, ERWIN, ER Studio, Visio, HP Quality Center, JIRA System, Parasoft SOATest, Tortoise SVN, Sourcesafe

Oracle Programmer/Analyst September 2004 to July 2005

System Research Automation Inc., Mississauga, ON, Canada

Responsibilities / Accomplishments

Wrote Procedures, Functions and SQL Loader scripts.

Designed and developed the high-level system specifications as team effort. Also designed and developed the high level and low-level functional specifications.

Involved in Analysis, design and Development of the System

Performed SQL tuning and optimization on views and queries generated by reporting front-end packages and developers.

Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system.

Accurately code and unit test each modification by meeting System Requirements.

Worked with team members to share functional and technical knowledge.

Provide timely status feedback to the team leads and manager.

Database application development; created tables, relationships, queries, forms and reports.

Modified the database structure and updated database based on user requirements.

Writing and debugging triggers and stored procedures and database functions.

Production support of Oracle applications.

Heavy interaction with users, make them understand the use standard reports. Trying to keep changes to minimum.

Technologies: Oracle tools (Forms, Reports and PL/SQL), Oracle database (8i & 9i), UNIX (shell scripting)

Oracle ETL Developer / Java Developer June 2003 to August 2004

BSmart Technology Inc., Woodbridge, ON, Canada

Responsibilities / Accomplishments

Involved in developing Logical and Physical Data Models using ERWIN.

Interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements.

Involved in creation and maintenance of Repositories, Folders, Users and Groups.

Worked extensively with Lookup, Router, Aggregator, Expression, Joiner and Filters etc.

Configured source, targets, mappings and workflows.

Created Mapplets transformations.

Developed 100s of complex stored procedures using advance PL/SQL.

Fine-tuned and improved the performance of mappings.

Created Partitions and Indexes on tables for faster execution of queries and improving performance.

Developed data base triggers for data validations.

Loaded client data from ASCII files using SQL*Loader.

Involved in writing queries in MySQL for Java project.

Developed some reports in core Java for Java Team and in Crystal Reports for BI Team.

Technologies: Informatica Power Center 6.x, Oracle 9i, PL/SQL, Java, MySQL, Crystal Reports, Windows 2000/XP, TOAD, ERWIN

Oracle Developer Consultant January 2001 to May 2003

System Research Automation Inc., Mississauga, ON, Canada

Responsibilities / Accomplishments

Involved in Analysis, Design and Development, Testing, Maintenance and resolved problems during implementation.

Involved in designing the requirement document using Erwin & Visio.

Worked on Food Processing System and Misc. Items Procurement System.

Modules Includes Order Entry, Raw/Packaging Materials & Misc. Items Procurement System, Store Inventory Control System.

Produced various reports as per the requests of the other departments using Oracle Reports.

Tuning SQL queries in order to increase the performance related issues of the existing database packages & functions.

Assist in migration of database from Oracle 8i to Oracle 9i.

Technologies: Oracle Developer Suite, Oracle 8i, SQL, PLSQL, Oracle Utilities, Windows

Oracle Developer/DBA January 1997 to August 2000

Knoll Pharmaceuticals Ltd., Karachi, Pakistan

Responsibilities / Accomplishments

Involve in Analysis, Design, Development, Testing, Implementation and Maintenance after implementation or Material Resource Planning System (MRP).

Designed conceptual data model based on the requirements, interacted with non-technical end user to understand the business logic.

Modeled the logical and physical diagram for the MRP project.

Discussed data model, data flow with development team members.

Modules include

oMaterial Planning for Planning Department.

oLocal Procurement System.

oImport Procurement and Tracking System.

oInventory Control System.

oQuality Control & Assurance System

oProduction Control System.

oDistribution System.

All systems are integrated with each other and are automated.

Designed, Developed, Implemented some Finance Department Systems:

oPurchase Analysis System (Integrated with MRP System)

oMaterial Valuation System (Integrated with MRP System)

oWork in Progress (WIP) System (Integrated with MRP System)

oPrepaid & Deposit System.

Developed Engineering Spares Inventory Control System.

Wrote PL/SQL Procedures, Stored Procedure, Functions, Packages, Libraries and Custom Views.

Technologies: Tools used ORACLE 8,8i, SQL Navigator, SQLPlus, SQL, PLSQL, Designer 2k, Developer 2k, Reports 2k, ERWIN and Visio. Windows NT/Server 2000, Novell Netware 3.5, 4.01, 5.

Programmer Analyst February 1994 to December 1996

Computer Services Consultant, Karachi, Pakistan

Responsibilities / Accomplishments

Worked for Gatron Industries Ltd. (Manufacturing Silk Threads).

Analyzed, Designed, Developed, Implemented of following Systems:

oOrder Entry System.

oProcurement System (Local & Imported Items).

oStore Inventory System.

oProduction Control System

oPayroll System and integrated with already designed Personal Information System.

oDesigned some MIS reports as per special instructions of Company Directors that allow the Directors to keep track of each department performance and Production Loss.

Worked on Procedures, Functions, Form and Reports.

Migrated data from FOXPRO based Time Management System to Oracle Database using SQL*Loader.

Technologies: Tools used ORACLE 6/7, SQL*Plus, SQL, PLSQL, SQL*Loader, Visio, FOXPRO, UNIX

Programmer June 1992 to January 1994

The Computer Wizard, Karachi, Pakistan

Responsibilities / Accomplishments

Personnel Information System and Time Management System (TMS) developed for this company. Those comprehensive systems are versatile systems and are integrated with each other and TMS have capability to integrate with any payroll system and can be installed in any company with some required modifications. Wrote Procedures and Functions using PLSQL.

Technologies:

Tools used ORACLE 6, ORACLE Forms & Reports, SQL*Plus, SQL, PLSQL, UNIX

EDUCATION

B.S., Computer Science

Bachelors in Computer Science from University of Karachi, Pakistan. Passed 1997.

PROFESSIONAL COURSES

Advance Oracle Form & Reports

Advance PL/SQL

Java /J2EE

COBOL

Contact this candidate