Saroj Banjara
Round Rock,Texas
Summary
Experienced Data Engineer with expertise in IBM Infosphere DataStage, SQL, UNIX scripting, and data analysis. Proficient in utilizing Python for data processing and transformation, including preprocessing complex file formats, automating ETL workflows, and enhancing data integration. Skilled in BI reporting using SAP WebI, job automation with Control-M, and implementing CI/CD pipelines through GitLab. Demonstrated proficiency in Snowflake for cloud-based data integration and transformation. Successfully led system upgrades, migrated legacy repositories, and optimized data extraction processes to enhance efficiency and integration capabilities.
Overview
8
8
years of professional experience
Work History
ETL Python Developer
Apex Systems | USAA
01.2020 - Current
- 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.
- Collaborated with system architects, design analysts and others to understand business and industry requirements
- Crafted SQL queries for data extraction and collaborated with business users and downstream teams to ensure seamless data communication and reporting.
- Utilized UNIX scripting and DataStage Designer to transform and load data into Oracle databases, ensuring efficient and accurate data integration.
- Developed Python-based solutions for preprocessing complex data files (e.g., PDFs) using Pandas and NumPy, automating data loading processes into target systems and saving significant manual effort and time.
- 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 to support the analytical needs of Investment and Accounting teams, enhancing decision-making processes.
- Troubleshot 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.
- 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.
- Assisted offshore team members by providing feature requirements and offering support throughout development, testing, and implementation phases to ensure successful project delivery.
- Monitored IT data platforms and server health, ensuring optimal performance and proactive identification of potential issues to maintain system reliability.
- Participated in 'Proof of Concept' reviews, adapting concepts to enhance workflow efficiency and contribute to workspace improvements.
Data Analyst
One Dollar Zone
12.2016 - 04.2018
- Automated sales data extraction and reporting processes, reducing manual reporting time by 40% and providing real-time insights into daily sales performance.
- Analyzed customer purchase data to create targeted marketing segments, boosting customer retention and conversion rates for promotional campaigns.
- Analyzed pricing trends and competitor data to recommend pricing adjustments, resulting in increase in overall profit margins.
- Created interactive dashboards for senior management, enabling faster decision-making and reducing time taken to assess business performance metrics.
- Analyzed customer purchase data to identify popular products, optimizing product assortment and driving sales.
- Standardized data collection and reporting processes, reducing reporting errors by 25% and increasing transparency for stakeholders.
- Leveraged data visualization tools like SAP WebI to effectively communicate business insights, enhancing decision-making and facilitating clear understanding of complex data.
- Developed customized reports, summarizing and presenting data in visually appealing format to enhance readability and support informed decision-making.
- Created data models to support decision-making processes, enabling data-driven strategies and improved business outcomes.
- Provided technical support for troubleshooting analytics and reporting issues, ensuring timely resolution and minimizing disruptions to business operations.
Education
B.S. - Information Technology
Columbia Southern University
Orange Beach, Alabama11.2023
Post Graduate Program - Artificial Intelligence and Machine Learning: Business Applications
McCombs School of Business at The University of Texas at Austin and Great Learning
Austin, Texas11.2021
Associates Degree - Computer Programming
ASA College
Manhattan, New York09.2019
Skills
- ETL development
- IBM InfoSphere DataStage
- Python
- UNIX scripting
- RDBMS
- SQL programming
- Snowflake
- Oracle
- SAP Web Intelligence
- BI Reporting
- Control-M
- GitLab
- CI/CD Pipelines
- Data analysis
- Data Management
- Data Warehousing
- Data Integration
- Data modeling
- Data migration
- Performance tuning
- Agile Methodology
- SDLC
- Risk analysis
- Advanced analytics
- Troubleshooting
- Critical Thinking
- Strong Communication
- Team Support
Timeline
ETL Python Developer
Apex Systems | USAA
01.2020 - Current
Data Analyst
One Dollar Zone
12.2016 - 04.2018
Post Graduate Program - Artificial Intelligence and Machine Learning: Business Applications
McCombs School of Business at The University of Texas at Austin and Great Learning
Associates Degree - Computer Programming
ASA College
B.S. - Information Technology
Columbia Southern University
Similar Profiles
Samin KoiralaSamin Koirala
DBA/Call Center Customer Service Representative at Apex Systems/USAADBA/Call Center Customer Service Representative at Apex Systems/USAA
Sarah Simone ShilowSarah Simone Shilow
Member Debt Solutions at Apex Systems | USAAMember Debt Solutions at Apex Systems | USAA
Bishwash SapkotaBishwash Sapkota
Commissioning/Operation Engineer at Walmart Advanced Systems & Robotics (Contract through Apex Systems LLC)Commissioning/Operation Engineer at Walmart Advanced Systems & Robotics (Contract through Apex Systems LLC)