Post Job Free
Sign in

.Net Architect Sql Server

Location:
Dearborn, MI
Salary:
145,000 per year
Posted:
August 21, 2024

Contact this candidate

Resume:

BA/Sr. Developer / Architect

Summary

Over ** years overall Software Engineering experience

Over 15 year’s .NET with SharePoint programming experience

Over 5 years Business Analysis

Over 6 years Java programming

Over 8 years System Analysis experience

Over 15 years SQL Server experience

Technical Skills

C/C++

VB6.0

Composite Software 6.1

Tomcat, IIS

Java

Visual C#

SharePoint

STS

Android Mobile apps

COM, ADO.Net

Visual Studio 2002,2003,2005,2008,2010,2012&2013

WebSphere

Flutter

Java

DevOps

SharePoint Designer

Flutter web

Web Services

Crystal Reports

InfoPath

DART

PHP, Perl

Visio

Oracle 9i

REACT

Angular

FrontPage

DB2

J2EE

JavaScript, DHTML

Delphi

SQL Server 2000, 2005,2008, &2012

VB.Net, ASP.Net

XML

Dreamweaver, Fireworks MX

SSIS

.NET Framework 1.1,2.0,3.0, 3.5,4.0&4.5

SQL, PL/SQL, T-SQL

Maximo

Unix/Linux

SharePoint 2007,2010, and 2013

Angular

OpenText

Apache

ADO. NET

MySQL

SiteCore, Akamai

Mainframe

Educational Background

Doctorate in Educational Leadership, National University, San Diego, CA expected 2025

Master of Art in Teaching Computer Science University of Michigan, Dearborn, MI 2000

Bachelor of Science in Computer Science Wayne State University, Detroit, MI 2006

Associate degree in physics for engineer Pau, France 1990

Associate degree

Certifications

Brain bench Certified for VB.NET, C#, SQL Server, and .NET framework

State of Michigan Certified for teaching Computer Science

State of Michigan Certified for teaching French

Professional Experience

Softerium Jan 2022 – July 2024

Senior Developer

Project Name: OneCallTicketManager

Description: A comprehensive application to manage one-call ticket requests for utility excavation projects. The application ensures compliance with safety regulations by facilitating the submission, tracking, and management of excavation requests and site details.

Successfully implemented a risk weighting model that significantly reduced the occurrence of underground utility damage.

Streamlined the workflow for contractors and infrastructure owners, leading to increased efficiency and reduced project delays.

Utilized AI-driven statistical studies to improve the accuracy and reliability of the risk assessment process.

Responsibilities:

Backend Development:

oImplemented the core business logic using Java and Spring Boot framework.

oDeveloped RESTful APIs for ticket management, including creation, updates, and retrieval of ticket information.

oUtilized Lombok annotations to reduce boilerplate code, enhancing code readability and maintainability by automating the generation of getters, setters, constructors, and other methods.

Database Management:

oDesigned and maintained the database schema using MySQL.

oImplemented data access layers using Hibernate and JPA for seamless integration with the MySQL database.

oUtilized HikariCP for efficient connection pooling, improving database connection performance and reliability.

Dependency Management and Build Automation:

oManaged project dependencies using Maven, ensuring consistent build environments and simplifying dependency management.

oConfigured Maven for project builds, packaging, and deployment processes, enabling smooth and automated CI/CD workflows.

oIntegrated various Maven plugins for tasks such as code quality checks, documentation generation, and test reporting.

Error Handling and Logging:

oIntegrated robust error-handling mechanisms to ensure application stability.

oConfigured logging using SLF4J and Logback to monitor application performance and troubleshoot issues effectively.

oImplemented custom error messages and logging levels for different components to provide detailed insights during development and production.

Project Name: Sitecore

Responsibilities

Designed and implemented a comprehensive real-time dashboard using Angular to enhance operational monitoring and decision-making.

Integrated complex data visualizations and interactive components to provide real-time insights into system performance and metrics.

Collaborated with cross-functional teams to gather requirements, design UI/UX, and ensure seamless integration with backend services.

Optimized dashboard performance and user experience through efficient state management and asynchronous data handling. •

Utilized Angular services, RxJS, and state management libraries to effectively manage application state and data flow.

Developed custom features in Visual Studio, .NET custom applications, and .NET components of Sitecore solutions based on feature specifications and technical designs.

Supported and enhanced the State of Michigan websites’ content after being migrated to the SiteCore platform using Javascript, Powershell scripting, and .Net components.

Integrated Akamai CDN with Sitecore CMS, to enhance website performance, security, and reliability. Leveraged Akamai’s caching capabilities for both static and dynamic content

