Avik Basu Email & Phone Number

Bengaluru, Karnataka, India

• Project - FlowServe:
• Designing the Architecture for the Project by creating the design by considering the various aspects - the Volume of the data and the Cost factors associated with the Storage of the data and the ease of accessibility.
• The Architecture Design was also approved by the Microsoft Team when we presented the design in a discussion with the Microsoft team along the client.
• Preparation of the Database design by studying the data and then preparing the different Dimension tables and the Fact tables and then identifying the columns for each of the tables and then identifying the Primary.
• Preparation of the Python Notebooks to consume the data from the different html files which are the Input source for the Project and then cleansing the data and then parsing the data and then preparing the Spark data.
• Interacting with the Client to understand any specific requirements and getting clarification for the different queries surfaced during the development of the project.

Chennai, Tamil Nadu, India

• Project - Dialmer Trucks North America:The Project deals with ingestion of real time truck sensor data into Azure Data Explorer (ADX) cluster from Azure Event hubs. The data is stored as parquet files in ADLS via.
• Preparation of data model and designing the table for all modules for the entire Operations.
• Preparation of Pl-Sql Stored Procedures for CRUD operations on the table data via API.
• Coordinating with the BA, Front-End, API team to design the Front-End screen for the CRUD operations on the Dimension and Fact tables and creating the Pl-Sql Stored Procedure for the same.
• Working on the Customer tickets and request - providing Operation Support for the above Systems.

Bangalore

• Project - Pine: The Pine Project implements Master Data Management Solutions to obtain the golden copy of the Customer records from the various Data Sources by using the AllSight Tool and the Big Data Eco System.As.
• Running Pig script to pull the data from Terradata & GreenPlum tables and prepare the avro files for Ingestion from various Source Systems.
• Ingestion Pipelines (StreamSets) were triggered in batches for consuming the Input source files.
• The Pipelines performed various Transformation to cleanse, format, split the data as Org/Person types.
• Address Standardization was performed by splitting the Address component and passing the same through AVS component and stitching the standardized address component back to the data via Py-Spark jobs.
• The Transformed data was finally ingested into appropriate Hive tables by running Py-Spark jobs.

Bangalore

Project – ANZ The project is on Banking domain with Australian and New Zealand Bank. Among the various modules ANZ has the MDM module is of significant importance. The MDM module has been implemented to take data inputs from several sources mainly Internet Banking, Mobile Applications and the various data feed from the Banking operations. The input sources.

Bangalore

• Project – Otsuka Pharmaceuticals. The Otsuka Pharmaceuticals has implemented the Master Data Management Solutions for their Customers, Products and their Sales Team with MDM tool - Informatica MDM.The Customer data.
• To ensure that the Daily Load Cycle (Cadence) was Initiated and monitored and Completed.
• To notify the Client and the Data Steward Team regarding the completion of the Load Cycle and when they can use the Environment for their activity and also to prepare and provide the Client with the various types of.
• In case of problems with the Load cycle - To Identify the cause of the problem and coordinating across different teams to resolve the problem and let the Load Cycle complete its run.
• To constantly monitor the various phases of the Data-flow during the running of the Load Cycle.
• Working closely with the client and the Onsite team to discuss and resolve the various problems.

• Project - Pfizer
• Working with the ETL Tool Talend 5.0 – Extracting the data from the various Source Systems and Loading them into the data tables onto the MDM layer.
• Working with the MDM Tool Siperian – Configuring it to take the feed from the ETL layer and after going through the Staging, Loading and Match & Merge process, providing the golden copy of the Data.
• Worked in Software Testing with Printer Driver, Mobile and Telecom domain testing.
• Worked with Software Automation Tools – QTP and Selenium with JUnit, NG, RC and WebDriver.
• Went Onsite with Lexmark Printer Driver Testing Project, to learn and train in the Apple – Macintosh Environment and then preparing the Offshore Test Lab to carry out the Mac Testing from Offshore.

B. Tech, Pharmacy

Pgdm, Operations Management

Higher Secondary, Physics, Chemistry, Mathematics

Div - I

Secondary, Physics, Chemistry, Mathematics, Biology, Language, History, Geography Etc, 77%