We provide IT Staff Augmentation Services!

Sr Bi/data Engineer Resume

Amarillo, TX

SUMMARY

  • Accomplished International manager/analyst with 33 years IT experience which includes 15 years in Banking and Financial services, 8 years in Transportation and Logistics, 6 years in Heavy Industrial, Construction and Maintenance and 4 years in Security and Operations; concentration primarily in the BI Ecosystem with data warehousing, analytics, and reporting. Supporting all levels of management.
  • Extensive experience as a solution architect for business intelligence information systems, focusing on database architecture, modeling, analysis, and application integration.
  • Experience in management of BI and analytics/reporting teams involved in Risk Management, Commercial and Consumer Lending.
  • Experience in Portfolio Management, Forecasting, Non - Performing Asset management, and Loan Servicing.
  • Proficient with multiple reporting, dashboarding and data discovery tools (IBM Cognos, Power BI, SAP Business Objects, SAS).
  • Effective leadership skills: coaching, teaching, advising, and helping others in developing their skills and abilities.
  • Assertive, Diplomatic, Confident, and Successful.
  • Strong communication, reasoning and relationship management skills.

TECHNICAL SKILLS

  • Business Intelligence
  • (SSIS, SSRS, SSAS)
  • SQL Server 2016
  • Cognos Analytics (11.1.7)
  • Cognos Framework Manager
  • IBM DB2 w/Blu
  • Power BI
  • SAS Analytics
  • Oracle 10g
  • SAP BODS 4.3
  • Visual Studio 2015
  • AS/400
  • Attunity

PROFESSIONAL EXPERIENCE

Confidential, Amarillo, TX

Sr BI/Data Engineer

Responsibilities:

  • Cognos & Power BI Administrator of the BI ecosystem which includes IBM Cognos BI Suite, Power BI On Prem and Cloud Service.
  • Maintain a stable Production environment for Cognos BI as well as administering and maintaining QA and Dev environments.
  • Planning, testing, scheduling and implementing fix packs and administering security, and backup procedures.
  • Use Motio CI and MotioPI Pro for admin and maintenance of Cognos environments as well as promoting updates, reports and dashboards between environments.
  • Experience with framework manager, reports and dashboard development using Cognos Analytics and Power BI.
  • Upgraded Cognos environments from 10.2.2 to 11.1.7. Currently testing Cognos Analytics 11.2
  • BI Lead for project meetings and stakeholder, developer of solution designs and documentation of projects.
  • Currently developing a BI Strategy to deliver improved data integrity while providing clean and consistent data quality.
  • Maintain current vendor relationships, assist with new vendor selection process and manage vendor priorities throughout assigned projects.
  • Created policies and procedures as well as documentation for the BI ecosystem.
  • Manage server migrations, software upgrades, data migration and reports migration within the BI ecosystem.
  • Remain current on BI Best Practices and apply those practices as appropriate.
  • Developed training materials for BI applications, coach and train team members and employees as needed.

Confidential, Baton Rouge, LA

BI Data Warehouse Architect

Responsibilities:

  • Cognos Administrator of the BI ecosystem which includes IBM Cognos BI Suite, Power BI On Prem and SAP BODS 4.3.
  • Data Cleansing, Data Profiling and Data Migration using SAP BODS 4.3.
  • Managed team of 4 Consultants through reporting conversion for a DW Upgrade (Cognos 10.2.2).
  • Complete SDLC including analysis, design, enhancement, testing and production support of data warehouse/data mart (SAP BODS 4.3).
  • Designed and Implemented the staging tables for source to target mapping of the ETL process using (Attunity, SAP BODS 4.3).
  • Created new data models based on user requirements and maintained/updated existing data models (Cognos Framework Manager).
  • Built offsite BC/DR for BI Data Warehouse. Created and maintained the documentation for BC/DR process and failover procedures.
  • Worked in a Waterfall/Agile (WAgile) project team using a hybrid approach.
  • DBA of SQL Server 2012 Cluster and IBM DB2 w/BLU.

Confidential, Atlanta, GA

Quantitative Analyst

Responsibilities:

  • Supported Retail Risk, Commercial Risk and Wealth Management on a broad range of analytics, reporting and ad-hoc requests (SAS & TM1).
  • Engaged in independent and collaborative efforts throughout the entire data analytics lifecycle from data discovery, to modeling, to project completion (SAS).
  • Reviewed and Updated Consumer Credit Retail Policies annually (SAS).
  • Performed profitability studies on existing and acquired portfolios (SAS).
  • Gathered data requirements on a scheduled basis for use with Credit Risk for CFO Earning’s Calls, Investor presentations and SEC 10Q/10K reporting, along with Stress Testing efforts (SAS).

Confidential, Atlanta, GA

Vice President, Consumer and Mortgage Report Production Manager

Responsibilities:

  • Managed the development of reporting and analysis for Mortgage and Consumer portfolios of approximately $64 billion (SAS & TM1).
  • SME working with consultants and business partners to build Asset Quality reporting decks to support Consumer and Mortgage LOB.
  • SME working with consultants and business partners to build Enterprise Data Warehouse to support ongoing reporting efforts, future reporting needs and ad hoc requirements for Corporate Risk Management as well as the Retail Consumer and Mortgage LOBs.
  • Worked with SVPs and EVPs to define ongoing reporting requirements, credit risk initiatives, and data systems projects.
  • Assisted in the preparation of financial statements for the company's monthly, quarterly, and annual reports. Including ALLL, External InvestorReporting, Moody’s, E&Y, along with SEC 10K, 10Q and Stress Testing report requirements (SAS).

Confidential, Birmingham, AL

Senior Business Systems Analyst

Responsibilities:

  • Participated in the planning and implementation of new projects, products, programs, and plans to achieve short and long-term business objectives.
  • Experience with BI, data integration, data warehousing and data conversion processes, techniques and/or tools
  • Designed logical and physical data models, interacted with non-technical end users to understand the business logics. Delivered Data Marts consisting of data extracts from internal and external sources (SAS).
  • Engaged in data profiling to integrate data from disparate sources (SAS).
  • Responsible for supporting the production reporting environment and solving issues in the timely manner (Cognos, Transformer).
  • Data migration of Direct Consumer and Indirect Auto data systems following the Regions/Union Planters merger in 2004 and Regions/AmSouth merger in 2006.
  • Developed and Delivered monthly and quarterly report decks using SAS, Crystal Reports, and Cognos.
  • Developed and delivered ad hoc reports to support senior level management and business customers (SAS, Crystal Reports, and Cognos).

Hire Now