Data Engineer

Nikhil Davis Kokkaly

Boston, Ma 857-***-**** *******.*@*****.***.*** www.linkedin.com/in/nikhil-kokkaly Education:

Master’s, Northeastern University, Data Analytics April 2020 Bachelors, Mumbai University, Information Technology May 2012 Technical Skills:

Programming Languages: SQL, Spark, R, Tableau, SSIS, Python, Sql Server, Golden Gate, SSAS. Database: Oracle, Sql, Oracle RAC, Data guard, Snowflake, DB2, AWS, SparkSql, Pyspark, Amazon Redshift Operating System: Linux, Unix, Windows, ubuntu,

Cloud: Experienced in working on AWS, S3, EMR, RDS, Hadoop, Spark, Amazon glue Professional Summary:

Data engineer and Oracle Database administrator with 7+ years of experience in Healthcare, banking and transport domain. Analyzing, interpreting and maintaining data in order to drive successful business solutions performing ETL operations along with hands on experience with Oracle databases. Implemented EMR on AWS analyzing big data on Hadoop. Proficient knowledge in analytics along with thorough understanding of regression modelling and various machine learning algorithms. Hands on experience working on HIVE, Hadoop, EMR, Pyspark and sparksql and REDSHIFT. Professional Experience:

Cotiviti: Data Engineer dataops Aug 2020 – Nov 2020

• Program per data transformation specifications to convert source data to be loaded into target data warehouse tables using PL/SQL and other Data Integration/ETL tools.

• Work as a team member in creation and maintenance of ETL scripts and Data Pipeline used for healthcare data management, data validation, statistical report generation, and program validation.

• Perform data analysis, data mining and investigations and identify root cause of issues with SQL queries.

• Review & test the data to ensure accuracy & validity of the data prior to uploading the data to the warehouse. IBM: Analyst (Downer Group)

Project: Analysis and deployment for Downer Oct 2016 – Sept 2018

• Designed architecture, designed data flow, budgeted resources for data storage for Downer group.

• Managed structured data and transformed unstructured data into machine readable form performing ETL operations.

• Retrieved data from DB2 database to Oracle using heterogenous DB link saving 180+man hours.

• Worked with application developers to monitor and trouble shoot data related issues, reporting & analyzing datasets.

• Created development, test and uat systems and Performed Extract, Transform, Load (ETL)Loads for testing.

• Imported data into databases tested various scenario executing Sql and delivered a tested live working production environment used by Sydney Rail systems on Dec 4 2017 using SDLC life cycle. Wipro Technologies:

Database Maintenance and reporting of Citi Financials Sep 2012 - Jan 2013

• Automated daily health check reports for servers and stored it in Oracle, reducing man hours by 250+ hours.

• Configured Bi-directional Golden gate replication across continents, providing 24*7 support. Database Analyst:

Testing & deployment of Citibank applications Jan 2013 – Oct 2016

• Performed data analysis on unstructured data after cleaning of data and loading into database.

• Assisted lead in identifying persistent ticket generating issues, bringing down ticket count by 1%.

• Performed ad hoc analysis on incident resolution to recommend operational strategies and improve operational efficiency by 15% and SLA adherence KPI by 7%.

Academic Projects:

Northeastern University, Boston Massachusetts Feb – 2020 Analyze Big Data with Hadoop AWS

• Created Amazon S3 bucket, created and launched Elastic MapReduce cluster created a master and slave cluster.

• created SSH request from client to access cluster

Contact this candidate