Summary
Overview
Work History
Education
Accomplishments
Timeline
Generic

Haritha Palika

California City,CA

Summary

· 10 years of experience performing tier 1 to 4 production support and maintenance of business-critical software applications based on a variety of technologies such as SQL, Oracle, Qlik Sense and Qlik view environments and N-printing. Configuration, maintenance and troubleshooting of Qlik Sense and QlikView environments.

· Exposure on upgrading Qlik Sense on all versions. Exposure on upgrading QlikView to 12.20 Creation of older and securing them with AD groups in QlikView.

· Installation of ODBC drivers such as SQL, Oracle, etc.

· Daily support of jobs running investigation of long runs and failures

· Maintenance support, environment stabilization, upgrades, licensing issue

· Produce and maintain operations manuals/run books for the operation support in line with corporate standards.

· Experience in Qlik Antiunity Platform environment setup/configurations and integration with other services.

· Familiar with Replicate and Attunity for efficient data movement and transformation.

· Provide technology guidance and best practices for the Platform to the Customer.

· Qlik Replicate: Proficient in configuring and managing Qlik Replicate for real-time data replication and synchronization.

· Data Integration: Experience with Change Data Capture (CDC) and ETL processes to ensure efficient data flow between systems.

· Cloud Platforms: Familiarity with deploying Qlik solutions on cloud environments (AWS, Azure, GCP).

· Performance Tuning: Skilled in optimizing Qlik applications for improved performance and scalability.

· Monitoring and Troubleshooting: Expertise in monitoring Qlik infrastructure and resolving issues to ensure high availability.

· Scripting and Automation: Developed Python scripts to automate repetitive tasks, improving operational efficiency and reducing errors by 50%.

· API Integration: Created scripts for integrating with various APIs, enabling automated data retrieval and processing for analytics.

· Data Processing: Implemented data processing pipelines using Python libraries (e.g., Pandas, NumPy) to transform and analyze large datasets.

· Performance Tuning and Optimization

· Conducted performance tuning on mappings, sessions, and workflows to minimize processing time and improve throughput.

· Identified and resolved performance bottlenecks by optimizing SQL queries, partitioning data, and fine-tuning session configurations.

· Implemented session and workflow parameterization for dynamic data loading and environment-specific configurations.

· Data Integration and Connectivity

· Integrated data from various heterogeneous data sources, including relational databases (Oracle, SQL Server, DB2), flat files, XML, and web services.

· Worked with source control tools and versioning to maintain code integrity and track changes across development cycles.

· Developed and maintained database connection objects and configured source/target connections in the Informatica repository.

· Informatica PowerExchange & Cloud Integration

· Implemented data integration solutions using Informatica PowerExchange to extract data from mainframes, ERP systems, and external systems.

· Utilized Informatica Cloud services for hybrid data integration, migration, and cloud data warehouse solutions (e.g., AWS Redshift, Snowflake).

· Error Handling and Debugging

· Implemented robust error handling and logging mechanisms within ETL processes to capture, troubleshoot, and resolve data load issues.

· Used Informatica session logs and workflow logs for debugging and improving overall ETL process reliability.

· Team Collaboration and Documentation

· Collaborated with cross-functional teams (business analysts, data architects, DBAs) to design and implement data integration solutions aligned with business requirements.

· Documented ETL processes, mapping specifications, and transformation logic for knowledge sharing and future reference.

· Version Control and Deployment

· Utilized Informatica Repository Manager for version control, deployment, and migration of ETL objects across different environments (Dev, QA, Production).

· Developed deployment strategies for promoting Informatica mappings and workflows from development to production environments.

· Designed and developed ETL processes using Informatica PowerCenter to extract, transform, and load data into Qlik data models for reporting and analysis.

· Integrated disparate data sources (e.g., relational databases, flat files, and web services) into Qlik by leveraging Informatica’s robust data transformation capabilities.

· Ensured data consistency and quality before loading into Qlik for real-time dashboards and visualizations.

Overview

10
10
years of professional experience

Work History

Qlik Attunity Administrator/Scrum Master/ Informatica Analyst

