Senior Sql Developer Resume
Jacksonville, FL
Objective:
- Lead/Sr. VB.Net Software Designer/Developer And/Or
- Lead/Sr. Data warehouse Architect.
- Lead/Sr. Business Intelligence Developer (ETL, SSRS, SSIS, Optimization) And/Or
- Lead/Sr. SQL DBA And/Or
- Lead/Sr. System Network Administrator.
Experience:
Over fifteen years of experience in designing and developing complex software windows applications and web applications. Highly experienced in SQL optimization, TSQL integration, ETL and SSRS developments. Designing, implementing and supporting client and company networks. Building, repairing and maintaining servers and client machines.
- Developing Tools: VB.Net 2010 Team Foundation, VB.Net 2008 Team Foundation, ETL, SQL Optimization, VB Script, Crystal Report 11.0, Infragistics Controls, Visual Basic 6.0, VBA, Business Intelligence 2008, SQL Server 2008 R2, SSRS, SSIS, SQL Service Broker, SQL Server 2005, SQL Server 2000, Ms Access, SQL Synchronization, Install Shield Professional 10.0.
- Administration Tools: IIS, MS Exchange Enterprise Edition, ISA Server. VMware Server. Remote Administrator Tools
- Operating Systems: Windows 7, Windows Vista, Windows XP, Windows 2008 servers, Windows 2003 servers, Windows 2000 servers, Active directory, Windows NT, Windows ME, Windows 98, Windows 95, Windows 3.11, Dos 6.22.
Education:
- Completed Course 1579 Accelerated Training for Updating Support And Designing a Directory Services Infrastructure For Windows 2000.
- Microsoft certified professional (MCP) in designing, implementing and troubleshooting Windows NT domains.
- Bachelor degree of computer science.
Accomplishments:
02/11-Present
Senior SQL Developer, Confidential Jacksonville, FL
- Lead a team of report developers; taught them how to write optimized SQL to have the report created within 3 seconds. Using BI Developer 2008, TFS 2008, SQL Server 2008.
- Designed and developed a multithreaded .NET application to collect all the domain users and domain computers and the relationship between the users and the computers from all forest domains. Using VB.NET 2010, TFS 2010 and Active directory 2008.
- Designed and developed software to collect data from Excel forms with various format styles containing dynamic fields and then imported it to SQL server. Using VB.net 10.0, SQL Server and Excel workbooks.
- Designed and developed software to extract data into files and send it to its destinations through email or FTP or file share using VB.net and SQL Server.
- Designed and developed a tool to create xml index files to be imported by LPS, using Vb.net 2010.
- Developed over 80 reports which include To Do Tasks, Inventory, Aging, pipelines and performance using SSRS, SQL Server.
- Designed and developed the data warehouse and integrated it with various data sources from LPS and Imageweb using SQL Server 2008 R2 and SQL Diagram Manager.
- Streamlined our department process by designing and developing a request form through share point and integrating it with our in-house tracking software using Share point, SQL Server 2008 R2 and SSIS.
- Supported three separate departments by dealing directly with them as customers, collecting Report specifications and then designing and developing the reports, using SSRS, TSQL and SSIS.
- Fixed our integration process by stabilizing it and optimizing it to speed it up from three hours plus to under one hour. Using SQL Execution Plan and SQL Server 2008.
09/06-10/2010
Senior Software Developer, Confidential Jacksonville, FL
- Designed and developed the data warehouse for the repository database and integrated it with various data sources using SQL Server 2008 and 2005 and SQL Diagram Manager.
- Designed and developed the in-house Database data replication across SQL servers using SQL Server 2008, SQL Server 2005, SQL Server Replication, SQL Service Broker and SSIS.
- Automated and stabilized the book keeping software. Built the system so it auto recovers itself.
- Designed and developed Windows Service to handle all synchronizations across all platforms. Using Vb.net, WCF, XML, SQL Server, Oracle, Com objects
- Removed all rounding problems so that all their accounting calculations match 100%.
- Designed and developed the in-house Inventory Management System software. It’s a buying and reordering system. Using VB.net, ASP.net, JavaScript, ADO.NET, SQL server.
- Shared in modifying SOP’s to improve performance and data integrity.
- Identified and developed needed tools for several departments.
- Searched, identified and resolved most of the systems bugs.
- Designed and developed the in-house Reports using SSRS and Crystal reports 11.
- Developed a watchdog service to watch and restart in-house services that used to fail.
06/05-09/06
Senior System Manager, Confidential Boca Raton, FL
- Evaluated the current network and software situation in the company and thus developed and prioritized my task list on my own.
- Improved the QA department by designing and implementing software tools. With these tools it takes less than 5 minutes to generate QA reports instead of several days. Using VB.Net, Oracle Server, SQL Server, Crystal Reports 11.
- Developed software for the company to accomplish scientific calculations of test results instead of the commercial software which saved them over $30,000. Using VB.Net, SQL Server, Office Applications.
- Redesigned and implemented the network to be dynamic. Implemented a redundancy system. That way we were prepared for any kind of disaster.
- Removed security holes that existed on the network.
- Allowed Remote users to be able to work on the network as if they are physically inside the company utilizing remote VPN, terminal services and remote printing capabilities.
12/02-05/05
Senior Software Architect, Confidential New York, NY
- Lead programming team to redesign and implement the existing Eyeweb software that offers a digital simulation for clients in the optical industry. Using VB.net, VB6, VBA, ADO.NET, SQL server, Access, XML, Install shield, industrial digital cameras and sonar systems.
- Added hidden tools for recalibration for the measuring system.
- Added hidden tools for color calibration for the simulation system.
- Redesigned the camera, light, and sonar code to be capsulated objects allowing the software to be independent on the hardware.
- Redesigned the multi language resources to be isolated from the core of the application.
- Automated the creation of the installation process.
- Improved the production of frame generation by designing and implementing software tool for the colleagues. With the tool it takes 10 minutes unattended to generate 100 frames instead of a week.
- Designed and implemented the in-house software for the company. Using VB.net, VB Script, ADO.NET, SQL server, Network remote security and Install shield.
- Moved all the databases from Linux and Oracle to SQL server. Continued maintaining the database on the SQL server.
- Designed and implemented the network for the main office. Using Windows 2k, active directory, ISA server 2.0, DNS and Windows XP Clients.
- Designed and implemented the network for the branch office in New Jersey. Merged the network across the internet with the main office. Using Windows 2k, active directory, ISA server 2.0, ISA Channels, Windows 98 Clients and Windows XP Clients.
7/1998 – 9/2002
Senior System Architect, Confidential, Edison, NJ.
- Responsible for the architecting process for all client software and maintaining the in-house network.
- Lead a programming team in developing “The Con$ultant” for “Ondeo-Nalco” in Chicago. Focused on designing and implementing the database and the middle-tier objects, which allowed smooth communication to the database and speeding of developing the interface. These objects provided the capability to complete every form within 2 hours. Using VB, SQL server, SQL Synchronization, network remote security and Install shield.
- Designed and implemented 3 tier synchronization schemas for processing data for the clients, who can’t use direct connection. Using SQL Synchronization and network remote security.
- Developed a tool for “BASF” in Germany to transfer data between their Oracle server and “Fieldnotes” software. Using VB, Oracle server, MS Access and Install shield.
- Lead a programming team in developing “Oasis” software for “Dow AgroSciences” in Indianapolis, Indiana. Using VB, Oracle, Oracle Lite and Install shield.