PROFESSIONAL EXPERIENCE:

• Over 8 years of experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence applications usingQlikview.
• Certified in both Qlikview and Qlik Sense.
• Strong knowledge in designing and developingQlikview and QlikSense dashboards by extracting data from different sources like Sales Force, SQL Server, Oracle, SAP, Flat Files, Excel files, XML Files.
• Worked installation & configuration, environment, system analysis, design, deployment, testing of projects.
• Experience in optimizing Qlikview and QlikSense applications to improve the performance.
• DevelopedQlikview and QlikSense objects like Multi Boxes, Straight tables, Pivot tables, Containers, Line charts, Bar charts, Combo charts, Scatter charts, Line objects, Pie charts, Buttons.
• Proficient in troubleshooting and fixing theQlikview and QlikSense dashboard issues.
• Extensive Knowledge in creating Excel reports, Word reports, PowerPoint reports using NPrinting designer and automating the jobs in NPrinting Server.
• Hands on experience in customizing theQlikview and N Printing reports as per the business requirements.
• Created incremental load process to load the data intoQlikview applications from different source systems.
• In - depth knowledge and understanding of data warehousing concepts, ETL, OLAP, OLTP, Cubes and normalizations to translate business requirements into TEMPeffective business intelligence solutions
• Involved in Performance Tuning and Deployment ofQlikview and QlikSense applications.
• Hands on experience inQlikview advanced features like Alternate States and Direct Discovery.
• Worked in Agile methodology environments and involved in scrum meetings.
• Experience onQlikview Scripting, Set analysis and Section Access.
• Scheduled the jobs and distributed to end users from QMC.
• Trained end users to develop and useQlikview and QlikSense applications.
• Involved in Onsite-Offsite coordination in delivering Business Intelligence Solutions.
• Understanding of data modeling, dimensional & relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables; experience in Extract, Transform and Loading process of data.
• Created detailed design, development, testing & migration documents and performing Proof of Concepts (POC).
• Delivered all the projects and assignments wifin the specified time lines wif accuracy.
• Strong ability to work wifin a demanding and aggressive project schedules and environments.

TECHNICAL SKILLS:

Dash boarding/Reporting/Analytical Tools: Qlikview 9/10/11, Qlik Sense, Tableau, NPrinting, BI Publisher

Languages: SQL, PL/SQL, python, Shell Scripting, Java scripting, HTML

ETL Tools: Informatica

Database Technologies: Oracle 9i,10g, My SQL, SQL Server 2005/2008, MS Access, Teradata, Sales Force

ERP: Oracle Applications eBusiness Suite (AP/AR/GL Modules)

Operating Systems: Windows (10, 7, XP, NT/2000, 95/98), Linux

Application Software: Adobe Works, MS-Office Suite

Source Control Tools: TFS, XIRA

PROFESSIONAL EXPERIENCE:

Confidential, Smyrna, GA

Sr Qlik Sense Developer

Responsibilities:

• Worked in a customer facing role interacting wif the customers regarding the business needs and Requirements.
• Strong in Requirements gathering, analyzing the Business process, generating Use Case models, Conducting Feasibility studies, Document generation.
• Designed different sets of reports and interacting wif client for requirement analysis and sent the reports to the off shore to develop Qlik Sense application.
• Created Logical and physical data model by analyzing the data and sent approve model to offshore to develop Qlik sense data model.
• Created end user manual in Qlik Sense and provided to the end users to supervise adhoc tasks sent by client.
• Created user level section access for the specified users.
• Contribute to high levels of professionalism and intellect necessary for continuous improvement of project.
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Experience in Using Qlik Sense Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc )
• Developed User Interactive Sheets & Reports as business needs.
• Developed SQL Scripts to load the relevant Data in Qlik View Applications.
• Developed Macros, SET ANALYSIS to provide custom functionality in Qlik View Applications.
• Enhance existing dashboards wif new functionalities and Tune ETL scripts for better performance.
• Research and troubleshoot technical problems and provided ongoing Qlik View consultation to the development team.
• Developed applications in Qlik Sense Desktop as well as in the Qlik Sense Hub and shared the apps wif the team through Qlik Sense Cloud.
• Enjoy collaborating wif users and halping shape up their requirements/ideas into beautifully constructed KPIs using the best of Qlik Sense features.

