Prashanth K Email & Phone Number

Seattle, Washington, Us

As a Data Engineer, I worked on various data components and deployment using scrips written in Pyspark and Python.Responsible for validating Alaska Airlines data and verifying with different data sources using PySpark scripts from scheduled jobs.Developed python scripts to manage data migrations,

Mclean, Va, Us

. Data Analyst working on migrating data to the cloud (to Snowflake and AWS) from the legacy data warehouses and developing the infrastructure.. Part of the Data and reporting team creating insights and visualization for the business to make decisions on automating the process of generating insights for the business.. Work with various business teams to solve client business problems by translating them into analytics.. Extracting and Analyzing data from various sources. Data wrangling and cleanup using Python-pandas. Create data-pipelines and maintain integrity of the data being passed through. Generate KPIs to reflect data passage.. Responsible for designing, implementing and testing data pipelines on the cloud using AWS Services.. Developing framework for converting existing PowerCenter mappings and to PySpark(Python and Spark) Jobs.. Developing Python code to gather the data from HBase and implement machine learning solutions using PySpark.. Developed HiveQL for sorting, joining, filtering and grouping the structure data and Metadata Management.. Develop Python scripts to perform Metadata validation of Delimited files Develop metrics based on SAS scripts on legacy system, migrating metrics to snowflake (AWS).. Added support for Amazon AWSS3 and RDS to host static/media files and the database into Amazon Cloud.

San Antonio, Texas, Us

• Analyzed data and developed models, algorithms, visualizations, and simulations for complex business problems• Performed statistical analysis to establish causal relationships between drivers and outcomes.• Built analytics processes for anomaly detection, knowledge discovery, decision-making, insights, optimization, monitoring, and new capabilities.• Partnered, support and collaborated with Business teams to assess business needs, defined project scope and requirements, managed expectations, facilitated communication and provided project updates.• Translated business requirements into technical requirements and work with Enterprise Architects, Solution Architect, and technical teams to assess implementation method and solution feasibility.• Worked closely with stakeholders, product owners, SMEs, business analysts, enterprise architects, software and QA engineers, and Production Support team to create and organize user stories and tasks, detailing user stories, manage and prioritize the product backlog.

Eindhoven, Noord Brabant, Nl

• Participated in all phases of research including data collection, data cleaning, data mining, developing models and visualizations. • Collaborated with data engineers and operation teams to collect data from the internal system to fit the analytical requirements. • Imported data by executing hive scripts. • Used SQL Server and spreadsheets as data sources for designing Power BI Reports and Dashboards. • Performed data processing using Python libraries like NumPy and Pandas.• Developed reports with Custom SQL views to support business requirements. • Performed data imputation using Scikit-learn package in Python. • Worked with data analysis using matplotlib and seaborn libraries to do data visualizations for better understanding.• Proficient in creating Triggers, Tables, Stored Procedures, Functions, Views, Indexes and Constraints.• Used visualization tools like, Tableau, Power BI for creating reports and dashboards.• Designed and developed various dashboards, reports using visualizations like bar graphs, scatterplots, geographic visualization and others, making use of actions, other local and global filters according to the end-user requirement. • Used clustering-based and tree-based anomaly detection models to predict anomalies.

• Developed web-based applications using Python, Django, XML, CSS, HTML, DHTML, JavaScript and JQuery • Designed and developed the UI of the website using HTML, AJAX, CSS and JavaScript. • Involved in Developing a Restful service using Python Flask framework. • Involved in debugging and troubleshooting issues and fixed many bugs in two of the main applications, which are main source of data for customers and internal customer service team. • Installed and maintained web servers Tomcat and Apache HTTP in UNIX. • Build the pipelines, run tests in Jenkins and deployed the application in AWS.

Sunnyvale, California, Us

• Involved in reviewing and understanding the Business requirements.• Involved in entire lifecycle of the projects including Design, Development, and Deployment, Testing and Implementation and support.• Wrote scripts to Import and Export data to CSV, EXCEL formats from different environments using Python and made a Celery action using REST API call.• Developed remote integration with third party platforms by using RESTful web services.• Developed web services that make database calls for inserts, updates, and select queries.• Developed Unit, Integration and Performance Test Cases using Junit, Selenium and Rational Function Tester.• Improved code reuse and performance by making effective use of various design patterns.• Used Python library Beautiful Soup for web scrapping’s.• Fetched twitter feeds for certain important keyword using python-twitter library.• Managed large datasets using Panda data frames and SQL.• Wrote and executed various MYSQL database queries from python using Python-MySQL connector and MySQL dB package.• Deployed the project into Heroku using GIT version control system.

Master Of Science - Ms, Information Technology

Bachelor'S Degree

B.Sc

Bachelor'S Degree

Bachelor'S Degree