SUMMARY

• Over 8 years of IT experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing/ Decision support systems and Business Intelligence (BI).
• 6 yearsof experience in Designing and Development of Business intelligence applications withQlikView 12.10/11.2/10.0/9.0 as BI tool.
• 2+ yearsof experience in preparing dashboards usingQlikSense 3.1/3.0.4/2.2/2.0 extension objects
• Having experienced in Agile Methodologies, Scrum stories and sprints experience in a Python based environment, along with data analytics, data wrangling and Excel data extracts.
• Over six years of professional experience as a Cognos Business Intelligence Developer - Analyst with key activities such as support, analysis, designing and testing Cognos BI solutions across multiple industries.
• Technical expertise in Data Warehousing (Relational, Dimensional Relational (DMR), & OLAP) modeling and development, schemas (Star & Snowflake), logical data marts & table structures (fact & dimension); using Data Modeling tools such as Cognos Transformer and Framework Manager.
• Installed, configured and worked on Cognos BI suite, including Business Insight & Advanced, Report Studio, Query Studio, Analysis Studio, Event Studio and Metric Studio.
• Proficient in developing Web Services (SOAP, RESTful) in Python using XML, JSON. Developed web - based application using Django framework with python concepts.
• Excellent knowledge and experience in Oracle Database, JDBC, DB2, PL/SQL, MS SQL Server, My SQL Server, Mongo DB.
• Developed tools to automate some base tasks using Python, Shell scripting and XML.
• Extensive experience in Full Life Cycle Development including Analysis, Design, Implementation and Maintenance different analytical applications using QlikView suite of Products (QlikView Server, Publisher and QlikView Enterprise).
• Strong knowledge in designing and developingQlikViewandQlikSensedashboards by extracting data from different sources likeTeradata, PostgreSQL, SQL Server, Oracle,SAP, Flat Files, Excel files, XML Files.
• Experience in optimizing QlikView and Qlik Sense applications to improve the performance.
• Developed QlikView and Qlik Sense 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 the QlikView and QlikSense dashboard issues.
• Created incremental load process to load the data into QlikView applications from different source systems.
• Involved in Performance Tuning and Deployment of QlikView and QlikSense applications.
• Hands on experience in QlikView advanced features like Alternate States andDirect Discovery and Experience on QlikView Scripting,Set analysisandSection Access.
• Scheduled the jobs and distributed to end users from QMC.
• Expertise with2-tier implementation and QVD Data Warehouse implementation
• Expert in using the QRS, QPS, QES APIs and building the automated solutions in Qlik
• Expertise in implementing the Section Access.
• Implemented all levels of security at row level, field level, and sheet level.
• Expertise in all types of loads in Qlik.
• Experience in NPrinting with Qlik Sense/QlikView
• Expertise with Qlik implementation in large enterprises.
• Coordinate with data sources such as SQL Server and Hadoop
• Excellent knowledge and work experience on Qlik Sense Hub, QMC, Proxy, QIX, Qlik Sense Scheduler (QSS), Qlik Sense Repository (QRS) and QVF
• Expert in all administration functions of Qlik Sense like SAML integration, User directory and Security Rules.
• Experience in database programming, SQL, Tables,Views, Indexes, Joins,andSub - Queries.
• Trained end users to develop and useQlikViewandQlikSenseapplications
• Strong Experience in Extract, Transform & loading data in QlikView Applications & Develop Data models using Star Schema & Snow Flake Schema’s.
• Performance tuning QlikView Applications for faster data reloads & efficient response times.
• Implemented data level security using Section access that hides selected areas of the dashboard & filters data dynamically depending upon user privileges.
• Sound Skills in SQL. Validating data using SQL Scripts.
• Having knowledge on the SDLC methodologies like AGILE, Waterfall model.
• Onsite-Offshore coordination in delivering Business Intelligence Solutions and Data Marts.

TECHNICAL SKILLS

Business Intelligence Tools: QlikView/Qlik Sense, SAP BO.

Database: Oracle 9i/10g/11g, SQL server 2008 & 2012, My SQL, Teradata, MS Access.

Web technologies: HTML, JavaScript.

Languages: C, C++, Java, Python, Visual Basic, JSP.

MS office: Project management, Excel.

Web browser: Internet Explorer 6/7/8/9, Mozilla Firefox 3/3.5/3.6/4.0 , Google Chrome, Safari.

PROFESSIONAL EXPERIENCE

Confidential

BI Developer

Responsibilities:

