SUMMARY

• 7 Years of total experience in IT industry with strong skills in QlikView, Business Objects, Database, Data Warehouse, Crystal Reports and Software development in .NET Applications.
• 3 + years of experience in analysis, designing and development of dashboards and reports using Qlikview 11.
• Extensive experience with QlikView sheet objects, scripting, and optimizing applications and building QVD’s and QVW’s.
• Developed and implemented best practices to resolve Circular Relationships and Synthetic Keys.
• Experience in loading data to QlikView from multiple data sources and data files.
• Experience in implementing Security in the QlikView application including the hidden scripts.
• Good knowledge and understanding of QlikView server, QlikView publisher.
• Hands on Experience with QlikView Architecture in development and deployment.
• Efficient in Optimizing, Debugging and testingSQL queries.
• Experience in using different databases likeOracle10g/9i, MS SQL Server, DB2 and MS Access.
• Experience in coding Web Forms, Data Controls, Validation Controls, and Web Controls using ASP.NET and C #.
• Strong background in Object Oriented programming and the ability to develop and support Applications in C#.
• Good understanding of Cascade Style Sheets(CSS) and client side VBScript, HTML, XML.
• Knowledge and ability to develop web - based applications using MS SQL Server2005 and 2008.
• Strong Knowledge and experience in all phases of Software Development Life Cycle (SDLC)
• Enthusiastic and Quick to learn new applications and tools and willing to take individual responsibilities.
• Good team spirit and organized working habits with a willingness to learn new concepts.

TECHNICAL SKILLS

BI Tools: Qlikview 9/10/11

Databases: Oracle 9i/8i/8.x/7.x, MS SQL Server 2005/2008, DB2, MS-Access

Languages: C,C++, C#, Visual Basic, PL/SQL, SQL, SQL*Plus, Unix Shell Script

Web Technologies: ASP.NET (3.0, 2.0, 1.1), Web Services, XML, HTML, JavaScript, AJAX.

Office Tools: MS Word, Excel, PowerPoint, Outlook

.NET Framework: 1.1/2.0 / 3.5

IDE: Microsoft Visual Studio 2005

PROFESSIONAL EXPERIENCE

Confidential, MA

QlikView Developer

Responsibilities:

• Interacted with the Business Users and Project Management for analyzing the business needs and develop Design Specification.
• Designed and analyzed on the Data sources to get the required metrics based on the KPI's.
• Created data models eliminating synthetic keys and circular reference loops.
• Created QVW to load the data from Source data files on a daily basis.
• Created dashboards by extracting data from different databases with multiple ODBC connections, stored data in QVD files, apply transformations based on the metrics needed and designed the UI based on business requirements on charts and graphs.
• Designed UI using different types of sheet objects like Bar chart, Scatter chart, Pivot and Straight tables.
• Implemented Incremental load Methodology in different scenarios.
• Designed different types of triggers at the sheet level and document level of dashboard.
• Extensively used Set Analysis on different charts for comparisons' and calculations.
• Implemented hidden scripts.
• Implemented Section Access in the application to prevent unauthorized access.
• Performance tuned SQL queries to improve build process on large amounts of data. Also helped business to improve the adhoc SQL process retrieval time.

Environment: QlikView™(11),SQL SERVER 2008, Oracle 11g, Db2,.XML Files.

Confidential

QlikView Developer

Responsibilities:

• Created multiple dashboards with multiple objects including the charts, graphs and tables like pivot pulling the data from different sources with ODBC connection.
• Created complex data models and improved performance by eliminating the synthetic tables and circular loop scenarios.
• Created Link tables combining the fact tables for better performance.
• Customized and tweaked the scripts for cross-tables and generic loads and created simple and complex expressions.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using QlikView Publisher and error notifications by email to assigned users.
• Optimized the load scripts and UI for efficient performance.
• Developed QlikView applications based on incremental Load Transactions using QVD Files.
• Developed concatenation method to solve circular loops issues.
• Performed various levels of internal testing and support in resolving QA defects.

Environment: QlikView™(9), SQL SERVER 2008, Oracle 11g, .CSV Files

Confidential, AZ

BI Developer

Responsibilities:

• Interacted with Business Users for requirements to develop and modifying Universes and Reports.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Applied security features of Business Objects like row level, report level & object level security.
• Created hierarchies for various reports based on the Business rule of the Organization.
• Troubleshoot and fix errors for reports, dashboards, and universes as per the business needs.
• Used Events for Daily/Weekly /Monthly Scheduling of the reports.

Environment: SAPBO XI, Universe, Oracle 9i, TOAD.

Confidential

Crystal Reports and PL\SQL Developer

Responsibilities:

• Responsible for Crystal Reports applicationdesign, code development and testing.
• Developed report design specification documents.
• Created Sub Reports, Cross Tab, Standard, OLAP and Master Detail Reports.
• Created various formulae, set parameters depending upon the selection criteria.
• Wrote PL/SQL stored procedures and triggers based on business rules and transformations.

Environment: Crystal Reports 10, Oracle 9

Confidential

Senior .Net and Crystal Reports Developer

Responsibilities:

• Developed web pages usingASP.Net,AJAXand class libraries usingC#.Net
• Developed web services using ASP.Net and hosted them in IIS.
• Responsible for creating reports using Crystal Reports and performed admin tasks related to users, groups, folders, and security using Crystal Management Console (CMC).
• Conducted discussions with BA and users to create test scenarios for running the reports.

Environment: .Net Framework 3.5(ASP.NET, C#), Oracle 9i, Crystal reports

Confidential

.Net Developer

Responsibilities:

• Prepared analysis and design documents, estimation for functional modules.
• Created Oracle Queries and store procedures for back end (Oracle 9i).
• Involved in working with Server sideState Management Techniques.
• Wrote several client side validation scripts.
• Designed and developed web services and middleware logic in C#.

Environment: Net Framework 3.5(ASP.NET, C#), Oracle 9i

Confidential

Crystal Reports/ .Net Developer

Responsibilities:

• Involved in requirements gathering, design, development, and testing.
• Worked withUser and Web Controls, Validation Controls, Server Controls, and Grid Views.
• Used Cascading Style Sheet (CSS) to attain uniformity through all the pages.
• Used master pages and themes to define the global look and feel of web application.
• Worked on reports that contained sub-reports (including drill-down sub reports). Handled both dependent and stand-alone sub reports.

Environment: Net Framework 1.1, SQL SERVER 2003

Confidential

Junior .Net Developer

Responsibilities:

• Responsible for requirements gathering, design, development, implementation and testing.
• Used C#.Net, ASP.Net for GUI design and business logic implementation
• UsedValidation ControlsinASP.NETand developed custom validation controls.
• Designed and developed Reports and created documentation for the application.

Environment: Net Framework 1.1, SQL SERVER 2003