Professional Summary

Dynamic and proactive IT consultant with more than 9 years of IT experience in Analysis, Design, Build and Implementation of several data warehousing projects.

Have experience in different roles like Project Lead, senior Teradata/ETL Developer, Data Modeler, Module Lead.

Have strong experience in Database Design, Development and business intelligence in Teradata, Oracle, Microsoft SQL Server and worked in several OLTP applications.

Strong technical expertise in SQL query tuning, Teradata utilities like TPT, Fast Load, BTEQ, Multi Load, Fast Export; and UNIX shell Scripting and expertise in other ETL technologies like Informatica Power Centre tools, Abinitio and SQL Server Integration Services (SSIS).

Excellent experience in interacting with Business and IT cross-functional teams to define & improve business process, strong ability to understand business work flows and defining & documenting scope.

Experience in end to end BI solutions (requirement gathering, analysis, technical design, build, unit testing, system integration testing, production deployment).

Well versed in working in software development methodologies like Waterfall & Agile.

Work Profile

Cognizant Technology Solutions – From July, 2011 to March 2017 designated as Associate projects

Infosys Limited – From June, 2007 to May, 2011 designated as Technology Analyst

Technical Profile

RDBMS

Teradata 13.0,15.0, Oracle 10g,11g, SQL Server

Tools

Informatica Designer, Workflow monitor, Workflow Manager, AbInitio, Tableau, OBIEE, HP Quality Centre 10.0, UC4, Maestro, Autosys, Erwin

Operating Systems

Windows 9X/2000/XP/7/Unix

Languages

PL/SQL, T-SQL, C, C++, C#, .Net, Java

Web Technologies

HTML, Java Script

UNIX

UNIX Shell Script

Effectively utilized Teradata BTEQ/Unix scripts to streamline the ETL loading process and enhanced the performance using parallelism logic.

Thoroughly proficiency in SQL, T-SQL programming and PL/SQL development in Oracle/Teradata, Data Modelling, Designing of Logical and Physical DataMart.

Have extensive knowledge in creating oracle PL/SQL procedures/macros/functions/triggers.

Worked extensively in performance tuning of the production long running queries/jobs in SQL server, Oracle and Teradata environments which has tremendously improved the system performance

Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes.

Poses good amount of knowledge on Hadoop architecture and trained in map reduce programs and in AWS database service.

Worked as a physical data modeler in creating the data warehouse and dimension models by translating the logical models into appropriate physical entities to generate the database schema.

Automated the ETL error handling features with the help of UNIX shell scripting to trigger mails

Worked as a view modeler in designing and developing complex report views for OBIEE and have designed several re-usable logics for complex cashbook report dashboards.

Completed Teradata and Informatica initial level certification

Worked extensively in performance tuning of the production long running queries/jobs which has tremendously improved the system performance.

Recent Assignments

1.PROJECT DESCRIPTION:

Project Title

Tech Strategy Finance Program

Duration

May 2015 to Dec 2016

Location

Enfield, Connecticut, US

Hardware

Teradata Server

Operating Systems

Unix

Database and Tools

Teradata, Informatica, OBIEE, Erwin

Other Utilities

Teradata Fastload, Multiload, Fast export, TPT

In MassMutual, the Tech Strategy Finance Program is being launched to support required FMT Finance business functions on new Tech Strategy platforms and ensure business continuity. The Finance program will provide solutions to Cash Accounting and Controls via, creating a pre-balance reconciliation for trades, cash, suspense and provides the option for the automated reconciliation process and views for financial transactions & distributions.

ROLES AND RESPONSIBILITIES

Performed roles as physical data modeler, View Modeler.

As a physical data modeler involved in the creation of data warehouse model by translating the logical model into a physical model and adding the appropriate physical objects needed for database creation e.g. indexes.

Maintaining the repository and generating data definition language (DDL) used to create the database objects

As a view modeler involved in complex view creation for all the cashbook OBIEE reports

Scrutinizing the data in all the interfaces and produced many analysis reports to the business partners.

Have automated the ‘Load-Lite’ process which involves in loading the target tables from files which requires less/no transformation from the source file using UNIX/TPT and control table approach.

Responsible for delivering the project on time without any delays.

2.PROJECT DESCRIPTION:

Project Title

Campaign Management System

Duration

Apr 2014 to Apr 2015

Location

Chennai

Operating Systems

Unix

Database and Tools

Microsoft SQL Server, SSIS, SSRS

