Isha Jain

• Developed and maintained ETL solutions, with primary focus on Data Warehouse design & administration

• Used ETL mappings to extract data from multiple sources comprising SQL Server, flat files and data marts

• Generated visualizations using Tableau & prepared reports for business users using SAP Web Intelligence tool

• Proposed adaptable solutions for day-to-day problems in villages.

• Got Second rank under 'Oracle Foundation' at national level

• Analysed demographic information & market trends to identify new revenue strategies

• Processed the data having more than 50% missing and highly skewed variables using log transformation

• Applied decision tree, neural networks, regression & combination of models to predict customers

• Gathered data for marketing reports to develop and implement marketing and public relation plans

• Researched industry-specific sites for product reviews of a firm and other relevant marketing information

• Administered google adwords campaign for a real world company to promote it on internet and increase profit

• Organised keywords into adgroups, adgroups into camapaigns while ensuring a clear adwords account structure

• Designed an application to provide automation of hotel reservation and billing system to front desk staff and online reservation facility to guests/customers.

• Analyzed the business situation of a hotel and designed computer based information system using object oriented methodologies resulted in increased revenue.

• Designed and developed a database management application for a fast food chain using SQL server and MS access

• Analysed issue and proposed a solution to reduce processing time of order to increase sales

• Created ER diagram in ERWIN modeller. Solutions were proposed for the problem of record maintenance and timing issues while taking orders.

• Whole system was made online while taking care of customer's convenience.

• Designed an embedded based system in 'C' to enhance the security level of the vehicles. GSM system was enabled to track the vehicle and identification codes were used to identify the owner of the vehicle.

• Whenever unauthentic access was tried the system sends the sms to the owner about the activity and stops the engine as per the command by the owner.

• Designed and executed the advanced development in embedded systems for energy saving of street lights by using electronic components.

• The main purpose was to save electricity by switching on the street lights during night and switch it off during day time automatically.