Developed Restful web API services

Trained and monitored Internship trainees to develop Restful web services using Spring Framework

Performed stored procedures optimization and Solr integration

Performed SiteCore customization with .NET integration and Javascript

Merge/rebase code and create pull requests in addition to code review

Performed DevOps pipelines’ configuration

Created Azure DevOps builds of the features’ related branches

Performed Sitecore site migrations

Environment: GIT Repository, Devops,setups, Git, SiteCore 9.3, IIS, VS 2019, ASP.NET, SQL Server 2019, JavaScript, Ajax, jQuery, & CSS Languages: C#

Ilitch Companies/Little Caesars Sept ’15 to Dec’21

Sr. Developer / Architect

Responsibilities /accomplishments:

Developed a three-tier .NET application end to end to streamline price changing and Store Information Details for Franchisees. The application was developed using .net core 2.0, MVC Razor pages, and Web API

Develop a Flutter-based mobile app serving both employees & franchisees as a portal. The application is cross-platform through RESTFUL web services and secured the app via the implementation of oauth2.

Performed testing automation and wrote testing scripts using the Flutter testing plugin and poweshell scripts that allowed automated execution of unit tests, and integration tests to ensure the quality and reliability of code changes.

Developing a progressive web app serving both employees & franchisees as a portal using Flutter and REACT JS

Developed unit/widget testing scripts for QA and developers to test the end-to-end flutter-based application. Streamlined the packaging of unit test calls with PowerShell scripting.

Developed microservices that expose company backend data and integrate SOLID principles.

Pull data from Workday to generate Power BI reports, and customize DevOps workflows in the workday with Power BI

Translated a Delphi-based POS application into .NET Standard 3.5

Configured CI Pipelines, integrated Version Control, and managed artifacts through enabling traceability and reproducibility of builds, and deployment to various environments through using Azure DevOps.

Streamlined the order-make line process of the Little Caesars store into a .NET application.

For production Management 2.0 by architecting and implementing .net solutions (Awarded)

Develop a .NET application to streamline human resources processes

Developed Data Zen reports based on the MySQL Little Caesars stores MySQL backend.

Developed new PHP forms, and reports for stores’ sales management to help support new features and legal requirements.

Developed a .NET web application to assess candidates’ proficiency in .NET, and LAMP technologies

Performed many enhancements to the pre-existed Caesar vision application to fix issues encountered in the stores by fixing the data, and business layer code

Troubleshoot issues in supporting new store systems, and helped in the installation process (Awarded as the handler of the last ticket escalation)

Advise and help the store systems offshore team in troubleshooting Caesar Vision’s issues

Environment: GIT Repository, Devops, setups, Git, Windows 7, Windows Server 2008 r2, Windows Server 2012, SQL Server 2012, MySQL 5.3, VS 2012,2013, HeidiSQL, MySQL Workbench, FileZilla, QuickStream, ASP.NET 4.0,4.5, Delphi 8, Office 365, WPF Languages: C#

Federal Reserve Bank, San Francisco Jun ’14, Aug’15

Sr. Developer / Architect

Responsibilities/accomplishments:

Architected, and implemented solutions to streamline actual business workflow into SharePoint 2013 solutions

Migrated legacy applications data from Lotus Notes to SharePoint 2013.

Architected, and implemented the rewrite of Lotus Notes applications into SharePoint 2013 using CSOM, and JavaScript libraries

Wrote a WCF web service and provided a hosted app for PDF signature and integration with document libraries.

Automate, and streamlined in place business processes via SharePoint technology

Developed mappings components between data layer, and business layer using Java technology.

Developed a RESTful web service to interface between a secure data layer, and SharePoint 2013

Environment: Windows server 2008 r2, Windows server 2012, SQL Server 2008 R2, VS 2012, STS, Git, Azure DevOps

3.4, WebSphere application server, VS 2013, ASP.NET, SQL Server 2012, JavaScript, Ajax, jQuery, & CSS Languages: C#

Guardian, MI Nov ’12, Mar ’14

SharePoint Architect

Responsibilities/accomplishments:

Architected solutions for a SharePoint 2010 portal built

Architected the topology of guardian SharePoint 2013 farm

Built, and configured SharePoint 2010 farms

Prepare migration to SharePoint 2013

Installed, and configure SSAS for SharePoint power pivot

Imported Excel files with power pivot based on SQL cubes.

Configure performance point, and build performance point list using dashboard designer

Build a web part that uses multiview to filter based on security built-in SQL cubes

Customized a survey using custom code applied to the original out-of-the-box survey list.

