1 Rajna Pajkic 55 Erskine Av, # 701, Toronto, ON M4P 1Y7 ...

snailyakΑσφάλεια

5 Νοε 2013 (πριν από 4 χρόνια και 7 μέρες)

149 εμφανίσεις

1


Rajna Pajkic


55 Erskine Av, # 701, Toronto, ON M4P 1Y7 / 416.880.1921
rajna@procc.ca


___________________________________________________________________________
_______________


Summary

Experienced Database/SharePoint/Web Solution/Information Architect with a
broad knowledge of project management, business systems analysis, database
system
s design and modeling, taxonomy, ontology, knowledge management and
web messaging technology


Led web technology development on several enterprise projects that improved
business process in terms of higher performance, high accessibility, availability,
acc
uracy and increased revenue


Designed dozens of banking solutions and databases based on the advanced
analytical skills for complex problem solving, data modeling as well as significant
in
-
depth knowledge of the SDLC



Published Scientific Paper


On the d
ual symmetrical theory of the complex vector field


/
Quantum Physics



Education



Bachelor of Science in Physics, University of Sarajevo


Work Experience


January 2012


Present

SharePoint Consultant / Information Architect/Business Analyst,
Magna International Inc.,
Aurora


PROJECT


MagNET INTRANET PORTAL REDESIGN




Responsible for developing information and application architecture for the MagNET
intranet SharePoint 2010 Portal redesign project that includes existing SharePoint 2007
Publi
shing as well as Collaboration sites



Conduct data analysis and data gathering information architecture discovery sessions
as well as eliciting business requirements with different focus groups that consist of
international senior management stakeholder
s in a full day long sessions



Conduct stakeholder interviews in order to gather business strategy for the departments
involved in the project



Document and present business requirements in the BRD with identified set of use
cases and solicit final app
roval



Document the existing information architecture for the specified SharePoint 2007
implementation sites and the file share in some cases by creating required documents
2

that include a list of an identified unique document types within the existing si
te
structures, content types and metadata analysis, as well as the relationships between
existing content types and associated columns



Develop wireframes that depict new user interface design and high level architecture of
the MagNET intranet portal as

well as the detailed architecture of the individual sites
and site pages



Create site map of the new and improved IA that works with SharePoint 2010 and map
it to the existing IA of the MagNET that reflects content moves between publishing and
collabo
ration sites involved in the redesign process



Develop taxonomy by identifying enterprise content types that can be used throughout
different sites by utilizing the Content Type Hub, and by defining managed metadata via
Managed Metadata Services



Defi
ne site collections and site structures, as well as navigation



Plan and define information management policy and governance



Perform a very large SharePoint POC based on the Information architecture design that
includes configuring the system and sett
ing the sites using out of the box functionality,
custom workflows, custom web parts and use of InfoPath forms, BCS with external
content types as well as enabling Excel Services



Define and create different sites templates, master pages and page layout
templates in
order to improve consistency and efficiency of the site design as well as to improve user
adoption



Perform search configuration and customization by defining managed properties and
utilizing best bets, managed metadata, keywords that will p
opulate the refinement panel
enabling filtering and drilling down into the search results



Define the Application Architecture based on the information architecture design plan
that includes logical information architecture with the site
map, site collections, site
structures and navigation, site and page templates, wireframes, content modeling and
content types, metadata and taxonomy, development, with search configuration and
integration



Support complex migration of the content by cr
eating a content migration point to point
document for all included sub sites under the MagNET intranet portal



Work closely with development team in order to help them to translate the final
information architecture documentation into a technical speci
fications



Conduct managed metadata educational sessions for the Business and create
managed metadata training material as well as best practices and governance policies
documents in order to support the use of the Term Store Management Tool



Improve
the approval workflow so it runs faster and execute automatically based on the
who initiated the workflow



Present to the Senior Management Information and Application architecture design


December 2011


February 2012

SharePoint Consultant / Informati
on Architect/Business Analyst,
Detour Gold Corp.,
Toronto

1


PROJECT


DETOUR GOLD PORTAL SHAREPOINT IMPLEMENTATION




Responsible for eliciting business requirements as well as developing information
architecture for the intranet Share
Point 2010 Company Portal including custom complex
cross
-
farm sites navigation between the head office and the Mine site



