SUMMARY:

• Having 7 plus Years of Experience in Implementing Business Intelligence Applications using various tools Like, QlikView and SQL,PLSQL.
• Over 6 Years of Experience in QlikView tools Such as QlikView Desktop, QlikView Enterprise Management Console, Qlikview Publisher, Qliksense Hub and Qliksense Management Console and Ajax Clients, QlikView Web Server.
• Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance using Qlikview.
• Experienced with Data Warehousing and business intelligence tools for developing various reports using QlikView BI.
• Designing and developing the best suitable practice for the QV data model, and designing the best schema (Star, Snowflake….etc), according to the user critical parameters (e.g. .QVD generation, volume size, reload frequency, duration and hierarchy of reload, setting the best time for automatic reload…..etc).
• Installed, Configured and deployed the application on QlikView and Qliksense server and Imported data from different sources like Oracle, SQL Server, share point files, QVDs and flat files using OLE DB/ODBC.
• Mainly designed and developed Qlikview software applications and complex server - based Qlikview dashboards from scratch to support reporting and Business Intelligence initiatives.
• Designed QVWs to generate QVDs for faster and efficient data reloads.
• Implemented security using QlikView‘s section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Implemented Google Maps using Qlikview at street level for locations of branches around the globe.
• Experienced in Requirements Gathering, Data modeling and Qlikview Application development.
• Designed and developed the PDF Reports for the applications where the users can print and save the reports dynamically from the Access point.
• Implemented Best Practices & Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys.
• Experienced in working with many complex SQL queries with Joins, Date functions, Inline functions, Fiscal Calendar and Sub-queries to generate reports.
• Used incremental loading of scripts for the faster retrieval of data from either database or flat files.
• Designing creative and visually effective user interfaces that address Key Performance Indicators
• Used Gantt Charts with the available horizontal bar charts to fulfill the requirement.
• Created Triggers at the document level and sheet level for the default selections when users are navigating between the tabs.
• Used Alternate States for the applications wherever required.
• Used set analysis and created publisher jobs for distributing the reports at Daily and Monthly level for the users.
• Good Knowledge of Structured Query Language (SQL). Experience with writing SQL queries for; data validation.
• Extensively involved in Demos, Presentations, Meetings and Interaction with Senior Management
• Business Analysis experience with excellent communication & interpersonal skills and broad understanding of business operations and requirements.

TECHNICAL SKILLS:

BI-Reporting Tools: QLIKVIEW 12,11,10,(Qlikview Desktop, Server, Publisher ),Jasper soft, OBIEE, Qliksense, NPrinting

Databases: Oracle 11g/10g/9i/8i, SQL server 2000, MS-Access, Microsoft GP

ETL Tools: Informatica Power Center 8.x/7.x

Languages: SQL, PL/SQL,C, XML

Tools: SQL Developer, SQL*Plus, TOAD, SQL navigator, SQL* Loader, Microsoft GP,Sierra

Operating Systems: Windows XP/2008/2012, HP Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Elsegundo, GA

Sr.Qlikview Developer

Responsibilities:

• Gathering requirements, preparing detail design document and developing the reports as per the business need. Developing BI backend ETL objects and front end reports.
• Installed and configured the Qlikview server.
• Qlikview from qlikview 11.2 SR 15 to the 12.1 SR8.
• Coordinate with other impacted teams. Effort estimation, involve in project planning with IT Project Manager and Business Manager/Owner.
• Support during integration testing, regression, system and performance testing and during promotion of these components to production environment.
• Performance tuning of the qlikview applications by Document Analyzer, Qlikview Components, DA Compare tool.
• Worked on load script customizations where clients can do their changes without altering the standard dashboards.
• Created and scheduled the jobs through EDX on the qlikview server.
• Used different database connectors such as ODBC, JDBC, OLEDB and QlikODBC for database.
• Regular interaction with different teams - all belonging to different departments and divisions to ensure the smooth running of the applications

Environment: Oracle database, Qlikview (11, 12), Jira Ticketing, Excel Spreadsheets, Windows Server/2008/2012.

Confidential, Augusta, GA

Sr.Qlikview Developer

Responsibilities:

• Involved in the requirements Gathering and Understanding the end- user business requirements and develop creative and visually effective user interfaces for Dashboards, Analytics and Reporting.
• Closely worked with SMEs to identify business-reporting needs and develop architecture to meet the requirements.
• Design and develop QlikView applications and complex server-based QlikView dashboards from scratch to support reporting and Business Intelligence initiatives
• ETL process to extract the data from M3 tables and Sql Server to generate the qvd’s.
• Used advanced scripting, set analysis, and advanced aggregation to meet complex business requirements.
• Deployed the applications to qlivkiew QA server and given access to the users for testing.
• Worked on consolidating multiple applications to single application.
• Created windows batch jobs and automated the scheduler to run the tasks on timely basis.
• Scheduled QVW reloads on server and troubleshoot errors and failures.
• Used Jira to handle and track the issues in QA and PROD.

