PROFESSIONAL DEVELOPMENT EXPERIENCE:

Confidential, San Antonio, TX

Sr. Software Engineer (Integrations Specialist)

Responsibilities:

• Confidential is a medium sized business with many roles including payrolling, staffing, master services provider, and human resources supplier.
• Confidential is in partnership with recruiters and suppliers that are in charge of interviewing, hiring, and staffing employees for institutions and state agencies requesting labor for their workforce.
• As part of this company, my role was to manage information in multiple forms and formats for integrating different systems to process payroll.
• This includes creating and managing integration packages to transform and inject data into templates ready for further processing into SAP FieldGlass Web Application System.
• Utilized Microsoft OneNote to create and manage all current projects worked on with status updates, specific files required for operations and procedures. Reported directly to I.T. Manager, Sr. Implementations Manager, & CFO.
• All management staff provided access to OneNote for real - time updates on projects including errors and issues.
• Microsoft Office 365 OneNote 2016, Excel 2016, Word 2016, Access 2016, PowerPoint 2016, Sway, Power BI, OneDrive, Sharepoint 2016
• Enterprise migrated from on premise to Microsoft Office 365 Cloud Environment.
• All information within stored network drives transferred into Sharepoint Online 2016 for Office 365 environment.
• Sharepoint Online now controls access to Sharepoint sites based on permissions within AD Azure Tenant Rules.
• Created development environment for custom applications.
• Windows Azure Subscription
• Windows PowerShell, Windows Azure SQL, Server 2016, Windows Azure Storage
• Created Windows Azure Development environment for custom application development.
• Created sample test users for importing users.
• Created AD tenant security groups to limit access to particular Sharepoint sites.
• Created PowerShell scripts to create folder structures, along with security permissions.
• Build user association PowerShell scripts along with permissions.
• MS Visual Studio SSDT, Excel 2016, .CSV, FWT (Fixed Width)
• Managed 38 tab Configuration Workbook for SAP FieldGlass implementation.
• Managed all data collection through versioning of Master Configuration Workbook file.
• Multiple departments included in massive information data mining.
• Managed development environments for API Integration interface for massive data uploads.
• Broken out data into batches for complete error free upload.
• Visual Studio 2017, SQL Server 2016, SQL MDS (Master Data Services),Visual Studio 2013/2015 SSIS, ASP.NET
• Created custom web applications to handle SSIS packages for different project implementations such as automated file imports to exports.
• Other functionality includes web services API which allows the retrieval of processed files that have successfully uploaded data into the FieldGlass Application.
• Other process include retrieving files from the FieldGlass Application into local data base for transformation into template for payroll processing.

Confidential, Randolph A.F.B, TX

Sr. Security Solutions Engineer

Responsibilities:

• My task was to work with a team of 4 members to help improve application performance while mitigating and discovered security threats.
• Security Assessment, Development and Implementation
• C#, HTML4, SQL,Batch Scripts, PowerShell Script, classicASP, Oracle11g/12c, TFS
• Ran full code analysis within classic ASP application and documented all current vulnerabilities and countermeasures that are available within the .NET Framework.
• Created internal PKI environment utilizing server certificates issued from Root Certificate Authority.
• Implemented forms authentication with security implementation for session management, cookie timeouts, and error page navigation.
• Mitigated application security threats via application configuration and secure in-memory encryption / decryption methodology.
• Reviewed all previous and latest documentation.
• Created new and up-to-date application documentation based on current analysis and configurations.
• Used coding analysis tools to compare code behind documents, server configuration files, and scripted solutions.
• Utilized TFS Kanban board to create, document and update Tasks under Product Backlog Item.
• Create application design with Visio documentation, produce word documentation, excel sheet data mapping and documentation.
• Application Deployment .ps1 - Scripts implement authorized user to create virtual directories sites, bindings, host headers, Application Pool, Virtual and Private Memory with SSL information.
• Windows Batch files - Scripts created to manage appcmd.exe to manage individual site management within IIS server.
• Customized multiple batch files to be referenced by Powershell file.
• Customized developer diagnostics application to test production application functions. All primary account management and application access will be can be checked, verified and managed through GUI. Diagnostics include User Login, Change Password, Forgot Username / Password, NewUserRegistration, and Common Access Card (CAC) Login.
• Connected Login application to download and implemented web service reference. Reverse engineered currently working web services soap methodology and implemented service namespace along with required objects for client to authenticate against authentication server over an encrypted HTTPS connection.
• Implement security best practices via Forms Authentication over HTTPS. Login and session data all encrypted during user logged in session.
• These configurations include session timeout, user page navigation permissions, session decryption and in-memory processing.

Confidential, San Antonio, TX

Sr. Web Developer (Project Lead)

Responsibilities:

