SUMMARY:

• 18+ years of technology transformation solutions architecture and business systems analysis experience.
• Specializes on users related research activities, robust design documentation at the various stages of design, conducting business analysis and user’s discovery sessions; identifying business needs, opportunities and outcomes and developing users requirements with qualitative and quantitative options analysis of business applications, digital tools, users websites/mobile applications; providing detailed project cost - benefit analysis and implementation recommendations.
• 10+ years’ experience with solutions delivery making clients design recommendations with large infrastructure improvements, Big Data and heterogeneous applications integrations, Private, Hybrid and Public Clouds, security and IAM, risk identification, analysis and development of mitigation strategies; procurement planning and option.
• In this capacity she has assisted financial domain clients such as Confidential, Confidential, RBC, Confidential, Fidelity, MFXChange Holdings Inc. Confidential and OPS clients such as Confidential, Justice Technology Solutions, MOE, MTO, Confidential, Confidential, Confidential to uphold clients and users information management best practices, policies and procedures using RUP and Agile methodology in a large, distributed, cross platform environment.
• Effectively communicates complex development concepts to both technical and non-technical individuals, and comfortably interacts with executives, business professionals, and project end users and sponsors.
• Proposes and presents findings and recommendations to users/clients, EARB and BEC.
• Has deep skills and experience encompassing all facets of system development life cycle. Experience with structured methodologies: RUP, waterfall and iterative.
• Completed PMP in 2004 and ITIL in 2010. Completed TOGAF in 2011.
• Has proven experience of documenting personas, wireframes, prototypes, scenarios, task flows, story boarding for large OPS projects using Zachman framework. Led multiple research activities, analyzed and evaluated findings, and provided recommendations for projects where costs are 1M to 20M.
• Developed use cases, storyboards, flowcharts/processflows, and functional specifications for City of Toronto (Fire Services) Confidential (Advanced Power Network), Rexall and Loblaws (ERP, CRM and DW), Confidential (Power Network, CRM), Confidential (Data Strategy), Confidential (CRM and Analytical Source of Truth), Confidential (CRM and Data Liberation), Confidential (CRM and Management Reporting), MTO, Confidential (Information Delivery Platform), Confidential (Capital Markets), Confidential .

TECHNICAL SKILLS:

System and Cloud: Solaris, HP-UX, AIX, Linux; Windows; NetWare, DOS, AS/400, OS390; Intelligent Storage Arrays, Private and Public Cloud, PaaS, IaaS, SaaS, Citrix XenApp, Citrix SSO, VMware, Pivotal, MS Azure, AWS.

DBMS Software: Oracle 7 - 12g; Oracle DB Exadata, RAC, Streams, Data Guard; IBM DB2 UDB, IMS DB/DC; MS SQL Server ; MS ACCESS, IBM Netezza, Teradata, GreenPlum 4.x, SAP HANA, MS Azure DW, Showflake, Sybase 11x-15x, MySQL, MongoDB, PostgreSQL, Couchbase, Redis, Cassandra.

Cloud DB: AWS RDS (Oracle, Postgres, MySQL),Arora, DynamoDB, Cassandra, RedShift, Showflake, Oracle Exadata.

Data Management: Object-oriented and Relational design, 3 - rd NF, Star schema, Econometrics, OLAP, ROLAP, MOLAP, HOLAP; Big Data, noSQL data (JSON, Avro, XML, Parquet), Master Data Management, Data Quality, Data Lakes, Data Mining and Analytical tools, Internet of Things, Enterprise Content Management, Data Acquisition, Profiling, Metadata, Data Cleansing, Partitioning, ETL-Extract Transform Load, KPI-Key Performance Indicators, Scorecards.

CI and CD: continues integration and development: Elastic Architecture approaches and Microservices, Amazon Web Services (AWS) and EC2 container services, Elastic BeanStalk, Lambda, Spring Boot, Hibernate, Angular

Enterprise Architectural Framework and Technology Governance: SOA, Enterprise Service Bus and Zachman framework, TOGAF, FEA, Gartner. Project Development: RUP/UML, IT Gating, JAD, RAD, Agile, Waterfall.

Security: Harmonized Threat and Risk Assessment (HTRA) methodology, Statement of Sensitivity (SOS), TRA reports, COBIT-3, 4, 5, Information Security Management System(ISMS) and ISO27001, PCI Level 1 regulations, SSL encryption, Personal Data Protection Act (PIPEDA), IAM - Identity Access Management, Personal Health Information Protection Act (PHIPA), Privacy Information Act (PIA), Identity and Access management, Data Cryptography, DMZs.

Asynchronous and Synchronous replication: Data and Application s integration framework; Interoperability tests, Storage solutions, Disaster-recovery solutions, Performance benchmarking tests.

ETL Tools: Cognos 6-10x, SAS, SAP BO, WebMethods, MS SQL SSIS, Informatica 5-9x, DataStage 6-8x, Ab-Initio.

Record Management: OpenText, MS SharePoint, Interwoven, FileNet, Livelink, Vignette, Nuance PaperPort.

Tools: and Languages: ArchiMate, ESRI GIS, WildFly, ApacheTom EE, WebLogic, MS Office Pro, SharePoint, UML, AllFusion Erwin, Rational Software Architect, Enterprise Architect, Sybase Power Designer; Informatica 5-9x, DataStage 6-8x, Siebel Tools, Power BI, SQL, SSIS/SSRS, Cognos 6-10x; Vignette, Brio Query Reports; Actuate e.Report, SAP BO, Crystal reports, WebFocus, MicroStrategy, WebLogic; WebSphere, MQ, MS IIS, 9iAS, OFA R9i-11i, Oracle eBusiness Suite, FileNet, PeopleSoft, Unica, SAS; Mercury, CISCO, Unix Shell, Cobol, PL/SQL, T-SQL, ASP/.NET, C+/C++, C Sharp, VB, HTML-5x, XML, Java, J2EE, EJB, JRuby, JS, PHP, Ceylon, Scala, Jenkins, Maven, MS Build, Splunk, Chef and Terraform.

PROFESSIONAL EXPERIENCE:

