SUMMARY:

• Versatile, detail - oriented, and accomplished professional, offering proven expertise in various aspects of business processes and technologies. Recognized for surpassing challenging goals and expectations in demanding technological environments.
• Adept at overseeing all aspects of process analysis, development, and user support. Capable of working and collaborating effectively with staff and other professionals in the industry. Equipped with strong multitasking, problem-solving, and interpersonal skills.
• Software Implementation and Functionality | Programming and Testing | System Configuration
• Troubleshooting | Problem Analysis and Resolution | Quality Control and Assurance | Customer Service
• Staff and Development | Leadership and Team Building

TECHNICAL SKILLS:

Languages: VB.Net, Web Forms, ASP.NET, T-SQL, JavaScript, HTML C#, Entity Framework, Model - view - controller (MVC), Web Forms, LINQ.

Application Servers: SharePoint, Microsoft Communications Server 2007.

Databases: SQL Server 2000/2016, Access.

Development Software: Visual Studio, .net Framework 1.1-4.5, SSRS, SSIS, TFS, SharePoint Designer, Unit Testing, Razor, JSON, CSS3, Generics and Reflection, and Web API, SOA

Operating Systems: Windows 2008/2003/2000 Server, Windows XP/7/8, Multiple Virtual Storage (MVS)

Productivity: SSMS, SSRS, SSIS, Team Foundation Server, Visual SourceSafe, SVN, Git, ImageNow, InfoPath, Microsoft Office, Visio, Primavera, Advent Portfolio Management, Advent Moxy Microsoft Solomon/Great Plains Dynamics, SharePoint Designer, Reporting Services, Crystal Reports, FRX, Power BI.

PROFESSIONAL EXPERIENCE:

Confidential

Sr.SQL Developer

Responsibilities:

• Develop ETL process with SSIS to retrieve data from MS Excel and MS SQL database.
• Create Stored Procedures insert data to third party app.
• Test and implement imports and exports on Clients environments.

Confidential

Sr.SQL Developer

Responsibilities:

• Google Analytics API.
• HubSpot API.
• SQL through SSMS
• Create SSIS packages and implement process.
• Create Stored Procedures insert data to third party app.
• Power BI

Confidential

Sr. SQL Developer/Dot net C#

Responsibilities:

• Analyze data from multiple systems and document processes to retrieve data
• SSRS reporting for specific accounts.
• Creation and modifying SSIS packages to extract account data from Excel and MS SQL.
• Generate SSRS reports including graphs for agents to engage with clients.

Confidential

SQL Developer/Dot net C#

Responsibilities:

• Analyze data from multiple systems and document processes to retrieve data
• SSRS reporting for specific accounts.
• Creation and modifying SSIS packages to extract account data from Excel and MS SQL.
• Generate SSRS reports including graphs for agents to engage with clients.

Confidential

SQL Developer/Dot net C#

Responsibilities:

• Research MS SQL encryption and implement.
• Build scrips to test encryption.
• Securing data from client to servers using MS SQL encryption.
• Create C# modules to manipulate data to conform to business rules where SSIS/ETL could not handle.
• Modified ASP.NET Web applications to display more information.
• Generate SSRS reports including graphs for agents to engage with clients.

Confidential

SQL Developer

Responsibilities:

• Data retrieval from various data sources from Clients application importing to Business Central.
• Did analysis with Accounting for extraction from Dynamics to Excel.
• Did analysis with marketing for import and export from Azora subscription management application.
• Create C# modules to manipulate data to conform to business rules where SSIS/ETL could not handle.
• Generate SSRS reports including graphs for agents to engage with clients.
• Develop TSQL queries to gather data for troubleshooting and if possible correct data.

Confidential, FL

Sr. Software Engineer/SQL Developer

Responsibilities:

• Tasked with implementing a data warehouse in SQL 2016 of Zuora subscription system.
• Create accounting and marketing reports from the data warehouse using Power BI, SSRS.

Confidential, FL

Software Engineer/SQL Developer

Responsibilities:

