SUMMARY

• Around 7+ 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.
• Around five years of experience in QlikView alone.
• Experience in Full Life Cycle development including Planning, Analysis, Design, Implementation and Maintenance using QlikView.
• Good Confidential working with Data Warehousing and other business intelligence tools for developing various reports using QlikView BI.
• Excellent knowledge in designing and developing dashboards using QlikView by extracting the data from multiple sources (Oracle, Flat files, Excel, Access).
• Experience in designing and developing dashboards using QlikView by extracting the data from JD Edwards 9.1 ERP application
• Experience in developing operational reports/Dashboards using JDE back - end oracle tables.
• Experience in Coding/developing for code reusability including the use of variables in QlikView.
• Maintained Three-Tier architecture across all QlikView dashboards.
• Extensive experience with QlikView sheet objects like Straight tables, Pivot tables, Containers, Line charts and Bar charts, scripting and building QVD’s and QVW’s.
• Experienced in consolidation of multiple QlikView applications into one.
• DAR (Dashboard, Analysis and Reporting) approach is maintained throughout dashboards.
• Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Developed various user interactive charts using QlikView advanced futures like Set Analysis and Alternate States.
• Experience with QlikView sheet objects including multiple charts types, Trends, KPI’s, custom requests for Excel Export and objects for Management Dashboard reporting.
• Experienced in all kinds of loads incremental, generic, partial, binary, preceding, mapping and resident.
• Experienced in implementation of QlikView security by authentication, authorization Confidential document level and data level to the end users.
• Explored intensively and implemented QlikView 11 advanced features like Set Analysis, Alternate states, integrating Google Maps, Dimension Limits and creating Ad-Hoc Reports.
• Working knowledge in writing SQL queries to test the OLTP & OLAP Databases based on changes of the functionality.
• Designed and implemented incremental load using QVD’s.
• Developed Ad-Hoc reports as per user requirements.
• Managed schedules and reloading of QlikView data model QVDs and QVWs through QlikView server
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher
• Experience in integration of Nprinting setup with Qlikview reports for generating automated office reports
• Extracted Data to PDF and excel files, triggered automated email notifications with charts using Nprinting
• Configured .Processed,.Bat Files for XML listeners to automate/Schedule Nprinting Jobs.
• Experience in Configuration of QlikSense.
• Experience in Upgrading existing Qlikview dashboards to QlikSense.
• Good in validating the BI reports/dashboards by preparing the Test Plans& Cases.
• Experienced in writing UNIX shell scripts, SQL Loader, Performance &Tuning of Database.
• Strong knowledge in Oracle 11g/10g/9i/8i database programming using/SQL (Stored Procedures, Functions, Triggers, Cursors) and standard Built-in Oracle Packages.
• Created test plans, test objectives, test strategies and test cases in the QA testing phase.
• Excellent work ethics, self-motivated, quick learner and team oriented. Continually provided value added services to the clients through thoughtful experience and excellent communication skills.

TECHNICAL SKILLS

Business Intelligence Tools: QlikView Enterprise v 9.0, 10, 11

Project Management Tools: MS Project 2007

ETL Tools: Informatica, Datastage, SSIS

Databases: Oracle (9i, 10g&11g), MS-Access, MySQL

Operating Systems: Windows Server 2003/2008, UNIX AIX 4.1/4.2, Linux Confidential 5, 6.

Office Tools: MS Word, Excel, PowerPoint, Outlook

PROFESSIONAL EXPERIENCE

Confidential

QlikView Developer

Responsibilities:

• Worked with Business Analyst and the Business user to identify the user requirements, business reporting needs, layout, and developed the architecture of prioritized reports.
• Performed planning, design, and development of QlikviewBI dashboards and data integration in a highly complex global services environment, interfacing Qlikview
• Actively participated in the design, architecture and development of user interface objects in Qlikviewapplications.
• Created Dashboard reports to track all the way through ship to final acceptance phases.
• Developed executive dashboards in Qlikviewdelivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Installed, configured and deployed the application onQlikview server and Imported data from different sources such as Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Performed technical leadership in dashboard application design, visualization, automation, e-mail alert and notification, data modeling and the integration with the Portal platform
• Created different complex sheets and sheet objects based on client requirements.
• Created List boxes, Statistic boxes to show the statistics of the sales held on different products in different years.
• Showed the statistics in bar charts and pie charts as per the client needs.
• Added dimensions to a bar chart and turning bar chart into a multidimensional pivot table.
• Created multi boxes, table boxes, and input boxes to fetch data based on the input given.
• Designed and developed to support UI visualization, ETL processes, automation, and workflow of dashboard presentation framework.
• Collected and analyzed business requirements, developing engineering prototype and using POC to facilitate KPI Metrics dashboard design across different regions and business units.
• Created Layout themes and applied it to several documents.
• Used set analysis, advanced aggregation functions and advanced charts for applications.
• Participated in design and code reviews, QA/UAT testing, enhancement design and development, and deployment to support day-to-day business operations
• Generated XML external report, Excel report, on demand report, HTML report using Nprinting.
• Automated and Scheduled Nprinting jobs.
• Involved in performance tuning of dashboards to limit the response time and enhance the functionality.
• Enhanced and translated existing dashboards in SSRS into Qlikviewand worked extensively with the set analysis.
• Successfully passed through the QA Environment and implemented on Production and currently working as post production support.

Environment: QlikView 11.2 SR3, QMC, Oracle 11g, SQL server 2008, 2010, 2012, Nprinting, Flat files, Excel files, Windows

Confidential, Raleigh, NC

Business Intelligence Analyst / QlikView Developer

Responsibilities:

• Involved in requirements gathering sessions with business users to prepare functional requirements
• Worked on the documentation for application development.
• Installed and configured QlikviewServer Small Business Edition.
• Generated ODBC Connections to extract from data bases and store them in QVDs.
• Extracted data from multiple data sources (SQL Server, Excel) and designed data model.
• Implemented Star Schema and Snow Flake schema in designing the data model.
• Used Link Tables to avoid circular reference and Loop issues.
• Developed Dashboards using different QlikviewObjects Line Chart, Bar Chart, Gauge Chart, Pie Chart, List box, Multi box, Table Box, Container etc.
• Worked with Alternate States to distinguish the selections for different charts with in a sheet.
• Implemented Security involved in Deployment of Qlikview Applications.
• Extensively implemented advanced SET Analysis for aggregation calculations.
• Automated and Scheduled data loads and Dashboard Applications weekly and Notifications by email to assigned users using Server.
• Modified Existing Login page to Access point to Client Specific Login Page.
• Responsible for the performance and tuning of the application, including performing maintenance upgrades on applications programs and systems as required.
• Converted Excel and crystal reports to Qlikviewdashboards.
• Experience in reporting activities which involved Business score card, sales and operations report.
• Coordinated with Business users in development process to integrate with the Test and Production Servers and helped creating use cases.
• Involved in User Training Sessions and Preparing Documentation.
• Involved in Production Support for Qlikviewapplications Server

Environment: QlikView 10, QMC, Oracle 11g, SQL server 2008, 2010, Access, Flat files, Windows

Confidential, Dodgeville, WI

Business Intelligence Analyst / QlikView Developer

Responsibilities:

• Interviewed users to identify problems, reporting requirements and problems in existing systems design.
• Collaborated with Business Intelligence team to learn current processes and practices
• Identified the Sales metrics for various businesses by interacting with users and analyzing Business Objects Reports.
• Generated new QVD files from the EDW by writing scripts in Qlikview applications
• Applied metrics in the data via QlikView scripts and transformed QVDs to cater the business needs.
• Designed and Developed QlikView dashboards meeting the business requirements.
• Published Client application using Qlikview Publisher and rolled out to Access point and implemented section access to handle user security
• Scheduled and managed QlikView jobs using Qlikview Scheduler for Qlikview application dashboards.
• Monitor computer systems to minimize unscheduled downtimes and ensured availability of resources.
• Assisted the users during UAT and incorporated the changes mentioned by the users.

