We provide IT Staff Augmentation Services!

Sr.qlikview Developer Resume

4.00/5 (Submit Your Rating)

Dallas, TX

EXPERTISE SUMMARY:

  • 7+ Years of IT Experience wif Analysis, Design and Development in the field of Data Warehousing, Data Modeling, Business Intelligence Analyst, and Reporting.
  • 3+ Years of Experience in working wif QlikView Desktop 7.5/8.0/9.0/10.0, QlikView Enterprise Management Console (QEMC), QlikView Publisher.
  • Strong background in Implementation and Administration of QlikView for BI reporting
  • Planned, designed and implemented Complex BI graphic design Applications using QlikView
  • Developed user - friendly GUI Dashboard reports using various QlikView objects.
  • Experience in Loading Data from Multiple data sources like Excel, Oracle and Teradata DWs, SQL Server 2005, text files to develop the QlikView Data Models
  • Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.
  • Developed ETL script in QlikView to extract data from DB.
  • Strong experience in Data Warehousing concepts - Star Schema, Snow Flake Schema and Data Modeling( Normalization/De normalization, ER Diagrams, Keys)
  • Experience in Installation, configuration and administration of QlikView Software
  • Experience in gathering and analyzing the report requirement to create usable long term dashboard and reporting solutions
  • Hands on experience in creating QVW files, QVD files and reloading them on timely basis as per the database updates
  • Collaborated wif Business Leaders to share and gather QlikView Planning requirements
  • Experience in implementing various levels of File/Document and Data level Security
  • Performed different types of loads Incremental Load, Optimized Load & Binary Load
  • Strong skills in providing custom functionality using Macros, Triggers, Set Analysis
  • Sound knowledge in writing SQL Queries
  • Strong Database Development skills using SQL Server 2005,2008 &Oracle 11g
  • Good ETL skills, Data modeling, Dimensional Modeling knowledge wif experience in developing data movement, data cleansing and data integrity processes for the purposes of loading decision support
  • Proficiency in creating different types of reports such as List, Cross-Tab, Conditional, Drill-down, Master-detail, Chart, Summary, Form and formatting them
  • Involved in Optimization of QlikView Dashboards wif a focus on Visualization, usability, Performance, Long-term, Flexibility, Accuracy and Standardization
  • Business Analysis experience wif excellent communication & interpersonal skills and broad understanding of business operations and requirements
  • Trained clients on utilizing QlikView capabilities
  • Good exposure on QlikView 10& 11.
  • A team player wif good interpersonal skills and work independently

TECHNICAL SKILLS:

BI Tools: QlikView 8.5/9/10/11, SAP Crystal Reports, Business Objects 4.0,Cognos

ETL Tools: Informatica Power Center

Databases& Connectors: Oracle 9i/10g/11g,Sybase,DB2 SQL Server 2005/2008, Teradata, MS Access, Excel, Flat Files

Programming: SQL, PL/SQL

Office Applications: MS Outlook, Visio 2000

Web Technologies: HTML, XML, ASP, Java Script, VB Script, Servlets, JSP

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr.QlikView Developer

Responsibilities:

  • Responsible for requirement gathering, architecture, data modeling, data extraction, designing and development of QlikView applications
  • Developed various QlikView Data Models by extracting and using the data from various sources files, Sybase,DB2, Excel, and Flat Files
  • Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized QlikMarts
  • Implemented alternate states in the application.
  • Implemented Data Modeling by using Star Schema and Snowflake Schema
  • Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports
  • Used QlikView Scripting and Complex SQL coding for loading, and transforming
  • Developed Set Analysis providing custom functionality in QlikView Applications
  • Designed and developed the incremental loading where applicable.
  • Developed required user interactive Sheets/Reports & categorized as per business need
  • Implemented Data Level Security, Object Level Security & Document Data Level Security
  • Implemented Section Access or combination of more than one option wherever required for accessing the application
  • Developed and scheduled Daily, Weekly and Monthly automated report.
  • Supporting existing QlikView app.

Environment: QlikView 11.2 SR3, Oracle 11g, Access, Windows 2003 Server, Java Database (JDBC), SQL Programming

Confidential, Montvale, NJ

QlikView Developer

Responsibilities:

  • Interaction wif the client on daily basis to understand their existing application and the requirements
  • Developed best user interactive application using variables, functions and different charts for faster and quality analysis.
  • Implemented complex and traditional data models avoiding synthetic keys and circular loops.
  • Generation of QVD's wif all the required transformation in the data using QlikView scripts.
  • Developed and designed KPIs using QlikView analytical functions and complex set analysis.
  • Defined and developed data visualization and user interface elements using QlikView script expressions and operators.
  • Implemented section access security.
  • Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
  • Created and maintained user guides and documentation for QlikView applications.
  • Explored new releases and features of QlikView and outlined utilization features for business.
  • Validated and developed quality and data scrubbing scripts for the applications.
  • Optimized existing data models including modifying load scripts and creating flag variables for faster reloads.
  • Provided necessary maintenance support of the application.

