Objective: To provide Day-to-Day Insight of Manual Check Team and cost involved in generation of manual checks.

Tools Used: Tableau, Oracle SQL developer

• Understand requirement, analyzing systems and source databases.

• Created views to extract data from different database system in desired aggregated formats.

• Built dashboard using tableau providing insight of manual checks for different product ADP.

• Represented data using visualization such as charts trend lines and reference lines.

• Used different types of filters on dashboard few for security and few for user control.

• Used Actions at dashboard level.

• Created customized charts using advanced features and logics.

• Used in-built Tableau prediction to guess number of manual checks that can be issued next week.

Objective: To provide insight of all teams under the umbrella of COS Service Delivery.

Tools Used: Tableau, Oracle SQL developer

• Understand requirement, analyzing systems and source databases.

• Created views to have data in desired aggregated formats.

• Built dashboard using tableau providing insight of different service delivery team’s performance.

• Represented data using visualization such as charts trend lines and reference lines.

• Used different types of filters on dashboard few for security and few for user control.

• Used Actions at dashboard level.

• Created customized charts using advanced features and logics.

Objective: To provide insight of the tasks performed by all teams and their utilization.

Tools Used: Tableau, Microsoft SQL Server

• Understand requirement, analyzing systems and source databases.

• Created views to have data in desired aggregated formats.

• Built dashboard using tableau providing insight of different team’s efficiency.

• Represented data using visualization such as charts trend lines and reference lines.

• Used Actions at dashboard level.

• Created customized charts using advanced features and logics.

Objective: To automate the whole 401K processing team calculations using reports.

Tools Used: SSRS, SQL Server 2014

• Understand requirement, analyzing systems and source databases.

• Extracted data from the internal data warehouse system to SSRS.

• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports, supported more than 100 COS client.

• Designed and developed stored procedures, queries and views necessary to support SSRS reports.

• Extensively used joins and sub-queries for complex queries which were involving multiple tables from different databases. Analyzing data and re-mapping fields based on requirement.

Objective: To automate the garnishment team day-to day calculation and activity using reports.

Tools Used: SSRS, SQL Server 2014

• Understand requirement, analyzing systems and source databases.

• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports, supported more than 110 COS and NAS client

• Extensively used joins and sub-queries for complex queries which were involving multiple tables from different databases. Analyzing data and re-mapping fields based on requirement.

• Scheduled and managed daily/weekly/monthly Garnishment reports based on the business requirements.

• Worked closely with the offshore team in finding solutions to arising problems.