Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic

Saroj Banjara

Round Rock

Summary

ETL Developer & Data Analyst with 5+ years of experience in data integration, SQL, Python, and reporting—supporting the Investment Accounting team under the CFO portfolio. Skilled in analyzing complex financial datasets, developing ETL pipelines, and building interactive dashboards for decision-making. Led a team of 5 offshore developers, ensuring data quality and alignment with business requirements. Optimized ETL performance and reduced manual reporting time by 40%, saving 15 hours weekly. Collaborated with accounting teams on month-end close activities and job monitoring. Recently completed a forecasting solution using Power BI and trend analysis with linear regression to predict weekly and monthly expenses for strategic planning.

Overview

6
6
years of professional experience
1
1
Certification

Work History

ETL Python Developer

Apex Systems | USAA
01.2020 - 12.2021
  • Orchestrated the development and management of ETL processes using IBM Infosphere DataStage, ensuring seamless data flow across systems that enhanced reporting accuracy while saving 15 hours weekly on manual tasks
  • Developed and optimized complex SQL queries involving JOINS (inner, outer, cross), sub-queries, CTEs, and window functions to extract and transform large datasets, ensuring efficient data retrieval
  • Leveraged UNIX scripting and IBM DataStage Designer to handle complex ETL workflows, transforming and loading data into Oracle databases, ensuring efficient, accurate, and seamless data integration
  • Developed Python-based solutions for preprocessing complex data files using Pandas and NumPy, automating data loading processes into target systems and saving significant manual effort and time
  • Developed and maintained customized financial reports using BusinessObjects, providing the Investment Accounting team with real-time insights into portfolio performance, transactions, and asset allocation.
  • Supported month-end closing processes by automating data extraction, transformation, and validation, ensuring timely and accurate financial reporting and compliance with GAAP accounting standards.
  • Collaborated with the Investment Accounting Director and Investment Analyst to improve the accuracy of investment data through the implementation of robust validation and reconciliation processes within the ETL framework.
  • Optimized ETL workflows to handle complex financial data, supporting the Investment Accounting team with timely and accurate reporting for audits, tax compliance, and financial disclosures.
  • Created automated solutions for month-end reconciliation tasks, improving efficiency and reducing manual errors during critical financial reporting periods.
  • Implemented data quality checks within the ETL workflows to ensure the accuracy, consistency, and integrity of financial data.
  • Troubleshoot ETL job errors and debugged data issues, delivering innovative solutions to complex problems to ensure seamless data processing and reliability
  • Automated job schedules using Control-M and contributed to testing and deployment of new projects utilizing GitLab and Urban Code Deployment
  • Monitored IT data platforms and server health, ensuring optimal performance and proactive identification of potential issues to maintain system reliability
  • Led a team of 5 offshore members, providing feature requirements and support during development, testing, and implementation, while driving workflow efficiency and workspace improvements through active participation in 'Proof of Concept' (PoC) reviews
  • Served as an L3 On-Call support resource, quickly responding to and resolving critical production issues, including ETL job failures and system outages, ensuring minimal disruption to business operations.
  • Collaborated closely with cross-functional teams to troubleshoot and resolve high-priority issues, providing timely solutions and ensuring data consistency and reliability in production environments.

Database Developer/Data Analyst

Apex Systems | USAA
01.2022 - 12.2024
  • Designed and implemented database solutions by analyzing user requirements and business needs.
  • Collaborated with vendors, including Princeton Asset Management (PAM) for General Ledger and Accounting, and Charles River Investment Management System (CRIMS) for compliance and live trade operations, ensuring smooth financial and trading workflows
  • Facilitated the transition from Charles River Investment Management System (CRIMS) to Broadridge Investment Management System (BIMS) and integrated BlackLine for reconciliation processes, streamlining financial operations and enhancing system efficiency
  • Partnered with business users and downstream teams to align data requirements, streamline reporting workflows, and enhance data accuracy for decision-making
  • Conducted data analysis, developed data models, and implemented data warehousing concepts to support efficient data storage and retrieval processes
  • Designed and developed reports in SAP Web Intelligence, and Power BI to support the analytical needs of Investment and Accounting teams, enhancing decision-making processes
  • Collaborated with cross-functional teams to migrate legacy repositories, streamline workflows, and enhance operational processes for improved efficiency
  • Optimized data extraction processes and automated data flow, resulting in improved operational efficiency and reduced manual intervention
  • Provided support for Business Intraday processes, ensuring timely and accurate data handling to meet business requirements

