Ted Lucas Email & Phone Number

Dallas, Texas, Us

Minneapolis, Mn, Us

Conduct comprehensive business and and quality analysis on data models, delivering valuable insights to Softcrylic's clientsAnalyze the business requirements and create logical data modelsCollaborate with cross-functional teams to design and develop Power BI dashboards for monitoring business performance metricsLead developers in the design and implementation of SQL views and tables withing the Azure environment, optimizing data structures for Power BI based dashboardsComplete quality assurance and analysis on SQL views and stored proceduresDevelop and provide exception reports to guide process improvementConsult with business owners and stakeholders to guarantee that business requirements are aligned and successfully met

Sought continuing education opportunities to stay current with industry trendsRecently completed and graduated with an Associate of Applied Science (3.9 GPA)

New York, Ny, Us

Serve as the Subject Matter Expert (SME) for root cause analysis/resolution for production issues.Analyze reported issues/incidents/defects to aid in determining possible underlying root causes and related improvements for continuous improvement efforts.Communicate to all stakeholders the impact assessment, steps taken for issue resolution and root cause analysis results.Conduct audits of the teams’ deliverables to ensure adherenceTrack, monitor and report/update Internal and OEM Partners on acceptance/rejection and resolution progress of accepted known defects.Run reports in SQL to verify integrity of data across multiple platforms and identify where corrections are to be made.Run reports on Amazon Cloud Services (AWS) using CloudWatch as part of analysis of quality of communication from remote devices.Identify quality issues to improve reliability of processes.Analyze API responses in JSON format.Use Postman and JavaScript to script updates to third party database using provided APIs.

Flower Mound, Tx, Us

Install and configure Spindlemedia's SMI Tax Office and SMI Suite software on customer workstations, a suite of both locally installed and cloud based Property Tax Software used by Taxing AuthoritiesCreate backup databases for use in testingCorrect and modify financially sensitive data using SQL statements Create SQL queries to validate quality of financial dataUpdate SQL stored procedures based on changes to requirementsMaintain and update customer facing installation and support documentationCreate and maintain internal support and technical documentation

Provide tier 1-2 support for cloud application by providing technical systems and data analysis support. Work closely with development, operations, and users to analyze and resolve all issues . Identify trends in local and national issues. Document clearly all issues and the steps taken to resolve the issue. Perform reports using SQL, Access, and Excel. Write queries and reports in SQL and in Microsoft Access. Write, create and maintain Excel Macros using VBA. Create and maintain support documentation. Perform user acceptance testing and QA testing. Accomplish project goals within an Agile Scrum environment.

Irvine, Ca, Us

Run and improve daily, weekly, monthly, and quarterly reports • Refine and automate scheduled processes, through improvement of existing codebase • Create, maintain, and improve VBA macros in excel to automate reports and improve report quality • Build and maintain SQL queries in Oracle • Update database using SQL, including running QA/QC steps and cleaning data using SQL and Excel • Create and maintain documentation for SOPs and regulatory compliance • Update and improve existing documentation in order to document changes, as well as streamline and clarify processes • Respond to ad hoc data requests from management and clients • Create fixed width data files for transmission of financial data to state tax agencies

Formatting data so it can be sent to all employees of the company with necessary information regarding their annual bonuses • Using Visual Basic to write macros to sort output so managers only receive data for their own employees • Working within Excel to automate this process and be tolerant of daily changes to the original source file • Automating process to ensure when the data is finalized it can be sent within strict deadlines

Houston, Tx, Us

Provide tier 2 support for an industry specific sales and inventory management database system.Create and maintain process and support flow documents for support staff.Create and test SQL scripts daily for corrections to the database.Prepare detailed and accurate documentation of queries and testing.Perform system testing, complying with Sarbanes Oxley documentation regulations.Run ad hoc reports for project management using SQL.Analyze and communicate findings to project management.

White Plains, Ny, Us

Generate Medicare claim data in SQL, and use results to create charts within Excel for use in monthly PowerPoint presentation for business leaders. Retrieve and upload beneficiary data to and from the Medicare CMS (Centers for Medicare and Medicaid Services) database. Update beneficiary information using data from multiple Accountable Care Organizations. Generate daily and weekly reports for Client Care Coordination detailing client interactions with physicians and client eligibility. Run ad hoc reports for upper management using SQL and Excel for in depth analysis. Create, update, and maintain SQL scripts for use in retrieving beneficiary, provider, and claim data from multiple databases. Work with the IT department in to assist in the automation of regularly scheduled reports.

New York, Ny, Us

Created and analyzed reports in SalesForce and Excel to manage workload and ensure efficiency of contract negotiations. Created data and graph intensive PowerPoint presentations for view by management. Created new and modified existing processes to facilitate offshoring of data analysis role.

Us

Generated and analyzed reports using Excel and Access. Evaluated technical concerns to insure access to database application and resolve technical issues. Created training and support documentation. SharePoint coordinator and site manager. Manage user account maintenance and permissions issues in Active Directory, deliver technical support to users, and effectively handle tasks related to user account management. User administrator for database application.

Houston, Texas, Us

Analyzed hardware failures on HP Industry Standard Servers in order to improve manufacturing quality and streamline service solutions.

Set up and configured new workstations, installed hardware/software, setup home networks and printers. Troubleshot issues using Windows XP, Windows Vista and Windows 7. Trained clients on new and existing equipment and software.

Indianapolis, Indiana, Us

Headed a team of 10 technical support staff. Functioned as lead and main point of support contact for management of pharmaceutical sales CRM, using in depth knowledge of this software to remotely support and assist pharmaceutical sales reps including training, maintenance, and new software deployment. Trained all new technical support staff. Created, maintained and updated training documentation using PowerPoint and Word. Managed Remedy ticket queues to ensure incident resolution within defined Service Level Agreements.Perform user account management in Active Directory, analyze account related issues, deliver technical support to users, and resolve print server issues in an enterprise environment

Associate Of Arts And Sciences - Aas, Interactive Simulation And Game Technology

Bachelor Of Arts (B.A.), Philosophy