Datawarehouse Architect - Informatica, Oracle

Sajith Thomas Varghese

Email:******.*****@*****.***

Call: +91-812*******

Professional Profile:

V Expertise of Over 12+ Years of experience in Product Development &

Management, Data Warehousing, Data Modeling, Oracle Database.

V Very Good knowledge & implementation of Dimensional modeling (STAR/ Snow-

flake) and Relational modeling, ETL and ELT Design and implementation in

Informatica/ Oracle PL/SQL.

V Thorough understanding of the SDLC with expertise in mapping client /

business requirements, application design, development, integration,

testing and troubleshooting for complex information systems management.

V Possess sound knowledge of best OLTP and OLAP practices with proven

ability in analysis, design and implementation of 3NF/ Denormalized/

Dimensional model.

V Oracle Database Expert (Database Architecture, Data Modeling, Data

Integration, ETL, Performance Tuning, Data Cleansing, Database

Programming PL/SQL)

V DW Architect: Experience in designing and working on complex data models

and ETL designs. Very good exposure to OLTP / OLAP modeling

V An effective leader with proven abilities in leading teams during the

project phases enabling knowledge sharing among the team

Experience Summary

. Expertise in Data warehousing, DW Design, code optimization, bottleneck

identification, parallelization of jobs. Functional experience includes

right from System study, Analysis, Design (Denormalized/ 3NF/

Dimensional), Coding, Testing & Implementation.

. Extensive knowledge on Oracle SQL, PL/SQL, ERWIN, Informatica 9.1,

Datastage Server Edition, Unix Shell Scripting.

. Code optimization/ performance tuning and implementation of best

practices of ETL Scripting in the applications

. Professional Experience working in the following domains - Pharmaceutical

co-vigilance, Finance & Securities, Telecom, Automotive, Airlines and CRM

related projects.

. Experience in working with open-source software like INGRES and Jasper BI

tools, HTML, ASP and Scripting Languages (Java Script & VB Script).

. Team guidance in BI Architecting- BO Universe creation for set of

standard reports and customization for end user requirements.

Experience Details:

Architect at Thomson Reuters Bangalore (Dec 2010 - todate)

At Thomson Reuters I am involved in architecting solutions and guiding a

team to build a Datawarehouse that gets fed from different sources

accumulating the information into a common denormalized structure before

being fed to the Dimensional DWH. This warehouse is mainly used for Process

analysis to identify which process has bottlenecks and who or which task is

causing it.

Responsibilities:

. DW Modeling (Logical / Physical) (Dimensional and Denormalized) based

on the requirements, ensuring proper documentation exists of the same.

. Informatica 9.1 ETL Mappings, Schedule management and Performance

enhancement of slow running jobs (parallelization/ staging /DB SQL

optimization).

. Implementation of best practices to ETL routines, Code optimization in

Oracle PLSQL using Explain Plans.

. Conversion of requirements to FSD/ UTCD, mapping documents, creation

of workflows, mappings, mapplets, team guidance, estimation to deliver

the requirements on time.

. Requirements analysis and conversion to Datawarehouse and ETL

routines.

Lead - Architect at ArisGlobal Software Pvt Ltd, Bangalore (Feb 2008 - Dec

2010)

ArisGlobal is one of pioneers in the advancement of drug safety, drug

safety monitoring, pharmacovigilance, regulatory compliance, medical

information and clinical trials management software. Their solutions are

designed to help all life sciences organizations facilitate regulatory

compliance and manage risk to improve operational efficiency.

Responsibilities:

. Setting up Best Practices and Coding Standards for the Development

teams

. Physical and Logical Database Design using ERWIN

. Dimensional Modeling, Data mappings b/w source and stage and stage and

target schema, PLSQL Procedures for Business logic implementation

. ETL design and Review using PLSQL/ Infa Powercenter 8.1 and

optimization of ETL Routines/ PLSQL Procedures for better performance.

. Database Designing for Performance & Recovery Strategy which involves

