Post Job Free

Resume

Sign in

Project Manager Sql Server

Location:
Middle River, MD
Posted:
January 14, 2016

Contact this candidate

Resume:

Akhtar (Alex) Hussain

Phone : 410-***-**** email: acs3x6@r.postjobfree.com

Summary of Qualifications

Seasoned Senior IT professional and Solution Architect with over 14 years of experience analyzing and problem solving across a broad spectrum of industries including Education, Real Estate, Medical Care, Pharmaceutical, Human Resources (HR) and Payroll. Experienced Project Manager and leader in corporate business technology and demonstrated ability to communicate with business and technical experts, capable of transitioning from technical expert to business strategist. Adept leader working with clientele including C-Suite and the ability to work as a collaborative team member and coordinating with QA teams.

Highly experienced in acute problem-solving and Microsoft (MS) certified to resolve the most complex challenges using industry best practices in delivering solutions using Dynamics CRM 2013 and SharePoint 2013. Industry expert in developing, deploying and managing Custom Web Parts, SharePoint Content Publishing, Custom Event handlers, site definitions, client object model, PowerShell scripting, and managed metadata in SharePoint 2013 and Dynamics CRM 2013.

Specialties

Tools:

CA ERwin, TOAD, MS VISIO, MS Project, PENCIL, Visual SourceSafe, TFS, LoadRunner and Balsamiq

Databases:

MS-SQL Server 2012/2008/2005/2000/7.0/MSDE, Oracle 6.0/7.0/8.0 /9.0/10g/11i, MS-Access

Platforms:

Windows, Linux, VMWare, VAX/VMS, and UNIX

Software:

Visual Studio, SharePoint 2013, Dynamics CRM 2013, Project Server 2013, JBuilder, Workbench Studio and CAML Builder

Operating Systems:

Windows 2012/2008/2003/XP/2000/NT/98/95 and Unix

Languages:

C, C++, C#, Java, Visual Basic, VB.net, Cobol, Assembly, Fortran and JavaScript, .NET, asp.NET, JQuery

Certifications

Microsoft Certified Professional (MCP)

Microsoft Certified Technology Specialist (MCTS): Dynamics CRM 2013

Microsoft Certified Solutions Developer (MCSD): SharePoint 2013 Applications

Sun Certified Java Programmer (SCJP)

Certified Oracle DBA, Brainbench, Inc.

Experience

SOLUTION ARCHITECT

4/2015 – Present

ZDAAS

Baltimore, MD

Client: Maryland State Department of Education (MSDE) EIS Web Portal

Solution Architect reporting to the Director of IT, Software Engineering Department and responsible for the creation of a detailed solution design of MSDE's Certification Educator Portal which allows teachers to apply for certification, print their certificate, update demographics, and view the status of submitted requests. Project Manager in all initiatives pertaining to the project including technical issues. Evaluated Security loopholes and implemented DOIT policies and procedures for the security of the portal.

Worked in collaboration with MSDE consultants and business users to determine the gaps in requirements. Determined functionalities and defined workable solutions to bridge gaps, designing the optimum technical solution in the context of the client's environment, requirements, and financial resources. Ensured the delivery of a quality system design which meets system performance requirements, an effective human-machine interface, optimal operational cost, and flexibility for future change.

Designed N tier Web application Architecture and Framework.

Implemented processes automation using Dynamics CRM 2015 Workflows and Dialogs.

Customizing Entity, Ribbon, Sitemap, Charts and Dashboard in Dynamics CRM 2015

Created Custom scripts to Migrate Dynamics CRM 4.0 to Dynamics CRM 2015

Analyzed architectural differences between different solution methods and the challenges and approaches to integrating solutions built on different platforms.

Created Custom Plugins using Visual Studio 2013 for Dynamics CRM 2015

Developed Custom FBA Authentication Web Parts.

Developed Custom Web Parts for PayPal integration with SharePoint 2013 Portal.

Migrated 1.2 million Documents from file system into SharePoint 2013 and integrated with Dynamics CRM 2015.

Created Workflows using Visual Studio 2013 and SharePoint Designer 2013 for implementing different business rules.

Created Custom events for business data validation and SharePoint 2013 timer jobs for scheduling events using Visual Studio 2013.

Developed custom web parts to update and retrieve Dynamics CRM 2015 entities data.

Co-ordinated with the QA team.

Used Scribe Insight for Dynamics CRM data migration

Tools & Technology: JavaScript, .NET, Scribe, Microsoft SharePoint 2013, Visual Studio 2012, Microsoft Dynamics CRM 2015 and SQL Server 2012.

SOLUTION ARCHITECT

10/2014 –03/2015

Zbizlink (a ZDAAS Company)

Baltimore, MD

Solution Architect reporting to the Director of IT, Software Engineering Department and co-teamed with the Technical Architect to produce technical specification for custom development and systems integration requirements for a first of class proprietary Global Business-to-Business (B2B) software application.

Consultative team member, participating in the process flow analysis and process redesign along with the Development Team, and produced a detailed functional design document to match product requirements. Shared and provided best practices and 3rd Party solution alternatives as part of the functional design document.

Participated in training design, documentation and delivery efforts in concert with the Project Manager. Completed and co/implemented a configuration workbook. Led the User Acceptance Testing (UAT) efforts.

Analyzed and Designed Web application Architecture and Framework.

Created Web API service to integrate asp.net, LinkedIn and Microsoft SharePoint 2013.

Used Asp.net 4.0 new features like Master Page, Global Themes, skins etc.

Developed SQL queries, Created Stored Procedure, Views and Data Marts.

Created SharePoint-hosted apps for document management and versioning.

Regularly reviewed the code of the team members.

Created reports and dash board using Microsoft SQL Server 2012 Reporting services.

Co-ordinated with the QA team.

Tools & Technology: JavaScript, .NET, Microsoft SharePoint 2013, Visual Studio 2012 and SQL server 2012.

SOLUTIONS ARCHITECT

05/2014 – 09/2014

Abacus LLC

Miami, FL

Projects: Pharmacy Management System

Medical Housekeeping Management System

Secondary Role: Project Manager

Solutions Architect reporting to the Chief Technology Officer, IT Department and serving as the Project Manager responsible for the implementation of 1) a proprietary Pharmacy Management System which tracks patient, doctor, drug and prescription records and 2) Medical Housekeeping Management System.

Responsible for the oversight of all project phases from conception to completion, and the management of a team of consultants, programmers, developers and analysts. Followed PMI® project management best practices throughout the project’s initiation, planning, execution and closure. Developed work breakdown structure, project plans including risk assessment, working closely with stakeholders and team member to ensure the project was successfully completed meeting objectives within budget and on time.

Implemented SharePoint 2013 and Dynamics CRM 2013 integration.

Translated business requirements into well-architected solutions that best leverage the Microsoft Dynamics CRM 2013 platform.

Implemented MSCRM architecture and its interaction with other interfaced systems

in the client environment

Developed the technical delivery of custom development, integration, and data migration elements of a Microsoft Dynamics CRM 2013 implementation

Created Custom Workflows and Dialogs using Visual Studio 2013.

Used Asp.net 4.0 new features like Master Page, Global Themes, skins etc.

Implemented ASP.net Identity framework for user and role management.

Developed SQL queries, Creating Stored Procedure, View. Having good exposure on SQL.

Assigned tasks to team members and reviewed the code regularly.

Conducted DAILY SCRUM meetings.

Co-ordinated with the QA team.

Tools & Technology: JavaScript, .NET, Microsoft SharePoint 2013, Visual Studio 2012, Microsoft Project Server 2013 and SQL server 2012

SOLUTION ARCHITECT

12/2013 – 04/2014

CGI Denmark

Aalborg, Denmark

Project: Real Estate CRM

Secondary Role: Project Manager

Solution Architect reporting to the Technology Manager, Software Solutions and supporting the detailed design solution for a Real Estate CRM, a property management solution in MS Dynamics CRM 2011 and web-based application. Collaborated with consultants and business users to identify features to develop a tool for Real Estate Agents, providing complete customization and management of the Sales Process for a property agent including Sale/Purchase, Rent/Lease Management, and integration of MS Live maps for address geocoding. Worked with the Database Administrator to design archiving solutions. Developed security standards, procedures, and guidelines for multiple platforms. Designed Test cases and provided guidance to the Test Team.

Project Manager, responsible for the oversight and management of a team of software developers and designers acting as the lead in technology guidance to team members. Led the project in completion of the customization of MS Dynamics CRM 2011 for the client’s Property Management, creating custom entities and implementing a dashboard to provide complete business analysis and reports. Conducted formal performance reviews of team members.

Performed MS Dynamics CRM 2013 Customization by coding custom forms, entities, workflows, dialogs and RIBBON.

Implemented MS Dynamics CRM 2013 Integration with Microsoft SharePoint 2013 and created reports using SSRS.

Created Custom web services to call data from Dynamics CRM 2011 Server.

Developed different Plug-ins, Custom Workflows, and Reports.

Performed End to end implementation of MS Dynamics CRM 2011.

Created, customized and implemented new critical requirements using Plug-ins, Workflow assemblies, web services and JavaScript.

Co-ordinated with the QA team.

Integrated CRM 2011 with external systems using MSCRM SDK using .NET, XML.

Tools & Technology: JavaScript, .NET, Microsoft SharePoint 2013, Microsoft Dynamics CRM 2013, Visual Studio 2012 and SQL server 2012

SOLUTION ARCHITECT

01/2013 – 11/2013

PlanetLogix, Inc.

Colorado Springs, Colorado

Client: HR Portal

Secondary Role: Project Manager

Solutions Architect reporting to the Technology Manager, Software Solutions and serving as Project Manager in all phases of the development of a Human Resource (HR) Portal, a SharePoint-based product that caters to a variety of industries to manage their Paid Time Off system fully integrating with Human Resources (HR) and Payroll. Responsible for all aspects of project execution, from draft of charter to project completion, including the design of the database and data marts including fact tables and dimension tables, dashboard and reports.

Project management of team members developing the enterprise architect, performing code reviews, test cases, UAT and Load Performance tests. Assigned team members tasks and evaluated the performance of the each team member.

Setting up SharePoint 2010. Technical planning, infrastructure, and architecture for SharePoint 2010 migration.

SharePoint 2010 migrations using the database attach upgrade. This had difficulties and fabulous 40 templates were also not migrating easily to SharePoint 2010. Migrated part of site using object model.

Rewrote site definitions, master pages and custom web parts to support SharePoint 2010 features.

Developed various custom workflows.

Custom development using Excel services object model for converting documents to various file formats.

Created different content types, lists and Metadata columns to be able to use enhanced SharePoint 2010 features.

Co-ordinated with the QA team.

Various event handlers, feature receivers, custom timer jobs and application pages were rewritten as part of enhancements in the SharePoint 2010 based system.

Tools & Technology: JavaScript, .NET, Microsoft SharePoint 2010, Visual Studio 2012, Dynamics CRM 2011 and SQL server 2008

SOLUTION ARCHITECT

7/2012 – 12/2012

ZK Homes LLC

Houston, TX

Project: Real Estate Portal

Secondary Role: Project Manager

Solution Architect Reporting to the CEO, Software Development in support of the design of a high-level architecture of a Real Estate Portal designed on the latest Microsoft’s technology SharePoint2010 to pace the growth of the business. Conducted joint application design (JAD) meetings prototyping the life cycle and collecting business requirements from stakeholders and the business users.

Project Manager responsible for the development and implementation of a proprietary tool to ease real estate-related functionalities such as schedule a showing, bookmark a property, financial calculators, Join Interest List, and Help Center. Led the team of developers, designers and database administrators in the creation of the proprietary tool. Shared best practices and served consultatively to Team Members throughout duration of the project. Led the Quality Assurance Team and supported the Test Cases, regularly reviewed the code, and created development and test environments.

Implemented change request policy and designed document change template for database modification.

Tools & Technology: JavaScript, .NET, Microsoft SharePoint 2010, Visual Studio 2010 and SQL server 2008

SOLUTION ARCHITECT

1/2012 – 6/2012

Zevenseas

Amsterdam, NL

Project: TunnelPoint

Secondary Role: Project Manager

Solution Architect reporting to the CEO, Software Development and serving as Project Manager from the conception to project closure of a web-based software providing service that makes it possible for SharePoint site owners to plug in data from external web services by using a no-touch approach to enrich the SharePoint experience.

Responsible for overall for the enterprise architecture and project management of initiatives. Managed team members, mentoring and guiding as needed. Involved in Quality Assurance, performing code reviews, and creating Test Cases. Performed Tuning and performance evaluation of the application.

Created and implemented the Security policy for coding and database design. Provided support for post-production requirements.

Tools & Technology: JavaScript, .NET, Microsoft SharePoint 2010, Visual Studio 2010 and SQL server 2008, AJAX, JQuery

SOLUTION ARCHITECT

8/2011 – 12/2011

Baylor Health, Inc.

Dallas, TX

Project: Enterprise Portal for Baylor University Medical Center

Secondary Role: Project Manager

Solution Architect reporting to the CEO, Enterprise Solutions to set up Microsoft SharePoint as an Enterprise Portal for Baylor University Medical Center. This portal helps patients to self-treat, choose a doctor and understanding the tests and procedures they undergo. Implemented Health Level Seven (HL7) standard, providing a framework (and related standards) for the exchange, integration, sharing, and retrieval of electronic health information, writing workflows and web parts, integrating with the insurance company system.

Converted business requirements into solution designs, designing a web-based systems architecture, service-based architecture, and enterprise application architecture. Optimized architecture activities across company needs, business constraints and technological realities. Managed enterprise integration tools and extract, transformation and load (ETL) tools.

As Project Manager, participated and lead, as needed, project meetings with the customer. Participated in internal projects as required. Implemented Agile (Scrum) project methodologies.

Created Web parts, User Controls, master pages and layout pages.

Created Themes for SharePoint 2010 Portal.

Created reports using Microsoft SQL Server 2008 reporting services.

Developed web services to extract data from insurance system.

Developed and deployed SharePoint 2010 Web parts and Workflows using Visual Studio 2010.

•Developed SharePoint 2010 Machine Workflows using Visual Studio 2010.

•Co-ordinated with the QA team.

Tools & Technology: JavaScript, .NET, Microsoft SharePoint 2010, SharePoint Designer 2010, Windows 2008 Server, Visual Studio 2010, SQL Server 2008, IIS (7.0)

SOLUTION ARCHITECT

1/2011 – 7/2011

Burke County Public Schools Web Portal

Burke County, NC

Client: Burke County Web Portal

Secondary Role: Project Manager

Solution Architect reporting to the CEO, Enterprise Solutions and serving as the Project Manager in the implementation of a SharePoint solution as an Enterprise Portal for 32 Burke County Public Schools. This portal contains numerous workflows, custom web parts, InfoPath Forms, Customized search, 32 Master pages, Layout pages, CSS and custom events for Microsoft SharePoint 2010.

Project Manager of developer and designer teams tasked to complete the project requirements while managing stakeholder expectations and budget requirements. Lead the Quality Assurance team and co-ordinate with the Development Team throughout the project lifecycle.

Technical Support lead to the Development Team, directing the creation of the application framework. Conducted regular code reviews and delivered optimized Database performance.

Tools & Technology: JavaScript, .NET, Microsoft SharePoint 2010, InfoPath 2010, Windows 2008 Server, Visual Studio 2010, SQL Server 2008, IIS (7.0).

SOLUTION ARCHITECT

5/2009 – 12/2010

eITSec

Leicester, UK

Client: Communication Workers Friendly Society (www.cwfs.co.uk)

Secondary Role: Project Manager

Solution Architect reporting to the CEO, Enterprise Solutions in support of the implementation of a project which involved setting up SharePoint as an Enterprise Portal and the development of customized workflows using Windows Workflow foundation (3.0) and deploying them in SharePoint Server 2007. Designed the high level architecture of the application implementing software development best practices.

Acting Project Manager of developers, designers and database administrator teams in the development of a workflow solution for Leave Requisition, Travel Requisition, Conference Room booking, Employee claims, etc. Provided technical guidelines and project plans for setting up features of SharePoint such as Document Management, Content Management, Collaboration, Blogs, Wikis, Document and Forms Libraries and configuring search and indexing capabilities. Responsible for managing the project development activities by the team members and the performance appraisals.

Implemented the security policy for network, database and development tools. Evaluated the performance of the application and performed the tuning of the application.

•Involved in collecting Business Requirements and performed JAD sessions with business users.

•Created of Functional Specification Document (FSD).

•Lead the team in creation of High-Level Design document.

•Setup SharePoint in Development, Staging and Production environments.

•Developed artifacts in InfoPath and deployment in SharePoint environment.

•Developed and Deployed Sequential Workflows for SharePoint 2007 using Visual Studio 2008.

•Customized and implemented branding of SharePoint portal according to business needs.

•Created Test plans and testing scenarios.

Performed Bug resolution and post-production support.

Co-ordinated with the QA team.

Tools & Technology: JavaScript, .NET, asp.NET, Microsoft SharePoint 2007, Windows 2003 Server, Visual Studio 2008, SQL Server 2005

Other Projects

ACE-INA, Toronto, Canada Jan. 2009 – Apr. 2009

Just MFG, Franklin Park, IL Jul. 2008 – Dec. 2008

CalTech System, Caltech, Pasadena, CA Apr. 2008 – Jun. 2008

Enquiry Management System, ITSEC, Leicester, UK Dec. 2007 – Mar. 2008

iPAMS™, ITSEC, Leicester, UK Nov.2006 – Nov. 2007

iSafe™, ITSEC, Leicester, UK July. 2005 – Sep. 2006

iDOX™, ITSEC, Leicester, UK Jan. 2005 - Jun. 2005

NDFS Sales System, ndfs, Bristol, UK July. 2004 – Dec. 2004

Inventory Control System, Data Concepts, VA Nov. 2003 – Mar. 2004

General Ledger System, isobar, Chicago, IL May. 2003 – Sep. 2003

Time and Attendance, Charter Com., CA Jan. 2003 – Apr. 2003

Traffic Ticket System Los Angeles, CA Sep. 2002 – Dec. 2002

YouConvertIt.com Los Angeles, CA Jun. 2002 – Aug. 2002

CURE ACCESS Los Angeles, CA Jan. 2002 – May 2002

e-Car Rental System enterprise, SF, CA Aug. 2001 – Dec. 2001

DIT24 Bug Tracking System SF, CA Jan. 2001 – Jun. 2001

Education

Quaid-e-Awam University of Engineering, Sciences & Technology (QUEST)

2012 – 2015

Masters Degree, Software Technology

University of Sindh

1996 – 1997

Master of Science, Computer Science

University of Sindh

1993 – 1995

Bachelor of Science, Computer Science



Contact this candidate