Home

Ravi Teja - Data Architect/Modeler

[email protected]

Location: Plainsboro, New Jersey, USA

Relocation: YES

Visa: TN

Resume file: RaviTeja_Data Architect_1745267937497.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Raviteja Mylavarapu Data Architect/ modeler Ph - +1 609-934-3901 [email protected] Key Skills Scrum and workshop facilitation Enterprise Data Warehouse Solution Data Modeling Data Integration Strategy Data Migration strategy Data Quality Reference data management Master data management Metadata management & catalog ETL, Analytics & Report Migration Data & Information Governance Project management Agile / Waterfall Delivery & Release Mgmt. Capability building Domain Exposure Retail Pharma Health care Airport, Airlines Telecom Retail & Mortgage Banking Financial services Capital markets Work History CIHI Oct 23 to till date Air Canada Oct 21 to Oct 23 CGI Mar 20 to Sep 21 Wipro Limited Jul 15 to Feb 20 Infosys LTD Hewlett Packard Wipro Technologies LTD Polaris software labs LTD ( Now Virtusa Polaris) Satyam Computer services LTD (Now Tech Mahindra) Key Position Hold Data Architect Data Modeler Technology Lead Senior Consultant Business Analyst Education Bachelor of Technology, ANU Employer: CIHI Role : Data Architect/ Modeler Period : Oct 2023 till date Technology Mix : Erwin Data modeler, Enterprise architect AWS S3, Athena, Glue, Redshift, Hive, MySQL DBeaver EE Git-hub Oracle 11g Toad, SQL Asst, T- Utilities Jira, confluence Employer: Air Canada (Data Nash Consulting) Role : Sr Data Analyst (Contractor Data Architect) Period : Oct 2021 Oct 2023 Technology Mix : Erwin data modeler Azure data factory, data bricks, Synapse, blob storage AWS S3, Glue,redshift Snowflake, ETL Pipelines Spark SQL, Python Informatica SQL Asst, T- Utilities Teradata Appliance Oracle MS SQL, SSIS, SSRS Power BI Jira, Bit bucket Employer: CGI Role : Sr Consultant (Data Analyst) Period : Mar 2020 Oct2021 Technology Mix : IBM Info sphere Oracle 11g, MS SQL SERVER MS SQL, SSIS, SSRS Power designer OBM Toad, SQL Asst, T- Utilities Teradata Appliance Jira, Bit bucket Power BI Employer: Wipro Limited Role : Data Solution Architect Period : July 2015 Feb 2020 Technology Mix : Teradata Appliance Cloudera Hadoop, spark, Hive, Spark SQL Oracle, MS SQL Server database Tableau, Micro strategy, OBIEE, SSRS , Power BI Informatica power center, Analyst, IDQ, SSIS RDM ER-WIN AWS S3, Glue, EMR, RDS SQL Asst, Aginity - SQL, PL/SQL, Load utilities Jira Employer: Infosys Limited Customer: Fidelity Investments Role : Onsite Technical Lead (Scrum Master) Period : June 2011 June 2015 Technology Mix : IBM Netezza Appliance Aginity - SQL, PL/SQL, Load utilities Oracle, MS SQL Server OBIEE , POWER BI Informatica power centre UNIX Rally ART (Fidelity patented driver allocation tool) PVCS, KINTANA Control-M Employer: Hewlett Packard Customer: CVS Caremark Role : Consultant Period : May 2010 May 2011 Employer: Polaris software labs ltd (Now Virtusa Polaris) Customer: Allied Irish Bank Role : Associate Consultant Period : Sep 2008 Dec 2009 Employer: Satyam Computer services ltd (Now Tech Mahindra) Customer: Fiserv Role : Software developer Period : Jan 2006 Aug 2009 Executive Summary Dedicated and results-driven Data Architect with extensive experience in delivering enterprise-level, data-driven solutions. Proficient in complex data modeling and experienced across various data structures, including relational databases, Star/Dimensional models, Data Lakes, and 3NF. Adept at managing the full project lifecycle from business analysis and data modeling to ETL design, performance tuning, and analytic applications. A proven leader in working with globally placed teams, ensuring timely delivery of projects, and collaborating with both IT and business stakeholders to meet organizational goals. Key Skills & Achievements: End-to-End Solution Design: From conducting workshops to crafting high- and low-level design documents, I ensure alignment across business and IT teams. Master Data Management (MDM): Skilled in requirements mapping, identifying functional gaps, and architecting MDM solutions with a focus on scalability and performance. Technical Leadership: Leading design review forums, creating technical architecture, building logical & physical data models, ER diagrams, and guiding ETL pipeline development. Operational Excellence: Overseeing production releases, managing hyper-care periods, and ensuring smooth software upgrades with minimal business impact. System Performance & Optimization: Proficient in performance tuning, network performance measurement, and troubleshooting. Envision data-intensive solutions, including both on-premises and cloud-based Enterprise Data Warehouses, Data Lakes, ETL/ELT processes, and Data Governance frameworks. Conducted workshops to identify and categorize analytics use cases (diagnostic, descriptive, prescriptive, and predictive) and designed appropriate data visualization and BI dashboards. Certified in AWS Data Analytics Specialty, demonstrating a strong understanding of cloud-based data solutions (to be renewed). AREAS OF EXPERTISE ETL Tools Informatica, Oracle PL/SQL, Bteq, ART, SAS DI BI / Analytics MicroStrategy, Tableau Appliance Netezza, Teradata, snowflake Data Modeling ERWIN, Power designer, Magic draw Data Model ER, Event driven model, Data vault model, canonical Model Big Data Hadoop, Spark, Kafka, Hive, Hbase, Spark SQL Azure Cloud Blob storage, ADF, Databricks, Snowflake, py-spark AWS Cloud S3, Athena, RDS, Glue (crawler, catalog, ETL), Python Case Tool Microsoft Office Visio 2003 /2013 , Power point Database Oracle , MS SQL Server,DB2 Data quality Informatica IDQ/ Analyst , iQnext Job Scheduler Autosys, Control M Tools Sql* Loader, Toad, PL/SQL Developer, SQL Asst, DBeaver Process Tools Jira, Confluence, Rally Process Agile & Scrum, Waterfall CIHI is passionate about health data and want to make a difference in the health care field. CIHI is an independent, not-for-profit organization provides essential information on Canada's health systems, enabling decisions that lead to healthier Canadians. Work to modernize Data architecture, taking into consideration business needs and priorities, technical capabilities, and cloud technologies. Develop and maintain data architecture strategies tailored to CIHI operational and Analytical data needs. Design scalable, efficient, and secure databases, data warehouses, and data lakes for effective data management. Implement data security controls, data encryption, and PHI policies to safeguard sensitive data. Define or Enhance, implement data models, schemas, and integration frameworks to ensure data integrity and accessibility. Create and maintain conceptual, logical, and physical data models with accurate metadata. Ensure compliance with industry standards (e.g., HL7, FHIR) and healthcare regulations (e.g., HIPAA, GDPR). Analyze source systems and translate business needs into long-term data models and flows. Design APIs, Build and optimize data pipelines, ETL processes, and workflows to support high-throughput data processing. Collaborate with business stake holders, program analysts, and cross-functional teams to solve business problems through data and ensure alignment with organizational goals Document technical specifications, data architecture designs, and operational procedures. Guide and mentor teams on best practices in data management, modeling, and engineering. Propose strategic solutions to data-related system integration and data quality challenges. Identify technical risks and work with the project teams to develop mitigation plans. Develop data architectural standards, design patterns and schemas, and conduct architecture gating reviews to ensure their implementation. Work with senior leaders, management, and vendors. Air Canada embarked on data/ Application migration from its on-premise Teradata appliance to Snowflake - Azure Cloud based environment. The Project Road map to migrate data from existing Teradata systems to Azure (ADF) based snowflake cloud data warehouse is being implemented. Applications Across the organization previously built on Teradata are being evaluated and migrated or rebuilt with necessary sophistication Conduct application analysis, create business process flows, mapping the data lineage, process flow and understand Architecture as it exists Data solution design with vision to handle scalable data in any form, Automated reusable ingestion pipelines, Data processing by batch and near/ real-time streaming. Collaborate with business stakeholders to streamline data handling, stewardship and quality guidelines. Creation of business glossary, data catalogs, governance strategy that align with internal business needs Envision data migration strategy, data mapping, define interfaces, perform mock conversion, define enhancements, and perform actual conversion. Work on canonical data model creation for operational system and Event based/ data vault model for Analytics data platform Lead initiative to strengthen data governance initiative from business requirement gathering to data solution implementation stages Actively involved in managing the evaluation and remediation activities of data based on Data quality scorecards and data rejection metrics Establish continuous data acquisition requirement gathering processes, Acceptable data standards, Data governance and quality control strategies. Conduct regular workshops with stakeholders at different levels, deliver data solutions by following Agile project implementation methods Experienced in Data Analysis, Profiling, define data quality standards, scorecard creation based on accuracy & completeness, data mapping, creation of data dictionary and business glossary Bell is a Canadian telecommunications company It is an ILEC (incumbent local exchange carrier) in the provinces of Ontario and Quebec and as such, was a founding member of the Stentor Alliance. It is also a CLEC (competitive local exchange carrier) for enterprise customers in the western provinces. Its subsidiary Bell Aliant provides services in the Atlantic provinces. It provides mobile service through its Bell Mobility (including flanker brand Virgin Mobile Canada) subsidiary, and television through its Bell Satellite TV (direct broadcast satellite) and Bell Fibe TV (IPTV) subsidiaries. Business requirement gathering and translation of the same to technical solutions for Backend and online platforms for Bell and subsidiaries. Create roadmap for data platform implementations, estimate efforts and commercial aspects that need to be fulfilled Optimize the technology solutions for better ROI for the business by aligning the business architectures with technology architectures. Identify process gaps in data & technology architectures and recommend solutions (based on TOGAF methodology) to bridge gaps between the business and the data & technology deployed to support the business. Update and maintain OLTP Data model for invoice data repository, Online bill Manager, Online bill presentment platforms; Responsible for artefacts like Data dictionary, Governance structure, guidance on space allocation in Oracle database Solution design to build On premise and cloud based (Hybrid) data platforms that support BI and analytics applications Mapping for the transactional data acquired from multiple source systems to the existing data model and updating reference data for business rules handling where ever applicable Work with vendor teams to secure install and kick start the selected tools at customer site Create overall solution presentations, organize workshop with business and technical teams to get approvals Assessing the Application Inventory, Finalize the Inventory with server / DB mapping specifications. Design and enhance ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems Greater Toronto Airports Authority Enterprise Data Management The Greater Toronto Airports Authority s Toronto Pearson is Canada s largest and busiest airport, in Canada s largest and busiest city. This architecturally stunning, completely functional, and incredibly friendly airport is the hub for some 456,000 flights a year and over 44 million passengers annually. Requirement gathering, Tool assessment, Translation of Functional requirement to ETL designs, Participate in design review forums and validate the designed solutions with client users. Data base design and new application development TOGAF methodology to in fulfilling GTAA s Analytics Architecture build needs Create project plans, release plans, handle design and development iterations, drive effort estimation for new and backlog stories. Early identification and management of issues and delays. Lead application development, manage release activities, Conduct code review sessions, and carry out data validation exercises and User acceptance criteria compliant. Work with project teams & clients to help define business requirements and functional specifications as a guide to data modelling Determine appropriate data modelling approaches by assessing the suitability of data modelling strategies and techniques. Reconcile multiple data sources and data models into a single, logically consistent model. Rationalize the relationships expressed in the logical data model to the schema of the physical data store Lead, plan and build quality Conceptual, Logical, Physical and Semantic Data models for Operational Data Stores, Data Warehouses and Data Marts using tools like ERwin. Map the transactional data received from upstream data generators to data models including required transformation logic, e.g. business rules, data cleansing rules, etc Design & build semantic layer to enable data platform for all business intelligence reporting and Analytics needs. Understand the regulatory, operational analytics needs to build enterprise wide standardized reports Airport analytics applications implemented OTP, IT Executive dash board, Flight Schedule Analytics, Passenger flow analytics, baggage journey and equipment maintenance analytics, Transport Canada regulatory reporting, Central de-icing facility Analytics, IT Ops analytics, CFO dashboard Finance reporting, Airport 360 degree view, POS Retail Analytics, Smart washroom Analytics Wipro Analytics, Integrated solution design Interface and communicate with all areas of the business, work with an engineering/ marketing/ sales counterparts to define product release requirements, positioning and road map. Analyze the RFI/RFP received from the client and provides a technical solution for the proposed bid preparation of the solution after analysing client pain points, crafting bids, driving and participating in due diligence, deciding on price points in consultation with Partners/Sales Team. Fidelity Cost And Profitability Program: Finance, Procurement and Accounting IT (FPAIT) group, a part of Corporate Technology Group (CTG) of Fidelity, is working on a future state roadmap to transform its cost and accounting profitability operations to achieve strategic goals and operational effectiveness. The BU wise End to end process cost, Project cost reporting (- Budget, Actuals, Forecast, Approved spend) Intercompany billing, Cost behavior attribution, Profitability Management (- Investment product & Account, Line of business profitability, Customer Profitability, Market, Channel & segment profitability) and Reporting Standard dashboard & Ad-hoc reporting are part of FCAP. The project builds the architecture landscape, which would be utilized by business analytics team to measure Billing, Costing and Profitability of the units. The team operates within the context of a globally distributed Fidelity team with Boston (Product Management), Dublin Ireland (Tech Leadership) and Bangalore (Development & Production Support) components. Guidance portfolio summary Application (PWI group) The GPS application analyses the customer portfolio and helps them in taking informed decisions on investments, initially the customer eligible for the Portfolio services are screened. On successful screening of the customer profiles, the portfolio is analyzed on the financial instrument held by the customer based on which several recommendations are made to the customer. Conduct daily scrums among the team sitting in multiple geos (US, Ireland and India), attend weekly scrum of scrums to appraise Business and IT stake holders Gather detailed business requirements and use cases, and translate technical specifications into product requirements. Make sure Architecture design follows the TOGAF methology Develop data architecture design to facilitate targeted customer analysis. Create Technical Architecture, Build logical & Physical data model, ETL designs, Participate in design review forums and validate the solutions Develop project plans, identify key milestones, track metrics and manage partners throughout the life of the project to ensure adherence to project schedules & budgets Create the Data Acquisition Layer, EDW Data Layer and Semantic Layer Lead application development, manage release activities, Conduct code review sessions, and carry out data validation exercises and User acceptance criteria compliant. Issue resolution, Performance tuning, change management and scheduling. Stake holder management at different levels Conduct Daily Scrums, solution design reviews, code & feature validation reviews, external & internal leadership reviews Managed team size of 15 members for global Application development and delivery; Acted as Scrum master to conduct daily scrums with customer and third party vendor team spread across US, Ireland & India CVS Caremark iBenefits CVS Caremark is the only fully integrated pharmacy health care company in the United States. The IBenefits is a dynamic and personalized consumer centric application that summarizes prescription claim utilization and highlights opportunities for members to save on generics, preferred brands. This mailing has been very popular with clients and is considered a premier product offering. It is critical to the organization that the IBenefits program be enhanced. Allied Irish Bank is a leading Banking and financial service provider in Ireland. PENTAGON: This Pentagon project is the combination of two Latest Technologies in Business Intelligence with Source system being TERADATA. The Pentagon project is affecting most of the AIB operations, as this project decommissions the existing Source system and using Teradata as new source system, affects many tables to alter and to design of new tables. ACORN: The ACORN project is the transformation of the current Retail Core Banking accounting engines through the implementation of the Flexcube Retail solution. As part of the Acorn program, existing BankMaster system will be replaced by suite of downstream batch interfaces. Each interface will deliver operational data on a daily and sometimes monthly basis in a prescribed format whereupon the downstream system can process it as required. Fiserv is a provider of technical solutions to the financial world, including banks, credit unions, and securities processing organization and insurance companies. One arm of Fiserv, the Fiserv Lending solutions deals with Loan Origination products and Loan servicing products called as MortgageServ. This project added new functionality to loss mitigation support and enhance the features that are currently supported in the system Task and expense tracking / Loss mitigation alternatives. Adding one extra feature of having borrower cash and unapplied funds. This would enable the loan modification process to spread the borrower cash and Unapplied Fund against current balances. Adding one hyperlink for ARM loans so that the ARM terms can be changed and ARM loans can be converted from ARM to fix. Keywords: business intelligence sthree database active directory information technology microsoft procedural language Delaware