Profilbild von Sandeep Kumar DWH ETL Consultant  (Informatica, Oracle SQL and PL/SQL, Unix, BO) aus Kloten

Sandeep Kumar

verfügbar

Letztes Update: 18.05.2013

DWH ETL Consultant (Informatica, Oracle SQL and PL/SQL, Unix, BO)

Abschluss: nicht angegeben
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: deutsch (Grundkenntnisse) | englisch (verhandlungssicher) | hindi (Muttersprache)

Skills

• Core Data Warehousing experience of 8+ years, with focus on ETL (Informatica), Data Modeling, Data Analysis, PL/SQL and UNIX Shell Scripting.
• Informatica Certified Developer in Informatica 8.x.
• Comprehensive experience in Software Development Life Cycle which includes Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging, Productions Support, and Maintenance of various Data warehousing Applications.
• Proficient in understanding Business Processes / Requirements and translating them into High level and low level Technical specifications.
• Extensive experience in working in onshore/offshore development model.
• Extensive experience in managing fixed price projects.
• Profound knowledge in banking and financial domain.
• Data Warehousing experience using Informatica Power Center 8.6/7.x/6.2/6.1.
• Design and Development of Universes and Reports using Business Objects XI R 3.1
• Experience in Solaris (SDSS) Packaging using Generic Staging 6.x/7.x.
• Strong knowledge on handling SwanXP Change Requests.
• Proficient in the integration of various data sources such as Oracle, SQL Server, Sybase, Fixed Width Flat Files, Delimited Flat Files, VSAM files.
• Proficient in the development of ETL (Extract, Transform, Load) processes with a good understanding of source to target data mapping, ability to define, capture Metadata and Business rules.
• Experienced in Performance Tuning and Debugging of existing ETL processes.
• Experienced in Star-Schema, Snow-Flake data modelling, Normalization, Logical and Physical data model design process.
• Experienced in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data meets the business requirements.
• Sound knowledge of RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL, Stored Procedures.
• Experience in UNIX shell scripting, job scheduling on multiple platforms like windows NT/2000, Linux environment.
• Designing ETL Jobs and Execution flow using Autosys and Control-M Scheduling tool.
• Proposal Writings for various Data Warehousing and ETL Related Projects.
• Maintain an awareness of existing, new and emerging technologies.
• Team player, motivated and dynamic with excellent oral and written communication skills.
• Worked extensively on Rational Clear case, Quality Center, Remedy, PACE, TOAD, Rapid SQL, CVS and Sub Version.
• Onsite experience of more than 1 year in US for Fidelity Investments.
• Working as a Senior IT Consultant for Credit Suisse AG, Zurich in Credit & Risk Domain, handling areas such as Analysis, Design, ETL Development, Unit Testing, Integration and Acceptance Testing, Production Deployments and Support.


SOFTWARE SKILLS
ETL Tool Informatica Power Center 8.6/7.x/6.x
Data Modeling Tools Power Designer
Databases Oracle 11g/10g, Awareness on DB2 and Sybase
Business Domain Banking and Finance
Languages SQL, PL/SQL, Unix Shell Scripting
Reporting Tool Business Objects Designer and Reports XI 3.0
Testing Tool HP Quality Center
GUI Tools TOAD, RAPID SQL
Operating Systems Sun Solaris, HP UNIX, Linux, Windows Server 2000
Versioning Tools CVS, SVN, Clear case
Others MS Project/Visio 2010, Autosys, Control-M, Clearquest
Remedy, PACE, SwanXP, SDSS

Projekthistorie

An excellent technologist and great team player, no task too small and every detail well executed!
November 25, 2012
Nora O'Sullivan
Data Architect at Credit Suisse
In my position as the technical lead for the Swiss Data Hub DWH application at Credit Suisse in Zürich I have worked with Sandeep for about 3 months. At that time our project was facing many challenges for delivering new functionality in a very short span of time.

Sandeep offered his services as a solution engineer to help us out.
I have never seen someone doing the onboarding in our project so quickly. Within a few days he was fully operational working on the project tasks that we assigned to him. We were very happy with the results.

If you are ever in the position to hire Sandeep, then do so. You will not be disappointed.

Please contact me if you need any additional information about Sandeep.
November 17, 2012
Ron T Hart
UBS
I had the privilege of working with Sandeep at Credit Suisse. He is one of the most thoughtful, knowledgeable and professional people I worked in Credit Suisse - data warehouse area. He's got a passion for the design, development and deployment of enterprise software, and is one of the "go to" people in the CS data-warehouse for his knowledge of the company tools, his understanding of the issues, his original ideas and his thorough execution. I have enjoyed all of our encounters and recommend him very highly!

You could always count on Sandeep for his judgment during the crucial times of a project. While working with Sandeep, I was always in awe regarding the creativity and innovation he brings - he has a knack for thinking outside box and turning vision from paper to reality. I would confidently recommend Sandeep to any company.
November 17, 2012
Snezana Gligorevic
Solution Architect at Credit Suisse

Great consultant. Proactive and very professional

November 29, 2011
Frans Smets
Project Manager at Credit Suisee

I’ve had a pleasure working with Sandeep for 2 years. He is a solid professional with wide range of skills in Informatica, RDBMS, And Data Warehousing.

Sandeep can be relied upon to deliver the most elegant and cost efficient solution in a timely manner. I found Sandeep to a be a great person to work with and I’d recommend him to anyone looking for a great addition to their team.

September 26, 2010
Alexandar Slavin
System Architect at Fidelity Investments, Boston

I have worked with Sandeep both during my undergraduate and corporate environments. What stuck out most was his innate ability to resolve issues with his strong analytical abilities and out of the box thinking. He has always been a hard and smart worker, difficult combination to obtain. His customer handling skills are superb and this makes him a must have on any team. I recommend Sandeep strongly, he will be an asset in any team under all the circumstances

December 28, 2009
Gaurav Pratap Singh
Software Engineer at Fidelity Investments, Bangalore

Matrixed-in as a resource and reporting indirectly, Sandeep contributed extensively to an innovative design and delivery of a key component for data validation and reporting. In my role as project manager of this large effort, I greatly appreciated having Sandeep on the team. He was a key contributor and member of the team. His commitment to getting the tasks done on time and as needed while adjusting and adapting to changing requirements as the data and reporting came into being was simply exemplary. I/we were even afforded the opportunity to work directly with Sandeep side-by-side in the US for a period of time, despite primarily working with Sandeep internationally (off-shore). Throughout this lengthy project, Sandeep was a significant, committed, and thoroughly reliable and productive member of the team.

December 7, 2009
Mark Faria
Project Manager at Fidelity Investments, Boston

Sandeep is one of the finest resources to work with . He is extremely dedicated , hardworking and steadfast . His innovative and out of the box thinking has won him accolades from all quarters .He excels in Informatica , Unix , Oracle and Perl . I would strongly recommend Sandeep as a person whom anyone would love to work with.

September 13, 2009
Vishal Mehta
Senior Software Engineer at Fidelity Investments, Bangalore

Sandeep is a very Dynamic and Result Oriented individual. He has great analytical skill which helps him solving the problem quicker than others. He is an excellent team player at his work. He is very nice person personally as well as professionally. He was awarded with On the Spot award at Fidelity Investments. He has also got lot of appreciation from Fidelity Clients. He has done lot of critical production deployment in very short interval of time and with Zero defect.

January 25, 2009
Abhishek Biyani
Software Engineer at Fidelity Investments, Bangalore

Sandeep and I had studied together pursuing our undergrad degree. Since then, he has been a great friend and an inspiration - consistent top performer, always calm under pressure, great sense of responsibility, very imaginative & goal oriented, a tough competitor but never losing the human angle.I am sure he has a long & successful career ahead, and will inspire a lot many people along the way!

December 30, 2009
Sameer Sinha
GE, Bangalore

Note: For employer references I have the reference letters which could be send on request.

Linkedin Profile: http://ch.linkedin.com/in/sandeep21kumar

Reisebereitschaft

Verfügbar in den Ländern Schweiz
Available for fulltime from 01.06.2013.
Profilbild von Sandeep Kumar DWH ETL Consultant  (Informatica, Oracle SQL and PL/SQL, Unix, BO) aus Kloten DWH ETL Consultant (Informatica, Oracle SQL and PL/SQL, Unix, BO)
Registrieren