Nov 2011 – Jan 2012 · 2 mos · Noida, Uttar Pradesh, India

• Tenix, an automated Traffic System for the Australian govt.
• Technology: MS SQL Server 2008, TSQL

Apr 2011 – Nov 2011 · 7 mos · Noida, Uttar Pradesh, India

• The RMS® Data Quality Toolkit, a robust client-server application, enables insurers and reinsurers to assess exposure data quality, measure its impact, and target data improvements where they matter most for catastrophe risk models. Data can be viewed at a macro level, e.g. by cedant or portfolio, or honed in to the location level. The Data Quality Toolkit delivers objective and independent insight into data quality, providing transparent, actionable, and easy to communicate metrics to inform portfolio management and underwriting decisions.
• Unlike the use of conventional metrics, the scoring metrics produced by the Data Quality Toolkit utilize RMS’ innovative Data Quality Analytics that is build upon the foundations of our catastrophe models to weight the quality of data by the importance of vulnerability, hazard, and net exposure. Scores account for the severity and gradient of the hazard, the relative importance of modeling attributes (e.g. occupancy, construction class, year built, and number of stories) for that region and peril, and the implications of financial structures, including attachment points.
• Responsibilities:
• Involved in understanding the business needs, functional specifications, work with the UI team in collaboration with onsite staff in US & UK and provide suggestions & solutions.
• Technology: MS SQL Server 2008, T-SQL, MS SQL Server Integration Services (SSIS)

Dec 2010 – Mar 2011 · 3 mos · Faridabad, Haryana, India

• AdvantageCS system (as discussed in the previous project) also lacked features of a CRM system. Customer sales and service is becoming very necessary to keep track of sales pipeline and reporting.
• We evaluated many CRM solutions in the market to suit our needs and budget. FreeCRM & Salesforce were the two viable candidates. SFDC was expensive, but was more flexible, robust, user friendly, on cloud application and had a fast response time. On the other side FreeCRM was very cheap, but was less flexible than SFDC, had a very complex architecture, on premise application with slow response time. So we finally ended up with the SFDC’s Sales Cloud Professional Edition.
• Roles & responsibilities:
• Involved in customizing the SFDC screens to capture every information related to a leads/contacts/accounts/sales.
• Setting up backend integration for setting up provision to push leads and related data from our main system AdvantageCS (SQL Server as backend) to SFDC.
• Using MS SQL Integration Services (SSIS) and Apatar (3rd party, free, open-source ETL tool/utility) as a Business Intelligence (BI) tool to integrate them.
• With prior experience in CRM systems I also provided training to the Sales Reps & Managers on SFDC.

Apr 2010 – Nov 2010 · 7 mos · Faridabad, Haryana, India

• AdvantageCS contains millions of Customer’s information, publications, newsletters and other inventory items like CDs, Transcripts, Training Camps for Medical Coding, etc. It is a robust system in itself but every system has some limitations and drawbacks.
• Like there is no provision for maintaining information related to Training Camps and Live products (CD/DVDs). And with new business processes getting functional there is a need of a new system which can maintain those processes and would be also extensible & flexible to implement future needs.
• The new system would also reduce the number of Advantage licenses thus reducing the operating cost globally.
• "Interface" will act like an extension to the AdvantageCS maintaining extended information for various items contained in AdvantageCS. It has 2 parts, first inventory management managed by admins. Second reporting used by various users & management which would reduce lot of AdvantageCS licenses.
• Technology: MS SQL Server 2005, T-SQL, ASP.net Maker, ASP.net Report Maker, MS ASP.net HTML, JavaScript, AJAX
• Role: Technical Analyst, Database Developer

Aug 2009 – Mar 2010 · 7 mos · Faridabad, Haryana, India

• Eli uses Advantage Computing System (AdvantageCS) as its internal tool to store its customer’s data and their preferred subscriptions. Subscriptions includes various kinds of publications, magazines, newsletters, Audio & live conferences, etc. related to Health-Care, Sports, Adventure, Finance, Travel, Business, etc. Advantage system tracks each and every outgoing publication and ensures their timely delivery to its customers. Advantage also helps to identify new and prospect customers with the help of its internal marketing team.
• We as a team are engaged in providing production support to the system from the backend. My nature of work includes creation/modification of complex SQL queries, stored procedures, triggers and refreshable/pivot excel reports on ad-hoc basis. Besides this I also provide end user support to Advantage users by taking care of some of its admin activities like, user management, process/jobs creation, issue tracking & troubleshooting in a timely manner.
• Technology: MS SQL Server 2005, T-SQL, Advantage CS, Crystal Reports, MS Excel, VBA
• Role: Reporting Analyst, Business Analyst, Database Developer

May 2008 – Jul 2009 · 1 yr 2 mos · Gurugram, Haryana, India

• Toronto Dominion Banking & Financial Group, headquartered in Toronto, ON, Canada. TD bought two banks in the US, Commerzbank and Banknorth. In Sapient we are involved in integrating these banks to provide a seamless, TD bank’s experience to all customers.
• The Banking mainframe system is based upon (FIS) Fidelity Information System with External System Interfaces as Image Archive (Titan & AFS), Solimar (eStatements), Metavante (Card Management System), RETI (Holds bank’s branch information) and SQN Fraud Detection system. Services for Consumer Apps (channels) are EH-Teller, Call Center App, Retail & Small Business Banking. The contract for this application is to expose number of the core services provided by Fidelity and other external systems (Web method Broker, JaQI, IBM CICS adapter, etc.) as a Web-Service that can be consumed by different channels/clients.
• Responsibilities:
• I was involved in creating/modifying business rules for the Business Support Center CRM application at the backend, i.e. Stored Procedures and writing SQL queries to fetch data for reporting.
• Technology: MS SQL Server 2005, T-SQL, Internal CRM Application
• Role: Database Developer

Jul 2007 – Apr 2008 · 9 mos · Denver Metropolitan Area

• Janus Capital Group (Denver, CO, USA) decided to phase out its old CRM tool (Onyx) and switch to a new, robust and dynamic CRM i.e SalesForce (SFDC). With Sapient as its existing support model and Salesforce as a vendor Janus decided to use SFDC as its CRM tool onwards.
• Played a key role in the process of data migration from Onyx CRM to SFDC. This involved data mining, cleansing, reporting, and creation of various stored procedures, triggers, Informatica mappings & Autosys jobs. It also involved the migration of integrations with 3rd parties like ADP, Wall Street on Demand (WSoD), iMake News, Moore, BARS, etc.
• Data includes the personal information of millions of Janus customers, their accounts, funds, fund value, newsletters, gifts, and collaterals.
• Technology: Onyx CRM, SFDC, T-SQL, MS SQL Server 2000, DTS, Informatica Power Center, Autosys
• Role: Onsite POC for India team, Technical Analyst, Database Developer

Feb 2006 – Jun 2007 · 1 yr 4 mos · Gurugram, Haryana, India

• Onyx, a web-based CRM application that enables the management of all the customer information in a central database. Janus (Janus Capital Group, Denver, CO, USA) Internal users are its customers. Janus client information and tracking are done through Onyx. Onyx helps to manage every business interaction with your customers, from initial contact through sales cycles and customer care programs. Using Onyx, users can gather, integrate and share valuable customer information with everyone in any organization.
• In Sapient, we are engaged in ongoing production support for the CRM application.
• Responsibilities:
• Writing/updating TSQL code (scripts, stored procedures, triggers) for implementing new & existing business rules.
• Run data-loads, creating/updating UIs, monitoring 3rd party integrations.
• Responding to ad-hoc client’s requests and handling critical issues in a timely manner.
• Technology: MS SQL Server 2000, T-SQL, DTS, Onyx CRM, Informatica Power Center, Autosys, ASP, JavaScript
• Role: Technical Analyst, Database Developer, Business Analyst