Management Sql Server

MUHAMMAD OWAIS

Email: *******@*****.*** Cell:647-***-****

Experienced Microsoft .NET, Microsoft Cloud Solutions, SharePoint,

SQL-Server, MS-BI, QlikView BI Architect / Lead Developer

An experienced Software Solution & BI Developer/Architect with more than 12 years experience of Enterprise Software Development using Microsoft .NET, SQL-Server and Business Intelligence (BI) /QlikView BI for Banking & Financial Industry, Television & Broadcast Industry, Publication & Print Media, HealthCare Industry, Supply-Chain as well as Transportation Management Industry.

TECHNICAL SKILLS

.Net Framework 3.5 / 4.0 / 4.5

C# .NET / VB .NET (VS 201x)

ASP.Net - MVC 4 / Bootstrap

Entity Framework/ NHibernate

HTML-5, WebScoket, AJAX

jQuery, Backbone.JS, KnockoutJS

JSON, XML, CSS

WCF / RESTful API

Web Services / SOAP /Web-API

WPF & WWF

MongoDB/ Document DB

Data Modeling & RDBMS Design

Object Oriented Design & GoF

BizTalk Server, SharePoint 201x

TFS, MKS, GitHUb VSS, SVN

K2.NET, Salesforce

Web Server Configuration / IIS

SDLC, Agile, Scrum, Waterfall

UDP, named-Pipe, HTTP, MSMQ

QlikView BI 11 / Development

QlikView Reporting

QlikView MC, QVD, Set Analysis

QlikView Scripting, Dashboards

MS SQL Server 2008 / 2012 /2014

T-SQL - SSIS, SSAS, SSRS

OLAP, MDX, ETL

Azure (IasS, PasS, SasS)

AWS Amazon Clouds

TOGAF Framework

Zachman Framework

WORK EXPERIENCE

SENIOR SOLUTION DEVELOPMENT CONSULTANT

Toronto Dominion Bank. Canada [http://www.td.com]

May 2016 - Present

•Leading team of 6 onshore and offshore developers, for architecting and developing Data warehouse solutions and BI Solutions for EETS Risk Solutions for TD Bank, using Microsoft BI stack (enterprise SQL Server, SSIS, SSRS, SSAS, OLAP Cubes etc.), along with enterprise development using Full stack .NET (C#, WCF, WPF, ASP.NET MVC, Backbone.JS using Visual Studio 2015 and Bootstrap 3.37).

•Designing, developing and implementing ETL services for a number of ETL processes automations that succeeded the various vendors' data feed management applications and presenting completed ETL jobs to the project stakeholders for concurrence of the alignment between business requirements and completed process automation.

•Responsible for designing, implementing and managing cloud services using Azure Technology Stack.

•Implemented overall SQL Azure encryption (TDE) for data at rest and transit and its integration with IBM Aveska Solution.

•Analyzing internal clients' requirements with the close collaboration with the clients and proposing potential architectural solutions for the complex problems mainly based on Identity management.

•Designing, developing, testing, UAT, PAT and implementing Microsoft BI solutions for the enterprise and providing post-deployment support for enterprise solutions.

•Assisting and mentoring the onshore and offshore developers for developing and implementing enterprise solutions.

•Responsible for designing and implementing NOSQL database using MongoDB and Cassandra and their affiliation with respective RDBMS models.

•Responsible for designing and developing integrations services to integrate TD Securities' FpML messaging framework with EETS Identity Management Data warehouse.

•Responsible for designing, developing and implementing enterprise services for integrating heterogeneous environment (mainframe, java, TIBCO etc.) using WCF, Windows Enterprise Service Bus (WESB) and RabbitMQ.

Task Management using Agile-Scrum Methodology and supervision of daily-project backlogs for team-sprints using JIRA.

SENIOR SOFTWARE CONSULTANT/ SENIOR LEAD ARCHITECT

Apricot Global Solutions Inc. Canada [http://www.apricotglobal.ca ]

Jan 2015 - Apr 2016

Leading team of 12 senior and junior developers for development efforts towards successful project delivery, also providing technical leadership to teammates through coaching and mentorship.

Designing, developing and implementing the media research products on Azure Technology stack for multi-tenant solutions using Azure Services, Web APIs, SQL Azure, and Service Bus

Implemented highly-scalable Data Access Layer with a primary SQL Azure database and one SQL Azure database per advertisers/agency/media company, with Geo-Replication.

Designed, developed and managed large Data Warehouse for TV Audience Measurement Solution, and designed Qlikview 11 Dashboards and QV Reports for real-time TV viewers behavioral metrics.

Developed Complex QlikView Reports using and Dashboards with customized QlikView scripts, also managed Qlikview Solutions installations & configuration, QVD backup management applying Incremental Loading & QlikView document Versioning.

Responsible for ensuring coherence of all aspects of the project as an integrated system with overall technical quality, and assisting developers implementation standardized development practices.

Responsible to team members' work assessment and their respective performance evaluations

Managing team members locally and in remote locations

Responsible for architecting, developing and maintaining complete Service Oriented Framework using EDA, and developing RESTful APIs in C#.

Lead architect and Senior Software Consultant, designed and developed both Products for Apricot Global Solutions Inc. and its client project using C #.NET, ASP.NET, jQery+AJAX, JSON, WCF, WPF, SQL-Server 2012/2014, SSIS & SSRS.

Responsible for designing and implementing NOSQL database using MongoDB and its association with SQL-RDMS

Implemented In-Memory OLTP Database using Microsoft SQL Server 2014 Hekaton

Responsible of developing and managing application client & server side JavaScript using Meteor.js, Backbone.js and Knockout.js

Evaluation and mentoring of local and off-shore junior developers on respective tasks.

Task Management using Agile-Scrum Methodology and supervision of daily-project backlogs for team-sprints along with managing product and project deliverables

SENIOR LEAD ARCHITECT / DEVELOPER

(ASSOCIATE VICE PRESIDENT)

BOL TV Network [http://www.bolnetwork.com ]

July 2013 - Aug 2014

Successfully Developed and Implemented, BOL Media Management Systems Portfolio (Newsroom System, Fixed Point Chart System, Advertisement Management) using C #.NET, ASP.NET, jQery+AJAX, JSON, AngularJS, WCF, WPF, SQL-Server 2008-R2, SSIS & SSRS, MOS-Protocol.

Implemented both Azure and AWS cloud stack for managing several media services for multi-tenant SasS solutions at AWS account layer.

Implemented Azure Service Fabric to build large-scale distributed, elastic cloud solutions

Designed developed and administrated overall BI implementation using QlikView BI and Microsoft BI stack for executive Dashboards for CEO & COO using QlikView BI.

Task Management using Agile-Scrum Methodology and supervision of daily-project backlogs for team-sprints

Evaluation and mentoring of junior developers on respective tasks.

Involved in every phase of SDLC including analysis, design, back-end/front-end development, re-usable services and object development, Unit-Testing, follow-up with QA team, implementation in production-environment.

Monitoring operations of implemented solutions by ensuring swift periodic enhancements.

Responsible for determining viable project mix that meets the target of the organization long term goal, by ensuring a mix of projects that balance various factors such as research versus development, short term versus long term, risk versus reward. Also responsible for planning, executing, monitoring, change management and ensuring the ROI of technological projects for BOL TV network.

Monthly status reporting to Sr. Executive Vice President -Technology and ensuring objectives are met timely.

Award : Silver Performance Award for the year 2013-14

LEAD DEVELOPER / SOFTWARE ARCHITECT

(SR. MANAGER SOLUTION DEVELOPMENT)

Independent Media Corporation (Pvt.) Ltd.

GEO TV Network [ http://www.geo.tv ]

Dec 2005 - June 2013

Analyzed, Designed, Developed and Implemented 17 key software applications using .NET Framework (C#, ASP.NET, VB.NET), Windows Workflow, SQL Server 2008-R2, Power-Pivot & Qlikview BI, SQL Server Reporting Services, Analysis Services, Notification Services, SharePoint Server 2010, K2.NET Workflow, Several Third-Party Products etc.

Developed BI applications and Dashboards for Executive Management by implementing Qlikview and Microsoft BI solutions.

Integrated GEO's Sales Order Processing system with Salesforce CRM.

Successfully Integrated Business Objects, Web-Parts, and Services by providing fully-integrated Information-Systems architectures at several applications of GEO TV Network & Jang Group.

Integrated Oracle EBS with in-house developed applications and SharePoint Portals using BizTalk 2010 Server Orchestration.

Assisted Group CTO-Software to plan, present and successfully accomplish 4 annual enterprise IS-Plans.

Led, engineered and managed more than 80 highly effective processes by turning them into E-Processes for different Business Units of organizations.

Award: CEO's Award and Incentives for successful implementation of Cost Benefit Analysis (CBA) System

SOFTWARE CONSULTANT

Xorbix Technologies Inc. [http://www.xorbix.com/ ]

Jan 2005 - Dec 2005

Developed Business Portals for Village at Manor Park using ASP.NET, C#, Infragistics Controls,SQL Server 2000.

Developed Project Management & Bug-Tracking application using C#.NET, ASP.Net and SQL-Server 2000

Offered ongoing maintenance of DSSI web-application

Developed augmented features of web-application security using AD-Authentication and SSL-Certificate

Developed back-end data encryption features of ioxphere - survey product using MD5 encryption.

SOFTWARE DEVELOPER

Premiere Software (Pvt.) Ltd. [ http://pre-soft.com/ ]

Nov 2003 - Dec 2004

Developed in-house ERP modules and Desktop business applications using VB.6.0, Active-Data-Object, SQL-Server 2000.

Designed and developed Online Shipping and Container Tracking Management System using ASP.NET, C# and MS-SQL

Developed Road Transport Management System (RTMS) for Shell-Pakistan for their initiative about Drivers' Road Safety Programs, using .NET Framework 1.0, ADO.NET, VB.NET, COM Objects and SQL-Server

EDUCATION

MBA - Media Management & Marketing

Institute of Business Management - Karachi, Pakistan

2011

Master of Computer Science (MCS)

University of Karachi - Karachi, Pakistan

2003

Bachelor of Science (Computer Science, Statistics, Mathematics)

University of Karachi - Karachi, Pakistan

1999

CERTIFICATIONS

Canadian Workplace Culture & Communication

School of Continuing Studies, University of Toronto

.NET Bridging Program

Humber College, Canada

Microsoft® Certified Technology Specialist

Certification Number : D075-9251

Certification/Version : Microsoft Office SharePoint Server 2007, Configuration

Exam : 70-630 TS: Microsoft Office SharePoint Server 2007, Configuring

Microsoft Certified Professional

Certification Number : F072-1330

Certification/Version : Microsoft Certified Professional

Exam

70-487 Developing Microsoft Azure and Web Services

70-480 Programming in HTML5 with JavaScript and CSS3

Microsoft Specialist

Certification Number : F147-8303

Certification/Version : Implementing Microsoft Azure Infrastructure Solutions

Exam : 70-533 : Implementing Microsoft Azure Infrastructure Solutions

Microsoft® Certified Solutions Associate

Certification Number : F133-9979

Certification/Version : Office 365

Exams

70-346 : Managing Office 365 Identities and Requirements

70-347 : Enabling Office 365 Services

REFERENCES

Available upon request

Contact this candidate