SUMMARY

• Strong experience inDataAnalytics,DataEngineering, BigData, Python, SQL, and Machine Learning.
• Expert in teh 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 teh 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 teh 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 halp enhance customer experience using NLP.
• Wrote teh 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 teh feedback after deployment and retrained teh model to improve teh performance.
• Designed, developed, and maintained daily and monthly summary, trending, and benchmark reports in Tableau Desktop.
• Created multiple custom SQL queries to prepare teh 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 teh business point of view in product selling strategy with BI and sales team.
• Gatheird 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 teh tables, and selecting teh requireddatato run teh 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.
• Teh reports will be generated by tracking, compiling, and extracting thedata.
• Involved in fixing invalid Mappings, testing Stored Procedures, and Testing Sessions, Batches, and teh TargetData.
• Re-engineer existing Informatica ETL process to improve performance and maintainability.
• SQL Query performance tuning is used to identify tables and understand teh 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 teh models with different batches ofdatato optimize teh models and prevent overfitting.
• Created and maintained reports to display teh status and performance of deployed model and algorithm with Tableau.
• Developed Python programs for manipulating teh data reading from various Oracle data sources and consolidating them as a single CSV Files and updating teh content in teh 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 teh requirements of clients with data governance in place.
• Processed data analysis for teh identification of teh features impacting teh zero-touch customer autantication 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 teh Configuration Data which is used by teh 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 teh information needs within and across functional areas of teh organization and modeling teh process in teh enterprise-wide scenario.
• Field mapping work involved establishing relationships between teh database tables, filter criteria, formulas, etc., needed for teh 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 teh 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 teh target, by scheduling teh sessions.
• Used teh dynamic SQL to perform some pre-and post-session tasks required while performing Extraction, transformation, and loading.
• Designing teh ETL Process using Informatica to populate teh DataMart using teh flat files to Oracle database
• Created complex mappings to populate thedatain teh target with teh required information.
• Wrote SQL Scripts to extractdatafrom Database and for Testing Purposes.

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