*+ years of experience in Data analysis and statistical modelling including data extraction, manipulation, visualization and validation techniques, reporting on various projects. Professional experience of working on different SDLC methodologies such as Agile (Scrum), Waterfall & Rational Unified Process
Strong skills in SQL, data warehouse, data exploration, data extraction, data validation, reporting and excel. Utilize Microsoft excel and access to manipulate, cleanse and process large data set.
Expertise in creating, configuring and fine tuning ETL workflows designed between homogenous and heterogeneous systems using SSIS of MS SQL server.
Expertise in building complex SQL Queries to perform data mining, data analytics, and data extractions across databases.
Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
Experience in Developing, Analysing and programming Machine Learning Algorithms based on Supervised an Unsupervised Learning.
Experience in creating Visualization and dashboards in Tableau desktop using Oracle as data source.
Experience in creating visualizations using Python. Experience in creating dashboards and reports using SSRS.
Experience in creating ETL packages using SSIS and Visual Studio. Experience in creating mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta - data definitions.
Experience in Data Mining solutions to various business problems and generating data visualizations using Power BI, Alteryx.
Experience in Performance Tuning and Debugging of mappings and sessions. Strong in optimizing the Mappings by creating/using Re-usable transformations, Mapplets and PL/SQL stored procedures.
Experience in Data warehousing, Data Architecture &Extraction, Transformation and loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica Power Center.
Experience object-oriented programming (OOP) concepts using Python and Linux.
Experience in writing Sub Queries, Stored Procedures, Triggers, Cursors, and Functions on MySQL database.
Strong team player with great verbal, written communication and interpersonal skills. Proven ability to prioritize and complete multiple task. Proven capacity to approach problems effectively and creatively. Quick learner and hard worker willing to take responsibilities.
Python, R, SQL, PL/SQL
MS PowerPoint, Tableau, Google Analytics, MS Office
SQL Server, PostgreSQL, Oracle, Teradata
SSRS, SSIS, SSAS
SDLC, Agile, Waterfall, Scrum
Informatica, Visual Studio, Power BI, Alteryx
Master’s in Business Administration Ashland University, Ohio
PNC Financial Services, OH - Aug 2019 to Current
Role: Data Analyst
Created code to utilize REST APIs for data query and gathered data from internal and external sources.
Performed requirement gathering for career services platform and defined the scope and phases of the project.
Liaised with the strategy team and presented data story using MS PowerPoint.
Created Tableau dashboards, worksheets containing extensive use of calculated fields, parameters, filters, sorts and Actions (Highlight, Filter and URL).
Designed and implemented multiple dashboards using Power BI - PowerPivot & Power Query tools for in house metrics.
Performed data analysis by writing SQL queries from the source data residing in Oracle database.
Provided technical support, including code testing and documentation of solutions, to the team.
Used ETL in Informatica, Python and SQL to transform and prepare the data for further statistical analysis.
Provided data-driven solutions to internal clients and presented key findings to benefit decision making.
Collaborated with consultants to conduct research on expanding region-based customers.
Expert in creating multiple kinds of Report in Power BI and presented them using Story Points.
Developed scripts using python programming for blog data scraping, analysis, and documentation.
Perform Data Analysis on the Analytic data present in Teradata and MS Razor using SQL, Teradata SQL Assistant, Python, Apache Spark, SQL Workbench.
Worked on migrating data using Python and BI tools like Alteryx.
Use SQL, PL/SQL to validate the Data going in to the Data Warehouse, creating complex data analysis queries to troubleshoot issues reported by users.
Responsible for defining the key identifiers for each mapping/interface.
Hexaware Technologies, India - Apr 2014 to Dec 2016
Role: Data Analyst
Understand the data visualization requirements from the Business Users.
Analyse Sales data mart model to identify the tables and their relations in order to extract required data.
Writing SQL queries to extract data from the Sales data marts as per the requirements.
Create Source to Target Data mappings for the individual reports.
Create Pivot tables in Excel to analyse data across several dimensions.
Creating mock-ups of Dashboards and individual data visualizations in MS Excel.
Developed Tableau data visualization using Scatter Plots, Geographic Map, Pie Charts and Bar Charts and another Chart.
Maintained data integrity during extraction, transformation and loading of data into data warehouse and engaged in requirements and gap workshops with clients for identifying the data sources and data needed for analysis.
Created Advanced Power BI Dashboards, SQL Queries and SQL Optimization experience.
Prepared test cases for the validation of data and look feel of the reports.
Document all data mapping and transformation processes in the Functional Design documents based on the business requirements. Maintaining various types of database
Ensemble learning method applied for better predictive performance
Worked with other team members to complete special project and achieve project deadlines
Developing tidy dataset, Data visualization in R using various packages.
Creating and managing scheme objects such as tables, views, clusters, Indexes, Procedures, triggers and maintained Referential Integrity.
Run reports based on team needs by writing SQL quires to extract data.
Created ad-hoc reports using SQL server Reporting Services (SSRS).
Maninder Pal Singh