OnBenchMark Logo

Saudagar

Senior SQL (MSBI) Developer
placeholder
Location Pune
view-icon
Total Views91
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 6 Year
  • Cost
    Hourly Rate$10
  • availability
    Availability2 Week
  • work from
    Work FromAny
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnJuly 26, 2024
Key Skills
MS SQL ServerSSISSSRST-SQLSQL
Education
2013-2015

(Computer Engineering)
Vishwakarma Institute of Information Technology

Summary
  • An ambitious and self-motivated database professional having 6 years of experience in SQL Server, SQL Server Reporting Services, and SQL Server Integration Services.
  • Experience in designing databases and creating database objects including tables, relationships,
  • stored procedures, user-defined functions, views, indexes, triggers, derived tables, and CTEs.
  • Experience in T-SQL programming for writing numerous ordinary to complex queries involving
  • multi-table joins, unions, correlated subqueries, CTE's, and views for diverse business requirements.
  • Experience in creating clustered and non-clustered indexes on tables and views for performance tuning.
  • Involved in troubleshooting, resolving data integrity, and monitoring performance issues.
  • Experience in Performance Tuning by analyzing different query options, indexing strategies, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning, and index defragmentation.
  • Experience in Rebuilding the indexes and updating statistics in databases at regular intervals for better performance.
  • Expertise in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
  • Involved in understanding Report Specification documents and designing, developing, debugging, and testing reports in SQL Server Reporting Services (SSRS).
  • Experience in designing and developing matrix and tabular reports with drill-down, drill through, and drop-down menu options using SSRS.
  • Experience in deploying and scheduling SSRS reports on Report Server using report manager.
  • Expertise in creating SSIS Packages to extract, transfer and load existing data into SQL Server from different environments by using various Transformations.
  • Experience in Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort, and Derived Column.
  • Introductory knowledge of cloud data warehouses like BigQuery and Amazon Redshift.
  • Introductory knowledge of analytics tools like Google Analytics and Segment.com
  • Introductory knowledge of scripting languages like Shell Script and Python to use them with
  • Jenkins to achieve various tasks like data migration, and scheduling of Jobs.
  • Ability to work individually as well as in the Group and provide solutions that meet business objectives.
  • Ability to communicate clearly and effectively.
Project Details
Title :Tillster
Duration :60
role and responsibileties :

Gathered requirements to identify and create database objects such as tables, storedprocedures,views, triggers and indexes.

Developed Database Objects such as Tables, Views, Stored Procedures, Functions, and Triggers toimplement complex business logic

Created numerous ordinary to complex queries involving multi-table joins, Union, correlatedsubqueries, CTE's and views for diverse business requirements.

Involved in understanding Report Specification documents and designing, developing, debuggingand testing of reports in SQL Server Reporting Services (SSRS).

Designed and developed matrix and tabular reports with drill down, drill through and drop-downmenu option using SSRS.

Applied various conditional formatting techniques in SSRS like interactive sorting, grouping tocreate user friendly reports to highlight key areas in the report data.

Developed Jenkins job using Shell Script and Python to migrate data from RDS and BigQuery toRedshift.

Worked on Segment for creating Source, Destination, Computed Traits and Audiences.

Worked on Google Analytics for creating profiles and sending data to destinations like BigQuery.

Worked on Google Analytics to Generate Custom Reports as well AdHoc reports using GoogleAnalytics APIs.

Involved in daily client calls.

Description :

Around the globe, Tillster provides an online ordering platform for the restaurant industry to morethan 2000 yum brands including Hello Bistro, Mc’Allister. This web-based platform has become anindustry standard for POS integrated ordering across multiple channels, as well as a robustintegration for call center ordering applications. Tillster simplifies digital ordering, improvescustomer engagement and grows sales by providing Food delivery as well as coupons and promotions.


Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon