SUMMARY

• 13+ Years of Experience in the information technology, Expertise in the Development, Enhancements, Supplemental and Administration using, Power BI, Tableau, Cognos, MSBI(SSRS, SSAS, SSIS) Tools.
• Managed AWS and Azure cloud technologies for distributed environments.
• Creation of advanced and custom visualization like heat - maps etc. Developing, maintaining
• Worked on the Power BI Reports & Dashboards using multiple sources.
• Developed paginated Reports using Power BI Report Builder.
• Supporting operational reports, dashboards, and scorecards using Microsoft Power BI.
• Able to creatively stretch the capability of Tableau to customize and develop creatively stunning and dynamic visualization using Tableau and Power BI.
• Good hands-on experience in Power BI Enterprise gateway, Power BI cloud publish/ sharing.
• Deep, technical knowledge of both Tableau Desktop and Tableau Server from an administrative and consultative standpoint
• Designed, developed, and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets. Implemented
• Consolidated data from different sources and stored in structured Data Warehouse.
• Experience developing SSAS tabular models, Scheduling of Power BI reports in online version.
• Worked on DAX expressions like filters, Aggregate, Mathematical Functions
• Created New Calculated Column and Measure using DAX Expression.
• Comfortable in working with filters/calculated columns/measures/relationships and transformations of Edit Query section.
• Worked with various versions in Tableau Desktop, Tableau Server.
• Worked dashboards in Power BI mobile version. Expertise in database concepts for data warehousing.
• Created Framework models and complex reports in cognos report studio.
• Designed as per the report requirement.
• Well versed in working with RDBMS like Oracle & SQL Server.

TECHNICAL SKILLS

BI Tools: PowerBI, Report Builder, Cognos, MSBI (SSAS/SSRS/SSIS)Tableau, Logi Analytics

Databases: Snowflake, Oracle, Sql server, GCP Big Query

Operating System: Windows, LINUX.

Cloud Technologies: AWS, Azure

Versioning Tools: GIT, Bitbucket

Ticket/Documentation Tools: Azure Devops, JIRA, Confluence

PROFESSIONAL EXPERIENCE

Confidential, Dearborn, Michigan

MSBI Lead Developer

Responsibilities:

• Involved in Requirement gathering, analysis and implementations using BI Solutions.
• Developed Reports using Table and Matrix visuals and Chart Visuals.
• Creating multiple kinds of Power BI Reports.
• Developing, maintaining reports using Microsoft Power BI.
• Migrated reports from Cognos to Power BI.
• Created Complex calculations using DAX functionality.
• Created data sets based on requirements.
• Publishing Reports to Workspaces in Power BI Service.
• Expertise in Excel, Power BI, and Experience in driving features.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Performed incremental refresh for datasets and schedule refresh.
• Worked on transform tab and created advanced DAX functions.
• Used Bookmarks and crated views to switch data.
• Developed Power Apps based on user requests.
• Created gateway connections in power bi Service.
• Created Workspaces and published the reports to the workspaces.
• Created Dashboards based on business requirement.
• Developed paginated reports using Power Bi Report Builder.
• Performed Unit Testing and data validations.

Environment: PowerBI, Report Builder, Cognos, Snowflake, Sql Server and GCP Big Query.

Confidential, Denver CO

Team Lead

Responsibilities:

• Involved in understanding the business requirements and document specifications.
• Getting data from different sources, extraction, transform and shape the data using Power BI.
• Query and then load the data into data modeling.
• Creating the Measures according to the business logic in Power BI Desktop using DAX.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Creating multiple kinds of Power BI Reports and Dashboards for the given requirement.
• Creating reports in Power BI desktop, deploy those reports on the cloud and define.
• Created Cubes using SSAS.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services(SSRS).
• Extensively created Calculated Measures, Custom columns using Power BI Desktop to generate reports for Business analysis. cards, Combo charts, Donut charts, Gauge charts, KPIs, Line charts, Matrix, Scatter an
• Bubble charts, Tables, Tree Maps, Waterfall charts.
• Created reports published into Power BI service.
• Worked on creating Dashboards by pinning visuals of the reports.
• Worked on creating Organization Content Packs.
• Shared the Dashboards through Power BI service to clients.

