SUMMARY

• Strong experience inDataAnalytics,DataEngineering, BigData, Python, SQL, and Machine Learning.
• Expert in the Data Science process life cycle including Data Acquisition, Data Preparation, Data Manipulation, Feature Engineering, Machine learning algorithms, Validation, Visualization, and Deployment.
• Experienced in advanced statistical analysis and predictive modeling in structured and unstructured data environments.
• Proficient in Python and its libraries such as NumPy, Pandas, Scikit - Learn, Matplotlib, and Seaborn.
• Efficient in preprocessing data in Python using Visualization, Data cleaning, Correlation analysis, Imputations, Feature Selection, Scaling and Normalization, and Dimensionality Reduction methods.
• Extensive experience working with RDBMS such as SQL Server, MySQL, Oracle, and NoSQL databases such as MongoDB.
• Knowledge in building various machine learning predictive models using algorithms such as Linear Regression, Logistic Regression, Naive Bayes Classifier, Neural Networks, Decision Tree, and Random Forest Regression.
• Knowledge in Text Mining, Topic Modelling, Association Rules, Sentiment Analysis, Market Basket Analysis, Recommendation Systems, and Natural Language Processing (NLP).
• Proficient in data visualization tools such as Tableau, and Python Matplotlib to create visually powerful and actionable interactive reports and dashboards.
• Good understanding of working on Artificial Neural Networks and Deep Learning models using TensorFlow packages using Python.

TECHNICAL SKILLS

• Python
• R
• PySpark
• Tableau
• Power BI
• MS-Excel
• SQL
• NoSQL
• MongoDB
• Data Analysis
• Data Wrangling
• Data Visualisation
• Data Mining
• Data Warehousing
• Statistical Modeling
• Demand Forecasting
• Predictive Analysis
• Linear Algebra
• Statistics
• Probability Theory
• Machine Learning
• Deep Learning
• Natural Language Processing

PROFESSIONAL EXPERIENCE

Sr Data Analyst

Confidential

Responsibilities:

• Performed steps in the life cycle ofdatasuch asdatacollection, scrubbing, understanding, analysis, modeling, implementation, actions, and result.
• Used Python programming for managing, transforming, and integrating with datasets in preparation for analytics.
• Utilizing Pandas, NumPy, SciPy, Matplotlib, and SciKit-learn in Python for developing various machine learning algorithms.
• Performed the statistical calculations, and removed and filled missing values using Python and its packages like NumPy and Pandas.
• Performeddatapreprocessing like cleaning (for outlier, missing values analysis, etc.) andDataVisualization (Scatter Plots, Box Plots, Histograms, etc.) using Matplotlib.
• Configuring product Metadata in CRM systems, Billing, Mediation, Value Added Service components, and interconnect systems for Postpaid and Prepaid business in Pre-Production and Production environment.
• Determine customer satisfaction and help enhance customer experience using NLP.
• Wrote the python script to automate data updating activity for every sprint (Agile framework) for new and existing customers for new and old prepaid and postpaid plans.
• Involved in generating various graphs and charts for analyzing thedatausing Python Libraries.
• Collected the feedback after deployment and retrained the model to improve the performance.
• Designed, developed, and maintained daily and monthly summary, trending, and benchmark reports in Tableau Desktop.
• Created multiple custom SQL queries to prepare the rightdatasets for Tableau dashboards.

Environment: Python (SciKit-Learn/NumPy/Pandas/Matplotlib), Machine Learning (Linear, Logistic Regression), Tableau, SQL

Data Analyst

Confidential

Responsibilities:

• Data Exploration, understanding the business point of view in product selling strategy with BI and sales team.
• Gathered requirements, performed business analysis, and documented all thedataafter pulling thedatafrom databases.
• Hands-on experience in analyzing thedataand writing Custom MySQL queries for better performance, joining the tables, and selecting the requireddatato run the reports.
• Utilized technology such as MySQL and Excel PowerPivot to query testdata and customize end-user requests.
• SQL scripts were developed and triggers and cursors are written.
• DataValidation is done a time to check whether thedatais correct and clean.
• The reports will be generated by tracking, compiling, and extracting thedata.
• Involved in fixing invalid Mappings, testing Stored Procedures, and Testing Sessions, Batches, and the TargetData.
• Re-engineer existing Informatica ETL process to improve performance and maintainability.
• SQL Query performance tuning is used to identify tables and understand the database tables’ performance.
• Mapping of business requirements to BusinessDataModel and understanding of systemanalystin Canonical Mapping.
• SQL Server Reporting Service is used to handle reporting of Designed Hierarchy dimensions.

Environment: Python (Pandas/Matplotlib/Seaborn), SQL, MS EXCEL, Microsoft Office, Tableau

Data Analyst

Confidential

Responsibilities:

• Extensively involved in all phases ofdataacquisition,datacollection,datacleaning, model development, model validation, and visualization to deliverdatascience solutions.
• Worked ondatacleaning and ensureddataquality, consistency, and integrity using Pandas and NumPy.
• Used cross-validation to test the models with different batches ofdatato optimize the models and prevent overfitting.
• Created and maintained reports to display the status and performance of deployed model and algorithm with Tableau.
• Developed Python programs for manipulating the data reading from various Oracle data sources and consolidating them as a single CSV Files and updating the content in the database tables.
• Collected and cleaned large volumes of data stored at CRM Database using SQL queries.
• Extracted unstructured/semi-structured data and transformed it into structured data.
• Set up database structures and queries to fulfill the requirements of clients with data governance in place.
• Processed data analysis for the identification of the features impacting the zero-touch customer authentication process using mobile applications using statistical data analysis and visualization (such as box plots, scatter plots, and correlation maps)
• Involved in writing complex SQL Queries and provided SQL Scripts for the Configuration Data which is used by the application.
• Collected and cleaned large volumes of data stored at CRM Database using SQL queries. Extracted unstructured/semi-structured data and transformed it into structured data.

Environment: Python, SQL, MS Excel, MS Word, Oracle, Tableau

Data Analyst

Confidential

Responsibilities:

• Identifying the information needs within and across functional areas of the organization and modeling the process in the enterprise-wide scenario.
• Field mapping work involved establishing relationships between the database tables, filter criteria, formulas, etc., needed for the reports and managed database optimization and table-space fragmentation.
• Actively involved in full Software Development Lifecycle (SDLC).
• Responsible for developing, implementing, and testingdatamigration strategy for overall project in the database using SQL as a platform with global resources.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers, and procedures to troubleshoot any database problems.
• Worked on Informatic PowerCenter tool - Source Analyzer,DataWarehousing designer, Mapping & Mapp let Designer and Transformation Designer and Developed Informatica mappings and tuning of mappings for better performance.
• Extracteddatafrom different flat files, MS Excel, and transformed thedatabased on user requirements using Informatica PowerCenter and loadeddatainto the target, by scheduling the sessions.
• Used the dynamic SQL to perform some pre-and post-session tasks required while performing Extraction, transformation, and loading.
• Designing the ETL Process using Informatica to populate the DataMart using the flat files to Oracle database
• Created complex mappings to populate thedatain the target with the required information.
• Wrote SQL Scripts to extractdatafrom Database and for Testing Purposes.

Environment: MS Excel, Oracle, Informatica Power Center, SDLC, SQL Server.