SUMMARY

• Power BI Developer/ Data analyst expert with around 6.5 years of total IT experience. Working as a Report Developer/ Data analyst in a wide variety of projects and skilled in analysis, design, development, testing and implementation in Data warehouses environment using Power BI, Python, ETL (SSIS) and ELT (Azure Data factory).
• 5+ Experience as report developer using multiple reporting tools like Power BI and Tableau visualization tool, also used Python (NumPy, Pandas, Matplotlib, SciPy) / ArcGIS for data analysis
• 2+ years of strong experience in Power BI designed, developed and published multiple advanced visualization report and dashboard in on premises /Azure cloud environment.
• Strong experience in Tableau Desktop, designed and developed multiple advanced visualization report and dashboard in using multiple relation databases like Oracle, SQL server and MySQL.
• Experience of at complete project life - cycles involving SQL Server Analysis Services (Development, Deployment and Maintenance) Cubes (Tabular mode)
• Experience in working with ETL team on Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell
• Experience in working with customers to determine their needs, gather, analyze and document requirements, communicate with customers throughout the development cycle, manage customer expectations, resolve issues and provide project status
• Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL query/ T-SQL /MS excel.
• Hands on Experience in performance tuning and query optimization in different databases like using SQL SERVER 2014/2016, Oracle 10g/11g.
• Proficient in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions.
• Heavily used DAX table functions including filter, all, values, distinct and related table.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
• Strong experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI and Tableau
• Hands on designing and deploying rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized dashboards using Tableau.
• Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI and Tableau.
• Generated context filters and data source filters while handling large volume of data using Power BI.
• Involved in creating Filters, quick filters, table calculations, calculated measures and parameters in Power BI.
• Knowledge and experience with the ESRI ArcGIS suite of GIS products and extensions, including but not limited to ArcGIS, ArcGIS Server, and ArcGIS Online
• Experience in spatial data creation (feature class), editing and conversion using ArcGIS and preferably loading into an ArcGIS Enterprise Geodatabase (versus a personal or file-based geodatabase)
• Knowledge of ArcSDE (ESRI Geodatabase design structure and management), as well as general database knowledge, including the manipulation of spatial and tabular data in GIS, summarizing, joining, and linking related data; Performed
• Experience in Exploratory Data Analysis (EDA) process in identifying continuous/categorical variables, histogram, trendlines, outliers, clustering, missing values, correlation, boxplots, quantiles and data normalization.
• Extensively used web-based ArcGIS Business Analyst to for site selection, customer segmentation and analyzed the data with demographic, income, age, housing, race for suitable retail location.
• Used five-year shapefile data from IPUMPS NHGIS National Historical Geographic Information System for population, Gender, Education level and Race and rigorously analyzed for data visualization using Tableau to observe the percent change and counties with the major changes.
• Created ArcGIS maps and based on client’s requirement and data to identify the contaminated land in compliance with Environmental Protection Agency (EPA) regulations and affected surrounding population and land use.
• Frequently performed geospatial data management using data conversion, changing map projections (longitude, longitude, UTM) and other mapping properties.
• Performed spatial query using Python ArcGIS package ArcPY
• Understanding with handling role-based access for dimensions.
• Experience with Dimensions, Measures, Calculations, Cube design.
• Hands on experience with MSBI (SSIS) to extract, transform and load data into database.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using ETL tools such as SSIS. Experience in testing and writing SQL statements.
• Extensive experience on interaction with system users in gathering business requirements and involved in developing projects.
• Worked on data integration from various source files such as flat files, CSV files, Relational Databases etc. into a common analytical Data Model.
• Performed Unit tests, Integration tests and helped users on Customer Acceptance tests (UAT).
• Ability to deal with people with conflicting needs, prioritize and schedule multiple tasks and work under pressure and a great problem solver and team player.

TECHNICAL SKILLS

Reporting Tools: Power BI Desktop, Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop 8.x/9.x/10.2 Tableau Server, SQL server reporting services (SSRS)

ETL Tools: Azure Data factory, SSIS

Databases: Oracle 10g/11g, MS SQL server 2014/16, MYSQL

Operating System: Windows, UNIX

Languages: Python, C, C++, SQL, PL/SQL, T-SQL

