Kamal Kumar Ramachandran
Menomonee Falls,WI
Summary
Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specific goals |A proven track record of working in a fast-paced environment| Highly-motivated employee with desire to take on new challenges. Strong work ethic, adaptability, and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills.
Overview
13
13
years of professional experience
Work History
Senior Data Engineer
Northwestern Mutual
Milwaukee, WI
04.2018 - Current
- The Core Data Integration team focuses on the build-out of Business Information Integration Platform (BIIP) to provide accurate and timely enterprise data for operational reporting & data integration needs across the enterprise
- This includes the consolidation of Enterprise data across multiple domains including Client, Product, Investment and Field from various Northwestern Mutual systems into BIIP and building services so that various applications in the enterprise can access this data
- CDI team is accountable for designing and implementing data integration patterns aligned with Enterprise Architecture.
- Data integration patterns cover both Real-time and overnight Batch to meet the consuming application needs.
- Managed performance monitoring and tuning while identifying and repairing issues within database realm.
- Collaborated with other teams to understand their requirements and deliver solutions accordingly.
- Assisted solution providers with definition and implementation of technical and business strategies.
- Cleaned and manipulated raw data.
- Created ETL scripts to move and transform data from various sources into a centralized repository.
- Integrated multiple heterogeneous sources into one unified source via ETL processes.
- Developed data pipelines to ingest and process large datasets.
- Maintained open communication with team members and stakeholders, resulting in successful project outcomes.
- Worked with cross-functional teams to achieve goals.
- Understood and followed oral and written directions.
Scrum Master/Lead ETL Developer
ULINE
Pleasant Prairie, WI
07.2017 - 04.2018
- The objective of this project is to come up with a redesign for the existing data warehouse and to incorporate changes in the design to support efficient reporting model by minimizing various join options and reducing redundant calculations that are present in the existing model
- The Data Engineering track of the project would support the database model in designing and executing solutions that would extract data from SQL Server 2016 and DB2LUW databases and park them across the redesigned set of dimensions and facts
- The solution implementation is in progress through Informatica(10x), SSIS and with Power BI, SSRS and Cognos for reporting metrics.
Lead ETL Developer
Northwestern Mutual
06.2015 - 07.2017
- The Main Objective of the project is to reduce the total number of documents (Insurance Policies) that were printed in house at the Franklin Campus
- The Strategy to implement the solution was to identify the existing business rules, enhance the rules and document layout and send the same to the vendor using secured file transfer protocol
- The house holding and opening of online viewing / archiving were some of the main features that were implemented
- The solution implemented was through Informatica(9x) and with Power BI, Power Query and Powerpivot for reporting metrics.
Project Lead
GE-Healthcare
Waukesha, WI
04.2014 - 06.2015
Powerpivotrmatica(8x,9x), Teradata (v12) for the ETL and OBIEE, Spotfire as the Reporting tool
Team Lead
GE-Healthcare
Bengaluru, Karnataka
01.2013 - 04.2014
ETL Lead Developer
GE Power and Water
11.2010 - 01.2013
Education
Bachelor’s in Engineering -
Anna University, India
Job Skills And Responsibilities
- Over 13+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of Data Warehouse and Business Intelligence solutions.
- 6+ years of Scrum Master and over 13+ years of Business Intelligence Project Lead
- Healthcare, Insurance and retail domain experience on large, complex, multi-phase, multi-million-dollar projects.
- Extensively worked on projects with Agile Methodology with Kanban and worked as technical scrum master and roles including running scrum meetings, Sprint planning, reviews and retrospectives.
- Data analysis and data migration using SSIS packages.
- Worked extensively with Informatica Designer Tools Source Analyzer, Target designer, Transformation Developer, Mapping Designer and Mapplet Designer.
- Efficient record in working and managing onshore-offshore model as well as Onshore development model.
- Proven track record in planning, building, and maintaining successful large-scale Data Warehouse and Decision Support Systems. Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data loading and Data management.
- Excellent project management capabilities with respect to identifying risk, issues and challenges
- Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
- Having very good knowledge and experience in various development methodologies like SDLC, Waterfall and Agile etc.
- Expertise in Configurations and Administration of Informatica Power Center and deploying ETL code to various environments such as QA and UAT and PROD.
- Hands on experience in designing and creating various reports using Spotfire, Tableau, Power BI and OBIEE 11g reporting tools for Business reporting and for end to end testing.
- Good experience in writing UNIX Shell scripts and with usage of Job scheduling tools
Languages
Informatica Power Exchange
Full Professional
Informatica Power Center
Full Professional
Data Warehousing
Full Professional
Data Modeling
Professional
Power BI
Limited
SSIS and SSRS
Limited
DB2
Professional
Teradata
Professional
AWS
Elementary
Certification Details
- Certified Scrum Master - SaFE
- Basics on Big Data programming -Edureka
- Data warehousing Concepts - Edureka
Accomplishments
- 2X CDA MVP 2022 and 2023
References
- Venkata Sudheer Chebroulu , Lead Data Engineer , Northwestern Mutual
- Rajendran Perumal , Assistant Director , Northwestern Mutual
- RaviKumar Ponnusamy, Senior Director , FIS Global, Ravikumarp1988@gmail.com, +1(414)-326-8232
- Nalini Tadiparthi, Senior Manager Projects, Capgemini, +1(952)-769-6009,
Timeline
Senior Data Engineer
Northwestern Mutual
04.2018 - Current
Scrum Master/Lead ETL Developer
ULINE
07.2017 - 04.2018
Lead ETL Developer
Northwestern Mutual
06.2015 - 07.2017
Project Lead
GE-Healthcare
04.2014 - 06.2015
Team Lead
GE-Healthcare
01.2013 - 04.2014
ETL Lead Developer
GE Power and Water
11.2010 - 01.2013
Bachelor’s in Engineering -
Anna University, India