Ravi Sharma

Ravi Sharma
Etl Developer
Kolkata, West Bengal, India
MySql, Common Sense, Unix +22

Profile Snapshot

Ravi is based out of Kolkata & has studied ECE ENTC-Electronics and Tele-Communication Engineering, BE BTech-Bachelor of Engineering or Technology from Year 2008-2012 in BPPIMTC-B P Podder Institute of Managment and Technology College, West Bengal university of Technology.

Ravi Sharma is Skilled in MySql, Common Sense, Unix and other talents.

About

I am having 5.3 years of overall experience in Data Warehouse development and enhancement.

Strong technical skills in UNIX shell scripting, Informatica PC, Greenplum Database, Oracle.

Talents

- Supply Chain Management
  
  yRank In Kolkata
  
  yRank In Kolkata
- » Compliment
  
  Global yRank
  
  21.28 %
  yTest
  21.28
- Unix
  
  yRank In Kolkata
  
  yRank In Kolkata
- » Compliment
  
  Global yRank
  
  75.54 %
  yTest
  75.54
- Unix Shell Scripting
  
  yRank In Kolkata
  
  yRank In Kolkata
- » Compliment
  
  Global yRank
- DBMS
  
  yRank In Kolkata
  
  yRank In Kolkata
- » Compliment
  
  Global yRank
  
  44.54 %
  yTest
  
  50
  Discussion
  44.54
  
  50

Complete Talent Profile »

Work Experience

Associate

Cognizant Technology Solutions

Full Time Feb-2014 To present 11 years 2 months

Responsibilities

Software Developer

Achievements

AVM Spot Award 2016; Awarded as "Budding Genius" in Q4' 2015

Software Engineer Trainee

Exilant Technologies Private Limited

Full Time Nov-2012 To Sep-2013 10 months

Responsibilities

Worked as a Software Developer. To design the database using UNIX shell script and populate data into the database table using terminal and generate reports.
Database - Oracle, Unix Terminal - MAC OS X 7.0

Achievements

» 4 Projects

Advanced Metering Infrastructure

Associate at Cognizant Technology Solutions

Sep-2014 to present

Developed Informatica XML source transformation to fetch the values from the XML source file and load the same to staging tables.
Worked on the existing Informatica SCD type 2 mappings, workflows for code enhancements.
Effectively worked in Informatica version based environment and created labels to migrate the objects.
Used debugger for identifying the data issue in existing mappings by analyzing data flow, evaluating transformations.
Effectively used Informatica parameter files for defining session variables, worklet variables, workflow variables, FTP connections and relational connections.
Involved in monitoring the data load from the XML, Mainframe, Flat Files (TSV, CSV) and Relational databases into staging area.
Created several UNIX shell scripts to generate reports for the stake holders.
Created ELT shell scripts to load the stage data to the fact tables in Greenplum database.
Created PL/pgSQL function to take data backup of audit tables with the help shell script.

Learn Management System

Associate at Cognizant Technology Solutions

Jul-2014 to Sep-2014

• Developed Informatica object - mappings, sessions and workflows.
• 100+ one to one mappings were created to pull the date for different modules.
• Configured parameterized Informatica objects- sessions & workflows.
• Unit testing of code completed successfully and proper documentation for same was done.
• Involved in Informatica version based environment and created labels to migrate the objects.

Data Supply Management System

Associate at Cognizant Technology Solutions

Jun-2014 to Jul-2014

• Developed and enhanced Informatica mappings, sessions and workflows.
• Involved in database table enhancement by altering the table definitions and changed the Informatica source & target transformations respectively.
• Informatica parameter file was configured for the sessions & workflows respectively.
• Workflow was tested and data load was verified successfully.
• Involved in Informatica version based environment and created labels to migrate the objects.

Innov IT Partner Portal System

Software Engineer Trainee at Exilant Technologies Private Limited

Mar-2013 to Sep-2013

• Developed UNIX shell scripts to create the data warehouse environment by using DDL scripts (tables, sequences, triggers, constraints).
• Created shell scripts to read the data from the source files and convert the same into SQL insert statement for loading the same data to the database using command line utility.
• Created shell scripts to cleanse the staging data and load the same to the fact tables
• Also created scripts to cleanse and load the dimensional data into the database from the source files
• Designed shell scripts to pull the properly formatted data from the oracle database and generate the report as per requirement using command line utility.

Education

Bachelor of Engineering or Technology

B P Podder Institute of Managment and Technology CollegeWest Bengal university of Technology

2008-2012 Score74%

Add academic achievement

Extra-Curricular Interests

Travelling
Playing Computer Games

Watching Hollywood Movies- Thriller | Action | Romance | Comedy

Painting

Profile Snapshot

Ravi Sharma is Skilled in MySql, Common Sense, Unix and other talents.

Find a different Ravi