Working as Senior Engineering Manager for DaaS (Data as Service). Proving Tech Leadership for Token and Fraud Application pertaining to Payment . Responsibilities include People Management, Stakeholder Management, Program Management, Roadmap , Delivery and Operations of Planned Releases, Leading innovation and fostering GenAI culture.

Techno Managerial Role ,Working with Big Data services and Snowflake on GCP and AWS cloud.

Working as Data Architect and Technical Programmer for OFS Data Engineering Team on Big Data technology in AWS environment .Build config driven ETL framework to move enriched data with decision variables from Hadoop to RDBMS for Business Rule Engine .Build Framework to improve user experience for payment pending alert by integrating data lake data with OLTP without moving the data .Build job monitoring and DQ utility.AWS cost optimization by implementing auto scaling , fair job scheduling .

Project: Data Mart, Pay PalThis project is for Pay Pal, biggest player in payment gateway Industry.Location: Offshore, Bangalore.Duration: Sep 2016 to PresentPlatform: Hadoop, TeradataRoles and Responsibilities Working in the capacity of a technical lead and DW architect. Client Interaction and finalizing requirement. Coming up with Conceptual, Logical and Physical Data Model. High Level Design Architecture for ETL Load. Defining Partitioning Strategy, Primary and Secondary Indexes Helping Team with coding, code review and design inputs. Designing Solution to implement processing layer in HDFS using Hive and Spark SQL Implementing External Table, Partitioning Strategy, Clustering, SCD1, SCD2 using Hive in GZIP and SNAPPY compression. Solution Design for Implementing purge strategy for Data and Moving processed data back to Teradata. Writing code for ETL to move data into data mart (Teradata, Hive, and Spark SQL). Designed Framework for DQ check reconciliation using Informatica Power center using Hive Connector to Hadoop with metadata in Teradata. Implementing DQ checks for reconciliation of data. Data access layer for Self Service portal. Regular client calls to discuss project health and issues if any and identify scope of improvement. Carrying out end to end development of components, unit testing and deployment. Code Review, UT review, Performance Tuning of slow running queries, views, and Compression of Older data. Handling 10 people Data Mart Team.

Data Quality for Common Data Environment. Duration: Feb 2015 to Nov 2016 Location: Onshore, Raleigh, North Carolina, USA Roles and Responsibilities Worked as a senior oracle PLSQL developer. Analysis of existing data quality rules implemented across subject area. Data profiling for existing data to find anomalies and implement business rules using Oracle EDQ and Informatica Data Quality. Development of a new data model for capturing Data Quality rules and Results. Defining new generic rules for Data Quality and moving them into a common framework after discussion with Subject Area Owner for various subject areas. Tool to enable comparison of data between any plugable source and target. Unit testing using Utplsql framework. Performance Tuning (Analysis, AWR Report, Query Tuning, Hints, partitioning of table, Rebuilding indexes, Bulk Collect, Creating Indexes, UDT, Parallel Executions, IOT) Developing Framework to do restatement for Dimension keys in Fact Tables Developing ETL procedure to load data from Operational database to data warehouse.Project: Middle Tier Application Development and Support. Middle Tier applications form part of platform as a service offering of Fidelity and encompasses various products which in turn are leveraged across various business units in Fidelity.FDQS (Fidelity data Query Service) ,EZPaaS,Suggestible Search,ApiMarketDuration: Jul 2011 to Jan 2015Location: Offshore, Bangalore, India Roles and Responsibilities Worked as a senior oracle PLSQL developer and Lead. Requirement Analysis, Estimation, Design, Development, Data Modelling, Data Migration Preparation of Unit Test Framework (Utplsql Testing), Coding, Peer Review, Testing, Implementation, Code evaluation using Sonar. Performance Tuning ,Data Modelling of Application EZPaaS Procedures, Packages, Functions, Triggers, Views etc. for Data Consumption layer for Application FDQS/EZPaaS/Config and Preference Services/Suggestible Search, ApiMarket

 Worked in the capacity of a developer Requirement Analysis and Translating into FSD. Design review with Lead and Coding Development of Procedures, Packages, Functions, Customized Tables for Reports and Extraction layer. Reading and writing data from files and triggering alert mail using UTL_FILE, UTL_MAIL utility. Data loads from files Support for Production issues

Platforms: Unix,WindowsTools: Toad,Putty,Informatica,Sql+Programming Language: PL/SQLTeam size: 6Roles and Responsibility; Maintenance and Support of Application CMA (Customer Master and Alignment).Solving day-to-day incidents tickets within SLA.Root cause Analysis of Issues.Carrying out day to day operational activities like reporting, and running processes.Effort Estimation of new enhancements.Development of new Units and carrying out testing and supporting UAT.Performance Tuning