Saroj Banjara
Round Rock,TX
Summary
ETL Python Developer and Data Analyst with 5+ years of experience in data integration, ETL processes, SQL querying, and data visualization. Skilled in analyzing complex datasets, creating interactive dashboards, and generating actionable insights for business decision-making. Supervised a team of 5 offshore developers from India, ensuring smooth project execution and maintaining high code quality. Played a key role in the production support team, serving as an L3 On-Call resource to efficiently resolve critical issues. Demonstrated exceptional skills in optimizing ETL performance by 25% and reducing manual reporting time by 40%, resulting in a weekly time savings of 15 hours. Contributed to operational efficiency by transforming and loading data into various databases over 3 years.
Overview
5
5
years of professional experience
1
1
Certification
Work History
ETL Python Developer
Apex Systems | USAA
01.2023 - 12.2024
- 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
- 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, ensuring efficient and reliable workflows
- Implemented CI/CD pipelines for automated deployments, significantly reducing deployment time and enhancing overall operational efficiency
- Led the upgrade of IBM DataStage, ensuring system compatibility, improved performance, and minimal disruption to ongoing operations
- 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 and onshore 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.
- Monitored and identified recurring production issues, proactively implementing preventive measures to enhance system stability and reduce the frequency of incidents.
- Managed escalations from L1 and L2 support teams, providing guidance and expertise to resolve complex data and system issues efficiently.
- Ensured timely resolution of production issues, participating in post-mortem analyses to identify root causes and recommending improvements to prevent future incidents.
Database Developer/Data Analyst
Apex Systems | USAA
01.2020 - 12.2022
- 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
Education
Bachelor of Science - Information Technology
Columbia Southern University
Orange Beach, ALAssociate of Science - Computer Programming
ASA College
Manhattan, NYSkills
- Agile Project Management
- AWS
- BMC Control-M Workload Automation
- Data Integration & Analysis
- ETL Process Design
- GitLab CI/CD Management
- IBM InfoSphere DataStage
- Oracle SQL
- Power BI
- Python
- SAP Web Intelligence
- UNIX Scripting
Certification
Post-Graduate Diploma in Artificial Intelligence and Machine Learning - University of Texas at Austin
Python for Data Science - IBM
Power BI Data Analyst Associate - Microsoft
Timeline
ETL Python Developer
Apex Systems | USAA
01.2023 - 12.2024
Database Developer/Data Analyst
Apex Systems | USAA
01.2020 - 12.2022
Associate of Science - Computer Programming
ASA College
Post-Graduate Diploma in Artificial Intelligence and Machine Learning - University of Texas at Austin
Python for Data Science - IBM
Power BI Data Analyst Associate - Microsoft
Bachelor of Science - Information Technology
Columbia Southern University
Similar Profiles
Saroj BanjaraSaroj Banjara
ETL Python Developer at Apex Systems | USAAETL Python Developer at Apex Systems | USAA
Saroj BanjaraSaroj Banjara
ETL Python Developer at Apex Systems | USAAETL Python Developer at Apex Systems | USAA
Samin KoiralaSamin Koirala
DBA/Call Center Customer Service Representative at Apex Systems/USAADBA/Call Center Customer Service Representative at Apex Systems/USAA