Others: TOAD, Oracle SQL developer, MS Office, FTP, Control-M, Teradata View Point, Teradata SQL Assistant, Rally, JIRA, GitHub, JSON

PROFESSIONAL EXPERIENCE

Confidential, Northfield, IL

Power BI Developer

Responsibilities:

• Coordinated with business user at various levels and call meetings during the different phase of projects to deliver successfully. interacted with Business Analyst, Data Modeler and team Members within the organization to understand business processes, implement the logic.
• Created Reporting Design Document from business requirements document (BRD).
• Created source to target mapping sheet for report.
• Analyzed the existing business logic to determine the reusability of the code.
• Read data from multiple source like CSV/SQL Server 2016/AZURE SQL DB through Power BI for creating Dashboards/ Reports.
• Worked with ETL team to build data transformations with SSIS including importing data from files, moving data from one database platform to another; helps build star schema data marts.
• Implemented context filters and data source filters for handling large volume of data.
• Created multiple data model with Power BI and used as a common data source for generating multiple reports.
• Worked with different types visualizations like Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts Waterfall and funnel charts, Gauges and single-number cards, Z-order, Visual hierarchies and drill-down in the reports.
• Used Power Pivot to create powerful data model and created power view for dynamic reports.
• Utilized DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions.
• Have refreshed/republish reports and data set manually.
• Created various views using Power BI (Tree maps, Scatter plot).
• Created calculated tables, Dimensions, calculated columns and measures.
• Developed Microsoft Analysis Services cubes (Tabular) for performance improvement.
• Wrote SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Created report test cases using different scenarios to verify each KPI; also involved in UAT.
• Developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.
• Optimized report performance and tuned SQL queries so that report can run faster.

Environment: Power BI Desktop 26, Power BI Service, Power BI Gateway, Power BI Report Server, SQL Server 2014, MySQL, AZURE SQL DB, SSAS, Advance Excel, SQL, T-SQL, SSIS

Confidential, Irving, TX

Sr. Power BI Developer

Responsibilities:

• Worked closely with Business Analyst, Data Modeler and all team within the organization to understand business processes.
• Involved in ETL processes and develop source-to-target data mappings, integration workflows, and load processes.
• Analyze source system data to assess data quality. Work with technical and business representatives to determine strategies for handling data anomalies that are identified. Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes. Design, develop, and implement enterprise-class data warehousing solutions.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Read source data from Azure SQL DB, CSV, ORACLE 11g, SQL Server 2016. through Power BI.
• Read different formats of Source data from hive like JSON, ORC, TXT.
• Generated context filters and data source filters while handling large volume of data.
• Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions in source data.
• Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
• Have used Z-order to overlap the reports on each other using Power BI.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
• Created multiple data model and used as a common data source for the reporting purpose.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.
• Created Row level security so based on role, the end user can view the data.
• Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.
• Created no of views, calculated tables, calculated columns and measures.
• Hand on Experience in Unix to write basic commands

Environment: Microsoft Power BI 2.6, SSIS, SQL Server 2016, ORACLE 11g, UNIX

Confidential, Dallas, TX

Tableau developer

Responsibilities:

• Worked with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the business needs.
• Discussed with team to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance.
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Participated in building and visualizing dashboards using Tableau Desktop
• Used Tableau to generate Tableau combination dashboards and wrote SQL Queries for testing the tableau report/dashboard.
• Implemented Extract filters, Calculation Filters, Context filters, Data source filters to exclude certain values or a range of values as well as batter performance.
• Created story using sequence of worksheets to convey information using Tableau.
• In Tableau dashboards used different bars and charts like stack bars, bar graphs, scattered plots, Gantt charts.
• Blended data from multiple sources like SQL Server 2014, PostgreSQL, oracle 10g, Teradata into one report by selecting primary keys from each database for data validation.
• Have done advance analysis, through field calculation, table calculation as well as also involved in forecast analysis.
• Used different functions like number, string, date, Type conversions, aggregate functions.
• Created performance recording to improve Tableau’s performance.
• Effectively used data blending feature in tableau desktop
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Written complex SQL queries to read data from source databases like Teradata and SQL Server
• Modified existing Unix shell script to automate the process.

Environment: Tableau Desktop 9.0, Tableau Server, MS Office Suite, Oracle 10g, Teradata 14, Unix, SQL Server 2014