We provide IT Staff Augmentation Services!

Bi Architect Resume

MI

SUMMARY:

  • Business Intelligence Analyst offering experience delivering cost - effective, high-performance technology solutions to meet shifting organizational demands.
  • Astute technology-business professional translates operational needs into technical solutions.
  • Mastery of analytics and reporting tools to provide insights in product design, flows and user experiences using data-driven philosophy.
  • Nineteen years of IT experience in Developing solutions for Data Requirements using Oracle Database/PDW/SQLServer/SSAS Tabular Models, Azure and BI Reporting Systems
  • Functional experience includes Confidential, Finance, Manufacturing, Energy and Telecom
  • Worked on Design and development of reports/Dashboards BI tools Power BI & MicroStrategy
  • Business Data warehousing experience in Data Modeling, Design, and Development mainly focusing on Implementing Business Intelligence.
  • Lead small to medium sized teams, executing projects through various stages of project life cycle.

SKILL:

  • Power BI
  • MicroStrategy 10/11
  • SQL Server, SSIS, SSAS
  • Azure Datawarehouse/Synapse, Azure Analysis Services, Azure SQL
  • Azure Data Factory
  • Oracle DB, Oracle PLSQL
  • HTML, Javascript, PHP

EXPERIENCE:

BI Architect

Confidential, MI

Responsibilities:

  • Gathered and documented business requirements for analytical reports.
  • Participated in requirements meetings and Data mapping sessions to understand business needs.
  • Identified and documented detailed business needs.
  • Designed and developed Schema Models.
  • Worked on Reports, Dashboards, slicers and Filters in Power BI Desktop.
  • Developed complex calculated Measures using Data Analysis Expression Language (DAX).
  • Configured Gateways and DB connections to Power BI.
  • Also integrated VSTS, SharePoint and Azure to power BI.
  • Worked on Power BI Premium environment and in implementing premium features like incremental Refresh in the Reports/Datasets as a part of Performance Tuning initiative in Production Environment.
  • Upgraded the Workspaces from Classic to New Workspace.
  • Embedded Power BI Reports to Microsoft Teams and SharePoint.
  • Worked on creating the Gateway and mapping datasets to Gateways.
  • Worked on design and development of SSAS Tabular Models.
  • Created DAX measures Confidential SSAS end where PBI source is SSAS.
  • Worked with Microsoft team on Product Limitations and communicated limitations and tool capabilities to business stakeholders.
  • Architect and implement ETL and data movement solutions using Azure Data Factory by creating Data Pipelines/ Using Copy Data.
  • Migrated SSRS Reports to Power BI.

Technologies Used: Power BI, SQL Server, Azure Data Factory, Azure SQL Data Warehouse/Azure Synapse, SAP HANA BW, Microsoft DevOps (VSTS).

BI Architect

Confidential, WI

Responsibilities:

  • Gathered and documented business requirements for analytical reports.
  • Participated in requirements meetings and Data mapping sessions to understand business needs.
  • Identified and documented detailed business needs.
  • Designed and developed Schema Models.
  • Developed and Integrated Custom Visuals based on business requirements using Power BI.
  • Worked on custom visuals imported from market place like Chiclet Slicer, Gantt chart, count down timer etc.
  • Worked on Reports, Dashboards, slicers and Filters in Power BI Desktop.
  • Developed complex calculated Measures using Data Analysis Expression Language (DAX).
  • Configured Gateways and DB connections to Power BI.
  • Also integrated VSTS, sharepoint and salesforce to power BI by connecting these tools from power BI.
  • Worked on Migration from PDW Database to Azure.
  • Worked with Microsoft team on Product Limitations and communicated limitations and tool capabilities to business stakeholders.
  • Involved in design and deployment of SSAS Tabular Models.
  • Worked on Azure SQL and SSAS for testing the source data in visualizations.
  • Involved in Design and testing of Azure Data Lake.
  • Embedded Power BI Reports on Ashley Align web page link.
  • Migrated Reports from Microstrategy/SSRS to Power BI.

Technologies Used: Power BI, Microsoft PDW Microsoft Parallel Data warehouse, SQL Server,Microstrategy, SSIS, Azure, MySQL, HTML, JavaScript, Microsoft DevOps (VSTS).

BI Architect

Confidential, NJ

