SUMMARY

• Over 7+ years of IT experience in software development, designing and implementation with major focus around Business Intelligence, Data Warehousing and Database Applications.
• Hands on experience on T - SQL, MSBI-SSIS, SSAS, SSRS, MDX, DAX, Power Pivot and Power View reports.
• Experienced with full life Cycle phase of SDLC involving Systems Analysis, Design, Development and Implementation.
• Good experience in Power BI Desktop, SQL Server & DAX Queries, Power BI mobile, Power BI Serviceand knowledge on Tableau.
• Worked extensively on creating reports and dashboard in Power BIfrom different databases & sources.
• Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Expertise in developing reports related to Market Research & Analysis, Design & Modeling of Supply Chain, Economic Analysis of Industrial Projects andResource Planning.
• Extensively worked on Documents and Dashboards to facilitate customized multi-report display for advanced visual effects and give the privilege to business users for better business analysis.
• Worked on power pivot models, power maps and Power view.
• Dexterous developer in creating Constraints, Defaults, Tables, Indexes, Views, Stored Procedures, Functions, Triggers and Dynamic SQL queries.
• Experience creating Cubes with Dimensions and Fact tables in OLAP using SSAS and creating calculated measures and dimension members using Multi-Dimensional Expressions (MDX)
• Proficient in creating Drill Down Reports, Ad-Hoc, data driven subscription, Parameterized reports, Charts using SSRS and MS Excel for data analysis.

TECHNICAL SKILLS

Languages: VBA, SQL, DAX

Databases: MS-Access 2.0/97/2000/XP/ 2002/2003/2007 , SQL Profiler, SSIS, SSAS, SSRS, DTS SQL Server, etc.

Tools: MS (Access, Excel, and Word PowerPoint), Microsoft SQL Server 2017

BI Tools: Tableau, Power BI other skills: VLOOKUP, Pivot table, Macros, Advance Excel

Methodologies: Agile Scrum, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Newark NJ

Sr. Power BI Developer

Responsibilities:

• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Validated data by writing SQL queries in source and target database.
• Good Knowledge in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Developed SSIS package to pull required data from source and mapped them to target database.
• Generating and applying surrogate keys in the Power BI Query Editor.
• Experience in SSIS\SSRS\SSAS. Wide experience in building static, dynamic and interactive reports using BIDS and Report Builder.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Exceptionally deliver stunning interactive reports in your app with the Power BI Embedded service.
• Deployed SSIS package to SQL Server and scheduled it to run daily using SQL Server Agent.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Created subscriptions to provide daily basis reports. Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Created Quality Assurance stats reports using Power BI.
• Created SSAS Tabular semantic model with partitions, hierarchies and calculated measures using DAX as per business requirements.
• Built Dashboards /Reports/ combine different datasets and publishing using Power BI Desktop tools.
• Worked on Visualization, Merge queries and enhancements using Power BI desktop tools.
• Worked on deploying, sharing reports/Dashboards to Microsoft Power BI service.
• Developed Power BI model used for financial reporting
• Extensively worked on Office 365 for Power BI implementation.

Environment: MS SQL Server 2012, DAX, SQL, T-SQL, T-SQL Procs, SSIS, SQl Query, Denodo and Power BI reporting.

Confidential, Jersey City, NJ

Power BI Developer

Responsibilities:

• Working with gateways and scheduling the refresh and Creating reports and dashboards.
• Good Experience on Power Query, Power pivot and DAX functions.
• Involved in installing and configuring gateway services for Power Bi Desktop.
• Created charts like Lines, Pies, Bar, Scatter, Area, Tree map, Map, Filled map, Gauge, Funnel, Single Card, Multi row card, Slicer etc.
• Importing Custom Visuals from Microsoft Power Bi gallery as per client request.
• Worked with T-SQL to create tables, stored procedures and user defined functions for complex business logic.
• Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculate the metrics that were revealed in the functional analysis.
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
• Worked on the Power BI reports & dashboards with SQL Server / Tabular SSAS, Excel, web sources, csv, and other sources.
• Involved in performance tuning for new databases and existing databases by using SQL profiler.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Experience in Generating reports like Pie-charts, Bar graphs, Drill downs, Drill through etc. using Power BI.
• Used Event handlers to run send mail tasks in the background upon success or failure of a package in SSIS.
• Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions.
• Involved in troubleshooting, enhancing and creating new ones of claims retro report templates.

Environment: MS SQL Server 2016, SQL, T-SQL,DAX, T-SQL Procs, SSIS, and Power BI reporting, Office 365, Database Schema, SQl Query, GitHub Desktop and GitHub online.

Confidential

Power BI Developer

Responsibilities:

• Build a data cube around the existing offer click, impression and revenue statistics from redirectors.
• Enhance and build selected redirect reports with the flexibility of an OLAP service
• Created SSIS packages to load data into staging table and data mart and Performed logging in SSIS packages to capture error data and for error handling.
• Used the SSIS to migrate Databases such as Access database, flat files to centralized IT destination.
• Performing T-SQL tuning and optimizing queries for reports that take longer execution time.
• Prepared the data to cover various scenarios and wrote SQL Query to verify the database updates, inserts and deletion of the records.
• Extract data from flat files which comprised of header and input files to SQL server 2012 and Created Testing scripts for staging validation, generated the Map Force file for mapping between flat file and database.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI Service.
• Developed Logical and Physical models based on the business requirements. Created ER Diagrams using Visio.
• Created MOLAP Cubes and automated the Processing options on different servers. Optimizes the processing time by tuning the DSV queries and created SSIS Packages eliminating complex syntax in Data Source View.
• Created the Partitions, Aggregations and various custom Member calculations in the Cube. And also, developed drill through actions which would navigate to SSRS reports deployed to Report manager.
• Created different kind of reports like cascading reports, Drilldown reports, Drill through Reports, Parameterized reports, Sub reports and charts in SSRS 2008R2.
• Used Power Query to acquire data and Power BI desktop for designing rich visuals

  Created Rich dashboards using Tableau/Power-bi Dashboards and prepared user stories to create compelling dashboards to deliver actionable insights.

• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
• Working on Creating partitions and Designing various storage modes to increase the performance of a cube using SSAS.

Environment: MS SQL Server 2008R2, SQL Server Integration Services (SSIS), Power BI reporting, DAX, Teradata, SQL Query, SSAS, SSRS, OLTP, Visual Studio 2010, SQL Server Management Studio, Excel, TFS, Windows XP.

Confidential

SQL /BI Developer

Responsibilities:

• Wrote complex SQL queries using joins, stored procedures and used defined functions to verify the data from the database to generate reports based on the business requirement.
• Developed various T- SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• Excellent experience in SSIS, SSAS and SSRS of MS SQL Server.
• Created (SSIS) packages to get data from various sources.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Extensive T- SQL Programming involving Development of Stored Procedures, CTE's (Common Table Expressions), Cursors, Views, Triggers, User Defined Functions and Scalar Functions.
• Expert in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
• Proficient in Creating business critical KPIs using SQL Server Analysis Services SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance. Scheduling the jobs to run for ETL using SQL Server Agent.
• Extensively developed complex PL/ SQL packages for Invoice Processing.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Involved in PL/ SQL code review and modification for the development of new requirements.
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
• Used PL/ SQL tables, array structures as a part of oracle collections.
• Create & maintained box jobs using Shell Scripts.
• Created ad Hoc and parameterized various reports using SQL server 2008 reporting Services

Environment: MS SQL Server 2008R2, MS office 2010 T- SQL, Microsoft SSMS, ETL, SSAS, Shell Script, PL/SQL, SQL Server Integration Services, Microsoft Visual studio 2008, Agile, Team Foundation Server.