PROFESSIONAL SUMMARY:

• Over 7+ years of IT Experience as a Business Intelligence Developer involved in analysis, maintenance, production support and knowledge transfer with good analytical skills.
• More than 4 years of experience in Designing and Development of Business intelligence application withQlikView as BI tool.
• Experienced in importing data toQlikViewfrom databases, QVD files, text files and connecting to external data sources to generate different dashboard style reporting user interfaces.
• Experience in developing User Interfaces andQlikViewDashboards using Chart - Box(Drill Down, Drill up & Cyclic Grouping), List Boxes, Input Fields, Table Boxes, Calendars and Data Islands
• Hands on retrieving of external data from ORACLE, Ms access to QlikView Dashboard in terms of QVDs by making connection through ODBC and OLEDB.
• Good knowledge of Data Warehousing Models, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.
• Good working knowledge in Data Modeling including Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
• ExperienceinworkingwithQlikViewcomponentssuchasQlikViewDesktop,QlikViewEnterpriseManagementConsole (QEMC),QlikViewPublisher,Qliksence, QlikViewWeb Server and Ajax Clients
• Used advanced scripting, set analysis, VBScript and JScript macros, advanced aggregation functions and advanced charts for applications.
• Created QVD's & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Constructed SQL Server database objects (DDL) and implementing queries (DML) that perform the business functions of the database models.
• Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys & Modelling Issues.
• Exhaustive experience in Data Extraction and Transforming and Loading (ETL) using SQL Server Integration Services (SSIS) in MS SQL Server to import/Export data, Bulk insert and BCP.
• Excellent skills with expertise in Data design and analysis using Oracle 10g/9i, MS SQL Server Excel, PL/SQL.
• Good experience in design, development & administration for OLTP and OLAP systems
• Experience in Installation, Configuration and administration of TABLEAU Server in a multi-server and multi-tier environment.
• Experience in extracting Data from different sources like DB2, Oracle, SQL Server and integration of Hadoop, Teradata withQlikView.
• Strong Experience in working with Charts (Table Box, Pivot Tables, Straight Tables, Pie-Charts, Gauge-Charts, Trellis).
• Worked in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS).
• Experience withQlikView/QlikSenseobjects 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.
• Strong knowledge in developing highly informative dashboards usingQlikViewobjects like ListBoxes, MultiBoxes, Tables, Charts, Current Selection Boxes, Buttons, etc and variables, fields, calculated expressions, basic and aggregated functions.Good knowledge and understanding ofQlikviewServer,QlikviewPublisher andQlikviewEnterprise version.
• Strong Experience ofQlikviewSET analysis to Calculate, Aggregate the fact Data as per client requirements.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad-hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Designed and implemented proof of concepts for clients in the Healthcare, Automobile, Pharmaceutical, Financial and Manufacturing.
• Excellent analytical and teamwork skills. Team player with excellent verbal, written and interpersonal skills and capable of independent work with minimal supervision.

TECHNICAL SKILLS:

Business Intelligence Tools: Qlikview10 & 11, Qlik Sense, Business Objects 4.1,WebI,Crystal Reports XI/ 2008, Xcelsius, SSRS, Toad 9.0, QlikViewServer/Publisher 10 SR3

Languages: C, C++, COBOL, JCL, REXX, SQL, PL/SQL, PHP, Java, HTML, VB Script, Shell Scripting, SAP-ABAP

Database Technologies: Oracle 10g/11i, SQL Server, Teradata, Sybase, DB2, MS Access

Operating Systems: Windows NT/00/03/XP, UNIX, clones, Windows XP/ 2003

Domains: Manufacturing, Finance, Social Media and Communication

Data Modeling: MS Visio 2003, Erwin, SAS, EViews, Microsoft Excel, Matlab

Tools: MS Visual studio 2008, MS BIDS, Toad, Excel

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. QlikView Developer

Responsibilities:

• Developed dashboards pertaining to KPI monitoring using QlikView11.
• Implemented memory business discovery platforms with the help of QlikView and Qlik Sense.
• Created Dashboards usingQlikviewusing various components like List Boxes, Sliders, Buttons, variety of Charts, Book marks.
• Performed data analysis after conversion using procedures or functions in PL/SQL.
• Used SQL Developer for developing and managing PL/SQL scripts.
• Developed and maintained QlikView Load Scripts across multiple data sources.
• Created Ad hoc reports using Report builder 2.0/3.0 in SQL SERVER 2005/2008/2008 R2.
• Designed complex Data models using various databases, resolved Synthetic Keys issues.Installed and configured Governance Dashboards in order to optimize QVW.
• Development in the field of Database, Data warehouse and implementation of BI applications.
• Experience in usingQlikviewfunctions (AGGR, PICK, MATCH, Date and time, Keep, Join, Mapping)
• Responsible for developing and deployingQlikviewdashboards including Extraction, Transformation, Qlikmart and Presentation layers. Also managed dailyQlikviewjobs that update QVD and QVW files.
• Thorough understanding of Kimball/Inmon strategies, key performance indicators (KPI) Reportsand data mining structures SSIS \ QlikView Expressor 2.3\3.9 Experience \ Pentaho Kettle EDI 5.1.0\5.1.1\5.1.2. Prepared QlikSense proof of concepts as per the requirements and specifications.
• Strong Skills in Data Modeling such as Star Schema, Snow Flake Schema, Fact and dimensional tables. & Loading data from multiple data sources.
• Multiple levels of Hierarchies are implemented such as Human Resource, Business Development, and Project Delivery Hierarchy etc.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.Managed schedules and reloading ofQlikView(TM) data model QVDs and QVWs through QlikView(TM) server
• Accessed QlikView Expressor 2.3 production packages to Development server to keep sync between production and development up to date to maintain integrity.
• Involved in managing theQlikviewLicenses to the users (Named CAL, SessionCAL, Document CAL).
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing theQlikViewData Models.
• Constructed various graphs such as Straight table, Bar graphs, Pie charts, Line charts Gauge charts.
• Experience withQlikViewsheet objects including multiple charts types, Trends, KPI's, Custom requests for Excel Export, Fast Change and other objects for Management Dashboard reporting.
• Connected to various data sources like Oracle, SAP BW and flat files to create and schedule different complex reports.

Environment: Windows 2000 Server, QlikView 11.2, Oracle 11g, SQL Server 2005, SAP,MS Office, SAP Lumira MS SQL Server, Oracle Apps 11.5.3, Informatica 8.6, Oracle 10g, Windows NT & Sun Solaris

Confidential, Durham, NC

QlikView/Tableau Developer

Responsibilities:

• Maintenance of data in form ofQlikView data files, pulling the data from relevant database.
• DevelopedQlikViewDashboards using different Chart, Drill through, Cyclic Groups, List, Input Field, Table Box, Container.
• Created the reports using charts like Pie, Bar, Line etc. Charts are used in making reports more user-friendly in analysis purposes.
• Gathering data sources like QVD files, Excel, Cloudera HIVE, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing theQlikViewData Models.
• Strong knowledge of Qlikview SBS and Qlikview Enterprise architecture and building Qlikview reports by applying user preferences, business rules and database modeling methods and validations.
• Skilled in data visualization with an eye to simple and clear front end design - Familiarity with all visual options available, create complex visualizations for dynamic aggregation, Actions and Triggers. Good understanding of graphic design concepts.
• Strong knowledge on Qlikview server architecture and building QVD, QVW and applying business rules and data validations.
• Designed, implemented and tuned multipleQlikViewapplications for the Healthcare Operations.
• Created Dashboards style of reports usingQlikViewcomponents like List Box, Slider, Buttons, Charts, and Bookmarks etc.Lead cross-functional teams to design, build, and test deploy complex analytical solutions utilizing Qlikview.
• Installation of QlikView EXPRESSOR 2.3 i.e. Illustrator, constructor, Processor, Repository onDevelopment and production server.
• Developed ETL Processes using SQL Server 2008 Integration Services to migrate data from Oracle data source into a SQL Server 2008 database
• Experiencing sourcing data from disparate systems with a good understanding of their Data Models and ETL procedures.
• Work with project manager to ensure technical execution risks & issues are captured and mitigated.
• Performed GAP Analysis/Impact Analysis as AstraZeneca was changing their vendor from RxCrossRoads to CareMateX.
• Performed Reverse Engineering to identify Key Metrics utilized for development of Qlikview Dashboards.
• Developed Combiner to combine data from History data warehouse and current datamart. .
• Involved in creating adual-axis and dual mapswith multiple measures.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

Environment: QlikView 11.2, QMC, SQL Server 2008, Tableau Desktop 7.0 & 8.1 to 8.3 Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel, MS BI Windows 7, Windows Server 2008, MS Visio.

Confidential, Jersey City, NJ

QlikView Developer

Responsibilities:

• Developed a Star Schema Data Model that suits the business requirements by eliminating synthetic keys and circular loops.
• Developed Dashboard using Bar Charts, Line Chart, Text Boxes and List Boxes.
• Used Alternate States and Set Analysis to get the needs of the end users.
• Used QVD generator QVW file to create the QVD's. In the QVD generator file the data is imported from the SQL Server.
• Used Document level and Field level triggers based on the requirements.
• Good experience in using the QlikView functions (Trim, Match, Like, String etc.)
• Implementing the Section access to the application developed and then deploying it to the server.
• Involved in enhancement of existing dashboards with new functionalities.
• Involved in analyzing the existing data model, script logics and ETL logics for the existing dashboards
• DevelopedQlikViewDashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Performance tuning by analyzing and comparing the turnaround times between SQL andQlikView.
• Involved in Business requirement gathering and Participated in Joint Application Development (JAD) process with different Business Segments in designing QlikView Applications.
• Worked with business analyst to gather requirements.
• Extracted data from the SQL Server database wrote SQL load scripts and used joins to join the tables.
• Oversee the development of Qlikview applications
• Define and maintain architecture and development standards for the Qlikview environment
• Maintain and execute the technology roadmap for the Qlikview environment

Environment: QlikView 11, SQL Server 2005, Oracle 10g, Windows Server 2003, Windows XP.

Confidential, San Antonio, TX

QlikView Developer

Responsibilities:

• Read and gathered QlikView Planning requirements.
• Tested Applications, ensuring the application met the requirements, Data quality for Quality Assurance before delivering it to the end users.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.
• Implemented Star & snowflake schema (confirmed dimensions). Writing SQL Scripts to load the relevant Data inQlikviewApplications.
• Involved in Upgrade of SharePoint 2010 to SharePoint 2013, Requirement Gathering, analysis, design document, coding, bug fixing and release.
• Design, Build, Test, Debug theQlikviewapplication in QV Test server environment.
• Delivered advanced/complex reporting solutions such as Dashboards and Standardized reports utilizing QlikView 11.
• Enable the features that were requested by the Business Process Owners and also train them in better understanding of new features Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, charts and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Developed ad-hoc reports to see how revenue, cost and gross profit are doing against forecast budget vs actual.
• Experienced in usingQlikViewFunctions (Date and Time, Keep, Join, Mapping, String & Input Fields, etc.) for creating dashboards, and designing the User Interface based on business/user requirements.
• Implemented Star schema & snow flake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation and solved the loops issues.
• Gathered & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files).
• Implemented Incremental Load to improve Load Time.

Environment: QlikView9, Oracle 10g, Access, .CSV Files, Windows 2003 Server / XP

Confidential, Dallas, TX

QlikView Developer

Responsibilities:

