May 2020 – Jan 2023 · 2 yrs 8 mos · Hyderabad, Telangana

• As a Data Architect, implemented and drove key Data Architecture and Data Governance initiatives.
• Data Governance Strategy: Led the adoption of Collibra to establish standardized processes, roles, policies, standards, and metrics, ensuring the effective and efficient use of information in achieving business goals.
• Event-Driven Architecture: Designed and implemented ROAP (Risk operations Analytics Platform) project with an event-driven architecture leveraging Kafka and AWS cloud services.
• Enterprise Data Architecture:
• Designed the architectural landscape for the RCDR data lake on the on-premise cloud platform GAIA.
• Developed conceptual, logical, and physical data models using ERwin.
• Established data quality controls through Informatica BDQ.
• Implemented orchestration processes and reconciliation services across business capabilities.
• Designed and implemented a PII framework to identify and protect sensitive and personal data.
• Developed a Metrics as a Service (MaaS) program to enhance data quality.
• Led data management initiatives covering Data Classification, Data Retention, Reference Data, and Metadata governance.

Dec 2018 – May 2020 · 1 yr 5 mos · Hyderabad, Telangana, India

• At HSBC, I contributed as Data Architect for the 'Retail Credit Risk' line of business and had an opportunity to initiate and drive Data strategy. The strategy outlines the journey for RCR to move critical processes including IFRS9, Stress Testing and Basel Modeling onto Big Data technologies. It is intended, over time, to integrate data from all RCR sites into the RCR CDM in support of a standardized data layer (Common Data Model) for regulatory modeling and reporting. Add on benefits are consistency in regional processes, conventions and outputs will allow to leverage data insights at Global level.
• Designed conceptual, logical and physical data models for RCR CDM Data Lake.
• Used IBM Infosphere Data Architect(IDA) data modeling tool for designs and Collibra tool for data governance.
• Contributed to Data Governance process as part of Enterprise Architecture Review board.
• RCR CDM Technical stack includes: Hadoop, Hive, Spark, Pentahoo (ETL Tool), Juniper(Data Ingestion tool), PyDQ (Data Quality) and Ansible (CI/CD).

Dec 2013 – Dec 2018 · 5 yrs · Hyderabad, India

• At United Health Groups, I worked as Data Architect & Analyst.
• Experience in designing conceptual, logical and physical data models for Enterprise Applications and Data warehouses.
• Experience with data modeling tools such as ER Studio and ERwin.
• Expertise in Data Modeling, Architecture.
• Developed various DB objects like packages, procedures, functions, triggers, Views and Indexes.
• Strong exposure on Oracle, MS SQL, PostgreSQL
• Part of the End-to-End SDLC project lifecycle viz. requirements gathering through implementation of data analysis solutions.
• As Data Analyst, acquired data from systems of record cleanse and conform it before distributing it to downstream analytics data marts and operational data stores.
• Extensively worked with Salesforce UI in multiple projects.
• Proven and demonstrable success in data architecture, data modeling, data quality and data governance on large scale implementations.
• Have been working closely with clients, ensured that the work products and deliverables were of the highest caliber up to client satisfaction.
• Worked as Data SME, identified, developed, and implemented techniques that improved engagement productivity, efficiencies, mitigated risks, resolved issues, and optimized cost saving.
• Ability and expertise in understanding data sources and structures that relate to data warehousing techniques and analytical reporting.
• Knowledge on Big Data Architecture, MapReduce, Hive and Spark.
• Hands on with Tableau (10.1) - Data Visualization and reporting tool, Crystal Reports.
• Hands on with performances tuning which includes SQL Queries tuning, rebuild indexes, partitions.
• Have exposure to ETL tools – SSIS & Informatica for Data extraction, transformation and loading.
• Creation of database tables, table spaces, users in Oracle 10g and 11g.
• Profound experience in Team mentoring, to achieve client expectations and project goals.

May 2010 – Dec 2013 · 3 yrs 7 mos · Hyderabad Area, India

• As an Oracle developer at Magnaquest technologies extensively worked on developing the solutions for the clients using PLSQL language.
• Developed Specific customizations using Oracle/SQL/PLSQL
• Created packages and developed PL/SQL Stored Procedures, Functions, database Triggers
• Had worked on Views and Materialized views
• Responsible for Data mapping and porting
• Worked on Data Migration
• Used SQL Loader, External tables and UTL_FILE to load the data to Database tables
• Backups and Recovery i.e. exports/imports are part of regular activities
• Having good experience in Dynamic SQL
• Extensively worked on the advanced PLSQL concepts like Collections, Arrays, Varrays and Nested Tables
• Had hands on in identifying the performance bottle necks & tuned them for better performance
• Developed the reports using Crystal Reports