| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Sql Server C++ Sayreville, NJ Computer Science Sql Server Spring Valley, NY SQL Server Management Studio, Oracle 11g, MS Word, MS Visio New York, NY Power Bi Sql Server Piscataway, NJ Sql Server Ms North Arlington, NJ Production Support Sql Server Monroe Township, NJ Sql Developer Project Management Old Bridge, NJ |
|
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLEEMAIL AVAILABLEPROFESSIONAL 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 MySQLDatabase 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. ProgrammingLanguages: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 ToolsMS Word, MS Excel, MS PowerPoint.PROFESSIONAL EXPERIENCE:Sunsoft Service Inc- Jersey, NJ Sept 5 2022 to Till Date VBA DeveloperResponsibilities: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 LOVs & 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 /AnalystResponsibilities: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 2019VB DeveloperResponsibilities: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 2017VBA DeveloperResponsibilities: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, IndiaData 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:Masters in computer science, Sardar Patel University, India. Mar,2018 Bachelors in computer science, Sardar Patel University, India. Mar 2015 |
