SUMMARY

• Pursued Masters in Computer Science, having 5 years of professional IT experience. Looking forward to solving the real problem by using known and learning modern technologies.
• Looking to apply with my technical skills towards the success of your company via the open POWER BI position.
• BI Reports Developer with an experience of over 5 years in the IT industry.
• Experience in dimensional data modeling, cube development and manipulations in SQL Server Analysis Services (SSAS).
• Skilled in publishing Power BI reports to Power BI Services and sharing them with other teams.
• The merit of contributing to the development and management of SSRS projects such as creating drill through reports through linked reports.
• Building BI applications in Microsoft platform using SQL Server, Power BI.
• Deliver interactive and high - performance Power BI dashboards for the business and data analysis requirements.
• Design Data Model and table relationships in Power BI.
• Creating Measures and calculating columns for the reports.
• Design report pages with different visuals such Bar chart, Column chart, Line chart, Area chart, Pie chart, Donut chart, Map, Gauge, Card, KPI, Slicer, Tables and Matrix.
• Interactive report design with bookmarks and drill through feathers.
• Setup Roles in Power BI for data-level security.
• Publishing reports to Power BI service and the creation of dashboards.
• Setting up data set security and data refresh schedules.
• Setup Power BI workspace and App for the users to view the dashboards from desktop, laptop, and smartphones, and tablets.
• Installing monthly updates for Power BI desktop.
• Proficient in the use of T-SQL for developing Stored Procedures, Tables, User Defined Functions, views, indexes, Relational Database models, Data integrity, query writing, SQL joins performance tuning and query optimization.
• Worked in OLTP and OLAP System Study, developing Database Schemas in relational and dimensional modeling.
• Created ad-hoc reports & data validations in Excel using pivot tables & Power pivot add-in.
• Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Teradata, Sybase, Flat File, and MS Access.
• Worked on SSIS, Data Cleansing and Data Migration.
• Creating, Configuring, Deploying, and Fine-tuning MS SQL Server Integration Service (SSIS) packages.
• Expert in Data Conversion, Normalization, and Data Modeling and involved in the creation of Fact Tables, Dimension Tables, Star Schema and Snowflake schema.
• Possess strong design, programming, debugging and analytical skills.

TECHNICAL SKILLS

Dashboard development: Microsoft Power BI, DAX, MDX

Data Visualizations Tools: Power BI, Power pivot, Tableau

Databases: SQL Server, IBM DB2

Data Warehousing: SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS)

Programming Languages: SQL, PL/SQL

Functional Area: Healthcare, Insurance & Financial

Operating Systems: Microsoft Windows

PROFESSIONAL EXPERIENCE

POWER BI Developer

Confidential, Columbus, OH

Responsibilities:

• Organized JRD meetings to gather business requirements from business users and SMEs.
• Designed the logical model with Erwin based on business requirements.
• Maintained data integrity with the creation of constraints and DML triggers.
• Wrote SQL queries and stored procedures to generate data for reports from various sources.
• Designed and deployed SSAS multi-dimension cubes used in analytic research and report generation. created a multitude of reports using Power BI desktop with a variety of visuals such as charts, tables, slicers, gauges.
• Wrote DAX expressions to create new measures, calculations per business requirements.
• Implemented row-level security and groups to restrict data access in Power BI reports.
• Integrated custom visuals based on business requirements in Power BI Desktop.
• Utilized Power BI gateways to configure data refresh of Power BI data models.
• Optimized reports with modifications to embedded queries and/or stored procedures.
• Generated on-demand and scheduled reports with SSRS for business analyses and managerial decisions.
• Utilized the PBI interface to organize reports, data sources, schedule report executions, and track report history.
• Collaborated with other team members utilizing TFS.
• Conducted JRD meetings to gather business requirements from business users and SMEs.
• Conceptualized and designed data marts involving bottom-up approach and star schema.
• Designed and optimized complex stored procedures to perform data profiling and auditing in the pre-staging database.
• Formulated stored procedures to perform index maintenance and data profiling for loading data marts and generating report datasets.
• Created stored procedures and functions to implement the business logic for interfacing with parameterized reports.
• Defined data sources and data source views for OLAP cubes utilizing SSAS.
• Utilized SSRS and Power BI to amplify data visualizations with interactive sharing, collaboration, and data management.
• Configured parameters and functions to extract data from Web APIs within Power BI reports.
• Implemented data blending, groups, calculated fields, and aggregated fields to analyze data in Power BI.
• Utilized Power BI gateways to configure data refresh of Power BI data models.
• Performed troubleshooting of performance issues that were associated with Power BI reports.
• Published sub, drill-down, summary, and matrix reports in SSRS.
• Prioritized and managed work items, tasks as per stack ranks on Team Foundation Server (TFS).

Work Environment: Power BI, DAX, Power Quirey, SQL Server, SSDT, SSAS, SSRS, T-SQL, Erwin, MS Excel, TFS, DTA, SSMS, SQL Profiler, DTA, MS Azure

Power BI Analyst

Confidential

Responsibilities:

• Collecting data from primary and secondary data sources using from Microsoft SQL Server, MS Excel
• Data and Document detailed designed as per requirement in Business intelligence
• Created tables, stored procedures, views, indexes, Triggers, Constraint, temporary tables and user-defined data types and functions using T-SQL
• Developed logically and physical Data Models by using ER and Normalize or Denormalize according to Business requirements.
• Gathered Business requirements and translated objectives into actionable Dashboard and analytics.
• Involved in designing the data model and implemented the star schema for QV better optimization.
• Writing an MDX / DAX Functions for data Manipulation and Transformation for efficient data visualization in Power BI.
• DAX is a component of the BI Semantic Model. That makes it Related to both SQL and MDX.
• DAX is a set of Functional expressions used to connect disparate data across mostly TABULAR data models.
• Designed and developed ETL jobs or extracts to pull the data from multiple sources required for the Visualizations
• Tune ETL code and reports to the optimum performance possible
• Created SSIS Packages to executed ETL data messaging operations for data profiling, cleansing, and verification.
• Experience in used Excel / CSV /Text files to generated reports.
• Used Quick Filters, sets, parameters and calculated fields on Tableau Reports.
• Created development of business intelligence solutions using Power BI
• Generated scorecards with executive summary dashboards to display performance monitoring measures with Power BI.

Work Environment: Power BI, DAX, MDX, ETL, SQL Server 2016, SSAS, SSRS, T-SQL, MS Excel, TFS, DTA, SSMS, MS Azure