Jawahar babu
Email: [Send email using form at bottom]
Phone:
----------------------------------------------------------------------------------------
PROFILE: Over 12 years of IT professional experience in Database Management,
Performance Management, Infrastructure Management, Programming, and Application
Development with a significant focus on Microsoft technologies. Hardworking and
have good skills of logical thinking, leading, motivating a team with high degree
of initiative with great sense of responsibility.
SUMMARY :
Expertises in designing Database Systems, Database Administration, and
Architecting Data-warehouse management systems.
Successfully handled full life cycle of data-warehouse and Business
Intelligence(BI) delivery for numerous clients. Immense experience in commercial
real time applications in various critical sectors such as Automotive,
Manufacturing, Health care, Production planning and control, Inventory,
Entertainment & Media.
Leading and organizing all S/W improvement initiatives in Feature
Architecture, S/W Analysis and Design, Coding, Code Reviewing, Subsystem testing,
Feature Integration and Testing.
Build and Managed hardware platforms including; IBM, HP, Dell Server
Configuration with a concentration on Hardware/Software RAIDs for Web,
Production, Development & Staging Servers.
Extensively used MS SQL Server 2008/2005/2000/7.0 Database Administration and
design, development, tuning & maintenance running mission-critical and very large
databases.
Administration of multiple instances of SQL Server including performance
tweaking, job creation and scheduling, Backups, Restores and Security.
Involved in Relational database design and development of data warehouse data
feeds by extensive use of Cognos and Microstrategy products.
Developed multidimensional cubes using Analysis server and used Cognos Power
play to build graph and charts of sales/purchase data.
Involved Extensively on SSIS tuning influencing Parallelism, Buffer Sizing and
by updating design alternatives
Expert Knowledge on SQL Server 2008, Conducted Pilot projects on latest
versions.
TECHNICAL SKILLS:
Operating System\ Languages
Windows 2003/2000/NT, Sun Solaris, \ C, Pro*C, SQL, TSQL, PL/SQL,
Linux, Mac OS X\ DHTML, PHP, VB Scripting
BI Tools\ Databases
MS Analysis Services, Cognos Series 7\ Microsoft SQL Server 2008/2005/2000/7
(Transformer, Power play, Impromptu, \ ( SSMS,DTS/SSIS, SSAS, BIDS, DTA ),
Cognos scheduler, Cognos script editor,\ Oracle 10g (SQL * Plus, DBCA,
Enterprise
IWR), MicroStrategy 8\ Manager), MySQL, MS-Access, FoxPro
Tools
Erwin, MS Project, MS Visio, PVCS,
Shell programming, Rapid SQL, Visual
SourceSafe, Toad for Sql Server, Sql Zip,
Lite speed
CERTIFICATIONS:
Microsoft Certified IT Professional DBA on SQL Server 2005 (MCITP)
www.microsoft.com/learning/mcp/transcripts Transcript ID: 832610
and Access Code: Jawahar1
Microsoft Certified Technology Specialist on SQL Server 2005 (MCTS)
Microsoft Certified Professional (# 5524144)
Certified Project Management Professional, since 2005 (PMP)
https://www.pmi.org/CertApp/Registry.aspx Last Name: Daksh and First Name:
Jawahar
TRAININGS :
Attended training on Oracle 10g DBA, ASP.NET, Microstrategy & Cognos
PROFESSIONAL EXPERIENCE:
Team Detroit, Michigan, U.S.A Feb
2002 - Present
SQL Server DBA / Database Architect
Responsibilities:
Extensively involved in MS SQL Server 2005/2000 Administration creating Stored
procedures, Linked Server, SSIS/DTS package development & Job scheduling to pump
data BI system built on MicroStrategy & Cognos products.
Involved design, development testing and maintenance of the Ad-Insights
application which tracks all locomotive commercials on Medias such as TV,
Magazine, Newspaper, Internet, Outdoor, direct mailing and Radio for FORD Motors
Co.
Involved in Logical & Physical Schema Design and Implementation.
Integrated Multi-vendor/Multi-site Heterogeneous Database communication and
data sharing through web interface with major pieces being handled by database
itself (SQL Server 2000/2005) multiple projects. The entire process is completely
automated.
Managed implementation of truncation and archival system for main database
components reducing storage requirements and improving performance of OLTP
systems.
Redesigned the entire data model updated SSIS packages and tuned for
performance by avoiding blocking transformations and by Parallel execution of
packages. Developed extensive transaction-based stored procedures for data
access.
Recommended the hardware (Memory requirements & External hardware (RAID, SAN &
Controller) based on Logical Schema, Capacity planning & Nature of transaction.
Designed a complete mirrored backup system using 3 TB HP ProLiant ML350
connected to each server via dedicated network cards and a separate switch.
Young & Rubicam Inc, Michigan, U.S.A Dec 1999 - Jan
2002
SQL Server DBA / Sr. Developer
Responsibilities:
Involved design, development testing and maintenance of the CIKS (Competitive
Information Knowledgebase System) which provide most the accurate & complete
automotive advertising info.
Administration of multiple SQL Server instances including job creation and
scheduling, backups and recovery, security, develop stored procedure, tuning &
optimization, performance monitor, space management and login administration.
Responsible for designing a flexible, comprehensive and robust competitive
advertising information knowledgebase system to track competitive advertising
activity for its client FORD Motors Co.
Responsible for database design, backup & recovery, space management, login
administration, tuning for all MS SQL Server databases with monitoring &
debugging. Design, develop DTS packages, to integrate data from several systems.
Design and develop OLAP data models by creating multidimensional cubes using
Analysis Services by using DTS to pump data to data marts.
Extensively worked on Power play Enterprise server and Cognos products for
cube deployment on web by creating power cubes.
GERS Retail Systems, San Diego, US Mar 1999 - Dec 1999
Software Consultant
Responsibilities:
Involved in the development of Big Ticket (BT), Corporate System (CS) and TOPS
applications.
GERS Retails system is a single integrated package that handles corporate,
stores and distribution centers, retail applications and services for the
consumer Electronics and Appliances.
Responsibilities included Enhancement, reengineering and coding of Oracle
Forms 5.0 based applications through PVCS under Data General UNIX DG/UX and
Windows NT environment.
Wrote queries for summary reports for different modules. Wrote scripts for
comparing any two oracle databases (Production/Development DBs)
Handled over 140 PRO*C files called during the redesign of User Exits.
Also played active role in unit testing and Bug fixing.
CMA Consulting Services, New York, U.S.A Dec 1998 -
Feb 1999
Software Consultant
Responsibilities:
Involved in the development of the State of Maine WIC application.
Responsible for analysis, design and specification, which includes writing
specification and test scripts for other programmers to follow.
Involved in system study along with domain experts has a great exposure to
health care industry.
Designed and developed database procedures, packages and triggers using PL/SQL
with Y2K compliant features.
Assisted in the conversion of the Oracle Forms 2.3 into Forms 4.5, and Reports
1.1 to 2.5 making extensive use of libraries and templates.
Responsible for SQL performance tuning using hints, analyzing joins, locking
strategy and Caching data wherever needed. Guide developers to use PL/SQL tables
to cache data.
Kumaran Systems, Chennai, INDIA Jan 1998 -
Nov 1998
Programmer Analyst
Responsibilities:
Involved in the off shore development of applications for various clients like
Coors Brewery Company, Denver and Strohs Brewery, Detroit.
Migrated client's existing Oracle 6.0/Forms 3.0 to Oracle 7.x/Forms 4.5 with
focus on providing Y2k complaint solutions by re-enhancing existing PRO*C, SQL
Scripts.
The Forms were converted such that the same form is executed both in windows
and in IBM character mode
Developed MIS level reports in Reports 2.5 and PL/SQL codes to replace
existing AOLs.
Responsible for providing full mouse functionality in the converted
application, offering different methodologies for functional mouse
implementation, which is not incorporated in forms 3.0, which was also called as
TMN (True Mouse Navigation).
Kumaran Systems, Chennai, INDIA Oct 1997 -
Dec 1997
Programmer Analyst
Responsibilities:
Involved in the development of Foreign Trade Supervision (FTS) project for
Intertek Testing Services., U.K.
Encompassing data warehousing of Import /Export of shipment and goods issuance
with emphasis on quality analysis and pricing.
Re-engineered code from Accell/Unify RDBMS into Oracle Forms 4.5/Oracle 7.x
incorporating Optimization and Application tuning.
Interacted directly with the customer by enhancing and fixing up the bugs in
the application.
Handled the Menu object to integrate both forms and reports.
Signal Technologies Pvt. Ltd., Chennai, INDIA May 1997 - Oct
1997
Programmer
Responsibilities:
Involved in the development of Accounts receivable system.
Extensive development in Developer 2000, Oracle7.x, PL/SQL, Forms 4.5.
Developed Customer personal details module, Product details module, Invoice
details module.
Generated reports ba |
