MS Power BI Developer Resume

SUMMARY

Over 10+years of experience in database design and development using MS SQL Server 2008/2012/2014/2016.
Experienced in Data Modeling, Multi - Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema.
Expert in creating and developing Power BI Dashboards in to rich look.
Extensive experience of writing complex T-SQL queries, views, Triggers, Functions, Stored Procedure, SSIS packages.
Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities
Knowledge of Reverse and forward Engineering, Logical and Physical models, Dimensional Modeling.
Excellent knowledge in RDBMS principles.
Expertise in Data Warehouse Modeling with SQL Server Analysis Services (SSAS).
Expertise in creation and deployment of dimensions, partitions, aggregation and cubes on SSAS.
Proficient in creating SQL Server reports, handling sub reports and defining query for generating drill down reports using SSRS.
Maintained existing reports and created new reports according to the business needs and integrated them in performance point server.
Experienced in using global variables, expressions and functions for the reports.
Maintained securities, roles, and subscriptions in report manager in SSRS.
Experienced in migrating reports from Crystal Enterprise 8.0 to SSRS.

TECHNICAL SKILLS

Operating System: Linux, Windows

Relational Databases: Oracle 8.x/9.x/10.x/12c

SAP R/3 Basis: Ver 4.6C

GUI Tools: Visual Basic .Net

Languages: Java Script, Cobol, FoxPro

Data Analysis and ETL Tools: MS SQL Server Integration Service(SSIS),MS SQL Server Analysis Services(SSAS)

Business Analysis / Report Tools: MS Power BI, SQL Server Reporting Services(SSRS), Crystal Report

PROFESSIONAL EXPERIENCE

MS Power BI Developer

Confidential

Responsibilities:

Design solutions that align with the firm’s data management principles, policies, standards and best practices
Generate large and complex data extracts and queries for the Analytical Leads for data analysis by utilizing various database schema such as Microsoft SQL Server, Oracle
Information collected from the user and documented.
Contract Renewal Report showing analysis of Vendors with renewal date and due date
Data Quality Report showing the analysis of data and errors in data
Data Spend Report: Analysis of data classification from Vendors
Equity Analysis report: Index based analysis of different countries
Index Management: Analysis of Index Trending Period wise. Data collected from JIRA.
Technical Notices: Technical Notices send to our client and analysis of theses TN based on classification.
Created Dashboard showing Indices Performance Global Level.

Consultant

Confidential

Responsibilities:

Overall responsible for Product development and completion of ongoing projects.
Project Study, Designing the project proposal and presentation, Finalize the platform and Project Approval.
Delivered project needs on time and within the agreed acceptance criteria in a hybrid methodology environment as they attempted to transition to an Agile Methodology.
Overall co-ordination with project Team to complete project in Schedule.
Finalizing Blue print documents for the projects
Business process study
Solution Mapping & GAP Customization

Environment: MS SQL Server, SQL Server Reporting Services, SQL Server Integration Services, XML, T-SQL, MS Access, Power BI, C#, Team Foundation Server, FTP & SFTP server.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship