We provide IT Staff Augmentation Services!

Sr.qlikview Developer Resume

Purchase, NY

SUMMARY:

  • 10+ years of IT experience in all aspects of Business intelligence applications with a strong background in Database development, Data warehousing /Decision Support Systems and Business Intelligence.
  • 4+ years of experience in Qlikview Development.
  • Expert in Extracting, Transforming, Analyzing, Visualizing, and presenting data from diverse business areas in novel and insightful ways to enable Directors, Vice Presidents, and C - level executives to take informed action.
  • Extensive experience in developing different analytical applications using QlikView suite of Products (QlikView Server, Publisher and QlikView Enterprise).
  • Worked on BI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
  • Expertise in Creating Dashboards using QlikView 11.2/11.0/10 using different data sources like Oracle, SQL Server, QVD files, text files, excel and generated dashboard as per the user requirement.
  • Worked with Sap 4.7, SAP ECC 6.0 & R/3 in Business Objects R/3.
  • Used Open Hub Services, to push data out of SAP BI using Data Services.
  • Good experience in design, development and maintaining Dashboards and BI applications using Qlikview.
  • Good in validating the BI reports/dashboardsby preparing the Test Plans & Cases.
  • Having Knowledge in Database structuring, database application design & development, Entity Relationship Modeling (ERM), Data export/import, SQL programming &ETL procedures.
  • Strong Database Development skills using Teradata 15, SQL Server 2005, 2008 & Oracle 11g.
  • Worked extensively on ER Studio in several projects in both OLAP and OLTP applications.
  • Design of Qlikview applications using Qlikview Data (QVD) files generated by ETL logic.
  • Experience in designing Qlikview Document/User Setting, Layouts to make consistent and professional optimized look to clients.
  • 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.
  • Experience in Loading Data from Multiple data sources to develop the QlikView Data Models.
  • Good working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
  • Expertise in Designing Universes for Ad-hoc query, canned reporting and analysis using the Designer Module.
  • Expertise in creating standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
  • Experienced in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries, Sub Queries.
  • Strong experience in Data Warehousing concepts - Star Schema, Snow Flake Schema and Data Modeling( Normalization/De normalization, ER Diagrams, Keys).
  • Sound knowledge in writing 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.

TECHNICAL SKILLS:

Databases: Oracle 9i/10g/11g, SQL Server 2005/2008, Teradata, MS Access, Excel, Flat File Salesforce(.d11 adaptor), SAP (OLAP, SQL Connectors)

BI Tools: QlikView 10 & 11, Business Objects Developer Suite 4.0/XI3.1/XI3.0/XIR2/6.x/5.x

ERP/CRM Tools: SAP, Data Warehousing

Web Technologies: HTML, XML, Java Scripting

Operating Systems: Win 98/2000/XP/Vista/7

PROFESSIONAL EXPERIENCE:

Confidential, Purchase, NY

Sr.Qlikview Developer

Responsibilities:

  • Attended and participated in information and Functional Requirement Gathering sessions.
  • Gather analytical requirements from Business Users and worked closely with Business Analyst to understand business requirement and data flow.
  • Developed and designed comprehensive and innovative ad-hoc dashboard to provide manufacturer with broad
  • Design and build QlikView Solutions to meet customer specifications.
  • Working and handing the team of Qlikview and ETL developer at offshore in India.
  • Develop extensive data models using fact and dimension tables, containing millions of rows and 100s of columns in tables.
  • Design flows and trends using complex objects and created Dashboards style of reports using Qlikview Components like Pivot Table,Buttons, Charts and Bookmarks.
  • Develop set analysis and other complex expression to make the dashboards truly interative for the business.
  • Performed data quality in building qlikview Applications.
  • Good understanding of QlikView Architecture. Extracting, Transforming and Loading data from different data source. Incremental loading is implemented.
  • Developed executive dashboards using QlikView 11.2 and delivered through the web.
  • Ability to interface with end customers.
  • Installing and setting up QlikView Server.
  • Management of QlikView Publisher.
  • 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.
  • Created Set Analysis for Comparison analysis eliminating additional complex coding.
  • Managing the security tables initiated by the statement Section Access, Data Level Security and implemented Data Reduction
  • Performed data modeling on requirements analysis by creating table displays, physical data model, star schema models and table designs.
  • Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance batch and response time of data for users.

Environment: Teradata 15, Windows,Qlikview 11.2,MS SQL RDBMS, Excel 2014.

Confidential, Newport Beach, CA

Qlikview Lead

Responsibilities:

  • Participating in requirement gathering sessions and design review sessions.
  • Helping power user on completing the development and providing best practices implementation.
  • Worked on Clinical Effectiveness Readmission Dashboard and Physician Development.
  • Customizing the data model of the product to meet the requirements, to best fit the data.
  • Creating Custom reports
  • Code fixing in Script file by checking Sql statements.
  • Solved data related issues on assigned dashoard.
  • Scheduling the dashboards, assigned named user.
  • Developed metric combinations according to user specification.
  • Onsite and offshore team management.
  • Implemented Data Qality rules to check against the data to solve data quality issues while loading sample data set.
  • Actively worked with Osite-team solvig issues for dashboard developemet followed by Agile methodology.
  • Engaged with offshore team assigning tasks to ensure completion of requests.
  • Attended daily status calls.
  • Providing Technical solutions to Management/Operational reporting needs of clients globe in various functional areas
  • Involved in weekly scheduled Project Updated meetings.
  • Worked with multi-users to better understand of their dashboard needs.

Environment: Qlikview 11,Windows,MS SQL Server 2008, Oracle 11g.

Confidential, Austin, TX

Sr. QlikView Developer

Responsibilities:

  • Involved in understanding the business from different areas and gather requirements.
  • Worked closely with BA(Business Analyst) in data Optimization of the Dashboard and design/code accurate.
  • Worked on End-to-End Development of the Project including Unit testing.
  • Simplified the level views on the each tab of the Metric Dashboard and redesigned in to single Sheet.
  • Connected OLE DB data base(ORACLE DB) connection string file to 64 bit in impplication file.
  • Participated in Weekly Project Status meetings with entire team and worked on assigned tasks in the Project Schedule to complete in given time.
  • Worked with Architech to present TDD(Technical Design Document), Code Reviews on Designed Dashboard for user expectations.
  • Involved with Admin Team in solving Section Access Issues at Access Point.
  • Experienced in UAT(User Acceptance)System Testing.

Environment: Qlikview 11.2,Windows,MS SQL Server 2008, Oracle 11g.

Confidential, NY

Sr. QlikView Developer

Responsibilities:

  • Involved in interacting with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
  • Worked closely with users to understand data sources and requirements to build the best data model for QlikView applications.
  • Participated in user discussions to understand the requirements, Design of the Dashboards to be developed.
  • Worked on Multiple Graphs to compare Look and Feel of Spot fire into Qlikview Tool as a Proof of Concept(POC).
  • Created QVD generator load scripts to implement the two-tier-architecture.
  • Meetings with end users to gather the functional requirements and customize Qlikview dashboards accordingly.
  • Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
  • Design & Development of QlikView Dashboards using QV scripting.
  • Created data model in QlikView desktop to get all the data in required format. Used Combining tables, Buttons,Actions,Joins,Variables and so on.
  • Wrote SQL Scripts to load relevant data in QlikView Applications.
  • Day to Day Trade Analyzation using Filtering the data in Front - End Application Designing.
  • Connected OLE DB data sources (SQL Server) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView.
  • Worked with Technical Support Team to solve the Issues in Script Loading and Data Model Building.
  • Scheduling Meetings in data visualization to Present Data Model with the BI Team & Designing the Dashboard according to UI Expectations.

Environment: QlikView 11.2, Oracle 11g, SQL Server 2008.

Confidential, Atlanta, GA

Sr. QlikView Developer

Responsibilities:

  • Managed company-wide system of QlikView BI solutions to ensure optimization of both data models and front-end UIs.
  • Roles and responsibilities include developing, enhancing, re-engineering, maintaining and supporting QlikView applications
  • Developed and designed comprehensive and innovative ad-hoc dashboard to provide manufacturer with broad
  • Visibility into its largest distributor, incorporating sales, forecast, target, and inventory metrics.
  • Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports.
  • Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks.
  • Used QlikView Functions (Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous etc.) and Created Variables using LET, SET or control statements in the scripts.
  • Used QlikView Scripting and Complex SQL coding for loading, and transforming.
  • Created Set Analysis for Comparison analysis eliminating additional complex coding.
  • Designed and developed the incremental loads where applicable.
  • Maintained both File and Data Level Security and implemented Data Reduction.
  • Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques.
  • Published Client application using QlikView Publisher and rolled out to Shared Drive with security permissions using Active Directory features.
  • Experience with QlikView Enterprise Management Console.

Environment: QlikView 11.2, Oracle 11g, Access, Windows 2003 Server, SQL Programming.

Confidential, Austin, TX

QlikView Developer

Responsibilities:

  • Meetings with end users to gather the functional requirements and customize Qlikview dashboards accordingly.
  • Involved in understanding the business from different areas and gather requirements.
  • Developed different dashboard with a complex database system which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
  • Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
  • Validation of Qlikview application at base level against QVD’s and Excel test files.
  • Set Analysis in providing custom functionality to QlikView Applications.
  • Experience in Using QlikView Functions ( Date and Time, Keep, Join, Mapping, String&Input Fields).
  • Created different publisher tasks like reload tasks, reduction tasks and distribution tasks using Qlikview Enterprise Management Console.
  • Monitoring of the QVS (Access Point), QVW's and user accounts for the usage of the applications.
  • Implemented section access which allows user to see by default their Region’s data and population attached to a particular Region.
  • Implemented security layer and extensively involved in the deployment activities of the Qlikview Application.
  • Automated QlikView jobs in QlikView Publisher and rolled out to QlikView Access Point and administered Security using Active Directory.
  • Wrote SQL Scripts to load relevant data in QlikView Applications.

