BI Developer Resume

SKILLS:

Languages: C, Java, T - SQL, Perl

Databases: SQL Server, Cosmos, SCOPE Script

ETL Tools: Microsoft SSIS

Data Visualization: Tableau, Power BI, Microsoft SSRS, MS Excel

WORK EXPERIENCE:

Confidential

BI Developer

Responsibilities:

Use Cosmos Big data platform for, writing Scope Scripts to query B2B user data from relevant sources.
Schedule and monitor jobs that periodically fetch needed data.
Currently collaborated with Microsoft to work on a large set of data for development and creation of data warehouse and writing SQL queries involving complex joins and sub-queries.
Worked closely with clients to understand the requirements and work towards generating actionable insights and solutions for AAD Tenant User activity data.
Implemented data models in Power BI and designed, developed and deployed reports as per the customer needs.
Developed product and cloud service usage insights through dashboards.
Created reports that help categorize the test automation infrastructure to improve productivity of development teams.

Confidential

BI Developer

Responsibilities:

Experience working with large and complex data sets, design and development of SQL Server databases and query performance tuning.
Expertise in writing complex and high performing multi-table SQL queries, user functions, indexes, views, triggers, functions, T-SQL.
Good knowledge in RDBMS concepts and Data warehousing concepts, OLTP & OLAP.
Proficiency in designing, developing and configuring scalable ETL packages using SSIS and maintaining the ETL pipeline.
Involved in daily loads (full and incremental) into staging area.
Designed and Created ETL packages using SSIS for data extraction from Flat files, Excel files, OLE DB to SQL Server database using different transformations and Scheduled jobs for executing SSIS packages on daily basis and monitoring them.
Implement Bulk Copy and Bulk Insert functionalities to load data from different data sources to SQL Server
Good knowledge in multidimensional data modelling techniques.
Responsible for developing Dashboard OSD PnL reports which provide the Profit/Loss data for Online Service Division of Microsoft in the form of CM (Contribution Margin) based on Revenue and Expense.
Created Rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver key insights, generated KPI for customer satisfaction survey results and disease management and created visualizations for logistics calculation and department spend analysis.
Interacted with clients, gathered report requirements and managed the delivery with an improved performance of reports to 15 sec.
Connected Tableau server with share-point portal and setup auto refresh feature.
Developed interactive reports using different functionalities like quick filters, context filters, parameters, calculated fields, hierarchies and table calculations.
Experience in creating complex formulas and calculations within Tableau to meet needs of complex business logic.
Maintained Test log and wrote test Evaluation, Summary Reports and extensively involved in user acceptance testing (UAT) and generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship