We provide IT Staff Augmentation Services!

Qlikview Developer Resume

3.00/5 (Submit Your Rating)

Atlanta, GA

SUMMARY:

  • 7+ years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database querying, Data Warehousing /Decision support systems and Business Intelligence.
  • Hands on years of extensive experience in teh field of Data Warehousing, Data Architecture, Data Modeling, Business Intelligence and reporting Applications (Qlikview).
  • Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
  • Strong working knowledge of Qlikview, Set analysis, aggregation functions, multi - dimensional objects and layout and design including chart properties and formats.
  • Strong knowledge in basic components of QlikView Enterprise like List Boxes, Multi Boxes, Tables, Charts, Current Selection Boxes, Buttons, Containers etc.. And experience in editing scripts for creating variables, fields, and calculated expressions, basic and aggregated functions.
  • Design of QlikView applications using QlikView Data (QVD) files, different Databases and creating reusable variables.
  • Experience inQlikViewServer and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
  • Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys & Modeling Issues.
  • Expertise in designing and modeling of QlikView with complex multiple data sources (Oracle, SQL Server, Flat Files, Excel and Access) relational designs.
  • Planning project activities viz. scoping, estimation, tracking, change management, delivery management & post implementation support
  • Trained teh end users TEMPeffectively to use teh reporting tool (Qlikview), to build and customize their ad-hoc reports.
  • Having proven abilities in development, design, testing and production support for successful execution of projects on Qlikview.
  • Expert in database development skills using SQL and writing Stored Procedures, Packages and Triggers.
  • Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back-end testing.
  • Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception ability to quickly master new concepts and capable of working in-group as well as independently.
  • Proven abilities in conducting feasibility assessment by coordinating with support & technical teams & developing TEMPeffective automation solutions for testing of applications
  • In-depth knowledge of industry best practices in both business management and technology domains.

TECHNICAL SKILLS:

Reporting Tools: QlikView 9.x, 10.x, 11.x seriesLanguages: C, Visual Basic, Unix Shell scripting and SQL

Databases: DB2, MS SQL Server 2012 and Oracle

Tools: / Utilities: HP Loadrunner, Jmeter, Performance Center

Configuration Mngt Tools: VSS

Operating System: UNIX, Linux, WINDOWS NT/XP/7/2008 server

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Qlikview Developer

Responsibilities:

  • Understanding user requirements and expectations. Providing end to end reporting solution.
  • Build dashboards using QlikView. Implemented QlikView best practices. Designed data model using database connection and excel files. Build multiple layers of QVDs, created transformations, build hierarchies and so on.
  • Resolved synthetic keys in teh model. Used various Load statements viz. Inline, Resident, CrossTable and so on.
  • Created multiple tab dashboards. Created Pivot tables, Trend graphs, Bar graphs, Stacked Graphs, containers and so on. Created links to access Cognos reports from teh dashboard. Created customer search. Used variables to show and hide objects based on user selection.
  • Optimized existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time.
  • Create dashboards by extracting data from multiple databases, storing into QVD files, write load scripts, and develop UI according to user requirements.
  • Simplifying complex expressions in teh front-end, improving layout structure
  • Designed various Frontend objects like Line, Bar, Pie, Straight, Pivot Tables and other sheets objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
  • Design and deliver TEMPeffective visualizations.
  • Build and maintain Qlikview applications.
  • Developed KPI’s and set analysis applications.
  • Troubleshoot issues and find teh TEMPeffective solutions.
  • Designed data models based on teh client requirements and without any ambiguous or Synthetic tables.
  • Stored teh tables as QVDs and used Scripts to generate appropriate fields dat halp in modeling teh data according to teh requirements.
  • Experience in transformation of external data sources to QVD’s and from QVD’s to QVW reports
  • Developed dashboard which gives overall health of all teh servers viz. No of users logged in, Usage of a particular application daily/weekly/monthly which halps in capacity planning, different reload tasks status.
  • Define and maintain architecture and development standards for teh Qlikview environment
  • Maintain and execute teh technology roadmap for teh Qlikview environment
  • TEMPEffectively identify and remediate issues and risks dat impact teh performance and reliability of teh Qlikview solution.
  • Ensure consistency across applications as they are developed

Environment: Qlikview 11, Microsoft SQL server 2012, Windows Server 2008.

Confidential, North Carolina

QlikView Developer

