SUMMARY

• 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.
• 4+ Years of experience in Qlikview Development.
• Expert in Extracting, Transforming, Analyzing, Visualizing, and presenting data from diverse business areas in novel and insightful ways to enable Directors, Vice Presidents, and C - level executives to take informed action.
• Extensive experience in developing different analytical applications using QlikView suite of Products (QlikView Server, Publisher and QlikView Enterprise).
• Worked on BI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
• Expertise in Creating Dashboards using QlikView 11.2/11.0/10 using different data sources like Oracle, SQL Server, QVD files, text files, excel and generated dashboard as per the user requirement.
• Good experience in design, development and maintaining Dashboards and BI applications using Qlikview.
• Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.
• Experience in Database structuring, database application design & development, Entity Relationship Modeling (ERM), Data export/import, SQL programming & ETL procedures.
• Design of Qlikview applications using Qlikview Data (QVD) files generated by ETL logic.
• Experience in designing Qlikview Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Experience in implementing various levels of File/Document and Data level Security.
• Performed different types of loads Incremental Load, Optimized Load & Binary Load.
• Strong skills in providing custom functionality using Macros, Triggers, Set Analysis.
• Experience in Loading Data from Multiple data sources to develop the QlikView Data Models.
• Good working noledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Expertise in Designing Universes for Ad-hoc query, canned reporting and analysis using the Designer Module.
• Expertise in creating standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
• Experienced in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries, Sub Queries.
• Strong experience in Data Warehousing concepts - Star Schema, Snow Flake Schema and Data Modeling( Normalization/De normalization, ER Diagrams, Keys).
• Sound noledge in writing SQL Queries.
• Strong Database Development skills using SQL Server 2005, 2008 & Oracle 11g.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, Ability to adapt, learn new technologies and get proficient in them very quickly.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g, SQL Server 2005/2008, Teradata, MS Access, Excel, Flat Files, Salesforce (.d11 adaptor), SAP (OLAP, SQL Connectors)

BI Tools: QlikView 10 & 11, Business Objects Developer Suite 4.0/XI3.1/XI3.0/XIR2/6.x/5.x

ERP/CRM Tools: SAP, Data Warehousing

Web Technologies: HTML, XML, Java Scripting

Operating Systems: Win 98/2000/XP/Vista/7

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. QlikView Developer

Responsibilities:

• Managed company-wide system of QlikView BI solutions to ensure optimization of both data models and front-end UIs.
• Roles and responsibilities include developing, enhancing, re-engineering, maintaining and supporting QlikView applications
• Developed and designed comprehensive and innovative ad-hoc dashboard to provide manufacturer with broad visibility into its largest distributor, incorporating sales, forecast, target, and inventory metrics.
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks.
• Used QlikView Functions (Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous etc.) and Created Variables using LET, SET or control statements in the scripts
• Used QlikView Scripting and Complex SQL coding for loading, and transforming.
• Created Set Analysis for Comparison analysis eliminating additional complex coding.
• Designed and developed the incremental loads where applicable.
• Maintained both File and Data Level Security and implemented Data Reduction.
• Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques.
• Published Client application using QlikView Publisher and rolled out to Shared Drive with security permissions using Active Directory features.
• Experience with QlikView Enterprise Management Console.

Environment: QlikView 11.2, Oracle 11g, Access, Windows 2003 Server, SQL Programming.

Confidential, Austin, TX

QlikView Developer

Responsibilities:

• Meetings with end users to gather the functional requirements and customize Qlikview dashboards accordingly.
• Involved in understanding the business from different areas and gather requirements.
• Developed different dashboard with a complex database system which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Validation of Qlikview application at base level against QVD’s and Excel test files.
• Set Analysis in providing custom functionality to QlikView Applications.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input Fields).
• Created different publisher tasks like reload tasks, reduction tasks and distribution tasks using Qlikview Enterprise Management Console.
• Monitoring of the QVS (Access Point), QVW's and user accounts for the usage of the applications.
• Implemented section access which allows user to see by default their Region’s data and population attached to a particular Region.
• Implemented security layer and extensively involved in the deployment activities of the Qlikview Application.
• Automated QlikView jobs in QlikView Publisher and rolled out to QlikView Access Point and administered Security using Active Directory.
• Wrote SQL Scripts to load relevant data in QlikView Applications.

Environment: Qlikview 11.2 SR4, Excel, MS SQL Server 2005, Oracle 10g.

Confidential, Atlanta, GA

QlikView Developer

Responsibilities:

• Design & Development of QlikView Dashboards using QV scripting.
• Performing analytics as per the requirement using charts and tables.
• Developed KPI’s and Set Analysis applications.
• Developed User Interactive Sheets & Reports as business needs.
• Developed Dashboards pertaining to Sales using Qlikview 11.
• Involved in Performance Tuning of QlikView dashboard.
• Manage daily QlikView jobs that update QVD files and Dashboards.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle, and SAP BW) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView.
• Developed extensively Alerts, Variables, Input boxes and Calendars.
• Experienced connecting to SAP database with SAP connector and created QVD’s as per the requirement.
• Worked on Qlikview Server and Qlikview Publisher.
• Responsible for ETL and developing dimensional model using QlikView.

Environment: Qlikview 11, Excel, MS SQL Server, Windows Server 2000, Oracle 9.

Confidential, McKinney, TX

QlikView Developer

Responsibilities:

• Participated in user discussions to understand the user requirements, layout, and look and feel of the dashboards to be developed.
• Worked closely with users to understand data sources and requirements to build the best data model for QlikView applications.
• Defined KPI’s and related data points on various lines of business; creates detailed and summary reports for executive review.
• Developed Dashboards pertaining to Revenue and Sales monitoring using Qlikview 10.
• Developed Qlikview presentation layer for charts with drill-down capability.
• Created QVD generator load scripts.
• Created data model in QlikView desktop to get all the data in required format. Used Mapping tables, Apply Map, Resident Load, Concatenate, Variables and so on.
• Performed analysis, documentation, for calculation for various attributes.
• Produced graphs and visuals using Excel charts and pivot tables to summarize data, identify outlying data points, and perform other exploratory data analysis.
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Performance Tuning, Setup and Configuration related to Qlikview.

Environment: QlikView 10, .CSV Files, MS SQL Server 2005, Oracle 9i.

Confidential

Sr. Business Objects Developer

Responsibilities:

• Involved in interacting with Users to no their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Converted business requirements in business/technical requirement documents.
• Developed Webi, Deski, Crystal, Webi Rich Client and Xcelsius Dashboards.
• Created Xcelsius Dashboards for Sales and Product level data based on Product Age & Usage using various components of Xcelsius.
• Created complex reports in Deski, using multiple Data providers.
• Changed the infoview page layout by adding new features like the company details instead of the Business Objects logo by using the customization methods.
• Written SQL queries has been used on the Universe and created as Derived Tables.
• Wrote Complex SQL Queries for Data validation purpose.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Implemented Row Level, Object Level security for data restriction at Universe level.
• Involved in Tuning and server configurations for different environments.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Enhanced the Performance of the Dashboards by manipulating and using complex formulas on the Universe and Excel.

Environment: Business Objects XI R2, 3.1, Crystal Xcelsius, Oracle 10g, SQL Server 2000 & 2005, SSIS, TeradataWeb logic 10 and Windows 2003, SAP 4.7, ECC 6, Oracle 9i, Windows XP, Unix, Java.

Confidential

Business Objects Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Wrote detailed level documentation for reports and universe design.
• Generated ad-hoc reports by linking systems and interfaces.
• Managed the resources, WEBI users, connections, and the Universe repository.
• Created Objects and prepared Reports like financial reports, HR reports, standard and ad-hoc reports, and universes.
• Created multiple reports using various complex courses and linked these reports with Combined Queries, Slice and Master Detail.
• Created different reports containing charts showing revenue and operating income by different divisions, market share of newspaper by circulation.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Generated the SAP Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Used the Export option for the Reports to schedule them in Broadcast Agent Server and sent the scheduled reports via Email, Text and Excel formats.
• Used the Broadcast Agent Server to Schedule and Monitor the Reports.
• Involved in updating and maintaining existing Universes based on changes in user requirements and changes in data.

Environment: Business Objects 6.5.1/ XI r2, Crystal Reports XIR2, Designer, Desktop Intelligence, Web Intelligence, Oracle 9i, SQL, PL/SQL, Windows XP.