PNC Financial Employee Reviews for Data Analyst

"• 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. • Facilitated the automation process for the reports - which are required to run a monthly and weekly basis using python script. • Worked extensively on Data Profiling, Data cleansing, Data Mapping, and Data Quality. • Used Pandas, NumPy, SciPy, Matplotlib, and Scikit-learn in Python for developing various Machine Learning algorithms. • Designed and developed various analytical reports from multiple data sources by blending data in a single worksheet in Tableau Desktop and created TreeMap, Heat maps, and background maps. • Create customize SQL Queries using MySQL Management Studio to pull specified data for analysis and report building in conjunction with Crystal Reports. • Developed Data Mapping, Data Governance, Transformation, and Cleansing rules for the Master Data Management Architecture involving OLTP and OLAP. • Extracted, Transferred, and Loaded (ETL) data from Excel Spreadsheets and Flat file sources with the help of SQL Server Integration Services (SSIS). • Utilized Tableau and custom SQL features to create dashboards and identify correlation. • Worked with AWS Services like Sage Maker, EC2, Lambda, S3, etc. • Manage Departmental Reporting systems, troubleshooting daily issues, and integrating existing Access databases with numerous external data sources including (SQL, Excel, & Access). • Wrote several Teradata SQL Queries using SQL Assistant for Ad Hoc Data Pull request. • Perform data collection, data cleaning, data wrangling, and data analysis on the data sets in Python. • Used JIRA and Git for version control in the project management."