Sql Server C#
Resume:
GREGORY GOLDSHMIDT
CONTACT
Owings Mills MD 21117
***********@*****.***
SKILL
C#
MVC
Entity Framework
Ajax
JSON
VB.Net
ASP.Net
Core.Net
Java Script
JQuery
Web Service
RESTful API
MS SQL Server 2000 – 2019
PL-SQL
TSQL
SSRS
SSIS
SSAS
XML
MSBuild
Visual Basic v.3 – v.6
C
C++
Visual C++
ASP
HTML
VBScript
ColdFusion
FoxPro
Dbase
Oracle
NoSQL
AWS
Jira
DevOps
CI/CD
CLEARANCE
Public Trust
CITIZENSHIP
US citizen
Software architect with 30+ years of experience. Extensive experience working with clients and team providing full life cycle development. Has led projects from start to finish both individually and as a team lead. Received individual achievement award from Leidos and recognized on multiple occasions by clients. ACCOMPLISHMENTS
Provided on going and timely support for all applications.
Provided technical consultations to other teams.
Participated in requirement gathering.
Designed databases and architecture for N-tier applications.
Created multi-layered application security.
Collaborated with clients to assure that the clients’ needs are met in the most effective manner within the application framework as well as architected expansion of application as needed.
Supervised teams of various sizes.
Provided technical interviews.
Received numerous written and verbal recognitions from clients. WORK HISTORY
May 2019 – June 2024
SSA Contractor / Sr. .Net Developer V Leidos
Communicated with clients to understand business initiatives and gather requirements to successfully implement solutions.
Designed and developed a web application (containing more than 400 menu items) to support multiple departments utilizing C#, Asp.Net, MS SQL Server 2014-2019, MVC, Entity Framework, AJAX, JSON, and jQuery.
Created data exchange processes with existing systems.
Configured multiple application environments.
Converted MS SQL Server legacy data from previous Asp.Net application to new database structure and integrated into the new Asp.Net application.
Analyzed and rewrote previous classic Asp.Net applications to new application design utilizing MVC and Entity Framework.
Provided data analyses and support for multiple departments.
Created tables, views, stored procedures, functions, and so on. Created database Documentation and presented database schema to the team.
As database administrator, created and configured daily jobs, tuned database for performance, analyzed scripts before applying to production, and created security roles.
Created multiple data reports and data extracts for the clients.
Designed and developed application security by user role profile including a fully customizable application dashboard, navigation pages, available actions, and data record security.
Created and integrated multiple Java Script and C# libraries in the application.
Utilized WAVE browser extension and JAWS application for 508 compliance.
Created an alternative to MS SQL SSIS process to upload CSV files from another system with more than 450 columns utilizing multi-threading. Configured processes as daily jobs on MS SQL Server.
Migrated Excel data to MS SQL Server database structure.
Mentored team members.
Led Agile sprint planning, and daily scrum meetings and worked with the product owner on the product backlog.
Provided development leadership for the team.
Conducted technical interviews for new employers and technical support for other REFERENCES
Available per request
projects utilizing Core.Net and MS SQL Server.
July 2016 – May 2019
System Architect Technical Frontiers Inc.
Participated in the system's design to understand different levels of requirements, technologies, and client expectations.
Designed multiple alternative proposals to clients where had been identified schedule, cost, technology, and so on.
Analyzed and researched the implementation of the non-relation database MongoDB to new projects.
Participated in meetings to design hardware and network structure. Perform cost- benefit analyses for new development.
Created systems and applications design.
Partitioned system on units.
Integrated multiple systems in a single process.
Provided Full SDLC architecture design.
Created database documentation and presented database schema to the team.
Participated in Agile sprint planning, daily scrum, sprint review, and sprint retrospective meetings with developers and clients.
Worked with clients on creating Agile stories and backlog items.
Provided documentation for CMMI III level.
Supported and modified COTs product for Medicare and Medical Services (CMS). Provided administration and customization web portal for CMS. July 2014 – July 2016
Sr. System Analyst Technical Frontiers Inc.
Full SDLC - design, development, and testing of complex web-based and Windows-based solutions utilizing C#, Asp.Net, MVC, Entity Framework, MS SQL Server 2008, AJAX, JSON, and jQuery.
Created Web Services. Created and deployed complex SSRS reports.
Deployed application and database to AWS environment. Implemented one-click deployment.
Automated reports process (creating more than 250 reports per run). Supported and modified COTs product for Medicare and Medical Services (CMS).
Worked on medical records with HIPAA standards.
Created tables, views, stored procedures, functions, triggers, and so on. Created database documentation and presented database schema to the team.
As a database administrator, created and configured daily jobs, tuned database for performance, analyzed scripts prior to applying to production, and created security roles.
Analyzed COT application and MS SQL databases (more than 3400 tables) and created custom processes.
Administrated and developed portal for Center for CMS.
Created multiple applications to provide support with SharePoint, Email, and so on.
Integrated two ways of identification with multiple third-party companies like Twilio, Plivo, and ExTexting.
Created process documentation for CMMI III level.
Participated in Agile sprint planning, daily scrum, sprint review, and sprint retrospective meetings with developers and clients.
Working with clients on creating Agile stories and backlog items.
.
July 2012 – May 2014
Sr. Software Engineer MJM Innovations
Designed and developed technical solutions to guide the team from architecture and design through the full software development lifecycle. Created database documentation and presented the database schema to the team.
Had a working knowledge of state-of-art programming languages and object- oriented approaches in designing, coding, testing, and debugging programs such as C#, Asp.Net, MVC, Entity Framework, MS SQL Server 2008, AJAX, JSON, and jQuery.
Created Web Services and Restful Web Services.
Developed process and object structure flowcharts and documentation.
Worked on more complex projects/issues that require in-depth knowledge across multiple technical areas and business segments while applying industry best practices for architecture.
Worked with both traditional and Agile software lifecycle development. By introducing routing and resetting properties on the Entity Model was able to implement an enterprise-wide website for multiple clients that utilizes a single client database. Integrated abstraction and Unity in object design.
Designed and integrated new features into the existing system while analyzing the impact and providing recommendations for the development. Tuned and improved multiple SQL processes. Created and tuned multiple SSRS reports.
Developed mobile applications for MS Windows phones. Integrated GPS location, map, and messaging systems utilizing multi-threading processes.
Mentored team members and provided code review and analysis for an off-shore team.
April 2012 – June 2012
Sr. Software Engineer Apex Systems Inc.
Observed, analyzed and documented workflow and basic operations for insurance division while helping to maintain and expend a current system using C#, ASP.Net, XML, MS SQL Server, WCF.
April 2010 – May 2012
Sr. Lead Database Developer Educate.com
Provided development and support of the company's enterprise application.
Corrected and improved database synchronization process (more than 350 times) between corporate office (MS SQL Server 2005, C#, Web Service) learning center servers and tablets (MS SQL 2005, C#, ASP.Net web service; CE 2000, C#, WPF service).
Tuned and re-indexed MS SQL Server for better performance.
Configured prototype for the database synchronization and replication processes.
Created tables, stored procedures, triggers, functions, and indexes utilizing GUI and DBCC.
Provided complete MS SQL Server support for the development team (MS SQL Server installation, database design, backup, restore, synchronization, compress, transaction log, security, and so on).
Validated and optimized SQL scripts for production release.
Organized and corrected code structure.
Developed the process to automate the creation of the development databases for the IT group utilizing MSBuild and implemented it in TeamCity.
Created a module to utilize Subversion API in the automated build process. Fixed and improved multiple database processes.
Created and fixed multiple ASP.Net and WCF web services. Developed multi- threading Windows services.
Implemented ASP.Net security (database and WCF service) for vendor's web application.
Analyzed and fixed transaction/synchronization issues.
Fixed Telerik reports and created multiple SSRS reports.
Created technical documentation.
Utilized Agile methodology in the software development process. August 2009 – May 2010
Sr. Software Engineer ATIntegrated
Provided support and developed e-commerce web applications utilizing ASP.Net 2.0 / 3.5.
Created several SSRS reports and processes for extracting data in multiple file formats.
Designed multiple Windows Services, Web Services, and Windows applications for data processing utilizing .Net 3.5.
Provided SQL, PL-SQL, and T-SQL support for the IT group.
Tuned SQL Server 2005 for better performance.
Utilized LinkQ for web application development.
April 2008 – July 2009
Sr. Software Engineer Netlink Research Group.
Worked on multiple web applications utilizing Coldfusion, ASP.Net.
Created database-driven formatting text files process.
Designed multiple web controls.
Implemented SubSonic as part of data tear.
Analyzed and created data conversion process between MySQL and MS SQL 2005.
Troubleshooted VB 6.0 application.
Implemented FTP file transfer in a web application. April 2006 – April 2008
Sr. Software Engineer Chesapeake Systems Solutions Inc.
Provided technical leadership for the Smart Treasury development group.
Designed multiple data processes.
Utilized VB.Net to create numerous multi-threading Windows Services and Web Services for financial data processing.
Created several applications to convert bank payment files into XML file format.
Designed and developed an application to convert XML data files to custom formats like Excel, text, and so on.
Analyzed database to create custom reports.
Created multiple SSIS (ETL) processes and SSRS reports.
Utilized VB Script technology created an installation process for vendor application and deployed it as an installation package.
Created multiple utility applications.
Designed web applications utilizing C#.
October 2001 – May 2006
Sr. Technical Lead / Database Administrator HCIT
Leadership and technical support for the IT department.
Provided complete MS SQL Server development and production support (MS SQL installation, database design, security, memory allocation, tuning, indexing, stored procedures, triggers, functions, jobs, and so on utilized GUI and DBCC.).
Configured MS SQL Server replication, backup, and recovery processes.
Utilized Visual Basic 6 and MS SQL Server 2000 to create several full life-cycle n- tear systems.
Integrated third-party controls into applications, as well as incorporated Windows APIs to streamline the processing of data, graphics, images, and files.
Designed and developed a complete "Optical Shop" system which includes retail, inventory, and order/transfer of merchandise.
Developed a complete Electronic Medical Record (EMR) system which includes the following modules: Application security system, Patient scheduling, Examination, Exam drawing, Image viewer, Scanning, Data point, Exam checker, Messaging, Billing code calculation, Assessments, Letters and Consents, File pulling, Department orders, etc.
Designed numerous applications to synchronize database and file structure for patient records.
Created a completely administrative application to automate the process of client system configuration.
Worked on patient electronic medical records with HIPAA standards.
Implemented database synchronization between EMR and Practice Management System (by MedInformatix) utilizing triggers and DTS processes.
Integrated ASP and MS Office into EMR to process and retrieve patient records utilizing a signature pad (by Topaz) to digitally sign documents.
Developed appointment application under Practice Management System to decrease data retrieval time from 10-15 min to 3-10 sec.
Designed and developed an administrative application for COM+ deployment. Integrated BizTalk server in the file processing systems.
Led installation and configuration of an Application server and MS SQL Server. Installed system in more than 45 locations. Provided technical support and upgrades.
March 2001 – October 2001
Sr. Software Engineer SmConsulting
Developed modules to process data stream from serial port.
Created mapping tools to map universal customer swiping card to database.
Created auto e-mail process.
Developed custom ActiveX controls to for custom e-mail.
Designed n-tear application structure.
Integrated multiple custom and third-party controls into application. April 2000– February 2001
Sr. Component Developer SciTutor.com Corp.
Created business modules and rules for development process.
Developed COM, COM+, ActiveDLL, ActiveX components utilizing Visual Basic 6.0.
Created multiple systems for the company and production use.
Involved in design and implementation of multi-teard for web applications.
In charge of the development process on MS SQL Servers.
Provided technical support for the web development team. May 1999 – April 2000
Programmer Analyst AEGON Corp.
Maintained and developed variety of applications for multi-user environment utilizing SQL Windows, Visual Basic 5/6.
Provided support desktop applications on SQL Windows.
Created batch processes using SQL, VBScript, MS-DOS, SQL Windows, and Visual Basic.
Created and supported data transmission systems.
Provided a full life-cycle technical support and maintenance for applications.
Developed diagrams, documentation, and specs.
April 1997 – February 1999
Programmer Analyst Unitel Corp.
Developed variety of applications for telemarketing services.
Created front-end and back-end applications utilizing Visual Basic 3/4/5 and MS SQL Server 6.0/6.5, MS Access 95/97, dBase III, Oracle.
Integrated outbound telemarketing applications with DAVOX Unison System, which interacts with E-mail, fax and FTP servers.
Created reports using MS Access and Crystal 5.
Developed modules for data transmission.
EDUCATION
1990
Bachelor in Computer Science
Polytechnical University, Odessa, USSR
Contact this candidate