Karthik Sundar

• Client: eBay
• Project Title: MAP Analytics
• Project Brief:

eBay is a multinational e-commerce corporation, facilitating online consumer-to-consumer and business-to-consumer sales. The Marketplace Analytic Program is designed to provide phenomenal value by simplifying how to find and use data to drive strategy, insights, and actions. It takes reporting to the next level, both in how the business story is told and how it is derived through intelligent design and smarter data integration to enable quicker decisions and actions.

• Responsibilities:
• Requirement Gathering and Documentation:

Collaborate with business units and users to gather requirements and document technical specifications, analyze data to forecast sales trends and identify any abnormalities, and monitor project plans to highlight any deviations from the initial project roadmap.

• System Architecture Design:

Design scalable system architectures to meet technical requirements, map technical requirements to subsystems, and ensure alignment with user needs.

• Data Processing:

Develop jobs for data extraction, transformation, and loading (ETL) using complex SQL scripts, by creating Hive tables, and by using Unix shell scripts for data processing.

• Testing and Quality Assurance:

Prepare unit test case documentation, and conduct unit testing. Track, troubleshoot, and resolve defects identified during test execution. Perform integration testing to ensure seamless module integration. Reconcile data across various source systems and databases.

• Deployment and Support:

Collaborate with the release management team to deploy code to the production environment. Monitor applications in production, providing real-time support for issue analysis and resolution. Implement monitoring and alerting tools to ensure operational efficiency.

• Client: Telstra
• Project: BIDW Non-Discretionary Program (Enterprise Data Warehouse)ehouse)
• Project Brief:

Worked in the EDW (Enterprise Data Warehouse) team for Telstra, Australia's largest telecommunications company, on a data warehousing project. Telstra is one of the best-known brands in the country, which provides services across all market segments – Consumer, Business, Enterprise, Wholesale, and Global.

• Responsibilities:
• As a part of this project, we extract OLTP data from the source and then load it into DW tables. After loading, business logic is applied, and data is loaded into the Access Layer, from where users can create views and reports relevant to business accomplishments.
• Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply, and Filter. Working on identifying and fixing the issues in existing ETL jobs.
• Working on performance improvement and space optimization processes.
• Worked on shell scripts to automate and process improvement tasks, and to avoid failures in the process. Working on Teradata BTEQ to transform the business data into user requirements. Working on the BI reporting tool Tableau to produce an interactive dashboard.