Subramanian Deepalakshmi

Email: acqq1f@r.postjobfree.com Phone: 961*******

Experience Summary

Dedicated, result-oriented IT professional with 15.5 years of experience in the areas of Project Management, Databases such as Oracle SQL, PLSQL, Performance Tuning, Sybase, Database design and development, Data Modelling, Data warehouse concepts, Data analysis and Database support

Worked extensively across all domains such as Investment Banking, Lifescience, Automobile and Manufacturing

Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies, Oracle database management

Strong working experience in Oracle 8i, 9i, 10g, 11g,12c database programming using SQL and

PL/SQL

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.

Design and create entity relationship diagrams (ERD) for Oracle based applications and interfaces.

Expert in coding complex and advanced PLSQL programs using Oracle’s Object-Oriented programming, collections, records, index-by tables, object types and methods.

Well-acquainted in working with complex SQL queries with joins, date functions, inline functions, sub-queries, Functions, Procedures, Exception handling, Views, Packages, Triggers and Ref Cursors.

Proficient experience in working on conceptual, physical and logical data models (3NF) using Data Modeling tools like ER Studio and Erwin.

Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions, foreign key concepts, referential integrity.

Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers

Exceptional communication and presentation skills and established track record of client interactions

Achievement Highlights:

Created, documented and maintained physical database models in compliance with enterprise standards and maintained corporate metadata definitions for data warehouse within a metadata repository.

Received appreciations from the customer for resolving the issues for the database failed batch jobs in Fraud Management system application with JP Morgan Chase Client

Received customer appreciation certificate from Deutsche Bank for automating most of the processes in data analytics activities by calling the database SQL from excel to generate the error free data which saves 80% of time

Automated the manual testing of business process maps by writing complex SQL queries to identify the errors in the business maps in GBS(Global Business Services) with Deutsche Bank

Drove numerous operational improvements through the implementation of writing complex queries, stored procedures and created many value pack reports to identify the redundant processes with Deutsche Bank

Led application development team and received customer appreciation certificate from Novartis Pharma for successfully delivering the project

Work closely with Product and other technical owners to determine and refine requirements

Designing systems to respond to our business needs

Manage communications and expectations with internal and external customers at all times

Solve problems and resolves the issues related to database queries and performance tuning

Creating database physical and logical design

Writing underlying database stored procedure code to implement functional/technical requirements

Writing unit test cases and create supportive documents and tickets for production deployment

Performing unit and integration testing of software deliverables

Determine level of effort and participate in project planning for the whole software lifecycle including deployment and support

work creatively to the highest engineering standards on challenging and pioneering custom development tasks

Maximize project resource utilization

Team building to supplement the work that is being performed in various db activities

Motivate, train and guide a dedicated team of excellent software developers

Involved in technical evaluation for selection of associates to the team.

Own all aspects of the Software Development Life Cycle, from technical requirements gathering to level 3 application support.

Professional Experience

ASSOCIATE CONSULTANT

TATA CONSULTANCY SERVICES

Nov 2006 to till date

SENIOR SOFTWARE ENGINEER

ROBERT BOSCH INDIA LIMITED

July 2003 to Oct 2006

PROGRAMMER ANALYST

COGNIZANT TECHNOLOGY SOLUTIONS INDIA Pvt. Ltd.,

July 2002 to June 2003

SOFTWARE ENGINEER

HINDUJA TMT LTD

Formerly known as ASHOK LEYLAND INFORMATION

TECHNOLOGY

March 2000 to June 2002

PROGRAMMER

Supersoft solution pvt.Ltd,

September 99’ TO February 2000

Certifications

Brainbench Certifications on Oracle PL/SQL, forms 6.0. and SQL

SII certificate on ‘Introduction to securities and investments’, UK

Technology

Software Products

Tools

Oracle 8i/9i/10g/11g

SQL Server

Sybase ASE 12.5

