Resume

Sign in

Project Data Analyst

Location:
Henrico, Virginia, United States
Salary:
100000
Posted:
October 15, 2018

Contact this candidate

Resume:

Aiswariya Aiyathurai

Mobile No : +*(***) -***-***6

Email : ac7d5f@r.postjobfree.com

Passport No : L9136527

Summary

To work for an organization which may utilize my skills and potential to deliver robust and innovative solutions in today’s competitive environment. I am willing to work as a key player in challenging and creative environment. I want to establish myself as a successful development and administration professional. I look forward in acquiring a position in a reputed organization and work assiduously towards achievement of organizational goals.

I am currently working in COGNIZANT TECHNOLOGY SOLUTIONS as an Associate with around 7 years of experience.

Skills

Key Skills

7 years of experience in data analytics/ Business Intelligence industry focused around EAI tools and implementation of applications in BI&BFS domain.

Have rich experience in life science/Retail domain under advanced solution practice & business process integration by doing analysis of clinical trials.

Rich domain Knowledge on Banking and financial sector, Retail, Life science and Marketing survey.

Excellent knowledge in developing medium to complex visualizations and analysis report for different applications and portfolio using Tableau desktop and Tibco Spotfire.

Having good experience on the administration part of Tableau/Spotfire in creating user, groups, upgrading from lower version to higher and giving licenses to them of Spotfire.

Experience in server Hotfix, LDAP configuration, config and xml files creation and trouble shoot, folder management etc.

Good Knowledge in Advance Data Services and Composite.

Good Experience in TIBCO Business Works Designer.

Strong analytical skills, communication skills and flexibility to learn and work on any platform.

Good knowledge in Business Objects and Good Knowledge in Tableau/Spotfire

Trained people in both Tableau & Spotfire admin and development for around 2+ years.

Created medium complexity reports in Service Now product suite

EAI and Data Analytics Tool:

Tableau 9.x and 10.x, TIBCO Spotfire Professional client, TIBCO Automation services, TIBCO Application Data service (Composite), TIBCO Active Space, TIBCO Business Works.

Microsoft Tools

MS Word, MS Excel, MS Powerpoint

Other Tools

Composite, Web intelligence, Crystal report and Business Objects XI reports

Databases

Oracle 10g, MS SQL server 2008, T-SQL server.

Scripting Languages

JavaScript, HTML, CSS., Iron python basics.

Hardware / Platforms

Windows 98/XP/2000, 2007, Unix.

Build Tools

Maven

Education and Certifications

Title of the Degree with Branch

College/University

Year of Passing

Bachelor of Engineering in Electronics and Communications

Thirumalai Engineering college/Anna University

2011

CCP Level0: Banking and Financial Services

Cognizant

2012

Employment History

Date

Company Name

Role

Nov 2011 – Present

Cognizant Technology Solutions

Associate

Project Experience

1.CARMAX Inc.:

Operating System

Windows 7

Role

Lead Data Analyst

Team size

15

Tools

Tableau 10.x product suite, Server and web Client, MS SQL Server 2012, Spotfire product suite, App dynamics, Service Now reports, Microsoft BizTalk

Period

September 2017 to Present

Employer

Cognizant Technology Solutions

Project description

This project is about systems integration various applications integrated with each other to form a complete workflow of system

Role and Responsibilities:

1.Lead the Analytics team from client site by allocating work to resources and helping them understanding the requirements.

2.Product owner owns the technical design and modification and communication to business stake holders and business systems.

3.Works with Business to identify opportunity of improvement in all Analytic product reports and process

4.Guide and create complex analytic reports using Tableau, Spotfire & Service now.

5.Creating complex stored procedures, queries etc using Sql for data make up of reports from raw data.

6.Support and testing of Analysis reports in systems integration team as per the live report monitoring.

7.Involved in enhancement and support of application which is built in various technologies like TIBCO, Tableau,BizTalk and App dynamics.

Contribution:

Lead the data analytics team with end to end activities from designing till delivery.

Optimization and problem-solving techniques for all the analysis reports

Created complex tableau reports as well as monitoring the live reports

Played major role in timely deliverable of all the dashboards with stringent timelines

Validating Analytic report, complex stored procedures, queries etc. using Sql where data make up of reports from raw data is made

Testing for all the new location opening with the multi-level finance partners of Carmax.

Played major role in timely deliverable of all the requirement gathering and documentation in accordance with Analytic designing in Tableau/Spotfire.

Proactively owned and worked on all the Tableau, TIBCO and BizTalk integration products which correlates with the Analytics team.

2.IPSOS Reporting Platform:

Operating System

Windows 7

Role

Lead Analytics Developer

Team size

5

Tools

Tableau 9.x product suite, Spotfire Professional Client, Server and web Client, MS SQL Server 2012

Period

May 2015 to September 2017

Employer

Cognizant Technology Solutions

Project description

This project is about Marketing Survey where analysis reports are created based on the KPI’s, Questionnaire etc.

Role and Responsibilities:

1.Gathering the requirements provided and setting up of data which supports reporting accordingly.

2.Solves business problems as needed and technical solutions event with creation of new dashboards from the scratch according to the problems

3.Creating Queries, stored procedures, views for the data’s in database

4.Documents and owns the functional and technical design of the process and systems.

