SUMMARY

• Around 7 years of IT experience providing expertise in design, development and support of applications Windows environments.
• 3+ years of experience as a QlikView Developer.
• Skilled at developing reporting and data solutions.
• Expertise in working with Data Warehousing and business intelligence tools for developing various reports using QlikView BI.
• Experience in full life cycle project development, including design, coding, testing and implementation with ongoing product support.
• Strong analytical database design and Data Modeling (Star Schema, Snow Flake Schema) skills in QlikView.
• Experience in MS SQL Server (BI) and SQL Programming.
• Good Understanding of Relational and Dimensional Database Concepts.
• Excellent understanding of data warehouse specific Architecture, Design and Procedures, ETL and workflow development, data cleansing, data quality validation and unit testing.
• Expertise in QlikView 11.0 SR1/10.0 SR3 installation and upgrading existing version.
• Expertise in designing in QlikView with complex multiples data sources (SQL, Flat Files) relational designs and optimizing applications by using QVD's, removing non - key fields and script variables (Loading phase).
• Developed User Interactive Sheets & Reports as business needs.
• Developing SQL Scripts to load the relevant Data in QlikView Applications.
• Developed set analysis to provide custom functionality in QlikView Applications
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Data Island
• Experience with QlikView sheet objects including multiple charts types, Trends, KPI's, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI's.
• Experience in creating ETL Applications for QVD's and QlikView Scripting variables and File, Date, System, Mapping, and Table functions.
• Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise reporting architecture.
• Exceptional analytical, troubleshooting and communications skills to communicate directly or remotely with business partners/clients to identify key areas where Business Intelligence can solve business problems by delivering pertinent and timely information.
• A well-organized, goal-oriented, highly motivated effectual team member.

TECHNICAL SKILLS

Business Intelligence: QlikView 10/11

Database: Oracle 10g, MySQL, MS Access

Operating System: Windows 7/XP

Database: MS SQL Server 2005,2008,R2,2012, MS Access 2000, 97, Oracle

Languages: C, C++,TSQL, PL SQL

Web Technologies: HTML, Java Script

Others: Microsoft Products MS Word, MS Excel, MS Access, MS Power Point, MS Visual Studio, Visual Basic 6.0

PROFESSIONAL EXPERIENCE

QlikView Developer/SQL-BI developer

Confidential - Newport Beach, CA

Responsibilities:

• Project includes requirement gathering, architecture design, ETL process, Data Modeling, Frontend development and reporting using QlikView.
• Created Dashboard using different components of QlikView like listboxes, multiboxes, slider, buttons, charts (Bar, Line, Combo, Gauge, Scatter, Straight/Pivot table).
• Analyzing data on financial information using Dimensional-modeling techniques.
• Developed KPI’s to show YTD & LYTD, MTD, QTD, Current period, Moving Average etc… as per user input for From and To Date using Calendar object.
• Analyzed and developed best practices for data management and Extract, Transform, Load (ETL) processes from multiple data sources.
• Extracted information from disparate data sources like Excel, QVD, flat, XML files by using different ETL script statements like Resident, Concatenate, Join, Keep, Mapping Load, autonumber128, Interval Match, Info Load.
• Ranking of Top “N” Vendors & Revenue contribution Buckets by suppliers.
• Customized and tweaked the scripts for cross-tables and generic loads and created simple and complex expressions
• Establish communication with higher management in manner that will optimize the project delivery time.
• Fine-tuning of code using SQL for back end process.
• Providing analytical dashboards to Improving the cooperative’s efficiency, and Creative adhoc reports to expense department. Focus on Budget, forecast and variance.
• Drill Information by creating Groups/Cycles in QlikView.
• Entitlement and data level security for dashboard using SECTION ACCESS.

Environment: QlikView 11, Windows XP, TSQL, XML, MS Visual Studio, MS Access 2007, MS Excel 2007.

QlikView Developer

Confidential - New York, NY

Responsibilities:

• Designed different sets of reports and interacting with client for requirement analysis and delivery project of QlikView application.
• Creating QlikView applications for analysis reports from multiple data source.
• Maintenance of data in form of QlikView data files, pulling the data from relevant database.
• Process analysis and process mapping with respect to project.
• To supervise adhoc tasks sent by client.
• Contribute to high levels of professionalism and intellect necessary for continuous improvement of project.
• Dashboard analysis portfolio by profit low to high and doing research for poor performance for revenue growth.
• Developing adhoc reports analysis to see how revenue, cost and gross profit are doing against forecast, budget and actual.

