Manager Project
Resume:
Senthil Pitchaimuthu
San Diego, California, 92128 United States
*******.************@*****.***
PROFESSIONAL EXPERIENCE
Teradata Corporation San Diego, California United States
Big Data Solution Architect Aug 2014 – Present
• Gathering functional requirements, developing technical specifications and project & test planning.
• Developing data governance standards, roadmap and architecture decisions.
• Providing data consultation on the project, best practices for Master Data Management.
• Working on Big Data POCs, Benchmarking projects and Performance Tuning.
• Data Modeling (Erwin/MySQL workbench), Designing/developing schema definitions.
• Designing/developing ETL jobs across multiple platforms and tools including Hadoop, Teradata and PostgreSQL.
• Resolving defects/bugs during QA testing, pre-production, production, and post-releases.
• Experience working with Agile Development (Scrum/Kanban), JIRA methodologies.
• Working on Hadoop (Hortonworks hdp 2.2), TDCH, Amazon EMR and cloud (AWS).
• Working on ETL scripts on Pig / Hive / Sqoop and C,C++, Perl/UNIX shell scripting
• Creating Pig scripts to load data from Hadoop (raw data) into Teradata and PostgreSQL Data Marts.
• Hadoop integration and application with Teradata / PostgreSQL back-ends.
• Strong experience working on AWS EC2/S3/RDS environments.
• Working on Continuous Integration (CI) environment (Jenkins integrated with GitLab).
• Well experienced in a solution architecture on database technologies such as Teradata, PostgreSQL, Oracle,
Netezza and Hadoop.
• Verify software solution feasibility, interoperability and performance assessments.
SONY Network Entertainment San Diego, California United States
Nov 2013 – Aug2014
Data Architect (SQL Server /Oracle / Hadoop)
• Identify and evaluate industry trends and new tools in big data technologies to serve as a source of information and
advice for upper management.
• Design and implement big data technology stack (Hadoop, Map/Reduce, Pig, Hive, NoSQL, Real Time Event Processing
technologies
• Worked on Hadoop distributed cluster and ETL design on new warehouse environment.
• Setup up and manage SQL server EC2 environments on Amazon AWS.
• Actively participate and maintain MUC (Max Up time) project to reduce significant downtime on OLTP using Golden
gate replication techniques.
• Participate SCRUM meetings, support and resolve issues for Agile SDLC sprint development activities.
QUALCOMM INC San Diego, California United States
Mar 2007 – Oct 2013
System Architect
• Hadoop distributed cluster: Completed Cloudera training and worked on complete setup of Hadoop cluster on Linux
using CDH4. Setup test ETL integration from Oracle data warehouse to Hbase on Hadoop cluster using Sqoop as the ETL
tool.
• ETL design and implementation: This is the project to design and implement BI solution on ERP. The source is Oracle
ERP and the target is Oracle Data warehouse. I was the architect to design the data model and ETL transformations using
Informatica power center (ver. 9.5.1). I have designed the logical/physical data models for data marts and ETL
workflows from OLTP source to Oracle Data warehouse.
• Informatica Data Replication (IDR): This project was to replicate complete data from Oracle database to Netezza
database in near real-time. This is a data warehousing solution for the company's focus on Big data in the future.
Role: IT Architect role, DBA roles in this project. I was the liaison between the data warehousing development team
/DBA team/ Unix Infra team/ Windows Server group and storage. I coordinated well with all these teams and setup the
windows servers for the IDR installation and got the NFS storage for the archive logs, installed new database on 2 node
10234 Rancho Carmel Dr San Diego,, California,, 92128 United States 508-***-**** *******.************@*****.***
RAC cluster and cloned production to act as a new source, worked on the optional-alternate archive log NFS location to
get the performance unaffected on the source.
• Data Warehouse (SAP BI 4.0/ BO-XI3.1/2/6.5) implementation: Those were multiple (4) projects happened in different
timelines in the span of 4 years and complete end-to-end projects from the planning through implementation and go live.
Role: System Architect. I was the primary who planned the servers, product license procurement, installation,
configuration, co-ordination with development and end-users for the complete testing. Those were very time consuming
projects, which needed lot of interfaces between different sources such as ERP/Engineering applications/different
Business applications and tools such as Informatica, control-M, Business Objects, LCM(life Cycle Manager), Oracle
Data Integrator with web services such as Apache/Tomcat. I worked with many teams such as Web services team for
Apache/Tomcat /Siteminder (SSO) integration, VIP, netscalar configuration, Sitescope monitoring, Unix infra team for
Unix server setups, DBA team for the database requirements, storage team for SAN and NFS file system, Windows server
group for windows server needs.
• OEM 12c implementation (Enterprise wide database monitoring tool): This project is to implement OEM 12c on Linux
Extended RAC (ERAC) clusters.
Role: Tech Lead for the end-to-end implementation of this project. I worked with the Unix Infrastructure team to plan the
servers, worked with the Storage team to plan SAN storage on two different data centers, worked with DBA team to
install 4 node 11gr2 RAC on Linux and 2node application installation on Linux, worked with Networking team for VIP
and GSS setup. I worked with Oracle support for issues resolution. I have done complete co-ordination, meetings,
communication with all the related teams and worked with entire DBA team to test the OEM KPI's, FO, LOAD testing’s.
The project went very well and in Live in production now.
HCL America, Inc. Sunnyvale, California United States
Senior IT Consultant Mar 2005 – Mar 2007
• At EMC Corporation, Westborough, MA as Database Architect: This project is to provide 24/7 Application DBA support
to production systems running on Oracle Applications (Versions 11.0.3 and 11.5.10).Database: 8i and 10g RAC.
Replication Tools: Shareplex and Goldengate
Role: All DBA activities such as 10g RAC installation and support, Application Tier Linux migration. Database upgrades
and patching. Shareplex support, Performance tuning, Cloning, Refresh, Backup and Recovery using RMAN. Provide
24/7 user support for Oracle (11.5.8/11.5.10) E-Business Suite -production. Development of shell scripts/utilities from
time to time to better the environment Able to work independently as well as work as part of a team.
• At Teradyne Inc., North Reading, MA as Project Manager (Oracle Applications): This is a HCL’s one of the big projects
which gave end-to-end support for Teradyne corporation’s IT operations.
Role: To plan and manage all database support activities for the entire project. I managed a team of 7 people. Involved in
the Project of upgrading 10.7 to 11.5.10.Detail database system study and implement better practices to improve the
performance and decrease the downtime. Recommendations, plan, design development of new technologies to betterment
the system. Numerous shell scripts, cron schedules for the automation of maintenance alerts, DB Monitor / File system
monitor scripts.
Oracle Corporation Bangalore, Karnataka India
Senior Application Engineer Jul 2001 – Feb 2005
• Member of Oracle Corporation's ongoing E-Business Suite (ERP) development which enhances and releases the new
versions of oracle E-Business suite.
• Worked with Oracle Development team on their 11.5.10 Oracle Application development activities.
• I played DBA and Release Manager Roles.
• As a Release Manager, I was responsible for oracle patch build activities. Worked with the development team to support
and resolve issues. Worked with release management team for the patch build and release activities.
Tata Consultancy Services Bangalore, Karnataka India
IT Analyst Oct 1998 – Jun 2001
• IT system analysis, System study to understand the components of the application, interfaces, network, storage. Reverse
Engineering to prepare the logical design of the system. User interaction to understand the existing functionality of the
system and to provide more information about the data to the development team.
EDUCATION
BHARATHIAR UNIVERSITY Tamil Nadu, India
Bachelor of Engineering in Computer Science and Engineering, Apr 1993
• Professional training attended:-
-Cloudera Hadoop administration from Cloudera
-Oracle Database 12c new features workshop from Oracle Corp
-Netezza 101 and advanced concepts from Qualcomm Inc.
-Project Management tools and techniques from Qualcomm Inc.
-Oracle Fusion Middleware Technologies from Qualcomm Inc.
-SAP Business Objects XI3/BI4 from SAP Business Objects
-Oracle 11 r2 ASM RAC from Oracle Corp- Oracle 11g r2
-New features from Oracle Corp
-Project management and negotiation skills from HCL America
-Release Management Process training from Oracle Corp
-Data warehousing concepts from Oracle Corp
ADDITIONAL SKILLS
• PostgreSQL, Teradata, Hadoop, Netezza, MySQL, Oracle
• Applications: Oracle 10g/11g Fusion Middleware Suite (SOA suite, BPEL, SSO, OID), Apache, Tomcat, Web logic
server, Business Objects, Data Integrator, Life Cycle Manager.
• Programming skills: Pig/Hive/Sqoop, shell scripting(Unix and PERL), PSQL, PL/SQL, Pro*C, C++
• Database technical skills: PostgreSQL, Teradata, Netezza, MySQL, Oracle databases, Oracle RAC ASM, Exadata,
Golden gate technologies, Big data Hadoop (HDFS).
• Working Environments: Hadoop HDFS, Teradata/PostgreSQL Data Warehouse, ETL (Data Integrator, Informatica)
• OS: Linux /CentOS, Oracle VM/ VMWare, Linux/Unix/SUN: Sun Solaris 10, Red Hat Linux 5.5
• Servers: LDOMs(T4,T5), Windows, Oracle Exadata, Amazon Cloud (EC2)
10234 Rancho Carmel Dr San Diego,, California,, 92128 United States 508-***-**** *******.************@*****.***
Contact this candidate