Sign in

Data Sql Server

Little Rock, Arkansas, United States
October 03, 2018

Contact this candidate



Durgesh Yadav

**** * ******* ***, ****** Rock, Arkansas, 72205

501-***-****– – 3 years of professional experience as MS SQL Server/ETL developer in process design and implementation GUI, Quality Analysis and Network Administration.

Strong understanding of databases and data structures, developing project plans and report generation. Robust understanding of ERP Systems, logical & physical Database design & development, data conversion & Normalization.

Profound understanding of Enterprise Data Warehouse (EDW) concepts including OLTP/OLAP, Dimension/Fact table, Top-down/Bottom- Models, Star Schema and Snowflake schemas. Broadly Intricate in Requirement gathering, Requirement documentation, Writing test plans, Testing and reviews.

Experienced in designing and deploying tabular reports, drill-down reports, drill through reports, multicolumn reports, linked reports and parameterized reports by using SQL SSRS. Hands-on experience with creating solution driven views and dashboards by developing different chart types including

Worked with System Development Life Cycle (SDLC) methodologies including Waterfall, Agile –Scrum Framework

Self-motivated individual with analytical, time management and Client Interfacing Skills, good verbal and written communication skills.


Master of Science, Information Quality GPA 3.50 December 2018 University of Arkansas at Little Rock

Bachelor of Engineering, Information Technology June 2013 PCCS, Greater Noida, India


Analytical Tools: Google Refine/Open Refine, KNIME, PowerBI, Tableau, Excel (Power Query/ Pivot/ Map), Weka, Data Flux Data Management Studio 2.5 tool. Reporting Tools: SQL Server Reporting Service (SSRS), Business Analyst Online (ESRI), Tableau Server Database: SQL 2008/2008R2/2012/2014/2016, Oracle 9i/10g/11g, MS Access, DB2 ETL: SQL Server Integration Service (SSIS), Data Transformation Services, SQL Server Data Tools (SSDT) Programming Languages: Python, C, SQL, HTML, CSS, PHP, C# Operating Systems: Windows 98/XP/7/8/10, Fedora, Linux Other: Data Modelling, Engineering, Architecture, Identity Resolution, Data Warehousing, Data Manipulation WORK EXPERIENCE

Graduate Assistant July 2017- Current

UA Little Rock, Information Technology Services

System Design Research and technical /process documentation for projects. Designing and creating Facts, Dimensions, and Hierarchies of the business model. IT architecture for research of new or existing software products and Constructing detailed. Innovating and designing workflows, Requirement Analysis, Modelling, Work Plan (Gantt chart), size Duration and cost.

estimation, diagramming (Activity, Use Case and Use Case Description, Sequence Diagram) and reporting Change/constraints for the applications.

Process Associate Nov 2013-Dec 2016

Suntec India Pvt. Ltd.

I was responsible for designing and implementing manufacturing processes, equipment, and plants (from pilot to fully operational) to achieve the production goals of the organization. Involved in all phases of Software Development Life Cycle. Involved in creating primary database objects like tables, views, indexes etc. Usage of various tools involved in Quality Analytics, monitoring and successful completion of the day to day batch jobs.

Coordinate with various teams, customers and provide technical maintenance for projects. Organize and assist to gather information for various applications and analyze it using data modeling techniques.

Monitor all processes and reuse all data for enterprise. PROFESSIONAL DEVELOPMENT

Graduate Certificate, Information Quality December 2018 University of Arkansas at Little Rock

Other Certifications

Certificate of ‘Data Stewardship’ from Collibra University (2017). ACADEMIC PROJECT

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.

UA Little Rock Admission System: Involved Designing workflows, Project Management Plan, Requirement Analysis, Modelling and Designing a system by following Work Plan (Gantt Chart), Size duration and Cost estimation, diagramming (Activity, Use Case and Use Case Description, Sequence Diagram, Object- Persistent Design) etc.

Contact this candidate