Sql Server/BI

Name: Mounika (recent graduate)

Email: *.*********@*****.***

Phone no: 337-***-****

Place: Atlanta,GA

Professional Summary:

• Overall 1.5 years of experience in design, development, administration, maintenance and analysis of

Databases using Microsoft SQL Server 2012/2008R2/2008/2005/2000.

• Experience as Microsoft BI developer (SSIS, SSRS, and SSAS).

• Conversant with all phases of Software Development life cycle (SDLC) including development, designing,

analysis, coding, testing and implementation.

• Hands on experience in writing advanced T-SQL queries like Stored Procedures, Triggers, Views, Functions,

Clustered and Non-Clustered Indexes, Cursors etc.

• Knowledge on Data Transformation Services, Data Cleansing and Data Migration.

• Experienced in Data Extraction, Transformation and Loading (ETL) between homogeneous and

heterogeneous systems using DTS and SSIS.

• Experience in creating reports using SSRS (SQL Server Reporting Services) and Crystal Reports.

• Knowledge on designing and building Dimensions and Cubes with Star schema using SSAS (SQL Server

Analysis Services).

• Knowledge on writing MDX queries.

• Knowledge on migrating DTS packages, reports and Analysis Services projects from SQL server 2000 to

SQL server 2008.

• Knowledge on using tools like MS SQL Profiler, Database Engine Tuning Wizard, Windows Performance for

monitoring and tuning SQL Server performance.

• Knowledge on programming languages like java and .NET

• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging

client needs and attention to detail.

• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member and

managing the data quality issues.

• Knowledge on database administration tasks like backup and recovery.

• Knowledge on scheduling jobs, setting alerts, user logins and access rights based on user roles, permissions

and security requirements.

Skill Set:

Databases:

MS SQL Server 2005/2008/2012, MS Access, Oracle 11g

Microsoft technologies:

MS SQL Integration Services (SSIS) 2012 and 2008, MS SQL Reporting Services(SSRS)2012 and 2008, MS SQL

Analysis Services(SSAS)2012 and 2008,Microsoft Office Share point Server 2010,Microsoft Visio, MS Excel, MS

Word, Microsoft Outlook

Software:

Visual Studio .NET 2012, SQL Server Management Studio, SQL Server Business Intelligence Studio

Programming:

T-SQL, .NET, JAVA, C, C++, HTML, VISUAL BASIC, PL/SQL

Architecture:

Relational DBMS, Client – Server Architecture, OLTP, OLAP

Operating System:

WINDOWS 2003/2012 ADVANCED SERVER, NT & WINDOWS 9x, LINUX

Educational Qualifications:

Bachelor’s Degree:

Gitam University, India

Academic Percentage: 83.4%

Master's Degree: (recent graduate Dec 2014)

University Of Louisiana at Lafayette

Major: Computer Science

GPA: 4.0

PROFESSIONAL EXPERIENCE:

UNIVERSITY OF LOUISIANA AT LAFAYETTE Jan 2013 - May 2014

GRADUATE ASSISTANT

• Worked as a Graduate Assistant in University of Louisiana at Lafayette where I worked with MS Access and

MS SQL Server 2012.

• Worked as a System Administrator where I was in charge of several tasks like installing several software in all

the systems of Computer labs, repairing the printers when they get jammed, helping out the students with the

computer operation, clarifying their doubts on how to use various software, issuing tickets for any problems

related to computers in the lab and repairing them. Also, performed several other tasks according to the

instructions of the supervisor and organized several meetings for the new Student Workers.

• Attended calls from different departments of the University regarding printout pickups, technical problems

and other issues.

• Provided help desk assistance to students where I answered phone calls from students and staff and helped the

students who come in to the office.

• Worked on a project which involved writing SQL queries and applying concepts like normalization as a part

of designing and maintaining the database.

• Worked on academic projects that involved programming in java,.NET and python.

SSIT TECHNOLOGIES,INDIA September 2011 - April 2012

SQL AND ACCESS DEVELOPER/BI DEVELOPER

SSIS Technologies is a leading IT training Institute which trains thousands of IT aspirants on various technologies.

Responsibilities:

• Developed and maintained Microsoft Access and MS SQL databases.

• Worked with client to discuss database requirements and developed system documentation.

• Imported data from existing system

• Designed user interface for database

• Developed complex programs in T-SQL\PL-SQL by using advanced T-SQL concepts like Stored Procedures,

Triggers, Cursors, Views, Functions and CTEs with best execution plan to update/insert the data into the database.

• Rewrote SQL queries to upgrade the server performance using SQL Server 2005/2008/2008R2.

• Worked on schemas, permissions and performance issues with client/server database design.

• Worked on Exception Handling with @@Error and Try-Catch.

• Developed dashboards using Excel Power Pivot.

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and process

SSAS cubes to store data to OLAP databases.

• Designed and developed SSIS Packages to extract data from various data sources such as Access database,

Excel spreadsheet, and flat files into SQL server 2008 for further Data Analysis and Reporting by using

multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge

and union all.

• Provided day-to-day administration tasks like space and log management.

• Developed Backup and Recovery Strategies, and Disaster Recovery Plan.

• Created reports using SSRS.

• Created and maintained cubes using SSAS.

GITAM UNIVERSITY,INDIA January 2011 - July 2011

STUDENT INTERN

Gitam University, founded in 1980, is one of the leading educational institutions in India. It offers several

Undergraduate and Graduate programs.

Responsibilities:

• Analyzed the requirements and systematically designed a database for the department of Electronics and

Communication Engineering.

• Designed Advanced T-SQL queries like Triggers, Cursors, Stored Procedures, Functions, Views and Indexes.

Tuned and optimized queries by altering database design, analyzing different query options and indexing

strategies.

• Defined various constraints like Check Constraint, Primary Key Constraint, Foreign key Constraint and Not

Null Constraint.

• Created reports using SSRS 2008 and Crystal Reports.

• Developed queries to generate Drill Down and Drill Through reports using SSRS 2008.

• Uploaded reports on to Report Manager and organized them into folders.

• Report generation and formatting by using Global Variables, Expressions and Functions. Designed and

implemented stylish report layouts.

• Worked with parameters for creating parameterized reports using SSRS 2008.

• Used Excel Power Pivot in order to build dashboards.

Contact this candidate