Data Analyst Power Bi

Manas Anand Nissankara

Houston, TX ***************@*****.*** +1-713-***-**** manasanand99.github.io linkedin.com/in/manas-anand-nissankara/ github.com/manasanand99 Education

University of Houston, Houston,TX Aug 2022 – Dec 2023 Masters of Science in Computer Science GPA:3.9

JNTUH College of Engineering Hyderabad, Hyderabad, India Aug 2016 – Sept 2020 Bachelor of Technology in Electronics and Communication Engineering GPA:3.8 Technologies

Languages: Python, Java, SQL, PySpark, Hive, Scala, Linux Shell scripting, C/C++, R, PowerShell, NoSQL Technologies:PyTorch, TensorFlow, OpenCV, NumPy, SciPy, Pandas, Scikit-learn, Matplotlib, PySpark, JSON Databases: PostgreSQL, MySQL, MongoDB, Cassandra, OracleDB, Snowflake Tools: GIT, Jupyter, Hadoop, Kafka, Snowflake, Oracle SQL Developer, Hadoop, Airflow, Spark Streaming, SAS Cloud Technologies: AWS, Azure Data Factory, DataBricks, Salesforce Data Visualization & Reporting: Tableau, Excel, Power BI, Spotfire Experience

Data Consultant, MTX Group Inc – Frisco, TX May 2024 – Oct 2024

• Conducted advanced data analysis and statistical modeling using Python, which identified business patterns and trends, supporting development of strategic initiatives that enhanced operational efficiency by 10%.

• Designed and implemented initial data visualization setups in Salesforce Tableau, configuring data sources and establishing templates that standardized visualization practices, enhancing consistency in reporting by 25%.

• Conducted in-depth market research to identify growth opportunities in the healthcare sector using SAS. Led to the successful launch of 3 new service lines.

• Wrote Microsoft SQL statements to send regularly updating inventory and sales reports in Excel through Power Query and ODBC for both corporate and branch managers on a weekly/monthly basis.

• Collaborated with analysts and other data engineers on requirement gathering, analyzing data inconsistencies, anomalies in data and actively took part in providing solutions for any issues throughout the ETL process. Data Analyst/Graduate Assistantship, University of Houston – Houston, TX Oct 2022- Feb 2024

• Utilized R programming to identify correlations between pricing strategies and product demand, creating compelling visualizations with ggplot2, which enhanced report clarity and effectiveness in data-driven decisions.

• Managed MySQL database operations, writing optimized SQL queries for efficient data extraction and performing maintenance to ensure database integrity, which boosted data retrieval performance by 35%.

• Partnering with Executive Service Corps of Houston (ESCH) to complete 6 projects for non-profit organizations and startups to identify the most engaging marketing campaign, resulted in a $50K increase of yearly revenue. Consultant/Data Analyst, Larsen & Toubro Infotech – Hyderabad, India Oct 2020 - Aug 2022

• Recognized growth opportunities by analyzing sales data, comprising of 1.3 million transactions, via advanced SQL queries and hypothesis testing methods (t-tests and ANOVA)

• Forecasted monthly revenue and expense budgets providing visibility into performance metrics of 150+ studios

• Implemented ARIMA models to accurately forecast customer visits, resulting in a 10% reduction in both overstock and stockouts of retail inventory.

• Mastered and applied advanced Microsoft Excel functions, including complex formulas and macros, to automate routine data analysis tasks, reducing manual processing time by 60% and minimizing errors Publications

Extensive Study of Speech Emotion Recognition(SER) using Mel Spectrograms Oct 2021 Journal of Xi’an University of Architecture & Technology Volume XIII, Issue 10, 2021 Projects

Converting Images to Prompts TensorFlow, Pytorch

• Implemented CNN-RNN based encoder-decoder model for vision2text image caption generation using RESNET50 v2 for image feature extraction (Encoder) and LSTM for text generation (Decoder) with confidence score of 0.90 on flickr30K dataset.

• Tokenized prompts in data file using GPT-NEO evaluated model with BLEU metric and obtained 0.43 score Prediction of Bubble Point Pressure and Oil Formation Volume Factor Using Machine Learning Techniques

XGBoost, Data Visualization

• Included a thorough Exploratory Data Analysis (EDA) phase in which I investigated the properties and connections of the dataset. I improved prediction accuracy to 92% by highlighting important patterns and connections through smart visuals through Spotfire that helped with feature engineering and model selection. Impact of Warfare in the regions of Africa and Middle east countries: Tableau, Microsoft Excel

• Performed data cleaning tasks such as removing duplicates, handling missing values, standardizing data formats, and checking for errors and outliers, validated the data against reliable sources, and documented the entire cleaning process in Tableau.

• Created custom charts like Lollipop Chart, Waterfall Chart, Funnel Chart, and Butterfly Chart using Tableau. Professional Certifications/ Trainings

• Certified AWS Certified Solutions Architect – Associate: Demonstrated expertise in designing and deploying scalable, highly available, and fault-tolerant systems on AWS, with hands-on experience in leveraging services such as EC2, S3, RDS, and Lambda to optimize cloud architecture and enhance operational efficiency.

• Certified IBM Smart Bridge Training and Internship in Artificial Intelligence: Completed an intensive program focused on AI applications using Python and IBM Watson, developing hands-on experience in machine learning, natural language processing, and data analysis to implement innovative AI solutions.

• Certified Microsoft Azure Fundamentals (AZ-900): Gained foundational knowledge of cloud concepts, core Azure services, security, compliance, and pricing models, enabling effective communication and collaboration in cloud-based projects.

• Experience with cloud-based data warehousing solutions, such as Snowflake, and ability to develop and maintain data pipelines from various data sources to the data warehouse.

• Familiar with data architecture including data ingestion pipeline design, Hadoop information architecture, data modeling

• Proficient in using Informatica PowerCenter to design, develop, and maintain ETL workflows for data integration and data warehousing projects

Contact this candidate