SUMMARY

• Around 7+ years of total IT industry experience analysis, design, testing, development and implementation of client/server applications.
• Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance using Qlikview. Good at working wif Data Warehousing and business intelligence tools for developing various reports using QlikView BI.
• Expertise in Installing and Configuring Qlikview Desktop, Qlikview Server and Qlikview Publisher.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Interacted wif Customers for requirement gathering and TEMPeffective analysis.
• Good experience in design, development & administration for OLTP and OLAP systems.
• Extensively worked on Framework Manager for creating Models and creating different layers (Database Layer, Presentation Layer).
• Importing Metadata from different data Sources, creating dimensions and hierarchies, determinants using Star Schema Grouping.
• Strong experience in design, development and deployment of dashboards from various data sources using QlikView.
• Strong knowledge in UI design using sheet objects like Multi Boxes, Tables, Charts, Containers, Custom objects, Extension objects and experience in editing scripts for creating variables, fields, and calculated expressions, basic and aggregated functions.
• Experience in optimizing existing QlikView reports wif a focus on usability, performance, flexibility, testability, and standardization.
• Experience in creating QlikView Access point for Client application rollout and administrator security by AD group using QlikView Publisher.
• Design of QlikView applications using QlikView Data (QVD) files, different Databases and creating reusable variables.
• Trained the end users TEMPeffectively to use the reporting tool (Qlikview), to build and customize their ad - hoc reports.
• Ability to work in tight schedules wif high quality and efficient in meeting deadlines.
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back-end testing.
• Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception ability to quickly master new concepts and capable of working in-group as well as independently.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.

TECHNICAL SKILLS

Reporting Tools: QlikView 9.x, 10.x, 11.x seriesLanguages C, Visual Basic, Unix Shell scripting and SQL

Databases: Teradata, DB2, MS SQL Server 2012 and Oracle

Tools: / Utilities: Pg Admin, TOAD, Visio, Jira, Wiki

Operating System: UNIX, Linux, WINDOWS NT/XP/7/2008 server

Software Development: Agile Methodology

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

Sr. QlikView Developer

Responsibilities:

• Requirements gathering from the business and application teams
• Analysis of requirements and preparation of design documents.
• Design and development of data movement and reporting applications
• Code review / testing of applications and Project status tracking.
• Involved in Sprint planning meetings using Agile Software Development.
• Code deployments from development to stage and production environments
• Involved in Scrum calls daily wif architects, designers, developers, QA and the customer/users.
• Creating Qlikview Applications using QVD files from user analytical/Business purpose.
• Served as Qlikview application developer for various ad-hoc analysis requests.
• Designed data models based on the client requirements and wifout any ambiguous or Synthetic tables.
• Stored the tables as QVDs and used Scripts to generate appropriate fields dat halp in modeling the data according to the requirements.
• Worked on tuning of SQL‘s.
• Design one global distribution dashboard which has all the information in one single place.
• Re-use the existing QVDs, new tables as QVDs and scripts to generate appropriate fields dat halp in modeling the data according to the requirements.
• Design of complex charts and trends which will provide Year on Year, Month on Month and Week on week analysis.
• Involved in testing the reports and enhanced the performance of the reports by writing Complex SQL queries
• Design dashboard using the various sheet objects Current selection, list boxes, search, Straight table, Pivot table, Bar chart, Line Chart, Pie Chart, Combo chart and so on.
• Demo of QlikView dashboard to users to enhance their knowledge on all the key capabilities of Distribution QlikView application
• Worked on Automation & scheduled QVW document refreshments using Qlikview Publisher and use of external OPSWISE tool as a scheduler.

Environment: QlikView 11.2, SQL Server 2008, DB2, SAS, Microsoft SharePoint.

Confidential, Houston,TX

QlikView Developer

Responsibilities:

• Participating in Data ware house, business requirements and design review sessions.
• Imported data from SQL server through OLEDB connection and modeling data as per user requirements.
• Creating data models wifout synthetic keys and circular reference loops.
• Creating dashboards by extracting data from database write and externalise the load scripts, store the data as QVD files and designing the UI based on business/user requirements.
• Designed UI using different types of sheet objects like Pivot table, Straight table, Bar chart, Scatter chart, Containers, Mini-Charts & QlikView Extension objects.
• Use of Set analysis and aggregation functions for sheet objects.
• Created macros in VBScript to meet the business requirements.
• Application performance enhancements by optimizing load script, expressions and UI.
• Installed and upgraded the QlikView Server/Publisher, QlikView Access Point, Qlikview Web parts for SharePoint from v9 to v10
• Maintaining permissions, schedule reload tasks, check performance and audit logs in QlikView Server.
• Monitoring QlikView Server/Publisher daily tasks.
• Tuned SQL queries and performed code debugging using SQL Navigator.
• Design and implementation of development standards for QlikView environment.
• Design and develop testing report modules prior to QA submission.
• Performed internal testing and support in resolving QA defects.
• Providing UAT group support/training.
• Go-Live Support.

Environment: QlikView 10 (SR3 & SR4), QEMC 10, SQL Server 2008, Microsoft SharePoint, VB Script, JIRA.

Confidential, Atlanta, GA

QlikView Developer

Responsibilities:

• Worked wif Business Users for requirement gathering and passing on the information to team.
• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Connected to Oracle using OLE DB and ODBC data sources connector and tables of SD, inventory, etc. to create and schedule ad-hoc reports by leveraging the basic components of QlikView.
• Extracted data from various sources (SQL Server, Oracle, text files and excel documents), used ETL load scripts to manipulate, concatenate and clean source data.
• Created and managed ETL script generation using QlikView Script Builder Application.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView.
• Created dashboard style of layouts using different components of QlikView Enterprise like List-boxes, Multi-boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Presented QlikView applications to various levels of user.
• Designed application for Sales & Marketing Modules dat Generates GUI Report for easy access through the data.
• Worked wif QlikView administrator to optimize QlikView performance.

Environment: QlikView 9, Teradata 13, Oracle, SQL Assistant, HP Quality Center 10.

Confidential

Report Developer

Responsibilities:

• Involved in a team in designing the database schema for the metadata for storing the informative queries dat are generated dynamically.
• Involved in creation of schema objects like tables, indexes, views, stored procedures, functions, triggers and synonyms.
• Tuned SQL queries and performed code debugging using SQL Navigator.
• Involved in testing, Code Walkthroughs and Reviews.
• Managed space, users, database objects, profiles and security.
• Involved in testing the database for the queries dat are generated and handled the performance issues TEMPeffectively.
• Involved in documenting the entire technical process.

Environment: Oracle 9i, SQL, PL/SQL, SQL* Loader, Toad, Windows NT.

Confidential

Report Developer

Responsibilities:

• SQL Development & Troubleshooting included file groups, data access, ODBC, indexes, stored procedures, triggers and table structures for application behavior manipulation.
• Created numerous simple to complex queries involving self joins, correlated sub queries and XML techniques for diverse business requirements
• Tuned and optimized queries by altering database design, analyzing different query options and indexing strategies
• Created Stored Procedures, triggers, views, tables for data manipulation & reporting
• Performance Monitoring, tuning and enhancing of SQL databases and objects
• Developed Indexes, Views, and Synonyms for the huge tables in the database
• Implemented Import/export for schema level and table level data
• Good Knowledge on Dimensional Data Modeling Concepts

Environment: SQL server 2005, SQL Scripting, PL/SQL, UNIX Shell Scripting, TOAD