D2K

SQL PL/SQL

Visual Basic,WinNT,UNIX

PL/SQL Developer

TOAD,DBArtisan

Erwin,ER Studio Data Architect, Wherescape red

VSS,Putty, CVS, SVN,,Ab-initio

Ctrl-M, Quality center,Sparx

Qualifications

Degree and Date

Institute

Major and Specialization

Bachelor of Engineering,

Jun -1998

Sriram Engineering College, B.E 72.8 June 1998

Madras University, Chennai

Electrical and Electronics

Projects

Project

CWE

Customer

Fidelity

Description

CWE is a collection of databases and datamart which contains data about customers, prospects and members. It is fed by a number of systems across fidelity.

Role

As a Data Modeler and database architect

Studied in-house requirements for the Data warehouse to be developed

Solve problems and resolves the issues related to database queries and performance tuning

Creating database physical and logical design

Writing underlying database stored procedure code to implement functional/technical requirements

Writing unit test cases and create supportive documents and tickets for production deployment

Performing unit and integration testing of software deliverables

Applied the datavault modelling design for CWE

Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation

Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy application and transform it in Oracle database systems

Created many stored procedures to do the data transformation logic for the CWE applications

Involved in technical evaluation for selection of associates.

Own all aspects of the Software Development Life Cycle, from technical requirements gathering to level 3 application support.

Solution Environment

Oracle 12c SQL, PLSQL,Unix, Control-M

Tools

Toad

Plsql developer

ER Studio Data Architect 9.5

Wherescape red

Project

Clinical Prism

Customer

GlaxoSmithKline

Description

Clinical Prism is the GSK business intelligence operational reporting solution within the Simplifying Clinical Development (SCD) programme. This caters to the business users, within the R&D space, in a timely and unified manner for their analysis and business decision making.

Role

Data Modeler

Analysed existing Data Model for business requirements.

Enhanced the Physical Data Model (PDM) for operation datastore using ER Studio Data Architect for Creation of database objects

Improved data integrity by adding foreign keys and normalizing the underlying data structure.

Enhance the data model to support the business users for generating reports in Cognos framework

Support the business requirements by enhancing the existing data model

Integrated the work tasks with relevant teams for smooth transition from testing to implementation

Solution Environment

Oracle 11g SQL, PLSQL

IBM Cognos

IBM Infosphere DataStage

Quality Center

Unix

Tools

Toad

Plsql developer

ER Studio Data Architect 9.5

Project

FMS(Fraud Management System)

Customer

JPMorgan Chase

Description

The Fraud Management system is the application used by Chase home finance to check/find for the fraudulent loans.

Role

Database Consultant and Project Leader

Analysed existing logical data model (LDM) and made appropriate changes to make it compatible with business requirements.

Expanded Physical Data Model (PDM) for the OLTP application using Erwin. Creation of database objects

Improved data integrity by adding foreign keys and normalizing the underlying data structure

Performance tuning of SQL queries

Database Code Deployment for each releases in DEV, IST and UAT environments

Support for the business user queries

Prepare the deployment scripts for each release.

Support the database issues in production

Write Unix shell scripts for export/import using data pump feature

Write queries for health check report

Support the post production release issues

Support the application from oracle migration from 9i to 11g.

Support the team in analysis and Fixing the database issues in the application

Training the team in Database tasks

Project Management activities

Solution Environment

Oracle 11g SQL, PLSQL

Microsoft .Net, Erwin Data Modeler,Quality Center

Unix,Control-M

Tools

Toad, Plsql developer

Project

Spark the Sparx

Customer

Deutsche Bank

Description

SPARX the sparx program provides a comprehensive, standardized front-to-back view of global processes (maps) within GBS (Global Business Services) in DB (Deutsche Bank).

Role

Data Analytics Lead

such as

Assignment of tasks to the Team

Performance tuning of sql queries

Creation of SQL queries for the value pack report

Creation of sql queries for the QC team to identify the errors in the maps

Review of SQL Queries

Creation of excel macros to generate the report from excel by connecting to the database from excel and run the sql queries

Project management activities like task assignment and Report review

Problem solving the query issue in SQL

Team Size

4

Solution Environment

SQLServer

Excel 2007 macros

Tools

Enterprise Architect – Sparx_bpm

Microsoft SQLServer Management Studio

Project

JPMCC ETL Testing

Customer

JPMorgan Chase

Description

JPMCC is JP Morgan clearing corporation which does the clearing process of securities. This is a conversion project. JP Morgan was using the external vendor called NFS for clearing process.

Role

Project Leader

System test plan and test cases creation

Execution of system test cases

Generation of test reports

Creation of input data file using ab-initio tool.

Assigning the tasks to the team.

Team Management

Solution Environment

Unix

Oracle 9i

Tools

Toad

Putty

Ab-initio

Ctrl-M

Project

TRC Decommission

Customer

Lehman Brothers

Description

TRC (Trade Reporting and Confirmation system) is a trade reporting and confirmation system in Lehman Brothers.

S2K and TRAX 2 are the two transaction reporting systems in TRC.

Role

Team Leader

Created procedures and temporary tables to decommission the reporting trades from S2K and Trax2 systems in TRC.

Modified the existing validation logic to reject the reporting trades

Involved in unit testing, regression testing and UAT Testing

Release scripts preparation

Production release

Solution Environment

Unix, Sybase

Tools

DBArtisan,Putty

Project

ReviewDB

Customer

Robert Bosch, Germany

Description

Review Database Maintenance is a review tool for all technical reviews and acts as a central database .This tool is applied in the software development life cycle in the GS (Gasoline Systems) division in Bosch.The tool should provide facility to plan review meetings, record the events, findings and actions during the meetings, track actions and findings to closure, monitor and evaluate Review statistics and metrics.

Role

Team Lead

Support for existing system

database activities like creating users,roles and granting roles

Designing the database

Coding using plsql procedure and functions

Testing

Performance tuning

Enhancements & Bug fixes

Production Release

Solution Environment

WinNT,Oracle 9i database SQL, PLSQL,Oracle 9iAS, Java 1.3

Tools

MS-VSS (for source code control)

Project

COBRA

Customer

IMS

Description

COBRA is a generic input system used to convert data coming into IMS from third parties to a common format. The COBRA system is used to deliver data to IMS major reporting systems including Pharmatrend and XTrend, and thus forms a critical

link in the data chain.

Role

Team Member.

Support for existing system

Coding and Testing for enhancement

Solution Environment

Oracle 8i PL/SQL,Power Builder,Basic Script,WinNT

Unix

Tools

MS-VSS (for source code control)

Project

ALMAP - ASHOK LEYLAND MANUFACTURING & PRODUCTION

Customer

Ashok Leyland Limited

Description

ALMAP is Ashok Leyland Manufacturing and Production System. This project consists of 26 Modules.This project is a conversion project which our client wants to convert from mainframe to Oracle.we use Form Builder6.0 used for developing screens, Business logic for the application handled using Triggers, Generic Functions, and Generic Procedures.

Reports were generated using Report Builder6.0 for all types of online Printing reports.

Role

Team member

Coding

Unit Testing

Documentation

Solution Environment

Windows NT,Oracle 8i,Forms 6i,Reports 6i

Tools

MS-VSS (for source code control)

Training / Continuing Education Summary

Program or Course

Coverage

Dates

German Language Training – G1

Read,write,speak

Jan-2004 -Apr-2004

Personal Details

Nationality

Indian

Passport Details

Name as on passport

Passport Number

Date of Issue

Expiry Date

Place of Issue

Subramanian Deepalakshmi

H2149176

Dec 2008

Dec 2018

BANGALORE

Contact this candidate