Mohammad

SUMMARY:

Over *+ years of MS SQL Server Development experience in Finance, Manufacturing & Distribution,

Telecommunications and Health Insurance domains with expertise in MS SQL Server

2000/2005/2008/2008R2/2012 and Microsoft’s suite of products like SSIS, SSAS, and SSRS.

Experienced in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous

and Heterogeneous Systems using SSIS of MS SQL Server 2008 and MS SQL Server 2005 respectively.

Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated

transformations to be used in SSIS packages.

Experienced in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and

involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema

using Erwin Tool.

High expertise in creating Reports of all types in SSRS, like Ad-hoc Reports, Drill-Down Reports, Drill-

Through Reports, parameterized Reports, Pivot and Tabular Reports based on client requirement.

Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using

Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for

the reports using SSRS 2008/2005.

Expertise in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Data

Mining Models, Deploying and Processing SSAS objects.

Adept in defining referenced relationships and calculated members in SSAS and used MDX queries.

Strong experience in Stored Procedure, Formulated Stored Procedure/TSQL coding, Performance

Tuning and Query Optimization.

Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User

Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query

writing and SQL joins.

Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).

Extensive knowledge in developing and implementing Disaster Recovery Model, and Replication

Models.

Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring

and tuning SQL Server performance.

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

challenging client needs using agile methodologies.

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

TECHNICAL SKILLS:

MS SQL Server 2012/2008R2/2008/2005/2000, MS Access, SQL, Transact-SQL (T-SQL), PL/SQL,

XML, MS SQL Server Integration Service (SSIS), MS SQL Server Analysis Services (SSAS), MS SQL

Server Reporting Service (SSRS), SQL Profiler, SQL Query Analyzer, MS SQL Server Index Tuning

Wizard, Visual Studio 2005/2008/2010, SharePoint,DTS SQL Developer, ERWIN, Microsoft Visio,

Crystal Reports 8.5,Report Builder, Adobe Photoshop 7.0/CS5/CS6, Adobe Flash, Windows Server-

2003/NT/XP/2000, Surround SCM Client, Team Foundation Server (TFS).

EDUCATION & CERTIFICATIONS:

Bachelors

PROFESSIONAL SUMMARY:

Microsoft/Annik Inc, Redmond, WA Jan 2014 – Present

ETL Developer /MS SQL BI Developer

Microsoft Corporation is an American multinational software corporation headquartered in Redmond,

Washington that develops, manufactures, licenses, and supports a wide range of products and services

related to computing. The project is MS Cloud Finance Business Intelligence (FBI), incorporates

companywide corporate reporting solution that provides insight on Cloud online revenue, primarily

focused on Office 365 Rev Sum Division.

Extensively involved in creating SSIS Packages to migrate data from various sources and loading

them into SQL Server Database.

Played major role on production support (operations) running and scheduling jobs, backups, cube

refresh and so on.

Handled day to day Service Requests (SR) and escalations (user requests) coming from end

users/customers.

Used C# scripts to map records between CRM and Legacy database.

Involved in SSIS Package creation from package design documents to package build.

Involved in Unit testing of the SSIS extract packages and also building validation packages to

check the accuracy of the data migrated.

Performance tuning of stored procedure, SSIS Packages and reports.

Wrote complex Join queries using T-SQL.

Used various SSIS data flow transformations, such as Data Conversion, Conditional Split,

Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks

during staging, before loading the data into Data Warehouse.

Created Test packages to validate the SSIS packages build.

Created and modified Stored Procedures, Functions, and Indexes.

Experience in configuration of report server and report manager scheduling in SQL Server

Reporting Services (SSRS).

Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and

Monthly processes.

Environment:

MS SQL Server 2012, SQL server Reporting Services 2012, SQL Integration Services 2012, MSRA, MS

Excel, T-SQL, TFS, Visual Studio 2010.

AON Corporation, Fort Wayne, IN Aug 2013- Jan 2014

SSIS/SSRS/SQL Developer

AON Corporation is a British multinational corporation that provides risk management, insurance and

