Roma H

908-***-****

ac6etf@r.postjobfree.com

Objective:

Experienced QlikView Developer/Admin seeks employment opportunity in a challenging environment to utilize comprehensive knowledge and experience of QlikView, to promote efficiency across all departments.

Professional Summary:

5 Years of real time IT experience with 5 Years in Architecture, analysis, design, development and implementation of QlikView and QlikSense applications.

Expertise in things like QlikView performance optimization, QlikView Management console, QlikView Administration and QlikView Data Modeling.

Strong experience in designing and developing dashboards using QlikView by extracting data from multiple sources (Oracle, Flat files, Excel, Access).

Extensive experience with QlikView sheet objects, scripting, and optimizing applications and building QVD’s and QVW’s.

Extensively worked on Data Analysis/Mining using QlikView.

Expertise on set analysis, advanced aggregation and section access.

Hands on Experience with QlikView Architecture in development and deployment.

Expertise in the QlikSense SDLC and Governance.

Hands on experience in implementing the new features of Qlik Sense like Pivot Table, KPI Object, PDF Printing and N-printing.

Expertise in QlikSense administration, attribute based on access control and role creation.

Involved in Optimization of QlikView Dashboards with a focus on Visualization, usability, Performance, Long-term, Flexibility, Accuracy and Standardization.

Expertise in QlikSense data modeling, master items and maps.

Experience with QlikSense Extensions using Java script and workbench.

Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, Automation, Macros interface in QlikView and DW.

Proficient in optimizing, debugging and testing SQL queries.

Technical Skills:

Dash boarding/Analytics:

QlikView12.4/11.0/10.0/9.0, QlikSense3.2/3.0, Tableau, SQL BI.

Languages:

SQL, PL/SQL, T-SQL, VB Script, Shell Scripting, HTML, Java Script.

ETL Tools:

SSIS, SSRS, Informatica, Cogno’s.

Database Technologies:

Oracle9i/10g/11g, SQL Server, Teradata, MySQL, DB2, SAP BW.

Platforms:

Windows Server 2003/2008, Linux (Ubuntu)

Others:

MS Access, MS-Excel, MS InfoPath, Visio

Projects:

Deutsche bank, NYC June’ 17 to Present

Sr. QlikView/QlikSense Developer

Responsibilities:

Working with a team of three onsite, two offshore QlikView developers and one database Admin.

Design, develop and implemented QlikView/QlikSense applications to help view investors data.

Dashboard included inverters detail drilldowns, threshold gauges and alerting mechanisms.

Created and Scheduled Weekly QlikView reports to distribute on email using N-Printing and publisher.

Implemented secure environment using QlikView and QlikSense Section Access.

Created various extensions like Qlik Maps, Multi switches using HTML and Java Script.

Implemented and followed the 3-tier architecture.

Strong working experience in Load script, Data modelling and QlikView / QlikSense extensions.

Data Modelling, Analysis, Reporting and Data Testing.

Co-ordinate with Testing team for QA and UAT.

Analysing the system requirements and advising on logical and physical design of the database.

Working closely with all levels of business, with varying levels of technical knowledge, to gather accurate and actionable business and technical requirements.

Analyse reporting requirements to architect appealing supportable reporting solutions.

Conduct validation of existing reports and new solutions to ensure continuous accuracy and front-end ease-of-use.

Prepared Technical Specification Document, Migration Documentation.

Involved in Client Meeting and Discussion and Helped end users to design test cases and worked through multiple UAT cycles.

Trained our end users where ever required on Qlikview/Qliksense weekly and monthly basis.

Ad hoc excel reports are created based on the business user requirements.

Environment: Qlik Sense 3.2.3, Qlikview12 SR4, Qlikview Publisher, Toad, Oracle, SQL Server, Flat Files, Windows 2008 Server, SharePoint, Agile methodology, Java Script and HTML.

Miracle software systems, GA Dec’ 15 to June’17

QlikView/QlikSense Developer

Responsibilities:

Actively involved in the Installation of the latest versions of QlikView 11 SR2 Release, recently migrated from QlikView 10.

Migrated all the Publisher Tasks from QlikView 10 to 11 and applied the Dependencies Between the tasks.

Worked on in various Prototype Designs and helped the Business Analyst to understand the capabilities of the QlikView Tool.

Designed and implemented the Incremental Loading using QVDs, includes more than 5 million records with daily incremental load schedule.

Implemented the 3-tier architecture (Data Extract, QVD/QVF and Data Model)

Designed the Data-Model using various data sources like Oracle 10g/DB2 Database, XML and Excel Sheets.

Designed Dashboards like "Revenue Growth Analysis" to analyze the summarized which includes reports like Top 10 Best and Top 10 Under-Performing Branches and charts based on The Metrics Revenues, Expenses, Income, Returns, Margins etc.

Dashboards also included customer detail drilldowns, threshold gauges and Alerting mechanisms.

Extensively worked with Set Analysis in some of the Dashboards.

Created Extensions in QlikSense and QlikView using Java Script.

Scheduled the Publisher Tasks in QMC by Daily/Weekly/Monthly on various Dashboards based on the Database updates.

