Home

Chandra - Senior Power BI developer

[email protected]

Location: Lansing, Michigan, USA

Relocation: Yes

Visa: H1B with passport number

Professional Summary Around 9 Years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment. Strong technical knowledge in MS SQL Server development including SSIS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting. Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server-based applications). Transformed data from one server to other servers using tools like SQL Server Integration Services (SSIS) (2012/2014/2017). Developing reports on SSRS on SQL Server (2008/2012/2014/2017). Understanding of SSAS, OLAP cube and Architecture. Excellent in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all. SQL Server Reporting Services (Generating reports in the form of Tabular, Matrix, Chart and List Data Region from OLTP and OLAP Data bases, grouping and sorting, formatting, parameters including Cascading, Drilldown, Dash Boards, Sub and Linked Reports and Ad-hoc Reports). Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports projects. Experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer Strong analytical problem-solving skills, self-starter with excellent inter-personal skills. Familiarity with issue tracking systems (TFS, JIRA and Cherwell). Add XML configuration files to each package to deal with different servers like Development, Testing and Production. Multi-tasking and ability to work effectively under pressure meeting deadlines as an individual contributor and a committed team player. Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports. Having a basic understanding of SQL Server Analysis Services (SSAS). Having basic knowledge of creating SSAS cubes. Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage. Having exposure on creating and developing PowerBI Dashboards into rich look. Having exposure on writing complex DAX functions in PowerBI and Power Pivot. Used various sources to pull data into PowerBI such as SQL Server, Oracle, SQL Azure etc. Developed Power BI reports and dashboards from multiple data sources using data blending. Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts. Created new measures using various DAX functions like SUM, MIN, MAX, AVG, COUNTROWS, DISTINCTCOUNT. Worked on row level security (RLS) in Power BI. Knowledge of Agile and Scrum methodologies. Developed ETL pipelines using Azure Data factory. Technical Skills Technology TOOLS Operating Systems Windows, UNIX, LINUX Programming Languages T-SQL, PL-SQL, C#, VB Script Database SQL Server 2008/2008R2/2012/2014/2017/2018, Oracle, PL-SQL Tools SQL Server Management Studio, Redgate SQL tool belt, Business Intelligent Studio, Query Analyzer, Profiler, Performance Monitor, SQL Server Agent, Visio, TFS, JIRA, Power BI, Azure Web designing tools Visual Studio, Share Point CI/CD Jenkins, Git Hub, TFS Software Methodologies Agile, Waterfall, Scrum, Kanban Version Control Tools GitHub, Redgate Academic Qualifications & Training: Master s in healthcare informatics from Sacred Heart University, CT 2017 Project Details: Client:Accident Fund Group, Lansing , MI January 20 Present Role: Senior BI Developer / Data Engineer Responsibilities: Created complex stored procedures to accomplish the business requirements. Creating new stored procedures and modifying existing stored procedures. Installation of SQL Server 2019 and database configuration. Created all types of reports using SQL Server Reporting Services (SSRS). Developed packages to handle data cleansing, loading multiple files and executing tasks multiple Times (using for Each Loop) Modified the Existing SSIS Packages and added more audits and alerts in case of package failure Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated Sub query, complex Stored Procedures and ad-hoc TSQL statement. Developed Query for generating drill down reports in SSRS 2017. Designed and implemented stylish report layouts. Used various Guidewire products Claim Center, Policy Center & Billing Center. Gained experience with navigating various Guidewire products Claim Center, Policy Center & Billing Center. Generated Reports using Global Variables, Expressions and Functions for the reports. Identified and worked with Parameters for parameterized reports in SSRS 2017. Developed Power BI reports and dashboards from multiple data sources using data blending. Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts. Explored data in variety of ways and across multiple visualizations using Power BI. Involved in a range of custom Power BI dashboards to help visualize complex data sets, bringing about trend identification and process improvement for stakeholders. Developed multiple robust data models using Power BI. Converted traditional report solutions into Power BI report solutions. Performed data validation to improve the accuracy of data analysis. Strategic expertise in design of experiments, data collection, analysis and visualization. Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for data cleansing and data massaging. Worked on data modelling using Power Query in Power BI. Combined data from multiple sources using Power Query. Created reports using Power BI Desktop and worked with Datasets using Direct query as well as Direct Import from views or Inbuilt SQL. Created new custom measures using several DAX functions for efficient data visualization in Power BI. Worked with different level of filters like report level, visual level filters, page level filters in Power BI. Used Bookmarks feature to allow users to look at saved set of information filtered to certain level in Power BI. Created paginated reports using Power BI Report Builder. Scheduled Automatic refresh and scheduling refresh in Power BI service. Worked on row level security (RLS) to filter data for specific users in a report. Involving deployments and source controls using TFS. Used Azure Event Hubs and Stream Analytics for streaming data analysis. Managed Azure Blob Storage for data storage. Developed ETL pipelines using Azure Data factory. Environment: MS SQL Server 2017/2019, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Excel Macros, TFS, Jira, Confluence, Azure Data Lake Services, Azure Data factory, Power BI. Client:Care Source, Dayton, OH July 19 December 19 Role: ETL/BI Developer Responsibilities: Installed SQL Server 2015/2017 and configured the database. Migrated data from Heterogeneous data Sources (Excel, Flat file, CSV file) to centralize. SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation Constraints. Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to load underlying data into the tables from Text files, Excel file and CSV file. Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop). Modified the Existing SSIS Packages and added more audits and alerts in case of package failure Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated Sub query, complex Stored Procedures and ad-hoc TSQL statement. Identified the Data Source and defined them to build the Data Source Views. Developed Query for generating drill down reports in SSRS 2017. Designed and implemented stylish report layouts. Used Guidewire Claim Center for claim Lifecycle. Generated Reports using Global Variables, Expressions and Functions for the reports. Identified and worked with Parameters for parameterized reports in SSRS 2015 And 2017. Explored data in variety of ways and across multiple visualizations using Power BI. Developed reports by creating custom calculated measures and columns using DAX functions like SUM, MIN, MAX, AVG, COUNTROWS, DISTINCTCOUNT. Strategic expertise in design of experiments, data collection, analysis and visualization. Familiarized with using SVN Repository and TFS Board for issue tracking. Worked on Performance tuning of T-SQL Long Running queries and Stored Procedures Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated Sub query, complex Stored Procedures and ad-hoc TSQL statement. Created dashboards using Power BI using various sources of data like Excel, CSV & SQL Server. Created pie charts and bar charts with various sources of data using Power BI. Environment: MS SQL Server 2014/2017, SQL Server Integration Services (SSIS), Excel Macros, TFS, Confluence, Azure Data Lake Services, PowerBI. Client: Genesys, Daly City, CA April 18 June 19 Role: Data Engineer/POWER BI Developer Responsibilities: Created Technical Specification document. Used Query, SQL, Merge, Case, Validation transforms to transform the data (as needed) before loading into the warehouse tables. Designed analytical reports and dashboards utilizing Power BI Desktop to identify critical KPIs per business requirements. Designed, Developed, Tested, Published and maintained PowerBI Functional reports, Dashboards based on user requirements. Migrated data from on-premises data servers onto Microsoft Azure cloud platform utilizing Azure data factory. Created Partition Tables based upon Partition Functions and Partition Schemas. Created various kinds of reports using Power BI and Tableau based on the client's needs. Created Complex ETL Packages using SSIS which upsets data from staging table to database tables. Published reports and dashboards designed in PowerBI utilizing PowerBI services and shared it across through Microsoft Office 365. Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages. Slight exposure Power BI development experience with desktop and pro versions. Familiarity with Direct Query functionality within Power BI. Experienced in developing and supporting Microsoft BI and reporting capabilities (Power Pivot, PowerBI, Power View, and SQL Server Reporting Services). Experience in writing Direct query, creating relationship between imported entities, derived column, measures, (visual, page and reports) filters, Role level security using DAX functions. Used Row Level Security (RLS) feature to protect data for specific users. Integrated custom visuals based on business requirements using Power BI desktop. Used Power BI performance analyzer to check the performance of the reports and take necessary steps to fix the performance issues. Developed interactive dashboards using Power BI desktop for actionable analytics, comprehensive views of data and thoughtful visualizations enabling business users to better understand data. Developed dashboards with charts, graphs, advanced controls like Gauge using Power BI to make complex information easier to understand and analyze. Developed complex Data models by importing data from multiple data sources as per reporting needs. Maintained existing PowerBI reports and dashboards and made changes onto the same as per new and changing business requirements. Expertise in reviewing/analyzing Software Requirements Specification documents [SRS], Business Requirement Documents [BRD] Responsible for testing to optimize the procedures and triggers to be used in production. Involved in project planning also schedule for database module with project managers. Environment: MS SQL Server 2014/2017, SQL Server Integration Services (SSIS), Excel Macros, VB.Net, Spotfire, Jira, Confluence, AWS EC2, Azure Data Lake Services, PowerBI. Client:DRB Capital, Delray Beach, FL Sep 17 Dec 18 Role: Technology Intern Responsibilities: Installed SQL Server 2017 and configured the database. Overall project documentation and technical flows of SQL Queries. Running Daily normalization scripts to clean and enhance the strategic data set with respect to transport and ETL Functions. Reviewing Requirement documents and creating mappings. Stakeholder data review and walkthrough of proposed changes. Environment: MSSQL Server 2014,2017, SQL Server Integration Service, SQL Server Reporting Services. Client: XFACTOR IT SERVICES, Hyderabad, India August 11 November 13 Role: SQL/SSIS/SSRS Developer Responsibilities: Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS Package. Extensively involved in designing the SSIS packages to load data into Data Warehouse. Involved in creating SSIS jobs to automate the reports generation, cube refresh packages. Extract Transform Load (ETL) development using SQL Server 2008, SQL 2012 Integration Services (SSIS). Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc. using SSIS. Involved in the Production Support of SSIS Packages. Enhancing and deploying the SSIS Packages from development server to production server. Involved in writing Visual C# Scripts in SSIS Packages. Responsible for Designing and Creating SSAS Cubes from the Data Warehouse. Involved in creating SSRS Reports. Involved in gathering the business requirements for the SSRS Reports. Worked on Performance tuning of T-SQL Long Running queries and Stored Procedures. SQL Queries debugging and improvement through analyzing Execution Plan. Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects. Worked with T-SQL to create Tables, Views, and triggers and stored Procedures. Environment: MSSQL Server 2012, SQL Server Integration Service, SQL Server Reporting Services, Windows XP, MS Access, MS Word. Keywords: csharp continuous integration continuous deployment business intelligence database active directory information technology microsoft procedural language California Connecticut Florida Michigan Ohio