Environment: Microsoft SQL Server, DB2 (M3 Tables), Qlikview (11, 12), Qliksense Server, Jira Ticketing, Excel Spreadsheets, Windows Server/XP/2003.

Confidential, PA

Sr.Qlikview Developer

Responsibilities:

• Created Different Data connections to connect to Different sources and created qvds.
• Added Different currencies to the existing ones for benchmarking data.
• Used Partial reloads on the applications as users can download and reload from their desktop versions.
• Created and embedded the RF Template Code in the applications, where users can use these for doing partial reload.
• Created a macro to browse the template to the local systems. And used widget buttons on the UI to open the filters.
• Created Triggers at the document level and sheet level for the default selections when users are navigating between the tabs.
• Used Alternate States for the applications wherever required.
• Worked on the QA and Production tickets using JIRA.
• Used interval match, Peek, Previous, Aggr functions.
• Used value loop and Valuelist to create dimensions on the fly.
• Created an app for the admins to track the Licenses allocated and usage analyzer using session’s logs.

Environment: Microsoft SQL Server, Oracle, Qlikview (11, 12), Qliksense Server, Jira Ticketing, Excel Spreadsheets, Subversion, Windows Server/XP/2003.

Confidential, Texas

Qliksense/ Qlikview Developer

Responsibilities:

• Created Different Data connections to connect to Different sources and created qvds from the Enterprise browser mode.
• Created different roles for the users depending on the streams like Root Admin, content admin, Audit admin.
• Implemented Security using section access and section application to reduce the data on the user login.
• By using content libraries imported the images into qliksense.
• Created different streams on the Qliksense QMC and made security rules for the streams and assigned the different roles.
• Migrated the QVF applications across different environments and published the apps to the streams.
• Implemented section access on the qliksense application.
• Created triggers for the tasks on the QMC like daily, weekly and dependent tasks for fail and Success
• Existing qlikview data-model applications are used in qliksense by using the Binary load and using session log files on the qliksense server, tracked down the usage of the applications.
• Created new apps on the MY Work and published to the Hub of Different Streams.
• Used different charts like KPI, Bar charts, combo charts, and Text objects.
• After developing the apps on the MY Work published the apps to the Different streams and added security rules for the apps
• Used qliksense Dev hub to connect to different tools like single configurator, Extensions Editor, mashup editor.
• For identifying the object ids and book mark ids of the qliksense used single configurator, Extension editor are used for editing the extensions and testing.

Environment: Microsoft SQL Server, Qlikview (11), Qliksense Server, Qliksense Hub, Jira Ticketing, Excel Spreadsheets, Subversion, Windows Server/XP/2003.

Confidential, Texas

Qlikview Developer

Responsibilities:

• Involved in the requirements Gathering and Understanding the end user business requirements and develop creative and visually effective user interfaces for Dashboards, Analytics and Reporting.
• Responsible for the QlikView Dashboard & Report development, which includes QlikView dashboard design /QlikView Script writing - connecting with varied sources (flat file/Oracle etc.), data cleansing, data analysis etc.
• Creating a relevant data model and front end to satiate the QlikView requirements
• Educated different user groups and peers with QlikView functionality.
• Have done the integration of project with the existing applications and used the Qlikview 11 features (Giving the users option to pick the Dimensions and Metrics).
• Implementing Security and Incremental Loading in QlikView Dashboards
• Monitoring the defects with HPQC and interacting with users to solve the issues.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Provided Production support to the existing qlikview applications.

Environment: Microsoft SQL Server, Qlikview (11),SAP BW, SFDC,HPQC,BMC Remedy, MS- Access, Excel Spreadsheets, SharePoint, Subversion Qlikview Server, Windows Server/XP/2003.

Confidential, Salt lake City, Utah

Qlikview Developer

Responsibilities:

• Used specially designed software called Wonderware which is the global leading brand of industrial software including Human Machine Interface (HMI), SCADA, MES, real-time Operations Management and Production Information Management software.
• Worked with Microsoft Great Plains accounting Software, Sierra and SharePoint which is used to get the required tables for the reporting.
• Coordinated with ETL team and performed integration testing to check data discrepancies
• Designed different applications for the different departments for IT, WRE production, HR, WRE oil recyclers.
• Created the Gauge charts to show the YTD, MTD, Daily cost and Efficiency of the Bio diesel production.
• Created the Gantt charts to track the Projects duration.
• Measuring the volume of Tank commodities, Total cost, Trending of bio diesel production.
• Imported images into qlikview by using bundle info load which are used in pivot tables.
• Using Sierra software designed a HR dashboard to track the Clock in and Clock out timings of the employees.
• Used incremental loading scripts for the huge volumes of data where the refresh is done hourly, daily, weekly.
• Debugging the Qlikview production server applications by using the log files, Session, Audit and performance log files.
• Developed User Interactive Sheets & Reports as business needs.

