Data Management

AJINKYA TELVEKAR ***, Schiller St., Apt ***, Itasca, IL-60143

Email: *****@******.****.***, *******.********@*****.*** https://www.linkedin.com/in/ajinkya~telvekar Phone: 630-***-**** Summary:

• Dynamic and result-oriented professional with exceptional BIA (Business Intelligence & Analyst) skills.

• Expertise to deliver compelling solutions by mining the data, creating dashboards and generating reports through ad-hoc analysis with additional emphasis on Database.

• Business Intelligence strategic thinker with splendid communication and technical expertise to figure out market potential and business trends, support and maintain data models corroborating BI.

• Knowledge of Big Data, Data Mining and developed data patterns in competitive markets, products and share performance.

• Hands-on experience dealing with queries including stored procedures, functions, triggers, views and leading NoSQL databases.

• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT& dimensions tables, physical & logical data modeling.

• Deep understanding of agile methodologies, SCRUM and SDLC phases like Requirement Specification, Analysis, Design, Implementation, Testing, Deployment, and Maintenance with various methodologies.

Programming Languages: R, Python, C, C++, Java, VB.NET Tools: Tableau, Cognos BI, R studio, Informatica, MicroStrategy, MS Power BI, MS Visio, Eclipse, Visual Studio 2010, Dreamweaver

Web Technology: HTML5, CSS, XML, JavaScript

Database: MongoDB, Oracle 9i/10g/11g/12c, PL/SQL, MySQL, EM Express, MS Access Networking: Wireshark

Operating Systems: Linux, Mac OSX/Yosemite, Windows XP, Windows Vista, Windows 7 Adobe Photoshop experience in enhancing and editing Education:

• Middle Tennessee State University Murfreesboro, TN, USA Master in Computer Information System (CIS) Spring 2016

• Bharti Vidyapeeth University, C ollege Of Engineering Pune, MH, India B.Tech Computer Engineering July 2013

Experience:

• Community Health Systems (CHS) 01/16 – 05/16

IS - Intern

Business Intelligence Analyst

• Maintaining and analyzing optimal Clinical data and deployment of portal activity of different facilities (hospitals) to process daily BI reports.

• Managing all process and activities at client end, analyzing user's requirements, developing test schedules, reviewing testing plans, tracking and documenting the development and results of these plans, and maintaining data used in departmental databases.

• Support Cognos BI applications tools and maintain all the documentation for Cognos reports and create ad-hoc queries extracting information from the datamart.

• Analyzing the patterns of the daily BI reports and determining the creeps.

• Acted as liaison between business units and technology groups to identify business processes and system requirements including the implementation of an executive portal to deliver knowledge content and Analytical Reporting.

• Performing Regression and Integration testing of the portal both independently to analyze the Patient Health Records (PHR) and transactions.

• Coordinate and perform in-depth tests, including end-user reviews, to modify new systems to ensure they meet defined system requirements.

• Troubleshooting EHR issues of the patients by creating tickets and assigning to the right facilities.

• Middle Tennessee State University 08/14 – 05/16

Department of Computer Information System

Graduate Teaching Assistantship

Assisted: Computer Lab

• Capita India Pvt. Ltd. 03/14 – 08/14

Process: Next (UK)

Image editor and Advisor

Interface in creation of official website www.next.co.uk (front end)) Academic

projects:

Master of Science Spring 2016

• Data Mining and Predictive Analysis:

• Creation of interactive dynamic dashboards in tableau by analyzing data on retail metrics.

• Integrating R with tableau establishing Rserve.

• Use of Tableau and SQL in data modeling, data collection, data analysis and reporting to procure ETL from various sources as well as database structures to report and provide solutions in a timely manner.

Master of Science Spring 2016

• Seminar in Database Management:

• Accessing server through VM, updating and accessing server database using command line arguments.

• Created RMAN Incremental backups: Level 0, Level 1 Differential and Level 1 Cumulative, through the Server.

• Performed Data Analysis for Online Transaction Processing (OLTP), Data Warehousing

(OLAP)/Business Intelligence (BI) applications.

• Support for administrative tasks such as storage and user management using EM Express.

• Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management. B.Tech 05/12 – 04/13

Home Automation using Cloud Network

(An Automation system where devices are controlled with use of Cloud services with the interface of Android/ Computers based on J2SE)

B.Tech 01/11 – 05/11

Student Management System

(Mini project based on student management system. Used Oracle 9i) Diploma 05/09 – 06/10

Separation of Text from Mixed Text/Graphic Images

(An automated system that separates text from graphics images. Used VC++) Extracurricular

activities:

Stood first in University level photography competition named as Krasa held by Bharati Vidyapeeth University, which was sponsored by National Geographic Channel.

Contact this candidate