Create external content types and external lists

Built sequential workflows, associated with lists using SharePoint Designer 2010

Built custom workflows by implementing event receivers using Visual Studio 2010

Built a web part that displays Inotes email inbox, and calendar

Put in place a knowledge center on SharePoint for SharePoint admins to troubleshoot common SharePoint issues.

Customize SharePoint lists’ forms using InfoPath forms, and filtering visibility using SharePoint GetUserProfileByName, and GetUserCollectionFromGroup web service.

Developed farm’s architecture, and performed sites’ migration

Automate, and streamlined in place business processes via SharePoint technology

Environment: Windows Server 2008, SQL Server 2008 R2, VS 2010, ASP.NET, SQL Server 2012, JavaScript, CSSLanguages: C#, & VB.NET

IBM, NJ Apr ’12, Jun’12

Developer

Responsibilities/accomplishments:

Built the backend of a .NET application

Built the user interface of a 3-tier .NET application, and integrated into SharePoint 2010

Environment: Windows Server 2008, SQL Server 2012, VS 2010, ASP.NET, JavaScript, CSS Languages: C#, & VB.NET

Severstal, MI May ’11, Mar ’12

SharePoint Developer / Architect

Responsibilities/accomplishments:

Architected SharePoint 2010 solutions and performed site migrations.

Built, and configured SharePoint 2010 farms.

Defined backup/restore strategies, and implemented successful disaster recovery policies

Designed, developed, documented, and managed departmental web pages, web parts, and workflows to improve business efficiency.

Created SharePoint sites; customized their look and feel and functionality.

Monitored the health of SharePoint farms using SPDiagnostics, SPManager, and other standard tools

Developed a web part that filters, and displays data generated by SQL reports

Implemented functionalities by creating master pages, web parts, lists, and .NET forms.

Developed web services to allow cross-platform interaction with SharePoint

Environment: Windows Server 2003 & 2008, SQL Server 2005 & 2008 R2, VS 2008 & 2010, Team Foundation Server, ASP.NET, JavaScript, XML, and XSL. Languages: C#, & VB.NET

Xperience, MI Jan ’11 – May ’11

.net developer / Architect

Responsibilities/accomplishments:

Developed a .net Inventory Scanning system application for Internal use

Developed a .net online Survey Application for Ford Customer

Created, and deployed SSRS reports

Developed a .net Application that automates sending customized messages to customized distributed lists.

Environment: SQL Server 2008, VS 2010, VS2008, SQL Server 2005, Crystal Reports 2011, ASP.NET, JavaScript, XML, and XSL. Languages: C#, VB.NET

IBM, MD Oct ’10 – Dec ’10

SharePoint Developer

Responsibilities/accomplishments:

Architected a SharePoint 2010 solution to fit the client's needs

Installed, and configured SharePoint 2010 server.

Created SharePoint sites; customized their look and feel and functionality.

Implemented functionalities through creating master pages, and .NET forms.

Developed web parts, lists, governance, and taxonomy.

Environment: SQL Server 2008, SharePoint Designer 2010, VS 2010, ASP.NET, JavaScript, XML, and XSL.

Intel, CA Apr ’10 – Sept ’10

Developer

Responsibilities/accomplishments:

Performed sites, and lists migration from MOSS 2007 into SharePoint Server 2010.

Built dynamic SharePoint sites in 2010 by means of:

Customizing master pages

Creating different style sheets, jQuery, and JavaScript functions

Creating different data views for the lists

Developing, and Macromedia components

Delphi, MI Mar ’09 – Mar ’10

Architect / Developer

Responsibilities/accomplishments:

Enhancing the search capability for the Delphi SharePoint documents repository.

Building web parts that encompass various tasks, and functionalities to improve the prebuilt capability of the legacy SharePoint repository.

Architecting the integration of the SharePoint 2003 legacy sites into SharePoint 2010.

IBM Solutions, MI Sep ‘09 - Feb ’10

.net Developer

Responsibilities/accomplishments:

Convert a classic ASP form that uses Clarify systems to ASPX forms that integrate with a . NET-compatible environment.

Created web services that instantiate workflows in OpenText.

Create tickets’ records into ISM environment, by customizing a web service that interfaces through the Maximo Adapter.

Manage integration processing, and create new integration points

Create processing rules for customizing interfaces

Support for multiple integration models using HTTP, messaging, and databases’ interface tables

Real-time, batch, and user-initiated processing of outbound and inbound interfaces

Support for customization of the predefined integration objects

ITT, IN (Fulltime) Dec ‘08 - Aug ’09

SharePoint Developer

