SUMMARY

• Around 7+ years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing /Decision support systems and Business Intelligence.
• Senior QlikView BI with comprehensive experience in planning, designing and building BI Dashboard and Analytics Reporting solutions, utilizing BI tools (QlikView, BO, SSIS/SSRS), Databases (Oracle, DB2, Microsoft SQL,IBM Netezza), data analytics and dashboard visualization skills, supporting evidence - based business decision making.
• More than 7 years of BI dashboard and Visualization experience.
• Strong Skills in QlikView 11, 10, 9.0, 8.5/8.0 in designing and creating dashboards and reports with various graphs and analysis
• QlikView Expert in full development Lifecycle reloads automation and management.
• QlikView scripting language, Macro, VBScript, JavaScript, AJAX, PDF reporting, QlikView Enterprise Server and Publisher, QlikView Developer, Section Access and Security/Entitlement model, QlikView scripting language, Macro, VBScript, JavaScript, AJAX, PDF reporting, QlikView Enterprise Server and Publisher, QlikView Developer, Section Access and Security/Entitlement model.
• Experience in database design & development, database programming, data modeling, business process analysis, and application development.
• Comprehensive noledge and exposure to different phases of Software Development Life Cycle (SDLC). Experience in Planning, Analysis, Design, Implementation and Maintenance using QlikView.
• Good expertise with teh development and design of QlikView applications.
• Experience in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• In-depth noledge of industry best practices in both business management and technology domains.
• Experience in working with Data Warehousing and business intelligence tools for developing various reports using QlikView.
• Expertise in Installing and Configuring QlikView Desktop, QlikView Server and QlikView Publisher.
• Proven expertise in analyzing teh Business Intelligence needs of teh enterprise and building teh enterprise Reporting architecture.
• Developed Business Logic such as Dimension Formula, Script Logic, and Business Rules
• Worked in close association with customers for requirement gathering and effective analysis.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Experience in designing and creating database objects such as Tables, Views, Indexes, stored procedures, functions, triggers in SQL Server based on logical design model and user requirements.
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in performance tuning, logging, error-handling of SSIS packages and deploying from development server to production server.
• Experience in report generation using SQL server reporting services(SSRS) from relational databases as well as OLAP cubes.
• Responsible for configuring teh business rules and developing script logic for Consolidation
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Provided Training Sessions on QlikView capabilities to potential clients
• Involved in Performance Tuning & Deployment of QlikView Applications
• Part of QlikView COE (Centre Of Excellence)
• Involved in Prototyping teh reports in QlikView
• A team player with good interpersonal skills and work independently.
• Expertise in problem-solving and trouble-shooting capabilities, creation and implementation of KPIs, deliveries as per SLAs. Possessing in-depth understanding of teh business needs on multiple domains, logical problem solving approaches, good communication and motivation skills.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flow.

TECHNICAL SKILLS

Business Intelligence Tools: QlikView 11.0 /10.0/9.0/8.5 , SAP Business Objects 4.0, Crystal Reports

Languages: SQL, PL/SQL, C, C++Databases MS Access 2000, DB2, MS SQL Server 2005, 2012 and Oracle, Excel,SAP BW.CSV Files

ETL Tools: Informatica Power Center,Cognos, Sql Server Integration Services (SSIS), SSRS

Operating systems: Windows 2003, Windows xp, 7/8, Ubuntu, UNIX

Domains: Financial, Banking, Healthcare, Services

PROFESSIONAL EXPERIENCE

Confidential, McKinney, TX

Sr. Qlikview Developer

Responsibilities:

• Involved in Requirement gathering & designing QlikView applications.
• Worked with teh team to identify teh business reporting needs and studied current reporting practices outside of QlikView through pivot tables.
• Performed redesign of QlikView BI platform to improve availability, scalability and performance to accommodate high volume of data with 60+ dashboards
• Participated on business requirement document preparation.
• Rebuild dashboard applications on both frontend UI and backend, developing scripting templates, UI design and coding standards, design guidelines, migration strategy and implementation plan.
• Developed different dashboard with a complex database system behind it, which includes extracting data from teh database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• 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.
• Maintained and administered source documents, source documents sets, and user profiles and executed resource management services like Access point resources, distribution folders and email servers. Monitor user access to manage teh limited number of licenses.
• Optimizing existing data models including document 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.
• Enhance existing dashboards with new functionalities and Tune ETL scripts for better performance.
• Participated in Scrum stand up meetings.
• Created SQL Stored Procedures and Views to fetch teh data from database to build reports.
• Designed and created teh dashboard reports for Executive board of company.
• Developed scripts for data reloading, mapping and transformation
• Conducted UI visualization improvement on Usability and User Experience (UX)
• Designed teh integration of Enterprise Management Reporting Portal to provide single point of entry, developing Drill-to-Detail (D2D) for deep linking and cross-system Interoperability
• Modified existing reports using QlikView.
• Maintained and updated teh dashboard reports as required by client.
• Analyzed teh external and regulatory reporting, intercompany and internal management reporting needs of teh business process.
• Installed, configured and deployed QlikView application on top of Oracle DB.
• Conducted and guided QlikView BI application global roll out, managed QA Testing, User Acceptance Testing, software update, migration deployment and parallel run, stabilizing teh server platform and application to achieve teh steady state for transitioning.
• Developed hierarchical business model for company codes, account numbers, line of business, treaty/plan, customers and adjustment periods.
• Designed dashboards identifying teh KPIs and to support teh time comparison between budgets and actual.
• Designed Executive Sales Analysis Dashboard that offers fast and flexible access to all key information across teh enterprise.
• Implemented security using QlikView section access technology that dynamically hides selected areas of teh dashboard depending upon user privileges.
• Maintained user guides and documentation for QlikView applications.

Environment: Qlikview10/11,Oracle, SQL Server, Tera Data, SAP, Excel, CSV files, Enterprise Management Reporting Portal, DB2, Cognos, QlikView Enterprise Server, JavaScript, Java, ASP.NET.

Confidential, St Louis, MO

Qlikview Developer

Responsibilities:

• Understanding user requirements and expectations. Providing end to end reporting solution.
• Suggested better way of presenting charts, which are accepted and successfully implemented in teh dashboards.
• Assigned to create dashboards by extracting data from multiple databases, storing into QVD files, write load scripts, and develop UI according to user requirements.
• 3 Executive Dashboards depicting Sales, Forecast and Inventory data were created during teh stint. Dealt with a data volumes ranging from 20 to 50 million records.
• Designed dashboards using teh various sheet objects Current selection, list boxes, search, Straight table, Pivot table, Bar chart, Combo chart and so on.
• 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.
• Used QlikView Functions (Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous etc.) and Created Variables using LET, SET or control statements in teh scripts.
• Document event trigger, document chaining and field event triggers is created. Incremental reloading is implemented.
• Analyzed teh database and provided detailed information on their operational and Forecast for future years.
• Performance tuning of dashboards was carried out to limit teh response time.
• Successfully passed through teh QA Environment and implemented on Production and post production support.

Environment: Qlikview 10/11, Oracle,SAP BW, SQL Server, Tera Data, SAP, Excel, CSV files, Enterprise Management Reporting Portal, DB2, QlikView Enterprise Server, QlikView Server and Publisher.

Confidential, Fremont, CA

Qlikview Developer

Responsibilities:

• Worked with Business Analyst and teh Business user to identify teh user requirements, business reporting needs, layout, and developed teh architecture of prioritized reports.
• Performed planning, design, and development of QlikView BI dashboards and data integration in a highly complex global services environment, interfacing QlikView, SAP BO, KDE, Java, JavaScript, Smart GWT, ETL (Informatica and Talend) and EDW (Netezza and Oracle)
• Actively participated in teh design, architecture and development of user interface objects in QlikView applications.
• Developed business rules and script logic.
• Created Dashboard reports to track all teh way through ship to final acceptance phases.
• Developed executive dashboards in QlikView delivered through teh web, enabling to measure teh performance of teh business with analytical capabilities.
• Installed, configured and deployed teh application on QlikView 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 teh integration with teh Portal platform
• Created different complex sheets and sheet objects based on client requirements.
• Created List boxes, Statistic boxes to show teh statistics of teh sales held on different products in different years.
• Showed teh statistics in bar charts and pie charts as per teh client needs.
• Conducted and managed teh design and development of high volume, high performance QlikView in-memory solution to support over 1 billion daily transaction volumes
• 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 teh input given.
• Designed and developed scripts to support UI visualization, ETL processes, automation, workflow and 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 advanced scripting, set analysis, VBScript and, 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
• Involved in performance tuning of dashboards to limit teh response time and enhance teh functionality.
• Enhanced and translated existing dashboards in SSRS into QlikView and worked extensively with teh set analysis.
• Successfully passed through teh QA Environment and implemented on Production and currently working as post production support.

