SUMMARY:

• Around 6 years’ experience working in IT Industry with 3 years’ experience as SQL/ETL developer 3+ years of experience in development and implementation of Qlikview and Qliksense applications.
• Expertise in technologies like Data Warehouse (DWH), Data Visualization and Business Intelligence Concepts and BI Tools.
• Experience with QlikView sheet objects including multiple charts types, Trends, custom requests for Excel Export, Fast Change and other objects for Management Dashboard reporting.
• Experience in Tableau desktop, Tableau server and tableau reader.
• Worked on Informatica tool Source Analyzer, Data Warehousing designer, Mapping Designer, Workflow Monitor, Workflow Manager OBIEE,and Repository Manager.
• Expertise in extraction data and creating reports for data from various Data Sources like Excel Files (.xls), CSV Files(.csv), XML Files(.xml), MDB Files(.mdb, .accdb), Oracle 11g, SQL Server 2005/2008, DB2 9.7 Database and other Databases.
• Experience in Designing and Development of Business Intelligence application with Qlikview.
• Having good Knowledge on Qlikview Desktop, Qlikview Server, IIS Server.
• Expertise in Qlikview Scripting.
• Developed business intelligence solution using dashboards, alerts, queries and reports.
• Proficient in Software Development Lifecycle (SDLC).
• Experienced in various types of BI methodologies.
• Expert in implementing Section Access and Data reduction techniques.
• Expertise in Business Intelligence (BI)/ data warehouse (DWH) concepts, designs, SSRS/SSAS, and project implementations.
• Good knowledge of data warehouse (DWH) Models, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.
• Created very good data models in QlikView for report development.
• Developed enterprise applications for use in production environments using QlikView.
• Hands on installing, using and troubleshooting various software applications.
• Good knowledge on C, C++ programming language, DBMS, RDBMS and Visual basic concepts.
• Experience in integrating the QlikView application with Salesforce, SAP Connector etc.
• Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys in QlikView and designing an optimized Data model.
• Experience in using all Microsoft Office Tools like MS Excel, MS Word, and MS PowerPoint.
• Proficient in SAS/Base, SAS/Macro, SAS/SQL, SAS/Connect, SAS/STAT, SAS/Access, SAS/Graph, SAS ETL studio
• Hands - on experience across all stages of Software Development Life Cycle (SDLC). Including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Experience on retrieving of external data to Qliksense Dashboard in terms of QVWs, QVDs connecting to ODBC and OLEDB.
• Expertise in creating ETL applications for QVD’s and QlikView Scripting variables and File, Date, system, mapping and table functions.
• Deployment and administration of production QliKView reports and environment using QlikView Management Console and QlikView Access Point.
• Hands on experience on Tableau Server administration including cloud based services.
• Able to work independently has a good interaction with team members.
• Good at understanding the client requirements and giving best solutions.

TECHNICAL SKILLS:

Tools: QlikSense, Qlikview 10 &11, Publisher, Enterprise Management Console, Management Console, QV Ajax Client, QV IE Plug-In.

ETL Tools: QVExpressor,Informatica.

Web technologies: HTML, CSS, XML, Java Script/Jquery

Languages: Java, C, C++, TSQL, PL SQL, SQL, VB-Script

Operating System: Windows 2008, windows 2003, XP.

Database: Oracle 9i/11g, SQL Server 2008/2010, MS Access 2000, Teradata, Sybase, DB2.

Others: SQL management studio, Visual studio, SAP, BIDS, Microsoft Products MS Word, MS Excel, MS Access, MS Power Point, Apache Tomcat 5.0, Visual Basic 6.0,Jmeter, SSIS, SSRS,Cognos, Visio, SQL Developer, SQL Tools, Automate MS Office.

BI Tools: Business Objects 4.1, WebI, Crystal Reports XI/ 2008, Xcelsius, Toad 9.0, Tableau 9.0/8.x

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX

Sr. Qlikview Developer

• Designed, developed and deployed QliKView dashboards, scorecards, KPI and other reports using all the charts and GUI features available in QliKView.
• Developed a very complex dashboard in QliKView 10 with QVD creators, Aggregated Model QVD Creator and stored the data in to QVD’s.
• Experience on testing the dev and QA servers and having a good knowledge on QV publisher and Access point.
• Understand the requirements to plan, define and clarify dashboard goals, objectives.
• Developing the dashboard in front end UI designing.
• Creating stories by using Qliksense.
• Performed data visualization by using Qlik Sense
• Involved in QlikView BI/DW design, dashboard and KPI metrics design, data modeling, QlikView SAP integration, QlikView scripts development, QlikView Set Analysis, and QlikView Server/Publisher setup/configuration.
• Worked with cross functional team and business user to develop Business requirement document (BRD), define key performance indicators (KPIs) and identify data sources.
• Developed strategy maps and roadmaps for delivering Data Analytics and BI Reporting using QlikView
• Designed and developed QlikView software applications and server-based QlikView dashboards from scratch to support BI initiatives.
• Hands-on experience in setting up new task and troubleshooting existing task setup and other issues.
• Expertise in writing Macros VBSCRIPT in Excel and Qlikview.
• Designed and integrated data from different types of data sources.
• Expertise in designing layouts, Mapping Tables, adding different types of colors to represent the data in UX design.
• Providing Security for the developed dashboards by using section access.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Created custom reports for our inventory tracking system using SAP Crystal Reports.
• Design, and develop SSIS packages, Tables, Stored Procedures, Triggers, and Indexes using Microsoft SQL Server. Design dimensional model for SSAS to de-normalize the OLTP database.
• Prepared complex SQL/R scripts for ODBC and Teradata servers for analysis and modeling.
• Coding to enable the mapping of various data extracts/data sets (excel, .csv, .txt, Teradata, etc.) to a new standardized SAS dataset.
• Designed and developed dashboards in Qliksense.
• Created KPI dashboards in Qliksense
• Designed and developed BI Reporting solution enabling users to effectively utilize the tools to create Analytical Reports, Dashboards, and Scorecards, helping clients align KPIs performance metrics to strategic drivers and priorities.
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Created automatic schedulers to reload the data as per requirements.
• Developed predictive analytics and forecast models to help clients gain deeper insights on existing data and information, improve business performance, and shape the future of the companies.
• Extract, transform, cleanse, and load (ETL) data into Microsoft SQL Server, Staging Databases using Microsoft SSIS.

Environment: QlikView, OBIEE, Informatica, QlikView Server and Publisher, QlikView Developer, Real-Time BI Analysis, Microsoft SQL Server, Tableau, SSIS, SSRS, Oracle Database, SAP Business Objects, Crystal Reports.

Confidential, San Francisco, CA

Qlikview Developer

