• Strategize solutions and design workflows to transform business requirements into easy-to-use system functionalities. Implemented cascading workflow to meet compliance requirements for self-service reporting– as a result, approximately 80% of the marketing material is generated dynamically.• Function as a primary liaison between Business and Technology teams to perform feasibility study, data analysis, and gather source and destination requirements for automating marketing reports and other presentation collateral. • Develop reports for upcoming investment strategies, dynamic product profiles, retail factsheets and simulation macros in Seismic application.• Define monthly sanity checks to identify functional or data issues within the system. Document root cause analysis and provide long-/short-term resolutions.• Create an intuitive support model using Jira Service Desk, manage project tasks, address system related queries and communicate updates to stakeholders.• Apply business analytics to identify target audience and offer customized content and training to increase application utilization.• Explore new features in Seismic application, leverage them to enhance user experience and position Seismic as a centralized reporting tool within the organization.Technologies used:• Languages/Technologies: Visual Basics, JSON, SQL• DBMS: MS SQL Server• Tools/IDE: Microsoft (VBA, Excel, PowerPoint, Visio), Atlassian - JIRA, Seismic, Swagger

• Reviewed and created the business logic in the reporting templates and assisted in documenting requirements for a seamless transition to Seismic application from the legacy system.• Created new material within Seismic, performed User Acceptance Testing as required and validated the data for reporting APIs.• Conducted impact analysis following market related changes including benchmark, country of risk, vendor coverage and country reclassification and ensure the change reflects in the reports. • Coordinated with the IT team to request changes and bug fixes in the APIs.• Researched, proposed and implemented new tools within the team for effective collaboration.Technologies used:• Languages/Technologies: Visual Basics, JSON, SQL• DBMS: MS SQL Server• Tools/IDE: Microsoft VBA, Microsoft Excel, Microsoft PowerPoint, Atlassian - JIRA, Seismic, Swagger

• Independently learnt the mechanism of a new Software Platform called Seismic to remodel the production of reporting and marketing materials for the Business Development Group.• Examined processes for successful SS&C Conversion and New Account Setups in the in-house web application.• Monitored monthly scheduled batching processes to support team’s production efforts.• Coordinated within the team and various business groups to build supporting exhibits for marketing reports.Technologies used:• Languages/Technologies: Visual Basics, JSON, SQL• DBMS: MS SQL Server• Tools/IDE: Microsoft VBA, Microsoft Excel, Microsoft PowerPoint, Atlassian - JIRA, Seismic, Swagger

• Automated existing macros utilized for data simulations, increased re-usability by reducing manual efforts up to 90%.• Verified the data for accurate representation in client/prospect presentations.• Produced data maps for the development of dynamic presentation templates.Technologies used:• Languages: Visual Basics, SQL• DBMS: MS SQL Server• Tools/IDE: Microsoft VBA, Microsoft Excel, Microsoft PowerPoint, Atlassian - JIRA

• Accumulated data requirements to decipher and build complex queries using Oracle SQL Developer.• Assimilated different database and query optimization as well as administrative techniques.Technologies used:• Language: PL/SQL• DBMS: Oracle• Tools/IDE: SQL Developer Tool

• Improved employees’ experience up to 30% by heading maintenance and new developments of a web application. • Enhanced auditing and reporting experience by programming new modules and data integration applications. • Coded and deployed WCF services and database for an Android application on client's server within a crucial deadline, thereby achieving client’s satisfaction and company-wide recognition for outstanding performance.Technologies used:• Languages: C#, Classic ASP, VBScript• Web Technologies: HTML5, CSS3, JavaScript, jQuery, AJAX, JSON, WCF• Frameworks: ASP .NET, Subsonic, Entity Framework• DBMS: MS SQL Server• Tools/IDE: TortoiseSVN, Visual Studio, IIS

• Planned, implemented and documented a property portal system focused on communication and property selection between buyers, sellers, and real estate agents.• Improved quality of search functionality and increased ease to complete transactions.Technologies used:• Language: C#• Web Technologies: HTML, CSS• Frameworks: ASP .NET 3.5, ADO .NET• DBMS: MySQL • Tools/IDE: Visual Studio