PL/SQL, SQL
Resume:
Pradnya Chahande
**** ********* ****, *** ****, Rockville 20852
ac2qyr@r.postjobfree.com
https://www.linkedin.com/in/pradnya-chahande/
https://github.com/PradnyaChahande
EDUCATION
Master of Science, Data Science: GPA 4 Lubbock, TX Texas Tech University, Rawls College of Business August 2017 Master of Science, Electrical Engineering Chicago, IL Illinois Institute of Technology, Armour College of Engineering August 2013 Bachelor of Engineering, Electronics and Telecommunication: Nagpur, India Priyadarshini College of Engineering June 2007
ACADEMIC PROJECTS
Designed Data Warehouse in SQL Server and Hadoop
• We designed and built a data warehouse, incorporating industry best practices, in SQL Server and Hadoop. We identified core business process, analytical theme of dataset, and performed data collection and analysis, creating implementation plan.
• Data Warehouse in SQL Server included Data mart design – creating dimensional model, perform ETL with Microsoft SSIS and load data into SQL Server, compress data and improve query performance by implementing column store indexes in SQL Server, optimize and tune query for efficient performance, design OLAP cube in SSAS for data visualization and reporting.
• Data Warehouse in Hadoop included performing ETL using Pentaho’s spoon to load data into Hadoop File System, implementing data warehouse in Hive, analyzing and generate reports for visual analysis using Tableau. DengAI: Predicting Disease Spread: DrivenData Competition
• Trained and tuned time series models such as Arima, seasonal Arima etc. to forecast number of dengue cases given the various environmental conditions.
Data Science Bowl 2017: Kaggle Competition
• Trained and tuned deep learning algorithms for determining when lesions in the lungs are cancerous based on thousands of high-resolution lung CT scans provided by the National Cancer Institute using H2O library in R Allstate Claims Severity: Kaggle Competition
• Trained and tuned deep learning algorithms like CNN (Convolutional Neural Networks) for predicting the cost and severity of more than hundred thousand insurance claims based on anonymous feature set using H2O library in R. Digit Recognizer: Kaggle Competition
• Successfully built an image classifier having an accuracy of 98.5% using Machine Learning techniques to determine the digit from an image of handwritten single digit.
• Anaconda Python environment was used to perform SVC (Support Vector Classification) and PCA (Principal Component Analysis).
Leaf Classification: Kaggle Competition
• Kaggle Rank: Top 15%
• Used binary leaf images and extracted features, including shape, margin & texture, to accurately identify 99 species of plants.
Titanic: Machine Learning from Disaster: Kaggle Competition
• Predicted the survival of passengers using various Machine Learning Algorithms such as Logistic Regression, Random Forest, SVM using R. Successfully achieved accuracy of 80% in predicting survival rate. Texas Public Health
• Exploratory data analysis on health insurance datasets using R, to understand how age, gender, education level, etc. relate to insured and uninsured Texans and build prediction models to identify possible uninsured candidates eligible for insurance.
WORK EXPERIENCE
Texas Tech University Lubbock, Texas
SQL Trainer (Graduate Assistant) February 2017 – August 2017
• Understand current operations database and data warehouse.
• Developed learning material for novice and advanced users.
• Delivered trainings incorporating adult learning fundamentals. Texas Tech University Lubbock, Texas
Graduate Assistant August 2016 – May 2017
• Developed financial intelligence application for Happy State Bank.
• Identified and quantified risk in loan portfolios and help establish effective strategic and capital planning processes.
• Stress testing at transaction level to assess the risks both at application level as well as at portfolio level.
• Developed models in R with Debt Service Coverage Ratio(DSC) and Loan to Value Ratio (LTV) as evaluation criterion. Zensar Technologies Ltd. Pune, India
Data Analyst January 2014 – July 2016
• Awarded excellence award ‘Star Achiever’ for outstanding contribution and commitment to the client.
• Lead a team of four to design and develop Oracle SQL reports to help the clients to make business decisions.
• Analyzed the data in database tables to resolve incidents and production requests.
• Assist in the ongoing process of ensuring compliance with Sarbanes-Oxley requirements across the organization.
• Conducted IT, operational and business risks reviews to determine and recommend nature, scope and direction of audits.
• Identified control deficiencies, process improvements and financial issues and proposed solutions for issues found. IIT Chicago – Kent Law Library Chicago, IL
Student Assistant February 2012 – August 2013
• Charged and discharged books, shelved books, helped the patrons and staff and performed responsibilities as required.
• Resolved technical problems related to computers software, printers and network. Assist patrons with their queries regarding locating books and articles in the library or requesting it from other libraries ensuring good customer service. ElectraCard Services (Now MasterCard) Pune, India
Engineer- Development November 2009 – July 2011
• Presented ‘Spot Award’ for the excellent efforts taken in the successful release of Middle East financial institution projects.
• Headed a team of seven resources and mentored new resources to get them up to speed with increased efficiency.
• Evaluated project deliverables with regards to ball park cost estimates, resource planning and delivery planning.
• Reviewed database design, forms and reports, PL/SQL functions, procedures, packages, triggers and other database objects for peers. Also, assisted with implementation support. Nalanda Information Technology Nagpur, India
Associate Software Engineer December 2007 – November 2009
• Designed table structure and forms to capture purchase order and sales orders details in the system. Programmed interface for General Ledger module to import journal entries from legacy system.
• Developed project deliverables using Oracle 9i, SQL, PL/SQL, Oracle Developer 2000 and Oracle Applications. SCHOLARSHIPS
Rawls Endowed Scholarship, Rawls College of Business 2016 National Overseas Scholarship, Government of India 2011 PUBLICATIONS
A Circulant Based Space-Time Coding for Multiple Input Multiple Output System in Fading Channels, IEEE International Conference on Electro Information Technology. 2013 A Survey on Rare Earth Doped Optical Fiber Amplifiers, IEEE International Conference on Electro Information Technology. 2013
Contact this candidate