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), Databases (Oracle, DB2, Microsoft SQL), 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 in designing and creating dashboards and reports with various graphs and analysis.
• QlikView Expert in full development Lifecycle reloads automation and management.
• Experience in database design & development, database programming, data modeling, business process analysis, and application development.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC). Experience in Planning, Analysis, Design, Implementation and Maintenance using QlikView.
• Good expertise with the development and design of QlikView applications.
• Experience in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• In-depth knowledge 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 the Business Intelligence needs of the enterprise and building the 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.
• 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.

TECHNICAL SKILLS:

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

Languages: SQL, PL/SQL, C.

Databases: MS Access 2000, DB2, MS SQL Server 2005, 2012 and Oracle, Excel, SAP BW.CSV Files

ETL Tools: Informatica Power Center, SSIS.

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

PROFESSIONAL EXPERIENCE:

Confidential, SFO, CA

QlikView Developer

Responsibilities:

• Involved in Requirement gathering & designing QlikView applications.
• Worked with the team to identify the 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.
• 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 the 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 the 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 the 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 the front-end, improving layout structure.
• Enhance existing dashboards with new functionalities and Tune ETL scripts for better performance.
• Created SQL Stored Procedures and Views to fetch the data from database to build reports.
• Designed and created the dashboard reports for Executive board of company.
• Developed scripts for data reloading, mapping and transformation
• Designed the 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 the dashboard reports as required by client.
• Analyzed the external and regulatory reporting, intercompany and internal management reporting needs of the 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 the server platform and application to achieve the 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 the KPIs and to support the time comparison between budgets and actual.

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

Confidential, Warren, NJ

QlikView Developer

Responsibilities:

• Extensively worked to confirm and clarify requirements and business logic.
• Analyzed the reporting requirements with the business users and came up with the technical specifications.
• Strong understanding in creating Dashboards, score boards for the required KPI’s in QlikView.
• Developed load scripts to work with multiple data sources (SQL, Excel, and MS Access).
• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Designed an applications for to support the lending process and dashboard style of layouts using different components of QlikView Enterprise like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher
• Designed, developed, implemented and tuned multiple QlikView applications for the Sales, IT,

Environment:Windows 2000 Server, Oracle 10g, MS Access 2005, MS SQL Server 2005,QlikView9.0/10.3, MS Office

Confidential, Milwaukee, WI

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 QlikView BI dashboards and data integration in a highly complex global services environment.
• Actively participated in the design, architecture and development of user interface objects in QlikView applications.
• Developed business rules and script logic.
• Created Dashboard reports to track all the way through ship to final acceptance phases.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Installed, configured and deployed the 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 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.
• Conducted and managed the 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 the input given.
• 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 the response time and enhance the functionality.
• Enhanced and translated existing dashboards in SSRS into QlikView and 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, Oracle, SQL Server, Informatica, Toad /SQL Developer, SQL Loader QlikView Server and Publisher, QlikView Developer.

Confidential

MicroStrategy Developer

Responsibilities:

• Involved in the meetings with the business users and collected the requirement documents.
• Based on the requirement documents CreatedSchema Objects(facts, attributes, Transformations, hierarchies) and application objects (filters, prompts, metrics, Custom Groups, Object Prompts, Reports).
• CreatedObject Prompts,Transformational metrics,Advancedfilters,Custom groupsand used them forcomplex reporting purposes.
• Created three types of reports that areDashboard Analysis Reports,Ad-hocReportsandEnterprise Reports.
• Having knowledge in customizing SQL Query by settingVLDB settingsat Different levels ofDatabase Instances,Report andMetrics.
• Involved in Maintenance and support for the project and end users.
• Extensively involved in Database Performance Tuning.

Environment: SQL Server 2000/2005/2008, MicroStrategy 8/9i