| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Tableau/Power Bi DeveloperEMAIL AVAILABLEPHONE NUMBER AVAILABLESummaryAnalytics 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 BIModified 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 FilesDeveloped 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, ServiceNowUnderstanding 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, MicroStrategyData Base: SQL Server, SSAS, SSRS, Excel.Data Integration Tools: SSIS.Documentation: SharePoint, Confluence.ITSM: Jira, ServiceNowOperating System: Windows8/7, XP, Server 2012/2008/2003 and UNIX/Linux.Overall Experience 10 YearsPower BI6 Years 3 MonthsMicroStrategy1 Years 4 MonthsTableau3 Years 0 MonthsSQL9 YearsEDUCATION:Bachelors in electronics and communication engineering.Client: Citibank Oct 2017- Till DateCitibank 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 2017Role: Tableau DeveloperResponsibilities: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 AnalystResponsibilities:Performed reverse engineering to decode QlikView reports into hand-crafted SQL code byAnalyzing each report and documenting the specificationsAccountable for all phases of development processanalysis, design, development, testing andimplementation.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 flashand 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 UATand PROD using object manager.Performed various admin related tasks using tools like Object Manager, Integrity Manager, andCommand Manager.Created configuration objects like Security Roles, Database Instances, Schedules andSubscriptions.Analyzed and developed partitioning and indexing strategies for performance tuning ofMicroStrategy 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, CommandManager, Object Manager), Oracle, Sybase, QlikViewClient: Infosys (India) May 2013 May2015Role: Tableau DeveloperResponsibilities: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. |
