Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Tampa, FL
Salary:
$85000
Posted:
September 25, 2017

Contact this candidate

Resume:

A. Michael Seghi

*** *********** ****

Valrico, Fl. 33594

Phone: 813-***-**** Cell: 813-***-**** Email: ac2ge7@r.postjobfree.com

Skype name: albert.seghi

OBJECTIVE: To continue my IT career in C#, VB.net, ASP.net, MVC, Web API, Win Forms, TSQL / PL-SQL, and MS Office / Interop application development.

SKILLS: Twelve years Microsoft .net C# and VB.net, OO Architecture and design, ASP.net, ASP, Win Forms, WPF, Visual Studio 2005-2013. Expression Studio 4, TFS and Subversion, Unit Testing, MS Access, MS Office Interop coding, Visual Basic 6, MS SQL Server/T-SQL 2005 – 2012, T-SQL, LINQ and PL-SQL queries, ADO.net, Log4Net logging, Crystal Reports, MS SQL Server/T-SQL Reporting Services (DYNAMIC SSRS), SSIS, WWF, RDBMS database management, Entity Framework, SOAP, SFTP, XML, HTML (5), DHTML, XHTML, EDI, CSS, JavaScript, Ajax Toolkit, JQuery, AngularJS, WWF, IIS and (WCF) Web Services, Amazon AWS, and SharePoint Web Parts. Telerik and Kendo controls. Also, have training in Xamarin Mobile phone development. All projects used the ITIL, Agile, continuous waterfall and testing methods. Projects from and including Johnson and Johnson were also using the SCRUM development environment. All development projects, especially contracts, used MS Project to track my development progress.

Recent Certifications: Brainbench C# 4.0 and .NET Framework 4.0

EMPLOYMENT:

21Tech 4/4/2016 – 1/27/2017

L3 Software .Net Developer

Remote contract with Thomson Reuters

Oakland, CA

•Software Development on, Thomson Reuter’s Aumentum, municipal tax application using Visual Studio TFS 2015 and SQL Server 2014. All coding was done in C# /ASP.net. /ASP.net MVC. I was assigned to the PPA (Personal Property Assessment) team.

•Designed Windows Workflow Foundation Workflows utilizing custom coded activities, queues, flags, and page navigation per user story tasks. This was a windows application using SFTP file transfers from assessors.

•Created and modified stored procedures and resultant, proprietary data services using SSIS, for new functionality and modifications of the tax application.

•Created two new ASP.net MVC web pages using AngularJS, Telerik, and Kendo controls.

Aditi Staffing 8/17/2015 – 12/31/2015

Senior Software Developer – Verizon Inc. contract

Tampa, FL

•Redesign and performance improvement of Verizon’s iCollect Payment System, including analysis of all stored procedures, introduction of AJAX into the application to limit full page post backs and analyzing 2370 stored procedures within a Scrum/Agile structure. I developed changes and additions using C# and VB.net, WCF, WEB Services, ASP.net, SSIS, and T-SQL.

•This inventory of stored procedures was made manageable using my Visual Studio Windows application to log the stored procedure name, containing procedure, the calling procedure and the exact location, by line number, in the code file. This report was quickly generated using the debug/output window while executing the iCollect application’s many functions using available test scripts.

•The iCollect databases had been updated to SQL Server 2012 in 2014.

•ICollect was written in both C# and VB.net using WCF and WEB services.

T2 Software Services Inc. 10/8/2014 – 11/21/2014

Senior Software Developer

Contract with Brailleworks

Seffner, Fl.

•Designed and developed a, C#.net, Windows application to work within several MS Access applications, using interop, to facilitate the movement of MS Access application versions from Development to either User Acceptance Testing or Production environments. This included automatically relinking tables to SQL Server/T-SQL.

•Designed and developed a second C#.net Windows application to monitor all three of Brailleworks main product lines and allow the removal of a very time consuming and inefficient, monitor process within the MS Access applications. This improved the refresh of job workflow statistics from approximately 1 minute to only 3 seconds. This Windows application also featured both a manual and automatic refresh setting. It used T-SQL Stored Procedures to determine the job statuses.

