SUMMARY

• Over 8+ years of strong experience in IT industry in the fields of Qlikview, Business Intelligence and database development.
• Over 3+ years in end - to-end implementation of Qlikview dashboards involving requirements gathering, design, development and deploying using Qlikview 10.0 and 11.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Expert in designing variety of charts (container, drilldown, cyclic, gauge etc.) analyzing the various KPI metrics
• Three tier architecture implementation (Data extraction layer, Transformation layer, UI/Presentation layer)
• In-depth understanding of implementing best practices for data modelling and scripting to eliminate synthetic keys and circular s in Qlikview
• Extensive experience in implementing Incremental load (Insert, Update) using the QVD (Qlikview Data) files
• Expert in writing complex set analysis expressions in Qlikview applications
• Experience in using different Qlikview functions like AGGR, Applymap, Match and various other String, Numeric and Date functions.
• Experience in building the QlikView Security Model, Data Reduction, Load balancing features of QlikView.
• Highly proficient in database development and building complex SQL queries, stored procedures, views and functions.
• Experience with Data Warehousing lifecycle such as dimensional modeling, data extraction, transformation and loading, schemas (Star Schema and Snowflake Schema).
• Proven track record of achieving high quality standards in the execution of end-to-end projects with an highest Customer satisfaction index

TECHNICAL SKILLS

Qlikview: QlikView Desktop (10/11), QlikView Server (10/11)Other BI SSIS, SSRS.

Database: SQL-Server 2008/2005, MS-Access, Oracle 10g, DB2

Programming: Qlikview scripting, HTML, VB Script, T-SQL

MS Office: Excel, Access, Outlook, Word, PowerPoint

Operating System: Windows Server 2003/2008, Windows XP/Vista/7/8

PROFESSIONAL EXPERIENCE

Confidential, Florham Park, NJ

Qlikview Developer

Responsibilities:

• Participated in Template designs, User Interface and Navigation Design patterns, coming up with Dashboard standards for the company.
• Extensively involved in working with Users in understanding requirements, preparing BRDs and presenting POCs to arrive at Dashboard solutions.
• Designed and developed dashboards with various levels of complexity including different kinds of charts and extensions.
• Built complex expressions using set analysis and functions in support of the dashboards.
• Used variety of QlikView Extensions such as Google Maps, QlikMaps, Webpage Viewer, Org Chart, Whisker Pie Chart and HtmlTextBox.
• Involved in Dashboard optimization to handle large volumes of data using QlikView best practices and Techniques.
• Prepared data models connecting to variety of multiple data sources such as Oracle, SQL Server, Access, flat files.
• Handled the end-to-end implementation of QlikView dashboard deployment.
• Implemented incremental load by creating QVDs and optimized the periodic data additions.
• Scheduling the automation of QV jobs using QlikView Management Console.
• Implemented triggering of QlikView Task via Autosys using EDX in order to invoke Dashboard refresh via Autosys Tool independent of Server.

Environment: QlikView 10/11, Oracle 9i/10G/11G, SQL Server 2008, Access, CSV Files, Windows 2008 Server, Cognos, SharePoint.

Confidential, Louisville, KY

Qlikview Developer

Responsibilities:

• Involved in User requirements and Documentation and Dashboard Prototypes.
• Created various dashboards using different kind of charts - Bar, Line, Combo, Scatter, Grid, Block, Spider, Pivot and Cross table.
• Written complex expressions using Set analysis and various QlikView functions.
• Developed data model to reflect a Star model after translating various sources into Dimension and Facts.
• Eliminated all Synthetic keys and Circular s in order to make data model efficient.
• Implemented tasks to schedule QVD generation and Dashboard refreshes at regular intervals and appropriate dependencies.
• Involved in QMC Administration, Server/Publisher installation and Configuration.
• Implemented Data security using Section access and Publisher Data Reduction.
• Developed QlikView Reports for PDF Distribution via Email.
• Developed Custom functionalities using Macros such as Emailing Dashboards in Email Body, Saving as PDFs etc.
• Involved in the entire lifecycle of QlikView Dashboards.
• Involved in Testing Dashboard data using extensive SQLs, Excel Pivots and Mappings.

Environment: QlikView 9/10, Oracle 10g, SQL Server 2008, Access, XML Files, MS Excel, Windows 2003 Server, SharePoint.

Confidential, Hartford, CT

Qlikview Developer

Responsibilities:

• Developed various QlikView Dashboards with various levels of complexity.
• Worked with ETL Team to provide necessary data and advised on data structures and transformations.
• Extract, transform, and load data from multiple data sources into the QlikView application and generated star and snowflake structures.
• Provided input on proposing, evaluating, and selecting appropriate design alternatives which meet requirements and are consistent with our current standards and processes.
• Participated in the UAT process along with business users and ensured an effective delivery of dashboard applications.
• Used Macros to provide some custom features in Dashboard such as PDF, Excel and PPT exports of charts and Data tables.
• Worked on Performance testing of Dashboard and also data validations using independent queries and raw data analysis.
• Implemented Section Access to filter data based on User Privileges.

Environment: QlikView 9/10, Oracle 10g, SQL Server 2008, Access, MS Excel, XML Files, Windows 2003 Server, SharePoint.

Confidential

Qlikview Developer

Responsibilities:

• Developed SSIS to extract, transform and load data from different data sources, such as databases, CSV, Excel files into SQL Server database for reporting purpose
• Maintained dimensions/facts/data extractions jobs using SSIS
• Developed complex stored procedures to process data in SQL Server 2005/2008
• Optimized SQL queries and fine-tuned indexes to improve system performance
• Developed scripts to execute SSIS packages using DTEXEC
• Deployed SSIS packages in either File System or MSDB
• Understanding SQL Server Replications, Snapshot, Transactional and Merge type
• Communicated with both customers and DBAs to accomplish large and complex assignments

Environment: SQL Server 2008, SSIS, Oracle 10g, SQL Server 2008, Access, MS Excel, Windows 2003 Server, SharePoint.

Confidential

BI Developer

Responsibilities:

• Well versed with SQL Server 2005/2008R2 Installation, Administration and Monitoring, Database Backup and Recovery and day-to-day database monitoring activities.
• Developed T-SQL (DDL, DML) statements using dynamically generated SQL and defined d relationships with the measure groups and fact tables.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase and MS Access.
• Transferred data (ETL) to Data warehouse environment using SSIS.
• Writing SQL Server Integration Services (SSIS) packages and deploy it in Development/Testing and production server.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
• Created Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks completion.
• Detach and Attach databases, manage and modify database files

Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, Report Builder, SQL Server Analysis Services (SSAS), BCP, SQL Profiler, Replication, Log shipping, Mirroring, Windows XP/2000 and Windows 2003/2008 Server

Confidential

SQL Developer

Responsibilities:

• Installation of Microsoft SQL Server 2008/2005 and 2000 on PROD, QA & DEV boxes.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase and MS Access.
• Transferred data (ETL) to Data warehouse environment using SSIS.
• Writing SQL Server Integration Services (SSIS) packages and deploy it in Development/Testing and production server.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
• T-SQL & PLSQL programming for writing stored procedures, user-defined functions, Triggers, cursors, views setup and management of linked servers to Non-SQL-Server Databases.
• Created SQL Jobs, Database Maintenance plans Schedule for execution at specified time
• Creating jobs for scheduling the SSIS packages.
• Worked extensively on SSIS Packages for extracting the data of the file system and transformed that data and load it into OLAP.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.

Environment: SQL Server 2000/2005, BIDS, Enterprise Manager, Windows 2000/2003, SQL Profiler, T-SQL, Linux, Solaris.