Resume
Login
Email

Qlik view developer

Location:
Edison, New Jersey, 07080, United States
Posted:
May 25, 2011   all resumes
Email:
sb03n2@r.postjobfree.com
Contact Info:
******@**************.***


Hari (870*******)
sb03n2@r.postjobfree.com
SUMMARY:
• Around 7+ years of experience in IT industry with strong background in Analysis, Design and Development in the field of Database, Data Warehouse, Data Modeling and implementation of Qlikview for BI applications.
• Database structuring and database application design and development.
• Designed and implemented proof of concepts for clients in the Pharama, Financial and Manufacturing sectors.
• Developed Complex Graphical User Interactive reports using various Qlikview Objects.
• Strong Skills in Data Modeling ( Star Schema, Snow Flake Schema) & Loading data from Multiple data sources.
• Installation & configuration Of Qlikview Software.
• Experience in Incremental Loading & QlikView document Versioning.
• Strong Experience in Data Mart/database design and development.
• Sound knowledge in writing SQL Queries, Pl/SQL Stored Procedures.
• GUI (Graphical User Interface) programming in Visual Basic for desktop application.
• Strong Database Development skills using SQL Server 2005,2008 & Oracle 10g.
• Good ETL skills ,Data modeling, Dimensional Modeling knowledge with experience in developing data movement, data cleansing and data integrity processes for the purposes of loading decision support applications utilizing advanced knowledge of DTS packages and Transact SQL, design and support/enhancements/maintenance.
• Experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services (DTS), SSIS, BCP, Bulk Insert).
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Helped the BA team design the Business Analysis reports using ProClarity 5.4 and Crystal reports
• Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them
• Hands-on experience covering every aspects of the business of customer relationship management (CRM)
• Provided Training Sessions on QlikView capabilities to potential clients.
• Implemented Best Practices & Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys.
• Implemented Triggers using Macros to provide custom functionality in Dashboard Applications.
• Involved in Performance Tuning & Deployment of QlikView Applications.
• A team player with good interpersonal skills and work independently.

TECHNICAL SKILLS:
Database: SQL SERVER 2005, Oracle 10g, Access, Excel & .CSV Files
Languages: SQL, PL/SQL, Visual Basic. Net
BI TOOLS: QlikView 8.5/9.0, Cognos, SSIS, SSRS
Data Modeling: Erwin, Microsoft Visio
Operating System: Windows95/98, Unix, Windows2000/NT/XP,MS DOS
EDUCATION:
Bachelors in computer science.
PROFESSIONAL EXPERIENCE:
Client: Verizon wireless, Lincoln, NE Sep 2009 – TILL DATE
Title: Qlik View Developer
Verizon Wireless is the wireless phone provider that owns and operates the second largest mobile telecommunications network in the United States, based on a total of 94.1 million U.S. subscribers
• 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 KPI’s and set analysis applications.
• 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 to provide custom functionality in Qlikview Applications.
• Implemented Security & involved in Deployment of Qlikview Applications.
• Created QVD’s & updated on timely basis as database updates.
• 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.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Qlikview.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.

Environment: QlikView 8.5/9, SQL Server 2005, Oracle 10g, Access, .CSV Files, Windows
2003 Server.
Client: Union bank, New York Apr 2008 – Aug 2009
Title: Qlik View Developer
Union Bank, N.A., is a full-service commercial bank, providing a broad mix of financial services to businesses and individuals. The bank also offers investment and financial management, trust services, private banking, insurance services, and global custody services
• Delivered advanced/complex reporting solutions such as Dashboards and Standardized Reporting using Qlikview 8.5.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Implemented Star schema & snow flake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation and solved the loops issues.
• Gathered & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files).
• 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.

Environment: QlikView 8.5, SQL Server 2005, Oracle 10g, Windows Server 2003, Windows XP, Microsoft Visio.

Client: State farm insurance
Location: O Fallon, MO
Title: Visual Basic / SQL Developer Nov 2006 – Mar 2008
State Farm is a mutual company owned by our policyholders. Our 68,000 employees and nearly 18,000 Agents service 81 million policies and accounts throughout the U.S. and Canada.
• Responsibilities implementing database objects.
• Documenting models with metadata
• Experience writing Complex SQL queries and PL/SQL
• Leadership, project management and time management.
• Created SQL Server database to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, optimization, normalization) and .NET data access components
• Implemented business logic as .NET Framework assemblies (C#, VB.NET)
• Envisioned and built front-end for the site written in MS Visual Studio .NET, VB.NET, XML, VBScript, HTML, DHTML.
• Performed business and system analysis, designed application and database structure, converted existing data into SQL Server using Data Transformation Services (DTS) and VBScript
• Used Crystal Reports to create reports based on SQL Server database
• Individually designed MS SQL Server 2000 database, coded stored procedures (T-SQL).
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Developed complex Stored Procedures and Views to generate various Drill-through reports, parameterized reports and linked reports using SSRS
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

• Coded ASP in MS Visual InterDev 6.0 using VBScript, JavaScript, HTML/DHTML/CSS, XML and ADO.
• Created components in MS Visual Basic 6.0, used CDO and Outlook 2000 for messaging.
• Deployed the solution, participated in testing and documenting.

Environment: Oracle 8i, PL/SQL, SQL*Loader, ODBC, Windows NT, UNIX, MS Visual Studio .NET

ICICI bank
Location: India
Title: SSIS,SSRS Developer Sept 2004 - Jun 2006
ICICI Bank offers a wide range of banking products and financial services to corporate and retail customers through a variety of delivery channels and through its specialized subsidiaries in the areas of investment banking, life and non-life insurance, venture capital and asset management.

• Actively involved in creation of database, modified tables, triggers, and store procedures to clean and validate the data about the cable layout, so as to meet the company specifications.
• Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Exposed to data conversion from different data sources to SQL Server 2005 using SSIS.
• Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server 2005.
• Experience in developing and monitoring SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) Packages.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications
Converting SQL Server 2005 DTS packages to SQL Server 2005 SSIS packages.
• Worked with DTS Packages on SQL Server 2005 and SSIS packages on SQL Server 2008 for the automation of day to day Maintenance Jobs
• Expertise in Extract, Transform and Load (ETL) using SSIS and various tools including Bulk insert, BCP, Import Export data, DTS packages and SQL Server Integration Analyzed, designed and developed for a Data Warehousing and Data Migrations.
• Managing the security in report manager and SharePoint through AD-groups as per HIPAA rules.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server.
• Developed complex Stored Procedures and Views to generate various Drill-through reports, parameterized reports and linked reports using SSRS
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2005 .

Environment MS SQL Server 2005/2000, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Share Point, T-SQL, Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Oracle 9i, VBScript.