I am a Masters candidate with 3 years of industry experience in financial services.
I worked on cutting edge technologies during my work period including ETL tools, BI tools and Hadoop technologies to implement and deliver projects.
Apart from that i actively took part is process automation wherever possible and some technology driven initiatives.
During my masters i strengthened my skills on python, AI/ML concepts and tools.
I am a fast learner and a promoter of learning new technologies. I am excited to use my expertise to make the organisation i work with a better and best one and grow along with it.
With the technical expertise I possess and my continuous learning I hope to meet the role specifics
-
Experience
Project #1: Manual testing automation to forklift reports in PL/SQL excels to Cognos based Excel
Problem: Manually test 100+ reports for correctness daily for 2 weeks.
Solution Implemented: Used VBA Scripting, Macros and automated email with Excel and where data mismatches are there to the report Owners. Written functions to match cell by cell and color code the cells where there is a mismatch. Send it via email to the owner of the report so he/she can make changes. Saved 80+ man hours per week. Improved over all turn around delivery time by 60 percent
Project #2 : Cognos Development of self-service reporting
Existing approach: Creating Adhoc based reports outputted in Excel by executing customized PL/SQL packages and triggered by Control-M jobs. Over all turn-around time is 2 weeks for 3 resources on an average.
Solution Implemented : Make it self service reporting with Cognos and let the end user drag and drop attributes as necessary for each report requirement. Identified frequently asked reports and most common attributes and freeze the business logic by having regular meetings set up with business analysts. Created complex PL/SQL packages to satisfy approximately 120 attributes/columns data and set up control-M jobs on daily basis to update data.
Created Cognos dashboard with all 120 attributes available with a date range of up to an year so the end user can create filter based on type of report whether its daily/monthly/quarterly /semi-annual or annual. Provided grants and read only/download privileges to the end users. Saved 70+ man hours per project per person
Project #3: Force for Good ( Technology for Social Good) Create Classroom Student Assessment system for a Non- profit NGO “Ashray Akruti’ that works for hearing impaired children.
Built UI for Teachers to input grades per student and submit them using Joget workflow. Storage in MY SQL database for all the inputs. Enable teachers to modify details like courses and grades.
Generated reports for progress cards using high charts and sent them to student’s guard or sponsor via email. Also create multiple views for each hierarchy in the NGO like principal, divisional head and other executives
Project #4 : Administered JIRA and built the framework, discipline for the tool as ‘Scrum Master’. Facilitated sprint ceremonies, monitored and managed the team towards sprint deliveries. Maintained documentation using Confluence, SharePoint and JIRA. Managed the project that converts existing PL/SQL packages into Abinitio graphs using Hadoop File System as source and Oracle DB as destination. Developed Oracle PL/SQL packages to enable generation of 100+ reports on home lending data
Project#5 : Created Chatbot for solving account enquiries for customers of chase as a proof of concept using NLP , LUIS framework implemented in JSON format
-
Projects
Capstone Project: Chat Bot for Departmental enquiries ( MS Office Suite, Python, SQL, HTML, CSS, NLTK, Theano, Plotly)
Building a chatbot using python NLTK libraries for answering all the departmental student enquiries from the website and dynamic answers that get updated in the SQLite database. Implementing NLP (Natural Language Processing) principles to achieve the result. Creating interactive user interface using HTML, CSS and PHP with bootstrapping. Generating analytics reports to management using Theano, Plotly
Systems Design and Analysis Project (MS Visio, Lucid Charts, Business Flows, UML, Excel)
Gathered requirements for a pharmaceuticals firm to provide technological solution to existing manual process using functional flow diagrams, UML, ERD and Excel for reports. Provided improved solution for segments to increase profits and improve processes
Web and Social Analytics Project (R, Excel, Tableau)
Provided data driven insights to OYO (hospitality industry) on which app to design and what features to include. Results were derived by applying regression analysis on numerous parameters with App store, OYO Hotels and bookings datasets using R and used Scatter plot/box plots for graphical representation of data along with Tableau reports
Business Analytics Project (MySQL Workbench, Excel, Power BI)
Designed a data model for a cupcake store to manage the store ingredients based on the demand and supply model developed using historic data of more than ten years using MySQL. Included models to predict seasonal cupcake demand. Provided features to incorporate social media for creating offers/coupons based on customer page likes/interests. Drew reports using Power BI
Artificial Intelligence Course Project (R, Python, Excel)
Determined best models for predicting the price of the house with Zillow(marketplace for real estate agents) housing data using decision trees, random forest ,logistic regression algorithms using R. Additionally analyzed factors affecting house price, implemented data preprocessing techniques and performed visual analytics on parameters relevant to determine price of the house