Business Analyst/Reports Developer
Resume:
ELIER O. SANCHEZ
Valrico, Florida 33594 Email: acg4xp@r.postjobfree.com
AREAS OF EXPERIENCE
System Tools: SSIS, SSRS, DTS, SaaS, Data Analyzer, Crystal Reports, Excel,
Active Directory, Remedy, Visio, CERNER, SIEMENS, PHP, XML, SharePoint
Database Tools: ORACLE, SAP, MANTAS, ORACLE SQL Developer, TOAD, ACCESS,
Crystal Enterprise (CMC), Oracle SQL* Plus, Query Builder, Oracle
Enterprise Manager, T-SQL, MySQL
PROFESSIONAL EXPERIENCE
PEMCO World Air Services/TEKSystems, Tampa, FL 10/2013 -
12/2014
Business Systems Analyst
. Liaison between internal business groups and the technology group to
identify needs and opportunities for enhancements and increased
efficiency in information delivery.
. Daily usage of creating SQL queries and utilizes reporting tools, such as
Crystal Reports, Query Builder, Access, etc. Currently an active
participant in an Oracle based ERP roll-out. During the ERP project,
responsible for converting and certifying existing Crystal reports.
Create ad-hoc reports for departments to analyze data from old system and
new system.
. Currently creating SaaS reports for dashboard sites for production team
to determine performances for each plane visiting the hangars.
. Interact with individuals on the floor (hangars) and line managers that
request reports and analysis on everything from: efficiency, processes,
workloads and redundancies.
. Identify opportunities for and contribute to the improvement of quality,
safety and cost for employee and client satisfaction.
Lakeland Regional Medical Center, Lakeland, FL
01/2013 - 10/2013
Junior Business Systems Analyst
. Identify and implement information system solutions that support more
efficient and effective work performance based on inherent knowledge of
business functions and processes.
. Develop and manage project plans for the deployment of new and/or changes
to information system applications.
. Administer system applications and serve as an educator and resource
regarding system functionality. I am responsible for functioning within
scope of individual education, licensure and competence.
. Identify opportunities for and contribute to the improvement of quality,
safety and cost, as well as patient, customer, and employee satisfaction.
. Create documents and reports using Squirrel SQL Client, Word,
Access and SSRS. Manage and assists with SharePoint
modifications and methods.
. Reviewed projects and design documentations for quality
expectations plus mine databases and investigated processes to
analyze resolutions.
BUNCH & Associates/Ashley Ellis, Tampa, FL 05/2012 -
01/2013
Business/Quality Assurance Analyst
. Evaluated and tested new or modified software programs and
software development procedures used to verify the programs
functions according to user requirements and confirm to
establish guidelines.
. Written, revised and verified quality standards and test
procedures for program design and product evaluation to attain
quality goals and objectives.
. Defined test procedures and tested plans for application
development while ensuring data integrity at all times when
testing applications. Troubleshoot applications errors or
applications by isolating issues from symptoms and recommend
solutions.
. Create queries using T-SQL and SQL for TOAD and SQL Server 12.
Manage and assists with SharePoint modifications and methods.
. Reviewed projects and design documentations for quality
expectations plus mine databases and investigated processes to
analyze resolutions.
. Created documentation of all test scripts for all bill review,
invoices and claim import/export to pass quality assurance and
update work orders through SHAREPOINT.
. Analysis of user requirements, procedures and problems to
automate processing to improve existing computer system.
. Ability to work in a cross functional team setting and lead or
serve on technical teams within the department.
. Determined necessary data to be entered, processing
procedures, and structures the output to achieve needs of end
users.
Hillsborough County Schools, Tampa, FL
Teacher 10/2003-06/2008 & 10/2009-
04/2012
. Taught eighth grade students for Hillsborough County by
following curriculum on regular, Pre-Algebra, Algebra I and II
Honors math.
. Taught high school students for Hillsborough County by
following curriculum on regular/advance Algebra, Algebra I and
II Honors math.
CITIGROUP/RANDSTAD, Tampa, FL 07/2008-
08/2009
MIS/AML Analyst
. Responsible for regular reporting and documentation tasks as
well as participation in a variety of projects and technical
challenges in critical Anti-Money Laundering (AML) operations.
. Required to creatively work with business analysts, operations
and project management to assist in automating existing manual
reporting processes, daily documentations of all users and
workflow errors/corrections to maintain a record of all
standard operating procedures, building web based reporting
solutions dashboards using various databases. Helped designed
an automated database for overnight reporting to email for
team leaders through batch files. Worked with AML IT with
their Data Warehousing Unit to create UAT reports. Provide web
access through SharePoint uploads and documentation of ad-hoc
reports.
. Used the SDLC Methodology for business projects and a liaison
between the testing and development team. Processed daily
written and system documentation from all users on how to
implement training for new software. Gathered data from the
users to create a better standard operating system to develop
better efficiency and productivity for the users and
directors. Within a year increase production by 25%.
. Build reports from various databases: TOAD (Oracle), SSRS,
MANTAS, Oracle SQL Developer, Access, Excel, Sybase, BRIO,
Filemaker Pro, Syfact, SQL Server 2000/2005 (creating
databases and indexes) and Oracle (iSQL plus and T-SQL) and
Business Intelligence (BI).
. Being part of a team by utilizing strong PowerPoint, Visio and
Excel spreadsheet skills to demonstrate attention to detail
and time management for special report projects to improve
data quality, daily reports and create workflow system.
Utilize Filemaker PRO to send KYC memos to various team leads.
. Manipulated data files importing/exporting them into EXCEL and
ORACLE SQL Developer.
EDUCATION
DeVry University, Phoenix, AZ
07/1997-06/2001
Bachelors of Science
Computer Information Systems
Contact this candidate