vedansh mehta , Rishikesh, India

Hi all,

I have more than 4 years of experience working as SQL/Database/ETL Developer in multiple companies and in multiple domains, currently working as a freelancer on multiple projects..

Skillset: T-SQL, PL/SQL, ETL, SSIS, SSRS, Microsoft PowerBI, Database Designing, Database Modelling, Database Development, MSSQL Server, MYSQL, PostgreSQL, Oracle, Python Scripting etc.

Professional Experience:

Company Name: Ericsson

Project1:
Technologies:
T-SQL,PL/SQL,SSIS,SSRS(Microsoft Power BI)
Team Size: 5
Tool: Ericsson System Performance Analyzer (ESPA): A tool designed especially for analyzing the performance of a
network. It is reporting tool that shows reports being calculated in database and also provide features like graphs and
dynamic reporting. ESPA implementation for performance and managing data of network for different vendor for
different technologies..
Bharti NSN: Complete end to end project handling from development in Python as per the requirement and delivery
along with managing and coordinating team. Developed procedures as per the requirement.
DTAC Thailand: Developing the solution as per the Requirements, generating and analyzing Reports from ESPA tool.
Database Handling:
Developed queries to add counters and KPI for checking network performance.
Developed queries to aggregate data at different levels.
Developed the stored procedures for doing automations.

Project2:
Technologies: T-SQL,PL/SQL, Microsoft Excel
Team Size: 2
Side DB Automation: For cleaning of data coming from various teams using python scripts to make them in standard
format. Inserting data to different database tables according to requirements. Various reports on user requirements.
Act as a functional tech person for project (requirement gathering, logic building, testing)
1. Name of the institute: Indxx Capital Management Pvt Ltd.
Duration: July 2018—Febraury 2019
Worked as SQL/ETL database developer in a medium-sized development team. Provided support for multiple
projects in all environments. Performed Database Design and Implementation, Process automation ,Coding in
Python for development and support. Also worked across project management for global clients in delivery domain.
Key Responsibilities:
• Understand client’s requirements, coordinate and collect data.
• Collecting data from 3 different data resource to integrate in same format using SQL Server Integration
Services.
• Developed database schema and end to end database
• Developed SSIS packages to integrate data from different platforms.
• Development of stored procedures, functions.
• Used SQL Server Reporting Services for visualizing data.
• Query Optimization and Performance Tuning using Query Analyzer and Profiler, advanced query structures
like CTE, Derived Tables, and Indexes etc.

Company name: Indxx Capital Management pvt. Ltd.
Project1:
• Technologies:
T-SQL,PL/SQL,SSIS,SSRS(Microsoft
Power BI)
• Team Size: 2
• Tool: IStudio : A tool designed for creating index for stock market. It is financial tool that applies different
algorithms and create new indexes for ETF providers. This tool was developed for one of our client
• Database Handling:
• Developed end to end database.
• Developed the stored procedures for doing automations.

Project2:
• Technologies:
T-SQL,PL/SQL,SSIS,SSRS(Microsoft
Power BI)
• Team Size: 1
• Tool: ICAL : A tool designed for creating index for stock market. It is financial tool that applies different
algorithms and create new indexes for ETF providers. This tool was developed for internal company use.
• Database Handling:
• Developed end to end database.
• Developed the stored procedures for doing automations.

Please contact to know more about me.

Best Regards,
Vedansh