| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name EMAIL AVAILABLE PHONE NUMBER AVAILABLE (c)Information and Data Management LeaderLeader in Information and Data Management with proven track record of building robust Enterprise Architectures and Data Management solutions for Global organizations.Over 20 years of experience in leading teams and building Enterprise Data Architecture, Enterprise Data Warehouse, ETL Architecture, Data Integration and Reporting Architecture, Data Governance, Business Intelligence and Data Analytics solutions within time and budget for various clients.Recognized for driving results, delivering complex engagements, innovative thinking & leadership.Provide strategic thinking, solutions, roadmaps and driving architectural guidance for clients.Developing Architectural plans and roadmaps supportive of the business objectives.Establishing communication strategy to share, present, educated and promote procedures, processes and roadmaps with leadership and various business and architectural teams.Solid experience leading and managing successful Design, Development and implementations of Data Warehouse and Data Integration projects across various business domains.Strong experience leading and managing successful implementations of Data Governance, Data Quality, Data Security, Metadata and Master Data Management initiatives across the enterprise.Strong experience with Guidewire DataHub Architecture and Design to customize solutions.Very strong Data Warehouse, Data Architecture, BI & Team Leadership and Management skills.Data Warehouse, ETL and Reporting Architecture and Design (Conceptual, Logical & Physical).Strong experience with various ETL/Data Integration and BI/Analytics/Reporting tools/platforms.Strong experience Managing and Leading Data Management solutions across the Enterprise.Excellent Management, Team Leadership, Communication & Inter-personal skills.Strong Vendor and Client Management experience.Education:Masters in Computer ApplicationsBachelors in StatisticsProfessional Training/Certification:Trained and Certified Six-Sigma Green Belt (for TQM Total Quality Management)Guidewire DataHub, InfoCenter and ETL Architecture and DesignIndustry:B2B, Energy, Airline, Banking, Government, Healthcare, Reinsurance, Insurance, FinanceSpecialty Skills:Leadership skills for Enterprise Data Architecture, Data Integration and ETL Architecture, Data Warehouse & BI/ Reporting Architecture, Data Analytics, Data Quality, Data Governance, Data Management.Achievements:Provide Advisory Services and create high level Data Strategy, Roadmaps and Architecture for Data Integration, Data Migration, Data Management, Data Governance, BI and Reporting solutions.Successfully lead teams through Requirements, Architecture, Design, Development, ImplementationLead the initiatives for Enterprise Data Architecture and Strategy, Enterprise Data Warehouse, Data Management and BI/Reporting solutions from grounds up and successfully implemented within time and budget for Insurance, Finance and Healthcare companies and State Government clients.Technical Skills Summary:Oracle RDBMS 7.x, 8.x, 9i, 10g, 11g, 12c, MS SQL Server 7/2000/5/8/12/14, Teradata, UDB/DB2, HP Vertica, Java, C++, .Net, ASP, Perl, Java Web Server, IIS, WebLogic, TIBCO, Jaros Analytics 3.0.3, Jaros AMDR 1.19.7, Erwin 9.64, 7.3, 4.1.4, 3.5, Sybase Power Designer 16.5, 15.x, Embarcadero ERStudio 9.5, Altova XMLSpy 2016, Informatica Power Center 5.1, 7.1, 8.1, 9, 9.5.1, 10.1, IBM Data Stage 8, OWB 2.1, 3i, Astera Centerprise Data Integrator 5.x, SAP BODS, SSIS, SSAS, DTS, WTX, EDI, X12, Cognos 8i, Business Objects, Logi Analytics 11.x, Guidewire DataHub 8.2, 8.3, 9, Guidewire InfoCenter, Visio, TOAD 11.0, 10.5, 9.6, 8.5, SQL Navigator, PVCS, VSS, TFS, CA Rally, HP ALM 12.21, JIRA, Azure, AWSProfessional Experience:Jun 21 till date Enterprise Data Architect/Lead Piedmont Community Health Plan, Lynchburg, VAAs part of the WINGS project, Piedmont Community Health Plan (PCHP) was implementing HealthRules Payor (HRP), a core administrative processing system from HealthEdge, for configuring Benefit Plan, Provider Contract, Claims Processing and Information Transparency, as they were moving from the legacy system IMPACT and S&S. Working as Enterprise Data Architect / Data Strategy Lead to implement a new reporting solution to deliver data and reporting needs for PCHPs business users and capabilities to interface and exchange data with other systems and external vendors. The reporting solution is implemented using SSRS.Worked with various business users and stakeholders to identify PCHPs data needs.Worked with business users from Provider Relations, Pharmacy, Medical Management, Customer Service, Operations, Underwriting, Actuarial, Sales, Marketing, Finance, Compliance divisions to ensure continuity of business operations along with external servicing partners and vendors.Identified the data and reporting needs for PCHP.Defined the to-be architecture to support PCHPs data integration and reporting needs.Helping with implementation and rollout of the new reporting solution built using SSRS.Document Data Flows and Process Flows.Help with resolving issues while converting the Provider data into Symplr, and Member and Group data from Exchange (Individuals) and Commercial (Small Groups and Large Groups).The data from HRP flows into the data warehouse HRDW and then into ODS, in near real time basis.ODS was built by the HRP implementation partner company UST.Understood and analyzed the data models for the movement of data across various systemsHelped with source to target data mapping and resolve issues.Worked with the report developers to extract/load data from ODS into various reports and data feeds.Help with establishing SFTP connections and setting up folders with various external vendors.Data files processing for Eligibility, Enrollment, Member, Provider, Authorizations, Accumulators, Claims, Repricing, Payments, Reconciliation data in X12 834, 837, NCPDP formats and as text files.Data files exchange with various vendors like Aetna (Repricing Claims), FirstHealth (Repricing Claims), Burgess (Claims Editing), Foster Fuels (Enrollment), Quantum, CVS/Caremark (Eligibility, Accumulators), Inovalon, Aerial (Eligibility), CRM (Member Benefit), Medecision (Authorizations), Softheon (Exchange and Small Group), HRP (Large Group), HealthTrio (Member Portal, Provider Portal, Cost Transparency) PNC(Claims Payment), VHI, etc. on daily and monthly basis.Providing APCD Eligibility, Provider, Pharmacy, Claim data feeds to VHI.Working with the business team for identifying and resolving issues and defects.Working closely with the UST Integration team, onshore and offshore, to resolve any issues.Provide regular updates to business users and internal and external stake holders to ensure successfully delivery of the reports and data feeds.Working closely with Program/Project Manager to define the plan, tasks, dependencies, estimatesLeading the team and directing work to development resources. Issue escalation and conflict resolution.Ensuring successful delivery of project within time and budget.Environment: AWS, SQL Server 2018, SSRS, JIRA, VisioOct 18 Jun 21 Enterprise Data Architect/ Data Strategy Lead MN Housing Finance, Saint Paul, MNReporting to the CIO of Minnesota Housing Finance Agency (MHFA) working as Enterprise Data Architect / Data Strategy Lead as part of Single Familys BOSS project to implement a new loan origination system ELC (Enterprise Lending Center) by Mortgage Cadence and create a centralized data repository to support Management of Funds solution to perform disbursements, have reporting capabilities and to interface and exchange data with other systems including HDS Master Servicing and US Bank. The new application ELC is on Microsoft Azure and the solution is implemented on Oracle database using Pentaho for ETL.Worked with business users and stakeholders to identify MHFAs data needs.Worked with Single Family, Accounting and Finance divisions of the Agency to ensure continuity of business operations along with external Servicing partners and Lenders.Defined the Enterprise Data strategy to be implemented by the agency.Defined the to-be architecture to support MHFAs data integration and reporting needs.Helping with implementation and rollout of the new loan origination system ELC (Enterprise Lending Center) built on Microsoft Azure/SQL Server.Document Data Flows and Process Flows.Created Data Modeling standards and best practices.Create Logical and Physical Data Models using ERStudioDesigned Source and Staging layer to land the incoming data before loading it into ODS using Pentaho.Defined the ETL architecture for the movement of data across various systemsHelped in creating source to target data mapping and resolve issues.ELC data is sourced multiple times a day from SQL Server database restored from Azure cloud.Worked with ETL developers to extract/load data from ELC into ODS using Pentaho.ETL workflows for sending data from ODS to US Bank, HDS Master servicing and back to ODS.Working with QA team for identifying and resolving issues and defects.Working with developers to provide data needed for Management of Funds (MoF) application.Working with developers to update the XML file used by the homegrown reporting application FIRMCreating data visualization dashboards and cubes in Sisense to support business data analytics needsExploring Power BI capabilities to support current/future agency data needsWork closely with DBAs to resolve any issues.Capacity planning. Database security, sizing and growth estimates,Provide regular updates to business users and stake holders to ensure successfully delivery of the projectWorking very closely with Program/Project Manager to define the plan, tasks, dependencies, estimatesLeading the team and directing work to development resources. Issue escalation and conflict resolution.Ensuring successful delivery of project within time and budget.Environment: ERStudio Data Architect 18.2, SQL Server 2016, Oracle 12c, Pentaho, Sisense, Power BIOct 16 Oct 18 Chief Data Architect / Data Management Leader FGL, Des Moines, IAWorking as Chief Data Architect/Data Management Leader for Fidelity & Guaranty Life (FGL) Insurance Company as part of the BigDig program for building a data platform to streamline processes and consumption of data from various sources to create timely, accurate, useful, single source of truth for reporting investment data for Investment Accounting/Financial Reporting, FP&A, Treasury, Risk Management and Audit. The solution is being implemented on SQL Server database using Informatica for ETL and Essbase and Tableau for BI and Reporting.Worked with business users and stakeholders to identify FGLs data needs as part of the BigDig project.Established Data Management strategy to share, present, educate and promote procedures, processes and roadmaps with leadership and various business and architectural teamsCreated the strategic layout of future Enterprise Architecture and Data Management plan.Create the roadmap for the future Data Management strategy and the Enterprise Data platformFacilitate on-going communications to leadership teams, Business leaders, Technology partners.Conducted analyses of business architecture models and reviewed the IT processes (SDLC), Program/Project Management processes (PMO), Cost control, Governance structures.Negotiate priorities and resolves conflicts among stakeholders and project team(s).Played the role of an Evangelist to educate users and socialize solution designs and the value of Data Management and architecture to solve complex problems.Lead and coordinate efforts to write/establish and gain consensus with standards in managing and governing enterprise data to reflect data governance, data security, data operations, data management, data quality, data processing, and platform/architectureEngage with teams to ensure standards can be consumed & leveraged as standard course of businessDocument the as-is and to-be System and Data ArchitectureDefined to-be architecture to support FGLs data management, sourcing, integration and reporting needs.Architect and Design end-to-end Solution for the BigDig project to address business data needs.Defined ETL architecture for the movement of data across various systems.Defined Reporting Architecture and designed the solution to support FGL reporting needs.For Release 1, build a platform to source the data from PAM for securities provided by SSKC/SSGSExtract Transform and Loading of the data from PAM Adaptor files (50+) for Securities, Forwards Swaps, including positions, valuations, transactions data, and PAM Supplemental files including mortgage data.Applying set of data quality checks and business rules on the incoming data, identify, measure, analyze and remediate data quality problems through data analysis and information processing of large datasetsCreating Golden Investment Datasets (GID) for Asset, Income, Transactions, Unapplied Cash, Open Payable/Receivable, CML, etc. by creating a set of processes to create Bronze (raw) datasets and applying adjustments to create Silver (adjusted) datasets until it becomes Golden (approved) during the Monthly PreClose, PAM Close and FGL Close of the month.Providing a set of reconciliations for data received from PAM with GL data received from Oracle.For Release 2, work on the replacement and sunset of ARD (Asset Reporting Database) by replicating the data and processes in the newly designed EDSDesigned solution for data exchange with additional data sources Bloomberg, Moodys and FactsetDesigned new reporting platform to replace the existing Asset Reporting Database (ARD)Creating new capability for ARD reporting dataset combining data from various sources including PAMManage business users and stakeholders expectations to ensure successfully delivery of the projectProviding regular updates to upper management and business usersWorking with Program Manager to plan, define tasks/activities, dependencies, resource allocation.Ensuring successful delivery of project within time and budget.Environment: Erwin 9.6, SQL Server 2014, Informatica 10.1, Essbase, Tableau, MS Project, VisioJul 15 Oct 16 Enterprise Data Architect / Lead TMNAS, Philadelphia, PAWorked as Enterprise Data Architect / Lead for Tokio Marine North America Services (TMNAS), for providing services to Philadelphia Insurance Company (PHLY). As part of the PHLYs SPIRE transformation program, the Guidewire DataHub is implemented as primary data repository for all core source systems (Rapidsure, OneShield/Philly Bond System, AQS, Guidewire BillingCenter, Guidewire ClaimsCenter, Guidewire PolicyCenter and APPS). The data from all these source systems needs to be integrated into the DataHub. The DataHub will be used as centralized data repository for Reporting, Coverage Verification, Phly.com, SAP GL, ISO STAT, DMV, VIN Lookup and any other outbound integration services. The solution is being implemented on SQL Server database using Informatica and BODS (Business Objects Data Services) as data integration tools.Worked with business users and stakeholders to identify PHLYs data needs.Facilitate on-going communications to leadership teams, business leaders, Technology partners.Created the strategic layout of future EA plan. Accomplished transition plans to reach EA goals.For Release 1, sources Rapidsure and Billing Center, including lines Personal Auto, custom LOBs (Collector Vehicle, supported by Personal Auto, Fitness Studio (GL, IM), Fitness Trainer (GL) and Billing Center (Commissions, Funds Transfer, Outgoing Payments, Hold, Region, User Information Services.For Release 2, sources AQS, OneShield (Philly Bond System) and Policy Decision, for ISO Lines (GL, Commercial Auto, Property) and for custom LOBs (Surety, Excess Liability, Non-ISO GL, Non-ISO PR, IM, D&O, E&O, EPL, Cyber Security Liability, BOP (ISO based and Custom), Medical Liability, Crime, Umbrella, Manufactures Liability)Defined the to-be architecture to support PHLYs data integration and reporting needsCreated Logical and Physical DataHub Integration ArchitectureCreated Pre-Landing Zone (PLZ), identical to source, Landing Zone (LZ), pipe delimited files, for landing of source data into TRF tables before loading it into DataHub using BODS and then InfoCenter.Defined the ETL architecture for the movement of data across various systems.Policy Event Handler to log all Policy transactions as XML messages through service on Enterprise Service Bus (ESB) for all LOBs into PLZManage business users and stakeholders expectations to ensure successfully delivery of the projectProvide Guidance to various development teams to resolve issuesHelping Project manager with project planning, timelines, task dependencies and estimates,Environment: ERStudio Data Architect 9.5, SQL Server 2012, Guidewire DataHub 8.3, Guidewire InfoCenter, BODS 4.2, Informatica 9.5, MS Project, VisioDec 13 Jul 15 Enterprise Data Architect / Leader CSC (NYSDOH), Albany, NYWorking for CSCs client New York State Department of Health (NYSDOH) on the Encounters Data Project as the Affordable Care Act (ACA) requires the State Risk Adjustment and Reinsurance entities to collect claims and encounter data for actuarial analysis. The Office of Quality and Patient Safety (OQPS) identified the submission by unifying the QHP, Medicaid and CHP plan data as an intake for the envisioned Statewide All Payers Database (APD). The solution is being designed using IBMs WebSphere Transformation Extender (WTX) for EDI, Data Stage, Cognos and Oracle.Interviewed the SMEs and business users.Conducting JAD sessions to get the data requirements. Document Data Flows and Process Flows.Worked with business users and stakeholders to identify NYSDOH data needs.Working with users in identifying Tier1 and Tier2 edits to X12 and NCPDP formatted data to increase the quality of data for Post Adjudicated Claims Data Reporting (PACDR).Architected the end to end solution for Encounters Intake System (EIS)Established data modeling standards and best practices.Created Conceptual, Logical and Physical data models using Erwin for EIS from scratch.Develop new data structures to store the historical PACDR data for all the EDI X12 837s (298-Professional, 299-Institutional, 300-Dental) and NCPDP data formats for QHP (Qualified Health Plans) and MMC (Medicaid Managed Care).Defined the ETL architecture for the movement of data across various systems.Loading various data files including Member Validation data from eMedNY.Create source to target data mapping for generating the MAEE (Medicaid Analytical Extract) extract from EIS (Encounter Intake System) for MDW (Medicaid Data Warehouse).Worked with the SMEs to identify the data and reporting requirements of the NYSOH.Working on data management and data security plan for confidential and restricted information and PII.Leading and Managing the entire development team to ensure successful implementation of Database Architecture and Design, ETL Design and reporting deliverables.Environment: Erwin 9.5, Oracle 11gR2 (11.2.0.1), IBM InfoSphere Data Architect 8.1, IBM Data Stage 8.1May 11Nov 13 Enterprise Data Architect Farmers Mutual Hail Insurance, West Des Moines, IAWorking for Farmers Mutual Hail Insurance Company of Iowa (FMH) as Enterprise Data Architect for designing and implementing the Data Warehouse for their Insurance, P&C and ReInsurance lines of business. FMH is one of the leading providers of Crop Insurance to Farmers in many states across US and has P&C and ReInsurance divisions for accepting risks from both domestic and international companies. The Enterprise Data Warehouse (EDW) was designed and implemented using Astera Centerprise Data Integrator and Logi Analytics (formerly LogiXML) support their reporting needs based on their newly in-house developed system CloudNet replacing their old policy admin system eCrop.Interviewed the SMEs and business users, for both Multi-peril Crop Insurance (MPCI) and HAIL lines of business within Crop Insurance to get the data requirements.Worked with business users and stakeholders to identify FMHs reporting and data needsFacilitate the presentations, education and on-going communications to leadership teams, business leaders, Technology partners.Created the data warehouse architecture and roadmaps and got buyins from the upper management.Evaluation of various tools, POCs and Vendor selection for ETL/Data Integration and Reporting tools.Defined and document the requirements using use cases. Document Data Flows and Process Flows.Established data modeling standards and best practices and created Conceptual, Logical and Physical data models using Sybase Power Designer.Created the BUS Metrics for the various business processes across FMH and identify the Dimensions and Facts to be used across these business processes.Designed Enterprise Data Warehouse including dimensions and fact tables using Kimball methodologyCreated STAR schemas for Policy, Agency, Claims, Reserves, Financial data marts.Defined the ETL architecture for the movement of data across various systems.EDW also housed some of the historical information from retired systems (TIP, AS400), P&C (Garvin Allen) and ReInsurance (SICS).Worked with the SMEs of source systems to satisfy the data and reporting requirements of the government body RMA (Risk Management Agency), NCIS and other third parties.Conducted various POCs and user focus groups for Agents and Adjusters for getting the dashboards and reporting needs using LogiXML (Logi Info and Logi Adhoc).Identifies the reporting needs from the workflow and document management system ImageRight and its data integration needs with CloudNet.Worked on reporting needs for Geospatial and GIS information in ESRI with CloudNetWorked on variety of old systems to be retired (TIP, AS400) to move their data in EDW.Working on the data security plan for confidential and restricted information and PII.Implemented user level reporting security based on user types, roles and permissions.Helped with conversion effort from old policy admin system eCrop to CloudNet.Vendor evaluation and vendor management.Environment: Sybase Power Designer 16.5, 16.1, Oracle 11gR2 (11.2.0.1), TOAD 11, 10.5, Astera Centerprise Data Integrator 5.1, Log Analytics (LogiXML) 11.x, ASP.NET, Perforce, MS Project 2007Mar 10 May 11 Enterprise Data Architect / Project Lead Wells Fargo, West Des Moines, IAWorking for Wells Fargo at their Home Mortgage headquarters as Enterprise Data Architect/ Project lead for Sourcing work stream, for sourcing and integration of data from 40 Home Mortgage related source systems for MIDE (Mortgage Integrated Data Environment) project. MIDE project is being implemented in Teradata environment for high volume parallel processing of data to support business needs.Working as Enterprise Data Architect/ Project Lead for Sourcing Workstream leading team of 10 AnalystsWorked with the SMEs of source systems including Loan Origination, Servicing, Correspondent and Wholesale, Institutional Lending, Sales systems, etc.Meet with SMEs of source systems including LIS, LPS, AS400, PCLS, SMS, CORE, C&W Standard, IL Online, MSP/Fidelity, Phoenix, Profiler, Arrow, ACAPS, SalesLogix, CTS, AOW, ECPR, MYBOB, Oracle GL, PeopleSoft, etc.Meet with SMEs of various users to help identify what data should be sourced into MIDE.Worked on variety of source system platforms including Mainframes, Oracle, SQL Server, Sybase, extracted data files, User Maintained data, etc.Setup meetings and work with the SMEs to identify and get the system of record (SOR) data sourced into MIDE from the respective source systems.Interviewed the SMEs & business users of all the 40 source systems to get business data requirementsManaging process for loading of metadata into EMR (Enterprise Metadata Repository).Help in documenting business rules, transformations and source to target data mappings.Working with source system experts and data stewards to resolve data issues.Lead and Manage team of Data Modelers and Data Analysts adhering to budget and strict timelinesDefined Project plan detailing tasks, activities, dependencies, resource allocationEnvironment: Sybase Power Designer 15, Teradata, AbInitio, MS Project 2007, VisioMar 09 Mar 10 Enterprise Data Architect AVIVA USA, Des Moines, IAWorked as an Enterprise Data Architect for AVIVA USA on a variety of projects. AVIVA is the sixth largest Insurance group in the world in Life Insurance and Annuities. Followed the Agile methodology and worked as Data Architect / Data Modeler for the Predictive Modeling project to help business cut costs on ordering labs for Life Insurance applicants. Worked on PII and data security projects and variety of other projectsMeet with users to identify the requirement for the Predictive Modeling project.Interviewed the business users and stake holders to get the requirementsDefined and document the requirements using use cases.Document Data Flows and Process Flows.Creating Logical and Physical data models using Erwin.Supported other application data models on DB2/UDB databasesMetadata creation, management and publishing.Followed the Agile methodology for the Predictive Modeling ProjectWorked with ETL developers to load data from third party vendors.Working on the PII (Personally Identified Information) project. Analyzing various applications and identifying as well as controlling access to users.Working on various projects and involved in tool evaluation.Helping in Project planning, estimates and timelines.Environment: Erwin 7.1, Oracle 10g, DB2/UDB, Informatica PowerCenter 8.1.1, TOAD 9.6, MS ProjectMar 08 Mar 09 Data Warehouse Tech Lead MoneyGram, Minneapolis, MNMoneyGram uses packaged data warehouse solution provided by Jaros for their source system Oracle Applications. Working for MoneyGram as a Tech Lead for the data warehouse team doing business analysis and design and delivering reporting needs based of the new module AR of Oracle Applications. Got trained and used the packaged out of the box (OOB) data warehouse solution by Jaros capturing near real time Change data capture (CDC) in the ODS and nightly in the Data Marts. Used the various tools by Jaros, Jaros Analytics, IDS (Information Directory Services) for Metadata management and building the Cognos namespaces to be used by the users. Analyzed and gather Business Requirements for reporting needs and adhoc queries as well as ancillary applications. Helped to design the ODS tables and star schemas for the custom tables built in Oracle Applications to support the business functionality, etc.Interviewed the business users and stake holdersIdentify business data needs and reporting needs and obtaining sign-off from client on specificationsConducting Joint Requirements Development (JRD) sessions.Worked with the data modelers to design the ODS tables and star schemas for custom tables in Oracle Applications supporting MoneyGram specific business needs.Create Conceptual, Logical and Physical data models.Created various tables to support the data needs of the ancillary applicationsDesigned structures around basic Customer Setup for various business units Credit Management and Recovery, Legal Fraud & Compliance, Agent Servicing and Operational Support, Settlement Servicing, Product Management & Marketing, Finance and Accounting, etcDesigned hierarchies for Agent and their relationships over time, Sales Rep, etc.Help resolve the data issues by interacting with the SMEs and the business users.Worked with Informatica ETL developers for loading Near Real Time in ODS and Nightly in Data Mart.Created and maintained control tables for sourcing the data from the Oracle Applications source tables.Monitor the overall development process and made sure deliverables are on time.Used Jaros Information Directory Services (IDS) to define relationships between various entities and publish the model in Cognos Framework Manager.Used Jaros Metadata Manager (MDM) to define and maintain the metadata so it can be published by the Jaros Help System for the business users.Applied Fixes for enhancement to the OOB Jaros data warehouse solution using the Jaros Fixes ToolIdentify sensitive data elements and implement the information security policiesDecryption of the encrypted data elements in the Cognos Reports and Auditing the information both at record level and the request criteria level for PCI compliance.Environment: Sybase PowerDesigner 12.5, Oracle 10g, Oracle Applications v11i, Informatica PowerCenter 8.1.1, Cognos 8i, TOAD 8.5, 9.6, PL/SQL Developer 7.1.4, MS Project 2007, Visio, WinCvs 2.0.2.4, HP Project and Portfolio Management (PPM) v 7.1, Jaros Analytics v 3.0.3, Jaros AMDR 1.19.7July 07 Mar 08 Enterprise Data Architect EOS Airlines, Purchase, NYWorking for EOS Airlines as an Enterprise Data Architect creating Architecture and Design of new Data Warehouse. Analyzed and gather Business Requirements. Designed Star and Snowflake schemas for Guest, PNR and VCR data from the primary source system SABRE. Also worked on creating a guest database to cleanse, merge and create master guest profiles to help reporting on guest behavior, guest activity, target repeat guests, revenue/nonrevenue guests, etc.Interviewed the business users and stake holders. Defined and document the requirements.Doing business |
