I am working in Identity Aware Proxy at Google Cloudhttps://cloud.google.com/iap

• Developed a web based data visualization application from scratch to help Project Managers monitor student’s data.• Worked on the database schema of the visualization system to support fast response for hierarchical aggregation queries. • Designed the authentication, role based view of the visualization system, user registration and admin approval workflows.• Implemented the backend ETL services using python and alchemy for reliably fetching the data from source files to our DB• Lead the team of four people as a Product Manager and Architect. Planned and tracked the work for timely deliveryTechnologies used: Python, Django, Javascript, HTML, CSS, SQL, MYSQL, pylint, jenkins, alchemy, WebStorm, PyCharm, JIRA, GitGithub link: https://github.com/soniaguptacmu/DashboardCustomer feedback: https://drive.google.com/open?id=1JJwLj0LA0Iwk0W0ZTSe2fgIAI1Sst_mLwXehwoBX9H4

• Designed and developed ETL engine using C# and SQL which helped with integration of data of different formats.• Analyzed key management information and designed a customized reporting engine using SSRS to improve quality of data. • Analyzed and implemented marketing and sales workflows of CRM using Microsoft Dynamics

Client Relationship Management (CRM) Web Application:• Implemented features to improve efficiency of sales and marketing workflows in CRM using JavaScript, Asp.net, C#. • Created a standalone application for production support to reliably perform routine activities on production database.• Accelerated maintainability of legacy code by improving unit test coverage from 10% to 40%. • Introduced and formalized code reviews and team review process by integrating JIRA with crucible which helped in improving code quality and knowledge sharing.• Formalized versioning, deployment and release management processes to help develop standard processes for the team. Web Services:• Designed new web services using Microsoft WCF REST to provide necessary data to the external teams.• Refactored traditional SOAP based web services to REST based web services to improve performance.Legacy web applications:• Worked as a single point of contact for any changes and information for legacy applications in CRM suite.• Initiated documentation of legacy code and architecture so that it is maintainable in future.

• Developed an analytics dashboard for research analytics department of client and sales technology in RBS. The Application was specifically designed for ipads. • It was an interactive charting application that asynchronously plots graph for share prices of a company on previous dates. Used HTML5 and javascript.• Main features of the application were plotting of multiple time series, multiple axes, interactive zooming and panning, display of data points and event annotation.