· Worked comprehensively on building the universe architecture and development of complex reports. The reports tracked core information on oversight activities and outcomes and uncovered important trends in regulatory compliance initiating well timed right actions; · Demonstrated proficiency in business analysis, dimensional modelling, data warehouse, reporting, developing queries to access data, and extensive knowledge of SAP Business Objects BI tools. The senior business analyst defined my project work as: “…The work you created was great... I was pleased to test your reports with the expectation of no errors or minor errors only”; · Analyzed business requirements, functional specifications, and report mock-ups. Partnered with Business Intelligence and Database/ETL development teams to review data models and understand data sources. Met with clients to get overviews of the applications, went over the content of the reports being developed and modified; · Identified universe scope for ad-hoc querying, analysis and reports. Following the Transport Canada BO development best practices, designed/updated universe Data Foundation and Business Layers in English and French languages. Using IDT tool, created dimensions, measures, filters (prompts), lists of values (LOVs), parameters, and scripts to support the special prompt requirements; · Developed English and French versions of reports - planned the layout of report contents, generated and tested the reports. Used SAP Crystal Reports for Enterprise, SAP BusinessObjects Web Intelligence Rich Client, BI LaunchPad, and SAP Crystal Reports 2016 tools. Created necessary testing and command SQL scripts; · Reviewed/fixed Web Intelligence dashboards and Web Intelligence reports. Performed necessary input controls, variables, merged dimensions, formatted fields; · Provided extensive technical support to clients and shared knowledge of SAP Business Objects reporting tools. Troubleshooted Web Intelligence reports. Documented how the most challenging report problems were resolved; · Selected accomplishments: The report displayed yearly numbers of oversight activities by status (Ongoing and Closed) and by oversight outcome categories (Threat / Risk, Non-Compliance, etc.) as well as percentage (+/-) previous period – fiscal year. The user was able to select single or multiple programs and single or multiple regions. The result data was accurately organized by selected program and region. The report included Lists, Column Charts and Line Charts Overlaid on a Column Charts. Used Control Structures, Grouping, Variables, Formulas, Functions; The report displayed the yearly numbers of outcome actions for each region by outcome classification and outcome action type (e.g. Written Warning, Ticket, etc.) as well as percentage Fiscal Year Total.

Project: Aeronautical Data Management System (ADMS) Interface Replacement: · Upgrade the interfaces that source aeronautical data from ADMS to Reference Data Repository (RDR) and Unified Data Repository Atomic Layer (UDRAL) · Convert aeronautical reference master data in RDR to dimensional format · Revise the data access layer for existing RDR data consumers to source the aeronautical reference master data from RDR in dimensional format · Upgrade processes for provisioning aeronautical reference data to IM's business and analytical systems in the same format that they receive today. Requirements Analysis Worked within integrated project team delivery - gathered, analyzed, and documented business requirements and source to target business rules supporting the business requirements. Participated in discussions of the AeroRDS - RDR - UDRAL data interface functional design and the AeroRDS - RDR data transformation to have the data simply flows through to maintain the UDRAL tables. Presented business requirements and business rules for Internal Information Management and client approvals to ensure conformance to existing requirements and according to established standards & procedures, and the NAV Canada IM System Development Life Cycle (SDLC) framework; Quality Assurance Testing Led the coordination of testing activities such as functional, integration, system testing for data warehouse back end services and data integration (ETL) processes across groups in support of product release verification. Discussed and developed the AeroRDS - RDR - UDRAL functional and integration test strategy. Performed functional, regression, and integration acceptance testing. Developed SQL data access queries and created test scripts including scripts for testing round-earth data of geography spatial data type. Designed test requirements and test cases in MS TFS. Created TFS bugs linked to the TFS test requirements and assigned the bugs to the person to resolve the issues. Ensured that each individual test case step after test execution has test script and test evidence attached to the test case with value Passed or Failed. Produced test results and Quality Assurance reports. Received Thank You Letter from the client for the contribution to the project and it's successful deployment; Reporting / Administrative Completed status reports on each phase of the work, specifically for analysis, design and testing phases. Produced implementation plans. Participated in team meetings to provide a status report of work in progress, what is accomplished and problems and issues encountered. Proposed, documented, and presented approaches and solutions. Responded to critical problem situations in a timely and orderly fashion. Transferred knowledge gained within the company to NAV CANADA data analyst.

Project: Develop queries to extract data. Develop / modify reports. Create and deliver user documentation. Consult in establishing DEV environment for Grant Management System (GMS), assist in administering of JIRA application. Gathered, analyzed and documented business requirements for development new reports. Estimated cost/time of the work with reports. Designed, developed, and tested new crop survey reports. Provided strong support to business users. Assisted the clients in testing during UAT. Participated in team meetings. Reported the status of work. Delivered training demos and detailed user documentation according to established procedures; Resolved issues and performed testing in legacy reports and dashboards. Reviewed related documentation including reports, metadata, data integration (ETL jobs) and batch scripts. The work required expertise in developing queries to access data, dimensional modeling, testing, data warehouse, ETL, Business Objects BI tools (InfoView, CMC, Crystal Reports), and Cognos tools (Report Studio, Query Studio, Framework Manager and Connection). The client defined the outcomes as ``The best results in a long time...''; Analysed ETL Pentaho jobs' scripts and related database tables. Changed queries that accessed / transferred data from operational database to a data repository. Performed functional and integration ETL testing. Provided detailed documentation including data flow diagrams, ETL transformations, and explanations why some data were not transferred; Developed SQL queries to extract data. Tested and provided result data along with data analysis and SQL code to meet established standards; Created technical documentation including data/applications architecture documents and report specifications and updated team documents such as handbook, JIRA application admin guide, and developer setup guide. Products resulted in positive team assessment and client reaction. Team management adopted some of the documents as future templates for documenting ETL components and details of data integration (ETL) testing.

