**** * **** ** *******, TX ***** 956-***-**** adh24f@r.postjobfree.com

https://www.linkedin.com/in/ivan-sierra-766051161/ VÁN SIERRA IT PROFESSIONAL

Software Engineer ~ Database Developer

Dynamic, versatile IT Professional with years of experience in software and database development. Demonstrated ability leveraging IT knowledge and strategic skill to deliver solutions beyond organizational expectations. Proven track record leading teams to achieve projects goals on time and within strict budgets. Recognized as a subject matter expert and awarded for innovative solutions. Fluent in Spanish. Areas of Expertise include:

Strategic Planning & Forecasting Research & Analysis Requirement Gathering

Regulatory Compliance Relationship Building Project Management

Improved Efficiency Client Education Problem Resolution EXPERIENCE & NOTABLE CONTRIBUTIONS

INVOICE CLOUD, INC.

DATABASE ADMINISTRATOR/SQL DEVELOPER Brownsville, TX 2018-2020 Served as a database developer and administrator analyzing, designing, and implementing new projects

Analyzing requests and determining the correct course of action need it to complete the task.

Coding and generating custom reports, Performing safe data updates and logging changes

Modifying and or creating tables, functions, stored procedures, etc. if requested and properly planned

Deploying changes to all databases in Azure environment to ensure consistency.

Using Azure Portal to ensure uptime, evaluate problems and recommend performance improvement

To provide expertise in technical design, analysis, performance and solving technical issues during project delivery

INVOICE CLOUD, INC.

SOFTWARE ENGINEER Brownsville, TX 2015-2018

Analyzed IT system requirements, client’s information technology needs and their resources in order to integrate them with our system.

Importing any custom file format to our system and converting them to Invoice, Payments, Adjustment Files, through different methods like, FTP, WEB Services, CRM, Stratus Application, etc.

Create ASPX web templates to display invoices in our system

Diagnose and resolve IVR interface issues

PDF Link process, read and extract data from PDF to make a link them to records in our system

Update Autopay and Paperless data and communicate with customer's systems PEGASYS SYSTEMS

COMPUTER SYSTEM ANALYST CONSULTANT Detroit, MI 2015-2015 Worked closely with clients to analyze IT system requirements, client’s information technology needs and their resources in order to plan IT projects and fulfill client’s expectations

Work on MS SQL Database (SQL Server 2008-R2/2012) / Business Intelligence (SSIS/SSAS/SSRS) & other database development methodologies and other tools required by our clients to perform specific task

Work with the team to conceive, develop, deploy, and maintain solutions to meet business and technical requirements

Enhance development base on Reporting and Analysis Services. Use SQL Server Reporting Services (SSRS) to design complex reports.

Need to write complex SQL queries and develop Stored Procedures and functions in SQL server environment. I

2432 N 31st ST McAllen, TX 78501 956-***-**** adh24f@r.postjobfree.com https://www.linkedin.com/in/ivan-sierra-766051161/ IVÁN SIERRA, PAGE 2

FYPON

SR SQL AND .NET DEVELOPER Matamoros, MX 2014-2015 Led IT projects and the information development team, developing RFID tracking to provide easy access to any information related to manufacturing plant production.

Reduced IT equipment costs by 75%.

Mentored, trained, and led application development team and enhancing development response.

Leveraged dynamic web and deliverable reports to provide accurate data for key management decisions. THERMATRU DOORS

SQL .NET DEVELOPER Matamoros, MX 2011-2015

Served as a database developer and administrator analyzing, designing, and implementing new projects.

Automatized and optimized daily reports and reduced database update process by 50%.

Developed and implemented devices for HMI data acquisition.

Enhanced data analysis migrating MS Access databases and processes to an M S SQL Server. UNIVERSAL LIGHTING TECHNOLOGIES

SOFTWARE DEVELOPER Matamoros, MX 2008-2011

Developed and maintain applications supporting headquarters operations and production plant.

