ERNESTO RIOS
**** ************* ****** *******, ** 32809
H: 817-***-**** C: 817-***-****
ac8etw@r.postjobfree.com
SUMMARY:
Over 16 years of Mortgage Banking, Project Management, Business Analyst,, Systems Analyst, Business Intelligence and Technical Analyst Experience.
Demonstrated experience in Documenting, managing projects relating to corporate changes and initiatives that impact a major line of Business function. Managed compliance processes for Government Programs HUD & MHA Eligibility through Reporting and Governance Programs. Created Project Schedules for End to end planning, implementation, training and Production across the business, technology, and support function. Directed and managed overall project status, budget, Change controls and risk management. Established and maintained Project life cycle methodology to ensure that all work was defined, including Budget, Scope Management, Requirements, Quality assurance, and were effectively managed, documented and communicated.
TECHNICAL SKILLS:
MS Access, MS Office, Sharepoint, AS400 iSERIES, MS Visio, Data Modeling. Over 10 years of Managing Project design, Documentation, Database Development, Testing, Building, Deploying, Maintaining, monitoring, and backup activities, Archive. SQL DBA Management. SQL 2005, 2008, 2008 R2, 2012, 2014 using SQL Stored Procedures, Functions, Views, T-SQL and SSRS Reporting and some SSAS cube maintenance. OLAP Reporting. Activity Based Costing, Tableau 8 and Power BI Interface Reporting.
ACCOMPLISHMENTS:
Reduced annual operating costs in a major Line Of Business by $787K by implementing Six Sigma principles and earning a (FASTER GOLD-Six Sigma Black Belt) in 2005 and 2012.
Became a Business Intelligence Developer.
Became a SQL Database Administrator.
Documented and Standardized Processes as well as Process Improvement.
Migration of SQL Database Servers between companies during Acquisitions.
Subject Matter Expert and Develop Comprehensive Cross-Functional Flowcharts and Analysis as needed Trending Analysis, OLAP & KPI Metrics
PROFESSIONAL EXPERIENCE
Consultant- Ultimate Software 07/2018 to CURRENT
SQL Database Engineer
Process Flows, Documentation, Data Mapping and Business Requirements Gathering for Internal and External Stakeholder reporting.
Develop Code and Support CRM based reporting for Salesforce KPI's and Dashboard Reporting and their dependencies.
Consult on best Reporting Visualization for Power BI and Tableau.
Update Data Elements within Reporting and create new SSIS packages for New Reporting.
Troubleshoot Data gaps and Reporting Requirements.
Use TFS to manage and update Database Objects.
Create Stored Procedures for Scheduled Jobs.
Create Views for Operational Reporting.
Peer Review and Optimization of Best Coding Practices.
Develop Code For SQL-based Operational & Dashboard Reporting
Consultant-FIS Fidelity National Information Systems 01/2018 to 05/2018
SQL Database Admin & Developer II
Provided Metrics Reporting for CRM based software called CMS.
Added Data Object Relationships to Track Production KPI's in CMS as well as Scorecard Reporting. Develop Code For Operations & Dashboard Reporting Using Power BI
Trend Data for Power BI Graphical Visualization Reporting.
Documentation, Data Mapping and Standardization.
Maintain multiple SQL Database Environments.
Manage Replication, Publication and Subscriptions of Database Objects.
Create Stored Procedures for Scheduled Jobs.
Create Views for Operational Reporting.
Peer Review and Optimization of Best Coding Practices.
Consultant-Disney Corp 03/2017 to 05/2017
Technical Analyst
Documentation and Business Requirements Gathering For Parks and Resorts.
Engage Business and Host Meetings to Develop Business Rules for Reporting Metrics and Standards.
Develop Project Schedule and Process Flows for Visualization, Set expectation of Milestones and Timelines.
Trend and Forecasting Report Data Using Power BI Graphical Visualization.
Data Mapping and Creating Relationships between External Databases for Internal Data Migration.
Consultant-Axium Special Pharmacy (Kroger) 04/2016 to 12/2016
SQL Developer-BI SQL Server, SSAS, SSIS, SSRS Lake Mary, FL
Develop Business Intelligence for CPR Application, Data Extracts For Specialty Pharmacy Client Aggregators, Referrals, and Shipments for Drug Manufacturers.
Develop Reporting For Operations Clinical Assessments, Forecasting and Dashboard Reporting.
Develop Documentation, Process Flows, Liaison and Consulting for Business Operations and Standardize processes for Technology and Business Teams. Schedule FTP tasks for data imports.
Write code, Stored Procedures T-SQL, Views, Functions, DTS Packages using Business Requirements Documentation and updates.
Migrated Stored Procedures, SSIS’s and dependencies onto Axium Servers and Platforms to Kroger Platform compatibilities.
Bank of America 06/2012 to 3/2016
Officer, BI SQL Server, SSAS, SSIS, SSRS Project Analyst II Stuart, FL
Create Loan Boarding Reports, Service Release Reporting, Develop Code, & Program Report Automation using SQL, SSIS, SSRS Data Management Government Portfolio Reporting GNMA, FNMA, FHLMC, VA Project Mosaic & Federal Compliance Reporting ETL/Data Warehousing, Data Governance, Data Mining, and Production Forecasting.
Reporting For Service Releases Mortgage Portfolio. Reporting Requirements Documentation
Manage Quality Assurance, Quality Control and User Acceptance Testing.
Highly proficient in operating MS SQL Server 2012/2008 R2/2008 suite of products like SSIS, SSRS and SSAS.
Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse for developing accurate DTS packages, creating jobs and linked servers for MS SQL Server databases.
Proficient in Creating, Configuring and Optimizing MS SQL Server Integration Services (SSIS).
Internal & External Client Relationship Management.
Activity Based Costing & Cost Benefit Analysis Marketing for MHA Federal Programs.
Bank of America Tax Services 04/2009 to 05/2012
BI SQL Server, SSAS, SSIS, SSRS/ Operations Project Consultant Plano, TX
Manage Non-Impound Tax Portfolio to ensure penalties are not assessed Technology Liaison for Vendor Management
Produce Forecast Reporting
Conduct Quality Assurance and User Acceptance Testing
Develop Comprehensive Cross-Functional Flowcharts and Analysis as needed Trending Analysis,
Maintenance of Business Applications using SQL Server and Visual Studio tools.
Bank of America Portfolio Communications 08/2007 to 08/2008
Systems Analyst II / BI SQL Server, SSAS, SSIS, SSRS Fort Worth, TX
Conducted Portfolio Analysis
Responsible for Year End Statements Reconciliation
Project Management
Cost Benefit Analysis
Managed Production Operations Trending and Forecasting Conducted Quality Assurance.
Involved in designing new complex mappings and workflows.
Responsible for designing Stored Procedures. Writing complex queries and Triggers for data source validations.
Countrywide Bank 01/2005 to 06/2007
Recon Trust - Business Analyst Simi Valley, CA
Conducted daily reporting for Mortgage Servicing, Default and Foreclosure
Created and ran daily, weekly, monthly and quarterly production reports
Conducted some SQL code development and DTS packages Financial Reports.
Scorecard Reporting Trending Analysis, OLAP & KPI Reporting Ad-Hoc queries Prepared Strategic Planning Presentations Software and Database Development Facilitated and led meetings
Generated Production Reports. Trending and Forecasting
Conducted Security Audits, Quality Assurance Testing and Analysis.
SOX Compliance Testing.
Responsible for developing Policies & Procedures for Compliance and Business Unit Servicing
Troubleshooting of PC Software and Applications Faster Silver-Gold Certified - Six Sigma Black Belt Equivalency.
EDUCATION:
Completed Courses: Software Development
Los Angeles Pierce College-PACE; Simi Valley, CA
Quality Assurance
Software Development Life Cycle
Project Scheduling
Budgeting and Forecasting
SOX Compliance Standardization
HIPAA Compliance Standardization
FASTER Gold-Six Sigma Black Belt Equivalent
Analyst Resource University (2005)
Simi Valley, CA, 93065
Software Development Life Cycle
Process Improvement Analysis
Business Requirements Development
Functional Specifications
Data Analysis & Metrics Development
Scorecard Development
Cross-Functional Mapping & Analysis
Budgeting & Forecasting
Project Scheduling & Resource Management
Coursework in Business Communications and Management Information Systems
Managerial Statistics and Management Communication coursework
Course work in Information Technology
CERTIFICATIONS:
Bank Officer For Business Technology Compliance & Federal Compliance Standards
FASTER Gold Certified-Project Management/CPI -(Six Sigma Black Belt Equivalent)
MS SQL Server 2008 Reporting Services
MCSE Certification
Certified CA Notary Public CA- Loan Doc Signing Specialist
LANGUAGES: Bilingual English/Spanish; Fluent reading/writing Spanish