Technology Analyst
Bhubaneshwar, Orissa, India
1. Was involved in complete development of an application known as CPFR. The application would fetch demand/supply data from multiple data sources like Octopus. Weekly complete data loading and measure calculation would be done at SCI end. For any changes to source data anywhere within a week, a queuing mechanism was constructed to sync up all data at SCI end as well. Roles and responsibilities included code development in a parallel development environment through GIT, coordinating with team members, coordinating with source team members.2. Was involved as a sole resource for complete development of an application called China Solver. Data was pulled from multiple source systems like Octopus. Roles and responsibilities included development of code for data ingestion from source, designing table structure, measure calculation, bug fixes and performance optimisations. A queuing mechanism was constructed to sync up data with source systems with Oracle enqueue-dequeue mechanism. An autosync function was also developed to sync up data from source at the press of a button.3. Was involved in MasterNinja project which is based on Bill of Materials in Supply Chain. Developed database for a web based application called MasterNinja. Roles and responsibilities included coordinating with onsite client for requirement analysis, coordinating with onsite team member for development, performance optimisations so that millions of records which are generally fetched in a BOM is fast. 4. Currently involved in a subpart of MasterNinja called Liability Dashboard Excel Tool, where similar hierarchical BOM data would be fetched. User can tag records as per their re-quirements from the Excel sheet, and the results fetched in the five sheets of LD Excel Tool will be computed according to the tags. Resolved multiple challenging performance issues in code.5. POCs on Python and Machine Learning to forecast Demand Quantity with Linear Regres-sion