ROLES AND RESPONSIBILITIES

Have involved in Planning, Defining and Designing database based on business requirements

Involved in preparing estimates and project plan (excel based) on the project deliverables.

Developed logical and physical data models for schemas using MS Visio.

Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate and other transformations to extract, transfer and load (ETL) data.

Was responsible for Design, review, and creation of primary objects such as tables, views, indexes based on logical design models, user requirements and physical constraints.

Have developed SSIS Packages to extract, transfer and load data from flat files to SQL Server using Business Intelligence Development Studio.

Worked on the performance improvement of the SQL queries by defining proper clustered/non-clustered indexes and by several best re-write options.

Scheduled jobs to run the SSIS packages on daily basis using SQL Server Agent.

Developed single value and multi valued parameterized reports for Business Users using Microsoft SQL Server Reporting Services (SSRS).

Have been a part of Code review team and mentored the team members.

3.PROJECT DESCRIPTION

Project Title

3M DWS

Duration

May 2013 to Mar 2014

Location

Chennai

Hardware

Teradata Server

Operating Systems

Unix

Database and Tools

Teradata, Oracle, AbInitio

Other Utilities

Teradata Fastload, Multiload, Fast export

3M’s existing database environment uses Teradata or SQL Server as the back end and Abinitio for ETL operations. The requirements are issues relating to existing applications in terms of performance. The motive is to focus on the badly performing and highly skewed queries which are triggered from the reporting environments such as from BOXI or qlikview and the batch queries getting triggered from MVS jobs.

ROLES AND RESPONSIBILITIES:

Focused on query tuning and optimizing the poorly performing queries and validating them and implementing those queries into the production system.

Developed highly generic graphs to serve the instant requests from the business and worked in highly parallelized (MPP Solution) Ab initio environment to process 1+Tera bytes of data daily.

Responsible for cleansing the data from source systems using Ab Initio components such as Join, De-dup Sorted, De-normalize, Normalize, Reformat, Filter-by-Expression, Rollup

Used Toad to verify the counts and results of the graphs

Responsible for managing the BOXI report queries performance tuning

Mentored the team for sorting out the performance related tickets with a quick turn-around.

4.PROJECT DESCRIPTION

Project Title

PayPal IMD DW

Duration

Jan 2012 to Dec 2012

Location

Chennai

Hardware

Teradata Server

Operating Systems

Unix

Database and Tools

Teradata, UC4, Informatica, JIRA (issue tracking tool), WinSCP, putty

Other Utilities

Teradata Fastload, Multiload, Fast export

Archival Project in PayPal: This project deals with creating SCD type 4 history tables to accommodate the changes happening for every merchant data. To achieve this incremental data is populated in a work table and it is compared with final table. After comparison, the same is flagged appropriately. Then the flagged data will be inserted/ updated in the final table.

ROLES AND RESPONSIBILITIES:

Involved in identifying functional gaps, interacting with cross-functional team and requirement gathering and data analysis.

Worked extensively as a data modeler to understand, design and implement the logical and physical data models for the archival system.

Have involved in requirement analysis and design and involved in UNIX/Teradata/Informatica code/mappings development

Involved extensively in system testing/UAT environment and provided appropriate business solution for gaps/bad data in data warehouse.

Actively involved in all the meeting communication with the on-site team and coordinating with testing team.

Have been a part of Code review team and mentored the team members.

Involved in the activities related to Code migration from QA to UAT to Production, version control of the code files using subversion tool.

5.PROJECT DESCRIPTION

Project Title

eBay

Duration

July 2011 to Jan 2012

Location

Chennai

Hardware

Teradata Server

Operating Systems

Unix

Database and Tools

Teradata, UC4, Informatica, JIRA (issue tracking tool), WinSCP, putty

Other Utilities

Teradata Fastload, Multiload, Fast export

Harmony Marketing in eBay: It deals with various programs to attract the buyers and to promote the revenue in different ways. Based on the type, the various programs are categorized into three groups such as Rewards, Reward Boosters and Coupons. As part of Harmony DW team, the past ten years of data stored within the data warehouse will be compared and analysed with the revenue that eBay is making out of these special programs in-order to identify the profit they are building year over year.

ROLES AND RESPONSIBILITIES:

Have effectively utilized Teradata BTEQ Scripts in eBay and enhanced the performance.

Have involved in requirement analysis and design and involved in UNIX/Teradata/Informatica code/mappings development

