RANJITH GNANASUTHAKAR ALPHONSERAJ

***** ******* ** *** *****,

UNIT-G,

San Diego,

CA – 92127, USA.

Mobile: 858-***-****

E-mail: a1svcb@r.postjobfree.com

PROFESSIONAL SUMMARY

• 8+ years of experience as a Technical consultant, DBA cum Developer and Programmer on SQL Server 2000/2005/2008 and ORACLE 10G database administration and development.

• Experience in logical and physical data modeling with normalization.

• Well experience in Database Analysis, Design, Performance Tuning and Query optimizing skills using SQL Server technologies.

• Worked on Database troubleshooting in both development and production environment.

• Proven experience in stored procedure, function, trigger in both SQL Server and Oracle.

• Worked in Transactional Replication, Database Mirroring, and Backup & Recovery policy.

• Good exposure in Routine Job Creation, Checking for re-indexing and Database Integrity.

• Proven experience in project and team leading with zero defect delivery. Equally comfortable working independently as well as in a team environment.

• Well experience in performance tuning, reviewing and testing databases.

• Worked in ORACLE 10G database administration and PL/SQL code development.

• Certified from MICROSOFT and ORACLE for the below certifications.

TECHNICAL SKILLS

Programming Languages SQL, T-SQL, PL/SQL

RDBMS SQL Server 2000/2005/2008, ORACLE 10G

BI SSAS, SSIS and SSRS

Operating Systems Win 2003/XP/2000/NT, MS DOS and UNIX

CERTIFICATIONS

Microsoft Certified Database Administrator (MCDBA) – SQL Server 2000

Microsoft Certified Professional (MCP)

Microsoft Certified Technology Specialist (MCTS) – SQL Server 2005

Oracle Certified Associate (OCA) – ORACLE 10G

Oracle Certified Professional (OCP) – ORACLE 10G

PROFESSIONAL EXPERIENCE

SONY Electronics, San Diego, CA Dec 2009 till Date

Sr. SQL Server DBA & Developer

MP Tool – Supply Planning

Manufacturing Planning Tool (MP Tool) is the planning tool for factory and market which consolidates the demand data from all the Sony regional sales companies. This system is a communication tool between factory, inventory management group and marketing for demand, supply and allocation. This system also acts as a communication tool between factory and the supplier for key parts and their replenishment plan. Other feature of this system are : Valid data for planning, Analytical tool for planning using ERP data, Establishing KPI metrics by analyzing real time operational data, Providing an accurate and timely measures for analyzing demand/supply fluctuation, Synchronization of data for local and global production planning, Aligning production qty with market for model close-out (EOL). MP Tool is an enhancement project starting with requirements gathering for new enhancements, development, testing, implementation and post implementation support. The system will be developed using the Agile Development Method.

Responsibilities:

• Involved in Requirement analysis and Designing of Database structure.

• Developed SSIS, SSAS and SSRS packages

• Report any functional gaps in existing applications.

• Test plan preparation, Review of test plans, unit and integration testing.

• Work with onsite lead and off-shore team for functional enhancements, system design and coding for the business critical modules.

• Developed PL/SQL code in ORALCE 10G

• Implemented Transactional Replication in SQL Server 2005

• Post implementation and Application support.

Environment: Microsoft Analysis Services, SQL Server 2005 Integration Services(SSIS), Oracle Database 10g, SQL Server 2005, MS SQL Server 2005 Reporting Services, PL/SQL

SONY Corp. of America Production DBA Support, San Diego, CA Nov 2008 to Dec 2009

Lead DBA

SCA DBA

SCA DBA Support team is maintaining all SONY’s database server. It includes SQL Server, SYBASE and ORACLE databases. There are around 16 dedicated SQL Servers (7 SQL Servers from East coast 9 from West coast locations) are handled by SCA DBA Support team. It is 24/7 support team.

Responsibilities:

• Involved in Jobs Monitoring.

• Involved in Backup, Recovery and database maintenance activities

• Involved in database design and performance tuning

• Implemented high availability solutions like Database Mirroring, Replication etc...

• Involved in SQL Server installation and up gradation

• Team Lead for 6 members.

Environment: SQL Server 2005/2008, ORACLE 10G and SYBASE

Paccar Inc., Seattle, WA Aug 2008 to Nov 2008

Database Consultant

AIS – Performance Tuning

AIS project had performance issues where list of SQL Server Procedures, functions and Triggers have to be tuned to improve the performance of the application.

Responsibilities:

• Involved in Basic support for SQL Server 2005.

• Involved in Performance tuning of the queries, stored procedures, functions and triggers.

• Involved in Database Analysis and design

Environment: SQL Server 2005

Wipro Technologies, East Brunswick, NJ Jan 2008 to Aug 2008

Database Consultant

Enlighta Admin

Enlighta is a governance tool used for maintaining project data. Since it is a production server to maintain the availability of data, the following architecture has to be automated with least manual intervention.

