Wednesday, July 26, 2023

SQL BI/Power BI


SQL BI/Power BI Developer Developer available.

Name : Shashidhar
Visa : H1B
Open to relocate

PROFESSIONAL SUMMARY
·      7+ 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.
·      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.
·      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, 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.
SQL Server Tools
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.
Other Tools
Microsoft TFS, GIT, HP Quality Center, Jira, Confluence ,MS Office 365,Microsoft Visio.
 
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: 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.
·      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.
·      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.
·      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.
·      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: SQL BI/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.
·      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.
 
 
Client: Tata Consultancy Services, Hyderabad, India                                                        Dec 2011 - Dec 2014
 Role: SQL BI Developer
 
Responsibilities:
 
·      Proficient in usage of SSIS Control Flow items (For Loop, executes package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
·      Developing, deploying, monitoring and scheduling SSIS Packages on daily, weekly and monthly basis in development, staging and production environments.
·      Developed Stored Procedures, User defined functions, Views, Triggers for complex business logic.
·      Implemented Joins, Correlated and Non- Correlated sub queries and enforced business rules using checks and constraints.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports Including current project status.
  • Created Star Schema for OLAP cube generation and extensively worked on dimension modeling for analysis using SSAS.
  • Created multiple automated reports and dashboards sourced from data warehouse using SSRS.
·       Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
·       Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
·      Created Drill down, Drill through, Sub Reports and Linked reports using MS SSRS as well as managed the subscription of the reports.
  • Implemented Event handlers and Error handling in SSIS packages and notified process results to various user communities.
  • Created different Parameterized Reports in SSRS which consist of report Criteria in various reports to make minimize the report execution time.
·      Designed and created Report templates, bar graphs and pie charts based on the financial data.
·      Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
  • Created Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
  • Designed Star schema (identification of facts, measures and dimensions) and Snowflake
  • Performed normalization of database to reduce redundancy and achieve maximum efficiency.
  • Created complex SSAS cubes with multiple fact measure groups and multiple dimensions hierarchies in SQL server
  • Extensively used SQL profiler to solve dead locks, to monitor long running queries and trouble shoot cubes
  • Used SQL Server Agent to automate the process of rebuilding indexes at regular interval for better performance.
  • Developed Cascading, Tabular, Matrix and Drill down reports using SSRS..
  • Worked on creating the SQL Jobs and alerts using SQL Server agent for SSIS packages.

Environment: MS SQL Server 2008, SSIS, SSRS, SQL, T-SQL, C#.Net, Visual Studio 2010/2008, 

Thanks & Regards,
Abhi  | Sales Recruiter
Email : abhilash@techsmartglobal.com Phone: 732-813-3839
666 Plainsboro Rd, Suite #1116, Plainsboro, New Jersey 08536