Project Manager Sql Server

Asif Nawaz Cell : 647-***-****

* ******** ******* *****: ****-*****@*******.***

Vaughan - ON, L4H 3B1

Summary of QualificationsBusiness / Systems Analyst: SDLC; Requirements and Project Feasibility Analysis etc.Programming: Applications Designing, Coding and Implementation, Microsoft Visual Basic 5.0 / 6.0 / VB.NET with third party components (TDBG, VSFlexGrid controls), N-Tier and Client/Server architecture, VBA, API calls. ADO/RDO/XML.COM components: Fully functional (self developed); Database connectivity, Dataware components, Transactions Log COM DLL/EXE components.Databases: MS-SQL Server 6.5 / 7.0 / 2005 (T-SQL)/Database Administration, TOAD for ORACLE 11i, MS-SQL Server Administration with Database Backup and Restore, Query analyzer, SQL Enterprise Manager, DTS, Security; Logins and User roles.ECM (Enterprise Content Management): Documentum Desktop/Webtop/Content

Server, DocApps, Application Installer, Application Builder, DA, and Workflows.Report Writing: Crystal Reports 4.2/6.0/7.0/8.0Methodologies: MS-Visual Modeler, Test Cases (User Acceptance Testing)Operating Systems: Windows 2000 / XP / 2003, UNIX.Internet Concept & Networking: IIS, TCP/IP, DNS, WINS, SMTPRemote Connectivity: WebEx, GoToAssist, Windows NetMeetingCase Reporting Tools: PeopleSoft CRM 8.0 / Vantive, REMEDY, ARIBA, SMS.

Professional Experience

Insurance Systems Inc. Jun. 2008 – Jul. 2012

Systems Analyst Toronto, CanadaParticipated in business conference meetings with Project Manager/Client Managers for new business needs.Analyzed and evaluated information and business process requirements pertaining to requested application/database enhancements or changes.Coordinated with Business Analyst to understand the change required as per details mentioned in BRD (Business Requirements Document).Proposing viable systems change followed by implementation on change request approval.Presenting process flow diagrams pictorial view. Goal is to eradicate errors, minimize performances issues and provide efficient data flow.Change Request (SRD/BRD): Documenting FSD (Functional Specifications Document) template (IPS: ISO Projects Standards), translating business terms into technical functions.Specified process description and scope, current functionality followed by proposed functionality. Created current Flow Diagram, Proposed Flow Diagram.Inputs/Outputs, Data validations, database tables/fields and queries/scripts.Backup and Rollback procedures, pertaining to DR (Disaster Recovery).Maintained document-changes history and versions.Digital sing-off from Business personnel (Business Change In-charge).Nominated developer and getting sign-off from developer.Meeting with QA to get a change-implementation final approval (sign-off). Conducted module/application smoke-testing prior to handing over to the Project Manager for deployment on Productions servers.Kept compete monitoring log of development life-cycle phases.Introduced new modules to automate processes.Designed and implemented proposed interfaces and changes to components/databases.Made changes to database structure (data-modeling, data-dictionary and relationships).Optimized and fine tuned queries, indexes for smooth application/reports performance.Identified and resolved performance-limiting problems.

Accenture - Canada Jul. 2007 – May. 2008

Analyst/Programmer Toronto, Canada

Documentum ConsultantOn-going project based role; La-Roche Pharmaceuticals in Nutley-NJ, United States.Supported Documentum Desktop/Content Server/Workflow Manager/DocApp/Virtual Document Manager, JVM/JRE, Apache Tomcat 4.0.6/5; integrated with Vantive (Peoplesoft).Analyzed client’s Business infrastructure /Workflows/Document Lifecycles/Cabinets/Folders/Documents.Created automations (Objects Export/Import, Check-In/ Check-In).Created and configured new Docbase/Docbroker. Collaborated with Production Services (built Production and Test servers from ground zero).Tuned docbase configurations; dmcl.ini/server.ini, projected docbases on Docbroker, ready for use on Production/Test servers.Dumped/Loaded full and partial docbase data from Production docbase. Consecutive 3 months (Quarterly) refreshing of Test docbase for users training.Coordinated with business, to test and verify changes; patches, Docbase Database and GUI modifications that were applied in Test environment, and deployed over to Production.Modified Default/Custom DocApps in Applications Builder. Released new DocApps versions.Added/modified new/existing attributes. Mapped attributes/fields in Docbase database tables hosted on SQL Server. Installed default/Custom DocApp using Applications Installer.Workflows manager; worked with and troubleshoot workflows. Created new/modified workflows/Activities/Workitems/Packages.Docbase administration; Executed periodic jobs; dm_DMClean, dm_ConsistencyChecker, dm_DMFileScan etc.Used Documentum Administrator/SAMSON for DQLs and APIs.User accounts administration in Documentum Administrator; granted users/objects permissions. Created/added users to groups and new groups. Created and applied ACLs to groups/users/objects.

Business Systems AnalystManaged complete systems development life cycle. Managed team of 4 support personnel.Congregated business requirements and stem process flow changes. Coordinated in business meetings with Project Manager/Client CEO/Client Managers for new business needs and tracking any process transformations.

Analyst/Programmer Created/modified GUI screens according to client’s specifications; Visual Basic 6.0/NET.Reverse engineered; identified application issues. Functional changes to COM components.Created/modified databases in MS-SQL Server 2005.Created DTS Packages for data transfer across databases.Monitored logs/processes/activities for optimized database performance.

IBM Canada Oct. 2005 – Jul.2007

Systems/Technical Analyst Toronto, CanadaThis was an on-going project based role for British Petroleum.Contributed in business meetings with Project Manager/Client Managers for business needs.Conducted Requirements Analysis; analyzed, evaluated data flow and business process requirements pertaining to requested application/database enhancements or new requests.Optimized application and database performances by fine tuning queries and code structure.

Goal was to eradicate errors, minimize performances issues and provide efficient data flow.Introduced new techniques to automate processes.Proposed viable systems change followed by implementation on change request approval.Designed and implemented proposed interfaces and changes to components/databases.Modified database structure (data-modeling, data-dictionary and relationships).Identified and resolved performance-limiting problems.Created Functional and Technical Specifications. Managed and allocated tasks to programmers and database architects.Monitored logs/processes/activities for optimized database performance.

EMC - Documentum Jun. 2004 – Sep. 2005

Documentum Support Analyst Toronto, CanadaPrimary support included EMC applications. Resolving cases per SLA/SOPs.Analyzed, researched, troubleshoot and provided support to different enterprise clients.Technical and application support included WebTop, Documentum Desktop, Documentum Administrator, Imports Manager, DFC/DMCL configurations, Documentum Content Server (Docbase/Docbroker), Applications Installer, Applications Builder, Workflow Manager, JVM, JRE, Apache Tomcat.Docbase and Docbroker Configurations; Includes Service Packs from 5.2.5 SP1, SP2 and SP3. Also used SAMSON for DQLs/APIs and Documentum Administrator for Administration.User accounts administration in Documentum Administrator; adding users to groups, permissions to objects and groups. Using API and DQL to fetch users, objects data.Researched on EMC applications; created Bug Notes / Feature Requests / Support Notes.

EducationMS - Computer Sciences 1996 – 1998

Majors: Systems Analysis and Design, RDBMSBS - Computer Sciences 1994 – 1996

References

Available on request

Contact this candidate