TCS/Manulife
07.2022 - 05.2023
  • Manage the infrastructure and server environments hosting Qlik Attunity components
  • Installs, configures, and maintains Attunity software and related dependencies
  • Monitors system health, applies patches and updates, and performs routine maintenance tasks
  • Collaborates with other IT teams to ensure proper network connectivity, security configurations, and compliance with IT policies
  • Performed incident resolution, problem management, change management and other activities according to agreed SLAs
  • Configuration and setup of Qlik Sense and QlikView Domain, Node configurations and application services
  • Providing expertise in technical analysis and solving technical issues during project delivery
  • Experience of dealing with Qlik Vendor about unknown issues across environments
  • Defining POC’s, technical documentation, best practices, system design, tuning, and performance
  • Team player with ability to analysis the problems quickly and implement the solutions
  • Strong leadership skills with an ability to keep the team motivated
  • Round the clock monitoring of jobs that are running in production and taking necessary action when there are issues
  • Performance tuning of dashboards was carried out to limit the response time to defining server sizing for optimal performance of Qlik sense dashboards
  • Activities associated with incident analysis, resolution, and tracking, problem-related task forces, developing and running of utilities and recoveries
  • Collaborating with the Qlik global support team to solve customer technical issues
  • Familiar with one or more server-side scripting languages e.g
  • PowerShell, ETL Python, Bash
  • Understanding of application layer protocols, such as HTTP/S, TCP/IP, UDP and web sockets
  • Implemented Qlik Replicate: Successfully deployed Qlik Replicate for seamless data integration across various databases and data warehouses, improving data accessibility and analytics speed
  • Real-Time Data Solutions: Designed and maintained real-time data streaming solutions, enabling timely insights for business decision-making
  • Collaboration with Teams: Worked closely with data analysts and BI teams to gather requirements and deliver tailored Qlik solutions that meet organizational needs
  • Documentation and Training: Developed comprehensive documentation and conducted training sessions for staff on Qlik tools and best practices
  • Implemented Qlik Compose to automate data integration processes from multiple source systems (SQL Server, Oracle, and cloud-based applications) into a centralized data warehouse
  • Reduced data loading times by 40% through optimized ETL workflows
  • Led the optimization of incremental data loading processes using Qlik Compose
  • Implemented best practices for change data capture (CDC), which resulted in a 50% reduction in data load times and improved overall system performance
  • Implemented a real-time analytics solution using Qlik Compose to enable near-instantaneous data updates from operational systems
  • This initiative improved decision-making capabilities across various business units by providing up-to-date insights
  • Managed and optimized SQL Server environments, ensuring high availability, performance tuning, and data integrity for mission-critical applications
  • Implemented automated backup and recovery solutions, and designed disaster recovery plans, ensuring minimal downtime during system failures
  • Developed complex T-SQL queries, views, and stored procedures for reporting and analytics purposes, reducing query run times and improving system efficiency
  • Used Qlik Compose to design and automate the end-to-end data warehouse process, including data ingestion, transformation, and loading into staging and target systems
  • Configured data models and workflows in Qlik Compose to streamline ETL processes, resulting in faster data availability for business intelligence and analytics teams
  • Integrated with multiple data sources, including SQL Server, and used Qlik Compose's automation capabilities to reduce manual interventions and accelerate data pipeline deployments
  • Leveraged Attunity Replicate for real-time data replication between SQL Server databases and cloud-based data storage, enabling near-instantaneous data updates for analytics and reporting
  • Configured Attunity to synchronize data from on-premise SQL Server to cloud platforms, ensuring that data was always up to date and available for business intelligence tools
  • Used Attunity Replicate for continuous data movement and incremental loads, minimizing latency and reducing data downtime during migrations and updates

Qlik Replicate/Qlik Administrator/ Informatica Analyst

TCS/Manulife
05.2021 - 07.2022
  • Install, configure and upgrade Qlik Server, Publisher and other 3rd Party tools NPrinting in a multi-server/multi-node environment
  • Experience working with Qlik Sense sites and the Qlik Management Console, to provide data and application governance, library maintenance, as well as user and application security
  • Participate in overall infrastructure design, strategy, backup and recovery of the Qlik suite of products including Qlik Sense and Qlik view
  • Manages the infrastructure and server environments hosting Qlik Replicate components
  • Installs, configures, and maintains Replicate software and related dependencies
  • Monitors system health, applies patches and updates, and performs routine maintenance tasks
  • Collaborates with other IT teams to ensure proper network connectivity, security configurations, and compliance with IT policies
  • Mentor developers and provide technical documentation, developer guides and assist in trouble shooting
  • Help users on how to use the Qlik Sense tool for reporting and data visualization to include communicating best practices
  • Responsible for the Qlik infrastructure, up-gradation, Tableau Cloud Admin Insights and migration of Qlik Sense applications
  • Directly Connect to Supported source system form of Qlik Cloud
  • Welp users on how to use the QlikView and Qlik Sense tool for reporting and data visualization to include communicating best practices a deep understanding of business needs and translate into QlikView and Qlik Sense technology solutions
  • Troubleshoot issues regarding access, data visualizations, display issues, streams, and performance
  • Data Replication: Successfully implemented Qlik Replicate to synchronize data across multiple databases, improving data consistency and availability
  • Performance Optimization: Conducted performance tuning of Qlik Replicate jobs, resulting in enhanced data processing speed and reduced latency
  • Cross-Platform Integration: Managed data replication between heterogeneous environments, including on-premises databases and cloud platforms (AWS, Azure)
  • Monitoring and Maintenance: Established monitoring solutions for Qlik Replicate jobs, ensuring high availability and quick resolution of issues
  • Trained new staff on ETL architecture, standards, and documentation practices to ensure consistency and quality
  • Coordinated production, development, and sandbox environments to facilitate seamless data operations and testing
  • Provided comprehensive support for Master Data Management (MDM) in the development of Enterprise Data Warehouses (EDW)
  • Supported all aspects of MDM within the EDW, ensuring data quality and consistency across multiple sources
  • Developed standards for data stewardship and created documentation for ongoing MDM processes
  • Utilized various Informatica transformations (e.g., Aggregator, Filter, Expression, Lookup, Sorter) to cleanse, enrich, and standardize data
  • Developed reusable transformation logic to improve ETL process efficiency and reduce maintenance time
  • Implemented complex data transformation logic to handle business rules, conditional mappings, and error handling