•Developed a third Windows application that took in USAA XML/EDI 837 claims data and checked for valid XML and EDI data to be input into a database for document creation. SSIS and SFTP were used to transfer and validate these files.

TrueFit 7/08/14 – 10/3/14

Senior Application Developer

Remote contract with Fidelity Information Services (FIS)

Jacksonville, FL

•Part of a team that was part of a massive migration of FIS servers to other cities. This included the gathering and cross checking of details such as Windows Services, Web Services, IP and endpoint addresses, file shares, disaster recovery site relocations, application dependencies on over 35 applications, etc.

•Technical lead on determining, assigned, application dependencies and server details. This included production, pre-production and DR servers.

•Worked with offshore team in Bangalore India to produce workbooks detailing the, above, types of technical information that needed to be replicated in the new location. Extensive SharePoint use in documentation. My assigned applications were C#.net, ASP.net 4.0, ASP.net 4.0/MVC, SSIS, SFTP, and Windows applications.

FutureNet Group 12/02/2013 – 3/31/2014

Contract with Department of Homeland Security (DHS) Federal Law Enforcement Training Center

Senior Software Developer III

Glynco, Ga.

•Developed two new pages, as part of FLETC’s CMTIS lesson management system, to enhance the usability of editing data within the two areas of CMTIS. One area was ALM (Area Learning Management) and the other was regarding user role management. A Telerik grid control, with JavaScript and JQuery/AngularJS/Ninject, was the main feature used to develop the new, ASP.net 4.0 MVC, page for ALM. A code first, Entity framework, was used for the SQL 2012 database interface. The role management page incorporated ASP.net 4.0 MVC, using JQuery/AngularJS/Ninject, Kendo grid, accordion and slider controls, to allow the grouping of role assignments. Code first Entity Framework was also used in this page’s database interface. Also, developed Web Parts in CMTIS SharePoint application. This project used SQL Server/TSQL2012.

•Developed a Windows application to allow the input of InfoPath documents into the Lesson Plan database of CMTIS. This was accomplished using a Windows form application to parse the InfoPath document’s (non-standard) XML) into a valid, SSIS usable, XML file. This file was then sent via SFTP and used by an SSIS package to insert data into the Lesson Plan database.

•Developed a WCF application, as part of the CMTIS project, to interface with the Plateau Learning Management system server. Used LINQ queries where needed.

JP Morgan & Chase 7/09/2012 – 8/1/2013

Senior Application Developer

Tampa, Fl.

•Developing enhancements and code fixes to Chase’s Mortgage Express product.

•Coding environment: C#, TFS Visual Studio 2010, Windows 7, WPF, ASP.net, SQL Server/T-SQL 2008, PL-SQL, TFS and Subversion, Windows Services, SFTP, SSIS, WCF Services, MSMQ, JavaScript, JQuery/AngularJS, Cigital and Fortify code analyzers, Log4Net logging, Entity Framework, and an extensive change management system including, Fast, Jira, Crucible and Confluence.

•Level 4 support within an onshore and offshore development group.

•I developed several new applications within Mortgage Express, such as, a WCF service that tracked more than twenty roles to ensure that the roles were always in sync with a roles security database. This application also used WWF.

•Planned and documented code releases for seven levels of application changes.

Cynetics – contract with Coca-Cola Enterprises 7/05/2011 - 6/29/2012

Senior Software Developer – Cooperative Trade Marketing WEB Site

Brandon, Fl.

•Full lifecycle, VB.net/ASP.net, development, including extensive customer requirements gathering, and testing, of a, web based client server, marketing application used to plan, track and fund special promotions for Coca Cola’s largest customers. It utilizes an approval process of 3 to 4 stages of approvals, which are confirmed through automated emails. These promotions are developed through elements, designed within the application, by CCE’s finance department and submitted to sales for the assignment of funds and fund forecasts within each element.

