ANUJA NAIR
Houston,TX
Summary
Detail-oriented Data Engineer experienced in designing, developing and maintaining highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business requirements to develop comprehensive data solutions.
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
14
14
years of professional experience
1
1
Certification
Work History
SENIOR DATA DEVELOPER/ANALYST
HEALTHHELP INC
04.2016 - 07.2021
- Led design and development of multiple operational system application projects including auto letter generation for certain processes.
- Responsible for loading data files received from clients into operational system.
- Automated processes to streamline data loading , conducted data analysis and reporting to support various business units.
- Proactively automated and optimized existing workflows to remove manual intervention thereby reducing time spent manually entering and analyzing data by call center team.
- Handled production data systems support for critical applications , day to day tasks , troubleshooting sensitive data issues, data deployment, monitoring production jobs, performance tuning queries.
LEAD ETL DEVELOPER/ANALYST
BLUE CROSS BLUE SHIELD OF TEXAS
06.2014 - 10.2015
- Developed ETL data flows using SSIS packages, SQL procedures/functions to load membership data during annual member enrollment rollout
- Tuned ETL loads and report queries to boost performance.
- Authored code fixes in production databases for incident resolution.
LEAD TECHNOLOGY ANALYST
GOLDMAN SACHS
01.2014 - 06.2014
- Designed and developed data pipelines to acquire, clean and process data for the monthly statement generation in the private wealth management unit of the business.
- Implemented detailed analytics to ensure checks and balances before the monthly reporting cycle kickoff.
- Upheld security and confidentiality of documents and data within area of responsibility.
ETL DEVELOPER/ANALYST
CAPITAL ONE AUTO FINANCE
06.2011 - 12.2013
- Met with customers to gather, analyze and prioritize requirements.
- Translated business requirements to document, develop,test, optimize, monitor, troubleshoot and administrate the data environment.
- Developed dashboards and reports to provide insights to stakeholders.
- Managed data quality and data governance processes.
- Updated old code bases to modern development standards, improving functionality.
ETL DEVELOPER
CAPITAL ONE FINANCIAL CORP
03.2010 - 05.2011
- Collaborated with system architects, business analysts and others to understand business requirements.
- Created technical design documents, performed code reviews and unit tests while subsequently ensuring timely project delivery.
- Designed and developed high performing ETL solutions.
- Optimized ETL process for archival and retrieval of customer data by 75%.
REPORT DEVELOPER
AETNA
01.2009 - 03.2010
- Used SSRS to generate required reports.
- Resolved report performance issues by optimizing SQL queries.
- Enhanced data integrity by applying meticulous attention to detail when reviewing and analyzing data maintenance processes.
- Created a template for automating stored procedure creation using excel VBA.
SOFTWARE DEVELOPER
INFOSYS
03.2007 - 12.2008
- Built databases and table structures for internal resource management and budget allocation web applications.
- Developed scripts and processes for data integration and maintenance.
- Documented technical workflows and knowledge to educate newly hired employees.
Education
Bachelor of Engineering - Electrical, Electronics And Communications Engineering
Don Bosco Institute of Technology
Mumbai , IndiaSkills
- SQL Server SSIS Azure ETL Performance Tuning Data Modeling Analytical and problem solving skills Python
Certification
Microsoft Certified : Azure Data Engineer Associate
Microsoft Certified : Power BI Data Analyst Associate
Timeline
SENIOR DATA DEVELOPER/ANALYST
HEALTHHELP INC
04.2016 - 07.2021
LEAD ETL DEVELOPER/ANALYST
BLUE CROSS BLUE SHIELD OF TEXAS
06.2014 - 10.2015
LEAD TECHNOLOGY ANALYST
GOLDMAN SACHS
01.2014 - 06.2014
ETL DEVELOPER/ANALYST
CAPITAL ONE AUTO FINANCE
06.2011 - 12.2013
ETL DEVELOPER
CAPITAL ONE FINANCIAL CORP
03.2010 - 05.2011
REPORT DEVELOPER
AETNA
01.2009 - 03.2010
SOFTWARE DEVELOPER
INFOSYS
03.2007 - 12.2008
Bachelor of Engineering - Electrical, Electronics And Communications Engineering
Don Bosco Institute of Technology