Qlikview Developer Resume
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