Venkata Kola Email and Phone Number

● Designed ODS structures and data mart star schemas and snowflake schemas.● Developed best practices for data remediation, naming standards and standardization.● Identified data inconsistencies and recommended corrective actions.● Built Conceptual Data Models, Logical Data Models and Physical Data Models followed by walk throughs with the stakeholders. ● Created and maintained metadata structures, data definitions, data models and data flow diagrams● Created and maintained Data Dictionary and source to target mapping documents● Assisted in development of technical specifications based on business requirements● utilized ETL strategies for data modeling● Worked well with clients, management, technical and development teams in meeting deadlines● Used the CSG Media & Telecom COTS package● Created Data Engineering and ETL proof of concepts in Azure Synapse and Data Factory. ● Provided support in the migration activities of moving from erwin 9.7 erwin 2020● Provided support in the migration activities of moving from erwin 2020 erwin 12.1 to erwin 12.5

● Worked at American Water, in Philly through APP Orchid a California based AI startup. ● Designed target to-be data model using IDERA ER/Studio Data Architect 18.0.1, involved understanding the as-is Salesforce application. created a source to target data element mapping document.● Designed developed a to-be logical data model, physical data model, conducted a walk through with the client’s team and got sign-off on the data models. ● Created the database in PostgreSQL 9.6.16, I wrote Postgres SQL scripts to load data from Salesforce as-is application to the to-be database and supported the app dev team on the database schema I designed.● Additional tasks - documenting App Orchid proprietary AI platform Catalog using Asciidoctor, an open source, Ruby-based text processor used for technical documentation of software products. ● Responsible for the reverse engineering and forward engineering of several client data assets including maintaining the proprietary platform physical data model on which a lot of AI (Artificial Intelligence) was being developed.● Tools: Salesforce classic Enterprise Edition, PostgreSQL 9.6.16, ER/Studio Data Architect 18.0.1, pgadmin 4, unix, asciidoctor, visio for data architecture diagramming.

● Support the reengineering/implementation of CDE organization and school directory dimensions● Requirements, design, develop ER models, LDM and PDM of as-is and to-be● Validating org and school directory dimensions, used Oracle Data Modeler, Toad, Informatica

● Individual Disability Insurance (IDI), Hyatt Legal service, Big Data Insight project - Large Insurance client. ● Analyzed business requirements, translating them to data requirements and developed application logical and physical data models. Created a Data Dictionary● Identified and promoted best practices and patterns for data modeling and provided oversight for data modeling methodologies and processes.

● My role was that of a Senior Data Modeler on the contract to the FEDERAL AGENCY, in cleaning up, building and maintaining FEDERAL AGENCY enterprise logical data model (LDM) repository for the Data Standards Implementation department.● Provided data architecture support to Unmanned Aircraft Systems (UAS), aided in needs analysis, development of logical data models, walk through with business stake holders and securing a buy in. ● Supported various activities that led to creation of data standards, proposals, implementation guides etc. for subject areas such as Visual Resources Management (VRM), Cultural Resources Management (CRM), Wild Horse Borough (WHB), SIGNS, TMAP, etc. ● supported in the migration activities of moving ER-Win 9.6 to Erwin 9.7 ● Used Informatica power center ETL tool to load test data into the WHB test environment database ● Wrote SQL and PL/SQL scripts to load heterogeneous data into stage tables. ● Used Tortoise SVN code version, Informatica Power Center 9.6.1, Oracle 11g and MS SQL Server.

● Led a team of technical staff to build a Data Ware house and move several data sets into it, so that OQR could provide SEC staff access to investment adviser, mutual fund and hedge fund data.. ● Requirements, analysis, design and development of an overall technical approach, architecture and the technical solution, support and troubleshooting project dealing with Hedge Funds, Mutual Funds MBS (Mortgage backed securities) and Investment Advisor data assets from prominent vendors like Lipper, Eureka, Barclay, HFI, HFR, Morning Star, Pertrac, MBS data, Blackbox Data, Moodys and Equifax data sets. ● The outcome of the project was an Analytics platform to be used by the SMEs and business users of the financial Instruments. Oracle, Hadoop and Netezza were the target and source.

● Project scope was to provide analytical support for the enterprise architecture (EA) initiatives of Forest Service (FS) CIO Planning, Information Management and Architecture Division (PIMA) Division. ● My roles was to support FS Enterprise Architecture roadmap and related initiatives around Conceptual Logical & Physical data models, data dictionary, data Flow diagrams and data artifact retention plans, Data Lifecycle Management (DLM). ● Conducted market survey of EA Tools like Mega, SPARX, Adaptive, Troux, Alphabet and System Architect by interviewing the EA Repository Tool vendors and analyzing the resulting data using techniques like Rank Score Analysis.

● Project involves modeling Financial Credit data requirements using Embarcadero ER Studio in the CDR (Credit Data Repository) project. ● Responsible for collecting data elements for MDM (Master Data Management) and making sure that Meta Data information is complete in the modules worked.

● The program focuses on all aspects of mortgage servicing and aligns with the overall objectives of the Servicing Alignment Initiative to improve Servicer performance through defined metrics, benchmarks, requirements, financial incentives, and compensatory fees. ● Reverse engineered the ETL code (Informatica) into the BRS (Business Rules Spreadsheets)● Delivered about 100 BRSs which included Fact and Dimension table business rule spreadsheets.● Performed Data Analysis, Data cleansing rules etc. DB2 & SQL Server were the RDBMS.● Developed source to target data mapping document.

● Mortgage Loan Origination and Servicing. The project was focused on the integration of the existing ING’s Orange Data Warehouse with the Capital One Financial Data Warehouse and around Mortgage “Stress Test” and enhancement of credit risk methodology to maintain Basel II standards. ● Worked with identified business users to define data requirements. ● Defined corporate metadata definitions for all Enterprise Data supported databases.● Developed source to target mapping spreadsheets ● Developed logical and physical data models that document source data from multiple sources (Client’s internal data systems, external source data systems, 3rd Party Data, Prospect Lists, etc.). ● Defined and developed designs to support departmental and functional data marts. Provided input to data modeling and physical database development standards with the Data Modeling Team. ● The project involved working in an agile development environment.● Supported loan origination system (LOS) which was built on SQL Server 2012, was involved in supporting, enhancing, and analyzing existing business applications like LOS.

Data Modeler/Analyst - Siebel Integration NYCHA NY ● The NICE project is a large complex COTS implementation; while it mainly focuses around Siebel - the solution integrates many other packages such as IFP, UCM, Global Bay, Oracle applications, Maximo● Managed a team of five off-shore Siebel Development resources during Design and Analysis phase of the project. ● Responsible for the issues and risks management and resolution● Responsible for Data Modeling for Conceptual, Logical and Physical models for PCR● Responsible for the review of DADs (Data Applet Design Documents), Operational Level Processes● Responsible for updating the PMO with Consolidated weekly Status.TSA, Annapolis Junction, MD | Data Analyst/Sr. Data Modeler ● The project involved enhancing the current Consolidated Screening Gateway (CSG) application to accommodate multiple enrollment providers.● Designed, developed and tested migration of documents and letters (appeals, waiver request etc.) into the CSG system. Made sure that NIEM data standards were followed while building the various data models on the project as well as related documentation.FEMA Risk MAP, Fairfax, VA ● Developed an application in Microsoft Access and Microsoft Excel using VBA for the PMO to help them resolve Timesheet discrepancies between the Client timesheet and IBM time sheet. ● If the invoice did not match the hours between the two-time sheets, the Client would hold payments. It typically took six-man days (2 people for 3 days) to manually resolve these issues once in every two weeks. ● The primary reason for the discrepancies was due to IBM having multiple sub charge codes for one client charge code.

Data Architect, USPS - Data Migration Architect● Designed and developed a data migration strategy and a detailed design document to migrate Legacy (Agent X) data into Eagle One, specifically products, accounts, service requests, employees and list of values.● Performed data analyst and needs analysis for the Siebel team● Developed SQL scripts to extract data from the legacy system and populate staging tables.● Co-ordinated with DBA's with respect to performance tuning, building of indexes, increasing tablespace and rollback segments.● Built & maintained Conceptual, Logical and Physical Data Models, used ER-Win 3.5 case tool● Reverse engineered Physical data models and Logical data models from the existing database schemas in Oracle.Data modeler, PUC Case Management System, Harrisburg, PA ● State of Pennsylvania has several desperate systems to handle their case management tasks. Unisys won the contract to implement a single system to implement an EMC package – FileNet P8 to consolidate all the desperate systems● DBA activities and ETL of Data using DTS packages. Performed Data modeling using ER-Win. Built & maintained a Logical and Physical Data Model of the entities and Tables usedBOSS Data Migration Project | SQL Server DTS/Data Modeler/Analysis● Performed initial analysis of the existing data assets. Prepare an as-is logical data model.● Created high levels requirements document aster discussions with the stake holders● Used SQL Server DTS packages to build several workflows to migrate data● Automated the data migration process developed.