Profile cover photo
Ahora estás siguiendo a
Error al seguir a usuario.
Este usuario no permite que los usuarios lo sigan.
Ya estás siguiendo a este usuario.
Tu plan de membresía solo permite 0 seguimientos. Mejora tu membresía aquí.
Dejaste de seguir correctamente a
Error al dejar de seguir al usuario.
Has recomendado exitosamente a
Error al recomendar al usuario.
Algo salió mal. Por favor, actualiza la página e intenta de nuevo.
Email verificado correctamente.
Avatar del usuario
Bandera de INDIA
mumbai, india
Aquí son las 5:37 p. m.
Se unió el julio 4, 2010
0 recomendaciones

Rakesh A.

@Rakesh87

0,0 (0 comentarios)
0,0
0,0
0%
0%
Bandera de INDIA
mumbai, india
N/A
Trabajos finalizados
N/A
Dentro del presupuesto
N/A
A tiempo
N/A
Tasa de recontratación

6.4 years of IT experience.... Very good in technology

RESUME Rakesh Agnihotri Mobile-09702792970 Objective: To dedicate upshot oriented hard work in a professionally managed organization that provide scope for learning and innovation exposure to new ideas and thereby promotes growth and development. Summary:  Around 6.3 years of focused experience in Information Technology with 6.2+ years of strong background in Business Intelligence development and Data warehousing.  Data Processing experience in designing and implementing Datawarehouse/Datamart applications, mainly transformation processes using ETL tool Informatica Power Center.  Proficiency in using Informatica Power Center tool to design data conversions from wide variety of source system.  Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.  Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.  Proficient in understanding business processes / requirements and translating them into technical requirements  Proven capacity to meet deadlines  A Team Player with excellent communication, analytical, verbal and writing skills.  Worked in Conversion Project for Australian Gas & Light.  Good understanding in Conversion project Process.  Highly self-motivated and able to set effective priorities to achieve immediate & long-term goals and meet project & operational deadlines  A good team player with belief in taking positive approach towards issue resolution.  Well-developed interpersonal and communication skills, having dealt with diverse professionals, clients & team members  Completed Infomatica Vendor Certification Successfully. Skills Profile: System Design and Development  System Design and Development  Analysis and Requirement Gathering  Designing, Development and Testing  Team Management Operating Systems UNIX, Windows 98/NT/2000/XP Languages, Software and Tools Informatica PowerCenter 8.x, PLSQL Developer, Cognos, Cronacle, CVS, Business Objects XI, Mercury Quality Centre, VB Excel Database Management Systems Oracle 9i, Teradata12,SQL Server Career Profile: o Team Leader :  Project planning estimation & tracking.  Process & people management.  To facilitate teamwork and gain synergy by individual sense of mission, ownership, commitment, accountability, motivation and responsibility.  Customer Communication and Escalation Management. o Offshore Coordinator :  Project Management  Requirement gathering & Analysis  Business Analysis  Acceptance testing support.  Defect management o Informatica Tech Lead :  Development of ETL processes with a good understanding of source to target data mapping  Performance Tuning and debugging of existing ETL processes.  Sound knowledge of RDBMS concepts and Database design.  Unit and Acceptance Testing  Maintenance and Enhancement o Security Auditor- Conducted Security Audit at Account level ensuring 100% Security compliance. o Six Sigma Deployment Lead – Mentored GE -TCS employees in Six Sigma programs and methodologies Educational Qualifications:  BCA with 1st class from MCRPVV University, Bhopal  10+2 1st class with Distinction from MP board  10th 1st class with Distinction from MP board Past Experience: Worked for ‘Tata Consultancy Services Limited.' Mumbai as a Programmer (From April. 2008 to 11 June 2010). worked for “Accenture Private limited” as a Software engineer (From 1st July 2010 to 26 Oct 2012) Current Experience: Presently working with “IBM India limited” as a Senior Application Consultant (From 30th Oct 2012 to till date) Project Details: 1. Project Name: TMS Client: General Electric Health Care (GEHC), USA Team Size: 4 Duration: 07 sept. 2008 till 5 July 2009 Role: Developer Description: This application gives the visibility to users for transportation cost and suggests the cheapest shipping method (carrier, mode of transport and service level) for shipping. For this purpose Data will be flowing in this application from GLPROD and OTM (Oracle Transportation Management) system OTM (Oracle Transportation Management) is a separate Oracle system used for Optimum transportation planning, which is integrated with Oracle EBS Tools: ETL: Informatica 8x Database: Teradata V2R5/R6, Oracle 9i Reporting: Cognos Scheduling: Cronacle Testing: Mercury Quality Center Source Management: CVS RESPONSIBILITIES: • Informatica Application Development • Working with various heterogeneous sources like Relational database and Flat files. • Conduction weekly reviews on application development progress. • Involvement with Team Leader in various phases of project. • Documentation as required in various phases of Project. 2. Project Name: Inventory Pulse Client: General Electric Health Care (GEHC), USA Team Size: 6 Duration: 6 July 2009 to 10-june-2010 Role: Developer Description: The PULSE Dashboard is based on the concept of an existing dashboards used by GE Healthcare called the Contractor. The PULSE Dashboard will combine data from multiple systems. The front end of this tool will have the look and feel of Microsoft Excel but customized for use of the PULSE Dashboard data sources. PULSE Dashboard will provide one integrated operational reporting dashboard solution to review the Supply Chain KPIs and the supporting information for future analysis. The PULSE Dashboard will be used to track and report inventory levels and improvement opportunities for each modality, distribution region and manufacturing organization with the modality. This tool will also capture weekly and quarterly numbers for trending. Tools: ETL: Informatica 8x Database: Teradata 12, Oracle 9i Reporting: BO XI, VB excel Scheduling: Cronacle Testing: Mercury Quality Center Source Management: CVS Responsibilities: • Working on various Transformations in Informatica. • Involvement in designing ETL Strategy. • Conducting weekly review meetings. • Conducting Unit Testing. • Creation of various documents at various stages of the Project. 3. Project Name: C&I Conversion Client: Australian Gas & Light (AGL), Australia Team Size: 17 Duration: 6 July 2010 to 30 Sep. 2011 Role: Developer Description: AGL is the leading Company in Australia, it 20 different legacy system for maintaining their business. C&I conversion is the conversion project here we are converting and migrating data from all the different Legacy system to SAP system. it will help them to generate their bill easily, as well as they can maintain Their systems. Tools: ETL: Informatica 8.6x Database: SQL Server Reporting: SAP, VB excel Testing: Mercury Quality Center Source Management: Accenture Share Point Responsibilities: 1. Working on various Transformations in Informatica. 2. Involvement in designing ETL Strategy. 3. Conducting weekly review meetings. 4. Conducting Unit Testing. 5. Creation of various documents at various stages of the Project. 6. Defect Management. 4. Project Name: CI Insight Client: Kesko,( Finland) Team Size: 6 Duration: 01 Oct. 2011 to 26-oct-2012 Role: Developer Description: Kesko is the leading Company in Finland, it has 9 different legacy system for maintaining their business. CI is the Data warehousing project here we are migrating data from all the different Legacy system to Data warehouse system. it will help them to generate their bill easily, as well as they can maintain Their systems. Tools: ETL: Informatica 9.1 Database: Teradata Reporting: Business Object Testing: Mercury Quality Center Source Management: Accenture Share Point Responsibilities: • Working on various Transformations in Informatica. • Working with Macro & basic shell script. • Involvement in designing ETL Strategy. • Conducting weekly review meetings. • Conducting Unit Testing. • Creation of various documents at various stages of the Project. • Defect Management. 5. Project Name: HDFC EDW Client : HDFC Bank Organization : IBM India Pvt. Ltd. Team : DataMart Team of Credit Cards Division Role : Team Member Location : Mumbai Tools : Informatica Power Center 9.1, Netezza, Unix Scope of the Project: This project is to build the Data Marts and Data Warehouse for the HDFC Bank. Currently the data for the bank is spread across the multiple systems like VP, CASA, FINONE, FINWARE etc… The project is focused on integrating all this information from different sources and building a single version of truth with SOR financial model of IBM. It also involves the data migration of about 50 Tb from existing system to Netezza database Roles & Responsibilities: • Implemented STG to SOR using BDW model • Designed and implemented ETL solution from SOR to Mart • All the existing stored procedures in existing reveleus system have been implemented in the ETL. • Designed & Built the ETL solution of huge datamart of Credit Cards division of HDFC bank having around 500 measures and successfully implemented in the production. • Done the successful implementation of FCT_CARDS_PROFITABILITY that is currently Live in HDFC Bank Credit Cards division. TRAININGS: • Attended Internal Company Training on Teradata V2R5/V2R6 at Tata Consultancy Services Ltd. • Attended Internal Company Training on Informatica 8.x at Tata Consultancy Services Ltd. • Attended Internal Company Training on Cognos 8.x at Tata Consultancy Services Ltd. • Attended Internal Company Training on Team management, Quality management systems, IT Security Awareness, Process management. AWARDS / RECOGNITION: • Completed Six Sigma Green Belt Certification Successfully on Automation of data validation of TMS Application. • Completed Infomatica Vendor Certification Successfully. PERSONAL DETAILS: Date of Birth: 05 th July 1987 Sex: Male Marital Status: Married Nationality: Indian Languages Known: English, Hindi Current Location: Mumbai Address of Correspondence: Room No.209,Building No.4, Sukh sangam building , JV L R road Marol MIDC Seepz Andheri East Mumbai (400093) Permanent Address : [login to view URL]. 269, Village – Chandranagar Distt.- Chhatarpur, State – M.P. Mobile: [login to view URL] References: Provided on request.

Contacta Rakesh A. sobre tu trabajo

Inicia sesión para comentar cualquier detalle por chat.

Comentarios

Cambios guardados
¡No hay comentarios para ver aquí!

Experiencia

6.4 Years of IT Experience

Capgemini India Pvt ltd
nov 2013 - Presente
RESUME Rakesh Agnihotri rakeshzt@gmail.com Mobile-09702792970 Objective: To dedicate upshot oriented hard work in a professionally managed organization that provide scope for learning and innovation exposure to new ideas and thereby promotes growth and development. Summary:  Around 6.3 years of focused experience in Information Technology with 6.2+ years of strong background in Business Intelligence development and Data warehousing.  Data Processing experi

Educación

BCA

Makhanlal Chaturvedi Rashtriya Patrakarita Vishwavidhyalaya, India 2004 - 2007
(3 años)

Calificaciones

Informatica Certified

2010
Informatica Designer 9.1

Contacta Rakesh A. sobre tu trabajo

Inicia sesión para comentar cualquier detalle por chat.

Verificaciones

Freelancer preferente
Identidad verificada
Pago verificado
Teléfono verificado
Email verificado
Facebook conectado
Usuario anterior Usuario siguiente
¡Invitación enviada correctamente!
¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.