add photo
Shefali
shefaligr89@yahoo.com
226-348-4546
United States
Application Developer
11 years experience W2
0
Recommendations
Average rating
141
Profile views
Summary

Summary:

  • Over 2.5 years of experience in IT, Financial, and Healthcare environments with primary skill on SQL Server database development and administration with SQL Server 2005/2008 and Business Intelligence Technologies.
  • Had a major role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, training, production support and Project review with client.
  • Experience in object-oriented programming; developing, testing and debugging code; designing interfaces; and administering systems and networks.
  • Experience in creating Packages, Jobs and Experience in migration of Data from Excel, Flat file to MS SQL Server by using DTS utility.
  • Worked on complex data loading from FTP sites (implemented the batch data cleansing and data loading).
  • Integrated SSRS reports with SQL Server Database.
  • Used SQL Server Reporting Services (SSRS) to generate reports for business analysis and management purposes.
  • Excellent knowledge of all the phases of Software Development Life Cycle (SDLC). Excellent written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.
  • Good working knowledge on reports using report builder and report developer in SSRS.
  • Quick learner and master new technologies; successful working in both team and self-directed settings. Exceptional academic record. Achieved 3.889/4.0 GPA.
  • Strong analytical knowledge coupled with excellent communication and interpersonal skills. Proficient in developing clear and concise documentation of all work performed.

Technical SKILLS

  • RDBMS/DBMS: SQL Server 2008/2005/2000, SQL Server 7.0, 8.0, 9.0, MS Access, and SQL Plus
  • Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio, SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS, BCP
  • Data Modeling: Visio 5.0
  • Reporting Tools: SQL Server Reporting Services, MS Excel
  • Programming Languages: TSQL, PL/SQL, Visual Studio, C# .NET, HTML, and JavaScript.
  • Operating System/Servers: Windows 9x/Windows 2000/Windows NT/ Windows Server 2003/Windows XP, Unix, Linux Ubuntu.
  • ETL Tools: SQL Server Integration services (SSIS), Data Transformation Services (DTS)
  • Collaboration: SharePoint.

Core Competencies

Business Intelligence / Database Systems:

  • Data Analysis / Data Validation / Data Integrity / Documentation
  • Data Migration / Source to target mapping / Data Loading / Data Cleansing
  • Reporting & Dashboard development

Business Analysis / Communication

  • Gathering of requirements across all levels of an organization
  • Translated technical concepts into Business Language to owners and stakeholders
  • Collaborate with 3rd party providers on behalf of client.

Experience
Education
Master's in Information Systems
Walsh College 2015
Management, New Delhi, India
Institute of Integrated Learning 2007
Punjab University 2005
Certifications
Microsoft SQL Server and SSRS course certification
Skills
SQL
2021
2
SQL Server
2021
2
Stored Procedure
2021
2
Windows
2021
2
C#
2021
1
SSIS
2017
1
UI
2021
1
Visual Basic
2021
1
Visual Studio
2021
1
.NET
0
1
BI Developer
2016
1
Business Analysis
2017
1
Business Intelligence
2017
1
Data Mapping
2016
1
Data Migration
2017
1
Data Replication
2015
1
Data Validation
2016
1
Data Warehousing
2016
1
Database Backups
2015
1
DBA
2015
1
ETL
0
1
FTP
0
1
HTML
0
1
JavaScript
0
1
Microsoft Excel
2017
1
MS SharePoint
2017
1
Oracle
2016
1
Performance Tuning
2016
1
Project Management
2016
1
Requirements Gathering
2017
1
SSRS
2017
1
T-SQL
0
1
Triggers
2016
1
UNIX
0
1