Data Architect/Lead

Venu Venkata Kasi Yakkala- Visa–US citizen Lead/Data Architect/Data Governance/Big Data/BI/Data Science/AWS

+1-201-***-**** Email:******@*****.*** https://www.linkedin.com/in/venu-v-kasi-yakkala-295a8141/

Over 20+ years of experience in IT –Interact with Business users/Clients/Architecture Teams and Analysis, Design, Data modeling, Data Architecture, Data Integration, Data Governance, Reference/Master /Meta Data Management.

Expertise in Data Lake/Data hub architecture design and implementation.

Lead/Mentor a team of Data modelers/Data analysts/ETL/BI resources

Implemented Kimball, Inmon data warehousing methodologies and various design patterns.

Create data models for CDW, CIF, relational(3NF), ODS/EDW, dimensional and Fact tables.

Define data model standards, create a framework to implement data standardization and data quality rules, metadata management, reference data architecture at enterprise level.

Familiar with Data Science (Python, R), Big Data, AWS Cloud technologies/ Cloud data warehouse. (Redshift, Snowflake).

Knowledge in Data Vault design, NO SQL, Columnar/Document database.

Worked on various BI/Data Visualization tools.

Familiar with Acord, IIW, IAA industry data models.

Good team player/planner/initiator/Analytical and presentation skills vision and work proactively.

Evaluated various BI and MDM tools, develop strategies/develop and present POC and blueprints.

Familiar with SOX compliance, proficient in Agile, Waterfall, and Iterative methodologies.

Business Domain Experience- Insurance, Investments, Banking, Retail, Healthcare, Pharma, Telecom, and Shipping.

PROJECT PROFILE

Client : New York Life Insurance - Clinton, NJ USA July 2015 - Current

Project: : Enterprise Data Lake (Big data, AWS, Cloud data warehouse)

Title : Lead /Data Architect

Desc- Objective is to create a single enterprise level data lake across organization with data governance process. Data lake will become a source for all downstream need which includes/predictive analytic, data science/BI reporting.

Data Domains- Life/Annuity/Disability/Funds/Shares/Securities.

Party (Agent, Client, Health care providers, Vendors), Underwriting, Policy, Annuities/Life/Disability, RX/MIB/Lab reports/Medical/Health records, Actuarial, Reserves, IVR call logs/Customer service, Campaign, Marketing, Reinsurance, Regulatory data, Financial Ledger transactions (SAP), Sales force data.

Roles:

As part of enterprise architecture team to define data strategy/data integration approaches required for Data Lake.

Lead data modeling/data architecture activity -Enterprise domain modeling, Taxonomy, Create/assist Data modeling/Data standards and quality rules/enterprise data models/meta data management. Align data strategy as per business needs.

Work with data governance /ETL/BI developers/Business partners/Micro-services /Data science teams/Review QA strategy.

Working on AWS Cloud migration/Cloud data warehouse (Snowflake and Redshift) initiative.

Plan, Analyze, Design, mentor, create/review enterprise data models and source to target mapping documents, integrate data from various external vendors/data providers/cross domains. Work with onshore and offshore vendor teams.

Env: Big data, Erwin, Horton works HDFS, HIVE, Sqoop, HQL, PySpark, Python, Kafka, Nifi, MuleSoft, AWS Cloud, Dremio, Tableau, Power BI, Protegrity, Oracle, Dynamo DB, SqlServer, Postgress, Data Stage, Informatica IDQ/AXON Data governance), Syncsort, JSON, XML and Tibco EBX(MDM), Snowflake Redshift, Sales force, SAP, Rally and Jira.

Client – Acord (NYC) - Worked with Acord on part time basis as a freelancer to validate generic Erwin data models against UML class diagrams. Updated XML data models for Party domain.

Tools- XML Oxygen, Magic Draw, Erwin.

Client : BED BATH AND BEYOND -- NJ USA NOV 2014 – June 2015

Project : Supply Chain (Retail), Payment Fraud Management

Title : Lead/Data Architect

Desc- It is Data integration project and different layers are EDW, Enterprise Foundation layer (EFL) and EDE.

Roles: Interact with Business users, Analyst/BI teams, work with Architects/Data modeling team. Understand requirements, Sources, Analysis, Data profiling, Create/Update modeling standards docs/Logical and Physical data models, review with project teams, resolve data quality issues.

Env: DB2, Teradata, Kognitio, Erwin 9.4, XML, XSD, Unix, Micro Strategy, External (Cybersource, Quantisense), Visio

Client : AIG – NJ/Houston APR 2014 - OCT 2014

Project: : Different projects in L&R IT Department

Title : Architect Senior Specialist (Data Modeling/Data/DW Architecture/Data Governance)

Description: Working as part of architecture group for Life and Retirement Department.

Roles:

Worked as part of Architecture/Data Governance groups, discuss, and define data warehousing/data architecture, data modeling design patterns/methodologies/process/standards (ACORD Naming), finding authoritative sources, data classification, compliance, Security, Standardization)/DMM (Data Maturity model).

Review and provide sign off on architecture/processes/Data Models developed by different vendors.

Translate requirements into logical/physical data models, Create Data Dictionary/Data Mapping. Resolve Data quality/extraction issues and data mapping (source, target, transformation, exception handling rules) query.

Env: Oracle, DB2, Sql Server, IBM Tools (IIS, Data Stage, Information Analyzer, Data Quality Stage, Infosphere MDM, Metadata Workbench), Tableau, ERWIN, Teradata, Visio and Unix.

Client : CIGNA, PHILADELPHIA (Aug 2012- MAR 2014)

Project : CGM FI (Medical records/Health care Payer, Insurance Policy, Claims, Payments/Adj, Security)

Title : Lead Data Modeler/Architect

Description: Integrate data from different source systems and sunset legacy, other source systems and feed the data to downstream systems (OFAC, TIAA-CREF, EOBs, Reserves, Disbursements, reporting need).

Roles:

Work with architecture/cross functional teams and design future state of strategic and enterprise level solution.

Discuss on priorities and plan of data volume, data migration, data archive and data loading strategies.

Work with business users/analyst about requirements, data profiling results, logic, business use cases and gaps.

Analyze, Design, Data architecture, translate requirements into data models, conduct JAD sessions and review data models with project teams, assist and guide other data modelers, ETL, data analysts and BI teams.

Worked part of data governance teams; maintain and improve data modeling process/guidelines/standards.

Create/maintain conceptual, logical/physical data model of ODS and OLTP.

Maintain/create Data dictionary/ER diagram reports, naming standards, control DDL execution/security/Data model version controlling/data model management, sync up data models/db structures in diff Envs.

Assist, discuss and resolve mapping/data integration queries, transformation logic, data anomalies/data quality issues, parallel/sequence/incremental/bulk data loads, create XSDs, read/map data element from XML in CLOB.

Env: Oracle, Sql Server, DB2, XML, Erwin, Model Mart/Manager, Data Stage, Mainframe, SSRS.

Client : Pfizer Inc, Madison-NJ (Jan 12- July 12)

Project : CORE BI (Clinical Products, Sales, Sales Force, Marketing and Inventory)

Title : Data Modeler/Data Architect

Description: Integrate data from different clinical products, business divisions and multi markets. Compare actual vs forecast/target values vs against competitors and measure Sales force performance.

Work with business users to understand multi market requirements. Worked as part of architect/data governance teams to discuss, decide and assist on architectural design, project roadmap/tasks, standards and procedures.

Created data acquisition strategy and decided file layouts required for incoming data from markets.

Architect, create and maintain Logical/Physical dimensional and Relational data models.

Env: BO (BOBJ), Informatica, Erwin Data Model and ER Model Manager 7.3, Oracle.

Client : Prudential Insurance, Newark-NJ Jan 11- Dec 11

Project: IMBI Data warehouse for Annuities (Funds, Payouts, Fixed/Var Bonds, Agreement, Reserves and Projections)

Title : Data Modeler/Data Architect

Description: CDW to integrate data from multiple source systems, CDW feed the data into down streams/ Data marts..

Worked part of architect team and discussed on architecture, vision, roadmap, future state and strategy.

Reviewed/modified industry data models of IBM Accord, IIW and IAA as per our requirements.

Created enterprise Conceptual, Logical and Physical data models of CDW (3 NF) and Data Marts.

Design data structures required for different incoming and outgoing feeds and Master data consolidation

Worked as part of stewardship/Data Governance team to decide logical/Physical naming standards and also maintain data dictionary and certain standards. Created and followed data model standards.

Env: ERWIN 8.0, Cognos, Oracle, XML, SAP, Informatica 8 (Power center, IDQ) and UNIX.

Client : ADP (Automatic data processing), Roseland- NJ Oct 09- Dec 2010

Project : Data warehousing BI reporting system (HR, Payroll, Time Entry)

Title : Data Modeler/DW/BI /ETL

Description: It is multi-tenant based BI application used by several clients of ADP.

Roles and Responsibilities:

Analysis, design, architecture, define roadmap, specs preparation., data modeling and create mapping doc

Created Conceptual, logical and physical dimensional data model, confirmed and degenerated dimensions, slowly changing dimensions and Fact tables, review and assist with project teams.

Created XML data models and generated XSD/DTD file required for Web services/SOA applications. .

Worked with different BI vendors (OBIEE, IBM Cogon, evaluating BI tool and designing BI prototypes and show tool capabilities and presented POC.

Env: ERWIN 7.3, Sql Server, Cognos, OBIEE, Oracle, Informatica MDM, XCase, XML, LDAP and Golden Gate.

Client : NYK Lines, Secaucus-NJ (Apr 2005- Sept 2009)

Project : MIS (Data warehousing application)

Title : Data Modeler/BI/ETL

Description: Objective to sunset legacy systems and integrate the data required for MIS reporting.

Requirement procurement, analysis, data modeling of OLTP, ODS (3 NF)/ CDW, Dimension and Facts.

Create conceptual, logical, and physical of various stages of data models; different (daily, snapshot, accumulated) data marts and confirmed dimension tables in star schema, bridge tables and hierarchies within dimensions.

Lead the team and managed their deliverables, schedules, and priorities.

Env: Erwin, Trillium, Oracle, Sybase, Sql Server, Teradata, XML, Sun Solaris, SAP, DB2, ODI 10.x, Visio, Cognos

Client : Hewlett-Packard, Singapore (Feb -2004 to Feb 2005)

Project : Senior Data Warehouse Consultant

Description: DW project captures Sales/Marketing information (telemarketing/internet/campaigns and programs).

Created tech specs/Data flow diagrams/Data dictionary, created data models

Informatica: Created Repository, mappings and transformation and Workflows, schedule jobs in TIDAL.

Developed BO Universe creation (dimensions, measures and prompts), thick client and thin client in BO and WEBI.

Env: Informatica, DTS, BO, Erwin, VBA, SQL Server, Sql Server Analysis Services (SSRS), Oracle, TIDAL.

Client : Nokia – Singapore (Nov ‘2002 to Jan‘2004)

Project : Claims management and tracking repairs - Senior System Analyst/DW Consultant

ETL and BI Development.

Env: Informatica, Business Objects 6.5, IIS, Oracle, Sql Server, Cognos 6.5/7.

Client : CITIBANK – Singapore, Programmer Analyst (Nov’01 –Oct’02)

Project: FXLINK (Foreign exchange) - Online Foreign exchange transactions and BI reports.

Development of Bo Universe and Webi Rports, shell/UNIX scripting and Java

Env: Sun Solaris, Business objects, JSP, Servlets, XML, XML SPY, Iplanet, Jrun, IIS, Web sphere, Oracle.

NCS (National Computer Systems) – Singapore (Mar 99- Oct 01)

Proj#1: Payment Gateway System (Credit Card)-Study and design and development using Cold fusion Java and Sql server.

Proj #2- Prepaid/Postpaid Management billing system (Telecom) - Java, Java script and Crystal reports development.

Project#3: Online travel web site - Design, development, testing using Vignette, story server and TCL.

Env: O/S: Windows NT, S/W: IIS, Vignette, Story Server 4.2, 5.0, SQL Server 7.0, HTML, JavaScript, Tcl.

New Era Information technology, India (Sept 97 to Feb ’99)

Project #I- Payroll System Client – Design, Development and testing of VB applications, AS/400 and COBOL/400.

Project #2 - Inventory– Code and reports dev using Visual Basic 6.0, SQL, Crystal reports.

Contact this candidate