Maheswar Gouni

Tableau/Power Bi Developer

ad38cc@r.postjobfree.com

+1-254-***-****

Summary

Analytics Developer with professional experience working with a diverse set of tools and technologies. worked within the agile methodology throughout the software development lifecycle, including analysis, design, development, testing, implementation, and post implementation support as well as within a Test-Driven Development. Skilled in Power BI, Tableau and MicroStrategy. Additionally, well-versed working with Sybase, MySQL, and MS SQL Server on the backend.

Over 10+ years of Data Warehousing experience in Power BI, MicroStrategy, Tableau.

Implement ETL process in Alteryx to extract data from multiple sources (SQL Server, XML, Excel, CSV) and schedule workflows.

Manage end to end complex data migration, conversion, and data modeling (using Alteryx, SQL), and create visualization using tableau to develop high quality dashboards.

Designing the Reports and Dashboards as per client requirement and created the reports using Excel files and different data sources in Power BI.

Imported data from SQL Server DB, Excel to Power BI application to generate reports and dashboards.

Created different types of filters as per requirement of client in Power BI

Modified the existing reports and dashboards in Power BI.

Development using DAX in Power BI to develop dashboards.

Created complex reports utilizing features like Hierarchy, Drill functionality, calculated fields, Parameters, Sets, Groups.

Performance improvement steps on Power BI reports with data validation and verification.

Extensively used ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Talend and designed data conversions from source systems relational sources like flat files, XML and Mainframe Files

Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.

Created different transformations for loading the data into Oracle database e.g. Source Qualifier, transformation, UpdateStrategy, Lookuptransformation, Ranktransformations, Expression, Aggregator and Sequence Generator.

Worked on Mapping Designer, Mapplet Designer, Transformation Developer, Warehouse Designer, Workflow Manager and Workflow Monitor.

Knowledge of Tableau Desktop. Preparing Dashboards using calculations, parameters in Tableau.

Has the ability to effectively manage multiple projects at the same time.

Having good experience in Data Modelling and ETL Process.

Skilled in planning, designing, development and deploying framework models with experience of both relational & multidimensional database design using Data Modeling tool (Framework Manager).

Worked in Waterfall and waterfall Methodologies.

Experience working in JIRA, ServiceNow

Understanding of relational databases like Oracle, SQL Server, Sybase and DB2.

Experienced in managing users, groups, sites, permissions, and roles on Tableau server.

TECHNICAL SKILLS:

BI Tools: Tableau (Desktop/ Server/ Reader), Power BI, Business Objects, MicroStrategy

Data Base: SQL Server, SSAS, SSRS, Excel.

Data Integration Tools: SSIS.

Documentation: SharePoint, Confluence.

ITSM: Jira, ServiceNow

Operating System: Windows8/7, XP, Server 2012/2008/2003 and UNIX/Linux.

Overall Experience 10 Years

Power BI

6 Years 3 Months

MicroStrategy

1 Years 4 Months

Tableau

3 Years 0 Months

SQL

9 Years

EDUCATION:

Bachelors in electronics and communication engineering.

Client: Citibank Oct 2017- Till Date

Citibank is the primary U.S. banking subsidiary of financial services multinational Citigroup.

Worked on various projects in the same organization and got chance to work on different reporting technologies. As part of organization requirement.

Role: Sr Power Bi Developer.

Responsibilities:

Developed Desktop dashboards using Power BI.

Write the required DAX functions using aggregates, logic, date and table functions.

Involved in creating Drill down and Drill through Reports.

Worked on append and merge queries, created new tables and created calculated columns in Power Query.

Working in diverse types of scenarios like conditional formatting, sorting, tool tips and drill though concepts as per user requirement.

Performed data modelling and ETL process.

Created Rich visualized Pie Charts, Tree Map, Tabular and Matrix Reports by using Power BI Service.

Experience in publishing Power Bi reports to Power BI service, connecting to the data from SQL Server.

Extensively worked on Power BI Personal Gateways and Enterprise Gateways.

Developed distinct types of charts like Donut, Funnel, Scatter and Bubble using Power BI.

Worked on complex reports using different techniques such as Calculations, filters and charts using Power BI.

Created reports with page level filters and report level filters using Power BI.

Developed reports according to end user requirements using Power BI.

Worked on complex reports using different techniques such as conditional formatting, page break and drill through.

Modified reports according to end user requirement.

Performance improvement steps on Power BI reports with data validation and verification.

Used filters, parameters, and calculated fields on Power Bi reports.

Environment: Power BI, Report Builder, SQL server, Microsoft Excel.

