SUMMARY

• 5 ½ Years of IT development experience.
• 3 years of experience working on Qlikview.
• Strong knowledge and experience in optimizing.
• Worked with Qlikview Hierarchies, Qlikview Architecture, ETL, Data - warehousing and Dimensional modeling.
• Involved in Requirement gathering & designing Qlikview applications.
• Gathering data sources like QVD files, Excel, Oracle, binary QVW, Inline and .txt files in developing the Qlikview Data Models.
• Experience in Scripting of QVW files.
• Extensive knowledge of all phases of software development life cycle. (Requirement Analysis, Design, Development, Testing and Documentation).
• Involved in troubleshooting issues and customizing reports as per the specifications of the analysts.
• Mastery of Qlikview charting; set analysis; reusability; leveraging variables and templates; and building/deploying section-access security models.
• Ability to write complex front end scripting or expressions.
• Hands on professional able to write complex front end scripts and expressions, data source integration and advanced GUI development in Qlikview.
• Strong knowledge on Qlikview server architecture and building QVD's and QVW's applying business rules and data validations.
• Any experience on Qlikview Extension objects would be plus.
• Advanced scripting and ETL, data modeling (star schema); Working with large data sets.
• Use of complex Qlikview functions and developing most optimal scripts for a given solution.
• Good knowledge of SQL, relational databases and Dimensional.
• Optimization of data model for performance.
• Creating complex expressions for dynamic aggregation.

TECHNICAL SKILLS

Databases: MS SQL Server 2008/2005, Oracle 10g/9i, My SQL5.0/4.1,MS - Access 2007.

Data Modeling: Dimensional Data Modeling, Logical and Physical data modeling.

ETL Tools: SQL Server Integration Services (SSIS), SQL scripts.

Languages: C, C++, HTML, CSS, JQuery, Java Script, T-SQL.

Operating System: Windows XP/2000, Vista, UNIX, Windows Server 2003.

Reporting Tools: Qlikview, SAP BI, and MS Excel.

PROFESSIONAL EXPERIENCE

Confidential, Bridgewater, New Jersey

Qlikview Developer

Responsibilities:

• Working as a Qlikview Developer in Business Intelligence department to design dashboards for the end-users.
• Implement SAP BW and other sources like .CSV, MS Access or MS Excel to extract the data to design Data Models in Qlikview 11.2
• Generated procedures, triggers and logic to make dynamic dashboards.
• Removed synthetic keys, ambiguous relationship and circular loops.
• Experience in designing different types of charts such as Bar charts, Line charts for Trend Analysis, Straight Tables, Pivot Tables, Pie charts etc.
• Prepared the technical manual for the end users illustrating the back end information regarding relative tables and fields based on the application they use.
• Solved issues regarding data on existing applications (.qvw) files.
• Created various Flags and KPI based on users requirements.
• Calculated Market TRX, Ratings etc. for various brands on the back-end based on each Territory and represented it on the front-end using dynamic charts.
• Implemented Section access and Hidden scripting for the Application Security
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Validated and tested many applications for performance tuning.
• Actively participated with PM and other team members to design POC and later implementing it to create dashboard.
• Created Data Island to create variables.
• Used QMC to create publisher task for data extraction, reload, Reduce and distribute applications.
• Actions and triggers, Document Chaining & linking experience.
• Knowledge to leverage mapping GIS providers in Qlikview for multi-layer maps (multiple metrics and dimensions overlaid on maps using extensions).
• Database Design and Performance Tuning.

Environment: Qlikview 11.2, Oracle, SQL server

Confidential, Cranbury, New Jersey

Qlikview Developer

Responsibilities:

• Designed, developed, validated and deployed application throughQlikview.
• Used various data sources like QVD files, Excel in gathering data to develop theQlikviewData Models.
• Was involved on modeling data as per business requirements.
• Dealt and eliminated synthetic keys, ambiguous relationship and circular loops.
• Knowledge of manyQlikviewFunctions (Date and Time, Keep, Join, Mapping, String & input Fields etc...) used in projects to create Data Models.
• Analyzed business data as per client requirement and Developed Dashboards.
• ValidatedQlikviewapplication at base level against QVD’s and Excel Test files.
• Implemented Security & involved in Deployment ofQlikviewApplication.
• Communicated and trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports and provide tech support when internal teams have enquiries.
• Performance tuning of dashboard by implementing best practices of Qlikview
• Design and develop user friendly application by providing apt graphs for the business requirement and reducing complexity in data model
• Writing SQL Scripts to load the relevant Data in Qlikview Applications and for testing the application data

Environment: Qlikview 11, Oracle, SQL server

Confidential, West Des Moines, IA

SQL Server Developer

Responsibilities:

• Developed SQL Scripts for creation of various Database Objects (Stored Procedures, Indexes, Triggers, and User Defined Functions).
• Developed complex queries using joins and sub-queries.
• Created multiple views and queries.
• Created Clustered index and Non-clustered for increasing performance.
• T-SQL programming, scripts, stored procedures, views.
• Practical understanding of theData modeling(Dimensional & Relational)concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Proven ability to transform business information into conceptual,logical and physical data modelspreferably in the financial industries.
• Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database (Text files and Excel files) to SQL Server.
• Involved in Performance tuning and Query Optimization.

Environment: SQL Server 2005,MS SQL MS Visio2005, MS office 2007, MS Project, Windows Server 2003, My SQL, MS-Access, MS Visual Studio 2005/2008, T-SQL, SQL Profiler, Management Studio.

Confidential, West Des Moines, IA

SQL Server Developer

Responsibilities:

• Participated in designing, coding, testing and implementing user interfaces, procedures and functions for new and existing software application requirements
• Responsible in writing the stored procedures, triggers and functions based on the business requirement
• Integrated Crystal Reports with SQL Server 2000 and Access databases
• Responsible for creating datasets using T-SQL queries and Stored Procedures
• Fine tuning the stored procedures and SQL queries for optimal performance by viewing execution plans, database tuning advisor and 3rd party tools
• Involved in database normalization and de-normalization for creating Data ware house
• Used SQL server agent for scheduling jobs and alerts
• Developed DTS packages to extract and transform data
• Created DTS package to get data from different data sources, consolidate and merge into one single source
• Used performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Responsible for creating and implementing logins and user permission to databases
• Created technical design document for the project
• Imported and exported flat files using Bulk Copy Program (BCP) extensively to/from SQL Server
• Implement different types of Replication Models like Transaction, Snapshot and Merge

Environment: SQL Server 2005,MS SQL MS Visio 2005, MS office 2007, MS Project, Windows Server 2003, My SQL, MS-Access, MS Visual Studio 2005 T-SQL, SQL Profiler, Management Studio.