BI Developer Resume

PROFESSIONAL SUMMARY:

Over 10 years of development and consulting experience in Business Intelligence Reporting for Banking, Finance and Web Analytics domains with expertise in Microsoft SQL Server suite of products (SSIS, SSAS, and SSRS).
Experience in performing roles such as Report Designer, ETL Developer, Data Analyst and Data Modeler.
Experience in providing end to end Reporting - Analytics solutions and designing Data Warehouse systems to implement these solutions.
Experience in Data modelling and ETL (using tools like SSIS, SAS DI Studio, MS SQL server etc.) for developing, loading and maintaining data warehouse systems with huge amount data.
Experience in designing and maintaining MS SQL Server Analysis Services (SSAS) cubes, using MDX to retrieve data for reporting and analysis.
Experience in designing highly customized Reporting environments using Microsoft SQL Server Reporting Services (SSRS) by using SQL stored procedures, CLR and MDX queries.
Experience of leading teams as Technical Team lead and Onsite coordinator.
Experience of working with Business users on regular basis for requirement gathering, project delivery and status reporting.

TECHNICAL SKILLS:

Microsoft BI Suite: Microsoft SQL Server 2008/2014/2016 SQL Server Integration Services (SSIS)SQL Analysis Services (SSAS)SQL Server Reporting Services (SSRS)T-SQL, MDX.

Others: TFS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, Data Warehousing and Business Intelligence Architecture.

PROFESSIONAL EXPERIENCE:

Confidential

BI Developer

Technologies: SSIS, SSAS, SSRS, SQL Server 2008 R2 and 2016.

Responsibilities:

Confidential has a highly customized User Access Management system that makes it possible for one report to be used by all level of users and delivers them only data they are allowed to see.
This eliminates need for creating multiple versions of same report.
It also supports different methods of reporting analytics depending on user preference, for example: Ad hoc reporting with MS Excel, automated delivery of subscribed reports in different formats, delegation of reports between users, drag and drop interfaces for data management removing need of any technical teams for data updates.
A central Master Data Management system can be used to make changes which will reflect in all sub-modules of reporting without manual intervention.
This system is used by around 40,000 employees of EY globally on daily basis.
Reports made in SSRS use a unique way of merging data from dynamic MDX queries and MS SQL tables. This makes it possible for all cosmetic and functional features of reports to be controlled by configuration changes in a central place.
This project has been in production with Green status for last 4+ years.

Confidential

BI Developer, System Analyst, Offshore Team Lead, Onshore Team Lead

Responsibilities:

Getting, understanding and documenting requirements from different sets of business users
Preparing necessary documentation, work plans, effort estimates and tasks
Coordinating the work between onshore and offshore teams
Providing inputs for design of overall system
R&D and feasibility checking of critical requirements
Creating prototypes for client presentations
Implementing design of the solution and system
Planning ETL development
Report Design using SSRS R2 (now being migrated to SSRS 2016)
Ongoing system maintenance and support
Optimization of project processes
Development of semi-automated yearly rollover process.

Confidential

Senior analyst

Responsibilities:

Providing inputs for internal analytical systems portal
Providing inputs to sales teams by creating presentations and case studies on ongoing projects
Active member of Technical Experts team that helps projects in trouble.
Providing training to employees to get them started in Microsoft BI development.
Mentoring and building a small team of fresh graduates to work in BI Dept.
Act as backup for Business Analysts and Tech Leads from different projects.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship