SUMMARY

• ETL & Business Intelligence Developer / IT professional with Bachelor of Computer Science and 12+ years of extensive experience developing, implementing ETL solutions, Business Intelligence, ERP software systems, and supporting IT system infrastructure
• Solutions - focused, team-oriented IT professional with broad experience and hands-on skills in the full cycle design and development (Prototyping & Design, Development, Unit & QA Testing, On-Call Support & Maintenance) of fully functional ETL solutions and ERP systems that solve the real business needs
• Analyze and define client business strategy and determine system architecture requirements to achieve business goals
• Translate business requirements into a scalable data models, create key data pipelines and data transformations
• Hands-on experience with ETL, in both batch and streaming structured and unstructured data ingestion
• Working knowledge and experience of data analysis, data cleansing, data modeling and data migration in financial, investment, insurance, banking and automotive industries
• Develop Big Data models, reporting and data analytics with advanced data visualization that identify and forecast trends and cause-effect relationships, lead to recommendations, and measurably maximize operational efficiency
• Experience with automation/scheduling of data workflows/data services jobs
• Work cross-functionally to explore and propose solutions to business problems using insights from data and algorithms
• Technical expertise and experience developing, customizing, testing, implementing and maintaining ERP solutions including the following modules: financing, accounting, warehouse, manufacturing, and HR
• Ability to analyze an organization's critical mission requirements, identify deficiencies and potential opportunities and develop an appropriate solution strategy
• ETL Data Warehousing and modeling: SAP Data Services 4.2 (BODS), SAP HANA 2.0, SAP Business Warehouse, SAP Replication Server (SRS), SAP Information Steward, IBM InfoSphere DataStage
• Big Data and clouds: Apache Hadoop, Google Cloud (BigQuery, Cloud Data Fusion, Cloud Dataproc)
• BI & Reporting Tools: SAP BusinessObjects (BOBJ), SQL, SAP Crystal Reports, SAP PLD Reports, SAP WEBI Reports, SAP XL Designer, Tableau
• SAP Solutions / SAP Business One Modules: S/4HANA, BW4/HANA;

PROFESSIONAL EXPERIENCE

Data Migration Consultant

Confidential

Responsibilities:

• I was Involved in all aspects of a full life cycle TCI data migration Agile project (Scrum) including integration architecture, technical analysis, design, development, testing, documentation and performance tuning
• Develop data architecture design to facilitate targeted customer analysis
• Suggest architectural improvements, design and integration solutions, and formulate methodologies to optimize data migration process
• Created architecture design for "Data Quality Monitoring Landscape using SAP Information Steward", which helps reduce IT consulting costs and complexity with a single solution for data profiling and metadata management
• Designed “SAP Data Transfer Standards & Best Practices” documentation which gives standards and guidelines to the usage of SAP Data Services and data transfer process. The purpose of these standards and guidelines is to facilitate the development of DS applications that are functionally correct, easily maintainable and well performing
• Created SAP BODS ETL technical framework for Confidential Canada data migration project. Main goal of this framework is standardization - to use the best practices and standards in the development process. The framework includes such important data processes as change data capture (CDC), data file processing, audit control, error handling and restartability, change log, etc.
• Implemented development review process, code promotion, cutover go-live plan, and was also involved into creating of change control process
• Performed data sourcing investigations to identify TCI database models
• Worked extensively with data profiling tool SAP Information Steward 4.0 for ongoing project to understand the quality of data before loading into the HANA database
• Coordinated discussion with various development groups and business units to determine data dependencies
• Facilitated business process reverse engineering and business process mapping
• Gathered the business requirements and analyze the legacy systems like EDW, COGNOS and Mainframe which are the source of data and accordingly map them with SAP BW4/HANA and SAP S/4 HANA reporting requirements
• Involved in designing the Hana ADSO cubes to load the historical data for various financial and sales reporting out of SAP BW4/HANA
• Designed and developed multiple data services jobs using ETL tools such as SAP BODS and IBM InfoSphere DataStage
• Migrated legacy COGNOS reports to SAP BusinessObjects BI 4.2
• Migrated over 800 analytic views to S/4 HANA DB from legacy system, most of which were recreated due to syntax and environment differences
• Mentored TCI team members and contractors ensuring all were trained in SAP Data Services and SAP HANA products knowledge and capable of performing assigned duties

ETL & Business Intelligence Developer

Confidential

Responsibilities:

