DAVE LARA Cell: 813-***-****

EDUCATION:

(**/2010 – 08/2012)

UNIVERSITY OF SOUTH FLORIDA, COLLEGE OF BUSINESS

B.S. in Management Information Systems; Minor in Corporate Management

(05/2005 – 12/2009)

HILLSBOROUGH COMMUNITY COLLEGE

A.A. in Liberal Arts and Sciences, Business Management

EXPERIENCE:

02/2015 to Current

PartTime Contract, Tampa, FL

Business Web Design

oWorked with small business owner to help evaluate and improve outdated website.

oCreate new user friendly webpage layouts with detail product line ups including google ad word functions to support product search.

oWorked closely with owners and met weekly to discuss changes, design functionality, product specs, update-to-date methods of payment.

oConducted research into business cost against prior saving business owner sixty percent of cost.

oConferenced with owner and service providers to streamline webpage functionality.

06/2015 to 02/2016

CITI TAX OPERATIONS, Tampa, FL

Application Developer

oDaily functions included working independently for tax ops tax department director and provided development enhancements in addition to troubleshooting daily issues for managers and their teams some include: clearing cacheing memory/ compressing, adding/removing users, creating stored procedures, comments.

oManaged and maintained data integrity for multiple VBA/SQL access EUC database shared by multiple teams/users.

oConference with managers' bi weekly in addition to senior technology team via online/phone from locations outside US.

oSupported application development for updates and stream lining of process throughout each application procedure.

oHeld phone conference meeting during testing phases for multiple end users to conduct EUC testing and validations on application updates.

oGathered requirements and creating Use Case documentation for department managers and team managers to support BRD.

oUsed Visio software to create ERD to support BRD. In addition to analyze database structure to achieve Data Normalization and free database of modification anomalies.

oSupported requirement documentation with Database Schemas and used Star Schema method.

oProject intention: Use SQL Server Management Studio tool (SSMS) to move MS Access data into a SQL Server & .NET Framework environment.

oOrganized methods to create stored procedures that correlated with access database select to be converted.

oCreated streamline methods for tuning database SQL queries removing anomalies and redundancy issues; reducing time constraints.

05/2013 to 01/2015

CITI OPERATIONS AND TECHNOLOGY, Tampa, FL

Business Systems Analyst

oDaily responsibilities included generating and archiving of metrics reports used for verification of analytics processes for team and other shareholders in multiple countries.

oManaged and maintained multiple MS Access databases established to generate series of reports used to insure data quality and daily data validation for multiple end users reporting.

oGathered requirements from department managers and team leads to create BRD to support MS Access databases for processes of daily operations.

oSupported requirement documentation for database schemas and relational database breakdowns, use cases, instructions enable with front page as a report to coincide with end product.

oOperated directly with operations stakeholders helping in the transition from Basel2 to Basel3 international regulatory requirements.

oCollaborated with multiple team leads to incorporate EUC developing of db systems process for daily operations.

oMaintained and manipulated processes and process structure of existing systems to improved delivery methods of database SQL based queries. Problem solving system issues debugging errors within VBA syntax and SQL syntax as database were being updated.

oIncluded end user computing methods within MS Access forms creating combo boxes, and multiple macro enabled button layout collaborating the use VBA language to execute SQL scripted within access environment.

oTested and debugged SQL script within MS Sybase and insured that database could read correctly.

oPerformed ETL methods in design of databases: extracted via ODBC connection from SQL Sybase into MS Access where data format was transformed and defined, to flow from source to target Excel worksheets and SharePoint.

oAutomated with Microsoft office suite application (Excel, Word, PowerPoint, Outlook, Access, and SharePoint) VBA, Macros, Formulas, V-lookup, to interact with multiple databases created for series of pivot reports and graphs.

oQA and QC tested automation processes- Query simplified, data dependency improving delivery time and data quality.

oNetworked multiple databases linking functionality process to improve on performance and ease of data access.

oEstablished models for ease of implementation of other SQL query oriented db requirements for team to improve on business automation endeavors.

08/2005 to 05/2013

NCH CORPORATION/ PARTS-MASTER, Tampa, Plant City, FL

Project Management /Inventory Contractor

oWorked independently remote and onsite with team during special projects

oWorked closely with sales vendor to set up and establish product inventory for multiple clients.

oPerformed assessment and mapping out of client inventory for cataloging via AIDC bar coding.

oIncorporated Microsoft office suite app (Excel, Word, PowerPoint, Outlook, Share Point) to retrieve and interact with data.

oEstablished MS Access databases used to gather data for reports used to for analysis of supplied inventory data.

oGathered monthly cost reports and used statistical computing methods within MS Access and Excel to analyze trends for strategic advantage for client.

oReviewed and reported demand patterns, preliminary supply, safety stock and inventory turnovers to establish optimum holding cost.

oCreated budget reports with gathered information and pricing data to maintain monthly budgets for clients.

oUsed cross referenced methods for inventory of excel spread sheet to clients SAP control transactions codes.

oExpanded and itemized function including cost, product descriptions, and client information.

oReported monthly inventory adjustment to clients and management team.

oManaged and maintained a monthly assessment of product inventory adjusting accordingly based on budget and priority of special projects.

oPrepared, scheduled and conducted regular inventory analysis and insured inventory physical counts. Ensured UPC barcodes were current and responding with correct data via tracking tool log reader and insured counts reflected database inventory.

oOverseen logistics processes for product, examined product, and verified completeness of orders and resolved billing, invoice, and/or other do comments to satisfy customer relations.

08/2011 to 12/2011

CORBAN ONE GROUP, St. Petersburg, FL

Business Process Analyst - (USF Project, Non-Paid)

oWorked with a team and with direction from company CEO to determined project requirements. Assigned to map process of executive level business structure to implement solutions for management strategies.

oUsed Visio process mapping to reflect organizational business functions and detailed key areas of the business and its process to eliminate or prioritize.

oInterviewed with key company stakeholders to establish daily company processes and operation procedures.

oEstablished directory with assigned team to collaborate and illustrate weekly process maps and procedures.

oConference weekly with key stakeholders to ensure process maps and development of project were met.

TRAINING:

Course Training: MIS/MNG

Business Application Development

Systems Analysis and Design

Information Security Management

Operations and Supply Chain Processes

Database Administration

Business Data Communications

Managing Information Resources

Organizational Behavior Analysis

Human Resource Management

Organizational Assessment

Integrated Management Applications

BUSINESS AND ECONOMIC STATISTICS I & II

Electronic Commerce

TECHNICAL SKILLS:

MS Office Suite (Access, SharePoint, Word, Power Point, Excel, and Outlook) Microsoft Visual Studios, Microsoft MySQL,

(C (C#), .Net, HTML, VB, SQL, IBM Cognos, EUC Automation,

Database design: QA, QC, Testing, Debugging, MS Visio, Blueworks, Deployment Flowcharts (Use Case, Cross Functional Process Mapping) (Functional, Nonfunctional Mapping),LEAN Manufacturing training, Six Sigma training,

Operating Systems Windows 7,8, Mac. IBM SPSS Clementine Statistics,(LAN/WAN) Computer networking flowchart design.

Information Security, Penetration Testing, Network analyzing, Wire Shark, CISSP Tested, and CEH Tested.

Myers Briggs Certificate of Completion in (Management), Management and Leadership/Team Building in (Management)

For more information regarding projects please view website provided below.

http://dlara49.wixsite.com/online-dlara-resume

Contact this candidate