Projects: Upgrade to a web-based Axios assyst incident management system. Create reports. SAP Business Objects (Central Management Console, InfoView) Administration Actions included: Managed users and groups, granted access rights to view and run reports manually; Configured and scheduled reports for distribution as an e-mail attachment or copying to other share drives. SQL Queries / Views Development and Testing Selected accomplishments: Multipart views using advanced decoding functions such as DECODE, OVER (PARTITION BY... ORDER BY...), joins, grouping and conditions to extract data from Lookups table for Portfolio Change Report; View to extract incident acknowledge time and incident resolve time using CASE structures, sub-queries, joins, conditions, and grouping for Monthly Summary Report; View to retrieve data for List of Tickets with Breached Acknowledgement Report. The view included multiple joins, inline views, CASE structures, Null-related and decoding functions such as COALESCE and DECODE; SQL query to extract the number of tickets that were assigned to Shared Services Canada (SSC) between the required dates. The data was organized by service department. If a ticket was passed between two or more SSC departments, it was counted as one ticket. The query included joins, grouping, inline view, and functions such as COUNT, TO-DATE, and MIN. Report Development / Testing with SAP Business Objects Crystal Reports Tool My reports have been often noted as timely provided, and as meeting all necessary requirements. Selected accomplishments: 8-page report displaying IT Performance AT-A-Glance. The report included seven linked sub-reports; Complex report highlighting tickets assigned to the service department, date of received tickets, date tickets were transferred to another team, team member response time, and alerts. The report contained multiple running totals and more than 70 formulas; such as, NthLargest, NthSmallest, DateDiff, Control Structures, String and Date and Time Variables, Counts, Remainders, Joins, and other Field, Selection and Formatting formulas; Report displaying open tickets by Severity, Category with Date Assigned, Last Action Date and Last Action Notes. The reports includes multiple charts, used Global and Local variables, and various formulas such as DateDiff, ToNumber, ToText, IsNull, and Join; Summary of Scheduled Requests for Changes (RFCs); specifically totals, outstanding, successful, failed, and incomplete RFCs. The report included Date and Time functions, Summaries, Control Structures, Variables, and Running Totals; Report displaying Changes of Partner Portfolios. The report included two sub-reports - RFCs Schedule and Detailed Descriptive Information; Monthly Summary Reports displays tickets actioned by Service Departments by Province also further specified totals, closed, and pending tickets. The report utilized Control Structures, Grouping, Variables, numerous formulas, and functions; Report providing quarterly PeopleSoft dashboard data included Type Conversion, Summary, String functions, Date and Time, Math, String formulas and Control Structures. Maintenance of Integration Servers Actions included: Developed queries and extracted large sets of data from DirectInfo system. Tested, validated and imported the data into assyst application to update assyst application org codes and client records on a scheduled basis. Utilized multiple advanced Excel formulas and Notepad++ Plugin Comparing features; Monitored utilities and performed maintenance as required to prevent Escalation, Import, or External jobs interruption; Revised code in the assyst application using HTML, Lua, and PL/SQL languages to execute various actions such as sending messages to specific users. Environment: HTML, Lua, PL/SQL, SAP Business Objects Enterprise Central Management Console, and InfoView.

Various Projects. Main project: Develop a business intelligence (BI) reporting module in grant management application. Business Analysis With business and development teams, coordinated and supported reporting for multiple projects. Led a variety of tasks in all phases of application lifecycle, including requirements gathering and analysis, relational star schema modeling, creating test plans and testing scripts, query development, performing functional, integration, and system testing, writing and delivering user documentation, and providing extensive support to clients; Represented CSDC Systems at working groups and provided assistance to many internal and external CSDC clients including Alberta Health and Wellness Ministry, Alberta Ministry of Tourism, Parks and Recreation, Alberta Ministry of Culture and Community Spirit, US Department of Commerce, US Department of Housing and Urban Development, Sustainable Development Technology Canada, City of Toronto, Agriculture and Agri-Food Canada, and the State of Vermont; Gathered, analyzed, and documented CSDC clients reporting requirements and source data. Identified areas of deficiencies, located data sources, and missing data in the data mart; Assessed potential various BI software solution options against requirements and discussed impacts, costs, and feasibility of creating complex reports using the new BI solution; Contributed to product team in conceptualization and development of data mart and Operational Data Store (ODS) and integration of the Grantium™ Business Intelligence (BI) Solution. Participated in database design and architectural reviews. Identified key reporting dimensions, common and program specific measures for integrated reporting; Provided business requirements at overview sessions to development team members. Created and delivered technical specifications, report mock-ups, and data mart mapping documents; Presented new BI solution at the client sites. Conducted QA reviews of the application prior to UAT. Report Development with IBM Cognos Tools. IBM Cognos Administration

Computer Programming, Diploma (Hons)

Механико — металлургический, Металловедение и термическая обработка металлов