**** * ******* ***, ****** Rock, Arkansas, 72205
501-***-****– email@example.com – linkedin.com/in/dxyadav1 3 years of professional experience as MS SQL Server/ETL developer in process design and implementation GUI, Data Analysis and Network Administration.
Experience in designing, developing and testing of the ETL processes to populate data from various source systems.
Robust understanding of ERP Systems, logical & physical Database design & development, data conversion & Normalization.
Profound understanding of Enterprise Data Warehouse (EDW) concepts including OLTP/OLAP, Excellent knowledge in Dimensional Modeling, ER Modeling, Star Schema/Snowflake Schema, FACT and Dimensional tables.
Expert in writing complex queries, stored procedures, cursors, triggers, views and user-defined functions for data consistency and manipulation.
Worked extensively on Power BI and created Reports/Dashboards using different type of Slicers and different Visualizations like Bar Charts, Line Charts, Graphs, and Pie Charts etc. to make it more attractive and explored data in a Variety of ways and across multiple visualizations using Power BI. Hands-on experience with creating solution driven views and dashboards by developing different chart types including.
Robust understanding of Database Management system (DBMS) and Relational Database Management System
Worked with System Development Life Cycle (SDLC) methodologies including Waterfall, Agile –Scrum Framework.
Self-motivated, Work independently with analytical Skill, time management and Creative thinking, good verbal and written communication skills.
Analytical Tools: Google Refine/Open Refine, Weka, Power BI, Tableau, Microsoft Suite, Data Flux Data Management Studio 2.5 tool.
Reporting Tools: Microsoft BI
Database: SQL 2008/2008R2/2012/2014/2016, MySQL
ETL: SQL Server Integration Service (SSIS)
Programming Languages: Python, SQL, HTML, CSS, PHP Other: Data Modelling, Cost Analysis, Static Analysis, Identity Resolution, Data Warehousing, Data Manipulation, Web Development, JIRA, AWS Cloud.
Master of Science, Information Quality December 2018 University of Arkansas at Little Rock
Bachelor of Engineering, Information Technology
Uttar Pradesh Technical University, Greater Noida, India
Protech Solutions Inc. July 2019-Till Date
Work and Support development team during design and coding.
Troubleshoot performance problems, fine-tuning of databases and index Analysis
Knowledge in stored procedures and functions. Experience in Clustering.
Experience in using dictionaries and finding long running queries.
Experience in Import, Export, Backup, Recovery, Database Monitoring tools and Application support.
Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance.
Noetic Partners Inc.
Data Analyst Intern April 2019-June 2019
Development of Reference Data dictionary to help identify data types representing each unique identifier.
Writing Definitions for Data fields to be integrated and implemented into working Model.
Supporting Noetic Business requirements.
Understanding of financial markets and how data is curated in the industry for the different use cases. UA Little Rock, Information Technology Services Dec 2017-Dec 2018 Worked as a Desktop Support Specialist in IT Services. Worked with the clients to resolve the issues related to the Installation, Network, Troubleshoot, Client Assistance via phone or remotely.
Collaborate with existing vendors to evaluate the new technology that is available and make recommendations to management on using that technology.
Monitor the performance of the company’s desktop infrastructure and make suggestions for improving efficiency.
Evaluate applications and software patches for desktop applications to see if they will solve desktop issues.
Estimation, diagramming (Activity, Use Case, Sequence Diagram) and daily reporting Change/constraints for the applications and Employee Activities.
Process Associate Nov 2013-Dec 2016
Suntec India Pvt. Ltd.
Worked as a Developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for the applications.
Performed Data mapping for extraction and loading.
Responsible for Disaster Recovery, backups, database optimization.
Expert in developing multiple kinds of Power BI Reports and Dashboards.
Analyze data in a Variety of ways and across multiple visualizations using Power BI.
Used SSIS to transform data into SQL database via FTP from Text files, MS Excel as source.
Heavily involved in query optimization and troubleshoot long running queries.
Wrote complex stored procedures, triggers and functions.
Used Performance Monitor and SQL Profiler to optimize queries.
Enhanced the performance of database servers.
Graduate Certificate, Information Quality December 2018 University of Arkansas at Little Rock
Certificate of ‘Data Stewardship’ from Collibra University December 2017 Effects of Immigration on the USA Economy: Our goal was to analyze the trends of legal immigration into United States and Correlation among immigration and economic parameters such as change in GDP rate, Income by population, GNI, CPI etc. The project included intensive data modeling and analytics using Tableau, Power BI, R Programming for spatial data modeling, scatter plots, stack bar graphs etc.