• My personality, drive, and the quality of my work earned me a promotion to Project Lead.
• Confidential invests in its employees by encouraging continuing education during employment by earning certifications, clearance, or any advance training that will help facilitate better relationships with long term and new clients.
• VB.NET HTML4, CSS2, SQL, T-SQL, SSIS, SSRS, SSAS
• Re-developed web forms application utilizing Microsoft Security Framework
• Implemented Secure Microsoft Forms Authentication over encrypted HTTPS connection
• Customized domain cookie attributes such as data encryption, sliding Expriation timeouts, etc.
• Ensured all data within application cookie are encrypted via Forms Authentication Tickets
• Integrated hardware smart card Common Access Card Single Click Secure Login Integrated and customized 3rd party Two-Factor Authentication “Anakam” software Tested all login and password reset functions within SSO Application

Confidential

Project Lead

Environment: VB.NET, HTML4, CSS2, SQL, T-SQL, SSIS, SSRS, SSAS

Responsibilities:

• Develop security protocol for securing all data within Single Sign On application
• Create multiple pages, routines, functions, to manage data entry controls within application
• Updated any and all application sessions by securing them within a “secure” application cookie
• Modify all current controls to implement ClassFunctions
• Main to sanitize all submitted data Tested all new functions within application before submitting ticket item to QA manager for final analysis and testing.
• Implemented Security+ Protocols by mitigating all web application threats from hijacking, clickjacking, spoofing, cross-site scripting and SQL injections.

Confidential

Project Lead

Environment: C#, HTML4, CSS2, SQL, T-SQL

Responsibilities:

• Create customized C# objects to translate VB.NET class objects and pass data between current session variables.
• Modify existing case management data entry submission and verification methods to new management databases
• Tested newly created session variables by assigning values to front-end labels to ensure data integrity.
• Implemented new SSO Secure application cookies containing authentication and permissions for logged in users.

Confidential

Environment: DotNetNuke CRM (DNN 7.0), SQL, T-SQL

Responsibilities:

• Develop database schema to match the current data scheme Confidential has provided and implemented within legacy system.
• Created powerpoint presentation with full display of application features, pages, roles, functions, and expected results of User Interface.
• Updated current SQL methods to include additional database tables when creating new records within DNN registration system er Database converting Excel sheets into SQL database tables.
• Tested all newly created SQL stored procedures, functions, conversions and calculation results Implemented 3rd party DNN modules

Confidential, San Antonio, TX

C# .NET Developer

Responsibilities:

• For over 25 years the company was an innovator in designing touch screen user interfaces for small businesses dealing in product sales.
• My role in this business was to attempt integration between a C based program and a C# based program via C++ and VB6.
• Enterprise Manager(SFTP Multiple - Store Manager)
• VB.NET, HTML4, CSS2, MS SQL 2012, SQL Agent Jobs
• Created multiple test data packages to import into Enterprise manager for parsing and storage of daily, weekly, and monthly data.
• Modified current network security connections to allow remote connections for RDP Server Management per 24/7 standard procedures.
• Implemented multiple scheduled Server agent jobs to parse multiple files into database records for reporting.
• C#.NET, MVC3, Razor, Entity Framework, MS SQL
• Integrated and tested Shopify api data model and created custom interface to handle data input for payment submissions and confirmations
• Unit tested front end registration, profile edit, appointment create, edit, delete, as individual test units via Moq, and Ninject
• Configured global.asax file for configuration registration (WebApi, Filter, Route, Bundle, etc.)
• Developed new SQL stored procedures to handle new user registration by Key / Foreign key relationship structures. (Registration, Profile, Appointment, etc)
• Create email confirmation response models/layouts for newly created/edited/deleted appointments.
• Unified all date formats by using conversions to manage extended formats to shorter date length formats via T-SQL Date Format Scripting
• SQL Development (2012) - Business Intelligence Development (2008)
• Create Database Level Triggers responding to Updated information for backup packages
• Create SSIS Database and Table Disaster Recovery packages
• Integrated C# and VB Script tasks handling XML, CSV and ODBC connections
• Design multiple Flow tasks to check for created files and file types for ODBC connections
• Design cascading CREATE TABLE Scripts for LocalDB data storage
• Created SQLDebug Database for New SQL Statement development and testing

Confidential, San Antonio, TX

C# .NET Developer / Salesforce Development Manager

Responsibilities:

• Once student has taken full advantage of the seminar, a student is now confident and ready to start dealing in Real Estate.
• My role in this company has been to manage the call center that registers students that wish to attend a seminar in their local area as well as other places in the United States.
• EMS Customized CRM Web Application
• C#.NET, HTML4, CSS2, AJAX, JQuery, JavaScript, .NET Infragistics, MS SQL
• Created custom web form pages to handle New Registrants for upcoming seminars
• Created multiple statistical call reporting data including Registrations, Conversions (Lead to Student), Attendants, Non-attendants, Reschedules, and Cancellations.
• Implemented 3rd party development controls from .NET Infragistics
• Salesforce CRM Cloud Application (Project Manager)
• JAVA, XML, CSV, SSIS, MS SQL
• Managed 3rd party Salesforce Developer Contractors to create all EMS corresponding pages via webcam teleconference.
• Migrated all current users from EMS CRM database into Salesforce database storage via Scribe DTS, Apex Data Loader, and SSIS.
• Researched Salesforce development methodologies, JAVA development coding standards, Eclipse IDE, Salesforce Development Kit.