Data Software Engineer
Resume:
Kamiya Chaudhary
***************@*****.***
Objective:
To obtain the challenging position in an organization where I can use my technical and analytical skills to provide solution to complex problems.
Skills Summary:
Object Oriented Concepts, JAVA, RESTful Web Services, Oracle PL-SQL, Toad, Android application development, Spring MVC framework, GIT, Agile development and SCRUM methodology, My SQL, Database performance optimization by writing and managing indexes and table spaces, ERD modelling, design and development using ERwin Data Modeller, designing and developing database architecture for migration, ETL tools like Oracle Warehouse Builder, knowledge of data warehousing, OLTP, and OLAP.
Education:
Master of Science in Computer Science from California State University, Sacramento, Jan 2013 - May 2015
Bachelor of Engineering in Computer Engineering from Thadomal Shahani Engineering College, Mumbai University, 2004-2008.
Employment History:
Employer – Vision Service Plan
Designation: Developer Intern May 2014 - May 2015
Work Performed:
Enhance the features on the company website using technologies like HTML, JavaScript, Struts 2.
Refactored Java the code to improve quality based on Sonar rules such as setting a threshold for method complexity, code conventions etc.
Worked with Project Managers and other members of development team to both develop detailed documents and to ensure timely completion of deliverables.
Followed Agile environment using SCRUM methodology.
Analysed, developed and tested the security issue with VSP website.
Some of the security threats that were taken care of were Cross-Site scripting, HTTP Strict transport security, Clickjacking, Insecure data caching.
Used Python scripts to manipulate data from CSV files and send service notification emails.
Employer – Capgemini Pvt. Ltd.
Designation: Senior Software Engineer Jan 2010 – Aug 2011
Work Performed:
Developed, tested, debugged and optimized complex queries (DML and DDL), functions, views, triggers, stored procedures and PL/SQL blocks using TOAD 9.5.
Analysed, designed, tested and developed the data models and database architecture for migration.
Implemented and supported the database activities such as tracking defects in Quality Centre and JIRA.
Analysed data requirements, system components, data dictionaries, and database.
Analysed, developed and tested the data in AMS - Address Management System.
Interacted with clients to understand requirements and potential issues, and translated them into technical specifications to enable the development of high quality solution.
Provided technical support during production release.
Coordinated with off-site DBA, troubleshoot the production database issues, and performed database operation support as needed.
Designed and developed ETL processes to manage data from disparate sources.
Executed, maintained, troubleshoot and document manual and automated reports.
Analysed, designed, developed and tested source to target Oracle Warehouse Builder mappings where application data is synchronized with new service centre application.
Achievement - Received Delivery Excellence award from clients and VP of Capgemini for Document Generator release.
Employer – ICICI Bank Limited
Designation: Software Engineer Oct 2008 – Mar 2009
Responsibilities:
Analysed, developed and tested Java programs to meet requirement specification.
Refactored the code to meet the coding standards and as recommended by senior staff.
Wrote SQL queries to extract data related to dormant accounts from OLAP database for analysis.
Implemented complex business rules by analysing internal business activities of the ICICI Bank.
Worked and coordinated with various departments such as loan, tax etc. to work within deadline.
Masters Academic Projects:
Project 1
An Android application for vision insurance company that enables the user to view their benefits with in/out of network providers. The user can find a doctor based on location, doctor name, office name, products and services. The user can navigate to the doctor's office using Google Directions API. The user can make payment using the registered accounts, credit card or PayPal.
Work Performed &Technical Skills:
Developed application using Spring MVC Controllers in Spring Tool Suite integrated environment.
Designed and developed the user interfaces such as login page, home page, payment page, navigation page etc using Android/Java.
Implemented auto fill feature for text box when user enters characters for source and destination using "Place AutoComplete - Google Places" REST API.
Used "Google Directions" REST API to retrieve different routes.
Implemented payment process using Paypal Mobile Payment Libraries.
Used Genymotion emulator to simulate end user experience for application.
Designed data model and used MySQL to store data.
Used JDBC API to access and modify data.
Project 2
A data mart to capture accurate records of fuel pricing for United States from 1995 - 2014. Implement the KDD process to understand variance in fuel pricing.
Work Performed &Technical Skills:
Designed and developed as STAR schema as a data mart for fuel pricing in MySQL.
Extracted data from various sources like csv, excel files to be transformed and loaded into the data mart using complex SQL queries.
Extracted raw data needed cleaning in which the missing values were filled by a default value, date format was transformed into compatible format.
Various OLAP operations were performed using slicing, dicing, drill down and roll up.
Used Linear, KNN, Polynomial Regression in Rapid Miner to generate graphs and understand the variance in fuel pricing.
Technical Certifications:
●Oracle 10g OCA certified
Contact this candidate