We provide IT Staff Augmentation Services!

Qlikview Developer Resume

5.00 Rating

MI

PROFESSIONAL SUMMARY:

  • 8 years of experience in Business Intelligence Tools (Qlikview, OBIEE), ETL Tasks and Data Warehousing.
  • 2+ years of most recent experience in Qlikview Desktop, Qlikview Server & Qlikview Publisher in aspects of development, deployment and administration.
  • Ability to offer end - to-end solution starting from requirement gathering, design, development & deployment of Business Intelligence applications. Experienced with Agile Development Methodology in providing quick analysis and visualizations for business users.
  • Expert in extracting, transforming, analyzing, visualizing, and presenting data from diverse business areas in novel and insightful ways to enable Directors, Vice Presidents, and CEO to take informed action.
  • Hands on experience with integration of Hadoop, Teradata & other Big Data technologies with Qlikview.
  • Experience with QlikView objects including multiple charts types, Trends, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI’s.
  • Created QVD’s & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
  • Involved in Optimizing existing QlikView dashboards with a focus on usability, performance, long-term, flexibility, and standardization.
  • Experience in working with Qlikview extensions such as Quick Map, Word Cloud, Word Map.
  • Performance tuning by analyzing and comparing the turnaround times between SQL and Qlikview.
  • Experience running complex and high volume ETL processes.
  • Excellent working knowledge in Data Warehousing Models, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.
  • Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys & Modeling Issues.
  • Expertise in optimizing, Debugging and testing SQL queries.
  • Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.
  • Attention to detail & ability to work in a pressurized time sensitive environment.

TECHNICAL SKILLS

Business Intelligence Tools: QlikView 10.0/11.0, OBIEE 4.0, Crystal Reports

Languages: SQL, PL/SQL, C, Java

Database Technologies: Oracle SQL Developer 3.0.04, Oracle11g/10g, MS SQL Server 2012/2008, Teradata14/13x, Netezza, DB2

Operating Systems: Windows HyperV, Windows 7/8, Cent OS, Ubuntu,, Unix Shell Scripting

Domains: Financial, Banking, Healthcare, Services, Manufacturing, Social Media

Big Data Tools: Cloudera, Hortonworks, Hive, Hadoop

Programming GUI: Unix, Putty 0.63, WINSCP 5.1.7

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, FACT and dimensions tables, Physical and Logical Data Modeling

Methodologies: SDLC, Agile Software Development, Six Sigma Implementation, Business Intelligence best practices

PROFESSIONAL EXPERIENCE

Confidential MI

QlikView Developer

Responsibilities:

  • Designed & developed QlikView dashboards for Operations & Marketing business groups.
  • Involved in full project life cycle implementation (requirement gathering to production) of QlikView dashboards.
  • Used Publisher and Server to automate the reports to perform Reload, Reduce and Distribute QlikView Application.
  • Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team.
  • Connected to different various data sources like Hive, Spark Oracle, SAP BW and flat files to create and schedule different complex reports.
  • Hands on retrieving of external data to QlikView Dashboard in terms of QVDs by making connection through ODBC and OLEDB.
  • Developed QlikView Dashboards using Chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box and Calendar & Date Island.
  • Using QlikView functions such as Date and Time, Keep, Join, Mapping, String& input Fields etc.
  • Designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
  • Working experience with SQL/Server T-SQL, SSIS and SSRS (MSBI).
  • Working on Microsoft Excel, Access to automate the process by creating/modifying Macros as per the requirements
  • Conducted User Acceptance Testing as part of SDLC process.

Environment: SQL Server 2008 R2, Excel, Windows Server 2008, QlikView 11.2, Hive, Hadoop.

Confidential, Chicago, IL

QlikView Developer

