Sql Server Data

R U M A N A N A Z M U L

***** ** ***** *** ( Redmond WA 98053 ( E-mail: ************@*****.***

Phone: 425-***-****

TECHNICAL SKILLS T-SQL; SQL Server 2008; SSRS; SSAS;SSIS; Excel; Access;

PowerPoint; Word; Share Point; Visual Studio 2008; Visio;

Team Foundation Server, Quality Center

Recent Microsoft Exam 70-461: Querying Microsoft SQL Server 2012

Achievement Feb

2014

EXPERIENCE

Business Intelligence Developer / Data Analyst June 2013 - May 2014

WorldVentures Marketing, LLC Plano Dallas TX

Gathered report requirements for various departments in the organization.

Analyze the data and design the report using SSRS tool and publish in the

intranet website.

Develop the report at the backend using Microsoft SQL Server. Create stored proc,

views, index, and function, jobs as necessary to maintain the reporting database

and create reports.

Develop the report using advance SQL query. And automate the report.

Analyze data and investigate the database on time critical issue.

Create data model with metrics to help the executive in decision making process.

Analyze and test data in the database to look for discrepancies and system error.

Work on database maintenance - data cleaning, data validation and maintain data

integrity.

Work on designing the data import and data validation.

Create SSIS package for data import.

Identify trends and issues and make presentation and recommendations to

management and external departments.

Business Intelligence Analyst / System Analyst April 2012 - Jan 2013

T-Mobile Bellevue, WA Through Harvey Nash

Played a role to identify, evaluate and develop solutions, systems, and

procedures in fast-paced Commissions and Sales Incentive Management domain.

Investigated the time critical production database issue and defect triage and

drive the solution in timely manner.

Analyzed data on the database and designed the solution and translated the

requirements into functional / technical specification.

Interviewed Business Partners to identify and document requirements for data

processing, integration, interfaces, business rules and reports and present it to

the stakeholders and higher management.

Facilitated/led reviews (walkthroughs) of technical specifications by

communicating design, requirements, feature set, functionality and limitations of

systems/applications to business team and development team.

Created Test Plans and Test Requirements Document with test cases.

Perform QAT Testing for the project.

Analyzed the database and provided input from high-level to detailed estimates

for intake, projects, and change requests in area of responsibility.

Facilitated and participated in working sessions with cross-functional teams.

Conducted peer reviews to solicit feedback on deliverables created.

Business Intelligence Analyst July 2011 - Feb. 2012

Microsoft Corporation, Redmond WA Through Aditi Consulting

Created and maintained existing reports that played central role in quality

improvement process for media streaming provided by Xbox Live.

Worked on the backend and frontend of the report- writing complex queries to

create reports on SSRS and publish in SharePoint.

Gathered requirements for new reports or new feature on existing reports and

deliver it in timely manner.

Acted as liaison between stakeholders to help shape solutions that enabled

participants to meet their objectives.

Monitored the telemetry data and identify issue and do further root cause

analysis and facilitated problem-solving sessions with functional leaders across

the spectrum of business partners

Contributor to Ad Hoc investigations for partners. Dig down further the time

critical day to day issues against database and do data analysis using pivot

tables charts in Excel

Created and maintained large spreadsheets for weekly and monthly scorecard for

internal and external stakeholders.

Tested the reports and related issues and file found bugs in TFS (Team Foundation

Server) and drive the solution.

Created documents and managed SharePoint.

Report Developer Sept. 2009 - June 2011

Financial Claims Inc, Kirkland, WA

Accountable for creating monthly, quarterly report for the clients and upper

management using T-SQL query and Excel.

Gather new report requirements and design and create the report in timely manner.

Created ad hoc reports as per request.

Analyze the report to assist to management in decision making.

Report Developer Nov 2000- July 2006

Capacity Planning and Performance Team

Centrelink IT Infrastructure, Canberra Australia

Accountable for ongoing daily, weekly, monthly performance report on enterprise

wide midrange servers.

Created reports using sql server at the backend and published on intranet.

Produced quarterly capacity plan using Excel and Sql query on critical production

servers. Analyzed the data. Data manipulation included server's historical and

present data.

Automated data manipulation process to produce quarterly capacity plan.

Created ad-hoc server performance reports as per internal customer and management

request.

Assisted in maintaining SQL server database in general by creating tables,

indexes, security management, automation of tasks, determining and solving common

performance problems, performance and tuning.

Created test plan and certified various upgraded software.

Strong involvement in several projects from planning to testing phase.

EDUCATION

Achievement

Business Intelligence Analyst GPA 4.0 Bellevue College

2013

Data Analysis and Business Modeling using Bellevue College Continuing

Excel 2007 2010 Education

T-SQL Query Extensions to SQL 2010 Bellevue College Continuing

Education

Certificate on Programming (C++) GPA 4.0 Lake Washington Technical College

June 2009

Certificate on Software Testing June 2009 University of Washington Continuing

Education

Bachelor of Information System 2000 Auckland University of New Zealand

Contact this candidate