Confidential

Sr SA

Responsibilities:

• Led business requirements gathering sessions; elicited and documented information from diverse business area stakeholders and subject matter experts. This project related to divisions of the City of Toronto and dealt with customized service delivery applications. The objective was to integrate the data collected by the fire and licensing departments and maintained by customized components of CAD (Computer-Aided Dispatch of Hexagon), RMS (Incident Record Management of Zolldata), Fire prevention software and Pre-planning forms, and to develop a new Billing system for Inspections. The task at hand was to develop a single set applications delivery solution near real time.
• Led solution development by capturing and analyzing existing users’ interfaces/applications, business processes, software components, data store, existing issues with data quality, multi-formats of data including images, and data integration. Assisted in the creation of business glossaries (data dictionaries)
• Developed templates and methodologies to ensure data integration and data reporting requirements are accurately and completely captured and can be effectively communicated to other data stakeholders.
• Developed current and future data architecture, including road map for solution delivery. Developed Data Models where required.
• Ensured the proposed technical solution effectively meet the business and technical need by presenting outcomes to the City of Toronto Business Stakeholders and Architecture Review board.
• Collaborated with the operations, development, QA groups to develop methods to test data components
• Evaluated existing and proposed data models and how to best access and query them.
• Evaluated existing and proposed data interfaces and how to clearly document them, including specification of data flow models, data flow timing, source-to-target mapping, and data transformation rules including data validations and controls
• Preserved current and evolving business knowledge domains to accurately assess the quality of the data. Provided solutions for document/image repository. Provided guidance to project teams via peer reviews.
• Lead development/approvals of test strategies and test plans. Lead preparation of test cases, test scripts and execution in all test phases.

Environment: SOA, Microsoft Azure, Cloud Elastic Architecture, Hybrid Cloud framework, PIPEDA, FIPPA, PHIPA, SSL encryption, SSO, IAM - Identity Access Management, ASP/.NET, C#, WCF, WPF, ETL, SAS Analytics, SAP SQL Data Warehousing with HANA, Opensource web services integration, MS SQL Server, SSIS, MS Reporting Server, MS Power BI, Business Objects, ESRI ArcGIS Pro and Enterprise, SharePoint, SSE CSOM, SSL, SFTP, J2EE, JSP, Java Script, XML, XSD, CSS, T-SQL, MS Office, Sybase Power Designer 16x, RUP, UML, BPMN-2.0, SQL.

Confidential

Sr. SA

Responsibilities:

• Led business requirements gathering sessions; elicited and documented information from diverse business area stakeholders and subject matter experts. Led design and development of an integrated data and performance measurement system for child and youth mental health. The new solution would perform data quality aggregation functions and would provide dashboards and ad hoc reporting capabilities for performance indicator monitoring.
• Documented current state of user’s systems and data architecture. Documented future state environment. Documented strategy and roadmap for solution delivery.
• Led and supported project government gating for Architecture by leading/obtaining business sign-off on the architecture artefacts / report specifications as required. Updated (and developed where required) information architecture artefacts (specified in the OPS architecture review checkpoint checklist) in compliance with OPS guidelines and standards and within the scope of the CYMH projects including support for business architecture deliverables as required.
• Managed Business Intelligence requirements including updates to Business Function model, Business Process Model and Business Use Cases.
• Architected, developed and maintained data models (business domain, process and data dictionary) for BI/DW with ETL knowledge including reporting. Provided solutions for document/image repository.
• Standardized architecture solution for hybrid cloud implementation framework using OPS I&IT Gates/ EAC 0-4 approvals. Worked with hosting service to coordinate/install/configure and administrate MS Azure and Cognos BI software. Worked with development infrastructure environment support of OPS ITS Public Cloud - Soft-layer development cloud infrastructure (Amazon) for MS Azure/Cognos development of BI project components.
• Developed, negotiated and presented deliverables (Interface Data Requirements, Logical/Physical Architecture, Supplementary Specifications, Application Inventory, Physical Deployment model, Quality Level Metrix, SOS, TRA, PIA reports) for review and sign-off by project executives and staff prior to moving to the project's next phase. Completed relevant Information Security-related work (such as conducting meetings/interviews) assigned by the relevant project staff.
• Lead development/approvals of test strategies and test plans. Lead preparation of test cases, test scripts and execution in all test phases.

Environment: Zachman, Cloud Elastic Architecture, Hybrid Cloud framework, Amazon Web Services (AWS), EC2 container, Elastic BeanStalk, Lambda container, Opensource web services integration, COBIT-5, PIPEDA, FIPPA, PHIPA, SSL encryption, SSO, IAM - Identity Access Management, ASP/.NET, C#, WCF, WPF, ETL, Cognos 10.x,11, SAS Analytics, SQL Server, SSIS, MS Azure DW, SharePoint, SSE CSOM, SSL, SFTP, J2EE, JSP, Java Script, XML, XSD, CSS, T-SQL, MS Office, Sybase Power Designer 16x, RUP, UML, BPMN-2.0, SQL.

Confidential

Sr. SA

Responsibilities:

• Led business requirements gathering sessions; elicited and documented information from diverse business area stakeholders and subject matter experts. Provided leadership in analysis, design and development of a scalable platform for remote control and visualization of Advanced Power Network to Confidential stakeholders. It was in consolidating customized components into a single platform, while maintaining their compatibility with each other and partner’s systems. The solution involved integration with asset data management systems of Confidential: Smart Meter Data collected by customized components of operational systems; IEE- Meter Reading and events; GIS- Network Topology; ORMS- Outages; DMS - Current Network Connectivity, NMS - Transmission Network Events; IRTT - AMI Reliability, CYME Dist - Distribution network planning and analysis; BI/BW - ECC Asset History, OMS - Meter consumption data. The customized components were linked with each other and to partner’s systems: SAP PM - Planned Work, Environment Canada, MPAC.
• Documented current state of users systems and data architecture. Documented future state environment. Documented strategy and roadmap for solution delivery.
• Developed options and prepare options analysis using both a quantitative and qualitative approach.
• Conducted business modeling; use case modeling; conceptual/logical data modeling; process/data flow modeling; business rules and non-functional requirements definitions for assigned projects.
• Reviewed and recommended logical architecture changes identified. Performed analysis via data flow diagrams, creative charts, and process specifications.
• Monitored progress, resolved problems and reported regularly to management and clients’ decision makers.
• Assisted with test planning and execution. Prepared, documented, and supported test cases execution. Assisted with defect review logging, monitoring and resolution. Provided solutions for document/image repository.
• Developed performance measures for evaluation, conducted follow-up and information gathering procedures. Facilitated JAD sessions, interviews, working groups and requirement gathering sessions with business and IT stakeholders to define and manage projects. Acted as a business liaison to facilitate communication between all relevant parties. Performed any other tasks as required in relation to business analysis and business architecture, and quality assurance associated with these projects.

