Home

Kishore - Power BI Developer

[email protected]

Location: Morrisville, North Carolina, USA

Relocation: Yes

Visa: H1B

Kishore Senior software engineer 214 716 8639 Summary: Over 12 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server in Development, Test and Production Environments on various business domains like Insurance and Financial. Involved in the design and development of the project. Involved in the ETL phase of the project. Creating packages at Sql Server Integration Service platform. Development of mappings according to the ETL specifications for the data load. Created Event Handlers for the Packages Using Event Handler Tab for Error Handling. Created Configurations to change the package properties dynamically. Maintained log information in SQL table to track Errors and recording package execution status. As per requirements developed the reports in the form of Table using SQL Server Reporting Services. Scheduled Reports Yearly basis as per the Client Requirements. Experience working with dataset ingestion, data model creation, reports, dashboards, KPIs, custom visuals, data pipelines, Power BI Pro features, workspaces, and security. Experience eliciting and documenting requirements for Analytics solutions. Capacity to develop complex SQL queries Working knowledge of DB views, materialized views, Packages and Stored Procedures. Working knowledge reporting from a Data Warehouse environment Familiarity with dimension and facts and relational models, Star and Snowflake Schemas. Develops logical and physical data flow models for ETL and reporting applications. Ability to troubleshooting data issues from target back to source alone or in a team setting Self-motivated with ability to work independently without close supervision. Responsible for Capacity planning, scaling up/Scaling out of servers and maintaining server architecture at enterprise-scale, serving 80k+ users and troubleshooting, performing health checks and deployment reviews with Tableau and Microsoft. Responsible for Server activities like Performance monitoring/optimization, change management, enforcing best practices, distributed cluster management and scheduling. In-depth knowledge of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework. Experience in working with different data sources like SQL Server, Snowflake, ORACLE, SAP, Flat files, and cloud databases, connecting them to Tableau desktop to develop dashboards and manipulate staged data sets to provide flexibility in visual design. Excellent ability to gather and transform complex business requirements into functional and technical design documents for scalable, robust, and optimal solution development. Collaborating with customers and cross functional teams, coordinating activities with end-users, senior organization leadership team, offshore/onshore teams. End-user training/mentoring, delivering best practices, handling content migration, and utilizing Agile Project Management Tools like Team Foundation Server (TFS), Jira and ticket/incident management using ITSM, remedy tools. Technical Skills: Database- ORACLE, Snowflake, SQL Server and DB2 Visualization and Reporting- Tableau 2019.x 2018.x, 10.x, 9.x, PowerBI, MicroStrategy Security and Authentication- Security Design, SSO, LDAP, and Active Directory Operating systems- Windows, Red Hat Linux EL10 Cloud Platform- AWS, Azure, and Tableau online Data Profiling- Alteryx and Information Steward. Other tools- JIRA, ITSM, Power Apps, Power Automate, SharePoint, Google Analytics, POSTMAN and MuleSoft. . Experience Optum, Minneapolis, US Sr Consultant Feb 2017 to Present Involved in the end-to-end implementation of the dashboards i.e., from understanding requirements and identifying data sources to building the data model by writing ETL and designing the front end. Designing and development of visualization solutions and creation of Business Requirement Documents (BRD) and plans for creating dashboards. Installed Tableau reports server on-prem and created folders on top of it and granted access to users. Development of mappings according to the ETL specifications for the staging area data load & warehouse data load using SQL Server Integration Services & SQL Server 2014. Created Event Handlers for the Packages Using Event Handler Tab for Error Handling. Created Configurations to change the package properties dynamically. Maintained log information in SQL table to track Errors and recording package execution status. Involved in creating reports for Business Analysis Process. As per requirements developed the reports in the form of Matrix, Table and Chart using SQL Server Reporting Services. Developed Report Models and Ad hoc Reports using Report Builder in the Report manager. Scheduled Reports Weekly and Monthly basis as per the Client Requirements. Implemented Different types SCD Functionality while loading the data into DWH. Published Tableau dashboard on Tableau Server and embedded them into portal. Migrated reports from existing environment MicroStrategy to Tableau whenever required. Setup of distributed server environments for optimum load balancing. Migrating legacy MS excel, MS access-based reports to Tableau based visualizations and use data warehouse live connections. Created Transformations for time-series analyses and prompts in customer tuned reports and prompts, custom groups, and consolidation. Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets. Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop. Handled user licenses for projects. Good SQL reporting skills with the ability to create SQL views and write SQL queries. Involved as a technical expert providing input to application design regarding performance tuning and administration requirements. Planned and implemented the overall analytics and business intelligence strategy. Optum, Hyderabad, INDIA BI Consultant Jul 2015 to Jan 2017 Worked with stakeholders to gather requirements and understand their needs and provided them best visualizations like KPI`s, paginated reports, ArcGIS maps, bullet charts, bar graphs, Tree/heat maps etc. Technical resource to manage large Power BI service environment, responsible for highly complex problems during planned and unplanned outages and serving 80k+ users and maintaining High availability (10+ nodes). Worked on DAX functions to build visualizations, developed power bi paginated reports using power bi report builder. Used DAX studio for performance optimization and used inbuilt power bi desktop performance optimization functionalities. Built visualizations using custom visuals from Microsoft Market place and organizational templates. Worked with Sql server management studio to write queries and extensively worked with SSRS and SSIS services. Migrated SSRS reports to Power BI and published on Power BI service. Responsible for server functions, Configurations, Installations, Upgrades, Cleanups, Backup, License management and Load balancing of servers. Responsible for Power BI service administration, setup and maintenance of Power BI Gateway and Power BI desktop packaging and layering. Full lifecycle PowerApps canvas and model driven applications Designing and developing Power Automate workflows. Use of Common Data Service Securing apps and data Deploying Power Platform solutions Developing Power Platform solutions in SharePoint and Teams Created flows via Power Automate for Power Bi subscriptions. Integrated Power Apps in Power BI visualizations and made forms to insert the values. Worked with premium licensing for Power Apps and Power Automate subscriptions. Responsible for Power BI server architecture design and creation of documents. Responsible for Data source connectivity testing/setup for power bi service and power bi desktop to both on-prem and cloud data sources. Acquisition of new licenses for Power BI Pro and free via Office 365 and worked on license harvesting. Installed, Upgraded Power BI gateway to May (latest version) and tested connections from all majorly used data bases like SQL, Snowflake, ORACLE, SAP and flat files etc. Involved in weekly Elite calls with Power BI Vendor to report or solve complex issues, utilizing Agile Project Management Tools like Team Foundation Server (TFS). ITC Infotech, Hyderabad, INDIA Software Engineer Mar 2013 to Jul 2015 Project Title : MCDB Extraction Client : State of Maryland The goal of the Project is to develop reports with regards to claims related to all Maryland residents covered under Maryland Contract H5665-002 for filing the Professional Services Data, Pharmacy Data, Provider Directory Data, Institutional Services Data and Medical Eligibility Data to the Maryland Health care Commission. Responsibilities: Involved in the design and development of the project. Involved in the ETL phase of the project. Creating packages at Sql Server Integration Service platform. Development of mappings according to the ETL specifications for the data load. Created Event Handlers for the Packages Using Event Handler Tab for Error Handling. Created Configurations to change the package properties dynamically. Maintained log information in SQL table to track Errors and record package execution status. As per requirements developed the reports in the form of Table using SQL Server Reporting Services. Scheduled Reports Yearly basis as per the Client Requirements. Source One Management Services Pvt Ltd, Bangalore, India Software Engineer Oct 2012 to Feb 2013 Converted high-level design specifications to detailed functional and technical specifications. Worked on creating Universes using the Business Objects and connected to the database using ODBC. Created queries for multidimensional analysis using Slice and Dice, Drill Down, Drill by and Drill Through. Worked on WEBI Info View to create and modify the existing reports. Submitted and presented the reports in user-defined formats like Tabular, Master Detail, and Cross Tab. Upgraded Business Objects Universes, User groups, and reports from Version 5x to 6x. Performed release management of Business Objects reports using Broadcast Agent Server. Designed, tuned, and optimized the Star Schema to implement core database. Scheduled and monitor different session of loading data using Power Mart Server Manager. Trained end users in basic and advanced ad hoc reporting skill. Maintained and updated database models, generating or modifying the database schemas Data Mapping and DWH loading Use case analysis. Database coding and implementation. Used workflow manager for session management, database connection management and scheduling of jobs. VSigma, Hyderabad, India Software Engineer June 2010 to Oct 2012 Installation of MicroStrategy suite. Help client in feasibility study so that they can consult with end users accordingly. Understanding the LDM and PDM before starting with the MicroStrategy development. Understanding the Dashboard requirement by discussing with the Business users. Creating Technical Design Documents. Creating Dynamic and static Dashboards by using selectors, panels, and panel stacks. Developed Reports using MicroStrategy objects such as Attributes, Metrics, Filters, and prompts to generate reports for Business analysis. Developed dashboards from varied datasets with interactive features such as widgets, selectors, and links. Designed Templates, Filters to generate Reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report. Created Transformations for time-series analyses and prompts in customer tuned reports and prompts, custom groups and consolidation. Worked in developing Reports according to the Business Requirements. Created I-Cubes to run the reports faster. Created the incremental refresh for the I-Cubes without updating manually. Creating the time and event-based schedules and subscribing the reports to the business users. Used VLDB Properties extensively to achieve report requirements. Keywords: business intelligence database active directory information technology microsoft