Summary
Overview
Work History
Education
Skills
Timeline
Generic

Avinash Meyyappan

Wildwood,MO

Summary

Talented Manager with expert team leadership, planning and organizational skills built during successful career. Smoothly equip employees to independently handle daily functions and meet customer needs. Diligent trainer and mentor with exceptional management abilities and results-driven approach.

Overview

17
17
years of professional experience

Work History

Manager- Data Engineer

Centene Corp
01.2019 - Current
  • Proficient in Technology leadership, architecture, building great teams, strategy planning, project management, client/partner management and budget planning etc.
  • Strong technical leadership skills with experience in managing customer, vendor and teams .
  • Engagement Manager with hands on experience in leading and successfully implementing Multi-Million Dollar Programs of Scale 5 M USD to 10 M USD in recent years
  • Strong problem solving & technical skills, learnability of New Technology and evangelization
  • Proven abilities and Insightful experience in project management activities including project scoping, estimation, planning, risk management, finalization of specifications, change and risk management and resource administration in multiple projects within budgets and execution timelines.
  • Crafting technology strategic vision, roadmap and leading data teams to deliver creative solutions leveraging OnPrem , Cloud & open-source technologies
  • Strong technical skills with hands on ability in big data solutions.
  • Managing multiple teams, managers, leaders, architects, principal engineers, and TPMs
  • Growing teams, develop people, uplift skills and turning teams into highly performing teams
  • Build trust and improve relationships with business and technology partners
  • Architecting and delivering analytic data solutions that power business capabilities
  • Streaming technologies, enterprise integration, and data warehousing solutions both on-premise and cloud
  • Cloud Migration to modernize data estates /data strategies
  • Lead full life cycle planning & delivery of projects and provide hands-on technical leadership to engineering teams
  • Experience in Telecom, Healthcare, Manufacturing and Financial domains
  • Data driven marketing campaign solutions with highly personalized data, recommender's and targeted messages
  • Partner and manage relationship with vendors
  • Translate long term strategy to roadmap

Senior Data Engineer

US BANK
05.2014 - 11.2018
  • Understanding mortgage application and leveraging Kalido tool to map tables from source (Black Night Mortgage Servicing Platform).
  • Responsible for all business user request in mortgage servicing space.
  • Developed and maintained BI universe encompassing servicing tables.
  • Huge initiative and Cost reduction in converting reports that were using third party software (Passport) to Business Objects.
  • Developed knowledge of all servicing workstations like Bankruptcy, Loss Mitigation, REO, Foreclosure and Collections.
  • Participated in requirement gathering, cube design, application design, SSAS development, training operational users.
  • Constructed cubes based on data volumes mostly adhering to Star Schema.
  • Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on OLAP Reporting needs.
  • Implemented SQL Server OLAP services (SSAS) for building data cubes.
  • Creating complex cubes for seeing business data from different perspectives by slicing and dicing data.
  • Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying data with MDX script.
  • Defined MDX scripts for querying data from OLAP cubes (SSAS) and build reports on top of cubes.
  • Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
  • Designed and implemented fact, dimensions and SSAS cubes using dimensional data modeling standards in SQL server 2012/ Business intelligence development studio.
  • Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements
  • Communicated new or updated data requirements to global team
  • Designed advanced analytics ranging from descriptive to predictive models to machine learning techniques

Software Application Developer

SAMBA INC
06.2010 - 04.2014
  • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline proposed solution.
  • Build new universes as per user requirements by identifying required tables from Data mart and by defining universe connections.
  • Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification.
  • Transforming high-level design spec to simple ETL coding.
  • Designing mappings according to mapping standards, naming standards and warehouse standards for future application development.
  • Created Common objects for ETL team to maintain Common Code and Documented standards for Informatica code development.
  • Involved in creation and maintenance of logical and physical data model using ERWIN tool.
  • Extensively used UNIX based UDB loader scripts to load data from DB2 to XML files and DB2 tables to Flat Files.
  • Used Informatica to load data from Flat Files/CSV files/XML files to DB2, DB2 to Flat Files.
  • Created Informatica mappings using the transformations like Source Qualifier, XML SourceQualifier, Unions Aggregator, Expression, Lookup, Router, Normalizer, Filter, Update Strategy and Joiner transformations.
  • Created several complex Informatica mappings as per business requirements.
  • Created reusable transformations and Mapplets and used them in complex mappings.
  • Crated SCCS & CMR tickets for Code migrations & data fixes.
  • Performed Unit Testing and Integration Testing for Data Warehousing Applications and tuned for better performance.
  • Involved in 24/7 on-call support for Info Factory, CDM, and CRM related jobs in Systems & QA & Production environments.
  • Involved in Code Reviews & suggested best practices and presented Informatica new features in USER Group meetings.

Sr. Data Consultant

Toyota Motors
09.2007 - 06.2010
  • Developed and Designed Universes, created classes and Sub-Classes, Objects, Conditions, Join, Alias, Contexts using Designer.
  • Extensively worked on OLAP cubes for building universes.
  • Work with SAP support to resolve any BO related tickets/issues.
  • Created reports with Bex queries as data source.
  • Created Aliases and Contexts for solving Join path problems in Business Objects.
  • Migrated Universes & Reports from BO 6.5x to BO XI R2 Environment using Import Wizard.
  • Configured Development, Test and Production environments and synchronize user accounts on all three environments.

Sr. QA Engineer

RedBull
10.2006 - 08.2007

QA / Development

Amp'd Mobile
01.2006 - 08.2006

Education

Master of Science (M.S) - Industrial Engineering

Wayne State University
2005

Bachelor of Science (BE) - Mechanical Engineering

University of Madras
India
2002

Skills

  • Data Stream : Apache Kafka, Spark Stream
  • Cloud Data Warehouse : Snowflake, redshift
  • Cloud Platform : AWS, GCP, Microsoft Azure
  • Analysis tool : Power BI, Tableau, MicroStrategy, QlikView, SSRS
  • Big Data: Sqoop, Hive, Elastic Search, Scala, and Spark
  • Machine Learning : Python
  • ETL: Informatica power center and power designer, Talend, Alteryx, Microsoft SSIS
  • Database Tools: SQL server, Oracle, Teradata, MongoDB

Timeline

Manager- Data Engineer

Centene Corp
01.2019 - Current

Senior Data Engineer

US BANK
05.2014 - 11.2018

Software Application Developer

SAMBA INC
06.2010 - 04.2014

Sr. Data Consultant

Toyota Motors
09.2007 - 06.2010

Sr. QA Engineer

RedBull
10.2006 - 08.2007

QA / Development

Amp'd Mobile
01.2006 - 08.2006

Master of Science (M.S) - Industrial Engineering

Wayne State University

Bachelor of Science (BE) - Mechanical Engineering

University of Madras

Similar Profiles

CREATE PROFILE
Avinash Meyyappan