Summary
Overview
Work History
Education
Skills
Timeline
Generic

Hariharan Ganesan

Burlington

Summary

Technical professional with a Bachelor’s degree in Engineering, having more than 18 years of experience in the Data warehousing, Business Intelligence Reporting, Email Marketing and Banking and Financial software services Industry. More than 15 years of experience in planning, developing and implementing Marketing Database solutions, leading cross functional teams in software development. Have gone through the complete SDLC phases for dozens of custom applications in building database solutions with analysis, design, coding, testing and production support of online applications and possess good analytical, communication, interpersonal, and leadership skills. Technical acumen in ETL suite like Talend - Architect, design and develop ETL solutions for various marketing database. Technical expertise in Cognos suite of products– Designing and Development of reports, cubes and metadata layer to facilitate various business reporting needs. Technical expertise in dimensional modeling and data warehousing concepts with exposure to STAR schemas, building optimized metadata layers and OLAP cubes. Excellent analytical skills in detailed data analysis of large database, identifying gaps and anomalies in the data set and improving the data quality. Good experience in Oracle, SQL Queries and Procedures. Good understanding of Oracle data warehouse with performance tuning. Instrumental in forming a BI Reporting Competency Center which would provide reporting solutions, design recommendations to all applications in our project. Delivery & Planning–Optimized time estimates and progress monitoring against detailed project plan. Good Customer facing skills, Communication, Documentation Skills and Testing Skills. Leadership Qualities in managing and mentoring a team in the Database development and guide the users about the system. Flexible, adaptable and adept in picking up new technologies, handling extra responsibilities and works well under pressure. Strong domain experience in Email campaigning, Online Database Marketing, Global Payments Reporting, Risk Management, Receivables, Same Day Reconcilement Services, Collections, Securities Lending, Investment Banking, Private Banking.

Overview

24
24
years of professional experience

Work History

Software Architect/ Reporting & DB Lead Developer/Team Lead

Infogroup Inc/DataAxle Inc.
Burlington
07.2012 - Current
  • Pioneered, Engineered and successfully implemented the whole database solutions with ETL architecture though Talend and BI Reporting through Cognos
  • Drove the high-quality completion of various system integrations and enterprisewide software upgrade/migration projects
  • Develop architectural design, data modeling of various dimension/fact tables, data validation/extract processes improving the client data quality by 25%
  • Develop standard framework structure for various modules for campaign and marketing DB thereby improving the performance and productivity by 30%
  • Impart training to the business users on various DB builds and coaching developers and establish standards for Databse/ETL design and development ensuring high quality of the deliverables
  • Managing the day to day production support for various clients and resolving end user issues/queries on a priority basis
  • Leading the onsite-offshore model in training/mentoring the offshore resources for DB development/support and managing the deliverables within the project timelines
  • Going above and beyond to make sure the clients are happy with the deliverables and strive for building a long-term relationship with them

Oracle Financial Services Software Inc.
Boston
10.2007 - 06.2012
  • Gather Reporting requirements, analyze technical feasibility and estimate efforts
  • Pioneered the migration activity from Cognos and Actuate migrations
  • Develop architectural design, Dimensionally Modeled Relational (DMR) modeling of SFBI enterprise data through Cognos framework models thereby improving the data quality by 25%
  • Impart training with Cognos Reporting to business users and train developers coming up with various presentations and documents
  • Helped the project with shouldering additional responsibilities of handling the SFBI module increasing the productivity by 20%
  • Onsite coordinator, Team Lead and Application Architect for all the SFT Reporting projects coming up with the effort estimation, project tracking and ensured quality deliverables with minimal defects

Technical Team Lead

Oracle Financial Services Software Inc.
Chennai
09.2006 - 09.2007
  • Team Lead for all the CPB Reporting projects coming up with the effort estimation, project tracking and ensured quality deliverables with minimal defects
  • Formed Actuate Competency Center for CPB to cater to all its reporting needs
  • Formed a team of 3 entry level developers, trained them in Actuate, led them effectively in a resource crunchy situation
  • Created templates, checklists and streamlined the processes for design, development and testing of reports that would minimize the defects and ensure high quality delivery

Senior Developer

Oracle Financial Services Software Inc.
Bangalore
05.2005 - 08.2006
  • Involved in the requirement study, analysis, design and development of the six new UI screens for Agency Lending Disclosure Daily (ALD) application
  • Designed and Developed new Actuate reports along with providing production support for the existing reports
  • Identified the grey areas in the SQL queries that affect their performance increasing the query performance by 20%

Senior Developer/Analyst

Polaris Software Labs Limited
Chennai
06.2001 - 04.2005
  • Designed and developed new Actuate Reports, held training sessions for the freshers for familiarizing with the Actuate reporting tool, CitiDirect Reporting Framework and various other functionalities
  • Was part of the founding team of “CitiDirect – Report Customizer
  • This project was initiated to give, enhanced customizability to the user in accessing and using CitiDirect Reports
  • Designed and developed new Actuate Reports and was awarded CITIDIRECT ‘Man of the Month’ award multiple times for timely deliverables, better quality, customer appreciation in supporting the application

Education

B.E.(Hons) - Mechanical Engineering

Birla Institute of Technology and Science
Pilani
01.2001

Skills

  • IBM Cognos
  • Actuate Reporting tool
  • IBM Rational Application Developer 70
  • IBM Rational ClearCase
  • Talend ETL
  • SalesForce Marketing Cloud
  • IBM Unica
  • Jira
  • Google Analytics
  • IBM Acoustic
  • Windows
  • UNIX
  • Java
  • Oracle PL/SQL
  • Python
  • Perl
  • Oracle
  • MySQL
  • Redshift
  • Talend Studio and Administrator Console
  • Tableau Public
  • Tableau Desktop
  • AWS S3
  • Glue
  • ElasticSearch
  • Kibana
  • Adobe Experience
  • IBM Cognos Analytics 12
  • Actuate e-Report/eSpreadsheet Designer
  • Actuate BIRT
  • Actuate iServer
  • ETL suite like Talend
  • Cognos suite of products
  • Dimensional modeling and data warehousing concepts
  • Oracle, SQL Queries and Procedures
  • BI Reporting Competency Center
  • Customer facing skills
  • Leadership qualities

Timeline

Software Architect/ Reporting & DB Lead Developer/Team Lead

Infogroup Inc/DataAxle Inc.
07.2012 - Current

Oracle Financial Services Software Inc.
10.2007 - 06.2012

Technical Team Lead

Oracle Financial Services Software Inc.
09.2006 - 09.2007

Senior Developer

Oracle Financial Services Software Inc.
05.2005 - 08.2006

Senior Developer/Analyst

Polaris Software Labs Limited
06.2001 - 04.2005

B.E.(Hons) - Mechanical Engineering

Birla Institute of Technology and Science
Hariharan Ganesan