Karen Jane L.
SQL Analyst at Coinberry- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Coinberry
-
Canada
-
Financial Services
-
1 - 100 Employee
-
SQL Analyst
-
Nov 2020 - Present
Wrote complex postgresql queries which involve creating result sets from referencing multiple data tables. Created reports and analytics to monitor database, application and overall company's performance using sql queries and presenting the data in tabular or graphically, using a Business Intelligence which is Metabase and the different functionalities of excel/spreadsheet (e.g. using pivot, vlookups, charts and other Mathematical Functionalities) Wrote complex postgresql queries which involve creating result sets from referencing multiple data tables. Created reports and analytics to monitor database, application and overall company's performance using sql queries and presenting the data in tabular or graphically, using a Business Intelligence which is Metabase and the different functionalities of excel/spreadsheet (e.g. using pivot, vlookups, charts and other Mathematical Functionalities)
-
-
-
FPT Software
-
Vietnam
-
IT Services and IT Consulting
-
700 & Above Employee
-
Software Engineer
-
Mar 2018 - Aug 2020
Hands on experience on Microsoft SQL Server. Created new tables, inserted, updated and deleted records according to client's request. Siebel Software Engineer focusing on Product Configurations and Pricing Provided reports via SQL query and the different functionalities of EXCEL Hands on experience on Microsoft SQL Server. Created new tables, inserted, updated and deleted records according to client's request. Siebel Software Engineer focusing on Product Configurations and Pricing Provided reports via SQL query and the different functionalities of EXCEL
-
-
-
Qualfon
-
United States
-
Outsourcing and Offshoring Consulting
-
700 & Above Employee
-
Jr. Agent Application Support
-
Jun 2017 - Mar 2018
Worked hand in hand with the US Client to fix bugs in existing applications reported by client through Database management via Oracle SQL. Sends hourly reports to monitor the table for error handling and as well as proactively investigates for alerts triggered by proactive monitoring. Adheres to client requests through queries and updates of records via Oracle SQL database. Created graphical representation of data using charts and different functionalities of EXCEL (e.g. PIVOT, CONCAT, VLOOKUP and other mathematical functions)
-
-
-
Lexmark
-
United States
-
Information Technology & Services
-
700 & Above Employee
-
Enterprise Software Support
-
May 2016 - May 2017
My responsibilities includes adhering to customer problem by providing them technical support on the application by helping them check the technical configurations and coding in the application, collaborates with the team to ensure fast resolution of cases, creating Knowledge Base Articles for resolved cases My responsibilities includes adhering to customer problem by providing them technical support on the application by helping them check the technical configurations and coding in the application, collaborates with the team to ensure fast resolution of cases, creating Knowledge Base Articles for resolved cases
-
-
-
Accenture
-
Ireland
-
Business Consulting and Services
-
700 & Above Employee
-
Software Engineer Analyst
-
Feb 2014 - May 2016
My responsibilities include the designing and developing system specifications based on requirements, creates operational documentation for the application, conducts project and issue management (e.g. Status Reporting) for assigned scope of work, creates Unit Test Plans and implement Testing plans. Able to manipulate and extract data using DDL and DML statements of Oracle SQL. Provided reports of data to clients thru CSV and EXCEL functions My responsibilities include the designing and developing system specifications based on requirements, creates operational documentation for the application, conducts project and issue management (e.g. Status Reporting) for assigned scope of work, creates Unit Test Plans and implement Testing plans. Able to manipulate and extract data using DDL and DML statements of Oracle SQL. Provided reports of data to clients thru CSV and EXCEL functions
-
-
Education
-
Xavier University - Ateneo de Cagayan
Bachelor of Science, Electrical, Electronics and Communications Engineering