SRINIVASAN GANESAN
Chennai
Summary
- To utilize the knowledge of Business Application skills and concepts in a challenging & growth oriented manner for the organization and using every opportunity to learn more in the fields of technology, which will help me to implement the same in the Business needs.
- Having 16+ years of professional experience in Data warehousing with strong background in business analysis, technical architecture and database technologies
- Specialized in informatica in designing and Implementing Data Warehouse applications using Informatica Power Center 10.X,9.x,8.x,7.x,6.x, Also worked with Netezza & Business Objects in different projects
- Proficient in understanding Business Process/requirements and translating them into technical requirements.
- Performed all dimensions of development including Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts. Also involved in testing and production rollout process
- Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like target, source, mapping and session.
- Experience in performing SQL query optimization .
- Hands on experience in Data modeling using Dimensional data modeling concepts
- Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
- Strong Knowledge and understanding of SQL and ability to fine-tune SQL queries
- Strong in Data Warehousing concepts
- Have worked on various client server technologies and worked on various databases.
- Have very good experience on BI/DW technologies Have extensively used Data Modelling tools
- Have conducted Knowledge sharing sessions / Internal training
- Excellent interpersonal, Organizational and client interaction skills
Overview
18
18
years of professional experience
5
5
years of post-secondary education
Work History
Senior Project Lead
Systech Solutions
09.2022 - Current
- Managed project planning and execution from initiation to closure.
- Identified and took action to mitigate potential risks and made recommendations to management.
- Implemented effective communication strategies for team members and stakeholders.
- Conducted regular meetings with team members to discuss progress, challenges, and solutions.
Production support Manager/SRE
TCS , Client : CIGNA CORPORATION
04.2021 - 09.2022
- Managing the Operational data store(ODS) tower for offshore
- Participate in client governance calls
- People management including Performance Reviews and Work Allocation
- Management Reporting which includes weekly status report on project progress/issues/risks
- Coordination with onshore team for all project related tasks
- Worked closely with staffing team in hiring the resources for the team
- Actively involved in employee rating/feedback/remuneration discussions with management
- Communicate Project Status to customer & account team
- Closely work with onshore project manager to meet the deadline
- Effective communication with customer
- Maintain good relationship with customer in getting new business
- Allocating the service now tickets to the team and providing technical help on critical tickets
- Creating Dashboards for client's using splunk
- Conducting Root cause analysis on the job failures
- Understand release and deployment activities and provide inputs to the team
Onsite Technical lead
TCS : Client : CIGNA CORPORATION
03.2014 - 04.2021
- Analyzed business documents and created software engineering requirement specification
- Helped business analyst in design, development and implementation of the Enterprise Data Warehouse and Data Marts
- Extracted data from the various source systems that include Oracle, SQL Server, DB2 and flat files
- Created and walked the team through mapping specification document
- Developed several mappings using transformations like Source Qualifier, Expression, Aggregator, Joiner, Lookup, Sequence Generator and Update Strategy etc in Informatica to populate the data to the target systems
- Improved the mapping performance by overriding the default SQL queries
- Running parallel sessions reduced the time for loading the data
- Partitioning the session improved the session performance by creating multiple connections to the source and target systems
- Performed unit and system testing of developed mappings
- Managing the development and testing ETL workflow and performance tuning
- Project Environment: Informatica Powercenter 9.1.1, Oracle 11i, UNI
Team Lead
CNA Financial Corporation
02.2012 - 01.2013
- Company Overview: CNA Financial Corporation is a financial corporation based in Chicago, Illinois, United states
- The primary business focus of CNA is to provide commercial property and casualty insurance to businesses and professionals
- Analyzing the data and designing the Data model and developing the ETL standards and strategies to load the DW
- Creating transformed data according to business rules
- Designed and developed the Ad Hoc reports and responsible for resolving the issues
- Developed pre and post SQL scripts for Informatica jobs, PL/SQL stored procedures and functions
- Used debugger to identify the bugs in the mappings and fixing errors so that they confirm to the business needs
- Optimized SQL queries using hints and indexes
- Analyzed clients' requests for new or modified applications through interviews and design sessions
- Involved in Planning and scheduling of the work among the resources
- Extensively involved in ETL code using Informatica Power Center in order to meet requirements for extract, transformation, cleansing, and loading of data from source to target data structures
- Responsible for weekly status updates showing the progress of the ETL process
- Managing the development and testing ETL workflow and performance tuning
- Allocating the tasks to the team members
- CNA Financial Corporation is a financial corporation based in Chicago, Illinois, United states
- The primary business focus of CNA is to provide commercial property and casualty insurance to businesses and professionals
- Project Environment: Informatica Powercenter 8.1.1, Oracle 10G, UNIX
Team Lead
Walmart.com
01.2011 - 01.2012
- Company Overview: Walmart.com is a subsidiary of Wal-Mart stores, inc
- Founded in 2000 with headquarters in Brisbane,CA More than one million products are available online which enable customers to order online and receive at home or pick it up at their local Wal-Mart retail
- Understanding the business and requirement of the project
- Analyzing the data and designing the Data model and developing the ETL standards and strategies to load the DW
- Creating transformed data according to business rules
- Managing the development and testing ETL workflow and performance tuning
- Coordinating and communicating with the client daily
- Allocating the tasks to the team members
- Walmart.com is a subsidiary of Wal-Mart stores, inc
- Founded in 2000 with headquarters in Brisbane,CA More than one million products are available online which enable customers to order online and receive at home or pick it up at their local Wal-Mart retail
- Project Environment: Netezza 4.0.4, Informatica Powercenter 8.1.1, BusinessObjects XI R2, UNIX
Senior Technologist
Systech Solutions Pvt LTD
07.2007 - 01.2012
CPE Lead (onsite)
Walmart.com
04.2010 - 12.2010
- The scope of this project is to work with production support and business support
- Work with the business user to get their requirement and fulfill their request in a short time provided
- The request would be created in terms of remedy tickets
- Every development in the ticket status should be updated in the remedy tool with list of emails attached
- Many requests would require involvement of multiple teams, in such cases need to co-ordinate with multiple teams to fulfill the requirement or reassign it to appropriate team
- Responsible for daily/monthly ETL to be completed and all critical reports to be published on time
- Business Support: communicate with business users and fulfill adhoc business requirements such as data request, adhoc reports, ETL logic changes and backtracking/Fixing issues
- Coordinating with the offshore team and update the remedy ticket status
- Develop adhoc reports to fulfill data request
- Production support - Monitor the load, resolve and escalate issues in case of any session failure
- Project Environment: Netezza 4.0.4, Oracle 10g, Informatica Powercenter 8.1.1, BusinessObjects XI R2, UNIX, BMC remedy 7.0.01
ETL/Report Developer
Walmart.com
04.2008 - 03.2010
- The scope of the project is to work with Walmart.com Reporting Team on enhancements and changes to the existing system through release updates
- Understanding the business and preparing the Understanding document
- Analyzing the data and designing the Data model and developing the ETL standards and strategies to load the DW
- Creating transformed data according to business rules
- Managing the development and testing ETL work flow and performance tuning
- Documenting the entire process
- Designing, Coding, Developing, and Formatting, Testing the new reports developed
- Modifying the existing reports and performance tuning
- Coordinating and communicating with the client daily
- Project Environment: Oracle Database 10g, Netezza 4.0.4, Informatica PowerCenter 8.1.1, Business Objects XI R2, Shell Programming, Win SQL
Education
Master of Science - Computer Application
SASTRA University
Tanjore 04.2001 - 01.2006
OCA - SQL
Skills
Informatica Power Center , IICS
Business Objects
Splunk
Oracle
Netezza
Microsoft SQL Server
Snowflake
Redshift
Databuildtool (DBT)
Timeline
Senior Project Lead
Systech Solutions
09.2022 - Current
Production support Manager/SRE
TCS , Client : CIGNA CORPORATION
04.2021 - 09.2022
Onsite Technical lead
TCS : Client : CIGNA CORPORATION
03.2014 - 04.2021
Team Lead
CNA Financial Corporation
02.2012 - 01.2013
Team Lead
Walmart.com
01.2011 - 01.2012
CPE Lead (onsite)
Walmart.com
04.2010 - 12.2010
ETL/Report Developer
Walmart.com
04.2008 - 03.2010
Senior Technologist
Systech Solutions Pvt LTD
07.2007 - 01.2012
Master of Science - Computer Application
SASTRA University
04.2001 - 01.2006
OCA - SQL
Similar Profiles
Surya ThangarajSurya Thangaraj
Enterprise BI Architect at Systech SolutionsEnterprise BI Architect at Systech Solutions
LAKSHMANA MURTHY RAJU MUDUNURILAKSHMANA MURTHY RAJU MUDUNURI
Data Engineer at Systech SolutionsData Engineer at Systech Solutions
SAI YARRAMSAI YARRAM
Data Engineer at Systech SolutionsData Engineer at Systech Solutions
Monika KMonika K
Billing Operation at ToastBilling Operation at Toast
V Madhwaraj RaoV Madhwaraj Rao
Senior Consultant at Infosys LimitedSenior Consultant at Infosys Limited