SUMMARY

• More than 7+ years of Experience as Business Intelligence Application Specialist for various clients.
• Broadly experienced inQlikview 8.5/ 9.0/10.0/11.20 with extensive expertise in helping users by developing innovative applications for the casual business user.
• Extensive experience in database design, E - R modeling, and data import/export, data manipulation, SQL Programming and Extra Transform Load (ETL) procedures.
• Worked on Data Mart and Data Warehouse and Implementation of Qlikview for BI (Business Intelligence) Reporting Solutions.
• Involved in ETL Tasks (data cleansing, Joins, Aggregation Tables) using QlikView.
• Created Dashboards and develop reports using various QlikView procedures and Objects.
• Developed Scripts to resolve Circular Relationships, Synthetic Keys & Modeling Issues within tables.
• Strong Skills in Providing Custom functionality using Macros, Triggers.
• Worked in all phases of Business Intelligence Life Cycleand Software Development Life Cycle.
• Experience in Incremental Loading & QlikView document Versioning.
• Well versed in SQL Scripts, PL/SQL Stored Procedures.
• Analyzed reporting requirements to usable long term dashboard and reporting solutions, develop solutions as necessary.
• Involvement in bettering existing QlikView dashboards with a focus on user friendliness, performance, long-term usability, flexibility, as well as standardization.
• Conducted validation of existing reporting, User Acceptance testing and new solutions to ensure continuous accuracy and front end ease-of-use.
• Administered QlikView 10 server and client environments including environment optimization and troubleshooting for Access Point, Publisher, server and client installations as needed
• Business Intelligence Experience with Cognos, Business Objects and Crystal Reports.
• Experienced in Data warehousing Concepts Star Schema, Snow Flake Schema, Data Modeling.
• UtilizedQlikviewPublisher for client application rollout toQlikviewAccess Pointand administeredsecurity using Active Directory technology
• Performed Installation & configuration Of QlikView Software.

TECHNICAL SKILLS

BI Tools: QlikView 8.5, QlikView Developer 9.0, QlikView Server 9.0 /10.0, QlikView 10.0, Qlikview Workbench Cognos 8.2, Crystal Reports

Languages: C++, Visual Basic, Power Builder 6.5, VB.NET, XML

RDBMS: MS-Access, SQL Server 2005, 2008, Oracle 10g, Teradata, SFDC, Bugzilla

Data Modeling Tools: Erwin

Web Servers: IIS, Apache

PROFESSIONAL EXPERIENCE

Confidential, San Mateo CA

Sr.Qlikview Consultant

Responsibilities:

• Installation of Qlikview Server for Domain and Extranet use and configuring the server for IIS support.
• Integration of Qlikview with Salesforce.com using Qlikview tickets.
• Managing the server by adding and removing users and configuring server for anonymous access.
• Developing Dashboards from scratch and enhancing available applications.
• Involved in Requirement gathering & designing QlikView applications.
• Studied the existing data model and incorporated the new fields including static and dynamic flag fields to meet with the new business requirements.
• Extracting QVD files from various Data sources and setting up incremental reload.
• Developed QlikView Dashboards using Charts (Drill Down, Drill up & Cyclic Grouping, Fast change), List, Input Field, Table Box and Calendar & Date Island.
• Developed User Interactive Sheets & Reports as per business needs.
• Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Implemented Security & involved in Deployment of Qlikview Applications.
• Enhanced available Qlikview applications to follow Qlikview best practices.
• Included the enhancement scripts to the existing QV scripts and performed the actual load to test the overall functionality of the applications.
• Enhanced Qlikview application to improve the application loading speed.
• Developed Qlikview dashboard to track bugs and customer satisfaction.
• Provided Trainings & Support to Business Users.

Environment: QlikView 10, SQL Server 2005, Oracle 10g, Access, .CSV Files, Excel files, SFDC, Bugzilla, Windows 2003&2008 Server.

Confidential, New York NY

Sr.Qlikview Developer

Responsibilities:

• Involved in Requirement gathering & designing QlikView applications.
• Studied the existing data model and incorporated the new fields including static and dynamic flag fields to meet with the new business requirements and performed Incremental loading.
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping, Fast change), List, Input Field, Table Box and Calendar & Date Island.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc...)
• Developed User Interactive Sheets & Reports as business needs.
• Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Developed Macros, SET ANALYSIS in provide custom functionality in Qlikview Applications.
• Implemented Security & involved in Release of Qlikview Applications.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Developed the QV scripts to handle the requirements and performed unit testing throughQlikViewbinary load
• Generate new QVD files created by ETL logic to feedQlikViewapplications
• Included the enhancement scripts to the existing QV scripts and performed the actual load to test the overall functionality of the applications.
• Provided Trainings & Support to Business Users.

Environment: QlikView 10/9, SQL Server 2005, Oracle 10g, Access, .CSV Files, Windows 2003 Server.

Confidential, Franklin Lakes NJ

SQL BI Developer/ QlikView Developer

Responsibilities:

• Designed SQL Server Integrated Services (SSIS) Packages to transfer data from various sources like Text Files, XML Files,SQL Server, Excel and Access toSQL Serverusing Business Intelligence Development Studio.
• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column using SSIS.
• Migrated data from different sources including flat files, MySQL, MS Access, Oracle 11g to SQL Server 2005 by using SSIS 2005.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Handled rapidly growing dimensions while maintaining the history of the data.
• Migrated packages from development server to production server using package configuration.
• Designed, Developed and Deployed reports in MSSQL Serverenvironment using SSRS.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Implemented AD HOC reporting with the report builder for the end users.
• Generated reports using Expressions and Functions using SSRS.
• Analyzed the existing applications and identified redundant data sourced from the same data sources.
• Developed Proof of Concepts of consolidated applications and demonstrate to the Business users.
• Generated new QVD files from the EDW by writing scripts inQlikviewapplications
• Applied metrics in the data viaQlikViewscripts and transformedQVDsto cater the business needs.
• Designed and DevelopedQlikViewdashboards meeting the business requirements.
• Assisted theusers duringUAT and incorporated the changesmentionedby the users.
• Involved ingathering,analyzing, anddocumentingbusiness requirements, functional requirements and data Specifications about the financial system.
• DevelopedDrill throughDashboard reports which enabled users to drill between SummaryQlikviewto detail Reports, templates and personalization.
• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs.
• Creation of reports usingreports and chartsas per the customer requirement depends on Quarter, monthly And analyzes the report with charts provided byQlikview.
• Formed User Conditions and Filters to improve report generation & readability andSQL tuningof report and displayed the summary of data bycreating Chartsby usingQlikview.
• Facilitated creation of Dashboard Reports usingQlikViewforSecuritiesData mart and using Security DM Universe as data Provider.
• Executed the job andrecreated the failure points similar to the Production server.

Environment: QlikView 9.0, SQL Server 2005, SQL Server 2008, SSIS, SSRS, Oracle 10g, Access, .CSV Files, Windows 2003 Server.

Confidential

MS SQL BI Developer

Responsibilities:

• Involved in writing scripts for the clients requirements for reporting purposes.
• Involved in creating SQL server Analysis Projects using MS SQL Server 2005.
• Created expressions and dimensions.
• Defined the Referenced Relationships with the measure groups and fact tables.
• Automatic generation of grouping attribute members.
• Defined Granularity with in a measure group and drill through actions.
• Implemented calculations to aggregate physical measures.
• Defined the Browsing Prospective and Browsing Translations.
• Cleansed and transformed data using SSIS.
• Imported data from different sources like oracle, DB2 to SQL Server using SSIS.
• Responsible for Process Database Objects Security Role.
• Developed SSIS packets to fulfill business need.
• Created and deployed reports like drill down, drill through reports depending upon the business need on daily, weekly and monthly basis using SSRS.
• Responsible for writing T-SQL code for creating cursor and handling the data validations.
• Developed complex T-SQL code for the application.
• Transformed the complex business logic and calculations into coding.
• Developed stored procedures, functions, tables, views and triggers.
• Implementing MS SQL Server Security and database Permissions.
• Wrote DTS scripts that extract data from database tables and write the data to text files
• Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.

Environment: SQL Server 2005 Enterprise Edition, SSIS, SSRS, SSAS, MS-Excel, DTS, Visual Studio.Net 2005, Windows server 2003, T-SQL, PL/SQL, MS Access 2000, C#, ADO.NET, XML, Web Services.