Information Technology Data

**** ****** **** ***** ******* Patange ********@****.***.*** 914-***-****

Cary, NC 27518 www.mitaleepatange.com www.linkedin.com/in/mitaleepatangeiitgrad2016

EDUCATION

Illinois Institute of Technology, Master of Science in Information Technology Management GPA: 3.9/4.0 May 2016

University of Pune India, Bachelor of Engineering in Electronics and Telecommunication GPA: 4.0/4.0 June 2011

TECHNICAL SKILLS

● Languages/Skills: SQL, Oracle, PL/SQL, SSIS, SSRS, UNIX, ETL, Java, REST, SOAP, Data modelling

● Products/Tools: Aginity, Informatica, Tableau, AQT, Git, SAP Power Designer, Amazon AWS, BIRT, Rally, HP QC

● Databases: IBM DB2, Oracle 11g, Microsoft SQL Server, MySQL, Netezza and Teradata

PROFESSIONAL EXPERIENCE

North Carolina Farm Bureau, Raleigh, North Carolina Data Analyst July 2016-Present

● Performed a range of data warehousing and business intelligence tasks for database design and development of ETLs, Scripts using SQL so that data can be used across multiple platforms. Created dynamic web-enabled reports and queries for the enterprise using Open Text Actuate e.Report Designer

John Deere Technology Centre, Pune, India Software Engineer 2011-2014

Business Domain: Customer Registry, Machine Knowledge Center, John Deere Experience, JD Extended Service Plan.

● Strong experience in providing solutions/implementations in Data Warehousing using Hand-coded ETL Architecture, and DW Tools Power Center Informatica 9.x

● Responsible for all activities related to Requirement Analysis, Design, Development, implementation and control of ETL process for data warehouses. Experience in Full Life Cycle Implementation of DWH, client-server applications.

● Proposed and worked on enhancements: Effective Unicode conversion, Standardization and automation of MKC batch process, Use of Push down optimization for performance improvements (50%) for 200 million dataset, Repository Reports for metadata analysis which led to reduce the time of code review of Informatica jobs and impact analysis by 80%, Visio template to create multiple mappings, Copy structures from Target to Source automation

● Provided unsupervised 24*7 application support (phone/email/live chat) for addressing any issues reported which lead to increase in the customer satisfaction index by 45% and helped eliminate common issues with RCA

● As a Scrum alliance certified Scrum master, led a group to follow agile methodology practices for two projects

ACADEMIC PROJECTS

● Amazon AWS based Cloud hosted web application for Image Processing: Developed thumbnail generator for images application (HTML, CSS and PHP) hosted in Amazon cloud using AWS … more on GitHub

● Movie Production Database Application: Developed a Movie Production Database application using Oracle as the back-end and Visual Studio MVC Website as a front-end right from modelling till reporting phases.

● IT Help Desk Online Ticketing System: Developed a Ticketing System that can be used by IT help-desk teams for registering and solving defects raised by employees using JavaFX and MySQL

● Hadoop MapReduce Framework for analyzing top k records: Developed an application to aggregate the number of visits of an IP address from web anomaly, find top k in term of visits and export the analysis to a MySQL database

● REST and SOAP Service Implementation: A messenger application which provides RESTful Profile, Message and Comment services using Java EE and Jersey was developed and differences between SOAP and REST were studied.

● Statistical analysis of Real Time vs Streaming Media: Study of the network resource consumption of applications and transport protocols that deliver real-time media and those that deliver streaming media.

● UML Based Development for E-commerce website: Use of Design Process Improvement Model and Testing Maturity Model to develop design diagrams providing insights into business requirements.

● Research Papers: Big Data-Dealing with Hadoop's Security Model and Best Practices in Knowledge Management

AWARDS/ACTIVITIES

● Toastmaster International Certified Competent Leader and Communicator Sep 2014

● Certifications: PowerCenter Data Integration 9.x Developer Specialist

DB2 Fundamentals, Scrum Alliance Scrum master, C++ Programming

Contact this candidate