•This application was developed using TFS Visual Studio 2010 (4.0) with VB.net and SQL Server/T-SQL 2008. Forecast reporting is being developed using Reporting Services (DYNAMIC SSRS) and legacy Excel data entered an SQL Server/T-SQL 2008 database using SSIS packages. The application’s design utilizes a three-tiered architecture, using only stored procedures, connected through groupings of class structures. Also, used HTML, CSS, Ajax, and JavaScript in this web application.

Collabra – contract with J.P. Morgan Chase 8/2010 – 5/31/2011

Application Integration-Client Server Lead Developer

Tampa, Fl.

•Gather customer requirements, design, develop, test and provide technical support for new and existing, in house developed, automation functionality and utilities based on the Line of Business application provisioning requirement. This automation, mainly Windows based, application used TFS Visual Studio 2010 and C# 4.0 with WCF being used to link the various browser automation programs to the main ticketing database application. Coded JavaScript functions to enhance the UI as needed.

•Identified data issues and provided recommendations for resolution to ensure optimal performance. Performed unit testing using “test driven development”.

•Language used is C# with DOM Developed, Win Forms and Web Forms.

•Used Oracle PL-SQL queries for support ticket data. Log4Net used for logging.

•Define and substantiate C# and .NET architectures and patterns.

•Gathered customer’s business requirements for each of the automation projects.

•Ensure best practices are applied and integrity of data is maintained through SSO security, documentation, and change management. ClickOnce used for installs.

•Plan, design, and implement application database code objects.

•Developed custom SharePoint 2010 Web Part pages and Workflows.

•Developed Use Cases through customer meetings to design Change Control Requests for new projects and for changes to current applications.

•Design flow charts in MS Visio for Change Control Request, SharePoint, and RAD.

•Gathered user requirements, designed and coded a time tracking, ASP.net, application used by the Access+ call center to gather call center metrics. This was coded in C# using an MS Access database. All timesheet reporting is being done using Reporting Services (DYNAMIC SSRS). Used SFTP to transfer files from the Access call center.

Comsys – contract with Johnson and Johnson - Vistakon 11/09/2009 – 1/12/2010

Senior Software Developer

Jacksonville, Fl.

•Developed a manufacturing, contact lens sterilizer, monitoring Windows application using TFS Visual Studio 2010 C#.NET 3.5 / Excel (using the Interop Namespace) and Oracle PL-SQL queries. Gathered customer requirements for a regulated environment where close monitoring of the manufacturing process was required. This application utilized Reporting Services for all sterilizer data in a, constant, real time environment. This was a full life cycle development effort, including testing.

Clayton Inc. 3/16/2009 – 4/10/2009

Programmer Analyst

Tampa, Fl.

•Part of a team that generated a C#.net 3.5, Windows application which automatically provided customer loan data to the call center agents on outbound calls. Also, gathered user requirements from the loan servicing agents. This application used SQL Server with TSQL programming.

•Created new Excel macros to streamline the morning MARS to Five9 dialing data feeds. This decreased the time required for data scrubbing, for invalid telephone numbers, missing loan numbers, etc. Utilized Reporting Services for all dialer number history including other client information.

•Monitored call center productivity for call rates and percentage of dials completed within the Five9 application and adjusted Five9 settings as required.

•Ran SQL Server/T-SQL 2005 queries for the generation of loan data reports, usually supplemented by the generation of Excel pivot tables, using C#.NET 3.5 / Excel applications that I developed. Performed unit testing as required.

GDKN 6/18/2007 – 11/20/2008

Infrastructure Technician – Nuclear - Florida Power and Light contract

Pembroke Pines, Fl.

•Development and support of a, TFS Visual Studio 2008 and C#.net 3.5, Windows application for tracking student qualifications relating to control room simulator training. This included a project, within this solution, to convert and load 300+ MS Word documents, into an SQL Server/T-SQL 2005 database, to allow for more efficient editing of simulator scenarios. These sections of MS Word documents were then pieced together using Reporting Services. This Windows application was generated using Visual Studio 2008.

•Development and support of an instructor monitoring application in using ASP.net and WCF. WCF was used to access the application from the web. Application is used to observe instructors, during class, making observations on many key areas. A scoring system is then reported, summing up their scores. This is a C#.net 3.5 conversion to ASP.net, also using JavaScript, with an SQL 2005 database. The code behind files were developed using VB.net.

