Ramki Sudersan

The Roads and Transport Authority (RTA) in Dubai is an independent government body responsible for planning and providing the emirate's integrated transportation system, including roads, public transport, and traffic management. RTA aims to keep supporting and offering a wide range of services to residents and visitors.

 Defining Solution Architecture: Creates a holistic technical vision for the data solution, outlining the architecture, components, and their interactions.

 Designs conceptual, logical, and physical data models, considering factors like scalability, performance, and data governance.

 Working closely with different stakeholders from multiple functions to understand and gather the requirements.

 Conducted stakeholders meeting every week to accomplish the project scope and minimize the project risk.

 Involved in the development of Informatica BDM mapping to build centralized Data Lake solution in client. Automate the various manual process of Data ingestion, File validation, applying business rules. Different flat files like text, Excel with multiple sheets, etc

 Implement the integration of the data solution with other systems and applications within the organization.

 Handled multiple sources, like; Legacy DB, HIVE, flat files, JSON, XML, API, Web Services.

 Utilize geospatial technologies such as GDRFS, ArcGIS data for location-based analytics.

 Implemented/Maintained the FINANCE Dashboard’s data integration with the complex logics on the multiple source systems, Like NOL, AVM, Hyperion, Maximo, E-Traffic, GRP, DTS, Manual Files, etc.

 Multiple projects/dashboard/use cases are delivered as part of the client assignment like: Compliance, ACS, CEO, Director Finance, Ridership & Crowd Management Dashboard.

 Continuously monitor End-to-End project Development including MicroStrategy web & Mobile Dashboards, Dossiers and Reports. To provide the on-time implementations /delivery to stakeholder that support business decision-making.

DESCRIPTION:

FAB, the UAE's largest bank of the largest of experience.

• Developed detailed project plans, ensuring resource availability and delivered project on time within budget and scope.

• Conducted stakeholders meeting every week to accomplish the project scope and minimize the project risk.

• Projects involved in the development of Informatica BDM mapping to build centralized Data Lake solution in client. Automate the various manual process of Data ingestion, File validation, applying business rules. Different flat files like text, Excel with multiple sheets, etc

• Data ingestion using dynamic mappings

• Migration of Siebel CRM to Microsoft Dynamic 365 CRM related DW & Power BI dashboard implementation.

• Captures Dynamic CRM data using ADF (Azure data factory) through Microsoft Power APPs & Microsoft DATAVERSE synchronization.

• Store the data into Azure Data Lake (ADL).

• Configuring the CI/CD pipeline in Azure Data factory using Azure Repos GIT.

• Providing CLM downstream extracts using HDFS files system & functional process: RISK (Moody's & SAS), MDM, Data governance, Data visualization, etc

• Developed Python based utility to automate the Multiple sheet excel source files (even though 1000+/N number of files at a time).

• Build a centralized ONEMI SSAS Cube model platform to have both Financial and Non Financial data having direct or indirect relationship. Utilize One MI platform to perform Analysis against the CARDSDB, Credit card Global Transaction Banking (GTB), etc.

• Reconcile the card transactions with the ODS posting file and the GL hierarchy aggregated table value for the corresponding GLs

• Handled Numerous RECON issues, including: ODS postings missing, GL postings incorrectly mapped, additional postings discovered on top of credit cards, manual postings discovered without authorization, reversal transactions not captured in ODS postings, DR and CR Internal A/Cs having the same value, etc.

 Provided Architectural Road Map, direction and work packets for ETL needs.

 Created detail ETL Standards documents for Design, Development, Release Management and Production Support.

 Coordinated with Business and end Users as Technical Lead to understand business needs and requirements

 Analyzing the effort and providing the estimation to the client.

 Design (Low Level Design), Coding, Unit Testing, SIT, UAT Support and Production Support.

 Prepared HLD (High Level Design documents), TSD (Technical Specification Documents) and SOP (Standard Operating System) documents.

 Since A Project started from scratch, I had totally involved for requirement gathering, understand the very different/complicated requirements and analyzed the data well.

 Developed complex mappings in Informatica to load the data from various sources.

 Implemented performance tuning logic on SQ, targets, sources, mappings, sessions to provide maximum efficiency and performance.

 Developed the code for complicated logics and completed the UNIT testing successfully.

 Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.

 Used CONTROL – M tool to execute batches with the logic embedded in the mappings.

 Involved in the migration and Project PRODUCTION deployment activities.

 Transitioning the development to the Service Management support team.