• Implemented various workflow to improve internal processes.
• SQL/Azure through SSMS
• Conversion on 200 plus VB6 apps to dot net (C# and VB.Net).
• Developed and debugged SQL 2016 stored procedures to speed up business processing.
• Conversion of user SQL accounts to Service accounts (200 + apps)
• Developed SSIS packages and SQL stored procedures to reporting tables.
• Developed reports with SSRS to consolidate date from various data sources.

Environment: VB6, C#, VB.NET, Microsoft SQL, PowerShell Scripting, CI/DC- Jenkins.

Confidential, West Palm Beach, FL

Software Engineer

Responsibilities:

• Installed SharePoint 201 3 and rebuild internal portal.
• Implemented various workflow to improve internal processes.
• Upgraded MS Great Plains Dynamics.
• Developed ADP integration to Data Warehouse.
• Developed Data warehouse, populated using SSIS and SQL stored procedures.
• Developed reports with SSRS to consolidate date from various data sources.

Environment: ASP.NET, SQL, SSIS, SSRS, DI360 - Data Warehousing, SharePoint 2013, C#.NET, CRM 2016,.

Confidential, Boca Raton, FL

Web Developer

Responsibilities:

• Development of PowerShell script in order to track and correct SQL Trigger errors across all databases.
• Maintained ASP.Net MVC applications.
• Added various SharePoint Document libraries to multiple projects.
• Environment: ASP.NET, Microsoft SQL, C#.NET, PowerShell.
• Drove inhouse databases with SSIS gathering info from various sources.
• Developed reports with SSRS to consolidate date from MS SQL.

Confidential, Juno Beach, FL

PGD Technical Services

Responsibilities:

• Took part in designing and utilizing web-based reliability of inventory of assets application through the use of Visual Studio 2010, C#, ASP.NET, Entity Framework, MVC, SSRS, TSQL and VS Unit Testing.
• Presided over the development of data model with the use of Microsoft Power Pivot published for SharePoint, as well as the production of SSRS to access data.
• Developed various services using Windows Communication Foundation (WCF) to read/update/edit and delete various data.
• Redesign existing applications to MVC framework.

Environment: ASP.NET, MVC, C#.NET, WCF, Entity Framework, TSQL, Visual Studio 2010, SharePoint.

Confidential, Boca Raton, FL

Web Developer

Responsibilities:

• Successfully created the design and led the application of web-based tracking of services application using Visual Studio 2010, C#, ASP.NET, SSRS, Crystal, and TSQL.

Confidential, Juno Beach, FL

PGD Technical Services

Responsibilities:

• Played an integral role in the augmentation of centralized integration through the use of Visual Studio 2010, C#, ASP.NET, and TSQL for integration.
• Proactively contributed to the development and utilization of web-based reliability of Wind Turbine performance application with the use of Visual Studio 2010, C#, ASP.NET, SVN, SSRS, and TSQL.

Confidential, Boca Raton, FL

Microsoft Customer Relationship Management (CRM) Developer (Contract)

Responsibilities:

• Monitored and modified various SharePoint sites via add-ons and SharePoint Designer.
• Executed thorough assessment of diverse business processes and technologies with regard to customer relations and data systems monitoring to ensure improvements and further develop processes.
• Initiated the development of centralized integration by using Visual Studio 2008, C#/VB.NET, ASP.NET, MVC JavaScript, .NET Framework 2.0-3.5, and TSQL for the integration of Microsoft CRM, SharePoint, and Outlook.
• Develop an InfoPath form available to all employees via SharePoint, form needs various dropdown controls that can be maintained by department managers.

Confidential,West Palm Beach, FL

Business Intelligence Officer

Responsibilities:

• Accomplished all facets of DBA duties on all SQL 2000/2005 databases.
• Led the development of C# application in order to support the Active Directory and BlackBerry development.
• Directed the generation of InfoPath forms for all employees from the internal departments through SharePoint workflows, which enabled various dropdown controls maintained by department managers.
• Expertly utilized SharePoint Web Services and Software Development Kit (SDK) for the development of various integrations to be used in creating various SharePoint document libraries.
• Provided technical support for Primavera.
• Spearheaded the development of Windows Communication Foundation (WCF) application for cleaning up unstructured SharePoint sites.
• Used SharePoint SDK to create Document libraries attached to MS CRM accounts.

Confidential, West Palm Beach, FL

Director - Information Technology

Responsibilities:

• Closely collaborated with senior planners, consultants, and employees in identifying current requirements and future business needs while emphasizing in the creation of strategies to ensure high-system efficiencies.
• Exhibited proficiency in designing, developing, and implementing accounting applications necessary for reconciling and integrating online systems.
• Developed import and export for various brokers (Fidelity, Schwab, ect).
• Supported Advent Moxy trading system.
• Pioneered the generation of CRM update modules by using SQL scripts for migrating and rearranging data fields which resulted to the enhancement of efficiency of CRM data.
• Achieved comprehensive knowledge on planning and executing Remote Setup for multiple disaster recovery (DR) sites.