Responsibilities:

  • Designed & developed QlikView dashboards for Distribution, ShippingOperations & Marketing business groups.
  • Involved in full project life cycle implementation (requirement gathering to production) of QlikView dashboards.
  • Connected to various data sources like Oracle, SAP BW and flat files to create and schedule different complex reports.
  • Hands on retrieving of external data in terms of incremental loading of extract scripts for QVDs by making connection through FTP, ODBC and OLEDB.
  • Sound understanding of relational, object and dimensional databases.
  • Developed QlikView Dashboards based on DAR(Dashboard Analysis & Reporting) principle using Chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box, Calendar, Date Island etc.
  • Using QlikView functions such as Date and Time, Keep, Join, Mapping, String& input Fields etc.
  • Identifying Key Performance Indicators and metrics.
  • Created Ad-Hoc report generation functionality in Qlikview applications adding flexibility to end users analysis.
  • Working experience with extensions such as QuickMap for deploying geographical location based metrics.
  • Identifying opportunities to employ Qlikview solutions to meet customer reporting requirements.
  • Designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
  • Designed Qlikview applications of various resolutions for IPad and LCD Screen displays using Flat UI Design and monochrome colors.
  • Checking of supplied data for sense, consistency and accuracy.
  • Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team.
  • Documenting work processes, establish procedures to ensure reliable production of reports, transfer knowledge to other reporting team members.
  • Conducted User Acceptance Testing as part of SDLC process.
  • Participated in daily scrums meeting and sprint cycles.
  • Strong team player working on all the areas of the project.

Environment: Oracle Client 11g, Excel, Toad for Oracle 11.6, QlikView 11.2 SR7

Confidential, North Carolina

Cognos BI Consultant

Responsibilities:

  • Effectively partnered with finance customers; ensured consistent and accurate flow of the information from business project sponsors to application/database developers.
  • Communicated with business users, business analysts to analyze, design, developed the Cognos reports, dashboards, and DMRs.
  • Implemented dimensional modeling and star schema grouping in Framework managers from a Cognos planning database.
  • Developed using Report Studio, advanced functionalities such as building complex prompt pages, render variables; parameters and parameter passing, master-detail, drill downs vs. drill through, various calculations, union and join queries and generated and troubleshooting report SQL.
  • Worked extensively on various report layouts such as chart, list, crosstab and repeater for presenting the data in efficient manner in Report Studio.
  • Performed data analysis for verifying Regional Data Warehouse (RDW) data, by generating and comparing reports from RDW with reports from existing legacy systems.
  • Created the data level security for various objects like PandL, market summary, and Fact Query subjects in the Cognos Framework mangers to restrict users to access the level of data.
  • Involved in the generation of different reports for different sets of data to target customer segments, in order to slice and dice and drill-through data for multidimensional OLAP analysis.
  • Prepared end user documentation on models, packages, and reports for end users that help in using the developed reports and build ad-hoc reports using Query Studio.

Environment: Cognos 8.2 and 8.4 (Framework Manager, Cognos Connection, Report Studio, Query Studio), Cognos Planning, PowerPlay Transformer 7.3, PowerPlay Enterprise Server 7.3, Oracle 9i, TOAD, HTML, JavaScript

Confidential

Cognos Developer

Responsibilities:

  • Created Framework Manger Models and created and published packages into the portal.
  • Created Standard Reports using Report Studio and Ad- Hoc Reports using Query Studio.
  • Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
  • Created standard and Ad hoc reports using Cognos Impromptu Designed catalogs and defined User Classes, Security and Privileges.
  • Created Multi-dimensional reports by implementing Multi-Dimensional Cubes using Power Play and Transformer.
  • Provided security for Cubes of various User classes. Used Date Wizard to create time dimension in Transformer for creating cubes and Power Play reports.
  • Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.
  • Created Impromptu Web Reports and published them on the web server and later on upfront.
  • Created News boxes in Upfront and customized the environment. Set Security for News Item and New boxes in Upfront. Set Privileges for user classes by defining News Index Admin

Environment: Oracle 9i, Cognos 8.1, Cognos ReportNet1.1 MR3 (Framework Manager, Cognos Connection, Query Studio, Report Studio), Cognos Impromptu Admin/User, Power play Transformer, Power play for Web/Windows, Cognos Report net 1.1, Windows 2000

We'd love your feedback!