Environment: TOGAF, CIM, SAP Business Objects, BODS (BO Data Services v 4.2), SAP Sybase IQ Database, Oracle 11 -12c, SharePoint, SSE CSOM, SSL, SFTP, J2EE, JSP, Crystal Reports, SQL Server 2012, SSIS, Java Script, XML, XSD, CSS, PL/SQL, MS Office, CRM, ESRI ArcGIS, RUP, UML, SQL.

Confidential

Sr. SA

Responsibilities:

• Led business requirements gathering sessions; elicited and documented information from diverse business area stakeholders and subject matter experts. Led number of work items for the retail transactions processing, and business reporting projects. These projects pertained to a large North American retailer and dealt with customized supply chain management software. The task at hand was to develop a single set data analytics solution near real time. It was in consolidating customized components of PMM, JDA Promo, Point of Sales (POS), RX, and AS400 BIDW into a single platform, with reporting and remote access ability.
• Analyzed and documented users/client requirements for solution delivery. The goals of the multi-integration targeted a unified data format, unifies hierarchies and transaction codes, the management of 500+ product items, the replacement of the COBOL code, and manual processes. Analyzed and documented business processes for in-house customized components, linked to systems: JDE, McKesson, Airmiles, Planogram, Signage, WIS
• Documented current state of systems and data architecture. Documented future state environment. Documented strategy and roadmap for solution delivery. Provided solutions for document/image repository.
• Developed Conceptual, Logical/Physical data models to consolidate the multi-source data using star schema.
• Developed ETL solution’s high and low level requirements and design specification replacing ineffective and inefficient processes of Informatica 9.1 with new Oracle ODI workflows. Each version of the ETL integration solution provided measurable performance improvements when applied to a large number of source records.
• Resolved business and technical issues with applications prior to establishing a reporting solution. Resolved and addressed data quality issues and concerns. Resolved issues with unexpected behavior of unified sets when consolidating transactions with inventory and promotions; security and availability at the front-end; issues with performance, scheduled jobs, workflows, issues with distributed transactions; and issues with business rules orchestration at the integration layer. Provided solutions for document management and document/image.
• Developed and delivered test cases and relevant materials for approvals by users, internal/external partners, and management. Provided technical coaching using data virtualization technique, data reporting, BI and analytical deliverables.

Environment: TOGAF, AS400, IMS DB/DC, COBOL, Win, VMware, SAN, Oracle 11 -12c, ODI, SQL Server 2012, SSIS, C#, ASP/.NET, WCF, WPF, SharePoint, SSE CSOM, SSL, SFTP, J2EE, JSP, Java Script, XML, XSD, CSS, PL/SQL, Informatica 9.1, JDA, GreenPlum 4.1, Opensource web services integration, MS Visio, MicroStrategy 9.4.1, DMZs, AODA, FIPPA, Access, Excel, SAS, CRM, RUP, UML, SQL

Confidential

Sr. SA

Responsibilities:

• Led business requirements gathering sessions; elicited and documented information from diverse business area stakeholders and subject matter experts. Led design and development of asset data management solution to support service oriented architecture and multi-systems integrations for renewable energy modernization projects; equipment and distribution modernizations. The Distribution Modernization program is an Asset Management initiative that improves reliability and productivity for the smart and renewable energy equipment received in 2015: Smart Meters, Solar, Wind, BIO/CHP/Landfill Generators.
• The task at hand was to integrate smart meters/generators into a distribution network, which was currently discrete. Other tasks were to develop a new platform for seamless transmission to customer connected model for integrated distribution/network operations, to collocate with other spatial data (landbase/real estate, imagery, etc.) and to provide the foundation for which to iterate subsequent requirements for alarm monitoring, remote control, and switch plan creation with built-in load transfer study as well as others. It was in consolidating customized components into a single platform, while maintaining their compatibility with each other and partner’s systems, that obstacles arose.
• Documented current state of user’s systems and data architecture. Documented future state user’s environment. Documented strategy and roadmap for solution delivery.
• Led re-development of architecture components, data processes to support modernizations and to leverage customized components of DMS (real-time network monitor and control, a key enabler of the operating model, especially support of Grid Modernization); SCADA (Remote control, Alarming, Trending, Tagging); NMS (the key tool that the Network Operating Division (NOD) uses to operate the Transmission System); FD GIS (Final Destination GIS provides data describing power network topology and equipment including Distribution Sub-stations, Feeders, Transformers, protection devices, and Meters), OMS (Meter Event and Consumption data), SAP (Asset Management System).
• Develop an integrated Tx/Dx Data Model, as well as facilitated integration with FD GIS (Network topology).
• Led development of data conversions from multi-formats like XML, Flat file in ASCII or EBCDIC format, SQL and Oracle database table extracts, Message format, Image, and Rationalized format into unified format.
• Provided solution’s guidelines, high and low level design specifications for data extracts and loads including performance measurements. Developed source to target mappings. Developed complex SQL queries for data issues discovery and resolutions. Provided solution’s guidelines and fixes for defects in data relationship within outdated and unsupported by vendor datasets. Provided solution’s guidelines and fixes for Dashboard reporting applications. Provided solutions for document/image repository.
• Developed and delivered test cases, other materials for approvals by users, internal/external partners, and management. Provided technical coaching using data virtualization technique, data reporting, BI and analytical deliverables.