• I have been actively involved in the development of the data solution since the very beginning of the project, and I developed key frameworks such as Change Data Capture (CDC), Slowly Changing Dimension, Master Data Load, Transaction Data Load, Master Data Harmonization, Exception & Error Handling, Unstructured Data Processing, etc.
• Analyzed, designed, developed, tested and supported (including on-call support) the following data transformations using SAP Data Services ETL tool:
• Raw Data Layer - designed and developed multiple data services jobs to migrate legacy data from multiple sources to SAP CRM, SAP HANA DB and analytics, including master data and transaction data objects:
• Source Systems: Oracle, MS SQL, Sybase, Cobol, Flat Files, XML, Excel files, SAP BW
• Target Systems: SAP HANA, SAP Sybase IQ
• Staging Data Layer - designed and developed the following data transformation processes:
• Technical Data Mapping: data matching, correlation, lookups
• Harmonization: data standardization, data quality, survivorship & de-duplication
• Validation & Cleansing
• Exception & Error Handling
• Data Audit and Reconciliation
• Target Data Layer - data extractions to the following target systems:
• SAP HANA (real-time database in memory)
• SAP CRM - built IDoc files to load CIF (customer information file) into CRM system
• Designed and developed a real-time data processing solution based on SAP Replication Server (SRS) in conjunction with SAP PowerDesigner, as an alternative way to capture changes from heterogeneous source systems
• Developed multiple HANA views (attribute, analytic, calculation), stored procedures, table functions, etc.
• Big data integration with Hadoop and cloud services
• Developed BI reports using Tableau, SAP BOBJ (WEBI)
• Performed unit, functional and regression testing, created and executed QA test cases/test plans using HP ALM test platform to identify and fix the data solution problems and their causes
• Mentored and guided new team members ensuring all were trained in SAP Data Services product knowledge and capable of performing assigned duties
• The data solution has been handed off to another part of the Power Corporation’s IT environment as it was quite successful, and as result all my data transformation frameworks will be used in other parts of the business

SAP Implementation Consultant

Confidential

Responsibilities:

• SAP ERP Implementation scope and design
• Documenting current-state customer business processes and designing future-state SAP Business One processes
• Defining and documenting requirements for software customizations and custom reports
• Designing and conducting data migration from legacy systems into SAP HANA
• Customizing forms and developing BI reports using SQL, SAP Crystal Reports, SAP PLD reporting tool, SAP XL Designer, Tableau, SAP BOBJ
• SAP Business One technical installations, migrations and upgrades
• Third Party Add-On's implementation and upgrades
• MS SQL Servers, SAP RSP (Remote Support Platform), MS IIS administrating, maintenance and support
• Worked closely with the offshore development team (Israel) to create a new custom solutions (add-ons) for the end clients
• Providing ongoing customer maintenance and support

Deployment IT Consultant

Confidential

Responsibilities:

• Provided IT-Consulting and support for the deployment project at Manitoba Hydro, and Manitoba eHealth
• Configured and tested enterprise software and IT facilities
• Provided IT-consulting and support to users
• Responsible for migration and backup of personal user's data
• Performed cross platform audits of Active Directory (AD) objects and user permissions

ERP Development & Data Migration

Confidential

Responsibilities:

• Built, led, managed, trained a competent team from scratch as STRATUP company
• Implemented and supported more than 100 ERP software systems across Kazakhstan during a 6-year period
• Initiated key Agile projects in full collaboration with the business stakeholders which resulted in successful competition
• Designed architecture, developed and implemented ERP solutions (based on 1C “Enterprise”, 1C “Accounting”, 1C “Trade” & 1C “Production”, SAP B1), conducted QA testing
• Data projects: ETL, data migration, data conversions and data modeling, data quality management
• Designed, implemented, administered and maintained IT environments
• Provided IT consulting and support to various SMB and Enterprise clients
• Managed offshore and virtual teams (CIS countries) to improve product quality and reduce costs
• Built long-term relationship with customers

ERP Developer / Infrastructure Administrator

Confidential

Responsibilities:

• Designed, developed and implemented enterprise management & accounting programs based on 1C ERP system (Enterprise, Finance & Accounting, Trade, Wholesale modules)
• Designed, implemented, and maintained network environment
• Installed, configured and maintained Microsoft Windows servers
• Maintained and supported computer software and facilities
• Designed, implemented and maintained distributed company database and organized ETL batches
• Carried out troubleshooting and diagnostics for the users