SUMMARY

• Dedicated IT Professional wif 5 years of IT experience in Analysis, Design, Development and Implementation of data warehousing which includes extensive experience in Qlikview and OBIEE formerly Siebel Analytics and Data warehousing tools
• 4 years of experience in Designing and development of business Intelligence application wif QlikView 9.x/11.x
• Hands on experience wif thorough knowledge of scripting, data source integration and advanced GUI development in Qlikview
• Good exposure to QlikSense 1.0/2.0
• Expertise in Installing and Configuring QlikView Server and Publisher … wif QlikView web server / IIS in both clustered and non - clustered environments
• Experience wif QlikView Sheet objects including various charts types, Trends, KPI's, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting
• Strong experience in designing and developing dashboards using Qlikview by extracting data from multiple sources (SQL-Server, Oracle, Flat files, Excel, CSV, QVD etc.)
• Extensive experience wif Qlikview sheet objects, scripting, and optimizing applications and building qvd’s and qvw’s
• Experience in setting up server, publisher (QVPR) configurations and security/ authorization at different levels in Qlikview
• Strong knowledge in Incremental Loading & QlikView document Versioning
• Strong experience in teh Qlikview scripting to write custom scripts and impalement SQL functionalities
• Extensively used SET analysis expressions to develop different KPI's like MTD, QTD etc over accountable Zones & time periods
• Strong skills in Section access incorporating row level security
• Distribution / Scheduling task for Qlikview Reports in Qlikview Management Console (QMC)
• Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Proficient in providing Data Warehousing and Business Intelligence Tool solutions wif Qlikview, SSRS, Oracle BIEE (OBIEE).
• Expertise in creating Schema Objects (facts, attributes, User Hierarchies, Transformations) to Build Application Objects
• Expertise in Developing Application Objects (filters, metrics, prompts, Custom Groups, Consolidations, Templates, Drill Maps) to Build Documents and reports
• Strong Experience in Extract, Transform & loading data in QlikView Applications & Develop Data models using Star Schema & Snow Flake Schema's
• Expertise in OBIEE Reports and Dashboards
• Strong SQL skills on Oracle, DB2, SQL SERVER and Sybase, PL/SQL technologies, Stored Procedures, Functions,Packages, DB Triggers and Indexes
• Designed and developed teh OBIEE Metadata Repository (.rpd) using OBIEE Admin Tool by importing teh required objects (Dimensions, Facts & Aggregates) into Physical Layer using Connection Pool, developing multiple dimensions (drill-down Hierarchies) & Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog in teh Presentation Layer
• Good Knowledge for Support and Monitoring Activities issues & resolution based on Priority
• Experience on Data filter, Combined Data Stream, Overriding methods, Bursting Techniques, Page level security techniques. Conditional report designing, Adhoc reporting
• Application knowledge of teh following industries: Sales, Insurance, Healthcare and Banking Services.

TECHNICAL SKILLS

Reporting Tools: Qliview 10.x/11/X, QlikSense 1.0/2.0, SSRS, OBIEE

Databases: MS SQL Server, Oracle

Data Modeling Tools: ERWIN

ERP: Oracle Applications, Peoplesoft

ETL: ODI

PROFESSIONAL EXPERIENCE

Confidential, NE

Senior Qlikview / QlikSense Developer

Responsibilities:

• Created reports based on teh different counties under numerous categories for benefit programs and other development programs.
• Developed Qlikview transformation Scripts
• Performed Business Requirement gathering & designing QlikView/ QlikSense applications.
• DevelopedQlikViewDashboards using different Chart, Drill through, Cyclic Groups, List, Input Field, Table Box, Container etc
• Maintenance of data in form of QlikView/Qliksensedata files, pulling teh data from relevant database
• Implemented different types of data loads in QlikView/Qliksense including Resident load, Binary Load, Incremental Load and Inline Load.
• Handled teh end-to-end implementation of QlikView /Qliksensedashboard deployment
• Implemented 3 layer architecture different load scripts so dat data stored as QVD's.
• Many QVD files will be shared between applications build an elaborate structure
• PreparedQlikSenseproof of concepts as per teh requirements and specifications
• Handled caching strategies for performance tuning.
• Finding and Understanding teh essential data, eliminating teh data which doesn't suit teh requirement.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging teh basic components of QlikView.
• Managed and reviewed Hadoop log files.
• Tested raw data and executed performance scripts.
• Creating teh data model wif necessary fact and dimension data.
• Created a standard template for teh dashboard.
• Bring teams to an even higher level of performance
• Engage in lightweight Agile program management
• Imported various data sources like QVD files, Excel, Oracle & SQL server 2008, Binary QVW, Inline & text files in developing teh QlikView Data Models
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input Fields etc)
• Promoting dashboards to production environment, Scheduling and Distributing through QMC and manage user access.
• Involved in working wif Server, Publisher and Application Deployment.
• Created automatic jobs to refresh QlikView files
• Utilized Incremental load concept for teh update of QVD’s
• Efficiently used Hierarchy and Interval match for grouping
• Developed Macros, Set Analysis, Section Access to provide custom functionality in QlikView Applications
• Testing applications, reports using review checklists, data quality for quality assurance before delivering to teh end users
• Developed production-gradeQlikViewreports and dashboard to meet business requirements in timely manner.
• Designed applications to support teh lending process and dashboard style of layouts using different components ofQlikViewEnterprise like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using theQlikViewPublisher
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, Statistics Box, Multi Box and Calendar & Date Island
• Experience in setting up Server, Publisher configurations and Security authorization at different levels.