• Implementing QlikView/Qlik Sense applications for Sensors/BI squad that are used across PI.
• Redesigning Sensors Classic along with all the QlikView Applications that are associated to Sensors Classic Application.
• Creating QlikView data models and interactive visualizations.
• After extracting data from Database, Creating transformed QVDs as per requirements
• Developing interactive data models with those Initial or transformed QVDs.
• Developed web applications and RESTful web services and APIs using Python, Django and PHP. Experience with Django, a high-level Python Web framework.
• Automated Confidential S3 data upload / download using Python scripts. Automated JIRA processes using Python and bash scripts.
• Implemented the CI/CD for the Forge Microservices to containerize the Microservices and pushing them to Private Docker Registery.
• Coordinated testing, rollout & deployment of Cognos 10.1 Business Intelligence reporting solutions.
• Worked closely with business users to define reporting requirements and documenting the requirements in order to design, develop and maintain, and secure Cognos reports.
• Performed burst of Reports against the regions, districts, and stores for delivering by email; appropriate outputs to the concerned District Managers & Team Ambassadors in Cognos Connection.
• Developing Python Framework using Django to perform scan software unit monitoring.
• Created Python and Bash tools to increase efficiency of application system. Developed Merge jobs in Python to extract and load data into MySQL database.
• Analyzed client needs and developed software tools to assist dynamic site content creation (Python, wxPython). Responsible for setting up Python REST API framework using DJANGO.
• Loaded data from various SAP source systems to HANA using SAP BODS and SLT replication techniques.
• Performed scheduling and maintenance of reports using Cognos Connection and Microsoft SharePoint based support portals.
• Created Qlik Sense applications by replicating the existing QlikView applications
• Supported clustering and replication for servers.
• Setup replication within the SQL databases.
• Experience in implementing many types of High availability and Disaster Recovery solutions like Clustering, Database Mirroring, Cold Standby, Warm Standby, Log Shipping, and Replication.After developing the models, Will develop QlikView/ Qlik Sense Dashboards.
• Designing and configuring the QlikView/Qlik Sense applications front-end calculations (i.e. set analysis, aggregations, etc.) as per business requirements
• Responsible for interpreting business needs of stakeholders and develop analytical solutions o Interacts directly with business users and SME’s to get the requirements from them to develop any dashboard.
• Working on Agile methodology and use Scrum in implementing the project.
• Document and test work products and conduct data quality checks on a regular basis
• Expertise in Qlik Sense data modelling, master items and maps
• License Modelling for both QlikView and Qlik Sense.
• Qlik Sense and QlikView Security Implementation. implementing the governance model
• Installed and configured Qlik Sense Nov and April releases.
• Qlik Sense and QlikView Administration.
• Attribute based access control and role creation.
• Coordinating with data sources such as SQL Server and Hadoop
• Worked on WebLogic to connect with QVWS (QlikView Web Server).
• Data source configuration and maintenance.
• Data Modeling/scripting, managing data flow between source and application.
• Creating/designing Dashboards.
• Performing Unit and Integration testing, validation and sanity checks on the deliverables.
• Deploying and publishing Mashups with QlikView applications on server.
• Converted apps from QlikView to Qlik Sense
• Post Production support/maintenance.
• Worked on NPrinting.
• Assisted in gathering Customer, User and Owner requirements; analyzed and documented them.
• Strong experience in implementing various aspects of SharePoint i.e. Social Collaboration, Web Content management, Document Management etc.
• Maintaining and Updating JIRA to keep track of work, Oracle SQL Developer to monitor the data in the database.
• Writing SQL Scripts for data dump in the database in PostgreSQL Server, to extract data to application.
• Performance tuning QlikView Applications for faster data reloads & efficient response times.

