Home

chatur - DATA ANAYLST

[email protected]

Location: Lucas, Ohio, USA

Relocation: yes

Visa: GC

CONTACT : [email protected] +1 (469)-988-5899 Around 9 years of extensive IT Experience as a Sr. Tableau Reporting Developer, Power BI, SAP WEB Intelligence, Looker Developer & Admin, Data Visualization Engineer (QA), Alteryx operator and Tableau Server Administrator, Business System Analyst, in IT Security, Mass Media, Video Entertainment, Health and Life Insurance, Banking, SCM, Financial and Retail. PROFESSIONAL SUMMARY Around 9 years of experience in working with Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 2019.x/10.x/9.x/8.x/7.x. Performed data analysis, statistical analysis, predictive analysis and generated reports listings and graphs using Excel, SSRS, and Tableau. Experienced in utilizing Salesforce Data Export feature to export data in CSV format. Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps, etc., Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources. Experience in enhancing Tableau Solutions including debugging, monitoring, and troubleshooting issues/tickets. Outstanding knowledge & working experience of slice & dice SSRS, Power BI & Alteryx. Assist end users with problems installing the Power BI desktop, installing, and configuring the Personal and On-Premises gateway, connecting to data sources and adding the different users. Adept at utilizing advanced DAX (Data Analysis Expressions) and Power Query for sophisticated data modeling and manipulation within Power BI. Strong analytical skills to derive actionable insights from Salesforce data visualizations in Tableau. Proven track record of creating insightful visualizations in Tableau to represent Salesforce data effectively. Proficient in Dimensional Data Modeling encompassing Relational Data Modeling, ER/Studio, Erwin, Sybase Power Designer, and Schema Modeling Power BI (Star Join Schema/Snowflake). Versed in SDLC methodologies (Agile, Waterfall), with experience in Technical Design, Development, Testing, and Implementation of Enterprise-level Data marts and Data warehouses. Skilled in Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS). Experience in writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as tables, views, indexes, complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs). Created different visualizations in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc. Also, using different transformation inside edit query into clean-up the data. Excellent knowledge of all the phases of Software Development Life Cycle (SDLC). Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion, and researching complex data problems via API Possesses deep knowledge of Machine Learning, Mathematical Modeling, Operations Research, and proficiency in R, Python, SAS, and Relational Databases. Utilizes SQL, Numpy, Pandas, Scikit-learn extensively for Data Analysis and Model Development. Hands on Experience working with Azure Data Lake Analytics to analyze the structured, non-structured data from various sources. EDUCATION Bachelor of Technology in Electrical Communication from Jawaharlal Nehru Technological University, India. TECHNICAL SKILLS OLAP/Reporting Tools: SSRS, SSAS, MDX, Tableau, Power BI Relational Databases: SQL Server database 2014/2012/2008 R2/2005, Oracle 11g, SQL Server Azure, MS Access SQL Server Tools: Microsoft Visual Studio 2010/2013/2015 , SQL server management studio ETL Tools: Informatica, SSIS, Alteryx Frontend Tools: Microsoft Project, Microsoft Office Document Management: Visual Source Safe 6.0, Share point, Ultra Edit, Documentum, Google Sheets Other Tools: MS Office 2003/2007/2010 and 2013, Power pivot, Power Builder, GIT, CI-CD, Jupyter Notebook. Programming languages: C, SQL, PL/SQL, T-SQL, JAVA, Batch scripting, R, Python Data Warehousing & BI: Star Schema, Snowflake schema, Facts and Dimensions tables, SAS, SSIS, and Splunk Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Serve. PROFESSIONAL EXPERIENCE Client: Huntington bank, Columbus, OHIO. Feb 22 Present Role: Data Analyst- Tableau & Power BI Installed and configured Tableau Server on various environments including Windows and Linux. Implemented best practices for server configuration to optimize performance and ensure scalability. Implemented Looker data transformations using LookML, SQL, and advanced functions to clean, aggregate, and prepare data for analysis, ensuring data accuracy and consistency. Created and managed user accounts, groups, and permissions to control access to Tableau resources. Provided training and support to users on Tableau Server functionality, including publishing, sharing, and collaboration features. Strong experience in connecting Tableau to Salesforce using Tableau Salesforce connector. Demonstrated ability to select relevant Salesforce data for analysis and visualization within Tableau environment. Designed various prototypes of dashboards using Tableau and Power Bi, which would give the ability to the users to plug and play the dashboards. Created Dynamic Dashboards showing Company's yearly performance using various graphs. Created several Custom tables, Views, Aggregations for developing reports used in Power Bi data layer environment. Involved in gathering requirements, conducting analysis, designing solutions, overseeing development, managing changes, and facilitating deployments. Extracted data from heterogeneous sources, applied intricate business logic to normalize raw network data, enabling BI teams to detect anomalies effectively. Responsible for assessing the changes going to PROD and fine tune Tableau server processes, Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets. Developed and maintained LookML models and explores to provide intuitive and actionable insights into business data, facilitating data-driven decision-making processes. Responsible for Deployment of Tableau workbooks to PROD and participate in all the cadence meetings related to the Releases. Responsible for working with Tableau Elite support and resolving any Server or Desktop related issues within Anthem. Wrote T-SQL (DDL and DML) queries, stored procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data. Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI. Indexed processed data, designed dashboards, and generated alerts in Splunk for support teams to utilize and take action upon. Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions. Developed custom Python functions and extensions for Looker to extend its functionality, providing tailored solutions for complex business requirements and analytical needs. Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging. Utilized SQL queries to extract, transform, and analyze CRM data, identifying trends and patterns to support strategic decision-making and business growth initiatives. Using a query editor in Power BI performed certain operations like fetching data from different file. Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements. Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service. Responsible for Go-Live. Once the production data is tested positive for no issues the project and its dashboards will set to go live for intended audience Worked on importing custom visualizations and used various data visualizations with Power BI. Environment: Tableau (Desktop/ Server), Power BI, SSRS, Hadoop, SQL, Oracle, Facets, Informatica, Agile, Jira, Snow, SSMS, Toad Client: Conduent, Raleigh, NC Dec 19 Jan 22 Role: Data Visualization Engineer (Tableau/ Power BI) Understand the Requirements and Functionality of the application from specifications. Integrated Tableau Server with other enterprise systems such as Active Directory, LDAP, and SAML for single sign-on and user authentication. Automated routine tasks and administrative workflows using Tableau Server REST API and scripting languages like Python or PowerShell. Designed, developed, tested, and maintained Tableau functional reports based on user requirements. Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams. Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart. Developed automated workflows and data pipelines to streamline data integration and processing between CRMA systems and other data sources, reducing manual effort and increasing efficiency. Developed and delivered training sessions on CRMA systems and data analysis techniques to empower users across the organization to leverage CRM data effectively in their roles. Implemented row-level security and access controls in Looker to restrict data access based on user roles and permissions, ensuring data privacy and compliance with regulatory standards. Implemented Python-based web services or microservices to interact with Looker APIs for custom data integrations, embedding, or application development. Implemented SQL-based data governance and security measures such as row-level security and access controls to enforce data privacy and compliance in Looker. Engaged in ER Modeling, Dimensional Modeling (including Star Schema and Snowflake Schema), Data Warehousing, and proficient use of OLAP tools. Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets. Responsible for doing final gateway check and ensure we followed all Tableau best practices while building the Tableau dashboards/Reports before the PROD deployment. Performed Research, review, and analyze the effectiveness and efficiency of existing report procedures and develop strategies for enhancing or further leveraging these processes. Created desktop and Mobile dashboards that will help the business to grow their sales rapidly in AMER, EMEA and APAC regions for this project. Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations. Collaborated with stakeholders to gather requirements and translate business needs into technical solutions within the Looker platform, delivering insightful analytics solutions. Utilized Tableau server to publish and share the reports with the business users. Designed and developed impactful Tableau visualizations, skillfully integrating calculations, parameters, calculated fields, groups, sets, and hierarchies to create insightful dashboards. Contributed to the development and maintenance of Looker development best practices and standards, ensuring consistency and scalability across LookML projects. Responsible for managing operations and support across the Big Data Analytics platform, Splunk, and Tableau visualizations. Expert in Power BI modelling, data storytelling and knowledge of how people make decisions with data Performed the role of MS Power BI subject matter expert. Environment: Tableau (Desktop/ Server), BOBJ, Looker (Lookml Development/Desktop/ Admin, Server), Hadoop, HANA Client: Merck Corporation, Rahway, NJ Oct 17 Nov 19 Role: Data Visualization Developer (Tableau Reporting & Admin) Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions. Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle. Working in Agile Scrum Environment. Working on Jira and Service Now Ticketing. Responsible for Administering, Maintaining of Tableau server like Capacity planning, High Availability setup, Scaling, Installs, Upgrades etc. Responsible for gathering reporting requirements from business, do reports prototyping and come up with optimized solutions to implement the requirements. Responsible for design and development of Tableau Dashboards connecting to Oracle, Excel, SQL And Big Data Data-sources. Responsible for doing final gateway check and ensure we followed all Tableau best practices while building the Tableau dashboards/Reports and before the PROD deployment. Responsible for fine tuning Custom SQL queries, Optimizing the workbook calculations, dashboards design to improve the performance. Conducted SQL performance analysis using database monitoring tools to identify and resolve bottlenecks and optimize query execution plans for Looker applications. Good Knowledge on Alteryx designer tool for advance analytics, predictive analysis, data blending etc Responsible for writing the python/batch scripts to automate lot of manual tasks related to Tableau server like Restart, High Availability, Backup of logs, PDF Delivery, extract failure alerts, etc. Responsible for configuring the third party community tools like Tabmon, Tabjolt, Logshark and leverage them for analyzing the server issues. Responsible for querying Tableau repository database and build some useful dashboards for production support monitoring and also to the senior executives. Responsible for coaching junior team members to implement the prototype solutions which were finalized. Responsible for assessing the changes going to PROD and fine tune Tableau server processes, Upgrades, Scale-up or Scale-out of Tableau server. Defined best practices for Tableau report development. Created dashboards and reports for ad-Hoc Reporting. Extensively worked on crystal reporting. Experience in working on sourcing the data from HADOOP platform using scoop. Experience in running queries in HIVE. Configured AWS for Tableau and Installed Tableau Server. Played an important role in coordination with the entire team and managing the time estimates for the entire project. Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts. Worked on PL SQL for UAT testing for financial reports. Provided E2E, Pre & Post implementation Development & Production support (Onsite & Off-Shore). Environment: Tableau (Desktop/ Server), Teradata, Hadoop, SQL developer, MS SQL Server, Oracle, SQL, PL/SQL, T-SQL, Teradata SQL Assistant, Toad, MS Access, Windows 2007 server, Client: Bank of NY Melon, Philadelphia, PA (Offshore from India) May 15 Aug 17 Role: Tableau Developer / Dashboard Reporting Analyst Interacted with business to collect and understand Requirements. Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level. Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents. Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models. Conducted and participated in JAD sessions with the users, modelers, and developers for resolving issues. Performed source data quality assessments and created source to target mapping documentation defining source rules, target rules, and data transformations for various ETL packages in SSIS. Created Data Definitions and help maintain Metadata repository. Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization. Building, publishing, customized interactive reports and dashboards, report scheduling using Tableau server. Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel. Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop. Created customized reports using various chart types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and SSRS. Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to tableau / SSRS. Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps. Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users. Ability to work quickly and under tight delivery deadlines with focus on details. Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards. Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development. Environment: Tableau (Desktop/ Server) , MS SQL Server 2008, Excel, SQL, PL-SQL, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS), MS Office, Visual Studio 2010 Keywords: cprogramm continuous integration continuous deployment quality analyst business intelligence active directory rlang information technology golang microsoft procedural language New Jersey New York North Carolina Pennsylvania