Conducted one
-
on
-
one interviews with business stakeholders to gather business vision
as well as business requirements



Conducted i
nformation architecture discovery sessions with identified stakeholders for
both sites



Documented and presented business requirements in the BRD and solicit final
approvals



Developed information architecture as a result of information architecture discovery
phase that includes logical information architecture with site map, site architecture and
navigation, page layouts, and wireframes, content distribution and capacity plann
ing,
content types and metadata, search engine planning and optimization, information
architecture security planning and web content management with analytics planning and
reporting



Identified and created enterprise content types and share them among
two SharePoint
farms by utilizing Managed Metadata Service and its feature Content Type Syndication
Hub



Developed ontology and taxonomy and created Term Store and general Term Set
import file with common managed terms to be used across the SharePoint fa
rms via
Managed Metadata Service



Trained stakeholders on managed metadata and how to create managed terms



Presented Information architecture planning document to the senior management


June 2011


December 2011

Information Architect
-

SharePoint,
Ca
nadian Tire Corporation, Toronto


PROJECT


STORE PORTAL REDESIGN




Responsible for developing information architecture for the extranet SharePoint 2010
Store Portal including Publishing site with a complex custom developed Publishing
Agent, that serves
as the main point of communication between the Corporate Home
Office and all active 478 Canadian Stores across Canada as part of the $4M big project
with objectives to redesign Store Portal while migrating it from SharePoint 2007 to
SharePoint 2010



Perf
orm discovery phase, including creating end
-
user information architecture
questionnaire, card sorting exercise, full application assessment, with complete content
inventory that consist of currently 20234 published items across 70 SharePoint
sub
-
sites, con
tent type and metadata analysis, and conducting in
-
depth customer
interviews

2



Conduct one
-
on
-
one interviews and focus groups with business stakeholders to gather
business vision as well as business requirements



Develop information architecture as a
result of information architecture discovery phase
that includes logical information architecture with site map, site architecture and
navigation, page layouts, and wireframes, content distribution and capacity planning,
content types and metadata, people
and personalization planning as well as social
tagging, search, information architecture security planning and web content
management with analytics planning and reporting



Introduce use of Excel Services for specific reports so they don

t have to get
downloaded to the client computer anymore



Create Enterprise content types and share them via Managed Metadata Service among
English and French site collections as well as to allow presentation of a different type of
content such as external content type
s linked to external data sources through BCS



Plan, define and implement managed metadata (taxonomy) through features of the
Enterprise Metadata Management that includes classification of the content by creating
hierarchical set of terms and terms sets
to improve the search through tagging and
custom refiners



Improve putabilty as well as findability of information through defining and applying
metadata that are discriminatory, entered accurately and consistently through the
central management of co
ntent types and managed metadata



Plan and implement Information Management Policy including document management
policies(document

s life cycle), retention, expiration and audit of the content



Add thesaurus feature to improve the search through use o
f synonyms



Develop and recommend new information architecture / security model where currently
2M ACLs could be reduced to 10K which could considerable improve performance



Improve performance by implementing HTML templates to change the publishin
g
process from embedded PDF to the

lightweight


HTML content. There are currently
12487 PDF published items on the Portal



Create Managed Metadata Best Practices as well as Managed Metadata Governance
policies documents in order to sustain business process once the project is completed



Create Managed Metadata training material and train designated group of users on
what Man
aged Metadata is and how to create and manage it by using Term Store
Management Tool



Present to the Senior Management and participated in all project meetings


April 2009


March 2011

IT Consultant / SharePoint Specialist,
BC&G LLP, Toronto


PROJECT


MOSS 2007 IMPLEMENTATION




Managed the implementation and deployment as well as interviewed and facilitated JAD
sessions to gather business requirements in order to develop project plan and to define
1

the solution & information architecture of the Corpor
ate SharePoint Intranet Site
developed in MOSS 2007



Documented business requirements and solution scenarios by developing Use Cases,
Activity and Context Diagrams



Built wireframes to communicate the site structure and navigation



Created Solutio
n Architecture Document as well as Logical Design document



Architected the SharePoint farm infrastructures for production, staging and development
environments



Communicated with clients to scope a major project of moving the central content
manageme
nt application to the SharePoint and direct the development cycle from
inception to completion



Translated business requirements into a technical solution, defined information
architecture, designed and managed development of the SharePoint solution th
at
mapped the existing functionality in the SharePoint environment through the use of
metadata and custom content types