- Application Server-1 and Application Server-2 are pointing to same database Server-1.

- The database Server-1 has to be replicated to database Server-2.

- When database Server-1 goes down Application Server-1 and Application Server-2 should point to database Server-2.

- When database Server-1 comes up we need database Server-1 to be updated with the data of database Server-2 as they need to reflect same data..

Responsibilities:

• Provided RFP to implement failover architecture through database mirroring.

• Leading team to implement database mirroring architecture.

• Provided support for performance tuning of queries.

• Provided support to create SQL Jobs for backup and recovery process.

• Monitoring and troubleshooting the production database.

Environment: SQL Server 2005

Paccar Inc., Seattle, WA Aug 2007 to Jan 2008

Database Consultant

EServices

The objective of the System would be to be able to leverage the existing executive dashboard infrastructure to develop a data repository for collecting vehicle Telematics information on a near real time basis. The design objective is to create a Paccar internal facing system. The system shall be able to extend to support external users in the future (E.g. Dealers and customers). Additionally, the data repository can also host a variety of data and be considered as a baseline for various systems like the Vehicle Registration, Fault Code system etc.

Responsibilities:

• Gathered requirements for the database design.

• Interacted directly with customer and studied all subsystems to integrate with eServices system.

• Provided high level entities and attributes list for database design

• Studied base model attributes to design the application data model.

• Designed logical and physical data model and created database.

• Given full support for development team.

Environment: SQL Server 2005

Micron Technologies Inc, Boise, Idaho Sep 2006 to Aug 2007

Technical Lead

FE-OLTP Application – Sybase ASE 12.5 to SQL Server 2005 Migration

This project is a migration project. SYBASE database system is used by MAM application. The backend processes are being migrated from Sybase ASE to SQL Server 2005.All the triggers, stored procedures and SQL queries are converted through the following steps:

- SQLCV2 [Perl Script] is used for initial conversion for all triggers, stored procedures and ADHOC SQL.

- Cosmetic changes and manual conversion for the stuff like joins, Group By clause, Distinct clause, NULL Issue etc.

- Testing the results of Sybase code and the converted code & make sure the functionality result and performance results.

- Prepare the test case and deliver to the clients in periodical manner.

Responsibilities:

• Migrating Triggers and Stored Procedures from SYBASE ASE to SQL Server 2005 through the following process:

• SQLCV2 [Perl Script] is used for initial conversion for all triggers, stored procedures and ADHOC SQL.

• Cosmetic changes and manual conversion for the stuff like joins, Group By clause, Distinct clause, NULL Issue etc

• Testing the results of Sybase code and the converted code & make sure the functionality result and performance results.

• Prepare the test case and deliver to the clients in periodical manner.

Environment: SQL Server 2005, SYBASE ASE12.5, SQLCV2 [Perl Script], SSMA

The Shams Group (TSG), Dallas, TX Jan 2005 to Aug 2006

SQL Server DBA & Developer

GALACTICA – Implementation

Domain: HealthCare

GALACTICA is used to link the patient’s documents with patient’s account information. All the patient’s documents are initially scanned and linked to patient’s account information through POS tool. GVII tool is used to view the patient’s linked documents. Download/Upload is the basic process for this system. GalacticaRXOP tool is used in the pharmacy centers. All the pharmacy documents from the doctors are sent to pharmacy centers

and it will be processed to patients based on the priority

Responsibilities:

• Involved in creation & implementation of new DTS Packages.

• Involved in Database analysis and Maintenance task.

• Involved in Backup & Recovery process.

• Involved in developing stored procedures, triggers, functions.

• Involved in Production database high availability implementation.

• Leading Development team for implementing/deploying code at Production database.

Environment: SQL Server 2000

The Shams Group (TSG), Dallas, TX July 2002 to Dec 2004

SQL Server DBA & Developer

GALAXY – Implementation

Domain: HealthCare

GALAXY is used to upgrade the Augusta-Galaxy as per Meditech System. Galaxy is downloading patient details from the Meditech [Mainframe] PC and uploading to SQL Server tables. Astro Interface Engine is used to download the records from the Meditech and SQL Server DTS Packages are used to upload to SQL tables. Astro Interface Engine is a collection of interfaces. SQL queries/procedures are used behind each interface. Magic code is acting as an intermediate between our system and mainframe system.

Responsibilities:

• Involved in creation of SQL Jobs for uploading data.

• Involved in performance tuning of Production databases.

• Involved in creation & implementation of new DTS Packages.

• Involved in Database analysis and Maintenance task.

• Involved in Backup & Recovery process.

• Involved in developing stored procedures, triggers, functions.

• Involved in Production database high availability implementation.

• Leading Development team for implementing/deploying code at Production database.

Environment: SQL Server 2000

EDUCATIONAL QUALIFICATION

Bachelor of Engineering (B.E.) in Computer Science, Apr. 2002.

Contact this candidate