SUMMARY:

• Highly Motivated Business Intelligence professional with 6+ years of experience in Report Development, Data Analysis, Business Analysis. Proven history of strong analytical skills, attention to detail, and hard work ethics to turn complex requirements into working systems.
• Extensive experience in Qlikview, Qliksense, SAP Business Objects XI 4.0, 3.1, XI R2, SQL Server.
• Expertise in designing and modeling ofQlikViewApplications usingQlikView with complex multiple data sources (SQL, Oracle, Flat Files, Excel and Access) relational designs.
• Hands - on professional with thorough noledge of scripting, data source integration, and development in QlikView/Qliksense.
• Expertise in working withQlikViewDesktop,QlikViewEnterprise Management Console (QEMC),QlikViewPublisher,QlikViewWeb Server.
• Implemented ETL - Extraction Transformation and Loading by usingQlikviewthree-tiered QVD architecture.
• Involved in full project life cycle implementation (requirement gathering to production) of QlikView/QlikSensedashboards
• Worked on data modeling and developed different complex models as per given user requirement without any closed loops, Synthetic tables and ambiguous relationships.
• Configured and deployed teh application onQlikViewserver and Imported data from different sources like Oracle, DB2, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.
• Extensive experience in tuningQlikViewapplications in order to meet enterprise performance standards.
• Experience in data warehousing concepts and principles and data modeling techniques including star, snow flake schema etc.
• Has good noledge and exposure with all modules inBusinessObjectsXI 4.1, BusinessObjectsXIR3. (Info view, Web Intelligence, Desktop Intelligence, Crystal Reports 2008, Dashboard Designer - Xcelsius)
• Knowledge and experience working on teh new features and applications added in BO XI 4.0 IDT (Information Designer Tool), Work-spaces, Data foundation, business layers and Query objects, Business Launch pad, Web Intelligence, Interactive analysis, Dashboard designer
• Exposure on SSIS and SSRS tools.
• Strong working noledge of SQL, T-SQL & PL/SQL,Data warehousing concepts, Crystal Reports and ETL automation's.
• Trained in Big data technologies, Hadoop framework, HDFS, Alteryx, Hive & Pig. Worked on POCs to analyses data using Big data tools.
• Experience with Waterfall & Agile development methodology.
• Has good communication, analytical, interpersonal and presentation skills.

TECHNICAL SKILLS:

Dash boarding/Analytics: Qlikview, Qlik sense, Xcelsius 2008 SAP Business objects 4.0, XIR3 & R2

Databases: Oracle 10g & 11g, DB2, MS SQL Server, MS access

ETL Tools: Business objects data services

Query Languages: T-SQL, PL/SQL, Hive QL

Reporting Tools: Qlikview 11,Qlikview 10, Business Objects 4.0,XIR3, XIR2, Xcelsius 2008,Bex Query designer and Bex Analyzer

Operating Systems: Windows Server 2012, Windows 2008 R2, 2003 R2, 2003, 2000-Advanced Server, Windows XP, Windows Vista, Windows 7, LINUX

Other Tools: Qlikview server,Qlikview Publisher, Control Management Console, Central Configuration Manager and Import Wizard

WORK EXPERIENCE:

Confidential - Chicago, IL

Qlikview/Qliksense Developer

Responsibilities:

• Involved in requirement gathering with different business teams to understand their analytical/reporting needs.
• Experience in pulling data from different ODBC, OLE DB data sources and flat files to create different complexQlikView/Qliksense dashboards as per given business requirement by leveraging teh basic components ofQlikView/Qliksense.
• Designed various Front-end objects like Line, Bar and Pie Charts, Straight Table, Pivot Table and sheets objects like List box, Multi box, slider, current selections box, buttons, charts, text objects, bookmarks, etc
• Develop data model (Star schema) inQlikViewusing ETL concepts sufficing business needs
• Develop KPI's using different charts viz. Gauge chart, Block chart, Scatter chart, Pie Chart, Line Chart, Bar chartImplemented Data modeling as per teh requirement.
• Implemented business logic at chart level using advanced set analysis expressions and aggregation functions.
• Tune/OptimizeQlikView/Qliksenseapplications in order to meet enterprise performance standards.
• Implemented security usingQlikviewsection access dat dynamically hides selected areas of teh dashboards depending upon teh user privileges.
• DevelopedQlikviewapplications based on Incremental Load Transactions using QVD files.
• Implement several QlikView functions (Date and Time, Keep, Join, Mapping, String & Input Fields).
• Design QVWs to generate QVDs for faster and efficient data reloads
• Managed theQlikViewServer tasks: developing tasks, assigning license CALs, creating user groups etc.
• Wrote SQL Scripts to load relevant data inQlikView/QliksenseApplications.
• Resolve synthetic keys. Utilize Mapping load, Apply Map to get descriptions in fact table based on ID's
• Troubleshooting and debugging teh script for error correction and optimization.
• Participated inQlikViewEnvironment setup, configuration and Implementation with teh BI Support Teams.

