Rajkumar Thanagarajan

• Responsible for all Development/Enhancements in BI
• Project execution, tasks completion, delivery of the tasks, customer interfaces and project status reporting for the project
• Review the work of team members, ensure that it is as per laid down specifications by project and meets the desired quality standards
• Lead Business Intelligence team worked on following specific project areas

Led agile project focused on developing analytical metrics within enterprise data warehouse.

Spearheaded migration of existing data flow orchestration to Snowflake using DBT and Airflow.

Executed migration of existing WCS RD to PROS platform, ensuring seamless transition.

• Managed the full lifecycle of development and enhancements to improve business intelligence capabilities.
• Assisted in executing project tasks to meet deadlines. Supported customer interactions to address project needs. Reported project status updates to stakeholders regularly.
• Review the work of team members, ensure that it is as per laid down specifications by project and meets the desired quality standards
• Lead Business Intelligence team from onsite and worked on following specific project areas

Led agile project focused on developing analytical metrics within enterprise data warehouse.

Executed migration of data warehouse to Snowflake, enhancing data accessibility.

Executed interface integration between Oracle Retail Integration (CIM, RPM, RMS, RPAS, and RESA) and Snowflake systems.

Spearheaded development of new integration programs to enhance Snowflake data warehouse capabilities.

• Managed support operations and enhancements for business intelligence systems to improve analytical capabilities.
• Assisted in project execution by addressing escalations. Completed quality assurance tasks to ensure delivery standards. Supported customer interfaces and reported project status updates.
• Review the work of team members, ensure that it is as per laid down specifications by project and meets the desired quality standards.
• Coordinated knowledge acquisition efforts for BI applications and developed SMTD documents to enhance clarity during knowledge transfer.
• Lead Business Intelligence team from onsite and worked on following specific project areas

Facilitated agile project focused on constructing analytical metrics in enterprise data warehouse, consolidating data sources from WCS, OMS, and IBM core metrics.

Executed migration of data warehouse to Snowflake platform, enhancing data accessibility.

Executed interface integration between Oracle Retail Integration (CIM, RPM, RMS, RPAS, RESA) and Snowflake systems.

Developed and implemented analytical metrics aggregates and reports to meet business requirements.

Project 4 :

Client : Petco(USA)-Business Intelligence Team

• Tools: Netezza, SQL server, MicroStrategy, Shell Script, SSIS, SSRS, R Analytics

Responsibilities:

• Managed comprehensive development and support processes for business intelligence systems, focusing on continuous improvement and user satisfaction.
• Assisted in executing project tasks and managing escalations. Supported quality assurance efforts to ensure task completion. Facilitated customer interfaces and communicated project status updates.
• Evaluated team members' work to ensure compliance with project specifications and quality standards.
• Coordinated knowledge acquisition efforts for BI applications and developed SMTD documents to support effective knowledge transfer.
• Directed business intelligence team on-site, overseeing project execution and strategic initiatives.
• Led agile project to develop analytical metrics within enterprise data warehouse, integrating data from WCS, OMS, and IBM core metrics.
• Executed R-analytics deployment to enhance data analysis capabilities within Netezza framework.
• Executed interface integration between Oracle Retail Integration (CIM, RPM, RMS, RPAS, RESA) and Enterprise Data Warehouse (Netezza).
• Developed and compiled comprehensive metrics aggregates and reports to meet business requirements.
• Managed multiple projects focused on enhancing business intelligence capabilities through innovative development strategies.
• Executed migration processes from SQL Server 2000 to SQL Server 2005 and 2008, ensuring data integrity and system compatibility.
• Facilitated conversion of DTS processes to SQL Server 2008, enhancing data management capabilities.

Project 3 :

Client : DHL(UK) – Application Development Team

• Tools: ASP.NET, VB.NET, SQL Server 2005, SSIS & SSRS

Responsibilities:

• Prepare project estimation, resource loading and schedule for proposal
• Working with clients on the Requirements, for the new development projects
• Provide technical solution design and prepare the BRS and SDS documents
• Review the work of team members, ensure that it is as per laid down specifications by project and meets the desired quality standards.
• Responsible for project execution, escalations, quality assurance, tasks completion, delivery of the tasks, customer interfaces and project status reporting for the project

Description:

• MART matching & resolution tool is to provide solution for unmatched intercompany transaction and processing which are not cleared in the source financial systems and that can be leveraged globally
• MART performs a data matching algorithm and resolve unmatched items that cannot be resolved automatically by source transaction systems.
• Facilitate to maintain historical data, allows the tracking of old items and enabling workflow. Facilitate to send Intercompany Request for Credit Note (IRCN) globally.
• Workflow to assign the unresolved items to teams, accountants, products & stations and to record feedback

Project : 2

Client : IATA-Application Management Team :

• Tools : ASP.NET, VB.NET, C#, VB, ASP and PHP
• SQL Server 2000, ORACLE9i and 10

Responsibilities:

• Provide technical support, mentoring & coaching team members on technology, business & other project specific aspects.
• Review the work of team members, ensure that it is as per laid down specifications by project and meets the desired quality standards.
• Work on estimates and allocate resources to a particular task in consultation with reporting lead/reporting manager.
• Responsible for project review, escalations, quality assurance, tasks completion, delivery of the tasks, customer interface and project status reporting for the project.

Description:

• AMS is a set of 70 applications developed in various technologies.
• Most of the applications are used to serve the airline industry and some applications helped the client to manage their internal operations.
• The applications are high critical in nature in the way they support the industry and the business.

Project 1 :

Client : Shell - SystemOnE

• Tools: ASP, VB and VBA, SQL Server 2000 and IIS
• Responsibilities:
• Provide technical support, mentoring & coaching team members on technology, business & other project specific aspects.
• Review the work of team members, ensure that it is as per laid down specifications by project and meets the desired quality standards.
• Work on estimates and allocate resources to a particular task in consultation with reporting lead/reporting manager.
• Description:
• SystemOnE is a web-based application that assists SHELL to manage their Project Portfolio. It maintains various types of business projects for their project plans.
• Projects are having different funnel stages and funnel stage status, to achieve their plans.
• It has types of Authentication Levels and series of checkpoints for approving the funnel stage and status.
• The Project templates covering all the business aspects of shell business project plan e.g. Economics for cost estimation, HR for resource planning and etc.
• Different type of reports, extracts, charts and power point presentations generated dynamically from the SystemOnE application.
• Different types roles and access types for users and administrators helps to control and maintain the application flow.