Investment Accounting Data Quality Analyst Sr.

Teacher Retirement System of Texas
05.2024 - Current
  • Forecast weekly and monthly expense trends using linear regression to enhance budgeting accuracy and strategic planning.
  • Identify root causes of data quality issues and recommend sustainable, long-term solutions aligned with business objectives.
  • Design and execute targeted data cleanup strategies, improving data integrity across systems.
  • Analyze and validate large, complex datasets to ensure completeness, accuracy, and consistency.
  • Investigate data anomalies by assessing scope, complexity, and business impact.
  • Collaborate cross-functionally with business stakeholders to define data requirements and ensure alignment with reporting needs.
  • Detect patterns and trends in high-volume datasets, delivering actionable insights to drive investment decisions and process improvements.
  • Create and deliver custom dashboards and reports using data visualization tools (e.g., Power BI, Tableau), enhancing interpretability for non-technical users.
  • Write, optimize, and maintain SQL scripts and ETL processes to extract, transform, and analyze data from multiple sources.
  • Implement business intelligence solutions to streamline operations and enhance data-driven decision-making.
  • Develop and refine data models to support predictive analysis and strategic forecasting.
  • Apply advanced data visualization techniques to present complex findings in an intuitive, decision-ready format.
  • Provide technical support for troubleshooting reporting discrepancies and analytics issues, ensuring continuity and reliability of insights.

Education

Bachelor of Science - Information Technology

Columbia Southern University
Orange Beach, AL
11-2023

Associate of Science - Computer Programming And Information Technology

ASA College
Manhattan, NY
11-2019

Skills

  • Proficient in agile project management
  • Workload management with BMC Control-M
  • Data integration expertise
  • ETL architecture development
  • Comprehensive financial reporting
  • Reconciliation of financial records
  • GitLab continuous integration and deployment
  • Proficient in IBM Infosphere DataStage
  • Experienced in Oracle SQL database management
  • Skilled in Microsoft SQL Server management
  • Power BI data visualization
  • Skilled in Python development
  • Experience with SAP BusinessObjects
  • Experience with Unix shell development

Accomplishments

  • Projected future Expenses: Developed an expense forecasting dashboard using linear regression in Power BI, enabling accurate weekly/monthly budget predictions for strategic planning.
  • Automated Reporting System: Designed and implemented an automated reporting solution using SAP Web Intelligence and DataStage, reducing the manual report generation process from hours to minutes.
  • Python Data Processing: Created Python scripts to preprocess and transform complex raw data, enhancing ETL pipeline flexibility and reducing manual intervention.
  • Data Validation and Quality Assurance Framework: Developed a robust testing framework using Python and SQL to automate data validation checks in the ETL pipeline, ensuring that all transformations and data loads adhered to specified business rules.
  • DataStage Upgrade: Led the migration and upgrade of IBM DataStage, ensuring a smooth transition to a modernized system with improved performance.
  • CI/CD Pipeline Implementation: Developed and implemented automated deployment pipelines using GitLab, improving efficiency and reducing errors.
  • Retirement of Legacy Repositories: Successfully retired outdated data repositories and transitioned to a modernized repository system for centralized and efficient code management, improving version control and reducing maintenance efforts.

Certification

  • Post-Graduate Diploma in Artificial Intelligence and Machine Learning - University of Texas at Austin and Great Learning
  • Python for Data Science - IBM

Timeline

Investment Accounting Data Quality Analyst Sr.

Teacher Retirement System of Texas
05.2024 - Current

Database Developer/Data Analyst

Apex Systems | USAA
01.2022 - 12.2024

ETL Python Developer

Apex Systems | USAA
01.2020 - 12.2021

Bachelor of Science - Information Technology

Columbia Southern University

Associate of Science - Computer Programming And Information Technology

ASA College

Similar Profiles

CREATE PROFILE