•Design and implementation of a new, Plateau, learning management system(LMS), using a C#.net 3.5, linked, Oracle PL-SQL queries, to correctly reflect Florida Power's, Nuclear Training Department training structures. This included writing complicated PL-SQL queries within the linked C#.net 3.5 Oracle database. Developed a C#.net 3.5 Windows application, using this SQL Server/T-SQL database, to verify database changes resulting from the additional LMS training structures. Performed unit testing as part of a test-driven development group.

•Developed a student QualCheck, C#.net 3.5 ASP.net, application to track the manual granting of credits for inclusion into our new LMS structure.

A-1 Temps 3/13/2007 – 4/9/2007

Programmer Analyst - Cyprexx Inc. contract

Brandon, Fl.

•Developed Dymo label printer Windows interface, including 5 C#.NET 2.0 to API interface modules and 1 form, as part of a C#.net, 3.5, application, to allow for the printing of labels to 12 network DYMO label printers. This allowed for agents to choose their preferred printer for label printing.

Century Staffing 5/2/2006 – 2/23/2007

Software Data Mining Developer – Verizon Inc. contract

Tampa, FL

•Gathered customer requirements and developed an Open Orders tracking Windows application using Visual Basic 6 with a C#.net/SQL database with input from Excel spreadsheets and MS Dynamics CRM. Developed extensive, C#.net, to automate the correction and conversion of Excel documents to successfully load into the Access database. This Open Orders tracking application improved the efficiency of tracking open orders by greater than 50% by automating the process of entering and reporting on aged order data from the field.

•Gathered customer requirements and developed a Claims Windows application used in tracking Claim status and performance metrics. All data manipulation was done using C#.net to process Excel spreadsheet imports and exports, detailed data forms and SQL/T-SQL database commands. Also, used MS Dynamics CRM for customer information. This claims application also used EDI data for the tracking of claims information for individual customers and suppliers.

•Developed Crystal Reports for the OpenOrders and Claims applications. Both Windows applications used the CRVIEWER DDL as a Crystal Reports viewer within the applications forms. This viewer was fully integrated into the application.

•Developed C#.net 2.0 Interop/Excel Windows applications to manipulate Excel spreadsheets to import Excel ranges into separate database tables, in other projects, as required. Also, was used as a general, Crystal Reports developer, resource.

Special Data Processing 7/2005 – 5/2/2006

Customer Service Representative

Clearwater, FL

•Took temporary position, telecommuting from home, to attend Techskills Microsoft C#.net training.

Spherion 4/2005 – 7/2005

Programmer Analyst - Home Depot contract

Tampa, FL

•Gathered customer requirements and developed a C#.net 3.0 / Excel Windows application to automate Excel operations.

•This Windows application converted Excel spreadsheets, using Interop and the Excel object, and imported them into an SQL Server/T-SQL database.

•Created reports using Crystal Reports from the above SQL Server/T-SQL database.

Gunn Allen Financial 7/2004 – 4/2005

Financial Advisor

Tampa, FL

•Series 7 license NASD #4826117 – Licensed on 11/2/2004

•Prospecting for new clients

•Signing up new clients to accounts

Researching several business opportunities. 12/2003 – 7/2004

Verizon Data Services 6/1998 – 12/2003

Systems Engineer II

Temple Terrace, FL

•Working within the Production and Planning Management (PPM) group, reporting to senior and executive management.

•Developed Visual Basic.net application, using ASP.net, to front end the generation of various Crystal Reports and keeping a C#, .net, SQL Server/T-SQL database, current with the latest server performance data.

•Developed a C#.net application which used the Interop Namespace to import Excel spreadsheets from the field and in generate various reports, in PowerPoint format, for over 1500 Verizon servers. This application involved PowerPoint automation coding.

•Generated several other C#.net Windows programs to automate Excel and Access database functions, queries to track Verizon call information.

•Utilized self-written SAS mainframe programs to generate graphs and publish to the company intranet.

•Generated reports on Verizon’s Unix, and AS-400, servers using data gathered from, BMC Corporations, Best/1 product.

•Configured Best/1 application to report and analyze the exact data that Verizon or Verizon’s client requested.

•Attended several Verizon C#.net, JavaScript, Java, UNIX, etc. training courses.

•Used Prognosis, by Integrated Research, to help provide production support for all Tandem systems. Worked with the development group on COBOL, SQL, and SCOBOL (Pathway) performance issues. Provided these reports to senior and executive management.

•Also, maintained PPM’s ASP website using Microsoft FrontPage, JavaScript, XML, HTML, CSS, FTP, and PowerPoint, Excel, and Word functionality.

Davron Associates 4/1998 – 6/1998

Programmer Analyst – Raymond James and Associates Inc. contract

Tampa, FL

•Tandem consultant for a 3 month, Y2K project, at Raymond James and Associates. Analyzed and coded necessary changes in Cobol85 and Scobol programs for Y2K compliance.

Health Resources 2/1998 – 4/1998

Programmer Analyst

St. Petersburg, FL

•Using VB 5 and Crystal Reports developed a client to download data into an Access database, via FTP, into the new Pharmaceutical Coupon project. Developed a reporting function within this application to easily generate Crystal Reports to upper management.

HBL, Ciscorp, Lear Data, Computer-People 5/1995 – 2/1998

Programmer Analyst

Various cities

•Contract with Litton Industries / U.S. Air Force, located in Dayton Ohio, to convert a main server from flat file processing to SQL table processing.

•At McGregor Medical, located in Houston Texas, modified Tandem Cobol programs to allow for Visual Basic data-type matching within the Visual Basic API.

•Contract with NDC, located in Atlanta Georgia, to perform Q/A using EDI data for a commercial banking application. Developed TACL utility to allow client to easily generate EDI test data for development and the client’s customer’s SLA agreement for purchasing the EDI application. This application used 835, 837, 820, and 829 EDI X12 formats.

•Contract with GTE Data Services, located in Temple Terrace Florida, to modify COBOL85 and SCOBOL code for Y2K compliance, along with documentation updates.

•Contract with Key Bank, located in Cleveland Ohio, to improve the efficiency of their ATM application, written in TAL.

•These contracts required extensive customer requirements gathering.

Computer Horizons 11/1992 – 5/1995

Programmer Analyst – GTE Data Services contract

Tampa, FL

•Long term outsourcing contract with GTE Data Services. Responsible for the installation of new releases of GTE Data Service's UMS (Universal Measured Service) billing system.

•Coded and maintained COBOL85 production support and development code. Generated several Enable (Pathway) applications for use in regression testing for the, request for testing, guidelines from the billing department.

•Consultant at Dell Computers, located in Austin Texas, where I recommended, through detailed customer requirements gathering, a project that merged the two primary servers in Dell Computer’s order and manufacturing tracking system. This project was the primary factor in allowing Dell to cut the order and configuration process down to one shift. This allowed the system build process to run during the remaining two shifts. This method eliminated Dell’s system build backlog problem.

•Responsible for generating a complex TACL macro, which reduced the installation group by two thirds. This macro included making all COBOL, SCOBOL, and SQL, Flat file, table, and program changes automatically.

Tandem Computers 2/1982 – 11/1992

Sr. Support Engineer / Systems Manager

Tampa, FL

•Systems Manager for in-house Tandem system for customer demonstrations, new release testing, training, and checking customer software compatibility.

•Installation and maintenance of Tandem computer equipment at various companies such as Equifax, GTE Data Services, NCNB, Home Shopping Network, Raymond James, Leroux Pitts and Associates, Transnet Corporation, Central Command (MacDill AFB), E-Systems and Watkins trucking.

EDUCATION:

•Master of Business Administration

Nova Southeastern University – Ft. Lauderdale, FL 2/1990 – 8/1992

•Bachelor of Computer Information Science

Florida Metropolitan University – Tampa, FL – 6/1985 – 10/1988

•Associate of Arts / Certificate in Computer Programming

Hillsborough Community College – Tampa, FL 6/1983 – 6/1984



Contact this candidate