Alex Shteinberg
Microsoft Specialist at Spark North East Link Tunnels D&C- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Native or bilingual proficiency
-
Russian Native or bilingual proficiency
Topline Score
Bio
Credentials
-
SharePoint Workflow Automation: Nintex
LinkedInJun, 2018- Nov, 2024 -
SharePoint 2016: No-Code Workflows
LinkedInJun, 2017- Nov, 2024 -
Learning Dynamics 365
LinkedInMar, 2017- Nov, 2024 -
Microsoft Dynamics CRM Essential Training
LinkedInMar, 2017- Nov, 2024 -
Up and Running with Power Pivot and SharePoint 2013
LinkedInMar, 2017- Nov, 2024 -
Office 365: Implement Identities for SSO
LinkedInDec, 2016- Nov, 2024 -
AngularJS 1: Building a Data-Driven App
LinkedInOct, 2016- Nov, 2024
Experience
-
Spark North East Link Tunnels D&C
-
Australia
-
Construction
-
100 - 200 Employee
-
Microsoft Specialist
-
May 2023 - Present
-
-
-
ConsultantVision Pty Ltd
-
Melbourne, Australia
-
Senior Technical Consultant
-
Mar 2013 - Present
-
-
-
White Sapphire
-
Australia
-
IT Services and IT Consulting
-
Senior Consultant
-
May 2016 - Present
-
-
-
Tools and Instrument Engineering (QLD)
-
Melbourne, Vic and Gold Coast QLD Australia
-
Senior Sharepoint Consultant (Remote development)
-
May 2013 - Present
-
-
-
Victorian Ombudsman
-
Australia
-
Government Administration
-
1 - 100 Employee
-
M365 Consultant
-
Mar 2023 - May 2023
-
-
-
Royal Australasian College of Surgeons
-
Australia
-
Education Management
-
300 - 400 Employee
-
M365 Consultant Specialist
-
Feb 2022 - Mar 2023
-
-
-
Victorian Department of Health
-
Government Administration
-
700 & Above Employee
-
Senior Sharepoint Consultant (Power Platfrom/Azure/DevOps/Security)
-
Nov 2021 - Feb 2022
-
-
-
Victoria Police
-
Australia
-
Law Enforcement
-
700 & Above Employee
-
Senior M365 Consultant
-
May 2021 - Oct 2021
Provide and develop key objective using the O365 Power Platform as part solution model and integration of various data stream. Working with different business units implementing various automated process for diverse range of business requirement. Building of dashboard reporting using Power Bi and development end to end Oracle financial payment verification payment using Power Platform tools, Developing PVA bots for Service Desk assistance as part of KB distribution. Provide and develop key objective using the O365 Power Platform as part solution model and integration of various data stream. Working with different business units implementing various automated process for diverse range of business requirement. Building of dashboard reporting using Power Bi and development end to end Oracle financial payment verification payment using Power Platform tools, Developing PVA bots for Service Desk assistance as part of KB distribution.
-
-
-
Adventure Consultancy Solutions (ACS)
-
Australia
-
Information Technology & Services
-
1 - 100 Employee
-
Sharepoint Consultant
-
Jan 2021 - May 2021
-
-
-
AustralianSuper
-
Australia
-
Financial Services
-
700 & Above Employee
-
Sharepoint Specialist
-
Jun 2019 - Sep 2020
-
-
-
Toyota Motor Corporation Australia
-
Australia
-
Motor Vehicle Manufacturing
-
700 & Above Employee
-
Senior Sharepoint Consultant (Cloud9 Consulting)
-
Aug 2018 - May 2019
Key tasks and roles: • Participated in TMCA ISD end user functional workshops. • Provided oversight of all TMCA Sharepoint BAU activities. Define and translated various process that would enhance the online experience. • Build the new EngineRoom based on MS best practise of using a “Flat Sharepoint site architecture” deploying team sites and define the navigation stream based on the organisation structure. • Identified divisional groups which were transition from their local share drives to the online platform (Sharegate migrations). Reviewed their operational requirements and provided educational streams as outlined in WSC deployment scope of the Office365 suite of tools, to enhance the End user experience. • Build and deploy site page templates for the Divisional Hubs using Shortpoint app (UI/UX) to provide management and target audience member of the proposed platform. • Build divisional security groups per Division Hub site. Using Sharegate reporting tools I was able identify site Owners and contributor members based on the current sharepoint access. • Based on workshop outcomes, certain groups have small BAU process and workflows in the current Classic site. I have generated transitional process to re-build this apps using PowerApps and Flow. • Designed and built a Power Bi dashboard for the WSC project team outlining the project’s performance and KPI. •Provide Sharepoint administration support to the TMCA Sharepoint administrator. I had Tenancy administration right for the production and development platforms. • Engaged with external vendors and outlined processes for the off-site development and define monitoring processes. Used Jira Agile tools to build Iteration of 4 sprints based defined stories (function specification). Managed stand ups, define UAT testing and provide Sprint deliverables with co-approval. • Defined UAT scripts for End user testing based on functional requirements. Show less
-
-
-
Dialog Information Technology
-
Australia
-
IT Services and IT Consulting
-
400 - 500 Employee
-
Technical Solutions Consultant (Office365/K2)
-
Jun 2017 - Jun 2018
As the lead consultant, I initiated the main solution design and platform. I was involved in all areas of project and its activities including Installation, deployment and configuration of Office365 /Sharepoint online/K2 Five AWS environments. Key tasks and roles: • Established the VGLM Office365 portal (Global Admin) for solution deployment. Identified and mapped user security using AD Azure and its configuration tools. • Created all the of VGLM Site collection for DEV/UAT/PROD. • Identified integration tools for the Sharepoint environment including: o K2 Five (Forms & workflow) Automation tools. o Power BI reporting app. o Sharepoint Sapient (Calendar integration tool) app. o ShortPoint UI/UX Branding app. Installed and configured all the above tools and apps. • Worked with a BA resource to define all the user requirements. • Participated in all user stories (user requirement) creation for project Sprints, Including role and actors. • Reviewed legacy content and data. Develop migration steps for existing transactional data using Sharegate app to migrate to Sharepoint list • Review End user security for internal and guest Sharepoint groups, and provide best practices for document access and management. • Developed and deployed the Sharepoint/K2 artefacts based on user stories for given sprints. • Implement VGLM branding for the Intranet sites using UI/UX Wireframe design with ShortPoint tool. • Migrated (Sharegate) VGLM TRIM documents (legacy) to the new Sharepoint document centre and configured all the archival and retention policies. • Primary K2 Five server administrator and participated in all environments (DEV/UAT/PROD) installation and configuration (DataComms AWS infrastructure). • Developed Power BI reporting artefacts for VGLM transaction data and UI dashboard deployed via ShortPoint tools based on Sharepoint user security. Show less
-
-
-
Trout Creative Thinking
-
Australia
-
Design Services
-
1 - 100 Employee
-
Senior Sharepoint Consultant
-
Mar 2017 - Jun 2017
In my role as a Sharepoint consultant, I am involved in various DECV Intranet project (DECV) tasks and platform configuration. My key task is to develop, configure, and implement Sharepoint best practice for transformation project: • Create and deploy the main site collections including My Sites. • Review legacy content and data. Develop migration steps for existing legacy. Most of the migration is going to be manual implemented on the site. • Review End user security using AD and Sharepoint groups, and provide best practise for Document Management. • Developed an automation process of policies document review. • Implement DECV branding for the Intranet site and my site, based on Trout Wireframe design. • Provided task estimates based the Requirement and IA documentation. • Provide consultative service to the DECV ICT group. Show less
-
-
-
RACV
-
Australia
-
Civic and Social Organizations
-
700 & Above Employee
-
Sharepoint Consultant
-
Jan 2017 - Mar 2017
In my role as a Sharepoint consultant/administrator, I am involved in various RACV Intranet replacement Project (SmartPlace) tasks. My key tasks is to develop, collaborate and provide the following: • Sharepoint application and collaboration solutions. • Review Office365 security, and provide best practise for Document management. • Develop Sharepoint collaboration, content and Governance workshop including presenting the content to RACV staff and management. • Development PMO site templates and general data process. • Review the use of global Exchange mailbox on Sharepoint sites as part of staff collaboration. • Participate in conversion review and develop mapping process for Lotus Notes application to Sharepoint. Show less
-
-
-
La Trobe University
-
Australia
-
Higher Education
-
700 & Above Employee
-
Senior Sharepoint Consultant
-
Nov 2016 - Dec 2016
In my role as a Sharepoint consultant, I am involved in enhancement project for Student Outbound Mobility Subject Approval System (SOMSAS). This an Agile project environment (JIRA) with various Sharepoint solutions developed, configured and deployed. The main development tools are JavaScript, SP Easyforms, SP Workflow and Nintex and SSRS integrated environment. My act ivies on this project: • Develop and defined reports using SSRS using Sharepoint list and SOMSAS content database. • Modified and enhance existing solutions and integrated SSRS reports into the application. • Developed technical documents for production deployment. Show less
-
-
-
Rail Projects Victoria
-
Australia
-
Government Administration
-
700 & Above Employee
-
Senior Sharepoint Consultant
-
Apr 2016 - Nov 2016
In my role a Senior Sharepoint consultant, I developed, configured and deployed an Office365 Sharepoint Intranet site with an Agile project stream with various 3rd party external groups to replace a legacy base Intranet (Matrix) • Supported and maintained METRO site branding using a BindTuning solution architecture (Bootstrap, AngularJS, JSON, HTML5, CSS, JQuery) • Implemented and deployed ShortPoint content authoring app. Provide end user training and support. Appointed Acting DEDJTR Office365 tenant administrator: Managed and administrate sharepoint site collections - As Sharpoint solution architect, I was involved in the department global SSO deployment as part of DEDJTR security governance requirements for single point login of new implemented solution. o Managed tenancy security protocols with department communication guidelines. o Provided tenancy usage guidelines for Azure and Office365 development tools. o Implemented Sharepoint Tenancy and Sharepoint reporting. Configured a multi-tier Sharepoint platform for production site change management deployment. Ensuring development governance standards and recording. o Developed End User security monitoring using Sharegate reporting of Sharepoint site collections and tenancy activities. Review the impacts of Office365 rights management tool as part of document management for site collection and via hybrid process in TRIM. - Provide consultative information to MMRA Senior management of the daily activities of the Tenancy. - Collaborated and advices various internal MMRA groups on the opportunities and benefits of Office365 platform. Show less
-
-
-
AusNet Services
-
Australia
-
Utilities
-
700 & Above Employee
-
Sharepoint Consultant
-
Apr 2015 - Apr 2016
In my role at ICT Commercial group (Procurement and Asset management), I provide the following system life cycle streams (analysis, design, develop and deployment) in the utilisation of the Office365 Sharepoint platform. The given solutions provide a centralised data repository, reporting and semi-automated process for the group BAU tasks. I introduced the Infowise app (3rd party software) for OOTB standard end user interaction for Alerts, form and workflow creation to minimise complexity. My Activities: • Site Collection configuration and administration. • Custom page development and deployment (CSOM/JQuery). • Design and developed InfoPath form solutions and incorporate Infowise workflow events in projects deployment for ICT Partner Hub and Portfolio Services groups. • Implement OOTB content and configuration for requested groups. • Developed BI/reporting solutions and output streams (PowerPivot, PowerView, Excel, Power BI) of group’s (ICT Partner Hub and Portfolio Services) KPI indicators. • Provide Office365/Sharepoint user support in relation to OOTB web part objects and pages creation, development of content type and implementation, and incorporate search web parts as a standard content deployment structure for cross-site interaction. • Migrated various legacy site objects and content via Sharegate tools. • Created interface files for FLEXERA and SAP systems. Show less
-
-
-
Mind Australia
-
Melbourne, Australia
-
Sharepoint Consultant/Solution architect
-
Mar 2015 - Apr 2015
Sharepoint 2013 portal implementation. - Install and configure Sharepoint 2013 Single node Farm. - Develop and implement OOTB master pages - Provide and assist with Sharepoint OOTB functionality - Review and provide guideline UI\UX for Sharepoint portal and subsite configuration. Sharepoint 2013 portal implementation. - Install and configure Sharepoint 2013 Single node Farm. - Develop and implement OOTB master pages - Provide and assist with Sharepoint OOTB functionality - Review and provide guideline UI\UX for Sharepoint portal and subsite configuration.
-
-
-
NEC Australia
-
Australia
-
IT Services and IT Consulting
-
700 & Above Employee
-
Sharepoint consultant/ BA
-
Sep 2014 - Dec 2014
In my role at Dept. Environment Primary Industries (DEPI), I was working on the FireWeb Upgrade project (Legacy ASP) which has being developed and transformed on Sharepoint 2013 enterprise farm encompassing ADFS protocols. The new FireWeb solution will implement a number of different functionalities ranging from Document management, Nintex form, IFrame and app development, branding and sociability capability. I was involved in the ECM document management business requirements collation and defining the migration process. • I defined requirements for FireWeb document migration process, metadata configuration and automation process. Identifying new processes and refining existing integration process with various FireWeb interfaces.• Created and configured the content type and term store for FireWeb Document metadata structure in the ECM development environment.• Created and configure document migration scripts for bulk file upload for non-match and matched metadata documentation. In addition, due to ECM platform constrains I built CSOM code for FireWeb bulk document upload, including mapping content type value and managed metadata.• Configure document library validation and retention rules. Included development of document Approval workflows (Nintex).• Assisted with the ECM end user security matrix configuration.In other related task:• I compile the project test strategy documentation (Agile – iterative methodology) . The defined sprints test scripts and functionality for ST, SIT, UAT and PVT phases. • Provide the technical development and consulting on various project task that encompass:• IFrame and page development (Webparts and apps)• Branding and UX configuration ( using JQuery,CSS5,HTML and VS2012)• Form and workflow development and configuration using Nintex 2013.• Migrated content and content databases between development and SIT environments. Configured portal sites to the managed metadata, content types and navigational requirements. Show less
-
-
Sharepoint Consultant/BA
-
Jul 2014 - Aug 2014
As a Sharepoint business analyst on the Toyota Intranet Portal replacement project. I reviewed theexisting intranet portal architecture, its content management and general functionality, including the current end-user experience and interface. In collating my document, I utilised various internal documentation including the Project brief document (defined by Toyota PMO) which outlined that current intranet portal has a limited end-user functionality and experience due to outdated technology (asp classic). This is a major contributing factor for loss of business productivity and the intranet portal limitation of providing end-user collaboration.The scope of the my deliverable is to present a High Level Business Requirement document which defines the business objectives and high level requirements for a new intranet portal as indicated by the key stakeholder.Key objective of my documentation:• Outlining objectives.• Defining high-level requirement.• Provide recommendation and outline functionality of the new portal (Sharepoint 2013).• Define the Governance requirements.• Developed Context diagram and Process maps “AS IS” and “TO BE”.• Define and review Gap analysis.• Provide high-level conceptual solution.I organised and run workshops with the key stakeholders. Interviewed nominated members of theProject. Collated and documented the required business objectives and requirements. Assisted other Sharepoint project with various scope definition for Document management migration and Implementation.Environment: Sharepoint 2013, Nintex workflows, ASP Show less
-
-
-
Newcrest Mining
-
Australia
-
Mining
-
700 & Above Employee
-
Sharepoint Consultant/BA
-
Apr 2014 - Jul 2014
In the role of Business analyst/Sharepoint developer, I reviewed the existing process, provided recommendation for the GNS Consolidation solution for the current Newcrest Sharepoint document management system (CDocS). Objective is to centralise the document numbering sequencing process in all of the major functioning groups within Newcrest for the CDocS system (document management). This solution is being implemented as part of Newcrest Sharepoint governance requirement and ongoing SLA support. In my current activities, I built a Sharepoint development environment for the proposed solution, migrated and built the required Term store and content type (Meta data) of the existing solution. I configured the existing document libraries and it’s workflows to reflect the production process. There are 2 different CDocS solutions being utilised by Newcrest, the corporate function area uses an automated GNS process but broken by section. The mining sites use a provision GNS numbering process within a manual process. The GNS consolidation model will automate the sequence numbering generation of the document number only, Newcrest functioning area specific document management process is not part of the scope. I redesigned and configured defined SQL objects and modified 2 customised workflow solutions (Visual studio 2010 C#/Sharepoint Designer) as part current scope. Configured various document libraries Content Type definitions (Meta data) and adjusted various term store data to reflect the new GNS requirement. I am developing the UAT testing and implementation requirement into production including the regression testing procedures based Newcrest project management methodologies. Dues to length of the project system testing will not be required. Env: Net Framework 3.5/4.0, C#, Visual Studio 2010/12, 2010, Sharepoint 2010, Sharepoint Designer, Nintex workflows, JQuery/Html/CSS,SQL Server 2008R2. Show less
-
-
-
Lion
-
Australia
-
Food and Beverage Services
-
700 & Above Employee
-
Senior Technical Analyst/Sharepoint Consultant
-
Dec 2013 - Apr 2014
In my role as Senior Technical Analyst/Sharepoint Consultant my key tasks is to provide a Lion D & D Group with a Sharepoint solution for the newly proposed Commercial Activation Self Service portal (CASSP) which will serve as supporting application for the Pricing and Rebate teams. The portal will consolidates data and provide key analysis and reporting solutions which will encompass as strategically tool. I initiated meetings and collated key information, discussed the various processes to automate, develop and deploy the proposed CASSP portal without the need to engage Lion IT development and deployment guideline. The solution is built with utilising Sharepoint 2010 OOB functionality and tools (Infopath, Sharepoint designer) with K2 workflow. I developed the CASSP portal is using a blank site collection with current group security. Designed and customise an Infopath (VSTA C#) form with multiple views to encompass all of the business data and its functionality. I incorporated the Lion’s branding requirement for the site collection look and feel. I created portal navigational buttons and utilising CSS and HTML to customise various behaviours of menus and certain navigational tools without modify the master page. I developed various pages with autocomplete fields to enhance the search of specific list, using JQuery/CAML scripts. All reporting tools are built using Excel 2010 using query connection to CASSP sharepoint lists/libraries/Web services. There 4 defined reports which will be deployed as part of monitoring and BI requirements for management. K2 workflow processes developed and deployed to update processed data and SAP external data update. In addition, I am converting an existing Excel Pricing tool (macro) to Infopath. The new form will be the new tool for the Pricing and Rebate teams, with form data to interact with SAP directly. Env: .Net Framework 4.0, C#, Visual Studio 2010/12,Sharepoint 2010, Sharepoint Designer, SAP Financials, K2,JQuery,CSS Show less
-
-
-
AusNet Services
-
Australia
-
Utilities
-
700 & Above Employee
-
Senior Technical Consultant
-
Aug 2013 - Dec 2013
I am currently involved on Project Server/Sharepoint 2007 migration to Project Server/Sharepoint 2010, using UMT OOB workflows solution, building customised functionality and content relating to reporting data and Project server processes. I am developing customised reporting (Financial and Project management) using SSRS 2008R2/2012 BI tools, various reporting solution incorporation Excel Pivot reporting using Sharepoint web part configuration for report deployment. As part of project Sharepoint platform administrator role, I participated in an installation process, and configuration of the SSRS integrated mode on EPPM UAT Sharepoint farm. Provided the user security requirements, installed customised and OOB web part solutions and activated the prescribed features as per project scope. Configure the Crawl search service and configure the general PDP content template. I am currently involved in configuration and migration of the UAT EPPM content to the production Sharepoint 2010 farm, including the web part solution and reporting objects (Excel/SSRS reports) deployment. I have been involved in the customisation of the UMT workflow web part field updates solution. Configuring and developing a WCF service to update posted actions from the UMT workflow tasks to the DeliveryHub database. Provide assisting with the Oracle financial data migration objectives using SSIS 2012 ETL tools to migrate complex data models as part of financial data integration requirement on the Project server 2010 platform. I perform various other duties include custom software troubleshooting and general Sharepoint servers node performance review. Environment: SQL 2008R2/2012, SSIS, SSRS, Net Framework 4.0, C#, Visual Studio 2010/12, Project Server 2010,Sharepoint 2010, Sharepoint Designer, Oracle Financials, UMT workflows Show less
-
-
-
GE
-
Richmond, Victoria AU
-
Senior Consultant - eLearning
-
Jul 2013 - Jul 2013
I developed eLearning module using Adobe Captivate for GE Capital group for training internal staff on the new Credit card program available via online using there retail partner. The interactive training modules were developed for the GE NZ group, using storybook requirements and guidance from the NZ Marketing co-ordinator. All modules were published for IE8 and Chrome web browser. Each module consisted of 30 slides, configuring interactive usage and standard timing on slide movement. All graphics were pre-select and developed in house. All recordings were used on test web application of the NZ retail client Noel Leeming Show less
-
-
-
ITRegister
-
Australia
-
IT System Custom Software Development
-
1 - 100 Employee
-
Sharpoint Consultant
-
Dec 2012 - Dec 2012
Sharepoint Consultant - Sharepoint 2010 - Branding, Master Page and CSS development - Site Page Customisation (Web part config) Sharepoint Consultant - Sharepoint 2010 - Branding, Master Page and CSS development - Site Page Customisation (Web part config)
-
-
-
ANZ
-
Australia
-
Banking
-
700 & Above Employee
-
Technical Consultant/Test Manager
-
Jul 2012 - Dec 2012
The following outlines my activities key roles at ANZ. Each required a dynamic transition on my part to adapt to requirements and deployment timeframe of each project. In the Technical Consultant role: I provided analysis, developed BP documentation and outline a proposed solution fort the WallStreet-Midanz reconciliation application (MSAccess) for migration to ANZ mainstream application platform using SQL server application tools (SSIS and SSRS). Conducted business and technical analysis of the existing GFX-Midanz application (MSAccess). Identified key data transformation process and business process. Documented strategies for future initiatives for product reconciliation with the Market Operation group. I developed store procedures and tested .Net code for the Peloton MITD upgrade. Provided technical analysis and provide assistance with Control-M task and trouble shooting in both production and test. In the Test Manager role: I started my duties during Cycle 3 of SIT/System Test. I manage, co-ordinate and document any issues with the Testing strategy that was defined by the MOSA project team as per ANZ PMO guidelines. Co-ordinate daily test meeting with the project testers and management. Compiled daily statistical and defect management reports of prior day testing activities (HPQC data). Provided MOSA senior management updates on the variation of testing issues and general tracking of key testing tasks. Managed testing resources (3 Melbourne test), outlined testes strategy activities with the MOSA BA lead, and uploaded defined testing scripts into HPQC. Co-ordinated and facilitated the UAT testing lab for the project. Documented and compiled testing cycle (Cycle and UAT) utcomes based ANZ PMO requirement. - TSR and CAM Provide technical analysis and resolution for Xceptor and Thunderhead issues during various testing phases. Facilitated and co-ordinated the MOSA Network Capacity and Penetration and Volume groups testing requirements. Show less
-
-
-
DEECD
-
Melbourne, Australia
-
Senior Technical Consultant
-
Apr 2012 - Jun 2012
In this role, I was involved in various BA tasks, technical development and project work that required me to provide defined solutions called the Ultranet Foundation Data Refresh Process (UFDRP) (managed Staging and Test environment process) for the Ultranet Foundation system (web base application). The majority of tasks involved in gathering and consolidating DEECD distributed data, reconfiguring system architecture (VMware test environment) and defining technical task. The outlined work required an automated approach using existing technologies (SQL, SSIS, SSRS, and PowerShell) as the working platform for the defined solution process. In the role: I developed process maps for the data flow of various source data streams (multiple SQL server versions). Reviewed the existing testing platform and provide recommendation of optimisation of various throughputs. Developed SSIS data transformation tools to process various datasource and in conjunction of developing of an Obfuscation tools (SQLCLR) for production data masking process. Develop PowerShell script for managing ADLDS accounts (Student accounts) within the ISIT2 environment Developed a SSRS interface tool to run the SSIS UF Refresh process and reporting tools to monitor the process My other duties included; to provide senior management with technical overview of the existing test system (VSphere ISIT2), analysis of the environment infrastructure and impact on the proposed process. Environment: SQL 2005/08/08R2, SQL 2005/08 SSIS, SQL 2005/08 SSRS, Net Framework 3.5 & 4.0, SQL CLR, VMware VSphere 5.0, Visual Studio 2005/2008, PowerShell 2.0 Show less
-
-
-
Australian Unity
-
Australia
-
Wellness and Fitness Services
-
700 & Above Employee
-
Senior Technical consultant
-
Aug 2011 - Apr 2012
In this role, I was involved in various BA tasks, technical development and project work that required me to provide technological solutions to the AUI Investment group. The majority of tasks involved the consolidation of distributed data which required an automated approach using existing technologies (Sharepoint, SQL, SSIS, SSRS, Excel VBA and in house system) as solution for AUI Fund reporting and daily/monthly reconciliation processes. In the role: (PFA Project) I developed an automated reconciliation engine as a solution to provide a time saving process to reconcile the IBM-SUN Financial system GL data against Cougar Property Fund system. Using ETL methodologies of extracting and setting up a central database repository. Developed an Excel macro solution to match datasets and calculation variation. This solution has provided a cost effective approach with minimal impact of group resources. I worked on the electronic invoice distribution process, utilising the Sharepoint 2010 Workflow tools (Sharepoint Designer/InfoPath). The outline task was to develop an automated process where scan property invoices get processed and allocated to specific AUI group’s base on the guidelines of the Workflow and stored in Sharepoint for archive purposes. My other duties included; to provide senior management with technical overview of existing systems, analysis of proposed solutions and infrastructure impact on various in house systems (pControl, TM1, Cougar, and OneVue) in their ability to meet the AUI group’s technological requirement for existing or future objectives. Environment: SQL 2005/08/08R2, SQL 2005/08 SSIS, SQL 2005/08 SSRS, Net Framework 3.5 & 4.0, Hyper-V, Visual Studio 2005/2008, Sharepoint 2010, Sharepoint Designer 2010, Sharepoint InfoPath 2010, IBM-SUN Vision, Cougar, TMI1 (COGNOS) Show less
-
-
-
Philip Morris International
-
Switzerland
-
Tobacco Manufacturing
-
700 & Above Employee
-
Senior Technical consultant
-
Feb 2010 - Jun 2011
I provided technical support and development to the current internal PMIS web base application including SRS (legacy) and TechPortal (legacy) reporting tools. In line PMIS ITIL process, all development or requested task are required SD4/SNOW SR system request with outline of the request, timeframe and approval for the user(s). These processes manage the co-ordination of various teams which are involved in the UAT testing and production deployment. As part of ongoing application review various tools were placed for an upgrade to meet the current PMID technological and platform standard. The TechPortal reporting system which was built on .Net 1.0 platform was commission to be upgrade to the current .Net standards of 3.5 and above. Base on my recommendation and available resources the product is being upgrade to SSRS 2005/08 reporting tool. Using SSIS data transformation tools to connect to various internal system dataset. Majority of the data processing from various affiliate FNP servers are using Powershell 2.0 and Control-M scheduling tools. In my role: I manage, co-ordinate all change control requirement using the SNOW ITIL system as part PMIS IT management. I develop and manage all aspect of the TechPortal reporting legacy system including the development and production infrastructure. I am responsible for development and deployment phase of the TechPortal upgrade. This includes SSRS report development, data transformation and performance improvement (SSAS,SSIS & store procedure, VBA scripting), and Asp.Net application. Provide ongoing support to existing legacy and current in-house applications. Manage the SD4/SNOW Support queue of user request Environment: SQL 2005, SSAS,SSRS & SSIS, Net Framework 3.5 & 4.0, Visual Studio 2005/08, ASP.Net 3.5, IIS 6 & 7.5, VB.Net, C# and ASP Legacy, Powershell, Control-M Show less
-
-
-
Callpoint Spatial Pty Ltd
-
Australia
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Senior System Consultant
-
Jan 2010 - Jun 2010
- Visual Studio 2008/10 & .Net 3.5/4.0 Development of Geocoder solution - Infrastructure deployement, configuration and management; Hyper-V, SQL2008 R2, Win2008/R2 IIS6.0 & IIS 7.7 - Data Analyst ; development of GNAF data flow procesess using SSIS - Visual Studio 2008/10 & .Net 3.5/4.0 Development of Geocoder solution - Infrastructure deployement, configuration and management; Hyper-V, SQL2008 R2, Win2008/R2 IIS6.0 & IIS 7.7 - Data Analyst ; development of GNAF data flow procesess using SSIS
-
-
-
-
Senior Developer
-
2007 - 2009
-
-
Education
-
RMIT
Associate's degree, Applied Science Information Technology