Prasad N.

ABOUT ME

Over 9 years of work experience in MSBI(SSRS,SSAS,SSIS), Data warehousing, C#, VBA

VBA/VB – Custom Solution for Microsoft Office tools
- Developing Customized reports in Excel, PowerPoint and Access using VBA.
- Building Dashboard/simulation tool to display information at a single place to get the quick
understanding of the data for market analysis.
- Creating generic tools to Generate Analytical reports from raw data files (CSV/Text files)

SSAS
- Involved in Analysing, designing, building & testing of cubes with SSAS 2014 and adding calculations
using MDX.
- Hands on experience in Creating Star Schema and Snow Flake Schemas
- Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modelling
standards in SQL Server 2014. Involved in the complete data warehouse development life cycle.

SSIS and SSRS
- Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data
warehouse.
- Developed, deployed, and monitored SSIS Package.
- Involved in designing, developing and deploying reports in MS SQL Server environment.
- Expert in creating simple and parameterized reports and also complex reports involving Sub Reports,
Matrix/Tabular Reports, Charts and Graphs using SSRS.

Power BI
- Expert in creating and developing Power BI Dashboards in to rich look.
- Expertise in writing complex DAX functions in Power BI and Power Pivot.
- Used various sources to pull data into Power BI such as SQL Server, OLAP, Flat Files etc.

C#.Net – Building the customized Solutions
- Responsible for developing the Library files using C# Technology and integrate the same with Excel.
- Strong Technical Skills on C#. Net technology with special focus on Windows Applications.
- Building office add ins using C# technology(Application and Document level add ins)

SQL
- Developing fine-tuned Queries to extract data as per client request, In Depth knowledge on DML and
DDL commands.
- Excellent technical and analytical skills with clear understanding of dimension modelling for OLAP
- Expert at Writing stored procedures, Functions and Good Knowledge on Triggers.

Data warehouse
- Incorporating innovative approach and methodologies while interacting with the data warehouse.
- Strong Knowledge on the data warehouse concepts
- Building data marts from the data warehouse for client access using relational model.
- Perform Data aggregation based on the client requirements.

SKILLS