Mr. Syed Fahad

+1-613-***-****

acdzk8@r.postjobfree.com

IT Related Experience Over 10 years

Security Clearance Secret Level II Canada &R.C.M.P

Canadian Citizen

PROFILE

Mr. Syed is a System Analyst with expertise in Java/J2EE, SharePoint 2010 &

SAP BI/BW with SAP PM module with over 10 years of experience in IT and

object-oriented development. Over the past 5 years he has become adept with

technologies such as Java, J2EE, HTTP, CSS, ASP, SQL, JavaScript, JSP,

JDBC, LDAP, Hibernate, Web Services (SOAP) Apache Tomcat,, WebLogic, Apache

Ant as well as the Apache Struts and Spring Application Frameworks. He has

worked for clients including D.N.D, R.C.M.P and Statistics Canada.

Mr. Syed holds a valid RCMP & Secret Security Clearance.

PROFESSIONAL EXPERIENCE

DND

DRMIS & Shared Work Space Collaboration Team

System Analyst

Jan 2012 - Present

Project Description:

Worked as System Analyst to Analyze, Design and Develop Web Based Solution

using Java, Struts, Tiles, Spring, Hibernate from existing and historical

database. Used IBM InfoSphere DataStage for Data Cleansing, ETL process for

data verification and validation. Part of a BI team assigned to migrate the

legacy (PlannEx Data) into DB2. Used Oracle RDBMS with SQL/PL-SQL for data

extraction. With respect to this following task:

Tasks Performed:

Part of a team assigned for designing and developing an intranet site in

Struts, JQuery to provide collaboration, document sharing and digital asset

management.

Created Content Type, Page Layout, Web Module, User Control & Customized

Enterprise Content Management by using publishing and Team Site

template,Created various workflows, and created Team Sites Template/Site

Definition using Sharepoint 2010.

Provide support to around 1000 site in SharePoint 2010 environment used by

50,000 users. Created site provisioning workflow using visual studio for

collaboration team.

Created custom master pages for branding of SWS website, new article based

publishing page with custom master pages, designed custom content type,

site column.

Analyzed the of Shared Work Space Collaboration team having issue with

Developed custom features and solutions such as Visual Web Part or Event

Receiver or Site Receiver.

Created Business Data Connectivity Service model in with Reporting

Application in Java, Oracle Hibernate & used Spring for IOC.

Accessed data through Spring and Hibernate.

Created prototype for migration of existing ASP.NET sites to Java

Environment.

Created Multiple Page layouts based on specific requirement

Created Meta Data Repository which can manage centrally and can be accessed

through other web based application.

Guided teams and groups in establishing their meta data and helped them in

bulk loading of meta data from excel files.

Conducted a feasibility study to make sure the BI solution proposed is the

right solution

Performed data profiling that is analyzed the contents of data (tables)

residing in PlannEx

Identified whether data meets the quality standards

Identifying data anomalies

Performed normalization and DE-normalization of data residing in

PlannExpert

Identified data gaps between PlannEx and EDR

Designed data model and transformations based on the business requirements

Designed migration strategy as how data will be migrated to BI

Performed Data Mapping

Designed and implemented data extraction process

Designed and implementing data transformation process using IBM Infosphere

DataStage

Designed and developed InfoArea, DataSource, Info Objects, Info Cubes and,

Data Sources using SAP BI/BW

Created Staging Area to store consolidate data and for detail reporting

Created Star Based Schema/Cubes for aggregated reporting.

Developed queries for transformation/update rules

Designed and developed process chains for master data loads and transaction

loads with the help of Info packages. And these process chains are

scheduled for periodic loads.

Producing on demand maintenance reports

Created reports using calculated key figures, restricted key figures,

formulas and created variables.

Royal Canadian Mounted Police (RCMP)

PAT (Police Access Tool)

Senior Developer

Dec 2009- Jan 2012

Project Description:

Contributed to the development of PAT (Police Access Tool) which is one of

the highest priority project, a newly developed web based, enterprise level

and database driven application to access PROS Data (Police Record

Management System) easily in a more user friendly way.

Tasks Performed:

Perform development using Java/J2EE in a Web environment for the PAT

Enterprise Level and database driven application developed using Java/J2EE

and SQL and hosted on a BEA WebLogic Application Server. Development

utilized Eclipse and WebLogic Workshop 10 as IDEs, Struts Framework and MVC

approach to development, Hibernate as the persistence layer framework and

Jasper reports to develop customized reporting within the solution.

Involved in queries and reporting on both the PAT and PROS databases

through developing and maintaining database driven applications using SQL.

Managed change control and version of code with MKS Source Integrity V7.

Communication between PAT, PROS and the overall APPS applications was

implemented using XML and development utilized Web Services including the

SOAP protocol to access data from current Police Record Management System

using SQL Server, Stored Procedure, XMLBean and modified XSD schema based

upon data requirement

Provide third-level support of the enterprise-wide PAT web application.

Application authentication for PAT was based on integrating directory

services using LDAP/X.500 into the PAT application

Provided consultation to small groups using Weblogic 10, created data

access layer in Hibernate, Optimized reporting time by moving some data

access code to stored procedures, adding indexing and using temporary

tables.

Built data entry validation rules using JQuery based validators.

Designed and developed complex Business Rules in Java using Spring based

Webflow framework

Uses XMLBean framework access XML based data through web services in Java

object form which saved time in parsing data from XML.

Created quarterly reports system in PDF using Jasper Reports.

Designed Card reader interface for PAT application to read driving license

and populate the data entry screens to help increase the efficiency of

officers.

Speak with client/officers on daily basis to resolve they experience in

remote areas and propose/fixed their issues with application.

Designed whole new interactive rich web based interface with wizard based

flow to access any complex scenario to minimize training time of Officers

and decrease mistakes in data entry using JQuery, Eclipse, J2EE, XML,

Struts, Spring, Hibernate, XMLBean, Web Flow, Workshop, WebLogic, Web

Services.

Royal Canadian Mounted Police (RCMP)

Annual Performance Planning System (APPS)

Programmer Analyst

Jun 2008 - Dec 2009

Project Description:

Developed and maintained the Annual Performance Planning System(APPS)

project and Risk Register project web based, enterprise level and database

driven applications.

Tasks Performed:

Perform development using Java/J2EE in a Web environment for the PAT

Enterprise Level and database driven application developed using Java/J2EE

and SQL and hosted on a BEA WebLogic Application Server Development

utilized Eclipse and WebLogic Workshop 10 as IDEs, Struts Framework and MVC

approach to development, Hibernate as the persistence layer framework and

Jasper reports to develop customized reporting within the solution.

Involved in queries and reporting on DB2 databases through developing and

maintaining database driven applications using SQL Managed change control

and versioning of code with MKS Source Integrity V7.

Communication between PAT, PROS and the overall APPS applications was

implemented using XML and development utilized Web Services including the

SOAP protocol to access data from current Police Record Management System

using SQL Server, Stored Procedure, XMLBean and modified XSD schema based

upon data requirement.

Provide third-level support of the enterprise-wide PAT web application.

Application authentication for PAT was based on integrating directory

services using LDAP/X.500 into the PAT application. Provided consultation

to small groups using Weblogic 10, created data access layer in Hibernate,

Optimized reporting time by moving some data access code to stored

procedures, adding indexing and using temporary tables.

Built data entry validation rules using JQuery based validators.

Designed and developed complex Business Rules in Java using Spring based

Webflow framework

Uses XMLBean framework access XML based data through web services in Java

object form which saved time in parsing data from XML.

Created quarterly reports system in PDF using Jasper Reports.

Designed Card reader interface for PAT application to read driving license

and populate the data entry screens to help increase the efficiency of

officers.

Speak with client/officers on daily basis to resolve they experience in

remote areas and propose/fixed their issues with application.

Designed whole new interactive rich web based interface with wizard based

flow to access any complex scenario to minimize training time of Officers

and decrease mistakes in data entry using JQuery, Eclipse, J2EE, XML,

Struts, Spring, XMLBean, Web Flow, Workshop, WebLogic, Web Services.

Royal Canadian Mounted Police (RCMP)

Historical Archiving

Senior Data Analyst

Feb 2011 - July 2011

Project Description:

The purpose of the Historical Project is to archive old data but which is

useful for analytical (reporting) purpose so information from it can be

used for future strategic planning. Used Oracle RDBMS, IBM InfoSphere

DataStage, Stored procedures, database driven application which would allow

access and reporting on past data which no longer exists(will get deleted

in near future) in the current RCMP PROS system.

Tasks Performed:

Weekly task include meeting with client to understand business requirement.

Perform development using Java/J2EE in a Web environment for the Historical

Enterprise Level and database driven application developed using Java/J2EE

and SQL and hosted on a BEA WebLogic Application Server.

Development utilized Eclipse and WebLogic Workshop 10 as IDEs, Struts

Framework and MVC approach to development, Hibernate as the persistence

layer framework and Jasper reports to develop customized reporting within

the solution.

Involved in queries and reporting on the database through developing and

maintaining database driven applications using SQL

Managed change control and versioning of code with MKS Source Integrity V7.

Provide third-level support of the enterprise-wide application.

Optimized reporting time by moving some data access code to stored

procedures, adding indexing and using temporary tables.

Created Data extraction of some old data from current database to

Historical data, used IBM InfoSphere DataStage with Oracle RDBMS, written

stored procedures, designed database for data staging purpose.

Royal Canadian Mounted Police (RCMP)

Mayor's Report

Programmer Analyst/ Java Developer

July 2011 - Aug 2011

Project Description:

The purpose of the Mayor's Report Project was to develop and enterprise

level, database driven web application which reports how many type of

crimes are being reported in specific time period and count if they

actually occurred, were unfounded or the number of people charged for that

crime so a Mayor or Head of that department can monitor the progress of

their division, district or detachment and then allocate resources/fund in

respective areas.

Tasks Performed:

Perform development using Java/J2EE in a Web environment for the E&R III

and Ringtail Enterprise Level and database driven applications developed

using Java/J2EE and SQL and hosted on a BEA Weblogic Application Server.

Development utilized Eclipse and Weblogic Workshop 9 as IDEs, Struts

Framework and MVC approach to development, Hibernate as the persistence

layer framework and Jasper reports to develop customized reporting within

the solution.

Involved in queries and reporting on the database through developing and

maintaining database driven applications using SQL

Managed change control and versioning of code with MKS Source Integrity V7

Communication between applications was implemented using XML and

development utilized Web Services including the SOAP protocol to access

data from current Police Record Management System using Oracle, Stored

Procedure, XMLBean, modified XSD schema based upon data requirement.

Provide third-level support of the enterprise-wide web application.

Application authentication was based on integrating directory services

using LDAP/X.500 into the applications.

Provided consultation to small groups using Weblogic 10, created data

access layer in Hibernate, Optimized reporting time by moving some data

access code to stored procedures, adding indexing and using temporary

tables.

Built data entry validation rules using JQuery based validators.

Designed and developed complex Business Rules in Java using Spring based

Webflow framework

Uses XMLBean framework access XML based data through web services in Java

object form which saved time in parsing data from XML.

Created quarterly reports system in PDF using Jasper Reports.

Designed whole new interactive rich web based interface with wizard based

flow to access any complex scenario to minimize training time of Officers

and decrease mistakes in data entry using JQuery, Eclipse, J2EE, XML,

Struts, Workshop, Weblogic, Web Services.

Statistics Canada (SC)

Java Developer/ Programmer Analyst

January 2008 - May 2008 (5 months)

Project Description:

The Integrated Metadata Base (IMDB) is a corporate repository of

information on each of Statistics Canada's nearly 400 active surveys (and a

roughly equal number of discontinued surveys). These surveys are the

Agency's core activities and the IMDB is the principal mechanism by which

they are documented, providing a key information resource for corporate

knowledge management and for data users.

The database is resident on a central server. For the initial load of this

database, metadata were collected from a variety of pre-existing metadata

stores, reformatted and validated and loaded into the new metadata base.

The database is kept up to date by Standards Division staff, which obtains

the necessary information from specialists in subject-matter divisions and

input this information through a system deployed over the departmental

Intranet. Formatted HTML pages of the IMDB content are made available on

the Statistics Canada web site. They can be accessed through hyperlinks

from CANSIM, from the online catalogue or from statistical tables on the

web site.

Statistics Canada is now extending the capabilities of the IMDB in order to

function as a register for the Bureau's Enterprise level Architecture

artifacts.

Tasks Performed:

Researched and became familiar with the IMDB data model, IMDB Java

Framework, existing interfaces to the IMDB, the EA requirements and the

IMDB Development Environment.

Designed, developed, implemented and tested the enterprise level and

database driven application utilizing Java, J2EE, JDBC, XML, JSP, and

Struts framework, SQL, Ant, Tomcat and Oracle 10g.

Utilized Eclipse as the IDE for development.

Developed and maintained the Integrated Metadata Base using SQL.

Participated in code reviews and acceptance testing with management and

users.

Responsible for updating system documentation, and for documenting program

design and quality standards.

The solution developed included a Consumer-Provider Relationship user

interface, a Classification Linkage/Management user interface, a

Documentation Linkage user interface, a Timeframe Linkage user interface,

and an Organization Linkage user interface.

Participated in the provision of problem debugging and resolution.

Provided other Programmer Analyst services, as and when required.

Environment: Java, J2EE, JSP, JDBC, Servlets, XML, Eclipse, Oracle 10g,

SQL, HTML, CSS, Struts, SQL, JavaScript, UML, Tomcat, ANT

Nokia

Programmer Analyst/Product Support Engineer

September 2005 - December 2007 (2 years, 4 months)

Project Description:

Worked as a Technical Support Consultant and Programmer for Enterprise

Security Products such as VPNs and Firewalls, based on the Nokia/Checkpoint

Firewall Product. Developed an Enterprise Level an database driven web

based application to provide a graphical user interface for the Nokia VPNs

and Firewalls.

Tasks Performed:

Designed and developed a new Web based Graphical User Interface enterprise

level and database driven application for the NOKIA VPNs and Firewalls. The

technologies used were JAVA, J2EE, Spring, Hibernate, AXIS SOAP engine, JMS

and LDAP, Custom Tag Libraries, XML, HTTP, JSP, Apache ANT, SQL, Apache

Struts Application Framework and JavaScript

Developed and maintained applications using SQL.

Modelled a number of DB tables in Hibernate and created a bunch of Data

access objects that were exposed to the front end using web services

Provided authentication by integrating directory services using LDAP/X.500

integrated into the enterprise level VPN and Firewall interface

application.

Utilized Eclipse as the IDE for development.

Identified and documented shutdown strategies, and documented database

content, structure and application sub-systems.

Created a number of JSP custom tags to simplify the developer's life for

the most commonly used cases.

Developed email notifications generated by the application using messaging

protocols including SMTP, POP and IMAP.

Provide support for security appliances for Nokia which run additional

security software such as Checkpoint, IPSO (Secured FreeBSD), Splat

(secure platform), a modification of RedHat Linux

Configured, debugged and troubleshot HTTP, HTTPS, DHCP, DNS, SMTP, FTP and

various network access issues using C++ between networks distributed as

Site-Site VPN Network

Development of a debugging and logging utility for enterprise level web

application using Java, JDBC, Custom Tag Libraries, XML, HTTP, JSP, Apache

ANT, SQL, Apache Struts Application Framework and JavaScript

Performed other related Programmer Analyst services, as and when required.

Environment: JAVA, Spring, Hibernate, AXIS SOAP engine, JMS and LDAP,

Custom Tag Libraries, XML, HTTP, JSP, Apache ANT, SQL, HTTP, HTTPS, DHCP,

DNS, SMTP, FTP, Apache Struts Application Framework and JavaScript

Aashaz Technology Inc.

Programmer/Analyst

September 2004 - October 2005 (1 year, 2 months) (count 1 year full time

during regular business hours)

September 2005 - October 2005 (2 months)

(Part-time, providing transitioning support outside of normal business

hours)

Project Description:

Worked as part of distributed team a J2EE based enterprise level Product

called "CRM" which is running in IT departments of many Multi National

companies. Designed and implemented using JSP, Java Custom Tag Libraries,

and Java Scripting under the Apache Struts Application Framework and using

web servers such as Apache Tomcat and WebSphere.

Tasks Performed:

Built XML Parser Generator and used as ETL utility XML Properties files

Parser using JAXP, SAX and (Validation, Extraction etc).

Analyzed system performance and tuned systems.

Performed development and maintenance of the enterprise level and database

driven CRM application using SQL, Java, J2EE, JDBC, HTML, CSS, JavaScript,

JSP, Struts framework, Spring, ANT and CGI

Developed HTTP request and response class using sockets.

