Software Development Systems Engineer

Salome Alejandro Mancilla Chavez

****.********@*****.*** 210-***-****

PROFESSIONAL ASSETS

Microsoft Information Technologies Developer Senior Computer Systems Engineer with extensive experience in all phases of the software development life cycle including requirements definition, prototyping, functional and technical design, interface implementation, testing, maintenance, documentation, technical and user support. As well as project management tasks such as coordinating and supervising developers groups, leading projects and dealing with Users of Executive level.

● 20+ years of experience in Software Development on Microsoft environment with visual programming languages

● Possesses expertise in Structural, Functional and Object Oriented Analysis, Design and Development.

● Large Experience with Agile Methodologies, Test Driven Development, and SCRUM Methodologies

● Skilled in all phases of the Software Development Life Cycle, from problem statement to implementation and support.

● High knowledge of Relational Databases Modeling, Implementation and Management.

● Solid leadership skills, demonstrated proficiency in leading developers groups.

● Analytical thinker, often called upon to consult on problems that have eluded resolution by others. TECHNICAL EXPERIENCE

.NET TECHNOLOGIES ASP.NET, ADO.NET, Win Forms, Web forms, Web Services, AJAX, LINQ, and .NET Framework, .NET Core

Languages VB .Net, C#, T-SQL Visual Fox Pro and Visual Basic; Databases Microsoft SQL Server, Access, DBF, Oracle 11i, DB2. DTS, Toad Database Access Tools ADO. Net, OLEDB, ADO, ODBC,SSIS, SQL Cubes Web Services XML, WSDL, SOAP, REST.

Web Technologies HTML, CSS, XSLT, ASP, XML,JSON, HTML, AngularJS and IIS Scripting Languages JavaScript, VB Script, JQuery, Ruby, Python and Powershell. Report Tools Crystal Reports, SSRS

Operating Systems DOS; Windows & Windows Server; Unix Source Code Control Git, Subversion Source Code, Tortoise, Microsoft Visual SourceSafe, Team Foundation Server, Harvest

Middleware/Libs

NHibernate, NUnit, MS Test, Unity, NAnt, NCover COM, ActiveX,Entity Framework, Active Record, Castle Project: Rhino Mocks, Windsor Container, MicroKernel. Protocols TCP/IP, SOAP, FTP & SFTP

Modeling & Design Visio, Erwin, UML, Client/Server, SOA, MVC; Miscellaneous Software Microsoft Office (Word, Access, Outlook, Outlook, Express, PowerPoint, Excel, Project); JIRA and confluence, Genesys (CIC) Phone System

SDLC Methodologies OOD, DDD, TDD, SCRUM

PROFESSIONAL EXPERIENCE

Bexar County IT, San Antonio TX

Senior Application Developer Jul 2023 - Current

● Developed backend process to produce extract files from Legacy and New systems, using C# .NET Framework 8.0 and SQL Server 2019.

● Built process to print PDF files for Subpoena requests, silently and automatically, using C# .NET Framework 8.0. Salome Alejandro Mancilla Chavez

****.********@*****.*** 210-***-****

● Enhanced Background Check Search, optimized query performance, and updated criteria for new system using C# .NET Core 6.0, MVC, and SQL Server 2019.

● Implemented and optimized T-SQL queries and stored procedures for dashboards and online search functionalities.

● Utilized Azure Service Fabric, Azure Functions, and Azure Blob Storage for scalable application deployment and management.

● Managed and integrated Azure APIs to ensure seamless integration and high performance.

● Provided Tier 2 application support, troubleshooting and resolving issues for multiple applications.

● Designed and implemented system integration solutions, ensuring data consistency across platforms.

● Maintained comprehensive documentation for developed applications and processes.

● Generated reports on application performance, issues, and resolutions.

● Identified and implemented process improvements to enhance system efficiency.

● Collaborated with cross-functional teams to deliver effective solutions aligned with business requirements.

