PROFESSIONAL SUMMARY:

A prolific Information Technology professional with 5 years work experience as a Power BI Developer / BI Developer, where, 3 years was based on SSIS and SSRS projects, and for the latter 2 years, I worked on Power BI projects and a little bit of every other tools. I have a solid understanding of the ETL, Data warehousing and Reporting processes and am well equipped to provide valuable skills and knowledge to the benefit of any organization I find myself.

• Collaborated with Analysts and Knowledge Experts to design, build, and customize reporting packages
• Maintained and debugged existing Power BI reports
• Developed complex SQL Views, Common Table Expressions, and Temporary Tables
• Integrated custom visualization according to the business requirements document
• Migrated existing reports to Power BI
• Developed reports in Power BI Desktop and deployed to both Power BI Report Server and Power BI Service
• Developed complex Data Analysis Expression Language (DAX) calculations, measures, report parameters, and report performance optimization
• Designed complex reports and dashboards using Filters, Drill - down Reports and Sub-reports reports in Power BI Desktop.
• Gathered business requirements, definition and design of data source and data flows.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS
• Analyzed source system data to determine the data model and ETL solution that will meet business requirements.
• Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, fuzzy look ups, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
• Created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and ForEach Loop Container, Execute SQL/Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Designed data structure with multiple facts and dimension tables to hold the source data to be used for building new reports with SSRS.
• Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star and snowflakes schema
• Implemented different Slowly Changing Dimension methodologies to maintain and update historical data corresponding to Dimension tables in the Data warehouse.
• Designing enterprise reports using SQL server reporting services (SSRS) and excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading and dynamics reports.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Defined data sources, data source views, dimensions, measures, hierarchies, attributes, calculations, KPI’s, perspectives and roles.
• Created Sub-Reports, Drill through, drill down, Parameterized, Matrix reports, and Dashboards using SSRS.
• Designed and develop Dashboards and Reports using SSRS.
• Developed various types of complex reports like Drill Down, Drill Through, Gauges, Pie Chart, Bar Chart, Sub-Reports
• Designed reports using table filters, single value parameters, multi value parameters, Dynamic, dependent parameters and cascading parameters.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created stored procedures, triggers, user-defined functions, views handling business logic and functionality of various modules.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures
• Established referential integrity, data consistency, indexing and data cleanup procedures to maintain high quality data that can be used for reporting

TECHNICAL SKILLS:

• Power BI Desktop, Power BI Service, Power BI Report Server, and DAX
• SSIS, SSRS, SSAS, SQL Server
• MS Visual Studio and MS Excel Power Query, Power Pivot and Power View

PROFESSIONAL EXPERIENCE:

Confidential

Power BI developer

Responsibilities:

• Develop different projects using Power BI, MSBI stack (SSRS & SSAS multidimensional and Tabular, SSIS)
• Manages Data visualization and dashboards (Power BI)
• Read, optimize, and update Sql queries where necessary

Confidential

Power BI Developer

Responsibilities:

• Developed and build the Reports, Dashboards and deployed into Power BI Service
• Imported, reshaped and modeled the data
• Created Power BI reports and visualizations
• Created App Workspaces and content packs to share your insights
• Imported data from Azure and build the dashboards according to requirements
• Scheduled dashboards according to frequency (daily, weekly, monthly)
• Created Workspaces and share insights to business customers and partners
• Collaborated with Analysts and Knowledge Experts to design, build, and customize reporting packages
• Maintained and debugged existing Power BI reports
• Developed complex SQL Views, Common Table Expressions, and Temporary Tables
• Integrated custom visualization according to the business requirements document
• Migrated existing reports to Power BI
• Developed reports in Power BI Desktop and deployed to both Power BI Report Server and Power BI Service
• Developed complex Data Analysis Expression Language (DAX) calculations, measures, report parameters, and report performance optimization
• Converted SQL Query code into DAX code for reports
• Designed complex reports and dashboards using Filters, Drill-down Reports and Sub-reports reports in Power BI Desktop.
• Designed data structure with multiple facts and dimension tables to hold the source data in SSAS to be used for building new reports with SSRS.

Confidential, NY, NY

SSIS / SSRS Developer Contractor

Responsibilities:

• Developed Integration Services (SSIS) packages for extracting data from Flat Files, XML files, CSV files, Excel files, SQL Server, and Transformed and Loaded the data to a data warehouse.
• Developed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different transformations like lookup transformations, merge joins, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
• Implemented Various Error handling and Event Handling Techniques in SSIS to ensure efficient package execution.
• Developed logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed SSIS jobs and scheduled packages using SQL server management studio for the daily load.
• Designed packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Task
• Created Sub-Reports, Drill through, drill down, Parameterized, Matrix reports, and Dashboards using SSRS.
• Defined the report layout and identified datasets for the report generation. Developed reports using complex T-SQL queries, user defined functions, stored procedures and views.
• Enhanced SSRS report performance using numerous techniques.
• Managed Report Subscriptions
• Created stored procedures, triggers, user-defined functions, views handling business logic and functionality of various modules.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures
• Established referential integrity, data consistency, indexing and data cleanup procedures to maintain high quality data that can be used for reporting

Confidential, Boston

BI developer

Responsibilities:

• Created and rendered reports in different formats like pdf, excel, flat file, etc. to be executed automatically on weekly or monthly basis and managed subscriptions.
• Generated Sub-Reports, drill down reports, Drill through reports and Parameterized reports using SSRS.
• Configured the report viewing security for various users at various levels using Report Manager.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Scheduled report and exported in PDF format.
• Documented all database objects, procedures, views, functions & packages for future s.