Environment: Qlikview 8.0, Oracle, SQL Server, Informatica, Toad /SQL Developer, SQL Loader and Sun Solaris, IBM Netezza DW appliances,QlikView Server and Publisher, QlikView Developer, Java, JavaScript.

Confidential, North Carolina

QlikView Developer

Responsibilities:

• Work directly with business users to define and prototype Qlikview Applications.
• Work with senior management to plan, define and clarify dashboard goals, objectives and requirement.
• Gathered, Analyzed, and transformed business requirements of teh Client into logical and physical BI solutions.
• Provided technical leadership in QlikView BI/DW design, dashboard and KPI metrics design, data modeling, QlikView SAP integration, QlikView scripts development, QlikView Set Analysis, and QlikView Server/Publisher setup/configuration.
• Participated in project planning, documentation, budgeting, and requirement analysis.
• Applied Scrum methodology in teh system development process.
• Worked with cross functional team and business user to develop Business requirement document (BRD), define key performance indicators (KPIs) and identify data sources.
• Conducted requirements gathering and developed strategy maps and roadmaps for delivering Data Analytics and BI Reporting via QlikView in-memory technology
• Designed and developed QlikView software applications and server-based QlikView dashboards from scratch to support BI initiatives.
• Hands-on experience in setting up new task and troubleshooting existing task setup and other issues.
• Designed and developed BI Reporting solution enabling users to effectively utilize teh tools to create Analytical Reports, Dashboards, and Scorecards, halping clients align KPIs performance metrics to strategic drivers and priorities.
• Identified data sources and targets for data modeling and solution architecture.
• Implemented new production methodologies that resulted in optimizing employee's time to finish teh tasks, thus enhancing employee efficiency.
• Created automatic schedulers to reload teh data as per requirements.
• Developed predictive analytics and forecast models to halp clients gain deeper insights on existing data and information, improve business performance, and shape teh future of teh companies.
• Worked closely with teh development team to understand functionality, resolve issues and provided feedback for teh UML diagrams.
• Extracted data from multiple complex hierarchies from cross table flat files and websites.
• Provided ongoing QlikView consultation to teh development team.

Environment: QlikView 7.0/8.0, OBIEE, Informatica, Oracle, Windows NT & Sun Solaris, QlikView Server and Publisher, QlikView Developer, Real-Time BI Analysis, Microsoft SQL Server, SSIS, SSRS, Oracle Database, SAP Business Objects, Crystal Reports, Informatica, Cognos.

Confidential

SSIS, SSRS Developer

Responsibilities:

• Actively involved in creation of database, modified tables, triggers, and store procedures to clean and validate teh data about teh cable layout, so as to meet teh company specifications.
• Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain teh consistency and data integrity.
• Exposed to data conversion from different data sources to SQL Server 2005 using SSIS.
• Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server 2005.
• Experience in developing and monitoring SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) Packages.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application
• Converting SQL Server 2005 DTS packages to SQL Server 2005 SSIS packages.
• Worked with DTS Packages on SQL Server 2005 and SSIS packages on SQL Server 2008 for teh automation of day to day Maintenance Jobs
• Expertise in Extract, Transform and Load (ETL) using SSIS and various tools including Bulk insert, BCP, Import Export data, DTS packages and SQL Server Integration Analyzed, designed and developed for a Data Warehousing and Data Migrations.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server.
• Developed complex Stored Procedures and Views to generate various Drill-through reports, parameterized reports and linked reports using SSRS
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2005.

Environment: MS SQL Server 2005/2000, SQL Server Integration Services (SSIS), SQL Server Reporting, Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Oracle 9i, VBScript.

Confidential

SQL Server Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
• Validated change requests and made appropriate recommendations. Standardized teh implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Managed user access and Created new security accounts.
• Performed Backup and restore of databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created teh DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at teh server.
• Updated teh statistics information for both teh old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS.