Resume

Sign in

Sql Server Ms

Location:
Garfield, New Jersey, 07026, United States
Posted:
October 07, 2016

Contact this candidate

Uzma Siddiqui

●I** West *nd St. Clifton NJ *****.

●Tel: 862-***-****

●Email: acwykc@r.postjobfree.com

» Objective

Make contribution in this organization to the best of my ability and to develop new skills and share my knowledge while interacting with others and achieve new height and to use my ability to work in a team environment. I am self-motivated and able to work both independently and as collaborative team member.

» Professional Summary

Over 2 years of experience in IT Industry as Microsoft SQL Server Business Intelligence Developer.

Experienced using Object Oriented Features like Inheritance, encapsulation and polymorphism.

Highly experienced in MS SQL Server 2012/2010/2008R2/2008/2005 Business Intelligence stack MS SQL Server Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).

Extensively worked on Data Extractions and Transformations.

Experience in creating, executing, and deploying SSRS Reports.

Proficient in generating reports using SSRS Reports and MS Excel. Also have expertise in generating drill down reports, parameterized reports, linked reports, sub reports, Ad-hoc reports, data driven subscription reports, matrix dynamics and filters, charts using SQL Server Reporting Services (SSRS 2000/2005/2008).

Designed and developed System Interface using PowerBuilder objects, both Visual and non-visual: Windows, Tree-views, User Object, DataWindow, DropDown DataWindow, datastore, etc.

Strong event-driven programming skills in user friendly Graphical User Interface Development on PowerBuilder.

Extensive experience in developing complex reports using DataWindows.

Resourceful, highly motivated, and well-organized with demonstrated ability to structure information, analyze data relationships, and extract meaningful business insights.

Quick learner and good performer both in team and independent job environments, excellent communication and analytical skills.

» Technical Skills

Microsoft BI Toolsets: SQL Server 2012/2010/2008R2/2008/2005, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS).

Databases: MS SQL Server 2012/2010/2008R2/2008/2005, MySQL, DBase, MS-Access

Operating Systems: Windows 95/98/NT/ Novell/2000/2003/XP/Vista/2007, UNIX,

LINUX,

Microsoft Applications: MS-Office Suite 2003/2007, MS- Project 2003, MS- Visio 2003/2007

Languages: MySQL, SQL Server Visual Basic 6.0, C#,ASP.net, CSS, HTML, HTML5,

C++, JavaScript,

» Education

●Punjab University College of Information Technology (PUCIT), Punjab, Pakistan

BS(IT) Hons. 2014

●Govt. College for Women, Punjab, Pakistan

Faculty of Science (Physics, Chemistry, Math) 2009

●MC Model Girls High School, Punjab, Pakistan

Matriculation (Science Subjects) 2007

» Work Experience

Snow & Sun Joe NJ United States

SQL developer

October 2015 - February 2016

I’ve worked with Snow Joe, a leading company dealing with snow equipment in NJ. Where I developed their reporting system covering the sales, purchase, routing and delivery information, managing the data in database, developed complex SQL queries, worked with store procedures, creating tables, views and jobs in SQL Server that also include troubleshooting and solve the runtime database errors. I also worked there for data fetching along VB.Net programming support.

Responsibilities :

Responsible for creating the reports based on the requirements using SSRS 2005.

Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.

Developing several reports using SSRS with consistent drill-down functionality including Drilldown reports, Summary reports, parameterized reports and Master Detail reports.

Generating on-demand, ad-hoc, custom reports for management decision using SSRS

Working with store procedures and functions for data set results to use SSRS to reduce report complexity and to optimize the run time. Exported reports into various format from (PDF, Excel) and resolved formatting issues.

Created views and modified existing views for cube, store procedures, Mapping the tables by using joins, involved in writing T-SQL, triggers, using indexes, constraints and business rules wherever applicable.

Uploaded reports on to the report manager and organized them in folders.

Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.

Deployed the generated reports on to the server.

Fine-tuned the database objects and server to ensure efficient data retrieval.

Generated very high level SSRS 2008 reports from the OLTP and OLAP cubes.

Converted very complex RPTs of Crystal Reports into RDLs of SSRS manually

Environment: MS SQL Server 2008,MS SQL Server Integration Services2008, MS SQL Server

Analysis Services 2008, MS SQL Server Reporting Services 2008, SQL, MS-Excel, XML, Windows

2000/2003/NT/XP

AutoSoftDynamics Lahore, Pakistan

PowerBuilder and SQL developer

August 2014 - May 2015

I've worked with AutoSoft Dynamics, a leading software house in Lahore Pakistan. Where I've developed an Information Security Risk Management (AutoISRM) system covering different ISO related standard requirements to meet organizational information Security needs. Other than this also develop Incident management, SOA management aligned with ISO Standard.

Responsibilities :

Requirement gathering with the users for feasibility study and Gap Analysis.

Responsibilities include Screen Design and Development.

Involved in Base code alteration.

Created Procedures, Triggers for some of their new functionality.

Executed file Generation and deliver the application.

Creating the test plan and implementation plan.

Data Backup.

Deployment & Implementation.

Worked on implementing report generation

User training/support after the implementation.

Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.

Created views and modified existing views for cube, store procedures, Mapping the tables by using joins, involved in writing SQL, triggers, using indexes, constraints and business rules wherever applicable.

Monitored performance and optimized SQL queries for maximum efficiency.

Deployed the generated reports on to the server.

Uploaded reports on to the report manager and organized them in folders.

Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.

Deployed the generated reports on to the server.

Fine tuned the database objects and server to ensure efficient data retrieval.

Environment: SQL server 2012/2010/2008,PowerBuilder 12.x

» Activities

I was the member of computer society in PUCIT.

I hosted many programs in University.

I am a good communicator.

I have good management skills and ability of leadership.

I worked as a Teacher Assistant in PUCIT for the subjects

oData Bases Management(DBMS)

oSoftware Project Management (SPM)

oSoftware Engineering

oSoftware Quality Assurance (SQA)

oParallel Programming



Contact this candidate