Senior MSBI/Power BI SQL Developer available. Visa H1B. Open to relocate.
PROFESSIONAL SUMMARY
· 9+ years of experience in developing Business Intelligence applications utilizing SQL server, T-SQL, MS BI stack(SSIS, SSAS, SSRS), MDX, DAX, Azure, Power BI, Power Pivot and Power View reports and Tableau.
· Experienced with full life cycle phase of SDLC involving Systems Analysis, Design, Development and Implementation.
· Following agile methodology for the projects, setting up monthly sprints, and daily stand ups to identify roadblocks and measure the progress of the ongoing project.
· Excellent in High Level Design of ETL DTS Packages and SSIS Packages for Integrating data using OLEDB Connection from heterogeneous sources (Excel, CSV, flat file, Text format) by using multiple transformations such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
· Developed multiple Dashboards, analytical reports, KPIs and Interactive reports based on business requirements using Power BI and SSRS to support executive needs.
· Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
· Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
· Worked Extensively on ETL process using SSIS packages.
· Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Ad-hoc and Sub Reports.
· Experience in Dimensional Modeling, ER Modeling, Star Schema/Snowflake Schema, Fact and Dimension tables.
· Worked on migration of legacy in house SQL server databases to Snowflake and AWS cloud.
· Designed Dashboards, Scorecards and reports using multiple KPI’s.
· Created Reports with complex formulas and to query the database for business Intelligence.
· Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
· Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.
· Designing SSAS cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
· Proficient in implementing and customizing Dynamics ERP solutions to streamline business processes and enhance overall efficiency.
· Hands on Experience with AWS Snowflake cloud Data warehouse for integrating data from multiple source system which include loading nested JSON formatted data in to snowflake table.
· Experience in working Azure cloud components ADF,ADL, and Azure SQL & Datawarehouse
· Built Interactive Power BI dashboards using multiple visuals, slicers, bookmarks, and Drill through functionalities.
· Experience in developing Dashboard Report, Parameterized Reports, linked reports, Sub reports by Region, Year, Quarter, Month and Week.
· Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts, and numerous stored procedures consumed at various stages of migration/cleansing process, reports or data validation.
TECHNICAL SKILLS
Languages
SQL, T-SQL, PL/SQL, MDX/DAX, C#, ASP.NET, XML.
Databases
MS SQL Server 2016/2012, Snowflake, Oracle 11g/8.0i, MS Access.
DWH /BI Tools
SSIS, SSRS, SSAS, Business Intelligence Development Studio (BIDS), Power BI Desktop and Services, Microsoft Visual Studio 2019/2017.
Cloud Environment
SQL Server Tools
AWS, Snowflake, AWS RDS, AWS Redshift, EC2, S3, Lambda, Cloud watch , AWS Auto scaling, Microsoft Azure and Google Cloud Platform.
SQL Server Management Studio (SSMS), SQL Server Enterprise Manager, SQL Server Profiler, Query Analyzer, Import & Export Wizard, Power Pivot, Excel Power Pivot, Excel Data Explorer.
Reporting Tools
Power BI, SSRS, Tableau, Crystal Reports, Einstein Analytics, SAP Analytics.
Other Tools
Microsoft TFS, GIT, HP Quality Center, Jira, Confluence, MS Office 365, Microsoft Visio, Smartsheets.
EDUCATION:
Master of Science, Management Information Systems (MIS)
University of Houston Clearlake, USA Dec 2016
Bachelors of Technology, Electronics and Communication Engineering
Jawaharlal Nehru Technological University, India May 2011
PROFESSIONAL EXPERIENCE:
Client: Idaho Transport Department, ID, USA Aug 2022 - Present
Role: Sr.Power BI Developer
Responsibilities:
· Creating dashboards using the existing business metrics, charts, and visualizations.
· Creating drill-down reports, interactive graphs, and visuals for a comprehensive report.
· Developed Power BI reports and dashboards from multiple data sources using data blending.
· Performed different types of context like Row context, filter context and query context using Power BI Desktop
· Performed transformations like Pivoting, Un Pivoting and Splitting of the columns using Power Query.
· Performed Query Folding using Power Query to filter data in the data source server.
· Implemented Date and time functions, Time-intelligence functions, Filter DAX functions.
· Worked with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER, RANK.
· Created Drilldowns, Drill through and Bookmarks in Power BI Reports for easy navigation and storytelling.
· Created Dynamic Dropdown measures in slicer with the help of DAX in Power BI Desktop.
· Developed Measures, Calculated Columns, Conditional Columns, Custom Columns in Power BI.
· Optimized database by creating Clustered, Non clustered Indexes and Indexed views.
· Resolved issues related to query optimization, database optimization and index tuning.
· Performance Tuning of multiple databases by fixing indexes, table partitioning, usage of temp tables, CTE’s and redesigning schemas.
· Created different visualization in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc. Also, using different transformation inside edit query into clean-up the data.
· Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
· Created ad-hoc reports such as YTD, YOY, MTD, MOM analysis for income statement, cash flow by requests from business units.
· Led successful implementations of Microsoft Dynamics ERP, optimizing workflows and enhancing data-driven decision-making capabilities.
· Developed different types of reports such as Descriptive, Predictive for end-users
· Represented geography data in Power BI using visuals such as Map, Filled Map, Shape Map, ArcGIS and Globe Map.
· Transforming and validating data using SSIS transformations like Conditional split, Lookup, Merge Join and Derived column for unstructured data and redundant data.
· Created SSIS packages for transferring the data from different systems such as SQL/Oracle server,
· Flat files, CSV files and xml files.
· Implemented logging and error-handling during SQL Server Integration Services(SSIS) package execution and notified process results to various user communities
· Developed complex SQL queries using stored procedures, common table expressions (CTE’s), temporary table to support Power BI and SSRS reports.
· Worked on Azure cloud databases servers, ADW and Blob storage for ETL.
· Used M language to create Custom, Conditional columns and Append files in Power Query.
· Created a form with Power Apps to enter Highway budget data every month.
· Integrated a Power Apps with Power BI which served as ticketing system to gather anomalies related to data.
· Created Paginated reports using Power BI builder and published to Power BI service.
· Publishing reports using advance DAX in Power BI desktop, share the dashboard with Power BI service, publishing reports for mobile apps giving access to the end-users like developers, stakeholders, managers and clients.
· Extracted and loaded CSV files, JSON data files data from AWS S3 to Snowflake cloud Data warehouse.
· Hands-on experience in creating tables, views and stored procedures in Snowflake.
· Performed tuning and optimization of reports that take longer execution time using MS SQL Profiler, Index Tuning wizard and SQL Query Analyzer.
Environment: MS SQL Server 2016/2012, Power BI, SSIS, SSRS, SQL, T-SQL, C#.Net, Visual Studio 2019/2017.
Client: CrossCountry Mortgage, OH, USA Jun 2017 – Aug 2022
Role: Sr.Power BI Developer
Responsibilities:
· Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
· Developed complex Power BI models for financial reporting and performed ad-hoc analyses.
· Created Excel Power Pivot, Power Query and Power View dashboards for data analysis and reporting.
· Implemented complex DAX functions in Power BI and Power Pivot.
· Proficient Knowledge of leveraging Common Data Service for scalable and secure data stores with a common yet extensible schema as part of the Business Application Platform, for Power Apps, Power Automate (Microsoft Flow) and Power BI.
· Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
· Created several user roles and groups to the end - user and provided row level security to them.
· Designed and developed Power BI dashboards, Reports and published it on Power BI sites.
· Scheduled jobs for creating snapshot of Power BI Reports and Dashboards and troubleshooting on datasets for Power BI sites.
· Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
· Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
· Extract, Transform, and Load (ETL) data using SQL Server Integration Services(SSIS) creating, deploying, scheduling, and managing Integration Services packages, configuring control flow, data flow and event handling tasks
· Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements.
· Implemented Role-Based Security as part of security in Power BI.
· Created Database Maintenance Plans for the performance of SQL Server, which covers Database Integrity Checks, update database Statistics, and Re-indexing.
· Used SQL Profiler for troubleshooting, monitoring, optimization of SQL queries.
· Querying and manipulating multidimensional cube data through MDX scripting in SSAS.
· Developing Data warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star schemas and Snow Flake schema for developing Cubes.
· Developing C# scripts in SSIS and automating tasks in C#.
· Implemented Copy activity, Custom Azure Data Factory Pipeline Activities.
· Participate in integration, performance, and user acceptance testing for BI solutions.
· Responsible in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity using T-SQL
· Developed modules based on the dimensions and measures required for the analysis. Pivoting, drill down, Slice and Dice and filtering operations are done for all the OLAP applications.
· Creating Index, Views, Complex Stored Procedures, Triggers, Cursors, and appropriate User-defined functions to implement the business logic.
· Transferred data from flat files, Excel spreadsheets, and XML Source data to SQL Server using SSIS and also used BCP and Bulk Insert.
· Formulated DAX Expressions create Date to yearly columns and implemented partitions in Tabular Models for Power BI.
· Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
· Used Team Foundation Server (TFS) for source control and sprint planning.
Environment: MS SQL Server 2016/2012, Power BI, SSIS, SSRS, SQL, T-SQL, C#.Net, Visual Studio 2019/2017.
Nikhil Ramagiri | Team Lead - Sales
666 Plainsboro Rd, Suite #1116, Plainsboro, New Jersey 08536
