SUMMARY

• Over 7+ years of IT experience with expertise in analysis, design, development and implementation of data Warehouses, data marts using Power BI, Tableau, ETL Tool (SSIS) and RDBMS like Oracle 10g/11g, MS SQL Server2014/16.
• Experience as a report developer using Power BI and Tableau visualization tool also used SSIS for data integration prospective.
• Experience in Power BI 2.5x/2.7x designed, developed and published multiple innovative visualization report and dashboard in MS SQL Server/Azure cloud environment.
• Experience in Tableau 8x/9x, designed and developed multiple advanced visualization report and dashboard in using MySQL, Teradata etc.
• 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 and Teradata 15.
• Hands on experience 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 RELATEDTABLE.
• 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.
• 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.
• Wrote Phyton script for Phyton visuals in Power BI report. Rscript visual for few reports in Power BI report.
• 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.
• Extensive experience in the testing environment, which included User Acceptance Testing (UAT), functional testing, system testing and defect tracking using Clear Quest.
• Adeptness to organize information, communicate and present research findings in a clear and useful manner.
• Proactive team player with capability of handling responsibilities independently as well as in a team environment and displayed strong analytical, problem-solving skills and document function/process flows.
• Good communication skills interpersonal skills and proven ability to perform both as an individual and as a team player.

TECHNICAL SKILLS

Reporting Tools: Power BI Desktop (2.68), Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop 8.0/9.3 Tableau Server, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS).

ETL Tools: SQL Server Integration Services (SSIS).

Databases: Oracle 10g/11g, MS SQL server 2014/16, Teradata 15, Azure SQL DB

Operating System: Windows, UNIX

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

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

PROFESSIONAL EXPERIENCE

Confidential, MA

Sr. Power BI Developer

Responsibilities:

• Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) with the help of ETL process.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Build GSHS Reports in Power BI from scratch.
• Developed various solution driven views and dashboards by developing different chart types includingPie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.
• Developed various dashboards to know the risk factors, and risk behaviors.
• Created dashboard forRetail system financial informationwhich includesrevenue and expenditure by district.
• Written some Java script plugin that makes the polygons work like hyperlinks.
• Specialized in transforming data into user-friendly visualization to give business users a complete view of their business usingPower BI.
• Used various sources to pull data intoPower BIsuch as SQL Server, oracle.
• Involved in installation of Power BI Report Server.
• Developed reports to visually explore data and create an interactive reportExcel and Power BI.
• Using a query editor inPower BIperformed certain operations like fetching data from different file.
• Createdgroups, content packs.
• Created the KPI to show the difference between actual and forecast data.
• Working with import and direct query, creating custom table in thePower BI.
• Merge queries and append queries, remove columns and split columns, choosing required columns in the data.
• By usingPower BI desktopconnected to various data sources, working with different visualizations.
• Developed and published reports and dashboards usingPower BIand written effectiveDAXformulas and expressions.
• UtilizedPower QueryinPower BItoPivot and Un-pivotthe data model for data cleansing and data massaging
• Created severaluser rolesandgroupsto the end - user and providedrow level securityto them.
• CreatedPower BI Reportsusing the Tabular SSAS models as source data in Power BI desktop and publish reports to service.
• Worked on importing custom visualizations.
• Worked withtable and matrix visuals, worked with different level of filters likereport level, visual level filters, page level filters.
• Used various data visualizations withPower BI.
• Created reports utilizingSSRS, Excel services, Power BIand deployed them onSharePoint Serveras per business requirements.
• Designed different types of KPI's for percentage growth in different fields and compared over the period of time and designed aggregations and pre-calculations in SSAS.
• Involved in designing partitions in cubes to improve performance using SSAS.
• Created Tabular modelreports to slice and dice huge volumes of data.
• Using Tabular modelprovided more security to data atRow level.
• MDX programming,DAX expressions, analysis and business forecasts.
• Implemented OLAP cubes, facts, and dimensions for providing summarized and aggregate views of large database sets.
• Superior involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud usingPower BI desktop.
• Creating reports from importing, direct query and live data from several data sources.
• Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, date & time column.
• Experience in combining data from different sources by using ofpower query.
• Experience with, power pivot and dashboard designer.
• Troubleshoot and support reports inPower BI workspaceswhenever there are issues in production.

Confidential, CA

POWER BI Developer

Responsibilities:

• Collaborated with the project team to outline project requirements in JRD meetings.
• Profiled the legacy database tables using T-SQL queries to provide data cleansing issue reports to the client.
• Developed data reconciliation SQL queries to validate the overall data migration.
• Formulated DAX Expressions create Date to yearly columns and implemented partitions in Tabular Models for Power BI.
• Used recently introduced Power BI to create self-service BI capabilities and use tabular models.
• Wrote DAX expressions to create new measures, calculations per business requirements.
• Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
• Analyzed the data using Statistical features in Power BI to develop trend analysis.
• Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.
• Successfully integrated custom visuals based on business requirements in Power BI desktop.
• Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.
• Created complicated reports such as parameter-based reports, graphical reports, excel reports, drill-down chart and tabular reports using SSRS.
• Created different data visualizations using Lines, Pies, Histograms, Maps, Scatter, and Bullets using Power BI.
• Wrote Phyton script for Phyton visuals in Power BI report.
• Administrated and scheduled data-driven mailing subscriptions on SSRS Reporting Server.
• Delivered reports with subscription functions in SSRS.
• Generated and scheduled on-demand reports for business analyses and management decisions with SSRS.

Confidential, NY

POWER BI Developer

Responsibilities:

• Participated in the user requirement gathering and Design meetings.
• Worked closely with Business Analyst, Data Modeler, and all team within the organization to understand business Processes.
• Participate in Microsoft SSIS ETL Framework to perform tasks synchronously and/or asynchronously.
• 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, transforming and loading data into the data warehouse.
• Experiences in various types of tasks like Execute SQL Task, For each Loop Container Task, Sequence Container, Data Flow Task, File System Task, Execute Package Task, Bulk Insert Task, FTP Task and Send Mail Task on control flow and data flow in SSIS and Implementing like Conditional Split, Lookup, Merge, Merge Join, Multicast, Union, Row Count, Fuzzy Grouping and Checkpoint, Transactions in SSIS.
• Read source data from Azure SQL DB, CSV, and SQL Server 2016. Through Power BI.
• Generated context filters and data source filters while handling a large volume of data.
• Hands-on experience in utilizing DAX functions which includes Aggregation, Counting, and Logical, information, Text and date functions in source data.
• 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 data 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 a year to date (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, Moving files from HDFS to local and vice versa.

Confidential, CA

SQL Server BI Developer

Responsibilities:

• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager
• Created reports by retrieving the data from cube using MDX reports.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed MDX queries to retrieve data from SSAS cubes.
• Prepared the complete data mapping and Report Definitions for the project which involved around 33 reports.
• Worked on Huge Data Transfers from & to SQL Server Database.
• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Created reports by retrieving the data from cube using MDX reports.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed MDX queries to retrieve data from SSAS cubes.
• Designed high level ETL architecture for overall data transfer from OLTP to OLAP with the help of SSIS.
• Performed operations like Data reconciliation, validation and error handling after extracting data into SQL Server.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
• Prepared the complete data mapping and Report Definitions for the project which involved around 33 reports
• Worked on Huge Data Transfers from & to SQL Server Databases using SSIS, and used configuration files and Environment variables for production deployment.
• Created necessary steps to enhance user response time by improving queries and their index selections to minimize
• Enhancing the SSIS Packages and deploying from development server to production server.