Ashwin Shenoy Email & Phone Number

New York, Ny, Us

New York, Us

Currently working in Bank Of America:Tools & Language used: Python (2.x, 3.7, 3.8), ReactJs, Node Js, Tornado, Flask (old legacy), Bitbucket, SQL Developer (Oracle 19c), Tableau Desktop, Tableau Server, VS Code, PyCharmInteracted with various Stakeholders to create UX designs, templates and implement the same using ReactJs, Html, CSS and Javascript.Responsible for various Architecture & Api Design and development of RESTful service end points using python for internal and external (3rd party groups) consumption of Volcker Datasets.Broke down the large functionalities of monolithic legacy app to create different microservices for quick turnaround and less impact. All this using python and tornado web servers. Built successful data pipelines by creating scripts in python to consume data from Oracle Db, created jobs to run on a schedule to load/modify the data for analytical purposes. Utilized the features of message queues for asynchronous and time consuming business logics.Built extensive Unit tests cases for all new features to reduce system failure and user complaints. Developed and defined rules to automate most of the data reconciliation reports using python scripts.Contributed in writing many SQL functions and scripts to consume data for Analytics and reportingUtilized cache management and propritery Object Database for faster data retrieval for high stake reportsWorked with QA team to develop & automate robust testing system to reduce dependency errors due to feature rollouts. Handled Release Management of the entire application stack on a rotational basis.Visualization – Developed highly performing tableau management dashboards Helped in utilizing the features and capabilities of Tableau in order to migrate from the existing legacy reports. To drive Tableau adoption quickly & efficiently by creating highly performing tableau dashboards and utilizing Tableau server’s best practices.

New York, Us

Tools & Language used: C#, ASP.Net (.Net Framework 4.5), Python, MS SQL Server, SSIS, SSRS, HTML5, CSS3, Javascript, Jquery, Tableau Desktop , Tableau Server, Visual Studio, TFS, GIT, SOAP ServiceRoles and Responsibility: Design and develop an analyticsWebApp using ASP.Net which showed insured patient data with key metrics.Used their org AD and ADFS to provide SSO experience to users logging in to the web application as well as into the analytical application.Designed and Built reusable UI controls and features to seamlessly embed analytical reports built using SSRS and Tableau into the Asp.net Web Application.Utilized their existing SOAP web-service architecture to create new data ingestion points needed for the webapplicationDeveloped greatly optimized stored procedures, functions, and database views to implement the logic needed for appropriate business reports.Assisted in performance monitoring, tuning and optimization of SQL queries.Created SSIS package to load survey data from Flat Files, Excel and other social median sites into the Data warehouse.Designed, built and launched new data models that provide intuitive analytics to the customers.Developed strategies to extract, resolve, and unify information of various types from numerous disparate data sources and integrate cohesively with other business applications for other departments.Helped in migration of several legacy and canned reports to Tableau and helped establish a culture around self service BI. Developed several scripts to automate generation of pdf reports of key management dashboards with proper filters and security using Python and tabcmdDeveloped script which helped firms to automate several workflows, deliver notifications to end users and schedule data load to several integrated systems using Rest Api, Python and Tableau SDKImplemented unit test code for all the module in asp.net to fullfill the code coverage of atleast 60%

Us

Tools & Language used: C#, Asp.net (.Net framework 4.0),jQuery, Visual Studio 2012, MS SQL Server 2012, Tableau Desktop, Tableau Server, IISRoles and Responsibility: Designed and developed ASP.Net web application for securely displaying patient data from various providers. Helped in creating various Restful Api’s to modify and filter data according to various key metrics and finally transfer them to the front end in JSON format.Used the org’s AD and ADFS setup to provide SSO experience to users logging in to the web applicationDesigned a clean and elegant dashboard in tableau to visualize different patterns in patient data and embedded above created web page object into it. This helped the staff to add, update and save patient commentary; straight from your visual dashboard. Built several url actions which interacted with SSRS server to create pixel perfect print friendly reports and email it to the user. Implemented the business rules using the stored procedures in SQL Server to improve the performance.Implemented AJAX wherever necessary for better rendering and reload experience and to improve usability.

Connecting to Tableau Server via PostGreSQL Database using trusted security, designing the forms, Generating script for individual reports in tableau serverDesigning front end forms in MS Access, scheduling products through VBA code implementation, database table design, creating reports using query.Develop SSIS packages using SQL Server 2008 R2 BIDS (Business Intelligence Development Studio). Design SSRS reports

Understanding of business requirements and product requirements, Involved in developing Business layer and Data Access layer in an iterative manner (Agile), Design and build proper UI, write suitable queries and stored procedures, Developing required reports both in Crystal Report and RDLC

Bachelor'S Degree, Computer Science

11 & 12, Statistics

High School, Environmental Science