● Ensured compliance with security standards and regulations, implementing necessary security measures.

● Provided training and mentorship to junior developers and team members, fostering a collaborative environment. Environment:

Visual Studio 2019/2022, ASP.NET, .NET Framework 4.5/4.7/ Core 6,7,8, C#, ADO.NET, XML, HTML, CSS, JavaScript, JSON, JQuery, SQL Server 2016/2019, Web Services WSDL/REST, Windows Applications, GIT, Azure Repo and CloudServices

Carenet Healthcare Services, San Antonio TX Oct 2012-Apr 2023 Software Developer / Lead .NET Developer / Team Manager

● Participating in building the MESO and MESO Lite (EOMS) Platforms for engagement program

An ASPX .NET website with web services to consume data from MSSQL Server DB

Platform utilize Javascripts, content files, and utilities

● Implemented updates, customizations and improvements to Main application CarePortal, HTML, ASPX, JS and JQuery

● Collaborated in the building of engagement all center scripts ASPX and JS templates

● Implemented the Extract operation for results and outcome for the Engagement, which uses command files to call executables, that read for MSSQL Server using dynamically build queries and stored procedures and write text and XML files and finally post file on SFTP site

● Providing second tier production support

● Provided Estimation for the work efforts

● Stage, package and assist on deployment of the artifacts for engagement and Nurse line solutions.

● Increased code testing coverage to around 75% with Unit and Integration testing

● In charge of deployment of components for Engagement and Nurse line solutions

Staging using Ruby scripts and MSBuild

Deployment of executables and websites with inhouse built deployment tool

Prepping of SQL queries for DB changes, and registry files for system configuration

