Mounika Nasini

Experience

• 

  Firewin Safety Engineers - India

  May 2010 - Jun 2013

  Data Analyst

  • Perform complex analysis of data preparing reports for use by fire staff and manager. • Cleansing large datasets for analysis, develops and manages data standards and reporting tools.• Regularly analyzes the performance measurement process to ensure improvement of organizational efficiency and effectiveness including the use of performance indicators.• Implemented data modeling. Transformed logical models into physical models and then deployed into SQL server databases during database design implementation. • Identified the entities, attributes and relationships and deployed them as physical databases in SQL Server.• Deployed Database schema changes in the development, testing and production environments.• Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.• Migrated and Upgraded SQL server 2005 databases to SQL server 2008 environment using upgrade advisor and tested the application.• Provided 24/7 critical production support for data issues and given appropriate solutions. Show less

• 

  University of Arkansas at Little Rock

  Aug 2013 - Dec 2013

  Programmer

  • Programmer on synthetic data generator using JAVA• Creating and developing program for the quality measuring of the synthetic data • Maintained and debugged program• Entity Resolution Data Challenge: Performed data cleansing, data standardization and entity resolution on a student’s dataset of 272000 records. • Sentiment Analysis of Twitter data using NodeXL• Mapping Airline routes using R programming to show the routes (visualization) of each individual airline carrier and used Tableau to show the market share of each airline in each individual state• Developing particular web pages related to library using WordPress, receptionist duties and designing content through Microsoft Word and Excel.• Deployed Database schema changes in the development, testing and production environments.• Prepared reports on online initiatives, including charts and graphs, and presented recommendations for action plans to management Show less

• 

  Provost, University of Arkansas at Little Rock

  Jan 2014 - Aug 2014

  Web Developer and Web Data analyst

  •Responsible for designing and editing of new websites in collaboration with the Associate Vice Chancellor for Academic Affairs, the Academic Editor and the college liaisons. •Design of newly created college websites and editing webpage content•Planning and coordination of the launch of newly designed websites with additional tasks as needed•Developing and editing already existing website using WordPress with HTML and CSS •Analyzed web site performance and trends, using results to implements changes to website•Measuring and analyzing the users\visitors data and maintaining quality of the website.•Improving the quality data in web pages without any broken links and applying web mining in order to analyze the data for the marketing of the websites. •Used R language in order to apply web mining to the analyze the data•Delivering weekly, monthly reports (excel, BI tools)•Create, maintain and improve analytics report •SQL codes are heavily used for all the analysis purpose•The data can be analyzed with the client data from web analytical tool that has tracking code and has to entered into the website in order to collect the users data.•Used JavaScript in the WordPress to avoid of tracking code visible in the main script•Process involves of writing SQL queries and TSQL functions to analyze particular attributes of a database table and rewrite the queries to modify the database for validation. •Used Tableau to show the visualization of the website data which is interacted with clients data.Environment: Windows 7, Mac OS, WordPress, HTML, CSS, R Studio, MS SQL Server 2012, MS Access, SSIS, SSRS, SQL Profiler, Tableau. Show less

• 

  University of Arkansas at Little Rock

  Sept 2014 - Dec 2014

  Web and Social Media Coordinator

  • Leading social media communications for the college, collaboration with college staff and faculty to keep website content current and in line with best practices for web communications• Attended events to take photos and uploading them into social media and the website. • Produced several posts that included original podcasts, videos that I created.• Planned and oversaw the organization’s promotion activities specifically linked to its web presence• Managed content from internal thought leaders and community for placement on the homepage using HTML and CSS.• Excellent Knowledge in WordPress for editing, maintaining and creating new websites for the college.• Created a messaging services for text and voice communication for the students and advisors • Created and engaged with social networks such as Instagram, Facebook and Twitter Show less

• 

  Arkansas Department of Information Systems (DIS)

  Aug 2015 - Mar 2020

  Production support and Database Administration

  As a SQL Server DBA, I have migrated 2005, 2008/2008R2 databases to 2012 and also to 2016 SQL Server in Production and Development environments. Performing backups and restores using LiteSpeed tool through T-SQL. Having experience on importing and migrating SSIS packages to 2012 and 2016 server on production and development environment and also creating SQL agent jobs to execute the package according to scheduled time.Assigning SQL Server roles and granting permissions. Monitoring and resolving Blocking\deadlock issues. Implemented Ola-Hallengren maintenance plan.Wrote T-SQL queries to manipulate data for data analysis and reporting.Troubleshooting user\login issues on the server. Verifying and resolving disk space issues. Experience in creating and maintaining data objects like Stored Procedures, tables and views. Having knowledge on SSRS design. Experience on SQL Server Profiler and Extended Events. Providing 24 x 7 on call support for Production environment. Gaining experience on UNIX UDB server. Show less