SUMMARY

• Around 5 years of experience and expertise in working with Data Warehousing and business intelligence tools for developing various reports using QlikView BI & Qliksense.
• Strong experience in Scripting, developing and designing dashboards using QlikView by extracting data from multiple sources (Oracle, Hadoop, Flat files, Excel, Access).
• Expertise in QlikView 12.0 SR4, 11.0 SR5/SR12, 10.0 SR3, Qliksense (Using Extensions) installation and upgrading existing version.
• Expertise in designing in QlikView & Qliksense 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).
• Experienced in developing or utilizing the Extension objects for Qlik sense as per the user requirements and modifying the extensions using Java script and HTML.
• Experience with QlikView & Qliksense 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.
• Expertise in designing google maps in Qlikview and Qliksense using different extension objects like Idevio Maps, Qlik maps
• Experienced in developing heated maps, Line layer maps, Area Maps using conditional drill down operation (Country, State, city, zip code level) in both Qlikview and Qliksense.
• Implemented Best Practices & Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys in QlikView and designing an optimized Data model.
• Experience in creating ETL Applications for QVD's and QlikView Scripting variables and File, Date, System, Mapping, and Table functions.
• Knowledge in setting up QlikView architecture including QlikView server &publisher.
• A well-organized, goal-oriented, highly motivated effectual team member.

TECHNICAL SKILLS

Business Intelligence: QlikView 11/12, Qlik sense 3.1 SR2, Qliksense 3.1 SR4&SR6.

Database: Oracle 10g, MySQL, MS Access, Hadoop (JDBC & ODBC), Oracle

Languages: TSQL, PL SQL

Web Technologies: HTML, Java Script

Others: MS Office, MS Visual Studio.

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

QlikView & Qliksense Developer

Responsibilities:

• Project includes requirement gathering, architecture design, ETL process, Data Modeling, Frontend development and reporting using QlikView & Qliksense.
• Created Dashboard using different components of QlikView like list boxes, multi boxes, 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.
• Extracted information from disparate data sources like Excel, QVD, flat, XML files by using different ETL script statements like Resident, Join, Keep, Mapping Load, autonumber128, Interval Match, Info Load.
• Fine-tuning of code using SQL for back end process.
• Modified the Extension objects or developing extensions for Qliksense as per the user requirements and using Java script and HTML.
• 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 & Qliksense.
• Entitlement and data level security for dashboard using SECTION ACCESS.
• Used NPRINTING to enable schedule and automatically distribute reports to multiple users via email, google drive or to a folder.
• A map of the globe showing lines connecting origins and destinations representing shipments’ routes and numbers of shipments along the routes.
• Establish communication with higher management in manner that will optimize the project delivery time.

Environment: QlikView 11 &12 Qliksense 3.1 SR2, Qliksense 3.1 SR4, Hadoop, Windows XP, TSQL, XML, MS Visual Studio, Oracle MS Access 2007, MS Excel 2007.

Confidential - Deerfield, IL

QlikView Developer

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/Dash boarding.
• 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.

Confidential

SQL Server Developer/SSIS/ SSRS

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 Services, SSRS, SSAS, T-SQL, DTS, ETL, SQL Profiler, Windows 2003.