5.Lead the project team added to by allocating work and helping them understanding the requirements.

Contribution:

Gathered requirements for the dashboard creation based on market survey.

Optimized performance of a report where performance shot up from 7 mins to 10 secs.

Sole ownership for one of the most complex dashboard developed.

Played major role in timely deliverable of two big analysis reports with stringent deadline.

Hosted two environments in one server which was one of the most challenging tasks.

Played major role in significance/statistical testing development and integration of R script.

Created Java script visualizations for complex requirements and beautified the dashboard using jQuery Accordion. Created Email Out functionality using Automation services.

Used Iron python scripts for few actions like carrying of filters from one filtering scheme to other, toggling between different visualizations etc.

Created launch pad which is a one stop point to access all the dashboards in the project.

Designed and developed complex dashboards like Mondelez, Scorecard where complex SQL procedures are used to consume data as per requirements.

Supported in migration of templates from one environment to another.

Used Zoom in and out of static visualizations present in a single page. Developed customized dashboard with dynamic Axis types, chart type, color by etc.

Supported post production activities like analysis of defects and issue fixing within due time.

Perform database testing and dataset analysis used for all the created analytic reports

3. Abbvie RandD study setup(DSS):

Operating System

Windows 7

Role

Team Member

Team size

1

Tools

Tableau 9.x product suite, Spotfire Professional Client, Server and web Client, MS SQL Server 2012

Period

December 2013 to May 2015

Employer

Cognizant Technology Solutions

Project description

This project is about clinical trial where analysis reports are created based on subject details, Lab results, grading details etc.

Role and Responsibilities:

1.Enhancement of existing report.

2.Creating new dashboards from the scratch according to the requirements.

3.Creating Queries for the data’s in database

4.Test analytic reports and create system documentation and user manuals.

5.Interacts with System architects and developers to ensure the system implementation strategy.

6.Design and documents functional and technical design of systems

7.Used Business Works designer for basic integration of Applications.

Contribution:

Created medium to complex SQL queries and procedures to consume data into Tableau.

Created jobs to save and export to Library using automation services.

Designed dashboards for new clinical trial requirements.

Exported and Scheduled updates using Automation services and Web player for faster load time.

Delivered all the report before deadline.

Delivered reports with minimal or zero UAT defects.

Supported in promotion of dashboards to various environments.

Created BOXI reports.

Worked on web intelligence tool in creating Business Objects reports.

4. GCST vPayments

Operating System

Windows 7

Team Size

7

Tools

RAD, MS Visio

Role

Team Member

Period

JAN 2013 to April 2013

Employer

Cognizant Technology Solutions

Project Description

In vPayments project, we redesign the existing vPayments application into the one completely owned by client eliminating a third-party sector. It mainly concentrates only on corporate cards but not consumer cards. In this we have various work streams in which we have designed Business process flow till technical architecture.

Role and Responsibilities:

Technical Diagraming

Business Analyst.

5. AMEX MYCA UMS Intl

Module

LILO, Omniture, OCE Intl,

Team Size

2

Role

Tableau Developer

Period

May 2012 to July 2013

Tools

TIBCO Spotfire product Suite, SQL Server

Role and Responsibilities

1.Creating dashboards for banking application using Tableau

2.Deployment and migration of reports from one environment to other.

3.Back up for team leader and Business Analyst to communicate and gather requirements from clients.

Project Description

There are various modules like LILO, Omniture and OCE Intl which I have worked under same project. In LILO module, we redesigned the existing Log Off page with PZN and third-party integration with added functionalities. In Omniture tracking module, we are tracking the users entered the specific application by using Web Analytics & (Adobe Site Catalyst) Itag and Analysis report. Tableau/Spotfire is used to track and analyze the application using visualization and dashboard. It helps to track the users hit to specific applications. OCE is Online Card Engagement it deals with two services which is of Card activation and Card registration. The project is to overhaul, rethink and rebuild the online activation and MYCA Registration processes which includes improved customer experience, better servicing, and tracking the analyzing the improvement using analysis reports prepared using Reporting tool like Tableau/Spotfire.

Contribution:

Developed a configuration page for dynamic function across the modules.

Created Combination chart to find the count of card applications having existing Log Off pages and uplifted Log Off pages.

Depicting the maximum and minimum number of users using the applications with uplifted log of pages using Heat Map. Used Property controls to select different kind of third party integration.

Created Map chart to show which country has maximum card applications with uplifted log off page. Used Map chart to depict which Country has the maximum users hitting the url of Card Applications.

Created different groups and users in admin for application users with existing Log Off pages and uplifted Log Off pages and giving permissions accordingly.

Tracked the Maximum, Average and Minimum Number of Users logging in and Logging out using Heat Map. Created a hierarchy for Country/Region/City and used it in Tree map to find the number of users.

Created analysis report for number of cards activated and number of cards registered before the rebuild of the application for the period of 1 year using Summary Table, Cross Table with Detailed Visualization.

Statistical metrics of improved customer and service experience percentage in average of half yearly basis.

Created CMR (Change Management Request) report depicting the Changes done in the application with respect to Date using Line Chart with Details of visualization.

As admin created different users and groups and provided licenses with respect to Cards.

Used composite services to fetch data from web services to Spotfire.



Contact this candidate