Responsibilities/accomplishments:

Built numerous Web parts using SharePoint.

Built various .NET applications and integrated them into the SharePoint portal.

Maintained SharePoint applications used by thousands of students, faculty members, and administrators, and spread across many campuses within the US.

Configured, and managed settings for single sign-on.

Created, and bound InfoPath forms for WF sequential workflows.

Created data taxonomy for a SharePoint Portal Server.

Created custom list forms that capture data and store them in SharePoint lists.

Created custom user access workflows.

Created, and implemented custom field types, and features; Performed features’ activation, and deployment automation.

Customized XSL files of MOSS to extend the publishing ability of SharePoint.

Created cascading style sheets to customize sites’ templates.

Created dynamic navigation bars using JavaScript.

Defined and documented detailed requirements for all aspects of the system, including, but not limited to, business processes, information needs, user interfaces, graphical design, other system interfaces, and technical infrastructure.

Customized the NewFormaspx of the SharePoint lists with the Data View web part using SharePoint Designer.

Branded the SharePoint master pages.

Created customized controls’ web parts by mimicking the 12-hive using MS Visual Studio, and NHibernate.

Created SharePoint form templates with MS InfoPath.

Created Association, Initiation, Task Edit, and workflow Modification forms

Created WWF sequential workflow unit testing

Created workflow features

Created customized site columns and site content types.

Performed various SharePoint deployment processes.

Created and maintained a handbook application used by thousands of students nationwide.

The application pulls information from multiple data sources and generates outputs in different formats (Excel documents, Mail Merge Word documents).

Gathered requirements from the client, and transferred them into technical specifications

Participated in the system DB Model

Developed process flows, and UI screens

Built forms by creating hierarchical Telerik Grids, and binding them to their data source with ASP.NET, and NHibernate for Object-relational mapping o Designed, and generated reports from various data sources using Crystal Reports. Created and maintained an online course assessment tool used, and to be used by hundreds of ITT faculty members, deans, and program directors.

The application uses web services and a pre-existing business layer to query databases such as IRIS, and Oracle and feeds the results to an ascx control.

The captured data is saved to an Oracle back end using a WCF service.

Customized WCF services to enable cross-platform communication

The ascx control is presented through a web browser and, in addition to presenting the queried data, allows the users to customize the interface by adding and removing functionality according to their needs.

Created WCF services’ components used by the application to communicate with different environments

Environment: SQL Server 2005, Oracle 10g, T.O.A.D, Microsoft IIS, WSS, MS Visual Studio 2005/2008, MOSS 2007, NHibernate, Windows Server 2003, dB visualizer Oracle driver, Crystal reports 9, and 11, MS Visio 2003, Visual SourceSafe

Compuware, MI(Fulltime) Aug ‘07 - Nov ’08

Systems Designer

Responsibilities / accomplishments:

Customized MOSS Search capability based upon metadata provided by the site columns

Created and customized web parts for various web applications.

Created different workflows for users with different permissions

Customized the XSL files of MOSS to extend the publishing ability of SharePoint.

Architected a system that hosts applications written in both .NET Framework 1.1, and .NET Framework 2.0 Designed and developed a Customer Selected Services online survey application. Performed technical evaluations regarding the migration of current Professional Services Division data to a protected website.

Troubleshot SharePoint backup issues. Identified, analyzed, and documented desired process and automation enhancements to streamline the business processes

Built WinForms for a CRM application that displays customer, and order information pulled from an SQL database.

Customized and implemented, reporting services for MS Excel.

Converted VB legacy code into VB.NET

Created Social Network Software Portfolios using DOJO, FxFoto 3.0, and Flash 5 for a charitable organization

Built an application with a search capability that displays items with their pictures from a data store using Flex Builder 3

Integrated a customized grid that replaced a preexisting MSFlex grid. Updated all related WinForms and affected modules. Performed application technical support.

Environment: SQL Server 2005, DOJO, FxFoto 3.0, Microsoft IIS, WSS, MS Visual Studio .NET 2005 for ASP.NET, MOSS 2007, Flex Builder 3, Windows Server 2003, MFC applications, MS Office,

WSS 2.0, WSS 3.0, PVCS/C, ChangeMan, VS 6.0, MS Visual Studio 2005/2008

Enlighten, MI Apr ’07 – Aug ’07

Software Developer

Responsibilities/accomplishments:

Designed a taxonomy pattern based on business group memberships

Designed a user interface based on a customized out-of-the-box search web part.

Created a search capability based on filtering with lists’ metadata

Customized forms using InfoPath 2007

Created different workflows for users with different permissions