reinsurance brokerage, human resource solutions and outsourcing services. The project that I am involved

in is mainly maintaining employee insurance and benefits database of AON’s various clients, mainly

Walgreens.

Leading a team of 3 offshore consultants; creating business requirement documents and

communicating with clients & Managers.

Extensively involved in creating SSIS Packages to migrate data from flat file, excel, OLEDB and

other sources to Database using SSIS 2008.

Used C# scripts in the script tasks to manipulate data.

Create validation package to check the accuracy of the data migration.

Created batch files to move files from Secured FTP server to deployment/Production server that

integrated the execution of stored procedures, SQL commands and SSIS packages.

Created various kinds of parameterized reports based on the business requirements.

Deploying reports to report server using SSRS 2008.

Involved in creating database objects such as view, table, stored procedure, trigger and function

using T-SQL.

Performance tuning of stored procedure, SSIS Packages and reports.

Wrote complex Join queries using T-SQL.

Created Database Maintenance Plans for Database Backups, Re-indexing and Data Integrity

Checks

Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and

Monthly processes.

Created SQL Server Agent Alerts to monitor the SQL Server Events and SQL Server Performance

Alerts and notify the Administrators of the critical situations.

Created Triggers to monitor activities on server as well as database and generate alerts and

notifications.

Created Stored Procedures, User-Defined Functions, Ad-hoc Scripts and Cursors on Development

and Test servers for pre-deployment testing.

Environment:

MS SQL Server 2008, SQL server Reporting Services 2008, SQL Integration Services 2008, Microsoft

Visual Studio, Microsoft Visual Basic, SQL Server Management Studio, MS Excel, T-SQL, WINSCP,

Microsoft Project 2010, Team Foundation Server (TFS),Surround SCM Client.

Microsoft, Redmond, WA Nov 2012 – Aug 2013

Business Intelligence, ETL/SSRS Developer

Microsoft Corporation is an American multinational software corporation headquartered in Redmond,

Washington that develops, manufactures, licenses, and supports a wide range of products and services

related to computing. The MPN Project is about migrating data from Legacy system to CRM Solution

using Web Services. The project also includes sub-projects like creation of various Reports.

Migrating data from Legacy system to CRM using SQL Server Integration Services 2012.

Used C# scripts to map records between CRM and Legacy database.

Involved in SSIS Package creation from package design documents to package build.

Involved in Unit testing of the SSIS extract packages and also building validation packages to

check the accuracy of the data migrated.

Used various SSIS data flow transformations, such as Data Conversion, Conditional Split,

Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks

during staging, before loading the data into Data Warehouse.

Created Test packages to validate the SSIS packages build.

Created and modified Stored Procedures, Functions, and Indexes.

Experience in configuration of report server and report manager scheduling in SQL Server

Reporting Services (SSRS).

Expertise in generating reports using MS Reporting Services 2012.

Experience in generating on-demand and scheduled reports for business analysis or management

decision using SQL Server Reporting Services.

Experience in writing VB scripts for user define functions in SSRS.

Excellent hands on experience scheduling and the deployment of the reports and uploading files

to a report server catalog from the report manger.

Excellent command on subscriptions, report snapshot and report cache.

Designed SSIS packages to Extract data from different sources like SQL server 2008, MS Excel,

MS Access; transform them and then load into Dimension and Fact tables in Data Warehouse

using SSIS.

Environment:

MS SQL Server 2012, Business Intelligence, SQL Server Integration Services (SSIS), SQL Server

Reporting Services (SSRS), SQL, Visual Studio 2012, Microsoft Office, Team Foundation Server (TFS),

SharePoint.

Ashland Inc., Wayne, NJ Mar 2012 – Oct 2012

Business Intelligence, ETL/SSRS Developer

Ashland is one of 500 fortune companies and the world-leading supplier of specialty chemicals and

performance enhancing products for consumer and industrial market. The project was based on generating

SSIS packages using Microsoft ETL tool SSIS. Ashland bought the privately owned company

International Specialty Products Inc. (ISP) that is itself a leading global supplier of specialty chemicals