Developed scripts using Abinitio wrappers and configuration files and created jobs using UC4 as per the requirements.

Have been a part of Code review team and mentored the team members.

Involved extensively in Unit testing/system testing and provided the fix for bad data in data warehouse.

Maintain data history and restructure the data to improve performance.

Actively involved in all the meeting communication with the on-site team and coordinating with testing team.

PREVIOUS PROJECT PROFILE

Company Name

Infosys Technologies Ltd

Duration

Jun 2007 – May 2011

6.PROJECT DESCRIPTION

Project Title

Associate Data Information Management(ADIM) – HRIS loads & development

Duration

Nov 2007 – Feb 2009

Location

Infosys Limited, Chennai

Hardware

Teradata Server, SAS Base

Operating Systems

Unix, Mainframes

Database and Tools

Teradata, Oracle, SQL Server, Abinitio,Autosys, Maestro

Other Utilities

Teradata Fastload, Multiload, Fast export

This project involves in the comprehensive collection of the Bank’s associate and contractor’s information for convenient access. Data is received from several External vendors and internal sources. ADIM receives these files from Fidelity (SOR) and loads these data to the raw, history and Model tables. ADIM provides data to over 200 different downstream systems within BAC via exposed table/view (for pull usage by downstream applications) or extract files (for the push of data out to downstream applications). ADIM also supports direct online user access reporting environment offering direct database query and real-time access to more then 5000 users.

ROLES AND RESPONSIBILITIES:

To write efficient queries that retrieve data from various tables. To tune and optimize the code so that it takes minimum time and resource to execute

Created code snippets for re-use within project and involved in maintenance programming and rectification of identified defects

Responsible for cleansing the data from source systems using Ab Initio components such as Join, De-dup Sorted, De-normalize, Normalize, Reformat, Filter-by-Expression, Rollup

Have ensured practices like coding standards, technical documentation standards, QA processes, configuration management, Create, document, and implement unit test plans, scripts, and test framework.

Coordinated with onsite and bringing design issues upfront and reduced the impact due to design issues at later stage in the development cycle.

Preparing the project plans and other artifacts for ADIM outbound extracts/views/reports

Have tested and reviewed the impacts of each interface to the atomic level

7.PROJECT DESCRIPTION

Project Title

Wholesale Credit Risk Modeling (Bank of America)

Duration

Mar 2009 – May 2011

Location

Infosys Limited, Chennai

Hardware

Teradata Server

Operating Systems

Unix

Database and Tools

Teradata, Oracle, SQL Server, Autosys, Maestro, Informatica

Other Utilities

Teradata Fastload, Multiload, Fast export

PROJECT DESCRIPTION:

Data warehouse development/maintenance for the largest bank in the United States (BANK OF AMERICA): The Wholesale Credit Risk Model (WCRM) was developed to consolidate credit information for use in monitoring and measuring credit risk within the Bank. The WCRM has been developed in Teradata using a Star schema approach to store the Wholesale credit risks data for efficient data storage, retrieval and maintenance. The WCRM model aims at improving the performance of managing (data storage & retrieval) Credit Risk Information and reducing the maintenance required. WCRM constitutes Data model and downstream modules. Data model is process of loading required data in star schema - which will be used for reporting purposes. ETL tool used in "Data model" are BTEQ/UNIX scripts, FEXP/MLOAD control files which are scheduled using Autosys.

ROLES AND RESPONSIBILITIES:

Worked in "Merging" process - When bank acquires any financial institution, credit risk data should be merged to banks credit risk data. The credit risk information of acquired financial institution will be loaded into same star schema (in different database) and will be merged into WCRM database based on the business logic.

Worked in "History Retention" process - Credit Risk information that is maintained in star schema was on monthly basis, with the requirement change to make the model to have "30 days rolling history", design has been changed.

Worked in "Redesign" - The WCRM repository has been redesigned from "surrogate key" concept to "natural key" concept, which required restructuring of all dimensions and facts.

Worked in “Parallelism” – The WCRM database includes around 80 dimensions and 20 facts and these tables were being loaded sequentially. With this parallelism logic, we load a set of 15-20 tables in parallel, based on the spool availability using the control table approach.

Certification Details

Title

Teradata V2R5 Master

Power Centre Informatica designer

Education Details

Qualification

Subject

Year

Bachelor of Engineering

Computer Science and Engineering

2003-2007

Contact this candidate