KAILASH CH Behera
Phone- +91 9937782314/983845190 E-mail :
Experience
Total IT Experience -
Have been working as a Project Manager(Data Warehousing), with an IT experience of 8 years which includes 7 years in Data Warehousing, 5.5 years of client site (on-site) implementation engagement, 2.5Project Lead/Management experience in various accounts in India and overseas.
Satyam Computer Services Limited (1998-2002) – India, Malaysia, Singapore
Wipro Technologies (2002-2004) – India, USA, Switzerland
Development Bank of Singapore(2004-2004) - Singapore
HCL Technologies (2004-2005) – India
Arrk Solutions- RAC (2005- continuing) – UK, India
Managerial Experience -
Project Manager (Data Warehousing) in UK, India managing 2 project streams and 4-5 projects (at different points of time) while operating from client site & managing team comprising team members from both client (European) and the vendor (Indian) sides.
Independent Vendor Facing Manager (DBS Bank, Singapore)
On-site-Off-Shore task management (Wipro, Client-Thames Water, UK)
TL (Wipro, Client-UBS, Switzerland)
Experience in Quality Usage (SEI CMM, ISO, BS7799), Project Estimation, Scooping (Wipro, Client-Entergy, USA).
Good grasp on banking domain & projects. E.g. worked for 3 banks, i.e. Swiss Bank (UBS), Zurich, Hong Leong Bank, Malaysia & DBS Bank, Singapore, all of them at client sites.
Participated in pre-sales support (Wipro, Switzerland).
Project Accountability - Directly responsible for the delivery and implementation of Data Warehouse solutions for the client worth 48 M GBP.
Largest Team Handled- 19 member in UK, 23 in India, involving people from different races.
Technical Experience -
Implemented projects primarily using Informatica (Powercenter 1.7/5.1/6.0/6.2/7.0), Teradata Utilities V2R4/V2R5, Secure Shell, UNIX shell scripts (K Shell), Trillium (Data Quality), PERL, Tivoli, Autosys (enterprise scheduler), Oracle 8i/9i(certified), Teradata with O/S as Windows 95/98/200/NT/XP, Unix (Sun Solaris, MP RAS) environments.
Conversant with cutting-edge warehouse design/implementations like (top-down, bottom-up) following Kimbel/Inmon methodologies, building/maintaining Foundation Data Warehouse (FDW), Enterprise Data Warehouse (EDW), Real /Near Real Time Data Warehouse (RTDW) and Active Data Warehouse/Data Marts.
EDUCATION
BE (Electronics & Telecom Engg), UniversityCollege of Engineering, Burla, India (1998). 1st Division.
Project Details
Arrk Solutions, (UK, india)
PROJECT: Customer Data Warehouse (CDW) (Feb ‘2005- Till Date), Client: RAC,UK
ROLE: Project Manager
Handles 2 project streams (Support and Development) of Data Warehouse division with a team size of 19 people (4 projects) for RAC (Royal Automobile Club, UK).
The development team work on 2 projects for RAC (Royal Automobile Club, UK) and one ETL upgrade project form Informatica 6i to7i.
The Support team work on 2 projects , i.e. a. Fault Fixing and b. on-call (24*7 ) maintenance.
The nature of work involves Project Planning & Implementation, KAP (Knowledge Acquisition Process) Management, Risk Mitigation, Defect Prevention, Effort Estimation, Client Management, Quality Assurance, Communication & Escalation Mechanism, Change Management, Team Management & managing an offshore-onsite development environment. Managing Data Warehousing Support (24*7) / Maintenance work (On-call, Fault Fixing). Managing people belonging to variety of cultural zones (Indian & European). Accountable for projects worth GBP 48 M/year.
Environment –Oracle 8i, 9i, DB2, Informatica Powercenter 6.2/7.0, BO, ErEin, Remedy, UNIX, Windows NT, PBN, MPP.
HCL Technologies (india)
PROJECT: RAT (Nov ‘2004- Feb’2005), Client: R&D (Products), India
ROLE: Project Leader (Technical)
Conceptualizing, designing & complete ownership of the RAT project. Worked as a Solution Architect for the project, that uses Erwin, Informatica, ASP, and Oracle. Techno-personal management of the team of 13 members including 2 TLs. Resource management.
Development Bank of Singapore (Singapore )
PROJECT: Foundation Data Warehouse (Apr ‘2004- OCT’2004), Client: DBS Bank, Singapore
ROLE: Technical Manager (S) (CSS)
Designing the ETL with a team of 8 including 2 MT (Management Trainees). ETL lead (informatica). Owner of teradata automatic script generator process for ETL. Interfacing the Data Warehousing vendor, NCR Team. Acceptance testing of the warehouse. Time management, work tracking of FDW team.
Wipro Technologies (india, switzerland, USA)
PROJECT: Zurich Central Accounting Logic (ZCAL) Feed Development Project (Apr ‘2003- FEB’2004), Client: UBS AG, Switzerland
ROLE: Tech Lead (Associate Consultant)
On-site coordinator (technical) from UBS, Zurich to interact with the UBS, Singapore, UK (on-site), India (off-shore). Managing 2 member team at on-site, 7 member-offshore. Implemented secured ETL part for Zurich segment using Informatica Powercenter. Debugging, Testing the ETL process. Reengineering the existing ETL system (UNIX, PERL) with Autosys, Informatica, and UNIX. Implementing the ETL process. Interacting offshore team.
Delivering Pre-sales support(technical) for Wipro, Switzerland, bagged Credit-Suisse, UBS (UNIX maintenance) account. Worked as a Brand Ambassador for Wipro, Europe.
PROJECT: Thames Water Data Warehouse (Dec ‘2002-Apr ‘2003), Client: Thames water, UK
ROLE: Tech Lead (Associate Consultant)
Re-conciliation of data. Managing the crisis of missing data. Optimizing ETL, planning & redesigning ETL activities (informatica, oracle) to overcome ETL bottlenecks.
PROJECT: Entergy Retail & Utilities Data warehouse (Oct ‘2002- TO Dec ‘2002), Client: Entergy, New Orleans, USA
ROLE: Project Leader (Associate Consultant)
Scooping of the project, risk analysis, mitigation of the warehouse implementation using Informatica & Business Objects. Preparing requirement specification document, project planning & conceptual universe design of Business Object. ETL task design with InformaticaPowerCenter, NCR Teradata.
PROJECT: TRANSCO MIS Data Warehouse(From Aug ’02 – To OCT ‘02), CLIENT: Transco, UK
ROLE: Tech Lead (Associate Consultant)
Planning, design, development, deployment & implementation of the whole ETL process using OWB. Work for data Quality Analysis. Complete ETL design, developing Transformation Rules. Preparing Test Plan, Test Cases, reviewing maps, ETL codes. Offshore team leader for a group of 3 people. Later testing Team Leader for a 5-member team. Interacting on-site team, client. Ensuring team deliverables. Unit testing.
Satyam Computer Services Limited (india, malayasia)
PROJECT – HLFG DW (Hong Leon Finance Group Data Warehouse) (From Jul ‘ 01 – To Aug ‘02), CLIENT: Hong Leon Bank, Kuala Lumpur
ROLE: Technical Consultant (Senior Software Engineer)
Making Data Quality Analysis, preparing EDI (Early Data Inventory-Design Document) with details about the source system & source data. Designing Source Map, preparing EDI (Early Data Inventory), writing Transformation Rules/ Business Logics. Writing Teradata Fast Export, Fast Load, Multi Load scripts with Queryman, teradata utilities.
PROJECT – Spectrum (ERP Data Warehouse) (FROM Jan’01 – To July ‘01), CLIENT: Spectrum (R & D)
ROLE: Technical consultant (Senior Software Engineer)
Identifying the KPAs, KPIs for HR module of the project. Preparing LDM for HR part. Developing transformations, business rules, mappings for automated ETL process using oracle stored procedure & Informatica power center.
PROJECT – SRA Data Warehouse (FROM Aug ‘99 TO Dec ‘00), CLIENT: State Railway Authority, New South Wales, Australia
ROLE: Technical Consultant (Senior Software Engineer)
Create the mappings using Oracle Warehouse Builder. Developing transformations stored procedures. Extracting, Transforming Data as per design specs given from client side & loading to target. ETL deployment with informatica, creating sessions, scheduling, running & testing the ETL output.
PROJECT – EBG ERP Project (FROM apr ‘99- TO Jul’99), CLIENT: Emirates Bank Group, Dubai
ROLE: Technical Consultant (Software Engineer)
Working on the payroll part of Oracle 11i (HRMS) as a technical consultant. Developing forms using Forms 6i. Developing APIs.
ROJECT – IBROS 2.0 –Accounts (Integrated Branch Operating System) (FROM Aug ‘98 – To Apr ‘99), CLIENT: Sharp, Japan
ROLE: Team Member (Software Engineer)
Preparation of User Requirement Documents, High Level Design, Detail Design, Construction Coding, Unit testing, Integration Testing & System Testing. Doing Construction Coding, Unit testing, Integration Testing & System Testing using VB, Oracle.
Kailash Chandra Behera 1