Post Job Free

Resume

Sign in

Data Project

Location:
Port St. Lucie, FL
Posted:
February 06, 2019

Contact this candidate

Resume:

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



Contact this candidate