Environment: QlikView 9, Oracle 9i,10g, Teradata, Flat files, MS Excel, MS Access, Windows

Confidential, Mountain View, CA

Oracle DBA

Responsibilities:

• Implemented Oracle Fail-Safe/Active-Passive setup for different clients.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Optimized tuning of user sessions and system level performance using SQL TRACE and gathered statistics using DBMS STAT
• Performance tuning of database regularly, worked on developers request of general SQL-TUNING, Database tuning used Explain Plan, SQL*Trace and Statspack.
• Responsible for handling Red Hat Linux servers and setting up the security in database.
• Automated the monitoring of databases regularly using shell-scripts, HTML, Cron-jobs.
• Configuring of kernel-parameters of the environments according to the end-requirements.
• Oracle Database Administration experience on different flavours of UNIX.
• Performed Installation, Configuration, Upgrades, Migrations, Administration of Oracle Databases.
• Worked on logical backups, Hot/Cold Backup and Recovery and Cloning of databases.
• Performed database Performance Tuning and Network Trouble Shooting using TNS configuration, Listener settings, Sqlnet settings.
• Worked in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Worked on various tools like SQL*LOADER, OEM, RMAN, Export/Import, Materialized Views, Replication.
• Oracle datawarehouse support third part client’s datawarehouses.
• Cloning production data into Dev, QA, Stage, Test, Training datawarehouses.
• Using Informatica Power Centre to configure data transfer, Folders, Session, Tasks, Attributes, Mapping and transformation developer (Update Strategy, Filter, Aggregator, Lookup, Rank, Joiner and Custom Transformation)
• Using Informatica Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Supporting and Monitoring data loading, Creating /Analyzing /Scheduling reports, User management, performance tuning using Datawarehouse Administrative Control (DAC).
• Database start-up and shutdown, alter database parameters, tablespace management, space monitoring and analyses, alter and move data files, table reorganization, index rebuild, export and import, manage database statistics, manage flashback database .
• Writing scripts for the system and database for the effective functionality and report generation, Automation of Start-up Shutdown on all Production and Development Database, Scripts for Start-up and Shutdown, Health Check of Databases, Analyzing of Tables, Cold Backups.

Environment: s: OEM, RMAN, Export/Import, ASM Packages, SQL, PL/SQL, SQL*Loader, TOAD, Data Guard, STATSPACK

Confidential

Database Administrator

Responsibilities:

• Implemented installations and configured Oracle 9i, 10g and 11g databases.
• Creating Databases,cloning Databases and refresh Databases using Exp&imp.
• Space management Confidential table space level (increasing table space sizes and syncing, resizing data files whenever it comes maximum values).
• Scheduling various jobs using crontab. Maintaining cron jobs and monitoring jobs.
• Applying RDBMS Patches and Cloning .
• Regular checking alert log and trace files for errors.
• Transported the tablespace from Production database and plugged-in it in Development Database for the usage of Developers.
• Using Flash Recovery Area to store RMAN backup files, backup auto control files, flashback database etc.
• Created and enhanced DB utilities needed for automation of system and unit tests and investigation of production issues, troubleshooting.
• Troubleshoot problems with Listeners.
• Closely monitoring backups (Rman Hot and Exp) and planning cronjobs accordingly.
• Implement and maintain Database Security (maintain users, roles, assign privileges, profiles).
• Space management Confidential OS level for backups and archive destinations

Environment: s: Oracle 9i, 10g, PL/SQL, SQL*Plus, SQL*Loader, Toad, UNIX, RMAN, ASM