• Analyzed the use cases given by the business analysts and developed test cases using them. Worked with the team lead to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that they are kept current.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Developed separate test cases for ETL process (Inbound & Outbound) and reporting
• Involved with Design and Development team to implement the requirements.
• Performed manual testing on various modules of the Application.
• Generates functional test cases that capture actual code behavior as a deployed application is exercised.
• Monitors test coverage and achieve high coverage using branch coverage analysis.
• Tests individual methods, classes, or large, complex applications.
• Tracks how test results and code quality change over time.
• Involved in Design and development of test plans based on high-level and detailed designs. Created various PL/SQL stored procedures for dropping and recreating indexes on target tables. Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• The EDW project aims at developing an Enterprise Data Warehouse for the claims Department.
• The project was designed using SQL, Pl/SQL, SAS, Mainframe, Teradata, and Oracle.
• Developed Test Plan, Test Strategy and Testing Scope Document.
• Conducted performance and load testing using Load Runner.
• Analyzed, reported and kept track of defects using Test Director.
• Provided testing results and weekly status report to the QA lead, provided test summary report once project was fully completed.

Environment: QlikView, Excel, MS SQL Server, Oracle 11g, PL/SQL

Confidential, Sacramento, CA

SQL/Tableau Developer

Responsibilities:

• Involved in creating a dual-axis bar charts with multiple measures, box plots, heat maps and background maps, trend lines statistics.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of repository.
• Tableau Worked on Datazen and had a good knowledge in creating the dashboard which best suites the requirement.
• Developed various dashboards illustrating data visualizations using Tableau Desktop.
• Proven experience in installation and maintenance of Tableau Server and administering users, user groups, projects and scheduling instances for dashboards in Tableau.
• Defined best practices for Tableau report development.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Developed Dashboards using calculated fields, parameters, sets and actions in Tableau.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different data sources.
• Understanding of relational database structures, theories, principles, and practices.
• Monitored Application Server and Tableau Data server activity to track performance and system availability.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Working on creating various dashboards in Tableau Desktop by querying various ODBC connections such as Teradata, Oracle SQL Developer, and SQL Server 2008.

Environment: Oracle 10g, TOAD, SQL Developer, UNIX, Windows XP,MS-Office Tools, Informatica 6.1, SQL, PL/SQL, UNIX, Shell Scripting, Manual Testing, Test Director, DB2, Oracle

Confidential

SQL BI (SSIS, SSRS) Developer

Responsibilities:

• Worked with various transformations like Lookup, Fuzz Lookup, Merge, Sort, Multicast, Conditional Split, Script Component, Loop Containers, Execute SQL Task and lot more using SSIS.
• Designed dynamic reports on the newly developed ERM Model for financial data users using SSRS.
• Involved in Performance tuning the SQL Server Queries used in SSRS Report and also used Report Snapshots for better performance.
• Worked with SSRS module to request data from output tables, design of report templates.
• Created user groups in Report Manager for limited access to the end users in SSRS.
• Closely worked with Data Quality team and Data Architects to identify bugs in the new Data Models and automated the Data Quality process which involved lot of T-SQL programming like Functions, User Defined Functions, Stored Procedures and Views.
• Created TABLEAU scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Involved in installation and configuration of SQL server 2008.
• Created SSIS Packages to load Data from Existing Data Model to new Data Model and Data Ware House
• Involved in designing complex packages moving data from various servers and environments using SSIS which also involved data from XML, Flat Files, CSV Files and SQL Server Databases.
• Performance tuning the SSIS Packages by understanding the Data Flow Buffers and by designing for parallelism.
• Scheduling the SSIS packages by creating a Job using SQL Agent in SSMS which involves nightly maintenance.
• Transferred CMC data between old (XIR2) and new version either through CMC/BIAR File/Import Wizard.

Environment: T-SQL, MS SQL Server 2008/2005, BIDS, SSMS, SSIS, SSRS, XML, OLAP, Cubes, Data-warehousing, SQL Profiler