RAKSHITH Nagaraj

Wrote and optimized in-application SQL statements. Designed and created ETL code installations, aiding in transitions from one data warehouse to another. Verified performance and reliability of development database transformation solutions via extensive simulation testing. Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations. Designed data models for complex analysis needs. Managed quality assurance program, including on-site evaluations, internal audits and customer surveys. Planned and implemented security measures to safeguard vital business data. Evaluated, designed, implemented and modified databases and database applications. Created scripts and processes for data integration and maintenance. Working on migrating data from Sybase database to Snowflake and Azure. Creating Snowflake objects and loading data into them using ETLTool. Helping reporting team to connect to Snowflake. Getting data loaded into Snowflake from Blob storage

Developed and delivered business information solutions. Established and secured enterprise-wide data analytics structures. Managed quality assurance program, including on-site evaluations, internal audits and customer surveys. Created optimal technical solutions to user needs through research and in-depth system analysis. Developed custom database objects, stored procedures and delivered application support. Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing. • Analyzed existing SQL queries to identify opportunities for improvements. Performed regular database backup.

Creating Sybase objects, Procedures for Fixed income system of Alliance Bernstein. Creating ETL mappings as per request and providing L3 support for the Fixed income data. Performing Intraday support for Portfolio managers on data if there is any mismatch and analyzing them. Creating Oracle objects for the Risk assessment Product of Alliance Bernstein. Worked on automating reports for data analyst to work with using Shell scripts and Scheduling tool.

Worked on Customer Master data management tool which uses Oracle PL/SQL programming and C# code for generating the golden record. We had an inbuilt ETL tool called Komodo where we used to load data from different source and then we used different processes like hashing and matching and extract golden data out of the machine. Worked on creating Oracle Procedures and Functions to Massage the data and process them. Created Oracle objects to define rules for matching and Hashing. Wrote and maintained technical and functional specifications to document database intentions and requirements. Administered, supported and monitored databases by proactively resolving database issues and maintaining servers. Devoted special emphasis to punctuality and worked to maintain outstanding attendance record, consistently arriving to work ready to start immediately.