Harika Palika || IT experience of 11 years in Banking & Financial domain || Piscataway, NJ

Harika Palika

7323443774

harikamp24@gmail.com

Piscataway, NJ

Objective:

Highly motivated, goal-driven professional with overall verifiable IT experience of 11 years in Banking & Financial domain. Experienced in Installation, Architecture, 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, Cognos TM1, Business Objects. Analytics tools -QlikView, Qlik sense, Tableau, Power BI .

Professional Summary:

  • Over 10 Years of experience Database, Data Warehousing & Business Intelligence with strong experience in Enterprise Data Warehousing tools like Cognos
  • Extensive experience in using Cognos 8.x and Cognos 10.x/11.x BI tools (Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Metric Studio, Transformer)
  • Expert in architecting, planning, installing and configuring IBM Cognos BI
  • as a Developer and Administrator Involved in Metadata modeling using Cognos
  • Framework Manager, Cognos Transformer
  • 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 Cognos10.1 to Cognos 11 from On-premise to Google Cloud Platform (GCP).
  • Excellent knowledge in Performance tuning methodologies at database level, ETL,
  • and Report Level
  • Strong administrative knowledge of Cognos environment and tools IBM Cognos 8BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Report Net, Impromptu, Power Play, Impromptu Web Reports (IWR), Access Manager, Upfront and IWR servers.
  • Administered Access Manager to implement Security among Cognos applications.
  • Expert in the analysis, design and performance optimization of Business Intelligence/OLAP/ROLAP Reports.
  • Experience in Installation and Configuration of various Cognos Products.
  • Experience in delivery of solution-oriented complex reports using Report Studio and Development of ad-hoc reporting interfaces using Query Studio and analysis of reports from cube packages using Analysis Studio.
  • Extensively worked on various versions of COGNOS BI and TM1
  • Experience in Cognos TM1 10.1.1/9.5.2/9.5/9.4
  • Experience in TM1 server maintenance and Administration
  • Experience in Cognos server maintenance and Administration
  • Experience in Advanced Turbo Integrator scripting
  • Extensively worked on Rules to apply business rules to a cube
  • Experience in scheduling Turbo Integrator process using Chores
  • Designed architecture for Cognos.8 BI, Cognos Enterprise Planning, Cognos Reportnet and Cognos Powerplay, Infrastructure in large scale projects.
  • Expert in implementing dynamic security at all levels of TM1 objects
  • Maintaining and administering TM1 application on eight different Production servers by streamlining the daily process by performing automations.
  • Monitoring huge applications data sets with the help of operations console.
  • Expertise in Linux and unix command and Kron Shell Scripting
  • Working with the FP&A team for enhancing the existing applications and also helping with the Quarterly PNL and reporting the same.
  • Enhancing the TI code and rules for better performance and working on enhancements.
  • Administering and maintaining the existing TM1 Security.
  • Experience in DMR modeling with Framework Manager
  • Extensive working experience in TM1 Incl model and implementation including: Score carding, Workflow, Architect, TM1 Modeler, Contributor, TM1 Web, Café, Insight, Turbo Integrator, Feeders, TM1 cube design, reporting & security Expert in creating Active Reports in Cognos 10 Report Studio.
  • Trained power users in Business Insight Advanced to create reports using externalized metadata.
  • Expertise in Automating Cognos Deployments through Devops process (Jenkins/Github)
  • Extensively worked on Relational Databases like Oracle, MS-SQL Server, DB2 and Teradata
  • Experience with Dimensional Data Modeling and creating Star Schema/Snowflake
  • Strong experience in Architectural design for ETL and Reporting
  • Implemented Security at different levels in Framework Manager and Cognos Connection
  • Expertise in developing Complex Reports (List, Crosstab, Drill through, Master-Detail, Charts,
  • Maps, multi-query multi-prompt reports, burst reports) and Dashboards and Active Reports
  • using Report studio
  • Strong experience in best practices design and performance tuning
  • Involved in the Cognos Administration Tasks like Creating Data source Connections,
  • Publishing Packages, scheduling reports, User Creation, Assigning Security,
  • Deployment of Packages and reports in different environments
  • Involved in the Installation and Configuration of Cognos 8.x/10.x/11.x BI tools and
  • Framework Manager
  • Mentored and trained users in Query Studio and worked closely with business leaders,
  • data modelers and data warehouse developers to ensure consistent and accurate reporting
  • using Report Studio.
  • Experience in deploying, migrating, analyzing, performance tuning and optimizing
  • models, packages, reports and cubes from Development to QA, and then
  • from QA to Production environments.
  • Expertise in Agile methodologies and worked as a scrum master with
  • Business to define the scope of a project and assisting and Product Owners with Backlog grooming, creation of User Stories and their prioritization.
  • Building BI Solutions using Cognos 10 Dynamic Cubes, Dynamic Query Mode (DQM) and DMR based Analysis and Reports
  • Supported the Cognos Cubes.
  • Worked on replicating cubes and cube views between servers.
  • Experience with Cognos dynamic cubes version 11.x
  • Used the OLAP cubes for Cognos FM modeling and DMR packages for Report building.
  • Actively participated in industry network seminars & webinars to ensure awareness of BI trends
  • and best practices in order to strengthen technical expertise and improve organization performance.
  • Experience in customizing reports using Java Scripts
  • Service line champion in Project Shunya (Key objective of this program is to build
  • healthy race in achieving 3 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.
  • 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.

Training & Certifications:

Attended trainings on Data stage, Control-M and R

Knowledge in ITIL foundation and attended trainings on agile methodology.

Experience Summary:

Senior Consultant

Mercedez Benz Financial Services US LLC, Michigan 02/2020 to present

Projects : Value Partner Award Reporting, EValidate Reporting, Daily Funding by Discounter

Technologies Used: Cognos 10.x Report/Query Studio/Power play studio, Cognos 8.x/Cognos 10.x Framework Manager, DB2, Cognos Transformer, Cognos Power Play Client, Tableau desktop, Tableau Server.

Cognos Roles\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.
  • Collaborated with the ETL/DataStage team to determine the necessary data models and UI designs to support Cognos reports by defining relevant attributes, dimensions, hierarchies and metrics.
  • 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.
  • Implemented Framework Manager Security for row level access and package access based on the Department, Region and Store Level. Creation of procedures, views, tables and functions according to business requirements.
  • Managing and supporting Cognos BI environment as well as developing, configuring, implementing, and validating various reporting and analytical solutions to meet business needs and goals
  • Administering and providing a stable production environment for Cognos BI based systems and software applications as well as troubleshooting and making necessary modifications or adjustments in a timely manner to meet performance needs
  • Created several Kron Shell Scripting for connecting to database and for file manipulation of data.
  • Worked on Control-M tool for Scheduling & Monitoring jobs
  • Working with internal and external Cognos administration teams in planning, scheduling and managing BI system and software implementations, installations and upgrades as well as developing and maintaining security, and backup procedures as required
  • Ensuring resolution of production issues and tickets within Cognos environment in a timely manner and creating accurate and detailed documentation for Cognos project plans, requirements, designs, test cases, issues and user change requests as required
  • Monitored server, database, system hardware or software installation, configuration and upgrades in compliance with established security standards and best practices as well as supported application teams in resolving performance issues as required

Consultant Specialist 09/2009 to 12/2019

HSBC Software Development Private Limited

 

#1. Project: Digital Insight & Evergreening:

Digital Insight collects and processes data from a wide range of sources and enables users to access the data via three methods: Web trends, Cognos, Data/System/Application Integration

Role: Technical Lead

Technologies Used: Cognos 8.x/Cognos 10.x Report/Query Studio, Cognos 8.x/Cognos 10.x Framework Manager, Cognos Report Net, Oracle, Teradata and DB2.

Client: Software House (SWH), USA

#2. Project: GSD:

As Part of the production management tool strategy, a single version of the PM tools is planned that enables key operational activities with minimal input from end users. The unified tool would also embed an analytical solution and help drive efficiency across Global Service Delivery.

Role: Developer/Analyst/Tester

Technologies Used: Cognos 10.2.1 Report/Query Studio, Cognos 10.2.1 Framework Manager, Oracle 11g

Client: HSBC GR Warehouse

#3. Project: TMG Migration (Cognos On-Premise to GCP Cognos):

The aim of this project is to leverage the Google Cloud Facilities, in term of faster processing and reduce the costs

Role: Technical Lead/ Developer/Analyst/Tester

Technologies Used: Cognos 11, Google Cloud Platform (GCP), Google Big Query,

Teradata

#4. Project: UK Earth & Moon Customer Institution Operational Transparency:

This is part of Earth and Moon Program which address regulatory changed that come into effect on requiring all the UK banks to segregate their Retail and Investment operations

Role: Developer/Analyst/Tester

Technologies Used: Cognos 10.1.1, Teradata

#5. Project: Cross Border Data Restriction:

This is a regulatory project to meet the regulatory requirement of Cross border restriction, the current online solution requires enhancement to enable the data restriction in a heartbeat and not be dependent on to make the changes after weeks. Not enabling the data restriction in a timely period may lead to fines/reputational impact with regulators

Role: Developer/Analyst/Tester

Technologies Used: Cognos 10.1.1, Teradata,TM1

#6. Project: FTP COGNOS:

Cognos Migration from 10.2.1 version to 11.0.10. Upgrading the environment and validating of reports

Role: Developer/Analyst/Tester

Technologies Used: Cognos 10.2.1, Cognos 11.0.10, Teradata

#7. Project: Immigration Act:

IA reporting is critical regulatory reporting sent to the UK home office to report the fraudulent customers

Role: Developer/Analyst/Tester

Technologies Used: Cognos 10.1.1, Teradata,TM1

#8. Project: CRS MI:

A suite of MI Reports have been developed in Cognos to enable markets help to manage their Risk, this allows markets to monitor day to day operational risk and to assist in undertaking corrective action in line with their local procedures.

Role: Developer/Analyst/Tester

Technologies Used: Cognos 10.1.1, Teradata

#9. Project: Fire Fly Digital Reporting:

Fire Fly is a priority project which brought JLP numbers into Digital reports.

Role: Developer/Analyst/Tester

Technologies Used: Cognos 10.1.1, Teradata

Cognos Roles\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.
  • Collaborated with the ETL/DataStage team to determine the necessary data models and UI designs to support Cognos reports by defining relevant attributes, dimensions, hierarchies and metrics.
  • 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.
  • Implemented Framework Manager Security for row level access and package access based on the Department, Region and Store Level. Creation of procedures, views, tables and functions according to business requirements.
  • Created several burst reports using Cognos
  • Created agents and added tasks in Event Studio to run reports based on specific business criteria.
  • Created Drill-Down Hierarchies and used slicing and dicing technologies to provide optimized Reports.
  • Involved in Query Optimization and Developing Prompt pages and Conditional variables.
  • Created Drill- through reports and Customized Reports with Prompts.
  • Involved in working with Cascading Prompts, Conditional Formatting, and Conditional Blocking.
  • Performance tuning experience related to reporting queries required.
  • As a Developer and Administrator involved in the complete cycle of Project Plan, Design, Installation, Development, and Testing, Production Cutover,End User Training and Post Production Maintenance of the system.
  • Upgraded IBM Cognos 8.3 Environment to IBMCognos8.4 and Deploying and testing all the Reports.
  • Followed Step by Step approach of Upgrade Process for all the Dev, Test and Production Environments.
  • Setting up of the backups of all environments with backup and restoring of Content Store Databases, backups of Cognos Configurations, Deployment of Public Folders.
  • Installed all the components of Cognos 8.4 suite of products in Dev environment with Application and Gateway on a single server and Content Manager in another server
  • Installed all the components of Cognos 8.4 suite of products in 6 Servers of Prod environment with two for gateway, 3 App servers, One Appserver backup content manager, and one for content manager.
  • Configured the Cognos 8.4 environment using Cognos Configuration with Application, Gateway and Content Manager Connections.
  • Implemented Third Party Security with LDAP and use those in creating Data Level, Object Securities in Framework Manager Models.
  • Setting up the Content store by creating content databases in SQL Server Management Studio, SQL Server 2012 and Oracle 10g.
  • Setting up the Security of Cognos Suite of Products Query Studio to General Users, Report Studio Report Authoring to Power Users, Report Studio Professional Authoring to Report writers based on User Roles.
  • Setting up the Security to Cognos FM packages, Folders and Reports in Cognos Connection by granting up Read, Write, Execute and Traverse Permissions based on user requirements.
  • Participated in requirements gathering process to bridge gap between user needs and tool functionalities.
  • Monitoring and Troubleshooting of servers with Performance Issues.
  • Deployment of Models, Packages, Folders, Reports, Cubes, DataSources from Development environment to production environment.
  • 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.
  • Develop and support IBM Cognos TM1 models through all stages in the project life cycle.
  • Design and build successful technical solutions that involve TM1 cubes, dimensions, TI processes, rules, and executing the completion of the TM1 architecture per project.
  • Edit/create rules while utilizing Turbo Integrator.
  • Develop and support Cognos reports on TM1.
  • Develop and implement TM1 coding standards
  • Working with the users, Analyzing, design and plan Reports.
  • Analysis of the specifications provided by the clients.
  • Creating TM1 forecasting calculations based on requirements.
  • Involved in creating TM1 servers, Dimensions, Cubes, Subsets, etc. using TM1 Architect.
  • Created new Cubes and Dimensions manually, using dimension worksheets and also using Turbo Integrator.
  • Imported data into dimensions and cubes using Turbo Integrator
  • Creating a flexible modeling structure that is easily adaptable to future needs.
  • Creating TM1 Turbo Loader processes for populating TM1 cubes from source data.
  • Creating regularly scheduled automated jobs to load TM1 data structures.
  • Involved in routine task like loading the data into the particular cubes.
  • Used Analysis studio for multi-dimensional analysis and created context filters for better performance
  • Implemented Devops automation for Cognos Deployments.
  • Installed, upgraded, and maintained security of all Cognos BI components, software applications and systems and monitored and controlled server usage as required as well as implemented and documented best practices of Cognos infrastructures
  • Supported BI application implementation and Cognos deployment and upgrades in a clustered environment as required as well as migrated project changes from development to UAT and from UAT to production
  • Allowed users access to Cognos namespaces and related software or applications as required as well as configured databases for multilingual reporting using IBM Cognos Analytics
  • Communicated various Cognos system performance issues with BI teams in a timely manner and recommended service improvements as required as well as provided technical support and consultation for system or application usage and maintenance to users

Education:

Osmania University 2005-2009

Bachelor of Engineering-ECE

Noteworthy Accomplishments in HSBC:

  • Received RISE Award in the first year of my service in HSBC (2010).
  • Nominated for Shine Award for Annual Rewards 2017.
  • Received Prime Award for Productivity improvement and Efficiency.
  • Received Team Awards.
  • Received Team Quality Catalyst Award in 2019 as part of Quality Initiative.
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, COGNOS TM1 9.4/9.5/9.5.1/10.1.1, Web Trends, Cognos Power play Transformer, Oracle Essbase,
Devops Tools GitHub, Jira, Nexus, Jenkins, Eclipse, RTC
Cloud Platforms Google Cloud Platform (GCP)
Languages SQL, Python, C, C++
Databases Teradata, Oracle, DB2, SQL Server 2005/2008/2012, Post gre, Big Query
Operating Systems Unix, Windows

Leave a Comment

%d bloggers like this: