| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Cell: PHONE NUMBER AVAILABLE E-mail: EMAIL AVAILABLELinkedIn: LINKEDIN LINK AVAILABLESYSTEMS ANALYSIS/DESIGN/PROGRAMMING - DB PROGRAMMERSystems Designer/Analyst, Computer Programmer and Database Professional, with extensive experience designing, developing and implementing information systems. Experienced developing solutions, conducting system overviews and operational tests, analyzing and identifying defects and software conflicts. Proficiency in SQL databases migration, programming and design.SUMMARY OF QUALIFICATIONSExperienced with database design concepts, data organization and storage.Experience with ETL solutions, worked with DTS, SSIS and SSRSReceived training in OLAP and Data MiningStrong problem-solving skills, as well as organizational ability.Excellent communication and interpersonal skills; Fluent English Spanish.Demonstrated ability to quickly learn and grasp new concepts, create innovative solutions.Capable of working independently or as part of a team effort.SKILLS: Operating Systems: Windows Server 2003 2008 R2, Windows XP, Windows 7, DOSLanguages: VB.NET VB6 MS ACCESS VBA XML HTML T-SQLDBMS: SQL Server 2005/2016 Stored Procedures Views Functions Triggers SQL Server Agent Jobs SQL Management Studio ADO.Net ODBCETL: SQL Server Integration System (SSIS)Reporting: Crystal Reports XI SQL Reporting Services (SSRS)Microsoft: Microsoft Office Suite MSMQ Visual Source safe Team FoundationOther: SAGE ERP 500, SBT Pro Series ACCPAC Pro Series JIRA (Zoom)EXPERIENCE:CDK GLOBAL 03/19-PresentSales and CRM software developer for automotive, marine, agriculture and, construction companiesETL Developer- ContractMaintaining & Creating SSIS (ETL) Projects using VS 2017 and SQL 2016 to import especially from XML files and reporting through EXCEL.Creating SQL 2016 views and stored procedures consumed by SSIS packages.Standardizing already created Stored Procedures, implementing exceptions handling.CONVEY HEALTH SOLUTIONS 07/18-01/19Government Sponsored Health Plans Services for Health Insurance CompaniesSQL Developer- 6 Months contractCreated SQL 2016 views, functions, triggers and stored procedures to maintain database SQL information.Maintained customers' applications using MS Visual Studio 2015 and C# programming language.Created SQL 2016 views, functions, triggers and stored procedures for new projects.Used SSIS applications (ETL) to transfer information from clients into our SQL database.CHROMALLOY GAS TURBINE LLC 08/17 06/18Design, manufacture and repair gas turbine engines parts.Data Warehouse Developer- 10 Months contractCreated SSIS packages (ETL) using VS 2015 transferring and modifying information from different sources (Sql, Oracle, DB2, Access, Flat files and FoxPro) into a data warehouse in SQL Server 2016.Enhanced SSIS packages design grouping functionality in different packages called by the Execute package task.Created SSRS reports from data warehouse for management.Used EXCEL macros and VBA to present detail information about tables and structures using functions and pivot tables.L. GARCIA-BLASQUEZ - PAGE 2EXPERIENCE: (CONTINUED)KNIGHTS ENTERPRISES MANAGEMENT, LLC 10/1507/17Advanced developments in weapon designs and accessoriesDatabase DeveloperCustomized the company's SAGE 500 ERP system using the built-in customization technology.Created SQL 2012 views and stored procedures to complement the SAGE 500 ERP system's customization.Developed .NET desktop applications using VS 2010 and SQL Server 2012, linked to EXCEL to present graphics.Designed the Sales Traveler .Net desktop application to control all aspects of Sales Orders processing from gathering finished items, government authorizations, invoicing, packing and shipping.NIGHTINGALE NURSES 10/12 07/15Traveler Nurses Staffing Company Boca Raton, FLApplications Developer- Database ProgrammerMaintained the Company main application using Microsoft Access 2010 using VBA forms and Macros.Created/modified SQL 2008 Stored Procedures, Views, Functions and Triggers, called by the Access application.Created SSRS reports distributed through for a wide range of users via SSRS Data Driven Subscriptions.Build SQL Agent Jobs to schedule distribution of SSRS reports.EDGEMED HEALTHCARE SOLUTIONS, INC. 03/12 09/12Practice Management Software & Medical Billing Services Boca Raton, FLDatabase Developer- 6 months contractMaintained the company's trade mark "Innovation" System using FoxPro 5.0Fixed corrupted FoxPro databases, create new indexes and rebuilt entire databases.Migrated the Company's Innovation system from Visual FoxPro databases to SQL Server using SSIS applications.Created SQL Stored Procedures, Functions and Views to support FoxPro functionality.TECHNOLOGICAL UNIVERSITY OF AMERICA 11/09 03/12University Coconut Creek, FLSystems Analyst/ProgrammerSupervised the design of the University website and all server side applications & SQL Information.Developed the library control system using VB.NET using VS2010 and SQL 2008. Graphics were presented in linked EXCEL sessions and extensive use of macros.Supported marketing campaigns to increase student census with data handling and reports.Created a data warehouse through SSIS applications to import student population/careers information from different regions in the US. Used SSRS to create reports.GLOBAL TV CONCEPTS, LTD. 11/08 11/09Design, Manufacturing and Distribution of Consumer Products Deerfield Beach, FLSystems Analyst Consultant 12 months contractPerformed system analysis to provide complete diagrams of the information flow of the company.Research vendors to find an effective EAI for the company to integrate accounting, CRM and EDI applications.Perform cost-benefit and ROI analyses for proposed systems, to aid management in decision making.Supervised the migration of the company Peach Tree accounting system to Microsoft GP and Dynamics CRM.FLEET LEASE DISPOSAL, INC. 08/99 11/08Used Vehicles Remarketing Delray Beach, FLSenior Systems Analyst/ProgrammerMaintained the company's main application using FoxPro 5.0, and SQL Server 2000.Migrated of the Company's FoxPro code to VB.NET application and the FoxPro databases to SQL Server 2005.Linked the main .NET application to SBT Accounting system via MSMQ using Web and Windows services.Created ETL applications using DTS and SSIS (ETL) with VS2005 and SQL Server 2005/2008.Created SSRS reports with VS2005 and SQL Server 2008.STUDIES:PERUVIAN AIR FORCERanks: Second Lieutenant / LieutenantPeruvian Air Force Academy: Bachelor of Science, Major: Statistics and Computer Science.Developed information systems solutions for the Air Forces Supply Chain and Aircraft Maintenance using COBOL programming language and FORTE and INFOS database management systems. |
