Post Job Free

Resume

Sign in

Sql Server Project

Location:
Oviedo, FL
Posted:
November 18, 2017

Contact this candidate

Resume:

SARAYU JAVALI PAI

**** *** **** **.

Oviedo, FL *2765

205-***-****, ac3d0o@r.postjobfree.com

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