Environment: QlikView 9/10, Oracle 11g, Access, SQL Server, Sybase, Windows 2003 Server

Confidential, Commack NY

QlikView Developer

Responsibilities:

  • Collaborated wif Business Leaders to share and gather QlikView Planning requirements
  • Implemented Star Schema & Snow Flake for Dimensional Data Modeling in QlikView
  • Created user interface reports using QlikView sheet objects like List Box, Input Box, Buttons, Text Input, Slider, Bookmarks, Charts (Pivot/Straight tables, Pie, Bar, Line etc.)
  • Created QVDs and developed Dashboard style of reports as per business needs
  • Developed extensively Variables, Input boxes, Triggers, Macros
  • Created Set Analysis for Comparison analysis eliminating additional complex coding
  • Wrote SQL Scripts to load relevant data in QlikView Applications
  • Created and schedules tasks for reloading and distribution of Data in QlikView Publisher
  • Automated jobs in Publisher & rolled out to QlikView Access point & maintained security
  • Gathered & loaded data into QlikView from various sources of data like SQL SERVER 2005, Oracle 10g, .CSV and excel files
  • Maintained both File and Data Level Security and implemented Data Reduction
  • Used to train and solve the issues related to the end users
  • Involved in Performance Tuning & Deployment of QlikView Applications
  • Intense knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Management Console

Environment: QlikView 9.0, QlikView Server 9, QlikView Enterprise Management Console, SQL Server 2005,Windows Server 2003, Oracle 10g, SQL Scripting, Sybase,DB2

Confidential, Northbrook, IL

Report Developer

Responsibilities:

  • Understanding the business requirements and report specifications
  • Created Reports usingQuery Prompts (parameters), Calculations, and selection filtersin the Reports.
  • Created Crystal Reports/SSRS by using SQL views, Stored procedures
  • Created daily, weekly, monthly and quarterly reports for the management team and Regional Managers
  • Involved in deploying the crystal reports in crystal server 2008 CMC
  • Create open document URL and call it from .net Application
  • Publications Creation for the users
  • Created of security model in BO 4.0 and in SSRS
  • Implemented SSO (Single Sign On) using active directory.
  • Created Subscriptions for Crystal reports and SSRS reports.
  • Disaster Recovery, Weekly Backups and server maintenance.
  • Involved in testing the reports data and performance testing.
  • Migrated Crystal reports from previous versions 8.5,2007
  • Worked on Lifecycle manager for moving reports from Development to QA to Prod
  • Created Overview documentation on Crystal reports
  • Involved in giving the Knowledge Transformation to team members and client.
  • Performance Tuning of the reports using SQL expressions.
  • Worked along wif .net Resource for integrating Crystal Reports to Application (Crystal reports for visual studio).

Environment: Crystal reports 2008, Crystal server 2008(BO 4.0 platform), SQL Server, MSBI (SSRS), Cognos 8.0 BI

Confidential, Houston, TX

Report Developer

Responsibilities:

  • Customer’s first point of contact for BI Cognos related support/issues
  • Monitoring scheduled daily/weekly power play cube builds
  • Granting and revoking IWR report access to user classes from IWR-Report Administration and Upfront
  • Monitoring weekly scheduled IWR reports in upfront and IWR-Server Administration
  • Filtering cubes and building new cubes (Time Based partitioned) during year end.
  • Grant and revoke access to Power play and IWR reports in upfront.
  • Monitoring Cognos (PPES, Upfront and Report server) services.
  • Access manager administrator (adding users, user signon, user membership, user’s data source access).
  • Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
  • Used Crystal Reports to create reports based on SQL Server database
  • Individually designed MS SQL Server 2000 database, coded stored procedures (T-SQL).
  • Deployed the solution, participated in testing and documenting.

Environment: Cognos 8.0 BI, Report Net 1.1, Framework Manager 1.1, Cognos Report Studio 1.1 DB2.0, Report Studio 1.1/8.0,Transformer 7.2/8.0, Cognos XML, Generic/Cognos JavaScript, Oracle 8i, PL/SQL, SQL*Loader, ODBC, Windows NT, UNIX, MS Visual Studio .NET

Confidential

SQL Developer

Responsibilities:

  • SQL Development & Troubleshooting included file groups, data access, ODBC, indexes, stored procedures, triggers and table structures for application behavior manipulation
  • Created numerous simple to complex queries involving self joins, correlated sub queries and XML techniques for diverse business requirements
  • Tuned and optimized queries by altering database design, analyzing different query options and indexing strategies
  • Created Stored Procedures, triggers, views, tables for data manipulation & reporting
  • Performance Monitoring, tuning and enhancing of SQL databases and objects
  • Developed Indexes, Views, and Synonyms for the huge tables in the database
  • Implemented Import/export for schema level and table level data
  • Good Knowledge on Dimensional Data Modeling Concepts

Environment: SQL server 2005, SQL Scripting, PL/SQL, UNIX Shell Scripting, TOAD

We'd love your feedback!