Candidates About

Summary:

• Over 5 years of IT Experience as a Business Intelligence Developer involved in analysis, developing, designing, production support and knowledge transfer with good analytical skills. Expert and certified using Qlikview and Qlik Sense as BI tool.

• Certified Qlikview Designer/Developer, Qlikview Administrator and Qlik Sense Data Architect.

• Extensive experience in developing different analytical applications using QlikView 11.0/12.0 suite of Products (Qlikview Desktop, Publisher and Qlikview Server), Qlik Sense 1.0/2.0/3.0-Monthyear versions suite (Qlik Sense Desktop and Qlik Sense Server), and other related Qlik family products such as Nprinting 15.0/16.0/17.0.

• Gathered functional and technical requirements as well as generated corresponding documentation with KPI and databases/tables for new projects.

•Created, developed and optimized model and dashboard using best practices like use Star Schema/Snowflake, autonumber instead of long string key, binary/digits set analysis. etc.

•Experienced with DAR methodology (Dashboard, Analysis, and Report) as methodology for graphical design and storytelling.

•Extensive support experience for a Qlik master reseller, resolving Qlikview Management Console like not running services and tasks, missing licenses and upgrading Qlikview versions.

• Strong knowledge in developing highly informative dashboards using QlikView/Qlik Sense objects like ListBoxes, MultiBoxes, Tables, Charts, Buttons, etc. and variables, fields, calculated expressions, and aggregation functions. Knowledge about advances and missing functionalities between both Qlik products.

• Experienced in creating customized reports, filters and charts in Qlikview.

• Good working knowledge in Data Modelling including Star Schema/Snowflake schema, concatenate FACT tables & Dimensions tables, and data model optimization.
• Experienced in importing and mixing data to QlikView/Qlik Sense from databases (Oracle, SAP, MySQL, SQL Server,), QVD files, text files and web url to generate different dashboard style reporting user interfaces.

• Excellent knowledge about Qlik developing process, using 4 phases process for Qlikview (Extraction, Transformation, Model, and Application) and 3 phases process for Qlik Sense (Extraction, Transformation, and Application).

• Expertise in reading and making SQL queries as well as redesigning complex SQL queries to Qlik ETL.

• Experienced in designing and merging data models from multiple data sources for different departments: Sales, Finances, Inventories/Logistics, Production Planning into an Qlik app or several Qlikview apps.

• Worked on migration process Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS) and SAS into Qlikview & Qlik Sense.

•Plenty Data Analysis and Data Quality experience studying the sources and calculation of numbers displayed on platforms,  and comparing reports from different sources.
• Experienced in optimizing existing QlikView/Qlik Sense reports with a focus on usability, performance, flexibility, testability, and standardization.

• Involved in QlikView Administration, Installation and upgrading the Qlikview Server and Publisher, and Qlik Sense Server.
• Experienced in configuring Qlikview/Qlik Sense Management Console, Access Point/hub, and security layer using active directory and local directories.

• Configured reload tasks and app distribution on Qlik Management Console and Nprinting Console.

•Expertise creating and modifying Nprinting templates, adding new objects from Qlik Sense and Qlikview.

• Good skills to troubleshooting issues on Qlik different layers (Dashboard, Data Model and Console) configured and created by third-parties.

• Involved in quick development process (3-5 days) for Qlik pre-sales products.

• Experienced teaching about best practices and basics topics for new Qlik developers.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem-solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.

Education

●        B Eng. Business & Technology

Technical Skills:
BI Tools: QlikView 11.0/12.0,  Qlik Sense 1.0/2.0/3.0, Nprinting 15.0/16./17.0, Tableau
Databases: Oracle, EBS, SQL Server, MySQL, SAP (R3, Business One, Business Object), Teradata
Languages: SQL, SAS
ETL Tools: Microsoft SQL Server Integrated Services, Pentaho.

Operating Systems Windows XP/Vista/7/8, Windows Server 2008/2012/2016.

Work Experience

Qlikview Developer/Engineer

Crossover (SmartLeads Customer Portal proyect) - Texas, US (working remotely)

Dec. 2017 – Current

Crossover connects talent from around the globe with companies that are looking to hire only the best. They have more than 2500 partners from 131 different countries working full time (40 hrs/wk) for our clients.

•Replicate tickets in Jira (portal) and study reason why they are existing.

•Resolve tickets using QA policies and rules, and send solution using Github.

•Modify Qlikview Data model, and Dashboard depending on tickets requirements.

•Modify Nprinting templates and projects (nsq) depending on tickets requirements.

•Explain possible solution to QAs when major changes are required on Qlikview.

•Study solutions which could have minimal impact on current data model and Dashboard performance.

•Discuss with QAs about native QlikView functionalities/issues, and point if a Javascript developer needs to resolve the ticket(s).

•Resolve conflicts generated by Github merging branches, leave evidence/explanation about code resolving issues at Github.

•Follow workflow processes for tickets until their release at Jira.

Qlik Senior/Standard Consultant

Qlikmex/AGS Nasoft – AN Analytics - Mexico City, Mx

Sep. 2013 – Dec. 2017

Qlikmex was first Qlik master reseller in Mexico and it had a lot of big clients in Mexico City, given them Qlik licenses, support and Qlik consulting services until it was sold to a biggest technology consulting company, AGS Nasoft/AN.

•Gathered technical and functional requirements as well as generated corresponding documentation with KPI to develop databases and tables for new projects.

•Created apps in record time (3-5 days) for Presales processes.

•Created and designed using best practices (e.g. snowflake schema, minimum fields on the fact table, eliminate unused fields) several apps on Qlikview and Qlik Sense for Retailer, Oil, Pharmaceutic, and Telemarketing companies used for Sales, Logistics, Manufacturing, Finances, and HR departments.

•Imparted basics administration, design and develop courses on Qlikview, Qlik Sense and Nprinting for technical users and end users.

•Validated numbers showing on apps and graphic design through apps with end users.

•Supported customers in troubleshooting issues related to Qlikview Management Console and resolved problems of designing and developing Qlikview apps.

•Integrated and handled several data sources such as Excel File, CSV, SQL Server, MySQL, PostgreSQL, and Oracle on Qlikview and Qlik Sense Apps.

•Configured Production, Quality Assurance, and Test environments on Qlikview/Qlik Sense Management.

•Managed and controlled migration of Qlikview local environment to Amazon Virtual Private Cloud.

•Ensured quality communication with customer and developer team for some projects on Qlikview

               Certifications:       

●     Certified in Qlik Sense Data Architect QSDA0400v3                                                                                                 Oct. 2017

●     Certified in Qlikview Administrator 11                                                                                                                        Nov. 2016

●     Certified in Qlikview Designer 11 and Qlikview Developer 11                                                                               Mar. 2015

●     Certified Associate in Project Management (CAPM)                                                                                                 May 2013

●     Certified System Modelling with IBM Rational Rose                                                                                                  Aug. 2010