Environment: TOGAF, ABB, SBB, SOA, Linux, Citrix XenApp, SSO, NetScaler, Win, VMware, SAN, MS AD, Lync, SharePoint, WebSphere 8x, CA Spectrum, CEM, Introscope, Cloud Monitor, Opensource web services integration, Oracle Fusion, Oracle 10 -11g, SQL Server 2010 and Win 2008 Clusters, SSIS, ASP/.NET, C#, WCF, WPF, SSE CSOM, SSL, SFTP, J2EE, JSP, Java Script, XML, XSD, FSDM/FSLDM, XSLT, XSL-FO, CSS, PL/SQL, MS Visio, MicroStrategy, ESRI ArcGIS, SAP Business Objects, DMZs, AODA, FIPPA, Erwin 7x, Lotus Notes, MS Access, Crystal Reports, SAS, CRM, RUP, UML.

Confidential

Sr. SA

Responsibilities:

• Led business requirements gathering sessions; elicited and documented information from diverse business area stakeholders and subject matter experts. Led analysis, design and development of Information Delivery Platform, IDP, and Netezza- Hadoop integrations solutions to support High Priority Transactions reporting, and Confidential Customer consolidated views. Developed IDP strategic goals, policies and procedures. Led analysis and design of Netezza BI infrastructure high and low level design specifications, integrated, analytical and reporting data models. Identified and defined of how and where authoritative data can be sourced. Led the design and development of BI reports as well as outlier detection, regression and predictive analysis. The resulted advancement was a unified representation of all the customer banking data from previous incompatible systems.
• Led analysis of data conversions from multi-formats like XML, Flat file in ASCII or EBCDIC format, database table extracts, COBOL, Json, Message format, Image, and Rationalized format into Netezza unified format. Analyzed and proposed multiple integrations solutions, data analytics extracts, and BI architecture implementations for internal/external employees, delivery partners, project stakeholders and sponsors.
• Provided solutions for outdated Fidelity Information System (FIS) and its unsupported applications like the Touch Point Teller (TPT) system. Provided fixed for unexpected behavior of TPT components, defects in data relationship, inadequate information, and unexpected behavior of Daily Cash and Cash Monetary Purchase Transaction extracts.
• Developed and delivered test cases, other materials for approvals by users, internal/external partners, and management. Provided solutions for document/image repository. Provided technical coaching.

Environment: SOA, ITIL, TOGAF, Linux, Netezza, Hadoop, CISCO, Private and Hybrid Cloud IaaS, SaaS, PaaS, CheckPoint, Win XP, VMware, SAN, Sun Solaris, IMS DB2, Oracle 10 -11g, WebLogic 11g, SQL Server 2008 and Win 2008 Clusters, SSIS and SSRS, SFTP, XML, XSD, FSDM/FSLDM, PL/SQL, MS Visio, JIRA, Rational Software Architect, MicroStrategy, Business Objects, DMZs, AODA, FIPPA, Lotus Notes, MS Access, Datastage, SAS 9x, CRM, RUP, UML.

Confidential

Sr. SA

Responsibilities:

• Led business requirements gathering sessions; elicited and documented information from diverse business area stakeholders and subject matter experts. Analyzed Business and Technical Challenges under Confidential, Justice Technology Cluster. Identified business and technical needs. Developed Business Case with detailed project costs, gap analysis and expected risks. Defined project scope, key objectives and deliverables. Researched possible solutions within standard technology practice. Identified Enterprise Architecture Approach, and Security Assessment strategy. Analyzed and proposed multiple options for data collection, web services integrations and BI reporting solutions developing Use Cases, PRD, Data and Process Flow, Activity diagrams, UI-interfaces, Test Cases and other detail specifications using functions and workflows. Developed conceptual and logical data models. Analyzed and documented security policies and procedures, PIA and TRA documents. Developed project, test and risk plans, and schedules. Developed and delivered materials for approvals by EARB and BEC.
• Documented current state of user’s systems and data architecture. Documented future state user’s environment. Documented strategy and roadmap for solution delivery. Provided solutions for document/image repository.
• Identified needs by eliciting and documenting information from diverse area stakeholders and subject matter experts of Toronto South Detention Centre, Confidential of Community Safety and Correctional Services, OTIS system, and TSDC facility. Developed Business Case, cost-benefit analysis, and feasibility study. Proposed optimal and alternative solutions resulted in data integration and delivery to Confidential and its partners. Developed PRD, conceptual, logical models, XML, ETL and reports detailed specifications. Developed and delivered materials for approvals by EARB and BEC. Provided technical coaching and support for technology upgrades as required.
• Collected business requirements for Youth Justice Services to support collection and presentation of key performance metrics to analyze youth and special programs involvement, while in custody. Analyzed and proposed multiple options for data collection, and BI analytical reporting. Developed Project Needs, Business Case, Costs Estimates, Fit-Gap Analysis, Risks, and Risks Mitigation plan, Preliminary Privacy Analysis, Security Assortment, Architectural Diagrams with data and process flows, conceptual, logical and physical models as required. Developed related project plans, and schedules

Environment: Zachman, CISCO, CheckPoint, Win XP, VMware, Linux RedHat, SAN, Sun Solaris, Oracle 10 -11g, ODI, SQL Server 2008 and Win 2008 Clusters, SSIS, C Sharp, .NET Framework, ASP, WCF, WPF, MS Active Directory, MS Dynamics, SharePoint, SSE CSOM, SSL, SFTP, J2EE, JSP, SAS 9x, Java Script, Ajax, Spring Framework, HTML5, CSS, Cognos 10.2, XML, PL/SQL, MS Visio, Erwin 7x, Sybase Power Designer 16x, DMZs, AODA, FIPPA, MS Access, RUP, UML, Oracle Siebel CRM, IBM CRM.

Confidential

Sr. SA

Responsibilities:

• Led business requirements gathering sessions; elicited and documented information from diverse business area stakeholders and subject matter experts. Analyzed Business and Technical Challenges under Integrated medical records processing system. Developed Business Case, Cost-Benefit Analysis, Fit-Gap analysis, Preliminary Privacy and Security analysis of data, possible risks and mitigations. Developed IT strategic plan for integration of Medical data collected from Long Term Care facilities; Continuing Care, Home Care, and Home Care Residential and Mental Care services. Developed possible and optimal solutions to achieve the best result. Developed and delivered materials for approvals by EARB and BEC. Negotiated project approvals, and sign-off.
• Documented current state of user’s systems and data architecture. Documented future state user’s environment. Documented strategy and roadmap for solution delivery.
• Developed Use Cases, Test Cases, PRD, DFD, and integrated Logical Data model. Established ETL IT policies and procedures for analytical data framework. Evaluated and assessed technological and business risks of proposed solutions. Developed ETL detailed mappings by converting SAS code into Informatica and PL/SQL functions. Supported technology upgrades, resolved fixes and issues.
• Developed and executed work plans test plans, iterations and IT environments. Built roadmap and timetable to deliver quick fixes and longer-term solutions for integrated reporting system. Provided solutions for document/image repository. Analysis of Performance experiments and findings.

Environment: Zachman, CISCO, CheckPoint, Juniper, Win XP, VMware, Linux RedHat, SAN, Sun Solaris, Oracle 9x -11g, OC4J, ODI, WLC 10x, Web Sphere, SQL Server, SSIS, Cognos 10.2, Erwin 7x, PL/SQL, MS Visio, SAS 9x, Microstartegy 9x, XML, J2EE, JSP, Java Script, Ajax, Spring Framework, Opensource web services integration, MS SharePoint, CSS, HTML5, ERStudio Enterprise Architect 8.5, Sybase Power Designer 15x, Ab-Initio 3x, AODA, FIPPA, MS Access, RUP, UML.

Confidential

Sr. SA

Responsibilities:

• Led business requirements gathering sessions; elicited and documented information from diverse business area stakeholders and subject matter experts. Analyzed Business and Technical Challenges under Data Liberation Initiatives resulted in short and long term Business and Systems Requirements for a solution to leverage Lottery applications integration. Developed Business Case. Researched possible solutions across COTS vendors and within standard technology practice.
• Documented current state of systems and data architecture. Documented future state environment. Documented strategy and roadmap for solution delivery.
• Documented users’ findings and requirements for current and future DART, Data Retrieval and Technology environment, provided alternative solutions and structures that is in line with the Confidential SDLC standards.
• Led business requirements sessions in order to collect data for Lottery analytics. Developed PRDs, functional and non-functional business requirements, Use Cases, Data and Process flows, Logical and Physical (where possible) data models addressing short term and long-term requirements. Developed ETL detailed specifications, Test Cases. Trained project members and users.
• Built roadmap and timetable to deliver quick fixes and longer-term Lottery solutions to make current environment more usable by users. Provided solutions for document/image repository. Supported technology upgrades.

Environment: TOGAF, CISCO, VMS/OS390, AS400, IMS DB/DC, COBOL, C/C+, PL/1, Win 2008 Clusters, MSA70, MSA2000fc, AIX 5.3, Sybase 15.0.2, IBM DB2 8.2, Datastage 7.5, SQL Server 2008, SSIS, Cognos Impromptu 7.4, Cognos 8-10x, Sybase Power Designer 15, Informatica 8x-9x, J2EE, JSP, Java Script, Ajax, Spring Framework, XML, .NET, C Batch, C#, HTML, Web Methods- AG, Opensource web services integration, SAS 9x, ERStudio Enterprise Architect 8.5, Crystal Reports, MS Office Pro, PeopleSoft 8.2, DMZs, RUP, UML, MS Dynamics, SharePoint, IBM CRM

Confidential

Sr. SA

Responsibilities:

• Led business requirements gathering sessions; elicited and documented information from diverse business area stakeholders and subject matter experts. The task at hand was to develop an advanced scalable Automated Meter Management platform that offers new data collection, automates meter and energy data management, and delivers new smart grid functionalities to provide an active network management. The solution involved asset data management systems of Confidential .
• Documented current state of user’s systems and data architecture. Documented future state user’s environment. Documented strategy and roadmap for solution delivery.
• Led analysis of information for senior management in order to identify the integration solution options for Operational Service Bus (iHUB) constructed from Distributed Generation and Electrical Vehicles systems as well as the Outage Response Management System (ORMS). In addition to that the solution targeted changes in dispatching and customer management processes and required the integration of customer’s data (CIS system), meter readings and OFF/ON events (IEE system), and lastly network reliability (IRTT system) with geographic information system, ESRI ArcGIS.
• Developed integrated logical/physical model based on customization of CIM, Common Information Model.
• Developed ETL code specifications, source to target data mappings, test scripts and test plans. Developed complex SQL queries for data issues discovery and resolutions.
• Provided solutions for document/image repository. Developed web reporting interfaces specifications, key performance metrics, a variety of relevant, visually appealing, intuitive and interactive graphs, maps and visuals using traceability matrix to functional requirements.
• Delivered test cases and materials for approvals by end users, internal/external partners and stakeholders. Provided technical coaching to team members on design patterns, development processes, and other IT processes in order to improve their technical skills.

Environment: Zachman, CISCO, VMS, WIN 2008n Clusters, Access 2003, Win XP, Linux RedHat, Sun Storage, Solaris, Oracle 9x -11g, SAP Business Objects, BODS (BO Data Services), ASM, Teradata, SQL Server, SSIS, PL/SQL, MS Visio, Apache, XML, J2EE, JSP, Java Script, Ajax, Spring Framework, NET, C#, ASP, HTML5, CSS, DMZs, Erwin 7x, Enterprise Architect, MS Dynamics, SAP, MS SharePoint, BlueCielo Meridian, Autodesk CAD applications, ESRI ArcGIS, Smart Meter AMI/AMR, CDM.

Confidential

Sr. SA

Responsibilities:

• Led business requirements gathering sessions; elicited and documented information from diverse business area stakeholders and subject matter experts related to Loblaw’s Manhattan, SAP, CRM applications. As a result the systems serve client requirements.
• Documented current state of business, systems and data architecture. Documented future state environment. Documented strategy and roadmap for solution delivery.
• Identified business needs, opportunities and outcomes and conducted qualitative and quantitative options analysis; detailed project cost-benefit analysis and provided implementation recommendations. Developed Business Cases, Cost-Benefit Analysis, Fit-Gap analysis, Preliminary Privacy and Security analysis of data, possible risks and mitigations. Developed Business data artifacts including Logical Architecture, Data Models, ETL Data Mappings, Work Plans, TRAs, Activity Diagrams, Gap Analysis, Use Cases, Test Cases, Test Scenarios, and Test Data Loads, Deployment Strategy.
• Active 'hands-on' participation in project. Managed development of custom configurations and deployment processes including BI reports. Managed and maintain data relationship between production and reporting database by solving technical issues that arise in data transfer and database maintenance. Managed Team Relationships. Provided performance feedback and coaching to project and program team members.
• Co-ordinated Technology and Business Groups, reviewed deliverables, actively participated in technology upgrades, provide approvals and recommendations, educated business users on project deliverables, technology solutions and recommendations.

Environment: TOGAF, CISCO, MS Project, AS400, IMS DB/DC, COBOL, IBM AIX P690, Oracle 10.2.4, 11i, ODI, OFA R11i, RAC, ASM, Data Guard 10g, Oracle Streams, Teradata, Sybase Power Designer 12x, PL/SQL, Win Server 2003, SSIS, MS Visio, MS IIS, Web Sphere 6-7x, Apache, Cognos 8x, UNIX Shell, Linux RedHat, Ab-Initio, XML, J2EE, .NET, ASP, HTML, Java Script, Ajax, Spring Framework, SAS, Opensource web services integration, C#, Mercury Load Runner v8, Erwin 7x, SQL Server, DMZs, RUP, UML, EA Sparx, MS Dynamics, SharePoint., Crystal Reports, Enterprise Architect, PeopleSoft 8.2, Siebel CRM.

Confidential

Lead SA

Responsibilities:

• Led requirements gathering, solution assessment and development of Drinking Water system to satisfy checkpoint review process including Business Case, Use Cases, functional and non-functional requirements, hardware and software specifications, logical, physical application architecture and deployment models, database and application integrations solutions, ETL mapping’s, Test Cases, d architecture, fit/gap analysis, risk mitigation, Disaster-Recovery solutions. Developed project plans, team work plans, materials for approvals by EARB, BEC.
• Documented current state of systems and data architecture. Documented future state environment. Documented strategy and roadmap for solution delivery.
• Developed and maintained processes for ensuring security and privacy of application’s data that comply with MOE and corporate security model for Canada.
• Developed and maintained processes for ensuring security and privacy of application’s data that comply with MOE and corporate security model for Canada.
• Performed experimentation, validation and uncertainly analysis with integrated datasets models and web based application for data collection. Walked-trough the COBOL code and develop ETL specifications for mainframe data loads, migration into new platform.
• Provided solutions for document/image repository. Developed portal solutions with WSRP standards, web interfaces design specifications, integration solutions for Java reporting application and Cognos.
• Developed detailed steps for deployment. Assisted in post-implementation efforts to enhance performance, data quality and integrity. Provided technical coaching.

Environment: Zachman, CISCO, VMS/OS390, AS400, IMD DB/DC, COBOL, PL/1, Sun Storage, Linux RedHat, Apache, Enterprise Architect, IMS DB2, Solaris 8,Win 2003 and XP, Oracle 9x-10g, ODI, AODA, FIPPA, Informatica 8x, PL/SQL, Cognos 7, 8, Sybase Power Designer 12x, SQL Server, Erwin 4x, DMZs, WebSphere, Opensource web services integration, XML, J2EE, Java Script, Ajax, Spring Framework, JSP, .NET, C#, ASP, MS Visio, RUP, UML, Environet, CIS, GIS, EAM, EDRMS, SharePoint.

Confidential

Senior SA

Responsibilities:

• Led business requirements gathering sessions; elicited and documented information from diverse business area stakeholders and subject matter experts. Developed and directed the Business Architecture goals, objectives, policies, and procedures for Road User Safety (RUS) solutions.
• Documented current state of systems and data architecture. Documented future state environment. Documented strategy and roadmap for solution delivery.
• Led proof of concept RUD solution development. Led development of solutions artefacts to satisfy checkpoint review process. Some of the architecture artefacts include: business case, possible solutions studies, system functional and non-functional requirements, use cases, CIAM, business and architecture, fit/gap analysis, logical and physical model, deployment models, GRUD matrix, quality level metrics, UI-interfaces, data security design, data governance policies, Informatica ETL mapping specifications, test cases, conversion estimates, work and risk plans. Provided project plans and developed team work plans.
• Developed new approach for Change Control processes designed to support on-going enhancements, and to manage the impact of changes resulting from data models conflict resolutions. Provided solutions for document/image repository. Developed portal solutions with WSRP standards.
• Coordinated with business users, applications and technology groups to ensure accurate and effective workflow, UAT, operating procedures under MTO standards.
• Developed and delivered materials for approvals by EARB and BEC.

Environment: Zachman, CISCO, VMS, Citrix, AS400, IMS DB/DC, OS390, COBOL, PL/1, C/C+/C++, Solaris, Oracle 9x,10g, RAC, ODI, EA Sparx, Informatica 7x-8x, Sybase Power Designer 9x, Unix Shell, Linux, SQL Server, Cognos 7-8x, Oracle 9iDeveloper, Apache, DMZs, SharePoint, Erwin 4x, FIPPA, MS Visio, J2EE, JSP, .NET, ASP, C#, XML, HTML, MS Dynamics, Project, Oracle Siebel CRM, IBM CRM, GIS, CIS, EAM, EDRMS, RUP, UML.

Confidential

Senior SA

Responsibilities:

