SUMMARY:

• Around 8 years of experience in IT Software Development Life cycle involving Business Requirement Analysis, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing and Database Business Systems.
• 3+ Years of Experience in working with QlikviewDesktop,QlikviewManagement Console (QMC), QlikviewPublisher,QlikviewWeb Server.
• Worked with QlikView Hierarchies, QlikView Architecture, Data - warehousing and Dimensional modeling.
• Involved in Requirement gathering & designing QlikView applications.
• Experience in loading data from multiple data sources like DB2, Netezza, SQL Server, Oracle, MS Access, Excel, Html, xml etc.,
• Developed QlikView Dashboards using Chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box and Calendar & Date Island.
• Strong working knowledge of Qlikview scripting, Set analysis, aggregation functions, multi-dimensional objects and layout and design including chart properties and formats.
• Expertise in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.
• Strong experience in Data Warehousing concepts - Star Schema, Snow Flake Schema and Data Modeling (Normalization/De normalization, ER Diagrams, Keys)
• Strong knowledge in basic components of QlikView Enterprise like List Box, Multi Box, Tables, Charts, Current Selection Box, Buttons, Containers etc., and experience in editing scripts for creating variables, fields, and calculated expressions, basic and aggregated functions.
• Hands on experience in creating QVW files, QVD files and reloading them on timely basis as per the database updates.
• Experience in optimizing existing QlikView reports with a focus on usability, performance, flexibility, testability, and standardization.
• Interaction with Business users during the various stages of project lifecycle to identify various KPI’s and designed solutions to enhance business decision making.
• Used Qlikview publisher to schedule data load, distribute Qlikview application, and manage security and access through Active Directory integration.
• Optimized theQlikviewDashboard's Performance by analyzing and tuning the QlikMart (Data Model).
• Expert in database development skills using SQL and writing Stored Procedures, Packages and Triggers.
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back-end testing.
• Energetic, enthusiastic and hardworking, result oriented team player inclined towards achieving career goals and enterprise objectives.
• Excellent communication, presentation and interpersonal skills.

TECHNICAL SKILLS:

BI Tools: QlikView 11.2/11.0/10.0/9.0/8.5.

Languages: C, SQL, PL/SQL and T-SQL, ANSI SQL

Databases: Teradata, DB2, MS SQL Server 2012/2008/2005.2000, and Oracle.

Data Modeling: Snow flake and Star-Schema modeling

Operating System: UNIX, Linux, WINDOWS 9x/NT/XP/7/2008 server, MS-DOS

Web Technologies: ASP.NET, VB.NET, HTML, XML, CSS

PROFESSIONAL EXPERIENCE:

Confidential, Newtown Square, PA

QlikView Developer

Responsibilities:

• Extracted Data from multiple data sources like Oracle, SQL server, MS Access, MS Excel, XML and Web files through OLEDB and ODBC connections.
• Developed dashboards pertaining to Revenue and Sales monitoring.
• Managed and distributed application using Qlikview Publisher.
• Managed the QlikView Server tasks: developing tasks, assigning license, creating user groups etc.
• Participated in QlikView server migration from one physical server to another.
• Participated in user discussions to understand the user requirements, layout, and look and feel of the dashboards to be developed.
• Performed analysis, documentation, for calculation for various attributes.
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Promoting dashboards to production environment and manage user access.
• Involved in Requirement gathering& designing QlikView applications.
• 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), List, Input Field, Table Box and Calendar & Date Island.
• Developed Custom DATE Calendar Object and Linked with in the Model.
• Strong Experience in Working with Charts ( Table Box, Pivot, Straight, Pie, Line Gauge)
• 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.
• Implemented Security & involved in Deployment of Qlikview Applications.
• Created QVD’s& updated on timely basis as database updates.
• Sound skills in developing hide/Show Objects based on Conditions & Triggers.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.

Environment: QlikView 11.2/11.0, SAP BW, Teradata, SQL Server 2005, Oracle 10g, Access, .CSVFiles, Windows 2003 Server, Sun one LDAP, SAP BW.

Confidential - Houston TX

QlikView Developer

Responsibilities:

• Developed KPI’s and set analysis applications.
• Developed User Interactive Sheets & Reports as per business needs.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes and Calendars.
• Implemented Star schema & snow flake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation (Resolving Loops & model ambiguity).
• Gathered & loaded data into QlikView from various data sources(SQL SERVER 2005, Oracle 10g .CSV and Excel files).
• Generate new QVD files created by ETL logic to feed QlikView applications.
• Included the enhancement scripts to the existing QV scripts and performed the actual load to test the overall functionality of the application.
• Coordinated with ETL team and performed integration testing to check data discrepancies.
• Automated QlikView jobs in QlikView Publisher and rolled out to QlikView AccessPoint and administered Security using Active Directory.
• Analyzed the existing QlikView data model and script logics for the existing QlikView applications.
• Executed the scripts and checked the incorporated script changes in the Application.
• 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.
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Developed SQL Scripts in validating data from different data sources.
• Mentoring Business User Groups.

Environment: QlikView 11.0/10.0, SQL Database, Windows Server 2003, oracle 10g, Microsoft Visio, QlikView Publisher, QlikView Server 9.0.

Confidential - Parsippany, NJ

QlikView Developer

Responsibilities:

• Designed and developed QlikView applications from scratch, to support reporting and Business Intelligence initiatives.
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Used advanced scripting, set analysis, VBScript, advanced aggregation functions and advanced charts.
• Converted existing Business Objects reports to QlikView.
• DevelopedQVDashboards using various Chart types (straight, pivot, bar, Pie, gauge and combo charts, List boxes, Input Field, Table Box, sliders).
• Participated in Installing, configuring and deploying.
• Gather business requirements from business users and developed Application Prototypes.
• Strong understanding in creating Dashboards for the required KPI’s in QlikView.
• Deployed the application on QlikView server and imported data from different sources like Netezza, DB2, SQL server, Oracle 10g, MS Access, XML files and flat files using OLE DB/ODBC.
• Involved inProduction Support and data validation of Business Objects reports and QlikView models.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers.
• Experience in usingQVFunctions related to string, date, color and formatting.
• Developed views in Data Base to load the relevant Data inQlikViewApplications.
• Developed Macros and implemented extension objects to provide custom functionality inQlikViewApplications.
• Used Oracle/SQL Server as backend and alsoQlikViewscript for ETL Operations for extracting,
• Involved in Deployment ofQlikViewApplications into the server.
• Extensively implemented incremental loading to decrease the load time / increase loading performance.
• Performed different tasks like extraction, reload tasks, distribution tasks, reduction, deploying apps, scheduling, User management, license management, Clustering and licensing.

Environment: Qlikview 10/9.0, My SQL, Excel Windows Server 2003

Confidential

SQL Developer

Responsibilities:

• Designed details of UI/Reports for Sales Performance tracking.
• Designed and implemented datasets and layouts for various reports with SSRS.
• Identified aggregation from business requirements and designed cubes with SSAS.
• Created cubes, did performance optimization and generated OLAP reports with SSAS.
• Involved in logical design and physical design of the data mart, forward engineering and reverse engineering with Erwin.
• Created data dictionary for the overall database.
• Identified interfaces to the Data mart, design and implemented data mappings with SSIS.
• Developed stored procedures to retrieve and transform data in T-SQL.
• Provided Full Reporting Life Cycle support using SSRS.
• Understood complex reporting requirements and define functional requirement.
• Designed, developed, and deployed new reports and enhanced existing Reports.
• Identified and worked with parameters for parameterized reports using SSRS.
• Retrieved data from cubes and generated OLAP reports using SSRS and SSAS.
• Developed complex Stored Procedures for the reports.
• Maintained data integrity by performing validation checks.
• Optimized queries, tuned and monitored server performance.
• Fine-tuned of database objects and server to ensure efficient data retrieval.
• Tested applications for performance, data integrity and validation issues.
• Developed front-end/UI for easy data access and submission in C#.

Environment: SQL Server 2005, SSRS, SSIS, SSAS, Erwin 4.1, Oracle 10g, C#.

Confidential

SQL Developer

Responsibilities:

• Modified report wherever needed as per the suggestions given by business analyst and Analyzed the existing Actuate and SQR reports.
• Created Cross-Tab, Sub-Reportusing RDL. Promoted RDLs to Reporting Service Server.
• Developed complex Stored Procedures to generate various Drill-through reports,parameterized reports andlinked reports using SSRS.
• Migrated actuate code of data extract to PL/SQL equivalent and Created PL/SQL functions, packages, procedures and joins.
• Coordinated with the client to make sure that there is not much change during the migration of the reports.
• Involved in Performance tuning and Query Optimization.
• Converted the Actuate and SQR reports to SSRSwithout any change in the output of the report.
• Enhanced the existing reporting functionality by using the advanced features of SSRS.
• Assessed the pros and cons of migration and conveyed the same to the Business Analyst.
• Used SQL Developer to Load / Extract data into and from Excel files.
• Written stored procedures for those reports which use multiple data sources.
• Conducted impact analysis and designed structures to enhance performance.
• Created different types of reports such as parameterized reports, matrix report, charts etc.,
• Tested (manual) the reports after migration to make sure that the SSRS reports serve the exact business purpose as that of existing Actuate reports.

Environment:MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration Services 2008, SQL Analysis Services 2008,Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.