SUMMARY

• 10 Years of verifiable IT experience in Analysis, Design and Development on BI/DW areas.
• Extensive Knowledge and Proficiency in Enterprise Data Warehousing, OLAP and Report Generating Systems - Cognos 8/10/11 Series, Business Objects. Analytics tools -QlikView, Qlik sense, Tableau.
• Extensive experience in using Cognos 8.x and Cognos 10.x/11.x BI (Framework Manager, Report Studio, Analysis Studio, Metric Studio and Query Studio)
• Technical Lead for Cognos Migration activities (to quote: Cognos 8.1 to 8.4 and Cognos 8.4 to Cognos 10.1 and Cognos 10.2 Respectively)
• Technical lead for migrating Cognos from On-premise to Google Cloud Platform (GCP).
• Extensive experience in creating QlikView/Qlik sense Analytics dashboards and handling the End-to-end implementation of QlikView/Qlik sense Dashboard deployment.
• Very good experience on QlikView/Qlik sense QMC Administration.
• Good experience in analysis, developing and designing dashboards and providing analytical solutions using Tableau desktop and administration by Tableau server/Online.
• Expert in working on all phases of Data warehouse from gathering requirements to testing, implementation, and support.
• Excellent knowledge in Performance tuning methodologies at database level, ETL, and Report Level.
• Trained in Python and Machine Learning.
• Expertise in Automating Cognos and Qlikview/Qliksense Deployments through Devops process(Jenkins/Github)
• Service line champion in Project Shunya (Key objective of this program is to build healthy race in achieving there zeros i.e. Zero Defects, Zero Outages, Zero Vulnerability)
• Expertise working as an Individual Contributor (Gathering Requirements from business users, development, unit testing, deployment) for Cognos/Qlikview.
• Worked on complete software life cycle starting from strategy planning, requirement feasibility analysis, design, development, testing and production support.
• Lead teams during various phases of the project whenever required.
• Constantly provided best technical approaches for project execution and provided consultancy for other projects whenever required.
• Have a proven analytical ability, co-ordination skills, worked in a large team environment and a good team player.

TECHNICAL SKILLS

Specialties: Data Visualization, Business Intelligence (BI), Software Management and Data Collection

BI Tools: Cognos 8.x, Cognos 10.x, Cognos 11, Cognos Framework Manager, Cognos Query Studio, Analysis Studio, Metric Studio, SAP BO, Hyperion, QlikView 9/10/11.0, QlikView N-Printing, Qlik sense 2.2/3.0, Tableau, Web Trends

Devops Tools: GitHub, Jira, Nexus, Jenkins, Eclipse, RTC

Cloud Platforms: Google Cloud Platform (GCP)

Languages: SQL, Python, C, C++

Relational Databases: Teradata, Oracle, DB2, SQL Server 2005/2008/2012

Operating Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead

Responsibilities:

• Understanding the business requirements and report specification and highlight the points which may conflict with business requirement and suggest alternative and Preparing Project Plans/Milestones and Project Status Reports.
• Translate business requirements into specifications and suggest best way of having database design created from potentially multiple data sources.
• Write and maintain technical specifications that describe program development, data modeling, coding, testing, changes and corrections. Finding and rectifying the gaps in the existing projects.
• Define and follow Cognos development best practices and Provide technical assistance and cross training to other team members.
• Creating, enhancing and maintaining Framework Manager models to support business requirements
• Work on Report Studio like Dashboards, List Report, Cross Tab reports, Charts using JavaScript and creation of reports using prompts, filters, Condition Variables/Styles/Blocks to highlight data/hide blocks based on reporting requirements.
• Scheduled reports to end user mail ids and event Schedule based on business requirement.
• Use of Stored Procedure based on requirement and write back data to database using Cognos.
• Implement Security measures.
• Performance tuning experience related to reporting queries required
• Involved in Migration from Cognos 8.4 to Cognos 10.1 and Prepared test cases for the reports, Upgrading OLTP reports to OLAP reports and Migration from Oracle to Teradata for Cognos Reports.
• Analysis of the Problems across the reports and defining the resolutions and modifications to the Existing Reports based on the CR Approvals
• Tracking of all development work from requirement to testing and Update QC with test cases and execution of it, track defects if any and provide resolution.
• Identify Service Request and Incidents and track. Checking of incidents raised and identify the root cause of it.
• Implemented Devops automation for Cognos Deployments.

Lead Developer

Confidential

Responsibilities:

• Work closely with clients/functional SME to translate business requirements into technical solutions.
• Data Modeling/scripting, managing data flow between source and application.
• Creating and designing Qlikview/Qliksense Dashboards using different types of Qlikview/Qliksense Objects.
• Involved in performance tuning of QlikView & QlikSense apps for faster data reloads and efficient response times.
• Involved in analyzing the data and defining Key Performance Indicators (KPI).
• Created Pixel Perfect reports, Excel reports, PowerPoint reports and Word Reports using NPrinting tool.
• Create and designing Qlikview/Qliksense dashboards in N-printing and further scheduling them.
• Build ad-hoc reports for business data analysis based on end user requirements & distribute reports to end users
• Created tasks and set dependencies using QlikView Publisher.
• Assisted in installation and configuration of QlikView and QlikSense servers.
• Actively involved in upgrading to the latest QlikView versions.
• Simplifying complex expressions in the dashboards and improving front end.
• Involved in converting the existing QlikView applications to QlikSense.
• Perform Qlikview/Qliksense code review & provides best practices for data modeling, application design and development.
• Implemented Security at Data and Dashboard Level.
• Developed load script using QlikView/Qliksense Functions, Designed and implemented the Incremental Loading.
• Provide technical product assistance and tuning to meet customer performance and functional requirements.
• Continuously develop depth and breadth of Qlikview/Qliksense solutions and training of Qlikview/Qliksense.
• Deploying and Publishing Qlikview/Qliksense applications on Server using QMC. Scheduling the tasks on server. Creating Release Window using GSD’s
• Performance tuning of script and front-end code
• Implemented Devops automation for Qlikview Deployments.
• Directly engaging with Qlik Technical Support Team.
• Involved in Production Support for various applications and failure analysis using error logs.
• Worked closely with Data Modelers in designing various data warehouse schema techniques.

Technical Lead

Confidential

Responsibilities:

• Part of Tableau Centre of Excellence team
• Maintain Vendor Relationship management and Vendor Contracts
• GB/GF stakeholder management and support
• Maintain Tableau standards for the group
• Collation and management of best practice
• Ownership of standard design patterns
• Software product versions and upgrades
• Communication and Maintenance with Enterprise of the Tableau Community
• Liaison Architecture
• Collaboration and innovation with Tableau as a strategic partner.
• Generating reports weekly and monthly basis as per business requirements.

Technical Lead

Responsibilities:

• Worked with business analysts, interpreted business requirements that users looked to dashboards to answer, and created server-based Tableau dashboards with automatic updates.
• Defined best practices for Tableau report development.
• Implemented Tableau BI Dashboard reporting solution for different groups in the organization.
• Published Dashboards onto Tableau Server and from there consumers would choose viewing medium (laptop, pc, iPad)
• Created extensive joins for data blending from several different data sources
• As Tableau Developer, primary activities included designing technology roadmap for Tableau; product installation and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Leveraged advanced features of tableau such as calculated fields, parameters, and sets to support data analysis and data mining.
• Developing various tableau dashboards prototype for the future uses and conversion of current excel reports into tableau
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Tested Dashboard for data accuracy and Functionality.
• Migrated Reports & Universes from Development to Testing and to Production Environment using Import Wizard.
• Part of Tableau Centre of Excellence team
• Maintain Vendor Relationship management and Vendor Contracts
• GB/GF stakeholder management and support
• Maintain Tableau standards for the group
• Collation and management of best practice
• Ownership of standard design patterns
• Software product versions and upgrades
• Communication and Maintenance with Enterprise of the Tableau Community
• Liaison Architecture
• Collaboration and innovation with Tableau as a strategic partner.
• Generating reports weekly and monthly basis as per business requirements.
• Installation and configuration of tableau tools across the environments and configuring to Active directory services.
• Deploying dashboards from Dev UAT PROD estates
• Created Hive, SQL Server and mongo DB data source on Tableau server.
• Manage Tableau application users, groups and integration with Active directory.
• Knowledge of Tableau Licensing
• Creating Tableau Sites and projects, assigning individual roles to user and group accessing across sites.
• Authorizing users and groups to projects.
• Tableau server maintenance and data maintenance, backup on regular intervals.
• Creating extract refresh, subscriptions and data driven alerts.
• Configuring SMTP setup on Tableau server Configuration Utility.
• Analyzing traffic to tableau views and dashboards.
• Written batch scripts for daily tableau server backup, services recycle and scheduled same.
• Digging the logs and finding RCA for server issues and user specific errors