SUMMARY

• An accomplished technology professional specialized in Business Intelligence, Analytics and Data management. Expertise in industry - leading products such as Cognos Analytics BI Suite, QlikSense, Business Objects, SQL Server Integration Services,Talend. 13 years of IT industry experience in full life cycle of the software development and product administration
• 13 years of experience in Business Intelligence, Analytics and Data management. Worked for three leading insurance companies and a leading healthcare company in United States
• Performed role of Cognos Platform Engineer for more TEMPthan 7 years, has thorough noledge on Cognos Architecture, Reporting suite, client tools, security, installation, configuration and maintenance.
• Experience in designing, capacity planning, building and maintaining of Cognos Platforms on Windows and Linux Operating systems, which includes on-premise as well AWS cloud servers.
• Experience in QlikSense platform admin activities such as managing sites, creating and securing streams, publishing and migrating apps, managing user access/tokens, manage connections and extensions.
• Lead Cognos development team in leading property casualty insurance company. Designed and developed Cognos reports and dashboards, which had challenging customer requirements and performance SLA.
• Performed role of Business Intelligence and Data management consultant for technology services division in leading property casualty insurance company. Provided data driven insights to improve operational efficiency, capacity planning and budgeting.
• Cognos Platform upgrades (8.2 to 8.4, 8.4 to 10.2, 10.2 to 11.0.11, 11.0.11 to 11.1.7)
• Cognos Platform migration from On-premise servers to AWS EC2 Cloud servers.
• Cognos Platform setup on Linux for Crown Jewel applications leading healthcare company.
• Integration of MotioCI versioning tool in Cognos Analytics Platform.
• Integration of PingIdentity to Cognos Analytics for multifactor authentication.
• QlikSense 13 (April 2020 version) platform upgrade.
• Software Security Compliance Dashboard for IT Security Team
• Automation of IT Finance charge back files validation.
• Workstation 360 dashboard for corporate laptop and mobile devices usage exploration.
• Underwriter Dashboard for Policy, Submission, flow and Production data visualization for Travelers International Business
• Elementum to Talend ETL migration project.
• Business Objects Sunset/Conversion project

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Platform Engineer

Tools worked on: IBM Cognos Analytics 11, QlikSense 12, BMC Remedy 9, ServiceNow, Oracle 12c, SQL Server 2016

Responsibilities:

• Technical support and administration of IBM Cognos Analytics and QlikSense platforms.
• Technical leadership and mentorship in a highly collaborative, multi-discipline team environment.
• Provide solutions for platform and reporting issues which may have high impact to business operations.
• Coordinate and execute new platform setup and upgrades, explore opportunities to improve the efficiency and resiliency of platforms.
• Periodic evaluation of platform usage, infrastructure utilization and platform capacity.
• Support Change Management, Configuration Management, Problem Management, Incidents and Service requests though BMC Remedy and ServiceNow.
• Automating repeated operational tasks such as platform monitoring, testing, bi-weekly service restart and disk drive cleanup.
• Participate in all phases of development lifecycle and post implementation support.
• Meet the IBM Cognos vendor contacts on a regular basis to analyze and resolve product defects, upgrade issues, and health assessment activities.
• Ensuring the platform security aligns with corporate standards and policy.
• Collaborate and share noledge and best practices with Development teams.
• Planning and coordinating business continuity and disaster recovery plans with global technology partners.

Confidential

Business Intelligence and Data Management Consultant

Tools worked on - Cognos Analytics 11/10.2.2, QlikView 11, Business Objects 4.1, SQL Server 2012, SQL Server 2016, SQL Server Integration Service, BMC Remedy, Autosys, Talend 6.4, Elementum GDE 3.4, Jenkins, IBM Urban Code Deploy

Responsibilities:

• Accountable for design and delivery of solutions to meet data visualization and data processing requirements from infrastructure service teams within Travelers
• Cognos Framework Manager modeling, report design and report migration across environments.
• Build reports using advanced capabilities such as Bursting, parameter Mapping, conditional styles and rendering, Trigger/Event based scheduling, iFrames and JavaScript based parameters display.
• Administration of Cognos Content for the GTS department.
• Managing Cognos upgrades by planning and executing report migrations, testing and addressing upgrade issues.
• Controlling Cognos security for multiples roles like Modeler, Report Developer, Query Users and Analysis users
• Cognos report performance tuning.
• Maintenance of two data marts, which includes addition or clean up of tables and columns, creating indexes, creating views, creating stored procedures and managing security.
• Design, Development, Unit testing, deployment and Maintenance of data extraction, cleasning and load process using SSIS and Talend. Some of major sources are BMC Remedy, Microsoft SCCM, AitWatch, Troux, IBM BigFix, Tanium, Lotus Notes, Zabbix, Active Directory etc. Sources are mix of databases, flat files, SharePoint lists and Rest APIs.
• Source data analyses and coordination with source SMEs.
• ETL Code deployment using Jenkins and IBM Urban Code Deploy.
• Managing remedy work order requests and incident tickets assigned to the team.
• Administration and maintenance of Business Objects environment to support remedy reporting.
• Development of QlikView dashboards for data visualization of infrastructure consumption, progress of various upgrade and migration projects, currency management, security compliance, application dependency etc.
• Automation of various tasks performed by infrastructure service teams to eliminate manual efforts and improve efficiency and productivity.
• Maintenance of Windows and Linux servers where SQL Server, Business Objects, Elemetum and Talend are hosted.
• Coordination with various infrastructure upgrade project teams for products like SQL Server 2016, Windows Server 2016, Cognos 11 and Talend 6.4.1
• Accountable for design and delivery business reports and dashboard of Travelers international business
• Assists in development of project charters, estimates, & project plan.
• Develops Cognos Framework Manager Models Packages and Reports in accordance with Requirements and architecture, design & Coding Standards
• Provide solutions for performance issues.
• Manage the work assignments for offshore team
• Unit testing and coordinating SIT and UAT for monthly releases.
• Coordinate performance test by involving performance engineers, database administrators and Cognos product engineers for new developments and major design changes
• Cognos code migration up the food chain till Production.
• Managing security for Reports and Data sources
• Fulfill request for ad-hoc data from business
• Assistance with an idea dat needs data and analytical support to formulate requirements.
• Business user communication and Training
• Cognos 10.1.1 to 10.2.2 to upgrade of Travelers International Cognos contents

Confidential

Cognos Product Engineer in Travelers OAISys - Enterprise BI Product Support

Tools worked on - Cognos 8.2, Cognos 8.4, Cognos 10.1.1, Cognos Insight, ESRI ArcGIS, EnVisn Cognos Admin Tools, IIS 6, IIS 7.5, BMC BladeLogic, BMC Remedy, HPSM, Fiddler and AutoSys, Oracle, SQL server etc.

Responsibilities include:

• Building and maintaining various Cognos environments (9 environments with close to 100 servers)
• Coordinating with various support groups to maintain the stability and availability of the Cognos platforms
• Help develop the Cognos Control model and working closely with the LOB administrators and halping enforce Cognos security control model and governance standards
• Working closely with the LOB developers and halping implement the “development best practices”
• Provide consultation on Cognos functions and features, answering “How to” questions and supporting a very large and diverse Cognos user base
• Product evaluation and certification and New functions/ features documentation
• Key contribution to planning and implementation of Product version upgrades
• Providing consultation on performance testing and performance improvement exercises
• Working closely with the product vendor and developers to troubleshoot and resolve product/application/Report issues
• Conducting the Cognos community meetings with a large target audience and providing regular updates about the Cognos environments
• As part managing the Cognos enterprise environment he has created number of reports using Audit database to analyze usage of Cognos reports, servers, Cognos license and troubleshooting report failures.
• Developed Cognos Health Summary dashboard using Cognos dashboards capability to produce visualization of of environment health which includes the connection test results for all types of data sources, performance deviation for reports created using different Cognos studios, results of various functionality tests and availability of servers.
• Responsible for the designing the Business Objects universe (models)
• Responsible for the designing and developing 70+ reports.
• Creating and maintain design documents for Universe and reports
• Write scripts for materialized query tables for the non-real time reports
• Identifying the source table relationships and joins and fix loops and traps by creating table aliases
• Unit testing and regression testing of Universe and Reports
• Co-ordinate User acceptance testing
• Warranty support and production release

TECHNOLOGY SKILLS:

Reporting/Analytics Tools: Cognos Analytics 11, Business Objects XI R2, QlikView 11, QlikSense

ETL Tools: SQL Server Integration Services, Talend 6.4, Elementum GDE 3.4

Operating Systems: Windows Server 2016, Linux RHEL 7.6

Programming Languages: PL/SQL, Windows batch script, PowerShell, Python

Database: DB2, Oracle 12C, SQL Server 2016