TOUQEER SYED
SACRAMENTO, CA
TEL. [Send email to request phone number] 12-8372
TOUQEER_US@YAHOO.COM
EDUCATION /
CERTIFICATION
Osmania University Hyderabad, INDIA
Master of Computer Applications (M.C.A)
B.Com (Computer Science)
PROFESSIONAL
SUMMARY
TECHNICAL
SUMMARY
Over 10 years of industrial experience using Oracle RDBMS as Sr. Analyst /
Developer.
Strong in Oracle Developer (Forms 10g/9i/6i, Reports 10g/9i/6i and PL/SQL
Using Designer10g/9i/2000), Oracle Portal 9i, Oracle9IAS and Oracle Database,
workflow, Oracle eBusiness suite and Application Server Administration.
Knowledge of Financials 11i (GL, AP AND AR)
Extensively involved in SQL Tuning to enhance the performance of the complex
queries for Management Reports and other business logic.
Experience in Tuning SQL statements using Explain Plan, SQL TKPROF, Hints
Working knowledge of UNIX shell scripting and many other regular DBA
activities.
Working experience in RS6000/SP2, Sun E4500, HP9000 and Windows XP/NT/2000
environments.
Working experience in J2EE (JAVA2) using JDeveloper 10g/9i, PL/SQL, Triggers,
Packages, Standalone Procedures/Functions, SQL*Plus, SQLDBA/SVRMGR/EM, TKPROF
utilities, Oracle Designer object libraries and Application 11i Object Library.
UNIX Shell Scripting, JAVA2, PERL and Exposure to Installation of 9IAS and
Apps 11i Admin.
DBA Tools: OEM 9.0.1,Quest Toad v7.5, Visual Source save, Spotlight on Oracle,
SQLab Vision, Quest Schema Manager
Familiars with Oracle Financials Oracle Receivables (AR),
Oracle Payables (AP), General Ledger (GL), Sourcing, FSG reporting,
Application Object Library (AOL), Technical Design and Documentation etc.
2+years experience with data warehousing (design, ETL, testing, BI and
deployment)
Languages: C, C++, JAVA2, XML, SQL, PL/SQL, Pro * C, COBOL, PASCAL, Visual
Basic.
RDBMS: ORACLE 10g/9i/8i/8.0/7.X/6, Oracle Applications (11.x and R12)
Operating Systems/Tools: SUN SOLARIS E 4500, RS6000/SP2, HP9000, WINDOWS
NT/2000, Application Object Library, SQL-STATION, Developer Suite 10g,
DEVELOPER/2000,9IAS, FORMS 10g/9i/6i, REPORTS 10g/9i/6i SQL*PLUS, PL/SQL,
SQL*LOADER, CASE TOOLS, DESIGNER10g/9i, ORACLE ENTERPRISE MANAGER (OEM).
TestDirector 8.0, UNIX, LINUX and, XML Publisher.
Version Control & Migration Tool: Oracle Designer, Rational ClearCase, PVCS,
Win CVS
EXPERIENCE
AUG 2005
Till Date
APR 2004
AUG 2005
MAR 2002
APR 2004
MAR 2001
MAR 2002
JAN 2000
MAR 2001
NOV 1998
JAN 2000
NOV 1997
NOV 1998
DEC 1996
AUG 1997
JUN 1993
NOV 1996
State Compensation Insurance Fund (San Francisco,CA)
Senior Programmer/Analyst
Project Description: The Electronic Claims File (ECF) Project for SCIF vendors.
Claim Transfer, Legal No, Policies Assignment, Letter Generation, UR referrals
and Balance Modules
Responsibilities:
GUI Conversion & Web-based Application Development:
Developed / enhanced new/existing forms for ease of maintenance.
Created several PL/SQL packages and subprograms
Performed logical database design using Oracle Designer 9i/10g.
Designed form modules, program units and triggers using Oracle Designer
9i/10g.
Modified existing Forms, Reports & Menus using Oracle Designer9i/10g.
Converted Forms and Reports from old versions 4.5 to new GUI Version 9i.
Rewrote Pro*COBOL Reports to Oracle Discoverer10g Reports.
Involved in writing the backend code in JAVA2 (J2EE) to convert .PDF files to
.JPG and stored in the specified directory using jDeveloper 10g.
Created and modified PL/SQL packages and subprograms (Procedures and
functions).
Created shell scripting.
Customize Forms for Printing Checks for SCIF vendors in Oracle Apps (AP
module).
Debug existing JAVA classes. Provided technical assistance to our group.
Interacted with the end users.
Configured and designed Entity Relationship Diagram (ERD) to illustrate the
logical structure of database.
Designed database tables using various normalization techniques and database
rules.
Developed and tested of SQL, PL/SQL code in database triggers, Stored
Procedures functions and Packages as per requirement.
Developed a test Plan development for the system.
Environment: Designer 9i/10g, PL/SQL, TOAD, Forms, JAVA2, Oracle 10g, Discoverer
reports, Oracle Apps 11i, jDeveloper 10g.
Harley-Davidson Financial Services, Inc. (Carson City,NV)
Senior Programmer/ Jr. DBA
Project Description: Harley-Davidson Credit Financial Services modules.
Enhance and maintenance of Daybreak System.
Responsibilities:
Responsible for Design and developed Credit Financial Services module.
Developed Oracle Stored procedures, functions and Database Triggers.
Front End Screens Developed by using Oracle Designer 9i,
Wrote several stored packages to fulfill business logic did application
Tuning, and Database Administration work.
The HDFS is using the Daybreak system this system it built on Oracle
technology. Create Technical Design Documentation
(Backup, export Import, SQL Loader, RMAN, Normalization).
Environment: Sun Solaris, HP-UX, Windows 2000, Rational Rose, OLTP, Developer
6i/9i, Designer 9i, Pro*C, PL/SQL, JAVA2, ETL, Oracle Database 9i/8i, Oracle9IAS
CELERA DIAGNOSTICS (Applied Bio Systems), CA
Sr. Developer/Analyst
Project Description: Celera pharmaceutical research Reagent LIMS Modules.
Responsibilities:
Laboratory information management systems (LIMS). Large DB > 1 TByte.
Responsible for Design and Development and implementation of a REAGENT LIMS
System Using Developer 9i/6i (Forms 9i/6i and Reports 9i/6i) Middle Tier 9IAS,
Oracle 9i Portal and Backend as Oracle 8i Database. Recently we moved Backend to
9i Database.
Developed Clinical LIMS system front-end by using Developer 9i using Designer
9i (Forms and reports).
Wrote several Procedures, functions, packages and database triggers. Installed
& managed Oracle 9IAS on Windows 2000.
Environment: IBM, AIX, Developer9i/6i (Forms 9i/6i, and Reports 9i/6i), Windows
2000, Oracle Database 8i/9i, PL/SQL, JAVA2 Swings, Perl, JSP (Java Server Pages,
Developer 9i, OLAP servers, Oracle 9IAS.
Accenture (Anderson Consulting), San Francisco, CA
Sr. Analyst/Developer
Project Description: Accenture in-house projects enhancement and support.
Responsibilities:
Provided 2nd level ORACLE support on GL, PO, AP, and FA modules.
Created FUNCTIONAL SPECIFICATIONS for new or updated reports and acted as a
liaison between users and developers.
Performed QUALITY ASSURANCE on various development projects in which our group
would eventually provide 2nd level support on.
Included on new development projects from start to finish with deliverables
and deadlines.
Professional training included: SQL, Actuate, and Oracle Assets. Informal
training on: Flash, HTML, and Visual Basic.
Performed SQL back-end queries on ORACLE databases
Integral team member on complex projects lasting more than 1 year
Environment: SunSparc, Linux, Developer 6i, Cognos, Embarcadero ER Studio,
Designer/2000 Windows 2000,Oracle9IAS with Oracle8i, Visio, TOAD, Visual Basic,
JAVA2, PERL
Pacific Bell Internet Services (SBC), San Francisco, CA
Senior Developer / Analyst
Project Description: SBC is a parent company of Pacific Bell.
Developed the Front End and support Backend to support there customers UI
interface modules.
Responsibilities:
Developed Several Forms and Reports using Oracle Designer.
Created several stored Procedures, Functions and Packages.
Technical Guidance to the Application Team for SQL optimization and Stored
Procedures for complex tasks.
Developed Data Warehouse Reporting System for SBC Corporation.
Involved in supporting a data warehouse that exceeds one terabyte when all
tables, indexes, and OLAP cubes are included.
Environment: Vantive 8.0, Oracle 8.2, SQL Loader, Visual Basic, PL/SQL, Java2,
Sun Solaris2.4/8, Developer 6i (Forms 6i, and Reports 6i), Windows 2000 And SQR
Reports
Novartis Pharmaceuticals Corporation (East Hanover, New Jersey)
DBA/Developer
Project Description: In-house projects to support Novartis Customer.
Responsibilities:
ORACLE 7.3 Database Administration
Developed several Forms and Reports for Product tracking Information module
using developer/2000 (Forms 5.0 and Report 3.0)
Database Tuning, Backup and Recovery strategies
Estimation of storage and SGA size
Technical Guidance to the Application Team for SQL tuning and
Crystal reports
Creation of users, database objects as per the Requirement.
Enforcement of security, integrity constraints etc
Unix Shell Scripts for automatic backup to a disk.
Troubleshooting Database and application Problems.
Environment: HP-UX, Windows NT, Developer / 2000(Forms 4.5, and Reports 2.5),
Pro*C, PL/SQL
Arkansas Department of Human Services
P Programmer Analyst
Project Description: CHRIS System tracks child abuse investigations foster care
placements modules.
Responsibilities:
CHRIS System tracks child abuse investigations foster care placements. CHRIS
is a client server system with nearly 1,200 users.
Responsible for using DEVELOPER/2000, REPORTS 2.5 and MSACCESS.
Mapped and converted data from the States old Legacy System (used for
tracking Child Abuse and Neglect Cases as well as Foster Care and Placement) to
their new CHRIS system.
Developed custom reports using REPORTS 2.5
Developed custom forms using FORMS 4.5 for a support help desk system.
Wrote UNIX Shell scripts (Korn, C and Bourne) to read and execute the
necessary Commands.
Environment: ORACLE DEVELOPER/2000, Forms 4.5 / Reports 2.5, Pro*C, PL/SQL,
UNIX, WINDOWS 3.11, NOVELL Client Server, IBM MAINFRAME, HP9000
Sintech Power Systems Pvt.Ltd. India
Programmer Analyst
Project Description: Purchase and Sales Order Processing system enhancement and
maintenance projects.
Responsibilities:
Project objective was to build a Purchase and Sales Order Processing system
for Sintech.
Total 28 data entry forms and 25 reports are generated using Developer /2000.
Responsible for designing screen using Oracle Forms (4.5) and
Generated reports using Reports (2.5). The design of classes in these
extensions was done using Object Modeling Techniques (OMT).
Environment: HP9000, HP-UX, Windows NT, Developer / 2000(Forms 4.5, and Reports
2.5), Pro*C, PL/SQL
Electronics Corporation of India Ltd.
Programmer Analyst
Project Description: Implementation of the Financial Management System
Responsibilities:
Involved in the migration and implementation of the Financial Management
System for Electronics Corporation of India Ltd.
The system was upgraded from Oracle 6.0 to Oracle 7.0 (Forms 3.0 to 4.5,
Reports 1.1 to 2.5). Involved creating/modification of table structures,
modification of data and generating exception reports.
Also involved in the testing the Receivable system and generated several new
reports on users request.
Environment: RS6000, UNIX/AIX, C, Oracle 7 Developer/2000(Forms 4.5/Reports 2.5)
Oracle 6(Forms 3.0/Reports 1/1)
|
