Tel: +44 (0) 2079890750

Global Recruitment Experts

Access to millions of CV's and
thousands of international jobs

CV, Experienced Datawarehouse consultant seeks work in UK or Australia

I am currently available for work
Serial No: 9210

List top 5 skills: cognos, data modelling, informatica, oracle sql, pl/sql, UNIX
Short Bio:

Over 9+ Years of Experience in IT industry.
I am a datawarehouse consultant with hands on expertise in ETL tools like Informatic, Cognos Data Manager and Cognos TM1.
I am also expert as a BI Consultant with hands on expertise in report studio, query studio, powerplay transformer.
I am Oracle trained & certified and holds OCP (Oracle certified programmer) certification.
I holds Cognos TM1 developer certification.
I am trained in various tools like Informatica & CA Erwin data modelling tools.
I am also expertise in data modelling & Dimension modelling.

Current location: 

Maharashtra, India - View on map

Spoken languages: 

english, Hindi

Locations I am interested in working:

Australia, Germany, United Kingdom, United States



Expertise:

 Expertise in ETL (Informatica 8.5/9.0/, Cognos 8.3/8.4 Data Manager, Frame Work Manager)

 Expertise in data Extraction, transforming and Loading using Informatica 8.6/9.0.

 Created mappings, reusable transformations, mapplets, worklets, workflow scheduled Informatica workflows using INFORMATICA.

 Created deployment groups for migration in INFORMATICA.

 Expertise in Dimension modeling using Cognos data manager & Informatica.

 Extensively worked on Data warehousing(OLAP) tools including Cognos PowerPlay Transformer, Framework Manager, Query/Analysis/Report studio)

 Hands on experience on Informatica Power center 9.0

 Worked on Job scheduling using Cognos Connection.

 Worked on UNIX Shell scripting to automate data warehouse jobs.

 Extensively Design and developed workflow in Informatica

 Experienced in software development life cycle.

 Excellent analytical skills to understand the business process and functionality

 Developed Use case specifications & Test Plan using (Fitnesse)

 Create dimensional model using CA ERWin.

 I was project lead for 4 years and handled a team of 6-8 members.

Certification

• Informatica(TCS In House certification)

• OCP Certified by Oracle.

• C, C++ (NIIT Certified Programmer)

• CA Erwin R9 trained

Professional Experience

Dec’ 10 – Dec’ 13

Working as Assistant Consultant with Tata Consultancy Services, Mumbai

May ’10 –Dec’ 10

Worked as a Assistant Manager with HSBC Electronic Data Processing India Pvt Ltd, Gurgaon

Sep’06– Apr ‘10

Worked as a software developer with Zenith Software Pvt. Ltd, Bangalore

Aug ‘05 – till Aug ‘06

Worked as a Technical Intern with Intel Technologies India Pvt. Ltd, Bangalore

Jan’04– Apr’ 05

Worked as a System Analyst for Meta-I Technologies (P) Ltd, Bangalore

Job Profile

Project : AEGON

Designation: Technical Architect

Period : Jul 2013 – Dec 2013

Client : AEGON UK Corporate Services Limited

Team Strength: 5

Description:

AEGON is a multinational life insurance, pensions and asset Management Company headquartered in the Hague, Netherlands.

AEGON’s businesses focus on life insurance and pensions, savings and asset management products. The group is also active in accident and supplemental health insurance and general insurance, and has limited banking activities.

Responsibilities:

 As a technical designer, I am responsible to design the new system

 Create Business system documents (BSD).

 Create Technical specification documents (TSD).

 Create dimensional model using Erwin tool.

 Develop ETL process using Cognos Data Manager.

Tools and Languages:

CA Erwin data modeling, Cognos Data Manager, Oracle 10g, Report Studio

Project : Hasbro AMS – BI – IN

Designation: Assistant Consultant

Period : Jan 2013 – Jun 2013

Client : HasBro

Team Strength: 5

Description:

Hasbro Inc. (formerly Hassenfeld Brothers) is an American multinational toy and board game company. It is one of the largest toy makers in the world. The corporate headquarters is located in Pawtucket, Rhode Island. The majority of its products are manufactured in East Asia.

Responsibilities:

 Design and develop Deployment groups for test and production migration using Repository manager in Informatica 9.1.0

 Monitor jobs using informatica monitor.

 Analysis defects, job failures & fix the data defects and make sure schedule jobs runs without failures.

Tools and Languages:

Informatica 9.1.0, SQL Server 2008

Project : UTi Cognos Data Manager Off