Environment: Qliksense 3.2, Qlikview 11.0, SQL, SSRS, QMC, SAP Crystal reports

Confidential, Seattle, WA

Sr QlikSense Developer

Responsibilities:

• Designed and developed Qliksense/ Qlikview applications from scratch, to support reporting and Business Intelligence initiatives.
• Collaborated wif business leaders to gather requirements and developed POC based on requirements.
• 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.
• Generate new QVD files created by ETL logic to feedQlikview applications.
• Created Dashboards style of reports usingQlikview components like List Box, Slider, Buttons, Charts and Bookmarks.
• Developed Variables, input boxes, extensively alerts and calendar
• Implemented Star Schema and Snowflake schema
• Developed Linked Tables, Concatenation (Resolving Loops & model ambiguity).
• Written complex expressions using Set analysis and variousQlikview /Qliksense functions
• Implement Actions/Triggers in theQlikview interface.
• Analyzed the existingQlikview data model and script logics for the existingQlikview applications.
• Used master calendar for time related dimensions and a strong source control methodology for tracking changes.
• Analyzed and developed Best practices for data management and Extract, Transform, Load
• Drill Information by creating Groups/Cycles inQlikview
• Involved in Deployment ofQlikview /QlikSense Applications into the server.
• Working knowledge ofQlikview Server,Qlikview Publisher, andQlikview Enterprise Version
• Mentoring Business User Groups.
• Entitlement and data level security for dashboard using SECTION ACCESS
• ImplementedQlikview dashboards distribution to business users using Section Access to dashboards, providing CALs to documents.

Environment: Qliksense 3.2,Qlikview 12, flat files, SQL Server, Oracle, Tera Data, MS Access 2007, MS Excel 2007

Sr Qlik Consultant

Responsibilities:

• Worked on requirements documents and design documents for the dashboards and reports
• Worked on dashboards for Sales force activities, Account calls, performance
• Created multi - layer data load scripts inQlikview.
• Wrote the extract layer, transformation layer and presentation layer scripts
• Had worked on conditional show for different charts and using buttons inQlikview.
• Created Master calendar for the Time dimension. Resolved synthetic keys, resolved loops
• Developed and designed the dashboards wif different types of charts inQlikview.
• Designed visualizations like bar chart, line chart, combo chart. Created Drilldown and Cyclic groups.
• Used Set analysis to perform data comparison for current vs previous years
• Involved in testing and code review.
• DeployedQlikview dashboard on the Server
• Managing and updating QVD files and dashboards. Interacting wif business users resolved user's queries.
• Created mockup dashboards on QlikSense to show how TEMPeffective it is in decision-making.
• Created maps using NPGeoMapQlikview extension object and for different regions along wif their sales.
• Worked on documentingQlikview environment

Environment: Qlikview 11.2, QlikSense,Qlikview Server/Publisher, Oracle 10g, MS-Word, MS-Excel, SEIBEL Compass system

Confidential, Bentonville, AR

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 11 implementation and integration.
• Involved in utilizingQlikview solutions to develop complex reports and executive dashboard.
• Created Architectural Conceptual documentation and Technical Specification Documents.
• Creating complex data models wifout synthetic tables and circular loops.
• DevelopedQlikview applications creating expressions using set analysis.
• Created and scheduled Complex reports by leveraging the basic components ofQlikview.
• Involved in organizing meetings to know the needs of clients for the Enterprise solution implementation.

Environment: Qlikview 11,Qlikview Publisher/Server, Windows 2003 Server/XP, SQL Server 2008, MS Visual Studio, MS Access 2007, MS Excel 2007

Confidential

Sr. BI Developer

Responsibilities:

• Created, manipulated and supported the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Documented the requirements and prepared various Business Requirement Documents.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Used stored procedures and triggers to implement business rules.
• Helped in integration of the front end wif the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Imported & Exported data from one server to other servers using tools like Data Transformation Services(DTS)
• Explored the use of User Defined Functions to encapsulate commonly used logic in the stored procedure and maximized the readability of such Stored Procedures.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.
• Performed daily database backup & restoration, monitored the performance of the Server.
• Handled development and production support, document reviews, test plan, integration of the system.

Environment: SQL server, Jupiter, Windows NT, UML, DTS, Query Analyzer, SQL Profiler