Sql Server Project

Deepthi Nama Alexander

Cell: 609-***-**** *.****************@*****.***

Professional summary

Experienced business and systems analyst with 2 years of IT experience. Demonstrated strengths include process analysis, technical troubleshooting, project leadership and communication skills. Seeking a position on a challenging and collaborative development team.

Around 2 years of IT experience as software analyst and quality assurance.

Experience in providing application production operational support for Enterprise systems across AT&T.

Understanding of QA methodology (Agile, Waterfall) to ensure quality control

Exposure to ETL testing with good SQL skills

In-depth understanding of database development, business intelligence, development and testing

Experience in managing firewall and regular status reports of the trouble tickets

Worked on UNIX servers, ORACLE database

Knowledge of SQL server 2012 & 2008 R2 – in creating views, triggers and SP’s etc.

Knowledge of SQL server Integration services (SSIS), ETL processing, RDBMS, stored procedures, Triggers, Functions, Views, Jobs, Alerts.

Worked on visual studio 2008/2010 to design GUI using .Net

Worked collaboratively with QA, development and business groups to complete comprehensive testing on releases

Documented and reported bugs, errors interoperability flaws and other issues within the applications and worked closely with the development team to resolve the issues

Ability to lead, train and maintain an enthusiastic, productive team.

Experience with C# and VB.Net.

Persistent and driven; acquired second Master’s degree.

Excellent computer skills, applications related to MS Office.

Very good interpersonal and communication abilities.

Core Qualifications

Extensive knowledge of IT procedures and available technology solutions

Strong ability to coordinate with external or internal clients

Ability to analyze clients existing systems and business models

Solid understanding of software development lifecycles

Excellent brainstorming abilities

Ability to meet strict deadlines

Ability to learn anything faster and perform well at any given tasks

Strong analytical skills

Skills

C, C++, T-SQL, PL/SQL, VB.NET, C#, UNIX, HTML Script, VMWare

RDBMS: SQL Server 2012/2008, Oracle, Microsoft Access

Testing: Test cases, Plans and scripts, Defect and Bug discovery, System and Unit testing, QTP, LoadRunner, Putty, Toad, Tracking, Logging and reporting, Issue identification.

Development Tools: Visual Basic, Visual Studio 2008/2012, .NET Framework Manager

SQL Server Tools: SQL Server Integration Services, SQL Server Reporting Services

Internet marketing

Digital media

Business development

Organized

Software Development Methodologies: AGILE, Waterfall Models

Operating Systems: Windows Server 2000/2003/2008, Windows XP/7/8

Competitive and strategic planning

Blogging

Web management

Superb writer and editor

Copywriting

Team player

Persuasive

Professional Experience

System Analyst 01/27/2014 – 05/30/2015

TechMahindra

Collaborated with developer’s testers and end users to ensure technical compatibility.

Mapped and documented interfaces between legacy and newer systems.

Developing solutions for existing products and systems.

Managed mission critical application ensuring uptime, responsiveness and SLA’s

Managed new builds and server deployments.

Worked on AOTS ticketing system resolving the customer issues within specified SLA.

Handled Live issues and Change requests (CR).

Documented the design process of application and the usage guides for interfaces.

Performed deployment and sanity testing of the applications on every new release.

Performed DR (Disaster Recovery) or Failover activities in case of service failure.

Coordinated with the interface teams and processing their requests.

Actively participated in enhancement meetings, project review meetings, weekly status meetings and various other meeting which were focused on making the application more effective.

Identified, documented and reported bugs, errors, interoperability flaws and other issues within the applications and worked closely with the development team to resolve the issues.

Provided continued maintenance and development of bug fixes and patch sets for existing web applications.

Diagnosed and troubleshoot UNIX and Windows processing problems and applied solutions to increase company efficiency.

Ensured network, system and data availability and integrity through preventative maintenance and upgrades.

Provided documentation on start-up, shut down and first level troubleshooting of processes to help desk staff.

Consistently met deadlines and requirements for all production work orders.

Trained Junior members of IT team regarding network security and troubleshooting the mission critical application.

Intern (SQL) June 2013- Jan 2014

Donato Technologies Inc.

Worked on SQL server, upgrade service packs.

Developed and designed database system tables, views, indexes and stored procedures.

Created and managed Tables, stored procedures, views.

Learned ETL process and reports using SQL queries.

Worked to establish connectivity between VB application and MS SQL server.

Used data partitioning in SQL server 2005.

Validated ETL process and reports using SQL queries.

Education

Master of science in Business April 2017

University of Mary Fargo, ND

Coursework includes: speech and communication, Marketing and Advertising, Project Management. GPA 3.8

Master of science in Information systems December 2012

University of Mary-Hardin Baylor Belton, TX

Continuing education in Project management, Graphic design coursework

Bachelor of Science: Information Technology May 2010

Continuing education in information technology, coursework includes Mass communications and communication studies.

Group Project,

University of Mary

Worked with a team on Project management, following the phases in the software development lifecycle.

Prepared the timeline using the Microsoft Project.

Performed risk analysis of the project.

Prepared the budget.

Shared the roles of being a project manager every week.

Did a literature review on how to bring quality of service in healthcare using Project Management lifecycle and change management.

Thesis,

University of Mary Hardin- Baylor

Designed networking website developed for the University of Mary-Hardin Baylor.

Developed the user interface for this website using ASP.NET technology.

This application is secure and it keeps the user's personal information confidential.

It took 6 months to design the web pages and it also took about 3 months to develop the database for

this project.

This web site will keep the track of all the student login details and it also will save the data about

the student's interactions.

Experience in writing test cases, drawing the ER diagrams.

The software development life cycle (SDLC) helps us in developing a system.

It helps us in moving from one phase to another.

Each phase has some activities that give some deliverable/ output.

Group Project,

Techno Fin Company

The project was to design a website for job seekers so that they can choose the location and the type of job they want and then post their resume.

Responsibilities:

Followed the Project management life cycle to finish the tasks.

Managed project deadlines and monitored milestones through completion stage.

Nexxoft infotel ltd.,

This project was designed for the admin and employers. We were to design a website for the employees so that the admin can control all the information about a particular employee. The admin and the employer have a different login authorization.

References: Available upon request

Contact this candidate