Project Oracle
Resume:
WAJAHAT SHEIKH
********@*****.***
Accomplished Senior Software Developer/Lead with 12 years of experience in
Information Technology.
Extensive experience in web development and database management.
Technical Skills
Programming JAVA,PL/SQL,ASP3.0/2.0,C,C++,CFML,COM/DCOM,DHTML,HTML,
Languages AJAX,XML, JavaScript, PERL, RPG, VB Script, Visual
Basic 5.0/6.0.
Databases / DB Oracle 10g/9i/8i,Toad 9/8/7,SqlPlus 9/8,Sqlloader
Tools 9,Discoverer,Oracle BI, SQL programmer,SQL
Developer,SQL Server 2000/7,OEM,Work bench,Avaya.
Desktop Tools:
Network Software
/ Communications:
Testing Tools:
Utilities /
Command
Languages:
Methodologies GUI Design, UML, Object Oriented Analysis,
Productivity Management.
IDE My Eclipse 5.5, Net beans, Cold fusion
MX/5.0/4/0,FrontPage 98, Rational Rose, Visual
InterDev 6.0, Homesite.
Operating AS/400, Windows XP/ NT/ 2000, UNIX, VI, Humming bird,
Systems/Tools reflection, putty.
Other Personal Web Server, Apache, IIS,Tomcat 5.5.9,Web
Logic 7/8,CVS, Source Forge, SVN, Verity K2, JMP
7.0,LDAP,Spectra.
PRofessional Experience
Forma Therapeutics / NEUROGEN CORP, 07/07 - present
branford,ct
Technical Lead/Senior Software Developer
IT and Informatics: Networks, Servers, Desktops/Laptops, Software
Evaluation
Setup 40 plus lab and user workstations on a Windows network.
Provided support for all computing hardware and software resources of an
entire company site.
Evaluated discovery informatics software systems (LIMS, ELN) and
supported LIMS system for deployment.
Developed protocols using Accelrys Pipeline Pilot.
Generated SDfile in Java using Chemaxon API.
Installed, configured and supported Chemaxon IJC.
Database management: Oracle database design/modeling, PL/SQL procedures,
performance tuning, OEM monitoring, migration of databases
Installed, configured and administered all corporate R&D databases as
primary DBA of the company.
Performed SQL tuning using TKPROF and EXPLAIN PLAN; improved SQL
response time from 30 minutes to a few seconds.
Created domain specific views and materialized views using complex SQL
joins to improve the reporting functionality.
Monitored Oracle databases to identify performance bottlenecks.
Application development: Web, Client-Server, and Multi-Tier Software
Development
Designed, developed, deployed, and maintained several scientific
applications; applications were either web based or thick client,
written in various languages (Java/J2EE, JavaScript, C#) with Oracle
back-end databases (database design, PL/SQL development)
Developed rulesets Java web application to calculate the UV purity of
samples using LCMS detectors. Integrated the application with LIMS.
IPT, Hartford,ct 07/06 - 07/07
Senior Database Developer/ DBA
Implemented ADS/ODS approach to build a data mart using Dimensional
modeling.
Created materialized views with complex SQL and tuned materialized views
using bitmaps Indexes, hints, range partitioning. Replicated data on a
daily basis. Configured Oracle Discoverer to view the portlets.
Developed a scorecard application using PL/SQL procedure. Implemented
Oracle CUBES/ROLLUPS for groupings to update the columns of a scorecard
table with data flowing from several hundred tables in ORACLE.
Migration of data from Informix (Avaya) to Oracle.
Performance Tuning of SQL using Explain Plans, Data pump
export/import, schemas, and tablespaces.
Developed Java based web application in JSP, AJAX, CSS and Oracle to
check the performance of service providers for scheduled maintenance and
reactive service requests at client locations for Blockbuster,
Exxon-Mobil, Office-Max. Designed reports to identify the areas for
assessment and capture data for service providers.
Pfizer, Inc,GROTON,CT 01/01 - 07/06
Senior Software Developer/Technical Lead
Architected and developed Bio-patent BLAST tool resulting in over $60K
annual savings via process automation.
Integral member of an intranet design/development team. Performed Web
Application Development (developed web pages in JSP, Cold fusion,
Spectra, Perl,.Net/ASP, Controller/Model in J2EE),
Database Design/Development (PL/SQL Packages, Procedures, Triggers,
Materialized views, Oracle Text Indexes, DbLinks), Database Tuning
(SQL), Data Migration (Exports, Imports), Schema, etc.
Addressed and resolved numerous technical issues and managed ongoing
system support. Worked closely with users from various global locations
to conceptualize, design, and launch intranet sites furthering Client
goals.
GDRS: Designed and developed Document Delivery System in J2EE using
Model view Controller with Oracle as a backend. Web Application resolves
citations at an article level. The unresolved citations are sent to the
document delivery staff for processing.
Oracle PL/SQL Development - Designed and developed PL/SQL
Packages/Procedures/Triggers
Sequences/Indexes/Views/Functions/Database Links/Oracle Jobs.
Java Development - Designed MVC Patterns, developed Model, Beans in
J2EE,Views in JSP's
Http Tags to call external Web Sites to parse XML data, Oreilly File
Uploading, Taglibs, Beans,
Pfizer Production Information: Pfizer Product Information database (PPI)
is a proprietary database that tracks all global PGRD published pipeline
product literature. PPI provides published product literature coverage
on Pfizer pharmaceutical products. PPI is a Web Application with a
Search and Maintenance Module.
Oracle PL/SQL Development - Designed and developed PL/SQL
Packages/Procedures/Triggers/
Sequences/Indexes/Views/Functions/Database Links/Oracle Jobs/Oracle Text
Indexes/
Database SQL Tuning using Explain Plans/Materialized Views/Schema
Creation in Dev, data
migration from Dev to Test.
Java Development - Developed Advanced Searching Tool in JSP and Oracle.
Search Log for Information Management - Developed Search log for
Information Management (SLIM) using Java Server Pages and Oracle. The
Site allows Colleagues to Log their Requests / View Old Requests/ Search
Requests/ Run Reports.
Oracle Development - Designed and Developed various Database Objects.
Java Development - Designed Web Pages in JSP's, JSP Smart File Upload,
NTLM, and Beans...
Gadgets Development for Portal - Designed and developed Web Services in
Cold Fusion, Active Server Pages (ASP), .NET and Java Server Pages
(JSP) .Created Journal/ eResources gadgets which queries Voyager to
display catalog data in electronic and print format.
Installation and Migration of Oracle - Installed Oracle 9I on a Test
Server and migrated the whole database from Oracle 8I to the new Oracle
9i Test server.
Installation: Installed Oracle 9i on Windows System, Created Table
Spaces/Schemas/ Roles
Exported Data dump using Export Utility and then imported whole data
into the database.
Patent Blast System - Designed and Developed the Bio Informatics
Customized Search Tool in Perl / Cold fusion which Searches WU-Blast and
NCBI Database Sequences. In Addition to Searching, various result
formats and reports are available as part of the Search results. The
Tool saved 90% of the time taken to Search and Collect different parts
of Information.
Installation and Configuration of Production Server - Installed Spectra
1.0/1.1/1.5,ColdFusion 4.5 sp2, Verity 97 on a Windows NT Production
Server, Configured all the datasources, Virtual Directories and created
Verity Collections.
Information Management Site - Designed and developed the Content
Management Web Site to allow Content Managers to create web pages on the
fly and publish data on a regular basis in order to keep the site
dynamic and allow for fairly easy modification of the interface (i.e.
order of information). Included Verity and Meta Data Searching as part
of the Site.
Phone Book - Re-designed and developed the Phone Book for Pfizer's
Groton location.
Migration - Migrated various databases from Microsoft Access to Oracle
8i.
I INTELIANT (QuiNCy,MA) 04/00 - 01/01
Web Developer/Analyst
F Fao Schwarz
F FAO.com is an online Toy store. Application provides an Interface
to shop by the category, brand, and
Boutique. The advanced search feature allows a customer to find the
perfect toy from FAO Schwarz.
This search feature enables you to create more specific searches than
are possible with a keyword search.
Point Of View
Developed ZebraLoan.com, which is a service that provides customers an
interface to apply for a mortgage loan, get pre-approved, and/or receive
up to four competitive offers simultaneously. The application was sent
to up to 16 mortgage professionals in the applicant's area who were
required to respond within 24 hours with competitive offers and terms.
The system narrowed down the offers to four competitive bids that the
customer was able to review, thus enabling him/her to decide which
offer, company, and broker met his/her needs. The customers could login
and check the status/progress of the loan. This information was updated
by the mortgage professional selected by the customer, so everybody
involved was able to see what was being done to get the customer to the
closing table on time.
Argusoft (For The Government Of 08/98 -04/00
Gujarat),INDIA
Web Developer/Analyst
Developed a web application (www.gujaratindia.com) which allows users to
browse, search, and view resolutions from the Government of Gujarat. The
resolutions (from 1965 to present) were being incorporated into the
application, and it provided a method for continual maintenance of the
Government Resolutions (GRs). A bilingual option allowed users to browse
the GRs either in English or in Gujarati. Each user can maintain his/her
own personal list of favorites (labeled with comments) and can add
remarks/annotate any of the GRs according to his/her requirements. The
project involved designing and implementing the following modules:
Main GR Display: On main page of GRBook all departments, divisions and
branches were displayed in treeview, which was simulated using
JavaScript. Physical indexes were created in table to improve database
efficiency.
Search module: Search tool is user friendly and provided facility to
search on GR number, department, division, remarks, description, and the
like. Search result was cached to improve performance and was displayed
in next "n" format.
Roles:
Involved in the database design in Microsoft SQL Server-6.5
Designed, coded, and implemented search module using ASP.
Client Company Name MM/YY - MM/YY
CLIENT INDUSTRY TYPE
KEANE ROLE
PROJECT DESCRIPTION SUMMARY
. LIST PERSONAL ACCOMPLISHMENTS & METRICS
ENVIRONMEN STATE ALL TOOLS, TECHNOLOGIES AND METHODOLOGIES USED ON
T: THE PROJECT "SEPARATE ALL WITH COMMAS"
Client Company Name MM/YY - MM/YY
CLIENT INDUSTRY TYPE
KEANE ROLE
PROJECT DESCRIPTION SUMMARY
. LIST PERSONAL ACCOMPLISHMENTS & METRICS
ENVIRONMEN STATE ALL TOOLS, TECHNOLOGIES AND METHODOLOGIES USED ON
T: THE PROJECT "SEPARATE ALL WITH COMMAS"
Client Company Name MM/YY - MM/YY
CLIENT INDUSTRY TYPE
KEANE ROLE
PROJECT DESCRIPTION SUMMARY
. LIST PERSONAL ACCOMPLISHMENTS & METRICS
ENVIRONMEN STATE ALL TOOLS, TECHNOLOGIES AND METHODOLOGIES USED ON
T: THE PROJECT "SEPARATE ALL WITH COMMAS"
Company Name MM/YY - MM/YY
INDUSTRY TYPE
POSITION TITLE
JOB DESCRIPTION SUMMARY
. LIST PERSONAL ACCOMPLISHMENTS & METRICS
ENVIRONMEN STATE ALL TOOLS, TECHNOLOGIES AND METHODOLOGIES USED ON
T: THE PROJECT "SEPARATE ALL WITH COMMAS"
Company Name MM/YY - MM/YY
INDUSTRY TYPE
POSITION TITLE
JOB DESCRIPTION SUMMARY
. LIST PERSONAL ACCOMPLISHMENTS & METRICS
ENVIRONMEN STATE ALL TOOLS, TECHNOLOGIES AND METHODOLOGIES USED ON
T: THE PROJECT "SEPARATE ALL WITH COMMAS"
Company Name MM/YY - MM/YY
INDUSTRY TYPE
POSITION TITLE
JOB DESCRIPTION SUMMARY
. LIST PERSONAL ACCOMPLISHMENTS & METRICS
ENVIRONMEN STATE ALL TOOLS, TECHNOLOGIES AND METHODOLOGIES USED ON
T: THE PROJECT "SEPARATE ALL WITH COMMAS"
Company Name MM/YY - MM/YY
INDUSTRY TYPE
POSITION TITLE
JOB DESCRIPTION SUMMARY
. LIST PERSONAL ACCOMPLISHMENTS & METRICS
ENVIRONMEN STATE ALL TOOLS, TECHNOLOGIES AND METHODOLOGIES USED ON
T: THE PROJECT "SEPARATE ALL WITH COMMAS"
Company Name MM/YY - MM/YY
INDUSTRY TYPE
POSITION TITLE
JOB DESCRIPTION SUMMARY
. LIST PERSONAL ACCOMPLISHMENTS & METRICS
ENVIRONMEN STATE ALL TOOLS, TECHNOLOGIES AND METHODOLOGIES USED ON
T: THE PROJECT "SEPARATE ALL WITH COMMAS"
Company Name MM/YY - MM/YY
INDUSTRY TYPE
POSITION TITLE
JOB DESCRIPTION SUMMARY
. LIST PERSONAL ACCOMPLISHMENTS & METRICS
ENVIRONMEN STATE ALL TOOLS, TECHNOLOGIES AND METHODOLOGIES USED ON
T: THE PROJECT "SEPARATE ALL WITH COMMAS"
Company Name MM/YY - MM/YY
INDUSTRY TYPE
POSITION TITLE
JOB DESCRIPTION SUMMARY
. LIST PERSONAL ACCOMPLISHMENTS & METRICS
ENVIRONMEN STATE ALL TOOLS, TECHNOLOGIES AND METHODOLOGIES USED ON
T: THE PROJECT "SEPARATE ALL WITH COMMAS"
Company Name MM/YY - MM/YY
INDUSTRY TYPE
POSITION TITLE
JOB DESCRIPTION SUMMARY
. LIST PERSONAL ACCOMPLISHMENTS & METRICS
ENVIRONMEN STATE ALL TOOLS, TECHNOLOGIES AND METHODOLOGIES USED ON
T: THE PROJECT "SEPARATE ALL WITH COMMAS"
Company Name MM/YY - MM/YY
INDUSTRY TYPE
POSITION TITLE
JOB DESCRIPTION SUMMARY
. LIST PERSONAL ACCOMPLISHMENTS & METRICS
ENVIRONMEN STATE ALL TOOLS, TECHNOLOGIES AND METHODOLOGIES USED ON
T: THE PROJECT "SEPARATE ALL WITH COMMAS"
Company Name MM/YY - MM/YY
INDUSTRY TYPE
POSITION TITLE
JOB DESCRIPTION SUMMARY
. LIST PERSONAL ACCOMPLISHMENTS & METRICS
ENVIRONMEN STATE ALL TOOLS, TECHNOLOGIES AND METHODOLOGIES USED ON
T: THE PROJECT "SEPARATE ALL WITH COMMAS"
CERTIFICATIONS / LICENSES
Name Of Certification Name Of Certification Name Of Certification
INITIALS INITIALS INITIALS
mm/yy mm/yy mm/yy
Publications / Presentations / Industry Awards
Award Name Or Award Name Or Award Name Or
Presentation Title Presentation Title Presentation Title
Organization Or Organization Or Organization Or
Publication Name Publication Name Publication Name
mm/yy mm/yy mm/yy
Professional Affiliations
Professional Professional Professional
Organization Name Organization Name Organization Name
(Initials) (Initials) (Initials)
Government Security Clearance
Security Clearance Type
(Initials)
Education B.E (computer engineering), Regional Engineering
College (NIT), India, 1998
MBA, University of Connecticut, 2010-2012
Employment status US Citizen
Contact this candidate