● Built Input and output file processing artifacts utilizing SSIS packages, SQL Jobs, SFTP, PGP Encryption/Decryption, Inhouse built application (C# .Net) for parsing and formatting files.

● Integrating CarePortal (Windows Application, C# .Net) with a Phone system to support live calls using Services.

Integrating DLL for Genesys(CIC) phone system

Allowing handling calls coming on both directions Inbound and outbound and multiple dialing mode: Preview, Predictive, and Manual

● Provided SMS capabilities as an additional outreach channel, C#.NET backend code, with MS SQL for DB

Integrating with Twilio via a provided API, to send messages and retrieve responses and SMS Status

Setup secured website(ASPX .NET, Javascript, JQuery) for surveys triggered from SMS

● Maintaining code testing coverage over 75% with Unit and Integration testing using NUnit and MSTest

● Maintaining CallCenter Scripts website (ASPX .NET, Javascript, JQuery, AngularJS, web services), Updating Existing and Adding New Functionality per to satisfy our clients requests. Salome Alejandro Mancilla Chavez

****.********@*****.*** 210-***-****

● Providing second tier production support for Engagement and NAL Applications, and input/output file processing

● Participate in process improvement initiatives including: requirements standard documentation, Testing Process and Procedures, source code control, Release and Deployment, SDLC, JIRA and Project management.

● Provide consultation as SME to clients and special projects

● Participate in Planning, Estimation and Prioritization of work efforts in both Waterfall and SCRUM setups

● Managing Onshore and Offshore development teams

Leading technical hand off, task breakdown, and technical analysis

Monitoring on task completion, time tracking, capacity, velocity and delivery dates

Assuring code reviews were performed

Validating Test Plan, Test Case and Test Results

● Participating in the recruitment, hiring and onboarding of Software developers. Environment:

Visual Studio 2010/2015/2019, ASP.NET, .NET Framework 4.5/4.7/ Core, C#, ADO.NET, XML, HTML, CSS, JavaScript, Angular JS, JSON, JQuery, SQL Server 2008/2012/2014, Web Services WSDL/REST, VBScript, PowerShell, Git for source code control, NHibernate, NUnit, CIC3.0/2015R3(4.0), Windows Applications TEKSystems / Wells Fargo NCA, San Antonio TX Mar, 2012- Sept 2012 Systems Analyst

As a contractor I was assigned to Wells Fargo TAG home preservation team Under Stephanie Arzola.

● Updated HTML Forms for Net Present Value Calculation application using C#, ASP.Net 2010, SQL Server 2008.

● Created MSP Notes application using C#, ASP.Net 2010, SQL Server 2008. This application loads Excel files and load the notes into the Database

● Upgrade VB 2005 Console applications to process images and send faxes, using FAXCOM API first and Web Service later, reducing the processing time required to 1/6 of the current time.

● Created the Website for Net Present Value (NPV) for client 512, this application allows to query for previous calculations and recalculate consuming a web service Environment:

Visual Studio 2005/2010, ASP.NET 2.5/3.5, C#, ADO.NET, XML, HTML, CSS, JavaScript, SQL Server 2008, Web Services, VB.Net 2005,

The SCOOTER Store, New Braunfels, TX Jul, 2009- January, 2012 Computer Systems Analyst/Software Developer:

Responsibilities:

● Maintained and Migrated Legacy Application from ASP to ASP.Net 2008

● Added New Functionality for TotalView and Framework using C#, ASP.Net 2005/2008/2010, SQL Server 2005/ 2008, Entity Framework, Unity IoC, MS Test, Visual Source Safe, and Team Foundation

● Added New Functionality for MobileView applications using C#, ASP.Net 2005/2008, SQL Server 2005/ 2008, MS Test, Rhino Mocks, .Net CF, Visual Source Safe, and Team Foundation Server

● Added New Functionality for LocalView application using C#, ASP.Net 2008, SQL Server 2005, Visual Source Safe, and WPF.

● Migrated Lead Importing SQL Server 2005 DTS Packages into SQL Server 2008 SSIS Packages.

● Analyzed and designed new Features for TotalView regarding insurance carriers.

● Acted as Team Lead during the Sprint and handled the release in production as the POC for the AAS Team following the SCRUM Methodology.

● Helped in the recruitment,hiring,onboarding and training of new developers

● Diagnosed and troubleshot production issues as 3rd level support.

● Developed Admin Pages for TotalView following DDD, OOP, SOLID Principles, Entity Framework, Unity IoC, and SOA, ASP. NET 2010, C# 2010, Framework 4.0

Environment:

Visual Studio 2005/2008/2010, ASP.NET 3.5/4.0, C#, ADO.NET, XML, HTML, CSS, AJAX, JQuery, JavaScript, SQL Server 2005/2008, DTS, SSIS, TFS, VSS, ASP, Web Services, .Net CF, VB.Net 2005/2008, Entity Framework, Unity IoC, MS Test, Rhino Mocks, Scrum, TDD,DDD, OOP, SOLID Principles. Salome Alejandro Mancilla Chavez

****.********@*****.*** 210-***-****

TEKSystems / The SCOOTER Store, New Braunfels, TX Mar, 2009- Jul, 2009 Systems Analyst

● Updated HTML Forms for TotalView application using C#, ASP.Net 2005/2008, SQL Server 2005.

● Created the Customer Satisfaction Interview Script an ASP application which eliminates the usage of the eSurvey website.

● Upgraded a Client/Server Win-Forms application (EAPP Admin) from VB6.5 to VB .Net 2008, accessing SQL Server 2005 DB with ADO .Net

● Enhanced a Win-Forms application (LMS) for a better visual identification of the origin of lead using VB 6.5, XML Web Services, ADO DB, Win-Services and SQL Server 2005.

● Added the Transfer leads functionality to TotalView using ASP Data Services

● Improved the channel recommendation on lead gathering Application (eBound) by changing the ASP Pages and the stored procedures from SQL Server 2005

● Other tasks concerning DB usage optimization.

Environment:

Visual Studio 2005/2008, ASP.NET 2.5/3.5, C#, ADO.NET, XML, HTML, CSS, AJAX, ASP JavaScript, SQL Server 2005/2008, VSS, ASP, Web Services, VB6.5, VB.Net 2005/2008, Win-Services Deintec (operating as Deintec North America In the US) Apr, 2007- Dic, 2008 Microsoft IT Developer Sr/ Microsoft .NET Web Developer

● Microsoft .NET Web Developer for Kansas City Southern de Mexico, Monterrey from Oct- Dic, 2008 o Created the UML documentation for the Analysis and Design of MyKCS Web Application Used by customers of KCS to track their freight loads carried by train. o Developed the Scheduling functionality converting from Java Website, and Oracle and DB2 into ASP .Net, C# 2008, Framework .NET 2.5, and SQL Server 2005.

o Converted the Route calculation, form COBOL to C# Libraries. o Applied, diffused and trained team’s developers (5) in agile principles and patterns. Environment:

Visual Studio 2008, ASP.NET 2.5, C#, ADO.NET, XML, HTML, CSS, AJAX, JavaScript, SQL Server 2008, Java, Web Services, TFS, COBOL, Oracle 11i, and DB2

● Microsoft IT Developer Sr. for Deintec / Farm Bureau Bank, San Antonio, TX from Aug, 2007-Aug, 2008 o Created UML documentation for the Analysis and Design of the Loan Automation Project o Developed a Windows Forms Application using Web Services with Visual Studio .Net 2005 C#. framework 2.0, MSSQL 2005

o Created the PDF files used as templates to print o Designed of SOA Architecture for the FBB internal Website o Implementing TDD, Extreme Programming and other Agile Principles with the local team. o Lead the offshore projects, coordinated both the local and remote Teams (5 developers).

Outlined and scheduled development plans

Trained the team in Agile Methodologies.

Collaborated in the creation of the Enterprise Process Framework to Schedule and execute jobs and report the status and results. Applying agile principles and patterns, developed with Visual Studio .Net 2005 C#. framework 2.0, Active Record, Castle Project o Documented the Process and Procedure implementing the Agile development at FBB o Provided Technical and user Support

Environment:

Visual Studio 2005, ASP.NET 2.5, C#, ADO.NET, XML, PDF, SQL Server 2005, Java, Web Services, Subversion, MVC, Rhino Mocks, NUnit, Tortoise, NCover, TDD,SOLID Principles, UML

● Microsoft IT Developer Sr. for Deintec/Hipotecaria Patrimonio, Monterrey, Mex. From Apr – Jul, 2007 Salome Alejandro Mancilla Chavez

****.********@*****.*** 210-***-****

o Technical Leader for the project to Hipotecaria Patrimonio, a Mortgage and loan financial institution, the project was about applying certain criteria to payment transactions in order to detect possible illegal operations linked to money laundering.

o Created the UML documentation needed to fill the stages in RUP Methodology,Use Cases, Class Diagram, Sequence diagrams, Entity Relation Database Model

o Developed application using C# 2005 and SQL Server 2005 as well as coordinated the team; the application consisted in a data migration win service, a Job to process the payments applying the criteria and a windows application to show the results.

o Managed the project form requirements gathering, thru progress report, and demoed the prototype. Environment:

Visual Studio 2005, C# .Net, XML, SQL Server 2005, Win Services, Visual Source Safe, UML Dextra Technologies / HP Corporativo Santa Fe, Mexico City Feb - Apr, 2007 Software Engineer

First Level support for Hewlett Packard’s Americas Division: WW Marketing and Sales IPG IT, at Corporative Building This area has to do with all Latin America, Mexico and part of the south of the USA.

● Updated and modified web portals, using Microsoft Content Manager,

● Uploaded data to local applications including a SQL Cube.

● Tracked operation and extracting special reports from Oracle Database through TOAD application. Environment:

SQL Server Cube, Oracle, TOAD, Microsoft Content Manager Bufete de Consultoria Aplicada Oct, 2001 – Feb, 2007 Software Developer / IT Consultant /Project Leader Bufete de Consultoria Aplicada is a Consulting company that provides IT solutions for financial systems, since 1999; its customers are mainly State Government entities around Mexico.

● Leading/participating in Full SDLC including networking, infrastructure, end user training and documentation, for several projects:

“Sistema Integral de Información Administrativo y Académico” (Administrative and Academic Integral Information System) for the Universidad Autónoma de Tamaulipas (Autonomous University of Tamaulipas).

Project Modernization of the “Dirección de Administración de la Comisión del Agua del Estado de México”

(Management Direction of the Mexico State Water Commission).

Project System Optimization for the “Dirección de Fiscalización dependiente de la Dirección General de Ingresos del Gobierno del Estado de San Luís Potosí” (San Luis Potosi Estate Government’s Fiscal Auditory Direction part of the General Direction of Incomes)

Project “Sistema Integral de Administración de Recursos Financieros y Materiales (SIARF)” (Financial And Materials Resources Management Integral System) for the “Secretaría de Educación Guerrero del Gobierno del Estado de Guerrero” (Guerrero State Government’s Education Ministry)

Project “Sistema Integral de Entrega Recepción (SIERGRO)” (Delivery - Reception Integral System) for the

“Coordinación de Entrega Recepción del Gobierno del Estado de Guerrero” (Guerrero State Government Delivery – Reception Coordination)

Project “Sistema de Indicadores de Evaluación al Desempeño (SIED)” for the “Contraloría General del Estado de Veracruz de Ignacio de la Llave” (Veracruz State Government’s General Treasury Inspector’s Office)

Project “Sistema de Gestión de Auditoria Fiscal (SIGAF)” (Fiscal Auditory Management System) for the

“Dirección de Fiscalización dependiente de la Dirección General de Ingresos de la Secretaría de Finanzas del Gobierno del Estado de San Luís Potosí” (San Luis Potosi Estate Government’s Fiscal Auditory Direction part of the General Direction of Incomes)

Environment:

Visual Studio 2003/2005, ASP.NET 2.0/3.0, ADO.NET, XML, HTML, CSS, AJAX, JavaScript, SQL Server 6.0, 6.5, 7.0, 2005/2008, VSS, Web Services, VB.Net 2003/2005 Grupo Mexicano de Reingenieria May, 1999 – Oct, 2001 Programmer/Software Developer

Salome Alejandro Mancilla Chavez

****.********@*****.*** 210-***-****

Grupo Mexicano de Reingenieria is a Consulting company that provides IT solutions for financial systems, from 1995 til 2001; its customers were mainly Banks and State Government entities around Mexico. Project: Financial Systems for State Government of Colima, Mexico

● Entry level programming of windows applications in client server model, for the Financial management of Income and Revenue,

● Grown to a Software developer for the Budget and Expense, and the Tax Audit modules Project: Financial Systems for the Education Secretary of State Government of Michoacan, Mexico

● Software Developer/Team lead on the development of the Budgeting Module, and assets control

● Software developer for Expenses and billing payments module,

● Trainer and production support for all modules.

Environment:

Visual Fox Pro, Visual Basic Pro, SQL Server 6.0, 6.5, VSS, Web Services, Visual Fox Pro, VB 6.0, 6.5, EDUCATION

Bachelor of Science in Software Engineering

Instituto Tecnológico de Colima, Mexico

August 1993 - January 1999

Upgrading Courses

● SQL Server Basic Course given by Bufete de Consultoría Aplicada, March 1999

● Visual Fox pro 5.5 Basic Course given by Bufete de Consultoría Aplicada, May 1999

● Visual Basic 6.0 Intensive Course given by SINAPSIS Enterprise September 2000.

● Visual .NET Basic Course given by Bufete de Consultoría Aplicada November 2003.

● 3rd Star of Microsoft “Desarrollador Cinco Estrellas 2005”.

Contact this candidate