Vamshi Swargam

Environment : Tableau 10.x, Trillium 15, MS Excel
Team Size : 5
Description :
The Client is an American financial services corporation, with assets of approximately $366 billion, as well as deposits of approximately $249 billion. The Client has operations include a regional banking franchise operating primarily in nineteen states and the District of Columbia with more than 2, 600 branches, online and mobile services together with 9000 ATMs, specialized financial businesses serving companies and government entities, and asset management and processing businesses. In the U.S., The client is the fifth largest bank by number of branch offices, sixth largest by deposits, ninth largest by total assets, and third largest by number of off-premises ATMs.

The main aim of this project is to check for completeness and conformity on credit card data, these checks were done on Trillium and then the results are exported to Excel file and then imported into Tableau to create the detailed reports as per the client requirement.

Responsibilities:
•Worked on Trillium tool to process the business rules.
•Imported data from Oracle and processed in Trillium based on business rules.
•Connected to different databases like oracle and excel.
•Developed various reports as per client requirement.
•Interacted with onsite managers and clients to get the requirements.
•Used filters, Parameters, Data Blending and Actions in tableau.
•Attended daily status call with onsite team.

•Project #2:

Title : Care Wise Health

Tableau 8.x/9.x, SSRS 2008, Oracle 10g, MS Excel
Team Size : 7
Description :
The benefits administration company SHPS Inc. formed Care wise Health in 2003 to develop health and wellness programs. Care wise Health became a driving force in the new area of wellness and care management a diversified group of innovative customers.

The main aim of this project is to migrate the project is from the SAS Existing Reports into Tableau.
There reports are like daily, weekly, monthly and quarterly for clients of carewise.the main clients of care wise are Premera, Avaya, Microsoft, Labcorp and Amazon.
Responsibilities:
•Worked for Different Reports like PDF and Excel.
•Created different reports like 1 page, 15 page and 35 page reports in Tableau.
•Connected to different databases like oracle and excel.
•Developed various reports as per client requirement.
•Interacted with onsite managers and clients to get the requirements.
•Used filters, Parameters, Data Blending and Actions in tableau.
•Attended daily status call with onsite team