Sakshi Manro

PROJECT 1

Client : Citi Bank, New York, United States.

Environment : Tableau, SQL

Domain : Banking

DESCRIPTION:

This project is mainly involved to provide the services and support to core banking products like mutual fund in India. Domestic Mutual fund (DMF) is part of the investment product offered by Citibank Mainly to its retail customer. Customer can do various mutual fund transactions through different channels. Basically the Citibank has selected lists of AMC for whom the Citibank acting as a broker and for customer perspective it’s an additional service offering by the bank.

RESPONSIBILITIES:

• Involved in gathering requirements from the business user to analyze the requirements for a new report or changes in existing report and implementation of applications across systems.
• Implementing the requirements into the system using SQL procedure, functions, and packages.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Involved in enhancing the SQL Stored Procedures, triggers and created Indexes for maximum performance.
• Coordinating and working in association with different teams assigned to different related functional areas to get the things done.

PROJECT 2

Client : HUMANA Inc

Environment : Tableau, SQL

Domain : INSURANCE

DESCRIPTION:

We Work with medical claims data and maintains the highest levels of data accuracy, security and integrity. Extensive, customizable testing and data validation techniques. We apply descriptive, predictive and prescriptive analytics across data sets to help you understand what happened, what could happen and, most importantly, what you should do.

RESPONSIBILITIES:

• Responsible for design, development, testing and implementation of applications across systems.
• Mingle with team as well as work individual work to meet deadline.
• Developing data model to create reports and dashboards.
• Creating rich dashboards using Tableau Dashboard and applying actionable insights.
• Produce standard monthly reports using Tableau.
• Created dashboard designing with effective data visualization of large data volume from data sources.
• Developed Tableau data visualization worksheets with different styles like bar, pie, tree map, dual axis, donut chart and Geographic Map.
• Combined multiple dashboards into single story to enhance the visual appeal of the report.
• Involved in support related activities like monitoring server and working on incidents.
• Participating in bridge calls and collaborate with clients and onsite folks.
• Delivering project goals and overview to the new joiners and freshers.