Sarvesh  .

Sarvesh .

Data Engineer / Data warehouse /SSIS/Informatica/SSRS/SSAS/SSIS/Power BI

Wadgaon , India

Experience: 1 Year

Sarvesh

Wadgaon , India

Data Engineer / Data warehouse /SSIS/Informatica/SSRS/SSAS/SSIS/Power BI

25714.3 USD / Year

  • Immediate: Available

1 Year

Now you can Instantly Chat with Sarvesh!

About Me

  • Professional career reflects more than 12 years of experience in IT industry in Microsoft BI (SSIS, SSAS, SSRS, SQL Server and Power BI) and around 3 years of experience with Big Data techn...
  • 5 years of extensive experience in Informatica Power center.
  • Experience in handling different file formats like Text files, Sequence files, ORC Avro data files using different SerDe's in Hive.
  • Developed workflow in Oozie to automate the tasks of loading the data into HDFS.
  • Experience in Sqoop in migrating data from RDBMS to HDFS and Vice-Versa using various compression techniques.
  • Experience in writing complex SQL queries.
  • Experience in performance tuning and query optimization in SQL Server.
  • Experience in OLAP multi-dimensional model, Star and Snowflake model
  • Experience in creating ETL packages using SSIS and Informatica Power Center 9.6

Show More

Portfolio Projects

Muthoot Fincorp India a data warehouse project

Company

Muthoot Fincorp India a data warehouse project

Description

Title                         - ODS System (Data warehouse)  

Client                     - Muthoot Fincorp Ltd, Trivandrum India

Project Duration – October 2019 to till date

Description: Muthoot Fincorp is leading NBFS Company in India to provide gold loan and MSME loans for small creditor. They have various transaction systems which is generating daily data. And load into ODS data warehouse system through ETL jobs on daily, monthly and yearly basis. Based on business requirement design report/dashboards in Microsoft BI for analysis purpose      

 

Tools/Technology: Informatica Power Center 9.6.1, Oracle 11.2 express edition, SQL Server 2016, Power BI.

Responsibilities:

  • BI Lead, ETL Developer, assign task to developer, prepared estimation plan and taking delivery responsibility.   
  • Capture Requirement/uses cases from Business Analysts, users.
  • Design document for ETL load
  • Prepare project plan for delivery.
  • Design ETL jobs for various data warehouse table load daily, weekly monthly and yearly load.
  •  Assign task to dashboard developer form developing the dashboard for various business dashboard.

Show More Show Less

Enterprise Data warehouse / Tokyo Marine HCC, London UK

Company

Enterprise Data warehouse / Tokyo Marine HCC, London UK

Description

Title                         - Enterprise Data warehouse

Client                     - Tokyo Marine HCC, London UK

Project Duration – June 2017 to October 2019.

Description: This is the (EDW) Enterprise data warehouse project, data comes from multiple source in format like .csv file, tab separated file, xml file, Jason file and SQL Server data, MYSQL data. We put all data into HDFS and design the four data marts in Hive EDW, ReportingDM, UnderritingDM and DM. after processing some data mart are used for business reporting purpose that goes into SQL Server for reporting.

Tools/Technology: Hadoop, Hive, HDFS, Sqoop, SQL Server 2012, HQL, Microsoft Power BI, SSAS/DAX/MDX SSRS, Informatica Power Center 9.6.1.

 

Responsibilities:

  • Capture Requirement/uses cases from Business Analysts, users.
  • Create specification document.
  • Created HIVE queries and Hive tables for storing data and calculating different KPI’s.
  • Developed workflow in Oozie to automate the Sqoop tasks of loading the data into HDFS to implement data-pipeline
  • Import and export the data from RDBMS to HDFS
  • Develop reports/dashboards in Power Bi
  • Validate and fix data issue in informatica power center jobs

Show More Show Less

Ivox Data /Data warehouse

Company

Ivox Data /Data warehouse

Description

Client                           - Ivox Data Atlanta USA.

Project Duration      - June, 2014 to May 2017

Description: The application with capability to track more than 5000 drivers producing per second data through GPS and LMU devices. Using GPS data, the driving performance is calculated. Contains web portal and mobile applications (Android and iOS). It also interfaces with smart car consoles

 

Tools/Technology:  SQL Server, MySQL, Informatica Power Center SSRS, Android, iOS.

 

Responsibilities:

  • Created data transfer jobs Informatica Power center 9.6.1.
  • Schedule Informatica Jobs, monitor the Job.
  • Involved in SQL query optimization.
  • Loading data from source to staging DB and Staging DB to Data warehouse 

 

Show More Show Less

IMU (Investment Management Unit) / SEI / Data warehouse

Company

IMU (Investment Management Unit) / SEI / Data warehouse

Description

 

Client                           - SEI Oaks PA USA

Project Duration      - Jan, 2014 to May, 2014

