| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate
Candidate's Name
Data AnalystEMAIL AVAILABLE | PHONE NUMBER AVAILABLE
LINKEDIN LINK AVAILABLESUMMARY: Over 5+ years of experience in IT Industry. Expertise in the field of Business Intelligence (BI) Analytics, Reporting & Dashboard development using Tableau. Experience in gathering Business requirements, Analysis, Design, Implementation, and documentation of various functionalities of Data marts and Business Intelligence. Hands on experience in following the SDLC methodologies like Waterfall model and Agile model. Deep technical knowledge of both Tableau Desktop and Tableau Server from an administrative and a consultative standpoint Some Alteryx Admin Work, District, Workflows, Collection, Private Studio, Controller Server Set up. Strong experience in Data warehouse, ETL, and PL/SQL concepts. Have very good working knowledge on Java Scripting and SQL stored procedures. Extensive Experience in analysis, modelling, design, and development of Tableau reports and Dashboards for analytics and reporting applications Strong experience in Retail, CPG/FMCG/Food Industry (Manufacturing and Distribution), High Tech, Rail Car Manufacturing, Automobile, Manufacturing, and Steel (Metals Forming and Manufacturing) industries. Extensive experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory, Power BI, Azure Databricks, Azure Analysis Services, SQL Server Integration Services, SQL Server Reporting Services and Tableau. Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts and publishing them to tableau server and tableau Online. Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines. Mastered in different formatting techniques, using Annotations and Mark Label. Developed effective and interactive Dashboards using Parameters and Actions. Setting the user permissions in Tableau Server. Extensive experience in Data Mining solutions to various business problems and generating data visualizations using Tableau, Power BI, Birst, Alteryx. Designed, developed and implemented Power BI Dashboards, Scorecards KPI Reports. Legacy Informatica logical code migrated into Informatica Intelligent cloud services (IICS) using Snowflake DB and cloud services. Worked on creating the Alteryx workflows to trigger Tableau data sources. Experienced in writing complex SQL Queries involving various tables using SQL joins and writing Sub Queries. Experienced in writing complex-SQL Stored Procedures and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity. Proven Experience in performance tuning and optimization of SQL queries Have exceptionally good working knowledge on SQL stored procedures. Experience in developing and debugging Stored Procedures and Triggers. Unit Test Python library was used for testing many programs on python and other codes. Significant knowledge and experience in various Database Systems MS-SQL Server, Oracle, Sybase, DB2, Middle-Tier systems like Informatica and Java applications Involved in the Creation of Key Performance Indicators for an Organization and evaluated the performance of the Organization using KPIs in Tableau. Proficient in designing and deploying rich Graphic Visualizations with Drill Down and Drop-Down menu options using Tableau. Produced attractive visuals/dashboards to convey the story inside the data. Working knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau. Well experienced in Mainframe application design, development, testing implementing using COBOL, CICS, DB2, VSAM, JCL and testing IMS based applications Experienced in developing web-based applications using Python, Django, PHP, C++, XML, CSS, HTML, DHTML, JavaScript and jQuery, MVC3, RESTful, RUBY, AJAX Views and Templates were developed with Python and to create a user-friendly website interface Django's view controller and template language is used.Technical Skills:WORK EXPERIENCE:Data Analyst February 2024 Till NowGrant Thornton, New York City, NY
Responsibilities: Participated in requirements gathering and translate business requirements into report visualization specifications design documents. Effectively utilized features and Best Practices of Tableau and visual analytics to maximize impact and utility of visualization products. Involved in Architecting and developing the Azure data factory pipelines by creating the datasets and source and destination connections to move the data from oracle database to Azure Data Lake Data Lake Store Raw Zone. Experience with Tableau reporting/data visualization tool and integration between Alteryx and Tableau. Developed the Canvas application in Power Apps to automate the manual data entry application. Hands-on experience in designing and developing cloud solutions based on Microsoft Power Platform using Power Apps, Power Automate, Power BI, Power Apps Portal and Common Data Service (CDS). Experienced in using Python for Exploratory Data Analysis (EDA) by analysing data sets to summarize their main characteristics and then Visualization the findings using Jupiter Hub. Design and develop business intelligence dashboards, analytical reports and data visualizations using power BI by creating multiple measures using DAX expressions for user groups like sales, operations and finance team needs. Published and maintained workspaces in Power BI Service, allotted the time refresh for the data, maintained the apps and workbooks. Involved in the Data warehouse, Data modelling based on the client requirements. Designed standardized Data Mart with aggregated data, calculated metrics to suffice the source data need for various Tableau Reports and worked with ETL, DBAs, Data Modelers to implement the same in Development, Test and Production environment. Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using roles. Worked on data shaping, transformation, and modelling in Power BI using DAX and Power Query Editor. Created reports in Power BI using Power Query, DAX Functions, visuals (Charts, Graphs, KPIs, Maps, Gauges, Power KPI, Matrix etc.) developed and dashboards. Experience driving cross - functional analytics projects from beginning to end: question formation, data model design, exploratory data analysis (EDA), validation, analysis, machine learning, visualization, and presentation. Assisted Supply chain analysts with automating reporting functionality using Power BI tools Power BI reporting, Dashboards Scorecards (KPI) and MySQL, AWS Data warehouse data sources. Experience in Power BI to design Interactive Reports using Power Query, Power Pivot and Power View. Created and administrated workspaces for each project on Power BI service and published the reports from Power BI Desktop to Power BI Services workspace Extensive back-end support for many various reports on Tableau and Power BI. Integration knowledge between multiple modules in SAP such as IM, WM and MMEnvironment: SQL, Tableau, Spark, Data Lake, MS Outlook, Celonis, Business Object, Snowflake, Power Automate-MS Flow, Epicor, Azure, Alteryx, NLP.MS SharePoint, Jupiter, MS Power Point, SAP HANA, MS Word, EDA, MS Excel, MS Access, Oracle.Graduate Assistant January 2023 December2023Chicago State University, Chicago, IL
Maintained databases using tools like SQL and Excel to organize, store, and retrieve data efficiently for academic research.Maintained records of student attendance, grades, and other academic performance metrics, ensuring accuracy and compliance with university policies.Collaborated with faculty on research projects, contributing to data collection, analysis, and the preparation of research papers.Managed the online learning platforms (e.g., Moodle) by uploading course content, managing student submissions, and tracking student progress.Designed and developed data visualizations using tools like Tableau, Power BI, and Matplotlib to present findings in a clear and compelling manner.Worked closely with faculty members to develop course content and assessment materials, ensuring alignment with academic standards and learning objectives.Data Analyst January 2019 June 2022Swift Technologies, India
Responsibilities: Extensively participated in discussions of BI team with business team and BA to get requirements. Involved in enhancements for existing dashboards by optimizing the workbooks. Created a Supply Chain Dashboard using Tableau in which the Order Booking and Shipments were visualized at each step. Validated data by comparing the data with different data sources using EXCEL and fixed the data issues. Created user training documents to educate the Users to make the use of Tableau Dashboards effectively Execute Disaster Recovery tests for Mainframe DB2 Monitor and fix the DB2 and IMS Issues in the environments Run Production unloads from DB2 and IMS databases and load them to all the environments Extensive use of SQL queries for loading data and creating data extracts. Analysing the customer retention details based on regions and customer segments using bar charts and tree maps. Performed troubleshooting, fixed and deployed many Python bug fixes of the two main applications data were a main source of data for both customers and internal customer service team. Maintain the data integrity in SAP by tracking asset dispositions, performing inventories, and updating SAP for all specified sites Created dashboards for analysing POS data using Tableau on top of SAP HANA. Knowledge of designing and deployment of Hadoop cluster and different Big Data analytic tools including Hive, HBase, Oozie, Sqoop, Flume, Spark, Impala, Cassandra. Create Service Notifications in SAP for Customer Support Engineers to perform instrument installs, disconnects, reconnects and repairs at Merck customer sites As a subject matter expert, I created and developed operational security process, which includes standard and procedure based on current cyber threats landscape to improve security controls and business performances. Participated in the US Region Order-to-Cash project which included writing, developing, executing, and validating UAT test cases in SAP for Sales Order Management (SOM), per requirements. Worked on various internal projects for different departments like QA and Sales Team Organized user demos on Tableau server features like printing workbooks and email subscriptions Created Tableau workbooks using Oracle as data source. Performed tuning of SQL queries to optimize the dashboards. Created dashboard-using parameters, sets, groups, and calculations. Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.Environment: Postman, DB2, Informatica PowerCenter 9.7.1, Spark, Query serge, TFS, HP ALM, ETL, SQL, Java, JIRA, GIT.Education :Chicago State University | MS Computer Science December 2023Major: Computer Science | GPA: 4.0RSR Engineering College | Bachelors Computer Science May 2019Major: Computer Science |
