ABOUT ME:
I am a skilled Data Engineer with problem-solving, business understanding and communication skills. I have accumulated technical expertise over the years while working with both Fortune 500 corporations as well as at startups in the USA and Canada. I’m willing to jump into groundbreaking challenges, to support business and operational teams to achieve their business objectives.
I strongly believe in continuous learning and updating skills by learning new technologies and in the last few years I have developed skills in Python programming, Pharo programming language and Tableau.
KEY PROJECTS:
Banking:
Developed SAS Governance framework. Worked on AML projects related to transaction monitoring and risk management. Handled multiple ETL projects related to Remote Banking and Point of Sales. Benchmarked current SAS system, especially for SAS exports to understand when a SAS program will fail due to hardware limitations.
Marketing
Build email and direct mail Data marts. During this project, I worked on a Database migration project. Converted Oracle SQL to Teradata SQL and converted Oracle-compliant SAS code to Teradata-compliant SAS code.
Insurance
Build Cubes for Loss and profit for insurance by state, month and by various categories. Enhanced data quality and automated manual processes for checking data quality.
Manufacturing
Build datasets from web and transformed in such a way that statistician can build a recommender system for various parts. Optimized certain process and reduced run time of process.
Health care
Worked extensively on Real World Data especially related to Heart failure with reduced ejection fraction (HFrEF). Did analysis on patient related data and built datasets in such a way that statistician can test their hypothesis.
PERSONAL PROJECTS:
Online Classes
I have helped over 100 students in their SAS & SQL journey.
SAS Communities
I have been recognized as PROC STAR (twice) on official SAS community forum for answering and helping other SAS users.
MY PUBLICATIONS:
- Accessing Teradata through SAS, common pitfalls, solutions and tips – 2016 MidWest SAS Users Group Proceedings October 11, 2016.
- Data movement issues: Explcit pass through can do the trick.
- Dictionary.columns is your friend while appending or moving data.
- Obtain better data accuracy using reference tables.
- Improving Query performance by saying “NO” to Heterogeneous Joins.
- Data Security in SAS® using Encryption and Hashing.
- Finding variable names and count of variables with missing values at various positions within an observation using SAS arrays.
CERTIFICATIONS:
- Live Object Programming in Pharo, France Université Numérique, Jan 2019.
- MongoDB Basics, MongoDB, Sep 2018.
- PH125.1x: Data Science: R Basics, Feb 2018.
- Essential Design Principles for Tableau, Coursera, Feb 2017
- Fundamentals of Visualization with Tableau, Coursera, Feb 2017, License 7DKFKEF8RPU6
- Visual Analytics with Tableau, Coursera, Feb 2017 License WX2QQREBWNPN
- Using Python to Access Web, Coursera, Dec 2015, License YAR3QR2JQMTH
- Python Data Structures, Coursera, 2015, License MY73LYNYVJLWBusiness Metrics for Data-Driven Companies, Coursera, Oct 2015, License HE3CFPUEQDH6
- Teradata 12 Certified Technical Specialist, Teradata, Aug 2015, License.
- Teradata 12 SQL Exam Completion, Mar 2014, License
- Teradata 12 Certified Professional, Teradata, Aug 2013, License.
- SAS Certified Advanced Programmer for SAS 9, SAS, Jul 2013, License
- SAS Certified Base Programmer for SAS 9, SAS, Nov 2012, License
SMARTTECH:
I regularly post videos on the SmartTech YouTube channel, where I have videos related to SAS & SQL. Over the years, I have posted more than 175 videos and built a community of more than 8500 subscribers.
CONNECT:
For any enquires please feel free to contact me at kiranvennaofficial@gmail.com
