Experience

• 

  State bank of india

  Apr 2013 - Jun 2013

  Intern

  State Bank of Hyderabad, Hyderabad, Andhra Pradesh. (April 2013- June 2013)Project title: “Study on Risk Management of State Bank of Hyderabad” to control, mitigate various risks faced in its operations. •Understanding the policies framed by the bank to analyze, control and mitigate various risks•Implementing the Statistical Methods used by the bank for calculating Market Risk.•Major Findings are how SBH can improve its business by the use of derivatives for either trading or hedging, establishment of controls to mitigate the risk and also the method of “Assessing Appropriateness” of the customers to categorize them for derivatives dealing with them. Show less

• 

  Cognizant technology solutions

  Jun 2014 - Jul 2017

  Senior analyst - product control

  Worked as a Senior Analyst in the Analytics team and the projects worked during the tenure are Prediction of Bond Pricing (Convertible bonds): We have built a predictive model using multiple regression technique through SAS to predict the factors affecting the price of the Bonds, which has an option to be converted to Stocks. Transformed raw historical data and applied data processing techniques for the prediction, which has been used for the financial reporting writing.To assess the credit risk involved in Corporate Bonds: Assessing the credit risk of new energy corporate bonds can help investors accurately identify investment risks, given that the model’s explained variable is corporate bond credit risk, whose possible values are default and non-default we have used Logistic Regression model by using Factor Analysis for dimensionality reduction. • Extracting, manipulating data, and creating Data Sets from various sources like Excel, flat files and Oracle database.• Completed the transition of "ETD (Exchange Traded Derivatives) Business Process" where I had an opportunity to work in Singapore for 8 months and have gained an onsite experience of working along with clients and have successfully offshored two roles to India. Show less

• 

  Bank of america

  Jul 2017 - Jan 2022

  Assistant manager (enterprise independent testing analytics)

  As a part of EIT Analytics team. the key responsibilities are:i.Creating and executing SQOOP jobs for data migration from RDBMS to Hive tables ii.Understanding business requirements and develop flows in TRIFACTA tool with the help of writing SQL queries, which would run on Hive tables. iii.Worked on assigned Jira tickets for amendments to exsisiting SQOOP jobs and development of new jobs ETL Team Role Responsibilities: i.Designing data pipelines. and develop SSIS packages to populate data from various data sources for ETL process for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server involving various transformations in Data flow task and control flow tasks .ii.Experience in Extraction, Transforming and Loading data using SSIS, creating mapping/workflows to extract data from sources i.e, SQL server, Excel file, Flat files and other RDBMS like Teradata and load into staging tables for running scripts in various frequencies.iii.Using of several ETL tools (SSIS, SAS EG) and later running the jobs by scheduling them in AUTOSYS to provide the samples to testing team. Show less

• 

  Wells fargo

  Jan 2022 - Jul 2023

  Lead analytics consultant

  As a part of SCM Analytics team the source data is used from webapis, HDFS , RDBMS and transform data over to multiple stages. The JSON data is flattened to generate the json hierarchy wherever required and write the data to the target hive tables as parquet with partitions to Hive tables. Recently part of migrations to AWS cloud environment where HDFS would be replaced by AWS S3 buckets and spark jobs would be trigged through AWS EMR step functions and target would be analyzed through AWS Athena as a Proof of Concept. Project Responsibilities:1. Load and transform large sets of semi structured data likes XML, JSON, Avro, Parquet using Spark. 2. Query data using Spark SQL on top of Spark engine for faster dataframe processing. 3. Create multiple Hive tables, running hive queries in those data, implemented Partitioning, Dynamic Partitioning, and Bucketing in Hive for efficient data access. 4. Generate complex JSON data after all the transformations for easy storage and access as per client requirements. 5. Involved in creating Autosys jobs to make the process data orchestration to reach downstream systems. 6. Responsible for Optimizing Spark queries that helped in better jobs performance. 7. Perform transformations, cleaning and filtering on imported data using dataframe, rdds, and load final data into HDFS. Show less

• 

  Coforge

  Jul 2023 - now

  Data engineer

  Working for Santander UK banking client in ESG reporting.Activities include building data pipelines from source tables to end reporting through the data transformations using Spark with Scala and schedule the batches using Control M to automate the process of delivering reports of various frequencies.