Environment: PowerBI, SSAS, Cognos, Sql Server, Azure.

Confidential

Team Lead

Responsibilities:

• Involved in understanding the business requirements and document specifications.
• Getting data from different sources, extraction, transform and shape the data using Power
• Query and then load the data into data modeling.
• Creating the Measures according to the business logic in Power BI Desktop using Data analysis expressions (DAX).
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Creating multiple kinds of Power BI Reports and Dashboards for the given requirement.
• Creating reports in Power BI desktop, deploy those reports on the cloud and define.
• Created Cubes using SSAS.
• Access control on the dashboards created using the reports.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services(SSRS).
• Extensively created Calculated Measures, Custom columns using Power BI Desktop to generate reports for Business analysis.
• Designed and implemented Drill Maps to access more detailed or supplemental Information by drilling up, drilling down, within and across dimensions.
• Created Reports using Various Visualizations like Bar and column charts, Single number cards, Combo charts, Donut charts, Gauge charts, KPIs, Line charts, Matrix, Scatter and
• Bubble charts, Tables, Tree Maps, Waterfall charts.
• Created reports published into Power BI service.
• Worked on creating Dashboards by pinning visuals of the reports.
• Worked on creating Organization Content Packs.
• Shared the Dashboards through Power BI service to clients.

Environment: Power BI, SSAS, Cognos, Sql Server, Azure.

Confidential

Team Lead

Responsibilities:

• Involved in gathering the requirements and analyze requirements specification for the reports.
• Experience in Customer Handling, Good Exposure on Policy and Billing systems.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Established Best Practices for Enterprise Table Environment and application intake and development Process.
• Tableau Administration Tool for configuration, adding users, managing licenses and data connections, scheduling task.
• Involved in creation of Framework model.
• Developing reports with Cognos 10 report studio.
• Created report design documents.
• Creation of Calculated Prompts and Filters for usage in various Reports.
• Creation of Dashboards and map reports.
• Created schedules and Tasks to refresh the workbooks and data sources in Tableau
• Created sites, projects, Application roles and users in Tableau Server.

Environment: Cognos, Tableau, Oracle.

Confidential, CA

BI Developer

Responsibilities:

• Created framework manager model as per the requirement.
• Worked with parameter maps and session parameters.
• Involved in creating the model in the framework manager using the target.
• Created filters, calculations in the model by using framework manager.
• Updated& published the package according to the business requirements.
• Created packages in framework manager.
• Created complex reports in report studio.
• Design various types of reports according to end user requirements.
• Created reports with Prompts, filters and multi queries.
• Design reports with detailed filter and summary filter.
• Created drill through reports with different parameters and associated with the summary reports to get details. Also used java scripts for prompts.
• Scheduling and Administering Cognos8 reports.
• Applied data level Security based on User requirements.
• Involved in design reports with Cascading prompt.
• Created drill through reports with different parameters and associated with the summary reports to get details and Performed Unit testing.
• Involved in scheduling reports using Schedule Management in Cognos Connection.
• Creating user groups in access manager and LDAP
• Creating the data sources in all environments
• Scheduling the job/Report based on user requests.
• Maintenance of cognos servers.
• Creation of user groups in ldap and Access Manager.
• Upgrading the Cognos application from lower version to higher version
• Restarting the cognos servers
• Providing the access to users based on request.
• Migrating the packages across the environments.
• Resolving application development issues.
• User maintenance in ldap and cognos Access Manager
• Refreshing power cubes.

Environment: Cognos8, Transformer, Reportnet, Oracle.