Dasaradharamaiah Kamma
Software Engineer
Dallas
Summary
Dependable ETL Developer with 10.5 years creating reliable and accurate data transformation workflows. Well-versed in technologies such as Informatica and ODI. Designs ETL workflows to scale overwhelming data transition tasks into manageable projects with realistic timeframes and achievable budgets. End-to-End implementation knowledge on implementing Data warehouse and BI projects in Agile methodology.
Overview
10
10
years of professional experience
8
8
years of post-secondary education
Work History
Senior ETL Developer
Bank of America
Hyderabad
10.2019 - Current
- Designed and created ETL code to build Data Warehouse applications using ETL tools INFORMATICA Power Center 10.4/10.2 and ODI 12c/11g (Oracle Data Integrator) to transfer the data from OLTP/legacy systems to common/ different targets.
- Created complex mappings using varied transformations Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Transaction Control and implemented SCDs etc. in Informatica
- Debug and Performance tuning of targets, sources, mappings and sessions (ETL Level Performance tuning), and on Report queries
- Peer reviews and migrating code from Dev to Test, UAT and Production environments and providing go live support till the system is stabilized.
Senior Consultant
Oracle
Hyderabad, Telangana
2015.03 - 2019.10
- Designed and created ETL code to build Data Warehouse applications using ETL tool ODI 12c/11g (Oracle Data Integrator) to transfer the data from OLTP/legacy systems to common/ different targets
- Created complex and re-usable mappings using varied transformations with components Expression, Filter, Join, Lookup, Pivot, Unpivot, Set (union, minus, intersect), Split, Aggregate, Distinct, Sort, Webservices in Oracle Data Integrator(ODI)
- Develop RPD and Creating analysis, dashboards in OBIEE 12c/11g
- Debug and Performance tuning of targets, sources, mappings and sessions (ETL Level Performance tuning), and on Report queries
- Peer reviews and migrating code from Dev to Test, UAT and Production environments and providing go live support till the system is stabilized.
Software Engineer
4G Identity Solutions
Hyderabad, Telangana
09.2011 - 01.2015
- Design and Develop Informatica mappings and workflows to load the data from various sources using different transformations like Source Qualifier, Aggregator, Expression, Lookup, Unconnected Lookup, Filter, Normalizer, Router, Joiner, Update, Union and Rank transformations.
- Develop workflows using sessions, command, decision, and control and Email tasks.
- Load data from flat files, Oracle databases working with SQL Override in the Source Qualifier and Lookup transformation
- Developing Slowly Changing Dimensions Mapping Type 2 SCD using MD5
- Performance tuning at ETL level & Database level using various techniques like push down optimization & Session partitioning
- Analyze existing system and develop business documentation on changes required
Education
Master of Science - Computer Applications
NIT Calicut
Calicut, Kerala, India 07.2007 - 05.2010
Bachelor of Science - Mathematics, Physics
Acharya Nagarjuna University
Guntur, Andhra Pradesh, India 2004.06 - 2007.03
Associate of Science - Mathematics, Physics And Chemistry
Bharat Jr College
Addanki, Andhra Pradesh, India 06.2002 - 04.2004
High School Diploma -
ZP High School
Addanki, Andhra Pradesh, India 2001.06 - 2002.04
Skills
ETL: Informatica, ODI
RDBMS: Oracle, Vertica, PL/SQL, SQL Developer, Toad
Reporting: OBIEE
DevOps: GIT, Bitbucket, Hudson/Jenkins, Jira and Confluence, JFrogArtifactory, Gradle, Ant
Dependable and Responsible
Problem-Solving
Planning and Coordination
Timeline
Senior ETL Developer
Bank of America
10.2019 - Current
Senior Consultant
Oracle
2015.03 - 2019.10
Software Engineer
4G Identity Solutions
09.2011 - 01.2015
Master of Science - Computer Applications
NIT Calicut
07.2007 - 05.2010
Bachelor of Science - Mathematics, Physics
Acharya Nagarjuna University
2004.06 - 2007.03
Associate of Science - Mathematics, Physics And Chemistry
Bharat Jr College
06.2002 - 04.2004
High School Diploma -
ZP High School
2001.06 - 2002.04