SUMMARY:

• Around Seven 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.
• Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance using Qlikview. Good at working with Data Warehousing and business intelligence tools for developing various reports using QlikView BI.
• 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.
• Interacted with Customers for requirement gathering and effective analysis.
• Developed interactive dashboards for mobile professionals while disconnected from network.
• Worked on BI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
• Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.
• Experienced in writing SQL scripts, SQL Loader, Performance & Tuning of Database.
• Strong knowledge in Oracle 11g/10g/9i/8i database programming using PL/SQL (Stored Procedures, Functions, Triggers, Cursors) and standard Built - in Oracle Packages.
• Experience in Oracle 10g/9i/8i/8.x, PL/SQL, SQL, TOAD, Stored Procedures, Functions, Triggers, SQL Server 7/2000.
• Experience in working with different operating systems like HP UNIX, Solaris, and Windows NT/2000.
• Created test plans, test objectives, test strategies and test cases in the QA testing phase.
• Extensively involved in Demos, Presentations, Meetings and Interaction with Senior Management
• Coordinated and acted as a liaison between the business groups and the IT department.
• Business Analysis experience with excellent communication & interpersonal skills and broad understanding of business operations and requirements.
• Self-motivated and enjoy working in a technically challenging environment. Have excellent Communication and interpersonal skills.
• 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:

BI Tools: QlikView BI, OBIEE, Business Objects.

Databases: MS SQL Server, MS Access, Oracle, DB2, Teradata and SAP BW.

Web Technologies: HTML, XML, ASP, Java Script, VB Script, Servlets, JSP

Data Modeling Tools: Erwin, Visio 2000

Operating Systems: Windows 95/98/2000/XP/NT, UNIX.

Languages: C, C++, Java, PL/SQL, SQL, Unix.

Other Tools: Informatica, ODI, SQL Loader, Toad, SQL Developer and Putty.

PROFESSIONAL EXPERIENCE:

Confidential, Long Island NY

Qlikview Developer

Responsibilities:

• Analyzed requirements, functional and technical specs from documentation of QlikView application requirements from end users.
• Worked on data modeling as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Reloaded and created ETL script using SAP Script Builder Application.
• Developed ‘Institutional Sales force’ Dashboards with a SAP CRM as data source; Extracting data from the data source, storing into QVD files, write load scripts, creating Qlikmarts and develop UI according to user requirements.
• Performed different tasks like extraction, reload tasks, reduction and distribution tasks based on Market drill-down using the Qlikview Publisher.
• Successfully completed the development cycle; migrated dashboards across Development, QA and Production servers.
• Provided support for Production environments.

Environment: Qlikview 11.0, SAP Script generator, SAP CRM, Sales Force Flat Files

Confidential, Herndon, VA

Qlikview Developer & Server Admin

Responsibilities:

• Working with the management to identify the business reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business.
• Analyze customer requirements and develop proposals of technical solutions as needed.
• Developed SQL Scripts, database objects, procedures, functions and packages.
• Designed the architecture of data model. Using the 3 tier methodology data extraction, aggregation, Creating Qlikmarts and usage was designed to yield faster and better performance from system.
• Configured and deployed the application on QlikView server and Imported data from different sources like Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.
• Setting access permissions and assigning CALs based on users.
• Schedule QVW reloads on server and troubleshoot errors and failures.
• Worked on data modeling and developed different complex models as per given user requirement without any closed loops, Synthetic tables and ambiguous relationships.
• Mainly designed and developed Qlikview software applications and complex server-based Qlikview dashboards from scratch to support reporting and Business Intelligence initiatives.
• Worked on dashboards related to Revenue Management, Sales, Daily Reports and Operations departments and implemented performance tuning that offers fast and flexible access to all key information across the enterprise.
• Testing dashboards and data validation.
• Used advanced scripting, set analysis and VBScript, advanced aggregation functions and advanced charts for applications.
• Designed QVWs to generate QVDs for faster and efficient data reloads.
• Trained Qlikview developers and users on best practices and general “how to” procedures.
• Designed a comprehensive and easy to use Rent Analysis and CostPerUnit dashboard for client to track the excess expenditure and income from each Client Companies
• Leads conversion dashboard analyzes the performance and efficiency of converting customer leads into reservations overtime period. Thereby helping to analyze the turndown factors and improve customer service.
• Implemented security using QlikView‘s section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Upgraded Qlikview Server and Publisher software.
• Provided ongoing QlikView consultation to the development team.

Environment: Qlikview 10.0, Oracle, SQL Server 2000, Toad 9.6.1/SQL Developer, SQL Loader

Confidential, Rockville, MD

Qlikview Developer

Responsibilities:

• Working with the user community and senior management to identify the business reporting need
• And developed proposals of reports needed.
• Installed, configured and deployed the application on QlikView server and Imported data from different
• Sources like SAP BW, Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• 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, set analysis, VBScript and JScript macros, advanced aggregation function
• And advanced charts for applications.
• Designed Executive Sales Analysis Dashboard that offers fast and flexible access to all key information
• Across the enterprise.
• Designed a Claims Management dashboard for client to keep track of Claims, verifying patient
• Eligibility, managing remittance.

Environment: Qlikview 9.0, Oracle, SQL Server, Informatica 8.6, Toad 9.6.1/SQL Developer, SQL Loader and Sun Solaris.

Confidential, Bonita Springs, FL

OBIEE Developer

Responsibilities:

• Performed the setting up, installation and configuration of the OBIEE and the required connectivity for seamless integration with the data warehouse.
• Analyze, Design, and Develop OBIEE/Siebel Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer (Semantic Layer), and Presentation Layer.
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports) by adding in extended columns.
• Customized the Sales Branding, Customer Service dashboard by adding in new products and Finish Sales Trend Dashboards.
• Developed HR intelligence Dashboards, used KPI’s which provides powerful metrics, Alerts and reports to HR professionals and line managers, enabling them to understand how workforce factors are affecting individual departments and take appropriate actions.
• Modified Pre-built OBI Applications dashboards, Answers, Repository for Sales, Finance, Inventory, Supply Chain, Expenses and Order Management Analytics.
• Created MUD (Multiple user Development) environment by utilizing projects.
• Implemented comprehensive security functionality by creating users & web groups, setting up LDAP (ADSI) authentication and associating catalog objects and Web modules with the created users and groups.
• Performance Tuning through aggregation strategy, caching schemes and usage tracking.
• Analyzed Reports and resolved Data Issues Related to Reports.
• Created Time Series Objects, Hierarchies, Level Based Measures.
• Developed many Ad-hoc and standard Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Implemented Security/Access privileges by creating roles & web groups, checks with External tables.
• Built the applications in order to track predefined KPI’S (Key Performance Indicators).
• Developed many incremental ETL using Informatica mappings & Oracle PL/SQL procedure.
• Integrated BI Publisher with Oracle BIEE and used to create highly formatted reports by using Oracle BI Answers and Oracle BI server Metadata.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.

Environment: OBIEE 10.1.3.4.1, Oracle Apps 11.5.3, Informatica 8.6, Oracle 10g, Windows NT & Sun Solaris

Confidential

Siebel Analytics Developer

Responsibilities:

• Performed GAP Analysis to gather functional mapping by coordinating with the Business Users to gather the data required for analysis.
• Extensively used Siebel Analytics Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Worked on warehouse tables to populate First Data Resource (FDR), Account, Credit Card, Proposal, Product, Opportunity, Time Dimensions & Fact and aggregated Facts.
• Presenting the information to Business user, by identifying appropriate source of data from FDR system.
• Developed Business models to represent business logic for ACS (Accounts and Consolidation Services), AOP (Accounts and Opportunity Planning), Estimator Analysis, Week-Week Analysis, Win Loss Analysis and Sales Analysis.
• Created dimension hierarchies for balanced and unbalanced hierarchies and assigned shared levels to respective hierarchy trees.
• Developed measure and dimension based aggregates to improve query performance.
• Created presentation catalogs with restricted access to various business users.
• Worked Extensively on Siebel Answers to create the reports as per the client requirements.
• Slice and Dice data using filters and used pivot/charts for better presentation.
• Configured Intelligence dashboards using links/images for conditional and exceptional reporting.
• Customized the appearance and texts of the various objects in the user Dashboards and answers.
• Edited the download options to restrict public access of data from Dashboards to users worldwide.
• Maintained iBots and default mail server for error reporting over the intranet framework.

Environment: Siebel Analytics 7.8.2, Oracle 9i, PL/SQL, SQL server, Windows 2000, UNIX