Developer Data

RESUME

Name : Samuel Gunaseelan Arumainayagam Pitchaimoni

Mobile : 1-856-***-****

SUMMARY:

Currently having 13 plus years of experience on database development, data modelling, data warehousing, performance tuning, application tuning across Oracle, SQL and, MySQL databases.

10 + years of Experience and expertise in Oracle Database SQL, PL/SQL programming, Database Designing, Development and Production support. Good in application tuning in SQL level and server level.

Having experience on working on various countries such as India, Canada, South Africa, Singapore and USA

Worked on a data warehousing project for Credit-Suisse client in Singapore there involved in various activities such as production support, PL/SQL development and ETL activities.

Worked as a Developer and DBA for Pfizer and involved in activities such as performance tuning, PL/SQL development, basic DBA activities and, data modelling

Expert in Oracle 9i,10g and 11g databases

OCP certified professional

Good working knowledge on optimized PL/SQL code and best practice coding standards and, documentation related activities.

Expertise in AWR report interpretation, and using database SQL plan, profiling, and oracle hints and real time working experience in database tuning in 4 node RAC database.

Create PL/SQL complex stored procedures, complex stored functions and views, Materialized views, database triggers, table partitioning, and performance tuning etc.

Worked on SQL T-SQL, DTS packages, stored procedures, functions and SQL server performance tuning.

Involved in data warehousing ETL design using DTS packages in SQL Server also

Expert level skills in Oracle DBA tasks – performance tuning in DB level, SQL level, AWR report analysis,

Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors, and other database objects.

Experienced as a Data architect and having working knowledge to solve any complex issue / solution in both Oracle database and SQL server Database

Having experience of leading a team on both offshore and on-site and co-ordinate with them to deliver the deliverables on time to customers.

Data modelling using ERWIN, SQL DEVELOPER data modeller. STAR schema and dimensional data modelling

Relational data modelling using ERWIN ERSTUDIO data architect 11.0

Good in UNIX platform in almost all flavours.

Worked in OLTP and DW environments

EDUCATION

Master of Computer Application.

2000 – 2003 Manonmaniam Sundaranar University – Tamil Nadu, India

OCP Certified Professional (2005 - Oracle)

SEI Investments (07/04/2016 - till date) - Data Architect

(Client of NIIT Technologies)

Environment and tools

Oracle 11g, putty, ERSTUDIO Data architect 11.0, SQL developer

Roles and Responsibilities

Writing complex Oracle stored procedures, functions, creating views, tables, indexes, PL/SQL blocks and all database objects.

Data modelling using ERSTUDIO data architect 11.0

Analyzing AWR report

Worked closely with QA team to give scope to test the application code.

Relational data modelling using SQL developer data modeller.

Code review of Developers code and assisting Front end and back end developers with database issues

Promoting code to QA, UAT, and other environments

Agile development methodologies

Performance tuning of long running queries

Worked on version control software Source system ( GIT )

Comcast (07/11/2011 – 06/01/2016) - Database Architect / Senior Database Developer

(Client of Cognizant)

Environment and Tools

Oracle 11g, putty, SQL developer, SSMS. Single View.

Roles and Responsibilities

Writing complex Oracle stored procedures, functions, creating views, tables, indexes, PL/SQL blocks and all database objects based on the client business requirements.

Performance tuning of existing code such as stored procedures, functions and ETL processes.

Data modelling for data warehousing ETL process using legacy DTS packages

Performance tuning of Oracle stored procedures, SQL, PL/SQL blocks etc.

Database level tuning

Analysing AWR report and get the exact reason for database slowdown and report to management

Actively worked on SQL server ETL process from Oracle to SQL server using DTS packages.

Worked closely with QA team to give scope to test the application code.

Generating Ad-hoc financial report for finance team.

Collecting long running queries from database and reporting to management team for review

Reporting the long running sessions in database and analyse it for any blocking on database level

Data modelling using ERWIN and SQL Developer data modeller

Dimensional data modelling and STAR schema data modelling.

Normalisation and demoralisation of data and structure based on the client requirement and performance optimization

Relational data modelling using SQL developer data modeller.

