Objective:

• Seeking a challenging position where I can utilize my experience and strong problem-solving abilities in Application Development / Database Architecture Design/ Redesign / Data Security / Migrations / Business Intelligence / Data Warehouse and System Architecture Implementations as a Subject Matter Expert.

Summary:

• Over sixteen (16+) years of IT experience in Application Development, Database Administration, Data Security, Metadata,Database Physical / Logical Design and Modeling based on Enterprise Wide Application Software Development Lifecycle. OLTP and OLAP databaseArchitecture and Application Design with emphasis on Data Normalization andQuery Optimization, Star and Snow Flake Schema setup for Data Warehouse applications using Oracle 11g, 10g, 9i and 8i databases.
• Lead several database migrations / integrations during Cingular / AT&T acquisitions of other cellular companies. Experience in providing Tier III support to users and data integrity teams for bulk data manipulations. Acted as Scrum master using Scrum (Agile Technology) concepts for timely implementation of projects and resource utilization.
• Hands on Expert in PL/SQL programming using stored procedures, functions, packages for Oracle Forms, Reports and Discoverer. Data migration Expert using Customized PL/SQL code and Oracle Warehouse Builder (OWB) to establish data quality and customized source to target mappings in various Oracle database versions for EarthLink’s MetaSolv Telecom application, AT&T SIMS application and FDLE’s (Florida Department of Law Enforcement) legacy fingerprint data.
• Excellent People Skills to communicate with all levels of stake holders in an organization to present mutually agreeable software solutionswhich are not only user friendly but also cost effective and forward compliant with reference to latest software and database technologies.
• Expert in Vendor negotiations. As Oracle License Manager, saved GE Power Systems over 18 Million USD by determining the best applications for the enterprise and aggregated all the database and application licenses for different sub organizations into one corporate deal.
• Extensiveexperience in Database Administration / Query Optimization of Oracle 11g/10g/9i/8i/8.x/7.x in UNIX, Linux and Windows environments.
• Experienced in Sybase, DB2 and MS SQL Server connectivity interfacing Oracle Database usingOracle Transparent Gateways.
• Experience in Oracle DatabaseInstallation, Creation, Tuning, Testing, Partition, Backup, and Migration.DatabasePerformance monitoring, Troubleshooting and Recovery in Dev, Test andProduction for UNIX, Linux and Windows environments.
• Developer group support for creating, managing and deploying Schemas, UsersAccess control and Security, database objects such as tables, sequences, indexes, stored procs, functions, triggers, packages and maintain them via Version change control SQL scripts.
• Data Security using audit schemas, Oracle Virtual Private Database (VPD) previously known as Fine Grained Access Control also called Row Level Security, Performance tuning under VPD.Setup of Oracle Database Vault in Oracle 11g for Corporate Governance Regulations which include Sarbanes-Oxley, PCI, HIPAA, Gramm-Leach Bliley, the Japanese Privacy Act, BASEL II, and much more.
• Database optimization for Multi TB VLDB high transaction OLTP and OLAP mixed databases using Oracle 11g’s new features such as Interval based automatic partitioning, referential partitioning for child tables, Virtual function based columns and partitioning based on Virtual columns. Oracle 11g server’s holistic tuning using SQL tuning sets in SQL Performance analyzer. Used Oracle 11g Optimal Flexible Architecture (OFA) setup features to minimize disk contention for I/O.

Skills/Tools:

RDBMS: Oracle 11g,10g, 9i/8i/8.x/7.x, Net8/SQL*Net,Sybase, DB2 and MS SQL Server. Tools: Oracle Enterprise Manager, Oracle MetaSolv Migration Tool (MTT), RMAN, ISQLPLUS, SQL*Plus, PL/SQL, Data Pump, SQL*Loader, SQL Trace, Auto Trace, TKPROF, Export/Import, Server Manager, Developer , Forms, Reports, VSS, Clear Case, Oracle Designer, Discoverer Admin, and User, Oracle WebDB and Oracle Portal, JDeveloper, Oracle Warehouse Builder, Oracle Workflow, RConfig, TOAD, MS Office, MS Project, MS FrontPage, Dream Weaver, Actuate, Vi Editor / Emacs, JEDIT, Exceed, Putty, File Zilla, Scrum Technology.DBMS Design Tools:, Oracle Designer, Erwin, Embarcadero ER/ Studio, VISIO
Operating System: Solaris, Red Hat Linux, Windows, DOS
Languages: PL/SQL, SQL, UNIX Bourne/ Korn Shell

Experience:

Project Name:Data Migration from Earthlink’s two Legacy MetaSolv (Telecom App) 5.2 instances to one MetaSolv 6.0 instanceDuration:October 2011 to January 2012.Employer- Confidential Role-Senior Oracle ConsultantLocation-Rochester NY / RemoteProject Description-Requirement gathering, Source to Target Mapping, Customization / Optimization of Oracle’s MetaSolv Migration Tool for data aggregation of two sources. BAR (Business Analysis Reports) generation using stored procs and Microsoft Excel.Technologies Hardware, Software, languages, and tools used-MetaSolv App Version 5.2, 6.0. Oracle Databases 8i,10g Enterprise Edition on Sun Solaris, SQL*Plus, PL/SQL, Oracle SQL Developer, MTT (MetaSolv Migration Tool), FileZilla, Vi Editor and Putty.

Project Name:Database Redesign and Optimization of Network Monitoring Software ProductsDuration:January 2008 to October 2011Employer-: Confidential.Role-Lead Senior Application Database ArchitectLocation-Sunrise, FL / Broomfield, CO and Frisco, TX / RemoteProject Description-Redesigned and optimized Nettraffic’s Network Monitoring Products and increased efficiency form 15K records / 5 minutes Collection to 1.2 Million records / 5 Minutes Collection cycle. Optimized Reporting queries for Actuate Reporting.Technologies Hardware, Software, languages, and tools used-Oracle 11g Enterprise Edition on Linux RHEL 4.0, Sun Solaris and Windows environments, SQL*Plus, PL/SQL, Oracle Enterprise Manger, Embarcadero ER/ Studio, SQL Performance analyzer, TOAD, PL/SQL Developer, Actuate, Vi Editor and Putty.

Project Name:FALCON Finger Printing Database Duration:October 2007 to March 2008.Employer-: ConfidentialRole-Lead Senior Application Database ArchitectLocation-Tallahassee,FLProject Description-Complete Logical and Physical Database Redesign with Metadata Rewrite for 15 Seconds SLA for Each Candidate’s Finger Print Verification Process.Technologies Hardware, Software, languages, and tools used-Oracle 10g Release 2 on Linux RHEL 4.0, SQL*Plus, PL/SQL, Oracle Enterprise Manger, Erwin, Oracle Warehouse Builder, Toad, Vi Editor and Putty.

Project Name:SIMS (Site Information Management System) and SIMS NG(Next Generation) Duration:June 2002 to June 2007.Employer-: ConfidentialRole-Application Database Architecture, Development and Production Support DBA.Location-Seattle, WA / RemoteProject Description-Complete Logical and Physical Database Design with Metadata Repository for Site Information Management System (SIMS) serving as database of record for all the cell sites in United States for Cingular Wireless.Technologies Hardware, Software, languages, and tools used-Oracle 10g Release 2 on Sun Solaris, SQL*Plus, PL/SQL, Oracle Enterprise Manger, Erwin, Oracle Warehouse Builder, Toad, Vi Editor and Putty.

Project Name:Intranet Portal for BankUnited Employees Duration:April 2002 to May 2002.Employer-: ConfidentialRole-As 9iAS Portal Administrator and Developer and DBA.Location-Miami Lakes, FL.Project Description-Self Serve Company Wide Intranet Portal for BankUnited Employees.Technologies Hardware, Software, languages, and tools used-Oracle 9i, SQL*Plus, PL/SQL, Reports 6i, Oracle Enterprise Manger, 9iAS Portal, JDeveloper 9i, Discoverer Admin and User, Oracle Containers for Java (OC4J), Win2000, Sun Solaris, Toad, Vi Editor and Exceed.

Project Name:Intranet Portal for Oracle License Management Duration:Sep. 2000 to Dec. 2001Employer-: ConfidentialRole-DBA/ Web Developer and Oracle License Manager.Location-Atlanta, GA.Project Description-Intranet Portal for Monitoring and Requesting Oracle Database and Applications LicensesTechnologies Hardware, Software, languages, and tools used-Oracle 8i, SQL*Plus, PL/SQL, Designer 6i, Oracle Enterprise Manger, Developer 6i Forms and Reports, Oracle WebDB / 9iAS Portal, Windows 95, Windows NT, Sun Solaris Unix.

Project Name:Client and order entry information system Duration:Dec. 1996 to Sep. 2000Employer-: ConfidentialRole-DBA and DeveloperLocation-Miami, FL.Project Description-Designed and managed a Client and order entry information systemTechnologies Hardware, Software, languages, and tools used-Oracle 7.x, SQL*Plus, PL/SQL, Developer 2000 Forms 4.5 and Reports 2.5, Windows 95 / Windows NT, Sun Solaris Unix.

Project Name:Client and order entry information system Duration:October 96 to March 97 (Part Time Employment)Employer-: Confidential.Role-DBA and DeveloperLocation-Miami, FL.Project Description-Designed and managed a Client and order entry information systemTechnologies Hardware, Software, languages, and tools used-Oracle 7.x, SQL*Plus, PL/SQL, Developer 2000 Forms 4.5 and Reports 2.5, Windows 95 and Novell NetWare.

AcademicCredentials:

• TL 9000 Quality Assurance Training completion for Telecom Industry.
• CJIS (Criminal Justice Information Systems) Certification.
• Oracle OCP Test 1 – Introduction to Oracle: SQL and PL/SQL (Exam 1Z0-001)
• NetG CBT Course 61312D: Complete Oracle8 Certified Database Administration Curriculum to pursue OCP Certification in Oracle8 Database Administration.
• Oracle 8 Database Administration: CIS 2990 MiamiDadeCommunity College. 4 Credit Hour Course. Secured A Grade with 4.0 GPA.
• Oracle PL/SQL: NetG CBT.
• Oracle SQL and SQL*Plus: NetG CBT.
• Oracle SQL and SQL*Plus: DML and DDL, NetG CBT.
• Programming in Visual C++ using MFC.
• SAP Fundamentals Certificate.
• University of Miami- IBM AS/400 System Operator Workshop Course-Certificate
• ICS Learning Systems- “Microsoft Windows NT 3.5 Fundamentals”-Certificate
• IBM Computer based training- “Exploring Computer Systems AS/400”-Certificate
• XEROXUniversity- “New Employee Training on PSP and QIP”- Certificate
• Masters of Science, PunjabUniversity, Punjab, Pakistan (Accredited by Josef Silny& Associates, Inc., International Education Consultants).