We provide IT Staff Augmentation Services!

Enterprise Data Architect Resume

Tampa, Fl

SUMMARY:

Accomplished global enterprise data architect lead who leverages in - depth technology background in Insurance, banking, financial services, technology distribution, supply chain, pharmaceutical, healthcare, retail, government and manufacturing industries that outperform business growth, revenue and project objectives in startup to Fortune 100 organizations. Offer 20+ years of expert level experience in enterprise data architecture, big data, data warehousing & BI, domestic/offshore development and business process reengineering.

TECHNICAL SKILLS:

Languages:: ABAP, SQL, PL/SQL, T-SQL, UNIX Shell, HTML, Java and XML

Operating Systems:: VAX, MVS, UNIX, LINUX, MS-DOS, Windows

Databases:: HANA1.x, Netezza, HBase, Oracle, SQL Server, MS Access, FoxPro, and DB2.

Software:: SAP HANA1.x, SAP R/3 ECC6.0/5.0/4.6C, SAP Net Weaver BW/BI, SAP BI -IP, SAP BW-BPS, BEx, SAP BPC 5.1/7.0,SAP EP(6.0), SAP FI/CO, SAP SD, SAP BOBJ, SAP Solution Manager, Mercury tools, Oracle Developer/Designer tools, Hyperion Essbase, Oracle Applications Suite 11i/12, SAS, J2EE, VB.Net, Informatica Power Center, Cognos ReportNet, Cognos Impromptu, Crystal Reports, MS-Project, Word Processors, Microsoft Source Safe, Visio, MS Project, Oracle Enterprise Manager (OEM), SAS9,TOAD, Desktop DBA, SQL Station, Secure Shell, Clear Case, Remedy, Enterprise Architect, SharePoint, Team Play, XML Spy, Secureshell and Hibernate, J2EE, Actuate and Crystal Reports

Data Modeling: ERWIN, Power Designer and Oracle Designer

Middleware:: IBM WebSphere & BEA WebLogic

Hardware:: IBM Compatibles, Sun Solaris, HP-UX; VM Ware, Wintel and Mac Compatibles

Big Data Tools:: HADOOP (Map Reduce, Pig, Hive, HBase, Sqoop & Oozie), Spark & Scala and Kafka

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Enterprise Data Architect

Responsibilities:

  • Architected solutions using Hadoop, HDFS, MapReduce, HBase, Pig, Hive, Spark, Solr Cloud, Impala Cloudera packages to create big data platform
  • Leveraged Cloudera hadoop eco system for fraud analysis by combining claims data, CRM data and social media data to verify whether a claim is valid or not by checking recent activities on social media sites whenever a claim is submitted
  • Architected big data predictive analytics and data science solutions, data engineering and management data search and catalog in data lake
  • Architecture guidance for datacenter migration, Linux/Wintel server migration and data migration to Amazon AWS solutions
  • Championed Hadoop eco system configuration in Cloudera environment creating MapReduce jobs to power data for search and aggregation. Led Installation and configuration of Hadoop, MapReduce and HDFS, development of multiple MapReduce jobs in java for data cleaning and importing and exporting data into HDFS and Hive using Sqoop
  • Leveraged Cloudera hadoop eco system for fraud analysis by combining claims data, CRM data and social media data to verify whether a claim is valid or not by checking recent activities on social media sites whenever a claim is submitted
  • Created data governance framework for master data (customer, prospect and products) across corporate functions
  • Led governance awareness workshops and formed governance steering committee with the business and technology stakeholders
  • Instituted Data Conversion, EDW & Reporting strategy workshops with ALG business team and data stewards to define the end-to-end process for Data Architecture, Data Governance and Data warehousing and reporting
  • Led Data Conversion, Data Warehouse and Reporting work streams for Guidewire implementation for P&C line of Business. Enterprise data architecture support for Guidewire Insurance Suite - Claim Center, Policy Center, Billing Center and Contact Manager as well as downstream systems Data Hub and Info Center
  • Defined data strategy, source data analysis, current, transition and end state architecture; staging, ODS - for operational reporting, EDW - enterprise data warehouse and OLAP design and development
  • Conducted EDW requirements workshops and gap analysis for P&C LOB to leverage Guidewire Data Hub/Info Center Out of the Box data elements and KPIs
  • Developed logical and physical dimensional data models for the MC Camish Life and Annuity products for ALG LOB utilizing Ralph Kimball methodologies
  • Developed the framework and data models for EDW, ODS and data marts for several business unit subject areas to support statutory, regulatory and ADHOC reporting and analysis for Actuaries.
  • Championed Reporting EDW and Reporting framework SQL Server Enterprise Edition utilizing SQL Server 2012/2014, SSRS, SSIS and SSAS