Responsibilities:

  • Gathered functional and non-functional client requirements in order to optimize the design of BI deliverable s (reports, dashboards, alerts, visualizations).
  • Involved in Data Modelling and building of ETL's from source system to Data warehouse using Abinitio toolset.
  • Created several Custom tables, Views, and Aggregations for developing BI reports.
  • Worked on Designing Dashboards for Adjustments, General Financial reports like General Ledger, Balance Sheet, reconciliation trend report, Price verification of different financial products received from Product Processors.
  • Extensively worked with MicroStrategy desktop in creating attributes, facts, metrics, hierarchies, transformations, hierarchies, prompts to be used in generating reports according to the needs of business.
  • Developed Reports using Freeform SQL and Transaction Services.
  • Involved in creating Intelligent Cubes for the project.
  • Used Enterprise Manager to generate reports for Objects Analysis, Usage Analysis etc.
  • Involved in providing planning estimates of ETL & Reporting modules to Project Management system.
  • Mentoring and managing team of developers on site and Offshore.

Technologies Used: MicroStrategy 9, Oracle DB, MS Project, Informatica.

BI Architect

Confidential, NY

Responsibilities:

  • My Role is to lead these two initiatives, single point contact for issues raising in these projects and giving Technical solutions and road map for implementing solutions to the team members.
  • Extensively involved in data modeling to build Data warehouse and ETL Transformations.
  • Studied and modified the attributes, facts and hierarchies based on the requirements.
  • Designed and customized the reports in development and production to supply the business with improved flexibility and functionality.
  • Created complex metrics with different level dimensionality, condition and transformations for user and business specific reporting needs.
  • Used Administrator tools like object Manager to move the objects from one environment to another environment.
  • Worked with MicroStrategy Enterprise Manager Tool for generation list of regular and Adhoc reports, Users etc.
  • Created Report Services Documents, Dashboards and Visual insights out of existing datasets.
  • Designed various prototypes of dashboards using MicroStrategy, which would give ability to the users to drilldown to claim (lowest) level.
  • Supported various testing phases like Performance Testing and UAT.
  • Created Ad-hoc reports by gathering specific requirements from the different users and enabled end-users to generate their own reports.
  • Migration of Reports from Confidential to LIPA.

Technologies Used: MicroStrategy 9, Oracle DB, MS Project, Informatica.

BI Architect

Confidential, Las Vegas, NV

Responsibilities:

  • Review of the deliverables for project N V Energy which is a part of the Energy Group.
  • Business and technical consulting and Support for queries on BI application.
  • Lead a Team of 12 Developers by giving them Technical inputs/expertise for various sub-projects in NV-Energy Group.
  • Requirements based solutions designing of MicroStrategy reports related to Phase 2 and developing the same.
  • Understanding business requirements and converting them into technical specification and design document.
  • Support for power user reporting as required by business.
  • System integration i.e., support in completing activities which includes EWAM BI related changes.
  • Coordination with business units for requirements, solutions, testing and .
  • Contribution towards solution and technical design.
  • Performance Tuning of MSTR Reports.

Technologies Used: MicroStrategy 9, Oracle DB, MS Project, Informatica.

BI Consultant

Confidential

Responsibilities:

  • My Responsibilities/Contributions in this Project are:.
  • Requirements Gathering.
  • Data Modeling and Analysis.
  • Schema Objects Development.
  • Presentation of the Dashboards to the stakeholders.
  • Issue Resolution and Proactive Solutions to the issues.
  • Preparation of Dashboards with Transitions for Web and IPad/IPhone.

BI Consultant

Confidential

Responsibilities:

  • Responsibility: My Responsibilities are.
  • Requirements Gathering.
  • Lead the Development team.
  • Prepare Symantec Layer.
  • Help Team in Developing the Public Objects, Reports & Dashboards.

BI Architect

Confidential, Bothell, WA

Responsibilities:

  • As a part of Team my responsibilities were as follows:
  • Performed customer requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations.
  • Extensively worked in creating and integrating MicroStrategy Reports and objects (Attributes, Filters, Metrics, Facts, Prompts and Consolidation & Custom Groups) with the data warehouse.
  • Extensively worked with MicroStrategy Desktop including MicroStrategy Architect and MicroStrategy Web.
  • Attended to Troubleshooting of MicroStrategy prompt, Filter & Template objects in an enterprise data warehouse team environment.
  • Developed Flash Dashboards using Widgets and Selectors for summary level reporting.
  • Involved in Development of PL/SQL packages & objects in Confidential OLTP Database to push the data to Confidential Reporting Staging Environment.
  • Query tuning and Database Health check Reports for Confidential and X datawarehouse for primary analysis.
  • Responsible for providing Data to X Datawarehouse for Reporting purposes.
  • Preparation of Release wise Development and Test Databases for X Datawarehouse.
  • Involved in Schema and Table Design.
  • Implementation and Post production support of Confidential Reporting project.

Environment: PL/SQL, Oracle 10g, Designer 2000, UNIX Env, MicroStrategy 9.0.2/8.1.2 , Informatica 8.1, JavaScript, HTML, JSP.

Hire Now