Sr. BI Developer Resume

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Sr. BI Developer

Confidential

Responsibilities:

Leading the definition, analysis, planning, development, testing, implementation, maintenance and documentation of innovative and cost - effective business intelligence solutions for company utilization.
Responsible for building, implementing and supporting Microsoft BI Solutions utilizing the Microsoft BI Stack 2016 (SSIS, SSRS, and SSAS).
Design data warehouses and data marts utilizing the Kimball Methodology to generate a logical and physical model for Star and Snowflake Schema.
Design and develop Power BI Solutions published to Office 365 via live links to SSAS Cubes through Power BI Gateway.
Support SAP Business Object environment and migration to Microsoft Platform.

Sr. BI Developer

Confidential

Responsibilities:

Responsible for building, implementing and supporting Microsoft BI Solutions utilizing the Microsoft BI Stack (SSIS, SSRS, and SSAS).
Develop BI solutions of GPS data in SQL Server utilizing the Kimball Methodology to generate the logical and physical model.
Collaborating with end users to identify needs and opportunities for improved data management and delivery.
Design and develop dashboards for various departments within the company based on requirements from CIO.

Sr. BI Developer

Confidential

Responsibilities:

Dimensional Modeling of Oracle data in SQL Server utilizing the Kimball Methodology to generate a logical and physical model.
Create SSIS Solution and test extraction, transformation, and load (ETL) processes that capture metadata and rules associated with ETL Staging and Data mart build with auditing for reporting.
Maintaining multiple database environments for development, user acceptance testing, and production.
Develop operational schedules, operational manuals and provide monitoring of Business Intelligence Solutions.

BI Lead Engineer

Confidential

Responsibilities:

Work closely with BI Director in leading the definition, analysis, planning, development, testing, implementation, maintenance and documentation of innovative and cost-effective business intelligence solutions for multiple applications and systems, utilizing information technology, business, and industry trends.
Create and test extraction, transformation, and load (ETL) processes that capture metadata and rules associated with ETL processes.
Develop operational schedules, operational manuals and provide monitoring of the ETL jobs Leads or participates in writing test plans to validate implementations against the requirements.
Work on large complex projects, which cross over multiple functions and meets with appropriate technical staff, end users, and senior management.
Design and develop BI Framework, Dashboards, Metric’s and Reports on the Cognos Platform and SSIS, SSAS utilizing Microsoft Solutions.

ETL Specialist

Confidential

Responsibilities:

Created ETL Packages and implement new data extracts, transformations, and load routines to populate the Data Warehouse utilizing the Kimball Methodology to populate dimension and fact tables.
Documented SQL Server components, which consisted of, Databases, Analysis Services, Integration Services, and Reporting Services, while maintaining metadata catalog for dimensional and fact tables.
Developed business requirements documentation, based on the initial business request that included use cases, user interface specifications, and user functional requirements as defined by the business rules.
Designed the logical structure of the database to include tables and views based on user specifications, in order to support the development of ETL Packages. In addition to, utilizing hands-on TSQL to create complex queries and stored procedures and functions.