Rashmita Jena

PROJECT-1(Global SALES package – Core Project)

GOP manages the data and order from different sources to Datawarehouse.This project is a part of developing and building Global Sales package table for APJ, AMER and EMEA regions for generating the CHANNEL SALES REPORTS reports. The global sales package table is building up with Global Models for Orders, Item and Customer subject areas extracting from the different kind of Omega tables and can be loaded to base tables before building up the Global sales package table.

Roles & Responsibilities:

• Designed and developed ETL mappings using Informatica Power Center Designer, Workflow Manager, and Monitor tools, ensuring alignment with project requirements and efficient data processing.
• Good Exposure on writing SQL queries.
• Designed, developed, and maintained Control-M jobs to automate and schedule data processing workflows, ensuring timely and accurate data delivery
• · Extensively used ETL tool for supporting the Data Extraction, Transformation and Loading in a corporate-wide data warehouse using Informatica Power Center 10.2/10.5 versions.
• · Worked with different data sources like Flat Files, SQL Server, Oracle and Teradata.
• · Performed efficient testing of the ETL mappings and the transformed & cleansed data in Dev and SIT environments to match the user requirements and the data quality in the warehouse.

PROJECT-2(Millet Procurement Automation System)

MPAS has been implemented to automate Millets procurement and channelize the online payment to the bank account of the farmers against the quantity sold under Govt of Odisha. All 15 districts of Odisha participated in procurement of millets and TDCCOL was the state Level agency for procurement of millets.

Roles & Responsibilities:

• Work with stakeholders to identify business needs.
• Gather and document functional and non-functional requirements.
• Analyze business processes to determine areas for improvement.
• Ensure that stakeholders expectations align with project goals.
• Reviewed the Business Requirement Documents (BRD) and Functional Specification Documents (FSD).
• Handled project implementation and coordination, ensuring timely delivery and stakeholder alignment, which aligns with project management principles.
• Regular monitoring of procurement and fixing the technical issues in automation system in coordination with the development team
• Monitoring of the payment to the direct beneficiaries account against the supplied stock.
• Created different MIS Reports for analysis and monitoring by the Stakeholders

PROJECT-3(Adisha.in)

The E-commerce portal of TDCCOL was developed to bring the tribal produces of SHG’s/farmers of Odisha to the forefront by selling their products in a global platform and benefit them from the competitive market price.

Roles & Responsibilities:

• Worked with stakeholders to identify business needs.
• Gather and document functional and non-functional requirements.
• Analyze business processes to determine areas for improvement.
• Handled the implementation, testing and deployment needs to identify project requirements and costs
• Daily Management of Stock Upload and Inventory system.
• Management of the payment gateway accounts linked to the E- commerce portal of TDCCOL
• Accounting of the sales and analyzing the performance of the E- commerce portal.
• Marketing of products in Social media sites through digital content and promotion of the E-commerce site.