Environment: Qlikview 11.2 SR4, Excel, MS SQL Server 2005, Oracle 10g.

Confidential, Atlanta, GA

QlikView Developer

Responsibilities:

  • Design & Development of QlikView Dashboards using QV scripting.
  • Performing analytics as per the requirement using charts and tables.
  • Developed KPI’s and Set Analysis applications.
  • Developed User Interactive Sheets & Reports as business needs.
  • Developed Dashboards pertaining to Sales using Qlikview 11.
  • Involved in Performance Tuning of QlikView dashboard.
  • Manage daily QlikView jobs that update QVDfiles and Dashboards.
  • Connected to different ODBC, OLE DB data sources (SQL Server, Oracle, and SAP BW) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView.
  • Developed extensively Alerts, Variables, Input boxes and Calendars.
  • Experienced connecting to SAP database with SAP connector and created QVD’s as per the requirement.
  • Worked on Qlikview Server and Qlikview Publisher .
  • Responsible for ETL and developing dimensional model using QlikView.

Environment: Qlikview 11, Excel, MS SQL Server, Windows Server 2000, Oracle 9.

Confidential McKinney, TX

QlikView Developer

Responsibilities:

  • Participated in user discussions to understand the user requirements, layout, and look and feel of the Dashboards to be developed.
  • Worked closely with users to understand data sources and requirements to build the best data model for QlikView applications.
  • Defined KPI’s and related data points on various lines of business; creates detailed and summary reports for executive review.
  • Developed Dashboards pertaining to Revenue and Sales monitoring using Qlikview 10.
  • Developed Qlikview presentation layer for charts with drill-down capability.
  • Created QVD generator load scripts.
  • Created data model in QlikView desktop to get all the data in required format. Used Mapping tables, Apply Map, Resident Load, Concatenate, Variables and so on.
  • Performed analysis, documentation, for calculation for various attributes.
  • Produced graphs and visuals using Excel charts and pivot tables to summarize data, identify outlying data points, and perform other exploratory data analysis.
  • Performed testing of dashboards for functionality, data, performance, look and feel.
  • Performance Tuning, Setup and Configuration related to Qlikview.

Environment: QlikView 10, .CSV Files, MS SQL Server 2005,Oracle 9i.

Confidential

Sr. Business Objects Developer

Responsibilities:

  • Involved in interacting with Users to know their Business views whilegathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
  • Converted business requirements in business/technical requirement documents.
  • Developed Webi, Deski, Crystal, Webi Rich Client and Xcelsius Dashboards.
  • Created Xcelsius Dashboards for Sales and Product level data based on Product Age & Usage using various components of Xcelsius.
  • Created complex reports in Deski, using multiple Data providers.
  • Changed the infoview page layout by adding new features like the company details instead of the Business Objects logo by using the customization methods.
  • Written SQL queries have been used on the Universe and created as Derived Tables.
  • Wrote Complex SQL Queries for Data validation purpose.
  • Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
  • Implemented Row Level, Object Level security for data restriction at Universe level.
  • Involved in Tuning and server configurations for different environments.
  • Tuned and Enhanced Universes with SQL Queries for the Report Performance.
  • Enhanced the Performance of the Dashboards by manipulating and using complex formulas on the Universe and Excel.

Environment: Business Objects XI R2, 3.1, Crystal Xcelsius, Oracle 10g, SQL Server 2000 & 2005, SSIS, Teradata, Weblogic 10 and Windows 2003, SAP 4.7, ECC 6, Oracle 9i, Windows XP, Unix, Java.

Confidential

Business Objects Developer

Responsibilities:

  • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
  • Wrote detailed level documentation for reports and universe design.
  • Generated ad-hoc reports by linking systems and interfaces.
  • Managed the resources, WEBI users, connections, and the Universe repository.
  • Created Objects and prepared Reports like financial reports, HR reports, standard and ad-hoc reports, and universes.
  • Created multiple reports using various complex courses and linked these reports with Combined Queries, Slice and Master Detail.
  • Created different reports containing charts showing revenue and operating income by different divisions, market share of newspaper by circulation.
  • Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports .according user requirements.
  • Generated the SAP Business Objects reports involving complex queries, sub queries, Unions and Intersection.
  • Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
  • Used the Export option for the Reports to schedule them in Broadcast Agent Server and sent the scheduled reports via Email, Text and Excel formats.
  • Used the Broadcast Agent Server to Schedule and Monitor the Reports.
  • Involved in updating and maintaining existing Universes based on changes in user requirements and changes in data.

Environment: Business Objects 6.5.1/ XI r2, Crystal Reports XIR2, Designer, Desktop Intelligence, Web Intelligence, Oracle 9i, SQL, PL/SQL, Windows XP.

Hire Now