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

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.