Profile:

• Senior IT leader with a Master's degree who is capable to lead the overall data design of a new enterprise architecture, make strategic decisions for enterprise level applications and systems with strong knowledge of database and data warehousing concepts, experienced in analysis, modeling, and development.
• 7 years of technical leadership with experience across all aspects of an architectures life cycle design, execution and operations
• 10 years of experience in Data Architecture, MDM, Data Stewardship, Metadata management, Data Quality Management, in-depth hands-on knowledge of Data Management technologies, Data Governance Standards and Practices, gathering business data requirements, developing related processes and documentation
• Experience in all facets of applications development, from initial use-case analysis, conceptual database design and data model de-normalization and normalization through implementation, documentation, testing, support, and users' training
• Proficient in Modeling Methodologies: conceptual, logical, and physical diagrams ERWin, ERStudio .
• Skills: SMP and MPP PDW Servers, Microsoft BI Stack: MS SQL Server 2000-2012 , SSIS from DB2, Oracle, MS SQL, MS Excel, text files, Fox Pro, Sybase , Transact SQL, MS Reporting Services SSRS , MS Analysis Service SSAS , Power Pivot, Power View, Share Point SAP Crystal Reports, Web
• Awards: Employee of the year for re-engineering and streamlining Annual Club and Maintenance Fee process
• BI Architect, Consultant

Confidential

• Creating a new Data Warehouse to measure sales, participation, gains and returns on capital using heterogeneous IT environment.
• Providing overall leadership for Data Warehousing Solution, including Data Analysis, Data Modeling, ETL Load Architecture, Dashboard Design, DW solution deployment and maintenance
• Developing, and communicating roadmaps and DW strategy to management team
• Running meetings with a stakeholder, who can help discovering business events and telling data stories Mainframe, MS SQL, flat files, other sources
• Planning and modeling data integration processes, communicating progress to senior business leaders
• Profiling the data, analyzing data quality and incorporation problems and suggesting technical solutions, standards, governance taking into consideration unified data consistency, reusability and legacy system integration
• Creating a dimensional model First iteration 14 dimensions, 7 facts using Kimball's methodology ERStudio
• Defining a strategy of ODS and Dimension/Fact load processes producing Mapping documents for Data Stage ETL developer
• Influencing of executive dashboard design and approach WebFocus

BI Architect, Central Division

Confidential

• Created a new Central Division Data Warehouse to support Division Care Scorecard Metrics such as Schedule Adherence, Calls per Productive Hour, Voice of the Customer, Line of Questioning, and Agent Transitional Sales Rate
• Planned, Architected and Modeled BI solution using MS SQL 2012 SSIS, SSAS, SSRS, PowerPivot, PowerView, SharePoint , Idera for performance management, TFS, SharePoint
• Defined environments, layers of the BI integration methodology and data usage impacts
• Coordinated development across the BI team by implementing technical architecture, monitoring team, reviewing requirements and ensuring entirety of the solutions
• Lead analysis of business requirements and creating a Data Model for the solution start schema, using ERStudio XE3
• Designed a methodology for extraction, data profiling, quality metrics, indexing, partitioning, archiving, error and exception handling, monitoring data privacy policies, establishing use/test cases, and production releases
• Created SSIS packages to load the model using SSIS 2012. Some facts: 23 dimensions and 11 fact tables, 22 different sources Db2, Teradata, Oracle, MS SQL 2008, flat files with about 300 tables, ODS size 3 TB, DW size 0.5 TB, biggest table 2 billion records Daily Snapshot 10 mln records , 3 fact tables were partitioned, switch partition approach was created for performance, MDM was used to support not maintained in any systems data 13 tables , capturing daily subscriber activities system Subscriber Revenue Activity was created to support fact tables.
• Created SSAS to track billing activities used SSRS, Power Pivot and Power View for reporting purposes.

Data Warehouse for Offer Analytics based on PDW server MS SQL 2008

• Used Agile methodology and followed Microsoft best practice to create centralized data warehouse on MPP server
• The primary business goals of the project: ability to see subscriber performance and activity on a more frequent basis daily , insight into offer performance levels based on various KPI's, ability to do more predictive analysis, forecasting capability related to subscribers and their offers
• Working with Microsoft consultants and lead a team of developers to create centralized data warehouse that is built to be the single provider of information and analysis for the Central Division. Business and Functional requirement documents were created. Data scrubbing technic against the business rules was created and stored in a manor more conducive to analysis to provide decision makers with reports to answer questions about customer profiles and revenue driven by those profiles
• Some facts: 2 different billing systems CSG and Amdocs , 11 Dimensions, 6 Fact tables, biggest table: 200 mln. records daily snapshot.

Consultant

