PROFESSIONAL SUMMARY:

• Around 7 years of IT experience providing expertise in design, development and support of applications Windows environments.
• 3+ years of experience as a QlikView Developer .
• Skilled at developing reporting and data solutions.
• Expertise in working with Data Warehousing and business intelligence tools for developing various reports using QlikView BI .
• Experience in full life cycle project development, including design, coding, testing and implementation with ongoing product support.
• Strong analytical database design and DataModeling (Star Schema, Snow Flake Schema) skills in QlikView .
• Experience in MS SQL Server (BI) and SQL Programming .
• Excellent understanding of data warehouse specific Architecture, Design and Procedures, ETL and workflow development, data cleansing, data quality validation and unit testing.
• Expertise in QlikView 11.0 SR1/10.0 SR3 installation and upgrading existing version.
• Expertise in designing in QlikView with complex multiples data sources ( SQL, Flat Files ) relational designs and optimizing applications by using QVD's, removing non - key fields and script variables (Loading phase).
• Developed User Interactive Sheets & Reports as business needs.
• Developing SQL Scripts to load the relevant Data in QlikView Applications.
• Developed set analysis to provide custom functionality in QlikView Applications
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Data Island
• Experience with QlikView sheet objects including multiple charts types, Trends, KPI's, Bookmarks, Pivoting , custom requests for Excel Export , Fast Change and objects for Management Dashboard reporting and other KPI's.
• Experience in creating ETL Applications for QVD's and QlikView Scripting variables and File, Date, System, Mapping, and Table functions.
• Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Good Understanding of Relational and Dimensional Database Concepts .
• Good Experiences on Data Warehousing Models, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server. 
• Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.
• Hands on Qlikview reporting/visualization in development projects.
• Experience on developing and architecting BI Solutions using Qlikview.
• Experience in Database structuring, database application design & development, Entity Relationship Modeling (ERM), Data export/import, SQL programming &ETL procedures.
• Design of Qlikview applications using Qlikview Data (QVD) files generated by ETL logic .
• Experience in designing Qlikview Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Entitlement and data level security for dashboard using Section Access . 
• Created QVD's & updated on timely basis as database updates and also developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys .
• Strong skills in providing custom functionality using Macros, Triggers, Set Analysis .
• Experienced in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries, Sub Queries.
• Strong experience in Data Warehousing concepts - Star Schema, Snow Flake Schema and Data Modeling (Normalization/De normalization, ER Diagrams, Keys).
• Experience in developing dashboards using different inbuilt  QlikView API’s.
• Expertise in Installing and Configuring Qlikview Desktop, Qlikview Server and Qlikview Publisher. 
• Experience in data modeling, data loading, data migration, data analysis.
• Experience in Working with Business analysts for acquiring business requirements.
• Assisted less experienced Business Objects and QlikView users on building their own reports.
• Experience implementing systems using the Agile/Scrum methodology .
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise reporting architecture.
• Exceptional analytical, troubleshooting and communications skills to communicate directly or remotely with business partners/clients to identify key areas where Business Intelligence can solve business problems by delivering pertinent and timely information.
• A well-organized, goal-oriented, highly motivated effectual team member.

TECHNICAL SKILLS:

Business Intelligence: Objects 4.1,WebI, Crystal Reports XI/2008, Xcelsius, Toad 9.0,Tableau9.0/8.x,QlikView 12.0/11.0

QlikView Administration Tools: QlikView Server 11, Publisher, QEMC.

QlikView Security: Section Access, Conditional Hide/Show, Hidden scripting, File Reductions.

Database: Oracle 10g, MySQL, MS Access, MS SQL Server, SAP Connector, MS SQL Server 2005,2008,R2,2012, MS Access 2000, 97, Oracle

Operating System : Windows 7/10

Languages : C, C++,TSQL, PL SQL

Web Technologies: HTML, CSS, Java Script/JQuery

Others: Microsoft Products MS Word, MS Excel, MS Access, MS Power Point, MS Visual Studio, Visual Basic 6.0

WORK EXPERIENCE:

QlikView Developer/ SQL-BI developer

Confidential, Louisville, Kentucky

Responsibilities:

• Project includes requirement gathering, architecture design, ETL process, Data Modeling, Frontend development and reporting using QlikView .
• Created Dashboard using different components of QlikView like listboxes, multiboxes, slider, buttons, charts (Bar, Line, Combo, Gauge, Scatter, Straight/Pivot table) .
• Analyzing data on financial information using Dimensional-modeling techniques.
• Developed KPI’s to show YTD & LYTD, MTD, QTD, Current period, Moving Average etc… as per user input for from and To Date using Calendar object.
• Analyzed and developed best practices for data management and Extract, Transform, Load (ETL) processes from multiple data sources.
• Extracted information from disparate data sources like Excel, QVD, flat, XML files by using different ETL script statements like Resident, Concatenate, Join, Keep, Mapping Load, autonumber128, Interval Match, Info Load.
• Managed company-wide system of QlikView BI solutions to ensure optimization of both data models and front-end UIs.
• Gathering data sources like QVD files, Excel, Oracle, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized Qlik Marts.
• Created QVD's & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.  
• Used QlikView Functions (Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous etc.) and Created Variables using LET, SET or control statements in the scripts.
• Ranking of Top “N” Vendors & Revenue contribution Buckets by suppliers.
• Customized and tweaked the scripts for cross-tables and generic loads and created simple and complex expressions
• Establish communication with higher management in manner that will optimize the project delivery time.
• Fine-tuning of code using SQL for back end process.
• Providing analytical dashboards to Improving the cooperative’s efficiency, and Creative adhoc reports to expense department. Focus on Budget, forecast and variance.
• Drill Information by creating Groups/Cycles in QlikView.
• Entitlement and data level security for dashboard using SECTION ACCESS.

Environment: QlikView 11, Windows XP, TSQL, XML, MS Visual Studio, MS Access 2007, MS Excel 2007.

QlikView Developer

Confidential, Lansing, MI

Responsibilities:

• Designed different sets of reports and interacting with client for requirement analysis and delivery project of QlikView application.
• Creating QlikView applications for analysis reports from multiple data source.
• Maintenance of data in form of QlikView data files, pulling the data from relevant database.
• Process analysis and process mapping with respect to project.
• To supervise adhoc tasks sent by client.
• Meetings with end users to gather the functional requirements and customize Qlikview dashboards accordingly.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input Fields).
• Gathered & loaded data into QlikView   from various data sources (Sql server 2012, Oracle 10g, .CSV and excel files).
• Monitoring of the QVS (Access Point), QVW's and user accounts for the usage of the applications.
• Implemented section access which allows user to see by default their Region’s data and population attached to a particular Region.
• Performance tuning of dashboards was carried out to limit the response time.
• Implemented security layer and extensively involved in the deployment activities of the Qlikview Application.
• Wrote SQL Scripts to load relevant data in QlikView Applications.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros. 
• Support included creation of reports and standard relational databases for upload to SharePoint dashboard web part pages, and creation of supporting SQL queries. 
• Experience in data modeling, data loading, data migration, data analysis.
• Developed production-grade Qlikview reports and dashboard to meet business requirements in timely manner. 
• Contribute to high levels of professionalism and intellect necessary for continuous improvement of project.
• Dashboard analysis portfolio by profit low to high and doing research for poor performance for revenue growth.
• Developing adhoc reports analysis to see how revenue, cost and gross profit are doing against forecast, budget and actual.

Environment: QlikView10.0, Windows XP, SQLS 2005/08, MS Visual Studio, MS Access 2007, MS Excel 2007.

QlikView Developer

Confidential, Los Angeles, CA

Responsibilities:

• Imported data from multiple data sources including Web Services, MS SQL Server and MS Excel through OLEDB and ODBC connections and modeling data as per user requirements.
• Participate in enterprise DW / BI strategy/Dashboarding.
• QlikView 9.0 implementation and integration.
• Involved in utilizing QlikView solutions to develop complex reports and executive dashboard.
• Created Architectural Conceptual documentation and Technical Specification Documents.
• Creating complex data models without synthetic tables and circular loops.
• Developed QlikView applications creating expressions using set analysis.
• Created and scheduled Complex reports by leveraging the basic components of QlikView.
• Develop front end applications using QlikView technology.
• Connected to multiple data sources such as Oracle, DB2, Flat files, Excel Spreadsheet's and prepared close to business requirement like model. (Especially star model and snowflake).
• Established a Standard structure for Test and working files (QVW) and version controlling to maintain parity between production and Test environment.
• Used QlikView direct discovery along with Document chaining to fetch on-demand report from linear database after creating View inside the database to protect performance from huge data loading during mass data accumulation due to Granular data fetching.
• Implemented 3-Layer architecture, Binary loads and Incremental Loads for optimal performance of the Dashboard reloads, rescaling and to adhere to data retention standards. 
• Incorporated necessary log files and failure mailing mechanisms for smooth day to day operations.
• Worked on data model according to the user requirement and successfully created an optimized QlikView application. 
• White boarded closely with the business in order to map out the most valuable visualization elements on the dashboard.
• Developed dashboards and KPI's using set analysis, variable creation etc. for individual payroll details, comparison with peer and comparison with the market.
• Involved in organizing meetings to know the needs of clients for the Enterprise solution Implementation.

Environment: QlikView 9.0, Windows 2003 Server/XP, SQLServer 2008, MS Visual Studio, MS Access 2007, MS Excel 2007.

SQL/ QlikView Developer

Confidential, Springfield, IL

Responsibilities:

• Involved in business requirement gathering and development of functional and technical specification documents.
• Developed different dashboards with a complex database system behind it, which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Connected to different ODBC, OLE DB data sources ( SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView.
• Gathered & loaded data into QlikView from various data sources ( SQL SERVER 2005, Oracle 10g, .CSV and excel files.
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Build reusable macros to control QlikView objects for ease of use by the users.
• Delivered advanced/complex reporting solutions such as Dashboards and Standardized Reporting using QlikView8.5
• Implemented Star schema & snowflake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation and solved the loops issues.
• Read and gather Qlikview Planning requirements.
• Used to solve the issues related to the end users.
• Installation/Configuration of Qlikview 8.5.
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Research and troubleshoot technical problems and provided ongoing Qlikview consultation to the development team.

Environment: Qlikview 8.5, Web Intelligence, Info View, TOAD, MS SQL Server 2005, Visual Studio 2005, T-SQL, MS Access, Windows XP/2003 server, HTML, VB Script & Java Script.

SQL Server Developer

Confidential

Responsibilities:

• Developed T-SQL code for the application.
• Modified the existing database by adding the tables and maintained relationships between the tables.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like billing, customer, and requests from the residential, business and large business databases.
• Created SSIS Dynamic Packages using variables and deployed the SSIS packages.
• Implemented Incremental loads using different kind of tasks using SSIS.
• Used Event Handlers for Exception Handling in SSIS packages.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created, Managed and Support existing reports using SSRS.
• Involved in creating, deploying and configuring reports according to the requirements using SSRS.
• Developed different types of Tabular Reports, Matrix Reports, and Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Developed cubes using SSAS involving multidimensional data.
• Supported various sectors like Development, testing, Production, Maintenance and Application teams.
• Conducted performance tuning by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard .
• Executed Test cases manually Using Quality Center.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Managed requests that came from the development team.

Environment: MS SQL Server 2005, ASP.Net, Management Studio, BIDS, Visual Studio 2005, MOSS, Integration Services, SSRS, SSAS, T-SQL, DTS, ETL, SQL Profiler, Windows 2003.

SQL Server Developer

Confidential

Responsibilities:

• Developed T-SQL code for the application.
• Modified the existing database by adding the tables and maintained relationships between the tables.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like billing, customer, and requests from the residential, business and large business databases.
• Created SSIS Dynamic Packages using variables and deployed the SSIS packages.
• Implemented Incremental loads using different kind of tasks using SSIS.
• Used Event Handlers for Exception Handling in SSIS packages.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created, Managed and Support existing reports using SSRS.
• Involved in creating, deploying and configuring reports according to the requirements using SSRS.
• Developed different types of Tabular Reports, Matrix Reports, and Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Developed cubes using SSAS involving multidimensional data.
• Supported various sectors like Development, testing, Production, Maintenance and Application teams.
• Conducted performance tuning by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard .
• Executed Test cases manually Using Quality Center.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Managed requests that came from the development team.

Environment: MS SQL Server 2005, ASP.Net, Management Studio, BIDS, Visual Studio 2005, MOSS, Integration Services, SSRS, SSAS, T-SQL, DTS, ETL, SQL Profiler, Windows 2003.