Technical Environment: Guidewire Insurance Suite 8.1 - Claim Center, Policy Center, Billing Center, Contact Manager, Data Hub and Info Center Oracle 10g/11g, SQL Server 2008/2012/2014, SSRS/SSIS/SSAS, Sharepoint, SAP BODS, Cognos, SQL * Plus, PL/SQL, Informatica Power Center 9.1, MS Project, Sun Solaris, Windows 2007, TOAD, XML, Erwin 7.5, MS Office, Visio, Unix Korn Shell, Windows 2007, Hadoop ECO system(Pig & Hive),TOAD, XML, Erwin 7.5, Unix Korn Shell. SAP BI 4.1(Crystal Reports)

Confidential, St. Petersburg, FL

Enterprise Data Architect

Responsibilities:

  • Big data analysis and data acquisition from Hadoop Big Data ECO system using PIG & HIVE for unstructured and semi structured data. Enhanced data warehouse using Hive. Worked extensively with Sqoop for importing metadata from Oracle. Extensively used Pig for data cleansing. Created partitioned tables in Hive
  • Created HBase tables to load large sets of structured, semi-structured and unstructured data coming from UNIX, NoSQL and a variety of portfolios
  • Defined, developed and executed data architecture principles & procedures, data modeling, Enterprise Data Warehouse, Operational Data Store (ODS) and reporting data marts
  • Led blueprinting workshops with cross functional process teams and data stewards to define the end-to-end process for Data Architecture, Data Governance and Data warehousing. Implemented data governance processes for master data across corporate functions
  • Led the requirements gathering, data map and gap analysis for the global regulatory reporting project by collaborating with business partners and technology partners
  • Established enterprise data architecture, data warehouse best practices and standards; database, ETL and BI architecture and performance tuning techniques, design/develop dimensional data models and ETL processes
  • Led source data analysis, staging, ODS - for operational reporting, EDW - enterprise data warehouse and OLAP design and development. Conducted data analysis and compliance reviews to make sure the customer sensitive data is properly secured before sending to the data consumers Risk, AML and marketing teams
  • Developed logical and physical dimensional data models for the enterprise data warehouse and data marts utilizing Erwin Data modeling tool. Modeling techniques include transactional (OLTP) and dimensional (OLAP). Led the data warehouse dimensional modeling utilizing Ralph Kimball methodologies. Developed the framework and data models for EDW, ODS and RDMs (reporting data marts) for several business unit subject areas to support the regulatory reporting requirements.
  • Designed and developed database driven framework utilizing Oracle and PL/SQL for reusable complex ETL rules engine automation to significantly reduce onsite and offshore ETL development time by 80%. Led ETL design, development and support activities for Informatica Power Center ETL framework, mappings, sessions and workflows.
  • Created data models to support drill down and drill-back capabilities in reporting data mart (Oracle) and ODS (Netezza)
  • Built several high performance views with data insensitive business rules in Netezza VLDB to reduce ETL development time and improved performance
  • Ongoing enhancements to EDW utilizing Oracle, PL/SQL, ERWIN and Informatica
  • Collaborated with production support and client operations group to resolve the production support issues and improve the quality of the software product. Migrated legacy data into distributed EDW - Oracle and Netezza databases

Technical Environment: Oracle 10g/11g, SQL * Plus, PL/SQL, Informatica Power Center 9.1, MS Project, Sun Solaris, Windows 2007, TOAD, XML, Erwin 7.5, MS Office, Visio, Unix Korn Shell, Windows 2007, Hadoop ECO system(Pig & Hive) TOAD, XML, Erwin 7.5, Unix Korn Shell.

Confidential, CA

Global Process Lead

Responsibilities:

  • Defined/executed strategy, global standards, governance and SOPs. Delivered project scope, project plans and key deliverables; managed scope; achieved milestones; collected and analyzed program metrics
  • Designed strategy for Data Governance and Master Data. Designed and implemented Global Data Synchronization, and MDM architecture including Data Modeling with conversion and security configuration
  • Developed short and long-term master data management strategies for our current roll-out. Planning and developing as well as executing data conversion techniques.
  • Driving user acceptance test planning and execution, performing as a key member of project teams through all phases (blueprint, realization, go-live, roll-out, and post implementation) of support.
  • Leveraged deep understanding of SAP master data and BI/MDM technology to design a solution that addressed several complexities.
  • Identified the major business objects to which Enterprise Services should be analyzed and defined
  • Established the method of data format and integration from an Enterprise Services perspective for these identified business objects
  • Identified and recommended data cleansing approaches to be used. Described and identified the solution deployment approach across applications. Recommended, with input from the client, the most feasible strategy to be used
  • Document the Master Data Conversion Strategy incorporating Data Harmonization and Integration requirements/Issues
  • Formed KPIs based on the business requirements regarding Business Intelligence. Defined the proposed Governance Organization Defined Data Governance procedures based on the Data Governance Organization Helped the client, put in place the Senior Governance strategy and procedures for better controls
  • Championed global, regional and local BI reporting templates on-time and with a budget savings of $2.5M to support Finance, Procure Pay, Order to Cash, Finance, Supply Chain Execution, HR & MARKETING business processes
  • Leveraged SAP standard business content from SAP FI/CO, SD, MM, PP, APO, HCM and SEM modules utilizing SAP BI and Business Objects for 136 business critical global templates with 150 KPIs to improve gross margin by 25%
  • Reengineered 15+ vendor/customer interfaces, increasing visibility, expanding functionality and 35% cost savings.
  • Migrated legacy data to SAP BI system, provided transition reporting and legacy decommission plans; achieved 50% productivity and $5M hardware cost savings
  • Standardized common metrics, KPIs, dashboards and scorecards and reporting tools across 4 regions and 35 countries