Environment: QlikView, Qlik Sense, MS-excel, Cognos 10.1.0 (Report Studio, Active Reports, Query Studio, Cognos Connection, SQL Server 2008. Oracle 10g/Oracle ERP, Share-point, Microsoft SQL server 2012, Hadoop, SQL Server with Clustering, Replication, Windows Server 2008.

Confidential, Boston, MA

Visualization Engineer/ QlikView / Qlik Sense Developer

Responsibilities:

• Implementing QlikView/Qlik Sense applications from Syngenta Enterprise Data Platform (SADIE)
• Working on different data sources but mainly SADIE to extract data for Initial QVDs.
• Creating QlikView data models and interactive visualizations.
• After extracting data from SADIE, Creating transformed QVDs as per requirements
• Developing interactive data models with those Initial or transformed QVDs.
• After developing the models, Will develop QlikView/ Qlik Sense Dashboards.
• Designing and configuring the QlikView/Qlik Sense applications front-end calculations (i.e. set analysis, aggregations, etc.) as per business requirements
• Data Migration from oracle to redshift using SCT and DMS. Built various graphs for business decision making using Python matplotlib library.
• OOP in PHP to extend or update functionalities. The project uses MySQL as the database. Built various graphs for business decision making using Python library.
• Responsible for setting up Python REST API framework using Django. Implement code in python to retrieve and manipulate data. Created entire application using Python, Django, MySQL and Linux.
• Worked on Element Tree XML API in python to parse XML documents and load the data in database.
• Creation of REST Webservices for the management of data using Apache CXF (JAX-RS).
• Worked on python-based test frameworks and test-driven development with automation tools.
• Developed a fully automated continuous integration system using Git, MySQL, Jerkins, and custom tools developed in Python.
• Worked in RDBMS implementation using, SQL, PL/SQL, DB2, MySQL on Oracle database. Worked on Python OpenStack APIs and used Numpy for Numerical analysis.
• Worked on server-side applications with Django using Python programming. Utilized standard Python modules such as csv, itertools and pickle for development.
• Configuring, maintaining and troubleshooting Native SQL Transactional Replication along with external replication tools like Oracle Goldengate & Attunity.
• Installed on configured Attunity Replication Tool for replicating data from one server to other using CDC change data capture
• Used and Maintained Golden Gate Replication for SQL Server and resolved the replication issues raised.
• Involved in configuring and monitoring Transactional Replication for reporting purpose.
• Implemented configured and maintained Transactional replication successfully in SQL Server 2008 environment.Responsible for interpreting business needs of stakeholders and develop analytical solutions
• Interacts directly with business users and SME’s to get the requirements from them to develop any dashboard.
• Working on Agile methodology and use Scrum in implementing the project.
• Document and test work products and conducts data quality checks on a regular basis
• Maintaining and Updating JIRA, Smartsheet to keep track of work, DataGrip to monitor the data in the database.
• Writing SQL Scripts for data dump in the database in PostgreSQL Server, to extract data to application.
• Creating dashboards by extracting data from database write and externalized the load scripts, store the data as QVD files.
• Use of Set analysis and aggregation functions for sheet objects.
• QlikView data modelling by building the Star schema and resolving loops/synthetic keys following QlikView dashboards optimization.
• Implemented the Various scenarios of section access.
• Created macros in VBScript and building the QlikView extensions.
• Use of Set analysis and aggregation functions for sheet objects.
• Strong working experience in Load script and Data modelling.
• Working with all types of data loads and functions like Automap.
• Debugging the QlikView server issues through server logs, Fiddler logs.
• Expertise with2-tier implementation and QVD Data Warehouse implementation.

Environment: QlikView, SQL Server with Clustering, Replication, Qlik Sense, NPrinting, MS-excel, PostgreSQL.

Confidential, NYC, NY

Sr. QlikView / Qlik Sense Developer

Responsibilities:

• Worked on SAP BO to Qlik migration of Finance Module of Anheuser Busch.
• Worked on metadata analysis of SAP BO universes and reports. Analyzed and short listed Critical universes and reports which can be migrated to Qlikview and Qlik Sense
• Work with senior management to plan, define and clarify migration goals, objectives and requirement.
• Created QVDs for a universe to develop Data Model.
• Gathering data sources like Teradata, Excel, SQL Server 2008, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Developed data models based on the client requirements and without any ambiguous or Synthetic tables.
• Design, Develop, Test, debug and implement Data Models based upon specified requirement.
• Developed Dashboards using all functions of Qlikview and Qlik Sense similar to the reports in SAP BO.
• Developed Qlik Sense Applications using features such as KPI Object, Pivot Table, etc.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc )
• Extract, transform and load data from multiple sources into QlikView applications.
• Design, Develop, Test, debug and implement Qlik Sense Applications based upon specified requirement.
• Developed data models based on the client requirements and without any ambiguous or Synthetic tables.
• Experience in Using QlikView and Qlik Sense Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc )
• Extract, transform and load data from multiple sources into QlikView and Qlik Sense applications.

Environment: QlikView12, Qlik Sense, Teradata, SAP BO, MS-excel, SQL Server 2008.

Confidential, Hoboken, NJ

QlikView Developer

Responsibilities:

• Understanding the requirements from the business users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Developed QlikView Dashboards using different Chart, Drill down, Cyclic Groups, List, Input Field, Table Box, Container etc...
• Work with senior management to plan, define and clarify dashboard goals, objectives and requirement.
• Design, Develop, Test, debug and implement QlikView solutions based upon specified requirement.
• Re-use the existing QVDs, new tables as QVDs and scripts to generate appropriate fields that help in modeling the data according to the requirements.
• Gathering data sources like QVD files, Excel, Oracle DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Developed data models based on the client requirements and without any ambiguous or Synthetic tables.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc )
• Extract, transform and load data from multiple sources into QlikView applications.
• Developed SET ANALYSIS to provide custom functionality in QlikView Applications.
• Created Dashboards style of reports using QlikView and Qlik Sense components like List Box, Slider, Buttons, Charts and Bookmarks.
• Design, Build, Test, Debug the QlikView application in QV Test server environment.
• Creating QlikView Applications using qvd files from user analytical/Business purpose.
• Served as QlikView application developer for various ad-hoc analysis requests.
• Provided ongoing maintenance and support to existing QlikView documents.

Environment: QlikView11.2, Oracle 10, Business Objects, MS-excel, Windows Server 2008.

Confidential

SQL Developer

Responsibilities:

• Involved in Business Requirements, System analysis and Design of the Data warehouse application.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Provide database coding to support business applications using Sybase T-SQL.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Writing validation packages using PL/SQL package.
• Developed Installation scripts forall the deliverables.
• Filtered and Loaded data from different formats of data sources into Database Tables.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Involved in preparing test plans, unit testing, System integration testing, implementation, and maintenance.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.