• Led requirements gathering, business case development, analysis and development of integration solutions, COTS custom configurations and deployment models following best practice of Confidential Enterprise Architecture, which supports business functions worldwide. Performed experimentation, validation, and uncertainties analysis with data grid, middleware applications, Content Management, and integrated data.
• Documented current state of systems and data architecture. Documented future state environment. Documented strategy and roadmap for solution delivery.
• Planed business and technical communications. Researched possible solutions using COTS products to satisfy business requirements. Provided solutions for document/image repository. Provided project plans and developed team work plans.
• Developed functional and non-functional requirements, use cases, test cases, Grud matrix, quality level metrics, fit/gap analysis, interfaces and security design, data migration strategy, work and risk plans, Disaster-Recovery plan. Develop and delivered presentations. Negotiated and received project approvals.
• Monitored, directed, and perform day-to-day operations of the assigned program to ensure that policies and procedures are being followed, that goals and objectives are met, and that services are being accomplished efficiently and effectively. Resolved and/or escalate issues. As a result data issues and discrepancies where eliminated.

Environment: TOGAF, CISCO, VMS, Citrix, AS400, IMD DB/DC, OS390, COBOL, PL/1, C+, Sun Solaris 8,Windows, Oracle 9.0.2, OFA R9i, ODI, Data Guard, RAC, SQL Server, Sybase, Sybase Power Designer 9x, Informatica 6x, Sybase GQL Report, Cognos Power Paly 6, PL/SQL, J2EE, XML, JSP, .NET, Opensource web services integration, ASP, SAS, Erwin 4x, HTML, Unix Shell, Linux RedHat, MS Office Pro, Visio, EA Sparx, DMZs, RUP, UML, Crystal Reports, Enterprise Architect, MS Dynamics, SharePoint.

Confidential

Lead SA

Responsibilities:

• Led requirements gathering, business case development, analysis and development of Confidential Business Architecture principles, standards, policies, procedures, which supports business functions in North America. Developed solutions for transactions integration.
• Documented current state of systems and data architecture. Documented future state environment. Documented strategy and roadmap for solution delivery.
• Developed processes aligning Harris and Confidential bank business models, and overall IT architectural framework, maximizing data utilization, minimizing costs, and ensuring data integrity using SOA and TOGAF framework.
• Planned business and technical communications, integrate processes. Developed business functional and non-functional requirements, Use Cases, Test Cases, PRDs, Process and Data Flows, work and test plans. Researched and analysed possible COTS solutions. Provided solutions for document/image repository.
• Resolved problems with data quality for methodologies used for Bank VAR, Monte Carlo methods, Counterparty credit exposure, risk monitoring, P&L, stress and sensitivity reporting. As a result discrepancies were eliminated.
• Provided technical coaching to team members on design patterns, development processes, and other IT processes in order to improve their technical skills.

Environment: TOGAF, CISCO, MVS/OS390, AS400, IMS DB/DC, COBOL, C/C+, C++, MS Office Pro, MS Visio, VMS, Citrix, IBM AIX P690, DB2UDB 7x-8x, AllFusion Erwin 4.x, DB2 Stored Procedures, SAS, ESP scheduler, MicroStrategy Reports, Web Focus, J2EE, XML, JSP, .NET, ASP, Opensource web services integration, HTML, UNIX Shell, Sybase Power Designer 9x, Ab-Initio, SQL Server, Informatica 7, OFA R9i, Trillium, EA Sparx, DMZs, Enterprise Architect, SQL, Access, ODBC, Linux, RUP, UML, MS Dynamics, SharePoint.

Confidential

Senior SA

Responsibilities:

• Performed requirements gathering, business case development, analysis and solutions assessment for Confidential applications and business data integrations following Confidential Application Architecture standards, policies and guidelines. Researched and analyzed possible COTS solutions. Proposed optimal and alternative solutions. Developed and delivered presentations.
• Documented current state of systems and data architecture. Documented future state environment. Documented strategy and roadmap for solution delivery.
• Developed business and architecture for integrated framework including architecture governance, applications and data integrations strategies, and security, expendability and backup solutions. Developed solution’s artefacts including datasets models. Provided solutions for document/image repository. Provided project plans and developed team work plans.
• Planned technical communications and integrate processes. Resolved problems with data quality for methodologies used for Bank VAR, Counterparty credit exposure, risk monitoring, Monte Carlo methods, P&L, stress and sensitivity reporting. As a result discrepancies were eliminated.
• Lead development/approvals of test strategies and test plans. Lead preparation of test cases, test scripts and execution in all test phases.
• Provided technical coaching to team members on design patterns, development processes, and other IT processes in order to improve their technical skills

Environment: TOGAF, CISCO, MVS/OS390, AS400, IMS DB/DC, COBOL, C+, PL/1, MS Project, MS Visio, Sun Solaris 8, Oracle 9.0.2, ODI, OFA R9i, PL/SQL, Unix Shell, Linux RedHat, Informatica 5.1, 9iAS, J2EE, XML, JSP, ASP, .NET, HTML, Opensource web services integration, Cognos PowerPlay 6, Oracle Reports and Workflow, Erwin 4x, SAS, SQL Server, Siebel 7, Sybase Power Designer 9x, Sybase GQL Reports, EA Sparx, DMZs, RUP, UML, Crystal Reports, MS Dynamics, SharePoint.

Confidential

Senior SA

Responsibilities:

• Performed requirements gathering, business case development, analysis and solutions assessment. Designed and implemented technical and non-technical solutions for business and technical problems or issues that arise to improve business efficiencies and effectiveness following modernizations of Application Architecture framework. Developed solution’s artefacts. Developed and delivered materials for approvals by management.
• Documented current state of systems and data architecture. Documented future state environment. Documented strategy and roadmap for solution delivery.
• Performed experimentation, validation and uncertainties analysis with integration of applications and data to provide optimal solutions that meet client’s needs. Provided solutions for document/image repository. Provided project plans and developed team work plans.
• Analysis of experiments and findings for datasets models, data processing and data collections. Performance benchmarking tests.