Environment: QlikView 11.2, Oracle 11g, Teradata, Flat files, MS Excel, MS Access, Windows.

Confidential, CT

Senior Qlikview Developer

Responsibilities:

• Involved in System Analysis and Database Design.
• Developed Reports and Admin modules.
• Developed dashboards pertaining to Revenue and Sales monitoring usingQlikview10.0
• Worked on data modeling and developed different complex models as per given user requirement by eliminating loops, synthetic tables and ambiguous relationships
• Designed various user interface objects like Line, Bar, Pie, Straight, Pivot Tables and other sheets objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc
• Used advanced scripting, set analysis, VBScript macros, advanced aggregation functions and advanced charts for applications
• Involved in working wif Server, Publisher and Application Deployment.
• On demand reload facility for teh users to reload teh data when needed to view in report.
• TunedQlikViewapplication for efficient performance
• Create product concepts based on teh company strategy
• Break down concepts into user stories
• Developed Dashboard using Bar Charts, Line Chart, Text Boxes and List Boxes.
• Used Alternate States and Set Analysis to get teh needs of teh end users.
• Used QVD generator QVW file to create teh QVD’s. In teh QVD generator file teh data is imported from teh SQL Server.
• Used Macros and Extensions in teh dashboard developed.
• Worked on Publisher & Autosys to automate and schedule daily/weekly/monthly data loads of QVW documents and error notifications by email to assigned users
• Implemented security usingQlikViewsection access dat dynamically hides selected areas of teh dashboard depending upon user privileges
• Extensively Used Mapping load, Apply Map to lookup instead of joins
• Trained severaldevelopersonQlikViewin terms of best developing and design practices and general "how to" procedures
• Updating leaves, attendance and team performance Reporting and sending Reports to teh Supervisor.
• Handlings calls related to Process and clarify doubts of teh Process wif teh users.
• Creating FAQs on daily basis and sending to teh users to clarify and giving solution to teh team.
• Well versed in Fraud issues.
• Developed client-side validations wif Java Script.
• Validating teh reports against warehouse using Manual SQL scripts

Environment: QlikView 10.0, Oracle 11g, Teradata, Flat files, MS Excel, MS Access, Windows.

Confidential, MA

Qlikview Developer

Responsibilities:

• Gathered and documentedQlikviewapplication requirement from teh users
• Developed SQL queries and sub queries for faster retrieval and server efficiency in SQL Server 2008
• UsedQlikViewfunctions to load data viz Load, resident load, concatenate and so on
• Created various sheets objects like Bar chart, Line graph, Straight table, pivot table, combo chart
• Created complex expressions in charts
• Closely worked wif End users to get teh requirements
• Created Dashboard of reports usingQlikViewcomponents like List Box, Slider.
• Developed Variables, Input boxes, calendar & Macros
• Developed Linked Tables, Concatenation and solved teh loops issues
• DevelopedQlikViewDashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, Statistics Box, Multi Box and Calendar & Date Island
• Created containers, Search object and Current selection box
• Resolved synthetic keys. Used Mapping load, Apply Map to get descriptions in fact table based on Id's. Used resident load, preceding load, cross table and so on
• Expertise in converting Business requirements to Technical specification documents
• Performed different tasks like extraction, reload tasks, reduction and distribution tasks based on Market drill-down using theQlikViewPublisher
• Worked on 11 dashboards for marketing and finance
• Wrote SQL queries for data validation
• Organized testing schedules and test scripts. Managed execution and sign-off tests and also played an active role in product rollouts

Environment: Qlikview 9.0/8.5, SQL Server Database, Windows Server 2003, oracle 10g, Microsoft Visio, Qlikview Publisher, Qlikview Server 9.0.