Data Engineering Health Care
Resume:
• Contact
Cumming, GA *****
***********@*****.***
• Skills
TECHNICAL SKILLS
DATABASE Snowflake, Teradata, Vertica,
Oracle
Excellent
ETL TOOLS Informatica, TPT, BTEQ, Vsql,
SNOW-SQL
Excellent
PROGRAM LANGUAGE: C, SQL, PL/SQL,
Python, Shell, PHP,Javascript
Very Good
BIG DATA: Hadoop, PySpark, Hive, Pig,
Nifi, Sqoop, Kafka
Excellent
CLOUD: AZURE/AWS, SQL DW, Data
factory, S3, Athena
Excellent
BI TOOLS Tableau, Power BI, Business
Objects
Very Good
Ram Venugopal
Data Engineering
Sr. Manager
A distinguished leader with a unique blend of technology and business skills, organizational management, product engineering, and academics centered on Data engineering/optimization, driving business value by critically aligning IT capabilities. Expert in Cloud database and Technologies 22+ years of experience in Business Intelligence and successful in BI Analytics software delivery in many Fortune 500 companies including Health Care IT (Health plans, Health care records, Consumer Analytics/Care Management, Member 360), and Telecom. / Retail Distribution/CRM/ Online Marketing etc.
• Work History
Sr. Manager
3M Solventum 2021 JAN- Current
• Data Migration from Hadoop to Snowflake. Data Engineering and MDM.
• Implemented Architecture data flow layers of Snowflake: Develop an architecture Blueprint to integrate various Applications in a Hybrid Cloud Database environment
• Masking policy to adhere PHI standards; RSA for controlled access of confidential COGS data
• Lead the data lake compliance program by implementing security across applications and consumption patterns
• Healthcare critical analytics on MyWoundHealing and IonHealing. Designed and Implemented Volume and Revenue Models. Models also helped in identifying new KPI’s and metrics, exposing revenue leakages and operational gaps
• MDM Provider: Healthcare provider and Healthcare Partners data to support Enterprise level APIs.
DEVOPS TOOLS: GIT, Jenkins, Jira
Good
• Fuzzy Wuzzy, Soundex, Metaphone: advanced algorithms and libraries logic to implement integrated Provider layer along with Address matcher.
Sr. BI Leader
CIOX Health, Alpharetta, GA 2017 AUG – 2021JAN
• Projects: CIOX Milestones - BIZMETRICS (BI and Analytics) Cloud migration Data Discovery
• Snowflake migration using hybrid migration model (combination of lift & shift and staged).
• Managed team of Data architects and Data Engineering for implementation of various strategic Hadoop & DWH programs working closely with client, performing estimates, mitigating risks and delivering on-time as per schedule & cost
• Building roadmap for migrating Hadoop & Teradata DW to Azure cloud and Snowflake
• Spear headed creation of Data Engineering team to build Data Products, Data Libraries and Business-ready dataset which will be consumed by Data scientists & Data analysts
• Implement and present proof of concepts for various innovative solutions to optimize performance and reduce cost. Sr. Enterprise Advisor
Anthem Inc, Atlanta, GA 2014 APR – 2017 JUN
• Projects: CM Auto Referral Bundle Payments Provider Data Layer
(MDM)
• Lead the data lake compliance program by implementing security across applications and consumption patterns
• Integrating and developing custom applications and database solutions & BI systems
• Scoping, estimating, and delivering, Strong consulting, leadership, communications, and technical skills across the entire software development life cycle (SDLC)
• Includes data warehousing, BI, web and Big Data
• Lead multiple or large projects and facilitates large group JAD sessions, modeling in several disciplines.
• Playing key role to convert/re-engineer current ETL process built around Teradata & Hadoop converted into Snowflake centric
• This saved funds, involved with Expensive environment Teradata
• Architect of solution built to Automate the Case Management Referral process and created robust application can be used as device to exchange information and data with External Providers to Anthem.
• Cloudera Hadoop: Data Lake, Data Discovery, Data Dumps etc. Technical Manager
AT&T Inc, Alpharetta, GA 2008-2014
• Lake Customer Relationships Management (CRM) PCA Profile & Action of Customer Engine IMDM Internet Marketing Data Mart
• As Principal Technical Architects at AT&T inc, driven the RoadMap to the Business and Specifications requirements process, suggested standards, provided guidance on setting Vision and Goals for whole Agile team
• Evaluated the Database platform engines for the Analytical Insight management and Discovery Data Store (Big Data environment)
• Built/designed end to end data flow ODS Operational data store to support operational reports, Data warehouse & Data Marts to support analytical reporting.
• Designed the whole product/application for the Profile Customer Action Engine(PCA) relating to different accounts, profiles, demographics, Credit(Score) Group and other customer information under one common View
• Enabled StoreRep to have better insight of customer to offer/sell more appropriate product
• Designed and Architect(ed) for the Data Lake of Vertica Environment and Hadoop environments
• CRM domain: Designed Customer Modeling in CRM and Campaign Management Tool
• Responsible for the Data Lake design and evaluation for the Database Engine (DB)
• Guided business and team to lay roadmap, classify the requirements, building the templates of the Artifacts, Retention Standards, Cost evaluations etc.,
• Supported the Performance improvement and enhancements for the data in the Vertica Platform and laid standards for the Design and Development
• Designed the Data Migration project from Teradata to Vertica and provided Cost Effective solution
• Responsible for Strategy and road map provided for the migration project; without affecting Clients/Customer reports, without changing the granularity of the data and retain critical data/process in Teradata and maintain the other data in the cost-dear platform Vertica
• Optimized & Tune the Data load jobs according to the Architecture of the Vertica Database
• Experience in an Agile-based delivery environment
• Coordinated with Scrum of Scrum master
DataWarehouse Engineer
National Grid Transco 2003-09 - 2004-04
• Education
1998-2001
Master of Science: Computers
Central University Pondicherry - Pondicherry India 1995-1998
Bachelor of Arts: Commerce
PVKN Arts College - Chittoor India
• Certifications
Master Certified Teradata Professional V2R5 (completed 6 levels) Master Certified in Data Modeling concepts
• Affiliations
BIG DATA ANALYTICS DWH & BUSINESS INTELLIGENCE DATA ARCHITECTURE & INTEGRATION AWS /AZURE CLOUD MIGRATION PREDICTIVE ANALYTICS DATA GOVERNANCE & SECURITY BUDGET & COST MANAGEMENT DEVOPS & AGILE METHODOLOGY BUSINESS PROFICIENCY CLOUD DATABASE & TECHNOLOGIES Rich experience includes Data Warehousing, BI, web, and Big Data and Cloud technologies (AWS/AZURE) and Snowflake Experience with establishing software engineering processes, reducing system total cost of ownership, shortening delivery cycle times, and increasing quality of deliverable Experience working in Agile Project methodologies. Working as a mentor, coach, and leader to the application development and support teams and work collaboratively with vendors to ensure effective support and development of applications. Discovery Area of Data Analytics and Big Data Lake (HIVE/PIG/PySpark) Have profound knowledge and experience in Dimensional Modeling Spear headed creation of Data Engineering team to build Data Products, Data Libraries and Business-ready dataset which will be consumed by Data scientists & Data analysts
Contact this candidate