Business Intelligence Developer Resume

SUMMARY

Strong analytical, problem solving, collaboration and technical skills with demonstrated experience delivering world - class, enterprise BI solutions using Microsoft SQL 2012, 2016 Microsoft BI stack (SSIS, SSAS, SSRS).
Creating reports in reporting tools like SSRS, POWER BI, Qlik Analytics using SQL MDX and Analysis Services, SQL Server as a data source, Passing Parameters (MDX and regular) to drill down reports, Working with Charts/Gages (Multi Column datasets), Deploying Reports, and Administering Security.
Testing Reports by planning and executing functional tests. (Test Plan Documentation-Review-Update-Baseline-Testing Techniques)
Ability to manage, adjust and negotiate a schedule throughout a project, ensuring delivery goals and quality goals are simultaneously achieved.
Strong knowledge of Data Warehousing concepts and Dimensional Modeling.
Developed numerous ad-hoc queries and reports to collect and present information that satisfied clients and contributed to achieve organizational goals.
Organized meetings with stakeholders to gather business requirements, create task backlog, scope/size tasks, prioritize tasks and allocate BI resources.
Excellent teamwork and communication skills.

PROFESSIONAL EXPERIENCE

Business Intelligence Developer

Confidential

Responsibilities:

Design, develop, test, and deploy MS SQL Server Analysis Services (SSAS) tabular and multi-dimensional models.
Experienced in the SQL Server and services, SQL Server Analysis Services (SSAS) Analysis Services (Multidimensional and Tabular)
Analyzed financial data to identify relationship between operations and payment trends.
Accounts receivable payment and trend analysis presentation to management committee to recommend strategic plans to increase revenue.
Designed SSIS package that extract patient's data from a SQL Server Database by using Lookup task, Foreach Loop Container. Used the slowly changing dimension task and its accompanying wizard to load a new dimension.
Strong analytical, problem solving, collaboration and technical skills with demonstrated experience delivering enterprise BI solutions using Microsoft SQL 2012, SQL 2014 Microsoft BI stack ( SSIS, SSAS, SSRS ), POWER BI, Pyramid Analytic .
Created cubes, dimensions, and business critical KPIs using SSAS representing aggregations in different ways - hierarchically and using custom groupings, that the company will use to analyze performance. Created measures in MDX/DAX according to business requirements.
Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients.
Built different kind of reports using SSRS like parameterized reports, Ad hoc reports, Drilldown reports and Drill through report.
Implemented Business Intelligence dashboards using Microsoft POWER BI and self-service Excel Power view, Power pivot, Power BI producing different summary results based on user view and role membership.
Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Data modelling using Erwin and SQL Server Enterprise manager.
Developed detail and summary reports, line and pie charts, trend analysis reports, sub-reports, and MDX queries according to business requirements using SSRS.
Support interfaces with users and third-party vendors.
Support the design, planning, implementation, administration and maintenance of the business intelligence platform.

Jr. ETL Developer

Confidential

Responsibilities:

Worked closely with business analysts and gathered functional requirements. Designed technical design documents for ETL process.
Provide production support of existing ETL processes (SSIS packages)
Analysis, development, testing, deployment, maintenance and troubleshooting of ETL data processing scripts using SSIS/SQL. Work on support tickets, maintenance tasks and assigned projects at discretion of the Reporting Coordinator.
Created files, views, tables and data sets to support Sales Operations and Analytics team.
Provide accurate level of effort estimates for data integration development to management.
Designing and implementing databases, ETL routines, tabular cubes, performance tuning, automation and reporting in addition to providing support and enhancements to existing client solutions.
Modified and maintained SQL Server stored procedures, views, ad-hoc queries, Functions and SSIS packages.
Extensively worked on creating SSIS packages and have used for each Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
Define the physical table structures, including any modifications required to support business reporting requirements, the overall data model, ETL development and the data dictionary used to support standard and ad hoc BI reporting.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship