SUMMARY

• Around 8 years of total professional experience as a Power BI Developer, ETL Developer in various industrial domains like Insurance, Finance, Banking and Health Care.
• Experience in developing BI Applications utilizing SQL Server, BI Stack, Power BI and Tableau.
• Experienced in developing Power BIreports and dashboards from multiple data sources using data blending.
• Experience in writing complex SQL Queries using stored procedure, common table expressions (CTEs) temporary table to support Power BI.
• Created different Power BI report sutilizing the desktop and the online service and schedule refresh.
• Experience in understanding of Microsoft development suite SSIS and SSAS, as well as familiarity with standard data extract, cleansing, integration, and aggregation techniques and best practices.
• Assist end users with problems installing the Power BI Desktop, installing and configuring the Personal and On - Premises gateway, connecting to data sources and adding the different users.
• Managed relationship between tables in Power BI using star schema.
• Responsible for building reports in Power BI from the Scratch and responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Experienced in both live and import data into Power BI for creating reports.
• Created reports in Power BI preview portal utilizing the SSAS Tabularvia Analysis connector.
• Proficiency in different visualization in the reports using custom visuals likeBar Charts, Pie Charts, Line Charts, Cards, Slicers,Maps etc. Also, using different transformation inside Power Edit Query into clean-up the data.
• Hands-on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, Information, Text and Date functions, Table Functions and Time Intelligence Functions.
• Hands on experience in designing and deploying rich graphic visualizations with Drill Down and Dropdown menu option and Parameterized dashboards using Power BI.
• Generated context filters and data source filters while managing large volume of data using Power BI.
• Experience in creating Filters, quick filters, table calculations, calculated measures and parameters in Power BI.
• Worked withtable and matrix visuals, worked with different level of filters likereport level, visual level filters, page level filters.
• Assisted customers in configuring and troubleshooting their Row-level security for their company.
• Created custom KPI scorecards to help end users visualize metrics according to their preference.
• Extensively used RDBMS like Oracle and SQL Server for developing different applications.
• Effective communication skills and proven ability to perform both as an individual and as a team player.

TECHNICAL SKILLS

Operating Systems: Windows, Linux, Unix

Languages: C, Python 2.7, UML, Visual C++ 6.0, VB 6.0, C#.Net, VB.Net, PL/SQL, TSQL, R programming and Java EE.

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS), Power BI, SAP BI 7.4.

Database: SQL Server 2012/2008, Oracle 10g/9i/8i, MYSQL, IBM DB2 7.1/8.0 and MongoDB

Reporting Tools: SSRS 2012/2008, Crystal Reports XI/X/9/8, Power BI, Excel, Qlikview and Tableau

Web Services: SOAP 1.2 and REST 2.0

Web Technologies: HTML, XML, JavaScript, Angular JS, PHP, Shell Scripting, jQuery

Methodologies: Agile, waterfall and Scrum.

Tools: Eclipse 4.2, SAS, UML Rational Rose, Visio, MS Word, MS Excel, MS Access and MS Project

Web/Application Servers: IBM Web Sphere 6.1, JBoss 3.2.x, Apache Tomcat 6.0, Microsoft IIS 6.0

Cloud Environments: Azure, AWS and Google Cloud.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Power BI Developer

Responsibilities:

• Created and managed data marts and OLAP cubes in MicrosoftSSAS.
• Experienced with SQL Server 2016 and above.
• Responsible for creating both Multidimensional and Tabular cube models.
• Performed dimensional modeling as well as defined semantic layers and BI Metadata repositories to support reporting and analysis.
• Developing row level security with Power BI and SSAS cube models.
• Analyzed data and provided recommendations on new metrics and functionality.
• Created formatted reports, analysis cubes, and dashboards, based on defined requirements from the users.
• Data visualization and creating interactive dashboards using BI tools like Power BI, creating SSRS reports.
• Publishing and sharing Power BI reports and dashboards across the company cloud platform.
• Assisting with data architecture and design standards and maintaining those.
• Assisting business analyst with detailed documentation as needed.
• Efficient in writing complex DAX queries to create different measures in SSAS cubes and analytical dashboards.
• Developing and creating SSIS packages, monitoring cube refresh processes, generating reports.
• Using business intelligence as required, creating dimensions, measures, DAX functions, KPIs, Perspectives, Partitions, Roles, and Actions in Tabular cube models.
• Participating in design sessions with otherdevelopersin the development team.
• Experienced with working on multiple projects simultaneously in a fast-paced environment.
• Efficient in communication with different groups, and working as a team-player.
• Dealt with live connection to Power BI with Tabular cubes and creating reports.
• Created different partitions in cubes to maintain timely cube refresh process across the databases.
• Expert in stored procedures to improve the performance.
• Used strong knowledge to extract, transform, load (ETL) from different environments for developing cubes.
• Creating and maintaining SQL jobs and creating Email alerts for unsuccessful job.
• Ability and expertise in working with different teams and maintain project with little supervision.

Environment: Power BI, Power BI Pro, Power BI Desktop, Power BI Service, Power BI Gateway, SharePoint, Microsoft Office, Outlook, Microsoft Teams, Skype for Business, SQL Server 2017, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS 2019), DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 10.

Confidential, Canton, MI

Power BI Developer

Responsibilities:

• Developed Dashboard Visualizations, cross tables, Bar charts, Waterfall, Tree map and complex reports which involves custom Controls and Custom Expressions using bars, lines and pies, maps, scatter plots, Gantts, bubbles, histograms, bullets, heat maps and highlight table.
• Developed custom calculated measures using DAX inPower BI to satisfy business needs.
• Creating Gateways for data intake and scheduled refresh.
• Used SQL Server Management Studio to execute SQL queries for data analysis and debugging
• Deployed and scheduled the reports in the Power BIService.
• Participated in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.
• Created workspace and content packs for business users to view the reports. created new OLAP data mart for more concise data and more efficient report performance.
• Worked on both live and import data to Power BIfor creating reports.
• Transformed complex business logic into Database design and maintaining it by using SQLobjects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Created KPI, Partitions, Perspectives, and Calculated Measures, used DAX queries in Power BI.
• Created tables, matrix, and chart reports as required and deploy those reports into Power BI Service.
• Created Parameterized Report, Dashboard Report and Sub Report by Year, Quarter, Month, and Week.
• Created report and page level filter in Power BIdesktop to visualize data according to requirement for different analysis.
• Created new hierarchies and managed relationships (active and inactive) in Power BI data models.

Environment: Power BI, Microsoft Dynamics CRM, SQL Server 2016, SQL Server Management Studio (SSMS), Visual Studio 2015, T-SQL, Excel, DAX.

Confidential, Atlanta, GA

Power BI / SQL Developer

Responsibilities:

• Collaborated with the project team to outline project requirements in JRD meetings.
• Profiled the legacy database tables using T-SQL queries to provide data cleansing issue reports to the client.
• Designed Star Schema (identification of facts, measures and dimensions) and Snowflake Schema.
• Development and Creation of Complex Stored Procedures, Triggers and Functions.
• Fine-tuning Stored Procedures to improve the performance by removing the unnecessary cursors.
• Usage of Active Directory to identity management design for providing strong authentication and authorization for internal and external websites.
• Management of T-SQL Views, Cursors, Index statistics, Tables and query optimization using execution plan for tuning the database.
• Implemented different types of constraints on the tables.
• Usage of Try, Catch and error for exception handling.
• Development of physical and logical data modeling tools such as Erwin and ER/Studio.
• Generation of periodic reports based on statistical analysis of data using SQL Server Reporting Services (SSRS).
• Creation of Cross Tab Reports, Drill-down, Drill-through and Sub-Reports using RDL.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View, Power Map and Power Pivot to visualize reports.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
• Managed upgradation of DTS packages to SSIS packages.
• Used the SSIS Import/Export, migrate the Heterogeneous Databases such as Access database, Oracle and flat files toSQLserver2014.
• Managed data from different sources with cloud-based platforms like SSIS, Azure Data Factory.
• Worked in developing Tabular model for Dashboard and Generating the power view Reports.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Developed multi-dimensional objects (cubes, Dimensions) using SSAS.
• Expert in creating Star schema cubes using SSAS.
• Involved in analyzing, designing, building & testing of OLAP cubes with SSAS 2014.
• Responsible for maintaining cubes using SSAS and populate cubes with data.
• Involved in development of ASP.NET/ C# /SQLServerWeb Applications.
• Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.
• Responsible for providing 24X7 Production support, Database and Log Backups & Restoration, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Configured replication servers and transactional replication between production & standbyserverfor disaster recovery.
• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: SQLserver 2008/2012/2014 Enterprise Edition, SSRS, SSIS, SSAS 2016, PowerBI, .NET Framework, C#, ASP.NET, ADO.NET, Oracle 11g/10g, Visio, MS IIS, XML, MS Excel, Access and Visual Source safe.

Confidential

SQL Developer

Responsibilities:

• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
• Developed free-form reports using reports using MS-SSRS tool for consulting multiple reports into single report delivered in .pdf format to the power users.
• Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.
• Worked on SSIS (DTS, DTSX) packages for Data Integration Services. Used SSIS to produce a Data Mart for reporting.
• Extensively used System variables and created User-Defined variables for SSIS packages.
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
• Developed custom reports and developed them onserverusingSQLServerReporting Services (SSRS). Generated periodic reports based on the statistical analysis of the data usingSQLServer Reporting Services (SSRS).
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
• Created reports using stored procedure and experience in building reports on Analysis Services cubes (SSAS).
• Worked with Report Builder 2.0, Report Models and Ad Hoc reports and worked with Tableau desktop, Tableauserverand Tableau reader in various versions of Tableau.
• Managing the ReportServercontents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.

Environment: SQLServer2012/2008 R2 Management Studio- Enterprise Edition, T-SQL, BIDS, SSIS, SSRS. SSAS, OLAP, XML, SharePoint, Agile, Visual Studio 2010, .Net Framework 3.5, Window 8