SUMMARY:

• Experience in gathering Business Requirements, Planning, Analysis, Design, Development, Testing and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence applications (QlikView, Oracle OBIEE)
• Experience in various development Methodologies like SCRUM, AGILE.
• Experience in Application/Production Support.
• Expertise in BI Applications (QlikView, Qlik Sense, OBIEE) Data Models using data.
• Experience in Creating Qlik Sense charts, Visuals, and dashboards to meet end users needs.
• Experience in data sources - Oracle, Teradata, SQL Server, QVD files, text files and Excel documents.
• Experience in Connecting Qlik Resources with Hadoop, SAP Connectors.
• Experience in Enterprise scale Qlik Environments.
• Experience in Qlik Sense admin activities using QMC (Qlik Management Console)
• Experience in QlikView Servers Clustering architecture, Nutanix hyper Converged Solutions.
• Experience in QlikView server load balancing, clustering, Users reliance.
• Experience in writing complex SQL Queries, SQL Joins, SQL Statements on Data warehouse applications, databases.
• Creating integrations in Qlik Sense using Qlik Sense Web Services/API's.
• Connected custom data sources using Qlik Sense using Qlik data eXchange(QVX).
• Experience in using Qlik Sense functions (Aggregate, Range, Geospatical, Mathematical, Numeric)
• Created Qlik Sense Extensions to reach to requirements.
• Experience using Qlik Sense Extensions development on Angular JS/UI Frameworks.
• Experience in Qlik Scripting using BI Data Visualization QlikView/Qlik Sense.
• Data Sources Integration using XML, ODBC, DirectDiscovery, QVX Technology.
• Created various charts like bar chart, combo chart, pie chart and Pivot table in Qlik Sense
• Extensive knowledge on Data modeling, Dimensional Modeling, Star/Snowflake Schemas.
• Experience in BI Application - QlikView objects, including charts types, Trend Lines, KPI’s, Bookmarks, Pivoting, and custom requests for Excel Export.
• Experience working on data modeling and developing complex models for business users.
• Managed all data and configuration information using Qlik Sense API’s.
• Upgrade Projects Involved in QlikView upgrade from 10.0 to 11.0 and 9.0 to 10.2 versions, OBIEE Upgrade from 10g to 11g and 11g to 12c.
• Experience in managing QlikView security, architecture, design components, user profiles, and authentication mechanisms.
• Developing SQL queries on Databases as per business data requirements.
• Developing BI Application - OBIEE Repository (Physical Layer, Business Model & Presentation Layer).
• Working knowledge of Qlik Sense Extensions for business views.
• Expertise in ETL (Data Extraction, Transformation & Loading), Data modeling, Report designing and Performance Tuning using QlikView
• Experience using QlikView objects - Straight tables, Pivot tables, Containers, Line charts, Bar charts.
• Building QlikView - QVD’s and QVW’s
• Expertise in creating Design Specification Documents to facilitate the development Cycle.
• Good Knowledge and experience in Performance Tuning of reports with complex database joins and tuning query logic in reports.
• Data analytical Skills and debugging for data accuracy and data integrity.
• Developing SQL queries, Views and Stored Procedures for BI Applications QlikView, OBIEE.
• Working Experience with parallel development teams in multiple projects.
• Proficient in coordinating and managing the activities between onsite and offshore teams.
• Understanding of QlikView application administration encompassing Planning/ Implementing User, Resource and Password Management, Backup & Recovery Strategies, Performance Tuning, Creation and Configuration of database on Oracle.
• Implemented Data Level Security, Object Level Security and LDAP authentication.
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
• Involved in the full System Development Life Cycle (Analysis, Development, Deployment, Testing and Documentation).
• Work well in teams as well as independently.
• Excellent client facing and strong communication skills.

TECHNICAL SKILLS:

BI Tools: QlikView(10/11/12), Qlik Sense(V2,V3, June2017 Release), OBIEE 11g/10g/9iOBIA/BI APPS 7.9.6x/7.9.5,: Data warehouse Administration Console (DAC) 11g/10g, BI Publisher.

ETL/Data Modeling tools: ODI (Scenarios), Informatica 9.x, ODI 11g (11.1.1.6.0 )

Database: Oracle 12c/11g/10g/9i, MS Access, Teradata, MS SQL

Operating Systems: Windows, LINUX, UNIX

Tools: TOAD, SQL*Plus, SQL Developer, Golden Gate, Tortoise, SVN

Languages: SQL, PL/SQL, C, Java, Shell Scripting, XML and PERL

WORK EXPERIENCE:

Confidential, Chattanooga, TN

Sr.BI Developer/Architect

RESPONSIBILITIES:

• Developing Qlik Sense apps using - Line, Bar, Combo, Pie and Gauge charts, KPI Charts, Heat Map US, Pivot Tables, Tree Map, Scatter Plot.
• Upgrading QlikView Version 10 to 11, Qlik Sense Version 3 to June 2017 Release.
• Conversion project of all Pentaho reports to Qlik Sense apps/Charts.
• Configuring N Printing for Delivering Qlk Sheets, App On-Demand Functionality.
• Created SET Analysis expression in sheets for data visualization needs.
• Developed Preceding load, Mapping load Scripts for data inside Qlik Sense.
• Qlik Sense Dev Hubs Integration using Single configurator, Extension editor, Mashup editor, Widget editor .
• Manipulating BI Visualization/BI Tool Reporting Qlik Sense Extensions.
• Managing Qlik Management Console (QMC) for admin activities.
• Experience in QlikView server load balancing, clustering, Users reliance.
• Developing Complex SQL Queries, SQL Joins and statements on data warehouse tables for data extraction and reporting purposes.
• Implementing web application security and concepts - SSL, LDAP Authentication.
• Created Charts, Sheets, Navigation Reports, Mashups, Extensions Functionality in Qlik Sense.
• Creating integrations in BI Visualization/BI Tool Reporting Qlik Sense using Qlik Sense Web Services API.
• Developing/Creating Qlik Sense Extensions to meeting business requirements.
• Developing/building dimensional model for facts and dimensions tables.
• Optimizing QlikView performance by creating QVD’s from DWH and configuring incremental reloads to reduce load on DB Server.
• Performing reload tasks and distribution tasks using the QlikView publisher.
• Business User Engagement for overview of QlikView/Qlik Sense and performing training sessions for End Business users.

Environment:: Qlik Sense V3, June 2017 Release, MS SQL, Pentaho, IBM Data Studio, Workfront, Qlik Extensions, Mashups.

BI Developer

RESPONSIBILITIES:

• Developing QlikView Dashboards using Various functionalities of QlikView - Chart types: Line, Bar, Combo, Trellis and Gauge charts, drill down, drill up, Upgrading QlikView Version 10 to 11, Qlik Sense 2 to 3.
• Design, develop and test QlikView scripts to import data from source systems and test QlikView dashboards to meet business requirements.
• Qlik Sense Extensions connecting to hadoop, SAP Connectors.
• Experience in QlikView Servers Clustering architecture.
• QlikView Clustered environment, single node.
• Developing Qlik Sense Visuals, dashboards to meet end users needs.
• Creating Mashup and integrations in Qlik Sense using Qlik Sense Web Services/API's.
• Qlik Sense Data Sources Integration using XML, ODBC, DirectDiscovery, QVX Technology.
• Creating integrations in Qlik Sense using Qlik Sense Web Services/API's.
• Configuration QlikView Architecture, Load Balancing and Scaling.
• Experience in Qlik Sense administration activities using QMC (Qlik Management Console).
• Qlik Sense Sharing applications App on Demand on Big Data.
• Created various charts like bar chart, combo chart, pie chart and Pivot table in Qlik Sense.
• Business User Engagement for overview of QlikView/Qlik Sense and performing training sessions for End Business users.
• Managing security layer with access management at the user level.
• Utilizing extensions for Qlik Sense Apps to meet the business expectations.
• Managing Data in QlikView application from QVDs excel files, database and external loading files..
• Developing/Creating Qlik Sense Extensions to meeting business requirements.
• Developing/building dimensional model for facts and dimensions tables.
• Image Insertion into Pivot table, creating scattered charts based on requirements.
• Reviewing Business requirements and achieving business goals/needs using QlikView reporting tool.
• Modifying existing QlikView dashboards, communicate with the business users in case of any issues with using the applications and providing solutions.
• Performing detailed analysis of source systems, source data and model that data in QlikView.
• Performance tuning of QlikView dashboard in order to reduce the calculation time and improving the overall performance of the dashboard.

Environment:: QlikView 11, Qlik Sense 3, Oracle (11g/12c), SQL Developer, MS Office, Windows, LINUX/UNIX, HPALM/HPQC.

BI Developer

RESPONSIBILITIES:

• Developed QlikView Dashboards using Various Chart types like Line, Bar, Combo, Trellis and Gauge charts.
• Designing and developing QlikView dashboards to support reporting and Business Intelligence expectations.
• Admin for QlikView Clustered environment installations patches.
• QVS Clustering unbalancing on servers following the architecture.
• Experience in Creating Qlik Sense charts.
• Connected custom data sources using Qlik Sense using Qlik data eXchange(QVX).
• Experience in using Qlik Sense functions (Aggregate, Range, Geospatical, Mathematical, Numeric).
• Created Qlik Sense Extensions to reach to requirements.
• Manipulating Qlik Sense Extensions.
• Creating integrations in Qlik Sense using Qlik Sense Web ServicesAPI.
• Installations and configurations of QlikView Server.
• Perform detailed analysis of source systems and source system data and model that data in QlikView.
• Design, develop, and test QlikView scripts to import data from source systems and test QlikView dashboards to meet customer requirements.
• Business requirements analyzing and developing dashboards and reports.
• Developing and maintaining technical design documentation.
• Performing quality coding to business and technical specifications.
• Coordinated with Team Members in development process to integrate with the Test and Production Servers.
• Configuring and deploying the applications in the access point using QlikView Server/Publisher.
• Identified bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that business needs meet.
• Creating Variables and Triggers to enhance functionality of QlikView
• Creating tasks and deploying applications in access point using QlikView Enterprise Management Console.
• Managing QlikView Server to run and operate in the most efficient manner.
• Work directly with business units to define and prototype QlikView Applications.
• Extracting, transforming and loading data from multiple sources into QlikView applications.
• Building QVD’s from SQL Server Database, Stored procedures and Excel files
• Designing User Interface (UI) based on the Business requirements
• Developing QVD scripts to load history and current data using Incremental logic
• Utilizing Stored functions to store QlikView Data into CSV files to create business reports
• Developing/Creating PDF reports and job scheduling to generate PDF’s for business users.

Environment:: QlikView 10/11, Qlik Sense 2, Oracle 11g, SQL Developer, MS SQL Server, MS Office, Windows, LINUX/UNIX, HPALM/HPQC.

BI Developer

RESPONSIBILITIES:

• Developing QlikView Dashboards using Various Chart types like Line, Bar, Combo, Trellis and Gauge charts
• Developing, and test QlikView scripts to import data from source systems and managing QlikView dashboards to meet customer requirements.
• Building QVD’s from Hadoop, Web Services using SOAP request, Teradata, Oracle, and Sales Force.
• Managing onsite team members for develop dashboard and reports.
• Identifying data sources and targets for data modeling.
• POC Activities, ROM Estimation, Scrum estimates for developing dashboards.
• Utilizing Section access and Sheet access to ensure application is available for business users.
• Managing Data from Databases to QlikView and Developing Dashboards to meet business requirements.
• Performing Training sessions for users to create dashboards using Qlikview functionality.
• Developing user defined document for Business Analysis.
• Optimizing data models by manipulating loading scripts to load data to improve performance.
• Engaing in QlikView management console activities.
• Monitoring and Maintenance of all BI components od DWH and BI.
• Developing SQL Queries to execute data from DB with better performance.
• Exporting and Printing data in QlikView.
• Developing SQL Queries to fetch data for dashboard reports.
• Converted QlikView Dashboard to Qlik Sense App.
• Created Input boxes, Pivot Tables, Straight Tables, Bar Charts, Buttons, Multi boxes on the UI to make it more accessible to User community
• Developing charts like Bar, Line, Combo, Pie charts to show various KPI’s and Scorecards.

Environment:: QlikView 11, Qlik Sense 2, OBIEE 11.1.1.7, Oracle 10g/11g, SQL Developer, MS SQL Server, MS Office, Windows, LINUX/UNIX, HPALM/HPQC.

BI/ETL Developer

RESPONSIBILITIES:

• Implemented Financial Analytics, Supply Chain and order Management Analytics, Integrated data from Finance and other enterprise systems.
• Extensively used all the features of Informatica Versions 9.1, including Designer, Workflow Manager and Repository Manager, Workflow monitor.
• Setup of Multi User Development Environment (MUDE) in OBIEE.
• Performed the Setup, Installation and Configuration of the complete Analytics platform environment OBIEE, Informatica and DAC.
• Designed and Developed Procurement and Spend and Supplier Performance, General Ledger, Payables, Receivables, Profitability, Dashboards in OBIEE.
• Designed and Developed General Ledger, Payables, Receivables, Profitability Dashboards in OBIEE.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.
• Detailed knowledge in Data warehouse Administration Console (DAC) and Informatica Servers.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Work Flow Monitor.
• Analyzed, Designed, and Developed OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Model and Mapping Layer, Presentation Layer.
• SSL, LDAP Configurations on OBIEE and NMS Servers.
• Migration of OBIEE Reports to another Environments.
• Analyzed, Designed, and Developed OBIEE Metadata repository (RPD) that consists ofPhysical Layer, Business Mapping and Model Layer and Presentation Layer.
• Worked on Repository manager to create and manage user profiles, and used Repository manager extensively while migration the code from development to production and compared both codes.
• Defined Dashboards, Filters, and Prompts as per user’s requirements.
• Handling larger database queries and applying transformations to make the business solution applicable to project.
• Involving in database Cloning Activites through the Environments.
• Created users in Informatica, assigned them various permissions.
• Setup of Multi User Development Environment (MUDE) in OBIEE.
• Wrote documentation to describe program development, logic, coding, testing, changes and corrections.
• Implemented Financial Analytics, Enterprise Asset Management Analytics, Procurement and Spend Analytics.
• Developed complex mappings using corresponding Source, Targets and Transformations like update strategy, lookup, stored procedure, SQL, sequence generator, joiner, aggregate, Java and expression transformations in extracting data in compliance with the business logic.
• Extensively used Informatica Power center and created mappings using transformations to flag the record using update strategy for populating the desired slowly changing dimension tables.
• Querying and analyzing multiple databases and handling the errors as per the client specifications.
• Created server optimized database routing and mappings and focused on performance tuning.

Environment: Informatica 9.1, OBIEE 11.1.1.6, BI Apps 7.9.6.4, DAC 11g.Oracle 10g, MS SQL Server, PL/SQL, SQL*Plus, SQL Developer, Unix/Linux, Windows.