MARS / EFFEM, NYC through RIS, Toronto (Mar’05-Current)
Role – Data warehouse administration / support

• Develop and administer 20TB data warehouse with complex Informatica mappings, sessions.
• Informatica performance tuning, query optimization, clean up, migration from QA/Production.
• Configure PCMR, produce metadata reports, query repository, monitor and support SLA jobs.
• Create new catalogs, profiles, queries, folders, prompts, power cubes and powerplay reports.
• Environment: PowerCenter 5/6.1, PowerPlay transformer 6.6, series 7 Reportnet, Visualizer, Oracle, Toad, PL/SQL, Maestro, HP-UX 10.20, Tivoli, lotus notes

CIBC, Toronto (Dec’04-Feb’05)
Role – Data warehouse analyst / ETL testing

• Perform analysis on ETL extracts representing intra bank fund transfers for Basel II project.
• Conduct SIT, UAT, compare greek values, delta, gamma, vega, theta values from mappings.
• Study ODS data models, mappings documents. Review ETL logs and produce test reports.
• Environment: Oracle, PL/SQL, DTS, PowerCenter, Visio, Excel, VBA, VB.Net, Solaris, scripts

KCI, India (July’02-Nov’04)
Role – data warehouse developer / team lead

• EDW project management, prepare star schema, dimensional design and review mappings.
• Design data models using complete compare, forward/reverse engineer, naming standards, transforms, design layers, role name, verb phrase, domain features and model mart.
• Environment: PowerCenter6.1, MS-Project, ERwin, AIX, Oracle, Toad, ASP.Net, VB.Net

ITM, NJ (Sept’00-Jun’02)
Credit Suisse First Boston, NY
Role – Data warehouse / Reports development

• Support 30TB EDW for fixed income and derivative reports to serve 5,000 customers.
• Produce yield analysis reports for equity, index, fixed income and money market mutual fund.
• Publish reports analyzing investment opportunities in mutual funds by calculating NAV, fees, back end and front end loads, management expense ratios (MER) and 12B-1 fees.
• Develop Informatica mappings, set up workflows and impromptu catalog administration.
• Environment: Informatica 5, Cognos, Oracle, Toad, PL/SQL, ASP.Net, VB.Net, Solaris, BTEQ

Barnes & Noble Inc, NY
Role – Data warehouse developer

• Initiated 7TB EDW and reports to grow sale of 4.8 million items and manage 700 stores.
• Gather requirements and develop complex mappings using routers, joiners, incremental updates, update strategy, history tracking, debugger and workflow manager, monitor.
• Environment: Informatica PowerCenter6.1, Oracle, Toad, Pro*C, scripts, C, VB.Net