Omar Pricca Email & Phone Number

Calgary, Alberta, Canada

Calgary, Canada Area

Facilitated requirements gathering sessions with business and IT users to create project documentation for current/ future state assessments, process flows, system interface integration, and system architecture diagrams. Created SQL extraction processes to provide reconciliation and reporting data to vendors for financial reimbursement. Key team member in the IT involvement of the CCA initiative to change our product wholesaler including interface data mapping, testing, and system integration activities. Implemented the CWSB Liquor division Perpetual Inventory and warehouse management solutions (NCR Purchasing and DAX/DDR). Implemented the Blue Yonder Store Operations and perishable Markdown label solution, such that product shrink can be captured and analyzed for all store/heirarchy levels. Designed and worked with developers on the of integration of ASN data into the CWSB Perpetual inventory system, reducing store labor and error rates. Created alert monitoring scripts to proactively report system issues that would normally impact business operations if left unattended. Created system and support documentation for various applications. Provided Tier III support for CCA Retail Systems applications and processes.

Calgary, Canada Area

Work with business users to provide operational and analytical reporting by:o Gathering detailed business requirements for the creation of report design documentation.o Identifying source systems and creating the required SQL for data extraction and prototype creation.o Collaborate with 3rd party IT service provider to ensure proper interpretation of the report design document into a UAT ready state.o Assist business users in report validation for production deployment. Work with auditors, external analytics providers, and our IT service provider in the identification, extraction, and validation of required data.Create the SQL scripting to support marketing and regional sales analytics.Create documentation and process forms to address new reporting/extract requests, provide time estimates, and capture design specifications. Conduct workshops to solicit business terminology for the creation of a common definition glossary and data dictionary.Work with the Master Data department to capture and document a prototype governance structure that reflects the current state ownership/stewardship model and the definition of various governance roles.Working knowledge of various application databases including JDA Portfolio Merchandise Management (PMM), Enterprise One (JDE), and Retek Point of Sale (POS).

Calgary, Canada Area

Worked with a team of Solution Architects to establish company standards and governance with regards to architecture.Created documentation to provide detailed solution and infrastructure blueprints for project initiatives.Assisted with the implementation of the JDA suite of products by:o Working with the application provider to identify required hardware configurations.o Identifying interface touch points from Legacy systems.o Facilitating sessions with business users and technical staff to understand current processes and issues.o Working closely with infrastructure support and interface development vendors.o Providing ‘hands on’ technical support as required.

Calgary, Canada Area

Created iSeries SQL stored procedures, functions, database indexes, and queries to address support and project initiatives.Created database refresh procedures for development and QA environments. Utilized the CA-ErWin software package to perform basic data modeling.

Calgary, Canada Area

Utilized the Visual Lansa 4GL programming language to create the Process Control and Payroll Time Sheet entry systems. Integrated the Lansa CE Direct Web Ordering system to the VersaPay Loyalty payment system.Performed break-fix work on the Lansa CE Direct Web Ordering system and worked with BDL customers on B2B setup/technical issues for POS initiated orders.Acted as the single point of contact for all Lansa administration an issues. Participated in the Change Management process of distributing RPG/Lansa programs and database file changes to Production (via Aldon LMi).

Calgary, Canada Area

Provided advanced technical support for the iSeries platform, JDE World v7.3c environment, and ongoing BDL operational requirements.Enhanced and maintained the iSeries Development, QA, and User Acceptance database environments.Performed iSeries system migrations and OS upgrades.Systematically captured iSeries performance data and correlated results to business volumes.Created the iSeries portion of the BDL Disaster Recovery plan.Supervised and trained staff for day-to-day activities. Identified and implemented processes for streamlining operations.

The first three years were focused on Network/Technical support and migrated to management.Assumed client role of ‘Manager, Help Desk and Operations’ for Mark’s Work Wearhouse Ltd.Initiated a ‘Help Desk Restructuring Plan’ in order to better utilize existing resources and improve customer service.Implemented a ‘Service Level Agreement’ methodology for monthly customer reporting.Managed 2nd / 3rd level analysts on various project and support activities.Provided technical services and 3rd level support to Help Desk staff. Areas of support included AS/400, Lotus Domino, network communications and personal computers.

Calgary

Initially hired as a Computer Operator and quickly became a Technical Analyst. Responsible for the supervision of operations staff covering the areas of voice and data communications help desk, personal computers and day-to-day AS/400 personnel. Worked closely with inter-company departments regarding the administration of computer expenditures (leases, communication costs, and divisional chargebacks).Specifically responsible for the performance, maintenance and capacity planning of the AS/400 environments.

Ba Certification, In Progress

Computer Engineering