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