Environment: Zachman, CISCO, MVS, OS390, IBM AS400, IMS DB/DC, COBOL, PL/1, C/C+/C++, Oracle 9i, ODI, OFA R9i, Oracle 8.1.7, SAS, SQL Server, Erwin3.5, AIX 4.3, J2EE, XML, ASP, .NET, HTML, Web Sphere, Informatica 5.1, 6.0, Cognos 6x, FoxPro, EA Sparx, DB2 UDB 7.1 and 8.2, Enterprise Architect, Crystal Reports, Sybase Power Designer 9x, IMS, MS Project, Visio, Linux RedHat, DMZs, RUP, UML, MS Dynamics, SharePoint.

Confidential

Lead SA

Responsibilities:

• Led analysis of business and technical challenges within Enterprise Model, which supports multimillion insurance businesses in North America. Developed Business Case, Cost-Benefit Analysis, Fit-Gap analysis, Preliminary Privacy and Security analysis of data, possible risks and mitigations.
• Documented current state of systems and data architecture. Documented future state environment. Documented strategy and roadmap for solution delivery.
• Improved information processing and information management functions by replacing 10-year old Access application with Informatica 5x and Oracle Financials functionalities. Developed solution’s artefacts.
• Performed user’s demonstrations and obtained business approvals for new solution. This resulted in reduction of operational cost from 6 employees to 1 employee. Provided project plans and developed team work plans.
• Successfully transitioned five production applications from US office in Dallas to Toronto. Extract data via Informatica 5.1 and 6.0 servers from IMS and DB2 database on IBM mainframe to Oracle 8.1.7 data warehouse on Solaris (1,2 terabytes), flat files extracts and submissions loads to PeopleSoft financials module.

Environment: TOGAF, CISCO, AS400, OS390, IMS DB/DC, COBOL, PL/1, C/C+, Linux RedHat, Oracle 8.1.7, 9.0.2, ODI, Sun Solaris 2.6, 8, Sun StorEdge 6900, Informatica 5.1, 6.0, SQL Server, Teradata, People Soft, SAP, OFA R9i, PeopleSoft, Oracle 9iAs, RAC, Actuate e.Report Designer Pro, Sybase Power Designer 9x, SAS, Oracle Discoverer, J2EE, XML, ASP, .NET, HTML, Erwin 4.0, MS Project, Visio, DMZs, EA Sparx, RUP, UML, SharePoint.

Confidential

Senior SA

Responsibilities:

• Performed requirements gathering, business case development, analysis and solutions assessment. Designed and implemented technical and non-technical solutions for worldwide business to improve efficiency and effectiveness following modernization of technology and Application Architecture governance framework.
• Documented current state of systems and data architecture. Researched and analyzed possible solutions. Developed strategy and road map for solution delivery. Performed eexperimentation, validation, and uncertainties analysis for data collections applications, integrated datasets models and reporting applications. Analyzed and developed data migration strategy and detailed steps of solution’s deployment: Analyzed COBOL code and developed detailed ETL specifications for mainframe data to be migrated into new platform.
• Provided solutions for document/image repository. Developed portal solutions using middleware technology and clusters.
• Developed project artefacts, test cases, plans and team work plans. Performed presentations to business users and project sponsors. Negotiated and obtained approvals for project deliverables.

Environment: TOGAF, CISCO, VMS/OS390, AS400, IMS DB/DC, COBOL, PL/1, C/C+/C++, Oracle 8i, 9i, ODI, Sun Solaris, WIN 2000, IBM DB2 UDB, Sun StorEdge 6120, SQL Server, Teradata, IBM Web Sphere, Java Server Pages, J2EE, ETL, XML, ASP, .NET, HTML, eXelon BPM, Erwin 3x, Crystal Reports, Sybase Power Designer 9x, SAS, Cognos Power Play 6.6, Apache, Linux RedHat, EA Sparx, MS Visio, DMZs, RUP, UML, SharePoint.

Confidential

Senior SA

Responsibilities:

• Performed requirements gathering, business case development, analysis and solutions assessment. Developed functional and non-functional requirements, business architecture, use cases, PRD for COTS custom configurations for IBM Net Commerce application to target sales requirements of 400M$/annually. Negotiated projects approvals. This resulted in quick adoption of reporting application.
• Documented current state of systems and data architecture. Developed possible solutions for data integrations. Developed strategy and road map for solution delivery. Performed multiple tests and promoted the optimal solution into production environment. Developed new approach for ETL processes and data quality check.
• Provided project artefacts, test plans, project plans, test plans and team work plans. Developed effective project support documentation for a new product release by doing analysis.

Environment: TOGAF, CISCO, VMS, Oracle 8x, Solaris 2.7, Data Guard, ODI, Sun StorEdge A5200, Veritas Volume Manager, Erwin 3x, PL/SQL, Unix Shell, Linux, Win/NT, Dynamo, Netscape 3x, J2EE, JSP, ASP, .NET, HTML, MS Visio, EA Sparx, RUP, UML, DMZs, XML, SharePoint

Confidential

Senior SA

Responsibilities:

• Led requirements gathering, business case development, analysis and solutions assessment. Provided business systems consulting services to Confidential with recommendations for possible solutions related to Timeline application re-development. Defined current and future data, analytics and reporting needs. Documented future state environment. Documented strategy and roadmap for solution delivery. Developed schedules for solution delivery. The resulted advancement was a migration from client-server environment to 3/n tier web platform using Oracle technology: Oracle Forms 6x and Reports 6x with Oracle database 8x. Developed web interfaces, logical and physical data models, test cases and test scripts, performed application performance testing.
• Developed data migration strategy, and assisted with data migration from legacy systems into Oracle.
• Performed project artefacts development, as required for Checkpoints 1-4, and for approvals by EARB and BEC Provided technical coaching.

Environment: TOGAF, SOA, AS/400, IMS DB/DC, Cobol, PL/1, C/C+/C++, CISCO, Oracle 8i, ODI, Win NT/2000, MS MTS, MS SQL Server 7, VB 6.0, .NET, ADO, IIS, OLTP, Erwin 3x, Crystal reports, MS Visio, REST, J2EE, XML, WSDL, JSP, ASP, .NET, HTML, SAS, RUP, UML, DMZs, WebLogic, SharePoint.