deciding about Logical Storage Structures and Forecasting Future

Expansions and also tailoring - customer requirements

Module lead at Wipro Technologies Bangalore (Aug 2005 - Feb 2008)

At Wipro I have worked on Banking domain (BFSI) projects for State

Street bank (Germany) on FREG (Financial Report Extract Generator) and

Depot-Bank Online Projects which was fed from MCH Datawarehouse and

Bloomberg.

Responsibilities:

. On-Site co-ordination, Estimation, Cost Planning, SOW for new Project.

. Conversion of requirements to TAD/ FSD/ UTCD, modularization of

requirements, mapping document, shell scripting, lead the team to

deliver the requirements on time.

. OLTP / Dimensional Modeling using ERWIN based on the KPI,

documentation of the same and team guidance.

. Informatica Powercenter ETL Mappings, Routine creation, Schedule

management and Performance enhancement of slow running jobs.

. DB Design (Logical / Physical), Project, user management, audit

modules.

. Identifying bottlenecks and optimizing code by providing solutions to

issues in the ETL routines and Oracle Stored procedures.

Implementation of best practices to ETL routines for best performance

(Oracle PL/SQL & Informatica mappings/workflows).

Sr S/w Engineer at Satyam Computers (Tech Mahindra) Chennai (Apr 2003 - Aug

2005)

At Satyam I have worked on Telecom Domain for 3 Mobiles UK / Automobile

domain projects Ford Motors US and Airlines project.

EDW nBilling was a project aimed at gathering billing data of 3G

customers at a common EDW that could facilitate BO Reports. Data from

different sources would be accumulated into a common EDW that was well

tuned and maintained for fast access of reports.

AEIS-Airline Executive Information system was to facilitate an ERP

application for the Airline Industry. This project involved creation of

jobs which would populate the AEIS(Stage / Build / Current) database from

the OLTP DB and jobs to populate report specific tables from the Current

stage. Budget specific Reports /STD Reports and forms were created in

Developer 6i.

Responsibilities:

. Creation of Datastage ETL routines, PLSQL Procedures, Mappings and BO

reports

. Conversion of DS server jobs for multibilling to run for parallelism.

. Identification of bottlenecks and code optimization in Oracle PLSQL

using various techniques

. Creation of Oracle PLSQL Procedures/ Packages for the Business logic

implementation

. Test case preparation and execution of the Test cases using Mercury

Test director

. Creation of time framed reports to identify and make appropriate

decisions to alter business requirements

. Migration of Legacy information into GL/ AR modules of Oracle Apps

. PLSQL PDK portlets, creation of portal interface, content management,

testing & implementation

Sr S/w Engineer at Dhithi Infoserve Bangalore (Sep 2000 - Apr 2003)

At Dhithi Infoserve I have worked on SCM / Compaq Call handling modules /

Finance Modules.

IMAGE - Information Management as Growth Enabler is the one of the

most challenging IT projects taken up by HLL in recent times. This is the

data warehouse that amasses data from all profit centers to a common point

viewed by the managers & planners through tools like OSA & portal. It gives

its users numerous views of the same data to affix results or

responsibility. With Sales and Estimates available, the DW allowed tracking

of key performance indicators.

Responsibilities:

. Involved in implementation of EDW Image at HLL

. Involved in designing the reporting module from the EDW to run on

Oracle Portal. Working with the client (HLL) and help with to

understand the EDW Image.

. Creation, implementation and training of users to use the CRS

application.

. ETL Programming using Datastage Server Edition.

. Leading a team to understand the requirements for VB module and

finding best approach to implement the same.

. Programming ASP / VB modules for Compaq using SQL Server as the

database

Educational Qualification:

B.E. - RV College of Engineering (Bangalore University) - Electronics &

Communication in 1999

PGD in Computer Application - (CDAC Pune) - PG Diploma from Amrita

Institute of advanced Computing Coimbatore. - 2000

Contact this candidate