| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name Jr.
Street Address University Heights Blvd Phone: PHONE NUMBER AVAILABLESan Antonio, Texas Street Address Email: EMAIL AVAILABLESummary of Qualifications Design, create and maintain database objects in MS SQL Server using T-SQL Design, create and maintain database objects in Oracle using PL/SQL
Design, create and maintain front end applications on multiple platforms Customer service, quality driven, dependable and easily adaptable Create Business Requirements, Functional and Non-Functional Design, Technical Design and Unit Testing Documents Perform data collection and analysis to create visualizations for business processes Coordinate with various teams to create conceptual data models and data flows Keep in constant communication with the stakeholders and/or user community to assure project integrityTechnical SkillsDatabase Systems MS SQL Server, Oracle, Sybase Server, MS AccessDatabase Languages Microsoft T-SQL, Oracle PL/SQL, Sybase Server, AccessDatabase Services PL/SQL Developer, TOAD, SQL Server Management Studio (SSMS),
Integration Service (SSIS), Reporting Service (SSRS)Software Microsoft Office Enterprise, Visio, ErWin Data ModelerRemote access VPN, Citrix, VMWare, Windows 10 Remote DesktopSDLC Methodology Agile, WaterfallProfessional Experience
OptumRx Dates 01/2023 - 09/2023Manufacturing Data Engineer
Fulfilling data extraction needs for business needs of the pharmacy operations department. Assisting in data conversions or creating application solutions to office requirements. Responsibilities included:
Create production data results for management with ad hoc queries Keep in constant communication with the stakeholders and/or user community to assure project integrity Design, create and maintain database objects (Procedures, functions, packages, triggers, Etc.) Create or modify reporting module to comply to regulation or business requirementsEnvironments: MS SQL Server 2016/18/22, MS SQL Management Studio (SSMS), Visual Studio, Windows 10, VMWare, Microsoft Office 365, CyberArk, Splunk, PowerBIACM Consulting, Inc. Dates 01/2017 - 12/2022Systems Analyst/Technical Consultant
Providing or modifying solutions to the business needs of various organizations. Assisting in data conversions or creating application solutions to office requirements. Tasks include office automation or modification to current trends.
Develop and troubleshoot Web application issues utilizing .Net/C# technology Provide technical support for existing systems and modify third party applications Integrate data from external sources to stage for internal office use Create or modify reporting module to comply to regulation or business requirements Assist clients with upgrades to their desktop systems in Windows and MacOS platforms Four Leaf Ventures, Irving, TX Dates 09/2021 12/2022Technical Consultant Contract Gathered business requirements concerning timekeeping and tip sharing Created patches and solutions to fix bugs in existing applications for Windows Server Evaluated latest technology and adopted cost-effective, useful solutions for Window Servers Created Access database and tables to port the data from Excel Migrated the current system from Excel to an Access database Performed unit and QA testing for implementation and provided post production support Provided reporting on trends and productivity Maximus, Brownsville, TX Dates 03/2020 03/2021Technical Consultant Contract Consulted on efficient processing of applications for the Covid Affordability Connectivity Program (ACP) Performed maintenance on user roles to ensure fluent application processing Restructured tables and queries to utilize optimal indexing Presented application processing to management in visualizations Computer Solutions Inc, San Antonio, TX Dates 06/2017 09/2019Technical Consultant Contract Gathered business requirements and create BRD for technical group Assisted in creating technical documents and assist in coding changes
Perform unit and QA testing for implementation Provided post production support and present optimization progress reportsEnvironments: Oracle 11g, MS SQL Server 2008/2012, SQL Developer, PL/SQL Developer, MS Access, MS SQL Management Studio (SSMS), SQL *Plus, Visual Studio, Windows Server, Visio, Microsoft Access, Microsoft Office Suite, Powerbuilder, TableauAlamo Colleges Dates 06/2016 09/2016Systems Administrator Manage user accounts and distribution groups Develop database reports for the multiple campuses Create PL/SQL queries to develop Argos Datablocks Develop system changes to improve the reporting process Interact with campus employees to gain their system requestsEngility Dates 04/2015 06/2016Application System Analyst (Remote) Assist in the development of the requirements and design documents for the Department of Defense - Retirement Benefits Program Attend daily SCRUM meetings to assess progress on projectEnvironments: SQL Server 2008/2012, SQL Management Studio (SSMS), Integration Service (SSIS), Reporting Service (SSRS), SQL *Plus, Visual Studio, Windows, Windows Server, Visio, Microsoft Access, Microsoft Office SuiteACM Consulting, Inc. Dates 05/2014 12/2014Technical Consultant Trinity Millennium, San Antonio, TX Dates 07/2014 08/2014Systems Analyst Contract Consulted on application issues concerning conversions of legacy systems Trained in Java on an in-house created training curriculum
Developed conversion applications to convert legacy systems to Java from PowerBuilder LORR, San Antonio, TX Dates 05/2014 07/2014Systems Analyst Contract Gathered business requirements, performed feasibility studies and created the technical specifications
Developed and maintained current record storage application Developed database objects necessary to the needs of the application Integrated customer data to effectively and rapidly convert existing data to the LORR application structureIntegrated Components San Antonio, TX Dates 12/2013 01/2014Software Engineer Designed the new bill payment systems database model and application specifications Created various database objects to support the newly designed projectACM Consulting, Inc. Dates 03/2013 12/2013Technical Consultant SD-Tech, Inc. San Antonio, Texas Dates 07/2013 12/2013Systems Analyst Contract Gathered and created Business Requirements, created Functional and Non-Functional Design and Technical Specifications Developed and maintained front end objects requested by customers and owners Designed, created and maintained database objects in MS SQL Server
Analyzed, designed and developed enhancements outlined by stakeholdersEnvironment: MS SQL Server 2012 R2, MS SQL Management Studio (SSMS), Windows 7 Professional, Windows Server 2012, Microsoft Office Enterprise, SSIS, Visual Studio Allbrite Construction, Inc. San Antonio, Texas Dates 03/2013 06/2013Systems Analyst Contract Procured hardware necessary to centralize the file structure Installed Windows Server and configured connectivity of all users Performed training seminars on accessibilityEJ Ward, Inc. San Antonio, Texas Dates 08/2012 01/2013System Engineer Performed the role as Project Manager, Business Analyst and System Analyst/Programmer Created Business Requirements, Process Flows, Functional and Non-Functional Design and Technical Specifications Designed, created and maintained database objects in Oracle 11g using PL/SQL coding Designed, developed and maintained Oracle and MS SQL Server stored procedures Supported multiple customers nationwide and maintained service tickets Adhered to the Waterfall methodology to accomplish necessary documentation of the SDLC Integrated data from legacy sources to optimize the database structure for the future state of the design Performed data collection and analysis to create visualizations for business processesEnvironment: Oracle 11g, MS SQL Server 2005 and 2008, SQL Developer, PL/SQL Developer, SQL Management Studio (SSMS), Integration Service (SSIS), Reporting Service (SSRS), SQL *Plus, Visual Studio, Windows 7 Professional, VisioACM Consulting, Inc. Dates 05/2012 08/2012Technical Consultant Innovative Software Solutions - San Antonio, TX Dates 05/2012 08/2012Systems Analyst/Senior Programmer Contract Developed and maintained front end objects requested by customers and management Created Business Requirements, Functional and Non-Functional Design and Technical Specifications Analyzed, designed and developed enhancements to the systems developed by the companyEnvironment: Microsoft SQL Server 2003, SQL Server Manager, PowerBuilder 11.5, NSIS (Nullsoft Scriptable Install System), Vista, MS Exchange, MS Office 2003/2007Kinetic Concepts, Inc. San Antonio, Texas Dates 09/2002 03/2012Systems Analyst/Lead Programmer
Managed large projects as team lead across multiple Information Technology and Business departments Developed and maintained front end objects requested by customers and management utilizing PowerBuilder, .Net and C# Designed, developed and implemented Oracle PL/SQL objects including packages, procedures, functions and triggers and modifications to database table structures including creations, alters and indexes to support the change requirements made to the front-end applications Collected and created implementation scripts for production, including gathering Oracle PL/SQL changes developed and maintained and application modifications to be submitted to change management Participated and contributed in timeline project planning and project cost estimates Constantly communicated with all stakeholders of projects to confirm any modifications would accomplish the desired goal and not create issues downstream once deployed Conducted training sessions for major application releases for the user community and the Service Desk Consistently communicated with Managers, Project Managers, Database Administrators and Business Analysts throughout project lifecycles
Complied with SDLC standards utilizing the Waterfall and Agile (on limited projects) methodologies Performed the role as Project Manager, Business Analyst and System Analyst/Programmer Created the Business Requirement Documents, Functional and Non-Functional Design Documents, Use Cases, Technical Design Documents, Unit Test Plans and created and performed Design Reviews for peers, managers and end users Monitored movement of changes from Development to Testing to QA to Production Tracked performance and any issues encountered in post-Production Implementation Interacted with the Service Desk, National Call Center and user community of multiple corporate systems to resolve Service Desk tickets and obtain specifications on user requests Created executables and automatic installers for system releases for multiple systems and remained available for any issues, complications or questions after deployment Performed light assigned tasks on projects concerning Data Warehousing, Oracle Financials, T-SQL and SOA Created EDI transactions to determine e-Eligibility for Managed Care and Medicare coverage and processed the response to the request (Transactions 270 and 271)Environment: Oracle (8, 9, 10g, 11g), PL/SQL Developer, SQL *Plus, MS SQL Server 2008 R2, SQL Management Studio (SSMS), PowerBuilder 9 to12.5, PowerBuilder Foundation Class, Serena Source Control, .Net 2.0, C#, Agile JAVA, Oracle Application Development Framework, SSIS, ErWin Data Modeler, Visio, Drools, Visual ParadigmEnron Net Works - Houston, Texas Dates 08/2001 09/2002Senior IT Specialist Develop and maintain front end applications and database objects Design, create and maintain database objects in Oracle 11i using PL/SQL coding Perform maintenance on in-house information management system in the area of Gas Settlements. Projects include applying fixes and modifications to PowerBuilder objects and intricate stored procedures
Performed the role of Project Manager, Business Analyst and Systems Analyst/Programmer Created the Business Requirements, Technical Design, Unit Test Plans Monitored the implementation of modifications to production and tracked any and responded to any issues or questions brought on by Production deploymentEnvironment: PowerBuilder 6.5.1, Sybase System 11, Oracle 8i, PowerBuilder Foundation Class, Microsoft Query Analyzer, Windows 2000 Professional, Lotus Notes, Java, Windows 2000EDUCATIONSan Antonio College Computer Systems Analysis San Antonio, TXREFERENCESBill Hamby, Director HR & PMO Systems, Valero Energy Corporation (Retired)(C) PHONE NUMBER AVAILABLE
Matt McGlothlin, Lead Business Intelligence Analyst, USAA (Retired)(C) PHONE NUMBER AVAILABLE
|
