Michael Vijayakumar Email & Phone Number

London, Gb

Service-oriented Leader with Master’s Degree in Computer Management, experience in Data Engineering, Data Warehouse, Data Integration, Business Intelligence, Analytics and Data Science. Well experienced in working with stake holders and product owners, project sponsors and work as a liaison between functional / business stakeholders and technical team. Expert in understanding the business needs and translating them to technology design and architectural blueprints. Core competencies include Project Management, Product Management, People Management, process Improvement in Data and Analytics space. Experience is working with vendors and implement various products such as AWS redshift, Dataiku and Five Tran solutions from the ground up. Proficient in identifying process gaps and implement solutions to improve efficiencies and save costs.Expert level understanding of Compliance, Security, Governance and experience in supporting various internal and external audits (Sarbanes -Oxley, Deloitte, DCMAA, CMMC etc.). Expert in implementing various audit requirement remediations such as access controls, audit controls, configuration management, Multi Factor Authentications, etc. Possess excellent communication and time

Reston, Virginia, Us

o Currently serve as EDW Technical Manager to implement OBIEE using OBIA.o Interact and participate in business development by identifying new opportunities and assisting with proposal developmento Work with Enterprise and Solution architects to define standards across all application design.o Leading the current legacy EDW application using Informatica 9.1.0 and administering informatica 9.1.0o Consolidated and migrated informatica 9.01 object to 9.1.0 objects from legacy OBIEE setup and saved license fee for the companyo Responsible for sun setting legacy DW application and migrate necessary objects to OBIAo Provide technical roadmap to upper managemento Working with EPM / Hyperion team by leveraging ODI experience to integrate EDW data to Essbase cubes using proper knowledge modules. o Responsible for designing and architecting CRM solutions and use OBIEE to present dashboards and reports.

Dublin , Ca, Us

• An EDW architect , design, model, built and implemented an Enterprise Data Warehouse and Business Intelligence solutions from the ground up• Work with other data stewards and propose new KPIs and provide recommendation using captured data.• Architect and model true Start Schema EDW using PSFT HCM,CRM and Payroll, AVAYA,PPM and QM data.• Document business analysis requirements & translate business requirements into logical data models and star schemas.• Define scope and develop project plans for projects to extend the data warehouse and provide recommendation of metrics that helps identify new facts and associated dimensions.• Create project plans and implement them with proper follow up during the course of the projects to bring them to completion and provide risk evaluation.• Design conceptual, logical and physical model as well as rules required to populate Data Warehouse tables.• Implemented technical and design templates and enforced design and code walkthroughs.• Mentor and train IT team members to use set based analysis vs row based analysis for EDW processing.• Assist users with creation of User Acceptance Test plans, and evaluation of results• Implemented ODI to replace current home built EDW engine.• Evaluated informatica 9.10 as a potential ETL tool for current EDW application.

Houston, Texas, Us

o As a Technical Manager / architect, worked with Cognos consultant to define and implemented EDW/BI solutions for Cardinal Health Care (hospital)o Worked with cognos consultants to define and finalize all part of modeling and get sign off from the business steak holders Conceptual Logical Physicalo Defined product roadmap, project sizing and presented to all the steak holders and ‘C’ level managers o Defined and enforced “Best Practices” in building data warehouse includes but not limited to  Data Quality Process reusability EDW naming standards Wiki for metadata (Part of MDM) Business and Technical documentation (SDLC) methodologies Process efficiency – Set based vs row based Design and code reviews Standardized implementation scripts (part of configuration management)o Implemented Congos’s new Adaptive Analytics (AA) and adaptive warehouse (AW) for Cardinal Healthcareo Worked with various teams around the globe in implementing the ETL processing on the Towers / Point Solutions including Work Force Administration (WFA) – PeopleSoft, Absence Management (AM) – KCRS, Recruiting and Staffing (RAS) – Taleo. The duties includes Extract the data by calling KCRS vendor’s stored procedures using DB link and create the necessary csv files. Extract data from Taleo using TCC Client (Client API) by passing valid parameters using xml files Transfer them to staging server using secure copy Load files into staging database tables using sql loader, import utilities Run cognos load utility to transform into multi dimensional modeling tables (Dimensions, facts)o Working with the vendors and cardinal health care users to design the data mapping specificationo Worked with German autosys team to implement / schedule all BI jobs in Autosyso Working with Data Integration team on Agile technology (SOA architecture).

Houston, Texas, Us

Agile (SOA – A3 architecture ) Technology. Data Integration  Involved in implementing EDS’s Agile Enterprise Technology (SOA) for Cardinal Health Care  Maintain and support Process flows developed using ORACLE BEPL. Served as an Prod support analyst using BPEL Process Manager to orchestrate various work flows to integrate the following applications o Work Force Administration (WFA) – PeopleSoft o Absence Management (AM) – KCRS o Case Management - Siebel o Recruiting and Staffing (RAS) – Taleo o Total Performance and Sum Total Design, develop and implement Oracle PL/SQL procedures, unix shells for Data Integration process Developed archival process for input / output data Created production support hand book to help document On boarding

Dallas, Tx, Us

 Design and developed numerous mappings using various transformations (Lookup, router, joiner, unconnected lookups) for Medical Insurance Analysis and HR Data Warehouse System using Informatica 7.1 and Oracle 9i Design / Edit work flows to link the mappings to complete ETL processes. Provided time and cost estimates to project teams – New Development / Maintenance Developed Business, System and Design methodologies for any new development and changes in business scopes. Involved in maintaining the current HR Data Warehouse application using Oracle Star Schema and Informatica 7.1 Served as a support analyst to the global users of AT&T’s HR data warehouse module.  Test, verify and implement other developer’s solutions.  Collect and review enhancements from the business.  OTHER ACCOMBLISHMENTS Out of Office System – Deployed EDS South East Atlantic Solution Center’s Out Of Ofice system from EDS’s machine to AT&T’s Intranet for EDS employees in AT&T. This ASP (IIS), DB2 application was converted to IIS ,Oracle 9i in 7 days due to server crash. PAYROLL DATA MART – Redesigned payroll datamart application’s Web site to use Oracle 9iAs’s Apache web server and use citrix server access to user Oracle discoverer. Also implemented Oracle Discvoerer Viewer 4i through the website.  Configuration Management – As part of a team to aid the account to acheive CMM Level 2, provided suggestions to create CMM handbook for the Non MVS portion of the account. In addition, created the Organization CMM Handbook for all the Time Entry applicaitons. ATT – SBC Transition – Payroll Application – As a active member of the payroll application SME team to provide application informations related to the transition

Mcm, Master'S In Computer Management

Bsc, Batchlor Of Science (Physics)