Customized the XSL files of MOSS to extend the publishing ability of SharePoint.

Environment: SQL Server 2005 o Microsoft Content Manager Server o Microsoft IIS, WSS, MS Visual Studio .NET 2005 for ASP.NET o Windows Server 2003, Microsoft Visio

Better Investing, MI Dec ‘06 - Feb ’07

Software Developer

Responsibilities/accomplishments:

Customized Microsoft Content Management Server for specific business solutions.

Diagnosed and fixed Microsoft Content Management Server (MCMS) defects.

Developed MCMS user-interface enhancements.

Customized BI members’ profiles and data stores.

Wrote the specifications for migrating to MS SharePoint 2007 for Intranet and web applications

Environment: SQL Server 2005, MCMS 2002, MOSS 2007, Microsoft IIS, WSS, MS Visual Studio .NET 2005 for ASP.NET, VS.NET 2005, VSS, Windows Server 2003

Recellular, MI Jul ‘06 - Sep ’06

Application Developer

Responsibilities/accomplishments:

Developed and maintained current in-house software systems.

Developed and created new software.

Provided training for staff as needed on new systems and system changes.

Troubleshot and repaired system problems with programming phones.

Wrote C++ programs for serial communication between computers and different phones.

Built a Windows-based application that uses serial communication to unlock cell phones.

Used Unit, Integration, Regression, Load, and platform tests to make sure that the WCF application is displayed correctly and has reasonable performance.

Used the Debug and Trace diagnostic classes to display alerts and log error conditions during the development process.

Used Microsoft ACT to record user interaction with a Web application in VBScript. Environment: MFC applications, MS Visual Studio for VB.NET, C#, and C++.

RE/MAX, MI Aug ‘03 - Aug ’06

System Analyst, and Systems Designer

Responsibilities/accomplishments:

Made major enhancements and developed new functionality to meet the requirements of clients

Wrote and reviewed detailed functional specifications

Created detailed functional specifications and test strategies for multiple projects

Worked with QA engineers and managers during the testing phases of different applications in their particular release periods

Designed, Developed, and Recommended different UI designs for the existing application

Modified and enhanced the database schema by working with subject matter experts

Wrote and modified stored procedures, to optimize queries in the database

Wrote and modified module structures to complement the improved database schema.

Develop Windows forms using Visual Studio.NET 2003, VB.NET/ C#, & Windows 2003 Server

Provide smart technology solutions using .Net programming (C#, VB.NET and ASP.NET)

Developed ASP application using VB scripting

Created custom reports using Crystal Reports, and Access 2000

Implement the 3-Tier Architecture in developing the .Net applications

Develop database applications in client/server environment

Develop stored procedures for the data layer to access the SQL Server 2000 database

Automate the login procedures with Perl modules, on secure Web sites in production environments.

Develop the assemblies for the business and data layer

Develop reports to work with existing SQL database data

Reconfigure data communication software

launch shopping carts, and provide back-end power to interactive Flash applications

Develop commercial web applications with Flex and the Adobe scripting language.

Supported legacy ASP applications

Designed Internet and intranet web pages for TierOne Technologies website

Created an advanced search function to list and prioritize all documents based on search terms

Environment: SQL Server, Web Services, Web Forms, Flex Builder 3, ADO.NET, ASP.NET, C#,

JavaScript, Perl 5.8, Visual Studio.NET 2003, Visual Source Safe, Windows 2000 Server, IIS 6.0, Adobe Photoshop, VB.NET, DTS, CSS, Microsoft Visio

Wayne State University (Full time) May ‘00 – Apr ’04 (USA)

Web Developer, & C++ instructor

Responsibilities/accomplishments:

Developed a software in Basic for measures of the currents, capacitances and resistances of cells. Designed a database for the E.coli Bacteria DNA sequences. Created tables, reports, and queries with MS Access.

Developed Faculties, web sites

Performed technical support for Mac Aquila, and maintained the current database

Worked on improving the university website' high ranking based on the different methods of optimization whether based on robots, spiders, or directories.

Wrote Java programs for the Undergraduate engineering department extending applets in the use of Java language packages.

Programmed multithreading in Task scheduling, dispatching, and Inter-Task communication.

Maintained many interactive websites for Wayne State University with the use of Java Beans, Java Applets, and Java Server Pages HYPERLINK "http://www.auditmypc.com/acronym/JSP.asp".

Created software in Java that codes for the translation and transcription of DNA.

Helped students with writing their C++ code. Gave students strategies in the abstraction and the simulation of their C++ projects. Held sessions three times a week to answer students' questions.



Contact this candidate