Installed and Configured QlikView 11 on Windows 2008 R2 Servers and clustered 6 Servers for our production environment.

Environment: QlikView 11, Qlik Sense 3.1.2, Oracle 11g, DB2 9.7, SQL Server 2008, MS Office, Windows 2008 R2 Server, Toad, Agile methodology, Java Script.

General Electric, Erie, PA Jan’15 to Dec’15

QlikView Developer/Admin

Responsibilities:

Full life-cycle development and implementation of QlikView for a packaged Help Desk/Service Desk module.

Involved in Analysis, design, installation & implementation of the BI solution. Converted and enhanced an older Oracle Discoverer BI solution and implemented QlikView.

Extracted data from the database, stored into QVD files, and wrote load scripts.

Experience in linking real time SAP data to the dashboards with BO interface.

Eliminated Synthetic keys, ambiguous relationships and closed loops.

Designed proficient dashboards as per the requirements.

Enhanced existing dashboards with new functionalities and established a secure environment using QlikView and QlikSense Section Access.

Created Input boxes, Pivot Tables, Straight Tables, Bar Charts, Buttons, Multi boxes on the UI to make it more accessible to User community.

Implemented drill down and cyclic dimensions.

Worked with bulk volumes of data and extracted them from various sources like excel, Oracle, SQL Server through ODBC and OLEDB connections.

QlikView and QlikSense data modeling by building the Star schema and resolving loops/synthetic keys.

QlikView and QlikSense dashboards optimization.

Strong working experience in Load script, Data modelling and QlikView / QlikSense extensions.

Involved in the development/implementation of Single sign on (SSO) and implemented security for company’s Active Directory Users and external users.

Worked as a QlikView Administrator which include maintains the QMC, configure tasks; manage the licenses, Implemented Security for applications (Included Section Access, Dynamic Data Reduction and Document level security).

Experience in managing schedules and reloading of QlikView applications through QlikView QMC.

Task set up are done and created architecture for the interdependent applications and execute in proper order.

Maintained Server for smooth QlikView development. Checked and updated environmental file, assigned task, path and triggers for QMC, QEMC.

Configuring server health checks, Backup failover & Server Alerts are also done.

Debugging the QlikView server issues through server logs, Fiddler logs.

Environment: QlikView 10, QlikView dashboard, QlikSense, Business Objects, SVN, Oracle 10g/11g, Subversions, MS Access, MS SQL server, SAP BW.

Wipro Technologies, Bangalore Jan’ 14 to Dec’ 14

Qlikview Developer/ Data Analyst

Responsibilities:

Worked as a BI analyst/ Qlikview Developer on sales applications.

Worked with the user community and senior management to identify the business reporting needs and develop the architecture of prioritized reports by role that would have the most positive impact on the business.

Developed systems architecture for Qlikview implementation identifying the data sources and target reports match.

Worked on different Qlikview objects like straight tables, line charts, bar charts and pivot tables etc. for dashboard design.

Worked on set analysis and advanced aggregation functions.

Writing VB Script Marcos wherever it's needed.

Developed Qlikview applications from scratch.

Worked on Qlikview server and publisher to automate the Qlikview tasks and apply the security.

Analyze customer requirements and develop proposals of technical solutions as needed.

Creating the oracle procedures, packages and functions.

Used MS Access for smaller databases to create the tables and generate the reports.

Created score cards with advanced set of dashboards using MS Office Performance Point Server Dashboard Designer that feature executive summary measures.

Scheduled SQL Server Agent Jobs to run every day to update changes in the base tables.

Resolved various performance issues by running DBCC command.

Performed daily tasks including backup and restore from disaster recovery by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler.

VE-Link Info Solutions, Hyderabad Dec’ 12 to Jan’14

Jn. QlikView Developer

Responsibilities:

Interacted with customers to gather business requirements and developed functional and technical specification document

Participated and proposed new business analysis for data which has no prior reports

Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports

Extracted data from the database, stored into QVD files, and wrote load scripts.

Eliminated Synthetic keys, ambiguous relationships and closed loops

Developed QlikView applications based on Incremental Load Transactions using QVD files.

Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.

Created dashboards using Macros to meet the reporting requirements.

Tuning data loads and QlikView application for efficient performance.

Documented report requests in the form of Functional and Technical specifications.

Established a secure environment using QlikView Section Access.

Wrote QlikView macros, variables, user friendly functions, and built reusable master framework

Collected and analyzed business requirements, developing engineering prototype and using POC to facilitate KPI Metrics dashboard design across different regions and business units.

Created Layout themes and applied it to several documents.

Participated in design and code reviews, QA/UAT testing, enhancement design and development, and deployment to support day-to-day business operations

Involved in performance tuning of dashboards to limit the response time and enhance the functionality.

Enhanced existing dashboards with new functionalities and tuned ETL scripts for better performance.

Enhanced and translated existing dashboards in SSRS into QlikView and worked extensively with the set analysis.

Successfully passed through the QA Environment and implemented on Production and currently working as post production support.

Provided training and supported client-in house business users.

Environment: Qlikview10.2, SQL server2008, .NET, Windows 7/2008.

Contact this candidate