ver 15 years f c mprehensive and in-depth w rk experience in Inf rmati n Techn l gy IT Industry with specializati n and expertise in Data Wareh using and Business Intelligence with implementati n experience in Banking Financial services d main. Banking and technical kn wledge in Enterprise Inf rmati n Management, Business Intelligence and Data wareh use has been practiced with financial instituti ns like BNY Mell n, Citibank, Standard Chartered Bank, Halifax-Bank f Sc tland, Washingt n Mutual Bank, Franklin Templet n, N rthern Trust C mpany and vari us ther Bank / Financial instituti ns as DW C nsultant, Sr. Data Architect and Sr. Data Wareh use/BI Architect. DW implementati ns in vari us functi nal d mains including Basel II perati nal Credit Risk , Fund Administrati n, Credit Cards, HR Inf rmati n Systems etc.

• High pr ficiency in Data M deling, Data wareh use Business Intelligence Design and Architecture.
• Manage 25 direct rep rts acr ss multiple l cati ns including India, US UK in a acc unt 100 ass ciates w rking at ffsh re l cati ns in India.
• Excellent kn wledge and understanding in Had p and N SQL database. Trained in Had p.
• Str ng Database skills with g d experience in racle, Sybase and SQL Server databases.
• Pr ven experience in effectively translating business needs int data centric strategic techn l gy s luti ns.
• Business Requirements c llecti n, d cumentati n and analysis, and techn l gy assessments and translati n f these c ncepts int crisp, f cused and acti nable designs, specificati ns, rec mmendati ns, and g -f rward strategies.
• Deep hands- n experience with the full c mplement f c ntemp rary Data Wareh use Business Intelligence T ls and Techn l gies including DBMSs, Data M deling, ETL t ls, Rep rting and Analytic suites, BI P rtals, Dashb ard and Sc recards and c ntemp rary pr gramming languages.
• Str ng expertise in Data M deling including L gical Data M deling, Physical Data M deling, Data wareh use Design, perati nal Data st re Design, Datamart design and Metadata management.
• Str ng Pr ject Pr gram Management Skills
• Handled large data wareh use database pr jects with High data v lumes.
• Str ng Technical, c mmunicati n, presentati n and team management skills.
• Internati nal w rk exp sure and client management skills.

C re Skills

Pr ject Pr gram Management

Data wareh use Design and ETL Architecture

Data M deling

Data Analysis

Database Design C nfigurati n

Inf rmatica P wer Center 9.0.1

SSIS, SSRS, SSAS

CA Erwin Data M deler v7.3

P wer Designer

racle 11g

Sybase ASE 12.5

SAP Business bjects XI R3

Xcelsius 2008

MS Pr ject 2007

Techn l gy

racle 10g, Inf rmatica P wer Center 9.0.1, Unix shell scripts, Erwin Data M deler, Business bjects XIR3, XCelsius 2008, SSIS, SSRS, SSAS

Pr gram Abstract

perati nal Risk Dashb ard and HR Inf rmati n Wareh use

R le

• Resp nsible f r defining verall data architectures, understand the business bjectives and pr vide s luti ns that efficiently meet the needs in a timely manner with a f cus n data integrity and quality.
• Lead in evaluating requirements and help design an end-t -end integrati n architecture and data m del f r the target data wareh use, staging, and data marts.
• Lead the identificati n and analysis f enterprise business drivers and requirements that drive the future state architecture
• Interacted with key individuals at vari us levels within an rganizati n including client managers/acc unt executives, cust mer leaders, team leads, pr ject managers, etc.
• C ntributed t the devel pment f new Data Inf rmati n pr duct strategies
• Devel ped C nceptual, L gical and Physical data m dels.
• Champi ned the ETL BI architecture.

Pr ject Abstract

Pr ject bjective f GFR is t create a multi-dimensi nal rep rting database t all w standardized and c ns lidated rep rting acr ss all Eur pean TA perati ns.

R le

• Designed, Architected and managed the pr ject res urces.
• Built a star schema m del c mpatible t the business and data d mains.
• Managed wned the delivery f ETL Rep rting design and devel pment
• Resp nsible f r rep rting the perf rmance f the pr ject t the cust mer n a peri dic basis.
• C nducted the requirement w rksh p with the business.

Confidential

Sr. Technical Manager/Seni r Data Architect

Pr ject Abstract

The bjective f the Credit Exp sure M nit ring CEM pr ject is t satisfy regulat r's c mments n N rthern Trust t aggregate the credit exp sure f any given client r c unterparty n an n-demand basis t identify and measure the risk ass ciated with the cust mer.

R le

• Designed and architected the Credit Exp sure M nit ring applicati n.
• Resp nsible in devel ping a scalable data m del using Erwin, t all w the data fr m disparate data s urces and maintain their data integrity
• rganized and c nducted the JAD sessi ns f r the analysis and design phase f the pr ject.
• Resp nsible f r planning, scheduling, res urce augmentati n, res urce planning, risk management and client management. Resp nsible f r the end t end delivery f the applicati n and c - rdinati n with the cust mers in the acceptance f the deliverables.

Confidential

Pr ject Abstract

The visi n f this pr ject is t c ns lidate platf rms f r Campaign executi n acr ss all lines f business.

R le

• Resp nsible f r the delivery f the design, implementati n and maintenance f the system.
• Instrumental in architecting and designing the Enterprise Wareh use f r the H me L ans Direct Marketing.
• Inv lved in the review f the data m del and ther deliverables f the pr jects.
• Inv lved in the perf rmance tuning f the applicati n during the UAT phase f the pr ject and als managed the defects.
• Resp nsible f r identifying the activity definiti ns, durati n estimati n, res urce leveling and change c ntr l.

Confidential

Pr ject Abstract

The Analytical Data Hub ADH Pr gramme f HB S c vers the pr visi n f Credit Risk data t the Analytics team f r BASEL II requirements.

R le

• Resp nsible f r the Technical Design and architecture. The technical and data architecture was arrived at after c nsultati n with the business and technical users f the System.
• rganized and c nducted the JAD sessi ns f r the requirements gathering and design.
• Managed the nsite and ffsh re res urces.
• Resp nsible f r the delivery f the deliverables in all the phases f the pr ject.
• Inv lved in the database c nfigurati n and tuning f the applicati n and the ETL l ads.
• Inv lved in the review f the data m del and ther deliverables f the pr ject.