Environment: QlikView 10.0, Windows XP, SQLS 2005/08, MS Visual Studio, MS Access 2007, MS Excel 2007.

QlikView Developer

Confidential - Deerfield, IL

Responsibilities:

• Imported data from multiple data sources including Web Services, MS SQL Server and MS Excel through OLEDB and ODBC connections and modeling data as per user requirements.
• Participate in enterprise DW / BI strategy/Dashboarding.
• QlikView 9.0 implementation and integration.
• Involved in utilizing QlikView solutions to develop complex reports and executive dashboard.
• Created Architectural Conceptual documentation and Technical Specification Documents.
• Creating complex data models without synthetic tables and circular loops.
• Developed QlikView applications creating expressions using set analysis.
• Created and scheduled Complex reports by leveraging the basic components of QlikView.
• Involved in organizing meetings to know the needs of clients for the Enterprise solution Implementation.

Environment: QlikView 9.0, Windows 2003 Server/XP, SQL Server 2008, MS Visual Studio, MS Access 2007, MS Excel 2007.

QlikView Developer

Confidential - Franklin Lakes, NJ

Responsibilities:

• Involved in business requirement gathering and development of functional and technical specification documents.
• Developed different dashboards with a complex database system behind it, which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView.
• Gathered & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files.
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Build reusable macros to control QlikView objects for ease of use by the users.
• Delivered advanced/complex reporting solutions such as Dashboards and Standardized Reporting using QlikView 8.5
• Implemented Star schema & snowflake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation and solved the loops issues.
• 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.
• Research and troubleshoot technical problems and provided ongoing Qlikview consultation to the development team.

Environment: Qlikview 8.5, Web Intelligence, Info View, TOAD, MS SQL Server 2005, Visual Studio 2005, T-SQL, MS Access, Windows XP/2003 server, HTML, VB Script & Java Script.

SQL Server Developer/SSIS/ SSRS

Confidential - Jersey city, New Jersey

Responsibilities:

• Developed T-SQL code for the application.
• Modified the existing database by adding the tables and maintained relationships between the tables.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like billing, customer, and requests from the residential, business and large business databases.
• Created SSIS Dynamic Packages using variables and deployed the SSIS packages.
• Implemented Incremental loads using different kind of tasks using SSIS.
• Used Event Handlers for Exception Handling in SSIS packages.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created, Managed and Support existing reports using SSRS.
• Involved in creating, deploying and configuring reports according to the requirements using SSRS.
• Developed different types of Tabular Reports, Matrix Reports, and Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Developed cubes using SSAS involving multidimensional data.
• Supported various sectors like Development, testing, Production, Maintenance and Application teams.
• Conducted performance tuning by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Executed Test cases manually Using Quality Center.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Managed requests that came from the development team.

Environment: MS SQL Server 2005, ASP.Net, Management Studio, BIDS, Visual Studio 2005, MOSS, Integration ServicesSSRS, SSAS, T-SQL, DTS, ETL, SQL Profiler, Windows 2003.

SQL Server Developer/SSIS/ SSRS

Confidential

Responsibilities:

• Developed T-SQL code for the application.
• Modified the existing database by adding the tables and maintained relationships between the tables.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like billing, customer, and requests from the residential, business and large business databases.
• Created SSIS Dynamic Packages using variables and deployed the SSIS packages.
• Implemented Incremental loads using different kind of tasks using SSIS.
• Used Event Handlers for Exception Handling in SSIS packages.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created, Managed and Support existing reports using SSRS.
• Involved in creating, deploying and configuring reports according to the requirements using SSRS.
• Developed different types of Tabular Reports, Matrix Reports, and Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Developed cubes using SSAS involving multidimensional data.
• Supported various sectors like Development, testing, Production, Maintenance and Application teams.
• Conducted performance tuning by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Executed Test cases manually Using Quality Center.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Managed requests that came from the development team.

Environment: MS SQL Server 2005, ASP.Net, Management Studio, BIDS, Visual Studio 2005, MOSS, Integration ServicesSSRS, SSAS, T-SQL, DTS, ETL, SQL Profiler, Windows 2003.