Technical Environment: SAP BI 7.0, ECC 6.0, SAP SRM 5.0, SAP MDM, SAP CRM, Oracle 10/11g, SQL * Plus, SQL *Loader, PL/SQL, Informatica Power Center 8.3, ERWIN, Business Objects XI R3.1, SAP R/3, SAP BW, MS Project, Sun Solaris, Windows 2003, Windows XP, Erwin, MS Office, Visio, Trillium and, BOA(Back Office Associates)

Confidential, Irvine, CA

Sr. Manager, Enterprise Data

Responsibilities:

  • Standardized KPIs, dashboards/scorecards for corporate performance; Developed, coached and motivated team members.
  • Championed 3K+ user EDW & BI platform to significantly improve profit margins. Leveraged effective management of onshore/offshore resource mix; achieved 60% time to deliver and 50% savings.
  • Championed KPIs, operational/analytical reporting, strategic dashboards & scorecards to enable performance management.
  • Built and managed matrix, US/international teams supporting IT, operations, sales/marketing, HR, finance and service.
  • Managed all initiatives to defined metrics and within budget. Demonstrated and satisfied commitment to meeting all SLAs.
  • Led the data modeling, master data management, data standardization and stewardship, information integrity and compliance, data quality management efforts globally.
  • Instituted BI standards/best practices for Oracle & SAP BI data models & queries, Informatica extractors, and Cognos BI framework models.
  • Established global reporting templates for AOP, Sales, Inventory and Marketing planning and several strategic dashboards with plan and actuals.
  • Instituted global reporting strategy; BI governance process for Finance, Retail, International and other business units.
  • Conducted blueprinting workshops with cross functional process teams and data stewards to define the end-to-end process for master data and BI Reporting strategy.
  • Drove user acceptance test planning and execution. Led the project teams through all phases (blueprint, realization, go-live, roll-out, and post implementation) of the projects.

Technical Environment: Oracle 10g, SQL * Plus, SQL *Loader, PL/SQL, Informatica Power Center 8.1, ERWIN, COGNOS ReportNet, SAP R/3,SAP ECC 4.6/6.0, SAP BW3.5/BI7.0, MS Project, Sun Solaris, Windows 2003, Windows XP, Oracle Enterprise Manager, TOAD, XML, XML Spy, Erwin 4.1, MS Office, Visio, Linux, Unix Korn Shell and First Logic

Confidential, St. Louis, MO

Vice President /Principal Data Architect

Responsibilities:

  • Established data architecture and BI best practices, standards and data models; recommended data warehouse and reporting performance-tuning techniques. Mobilized and directed BI professionals and offshore development team of 30+.
  • Generated 80%+ performance gain for enterprise BI systems and by strengthening OLAP database systems.
  • Instituted end-to-end technical guidance and end state roadmaps for Sales & Marketing, Correspondence Analytics & Servicing and Broker and Correspondence data marts.
  • Partnered with stakeholders to identify business problems and develop state-of-the-art solutions aligned with business objectives. Provided data warehouse & BI technology vision, roadmaps and blue prints and project plans.
  • Formulated and executed corporate roadmaps to ensure compliance with SOX and corporate governance criteria.
  • As member of executive Change Control Board, developed and refined repeatable framework/processes. Consolidated BI reporting technologies to increase project/program value proposition.
  • Saved $1.7 million annually by consolidating servers/databases and leveraging enterprise licensing agreements.

Confidential, Dallas, TX

Project Lead

Responsibilities:

  • Instituted end-to-end technical guidance for the EIM data warehouse project for Confidential
  • Drove analysis/design efforts of Loyalty Intelligence Database (LIDB) using Kimball's data warehousing methodologies
  • Promoted to advance the development of Loyalty Solutions Platform . Guided company through 5 subsequent releases
  • Directed highly skilled team of 15+ professionals in the US/India; attained unprecedented employee retention rates
  • Led strategic planning, development of product roadmaps and technical/architectural project reviews
  • Recognized by Chamber of Commerce as well as Confidential, Confidential, Confidential and Confidential for excellence
  • Defined, developed and executed strategy for launch of robust, industry-1st, Oracle-based CRM/BI solution

Confidential, Silver Spring MD

Senior/Lead Programmer Analyst

Responsibilities:

  • Full life cycle development and implementation of client-server and data warehouse systems for key clients including Confidential, Confidential & Confidential and Confidential .

Hire Now