and performance enhancing products for consumer and industrial market. Today, Ashland assets 15,000

people serving customers in more than 100 countries.

Responsibilities

Experience in configuration of report server and report manager scheduling in SQL Server

Reporting Services (SSRS).

Expertise in generating reports using MS Reporting Services 2008R2/2008/2005.

Experience in generating on-demand and scheduled reports for business analysis or management

decision using SQL Server Reporting Services.

Experience in writing VB scripts for user define functions in SSRS.

Excellent hands on experience scheduling and the deployment of the reports and uploading files

to a report server catalog from the report manger.

Excellent command on subscriptions, report snapshot and report cache.

Designed SSIS packages to Extract data from different sources like SQL server 2008, MS Excel,

MS Access; transform them and then load into Dimension and Fact tables in Data Warehouse

using SSIS.

Used various SSIS data flow transformations, such as Data Conversion, Conditional Split,

Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks

during staging, before loading the data into Data Warehouse.

Developed SSIS packages using for each loop in Control Flow to process all excel files within

folder, File System Task to move file into Archive after processing and Execute SQL task to insert

transaction log data into the SQL table.

Involved in extracting data from heterogeneous sources, such as CSV and Excel files.

Involved in dealing with off short team

Created and modified Stored Procedures, Functions, and Indexes.

Designed and developed SSIS packages, Stored Procedures, Configuration Files, Tables, Views,

Functions, and implemented best practices to maintain optimal performance.

Optimizing query performance with the help of Execution Plan and SQL Profiler.

Created and scheduled Jobs using SQL Server Agent

Used Event Handlers for Exception Handling in SSIS packages.

Developed dependent, dynamic menu objects to allow end-users selection and data filtering

capabilities.

Environment:

MS SQL Server 2008 R2, Oracle 11g, Business Intelligence, SQL Server Integration Services (SSIS),

SQL Server Reporting Services (SSRS), SQL, Visual Studio 2005, Erwin, and SQL Profiler, Actuate

Report, MS Visual Basic .

AARP, Rockville, MD Apr 2010 - Mar

2012

MS SQL Server Developer/SSIS and SSRS

AARP, formerly known as American Association of Retired Persons, is United States based non-

governmental organization founded in 1958 headquartered in Washington DC. AARP is "a nonprofit,

nonpartisan membership organization for people age group 50 and over- dedicated to enhancing quality of

life which provides a wide range of unique benefits, special products, and services.

Responsibilities:

Migrated reports that were built in Actuate Reporting System to SSRS using VB Scripts.

Gathered report requirements and determined the best solution to provide the results in either a

Reporting Services report, Analytical Cube or an Excel pivot table.

Designed SSIS packages to Extract data from different sources like SQL server 2008, MS Excel,

MS Access; transform them and then load into Dimension and Fact tables in Data Warehouse

using SSIS.

Developed SSIS packages using for each loop in Control Flow to process all excel files within

folder, File System Task to move file into Archive after processing and Execute SQL task to insert

transaction log data into the SQL table.

Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, dashboard and matrix

reports.

Wrote complex SQL queries and stored procedure to create reports using SSRS 2008 from the

relational database.

Generated monthly and quarterly reports as bar charts for the management using different

techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.

Converted manual reports pasted together into parameter driven stored procedures to be used with

Microsoft Reporting Services 2008.

Attained legacy data to use as a source to develop new reports previously compiled and

maintained manually.

Developed functional and technical documentation to assist in the design, development and/or

maintenance of deliverables.

Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder

for report server to create reports.

Configured the report server and generated the report models for user interactions.

Responded to ad hoc requests and special projects that require immediate attention while at the

same time maintaining deadlines on existing requests.

Developed and maintained system documentation, diagrams and flowcharts.

Worked with project manager and technical leads for resolution of technical issues.

Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use

of T-SQL.

Created clustered and non-clustered indexes on tables for new database to faster retrieval of data

for the Reports.

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration

Services 2008, Microsoft Visual Studio, Microsoft Visual Basic, Oracle 11g, SQL Server Management

Studio, MS Excel, T-SQL,ERWIN, Photoshop 7.0.

Monster Cable, Brisbane, CA Jan 2009 - Mar 2010

MS SQL Server Developer/SSRS/SSAS

Monster is the world's leading manufacturer of high performance cables that connect audio/video

components for home, car and professional use as well as computers and computer games. The project

focused on generating monthly, quarterly and weekly reports using SSRS tool. The scope of this project

includes developing reports, scorecards, and dashboards.

Responsibilities:

Worked closely with business unit(s) to understand key business drivers and then identify the

individual business metrics and key measures that support them.

Worked with management to develop strategies to support company needs.

Resolved data conflicts and inappropriate use of data.

Wrote complex SQL queries using joins, stored procedures, and user defined functions to verify

the data from the database to generate reports based on the business requirement.

Utilized SSRS reports from different source formats satisfying clients by representing reports and

presentations.

Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi

parameterized report, ad-Hoc and parameterized reports using SQL server 2005 reporting

Services.

Implemented multiple grouping into several reports using visibility and toggle options.

Administrated and scheduled mailing subscriptions on SSRS reporting server.

Structured conditional formatting logic to control components behavior and appearance.

Produced parameter driven matrix, sub-reports and integrated report hyper-link functionality to

access external applications.

Customized SQL queries to create RDL Datasets and create SQL reports.

Created Tabular and Matrix Reports with all aggregate functions and expressions.

Created dashboard SSRS reports under report server projects and publishing SSRS reports to the

reports server.

Developed functional and technical documentation to assist in the design, development and/or

maintenance of deliverables.

Created SSRS Data Model projects using Microsoft Visual Studio 2005 and using Report Builder

for report server to facilitate Ad-hoc reporting by the business users

Environment: SQL Server 2005, SSRS, SSAS, T-SQL, SSMS, BIDS, Visio, Excel 2003, SharePoint.

Blue Care Network, Southfield, MI May 2006 – Dec

2008

BI Developer/SSRS Developer

Blue Care Network is one of the nation’s best Health care organizations. Blue Care Network features

award-winning disease management programs and the largest HMO network of physicians and hospitals

in the state. Blue Care Network has a Health Care Online Web portal, which helps Physicians and

Hospitals to interact with each other. The main project goal was to extract data from various data marts

and loaded into SQL Server Integration Services and also created, designed and modified reports as per

requirements.

Responsibilities:

Gathered requirements about the project which was used to create the SSIS 2008 packages.

Wide knowledge of ETL architecture, data schemas and SSIS packages

Identified the data sources and created source to target mapping documents to be used by the packages in

SQL Server Integration Services (SSIS).

Orchestrated, developed and deployed the SSIS packages using SSIS 2008 as the ETL tool.

Used Package configurations, Variables and Expressions while creating the SSIS packages.

Developed complex stored procedures to be used in SSIS 2008 packages to audit the information about

the data flow from one stage to other.

Used various transformations in the ETL packages while transferring the data from OLTP source to

destination using SSIS 2008.

Used SQL server agent to automate the SSIS package execution.

Responsible to create test cases and performed system testing for the SSIS packages using SSIS 2008.

Made various report parameters and query parameters to create parameterized reports using SSRS 2008.

Created reports having actions like URL and bookmarks which helped to easily navigate through the

report using SSRS 2008.

Implemented caching of reports and managed the report history in the Report Manager.

Performed complex Expressions to create calculated fields and used Global Variables in SSRS 2008.

Use ETL to implement the slowly changing Transformation, to maintain Historical Data in Data

warehouse.

Created stylish reports and implemented conditional formatting using SSRS 2008.

Deployed and managed the reports in the Report Manager using SSRS 2008.

Wrote complex stored procedure, views using T SQL in Management Studio

Optimized the queries for efficient data retrieval by implementing indexes on the tables.

Environment: SQL Server 2008 Enterprise Edition, SSIS, SSRS, T-SQL, Windows NT.

Contact this candidate