Kevin Patel
Data Analyst · PNC Financial Services
In My Own Words
• Data analyst with 3+ years of industry experience in collecting, organizing, interpreting, and disseminating various types of statistical figures.
• Experience working in all phases of the Software Development Life Cycle (SDLC) using methodologies like Agile, and Waterfall.
• Knowledge in Python programming with various packages including NumPy, Matplotlib, SciPy, and Pandas.
• Proficient in all the phases including data cleaning, data extraction, and data visualization with large data sets of structured and unstructured data, created ER diagrams and schema.
• Good Knowledge of creating visualizations, interactive dashboards, reports, and data stories using Tableau and Power BI.
• Knowledge of data mapping, querying the source and target tables in the database using SQL for testing purposes.
• Knowledge and understanding of Data warehousing concepts: Star Schema, Snowflake Schema, Fact, and Dimension Tables.
• Knowledge of Designing dashboards reports that display key performance indicators (KPI), scorecards, and drill-down details.
• Knowledge of Data Modelling, Data Collection, Data Cleansing, Data Warehouse, and OLAP.
• Proficient in importing and cleansing of data from various sources like Teradata, SQL Server with high volume data.
• Experience in pulling the ad-hoc data and delivering data to the customers in different formats like excel, pivot tables, and flat files.
• Good knowledge of RDBMS implementation and development using SQL, PL/SQL, MySQL, and SQL Server stored procedures, and query optimization.
• Good Knowledge of Data Transformation, Metadata, Data Dictionary, Data Loading, Modelling, and Performance Tuning.
• Knowledge of using functions in Excel and perform analysis using Pivot charts.
• Experience in working with different operating systems like Windows and Linux.
Work Experience
Data Analyst
PNC Financial Services2018 – 2019
Responsibilities:
• Worked in an Agile environment, with an ability to accommodate and test the newly proposed changes at any point of time during the release. • Clean data and processed third party spending data into maneuverable deliverables within specific format with Excel macros and python libraries such as NumPy SciPy, and Matplotlib. • Performed troubleshooting, fixed, and deployed many Python bug fixes of the two main applications that were the main source of data for both customers and the internal customer service team. • Created the Business metric KPI (Key Performance Indicator) to evaluate factors for different modules. • Generated PL/SQL scripts for data manipulation, validation, and materialized views for remote instances. • Implemented point of view security to Tableau dashboards to facilitate visibility across various levels of the Organization. • Configured data extraction and scheduled refreshes both incremental and complete refresh depending on the data to improve performance of Tableau reports. • Wrote, executed, performance-tuned SQL Queries for Data Analysis & Profiling and wrote complex SQL queries using joins, subqueries, and correlated subqueries. • Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports. • Perform advanced excel functions such as pivot tables and VLOOKUP to analyze data. • Analyzed functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. • Imported data from multiple data sources into Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using VLOOKUP and formulas, built PivotTables and Pivot Charts using Power Pivot skill.
Environment: Agile, Python, NumPy, Matplotlib, KPI, SQL, PL/SQL, Tableau, VLOOKUP, Excel, PivotTable.
Data Analyst
Exert Infotech2016 – 2016
Responsibilities:
• Developed business process models in Waterfall to document existing and future business processes. • Developed programs with manipulate arrays using Python libraries like NumPy and SciPy. • Imported the claims data into Python using Pandas libraries and performed various data analyses. • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects. • Used Python programs automated the process of combining the large datasets and Data files and then converting them as Teradata tables for Data Analysis. • Installed and configured Enterprise gateway and Personal gateway in Power BI service. • Provide support to internal Power BI users and mentored them in creating custom reports and dashboards with troubleshooting technical issues. • Collaborated with vendors and business teams to identify and develop Key Performance Indicators (KPI) that assisted in creating KPIs with realistic targets that can easily be quantified and measured. • Maintained PL/SQL objects like packages, triggers, procedures, etc. • Created functions, triggers, views, and stored procedures using MySQL. • Used Aggregations, Set Operators like Union, Minus, and Intersect, CASE Expressions, and String expressions to retrieve data in a required form from multiple tables. • Generated graphs using MS Excel, Pivot tables, and creating presentations using PowerPoint. • Compiled data from various sources public and private databases to perform complex analysis and data manipulation for actionable results.
Environment: Agile, Python, NumPy, SciPy, Pandas, Teradata, Power BI, MySQL, KPI, PL/SQL, MS Excel, Pivot table, PowerPoint.
Education
Master of Science in Information System Security
University of the Cumberlands2020 – 2021
Master of Science in Information System Security