Omar Limon Email & Phone Number

Ciénega De Flores, Nuevo León, Mx

•Análisis de requerimientos relacionado con el proyecto con usuarios finales •Creación de Conectores para extraer la información de diferentes fuentes de datos como SQL, SAP, Excel Files.•Modelado de Datos: Entidad Relación, Diagramas Estrella, Querys Joins o scripting avanzado en Qlik Sense SAAS.•Resolver issues o problemas como: Llaves sintéticas, llaves circulares, peformance de las apps, certificación de cuadre de datos Vs ERP's.•Mejores practicas.•Automatizaciones.•Desarrollo de aplicaciones con cargas incrementales.•Desarrollo de Reportes y tableros Financieros (Ventas, Cuentas por Cobrar, Cuentas por Pagar, RH, Tableros Gerenciales etc...) desde inicio a fin de todo el ciclo del proyecto (Desarrollo, QA y puesta en producción)•Diseño de Reportes(objetos): (Ventas, Cuentas por Cobrar, Cuentas por Pagar, RH, Tableros Gerenciales etc...) •Reportes de SQL•Seguridad con Section Access.•HUB de Qlik Sense SAAS.•QMC: Qlik Sense SAAS Management Console (agregar usuarios, asignar permisos, crear espacios, Apps, agregar miembros, etc.).•Documentación del proyecto.•Curso y training a usuarios finales para uso correcto de la herramienta.

American Client Company: Qlik, UPSAnalyzing client requirements involved to the project. Pull the Information from different sources as DB Databicks, Excel Files.Data Model: Relation entity, Star Diagram, Queries, Join or scripting hard code by Qlik Sense SAAS.Auotmations.Advanced Scripting and hard code in QlikSense SAAS.Dashboard Design or Financial applications by QlikSense SAAS. KPIs Design as Bar chart, Line chart, Bubble Chart, Combo chart, Radar chart, Gauge Chart, Mekko Chart, Pie, Straight tables, Dynamic tables, Straight and Dynamic tables.Incremental Load in Apps.QlikSense SAAS HUB.QMC: Qlik Sense SAAS Management Console (add users, assign permissions, create spaces, apps, add members so on.)

Monterrey, Nuevo Leon, Mx

Interview at end users to get the different Financial KPIs as Sales, Purchase, Inventory, Payable Account, Receivable Account, Payroll.Interview at System User IT to get the access to SQL database. Analyzing customer requirements and customer documentation related to the project.Extraction of the different sources of Information as ERP SAP, SQL Server 2012, SQL Server 2017, Text Files, Excel, Flat Excel files .CSV.Data Modeling: Entity Relationship, Star schema, Queries Joins or scripting by QlikView Desktop 12 and QlikView Desktop 11 with the Best practices.Experience in Qliksense as Developer models.Advanced Scripting in QlikView as SET Analysis, Applymap, Crosstable, IF, sum, min, max, triggers, variable in objects in Chart properties and inside of the QlikView document.Best Practices in Data Models: Variables, Include Statement, Subroutines, Inner Join, Outer Join, Left Join, Right Join, Exists, Comment Tables, Comment Fields, Mapping etc. Dashboard Design or Financial applications by QlikView 12, QlikView 11. KPIs Design as Bar chart, Line chart, Bubble Chart, Combo chart, Radar chart, Gauge Chart, Mekko Chart, Pie, Straight tables, Dynamic tables, Straight and Dynamic tables with alarms.Validation of QlikView Information Vs Executive Reports ERP.Check the Performance about the execution of the applications by time in all applications by QlikView 12&11.Created Data Connections by QlikView through ODBC/OLEDB Connections (SAP). Administration of QlikView Enterprise Management Console: Privileges, Licensing by type: Named or Documented for Users, schedule process to update the information, Maintenance Plan of Upgrade with patches to current version, Training users to work by QlikView Access Point.Business Analysis (creating a detailed business analysis, planning, and monitoring process, reporting)

Monterrey, Nuevo Leon, Mx

Interview the end users to get the different Financial KPIs as Workflow, Payable Account, Receivable Account.Interview the System User IT to get the access to the database as SQL. Analyzing customer requirements and customer documentation related to the project.Used QlikView sheet objects including Pivot, List, Multi box, multiple charts types, Trends, KPI's, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reportingBest Practices in Data Models: Entity Relationship, Star Diagrams, Querys Joins or advanced scripting by QlikView Desktop 12.Best practices in Data Models: Variables, Include Statement, Subroutines, Inner Join, Outer Join, Left Join, Right Join, Exists, Comment Tables, Comment Fields, Mapping etc.Dashboard Design or Financial applications by QlikView 12, QlikView 11. KPIs Design as Bar chart, Line chart, Bubble Chart, Combo chart, Gauge Chart, Pie chart, Straight tables, Dynamic tables, Straight and Dynamic tables with alarms.Layout properties in charts: Changing the default object layout options, changing the default selection color scheme, modifying color schemas, using containers as an alternative to multiboxes, custom format cells. Validation of QlikView Information Vs Executive Report ERP.Best Techniques for Solving issues as Synthetic Keys, Circular Keys.Monitoring of the QVS, QVW's and user accounts for the usage of applications and user access to manage the limited number of licenses.Created Dashboard using different components of QlikView like list boxes, multi boxes, slider, buttons, and charts. Business Analysis (creating a detailed business analysis, planning, and monitoring process, reporting) Administration of QlikView Enterprise Management Console: Privileges, Licensing by type: Named or Documented for Users, schedule process to update the information, Maintenance Plan of Upgrade with patches to current version.

Ciénega De Flores, Nuevo León, Mx

Interview the end users to get the different Financial KPIs as Sales, Payroll, Payable Account, Receivable Account.Interview the System User IT to get the access to the database as SQL. Analyzing customer requirements and customer documentation related to the project.Extraction from different sources of Information as ERP SAP, TxT Files, Excel, Flat Excel files .CSV by QlikView and QlikSense.Best Practices in Data Models: Entity Relationship, Star Diagrams, Queries Joins or scripting by QlikView Desktop 11, QlikView 12 and QlikSenese.Performance to the different PDF reports with Macros by QlikView 12.Validation of QlikView Information Vs Executive Reports ERP.Validation of QlikSense Information Vs Executive Reports ERP.Best practices in Data Models: Variables, Include Statement, Subroutines, Inner Join, Outer Join, Left Join, Right Join, Exists, Comment Tables, Comment Fields, Mapping etc Developed data model to reflect a Start model after translating various sources into Dimension and Facts by QlikView and QlikSense.Advanced Aggregations: Using TOTAL to calculate the percentage of total and subtotal, Using AGGR to calculate the percentage of the maximum value, Using AGGR to resolve a "Sum of Rows" issue, Creating a dynamic AGGR expression for a Group dimension using Dollar Expansion, Using RangeMax to return only positive numbers, Showing only the top 3 values in a pivot table by QlikView and QlikSense.Administration of QlikView Enterprise Management Console: Privileges, Licensing by type: Named or Documented for Users, schedule process to update the information, Maintenance Plan of Upgrade with patches to current version, Training users to work by QlikView Access Point.Migration from QlikView 11 to QlikView 12.Migration project to different Server by SAP Connector and QlikView, Make a Connector SAP for QlikView 11 and Connector SAP for QlikView 12.Business Analysis (creating a detailed business analysis, planning, and monitoring process, reporting)

Interview the end users to get the different Financial KPIs as Sales, Purchase, Payroll, Payable Account, Receivable Account.Interview the System User IT to get the access to the database as SQL. Analyzing customer requirements and customer documentation related to the project. Data modeling: Relational Database and ER modeling by QlikView, dimensional modeling, the star schema, the snowflake schema, dimensional model models in QlikView, how associations are created, avoiding data model conflicts, the table viewer window: table information, field information, table preview, table vie Extraction from different sources of Information as ERP ROM, SQL Server, TxT Files, Excel, Flat Excel files .CSV.Development advanced functions in SET ANALISYS as TOTAL, AGGR, Applymap by QlikView ScriptingSecurity of the information by AccessPointCalculate KPIs with Island CalendarDesign dashboards or financial applications by QlikView 11 about Sales, Purchase, Payroll, Payable Account, Receivable Account.Loading a table file, Specifying the file attributes, the CSV attributes, the transformation step, QVD Files,.Bookmarking Selections, creating bookmarks, Retrieving a bookmark,Layout properties in charts: Changing the default object layout options, changing the default selection color scheme, modifying color schemas, using containers as an alternative to multiboxes, custom format cells. Validation of QlikView Information Vs Executive Report ERP.Best Techniques for Solving issues as Synthetic Keys.Administration of QlikView Enterprise Management Console: Privileges, Licensing by type: Named or Documented for Users, schedule process to update the information, Maintenance Plan of Upgrade with patches to current version, Training users to work by QlikView Access Point.Configuring the driver to the OBDC, Creating the OLE DB connection string.Business Analysis (creating a detailed business analysis, planning, and monitoring process, reporting)

Worked on the documentation for application development.Generated ODBC connections to extract from databases and store them in QVDS.Extraction from different sources of Information as ERP Infor LN BAAN, SQL Server 2012, TxT Files, Excel, Flat Excel files .CSV.The document properties, captions colors and style, changing the caption colors, Setting the caption font,the content font, the global font, the presentation tab, The Number tab, The font tab, the multibox, the current selection Box, working with listboxes: configuring the general tab, the expressions tab, the sort tab.Implemented Star Schema and Snowflake Schema in designing the data model.Adding a bookmark objectAligning and resizing sheet objectsSecurity of the information.Debugging script, saving logs to disk and after that check any issue about the debugging scriptStandardizing and organizing script: Using tabs, comments, adding an information tab, Re-using scripts, Managing file locations and connection strings.Developed dashboards using QlikView Objects Line Chart, Bar Chart, Gauge Chart, Pie Chart, Table Box, etc.Data transformation: “Cleansing” a dirty table, loading a Crosstable. Best Practices in Data Models: Entity Relationship, Star schema, Queries Joins or scripting by QlikView Desktop 11Validation of Qlikview Information Vs Executive Reports ERP.Comparative analysis current period vs last periodCloning a datamodel (Binary Load)Administration of QlikView Enterprise Management Console: Privileges, Licensing by type: Named or Documented for Users, schedule process to update the information, Maintenance Plan of Upgrade with patches to current version, Training users to work by QlikView Access Point.Involved in User Training Sessions and Preparing Documentation.

Interview at end users to get the different Financial KPIs Purchase, Inventory, Payable Account, Receivable Account, Payroll.Interview at System User IT to get the access to SQL database. Analyzing customer requirements and customer documentation related to the project. Make Cubes by Artus Gen VISecurity of the information by Artus Gen VIFinancial Design dashboards by Artus Gen VIValidation of Artus Gen VI Information Vs Reports ERP´s information.Create Back Up’s, Restoring the databaseCreate Tables, Index, Job’s by SQL Server Diagrams schema Models, Querys JoinsModify Views and Stores ProceduresCreate DTS’sArtus Administrator Gen VIROLAP Cubes Make profiles to end usersDimensions MetricsBusiness Analysis (creating a detailed business analysis, planning, monitoring process, reporting) Training users to work by Artus Gen VI Web.