SUMMARY

• Over 10 years’ experience in Information Technology with proven ability to implement Business Intelligence solutions aligned with business objectives and innovative analytical reporting. Capable of managing numerous projects while leading cross - functional teams and competent in all aspect of QlikView and Business Objects.
• Implemented Enterprise Business Intelligence Systems for diverse group of clientele such as HealthCare, Automotive, Financial, Telecom, Government, and Manufacturing.
• Full life cycle implementation of Business Intelligence projects using QlikView, Business Objects (Universe, WebI
• Strong experience in designing and developing dashboards using QlikView by extracting data from multiple sources (Oracle, Flat files, Excel, Access).
• Extensive experience with QlikView sheet objects, scripting, and optimizing applications and building qvd’s and qvw’s.
• Hands on Experience with QlikView Architecture in development and deployment.
• Expertise knowledge in Set Analysis, Advanced aggregations, synthetic keys and circular references
• Hands on experience on implementing QlikView hierarchies using QVD approach
• Experience in setting up server, publisher configurations and security/ authorization at different levels.
• Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, Automation and Macros interface, Section Access, Set Analysis in QlikView and DW concepts.
• Strong knowledge and extensive experience in developing business intelligence solutions utilizing SAP Business Warehouse, Business Objects, SAP Mobile BI and Enterprise Data warehouse (relational and OLAP).
• Good knowledge in Data Modeling Schemas, Packages, Attribute Views, Analytic Views, Calculation Views and Analytic Privileges in HANA Studio.
• Good Knowledge in BOBJ Reporting (Universe, WebI, Explorer, and Dashboard) consuming data from SAP HANA.
• Good knowledge in different ETL tools like BO Data Services, BO Data Integrator, Informatica and SSIS.
• Experience in operational reporting using SAP Crystal Reports for Enterprise (CR4E/2011/2008/XI).
• Experience in interactive reporting using Web Intelligence Rich Client (WebI).
• Expertise in Business Analytics/KPIs using BOBJ Xcelsius 2008 and Dashboard Designer.
• Experience in SAP BEX Designer, SAP BEX Analyzer, OLAP Advanced Analysis
• Experience in Business Intelligence Software Installation, Configuration, Upgrades and Migration.
• Experience in creating Cardinalities, Contexts, Joins, Prompts, LOVs, Cascading prompts, Aliases for resolving Loops, chasm Traps and Integrity check of the Universes.
• Proficient working with very large Datasets, Optimization and Performance tuning of new and existing universes and reports catering to huge databases.
• Strong understanding of Data Warehouse concepts such as Star Schema, Snowflake Schema, OLTP, OLAP, Data Marts/Models, Master Data Model, Meta Topic and Multi-Dimensional Models for query and analysis.
• Excellent Technical, Interpersonal and solid communication skills with the ability to interact with end-users and managers and Experience in requirement gathering and Training End-users.
• An enthusiastic, project-oriented team player with leadership skills and with an ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

BI Analytic / Reporting Tools: QlikView 11.2 SR9/10.X/9.X, Business Objects and Tableau

SAP BI/BOBJ Tools: Business Objects XI 4.1/ 4.0 / 3.1/ R2/6.5, Information Designer Tool, BI Launch Pad, Analysis for OLAP, Universe Designer, Web Intelligence, DeskI, XCelsius2008, Dashboard Designer, Central Management Console (CMC), CCM, InfoView, Scheduler, BEX, BICS, QAAWS, Live Office, Query Browser, Crystal Reports 2008/2011, Import/Export Wizard and Life Cycle Manager (LCM).

ETL/Data Provisioning Tools: Informatica Power Center, Business Objects Data Integrator, Business Objects Data Services (BODS), and HANA Studio

Databases: Oracle8i/9i/10g/11g, SQLServer 2000/2005/2008 , MS Access 2007/2010, MySQL, SAP BW

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Senior BI/QlikView/Solution Designer

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.
• Developed and Designed interactive Tableau Dashboard reports.
• Designed Dashboards with Drill Down and Drop down menu option and Parameterized using Tableau.
• Installed Tableau Desktop and Tableau Server on distributed environments.
• Created User groups; Users and subscriptions based on business requirement.
• Published Tableau data sources and workbooks to the Tableau Server.
• Designed Dashboards using calculations, parameters in Tableau
• Objective of the Project is to create detailed documentation of the existing QlikView code with respect to transformations, QVDs, expression, data sources
• 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
• Gained understanding of the QlikView scripts - Load statements, Joins, Concatenate, variables, QVDs used and so on. Created detailed documentation of the multiple layer QVD structure that gave understanding to the team on how the data is flowing in QlikView dashboards
• Created a brief document on how the QlikView statements, functions work so that even a novice user/developer can gain understanding of the QlikView scripts.
• Fine-tuned Qlikview jobs for faster and better loading of data
• Worked on extensively to cluster QlikView Server environment
• Worked on QEMC configuration on Qlikview server

Environment: QlikView 11.x, QlikView Server/Publisher, Tableau8.3, SQL Server, MS EXCEL

Confidential . SFO, CA

Senior BI/QlikView Solution Designer

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.
• Objective of the Project is to create detailed documentation of the existing QlikView code with respect to transformations, QVDs, expression, data sources
• 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
• Gained understanding of the QlikView scripts - Load statements, Joins, Concatenate, variables, QVDs used and so on. Created detailed documentation of the multiple layer QVD structure that gave understanding to the team on how the data is flowing in QlikView dashboards
• Created a brief document on how the QlikView statements, functions work so that even a novice user/developer can gain understanding of the QlikView scripts.
• Fine-tuned Qlikview jobs for faster and better loading of data
• Worked on extensively to cluster QlikView Server environment
• Worked on QEMC configuration on Qlikview server

Environment: QlikView 11.x, QlikView Server/Publisher, SQL Server, MS EXCEL

Confidential, SFO, CA

Senior BI/Qlikview Solution Designer

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.
• Objective of the Project is to create detailed documentation of the existing QlikView code with respect to transformations, QVDs, expression, data sources and so on.
• Analyzed dashboards in the presentation layer, gather understanding of the data model using table viewer and system fields.
• 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
• Gained understanding of the QlikView scripts - Load statements, Joins, Concatenate, variables, QVDs used and so on. Created detailed documentation of the multiple layer QVD structure that gave understanding to the team on how the data is flowing in QlikView dashboards
• Created a brief document on how the QlikView statements, functions work so that even a novice user/developer can gain understanding of the QlikView scripts.
• Developed and Designed interactive Tableau Dashboard reports.
• Designed Dashboards with Drill Down and Drop down menu option and Parameterized using Tableau.
• Installed Tableau Desktop and Tableau Server on distributed environments.
• Created User groups; Users and subscriptions based on business requirement.
• Published Tableau data sources and workbooks to the Tableau Server.
• Designed Dashboards using calculations, parameters in Tableau
• Creating Dashboards using Dashboard designer 4.0.
• Creating reports using web intelligence and crystal enterprise 4.0
• Using Universe Query and BI Web services Method to populate the data in to Dashboard.
• Working with OALP for Analysis.
• Creating Business Objects Universes with Information Design tool.
• Created summary and detail reports as sections using Business objects Web Intelligence.
• Created summary and detail reports with opendoc using Business objects Web Intelligence.
• Created Input Controls in Web Intelligence for users to filter the data.
• Used different functionalities of WEBI like Breaks, Sorts, Filters, and Sections and drill down in creating complex reports.
• Worked on different types of joins and resolving join problems such as Loops, Chasm trap and Fan trap.
• Mentoring new developers on QlikView best practices and dashboard development.

Environment: QlikView 11.x, QlikView Server/Publisher, Tableau8, Business Objects 4.0/4.1, Dashboard Designer, SQL Server, Oracle 11g

Confidential, Marysville, OH

Senior Business Intelligence Solution Designer

Responsibilities:

• Involved in Business requirement gathering and Participated in Joint Application Development (JAD) process with different Business Segments in designing QlikView Applications.
• Involved in exploring solutions for data inconsistency.
• Developed a metadata monitoring tool using the QVD files generated to provide stats on daily loads
• Developed SQL Scripts, database objects, procedures, functions and packages.
• Worked on data modeling and developed different complex models as per given user requirement by eliminating closed loops, Synthetic tables and ambiguous relationships.
• Installed, configured and deployed the application on QlikView server and Imported data from different sources like SAP BW, Sales force, Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Worked with Microstrategy 9 for data migration to QlikView.
• Mainly designed and developed QlikView software applications and complex server-based QlikView dashboards from scratch to support reporting and Business Intelligence initiatives.
• Used advanced scripting, VBScript macros, advanced aggregation functions and advanced charts for applications.

Environment: QlikView 10X, QlikVIew Server/Publisher, Oracle 10g, MS Access, Toad, Tortoise SVN

Confidential, Reston, VA

Business Intelligence& QlikView Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data Specifications about the financial system for.
• Designed, developed and managed Universes in Business Objects Designer for generating the pay roll
• Developed Drill thrus Dashboard reports which enabled users to drill between Summary Qlikview to detail Webi reports, templates and personalization.
• Created custom reports like Shortterm bonds, Longterm bonds, Gross Margin, Dealer Auctions, Income Statement, Bad Debt and Payment Reports in response to user needs.
• Creation of reports using reports and charts as per the customer requirement depends on Quarter, monthly And analyzes the report with charts provided by Qlikview.
• Created User Conditions and Filters to improve report generation & readability.
• Handling user security using section access
• Created User Conditions and Filters to improve report generation & readability and Sql tuning of report and displayed the summary of data by creating Charts by using Qlikview.
• Created Dashboard Reports using Qlikview for Securities Data mart and using Security DM Universe as data Provider.

Environment: QlikView 9/QEMC, Oracle 10g, SQL*Plus, SQL Developer, .CSV files, MS Excel

Confidential, Atlanta, GA

Senior Business Intelligence Solution Designer

Responsibilities:

• Worked as a Senior Business Objects Solution Designer for Equipment Dashboard, Segmentation reporting and Asset Utilization Reporting Projects.
• Creating Dashboards using xcelsius 2008.
• Creating reports using web intelligence and crystal reports
• Using QAAWS and Live Office Method to populate the data in to Dashboard.
• Created Universe using Info cubes, Bex queries and Multiproviders as data source.
• Creating Business Objects Universes against Bex Queries using universe Designer
• Created Dashboards in Dashboard Designer using Universe Query and BICS Connection
• Creating Business Objects Universes with Universe Design tool.
• Used different functionalities of WEBI like Breaks, Sorts, Filters, and Sections and drill down in creating complex reports.
• Worked on different types of joins and resolving join problems such as Loops, Chasm trap and Fan trap.
• Involved in requirement Gathering Sessions with the Business Users.

Environment: Business Objects XIR3, Xcelsius 2008, Teradata12, SQL Server2008, SAP BW 7.0

Confidential,New York, NY/ Collegeville, PA

Team Lead/Senior Business Intelligence Solution Designer

Responsibilities:

• Worked as a team lead for the Speaker Operations Project and communicating with the offshore team members.
• Involved in requirement gathering working sessions with the users
• Designed Report Design Documents and Universe Design Documents According to the Confidential Standards.
• Involved in validating the Requirement Tractability matrix Document with Business Analyst
• Designed Universes for Speaker operations reporting system.
• Created Classes and Objects for Speaker Operations Universe and Reports like Program Activity reports, Program AttendancesReports, Compliance Reports and BU certification Reports and ad-hoc reports.
• Created summary and detail reports as sections using Business objects Web Intelligence.
• Created summary and detail reports with opendoc using Business objects Web Intelligence.
• Created Input Controls in Web Intelligence for users to filter the data.
• Used different functionalities of WEBI like Breaks, Sorts, Filters, and Sections and drill down in creating complex reports.
• Worked on different types of joins and resolving join problems such as Loops, Chasm trap and Fan trap.

Environment: Business Objects XIR3, Web Intelligence, Xcelsius 2008, Oracle 11g/10g

Confidential, Sacramento, CA

Senior Business Intelligence Solution Designer

Responsibilities:

• Generated Reports for Penalties and Interest data using Crystal Reports 2008.
• Created a substantiation report for penalties and Interest using crystal reports 2008.
• Developed functional design specifications for Report development objects.
• Developed functional design specifications for VDF (voluntary Deduction File) and F496 File Layouts.
• Meeting with functional people and gathered requirements and developed FDS for Report development objects.
• Created functions and various parameters according to the requirement using crystal reports 2008.
• Created Table Structures in SAP ECC for Penalties and Interest Data.
• Created sub reports and pass through parameters from main report to the sub reports.
• Created Cascading dynamic parameters using crystal reports 2008.
• Using the functionalities like grouping and sorting according to the requirements using crystal reports 2008.
• Was responsible to develop customize reports requested by Clients.
• Worked on performance tuning of queries for faster execution of reports.

Environment: Business Objects XIR3, Web Intelligence, Crystal Reports 2008, SAP ECC 6.0, SAP PSCD

Confidential

Business Objects Developer

Responsibilities:

• Interacting with Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing Universes and Business Object Reports.
• Developed Universes using Designer and Business Objects for the reporting solution for Operational reporting System.
• Potential usage of alias, context, and shortcut join concepts to overcome the loops.
• Created Detail and Summary reports for Total text Messages send, Roaming charges, Direct Connect per second, for the frequency Monthly, Daily, and Weekly.
• Created reports that limit the reports to display information for particular measures by designing Complex Filters.
• Created Reports like, Reports by Product, Reports by Time (Year, Quarter, and Month Date).
• Created Complex Reports like Master Detail and Cross Tab.
• Developed Ad hoc reports using Business Objects.
• Formatted Reports as per the User requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
• Involved in Importing/Exporting the Universes to repository to make available to the end user.
• Extensively used Calculations, Break points, Drill down, Slice and Dice, and Formulas,Filters&Alerts for creating Complex reports.
• Conducted and assisted user training sessions.
• Used the Broadcast Agent for Scheduling and monitoring the Reports.

Environment: Business Objects XI/6.5, Oracle 8, SQL, MS SQL Server 2000.

Confidential

Business Objects Developer

Responsibilities:

• Involved in report requirement gathering.
• Designed and maintained Universes and exported them to the repository.
• Created Classesand Objects (Measure, dimension and detail) in the universe.
• Used Designer Module to implement Universes, Joins between Tables, and createdpromptsand queries, parsing of Universes, and created Contexts and Alias Tables to remove cyclic dependencies.
• Developed ReportsUsing Master/Detail, cross tab, Charts.
• Created reports using standard company templates. A few of them were created based on the Department requirements.
• Extensive use of Business Objects functionalities in formatting reports.
• Created user Prompts, conditions and Filtersto improve the report generation. Also used Alerts to improve the readability of the report.
• Creating the reports in Web Intelligence.

Environment: Business Objects 6.5, Web Intelligence, Business objects Designer, Oracle, SQL.

Confidential

Trainee/Junior Developer

Responsibilities:

• Developed Reports for cash transaction
• Created Tables, Indexes, Views and Sequences.
• Developed Packages for sales of all the products.
• Developed various procedures and functions.
• Developed Tender Notice forms using Form Builder.
• Designed and developed different forms and reports.
• Involved in development of Tables, Stored Procedures and Functions for data manipulation and data processing.
• Involved in generation reports using Oracle Reports.