FACT and dimensional table creation and creating the surrogate keys and generating and helping the OBIEE developer to develop slice and dice of the reports.

Normalisation up to 3 NF (Third normal form).

News America Marketing (12/17/2010 - 07/08/2011) – Senior Oracle Developer

(Client of Cognizant)

ROLES AND RESPONSIBILITIES:

Involved in SQL and PL/SQL tuning, existing stored procedure and process tuning.

Did some architectural change which brought some huge gain in performance.

Writing Complex SQL and PLSQL code for their application

Co-ordinated with DBA team for release related activities

Analyzing AWR report and help development team to tune their application

SVN check – in for version controlling

DTCC - Sybase to Oracle Migration assessment (11/15/2010 - 12/15/2010) – Software Developer

(Client of Cognizant)

ROLES AND RESPONSIBILITIES:

I was involved in assessing the Migration from Sybase to Oracle database which i was involved in POC and inventory collection which is used for Estimating the project.

CREDIT-SUISSE (09/07/2009 - 09/30/2010) - Oracle Developer

(Client of Cognizant)

ROLES AND RESPONSIBILITIES:

Involved in ETL development and monitoring of PROD daily jobs

Monitoring daily ETL loading of data from legacy system T-24 to Oracle ODS

Star schema modeling, fact table, dimension table etc.

Used SVN for version control

Performance tuning of existing PL/SQL codes.

Involved in Design and architectural review of existing design and coding and involved in re-designing the architecture.

Worked close with BI team for report generation

Worked closely with QA team for testing

Pfizer (Mar 2008 – Jul 2009) - DBA and Developer

(Client of Satyam computers private ltd)

CLIENT DESCRIPTION:

The client is a Pharmaceutical client whose is having the GLOBAL presence.

ROLES AND RESPONSIBILITIES:

I was doing Production support and Performance Engineering work for GLOBAL support of its 1000 + databases and its applications where I was part of Performance Engineering team

My roles and responsibilities involves UNIX shell scripting, Prod support

Gathering statistics for oracle databases by writing Unix shell script and automating in crontab

Colleting the database health check and analyzing if any issues

Proactively tuning and re-actively tuning the database

Re-building indexes and database object de-fragmentation

Creating materialized views for few application support

Tuning existing pl/sql stored procedures and functions and creation database objects such as complex procedures, packages and materialized views and all database objects

Standard bank storage & Infra (Jul 2007 – Jan 2008)

(client of Satyam computers private ltd)

CLIENT DESCRIPTION:

The client is a PREMIER bank in South Africa where i was working in Johannesburg branch.

ROLES AND RESPONSIBILITIES:

As database administrator he performed the following database monitoring.

Checking Alert logs for ORA- errors

I/O Monitoring

Db buffer monitoring

Shared pool monitoring

Table space Management

Index rebuilding for production databases

Rollback Segment Management

File system management

Redo log monitoring

PL/SQL and SQL writing and complex stored procedure and package writing for the business requirements.

AAL – Administrative Assistant Ltd (Apr 2005 – Apr 2006)

(Client of Kumaran systems INC)

CLIENT DESCRIPTION:

The client is a Product based company having developed an application called e-SIS which a STUDENT Information system which is having clients in North American schools.

ROLES AND RESPONSIBILITIES:

As database administrator I performed the following database monitoring.

24 x 7 Database production support and development support

Clone database for developers and testers

As a dba I have performed

Database monitoring

Table space Management

Extent Management

Rollback Segment Management

File system management

Checking Alert logs for ORA- errors

I/O monitoring

Redo log monitoring

Tuning memory structures such as shared pool and buffer cache by querying various dynamic performance tables..

Backup using RMAN

Worked on Data Guard

Export/Import

Creation of Database and configuring the database for Development/Production database.

ARIG – ARAB Reinsurance Group (Apr 2004 – Feb 2005)

CLIENT DESCRIPTION:

The client is a Insurance client whose is having the GLOBAL presence. The main business is re-insurance with the other Insurance players

ROLES AND RESPONSIBILITIES:

Development in forms 6.0

Development in Report 6.0

PL/SQL coding

Fine tune application.

Contact this candidate