Client: Bank of America. May 2015 – Sep 2017

Role: Tableau Developer

Responsibilities:

Involved in publishing various kinds of live, interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau servers.

Involved in conducting training to users on interacting, filtering, sort and customize views on an existing visualization generated thru Tableau desktop.

Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Developer.

Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.

Created Tableau scorecards, dashboards, Heat maps using show me functionality.

Created complex data Views Manually using multiple measures also used sort, Filter, group, Create Set functionality.

Published Reports, workbooks & data source to server and exporting the reports in different Formats.

Experience in using URL's, Hyperlinks, Filters for developing Complex dashboards.

Worked on creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.

Worked with Data mapping team to understand the source to target mapping rules.

Analyzed the requirements, framed the business logic, and implemented it using Talend.

Analyzed and performed data integration using Talend open integration suite.

Worked on the design, development, and mappings.

Created triggers for a Talend job to run automatically on server.

Worked on Exporting and Importing of Talend jobs.

Implemented update strategy on tables and used tJava, tJavarowcomponnets to read data from tables to pull only newly inserted data from source tables.

Monitored the daily runs, weekly runs and adhoc runs to load data into the target systems.

Translated business rules and functionality requirements into ETL procedures.

Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy.

Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.

Restricted data for users using Row level security and User filters.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Environment: Tableau, SQL server, Microsoft Excel.

Role: Programmer Analyst

Responsibilities:

Performed reverse engineering to decode QlikView reports into hand-crafted SQL code by

Analyzing each report and documenting the specifications

Accountable for all phases of development process—analysis, design, development, testing and

implementation.

Involved in creating/replicating reports in MicroStrategy based on existing QlikView Reports.

Worked with data modelers and DBAs to ensure functional and non-functional requirements,

implemented properly.

Created MicroStrategy schema and public objects: metrics, filters, prompts, consolidations,

custom groups, facts, attributes, transformations, and hierarchies.

Developed standard reports, Freeform SQL reports and Ad-Hoc Reports (Visual Insights Analysis)

using MicroStrategy Developer/Web.

Created advanced Dashboards with panel stacks, selectors, information windows, complicated.

grids and graphs, customized widgets (time series slider, gauges, bubble graphs) both in flash

and Interactive modes.

Created Transaction Services enabled documents to write back to source data based on analysis.

by business users.

Involved in creating migration packages and deploying them into other environments like UAT

and PROD using object manager.

Performed various admin related tasks using tools like Object Manager, Integrity Manager, and

Command Manager.

Created configuration objects like Security Roles, Database Instances, Schedules and

Subscriptions.

Analyzed and developed partitioning and indexing strategies for performance tuning of

MicroStrategy reports and used intelligent cubes for faster query performance using memory.

cache.

Used Command Manager to automate the whole MicroStrategy administrative tasks including,

purge cache, user management, and trigger reports according to event load.

Troubleshooting MicroStrategy issues by analyzing DSS Error log files.

Involved in various back end ETL development tasks, UAT testing and Production Support.

Environment: MicroStrategy 9.4.1 (Developer, Administrator, Web, Enterprise Manager, Command

Manager, Object Manager), Oracle, Sybase, QlikView

Client: Infosys (India) May 2013 – May2015

Role: Tableau Developer

Responsibilities:

Involved in publishing various kinds of live, interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau servers.

Involved in conducting training to users on interacting, filtering, sorting and customize views on an existing visualization generated in Tableau desktop.

Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Developer.

Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.

Created Tableau scorecards, dashboards, Heat maps using show me functionality.

Created complex data Views Manually using multiple measures also used sort, Filter, group, Create Set functionality.

Published Reports, workbooks & data source to server and exporting the reports in different Formats.

Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards.

Worked on creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.

Created Views, Stored Procedures, and validated data for the Performance.

Developed various types of complex reports like Standard reports, Group reports, Detail and Summary reports, Crosstab reports, Graphical reports, drilldown reports, on Demand and Linked sub reports using crystal reports, tables, views, business views.

Provided daily production support and administration of portal operations, such as problem resolution.

Worked closely with Data Modelers in designing various data warehouse schema techniques.

Worked on the data provider that forms the basis of the ad-hoc analysis.

Analyze business information to identify process improvements for increasing business efficiency and effectiveness.

Participate in cross-functional meetings to resolve recurring customer issues.

Involved in the full systems life cycle and responsible for coding, testing, implementing, maintaining, and supporting applications software.

Worked closely with customers, business analysts, and team members to understand business requirements.

Environment: Tableau Desktop, Tableau Server, SQL Server, SQL Developer.

Contact this candidate