R

Ray Erden  new_releases

About

Detail

Business Systems Analyst
Minnesota, United States
Contact Ray regarding: 
groups
Networking

Timeline

work
Job

Résumé

Jobs verified_user 0% verified
  • Wells Fargo
    Sr. Lead Analytics Consultant
    Wells Fargo
    Jun 2022 - Feb 2023 (9 months)
     Performed Teradata SQL analysis for customer complaint tickets for ECMO (Enterprise Complaint Management Office).  Prepared final documents to communicate the current status of customer complaints under the Sales Practices remediation program to ECMO and tracked their progress on JIRA.  Responded to CFPB (Consumer Financial Protection Bureau) requests for those customers whose cases were under the close scrutiny according to the Sales Practices remediation program.  Assisted team lead with tracking the pipeline and team member training and reviewing their work.  Provided advance data analysis services to identify populations for remediation efforts.
  • Att
    Solutions Engineer and Data Strategist
    Att
    Dec 2021 - May 2022 (6 months)
     Performed as a solution architect in data platform to deliver impact assessments for applications  Interacted with lead project managers, application owners/managers, developers to assess the level of complexity involved for required changes.  Communicated the findings to solution delivery teams to assist with assigning the proper resources to dedicate for projects.
  • Wells Fargo
    Data Resiliency Strategy Consultant
    Wells Fargo
    Mar 2021 - Dec 2021 (10 months)
    Remote Work in Data Backup and Segmented Recovery work stream of Enterprise Functions Technology. Identify mission critical applications with poor recovery performance to support the business continuity plans. Engage with the application owners for gap analysis on poor recovery times. Prepare recommendations and guidelines to enhance application recovery times after a data corruption incident. Work with the monitoring and detection teams to plan on identify and manage potential data corruption events. Work in fully agile environment, attend daily scrum calls and coordinate my work per the ongoing initiatives with the rest of the team.
  • Mercer
    Data Management Specialist
    Mercer
    Aug 2020 - Dec 2020 (5 months)
     Worked with HR benefit programs premium data files on behalf of the major carriers. Prepared outbound data file configuration for benefit program carriers via Oracle SQL.  Modified and wrote Oracle SQL scripts to develop carrier files per business requirements.  Worked with data integration specialists to ensure correct mapping for the outbound data files.
  • S
    Sr. Business System Consultant
    Feb 2020 - Aug 2020 (7 months)
     Create UAT test scripts to ensure data integrity and quality of data mapping and loading processes.  Write SQL statements against Teradata databases according to specifics identified in test cases.  Structure ALM (Application Lifecycle Management) application to manage team's testing efforts.  Work with ETL developers and business to grasp the big picture to design effective test routines.  Prepare BRD and FSD artifacts to communicate the requirements and functional specs to stakeholders about data structures and data flow among the database systems.  Support business continuity and disaster recovery data structures and testing.
  • U
    Sr. Business Systems Analyst
    UnitedHealth Group OptumHealth Technology
    Sep 2019 - Jan 2020 (5 months)
    Provided data profiling, source to target mapping and data analysis in agile environment. Attended daily scrum standup meetings and conducted ad hoc webex meetings with the project and business team members to gather business requirements Participated user story creation and feature grooming sessions for upcoming sprints. Communicated with the business to understand the reporting requirements to reflect in data mapping and profiling. Worked with very large data sets and complex data models supporting consumer engagement platform campaign process. Delivered data profiling document to development team after the business sign off and provided follow up support for any issues or questions..
  • Wells Fargo
    Data Analyst
    Wells Fargo
    Mar 2019 - Aug 2019 (6 months)
    Developed Excel based scheduling tool which facilitates business process testing activity planning. Built user friendly model office week-wise activity planning and tracker tool in Access. Generated reports from SQL Server database and posted to SharePoint for the audience to track status of each business process readiness status in conjunction with the testing activities. Assisted project managers who overview the scope activities within agile environment via weekly status reports that are used to support and track multiple teams' activities. Modified and improved Access training database which tracks required employee training activities and status in a suite of banking topics. Reviewed and improved the overall risk rating system which wa
  • B
    Business Systems and Information Analyst - Employee FT
    BASF Construction Systems
    Nov 2016 - Dec 2018 (2 years 2 months)
     Developed self-analytics reports for Finance, Sales, Product Management, Pricing, R&D and Customer Service departments.  Worked with SAP master data building queries to extract data sets feeding reporting processes.  Developed Access based business intelligence tool (BIT) for the daily view by a large audience.  Modified and added new functionalities for Access based pricing tool that generates price lists for each customer.
  • M
    Excel and Access Developer
    Minnesota Housing Finance Agency
    Feb 2015 - Nov 2015 (10 months)
    Supported business users with Excel and Access based reporting and tracking tools. Maintained VBA driven applications and modified tools for the changing business requirements. Worked with BA and PM to deliver custom solutions for the changing and new business requirements. Created process documentations and flow charts for the existing processes also for modified and new developments. Delivered customized tools for operations tracking and monitoring in Excel and Access. Contributed to new data structure initiative for more robust tracking and reporting systems.
  • Wells Fargo
    Business Systems Consultant
    Wells Fargo
    Apr 2014 - Sep 2014 (6 months)
     Worked with source data to Integrated Layer mapping in iHub common data platform  Participated business requirements, data quality, data profiling and data modeling meetings  Worked with Oracle tables using SQL Navigator for extractions  Compiled data from multiple sources in multiple formats  Worked with data conformance and governance
  • U
    Data Analyst
    UnitedHealth Group | Corporate IT | Solution Support and Services
    Sep 2013 - Mar 2014 (7 months)
    health rewards programs of the existing and new clients and completed data loads to Oracle tables per given requirements. Used data models and business rules and executed PL/SQL scripts accordingly to load tables per the requirements as depicted on decision guides. Executed SQL Server SSIS / ETL packages via Visual Studio in order to load Oracle 11 .g client tables in UAT and production environments. Coordinated unit testing and data validation efforts with the offshore team also fixed the assigned defects by the UAT testing team.
  • Prime Therapeutics
    Enterprise Process Analyst
    Prime Therapeutics
    Feb 2013 - May 2013 (4 months)
    Streamlined and enhanced fully automated performance quality metrics reports in Excel. Developed pivot table and VBA based toolkit to track discrepancies in multiple reports. Modified existing scorecards and dashboards via Excel macros and highly complex formulas. Applied enhancements to the existing Excel based toolkit that generates various automated reports. Reviewed the existing VBA code and made the requested modifications in several update routines. Developed new procedures for the existing metric reporting system to gain operational efficiencies. Supported the team with technical issues and worked together on the standard operating procedures (SOP). Provided general IT support to performance engineer of the reporting team.
  • Target
    Data Quality Analyst
    Target
    Oct 2012 - Dec 2012 (3 months)
    Responsible for the execution and improvement of data quality processes to ensure standards for relevant, high quality and accessible data are met and continually improved. Identified root cause issues and communicate data quality issues to business partners. Ensured that data is consistent, available, accurate and fit for reporting. Performed unit testing to ensure data quality against to Teradata using AQT tool to write SQL. Responsible for ensuring that the testing meets all functional requirements defined. Worked with the data governance teams to ensure data governance requirements and standards are met. Monitored data quality, define parameters for data integrity and compliance by performing data validation. Communicated quality metric
  • UnitedHealth Group
    Sr. Financial Analyst / Business Analyst - Employee FT
    UnitedHealth Group
    Dec 2007 - Jul 2012 (4 years 8 months)
    Prepared actionable reporting processes to update executive dashboards for the senior leadership team. Designed Excel based ETL processes to support the BI focused reporting processes. Delivered monthly metrics and KPI reports to track performance within the agreed upon deadlines. Built online navigation functionalities on SharePoint for the interactive utilization of performance metrics reports. Wrote VBA procedures in Excel to automate updates and to add customization to reporting processes. Created and automated Hyperion Essbase queries to obtain data from G/L in PeopleSoft into Excel. Put together various data integrity procedures to ensure accurate and efficient delivery of essential updates. Developed MS Access database applications f
  • G
    Performance Analyst - Employee FT
    GMAC Real Estate
    Oct 2005 - Nov 2007 (2 years 2 months)
    Assisted processes for the measurement, monitoring and analytics of servicer performance for retained risk position. Designed reports to measure key metrics and benchmarks of servicing performance. Verified accuracy of all data and performance results. Worked with internal/ external operating areas to explain results. Developed MS Access based tools for asset managers to monitor, analyze and report on their findings. Worked with various groups to coordinate reporting on the portfolio and collecting data attributes for measurement. Interacted with servicing partners on data feeds or data integrity issues. Acted as a liaison with IT for maintenance and development of systems and applications to create efficiencies. Identified pockets of the p
  • Express Scripts
    MS Access Database
    Express Scripts
    Sep 2005 - Oct 2005 (2 months)
    Prepared a reporting database for detective reporting in order to identify incorrectly invoiced rebate transactions. Worked with tables housing the total volume of 60 million transactions.
  • F
    Business Analyst
    FUJITSU AMERICA, TBA
    Mar 2005 - Jul 2005 (5 months)
    Project: Global Financial Systems Information Management – GFS IM TREX Enterprise Net flow Initiative. Deliverable : To determine total net cash flow into the company encompassing 10 different systems that feed one database called TREX for the entire company (AEFA). SQL statements to be prepared and ultimately to be submitted to SAS programming team to be incorporated into SAS routines. This tool was intended to be used as a gauge to measure the performance of all the financial advisors in the field in order to compensate them based on their net contribution to the company. Accomplishment: Using sample data for 2004 for each system, prepared SQL statements to get the new cash flow calculations in and out of the system per event as identifie
  • G
    Consultant - MS Excel/VBA Developer
    General Mills – IS Supply Chain
    Jan 2005 - Mar 2005 (3 months)
     Developed an Excel based project management tool called Critical Path to be utilized online by 1000 plus users to monitor a new product launch process via Windows SharePoint on the corporate intranet.
  • Life Time Fitness
    Independent Consultant - Excel/VBA Developer
    Life Time Fitness
    Dec 2004
    Developed an application working between MS Outlook and MS Excel facilitating individualized emails to 8,000 users from one data source.
  • G
    Information Specialist & Master Data Analyst
    General Mills | International Export Division
    Mar 2004 - Oct 2004 (8 months)
    Provided technical and analytical support for International Export Supply Chain division through the creation and implementation of user developed databases and/or reports using MS Access. Created, maintain and request master data records stored and processed in SAP R/3. Leveraged data tools primarily MS Excel 2000 extensively including VBA macros to analyze SAP and legacy systems data to assure compliance with business processes and a high level of data quality.  Designed and maintained department web content utilizing Microsoft FrontPage 2000 and utilizing MS Share Point in conjunction with this web site to facilitate pulling online documents with ease for customer service reps and managers.
  • Wells Fargo Home Mortgage
    Operations Data Analyst / Contract
    Wells Fargo Home Mortgage
    Oct 2003 - Jan 2004 (4 months)
    1 year 5 months Operations Data Analyst / Contract October 2003 - January 2004 (4 months) Minneapolis, MN Maintained, modified and improved MS Access database to support compliance teams for daily testing on sampled closed loans for data integrity and accuracy
  • M
    Analyst / Contract
    Mortgage Closing
    Sep 2002 - Sep 2003 (1 year 1 month)
    Performed as a Subject Matter Expert in the mortgage closing area providing assistance to new team members Worked on the mainframe based LPS (Loan Processing System) Provided customer service for the approved mortgage loans primarily for refinances Coordinated the mortgage closing between the customer and the closing agent
  • U
    Reporting Analyst/ Contract
    US Bank Corporate Trust Center
    Feb 2002 - Jun 2002 (5 months)
    Provided spreadsheet support for ad hoc data analysis requests in Excel. Developed MS Excel based tool to assist the process of reporting remaining eligible funds to appropriate states
  • U
    Product Analyst - Employee FT
    US Bank, Insurance and Investment Services
    Jan 1999 - Jan 2000 (1 year 1 month)
     Maintained and improved payment protection sales tracking database in MS Access 97  Designed SQL procedures to pay sales commissions for participating bankers  Provided weekly standard and ad hoc reports for end users showing weekly sales
  • Wells Fargo
    Sr. Business System Consultant
    Wells Fargo