Feb 2020 – Aug 2021 · 1 yr 6 mos · India · On-site

• Worked on data modeling, data validation, and other EDA techniques
• Built AWS S3 data pipelines and validated data lineages for large datasets using PySpark,
• Applied statistical measures such as precision, recall, correlation, differential mobility, MAPE calculation techniques, so as to validate business use cases and provide signoff's on data models
• Designed and implemented new features & dimensions to existing Yodlee Data Science models like user income predictions, customer payroll transaction identification, and user demographics identification using Pyspark scripts. These models were deployed on Apache Spark EMR, thereby impacting 5 downstream Yodlee applications/products
• Led the feature development process and provided product improvement ideas to data scientists, data engineers, and coordinated the releases
• Proactively involved in driving new product ideas to senior management
• Technology:
• Python, SQL, PySpark, AWS Redshift, Amazon S3, Tableau

Aug 2017 – Feb 2020 · 2 yrs 6 mos · Bangalore

• Performed data wrangling on sales datasets of more than 400+ Asset Management and Capital Management firms
• Automated adhoc and regular reporting procedures for the marketing of equity stocks by a large investment bank
• Quality checked on data issues using automated Python scripts and automated data upload process onto third-party vendor platforms, thereby improving performance by 5 times to upload data asynchronously.
• Resolved business queries and generated team performance statistics on Qlikview
• Recommended changes in the existing business processes to senior stakeholders and management
• Lead a Team of 5 members and mentored junior team members while developing new Data Management frameworks
• Technology:
• Python, SQL, Qlikview, Excel Reports, VBA

May 2016 – Jun 2017 · 1 yr 1 mo · Bangalore

• Identified money laundering patterns such as structuring over large value transactions by implementing effective SQL queries on banking datasets
• Built Trigger mechanisms on suspicious activity scenarios and reported fraud thereby saving millions to the client bank
• Mutitasked multiple projects as a Data Integration and Migration Analyst
• Implemented SQL stored procedures in SQL Server Management Studio to migrate all data from source and target tables into audit testing environment
• Executed SQL scripts over testing environments to determine data completeness and data consistency errors for each test case
• Documented Reports of data migration activities and shared with the client bank for further analysis
• Gained exposure on ARCA (AML Risk and Compliance Analytics)
• Technology:
• PLSQL, SQL, Excel, VBA

Jun 2014 – May 2016 · 1 yr 11 mos · Bangalore

• Involved in multiple projects as an ETL developer and performed data integration and validation
• Worked on tools like Oracle SQL Developer and SQL Server Management Studio to write SQL and PL-SQL scripts including stored procedures, triggers & functions
• Built data lakes and integrated data warehouses & databases
• Created KPI's dashboards over Insurance datasets by analyzing key metrics impacting local and global premium payment amounts, profit to loss ratio, and other statistics using Qlikview and Tableau
• Performed data visualization using graphs/plots (Line, Bar, Scatter Plot, Bubble, Box Plot, Histogram)
• Acquired subject-matter expertise on performance improvement strategies and insights generation on Insurance data and related products
• Technology:
• PLSQL, SQL, Excel, VBA, Qlikview, Tableau

Jun 2013 – Jul 2013 · 1 mo · PESIT

• Mentored student teams working on Mobile and Web Technologies.
• Designed User Interfaces on Windows Application for Microsoft Lumia devices.

Jun 2012 – Jul 2012 · 1 mo · PESIT

• Built Windows Mobile Applications using XNA Silverlight and XNA Game studio 4.0.