AWILDA RIOS CRUZ
Altamonte Springs,FL
Summary
To achieve a position of a BI Developer in a highly challenging environment where I can work to the best of my knowledge and skills.
Knowledge and experience with the following: Monarch, FoxPro, Microsoft Office, Lotus, Peachtree, Quicken, QuickBooks, Crystal Report 8.5, 9.0,11, Business Objects, R&R Report Writer, Metavante datawarehouse (Oracle based), UltiPro, GoldMine, OnBase, PayPlus, MortgageWare, MartketLink, EAS, SSRS, SSAS, SSIS, PeopleSoft BI Publisher, PeopleSoft Pagelet, PeopleSoft Pivot Grid, PeopleSoft SQR, PeopleSoft Application Engine, SQL developer, Power BI, Oracle database Highly motivated; work well independently and as part of a team. Excellent interpersonal skills, able to relate well with people from diverse background and cultures. Strong analytical and problem solving skills. Motivated self-starter. Ability to handle pressure, exhibit sound judgment, and communicate decisions clearly. Well organized and detail oriented. Fluent in Spanish: written and verbal skills.
Overview
27
27
years of professional experience
Work History
ERP IT Analyst Reporting Sr
AdventHealth System
02.2013 - Current
- PaTranslated business requirements (Functional Specification) into Technical Specification for Finance, Supply Chain and HCM and Workforce
- Proficient on PeopleSoft reporting tools
- Developed, deployed and maintained PeopleSoft reports using BI Publisher, PS Query, Pivot Grid, and Pagelets
- Proficient on PeopleSoft tools – Application Designer; created SQL tables, views, and projects to be deployed
- Used Oracle SQL developer to query databases to validate data, create and test views, ad-hoc queries to export data to excel
- Created PeopleSoft Account Payable Operational Dashboards
- Developed and support Workforce reports (Crystal Reports)
- Build data models and develop dashboards using Power BI desktop
- Use advance level calculations on the data set using DAX functions in Power BI
- Converted HR PS BI publisher report to Power BI
- Converted Qlik Finance dashboard to Power BI
- Customized PeopleSoft delivered reports with company reporting standards (logo, header and footer)
- Worked directly with users to test reports
- Performed Technical Specification Peer review for other developer projects
- Adopt best practices in reporting and analysis, data integrity, test design, analysis, validation, and documentation
- Respond and resolve tickets and issues submitted by users
Financial Systems Developer/Data Analyst
Universal American
07.2010 - 02.2013
- Maintained day to day operations of Corporate Financial Systems including General Ledger, Accounts Payable and Corporate Reporting
- Designed, developed and modified Stored Procedures, Views, and SSIS Packages
- Designed, developed SSIS packages to Transfer /Import data From/To EAS finance software on a daily or monthly basis
- Designed, developed SSIS packages for a new Finance ODS, created Dims and Facts tables
- Designed, implemented and modified Crystal Reports, including sub-report, formulas, cross-tabs, graphs, drilldowns and running totals
- Convert Crystal Report to SSRS
- Developed, modified and maintenance of Access databases
- Developed and modified project documentation as required
- Developed and executed integrated test plans
- Upgraded SunGard Financial System EAS
- Performed Application and Database upgrade
- Created Ad-hoc data extract for business users, IRS and Auditors
- Provided after-hours production support on a rotating, on-call basis
Project Analyst
PRC
02.2005 - 05.2010
- List merging and purging, and reporting on numerous client databases
- Project management, data conversion, data administration, troubleshooting and reporting
- Combine data from various data sources as required
- Collect and analyze data; deliver reports to internal staff
- Produces reports on Access and Crystal Reports that are aesthetically pleasing and easily understood
- Access and SQL Database maintenance and associated tasks
- Interaction with account managers, project managers and clients
- Create VBA functions and sub routines
- Correctly modify existing VBA code and Access queries
- Produce detailed project documentation
Programmer/Database Analyst
City National Bank of Florida
01.2000 - 07.2004
- Lead database programming and administration
- Responsible for the Analysis and Implementation of several Systems
- Major Activities include database design, maintenance, installation, data mining scripting, SQL Stored Procedures, DTS, Crystal Report writing
- Responsible for the implementation of the BSA (Bank Secrecy Act) system
- Performed BSA application analysis, created a temporary data warehouse to keep track of transactions to comply with the Patriots Act and BSA, created data dictionary for the Imports, created database, stored procedures, DTS, Jobs Schedules and documentation
- Defined structure of data sources for reporting using the datawarehouse
- Active participation in OnBase upgrade, planning and database migration to the new SQL server
- Provided the analysis and led the implementation of Goldmine application
- Provided many customs reports and database updates
- Created the stored procedures and report interface for several applications
- Participated in the conversion to the Xtria tickler system and provided logistical support to the lending and credit departments
- Online Banking Conversion
- Created all reports to analyze and clean up the data
- Created all verification reports and performed data conversion
- Convert Access applications to MS-SQL
- Designed and implemented E-partner/ACH Access database for Online Banking Department
- Provided extensive support during RPL conversion providing all database comparison and creating new report modules for the application
- Built data mining scripts to produce financial analysis report required by executive management to monitor Loan Officers performance
- Performed all upgrades system maintenance, application and database administration for the Payroll application (UltiPro) and Cognos
- Provided SQL databases and support for the conversion of Payroll system to an inter-sourcing model
- Designed and implemented SQL database to create monthly reports for monitoring the loan portfolio conforming to the OCC recommendations
- Performed Paragon conversion
- Developed SQL database to process the ACH Returns
- Redesigned and convert reports from R&R report writer to Crystal Report 8.5
- Create and Modify Visual Basic code
- Designed several Crystal Reports for the different departments of the Bank
Information Systems Specialist
Banco Popular of Puerto Rico
04.1998 - 03.2000
- Developed and implemented access databases and interfaces between programs
- Provided maintenance and modifications to access database and programs
- Provided specialized training and support in programs to end users
- Act as a trouble-shooter for a variety of systems and software problems
- Upgraded and installed existing and new software
- Created and customized reports utilizing Crystal Reports and IBM AS 400
Education
Power BI Training -
12.2021
PeopleSoft SQR Rel 8.50 -
Oracle Certificates
04.2013
PeopleSoft Query/XMLP Power Combo Rel 8.50 -
Oracle Certificates
02.2013
M20723: Programming a SQL Server 2000 Database -
Productivity Point International
05.2002
Total HTML -
Productivity Point International
04.2002
Crystal Report 8.0 Advance -
Productivity Point International
01.2001
Visual Basic I, II and III -
University of Miami (School of Continuing Studies)
09.2000
Crystal Report Intro 7.0 -
Seagate Software Training
01.1999
Bachelor of Business Administration - Management Information Systems
Interamerican University
Cupey, P.R05.1997
Skills
- SQL
- Oracle database
- Peoplesoft
- MS SQL server
- Crystal Reports
- Power BI
- Cognos Analytics
Education/certifications
- Interamerican University, Cupey P.R, Bachelor of Business Administration, Management Information Systems, 05/01/97
- Seagate Software Training, Crystal Report Intro 7.0, 01/01/99
- University of Miami (School of Continuing Studies), Visual Basic I, II and III, 09/01/00
- Productivity Point International, Crystal Report 8.0 Advance, 01/01/01, Total HTML, 04/01/02, M20723: Programming a SQL Server 2000 Database, 05/01/02, M2072 Administering a Microsoft SQL Server 2000 Database, 05/01/02
- Oracle Certificates, PeopleSoft Query/XMLP Power Combo Rel 8.50, 02/01/13, PeopleSoft SQR Rel 8.50, 04/01/13, Oracle BI11g Create Analyses and Dashboards
- Qlikview Training, 2017
- Power BI Foundations + Power Query + Governance training -12/2021
Timeline
ERP IT Analyst Reporting Sr
AdventHealth System
02.2013 - Current
Financial Systems Developer/Data Analyst
Universal American
07.2010 - 02.2013
Project Analyst
PRC
02.2005 - 05.2010
Programmer/Database Analyst
City National Bank of Florida
01.2000 - 07.2004
Information Systems Specialist
Banco Popular of Puerto Rico
04.1998 - 03.2000
PeopleSoft SQR Rel 8.50 -
Oracle Certificates
PeopleSoft Query/XMLP Power Combo Rel 8.50 -
Oracle Certificates
M20723: Programming a SQL Server 2000 Database -
Productivity Point International
Total HTML -
Productivity Point International
Crystal Report 8.0 Advance -
Productivity Point International
Visual Basic I, II and III -
University of Miami (School of Continuing Studies)
Crystal Report Intro 7.0 -
Seagate Software Training
Bachelor of Business Administration - Management Information Systems
Interamerican University
Power BI Training -
Similar Profiles
Jadirys Acevedo ReyesJadirys Acevedo Reyes
PACU Charge Nurse at AdventHealth SystemPACU Charge Nurse at AdventHealth System
Twanetta KingTwanetta King
Manager of IT Services at AdventHealth Zephyrhills, AdventHealth Dade City, AdventHealth Connerton, and OSED Meadow Pointe ED Wesley ChapelManager of IT Services at AdventHealth Zephyrhills, AdventHealth Dade City, AdventHealth Connerton, and OSED Meadow Pointe ED Wesley Chapel
Angela HamblinAngela Hamblin
Registered Nurse, Operating Room Circulator/Ortho-Med Surg at AdventHealthRegistered Nurse, Operating Room Circulator/Ortho-Med Surg at AdventHealth