Environment: Microsoft SQL Server, Qlikview (11.2),Wonderware, Sierra Software MS- Access, Excel Spread sheets, SharePoint, Qlikview Server, Windows Server/XP/2003, SQL Sever management Studio

Confidential, Weehawken, NJ

Qlikview Developer

Responsibilities:

• Developed User Interactive Dashboards & Reports as business needs.
• Strong knowledge in building optimized data model understanding Star Schema and Snow Flake schema based on Business requirements
• Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Designed QVWs to generate QVDs for faster and efficient data reloads
• Implemented incremental loading for the slowly changing dimensions.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Communicate with users, clients and team members to understand specific requirements.
• Using QEMC mounted Apps into qlikview server and also created tasks for extract scripts, data models and front end applications.
• Design & Develop QlikView Dashboards using various objects & ability to write complex front end scripting or expressions.
• Analyzed the existingQlikViewdata model, script logics and the ETL business logic for the existingQlikViewapplications.
• Improved the overall performance of the application and redesigned data model applyingQlikViewperformance tuning techniques

Environment: Oracle Database (10G), Qlikview (11.2) SQL Server, MS- Access, Mainframe FilesWindows Server/XP/2003, Toad 9.0, SQL Developer.

Confidential, Manhattan, NY

Qlikview Developer

Responsibilities:

• Did Proof of concepts (POC’s) of the project applications as they are migrating from Business objects into Qlikview.
• Extensive experience in end-to-end implementation of Business Intelligence (BI) projects, especially in scorecards, reports & dashboards
• Involved in Requirement gathering & designing QlikView applications.
• Installed, Configured and deployed the application on QlikView server and Imported data from different sources like Oracle, SQL Server, XML files, QVDs and flat files using OLE DB/ODBC.
• Experience in designing backend ETL for data extraction & building data model using QlikView Scripting.
• Analysis of reports and data, working directly with the business to provide graphical reporting solutions
• Trained End Users on Using QlikView Tools.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Better understanding of business requirements and software development cycle and possess excellent interpersonal and communication skills.

Environment: QlikView 11.0, 10.0, Oracle 10g, Excel, .CSV Files, Windows XP, snagit.

Confidential, Fremont, CA

SQL/ETL Developer

Responsibilities:

• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer Mapping & Mapplet Designer and Transformation Designer.
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and.
• Designed and developed Informatica mappings for data loads.
• Extensively used Erwin for data modeling and Dimensional Data Modeling.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Extracted data from Sales department to flat files and load the data to the target database.
• Created and maintained several custom reports for the client using Business Objects.
• Generated reports using BO tools querying database.
• Created List Reports and Cross Tab Reports and Drill Through reports.
• Setting up sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Developed Aggregate, Joiner, Router, Lookup and Update Strategy transformation logic.Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy and others.
• Creation of Test data and verify the workflows and sessions and monitored sessions using Informatica Workflow Monitor.

Environment: Informatica 6.2, Oracle9i, SQL-Navigator 4.5, Erwin 4.0, UNIX, Windows XP.

Confidential

OBIEE Developer

Responsibilities:

• Gathered user requirements, reporting requirements and Involved in designing Physical Data Model.
• Worked closely with the ETL team to determine the granularity and figure out the facts and dimensions.
• Designed and developed OBIEE Repository at 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model mapping layer (create Logical tables and data source mapping) and Presentation Layer level (create presentation catalogs).
• Designed Physical Data Model in Repository according to the Business requirements with necessary logic that involved creating the physical, BMM and the presentation layer. Also created hierarchies, variables, and poll strategies in the repository.
• Implemented security at the data and object levels as per the business user requirement.
• Administered various OBIEE environments with large number of users and provided optimum system uptime and performance. Designed security matrix, configured Authentication and Authorization architecture, and provided permissions to users according to their role.
• Created dimensional hierarchies and multiple dimensional Hierarchies and various set levels in the Business Model Layer and Mapping Layer of Repository implementing drill down, Aggregation and Sum over columns.
• Used appropriate filters, column filters, prompts, dashboard prompts and calculations in reports.
• Developed Reports and Dashboards in different Analytical Views (ticker, narrative, column selector, view selector, legend, funnel Pivot Table, Chart) to visualize data in different perspectives using OBIEE Answers.
• Setup the visibility of dashboards to employees with respect to their responsibilities. Administered permissions and privileges for dashboard visibility and modifications to users based on their groups or responsibilities.
• Used Variable Manager in OBIEE Administration tool to define various Repository Session variables.
• Customized the look and feel (Skins & Styles) for OBIEE products (Answers Login Page, Banners, CSS files, etc.) as per company specific standards.
• Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views and aggregate tables.

Environment: OBIEE 10.1.3.2, Informatica 6.2, Oracle 9i, Windows XP