Confidential

• Provided guidance regarding the use of data warehouse systems, capability of systems to deliver information, and subject matter expertise regarding current systems, worked with business sponsors to ensure training, understanding and adoption of BI principles.
• Ensured the development of enterprise-wide standards for the Data Warehouse to ensure compatibility and integration of existing reporting platforms.
• Used BEAM Business Event Analysis Modeling data modeling method and Agile technologies to design Star schemas that were optimized for decision support processes.
• Created conceptual, logical and physical models using ER Studio.
• Developed and implemented a data warehouse using SSIS, established auditing of the data warehouses to ensure quality control of data.

Projects:

• Healthcare pre-cert MS SQL 2008 R2, Sybase, Power Designer, Tortoise
• Healthcare Vitals, Health Maintenance, and Healthcare Modifiers: HIT Data Integration project using technical best practices for data movement, data quality, data cleansing, and standards. Develop ETL Strategies, work as liaison between Business Analysts, Report Writers and Architects on all Data Integration development activities MS SQL 2012, TFS, Skelta .
• Offers and Campaigns: Gave ability to evaluate offers promotions, coupons and campaigns performance, provides key measurements such as promotion revenue, margins of 'targeted' products and 'sold with' products, volume of acquired customers, number of newly penetrated customers
• Ecommerce: Helped to improve co-relation between the web site design, sales, and customer retention in e-commerce environment, capturing the navigation habits of customers using Ecommerce sources such as Coremetrics, Exact Target, Unica.
• Microsoft Incentives: The goal was to make the information accessible to analyze licenses' incentives and rebate fees for such strategic purposes as trend identification, forecasting, competitive analysis, and targeted market research MS SQL 2008R2, SSIS, SSRS, ER Studio, TFS, Excel .

-

Business Intelligence Manager Lead BI Developer

Confidential

• Created the requirement documents that include a list of data elements, example questions, desired reports that help answer the analytical questions for Automation of Sales Journal Entry project. Established analytical techniques used in collecting, preparing and cleaning sales data, designed the queries and reports needed by end users that allowed to save about 150 hours every months
• Identified Key Performance Indicators KPIs like value per tour and rescission percentage defined, designed and documented business flows and processes using MS Visio and MS Excel created BI tool that allows reducing marketing cost and modifying the strategies MS SQL stored procedures, cubes, .Net, Web .
• Initiated and supervised the development of the 'Person' Data Warehouse MS SQL 2005 that included Data integration of the demographic sources from different platforms SSIS DB2, Oracle, MS SQL2000, flat files, MS Excel . Established and scheduled customer address, phone, and e-mail population and upgrade T-SQL, SSIS, stored procedures . Cleansing logic allowed to decrease mail return from 30 to 3 that saved more than 50 thousand dollars for each mail blast. Directed a development of user friendly interface GUI .Net, Web to provide a complete picture of customers' activities.
• Leaded a team of .Net developers of transactional database Shell Vacations Tour Entry And Gift Management OLTP MS SQL 2005, SSRS database design, development, implementation and maintenance . Provided business analysis, data acquisition, access analysis and design of the database. Translated objectives into short-term assignments, established priorities, and measured a progress.
• Involved and managed a development of customized replication from AS400 mainframe to MS SQL 2000 stored procedures, triggers . The application replaced DB Moto software.
• Managed the development of customized Intranet application .Net Operational Reporting System that allowed all users to run Crystal Reports according to their permissions without a local copy of Crystal Reports. The application saved 94 thousand dollars to the company. MS SQL 2005, Crystal Reports 11

-

Data/Business Analyst, User-Programmer Liaison

Confidential

• Identified users' requirements validated and analyzed business rules, data flow and definitions. Determined data sources such as customers, contracts, reservations, tours, accounting . Established a cleansing logic on one of the main system based on mainframe AS/400.
• Developed reasonable data sharing strategies and download methods for each table replication or scheduled job, DTS from Oracle, DB2, excel spreadsheets and MS SQL, defined standards.
• Consolidated data into MS SQL 2000, 2005 from data from multiple origins and into Data Warehouse DW with daily and end of the month snapshots. The reports cut down users' time, only one Customer Pre-arrival Information Report economizes 4 person/days per month for each of 12 sales centers in USA and Canada.
• Leaded analysis sessions to capture data requirements. Created logic and developed a SQL job that calculates maintenance and club fee annually for club members that saved a few month of work for Member Services and Portfolio department.
• Optimized the DW server to prevent deadlocks, created indexes, views to improve performance and maintain security. Developed more than 550 stored procedures for regular reports. Developed and provided end-user Data Structure and Crystal Reports training WebEx, Team Viewer 4 materials and courses for more than 35 users