ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

MohitKalra_Resume

•Download as DOC, PDF•
•
Mohit Kalra
Mohit Kalra

Mohit Kalra has 3 years of experience in data warehousing projects using Informatica, Oracle, and PL/SQL. He has experience developing mappings, sessions, and workflows in Informatica PowerCenter and writing PL/SQL procedures, functions, triggers and cursors. He has experience extracting, transforming and loading data from various sources into a data warehouse.

1 of 3
Download to read offline
MOHIT KALRA Mobile No: +91-9986376484 +91-9999326484 Email Id: mohitkalra@ymail.com PROFESSIONAL SUMMARY • Having 3 Years of IT experience in Development and Implementation of Data Warehouse projects using Informatica, Oracle, PL/SQL and Tableau. • Experience in developing Mappings, Sessions and Workflows Using Informatica Power Center 9.5/9.1. • Experience in writing procedures, functions, triggers and cursors using PLSQL. • Experience in Development, Testing and Production Data warehousing environment. • Developed ETL process to extract, transform and load data from various Heterogeneous sources i.e. Flat files, Oracle, Sql-Server, DB Visualizer into data warehouse. • Experience in performance tuning in Database as well as at Informatica level. • Extensively used Expression, Aggregator, Lookup, Update Strategy, Joiner, Router, Filter, Union, Sorter, Sequence generator transformations. • Developed reusable transformations to reduce the development time. • Good Knowledge on Software Development Life Cycle and Agile Development Methodology. EDUCATIONAL QUALIFICATIONS Year Examination/Board Specialization Institute/School Percentage 2012 Bachelor of Technology, M.D.U. Rohtak Computer Science Engineering Dronacharya College of Engineering, Gurgaon 66.68 2008 AISSCE, C.B.S.E. Science with Computers New Era Public School New Delhi 72.40 2006 AISSE, C.B.S.E. As set by Board New Era Public School New Delhi 80.80 - TECHNICAL SKILLS • ETL : Informatica Power Center 9.5/9.1 • Databases : Oracle 11g/10g, SQL Server 2012/2008, DB2 Visualizer • Web Technologies : HTML, CSS, Javascript • Tools : Oracle SQL Developer, WinSCP, Putty, Tableau • Operating System : Windows 7, Windows XP 1
PROFESSIONAL EXPERIENCE July 2013 to Till Date Employer: Capgemini India Private Ltd. Location: Bangalore Project: Commercial Data Warehousing Client: GE Oil and Gas Environment: Informatica Power Center 9.5, SQL Server 2012, Oracle11g, Flat files, UNIX Role: Technical Lead Brief description of the project: The high-performance data warehouse infrastructure that integrates data from a variety of source systems to generate reports that provide client with valuable information. The main process performed is Extraction, Transformation and Loading. The data is obtained from Relational tables and Flat-files across different sites all over the world. Then data is cleansed, transformed & loaded into data warehouse. Responsible for: • Interacting with Business Analysts to understand the requirements and preparing design • Involved in ETL coding using Informatica to load data from Oracle database, SQL server, and Flat files to Data Warehouse. • Created various workflows, mappings according to the business requirements • Developed mappings which pull data from heterogeneous sources, transform the data into designed fact and dimensional tables • Used transformations like joiner, filter, expression, lookup and aggregator in mappings according to the business requirements • Tuning mappings, transformations and data flow to optimize the performance • Involved in testing against the developed mappings by creating appropriate test cases • Writing SQL Queries, procedures, cursors and triggers to maintain the business rules Awards and Recognition: 2
• Earned Letter of Appreciation from customer for high quality deliverables within expected timelines. • Got appreciation from onsite team and client for initiatives and innovations in the project. STRENGTHS • Good communication skills. • Positive attitude and zeal to learn new things. • Perseverance and Hard working. • Complete dedication to my work, working with my full potential and giving my 100%. • Team Player who meshes well with everyone with good leadership skills. • Dedication...willingness to walk the extra mile to achieve excellence 3

More Related Content

MohitKalra_Resume

  • 1. MOHIT KALRA Mobile No: +91-9986376484 +91-9999326484 Email Id: mohitkalra@ymail.com PROFESSIONAL SUMMARY • Having 3 Years of IT experience in Development and Implementation of Data Warehouse projects using Informatica, Oracle, PL/SQL and Tableau. • Experience in developing Mappings, Sessions and Workflows Using Informatica Power Center 9.5/9.1. • Experience in writing procedures, functions, triggers and cursors using PLSQL. • Experience in Development, Testing and Production Data warehousing environment. • Developed ETL process to extract, transform and load data from various Heterogeneous sources i.e. Flat files, Oracle, Sql-Server, DB Visualizer into data warehouse. • Experience in performance tuning in Database as well as at Informatica level. • Extensively used Expression, Aggregator, Lookup, Update Strategy, Joiner, Router, Filter, Union, Sorter, Sequence generator transformations. • Developed reusable transformations to reduce the development time. • Good Knowledge on Software Development Life Cycle and Agile Development Methodology. EDUCATIONAL QUALIFICATIONS Year Examination/Board Specialization Institute/School Percentage 2012 Bachelor of Technology, M.D.U. Rohtak Computer Science Engineering Dronacharya College of Engineering, Gurgaon 66.68 2008 AISSCE, C.B.S.E. Science with Computers New Era Public School New Delhi 72.40 2006 AISSE, C.B.S.E. As set by Board New Era Public School New Delhi 80.80 - TECHNICAL SKILLS • ETL : Informatica Power Center 9.5/9.1 • Databases : Oracle 11g/10g, SQL Server 2012/2008, DB2 Visualizer • Web Technologies : HTML, CSS, Javascript • Tools : Oracle SQL Developer, WinSCP, Putty, Tableau • Operating System : Windows 7, Windows XP 1
  • 2. PROFESSIONAL EXPERIENCE July 2013 to Till Date Employer: Capgemini India Private Ltd. Location: Bangalore Project: Commercial Data Warehousing Client: GE Oil and Gas Environment: Informatica Power Center 9.5, SQL Server 2012, Oracle11g, Flat files, UNIX Role: Technical Lead Brief description of the project: The high-performance data warehouse infrastructure that integrates data from a variety of source systems to generate reports that provide client with valuable information. The main process performed is Extraction, Transformation and Loading. The data is obtained from Relational tables and Flat-files across different sites all over the world. Then data is cleansed, transformed & loaded into data warehouse. Responsible for: • Interacting with Business Analysts to understand the requirements and preparing design • Involved in ETL coding using Informatica to load data from Oracle database, SQL server, and Flat files to Data Warehouse. • Created various workflows, mappings according to the business requirements • Developed mappings which pull data from heterogeneous sources, transform the data into designed fact and dimensional tables • Used transformations like joiner, filter, expression, lookup and aggregator in mappings according to the business requirements • Tuning mappings, transformations and data flow to optimize the performance • Involved in testing against the developed mappings by creating appropriate test cases • Writing SQL Queries, procedures, cursors and triggers to maintain the business rules Awards and Recognition: 2
  • 3. • Earned Letter of Appreciation from customer for high quality deliverables within expected timelines. • Got appreciation from onsite team and client for initiatives and innovations in the project. STRENGTHS • Good communication skills. • Positive attitude and zeal to learn new things. • Perseverance and Hard working. • Complete dedication to my work, working with my full potential and giving my 100%. • Team Player who meshes well with everyone with good leadership skills. • Dedication...willingness to walk the extra mile to achieve excellence 3