Data Analyst Business Intelligence
Resume:
CAREER OBJECTIVE
Results-driven Data Analyst with 5+ years of experience in extracting actionable insights from complex datasets to drive strategic business decisions. Proficient in data mining, statistical analysis, and data visualization, with a strong background in using tools like SQL, Python, and Tableau.
PROFILE SUMMARY
5+ years of IT experience in Business Analysis, System Analysis, Data analysis, Software Design, and Development.
Implementation and Maintenance of Business Intelligence and across Agriculture, Airline Services, Banking and Retail domains
Passionate individual successful at undertaking complex assignments and delivering promising results
Skilled in data analytics, business analysis, R programming, Python, ETL design, front end development and analytical reporting.
Highly Proficient in Agile, Iterative, and Waterfall and Scaled Agile Framework (SAFe) software development life cycles.
Well acquainted with SDLC, STLC and QA processes.
Proven expertise in functional, integration and regression testing for UI and back-end. Expert in Data Visualization, Data Analysis, Business Intelligence, IT Analysis/Design, and Client/Server System Architecture.
Expert in designing and developing analytical reports, dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data by integrating data from multiple sources and help users to identify critical KPIs and facilitate strategic planning in the organization.
Strong knowledge in SQL using SQL Server and Oracle databases. Worked in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Pipeline Pilot.
Proficient in analysis, design and implementation of data warehousing/ BI solutions using Tableau, Spotfire, Alteryx, Pipeline Pilot, Informatica, MicroStrategy and Database technologies.
Worked with TIBCO Spotfire to communicate and update business information. Involved in Performance Tuning and Deployment of TIBCO Applications. Excellent knowledge in designing and developing dashboards using TIBCO Spotfire by extracting the data from multiple sources (Flat files, Excel, Access, SQL server, Oracle).
Good understanding of Tableau Desktop architecture for designing and developing dashboards.
Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
Knowledge of data mapping/migration, Cleansing, Profiling and Data Governance.
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.
Hands-on experience using Dimensional Data Modelling, Star Schema Modelling, Snow-Flake Modeling, Fact and Dimension Tables, Physical and Logical Data Modelling.
Possess strong knowledge of database management in writing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
Adept in analyzing bugs, interacting with team members in fixing errors and User Acceptance Testing (UAT) and assisted in post-production support.
Implements methods for inspecting, testing, and evaluating product and equipment accuracy to ensure precision in production processes.
TECHNICAL SKILLS
Analysis Tools: Tableau, TIBCO Spotfire, Power BI, MS SSRS, MS SSAS, MS Excel (VBA, VLOOKUP, Pivot tables)
Data Integration (ETL) Tools: Alteryx, Pipeline Pilot, Informatica, MS SQL Server Integrated Service (SSIS)
Project Management: SDLC - Waterfall & Agile methodologies, project life cycle, MS Project 2013, JIRA
Programming: SQL, PL/SQL, Python, R-Script, C#, CSS, HTML, JavaScript, jQuery
Application Software: MS Office, Eclipse, MATLAB, Visual Studio, MS Excel advance, MS Access, MS Visio, Toad Oracle
Manual Testing: Requirement analysis, Test scenario design, Test case design, Test data management, Test Execution, Database testing, Regression testing and Defect tracking
Google Apps Scripts: Automation of Google Sheets, Documents, and other Applications
Google Looker/Google Data Studio: Reports and dashboards
Google Sheets: sheet setup, advanced functions, pivot tables
Google BigQuery: SQL Data Warehouse
Other: Product Issue Investigations, Quality Standards Development, Procedure Formulation, Junit, Proboscis,VBA script, Payment Services Business Knowledge,Autosys, Detail Oriented, Time management, Problem solving, Analytical thinking, Value Management, construction cost forecasting
WORK EXPERIENCE
Client: PayPal, Austin, Texas, USA Apr 2023 - Present
Role: Data Analyst
Description: PayPal Holdings, Inc. is an American multinational financial technology company operating an online payments system. Developed and optimized interactive dashboards and reports to support data-driven decision-making, enhancing visibility and operational efficiency through advanced data visualization and migration strategies.
Responsibilities:
Learnt about the structure of the company and the process of workflow in Confidential.
Worked in the Confidential Risk Management team as a data architect.
Analyzed requirements, developed and debugged applications using BI tools
Performed data mining on large datasets to uncover patterns and trends, supporting the Risk Management team in enhancing fraud detection and operational efficiency.
Interacted with the users and business analysts to assess the requirements and performed impact analysis
Used agile software development with Scrum methodology.
Involved in Data migration from traditional databases to Cloud.
Designed and maintained Spotfire and Tableau visualization dashboards on daily basis to facilitate Field testing all over North America
Experience with Spotfire application performance monitoring, capacity planning, and tuning of the Spotfire environment.
Strong experience in creating sophisticated visualizations, calculated columns and custom expressions.
Demonstrated experience building dashboards: Developed interactive dashboards in Tableau and TIBCO Spotfire, integrating data from various sources to enhance visibility and support data-driven decision-making.
Developed Map Chart, Cross table, Bar chart, Tree map and complex reports which involves Property Controls, Custom Expressions. Created a multi-page report dashboard in Google Looker (Data Studio) using Google BigQuery data.
Built BigQuery SQL queries and views for Google Looker.
Utilized regulatory reports and compliance-related data analysis, ensuring alignment with financial regulations (e.g., AML, KYC, SOX compliance).
Extensively used Spotfire and Tableau to create data visualizations enabling prescriptive operations and increasing data visibility.
Developed various new reports using complex Spotfire dashboards by using the key concepts filtering scheme, data on demand, Property Controls, text areas in TIBCO Spotfire reports
Created Information Links for many databases for populating data into Visualization from underlying databases such as Sql Server and Oracle.
Utilized Payment Services Business Knowledge in-depth knowledge of payment services to optimize transaction workflows and ensure regulatory compliance.
Extracted data from AWS cloud and used in pipeline pilot and created reports in Spotfire and Tableau.
Built scalable pipelines, model deployments and reusable protocols using pipeline pilot to support daily operations
Migrated couple of reports from Spotfire to Tableau, Power BI and Superset.
Preparing reports, extracts and integration of existing data as needed to support analysis, visualizations, and statistical models.
Extensively worked on designing and creating the dashboards. Also, automated Dashboards to help end users to identify the KPIs and facilitate strategic planning in the organization.
Used data blending for reading data from different data sources, while designing dashboards.
Created ad-hoc SQL queries for customer reports, executive management reports. Created Dashboards in Tableau based on the user requirement for AML.
Implemented and managed job scheduling and automation using Autosys, improving workflow efficiency and ensuring timely execution of critical batch jobs.
Created affinity analysis dashboard and Radical charts for better understanding data. Published reports to the server and given authentications to the users.
Used VBA Script in MS Access to automate customized report generation by pulling data from multiple tables, formatting it, and exporting it to PDF. This automation streamlined the reporting process, reducing manual effort and improving accuracy and efficiency.
Extensively worked on Tableau dashboards optimization for better performance tuning.
Analyzed scripts in Teradata and created new queries in Snowflake using SQL Workbench.
Environment: Tableau Desktop 10.1.3, Oracle SQL Developer, SQL Workbench, Snowflake, Teradata, AWS S3 and Jira
Client: HF Sinclair, Dallas, Texas, USA Mar 2022 - Mar 2023
Role: Data Analyst
Description: HF Sinclair Corporation (HF Sinclair) is a diversified energy company that manufactures and sells products. Played a key role in developing and optimizing data models and visualizations to enhance operational efficiency and support decision-making processes through comprehensive analysis and effective user collaboration.
Responsibilities:
Led the development of prescriptive data model to optimize operations and increase packaging efficiency
Analyzed requirements, developed and debugged applications using BI tools
Interacted with the users and business analysts to assess the requirements and performed impact analysis
Used agile software development with Scrum methodology.
Worked in coordination with clients for feasibility study of the project in Spotfire and with DB Teams for designing the database as per project requirement.
Applied construction cost forecasting, accrual reporting, Earned Value Management (EVM), and conducted application for payment reviews to support accurate financial tracking and construction scheduling in project management.
Produced databases, tools, queries and reports for summarizing and root causing failure data.
Designed, developed, tested, and maintained Spotfire reports based on user requirements.
Demonstrated experience building dashboards: Developed interactive dashboards in Tableau and TIBCO Spotfire, integrating data from various sources to enhance visibility and support data-driven decision-making.
Extensively worked on Tableau dashboards optimization for better performance tuning.
Extensively worked with various functionalities like context filters, global filters, Drill-Down Analysis, Parameters,
Background images, Maps, Trend Lines and created customized views, conditional formatting for end users.
Assisted report/visualization developers and statistical modelers in filtering, tagging, joining, parsing, and normalizing data sets for use in reports & analytical models.
Extract, transform, and load data from a variety of data sources into staging datasets and ultimately into visualization tool. Extracted data from Airtable using Google Apps Script for review and cleanup.
This data was ultimately moved into Google BigQuery.
Worked on Data blending, Data preparation using Pipeline pilot for tableau consumption and publishing data sources to Tableau server. Created scripts in Python and R for calling APIs through Insomnia and Postman.
Developed custom SQL connections and calculated fields within the environment to facilitate automated production of data visualizations.
Provided production support to various tools and created tickets in Jira.
Environment: TIBCO Spotfire 7.x, Tableau 10.x (Desktop/Server), Pipeline Pilot, Alteryx, Oracle, SQL Server, MS SQL, AWS, Python, R- Script, Power BI, SharePoint, APIs, Insomnia, Postman, Jira, MS Office Suite (Word, Excel, PowerPoint)
Client: Thomson Reuters, Hyderabad, India Jan 2021 - Nov 2021
Role: Junior Data Analyst
Description: Thomson Reuters Corporation is a Canadian-American multinational information conglomerate. Contributed to the full project lifecycle by gathering business requirements, developing data models, and creating analytical reports to support data-driven decision-making and improve business intelligence strategies.
Responsibilities:
Involved in full project lifecycle of SDLC and coordinated with all project teams.
Interacted with Subject Matter Experts and End Users and gathered business requirements. Analyzed requirements, developed and debugged applications using BI tools
Acted as a Liaison between Business Intelligence and Business User groups to relay change requests. Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
Developed Logical data model using Erwin and created physical data models using forward engineering.
Translated business and data requirements into Logical data models in support of Enterprise Data Models, OLAP, Operational Data Structures and Analytical systems.
Involved in collection and cleaning of large amount of unstructured data using Excel and python.
Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
Created extracts and scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
Developed dashboards with interactive views, drill downs and published them to the portal with user level security.
Developed various reports using Tableau features like Parameters, Filters, Sets, Groups, Actions, etc. to present users with various scenarios of predictive analysis.
Generated guided navigation links for Interactive dashboards in Tableau.
Developed reports to analyze multiple measures using Blended Axes and Dual Axes.
Created and updated custom SQL scripts to serve as data sources for various reports and handled performance issues effectively.
Environment: Tableau 10.x/9.x/8.x (Desktop/Server), Alteryx, Erwin, Oracle, SQL Server, Python, SSIS, SSRS, MS Office Suite (Word, Excel, PowerPoint)
Client: UBS, Hyderabad, India Mar 2019 - Dec 2020
Role: Junior Data Analyst
Description: UBS Group is a multinational investment bank and financial services company. Involved in creating and administering data visualizations and reports, optimizing performance, and providing production support to improve data-driven decision-making.
Responsibilities:
Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau. Also, involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
Worked closely with all team members in implementing Tableau BI tool in all IT projects.
Generated reports using SQL queries and published them to users in online thru Tableau server.
Involved in generating Daily/Weekly Sales and Finance trending reports using Tableau by identifying the dimensions, measures, measure values and level of details for Business Analytics and Top Executives to give an overview current Trends. Worked on Donut chart, Bubble chart, drill down analysis using tableau desktop.
Involved in publishing of various kinds of live, interactive data visualizations, dashboards. Reports and workbooks from Tableau Desktop to Tableau servers.
Used Hadoop, HDFS, MapReduce, Hive, Pig and Spark to manage data processing in AWS (EMR).
Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
Provided post implementation production support.
Environment: MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL, Power Designer, Informatica, HDFS, PIG, HIVE, Map Reduce, Linux, HBase, Flume, Sqoop, Matlab, SAS
EDUCATION
Masters in Computer Science from Wichita State University, USA
Bindu Kari
Data Analyst
***********@*****.***
Contact this candidate