Balasubramanian Raghunathan
Charlotte,NC
Summary
Experienced with creating comprehensive data architecture strategies that align with business objectives. Utilizes advanced data modeling techniques and architectural frameworks to enhance system efficiency and reliability. Track record of optimizing data management practices, ensuring seamless data integration, and supporting data-driven decision-making.
Professional data specialist with strong expertise in designing and managing enterprise data architectures. Skilled in data modeling, database management, and data integration. Focused on team collaboration and delivering impactful results. Known for adaptability and reliability in dynamic environments.
Analytical data professional prepared to deliver innovative data architecture solutions. Recognized for developing efficient data frameworks and enhancing data systems to drive business growth. Known for collaborative teamwork and adaptability to evolving project needs. Proficient in data modeling, database design, and data integration.
Innovative and analytical, bringing solid foundation in data modeling and database management. Proficient in SQL and data warehousing, with keen understanding of data integration and migration processes. Committed to leveraging these skills to design efficient data architectures that drive business insights and performance.
Overview
12
12
years of professional experience
1
1
Certification
Work History
BA and Data Architect
Bank of America
04.2024 - Current
- Worked as a BA and Data architect under Wholesale Credit space, for Climate risk projects
- The objective of this domain to Provision climate risk related data to Global Risk Analytics regulatory models and other credit models
- Have worked with around 10 developers both onshore and offshore.
- Data needs to be provisioned to Global Risk Analytics in model ready format that includes sourcing consolidated SOR data from different kinds of sources and running common model specific derivations
- The data pipeline also involves value added processing(Pre collapse logic, Collapse and Proxy) that needs to be streamlined in order to maintain quality of data required for model execution
- Improved database performance by optimizing queries, indexing strategies, and overall architecture design.
- Gathered, defined and refined requirements, led project design and oversaw implementation.
- Designed data models for complex analysis needs.
- Conducted thorough root-cause analysis on complex data issues, proposing practical solutions that align with business objectives.
- Implemented rigorous testing procedures to validate the accuracy, reliability, and functionality of all developed systems before deployment.
- Established strong relationships with vendors for timely support during critical incidents or software upgrades.
- Collaborated with stakeholders to identify key business requirements and translated them into actionable architectural plans.
- Enhanced data quality by designing and implementing efficient data models, schemas, and storage techniques.
Data Engineer/Data Modeler - Integrated Risk Reporting (CARAT/RDS)
Wells Fargo
09.2022 - 03.2024
- Worked as a Data engineer and Data modeler, in designing reporting models for frontline needs and Corporate Risk related to SERM solutions and Non SERM solutions like RCSA, ILD, etc.
- Presented complex modeling results to stakeholders, facilitating informed decision making.
- Integrated diverse data sources into cohesive models for comprehensive analyses of various scenarios.
- Collaborated with around 5 different cross-functional teams to ensure model relevance and applicability.
- Mentored around 10 junior modelers, fostering a culture of continuous learning and growth.
- Streamlined processes, resulting in increased efficiency in model creation and analysis.
- Managed multiple modeling projects simultaneously, delivering timely and accurate results.
Senior ETL Developer
Bank of America
04.2013 - 08.2022
- Ensured compliance with industry standards by adhering to strict guidelines during data migration projects.
- Integrated disparate data sources into a cohesive system for more efficient analysis and decision making.
- Reduced maintenance costs by creating reusable components within ETL pipelines.
- Implemented automation within ETL processes to reduce manual tasks and improve efficiency.
- Optimized ETL performance by identifying bottlenecks and streamlining for around 10 workflows.
- Troubleshot issues related to performance or system errors, quickly resolving them to minimize business impact.
- Streamlined data transformation for faster processing, reducing overall processing time.
- Implemented robust error handling techniques, resulting in fewer data discrepancies during the ETL process.
- Documented technical specifications, enabling seamless knowledge transfer among team members.
- Developed complex SQL queries for improved data extraction and accurate reporting.
- Evaluated new technologies as potential solutions for enhancing current ETL processes, providing recommendations based on research findings.
- Collaborated with cross-functional teams to define requirements and deliver high-quality solutions.
- Increased data accuracy through rigorous validation checks during the ETL process.
Education
Bachelor of Technology - Mechanical Engineering
SRM University
Chennai, India05.2008
MBA - Technology Management
Anna University
Chennai, India08-2012
Skills
- Industries: Banking
- Project Domain: Transactional and Warehousing
- ETL Tools: DataStage117,9x,8x and7x, IBM Information server suite, Quality Center, Maximo
- Data Modeling: Power Designer for building Physical Data models
- Data quality: Hadoop framework, Hive, Legacy Mainframe, Data Stage, Quality Stage, data Profiling with Information Analyzer, Data Quality assessment and remediation
- Operating Systems: Windows NT/2000, UNIX, Linux
- RDBMS: DB2, SQL Server, Teradata, Single store, HIVE
- Utilities/Platforms: TOAD, Putty, Notepad , Git hub, bitbucket
- Scripting: UNIX Shell Script, Teradata BTEQ Scripting, WINDOWS batch Scripting
- Scheduling Tool: Autosys, CA7
- Reporting Tools: MS Excel, Tableau
- Documentation: VISIO, Microsoft studio, Notepad
- SQL
- ETL development
- SQL expertise
- Data migration
- Database design
- Data quality management
Accomplishments
- Achieved Data Migration to Singlestore database by completing all migration tasks from DB2 to Singlestore with accuracy and efficiency.
- Successfully implemented performance improvements techniques in critical data driven projects involving, Hive, SQL server, My SQL, SInglestore and DB2.
- Successfully implemented end to end data flow from Source to target and creating complete data lineage documents.
- Documented and resolved Data base issues and Data base optimizations which led to improved and streamlined batch processing
- Designed and developed number of Type 2 dimension solutions for historic handling of data
- Successfully worked with multiple teams to design and architect end to end data pipeline for Climate risk Projects for Bank Of America which led to on time SLA delivery of decision driven data to downstream applications.
- Resolved product issue through consumer testing.
Certification
- MemSQL Developer Certified
- MemSQL Admin Certified
- Datastage version8.5 certified
- Certified Scrum Master
- DB2 V9 Certified
Languages
English
Tamil
Interests
- Music Singer and a Bass Guitarist Part of 3 bands in Charlotte Area
Timeline
BA and Data Architect
Bank of America
04.2024 - Current
Data Engineer/Data Modeler - Integrated Risk Reporting (CARAT/RDS)
Wells Fargo
09.2022 - 03.2024
Senior ETL Developer
Bank of America
04.2013 - 08.2022
- MemSQL Developer Certified
- MemSQL Admin Certified
- Datastage version8.5 certified
- Certified Scrum Master
- DB2 V9 Certified
Bachelor of Technology - Mechanical Engineering
SRM University
MBA - Technology Management
Anna University
Similar Profiles
Miranda BoldenMiranda Bolden
Home Services Specialist I at Bank of AmericaHome Services Specialist I at Bank of America
Ty'Qwasia MahoneTy'Qwasia Mahone
Senior Client Advocate at Sykes Enterprises, Incorporated / Chase Bank / Bank of AmericaSenior Client Advocate at Sykes Enterprises, Incorporated / Chase Bank / Bank of America
Emily CorbettEmily Corbett
Credit Claims Analyst II (Back Office) / Officer at Bank of AmericaCredit Claims Analyst II (Back Office) / Officer at Bank of America