*

PREETHI MADHUBALAN

acsxm4@r.postjobfree.com

Mobile Number: +91-852-***-****

Experience Summary

Seeking a challenging career in BigData Technology where I can utilize my previous 3 + years of experience as a Software Engineer, to improve my skills and support my team to build successful system in all possible fields. Highly motivated to work in a professional environment with a growing organization and put in best efforts for the technical enhancements of organization and myself. Having extensive knowledge in Hadoop Ecosystems like HDFS, MapReduce, HBase, Hive, Pig, Sqoop, Oozie and Flume. Flexible, self-motivated with the ability to work under pressure, prioritize and perform multiple tasks. An effective communicator with strong Leadership, People Management and Problem-Solving skills with ability to interface and influence at all levels of the organization and collaborate with offshore and onsite team members effectively.

Core Competencies

• Expertise in Oracle Database administration for 10/11g on Unix/Linux/Windows platform and having good knowledge in architecture, Experience in Installation, creation, configuration, upgrade and patching, Hot and Cold Backup and Recovery, cloning of databases using RMAN, Packages and Stored Procedures.

• Good Knowledge in Moving data files generated from source to HDFS for further processing, writing the Apache PIG scripts and using Map Reduce codes for UDFs to process the HDFS data, Creating Hive tables to store the processed results in a tabular format.

• Proficient in Oracle Standby Database, Data Guard, Replication, Upgrade, Refresh, Cloning, Tuning Up Parameter value for best simulation, Shell Scripting and Logical database design

• Experience in Installation and maintaining Real Application Clusters.

• RDBMS experience includes SQL Server 2008/2005/2000, MS Access; Database programming and connectivity using SQL, TSQL,PLSQL, SQL Queries, Stored Procedures, and ADO /ADO.NET objects

• Technically proficient in PL SQL, DB Administration & manual testing and internal and external audit.

• Excellent in analysis, design, coding and implementing for enterprise, Internet, intranet and client server applications.

• Expertise in .NET development, using C#, ASP. Net, VB.Net, ADO.Net, SQL Server, Oracle

• Have strong analytical, administration and problem solving skill dedicated to maintain the high quality of standard and ability to work independently.

• Excellent Decision making, People management skills, communication capabilities & presentation skills Career Profile

Organization Role/Designation Duration (in Yrs.)

Tata Consultancy Services LTD System Engineer 3 years 4 months Technical skills

Web Technology ASP .NET, HTML, XML, CSS

Languages VB, C, C++, C#, Java

Platforms/operating

systems

Windows 2000/2008 /NT 4.x/9x, MS-DOS,HP–UX, Sun Solaris, Redhat Linux RDBMS SQL Server 2000/2005/2008, Oracle 11g/10g,MS Access Middle Tier Internet Information Server, ADO .NET

Tools & Utilities

EXP/IMP,OEM, RMAN,TKPROF, STATSPACK, AWR,ADDM, SQL LOADER, SQL NET, TOAD, SRVCTL, DBMS APIS, ORADEBU

2

Achievements

Award Name Project / Organization

Beat Team Award - March 2012 Pfizer @ TCS

On Spot Award - June 2010 TCS CTG @ TCS

Certifications

Certification / Professional Society Date Certified/ Member Since IZ051 Oracle Database 11 g SQL Fundamentals-I July 2014 IZ052 Oracle Database 11 g Administration -I In Progress Hadoop Developer certification In Progress

Training

• Hadoop Developer training - online through MAPR Academy

• Oracle Database Associate training - online

Key Assignments - Tata Consultancy Services LTD (TCS) Project - Pfizer Duration – June 2010 to March 2012 Customer Name: Pfizer, Inc.

Project Description:

Pfizer, Inc. is an American multinational pharmaceutical corporation headquartered in New York City, with its research headquarters in Groton, Connecticut, United States. It is the world's largest pharmaceutical company by revenues, which remains dedicated to discovering and developing new, and better, ways to prevent and treat disease and improve health and wellbeing for people around the world. Role & Responsibilities:

• Installed and configured Oracle and Oracle Products on UNIX, Linux and Windows Environments.

• Monitored & tuned the performance of database, SQL statements and for unusual conditions in database against contention, load throughput and cache utilization.

• Performed Monthly Cold Backup, Weekly Hot Backup, daily incremental backups using Export, Testing of Backup’s and Documenting backup strategies.

• Strong Exposure in writing Simple and ComplexSQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collect

• Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries

• Monitored regularly whether primary and standby databases are in sync and clearing the backed up Archive log files after confirming that they are applied on the standby database.

• Monitored the database objects growth, managing the extents growth and de-fragmenting the objects, which are running out of maximum extents, the excessive fragmentation of table spaces and taking remedial steps.

• Starting the reporting database using the standby database data files and standby control file.

• Daily activities include monitoring batch application for performance and space requirements and tuning the system to optimize space and performance.

3

• Used SQL LOADER for dumping data into database from Legacy Systems and Flat files.

• Good experience in SQL, PL/SQL, Shell Scripting.

• Worked with DW team for loading data to warehouse databases and Performed tablespace Management and Rollback tablespace Management.

• Transaction Management and Security Management.

• De-fragmentation of database objects and Involved in migration of the databases from Oracle 10g to Oracle 11g.

• Upgraded Oracle 10g RAC to Oracle 11g RAC.

• Shell scripting for monitoring health of database and sending email for any errors logged in alert log file, monitoring file system space availability.

Project - Target Duration - June 2009 to June 2010 Customer name: Target Corporation

Project Description:

Common singing program where the application is in vb.net which is migrated to C#.net and enhancement. Role & Responsibilities:

• Client discussions to gather requirement

• Worked on converting requirements into high level and detailed level design using c#.net

• Design and developed the database tables.

• Provide the secure web application that is secured and complaint with the standards.

• Provide the regular status update, maintained project documentation, followed quality processes and procedures.

• Responsible for the creation of the user defined applications, database classes, procedures and user controls.

• Responsible for the testing, fixing the bugs and troubleshooting the technical problems.

• Modified applications according to the user’s requirements.

• Responsible for the development of the template request modules and integrate them with the current applications.

• Train and helped other developers to resolve the technical problems.

• Provided Production support and prepared the user Manual.

• Strictly adhered to quality processes and procedures.

• Preparing monthly work status report and updating the technology specific documents.

• Performed code review, worked close to team member to ensure consistence to code standards. Project - Marks And Spencer Duration - November 2008 to May 2009 Customer name: Marks and Spencer

Project Description:

Developed a resource management system tool for Marks and Spencer project team to manage the resource details.

Role & Responsibilities:

• Performed requirement gathering and analysis.

4

• Developed Detailed Level Design and UI design using Asp.net.

• Developed reusable custom control, which has been used across the modules.

• Data access layer implemented using ADO.NET with Database SQL Server 2005.

• Create functions and store procedures using SQL Server 2005

• Prepared the user Manual

• Writing/Reviewing System Use Cases and Test Cases

• Test Execution activities – Test Data gathering, execution, defect reporting, retesting and regression testing

• Review and verify the technical document in Low level design

• Co-coordinating and conducting knowledge transfer session for other team members. Education

Degree / Specialization University Year

Bachelor of Engineering – Computer Science Anna University 2004 - 2008

Contact this candidate