Designation: Assistant Consultant

Period : Jun 2012 – Jan 2013

Client : UTi

Team Strength: 3

Description:

UTi is an industry-leading, non-asset-based supply chain management company that delivers competitive advantage to our clients’ supply chains. With innovative, integrated solutions configured to your specific requirements within any major vertical market, we can design, manage and service your supply chain efficiently and cost-effectively. UTi’s global footprint of 350+ offices and 240+ logistics centers in 50+ countries enables us to develop and implement client-centric, global solutions with primary services that include:

•Air and ocean freight forwarding

•Contract logistics

•Distribution

•Customs brokerage

•Managed transportation services

•Supply chain analysis and consulting

Responsibilities:

 Design and develop new dimensions, dimension builds, fact builds,

 Jobstream using Cognos Data Manager.

 Created mappings using Cognos Data Manager.

 Support and monitor data load jobs.

 Support and maintain financial data loads.

Tools and Languages:

Cognos 8.4 Data Manager

Project : The Children’s Place Offshore

Designation: I.T. Analyst

Period : Jan 2012 – Jun 2012

Client : TCP

Team Strength: 3

Description:

The Children’s Place (TCP) is an American specialty retailer of children’s apparel and accessories founded in 1969. It’s headquartered in Secaucus, New Jersey, and currently has 5,000 full-time employees. Children’s place stores are divided into five specific size ranges sections: Big Girls, Big Boys, Baby Girls, and Baby Boys & Newborn. Most of the stores are located in and around regional malls, strip centers, outlets and street stores and also in big box format.

Responsibilities:

 Gathering of requirements from the various systems business users.

 Communicating with the business users to understand business requirements clearly

 Conducting meetings with the data architects to understand the source system elements.

 Worked on loading of data from several flat files sources to staging area using Informatica

 Created reports, scorecard and dashboards using Cognos Metric studio and report studio.

 Preformed data analysis and prepared the physical database based on the requirements.

 Performed data validations.

 Created views and wrote several procedures, functions and packages to handle load process in Informatica using Oracle 9i.

 Worked on tuning and troubleshooting Informatica system at various levels

 Performed unit testing, regression testing and Integration testing.

 Assisted the testing team in developing SQL/PLSQL scripts for automated testing.

 Designed and developed batch files for scheduling the batch load using Informatica and Unix shell scripts

 Created job schedules to run the reports in Cognos Connection.

Tools and Languages:

Cognos BI (Report Studio), Informatica

Project : Eaton Corporate BI Offshore

Designation: I.T. Analyst

Period : Dec 2010 – Jan 2012

Client : Eaton

Team Strength: 4

Description:

Eaton is a global technology leader in diversified power management solutions that make electrical, hydraulic and mechanical power operate more efficiently, effectively, safely and sustainably.

Responsibilities:

 Gathering of requirements from the various systems business users.

 Communicating with the business users to understand business requirements clearly

 Conducting meetings with the data architects to understand the source system elements.

 Worked on loading of data from several flat files sources to staging area using Informatica

 Created reports, scorecard and dashboards using report studio.

 Preformed data analysis and prepared the physical database based on the requirements.

 Performed data validations.

 Created views and wrote several procedures, functions and packages to handle load process in Informatica using Oracle 9i.

 Worked on tuning and troubleshooting Informatica system at various levels

 Performed unit testing, regression testing and Integration testing.

 Assisted the testing team in developing SQL/PLSQL scripts for automated testing.

 Designed and developed batch files for scheduling the batch load using Informatica and Unix shell scripts

 Created job schedules to run the report in Cognos connection.

Tools and Languages:

Informatica 9, Cognos BI, Oracle

Project : HSBC (Global Finance Operations)

Designation: Assistant Manager

Period : May 2010 – Dec 2010

Client : HSBC

Team Strength: 10

Description:

HSBC is one of the largest banking and financial services organizations in the world. HSBC provides a comprehensive range of financial services to around 100 million customers through four customer groups and global businesses: Personal Financial services (including consumer finance), Commercial Banking, Global Banking and Markets, and private Baking.

Responsibilities:

• Design and develop new dimensions, cubes, processes, replicators & chores and support of Cognos TM1 applications.

• Analyze business requirements and develop technical solutions.

• Created rules using TM1 rules SKIPCHECK, FEEDERS & data spreading technique to apply business logic to the cubes.

• Created a Drill through process.

• Created technical documentation of TM1 applications and data flow of information across systems.

• Reviewed current reporting architecture and make recommendations for improvements.