Identified and documented shutdown strategies, database content, structures

and sub-systems.

Developed a debugging and logging utility for web application, and provided

problem debugging and resolutions.

Utilized Eclipse as the IDE for development

Created a HTML Browser for Editing /Generating Test-Script.

Used various Design Patterns such as Singleton, and MVC.

Designed and developed a data entry tool.

Integrated the application into IBM Websphere MQ using JMS.

Wrote Java classes for the business layer and embedded SQL for the access

layer that search contents from Oracle database using JDBC/DNS connections.

Participated in all phases of development and testing.

Developed email notifications generated by the CRM using messaging

protocols including SMTP, POP and IMAP

Responsible for client side development.

Wrote Oracle PL/SQL packages.

Designed, developed and maintain Software Edge application.

Participated, as a team member of Java Developers, to develop application

reports based on Java 2 Enterprise Edition (J2EE) and Oracle9i Database.

Developed components for each scoped mandatory enhancement, change requests

for the business function, complete development of JSP, Data Access Object.

Reviewed design/build specifications with Development Business Analysts and

Development lead.

Worked under the direction of the specified Development Lead in developing

JSP Forms/form beans and other MVC components in Application development.

Performed code reviews and modifications under directions from the

Development Lead.

Coordinated and performed unit tests and system tests with the team

members/analysts/end users.

Contributed pro-actively by completing tasks in accordance with established

project tracking processes as defined by the Project Manager and the

Development Lead.

Provided other related Programmer Analyst services, as and when required.

Environment: Java, J2EE, JSP, Servlets, XML, Jbuilder, Oracle 9i, SQL,

Rational Rose and OO Design, HTML, CSS, Struts, Spring, SQL, JavaScript,

UML, Jbuilder, TCP/IP, RDBMS, WebSphere, Tomcat.

Freelance

Programmer/Analyst

August 2003 - August 2004 (11 months)

Project Description:

Worked as a Freelance Developer on a .NET/J2EE based JAVA enterprise level

application product called "Application Generator" for GUI based

application development without writing queries, HTML or even any line of

code by hand. It started as .NET project which was later ported to JAVA

using MONOPROJECT commercial version MainSoft which allows to run Microsoft

.Net based application to any J2EE based Server Tomcat, Design ER model

and implemented persistence layer after redesigning Data Access layer using

DAO to allow multiple Database server, wrote ANSI-SQL to maintain Database

independent query language. Application was re-designed using MVC model to

maintain complete independency of each module with underline

implementation.

Tasks Performed:

Analyzed the system performance and tuned the system.

Completed remodelling of database access, and documented the database

content, structure, and sub-systems.

Identified problems, documented issues, and developed solutions.

Added application framework utilities such as debugging tool,

internationalization

Organized all queries in XML file, backup and restore utility and with

encryption of backup file.

Performed application development and maintenance of the enterprise level

and database driven Application Generator application using JSP, Sockets,

Threading, Swing, SQL, XML, Mail SMTP, JAXP, SAX, DTD, ORACLE, MS-SQL

SERVER

Provided other related Programmer Analyst services, as and when required.

Environment: Visual Studio.Net C#, Core Java, J2EE, JSP, Tomcat, Oracle,

SQL Server, SQL, OO Design, XML, HTML, CSS, ASP.NET, Mainsoft, UML,

JBuilder, RDBMS.

ABM-IT

Programmer Analyst

January 2003 - August 2003 (8 months)

Project Description:

Worked as a Software Engineer in ABM-InfoTech on a Java based Product

called "HELPDESK" for call logging etc. which is running in IT departments

of many Multi National companies and developed using the Apache Struts

Application Framework. It is JSP based product and a Testing Tool was also

developed by using JSP, Sockets, Threading, Swing, Sockets, XML,TCP/IP,

JAXP,SAX,DTD,ORACLE,MS-SQL SERVER . UML Designing tools used such as Magic

Draw and for Version Control Software CODE COOP was used. Some work was

also done in ASP.3 for implementing the information gathering tool from the

user, using Oracle 9i as database.

Tasks Performed:

Analyzed systems performance, tuned the system and provided all supporting

documentation.

Participated in the design and development of a five-tier web based

enterprise level and database driven application, including use cases,

class diagrams, ER diagrams, sequence diagrams and navigation maps using

Object Oriented (OO) design UML for design and Java, J2EE, JDBC, HTML, CSS,

ANT, SQL, JavaScript, JSP, Struts framework, ASP and CGI for development.

Utilized Eclipse as the IDE for development.

Wrote code for creating account, maintaining user privileges, auditing,

email generation, customize notifications, using Java, J2EE, JDBC, HTML,

CSS, ANT, JavaScript, JSP, Struts, ASP and CGI.

Developed email generation feature using messaging protocols including

SMTP, POP and IMAP.

Worked for the setup of Struts framework using Tiles technology for the

front end.

Participated in the designing of database model based on RDBMS principles.

Wrote custom tags for serving pages according to client requirements.

Performed migration of data (including sensitive information) from older

version of application to the newer version of it.

Wrote triggers and stored procedures in the database to provide auditing

capability to the application.

Worked in J2EE environment, and wrote Bean, Business and Access layers code

in Java while presentation layer in JSP / XML using an Oracle database.

Participated in the complete development cycle of this application, and

worked on implementation of all layers, i.e. Database, Access layer,

Business layer, Bean and presentation layer.

Developed unit test plans, and created test plans and test cases.

Implemented web interfaces using J2EE (JSP/Servlets/EJB), HTML and

JavaScript, using (OO) design using UML methodology and process.

Developed Embedded SQL scripts to create tables, sequences and loading

data.

Performed systems analysis and design using UML, and worked on the Clear

Case system repository.

Responsible for the customization of application and implementation

(coding) of the performance testing tool.

Helped the QA team in testing different builds by integrating the different

components of each new build.

Assisted in the debugging of various pieces of codes written in Java / JSP

Involved in analyzing different problems related to loading of data from

one database to another

Responsible for the development of Data/Business Tier using Java and JDBC,

and the Presentation Tier (JSP/ XML

Responsible for the complete development and testing cycle.

Performed other related programmer analyst services, as and when required.

Environment: Java, J2EE, JSP, Websphere Studio, Oracle, SQL, Rational Rose

and OO Design, PL/SQL, EJB servlets, XML, HTML, CSS, ASP, Struts, SQL,

JavaScript, UML, Rational Rose, Clear Case, JDeveloper, RDBMS, PERL,,

Ultra Dreamweaver 4.0, Sun Solaris/Sun OS

TECHNICAL SUMMARY

Language

C (under DOS & UNIX)

C++

Visual Basic v 6

SQL, PL/SQL

COM Objects

SQL/PL, JAVA 2, CORBA

UML, Rational Rose, XML

Microsoft .NET Enterprise

J2EE, ASP.NET, VB.NET, C#.NET

Web development

MS Front Page, JAVA & VB Scripting,

XML, XSL, XHTML, HTML, ASP, JSP, Servlets, Struts, JQuery,WebFlow,

PHP, EJB, JMS, ASP.NET, VB.NET, ASP classic,C#.NET.

Networking

Windows 2000,

Window XP,

UNIX, Microsoft Proxy Server

IIS, Apache Server

Operating System

Windows XP,Windows 7, 2008 Server, LINUX, Unix

APPLE Mac

JAVA Framework

Microsoft .NET Framework

Jakarta Struts, Spring, WebFlow, Hibernate, Jakarta Validation, Jakarta

Velocity

Web Server

Oracle Container for JAVA

WebLogic Application Server

Jakarta Tomcat

IBM Web Sphere

MS Internet Information Server

JRUN Server, Apple Web Object

Jakarta Apache Server

ORACLE 9iAS

System Repository

ClearCase

MKS

CVS

Testing Tool

Rational Robot

Win Runner

JUnits

Object Models

JavaBeans, COM

Case Tools/Modeling

ClearCase,

Rational Rose

Microsoft Visio 2002

ERWIN 3.5

Magic Draw

Tools

IBM WSAD 5.1, Oracle Jdev

Microsoft Visual Studio.NET, Microsoft Visual Studio 6.0

MyEclipse

Weblogic Workshop

JBuilder X

C/C++

Turbo Prolog 3.0, Turbo C 3.0

JUnit

EDUCATION

B.C.S, Bachelor of Computer Science (2003) (N.U.C.E.S) University F.A.S.T

Microsoft Certified SharePoint Application Sharepoint 2010

Contact this candidate