Sql Server Project Management
Resume:
Sheetal Valand
*******.**********@*****.***
PROFESSIONAL SUMMARY:
• Over 7 years of experience in Application design, analysis, testing and production support.
• Designed SQL Server / Access database for storage and retrieval of real-time sensor data.
• Extensive experience working with large Corporations in Agile and Waterfall environments.
• Extensive experience in Analyzing and migrating large data.
• Extensive experience in extraction, transformation and loading (ETL) data.
• Proficient working on all phases of SDLC.
• Designed and developed user-friendly screens in Access, VB 6.0 and VB.net.
• Published MS Access tables as a list on SharePoint server.
• Translated detailed designs into application.
• Proven background completing projects under aggressive financial and time constraints.
• Exceptional communication, analytical, and project management skills.
• Prepared High level, program-level and user-level documentation. TECHNICAL SKILLS:
RDBMS / DBMS: MS SQL Server, MS Access and MySQL
Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, MMC, I-SQL, PL/SQL, DTS, ODBC, SSRS, ADO, SQL OLEDB, DBCC.
Operating System: Windows, Red Hat Linux, Solaris. Programming
Languages:
VB.Net, C#.Net, VB 6.0, VBA, VBScript, HTML, DHTML, T-SQL, PL/SQL. Reporting Tools: Access Reports, Crystal Reports, Data Reports, SSRS. Office Tools
MS Word, MS Excel, MS PowerPoint.
PROFESSIONAL EXPERIENCE:
Sunsoft Service Inc- Jersey, NJ Sept 5 2022 to Till Date VBA Developer
Responsibilities:
Project: 1) Code Review and Validation (CRAV) 2) CRAV Re-Platform 3) Case Investigations & Management System 4) Metric Stream 5) Data Migration.
Department: Claims Development and Support
• Modified existing VB scripts and VBA code during enhancements.
• Developed macros to automate Prepayment Letters & reports.
• Created smart GUI forms in MS Access using VBA for capturing auditing data.
• Migrated MS Access slow running queries to SQL Server Views.
• Created consolidated reports in MS Access and Excel.
• Create/Modify/Move queries to SQL Server views/Proc.
• Parse address field into Street, City, State and Zip code through macros.
• Fetch user & computer details from windows API.
• Extensively worked with “Pass through queries”.
• Automated daily reports in Excel using VBA & Macros.
• Migrated data while merging CIMS with Metric Stream.
• Worked with large datasets, Implemented OFFSET & FETCH NEXT key words in the select statement for splitting result sets.
• Migrated 40k Metric Stream cases to CIMS.
• Handled 76k attachments during data migration.
• Created VBA tool for migrating data.
• Created LOV’s & Column mapping for data migration.
• Utilized SQL server import/export tool for populating SQL server tables.
• Created hundreds of DSN less Linked tables for Prod & Dev environments.
• Created Tables, Views, and Procs in SQL server for CIMS & CRAV applications.
• Created staging tables, views, triggers and procs in Oracle for pulling Facets claims.
• Created staging tables, views, triggers and procs in Teradata for pulling ‘WellPoint Group System’ (WGS) claims.
• Modified/Enhanced existing Visual basic applications.
• Designed normalize Database for Pre-Payment providers.
• Created Dev environment for CRAV migration and merging CIMS with Metric Stream.
• Import data into SQL Server Dev environment from Prod during Dev environment setup.
• Created Application Current Status, functional and technical documents. ENVIRONMENT: MS Access 2010, SQL Server 2012, Oracle 10, Teradata, VBA, Excel 20110. InterPublic Group – New York, NY Nov 2020 to july 2022 VBA Excel Access Developer /Analyst
Responsibilities:
Project: Role Mapping Tool
• Developed multiple Excel forms for SAP roles.
• Designed and developed GUI dashboard in MS Excel.
• Designed and developed “Role Mapping Tool” in MS Access.
• Published “Role Mapping Tool” on SharePoint server.
• Published existing MS Access tables as a list on SharePoint server and linked it back to the tool.
• Created validations in Excel.
• Developed macros to filter, format and send data as CSV attachment.
• Created Queries and Reports in Ms Access.
ENVIRONMENT: Windows 7, Excel, Access 2010, C# 2012, VBA, SAP, SQL Server 2012. IKEA - Conshohocken PA July 2017 -Oct 2019
VB Developer
Responsibilities:
Project: 1) FTP Tool
• Parse XML file and read configuration data from XML file.
• Implemented XML configuration settings into VB.
• Loop in several folders and servers for identifying required files.
• Filter & Pickup approx. 3000 files from multiple servers and upload on multiple servers.
• Created log files using System.IO.
• Send report as email attachment to users through SMTP using SQL server mail.
• ENVIRONMENT: Windows, VB 2008, XML, VBA, Access 2010, Excel, SharePoint, FTP. Whirlpool - St Joseph, MI Apr 2016 - July 2017
VBA Developer
Responsibilities:
Project: Preliminary bill of material (PBOM)
• Designed Dashboard in excel.
• Designed Master form, Reports in Access.
• Developed data base queries to fetch data from Access.
• Developed user friendly screens for capturing data.
• Developed and performed test/debug functions.
• Implemented conditional formatting in Excel.
• Developed VB application to export data from SQL Server to Access.
• Created tables, Views, Forms and Reports in Access. ENVIRONMENT: Windows, Access 2007, Excel, VBA, SQL Server 2008, Oracle 10, SAP BW. Digitech Computers – Vadodara, India
Data Analyst / VBA Developer Aprill 2015 – Mar 2016 Responsibilities:
• Worked with VB Forms, pull-down menus, buttons, and radio dials.
• Developed VB applications that load data from the SQL Server databases.
• Enhanced existing VB application that communicates with DB using ADO objects.
• Designed an optimal one-to-many relationship layout of tables in SQL server.
• Developed stored procedures for bulk data updates. ENVIRONMENT: Windows, VB 6.0, VBA, Access 97/2000, Excel, SQL Server 2000. EDUCATION:
Master’s in computer science, Sardar Patel University, India. Mar,2018 Bachelor’s in computer science, Sardar Patel University, India. Mar 2015
Contact this candidate