SUMMARY:

• Over 7.5 years of IT experience in the field of Information Technology with experience in implementation of all phases of Data warehouse development lifecycle, from gathering, Planning, Analysis, Design, Implementation and Maintenance using Qlikview.
• Implemented the 3 - tier architecture (Data-Extraction, Data-Modeling and Application Development) as recommended in QlikView best practices guide.
• Designed and developed state-of-the art Qlik Sense Applications / Dashboards.
• Hands on experience in implementing the new features of Qlik Sense like Pivot table, KPI Object, PDF Printing etc.
• Performed POC on Qlik Sense to generate immediate analyses and insights for reporting from mobile platform.
• Developed different apps for Qlikmap (Points and Polygon), Extension objects to let the user to explore best features in Qlik Sense and to compare with QlikView.
• Good experience in performing detailed data analysis/data profiling (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples).
• Ensured a focus on data quality by developing data standards such as a common business vocabulary, naming conventions, data standards and transformation rules.
• Strong Knowledge in designing and developing Data marts, Data Warehouse using Multi-dimensional models such as Snow Flake and Star Schema. Expertise in Analytics and Data Visualization techniques.
• Imported data from different sources like Oracle, MS Access, XML files, QVDs and flat files using OLE DB/ODBC/ and deployed the application on QlikView server.
• Good understanding with QlikView administration at the enterprise level which includes migration of QlikView Servers / publisher to higher version, enterprise turn request, maintenance of QlikView Servers, clustering of servers, developing QlikView dashboards for QlikView administrative purpose.
• Expertise in designing efficient Data-Models from multiple data sources and QlikView scripting.
• Proficient in design and development of various Dashboards using chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box, Containers and Calendar & Date Island.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input Fields.
• Created QVD’s& updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.
• Worked on BI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
• Implemented Incremental ETL to handle high, historical and incremental volume of data, resolved Circular Loops, Synthetic Keys.
• Experienced in Data visualization reporting tool Qlikview 9, Qlikview 10 and older versions of QlikView Enterprise software.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Business Analysis experience with broad understanding of business operations.

TECHNICAL SKILLS:

BI Tools: Qlikview 11/11.2, Qlikview 10, Qlik Sense, and older versions, Tableau, Informatica

Tools: Erwin 4.0/3.5, MS Visio, Share point, GIT

Databases: MS SQL Server, MS Access, Oracle and DB2, Hadoop

Web Technologies: HTML, XML, ASP, Java Script, VB Script, Servlets, JSP

Languages: Java, SQL, Hive

Operating Systems: Windows 95/98/XP/NT, UNIX (Sun Solaris), Linux

PROFESSIONAL EXPERIENCE:

Senior Qlikview Developer

Confidential, Bellevue, WA

Responsibilities:

• Developed applications in the desktop as well as in the Qlik Sense hub and shared the apps with the team through Qlik Sense Cloud.
• Developed dashboard extensions for Qlik Sense using JavaScript.
• Designed and developed state-of-the-art Qlik Sense Applications. Developed ETL Scripts in Qlik Sense while loading the data.
• Developed Dashboards for various global teams, and entirely involved with design and development of performance appraisal dashboards and traceability matrix for the support teams using Qlik Sense.
• Developed applications in the desktop as well as in the Qlik Sense hub and shared the apps with the team through Qlik Sense Cloud.
• Worked as Qlikview developer role in creating interactive dashboards and scorecards.
• Developed different user interactive dashboards with complex source systems by extracting data from the database, storing into QVD files, writing complex ETL scripts and developing UI according to business requirements.
• Worked on incremental load for millions of daily data for Fact tables.
• Implemented Sheet level and row level section access by Active Directory Group.
• Implemented version Control by integrating Microsoft TFS with Qlikview.
• Loaded multiple custom images into the dashboard by using binary function.
• Worked on Extensions and implemented session timeout for every 20 mins.
• Involved in Pen testing and performance testing of Qlikview Dashboards.
• Worked on complex data models and various enhancements and involved in production support.
• Produced scripts to cleanse source data, ETL process (Extract, Transform & Load) data with business rules, and built re-usable Mappings.
• Involved in migration to Qlikview latest version and supported various dashboards across the enterprise.
• Used Complex Qlikview functions like peek, generic load, applymap, wildmatch, keepchar, Rangesum, Valuelist etc. and implemented partial reload for certain tables.
• ICRR dashboard helps users to analyze the key metrics like Exposure, RWA, EC, and EL across multiple branches and demonstrates the ratings given by multiple customers.
• Worked on link table scenarios and implemented Star Schema Data model.
• Worked on PDF Distribution of reports by using Qlikview Publisher.
• Generated PowerPoint Reports by using NPrinting tool by scheduling on a weekly basis.
• Used Citrix Tidal Scheduler for Scheduling jobs.
• Worked on N-Tier Dashboard which helps the bank to analyze reconciliation across multiple hops or stages and determines the status on a given day.
• Took responsibility in delivering various production fixes and also involved in Admin activities.
• Used Qlikview Server agent to start and stop all the Qlikview services in server and usage of Qlikview Super Server Agent for identifying errors in server.
• Implemented Qlikview Licenses (LEF) and taking backups of PGO files in the servers.

Environment: Qlikview 11 SR12, SR8, Qlik Sense, Share Point, BO 4.1, OBIEE 11.2g, Tidal, Microsoft TFS.

Senior Qlikview Developer

Confidential, Raleigh, NC

Responsibilities:

• Played Qlikview developer role in gathering business requirements and developed interactive dashboards.
• Worked on existing Global interactions dashboard which is used by the Global Legality Management Team to exclude some of the interactions and worked on improving the performance of the dashboard.
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Produced scripts to cleanse source data, ETL process (Extract, Transform & Load) data with business rules, and built re-usable Mappings.
• Worked on Client Analyst dashboard to separate clients that have interactions which they primarily focused on.
• Worked on Key penetrating key accounts dashboard which requires high prioritization clients that have ranks in according to their analyst performances.
• Worked on the Global Coverage dashboard which shows their credit and Equity Coverage distribution across various regions.
• Used Complex Qlikview functions like apply map, lookup, keep char, previous, aggr, first sorted value, date and time functions etc.
• Global Coverage Dashboard helps the user to identify analyst who covers specific tickers. It also shows the ratings distribution across different regions. This Global Coverage Dashboard will also provide a detailed look at GIRs current and historical coverage position in Equity Research, Credit Research as well as Sustain - highlighting both company coverage numbers as well as company ratings information.
• Worked on performance issues related to the readership dashboard which gives information regarding the publications that are published.
• The Global Readership Dashboard will provide insight into Readership, Consumption and Distribution of firm’s Global products. Highlights included are Top Publications, Top Readers, Top Authors, and Top Clients.
• Worked on Google maps extensions on the global coverage dashboard to show their current locations.
• Helped in centralizing the data models for the existing dashboards and debugged the errors in the code.

Environment: Qlikview 11 SR1, Share Point, GIT 1.8.3

Qlikview Developer

Confidential, NYC, NY

Responsibilities:

• Involved in gathering & Analyzing business requirements.
• Designed ECD Convergence Dashboard which gives user to rate customer and their status.
• Implemented Star schema data modeling, Removed complex synthetic keys in the existing data modeling of various dashboards.
• Worked extensively on the SQL Server/MYSQL databases and imported SQL scripts into Qlikview.
• Implemented best practices of scripting and ensured that QV can handle millions of data without performance issues.
• Ability to write VB script macros whenever required.
• Implemented security using section access that dynamically hides selected areas of the dashboard depending upon user privileges.
• Implemented Sheet level security to limit access based on user groups.
• Dynamically show/hide sheets, handled Null Values.
• Developed Macros which facilitates user to export large volume of data into Flat Files.
• Worked on complex aggregate functions and gave the desired output across the combinations.
• Created optimized QVDS which loads faster and helps to improve the performance.
• Experience with Qlikview functions like fabs, peek, previous, is null etc.
• Created pop up text box on button click which will prevent it working where user can navigate to that sheet only after making required selections in that page.
• Worked on enhancements and Performance tuning on existing dashboards.
• Provided User meetings and training on Qlikview Dashboard functionalities.

Environment: Qlikview 11.2, SQL server, Oracle, MY SQL, Toad, SQL Developer, Putty.

Qlikview Consultant

Confidential, Bellevue, WA

Responsibilities:

• Worked with the business units, identified and resolved the existing issues.
• Developed reports by connecting to Hadoop by using Cloudera connector which pulls data from the Hadoop into Qlikview.
• Proposed solutions such as incremental Qvds which helps to optimize the load on the database when there is a limit for 10 million rows.
• Automated various dashboards, publishing them to the server and also proposed best practices for the server installation.
• Developed SQL scripts and made required modifications to function in Hadoop Environment.
• Worked on Hive/Hue and tested various scripts in Hadoop before getting them into Qlikview.
• Worked on setting up the email alerts in the dashboard without pointing to server by writing a macro script.
• Proposed a solution for the date range issue where user wants to see only one week of data on default upon opening of a dashboard.
• Modified the scripts in DB2 which reduces the load on the database and optimized the performance.
• Imported data from different sources like DB2, SQL, and Hadoop.
• Added dimensions to the existing SEO dashboard which resulted to show and compare W/W (week over week), Y/Y (Year/Year) analysis by writing set analysis.
• Trained end users on using Qlikview.
• Experience in using Qlikview Functions (Date and Time, Keep, Join, peek, Fabs).
• Good experience in performance tuning and deployment.

Environment: Qlikview11/11.2, SQL server, DB2, Toad for DB2 5.0, Tableau 8.0, Hive 0.8, Business Objects 4.0

BI Consultant

Confidential

Responsibilities:

• Performed the setting up, installation and configuration of the OBIEE and the required connectivity for seamless integration with the data warehouse.
• Analyze, Design, and Develop OBIEE/Siebel Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer (Semantic Layer), and Presentation Layer.
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports) by adding in extended columns.
• Customized the Sales Branding, Customer Service dashboard by adding in new products and Finish Sales Trend Dashboards.
• Developed HR intelligence Dashboards, used KPI’s which provides powerful metrics, Alerts and reports to HR professionals and line managers, enabling them to understand how workforce factors are affecting individual departments and take appropriate actions.
• Modified Pre-built OBI Applications dashboards, Answers, Repository for Sales, Finance, Inventory, Supply Chain, Expenses and Order Management Analytics.
• Created MUD (Multiple user Development) environment by utilizing projects.
• Implemented comprehensive security functionality by creating users & web groups, setting up LDAP (ADSI) authentication and associating catalog objects and Web modules with the created users and groups.
• Performance Tuning through aggregation strategy, caching schemes and usage tracking.
• Analyzed Reports and resolved Data Issues Related to Reports.
• Created Time Series Objects, Hierarchies, Level Based Measures.
• Developed many Ad-hoc and standard Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Implemented Security/Access privileges by creating roles & web groups, checks with External tables.
• Built the applications in order to track predefined KPI’S (Key Performance Indicators).
• Developed many incremental ETL using Informatica mappings & Oracle PL/SQL procedure.
• Integrated BI Publisher with Oracle BIEE and used to create highly formatted reports by using Oracle BI Answers and Oracle BI server Metadata.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality. a

Environment: Qlikview 8, OBIEE 10.1.3.4.1 , Oracle Apps 11.5.3, Informatica 8.6, Oracle 10g, Windows NT& Sun Solaris.

Report Developer

Confidential

Responsibilities:

• Performed GAP Analysis to gather functional mapping by coordinating with the Business Users to gather the data required for analysis.
• Presenting the information to Business user, by identifying appropriate source of data from FDR system.
• Involved in flow chart design and prepared case diagrams using Visio. Developed Store procedures, triggers, and packages for Oracle 8i database.
• Performance tuning of SQL queries and stored procedures.
• Developed and implemented various enhancements to the application in the form of production and new production rollouts.
• Prepared the Database Design, Technical Design (Low level Design) of some modules based on the approved functional design document.
• Enhanced the physical data model using Microsoft Visio.
• Created database links to transfer data from one database to another.
• Performed tuning and optimization on SQL queries.
• Developed automated Korn shell scripts to schedule the loading of flat files.
• Used composite partitioning schema (Range-Hash partitions) to partition very large transaction tables, range partitioning and hash sub-partitioning.
• Developed SQL scripts using Sybase to perform data retrieval for a range of business criteria’s.
• Produced scripts to cleanse source data, ETL process (Extract, Transform & Load) data with business rules, and built re-usable Mappings.
• Devised the test strategies and prepared the unit test plans.
• Used Remedy to log the design defects, bugs or review defects.

Environment: Oracle 9i, PL/SQL, SQL server, Windows 2000, UNIX.