Technology: QlikView 11, Qliksense, QlikView Server, QlikView Publisher, Nprinting,SQL Server, PL/SQL.

Confidential - Atlanta, GA

Qlikview & Business objects Developer

Responsibilities:

• Involved in requirements gathering sessions with business users to prepare functional requirements.
• Created ODBC Connections to extract from data bases and store them in QVDs.
• Experience in Data Extraction, Transforming and Loading from different source systems and flat files intoQlikView according to business requirement.
• Implemented Star Schema and Snow Flake schema in designing teh data model.
• Used Mapping Loads to eliminate certain dimension tables and reduce teh number of tables and complexity in theQlikView data model.
• Building QVD's from different data sources like SQL Server, Oracle, Excel, CSV and Flat Files.
• Developed dashboards using different sheet objects like List boxes, Multi boxes, Buttons, Text objects, Input boxes, Scatter charts, Bar charts, Pivot Table, Straight Table, Containers, Slider, Funnel chart.
• Providing production support to theQlikViewapplications.
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in teh front-end, improving layout structure.
• Created adhoc reports inQlikViewand supported teh users with teh adhoc reporting queries
• DevelopedQlikViewDashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar.
• Involved in security implementation onQlikViewapplications and deployment ofQlikViewapplications to teh production environment.
• Implemented Set Analysis to improve teh calculation times on teh front end. Used different Types of joins to join data from different tables.
• Troubleshooting and debugging teh script for error correction and optimization.
• Uses QVD and incremental loading to delete, insert and update records.
• Created universes using teh IDT (Information Designer Tool) in SAP BO XI 4.0 from teh relational data sources for work flow reporting.
• Worked on charts, filters, drill reports, linked reports (Open doc/Hyper linking through interactive reporting), sorting, sectioning, alerting, ranking, complex report formatting using various WEBI formulas, scheduling reports, profiling and publications through CMC.

Technology: QlikView 10 & 11, Qlikview server, SAP BusinessObjectsBI4X (SIA/ Central Management Console, Information Design Tool (IDT), SQL Server 2005, Oracle 10g

Confidential

Business Objects Developer

Responsibilities:

• Gathering, analyzing, and documentingbusinessrequirements, functional requirements and data specifications forBusiness ObjectsUniverses and Reports.
• Involved in SAP BOXI 3.1 Software Installation and Configuration
• Modified universes by identifying and defining teh various joins, cardinalities.
• Created reports usingBusinessObjectsInfo view. Created different types of reports such as cross tab, master reports.
• Created prompts and cascading prompts to refine teh report as per teh requirement.
• Creating joins between teh tables, resolving teh loops in teh Universe as per teh business reports requirements.
• Used report conversion tool to migrate DeskI reports to WebI reports.
• Used Oracle database to access teh various tables and queries to be imported into teh Universe.
• Used @aggregate aware, @select, @where, @Variable and other @function in a Universe to make efficient universe. Link different universes and import and export to repository.
• Created Classes, Sub Classes, Dimension Objects, Measure objects in multiple universes, checked teh Integrity of teh Universes and exported teh Universes to Repository to make them available to user.
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data.
• Created reports using functionalities like Slice and Dice, Drill Down, Drill Up and Ranking dat were used in reports.
• Used functionalities like filters, alerts and created formulas and variables to develop reports.
• Resolved issues like Loops, Fan Traps & Chasm Traps by creating Aliases and Contexts as required in removing teh cyclic dependencies.
• Created user groups and managed access privileges usingBusinessObjectsCMC.
• Set up teh security levels to teh users in universe module like row level andobjectlevel security.Exported teh universe to teh Repository to make resources available to teh users.
• Created Xcelsius dashboards using various data connections like Excel, Query as a Web Service (QAAWS) and Web service connections
• Build a Dashboard using Xcelsius 2008 forBusinessanalysis.
• Created multiple Flash variables in Xcelsius and used them to pass data from one dashboard to other.
• Worked on improving performance of reports with aggregate aware and using indexed columns in reports.
• Created users and groups in CMC.Created folders and granted rights for teh different user groups.

Tools: used: Oracle11g, BusinessObjectsXIR3 & XIR2, BO SDK, Web Intelligence, Desktop Intelligence, CMC, Designer, Import Wizard, Report conversation tool, Xcelsius 2008