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, BIGDATA, data warehousing & BI, domestic/offshore development and business process reengineering.
• Expertise in diverse industry verticals including insurance, financial services, banking, technology, telecom, pharmaceutical, healthcare, retail, government and manufacturing and ERP functional areas like Supply Chain, Financials, Order to Cash and Procure to Pay.
• Expertize in Guidewire Insurance Suite implementation strategy of Data Hub, Info Center; legacy data conversions to Claim Center, Policy Center, Billing Center.
• Highly talented in architecting, designing and implementing high performance data warehouse and BI systems for structured, semi structured and unstructured enterprise data utilizing latest technologies including Hadoop, Netezza, Oracle, SQL Server, Microsoft BI Suite, SAP BI/BW, Cognos, Informatica and Business Objects to name a few.
• Experienced in BIGDATA data modeling techniques. Design, development and support of Map Reduce, Pig, Hive and Scoop in Cloudera Hadoop ECO Systems
• Instituted policies for data integrity, data security, data compliance/regulatory compliance, data ownership and data standards for Fortune 100 clients
• Expert level data architect with extensive database system analysis, design, and implementation experience. Led several full SDLC for database projects using every common type of data store - transactional (OLTP), data warehouse (Kimball), Data Mart (OLAP), Operational Data Stores(ODS) and Data Integration Using ETL, EAI, and EII tools to create an Integrated enterprise.
• Extensive experience in requirements gathering and business rules analysis using a variety of techniques and artifacts, conceptual/logical/physical database modeling, model validation/business rules traceability analysis, “as-is” vs. “to be” data modeling, gap analysis, and meta-modeling.
• Hands on database system design and development experience to include stored procedure construction and testing, extraction/transformation/loading (ETL) design and implementation, OLAP cube design and construction, persistence and business logic layer development, report development, database system troubleshooting and performance tuning, database configuration and administration (e.g. DBA tasks), and application testing.
• Frequent trainer in data modeling techniques, skilled in team leadership/mentoring/training, workshop facilitation, acting as a liaison between business users and technical staff, and coordination of offsite (e.g. offshore) development efforts regardless of the chosen development process (waterfall and scrum).
• Data governance, data cleansing and house holding of data utilizing Trillium and First Logic software.
• Expert in major databases, data modeling, ETL, ERP and BI technologies that include:

TECHNICAL SKILLS:

Big Data: Hadoop, Map Reduce, Pig, Hive and Sqoop

Databases: Oracle, Netezza, SAP HANA, SQL Server, DB2 and MS Access.

Oracle tools: SQL* Plus, SQL* Loader, Import/Export, PL/SQL and OEM

Data modeling tools: ERWIN, Power Designer, Oracle Designer and Visio.

Data cleansing tools: Trillium and First Logic.

ETL tools: Informatica as well as custom ETLs with PRO*C, PL/SQL, Shell and PERL scripts;

ERP tools: Oracle ERP, SAP R/3 & ECC 6.0, SAP BI, SAP CRM and SAP MDM

Business Intelligence Tools: SAP BW, SAP BI(Business Objects), Cognos, Actuate and SAS

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

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Enterprise Data Architect

Responsibilities:

• 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.
• 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.
• 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.
• Led development of Hadoop streaming jobs to process terabytes of data. Involved in creating Hive tables, loading with data and writing hive queries and automated all the jobs for pulling data from FTP server to load data into Hive tables. Integrated and analyzed unstructured data a data warehouse using Hive
• Leveraged HADOOP BIGDATA 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.
• 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, SSRS and SSAS.

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, SSRS/SSAS, 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.

Confidential, Tampa, FL

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.
• 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.

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, Santa Ana, CA

Global Process Lead - Enterprise Data

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. Data Integration, Conversion and Harmonization:
• 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 Business Intelligence Strategy
• 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

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. Project 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.

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:

• Correspondence Analytics & Servicing Data Mart - Led the requirements analysis, Operational Data Store (ODS) and data mart design, dimensional data modeling, Infrastructure and database sizing, design and code reviews. Provided end state road maps to Correspondent and Servicing data marts.
• Access database conversion - Introduced the enterprise wide solution for these growing Access database problems to convert into ODS and building datamarts to address immediate and future business needs for various business units like Retail and Wholesale Lending Channels. Retail Lending alone achieved 70% productivity gains.
• EIM Data Warehouse project - Instituted end-to-end technical guidance for the Corporate Enterprise Data warehouse that includes requirement analysis, feasibility study, vendor evaluation, infrastructure and resource requirements, ROI calculations and technical guidance to the development teams. Championed ETL processes, database design and code reviews, Championed for 200 million record, 40 feed, data and piped parallel, batch, initial and incremental load; email, telephone, name & address hygiene, and matching, scripted ETL processes to populate and select candidates from ODS schema at address, household, and individual level using the Trillium Software System v7.0-7.5, Oracle 9i SQL, and Unix Korn Shell.
• Get Healthy Initiatives - Championed several Get Healthy initiatives to improve CREST systems performance. Improved Pricing Engine and Fees Engine performance by 80% and CFI originations system and Citi Mortgage web site performance by 70-80 %. Improved CREST data warehouse performance by 60 - 80% after rewriting the queries, adding necessary indexes and changing the oracle initialization parameters.
• SkipJack - Provided architectural guidance that includes Infrastructure requirements, sizing and database and application design. As a Change Control Board member, conducted design and code reviews to enforce CREST development standards and best practices within the Chesapeake Title Company business unit.
• Exstream Content Management Project - Led this major CREST servicing initiative that brings statement generation in-house. Conducted requirements review and analysis, product selection, vendor evaluations and several POCs. Introduced enterprise wide Content Management Roadmap. Saved $5M annually and generated $10M new revenue..
• Principal Residential Mortgage Conversion - Provided architectural guidance for PRMI systems integration projects with CitiMortgage that includes servicing and originations portfolio conversion and several web sites integration.
• Investor Reporting project - Instituted the project team to in corporate corporate information security policies and standards, CMTPM standards and data model standards for data persistence.
• Research and Position papers: Published several research and position papers that include PL/SQL Best Practices, Oracle 9i New features for developers and DBAs, QRM Process improvements, CREST database Development Standards, Actuate Report performance improvements and Mortgage Data warehouse performance improvements. SOE ID integration with CREST Applications, Position papers on Oracle as RDBMS, Trillium as Data Cleansing Tool, Exstream as document generation software, Xenos d2e vision as content splitting and generation tool.

Environment: Oracle 9i/10g, PL/SQL, Informatica, COGNOS, SAS 9, SQL * Plus, SQL *Loader, MS Project, IBM-UNIX, Sun Solaris, Windows NT, Windows 2000, Oracle Enterprise Manager, UNIX Shell Scripts, ERwin, Actuate 7, J2EE, TOAD, XML, XML Spy, Exstream Dialogue, IBM WebSphere, Secureshell and Hibernate. Erwin 4.1, MS Office, Visio, Unix Korn Shell, and Trillium

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 American Express, Confidential, Best Buy and GE for excellence.
• Defined, developed and executed strategy for launch of robust, industry-1st, Oracle-based CRM/BI solution.