Description: Based on the Client (Financial Services Provider) requirement, a number of data loaders were developed to extract data from text files, stage and validate data, load new data to the Dimension and Fact tables incrementally into the Warehouse, log the progress of the Package, error handling & package Configuration for variables and Connections being used. The packages were tested on the pilot server and issues were resolved (UAT) till its approval for production release. The next phase was maintenance. Re-engineering, Documentation of the design, configuration management with every change request/ feature addition/ support ticket.

 

Tools/Technology Used: SSIS (ETL), SQL Server 2008 R2, SSRS, SSAS, ASP.net /C#

 

Responsibilities:

  • Implemented the business logic in SQL stored procedures, user defined functions.
  • Implemented ETL process for extraction and data manipulation from different data sources (Excel, Flatfiles) into SQL server using SSIS.

Show More Show Less

Speedo Service Solution / Data warehouse

Company

Speedo Service Solution / Data warehouse

Description

  •         Client                - Toyota Motors Thailand
  •         Project Duration - Jan, 2013 to Dec, 2013

Description: Project required ETL process (Extract, Transform, and Load) migration of data from User inputs and TOPSERV database to Data warehouse and then generating requisite reports using Cognos tool. Joined the onshore migration team in Bangkok for change, enhancement and maintenance aspect of the ETL process migration

 

Tools/Technology Used:  Oracle 9i, DB2 10.x, Informatica Power Center 9.5 and IBM Cognos 10.

 

Responsibilities:

  • Created SQL views/SQL Procedures by implementing business logic.
  • Involved in performance tuning and query optimization.
  • Designed and developed automated ETL (Informatica Power Center) packages to load the business required data into archived database from heterogenous data sources.

Show More Show Less

Tools

Notepad ++

IgoUgo.com (Database Cleaning and Code Optimization)

Company

IgoUgo.com (Database Cleaning and Code Optimization)

Description

  • Client                         - Sabre Holding USA
  •         Project Duration - June, 2012 to Dec, 2012

Description: IgoUgo is one of the world’s leading online travel communities. To date IgoUgo has more than 650,000 members, 530,000 reviews, 570,000 photos, and 62,000 journals covering more than 10,000 destinations around the globe. Users can share their travel experiences and photographs to their friends, relatives and other users

 

Tools/Technology Used:  SQL Server 2000, MS SQL Server 2008, SSIS 2008, ASP.net/C#/VB.

 

Responsibilities:

  • Created SQL views/SQL Procedures by implementing business logic.
  • Database cleaning and performance tuning of tables and stored procedures.
  • Migrating data and setting environment from SQL Server 2000 to SQL Server 2008 R2.

Show More Show Less

Subscribe (RSL) [PRP (Platform Replacement Programme)] (Data Migration Project)

Company

Subscribe (RSL) [PRP (Platform Replacement Programme)] (Data Migration Project)

Description

  • Client                         - Amlin corporate Insurance London U.K
  •         Project Duration - Feb, 2010 to May, 2012

Description: Subscribe is the product of NIIT Insurance Technologies Ltd. (NIIT Technologies Group of companies). This is a non-life insurance domain project based on London Lydos market this application maintain the all data related non-life insurance.

Tools/Technology Used:  SQL Server 2005, SSIS 2005, SSAS, Data Stage.

 

Responsibilities:

  • Designing SSIS packages
  • Loading Data into Subscribe Database.
  • Creating Health checks scripts and reconciliation scripts.
  • Migrating data and setting environment from SQL Server 2000 to SQL Server 2008 R2.

Show More Show Less

RIG Reporting System (Windows Application)

Company

RIG Reporting System (Windows Application)

Description

Title - RIG Reporting System (Windows Application)

Client - Atwood Oceanic Huston, USA

Duration - Aug, 2008 to Jan, 2010

Tools/Technology Used:  SQL Server Reporting Services 2005, SQL Server Integration Services 2005, SQL Server 2005 Analysis Services.

Show More Show Less

Tools

notepad

Southall Travel

Company

Southall Travel

Description

Title – Southall Travel (http://www.southalltravel.co.uk)

Client - South All Travel Ltd., London, UK

Duration - Sep, 2007 to Jul, 2008

Tools/Technology Used:  C# / ASP.Net SQL Server 2005, TFS. , Web Services, SQL Server 2005 Integration Services ,SQL Server 2005 Reporting Services, JavaScript, AJAX, MOSS (Microsoft Share Point Server) 2007. , WSS 3.0, Workflow, Info Path 2007.

Show More Show Less
Share:

Verifications

  • Profile Verified

  • Phone Verified

Preferred Language

  • English - Fluent

  • Hindi - Native/Bilingual

Available Timezones

  • Eastern Daylight [UTC -4]

  • Central Daylight [UTC -5]

  • Pacific Daylight [UTC -7]

  • Eastern European [UTC +2]

  • Eastern EST [UTC +3]

  • Mountain Daylight [UTC -6]

  • Greenwich Mean [UTC ±0]

  • Further EET [UTC +3]

  • Australian EDT [UTC +11]

  • Australian CDT [UTC +10:30]

  • New Delhi [UTC +5]

  • Singapore [UTC +7]

  • Hong Kong (East China) [UTC +8]

  • Dubai [UTC +4]

  • China (West) [UTC +6]