Data Analyst Python

Karan Shetty

Data Analyst

SUMMARY

Data analyst with 3+ years of experience in data analysis and data management, has proven ability to work efficiently in both independent and teamwork environments.

3+ years of IT experience as a Data Analyst, including profound expertise and experience on statistical data analysis such as transforming business requirements into analytical models, designing algorithms, and strategic solutions that scales across massive volumes of data.

Experience as a Data Modeler, Data Analyst with more than 3 years of experience in all phases of Software development life cycle (SDLC) including System Analysis, Design, and Data Modeling, Implementation and Support and maintenance of various applications in both OLTP and OLAP systems.

Proficient in using various packages in Python like Pandas, NumPy, Seaborn, SciPy, and Matplotlib.

Good knowledge of Performed Data Analysis and Data validation by writing complex SQL queries using SQL against the SQL server database.

Good Knowledge of developing different Statistical, Text Analytics, Data Mining solutions to various business generating problem and data visualizations using Python and Tableau Design and development of Data warehouse and reporting.

Knowledge of AWS Cloud platform and its features which includes EC2, S3, Redshift etc.

Good knowledge of Data collection, data transformation and data loading using ETL systems like SSIS.

Good understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact, and Dimension tables.

Working knowledge of MS Excel including date functions, text calculations, lookups, Pivot tables, advanced summations.

Knowledge of various reporting objects like Facts, Attributes, Hierarchies, Transformations, Filters, Prompts, Sets, and groups in Tableau and Power BI.

Proficient in development of T-SQL, OLAP, PL/SQL, Stored Procedures, Triggers, Functions, Packages, performance tuning and optimization for business logic implementation.

Proficient in MS-Excel, PowerPoint, spreadsheets (Pivot table & Pivot Charts, Macros), Version control software using Git.

Proficient in Data Flows, Data Architecture, Data Profiling, Data Quality, Data Cleansing, Data Processing, and the ability to create Data Dictionaries.

Extensive experience in Text Analytics, generating data visualizations using R, Python and creating dashboards using tools like Tableau.

Good computing skills including Microsoft Office suite: MS Excel, PowerPoint, Access, Word, Microsoft Outlook.

Experience in working on different Operating Systems like Windows and Linux.

Good Interpersonal Skills, team-working attitude, takes initiative, and very proactive in solving problems and providing the best solutions.

Ability to learn new technologies and avid knowledge hunter with excellent communication skills, strong architectural skills, hardworking, and a good team worker.

Excellent communication and interpersonal skills, ability to work independently as well as part of an integrated team.

Methodologies:

SDLC, Agile, Waterfall

Programming Language:

Python, SQL, PL/SQL, T-SQL

Packages:

NumPy, Pandas, Matplotlib, SciPy

AWS Service:

EC2, S3, Redshift

ETL:

SSIS

Reporting Tools:

Tableau, Power BI, SSRS

Database:

MS-SQL Server, MS Access

Other Skills:

JIRA, Git, MS Office, OLAP, OLTP

Operating System:

Windows, Linux

SKILLS

EDUCATION

Master of Science in Information Systems

University of Maryland, Baltimore, MD

EXPERIENCE

Data Analyst

Liberty Mutual Insurance, MD May 2020 – Current

Designed the business requirement collection approach based on the project scope, created business analysis using an Agile methodology.

Cleaned data and processed third-party spending data into maneuverable deliverables within a specific format with Excel macros and python libraries such as NumPy, SciPy, and Matplotlib.

Designed and deployed reports with Drill Down, Drill Through, and Drop-down menu option and Parameterized and Linked reports using Tableau.

Involved in creating database objects like tables, views, procedures, triggers, functions using SQL to provide definition, structure and to maintain data efficiently.

Worked on goals of Data Administration (also called Information Resource Management – IRM) including minimizing redundant operational data and structuring data to serve the organization’s overall purpose in capturing that data.

Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.

Used Data wrangling and involved in transforming the data and manipulating the structure, granularity, accuracy, temporality, and scope of data to better align with analysis goals.

Data wrangling helped me to lead to precise insights based on valuable enterprise data assets when done correctly.

Validated the data flow and control flow transformations are working according to functionality in SSIS packages.

Worked on creating filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.

Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts, Table.

Created the Business metric KPI (Key Performance Indicator) to evaluate factors for a different module.

Built, published customized interactive reports and dashboards, report scheduling using Tableau.

Used Tableau to analyze and obtain insights into large datasets to create visually compelling and actionable interactive reports and dashboards.

Implemented Optimization techniques for better performance on the ETL side and also on the database side.

Used SQL, PL/SQL, stored procedures for implementing business rules and transformations.

Data Analyst

Sigma Tech Solution, India Aug 2016 - Dec 2018

Maintained Automated Scripts and troubleshoot their issues for each site release, feature and small enhancement project.

Used Agile methodology throughout the project and involved in weekly and daily basis release management.

Developed Python programs for manipulating the data reading from various SQL SERVER and convert them as one CSV Files, update the Content in the database tables.

Experience in a Python-based environment, along with data analytics, data wrangling, and Excel data extracts and Familiar with Pandas, NumPy, SciPy, and Matplotlib.

Proficient in Data wrangling, also integrated information from multiple data sources, solving common transformation problems, and resolved data cleansing and quality issues.

Analyzed various logs that are generating and predicting/forecasting the next occurrence of events with various Python libraries such as NumPy, Pandas, Matplotlib, SciPy.

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

Designed and implemented multiple dashboards using Power BI - PowerPivot & Power Query tools for in-house metrics.

Used Modeling for operational systems and Modeling for informational systems and used the same techniques but resulted in two different types of models: a.) a detailed, transaction processing representation of the operational business requirements; b.) a less detailed, more summarized analytical processing representation of the informational business requirements.

Worked for the proper, cohesive development of systems, and should be conducted as part of any systems development or enhancement effort. In informational data model, supported the targeted business area’s analytical requirements.

Designed and implemented the data loading ETL and publishing processes within the Data Warehouse/BI environment.

Performed ETL using Microsoft SSIS, to extract, transform and load test data on the test environment and to test against the database.

Created Tabular Matrix reports, Charts, and graphs as per customer requirements Using SSRS.

Used Power BI power query to extract data from external sources and modify data to a certain format as required for consumption in the dashboards.

Developed the required data warehouse model using Star schema for the generalized model.

Developed new and improved existing MS Access databases.

Performed data analysis and data profiling using complex SQL on various sources systems.

Created and managed schema objects such as Tables, Views, Indexes, Stored Procedures, and User-Defined Functions depending on the Requirements Using T-SQL.

Participated in daily stand-ups, sprint planning, sprint reviews, and sprint retrospective regularly and reviewed tasks and user stories and provided estimates in JIRA.

Configured and managed various version control systems including tools like Git.

Environment: Agile, SQL, Python, NumPy, Pandas, Matplotlib, SciPy, OLAP, JIRA, SSIS, SSRS, Power BI, T-SQL, MS Access, Git.

Contact this candidate