Michael S. Arellanes

Email: ad38hq@r.postjobfree.com

Contact Phone: 832-***-****

Professional Summary: As an SAP developer with several years’ experience, I am highly skilled in designing, developing, and maintaining SAP BW solutions. I possess an in-depth knowledge of data modeling, ETL processes, and data warehousing. I have strong understanding of business processes and extensive experience in system integration.

American National Insurance Company

November 15, 2008, thru February 29,2024

League City Texas

SR. SAP BI ANALYST

Member of SAP project team implementing SAP FI. CO, and FSCD modules. Responsible for Blueprint process of gathering high level and detail design specifications.

Responsible for implementing SAP BW environment.

oDevelop and maintain SAP BW solutions for American National financial systems that include data modeling, extraction, data transformations data loading, ETL processes, BEX and Business Objects reporting.

oTrouble shooting SAP solutions, performance tuning, and organization.

oCollaborate with business users and SAP functional analysts to gather business requirements and design BW solutions that meet financial reporting needs.

Responsible for supporting a Microsoft SSIS project for the purpose of translating Legacy systems financial data feeds into a SAP FSCD format and data loading. Into SAP ECC

Responsible for providing backup support to SAP BPC support analyst.

oFamiliar with BPC Package & Package Link setup

oFamiliar with backend dimension updates, Master Data loads, etc.

ExxonMobil

May 2001 - Nov 2008

Houston Texas

Consultant – Contractor

oExxonMobil /GIS/BLA/SHE-GREF-TREAS Systems Analyst, (Jan 2007 - Nov 2008),

Development of C# .net and VB .net 2005 windows forms.

Initial transition of Database platforms from SQL 2000 to SQL 2005.

Development of SQL Server stored procedures, DTS packages, and batch processes.

Application Database Administration functions which include the following:

Database maintenance plans, Log Shipping, Full & Differential backups, Database object creation (Table, Views, Triggers, Procedures, Indexes, Constraints, Full Text Indexes)

SQL Optimization using SQL profiler & execution plans.

Development of interfaces to SAP HR and SAP Financial modules.

ExxonMobil /GIS/Global Projects (EMARC) Systems Analyst, (May 2004 - Dec 2006), on a Global Facilities Management

Data warehouse project. Primary responsibilities include the analysis of data migration plans and requirements, data mapping, development of automated tools and process, to convert multiple data sources from various types of system platforms into a common global data warehouse.

Additional responsibilities include implementation and maintenance of Web and Client server applications for end user to access the data warehouse.

This position requires extensive development with C# and VB .net 2003, DTS packages, SQL Server stored procedures, batch interfaces to SAP and other systems, test plans, and regularly interfacing with business clients and upper management.

oExxonMobil Pipeline Company

Visual Basic Developer / SQL Server Application DBA, (May 2001 - Apr 2004)

oExxonMobil Pipeline Revenue Accounting system development project. The Application DBA responsibilities included creation of data model, logical and physical database, as well as Database object management, backup & recovery, and security.

This position also required development of VB 6.0 Class Modules (COM Objects) & Forms, and SQL Server 2000 Stored procedures, and DTS Packages.

odatabase objects, SSIS and SSRS.

Skills: SAP BW Development 7.50, Sap Business Objects development with Crystal Reports, Microsoft SQL Server 2018 and prior versions, SSIS 2018, Stored procedures, VB.Net 17,

Education: Bachelor of Business Administration, Information Management – University of Albuquerque New Mexico

Contact this candidate