Tools and Languages:

Cognos TM1, Ms Excel.

Project : SpareBank1

Designation: Software Engineer

Period : Sep 2006 – Apr 2010

Client : SpareBank1

Team Strength: 20

Description:

SpareBank1 is a Norwegian savings bank supplementing the banks with securities and insurance. Companies group includes mutual fund, life insurance, the credit card company, the commercial bank and the car finance company. This project requires development of modules for investment banking and creating responsive and reliable banking products.

Responsibilities:

• Developing the ETL process in Informatica, Cognos (Data Manager), Packages in framework Manager Tool according to technical specifications.

• Design and Develop OLAP cubes using PowerPlay transformations.

• Importing source and target tables from their respective databases.

• Preparing the documentation for the mapping according to the designed logic.

• Writing Shell script and running jobs in UNIX

• Involved in database maintenance and handling database change request.

• Create reports using report studio & business objects.

• Create unit test plan and document the process.

• Create life cycle testing process and document the process.

Tools and Languages:

• Oracle 9i, PL/SQL, Unix, Informatica,Data Manager, Frame Work Manager, and Cognos BI tool Report Studio.

Project : Automating hiring Process for Intel Technologies (P) Ltd

Period : Aug 2005 – Aug 2006

Client : Intel Technologies India Pvt. Ltd

Team Strength: 10

Description:

Analyze, Design, Development of hiring tool. The system is capable of performing Candidate search & selection, scheduling interviews and determining recommended date of joining. The system has extensive reporting capabilities including generation of offer letters, offer requisition, offer related reports, metrics & indicator and dashboard reports & Analysis.

Responsibilities:

• Analysis & Development of hiring tool. Creating dashboard reports.

• Perform gap analysis on the product developed.

Tools and Languages:

• ASP.NET, SQL, Oracle9i, Ms Excel, Business Objects.

Project : Institution Management System for Meta-I Technologies (P) Ltd

Period : June 2004 – Jul 2005

Client : EEP department at IIM-B

Team Strength: 5 (3 Technical + 2 Operations)

Description:

Analyze, design and development of management information system capable of handling all-round

Department tasks such as Program Proposals, Registrations, Budgets & Expenditures, Payments,

Accommodation Moderation, Room Inventory Maintenance, Time Table Tracking, Faculty & Program

Evaluation and so on, with extensive cross-module process validation constraints and role-based user

authentication during all system interactions. The system has extensive Reporting capabilities including

Backtracking into Historical Data to enable decision making, and features such as Authenticated

Workspaces facilitating shared areas to which access for other users as determined by the owner-user.

Responsibilities:

• Design, Develop & Testing

Tools and Languages:

• ASP.Net, HTML, JavaScript, SQL Server 2000, Crystal Reports 8.0

Project : Office Management System for Meta-I Technologies (P) Ltd

Period : January 2004 – May 2004

Client : Meta-I Technologies (P) Ltd

Team Strength: 5 (3 Technical + 2 Operations)

Description:

Analyze, design, development of a office information system capable of handling all-round department tasks such as employee details, Budgets & Expenditures, Payments, Leave details, Employee performance details, Employee project details and description, Employee salary details and so on, with role-based user authentication during all system/company’s interactions.

The system has extensive Reporting capabilities including backtracking into Historical Data to enable decision making

Responsibilities:

• Analysis, Database Design, Design & Development.

Tools and Languages:

• Visual Studio.Net, ASP.Net, VB.Net (for the components), HTML, JavaScript, SQL Server 2000, Crystal Reports 8.0

Educational Qualifications

Degree: B.E. (Information science)

University: Bangalore University

Institution: Dayananda Sagar College of Engineering

 

 

 

 

Technical Skills

 

Operating System: UNIX, Windows 2000 Server, Windows XP

Databases: Oracle9i, SQL Server 2005, MS Access 2000

Web Technologies: Forms9i, ASP.NET, ASP 3.0

Languages: SQL, PL / SQL, C, C++

GUI: Visual Studio .NET (Visual Interdev 7.0)

Testing Tools: WinRunner, Fitnesse

Other Tools: Cognos Data Manager, Framework Manager, PowerPlay

Transformer, Cognos TM1, OLAP, Data Mining (Clementine)

Scripting Languages: Shell Script, VBScript, JavaScript

Mark-up Languages: HTML

Reporting Tools: Cognos Query/Analysis/Report Studio,

Reports9i, Crystal Reports 8.0

ETL Tool: Informatica Power Center 9.0, Cognos Data Manager, Cognos TM1