Informatica Developer

RIPUDAMAN SINGH KOHLI

**** ******* *** *** #*, Columbus Ohio -43220

*******@****.**.*** • 513-***-****

www.linkedin.com/in/ripudamansinghk/

EDUCATION

University of Cincinnati, Carl H. Lindner College of Business, Cincinnati, Ohio Aug 2014-Dec 2015

MS –Information Systems, GPA: 3.97

Coursework: Data Mining, Data Analysis using R, Data Modeling, Database Design, Business Intelligence, Statistical Computing, Process Modeling, Data Visualization using Tableau

Bharati Vidyapeeth College of Engineering, Pune, Maharashtra July 2006-June 2010

Bachelor of Engineering, Electronics (GPA 3.58/4.00)

CERTIFICATIONS

SAS Base Programming for SAS 9 (Certificate No. BP055391v9)

Microsoft Certified Professional –SQL Server 2008 R2 (Certification No. E172-9171)

ITIL V3 Foundation Certified (EXIN)

Certificate in Data Analytics (R, SAS), University of Cincinnati

R-programming, Exploring and Cleaning Data with R, Data Structures in Python(Coursera)

Python for Everybody, Python data Structures(Coursera)

PROFESSIONAL EXPERIENCE

Nationwide Insurance, Columbus, Ohio (USA) May 2015 - Present

Sr. ETL Developer

Performed Data profiling, analysis, cleaning and modeling for historical Beneficiary data conversion project

Successfully completed data conversion by developing Informatica workflows for moving the data from old systems to new data warehouse.

Reduced data validation time frame by 200% with the help of R scripts

Developed shell scripts for running daily feeds

Data Analyst Intern (May 2015-December 2015)

Prepared Data Model for existing databases storing old closed claims.

Analyzed, cleaned the existing data for Life, Annuities and Retirement claims.

Using the existing database model and data in it, prepared data model for new data warehouse to store closed Life, Annuities and Retirement claims.

Automated internal IT processes by creating R scripts.

Successfully implemented proof of concept to capture skills in the team by using R Script

Prepared Dashboard using tableau to display skills of the Team members as a part of POC.

Worked on Streamlining Intern On-boarding process. Implementation of it saves $50000 for Nationwide Financials each year.

Tata Consultancy Services, Gurgaon (India)/Crawley (United Kingdom) August 2010 – July 2014

Contracted to Client location for setting up disaster recovery environment and to implement Payment Card Industry Data Security Standard (PCI-DSS) Compliance.

System Engineer – SQL Server DBA (December 2010 – June 2014)

Improved performance of the SQL Server Farm for a well renowned Airline client by optimizing and tuning the Servers, re-indexing the databases, upgrading instances from old versions to new ones

Successfully created and maintained Disaster Recovery Environment for SQL Farm

Day to Day activities included setting up Mirroring, Log shipping, SSIS, SSRS, Upgrade from 2005 to 2008 R2 and 2012

Led the release and implementation of the newly developed applications, for making the client Payment Card Industry (PCI) compliant.

Achieved PCI Compliance for the client and handed over the applications for support to TCS within a year which exceeded project goal expectation by six months

Assistant System Engineer – Level Two Support (August 2010 – December 2010)

Implemented more than five System Improvement Plans(SIP)for supported applications which resulted in reduction on the count of issues by 25 percent per month

Handled Incident, Work Order, Change and Problem Management using ‘BMC REMEDY’ management Suite.

PROJECTS

Predictive Modeling using R to estimate Landing Distance of an Airplane

Using R, developed predictive models and compared them by evaluating Normal Q-Q Plots and residuals/fitted value plots.

Credit Risk Analysis using R

Analyzed 58000 data points to predict the probability of credit default by: In sample prediction, Misclassification rate, ROC Curve Analysis, confusion matrix and optimum cut off probability.

TECHNICAL SKILLS

Statistical Analysis- SAS, R, MS Excel, Python

Algorithms –CART, K-Means

Regression- Linear and Logistic Regression

Data Visualization : Tableau, R packages for visualization, MS Excel

Database Management Systems – SQL Server 2000, 2005, 2008 R2, 2012, MySQL, Microsoft Access, Excel

Programming Language –T- SQL, PL/SQL, Python, Unix

Data Warehousing – Informatica, QlikView

Methodologies – Agile, Water fall

Leadership, Affiliations, and Awards

Won the First Prize for Best Designed Application at Nationwide Financial Hackathon

Among the top 10 ideas in the Idea Jam 2015 held in Nationwide Financials

Won ‘On the Spot’ Award in TCS for excellent issue handling skills

Won the First Price for Dance (Bhangra) in College

Part of Management Team to organize college Fest called ‘Bhartiyam’

Contact this candidate