EXPLORE

0.4
0.4
100%
$20 USD / Hour
・

India (4:47 PM)
・
Joined on August 20, 2012
$20 USD / Hour
・
I am a SQL Server DB & BI architect and DBA working as a consultant with numerous clients. I have designed, developed, deployed, administered and maintained over 65 SQL Servers and 600 SQL Server databases across the globe. I am also involved in Performance Tuning & Optimization at different levels. My work area includes writing/rewriting SQL queries for optimized executions, execution plan analysis, indexing, statistics management, benchmarking & baselining SQL Server, Replication, designing database architectures, designing data warehouse architectures, SSIS package development, SSAS multi-dimensional database development, SSRS Report Writing, MDX Query writing, Power BI, SSAS Tabular database development and Business Intelligence Application design. I have been working into multiple domains too that involves data center, finance, transportation, scrap consolidation and taxation domain.
Great work. Highly recommend
Share
Experience
BI Architect & DBA
May, 2017 - Present
•
9 years
Ultima Planning
May, 2017 - Present
•
9 years
1. Performing Administration tasks for databases including, backups, restores, replication, query management, releases, fresh server setups, u[grades, benchmarking, baselining, performance monitor data collection. 2. Performance tuning of SQL Server queries, databases and servers (SQL Server Configuration levels as well as Hardware levels) 3. Designing data warehouses and business intelligence architectures for fresh applications. 4. Performance Tuning of SSIS, SSAS, SSRS Implementations.
May, 2017 - Present
•
9 years
BI Developer & DBA
Oct, 2013 - May, 2017
•
3 years, 7 months
Cygnet Infotech
Oct, 2013 - May, 2017
•
3 years, 7 months
Performed the following activities for various projects : 1. Changing data models based on addition of new features in the system. 2. Creation of real-time SSRS reports operating on OLTP databases. 3. Creating SSRS reports using T-SQL on data warehouses. 4. Creating SSIS packages for ETL purposes. 5. Creating multi-dimensional SSAS databases for historical data analysis. 6. Designing database architectures for fresh applications.
Oct, 2013 - May, 2017
•
3 years, 7 months
T-SQL Developer
Jan, 2013 - Oct, 2013
•
9 months
Indusa Infotech
Jan, 2013 - Oct, 2013
•
9 months
Involved in writing complex T-SQL queries running on enterprise level databases. I also was responsible for troubleshooting T-SQL queries for bugs and change requests. After preparing the query I tested the query on several different types of data for complete data testing.
Jan, 2013 - Oct, 2013
•
9 months
Education
Gujarat Technological University (GTU)
2009 - 2013
•
4 years
B.E. (Computer Engineering)

India
2009 - 2013
•
4 years
Certifications
SQL Server
SQL Server
Verifications
On time
100%
On budget
100%
Accept rate
100%