SUMMARY

Over 15+ years of software development and management experience coupled with versatile experience in providing exhaustive support for all the phases of Software Development. Proven ability to create quality software while adapting to changing customer needs, also well versed with all aspects of software development and implementation lifecycle including 24X7 on-call production support.

• Extensive project management skills that involves procurement of requirements, Project Planning, Resource allocation, risk evaluation, design, development, implementation and maintenance.
• Solid skills in database optimization and performance tuning for servers, applications, and SQL queries.
• Designed and developed database applications and data warehousing for business intelligence.
• Database designing, database cloning, data warehousing, Performance monitoring and tuning.
• Providing 24X7 on-call production support, for the projects deployed and meeting all the technical requirements in emergency situations.
• Vendor management and coordination to support implementation of applications involving multiple software products and modules.
• Supporting major aspects of software project cycle like design and coding, deployment, maintenance, performance tuning, disaster recovery etc.

• Oracle 11g
• Oracle 10g
• Oracle 9i Internals
• Oracle 8i Parallel Server (OPS)
• Performance Tuning
• Security Administration
• Replication
• Distributed Databases
• Disaster Recovery Solutions
• Database Design
• Data Obfuscation
• System Design
• Data Modeling
• Recovery Manager (RMAN)
• Standby Database Solutions
• Oracle 9i Data warehousing
• Oracle Enterprise Manager (OEM)
• Informatica
• ComPOSITE
• XML and Web Integration
• Unix Shell Scripting
• PL/SQL
• Unix, Solaris, HPUX, Tru64, AIX
• Windows NT, 2000,XP,Vista
• Project Management & MIS Reporting
• Training & Team Management
• Developer 2000 (Forms 5.0/Reports 3.0)
• HTML, DHTML,Ms-Access
• MTS, Visual Intradev, ADO, ActiveX
• ASP , Crystal Reports, VB, VBScript,
• Java , JavaScript
• COBOL, CICS, DB2, TSO/ISPF,PC

Professional Experience

Confidential,NH Nov 2000 – Present

Comcast has grown from a single system cable operation into one of the world\'s leading communication companies, focused on broadband cable, commerce and content. Comcast Cable is the country\'s largest provider of cable services, and is expanding its cable operations to deliver digital services, provide faster Internet service, and develop and deliver innovative programming.

Professional Achievements

• Honored to be the Legends Nominee and received many awards for outstanding contribution and achievements.
• Heading the North Eastern Division DBA team and supporting critical applications and was involved from the setup, configuration, development, performance tuning and providing 24/7 support.
• Monitoring 5 business critical production databases simultaneously with database sizes ranging from 10GB up to 10TB OLTP and Data Warehousing systems.
• Optimization of a user process from 5 Hrs to under 10 minutes to meet Senior MIS reporting requirements
• Solely responsible for setting up mirror environments to extract production data from Mainframes and saving huge expenses incurred towards Mainframe utilization time.
• Solely responsible for designing the following applications currently in production
• NETE Time Entry system for New England.
• Sales Compensation System for BSP group.
• Credit & Adjustments web based report integrated with Crystal Reports.
• CPE Database and reports
• Revenue Reports
• Business Operations
• Work Order Discrepancy Web tool
• Various reports to meet the requirements of different departments like, finance, operations, Marketing HR and Senior Management.

Working as a Senior Database Administrator for 9 + years held the following responsibilities.

• Data Extractions from Vantage and infoDDP (Amdocs) to support Data availability to Divisional Reporting Analysts.
• Development of scripts to restore and recover databases from SAN EMC split mirrored hot backups. Setting up the required environments to support the recovery testing.
• Setting up RMAN / expdp tools to backup and monitoring events through OEM.
• Designing of packages to extract the data from remote sources like SAP for Divisional users.
• Created various Packages to utilize Oracle / MS SQL Server DBA functions
• High availability, 24/7
• Design/model DB structures to support a variety of software applications
• Support development team in tuning DB and apps for optimal performance
• Monitor DB growth and provide DB capacity planning for apps expansion
• Design and implement backup methods and disaster recovery strategies
• Migration of DB between software versions, platforms, DB products
• Materialized views refresh run via the PL/SQL package for Data Warehousing.
• Responsible for monitoring 5 Business Critical production Oracle Databases.
• Implementation of advanced Oracle features like virtual partitioning and compress.
• Resolving production issues in emergency situations
• Monitoring database backups; query optimization; writing PL/SQL packages/functions/procedures; database security administration and account administration;

Environment: Oracle 8, 9i, 10g, 11g, Informatica, Unix, Linux, SQL Server, SAN storage

Confidential,Oct 99 – Oct 2000
Hook Fast Specialties is a company that specializes in the just in time delivery of badges, pins, service awards, merit awards, belt buckles, tiepins, etc., these products are used nationwide by police, sports, government, law enforcement as well as for personal use. A team of people created an on-line store where orders could be taken on line and then delivered to the production unit for manufacturing. It was essential that the Order Tracking systems was fast to ensure that orders went into production and then were quickly delivered.

I was involved in developing a new Online Shopping System, which has all the functionalities of an e-commerce system.

Responsibilities:

• Responsible for implementing the functionalities
• Database Design
• Coding using HTML, VBScript, Jscript, ASP 2.0, Cascading style Sheets, SQL Server 7.0
• Coordinating with the client and study their requirements and make recommendations
• Maintaining Quality Assurance reports and documentations.

Confidential,, MA Jan - Sep’ 99

Web Site design for online shopping of seafood. The site supports secured credit card transactions. As part of the web site design, admin section for storage and maintenance of products, vendor order generation was also developed. Was responsible for the development of admin module. Admin module includes forms for data entry into the database, generation of Vendor Orders, modification of existing customer orders etc. Also, was responsible for development of search engines for the site, and integrating the Asps to be compatible with Netscape browser.

Environment: ASP 2.0, SQL Server 6.5, VB Script, JavaScript, Pentium PC, Windows NT Server

Confidential,MA Jul 98 - Dec 98

AutoBook 2/32
Upsized the MS-Access 97 database to MS SQL Server 6.5. Ported AutoBook2 (16 bit) to Visual Basic 5.0 from Visual Basic 4.0. Made use of third party controls such as Tlist, Sheridan’s data widgets, spread and Crystal Report Controls. Coded the installation in Wise Installation system. Bug fixing was done in SQL Server version of AutoBook. Created database schema for IQC and aggregate databases. Worked out the procedure for installation of the software. Interacted with QA while bug fixing was done.

Environment: Visual Basic 5.0/4.0, Crystal Reports 6.0, MS-Access 97, MS-SQL Server 6.5, WISE Installation System 6.0, Windows NT 4.0, Windows 3.11, and Novell Netware

Confidential,NY Jun 97 – Jul 98

This was a system designed and developed as a database to store reactant chemicals and emission information of various grades of silicone manufactured be different reactors of the plant. The application also consolidated emission information from various equipment, displayed warnings for abnormal emission rates, etc.

Features included:

• Display of consolidated emission information with reference to different parameters - like a particular equipment, grade of silicone, reactant chemical, etc
• Issue of warning for abnormal emission rates
• Forms for data entry to the database

GUIs were developed using Visual Basic with MS Access as the database.

Environment: Windows 95, MS-Access 97, and VISUAL Basic 5.0

Education: Masters Diploma in Computer Applications