SUMMARY

• Around 9 years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing/ Decision support systems and Business Intelligence (BI).
• 5+ years of Extensive experience with Qlikview 11.2/10.0/9.0 in planning, designing, implementation, maintenance, expertise in designing Qlikview applications and building BI dashboard and analytics.
• Strong experience in Qlikview Product family such as Qlikview Desktop Client, Qlikview Management Console, Qlikview Server.
• Experience in Full Life Cycle development including Planning, Analysis, Design, Implementation and Maintenance using QlikView.
• Expertise in using complex multiple data sources such as SQL, Flat Files, Excel and Access for designing and modeling of Qlikview.
• Maintained Three - Tier architecture across all QlikView dashboards.
• Experience in using ETL Tasks such as data cleansing, joins, aggregation tables using Qlikview.
• Designing Data Mart and Data Warehouse and Implementation of Qlikview for BI Reporting Solutions.
• Extensive noledge with Dimensional data modeling, star schema, snow flake schema, Fact and dimensional tables.
• Created scheduled jobs for QVD extracts and report reloads.
• Hands on experience in SDLC processes and methodologies in Business Intelligence domain.
• Developed business requirements, dashboard development, and data verification and analysis.
• Experience with Multiple Relational Databases including Oracle, MS SQL Server, DB2 and MS Access.
• Experience with Qlikview sheet objects Pivot, List, Multi box, Multiple charts types, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Experience with Oracle Application Modules - Account Payables, Order Management, Purchase Order, Account Receivables, General Ledger.
• Excellent technical, analytical, and problem solving skills. Strict attention to detail and ability to work independently as well as within a team environment.
• Expertise in implementing Oracle BI Apps like implementing Out of order Box prebuilt mappings, Creating Oracle provided Data Warehouse, OBIEE RPD development, OBIEE reports and Dashboards, Upgrading the versions.
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas.
• Worked extensively in the creation of large SAS data sets.
• Good experience in importing the data into Data warehouse from source using ETL.
• Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling in the OBI Administration tool, ERWIN 8.
• 3 layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters.
• Excellent written, oral communication and interpersonal skills.
• Good Knowledge in Dimensional Data Modelling, Star Schema, Snow Flake Schema, Fact and Dimensional tables.
• Strong noledge in database programming using SQL (Stored Procedures, Functions, Triggers, Cursors) and standard Built-in Oracle Packages.
• Working noledge in writing SQL queries to test the OLTP & OLAP Databases based on changes of the functionality.
• Experience in debugging the reporting issues using Qlik Sense.
• Strong experience in writing SQL Queries, views and stored procedures.
• Hard working team leader executing the principle responsibilities and also monitoring the performance of junior staff.
• Good in validating the BI reports/dashboards by preparing the Test Plans& Cases.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.
• 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

ETL Tools: QlikView (11.20 SR3, 11 SR1, 10 SR4), QlikView Management Console, Tableau (9.x 8.x / 7.x ), SSIS, SSRS, Informatica Power Center 8.5 /8.1.1/ 7.1 /6.2.

Database: S SQL Server2014/ 2012/2008R2/2005/2000/7.0, MYSQL,,PL/SQL, Oracle, MS Office Access 97/2000/2003.

Programming languages: C, C++, C#, SQL&PL/SQL, Unix Shell Scripting.

Web Technologies: HTML 3.2/4.0, IIS 4.0/5.0.

Database Tools: TOAD, SQL Plus, PL/SQL Developer.

Operating Systems: Windows 7/Vista/XP/2000/NT, Server 2012/2008R2/2003, Exchange 2003, Linux, UNIX.

Data Modeling: Dimensional DataModeling, Star Join Schema Modeling, SnowFlake Modeling, FACT and dimensions tables, Physical and Logical Data Modeling

.PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

QlikView Developer/Admin

Responsibilities:

• Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Delivered advanced/complex reporting solutions such as Dashboards and Standardized reporting using Qlikview11.
• Install and configure QlikView Server and Publisher.
• Provide administrative services.
• Enable the features dat are requested by the clients and make them understand the new features.
• Created Dashboards with different style using Qlikview components like List Box, Slider, Buttons, charts and Bookmarks.
• Implemented Star schema & snow flake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation and solved the loops issues.
• Allocating daily jobs and workloads and also involved in training new team members.
• Extensively worked to confirm and clarify requirements and business logic.
• Collaborate with L3 on patch and bug fix deployment
• Created SAS Modified Reports using the Data Null technique and written ad-hoc queries to service ad-hod reports.
• Participate in overall architecture and strategy for the development of QlikView suite of products.
• Provide training and documentation for supported applications.
• Assist with performance and tuning of QlikView applications.
• To create QMC tasks to schedule QVW task for reload, publish and distribution.
• Research and recommend alternative actions for problems resolution based practices and applications functionality with minimal direction.
• Analyzed the reporting requirements with the business users and came up with the technical specifications.
• Strong understanding in creating Dashboards, scoreboards for the required KPI’s in QlikView.
• Analyzed the database and provide detailed information on their operational and Forecast for future years.
• Multiple levels of Hierarchies are implemented such as Sales, Product, Partner, Customers and Service Hierarchy etc.
• Maximum Application size is 8.5 GB, with 56 Booking and Revenue related fields, 500 million rows and associated with 98% data density.
• Involved in Design, develop and maintain web-based client software using HTLM, JAVA script.
• Worked with 40 core processor with two 1TB RAM server and two 256GB RAM servers, having monthly refresh.
• Was actively in the Server migration and the Fresh QlikView Installation process.
• Maintained Server for smooth QlikView development. Checked and updated environmental file, assigned task, path and triggers for QMC, QEMC.
• Multiple tier of QVD architecture is implemented depending upon the complexity of the application and the final application reload duration was 4 Hours.
• Developed load scripts to work with multiple data sources (SQL, DB2, AS400, Excel, and Share point site).
• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Designed an applications for to support the lending process and dashboard style of layouts using different components of QlikView Enterprise like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks etc.
• Assisted in requirements gathering and prepared functional documentation.
• Documented technical specifications and reviewed call statistics.
• Resolved technical problems and implemented QlikView consultation services.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher
• Involved in up-gradation of QlikView environment from QV 10.0, QV 11.0 versions. Did end to end Unit Testing when migrating the applications.
• Designed, developed, implemented and tuned multiple QlikView applications for the Sales, IT, Manufacturing, Purchasing & Finance QlikView applications.
• Converted SAS codes to SAS Stored Processes.
• Working with the management to identify the business reporting needs and also develop the architecture of prioritized reports by role dat would have the most positive impact on the business
• Analyze customer requirements and develop proposals of technical solutions as needed.
• Analyzed modeling data in conformance to business needs.
• Modified load scripts and automated data refresh.
• Supported and automated ETL processes with T-SQL.
• Executed DBA functions and maintained QVD files.
• Used SAS Macros and SAS SQL to query data and to obtain results which were generally stored as delimited text.
• Wrote SQL Scripts, procedures and views which are required for QlikView projects.
• 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.

Environment: QlikView11x/10(Desktop, Server/Publisher, Access Point),Nprinting for QlikView (14.03.), SQL Server/ 2012/2014, Windows XP/7, HTML, SAS/Base, SAS/SQL.

Confidential, San Ramon, CA

QlikView Developer

Responsibilities:

• Responsible for the implementation, analysis, design, development, administration and support of the QlikView systems suite of products (QlikView Developer, QlikView Server, Publisher and QlikView Enterprise Management Console).
• Consolidated two existing QlikView applications into one.
• Gatheird & loaded data into Qlikview from various data sources (SQL SERVER, Oracle, .CSV and excel files).
• Created different types of sheet objects like List boxes, Buttons, Multibox.
• Sound noledge of various functions of QlikView technology.
• Implemented Incremental Load to improve Load Time.
• Tested Applications, ensuring the application met the requirements, Data quality for Quality Assurance before delivering to the end users.
• Created POC’s, proposed and documented the requirements to the user for consolidated application.
• Did the analysis of the application regarding user experience (Front end), QlikView data model change, volume estimation, QVW size estimation, BI processing time saved after consolidation.
• Did testing in two different servers and validated the data.
• Resolved the failure issue of existing publisher job in Production server.
• Validated the data of the reduced QlikView files.
• Executed the job in Publisher.
• Implemented security using QlikView section access dat dynamically hides selected areas of the dashboard depending upon user privileges.
• QlikView best practices were used in implementation of scripting, set analysis and usage of variables.
• 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 Sales Analysis, Production over time and implemented performance tuning dat offers fast and flexible access to all key information across the enterprise.
• Trained Distribution Center, Planning and Purchasing & Finance Teams on how to use QlikView applications.
• Testing dashboards and data validation.
• Involved in performance tuning of dashboards to limit the response time and enhance the functionality.
• Designed and developed QlikView software applications and server-based QlikView dashboards from scratch to support BI initiatives.
• Implemented Section access and hidden scripting for the Application Security.
• Hands-on experience in setting up new task and troubleshooting existing task setup and other issues.
• Identified data sources and targets for data modeling and solution architecture.

Environment: QlikView 11, Oracle, SQL Server, Toad /SQL Developer, SQL Loader, QlikView Server and Publisher.

Confidential, AL

QlikView Developer

Responsibilities:

• Involved in Requirement gathering & designing QlikView applications.
• Worked with the team to identify the business reporting needs and studied current reporting practices outside of QlikView through pivot tables.
• Performed redesign of QlikView BI platform to improve availability, scalability and performance to accommodate high volume of data with 60+ dashboards
• Participated on business requirement document preparation.
• Rebuild dashboard applications on both frontend UI and backend, developing scripting templates, UI design and coding standards, design guidelines, migration strategy and implementation plan.
• Developed different dashboard 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.
• 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.
• Maintained and administered source documents, source documents sets, and user profiles and executed resource management services like Access point resources, distribution folders and email servers. Monitor user access to manage the limited number of licenses.
• 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.
• Enhance existing dashboards with new functionalities and Tune ETL scripts for better performance.
• Participated in Scrum stand up meetings.
• Created SQL Stored Procedures and Views to fetch the data from database to build reports.
• Designed and created the dashboard reports for Executive board of company.
• Developed scripts for data reloading, mapping and transformation
• Conducted UI visualization improvement on Usability and User Experience (UX)
• Designed the integration of Enterprise Management Reporting Portal to provide single point of entry, developing Drill-to-Detail (D2D) for deep linking and cross-system Interoperability
• Modified existing reports using QlikView.
• Maintained and updated the dashboard reports as required by client.
• Analyzed the external and regulatory reporting, intercompany and internal management reporting needs of the business process.
• Installed, configured and deployed QlikView application on top of Oracle DB.
• Conducted and guided QlikView BI application global roll out, managed QA Testing, User Acceptance Testing, software update, migration deployment and parallel run, stabilizing the server platform and application to achieve the steady state for transitioning.
• Developed hierarchical business model for company codes, account numbers, line of business, treaty/plan, customers and adjustment periods.
• Designed dashboards identifying the KPIs and to support the time comparison between budget and actual.
• Designed Executive Sales Analysis Dashboard dat offers fast and flexible access to all key information across the enterprise.
• Implemented security using QlikView section access technology dat dynamically hides selected areas of the dashboard depending upon user privileges.
• Maintained user guides and documentation for QlikView applications.

Environment: Qlikview 10/11, Oracle, SQL Server, Terra Data, SAP, Excel, CSV files, Enterprise Management Reporting Portal, DB2, Cognos, QlikView Enterprise Server, JavaScript, Java, ASP.NET.

Confidential, Ashburn, VA

SQL Server Developer

Responsibilities:

• Perform business analysis, technical analysis, systems design, application software programming.
• Prepared DFD's & Entity Relationship(ER) diagrams and restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming.
• Transferring the data (ETL) to Data warehouse by SSIS and extensively worked on Dynamic Management Views in SQL Server 2008R2.
• Installed, authored, managed reports using SQL Server 2008R2 Reporting Services and the migration of SQL Server 2008R2 databases to SQL Server 2008R2.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks and Developed, deployed and monitored SSIS Packages in SSIS.
• Worked with Data Stage Manager for importing metadata from repository, new job Categories and creating new data elements.
• Designed and developed ETL processes using Data Stage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
• Used Data Stage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Performed daily tasks including backup and restore by using SQL Server 2008R2 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Rebuilding the indexes at regular intervals for better performance. Monitored and modified Performance using execution plans and Index tuning.
• Extensively worked on DBCC commands and Dynamic Management Objects. Rebuilding the indexes at regular intervals for better performance.
• Expertise in SQL Server Reporting Services and SQL Server Analysis Services.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Export or Import data from other data sources like flat files using Import/Export through SSIS.
• To analyze long running slow queries and tune the same to optimize application and system performance. Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Environment: SQL Server 2008R2, IBM Data Stage 8.0 (Designer, Director, Manager, Parallel Extender), Windows 2008 Server, MS TFS, MS-Access, Visio Professional, DB2.

Confidential, Calabasas, CA

SQL Server /BI Developer

Responsibilities:

• Actively participated in interaction with Users, DBA's and Business analysts to fully understand the requirements of the system.
• Reviewed database design and integration of systems and made recommendations on enhancements and participated in moving legacy data to the data warehouse using ETL.
• Involved in System Study analysis for logical/physical data model their by defining strategy for implementing Star and Snow flake schema with Fact and Dimension tables.
• Designed ETL architecture for complete data transfer from OLTP to OLAP using SSIS.
• Performed data conversion from flat file into a normalized database structure and used FTP/SFTP tasks to get Data and Checksum files and upload them back to secured sites based on business requirements.
• Imported data from files using SQL BULK INSERT in user specified format to database tables.
• Exported the data in/out of SQL databases quickly using BCP Command.
• Performed metadata validation, reconciliation and appropriate error handling in ETL processes using SSIS.
• Generated reports using SSRS, Excel (Pivot) dat could be used to send information to diverse group of users, clients, and managers and also published Reports to SharePoint site.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability and Created SQL scripts for tuning and scheduling.
• Actively participated in troubleshooting data issues validated result sets and implemented process improvements also Written Complex T-SQL Queries, Sub queries, Co-related sub queries, Dynamic SQL queries, Procedures, Functions, Triggers and other database objects using SQL.
• Performance tuning of Stored Procedures and T-SQL Queries.
• Having noledge of Normalization and De-Normalization techniques.
• Worked in data modeling using MS Visio and Erwin.

Environment: SQL Server 2008, Visual studio 2008, MS Visio 2007, C#.net, XML, SQL Server Management Studio, DBCC, SQL Profiler, Database Tuning Advisor, Business Intelligence Development Studio, MS Excel, SQL Data Generator.

Confidential

Database Developer

Responsibilities:

• Gatheird business requirements from Business Analyst and translated them as technical specifications.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created Reporting documentation by analyzing Report data and used as reference to develop reports from Data Mart.
• Created SSIS packages to load data from DB2 database to SQL server.
• SSIS package flow is coded using various tasks like For-Loop, for each Loop, Data Flow, Execute SQL, Execute Process, FTP Task, File System Task and Precedence Constraints.
• Used various SSIS components such as Conditional Split, Derived Column, Lookup, Merge Join, Row Count and OLEDB Command, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Implemented Logging Configuration to monitor the execution of SSIS package.
• Created package configuration to change source, destination credentials and load data as per TEMPeffective date range.
• Implemented Checkpoints, to return failed package from point of failure.
• Implemented Event Handlers in SSIS package.
• Data Warehouse is loaded as per SCD-1, SCD-2 requirements. SCD-2 is implemented to load early arriving Facts.
• Identified Attributes, Hierarchy and Created Cube, generated SSRS Reports from dis Cube.
• Created Tabular-Reports, Matrix-Reports, Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated multiple Enterprise reports (SSRS) from SQL Server Data Mart and included various reporting features such as group by, drilldowns, drill through, sub-reports.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Worked on Erwin tool to analyze Data Mart.

Environment: SQL Server 2008, TFS, Erwin, SharePoint 2010, Business Intelligence Studio, Visual Studio 2008, Windows XP, Linux, DB2.