Data Analyst

Jyoti Mishra

Seattle, WA ****@******************.*** 609-***-****

SUMMARY

* ***** ** ********** ** Information Technology as a Data Analyst on Data Analysis, Data Manipulation, Data Mining, Data Visualization and Business Intelligence.

Data Analytics experience in SQL,Python, R, & NoSQL Databases and Machine Learning.

Good Understanding of Data ingestion, Airflow Operators for Data Orchestration, and other related python libraries.

Ability to identify and learn applicable new technologies independently as needed.

Proficient in designing and creating various Data Visualization Dashboards, worksheets, and analytical reports to help users to identify critical KPIs and facilitate strategic planning in the organization utilizing Tableau Visualizations according to the end user requirements.

Expertise in building dashboards using Tableau, Power BI, QuickSight

Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, Power BI and Excel to provide better data visualization.

Experience in Project Management best practices, processes, and methodologies (Agile and Waterfall).

Highly experienced at translating business objectives from multiple stakeholders into detailed implementation and project plans.

Active involvement in requirement gathering sessions and helping the developers to understand the user’s requirements.

Ability to tailor communication and presentations to peers in both business and technical areas, to deliver optimal business solutions in line with corporate priorities.

Expert in creating PL/SQL Schema objects like Packages, Procedures, Functions, Subprograms, Triggers, Views, Materialized Views, Indexes, Constraints, Sequences,

Exception Handling, Dynamic SQL/Cursors, Native Compilation, Collection Types Record Type, Object Type using SQL Developer.

Knowledge and experience working in Waterfall as well as Agile environments including the Scrum process and using Project Management tools like Project Libre, Jira/Confluence.

Quick learner having strong business domain knowledge and can communicate business data insights easily with technical and nontechnical clients.

Ability to understand and articulate the “big picture” and simplify complex ideas.

EDUCATION & Certification

Kanpur University -Bachelor of Arts Kanpur, India-May 2015

Certification: Google Data Analytics

TECHNICAL SKILLS

Programming: SQL, MySQL, Redshift

Machine Learning: Data Analysis, Feature Engineering

Big Data and Cloud: AWS EC2, AWS S3

Software: Anaconda Suite, Microsoft Suite(Excel, Word, PowerPoint), GIT, Maven, Tortoise SVN, JIRA.

Database and Visualization: Tableau, Power BI, MySQL, Redshift

PROJECT EXPERIENCE

Blackrock, Wilmington, DE-

Sr.Data Analyst (Remote)

January 2021-Present

Responsibilities:

Use Agile methodology throughout the project. Involved in weekly and daily bases release management.

Implemented and followed Agile development methodology within the cross-functional team and acted as a liaison between the business user group and the technical team.

Responsible for data management (data cleanup, extraction, and update) through SQL, perform analysis, and prospective research to identify KPIs.

Generating various capacity planning reports (graphical) using Python packages like NumPy, pandas, and Matplotlib.

Performed data analysis and data profiling using complex SQL on various source systems including Oracle and Teradata.

Extract data from various data sources and prepare interactive dashboards utilizing various kinds of charts, graphs and filtering data using logical filters and publishing them.

Delivered files in various file formatting systems (ex. Excel file, Tab-delimited text, Comma-separated text, Pipe delimited text, etc.).

Created dashboards using Tableau/Power BI for analysis project by analyzing the historical data and identifying KPIs which had a positive impact on the business.

Develop & maintain Tableau dashboards and KPIs to help identify areas of growth, track changes and provide visibility to stakeholders.

Developed Tableau data visualization using Scatter Plots, Geographic maps, Pie Charts and Bar Charts, and Density charts.

Preparing dashboards using calculated fields, parameters, calculations, groups, sets, and hierarchies in Tableau.

Designed and created various analytical reports and dashboards to help the Senior Management to identify critical KPIs.

Developed Complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.

Performed Data Analysis and Data profiling using complex SQL on various sources systems including MySQL and MS SQL Server.

Architect delivered various complex OLAP databases/cubes, scorecards, dashboards, and reports.

Worked with various Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Stored procedure, and Normalizer.

Prepare the data rules spreadsheet using MS Excel that will be used to update allowed values, findings, and profiling result.

Used Jira for bug/issue tracking and project management purposes.

Indus Infotech

Vangaurd, Philadelphia, PA (Offshore)

June 2017 – July 2020

Data Analyst

Analyzed effectiveness of products based on customer feedback and involved in data collection, cleaning, pre-processing & quantitative analysis to extract useful insights for creating various reports using SQL, Microsoft Excel (using pivot tables, Vlookups, etc) to provide definition, structure and to maintain data efficiently.

Gathered Business requirements from stakeholders and ensured their implementation as mentioned in requirements document and project management, to served 100% deliverable.

Created queries to extract data from SQL Server (Source Database) to Flat Files or Excel files.

Managed and implemented the data extraction and data importing procedure to ensure Data Migration integrity and quality.

interactive data visualizations used across the company .

Conducted meetings with business stakeholders, clients and director level members for requirement

gatherings and presented various solutions using best practices .

Expertise in data preparation with experience in blending multiple data connections, and creating

multiple joins across same and various data sources .

Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs,

Gantt chars, trend lines, waterfall charts, statistical models, heat maps, geo-maps allowing end users to

Excellent SQL skills for daily testing of data using various SQL queries.

Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.

Documented Tableau best practices and performance optimization strategies for power users.

Created users, groups, projects (nested) on AGORA site and provided custom privileges at each level.

Worked with Audit team to define data quality expectation and created automated DQ reports.

Supported BI release team for Self-service releases and provided general systems maintenance.

Wrote complex custom SQL to gather data from multiple databases.

Worked with ETL team to address data needs and expectation from Informatica.

Created Pixel perfect dashboards for Exports functionality in PDF/PPT format.

Redesigned legacy dashboards in addition to creating complex new Tableau reports.

Analyzed data from various databases and formatted it into various visuals using Tableau Desktop.

Designed Technical design document and provided Training plans for business users.

Indus Infotech- (Lineage logistics -Offshore)

Data Analyst

June 2015 – May 2017

Responsible for all project documentations and assisted testing team in understanding the business rules and the system development.

Responsible for ETL Operation which extracts and transforms the data-to-Data Warehouse using Alteryx

Provide ad hoc financial reports and answers to variety finance matrices fluctuation to Management on the daily bases.

Supporting the data warehouse in identifying and revising reporting requirements.

Commissioning and decommissioning of data sets.

Developed Tableau reports and analysis.

Involved in the dimensional modeling of Data warehouse.

Prepared testing documentation including test objectives, test cases and test plan.

Developed standard and Confidential hoc reports using T-SQL, SSRS and presented to Product Manager and Executives.

Designed and developed methodologies and procedures to carry out effective analysis, provided training to the end-users on the new systems implemented.

Maintaining confidential database and information.

Managing and designing the reporting environment, including data sources, security, and metadata.

Processing confidential data and information according to guidelines.

Contact this candidate