Sr.qlikview Developer Resume
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