Responsibilities:

  • Work directly with business users to define and prototype Qlikview Applications.
  • Work with senior management to plan, define and clarify dashboard goals, objectives and requirement.
  • Design, Develop, Test, debug and implement Qlikview solutions based upon specified requirement.
  • Extract, transform and load data from multiple sources into Qlikview applications.
  • Created QVD’s & updated on timely basis as database updates.
  • Deploy applications on production server and set up automated data reloads.
  • Create PDF push reports using Qlikview report editor.
  • Developed ETL Scripts while loading teh data, resolving loops & ambiguity joins
  • Using Qlikview Functions (Date and Time, Keep, Join, Mapping, String and input Fields etc.)
  • Developed User Interactive Sheets & Reports as business needs.
  • Created Dashboards style of reports using Qlikview components like List Box, Slider, Buttons, Charts and Bookmarks.
  • Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
  • Implemented Star & snowflake schema (confirmed dimensions).Writing SQL Scripts to load teh relevant Data in Qlikview Applications.
  • Developed Macros, SET ANALYSIS to provide custom functionality in Qlikview Applications.
  • Design, Build, Test, Debug teh Qlikview application in QV Test server environment.

Environment: Oracle 10 g, Excel, QlikView 10.0, Windows Server 2008 R2

Confidential, Chicago, IL

Qlikview Developer

Responsibilities:

  • Worked with teh finance teams to identify teh business reporting needs and studied current reporting practices outside ofQlikViewthrough pivot tables.
  • Participated on business requirement document preparation.
  • Participated in Scrum stand up meetings.
  • Created SQL Stored Procedures and Views to fetch teh data from database to build reports.
  • Designed and created teh financial dashboard reports for Executive board of company.
  • Modified existing reports usingQlikView.
  • Re-use teh existing QVDs, new tables as QVDs and scripts to generate appropriate fields dat halp in modeling teh data according to teh requirements.
  • Design of complex charts and trends which will provide Year on Year, Month on Month and Week on week analysis.
  • Maintained and updated teh dashboard reports as required by client.
  • Analyzed teh external financial and regulatory reporting, intercompany and internal management reporting needs of teh business process.
  • Created and maintained OLE DB/ODBC connections for all environments.
  • Developed hierarchical business model for company codes, account numbers, line of business, treaty/plan, customers and adjustment periods.
  • Designed dashboards identifying teh KPIs and to support teh time comparison between budgets and actual.
  • Designed Executive Sales Analysis Dashboard dat offers fast and flexible access to all key information across teh enterprise.
  • Implemented security usingQlikViewsection access technology dat dynamically hides selected areas of teh dashboard depending upon user privileges.
  • Maintained user guides and documentation forQlikViewapplications.
  • Installation/Configuration ofQlikView10

Environment: QlikView10.0, Oracle, SQL Server, SAP, Excel.

Confidential

Project Engineer

Responsibilities:

  • Developed dashboards pertaining to Revenue and Sales monitoring using Qlikview 9.0 SR6.
  • Managed and distributed application using Qlikview Publisher.
  • Participated in user discussions to understand teh user requirements, layout, and look and feel of teh dashboards to be developed.
  • Performed analysis, documentation, for calculation for various attributes.
  • Worked with Various Qlikview Objects to develop Applications
  • Performed testing of dashboards for functionality, data, performance, look and feel.
  • Promoting dashboards to production environment and manage user access.
  • Design and deliver TEMPeffective visualizations using best Practices.
  • Involved in User Sessions and Production Support of applications.

Environment: Qlikview 9.0, MS SQL Server 2005, PL/SQL,Oracle 9i, SQL.

Confidential

Performance Test Engineer

Responsibilities:

  • Collecting requirements from teh stake holders and translating them into measurable non-functional requirements.
  • Creating performance test plans detailing requirements for Benchmark and Load testing.
  • Involved in designing Load Testing scenarios based on teh non-functional requirement and SLA for various modules.
  • Coordinating with teh client business analysts, application architects, development team, technical team and PMO to resolve any project requirement with respect to application performance.
  • Gathering baseline statistics for each individual component by testing them separately.
  • Developing simulation scripts using HP Loadrunner - Web and Siebel-Web protocol.
  • Executing multiple test using Performance Center to identify Performance bottlenecks.
  • Monitoring teh Response times, Throughput, Bandwidth usage and other server metrics during teh test was running.
  • Analyzing teh test results and preparing teh preliminary report consisting of teh response time, scalability point and threshold level of teh application.
  • Preparing final executive summary report at teh end of teh engagement.
  • Preparing comparative study of teh performance of teh application before and after teh Siebel up gradation made.
  • Involve in preparing and presenting weekly status reports with clients.

Environment: Manual Testing, HP Loadrunner, Jmeter, SQL Bugzilla.

We'd love your feedback!