Project Description: Data Load Gateway between multiple source systems and BI solutionCompany has several hospitality products and hundreds of clients using these products. In addition, company provides Analytics service based on Gooddata BI solution which works on own datasource and requires ETL operation. Gateway serves as an internal portal to initiate, monitor, troubleshoot and manage data load operations.Project Role: Business AnalystResponsibilities: - Requirements Management- Define scope of solution- Create and manage requirement documents for project based on results of analysis.- Support development team during Agile lifecycle

Project Description: Mobile Member Portal for leading US Healthcare Insurance companyCross-platform B2C application for Mobile Member Portal. Application allows members to access their insurance information using mobile channel (iOS, Android, mobile Web). Mobile channel provides access to a subset of Desktop Web portal features: Insurance Plan information, Claims, Explanation of Benefits, Find a Provider, etc.Project Role: Business Analyst LeadResponsibilities: - Leading a team of 4 Business Analysts: define team standards, processes- Requirements Management (Elicitation, Analysis, Formalization)- Define scope of solution- Create and manage requirement documents for project based on results of analysis.- Communicating requirements to distributed team of about 50 people in 4 locations- Support development team during Agile lifecycleTools & Technologies: Kony Mobile Application Development Platform

Project Description: Group of B2E and B2C mobile applicationsCross-platform mobile applications (iOS, Android, Blackberry, Mobile Web) aimed to cover different aspects of organization-employee or organization-customer interaction:- HR: time reporting, leaves reporting, expenses reporting- Insurance agent mobile portal- Customer Service Agent web portal- Medication Reminders for customers of Insurance PlanProject Role: Business AnalystResponsibilities: - Requirements elicitation - Define scope of solution- Create and manage requirement documents for project based on results of analysis.- Support development team during Agile lifecycleTools & Technologies: Kony Mobile Application Development Platform

Project Description: Multiple (100+) relatively small projects related with implementation data load feeds to existing applicationLoad large amounts of marketing data into online marketing application (business/consumer records, up to hundreds millions records). Source data can come from various sources, there can be duplicates, data inconsistencies. As a result of each project, client data should be analyzed and ETL process to accept data from client, apply multiple services, reformat it to structure accepted by application on repeating basis should be created.Project Role: Data Analyst, Business AnalystResponsibilities: - Analysis of client data aimed to load it to huge online application. - Design data models, requirements for data transformations from original form to models that enable application to use client data. - Review, analyze and standardize metadata prior to loading data to application. - Create requirement documents for project based on results of analysis.- Design data quality methods and tests for each particular data set. Use these methods to report issues/inconsistencies to product manager and client. - Define recommendations for client regarding metadata and data consistency in order to minimize issues and delays of ETL operations for his data on their way to application. - Provide technical expertise to product managers, client-facing people- Work with development team as a client proxyTools & Technologies: Microsoft SQL Server 2000/2005, Sybase IQ, Microsoft Data Transformation Services (DTS), Microsoft SQL Server Integration Services (SSIS), DataLever Enterprise Suite

Project Description: Implementing custom data modification routines for small projects (ETL operations – Extract, Transform and Load)Projects are related with technical support of Direct Marketing initiatives of our clients: data transformation operations between numerous data formats, utilization of special tools to standardize address/name information in order to improve quality of data, duplicates detection based on non-exact matching of address/name information.Responsibilities: - Implement data load processes- Review data using profiling tools or direct access and provide specifications to programmers. - Recommendations to account manager regarding additional services client may need. - Confirm data quality based on corporate standards.Tools & Technologies: Microsoft SQL Server 2000/2005, C/C++, Business Objects ACE/Data Right/Match-Consolidate