Jan 2024 – Feb 2025 · 1 yr 1 mo · On-site

• Responsible for managing an Enterprise Data platform that includes a Data lake, Data Warehouse, BI, and Machine learning Platforms. I am also responsible for ensuring that the overall health of the aforementioned systems is maintained and managed and hence own Operations on these platforms
• Responsible for Platform Modernization and continuous improvements in these Areas
• Data Engineering
• Database design and modelling
• Data model improvements and optimization
• Data Integration
• Performance Optimization
• Alerts and Notification
• BI Platform Architecture
• Ensure BI Platform Architecture is Optimal in terms of Cost and Performance
• Platform modernization
• Ensuring Availability, and Reliability
• ML Platform Architecture
• Ensure ML Platform Architecture is Optimal in terms of Cost and Performance
• Platform modernization
• Ensuring Availability, and Reliability
• Data Quality
• Automated Recon and Reload
• Data Cleaning
• Alerts and notification to source systems when data is out of synch
• Overall System health and Performance and Backup
• Ensure system is stable and available
• Best practices are incorporated
• Robust backup and failover process
• Data Security
• Data Masking and PII protection
• Platform to be maintained in private network as per Infosec guidelines
• Control access to the Database and ensure proper approvals are in place before allowing the usage of data
• DevOps and Support
• Support operations
• Lead DB upgrades and maintenance activities
• Put a Change management process in place for Data Integration and Model changes
• Oncall support during downtime
• Operations
• Manage Platform Operations – Data, BI and ML Ops
• Developer support – Onboarding, Offboarding
• Budgeting and Cost management
• Plan and budget for Platform Operations and Maintenance
• Optimize cost
• Work with vendors to optimize Developers cost
• Product management and Delivery support
• Support Front end Analytics team in delivering business solution
• Manage product backend

Aug 2021 – Dec 2023 · 2 yrs 4 mos · On-site

Feb 2019 – Jul 2021 · 2 yrs 5 mos · On-site

Jan 2018 – Jan 2019 · 1 yr · Bengaluru, Karnataka, India

• Architect and design, solutions for complex business requirements, including data processing, analytics, and ETL and reporting processes to improve performance of data loads and processes.
• Worked on maintaining and providing 24x7 Teradata database administration support for a very large Teradata enterprise data warehouse environment.
• Develop a high-performance, scalable data architecture solution that incorporates a matrix of technology to relate architectural decisions to business needs.
• Defineddata layers/ integration methodology, quality monitoring, auditing, reconciliation and exception handling, coordination of loads, indexing, and partition and modeling/management approach.
• Performing Business Area Analysis and logical and physical data modeling for Data Warehouse / Data Mart applications as well as Operational applications enhancements and new development. Used the Ralph Kimball Methodology for Data Warehouse/Data Mart designs.
• Frequently used Teradata Utilities such as BTEQ and Reload for loading small amounts of data and Fastload for loading huge amounts of the data into the tables and involved in writing complex SQL code using SQLAssistant and BTEQ to generate Ad-hoc reports for the business team.
• Worked on Data Analysis, Data Profiling, Mapping, Identify Data Quality issues, Data Cleaning, Data validation, and Loading.
• Developed the performance tuning of the database by using EXPLAIN PLAN, TKPROF utilities, and also debugging the SQL code, and identified and streamlined complex queries which were causing iterations and affecting database and system performance.
• Designed and developed the data dictionary and Metadata of the models and maintain them and Designed Metadata Repository to store data definitions for entities, attributes & mappings between data warehouse and source system data elements.
• Reverse Engineered the Data Models and identified the Data Elements in the source systems and adding new Data Elements to the existing data models

Jun 2017 – Dec 2017 · 6 mos · Bengaluru, Karnataka, India · On-site

• Worked with SME's and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical, and Physical Data Models.
• Created a high-level industry-standard, generalized data model to convert it into the logical and physical model at later stages of the project using Erwin and Visio
• Involved with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin tool.
• Enforced referential integrity in the OLTP data model for the consistent relationship between tables and efficient database design.
• Conducted design walk-through sessions with the Business Intelligence team to ensure that reporting requirements are met for the business.
• Worked on complex mappings in ODI to map the source XML data with Oracle Data Servers.
• Developed Data Mapping, Data Governance, and Transformation, and cleansing rules for the Master data management Architecture involving OLTP, ODS.
• Served as a member of a development team to provide business data requirements analysis services, producing logical and Physical data models using Erwin.
• Explored data to identify its model role and measurement level. Verified data for missing values and incorrect data. And then cleaned and structured the data based on the format required.
• Created stored procedures using PL/SQL and tuned the databases and backend process.
• Performance tuning of the database, which includes indexes, and optimizing SQL statements, monitoring the server.
• Designed and Developed PL/SQL procedures, functions, and packages to create Summary tables
• Used Star schema methodology in building and designing the logical data model in the dimensional Models.
• Environment: Erwin, SSAS, SSIS, DB2 UDB, SQL Server, Linux, Excel, ER Studio, SQL, SQL Server 2000/2005, MDM, Netezza, Oracle 10g

Jan 2011 – Mar 2017 · 6 yrs 2 mos · Chicago, Illinois, United States · On-site

• Actively involved in creating Physical and Logical models using Erwin.
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Databasetriggers, StoredProcedures) in the data model.
• Presented the data scenarios via, Erwin logical models and excel mockups to visualize the data better.
• Worked on building the data model using ERStudio as per the requirements, discussion, and approval of the model from the BA.
• Involved with Data Analysis primarily Identifying Data Sets, Source Data, Source MetaData, DataDefinitions and Data Formats
• Designed and Developed logical&physical data models and Meta Data to support the requirements using Erwin
• Creating Variables, Sequences, User functions, Scenarios, Procedures, mappings, re-usable mappings, and Packages in ODI.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys), and physical database (capacity planning, object creation, and aggregation strategies) for Oracle and Teradata as per business requirements using Erwin
• Created complex Stored Procedures, Triggers, and Cursors, Tables, Views, and other T-SQL JOIN techniques.
• Involved with Data Profiling activities for new sources before creating new subject areas in the warehouse
• Tested the ETL process both before data validation and after the data validation process. Tested the messages published by the ETL tool and data loaded into various databases
• Experienced in creating UNIX scripts for file transfer and file manipulation.
• Successfully created and managed a conversion testing effort which included a data quality review, two system test cycles, and user acceptance testing.
• Involved with data cleansing operations using SSIS transformations.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application metadata.