Data Manager

SHEFALI SINGH 226-***-****

SQL/BI/Application Developer ***********@*****.***

Summary:

·Over 3.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 viewer in Visual Studio, report builder and report developer in SSRS.

·Quick learner and master new technologies; successful working in both team and self-directed settings.

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, SQL Server Enterprise Manager.

Reporting Tools: SQL Server Reporting Services, MS Excel.

Programming Languages: TSQL, PL/SQL, C#.

Operating System/Servers: Windows 7, Vista, Windows 10, Unix, and Ubuntu.

ETL Tools: SQL Server Integration services (SSIS), Data Transformation Services (DTS, BCP)

Collaboration: SharePoint.

Software: Visual Studio, Visio, Microsoft Office.

Familiarity: Python, MongoDb, Oracle, Cloud Computing, JavaScript and HTML.

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.

PROFESSIONAL EXPERIENCE

Blue Cross Blue Shield (contract - Strategic Staffing Solutions) - Detroit, MI September 2019 – current

Application Developer

·Assisted in refactoring C# Applications to streamline daily tasks.

·Stored, retrieved, and manipulated data for close analysis of application capabilities.

·Designed database and table schemas for new and evolving applications.

·Created tables, stored procedures, views and functions to bring data into applications.

·Designed Windows Forms for application UI; perform unit and integration testing before launch.

·Created reports using C# using report viewer.

·Performed application testing and created user documentation.

Took Maternity break July 2017 - August 2019

Livingston International (contract: Zenith Talent) - Southfield, MI October 2016 – July 2017

Business Intelligence / Reporting Developer

·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

First Recovery Group (Global Techies Inc.) - Southfield, MI October 2015 – September 2016

Jr. Database/BI Developer

·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

·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 remove 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.

Quicken Loans - Detroit, MI May 2015 – August 2015

DBA Intern

·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.

Title Source - Detroit, MI June 2013 – September 2013

IT Intern

·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.

·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 MS SQL database tables in OLTP environment.

·Involved in all phases of software development life cycle.

EDUCATION

·Walsh College, Troy, MI * Masters of Science in Information Technology, June, 2015, GPA: 3.88.

·Institute of Integrated Learning in Management, New Delhi, India * M.B.A.,2005-2007

·Punjab University, Chandigarh, India * Bachelor of Arts, 2002-2005

·Microsoft SQL Server and SSRS course certification, May 2017 – Current

REFERENCES

Available Upon Request

Contact this candidate