India
• Experience in database design and development along with data integration, transformation, analysis, and reporting in various domains, such as insurance, banking, marketing and advertising. • Proficient in using Transact-SQL to create database objects and store data in the database in an optimized manner for better performance. • Created SSIS packages for ETL processes and to build data marts using various transformations, tasks, and containers. • Experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Charts using SQL Server Reporting Services (SSRS). • Hands-on experience in web application development using technologies, .NET, ASP.NET, C#. • Managed projects to track their development using various source control tools, JIRA, GIT, TFS, VSS • Efficiently prepared business requirement, functional requirement specifications, and user acceptance test documents.
• Created complex SQL queries for the auditing and security product developed by Lepide. The product stores the information regarding what, when, who changed or modified the components added in the auditor by the user. It audits the components such as Active Directory, File Server, SQL Server, SharePoint Server etc. • Created database design, tables, indexes, and other DB objects. • Used Dynamic SQL to make the SQL queries as generic as possible. • Fixed the existing bugs and codes. • Used SQL Profiler and other methodologies like indexing and referential integrity keys to tune the performance of the database.
• Developed SSIS Packages and SSRS Reports to process and transform the marketing data into the end-to-end customer acquisition and retention solutions. These solutions are then used by the clients to analyze the market trend and make strategical decisions to achieve maximum ROI. • Created SSIS Packages using different transformations, execute SQL task, script task, conditional split, OLEDB Source, OLEDB Destination etc. • Developed and designed Data Mart using ETL process that included creation of fact and dimension tables. • Scheduled the SSIS Packages under the SQL Server Agent by creating the SQL Jobs. • Created daily, weekly, and monthly SSRS reports such as Accounts, Email Campaign Overview, Email Campaign Summary. • Created dynamic cross tab reports using pivot in the stored procedure logic. • Set up the SSRS server and scheduled the reports on the same. • Created stored procedures and user- defined functions (UDF) that are used in SSIS packages and reports. • Used third party tool WinSCP in an SSIS package to transfer the file over FTP and SFTP server. • Used GIT repository as the source control version. • Used JIRA to manage daily and weekly tasks according to sprints created based on scrum agile methodology.
• Worked with Clients – IDB (Israel Discount Bank), American Express • Worked on enterprise Big Data repository to extract the report and analyze the credit risk, cross sell, and deepening of customers in Amex ecosystem. This repository contains the data from different feeds related to marketing offers, loyalty programs, rate changes, credit bureau information, and international consumers. • Designed and implemented tables, functions, stored procedures and triggers to implement the business logic as required by the client. • Used SQL Profiler to trace the activities of stored procedures and performance tuning them thereafter. • Created views and triggers for the quick access of the data and logging the activities performed on the tables. • Used Instead of trigger to update data in multiple tables through views. • Used Merge statement to insert, update, and delete the data in the tables. • Created SSIS Packages using different data flow transformations such as, Fuzzy Lookup, Condition Split, Term extraction, Aggregate, Slowly Changing Dimension, Execute SQL Task, and Data Flow Task to generate underlying data for the reports and to export cleaned data from OLTP System, Excel Spreadsheets, Text file, and CSV files to SQL Server database. • Implemented error handling, transactions, and logging in SSIS Packages. • Lead the team members in guiding the business-related information and explaining the project.
• Managed and developed web application for Curepet, a New York based pet healthcare company. o Gathered and analyzed client requirement. o Used C#, ASP.NET, MVC to develop different modules of the Web application. o Created the data importing tool and integrated it with the application to import the data from the third-party tool and save it in the local database. o Fixed the bugs in the application to maintain and make the error-free application. • Previously, worked in two projects for Singapore insurance companies, Parkway Shenton Insurance Pte Ltd. and International Medical Insurers Pte Ltd. (Subsidiary of Raffles Medical Group, Singapore). o Interacted with the client to understand the requirement. o Worked on different modules of the Web application developed in .NET. o Created and managed distributed applications, Windows and WCF service. o Fixed the bugs and tested the application for periodic reviews. • Developed and managed the database containing the health insurance and veterinary health applications data using stored procedures, triggers, functions, and views. • Created ER diagrams as per the design requirements of the business. • Worked on Indexes and constraints to optimize the database performance. • Used joins and sub queries to write complex T-SQL code. • Used Agile (Scrum) methodology to maintain project documents and source code files in TFS as per weekly sprints.