Machine Learning Power Bi

PROFESSIONAL SUMMARY

Mohan Pulagam

+1-682-***-**** ad8sck@r.postjobfree.com LinkedIn

• Over 3+ years of experience in the software industry with Master’s degree in computer and information science with Big data specialization.

• Proficient in integration AWS and Azure Cloud Services reducing infrastructure costs and improving scalability.

• Expertise in implementing Machine Learning Algorithms, Python, R, Tableau, Power BI, SQL and Big Data Technologies. . TECHNICAL SKILLS

Programming Languages: Python, R, Java, Spark, Hadoop, HiveQL, PySpark Data Visualization Tools: Tableau, Microsoft Power BI, Matplotlib (Python), seaborn (Python), D3 Charts, Qlik View Machine Learning and Data Analysis Tools: Pandas, NumPy, Scikit-learn, Tensorflow, MS Excel Cloud Technologies: AWS (Lambda, Step Functions, S3), Azure (Data Lake, Data Factory) Data Engineering Skills: Data Warehousing, Data Modeling, Data Manipulation and Processing, ETL, Star, Snowflake Database Management Technologies: MySQL, PostgreSQL, Oracle Big Data Technologies: Hadoop, Scala, Hive, Apache Spark, Spark SQL, Pig, Kafka PROFESSIONAL EXPERIENCE

Data Analyst Oncor Electric Delivery Dallas, Texas June 2023 – Present

• Analyzed and visualized large datasets using Tableau, Python libraries facilitating data-driven decision-making processes.

• Participated in CI/CD deployment processes with Jenkins, streamlining software delivery pipelines and reducing time-to-market by 20%.

• Achieved 30% reduction in modeling time with R scripts and Python libraries for statistical analysis, preprocessing, and feature engineering.

• Boosted query performance and data accuracy by 35% with advanced SQL queries using nested queries, joins, subqueries, and window functions.

• Designed and developed ETL pipelines using AWS Lambda, AWS Step Functions Informatica and SSIS for SQL Server integration, achieving a 35% reduction in data processing time and improving data integration. Application Development Analyst Accenture Bangalore KA, India June 2020 - Aug 2021

• Utilized Agile methodologies, including sprint planning, stand-up meetings, retrospectives, code deployments, and reviews, while collaborating with cross-functional teams and tracking progress through Jira board.

• Employed machine learning algorithms for advanced analytics, contributing to a 25% improvement in forecasting accuracy.

• Leveraged advanced SQL queries and collaborated with data engineering teams in reducing the data processing time by 20%.

• Operated and maintained large-scale data warehouses, optimizing data storage and retrieval to enhance analytics and reporting efficiency, resulting in a 25% improvement in data processing speed.

• Architected and implemented 3 AWS projects, optimizing infrastructure, and achieving 35% reduction in operational costs by leveraging services such as AWS Lambda, AWS Step Functions.

Junior Technology Analyst Accenture Bangalore KA, India June 2019 - June 2020

• Engineered dynamic user dashboards, metrics, reports using Power BI enhanced data visualization and project insights to drive key business needs.

• Utilized Microsoft Excel (V-LOOKUP, Power Pivots, Macros) for data cleaning, analysis and reporting, resulting in 25% reduction in data errors and discrepancies.

• Boosted data processing efficiency and retrieval speed by 30% with Python scripts using Pandas, NumPy, PySpark, and REST service integration and through advanced SQL procedures and functions.

• Enforced robust data security measures and compliance protocols, including encryption and access controls, ensuring 100% adherence to industry standards and regulations and participated in code deployments ensuring code quality. TECHNICAL PROJECTS

Netflix Data Analysis, University of Texas at Arlington Map-reduce, Python, Java, Spark, SparkSQL, Pig, Hive

• Analyzed Netflix data using Big Data Technologies for user viewing patterns and genre understanding. Utilized Java, Python, Spark, and SparkSQL for data analysis, enhancing accuracy by 20%. Sentimental Analysis on Restaurant Reviews, University of Texas at Arlington Machine Learning, Python, Scikit-learn, NumPy, Pandas

• Improved sentiment analysis accuracy by 25% on restaurant reviews through the application of machine learning algorithms and feature engineering techniques, while concurrently reducing dataset processing time by 40% using Python and ML algorithms. Library Management System, GITAM Deemed To Be University MySQL, PL/SQL, Postgre SQL

• Designed schema, ER diagrams, and tables for a Library Management System, improving operational efficiency by 40%

• Implemented features for tracking book insurance and automated tasks with stored procedures and triggers for overdue notifications and inventory updates, improving performance and user experience. Online Retail Analysis Dashboard, Dallas, Texas Power BI, SQL

• Created a Power BI dashboard for analyzing sales performance, customer behavior, and product trends in an e-commerce setting.

• Conducted data analysis, preprocessing, and visualization, developing various charts including bar charts, line charts, and pie charts to highlight key insights and drive business decisions. EDUCATION

The University of Texas at Arlington MS, Computer and Information Sciences GPA: 3.0 Aug 2021 – May 2023 GITAM Deemed To Be University B.Tech, Computer Science and Engineering GPA: 7.3 June 2016 – June 2020 CERTIFICATIONS

AWS Developer Associate

Contact this candidate