Aurea is an international enterprise software company that helps large global enterprises like Disney, British Airways,  eBay, Evobus, etc.. creates transformative experiences for their end customers. 

Role : Support and new development of Tableau dashboards. Majorly moving existing crystal reports into tableau and creating tableau dashboards. The base reports are developed in crystal reports for Remedy system and we migrated all crystal reports in Tableau Dashboards. 

Responsibilities: 

• Extract Data from multiple sources like Flat files, Oracle, and SQL Server.

• Coordinating with the Client team to verify the data/view/stored procedures availability. 

• Developing New Tableau Dashboards and support existing dashboards.

• Developing Dashboards for complex requirements

• Creating Visualization charts on Data Requirements

• Publishing tableau dashboards and extracts and schedule extracts based on the requirement

• Worked on Transformation and Aggregation Logic  in ensuring Business Analytics requirements are met in collaboration with Data Scientists and Data engineers

• Conceptualized, Designed, and Developed data concepts into Clear communication

• Involved in performance tuning of mappings, identifying source and target bottlenecks and worked with the sessions and workflow properties to improve performance.

In operations from Sep ’2012, I was dealing with various reports generation and analysis.  Analysis of data from various sources and reports generated from various machines.

Responsibilities:

• To find out the new Risk/fraud patterns in the EU region

• Involved with large data cleansing and mining using SQL environment and analysis of reports generated from SAS, OBIEE machines. 

• To update associates regularly on upcoming trends in fraud and risk in online transactions

• To analyze auto-generated reports from various machines like OBIEE, ETL & SAS. 

• To publishing Daily, Weekly, and Monthly updates and ongoing activities in the team

• To manage workflow as shift PoC

• Maintaining JIRAs every day depending on the severity of Ticket

Tool Engineering team: Apart from these regular duties, I was part of the “Tool development engineering” team, “Where we work on tool improvement and development ideas from associates”.

Responsibilities: 

• Studying and analyzing tool improvement ideas from associates. 

• Generating and validating Use cases & Test cases 

• UAT and Sign off on new enhancements on tools

• Providing feedback on bugs and enhancements. 

Providing End-to-End solution on Pilot operations and Sick management systems and    Guaranteed Fare Transition Program. These applications provide escalation and resolution facilities to Fed-Ex employees and   Pilots. 

Responsibilities: SCRUM and JIRA Administration

• Ensuring the Scrum team meating it’s all SCRUM Values with out fail
• Organizing SCRUM ceremonies
• Planning and Deriving Sprints and Releases
• JIRA administration to Maintain & Track  SCRUM metrics 
• Coordinating with Global team and Team members  and to ensure the Development process is Smooth
• Prepare and managing SCRUM Board and KANBAN board to improve the visibility of progress.

Client: MOL – Mitsui OSK Lines

• Extract Data from multiple sources like Flat files, Oracle, and SQL Server.

• Developing New Tableau Dashboards and support existing dashboards.

• Understanding the ETL Specification Documents for mapping requirements.

• Extensively working on Informatica tools such as Source Analyzer, Target Designer, Transformation Designer, Mapplet Designer, and Mapping Designer to design, develop and test complex mappings and Mapplets to load data from external flat files and RDBMS

• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Joiner, Union, Sequence Generator, and Update Strategy.

• All errors encountered were documented using an Issue Log.  Interacted with team members to resolve the errors encountered.

• Involved in performance tuning of mappings, identifying source and target bottlenecks and worked with the sessions and workflow properties to improve performance.