Resume of Mohammed Shakir To receive an Email of this resume: Enter your Email Address: Text Word Doc. Add to Clipboard Add to My Resume Bank View in Microsoft Word Go Back Oracle DBA, C++, JAVA, DB Tuning,ASP.NET Quickfind: 489377 Date Submitted: 2003-03-07 06:48:35 Name: Email: Skill Words: Min. Salary: Residence: Work Locations: Mohammed Shakir mshakir@comcast.net Oracle DBA, C++/JAVA, ASP.NET East Brunswick NJ New York New Jersey Home Phone: Cell Phone: Experience: Work Type: Will Relocate: Work Status: 732-672-0464 732-672-0464 5+ Years Contract or Full Time No US Citizen Senior Oracle Developer/DBA, C++, JAVA, ASP.NET, ADO.NET, C#, Viual Basic, JSP, Servlets programmer/Analyst. Over 22 years USA experience. Hands on Project Management, back-end software development, Oracle Database Analysis, Large Scale DB Design, administration, DB optimization. Identify and fix System performance bottlenecks. Data-warehouse design, OLAP, Solaris/UNIX/Windows NT/2000 system and network administration. Systems Analysis, Software Development(full SDLC), and Integration of client/server and web based applications back-end/Server in C, C++, C#, ASP.NET, SQL, PL/SQL, triggers, stored procedures, PRO*C, FORMS 4.5, VISUAL C++, APACHE/TOMCAT- Jakarta/JServ, JDK 1.3, XML, ORACLE, SQL Server 2000, INFORMIX, POET ODBMS, POET Object Factory(Object- Relational), Oracle Object-Oriented DB, , OCCI, Database Template Library (DTL), UML, Rational Rose, Data Modeling, Oracle Designer and ERwin, Crystal Reports, TUXEDO on Solaris, SunOS, NT/2000, AIX and VAX/VMS platforms.. Built systems end-to-end and provided production support. Developed information systems for data-warehousing, graphic data analysis and reporting. Logical and physical database modeling, installation, setup and maintenance (24x7) of ORACLE databases, X-based OpenWindows Application Porting and Integration. Provide Object-SQL mapping and data conversion. Setup and Maintenance of TCP/IP based Local and Wide Area Networks for database and files access. Installation and Setting up of Oracle financial 11i on NT/2000. US Citizen. Excellent interpersonal, communication and analytical skills. Competent, highly dependable and reliable, motivated, dedicated, committed for excellence, hard-working team player, customer oriented and gets the job done on time and within budget. AREAS OF EXPERTISE Hardware/OS: SUN Ultra SPARC Enterprise Server 4500, DEC/ALPHA, IBM, AT&T, NCR, PYRAMID, Windows 98/NT/2000, AIX, SUN Solaris 2.x, SunOS 4.1.x, UNIX SVR4, Windows 98/NT/2000, VAX/VMS, OS/2 Software: Object Oriented/C++, C, VISUAL/C++, JAVA, Servlets, JSP,ORACLE 9i, 8i, INFORMIX, SQL Server, POET Object DB, ORACLE JDeveloper, Pro*C, PL/SQL, SQL, KSH, DEVELOPER/2000, DESIGNER/2000, ERWIN, INFORMIX/ESQL-C, IFS, OpenWindows, X-Windows, PVCS, StarTeam, SUBLIME, Make, Borland C++/Windows, MS/WORD, MS/EXCEL, MS/Project, MS/ACCESS, POWER BUILDER, IBM VISUAL AGE C++ Compiler,. POET ODBMS, POET Object Factory, SQL Server, Lotus notes EXPERIENCE August 2002 Standard and Poor’s, Manhattan, NY To Present CONSULTANT(Database and System Optimization) Analyzed and optimized Trade Credit Service system Queries, Schema and Oracle database. System based on Solaris 2.8, Oracle 8i, JAVA 2 SDK, JSP, servlets and IPlanet Web Server. System web and transaction based to provide business credit rating information to large clients. Optimization based on response time analysis, system and waits states analysis and ratio based analysis. Real time and static database monitoring to identify system bottlenecks. Also used Oracle tools like statspack, home grown DB monitoring scripts and scripts available on web. Used Visio Enterprise Architect, Erwin, and Power Designer 7.0 for logical DB design and Reverse Engineering. May 2002 Rudolph Technologies, Inc., Flanders, New Jersey, USA To August 2002 CONSULTANT Develop Web Services to distribute data in XML format from a central Oracle database repository to applications running on several different machines Develop back-end SQL Scripts using Visual Studio.Net, Visual Basic and C# with Oracle and SQL Server 2000 as backend databases.. Develop SQL Scripts to process data in Oracle Database and create classes to support Web Services(ASP.NET) and XML data. Develop one class that would serve one hundred tables. August 2001 Standard and Poor’s, Manhattan, NY To Present CONSULTANT(Application & Database Optimization and Data Warehouse/OLAP Design) Identify and analyze ORACLE database performance problems, contentions and optimize the SES web based applications and 107 Gigs Oracle database (8i) on Sun Ultra SPARC 4500 with 12 CPUs. Run performance diagnostic scripts dynamically and find bottlenecks in real time. Bring down process execution time from 58 hours to 26 hours. Re-write PL/SQL code to store and retrieve data. Remove SQL code outside the loop, to minimize SQL execution. Optimize queries using HINTS, explain plans, Trace and Tkprof. Modify Oracle parameters, re-size redo logs and rollback segments. Analyze and add histograms to get best execution plans. Rewrite and replace procedures to shorten process time. Partition and distribute tables to reduce disk contentions. Add parallelism to shorten processing time taken during indexe builds, selects and inserts records into tables. Monitor system and session events waits dynamically to identify performance problems. Write PL/SQL procedures to add new features to reduce processing. Procedures based on PL/SQL tables and Dynamic SQL Use SQL*Navigator to program and manage SQL and PL/SQL code. Database Analyst to support Data warehouse project using OLAP services. Extract, Transform and Load (ETL) Financial Services Unified Billing, Accounting and Information System data to Oracle 8i database. Design data warehouse based on Star Schema, Fact and dimensional tables, and materialized views. Develop code for building database, ETL, reporting and publishing for the web. Evaluate OLAP tools like Hyperion , SQL Server 2000 OLAP services, Oracle Business Intelligence Beans and 9i Jdeveloper . Investigate Oracle 9i OLAP feature and test them for feasibility using Jdeveloper and Business Intelligence Beans. Jan 2000 Rudolph Technologies, Inc., Flanders, New Jersey, USA To July 2001 CONSULTANT Analyzed and optimized Oracle database and applications, SQL queries. Modify C++ programs to add new queries that are dynamically generated using C++ templates and RogueWave Object Oriented C++ framework. Add Stored Procedures and updated C++ programs to use new stored procedures. Modify database parameters, indexes and queries to provide quickest interactive response. Created scripts to analyze the database and query performance. Run explain plan, trace and tkprof utilities to analyze the queries. Used Oracle 8i on Windows NT and Oracle 7.3 on OS/2. Extensive use of Oracle Enterprise Manager for DBA work. Used Object Oriented Programming in C++ for database migration software. ER diagram from Oracle Designer to ERwin. Using ERwin created scripts to change client databases to reflect changes in schema and releases. Export/Import Oracle Designer Repository. Reverse engineer database schema and create ER diagram in Oracle Designer 6. Optimize Oracle 8i(8.1.7) on Windows NT/2000. Prototyped Database Layer(back-end) using VISUAL/C++, Database Template Library, POET ODBMS and POET Object Factory, ORACLE 8i, SQL Server, and UML. Setup Oracle 8i(8.0.5-8.1.7) on Windows 98, NT and Windows 2000 platforms. Used Oracle Enterprise Manager. Evaluation of Object Oriented Databases like Poet, Objectivity/DB, ObjectStore, ITASCA, Matisse, for incorporating them into complex C++ Object oriented based applications. Review features, white papers, code, and company profiles to find a package that minimize coding, mapping and serialization. Looked for a ODBMS package that is a true object database, supported ODMG specs, and code stayed portable to other object database. Analysis of Oracle Object paradigm and convert Relational Schema to schemas based on Oracle Object types, Object tables and Object views. Evaluation of Oracle C++ Call Interface(OCCI) to create a DB layer to connect object oriented C++ applications to Oracle Object Database. Used Oracle Designer to automate schema and object types, tables and views creation. Created Object views to get data from Oracle relational tables. Converted Velocis/Raima network model based very complex database schema to Oracle relational based Schema using Oracle/Designer 6 for Data Modeling. Oct 1999 Neuman Distributors, NJ, USA To Nov 1999 CONSULTANT Modified and added forms, triggers and PL./SQL procedures based on Oracle Developer/2000 for a Contract Management System Application. Analyzed the forms, triggers and PL/SQL to find the software faults and fixed them. Added triggers and PL/SQL procedures to add new features like updating tables that were not part of the current blocks and forms. As part of DBA work, Coded PL/SQL scripts to remove old records from multiple tables and added PL/SQL scripts to update records not handled by the FORMS applications. Used Oracle database on AIX/UNIX. Optimized all the queries used in the applications. June 1999 Industrial Bank Of Japan, New York, NY, USA to October 1999 CONSULTANT/Software Development/Oracle DBA As Compaq/Digital Consultant provided Oracle Pro*C/C++ programming services for developing new applications for database warehouse, and financial applications for the Bank. Worked on applications involving Foreign Exchange and stock options.. Most of the emphasis was on SQL code to process data from different tables and load them into new tables. Generated data files for external systems. Software development on VAX/Alpha/VMS and Windows/NT with Oracle 8.x. Created tables, indexes and sized them for 70+ Gigabytes database. As part of the DBA work, provided database analysis for indexes, tablespaces, database sizing for all the applications (at least 10), created tables, indexes, constraints, and analyzed and fixed SQL code to improve performance using explain plan tables. Estimated number of records, calculated records size for each table for ten applications, indexes, temp spaces etc. Used Erwin to confirm the Excel based manual calculations. Used Crystal Reports. 1981 AT&T/Lucent Technologies/Bell Laboratories, New Jersey, USA to May 1999 CONSULTANT/CONTRACTOR/Out-Sourcing Database Analysis, Data Warehousing, Design and Database Administration Researched to develop an Internet based financial product based on Oracle JDeveloper, Oracle(Web) Application Server (OAS) and Oracle 8i and SQL Server. Set up the development environment based on JAVA/JDeveloper and Oracle (Web) Application Server and developed test applications. Software development on Windows NT and Sun Ultra SPARC/Solaris 2.6. Tested programs to work using cartridges and CORBA. Setup Oracle environment on Windows NT and Solaris 2.1.6 Performed logical and physical database modeling and the design and administration of several large relational databases (6 Gigabytes to 40 Gigabytes) based on ORACLE (version 7.3.x) and UNIX in a Client/Server environment. Setup, upgraded and maintained application databases and ORACLE. Applications based in a Local and Wide Area network environment. Responsibilities included performance monitoring and tuning. Also developed SQL scripts for database loading, accessing data for applications, database backup and recovery. Used SUN 4/670, SPARC 1000 and Pyramid hardware. Developed the core databases located on several Pyramids and Sun Servers spread throughout the country. This database allowed network engineers, planners and management to monitor equipment inventory, network traffic usage, forecast for buying new equipment, customer usage patterns, equipment loads, and potential network troubles in SUN/Open-Windows Graphic environment. The project saved the company several millions of dollars a year and it provided better service to customers. Used Ervin for Re-Engineering and DB maintenance. **** ADDITIONAL NOTES **** I work hard to please the clients, meet more than their expectations, and clients like the work I do and therefore, my contracts last longer than they were intiated. About Net-Temps | Privacy Statement | Terms of Use | Advertising | Contact Us | © Copyright 1995-2003, Net-Temps, Inc. All Rights Reserved. Net-Temps ® is a registered trademark.