Project Data Analyst
Resume:
Aiswariya Aiyathurai
Email : *********@*****.***
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