KARISHMA MEHTA

**** ****** **, *** #****, Santa Clara, CA 95050, 562-***-****, acudy8@r.postjobfree.com, https://www.linkedin.com/in/karishma1412, http://www.karishmamehta.info Available from May 2016

• Good analytical and debugging skills gained through industrial experience SUMMARY

• Experience with ETL Tools - Informatica, MSBI Stack, SQL, Data Analysis, SAP Business Objects

• Excellent database skills – Oracle/ PL-SQL / T-SQL / MySQL/ MS SQL Server

• Experience with Databases, Web Services, Software Development,Testing and Quality Assurance.

• Experience in coding languages like Java, .Net, Python, PHP with MVC framework

• Database: Oracle 10g/11g, MS ACCESS, MS SQL Server, T-SQL, MySQL TECHNICAL SKILLS

• ETL & Reporting Tool: Informatica 9.5, Business Objects, IBM Cognos, Tableau, MicroStrategy, SSIS, SSRS

• Programming Languages: C, C++, Java, Python, R

• Web Technologies: HTML5, CSS3, ASP, AJAX, JavaScript, JQuery, Bootstrap

• Scripting Languages: PHP, SQL, PL/SQL

• Version Control Systems: SVN, Git

• Issue and Project Tracking software: JIRA

• Tools: Eclipse IDE, NetBeans IDE, MySQL Workbench, SharePoint, SQL Server Management Studio, Visual Studio

• Operating System: Windows, Linux, MacOS

ETL Developer, California State University Long Beach Jan 2016 – Present EXPERIENCE

• Develop basic and execute complex ETL (Extract, Transform and Load) scripts to transform ERS flat files into uniform structured data format.

• Develop and run ETL scripts for tabular and non-tabular data

• Create and execute basic and complex stored procedure.

• Used Tableau dashboard for reporting and data visualization.

• Working on developing web application on Java and JSP to be used across the university. Software Development Intern, Internet Brands, CA June 2015 – Aug 2015

• Implemented enhancements to base designs in object-oriented PHP using the MVC patterns.

• Identified and resolved many tickets on JIRA by providing enhancements to code and ensuring the code is 100% error free.

• Communicated well with the team and clients to understand requirements clearly and implement those requirements.

• Worked on technologies such as PHP, JSON, CSS3, Ajax, jQuery, Wordpress to handle various requirements.

• Developed RESTful web services in Java.

• Experienced developing rich client side applications and user interface using Bootstrap Database Developer, ROI Engineering LLC, CA Jan 2015 – June 2015

• Was a part of Software Engineering team for developing database and MS Access forms which was used for plating of an airplane landing gear.

• Created 35 T-SQL Stored Procedures using SQL Server to get data based on various inputs regarding the tank and tank cells

• Developed and enhanced 15 MS Access Forms and 1 Master form to insert/update/delete data in the database

• Performed validations using Visual Basic scripts on the MS Access forms according to the database Software Engineer, Accenture Services Pvt. Ltd, India Jan 2013 - July 2014

• Responsible for development of Enterprise Data Warehouse using ETL tool Informatica PowerCenter 9.5, SQL Server Integration Services(SSIS) and SQL Server Reporting Services(SSIS) with databases like Oracle

• Created high level and low level documents. Designed and implemented 5 re-usable components (Mapplets, Scripts). Developed stored procedures, triggers, views and functions in SQL.

• Implemented error handling, SCD Type2 and reconciliation framework for 40 EDW Mappings

• Developed 120 source to ODS (Operatinal Data Store) and ODS to EDW mappings and tested the same

• Performed System Integration Testing (SIT) and also deployed all mappings from Dev to UAT and UAT to Production

• Created reports in SSRS to aid data discovery and visualization

• As a Production support engineer generated daily status reports over 6 months for the client, monitored the status of the EDW data load and also used version control tool SharePoint.

• Wrote complex queries in SQL to fetch data from source systems and load it into data warehouse.

• Performed root cause analysis on the data been received from source system. Software Engineer, Ritz Softec, India Jun 2012 - Jan 2013

• Designed and developed web applications in various domains such as Image Processing, SMS based services.

• Followed agile methodology with the principles of SDLC. Experienced with object oriented design, coding, testing patterns, and programming languages (Java, C++, C#, Python)

• Produced high quality software that is unit tested, code reviewed, and checked in regularly for continuous integration. CERTIFICATIONS

Oracle Certified Associate 11g Jan 2016

R Programming – Coursera Certified Nov 2015

License Number: XHMSQ53XPR Marks Secured: 80%

California State University Long Beach, CA GPA: 3.7 EDUCATION

Master of Science in Computer Science May 2016

• Courses: Database Management Systems, Operating Systems, Adv. Programming Languages Advanced Algorithms, Software Architecture, Mobile Application Development (Android SDK), Data Structures, Object Oriented Analysis and Design, Design Patterns and Refactoring K.J. Somaiya College of Engineering, University of Mumbai, India GPA: 3.91 CAPTCHA Solver Python Aug 2015 – Dec 2015

ACADEMIC PROJECTS

It was an application developed in Python which could read the CAPTCHA and break it. K nearest neighbor algorithm was used. It was based upon machine learning and specific libraries of Python such as numPy, opencv, tkinter,gtk+. This system also gave the probability calculations which could say the failure probability and success probability of the system. MindMonitor Application Android SDK Jan 2015-Apr 2015 This app facilitates storing various readings such as meditation level, blink level and attention level of particular person to be stored into app at various locations using a hardware device and interfacing the device with the app using Bluetooth. It can be of great use in Health Care Industry. https://www.youtube.com/watch?v=LWy9hWHeRkQ&feature=youtu.be CSULB Health Management System PHP, JavaScript, MySQL Aug 2014 - Dec 2014 Developed application in PHP to manage upcoming appointments, accept feedback from students and set automated reminders to enhance functionality of the application. Developed cron jobs to send automatic emails. http://www.karishmamehta.info/health/

Graphical Password Authentication Java Jan 2011 - Jun 2011 This project was an enhancement to traditional ‘Login Id- Password’ mechanism to enter a system. The login id is same every time user logs into the system, but password is displayed in a matrix of 9*9 buttons displayed on the screen and user needs to provide some valid button clicks based on the algorithm and password.

• Awarded as a ‘INSTANT KARMA AWARD’ in Accenture

AWARDS

Sandesh Mittal (Team Lead, Accenture)

RECOMMENDATION

Accountability and Reliability are two perfect words which suits Karishma’s work style. Working with Karishma was always enjoyable. Her approaches in problem solving always impressed me and she is also a real team player and extremely focused in work. Always manages to complete her tasks without any distraction. Excellent resource will prove to be an asset to any organization

Contact this candidate