Anurag Rajendra Watane

Responsibilities: • Involved in the entire application development cycle, from requirement gathering to design thinking to programming. • Worked on asset allocation algorithm for a wealth management platform • Used Machine Learning techniques (e.g. Logistic Regression, Random Forest, SVM) to build up predictive models. • Created two investment portfolios with equivalent KPIs (e.g. Risk, Return, ESG Score) using clustering algorithms (e.g., DBSCAN, K-means).

• Tuned and optimized SQL query for the best performance. • Handled high priority issues. • Analyzed quantitative and qualitative business data to develop a solution capable of fulfilling the customers requirement. • Designed and developed data management system using MS SQL Server.

Role: Development, Unit testing and Bug fixing Contributions: • Creation of database objects like Stored Procedures, Functions, Triggers and Packages. • Worked on development of various modules. • Design and creation of Web pages. • Used Asynchronous JavaScript and XML (AJAX) techniques to improve performance of the portal. • Executed migration from different data sources like SQL Server, Excel and flat files to Product database.

Role: Development, Unit testing and Bug fixing Contributions: • Developed classes in Business Layer and in Data Access Layer in C# • Worked on development of AI Chat Bot. • Used JavaScript for the client side validation, browser detection and application functions. • Written SQL procedures, functions, triggers, packages, and ad-hoc queries. • Optimized query by using Materialize View, Index and oracle hints for reporting. • Effectively mined unstructured data.

Role: Development, Unit Testing, Bug Fix, Data Fix, Change Request handling Contributions: • Designing and Creating User Interface. • Implemented the Business Logic and Functional requirements. • Writing Procedures, Functions, Triggers, Packages, and ad-hoc queries in ORACLE. Created database objects like Types, View, Indexes and Collections etc.

Role: Data Analysis Contributions: • Created data base objects. • Created scripts to migrate data from multiple sources to production database. • Created business reports and dashboards. • Presented the reports and dashboards to stake holders. • Created dashboards and reports using Microsoft's MicroStrategy Business Intelligence Tool

1> Analytics and Statistics: R, RStudio, Regression, Data model, Prediction, 2> Information Systems: MongoDB, Robo 3T, Neo4J, Redis, Python, 3> Data Management: Open Refine, Talend Data Quality, Data Profiling, TriFacta, 4> Data Engineering: Apache Kafka, jQuery, HTML, PyMongo, AJAX, FLASK