data Engineer

KRISHNA PRASAD PULIPATI

******@*****.*** 770-***-**** Seattle,WA No visa sponsorship needed(on GC EAD) OBJECTIVE

A collaborative analytics and engineering professional passionate for turning data into products and actionable insights.Excited about providing solutions for business problems involving data using open source technologies.Seeking a role that challenges my data skills with cutting edge technologies in a fast paced environment. CERTIFICATIONS

• Oracle Database SQL Expert ; Couchbase NoSQL Essentials ; SAS Certified Base Programmer TECHNICAL SKILLS

• Languages : Python, R, SQL,bash,shell scripting

• Big Data/ETL : Spark, Hadoop,Hive

• Analytics : Data Mining, Regression, Statistics, Predictive analytics, A/B testing, Marketing analytics,Tableau

• Others : Airflow, Github, Jira

EDUCATION

MS in Analytics Georgia State University, Atlanta [Aug’15 - May’17] BS in Computer Science and Engineering SRM University, India [May’09 - Jun’13] PROFESSIONAL EXPERIENCE

Data Engineer Promantus Inc. [Dec’20- Present]

• Gather data using Java/Selenium for a leading telecom client and subsequently build data pipelines and machine learning models to increase client’s market penetration

Data Engineer(contract) Starbucks Coffee Company [Feb’20- Oct’20]

• Built ETL pipelines on millions of rows of POS data using Spark and make the data available for

- Data scientists to build forecasting models that replenishes the stores with the right quantity at the right time

- Analysts in ADLS(Azure Data Lake Storage) for their dashboarding needs

• Wrote unit tests for the scripts in the pipeline

• Authored and scheduled Airflow DAGs to run spark batch jobs on a daily basis

• Troubleshot failed jobs and worked on change requests for bugs/enhancements in the existing code

• Setup schemas,create material views,incremental/full loads,build dashboards for internal clients using Incorta which is saving them 2 man-hours/day

• Wrote queries using Hive Query Language for data analysis to answer adhoc questions

• Used Git Flow model for release management

Data Analyst(contract) Boeing [Sep’17- Jan’20]

• Use SQL and Excel to analyze supply-chain transactional data to provide insight for systems engineering teams. Delivered insights that reduced a dollar value discrepancy(arised due to incorrect onhand quantities of parts) of

$500000/week which in turn improved the efficiency of demand planning. Built reports in Tableau to visualize inventory mismatch trends for airplane parts between material management/engineering systems.

• Collaborated with airline customers and business partners present in Europe and Asia to keep them data-informed and thus help them succeed in their daily operations

• Proactively identified and analyzed gaps between airline customers, Boeing’s business teams and engineering teams and streamline existing processes that resulted in lesser transactional failures in Boeing’s supply chain systems Data and Marketing Analytics Intern Red Hat Inc. [May’16- Aug’ 16]

• Preprocessed and performed exploratory data analysis on customer's characteristics and past online behavior dataset. Built predictive models(Gradient Boosting, Random Forest) to identify the purchase probabilities of future customers to increase marketing spend efficiency. Increased the ROC of existing model from 65% to 88%

• Developed marketing dashboards to visualize CTR, Bounce Rate, Delivery Rate and Subscribe Rate. Presented result to sales, customer experience & engagement teams to spread awareness about Red Hat’s marketing practices

• Performed text analysis on old marketing emails to improve the click through rates of low-clickedemails Graduate Research Assistant Department of Marketing,(GSU, USA) [Aug’15 – May 17]

• Assisted professor with cause marketing research using text-mining.Extracted consumer feedback data from Social Media REST APIs(Facebook'sGraphAPI,tripadvisor,yelp) using Python Project Engineer Wipro Technologies(Chennai,India) [Dec’13 - May’15]

• Resolved incidents related to SAP Basis and security and supported administration activities for the client

• Performed database administration activities for DB2

• Trained junior team members on existing systems in the project

Contact this candidate