Ramesh Sajja

Delta is a critical application in the Integrated Service Platform (ISP), and it is the first centralized tool that supports all segments across Dell globally and provides many advantages to the agents and customers.

Responsibilities

• Created workflows and tasks in Informatica Cloud Data Integration (CDI) to automate data pipelines.
• Design scalable and efficient data pipelines, and data transformation logic in the IICS environment.
• Work with various data formats, such as flat files, relational databases, and cloud data sources, i.e., Amazon S3.
• Leverage IICS to integrate data from on-premise systems, with cloud-based applications and services.
• Worked on replication and synchronization tasks.
• Requirement analysis.
• Impact analysis for new requirements.
• Effort estimation for new development tasks.
• Delegating work to the team and guiding them in completing the work on time.
• Working with the DRE team, in case of any production issues.
• Preparing weekly status reports.
• Emergency production issue fix.

The Trade-In Experience project is for tracking the GE Healthcare trade-in business. Basically, whenever GE wants to buy back install-base products from customers, a quote will be created, and asset value will be provided. And these products are segregated based on their usage and kind of modality. Categories like GSC and SP will have more value than others. This trade in information will be received as files, and the same will be processed with Informatica. The target database is Oracle 10g. For some categories, we load data to the Postgres database.

Responsibilities

• Coordinating with source system owners, day-to-day ETL progress monitoring, data warehouse target schema design (star schema), and maintenance.
• Designed Informatica mappings by translating the business requirements.
• Worked with business analysts and the DBA for requirements gathering, business analysis, and designing of the data warehouse.
• Developed reusable transformations. Widely used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Workflow Manager.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Used workflow manager for session management, database connection management, and scheduling of jobs.
• Extensive performance tuning by determining bottlenecks at various points, such as targets, sources, mappings, and sessions.

The Enterprise Data Warehouse (EDW) is a post-paid data warehouse used across T-Mobile. The purpose of the EDW is to provide comprehensive, integrated, and centralized data of all the T-Mobile activities across the enterprise. EDW supports a wide range of operational and analytical reporting across various business groups. Based on business requirements, various business groups will act as business owners, and there is no specific business unit that owns the EDW. The EDW tracks the subscriber lifecycle from activation to cancellation for analytics.

Responsibilities

• Coordinating with source system owners, day-to-day ETL progress monitoring, data warehouse target schema design (star schema), and maintenance.
• Designed Informatica mappings by translating the business requirements.
• Worked with business analysts and the DBA for requirements gathering, business analysis, and designing of the data warehouse.
• Developed reusable transformations. Widely used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Workflow Manager.
• Used look-up, router, filter, joiner, stored procedure, source qualifier, aggregator, and update strategy transformations extensively.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Used workflow manager for session management, database connection management, and scheduling of jobs.
• Extensive performance tuning by determining bottlenecks at various points, such as targets, sources, mappings, and sessions.

Centralized Decision Technology (CDT) is a relatively new marketing concept, which seeks to:

Centralize the marketing decisions across channels to improve the customer experience (e.g., Avoid customers receiving multiple, and potentially inconsistent, promotions and communications across channels.

Move an organization away from 'product-centric' campaign management to 'customer-centric' marketing.

Have a more sophisticated view of the value of a particular customer to an organization, so that the more valuable customers can be retained and sold the most appropriate offers.

Responsibilities

• Designating work to team members and coordinating with the client.
• Creating STT, LLD, and involving in requirement gathering, and deploying code into different environments like QA, pre-prod, etc.