Developed governance model for the MOSS 2007 solution



Defined document management policies, site navigation, branding, and site
templates to
support governance model



Developed and implemented workflows using SharePoint Designer 2007 and MS
InfoPath



Evaluated third party tools in order to integrate Hummingbird DMS with SharePoint and
to ensure that backup and recovery are man
aged well as it

s very important that the
SharePoint Corporate Intranet Site is always accessible and its content secure as the
company holds a very sensitive data



Selected the IT vendors based on the evaluation of the products (SeeUnity & AvePoint)



Managed migration to SharePoint 2010 by using AvePoint migrator tool



Built taxonomy using the TermStore Management Tool



Implemented Tag Cloud WebPart so users can identify their relevant topics(folksonomy)



Managed and coordinated all work teams
as well as external vendors and suppliers



Presented to the Senior Management and conducted

Lunch & Learn


sessions


Oct. 2007


March 2009

Database Solution Architect / Team Lead,
Scotiabank, IT&S, Toronto


Project


branch Technology refresh


BTR (WIN xP) dEPLOYMENT / CONVERSION

BTR is the largest project that Scotia Bank has undertaken in the last twelve years, with the
allocated budget of $80M. BTR

has won an industry award
-

CIO 100 for 2009
.



Responsible for project database solution business requirements definition, data
modeling, design, architecture and development of a logical data model that spans
enterprise multiple data sources required to track and report on ~45
,000 devices and
35,000 LAN connections of existing and the target system and implementation activities
2

necessary for successful conversion to Win XP at ~1150 branch locations across
Canada



Collaborated closely with the network group in order to manage
network connections,
switches, routers, firewalls, TCP/IP protocols in the new post conversion state



Without sophisticated database it was expected that there would be significant delays
and project rework. The database also provided rich reporting cap
abilities, asset
management and software version control



Refresh has saved $1.2 million annually in printing costs and $3 million in one
-
time
execution costs. The company also projects a revenue increase due to the new
technology of $1.95 million withi
n five years.



Examined processes, data and environment, collaborated with business stakeholders in
order to deliver a detail proposal and Data/Application architecture for the project



Properly identified all relevant concerns using business scenari
os as well as developed
different architecture views of the overall Data/Application architecture to support it



Created Activity diagrams for the several use cases in order to show the structure of a
flow of events



Established which elements of th
e current system must be carried forward and which
must be replaced or removed as well as how to introduce brand new elements of the
future system



Fully automated key processes related to the execution of the BTR project created
conditions required for
meeting very tight shipping schedules especially for distant
locations, and for maintaining shipping orders accuracy for an outside vendor, which
helped the project execution within the budget and three days ahead of schedule



Conducted project
-
specific
data and business analyses, perform data mining in order to
extract data from the third
-
party shipping warehouse
-
MicroAge as well as to collaborate
with IBM consulting team during the reconciliation process to ensure that financial
statements accurately re
flect the real picture of the branch assets after the BTR project
is completed



Presented to the Senior Management, team members, trained users and create
documentation for the BTR database solution and conducted the

Lunch & Learn


series

Oct. 2007


M
arch 2009

SharePoint Solution Architect / Team Lead,
Scotiabank, IT&S, Toronto

Project


branch Technology refresh


BTR (WIN xP) SharePoint Intranet site



Defined information architecture, designed, built, customized, deployed and
administered BTR Shar
ePoint Intranet Site using best practices, with 110 active users
and 27GB of data as the Project deployment information file data repository
management system developed on MOSS 2007



Designed, built, tested and implemented the POC as a pilot project prio
r starting the
major rollout



SharePoint governance was exercised in order to manage risk, cost and adoption of the
SharePoint Intranet Site in terms of establishing a communications plan, change
management process, branding of the site, infrastructure c
hanges that includes setting
up firewall rules for IBM users, taxonomy, education and training

1



Worked closely with IBM contact in order to solve the connection problems related to
outside vendors (CAL)



Exposed data from BTR Master Database on the BTR

SharePoint Intranet Site and
automated update of the Excel spreadsheet Dash board and reporting over the SP
Portal



Designed and implemented workflows using SharePoint Designer and MS InfoPath to
automate the process related to the uploading rollout re
lated data to the SharePoint
Intranet Site



Presented to the Senior Management, and conducted the

Lunch and Learn


series on
the SharePoint Intranet Site features that greatly enhanced the entire execution of the
project

Sep. 2003


Oct. 2007

Senior Web/SharePoint Solution Architect,
T&S Finance Application Support, Bank of
Montreal
-

SCC, Toronto

Project
-

WSS File Management System (Project manager)



Architected, designed and was project manager for a tree structured SharePoint 2003
team si
tes for the T&O Finance Operations division and PF&A Shared Services
Department that revolutionized the business process by enabling personnel to work
collaboratively on projects with routing approval while ensuring sensitive data are
protected by utilizin
g different levels of access based on a tree data structure model



Interacted closely with Senior Management to setup development, QA, licensing issues
and to perform the POC as a pilot project before the final production implementation of
the entire pr
oject



SharePoint governance was exercised in order to manage cost and adoption of the
SharePoint portal by ensuring that the branding of the SharePoint site is in place as well
as change management process, cost allocation, education and training as wel
l as
taxonomy



System supports Web Content Management for 30 finance departments with individual
sites

Migrating IIS ASP applications to SharePoint Server and ASP.NET (TEAM LEAD)



Served as the PM and Technical lead (N&S) in migrating several web site
s from N&S
web server /IIS /ASP to MS SharePoint Portal Server environment ensuring that they
retain database
-
driven web application functionality within a new environment

T&O IDP Central Repository & T&O Signing Limits (Authorization Matrix) Repository



Defined application architecture, designed taxonomy and
built T&O IDP Central Repository using WSS (Windows
SharePoint Services 2.0) as a means to track and share
approved T&S Funds Requests and T&S Technical
Concurrence approvals including supporting
do
cumentation and analysis as well as exercised
SharePoint governance ensuring that the branding of the
SharePoint site is in place as well as change
management process, cost allocation, sponsorship and
taxonomy views using metadata

2



Repository solved the

problem of having multiple versions
of the same IDP document in MS Excel by providing the
T&S Finance team with a mechanism to upload, share,
filter and query approved T&S Funds Requests over the
BMO Intranet using one master version on the
SharePoint por
tal

Flash Sheet in .NET (TEAM LEAD)



Performed a complete analysis and feasibility study for re
-
architecture and
reimplementation of the Flash Sheet Excel based DSS system as well as the Flash
Administration website replacing the PHP proxy with ASP.NET.

This update accelerated
the execution and the MS SQL Server database update



Managed Decision Support System using several Hyperion Essbase cubes to assist
Senior Management

Project

GENESIS Web Tracking System (Project manager/TEAM LEAD)



Performed business and systems analysis, planned, architected, performed data
modeling, created Data Flow Diagrams, Solution Architecture and Logical documents,
activity diagrams and use cases, designed and built n
-
tier data
-
driven web
-
based
database manag
ement system (ASP.NET) used for tracking the approval process of a
RFA for items greater as well as less than the threshold of 1M as well as the
administration of MS SQL Server database. System allowed for better data integrity over
the existing MS Excel s
olution, security and 24/7 access with user

s authority level
driven dynamically built user interface



Designed and built in search engine with support for sorting, paging, filtering, and two
way data binding, editing, deleting and populating SQL Server
database while providing
reports with export to XLS/PDF.

Project


Web Enabled Client Care Service & Billing Change Management (TEAM LEAD)



Architected and led development of two data
-
driven web
-
based trouble
-
ticket systems
using ASP and MS SQL Server fo
r recording and tracking billing problems and billing
queries and requests for resolution or an explanation about the billing problem that
solved the problem of addressing billing issues on time and ITIL compliant Billing
Change Management system used to m
anage what changes have been made to the
Billing Modules & Systems before issuing a new Client Bill with built
-
in ASP
-
based with
master/details structure search engine and authenticated login



Performed business and systems analysis, designed, built a
nd implemented an ASP
web application



Enabled tracking capabilities and routing approval, and an automatic e
-
mail feature was
added.



Database design included ERD, logical and physical design of the Billing Problem
Management database



Presented to

the Senior Management, billing analysts, and trained users

May 2000


Sep. 2003


Senior Database Application Software Developer,
Billing & Costing Department, Bank of
Montreal

Project
-

Web Enabled Forward Billing and Planning System Database (TEAM LEAD)



Architected and served as the PM in the development, deployment and implementation
of a data
-
driven web
-
based n
-
tier ASP application that enabled established clients to
1

access the FBPS (DB2 on AIX) reporting capabilities via web over the FBPS Report/Fil
e
Server as well as to feed the DB2 database over the Web on a monthly basis with
secure sign in process with encrypted logic



Presented to the senior management, billing analysts, and trained users



The benefits gained after this n
-
tier data
-
driven ASP web application has been deployed
were immense. The business process has been completely changed, significantly
higher accessibility, better performance, DB2 client as well as MS Access front end
have b
een removed from clients computers

Project


BOD_905 View Utility and variance analysis database application



Designed, developed, tested and implemented several stand
-
alone database
applications using MS Access in order to drill down the BOD (Bank's Or
ganizational
Database
-

mainframe) by specified Cost Center; to investigate relationship between
projects numbers, applications and costs associated with the cost centers using 905
table (a DB2 mainframe database) as well as to perform Variance Analysis on

two
selected sets of client charges to a given cost center with enabled export to an Excel or
Snapshot format with browsing capabilities.

Apr. 1999


May. 2000


Database Application Developer,
Financial control and Invoice Processing, Bank of Montreal

Pr
oject


Centralized Voice Service Data Processing


Centrex Billing for 1000+
branches



Defined the architecture, designed, developed, tested and implemented the Voice
Services Bill database application with a complex Voice Services Bill in order to
cent
ralize the Billing system for the N&S Voice Network Services for above the line
charges for more than 1000 branches, reporting and analysis, cost behavior, data
processing and generating the largest General Ledger on a monthly basis using VBA,
Class Module
s, API, MS Access, MS SQL Server, Excel and advanced SQL techniques

Sep. 1998
-

Jan. 1999


Programmer Analyst,
Bank of Nova Scotia, Toronto



Converted main VB3 client/server application CAU to VB6 using Data Report Designer,
TrueDB Grid, Informix
-
On
line Dynamic Server, ODBC, DAO, ADO, SQL, OOP
Concepts, ActiveX controls

Oct. 1992
-

Oct. 1996

Assistant Programmer and Physicist

Faculty of Applied Technology
-

Yugoslavia

May 1987
-

Apr. 1992


Software System Engineer for Application Software Developme
nt

Remote Control Systems
-

Energoinvest, Sarajevo, Yugoslavia



Designed real
-
time process control software for feedback regulation used for City
Central Heating System and City Water Supply Dispatching System using Pascal and
Assembler

on PDP
-
11 and operating system RSX11M



Implemented critical portions of the PC SCADA software system in C


SKILLS

SQL, ASP, ASP.NET, C#, VB.NET, Visual Basic, VBScript, VBA, PHP, T
-
SQL,
PL/SQL, Pascal,

DB2 UDB on AIX, MS SQL Server
2005/2008 (DTS, SSIS, Reporting Services
and SP), Informix
-
Online Dynamic Server 7.1, MS Access, MySQL, Oracle, IIS,
2

Windows SharePoint Services 2.0 & 3.0, SharePoint Server 2003/2007/2010,
ODBC/OLEDB, Linux, Apache, Unified Process, TOGAF, SOA, ERP,OOA/OO
D,
ITIL, Web Services, Erwin, UML, XML, CSS, HTTP, SMTP, SOAP, CDONTS/
CDOSYS

Dreamweaver MX/2004/8, MS Visio, MS Project, MS VS 2008/2010, MS Office
2007/2010, Adobe Photoshop, MS Project, MS InfoPath 2007/2010, Internet/Web
architecture, Web Services, MS

SharePoint Designer 2007/2010, phpMyAdmin,
AvePoint DocAve/Migrator, OpenText, Quest Software, Term Store Management
Tool, Snagit, MockFlow


COURSES:

Building Data
-
Driven SharePoint Applications using SharePoint Designer 2007

Systems Analysis and Design

D
atabase Systems Design and Data Modeling

Enterprise Web Development with .NET

Project Management

Mastering WEB Application Development Using Visual Inter Dev 6 and ASP

Visual Basic Development for SQL Server 7 / Visual Basic & COM+ for
Enterprise Applications

Advanced Database Concepts Using Oracle 8 and PL/SQL / Oracle Developer
2000