Qlik Administrator/ Informatica Analyst

HSBC
07.2019 - 05.2021
  • Allocated licenses and generated LEF
  • Application health check including weekend sanity checks on Saturdays and Geek end AGS maintenance
  • Monitoring servers and service status
  • Monitoring and Tableau integration with Azure AD and AWS Services maintaining scheduled jobs and reports
  • New user on-boarding
  • Experience on Qlik Cloud Migration with Tableau and developing and Implementing Cloud Solutions
  • Experience on Tableau Bridge Instillation and Collibra
  • Creating ODBC system DSN such as SQL, Oracle, etc
  • QV Admin activities include Gorking on failure of jobs, Security Implementation
  • Managing Auto email alerts for
  • Ailed reload tasks for Qlik Sense
  • Exposure in using Qlik web connectors and connecting to share point
  • Fixing productions related issues and providing information based on SR&s & INC tickets
  • Managing admin roles such content admin, security admin, deployment admin etc
  • In Qlik Sense
  • Managing user allocation licensing rules
  • SSL implementation
  • Real-Time Analytics Implementation: Led a project utilizing Qlik Replicate to provide real-time analytics capabilities, enhancing decision-making processes
  • Migration Strategy: Developed a comprehensive migration strategy for transitioning legacy data sources to Qlik Replicate, ensuring minimal disruption
  • In-depth understanding of SQL Server and Oracle databases, with experience in SSIS (SQL Server Integration Services)
  • Coordinated production, development, and sandbox environments to facilitate seamless data operations and testing
  • Developed and maintained the EDW using SQL Server and Oracle, ensuring robust data integration through Compose
  • Managed the transition of documentation and security protocols for all procedures, enhancing data governance and compliance
  • Conducted performance tuning on mappings, sessions, and workflows to minimize processing time and improve throughput
  • Identified and resolved performance bottlenecks by optimizing SQL queries, partitioning data, and fine-tuning session configurations
  • Implemented session and workflow parameterization for dynamic data loading and environment-specific configurations

Application Support Engineer

Warrior Safety Solutions
06.2017 - 06.2019
  • Creation of users and setup the roles in N-printing
  • Installation of N-printing and upgrading to new releases
  • Creation of connections and reloading of Meta data in N-printing
  • Creation of published task and generate the report to the destination Newsstand, email hub
  • SSL configuration and SMTP configuration
  • Creation of Streams and securing them with AD groups in Qlik Sense
  • Auditing of Resources Apps, Streams, content libraries, Data connection, Extensions Nodes User Sync tasks etc.in QMC
  • Perform deployment activities such as load balancing of Engine
  • Managing the scheduler nodes and configuring concurrent task accordingly
  • Managing virtual Proxy configurations
  • Migration activities across environments
  • Maintaining and managing the security rules over QMC
  • Monitoring and maintaining scheduled reload tasks
  • Automated System Administration: Developed shell scripts to automate routine system administration tasks, reducing manual effort by 60%
  • Log Monitoring and Analysis: Created scripts for monitoring system logs and generating alerts for anomalies, improving incident response times
  • Backup and Recovery: Implemented shell scripts for automated backups of critical data and systems, ensuring data integrity and availability

Application Support Executive

Tata Business Support Service
09.2013 - 05.2017
  • Working with customers/employees to identify setup box problems and advising on the solution
  • Logging and keeping records of customer/employee queries
  • Analyzing call logs so you can spot common trends and underlying problems
  • Updating self-help documents so customers/employees can try to fix problems themselves
  • Working with field engineers to visit customers/employees if the problem is more serious
  • Testing and fixing faulty equipment
  • Task Scheduling: Created scripts to schedule and automate routine tasks, such as software updates and maintenance activities
  • Data Extraction and Reporting: Used PowerShell to extract data from various sources and generate reports, enhancing visibility into system performance and usage
  • Cross-Platform Integration: Implemented PowerShell scripts to facilitate integration between Windows and Linux environments, enabling seamless operations across platforms

Education

Bachelors - computer science engineering

JNTU
04-2011

Accomplishments

  • Created scripts to take logs backup automatically for Qlik.
  • Queal is developed on windows PowerShell for Qlik Services auto restart in servers.

Timeline

Qlik Attunity Administrator/Scrum Master/ Informatica Analyst

TCS/Manulife
07.2022 - 05.2023

Qlik Replicate/Qlik Administrator/ Informatica Analyst

TCS/Manulife
05.2021 - 07.2022

Qlik Administrator/ Informatica Analyst

HSBC
07.2019 - 05.2021

Application Support Engineer

Warrior Safety Solutions
06.2017 - 06.2019

Application Support Executive

Tata Business Support Service
09.2013 - 05.2017

Bachelors - computer science engineering

JNTU
Haritha Palika