Sql Server Project
Resume:
SARAYU JAVALI PAI
Oviedo, FL *2765
205-***-****, **********@*****.***
OBJECTIVE:
To be part of an organization with a challenging and progressive environment.
TECHNOLOGIES:
.NET
C#, VB
Other Languages
PHP, Objective C
Web Technologies
ASP .NET, ADO .NET, HTML, CSS, XML, Wordpress
Databases
MS SQL, Oracle, MySQL
Tools
Vantive, Axure, MS Visio, Citrix tools, Subversion, GIT, Postman, SourceTree, XAMPP
IDE
Visual Studio, VS Code, SQL Pro, MySQLWorkbench, XCode, SQL Server Management Studio
Operating Systems
Mac OS X, Windows, Linux
Scripting Languages
Javascript
EDUCATION:
Master of Science in Electrical Engineering May 2010
University of Alabama at Birmingham
Bachelor of Engineering in Information Science and Engineering July 2005
Vidya Vardhaka College of Engineering
Mysore, India
PROFESSIONAL EXPERIENCE:
Learning Systems Analyst, Florida Virtual School, August 2016 – Present
Provide support to staff in order to make the process of course migration and delivery on time
Develop tools to improve efficiency in course migration and delivery
Explore innovative means of delivering courses
Maintain server and continuous integration of courseware
Proficiency in Learning Management Systems and issues
Technologies: PHP, Wordpress, MySQL, GIT
Programmer/Analyst, Communications Test Design Inc., October 2015 – June 2016
Provided support to the workers and staff with the existing application for Bright House Networks (BHN)
Design and develop enhancements to the application according to the requirements provided by the staff
Worked on new project to create application for technicians to be allocated units
Create reports for staff to analyze and assess daily productivity
Writing SQL queries in order to debug issues relating to day-to-day work in the warehouse
Develop and maintain web services that provided interactions between CTDI and BHN
Worked on developing application using java script in order to develop a touch screen based application which was an enhancement to existing refurb application
Technologies: Oracle 10g, Visual Studio 2010/2013
Independent Contractor, Information Technology Division at University of Alabama at Birmingham
August 2015 – Present
Working with the staff to develop reports for the existing database
Involves writing queries in addition to views and functions whenever necessary.
Technologies: SQL Server 2012
Programmer/Analyst, Division of Continuing Medical Education, University of Alabama at Birmingham, April 2010 – January 2014
Liaised with research staff, faculties and physicians to analyze and design requirements in order to build optimum solution
Used agile methodology to develop projects and provide time estimation for projects with Axosoft tool.
Designed and developed web-based solutions for physicians and care-givers by providing needs assessments and credits
Designed web templates to provide the look and feel of the applications
Involved in testing applications and updating data and contents on a regular basis
Involved in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating workflows to migrate data to SQL server from Access and Excel sources
Created database objects like Tables, Stored Procedures, Views and Triggers.
Provided maintenance and support for existing projects which included regular batch uploads of data using SSIS
Technologies: ASP.NET 3.5/4.0, Visual Studio 2008/10, SQL Server 2008, MS Business Intelligence Studio
Project Engineer, Wipro Technologies Ltd, Bangalore, India, November 2005 – October 2007
Tested products built by Citrix Systems such as Citrix Web Interface and ICA clients. The testing techniques followed were black-box, regression, system testing and globalization testing.
Modified and executed test cases
Tested the compatibility of Citrix products on various platforms
Involved in integration testing of Citrix products with a variety of products developed by Microsoft.
Technologies: Citrix products
Graduate Student Assistant, University of Alabama at Birmingham, January 2009 – May 2010
Involved in analysis, design, development of an oil and gas exploration game on iPhone.
Deploying and testing the game on multiple iPhone clients. This project also involved developing the requirement document, design document and finally the project wrap-up report.
Technologies: XCode, Objective C, Cocoa Touch
Retrieving registrar and contact information for phishing sites
Involved using the existing database of phishing sites to retrieve information and display only the relevant information to be used further by law enforcement agencies.
Technologies: Perl in Linux, Postgress
PROJECTS:
Wordpress Plugins as Efficiency Tools: This was an effort to improve in various aspects of course migration and delivery by automating some of the processes and improving time and efficiency.
Technologies: PHP, Wordpress, MySQL
Smart Curriculum Course Hierarchy: This project involved process to include standards and hierarchy within a course by manipulating the existing course cartridge.
Technologies: PHP, XML, Postman
Performance Improvement for Pain Management (PI4pm): This project was to provide primary care providers an online experience targeting the management of patients with non-cancer chronic pain.
Technologies: ASP.NET 4.0, C#, CSS, Visual Studio 2010, Adobe Fireworks and Dreamweaver
Role: Was involved in requirement analysis, designing the user interface, database design, implementation which also included creating extensive stored procedures, testing, release and maintenance of the project.
CME Certification Management System: This project was a collaborative work between CME and QueCentric LLC to create a centralized environment through which assessment participants can access all their certification information from a single point of entry.
Role: Was involved in designing a single database in which all the project data needed to be migrated. I worked in developing SSIS packages to migrate major part of data from Access database to SQL server, and data from other databases.
Technologies: SQL Server 2010, MS Business Intelligence Studio, SSIS
Hepatitis Web Study: This project involved relaying participant information and the assessment scores to and from the CME website to UW website using XML and also providing assessment, certificates and transcripts.
Role: Worked with the UW project staff for requirement analysis. I was involved in analysis, design, implementation, testing, release and maintenance of the project. I also designed the user interface for the site.
Technologies: ASP.NET 4.0, C#, CSS, Visual Studio 2010, SQL Server 2010
CERTIFICATION:
Citrix Certified Administrator for Citrix Presentation Server 4.
AWARD:
TITANS in recognition of excellent contribution in testing services.
PUBLICATION:
Sarayu J. Pai, Vaibhav Gathibande, S. Brande, and M. M. Tanik, “Oil and Gas Exploration Game for Geoscience Students”, Proceedings of the Fourteenth SDPS Transdisciplinary Conference-Workshop on Integrated Systems, 2009, pp. Not Applicable, Montgomery, AL, November 1-5, 2009.
PRESENTATION:
Oil and Gas Exploration Game presentation for Graduate Research Days at University of Alabama at Birmingham, AL, on 02/24/2010.
Contact this candidate