SUMMARY:

Over 7+ years as an IT professional and 5 years of Qlikview with extensive experience developing Qlikview applications, ETL design, database development, designing data modeling, data warehouse, requirements analysis and data conversions.

TECHNICAL SKILLS:

QlikView Tools: QlikView Developer, QlikView Publisher, Enterprise Management Console, Management Console, QV Ajax Client, QV IE Plug - In.

Tools: QlikView, Cognos, Visio, SQL Developer, SQL Tools, Automate MS Office.

Databases: Oracle 11g/10g, SQL Server 2005/2008, Teradata, MS Access.

Languages: SQL, PL/SQL, VB-Script, C

Operating Systems: Windows 2005/2008/XP.

Web Applications: IIS 6/7, Web Logic 8.

PROFESSIONAL EXPERIENCE:

Confidential

Lead QlikView Developer

Wilmington, DE 

Responsibilities:

• Involved in the requirements Gathering and Understand ing the end- user business requirements and develop creative and visually effective user interfaces for Dashboards, Analytics and Reporting.
• Responsible for the QlikView Dashboard & Report development, which includes QlikView dashboard design /QlikView Script writing - connecting with varied sources (flat file/Oracle etc.), data cleansing, data analysis etc.
• Designed and developed a wide variety of charts and associated sheet objects to satisfy complex business requirements.
• Creating a relevant data model and front end to satiate the QlikView requirements
• Educated different user groups and peers with QlikView functionality.
• Have done the integration of project with the existing applications and used the Qlikview 11 features (Giving the users option to pick the Dimensions and Metrics).
• Implementing Security and Incremental Loading in QlikView Dashboards
• Monitoring the defects with HPQC and interacting with users to solve the issues.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Provided Production support to the existing qlikview applications.

Environment: Microsoft SQL Server, Qlikview (11),SAP BW, SFDC,HPQC,BMC Remedy, MS- Access, Excel Spreadsheets, SharePoint, Subversion Qlikview Server, Windows Server/XP/2003.

Confidential

Lead Qlikview Developer

Salt Lake City, UT

Responsibilities:

• Developed highly customized QlikView dashboard applications.
• Designed and developed a wide variety of charts and associated sheet objects to satisfy complex business requirements.
• Designed Graphical User Interface with Qlikview Extension objects according to requirement.
• Created a navigational system that utilized QV hierarchy that used weights to identify values.
• Worked on enhancements and Performance tuning of existing Apps.
• Back traced data to make sure it works cohesively as well as accurately by looking for discrepancies such as duplicates, rescinded information etc...
• Was given the task to define major KPI so analyzed, brainstormed the needs of the company and created a trigger system that alerted higher ups in problems with any unit of measure they are measuring or would fall under their jurisdiction to know the status of.
• Wrote Complex set analysis statements.
• Used SQL Server Management Studio, TOAD to run SQL queries and validate the data in Data warehouse and Data Marts.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Code review as well as fine tuning of applications as well as fixing data model.
• Scheduled tasks in server and Trouble shooted application in access point as well provided maintenance.
• Dealt directly with CEO, CFO as well as all managers on day to day basis to create an effective system and that tailored to each person moreover primarily focused on CEO needs.
• Coordinated with offshore team in India on daily basis.
• Educated different user groups and peers with QlikView functionality.

Environment: QlikView 11.0 SR3, Windows Server 2003, Oracle 11g, MS Access 2005, MS SQL Server 2008, MS Office.

Confidential

Qlikview Developer

San Diego, CA

Responsibilities:

• Focused on Template Design UI-friendly and implemented section access using Windows NT authentication.
• Designed and implemented mapping tables to support data transformation during data load.
• Extensively utilized native QlikView functions within load scripts and charts to streamline application design.
• Designed (ETL) processes for extracting, transforming and loading vendor sales data into Oracle tables.
• Created a relevant data model and front end to satiate the requirements.
• Implemented section access to enforce row-level data security.
• Utilized alternate states to simplify application design and reduce on-going maintenance.
• Created trigger actions to provide custom functionality such as setting variable values and default filter selections.
• Written QlikView Scripts, macros, design Dashboard and Reports for different user groups
• Deployed the QlikView Application to the server and automated the jobs.
• Managed QlikView Licenses User CAL, Document CAL, Server Licenses, Publisher Licenses.
• Held weekly meetings to track progress along with to optimize efficiency.

Environment: QlikView 11, Teradata, SQL Server 2005, Oracle 10g, Access, .CSV Files, Windows 2003 Server, Sun one LDAP, SAP HRMS.

Confidential, Minneapolis, MN

Qlikview Developer

Responsibilities:

• Gathered requirement and functional knowledge from the business.
• Extracted data from various sources used ETL load scripts to manipulate, concatenate and clean source data.
• Designed and developed the Data mart for the QlikView dashboards in star schema/snow-flake schema. Identified various sources and designed the data transfer and transformations with in QlikView.
• Developed dashboard’s using different components of QlikView like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Created and managed ETL script generation using QlikView Script Builder Application.
• Participated in the UAT process along with business users and ensured an effective delivery of dashboard applications.
• Created tasks in Publisher for the application from making the QVD’s to the whole application reload.
• Upgraded QlikView Server from QlikView 9.0 SR3 to QlikView 10.0 SR3.
• Managed QlikView Server Licenses and User Licenses.
• Worked with QlikView administrator to optimize QlikView performance.
• Provided Production support to existing QlikView Applications.
• Trained the end users effectively to use the reporting tool.

Environment: QlikView 11, Oracle10g, Toad, Squirrel, Netezza, SQL Server 2005

Confidential, Newark, DE

QlikView Developer

Responsibilities:

• Extensively worked to confirm and clarify requirements and business logic.
• Analyzed the reporting requirements with the business users and came up with the technical specifications.
• Created Dashboards, scoreboards for the required KPI’s in QlikView.
• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Designed applications for to support the dashboard style of layouts using different components of QlikView like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Developed load scripts to work with multiple data sources (SQL, Oracle, Excel, and Oracle).
• Implemented the Incremental Loading feature in QlikView.
• Developed SET ANALYSIS to provide custom functionality in Qlikview Applications.
• Developed Macros, Set Analysis to provide custom functionality in QlikView Applications.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.

Environment: QlikView 11, Oracle10g, Toad, Squirrel, Netezza, SQL Server 2005

Confidential

QlikView Developer

Jersey City, NJ

Responsibilities:

• Clarified the requirements by talking to the user groups and accordingly modified the functional and technical specifications.
• Connected to Oracle using OLE DB and ODBC data sources connector and tables of SD, inventory, etc. to create and schedule adhoc reports by leveraging the basic components of QlikView
• Consolidated two existing QlikView Application.
• 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 the changes in Production to solve the issue.
• Handled other day to day Production server issues.

Environment: QlikView 9.0/8.5, SQL Server2005, Windows 2000 Server, oracle 10g, Microsoft Visio, QlikView Publisher, QlikView Server 9.0.

Confidential

BI Consultant/SQL Developer

San Diego, CA

Responsibilities:

• Analyzed and reviewed Business Requirement and Specification documents.
• Coordinated with business team to provide and receive feedbacks on the business requirements.
• Created Functional Design documents, and hold the reviews with business and IT team.
• Created SQL Server database to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, and optimization) 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.
• Individually designed MS SQL Server 2000 database, coded stored procedures (T-SQL).
• 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: Sql server 2000, Microsoft Visio, oracle 10g