Sample CV for Data warehousing professionals

Sample CV for Data warehousing professionals

P Sharma
Mobile: (0)99********
Email: dw*******@gmail.com

Career Summary

-Possess 4.6+ years of experience in the Data warehousing Area and experience in Visual Basic, Oracle 9.2/10g.
-Rich Knowledge in multi-dimensional business models.
-Proficient in Production Support for Infineon & Qimonda Corporate data warehouse projects.
-Well versed in Development, Maintenance in Financial, Retail, manufacture Domain projects.
-Strong ability in identifying problems, developing new ideas, and finding the best solutions.

Technical Skills

-Hardware and Operating Systems Windows 95/98/2000/XP, Windows NT, UNIX
-Database ORACLE 9.2/10g, MS Access 2000, SQL, PL/SQL
-ETL Tool Informatica 5.1 & 6.1, Data stage 7.1 & 7.5.2

Key Responsibilities Handled

-Solving and debugging of blocked jobs in UC4 & Data Stage; thereafter reporting Error Character tics (analysis result) to the customer.
-Designed mappings in Informatica for the loading of the data in the Data warehouse from the system.
-Extensively involved in the extraction of different flat files and Oracle OLTP system.
-Created Power cubes in Cognos Transformer.
-Created drill up, drill down, drill through using Cognos Power play.
-Involved in production support issues.
-For New/Change requests, Involved in reporting Correction Character tics to the customer.
-Created Repository in Informatica 6.1
-Development and testing of ETL processes and components using Informatica

Key Projects Handled

Project 1
Environment: Data stage 7.5.2, Oracle 9.2, SQL Navigator, UNIX, Windows NT, and UC4-Job Scheduler.
Details: The Project aimed at daily status reporting to onsite/customer Solving and debugging of blocked jobs in UC4 & Data Stage; thereafter reporting Error Character tics (analysis result) to the customer.

Project 2
Environment: Data stage 7.1, Oracle 9i, SQL Navigator, UNIX, Windows NT, and UC4-Job Scheduler.
Details: The Project involved debugging of blocked job in UC4 & Data Stage and creating Weekly Report depending on Job aborts whole week, any task handled from customer request & Infrastructure issue etc.

Project 3
Environment: Informatica 6.1, Oracle 8i, SQL, Windows 2000 & NT, UNIX, MS-Excel.
Details: The Project involved Designing mappings in Informatica for the loading of the data in the Data warehouse from the system and creating complex mappings/mapplets using expressions, aggregators, joiners, ranking, filters, look up transformation in Informatica Power Mart

Project 4
Environment: Visual Basic 6.0, Oracle, ADO, SQL Server 6.5, Windows 98.
Details: The Project involved generating reports, which helped management tightens control over purchases and Designing logical and physical database model using case tools


Achievements

-Rashtrapathy Guide award from President of India.
-Achieved a GATE percentile of 77.02. (all India rank 68)
-Achieved a CAT percentile of 82

Employers

-ABC Information System Ltd, Delhi. Associate Consultant Nov-09 to Till-date
-Digi Systems & Software, Chennai Software Engineer May-07 to Oct-09

Educational Qualifications

-Master of Computer Applications (72%), XYZ.
-B.Sc., Computer Science (78%), QASA.

Personal Details

-DOB: 18th June, 19XX
-Languages known: English, Hindi.
-Address: Xxxx