Chrisona Solomon

Coupa System Archival

• Collaborating with the Stakeholders to refine and prioritize the requirements
• Compiling the Business required Documentations
• Creating User stories in Agile
• Clarifying Technical issues from technical end with Clients
• Sharing MOM and Weekly Status reports
• Development for Data archival from external Coupa source system to GCS bucket after loading the data into Bigquery Tables through Dag creation

• Monitered and Trained a team of 16 trainees in GCP, Python and Big Data programming Languages.
• Conducting training sessions for employees on various technical topics
• Handled employee relations issues including conflict resolution, Disciplinary actions and performance improvement plans
• Collaborated with department managers to assess staffing need and develop workforce planning strategies
• Conducted employee surveys and analyzed feedback to identify areas for improvement and implement initiatives to enhance employee satisfaction and retention
• Assisted in the development and implementation of Performance management systems, including goal setting, Performance Evaluations and Career development Planning.
• Conducted Team activities and Assessments to excel in their technical Skills

Google Cloud Platform on Big Query

• Integrating the tables, incremental and full Load data by Dag creation from AWS to GCP and BQ to SQL server.
• Performed Migration through Dataflow from BQ to SQL server.
• Report Creation through Views to Provide the list of delivery details, product and customer information.
• Integrated the Incremental Load and deletes of the salesforce records in the BQ tables based on the ActiveID files.

• Build an ETL that will gather all the data coming from the local systems and formatted to be consumed by Logility by creating LOM files and load it into logility for markets.
• Transfer Product, sales and customer data into logility from various external systems used by demand planners for different markets.
• Transform the data into Fixed Width Text Files LOM files.
• Upload the files in Logility production within 2nd Working day of the month and check the processing log for any error reports.
• Automation of the whole process by creating Stored procedures from SQL server to Mysql.

• Integrate product and related data from MDM to One CRM for core Sales and Marketing and Price Quoting functionalities
• Going through the user stories and understanding the requirement
• Writing PL/SQL Stored procedures, Packages, Functions and Triggers
• Importing the data from file to database using SQL Loader
• Creating migration script
• Collaborating with the onshore for updates.