Uploaded File
add photo
Shefali
shefaligr89@yahoo.com
226-348-4546
Application Developer
9 years experience W2
0
Recommendations
Average rating
23
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
Application Developer
Information Technology
Sep 2019 - present
Detroit, MI
  • Contributed in development of applications through the software cycle, from requirement definition through successful deployment.
  • Updated access scripts into modern desktop applications; evaluate existing application to reprogram, update and add new features.
  • Stored, retrieved, and manipulated data for close analysis of application capabilities.
  • Design the database and table schemas for new and evolving applications, ensuring their stability and performance.
  • Creating and modifying tables, stored procedures, views and functions to bring data into applications.
  • Work very closely with the front-end developers to ensure data that is being brought in and is clean and accurate.
  • Designed Windows Forms for application UI; perform unit and integration testing before launch.
  • Created reports in application via report viewer.
  • Performed all testing and troubleshooting methods and documented solution.
  • Consulted regularly with customers, team members on project status, proposals and technical issues.
  • Collaborate with team members to research, design, set and implement specifications for new applications.

Environment: Visual Studio 2015( Visual Basic, Visual C#, Report Viewer, Report Wizard) SQL Server 2008 (Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler).

C# SQL SQL Server Stored Procedure UI Visual Basic Visual Studio Windows
Remove Skill
n/a
Information Technology
Jul 2017 - Aug 2019
Southfield, MI

n/a

No skills were added
Remove Skill
Business Intelligence / Reporting Developer
Information Technology
Oct 2016 - Jul 2017
Southfield, MI
  • Lead requirements gathering from management, engineers, clients and business analysts; expedite and evaluate scope of work while accumulating data requirements.
  • Expedite sessions with involved stakeholders and repeatedly evaluate progress while gathering business data requirements.
  • Develop new and optimize existing complex report queries and stored procedures; designed reports to comply with clients and business units.
  • Investigate and interpret business data to construct meaningful reports using SSRS for business units.
  • Develop new stored procedures, views and complex queries; optimized existing SQL server objects.
  • Published reports to SharePoint repository, and monitor database and server for performance improvements.
  • Investigate and identify areas for improvement in database environment and monitor server to help identify opportunities for performance improvements.
  • Build and maintain the Report Life Cycle Processes, Data Migration Plans, Report Inventory and BI program guidelines.
  • Recording data and reporting it to proper parties such as clients or leadership
  • Troubleshoot current/existing business intelligence reports

Environment: SQL Server 2008 (Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler) SSRS 2008, SSIS 2008, MS Excel, Windows 2000/2003, MS Visio

Business Analysis Business Intelligence Data Migration Microsoft Excel Requirements Gathering SQL SQL Server SSIS SSRS Stored Procedure MS SharePoint Windows
Remove Skill
Jr. Database/BI Developer
Information Technology
Oct 2015 - Sep 2016
Southfield, MI
  • Design/Build Extract Transform Load (ETL) procedures in SQL Server using SSIS and DTS packages and import/export data feeds to/from data warehouse and loan systems.
  • Data Mapping between the source and the destination and documentation of the data mapping spreadsheet
  • Extract, transform and load (ETL) data from different sources such as production database, flat files, excel files into database using SSIS and DTS
  • Perform data validation, error checking, troubleshooting and performance tuning.
  • Created queries to cleanse data (duplicated claims ) by using temp tables; created correlated and non-correlated sub-queries for complex business queries.
  • Implemented triggers and stored procedures and enforced business rules via checks and constraints.
  • Worked on Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
  • Modified SQL queries and stored procedures to generate data for reports.
  • Troubleshooting problems by using SQL server profiler. Very Pro-active in identifying the problems before user complaints.
  • Created and Scheduled the Reports to run on daily/weekly/monthly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
  • Enhanced the old Excel Reports to new SQL Server Reports to fit new business requirement.
  • Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.

Environment: SQL Server 2000 (Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, MS Excel, Windows 2000/2003, MS Visio, Progress Open Edge, Oracle, Sql Server, UNIX.

BI Developer Data Mapping Data Validation Data Warehousing Oracle Performance Tuning Project Management SQL SQL Server SSIS Stored Procedure Triggers Windows
Remove Skill
DBA Intern
Information Technology
May 2015 - Aug 2015
Detroit, MI
  • Gained extensive knowledge of Progress and created database physical structure in test environment. Experimented database administration tasks including backup, recovery, dump and load, replication.
  • Understood Client-Server architecture and practiced on test environment.
  • Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
  • Demonstrated ability to effectively work in team structure. Assisting manager in performing database administration tasks.
  • Participated in meeting for schema changes along with Business Analysts and Database Engineers.
Data Replication Database Backups DBA
Remove Skill
IT Intern
Information Technology
Jun 2013 - Sep 2013
Detroit, MI
  • Involved in testing and debugging business logic in Store Procedures with Application Development Team. Involved in performing functional, systems, regression, and integration testing.
  • Assisted mentor to review and finalize requirements. Participated in status meetings with other IT teams on new project
  • Maintain communication channels with software engineers and project managers.
  • Created queries to check for duplicate records, delete/modify them depending on the business rule. Rigorously tested and debugged all the scripts to test the validity of the data after the export/import/delete were done.
  • Developed SQL scripts to Insert, Update and Delete data in MSSQL database tables in OLTP environment.
  • Involved in all phases of software development life cycle.
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
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