Reduced maintenance support time moving desktop and windows applications to web applications.

Served on 24/7 on-call rotation for remote maintenance and troubleshooting. CARTOINDUSTRIAL DEL NORTE

IT SUPERVISOR Matamoros, MX 2007-2008

Responsible for the IT environment of the production plant, including hardware, and software maintenance.

Provided accurate data about purchases, sales, and administrative transaction to support decision-making.

Decreased response time to customers by 30% and inventory time by 50%. INDUSTRIAL AUTOMATION

OWNER, PROJECT MANAGER Matamoros, MX 2001-2007 Built this industry-service company to administer HR and analyze, design, and develop automated systems through customized examination—led IT development team, customer support, and accounting.

Built and maintained network of customer relationships.

Supported customers increasing productivity by providing specific, customized solutions to meet client needs. GOBAR SYSTEMS

DEVELOPER ENGINEER Matamoros, MX 2000-2001

Developed automation projects supporting headquarters operations and production plant.

Achieved 100% product inspection using electronic devices and microcontrollers.

Achieved 100% product inspection using DVT vision system.

Reduced costs in automated machines replacing PLC with microcontrollers. COMPUSERVICIOS DIGITEC

SOFTWARE DEVELOPER Matamoros, MX 1997-2000

Developed IT system specifications after evaluating customer’s nature of work and business volume.

• Helped customer to increase their productivity by providing a specific and particular solution to their own needs.

• Reduced scrap using automated reports providing accurate data. 2432 N 31st ST McAllen, TX 78501 956-***-**** adh24f@r.postjobfree.com https://www.linkedin.com/in/ivan-sierra-766051161/ IVÁN SIERRA, PAGE 3

KEMET ELECTRONICS

MAINTENANCE MECHANIC Matamoros, MX 1995-1999

Mechanic plant problem-solve.

• Worked solving electro-mechanic problems in different kind of automated machines. DELPHI DELCO ELECTRONICS

AUTOMATIC INSERTION TECHNICIAN Matamoros, MX 1994-1995 Kept production equipment in optimal operation.

• Repair axial and radial machines electro-mechanic problems. 2432 N 31st ST McAllen, TX 78501 956-***-**** adh24f@r.postjobfree.com https://www.linkedin.com/in/ivan-sierra-766051161/ IVÁN SIERRA, PAGE 4

EDUCATION

Bachelor of Science, Electronic Engineering

INSTITUTO TECNOLOGICO DE MATAMOROS Matamoros, MX 2001 TECHNICAL SKILL

Languages

Visual Studio .NET 2010/2008/2005/2003 (VB.Net and C#) VB 4/5/6 ASP APEX for Oracle 3 & 4 GW-Basic Q Quick Basic VBA HTML PHP CSS JavaScript XML Python Unix/Linux Scripts Databases

MS-SQL Server 2000/2005/2008,2012, 2014, 2016/Azure Business Intelligent Development Studio SSIS SSRS Firebird PostgreSQL

MySQL Oracle 7.3,8i,9i,10g/11g Access Excel DBase Software

Open Office Crystal Reports (Business Objects) Crystal Clear (I-NET Software) Corel Draw Adobe Fireworks Dreamweaver AutoCAD TOAD SQL-PLUS SQL Developer ZPL AVG Norton Symantec McAfee Operating Systems and Servers

Windows Server 2000/2003/2008/2012 Windows (all versions and servers) UNIX/Linux IIS Apache DHCP DNS LAMP WAM Raspberry PI OS.

AWARDS

1st place, II, III IV y V Software Contest, Technologic Institute of Matamoros 1st place, IX, X, XI y XII Creativity Contest, Technologic Institute of Matamoros Participant, IV, V, VI y VII Electronic, Information Technology and Electric Inter-University Congress (CIECE) 2nd Place, National Mathematics Olympics (City)

6th Place, National Mathematics Olympics (State)

Participant, IX National Mathematics Olympics (National)

Contact this candidate