• Created various tasks in QlikView Management Console (QMC) and managed their schedule dependency to ensure the data gets refreshed in a timely and accurate fashion.
• Designed and developed the Data mart for the QlikView dashboards in star schema/snow-flake schema.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML, .doc and CSV using SQL Server Reporting Services (SSRS).
• Data visualization is performed by using Qliksense.
• Used SQL Server Management Studio, TOAD to run SQL queries and validate the data in Data warehouse and Data Marts.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Designed ETL processes for extracting, transforming and loading data into Oracle tables.
• Written QlikView Scripts, macros, design Dashboard and Reports for different user groups
• Deployed the QlikView Application to the server and automated the jobs.
• Managed QlikView Licenses User CAL, Document CAL, Server Licenses, Publisher Licenses.
• Provided security for the developed boards.
• Installed Nprinting Server and Client in the remote systems, so that developers can access the client tool to create adhoc reports.
• Created a template to save the files in a specific location when the user run the adhoc request.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server with high volume data.
• Integrated data from different types of data sources like Flat files, QVW’s, Qvd’s,.csv and from different types of databases to Qlikview.
• Expertise in developing star flake schema and snowflake scheme datamodels.
• Performed many functions in both front end and Back end.
• Managed schedules and reloading of QlikView data model QVDs and QVWs through QlikView Enterprise Management Console (QEMC).
• Test and monitor the underlying data, assuring quality and optimizing the data view that dashboards use
• Understand the techniques used in visual reporting in tableau.
• Designed the data transfer and transformations with in QlikView.
• Used different components of QlikView like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc to developdashboards.
• Created and managed ETL script generation using QlikView Script Builder Application.
• Connected to different ODBC, OLEDB data sources (SQL Server, Oracle, and SAP BW) and flat files as per requirements by using components of Qlikview.
• Created and scheduled different complex reports as per the business requirements.
• Analyzed the application regarding user experience (Front end), QlikView data model change, volume estimation, QVW size estimation, BI processing time saved after consolidation.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server with high volume data.
• Generated reports in BI using SRSS.
• Developed ELT using SQL Server Integration Services (SSIS) and OLAP development using SQL Server Analysis Services (SSAS).
• Developed tools using Python, Shell scripting, XML to automate some of the menial tasks.
• Developed data models and published packages in Cognos connection using Framework Manager.
• Preparing Dashboards using advance table calculations, parameters, calculated fields, groups, sets,forecasting and hierarchies in Tableau.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Created packages from different data sources and published packages to Cognos Connection
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Developed KPI’s and set analysis applications. Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.)
• Developed User Interactive Sheets & Reports as business needs.
• Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Developed load scripts to work with multiple data sources (SQL, Flat Files, Excel, and MS Access).

Environment: QlikView 11x/10(Desktop, Server/Publisher), Oracle, SQL Server, Tera Data, SAP, SAS, Excel, CSV files, Enterprise Management Reporting Portal, DB2, Tableau, Cognos, Informatica, QlikView Enterprise Server

Confidential, Chevy Chase, MD

Qlikview Developer

• Evaluated functional requirements and map the documents.
• Analyzed the existing Qlik Sense QlikView data model, script logics and the ETL business logic for the existing QlikView applications.
• Built the SSIS reports and extracted data Using SSIS and transformed & loaded into Qlik Sense.
• Responsible for the QlikView Dashboard & Report development, which includes dashboard design /QlikView Script writing.
• Connected with varied sources (flat file/Oracle etc.), data cleansing, data analysis etc.
• Developed QlikView Dashboards using Chart Box List, Input Field, Table Box and Calendar & Date Island
• Developed and created stories in Qliksense.
• Worked on tools like QV connectors to create connections in QliKView to connect to SAP databases for retrieving data from tables.
• Designed and developed multiple QlikView applications for the Sales, IT, Manufacturing, Purchasing & Finance qlikview applications.
• KPI dashboards are developed in Qliksense.
• Performed redesign of QlikView BI platform to improve availability, scalability and performance to accommodate high volume of data with dashboards
• Created schema objects like tables, views, indexes. Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Connected to Oracle using OLEDB and ODBC data sources connector and tables of SD, inventory, etc. to create and schedule reports by leveraging the basic components of QlikView
• Created Complex Reports using Cognos BI Report Studio and Ad-hoc web based reports usingCognos, BI Query Studio.
• Used CognosBI Framework Manager in building the Models and packages and published into Cognos connection Portal and implemented securities for the packages.
• D eveloped reports using MDX scripting, SQL and SQL Server Reporting Services (SSRS).
• Performed ETL- Extraction Transformation and Loading, data analysis, Graphical presentation, reporting and documentation.
• Performed daily tasks including backup and restore from disaster recovery by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler.
• Created score cards with advanced set of dashboards using MS Office Performance Point Server Dashboard Designer that feature executive summary measures.
• Developed reports in Tableau.
• Created the mappings, sessions and Workflows as per requirement of business logic.
• Created a mapping document based on High level design document
• Designed and developed scripts to support UI visualization, ETL processes, automation, and workflow and dashboard presentation framework.
• Developed engineering prototype and using POC to facilitate KPI Metrics dashboard design across different regions and business units according to business equiements.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Extracted the data from various sources like relational and flat file sources of OLTP systems.

Environment: QlikView 11x/10(Desktop, Server/Publisher), Oracle, SQL Server, Tera Data, SAP, Excel, CSV files, Enterprise Management Reporting Portal, DB2, Tableau, Cognos, Informatica, QlikView Enterprise Server, QlikSense,Oracle 10g, Access, .CSV Files, Windows 2003 Server, Sun one LDAP, Nprinting, SAP HRMS.

Confidential, Mt Laurel, NJ

SQL Developer/ETL developer

• Involved in Creation of Reports, Created ODBC Connections, database Connections, stored procedure using oracle.
• Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Scheduled the published dashboards from Tableau Server on weekly basis.
• Used MySQL to handle the data, for the implemented OLTP operations.
• Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Developed data base tables and created SSIS packages.
• Designed and development Data modeling, database design, and ETL in an Agile development environment.
• Worked on SAS datasets using the ETL concepts to increase the overall performance.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Involved in designing, developing and deploying reports in Microsoft SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).
• Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel and .Net.
• Develop and support Extraction, Transformation and Load process (ETL) using Informatica power center to populate Teradata tables and flat files.
• Resolved various performance issues by running DBCC command.
• Designed ETL processes to transform information from multiple sources
• Troubleshooting, monitoring and coordinating defect resolution related to ETL processing.
• Developed data warehouse models and prepared reports for all Meta data integration into systems and draft ETL scripts and prepared required reports for all end users.
• Understand the specifications and build the ETL applications like Mappings on daily basis.

Environment: QlikView 9, HTML, CSS, Jquery, SQL Server 2005/2008 Enterprise Edition,SSIS, SSRS, MS SQL Server management Studio, Erwin Data Modeler, MS PowerPoint, MS Excel

Confidential

SQL Developer

• Worked with multiple platforms, architectures, and diverse technologies gathering requirements.
• Designed and maintained data integrationand EDI applications using a SQL, data mapping tools, and web services in various formats and custom file layouts
• Createinterfaces between application systems and various organizations.
• Developed web pages by using HTML, XML, JavaScript.
• Dashboards are created depending on the Business Intelligence based on the SRS reports.
• Extracted the data from Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS.
• Designed and deployed SSIS packages.
• Understanding ETL products, services, protocols, and standards in support of procurement and development efforts.
• Application is connected to database using JDBC.
• User executions permissions are provided using SQL.
• Created Entity Relationship (ER) Diagrams to the proposed database
• Created database objects such as tables, views, stored procedures, Triggers etc.
• Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Back end Oracle data base is used to store data, each output from the lab is stored and then integrated to the java program to retrieve the data from the database and connect to the doctor system.
• Responsible for writing SAS programs using Base SAS and SAS/Macros to create SAS reports.
• Developed PL\SQL queries to manipulate the data and structure of a database.
• Installed and configured a security and troubleshooting issues related to database.
• Experience on procedures, Packages and triggers in SQL.
• Implemented and developed ETL process using ORACLE functions.
• Created cubes in SQL Server Analysis Services (SSAS).
• Developed reports in SQL Server Reporting Services (SSRS).
• Designed, Developed and Deployed SSIS Packages.
• Understand the requirements and provide the back-end functionality for the applications.
• Participated in development and creation of Data warehouses.

Environment: Linux, Windows, Ajax, Java, JavaScript, oracle, JDBC, SAS,SSRS, SSIS, HTML, CSS, JQuery, XML, JBOSS.