• Designed and developed loan processing graphs in Ab Initio to transform data from upstream systems for downstream analytics and reporting teams.
• Integrated data from multiple upstream sources, ensuring accuracy and completeness during ingestion and transformation processes.
• Developed data pipelines to process loan data, including cleansing, transformation, and loading into data warehouses.
• Created workflows to automate data ingestion from upstream teams and distribute processed data to downstream teams.
• Created reusable components and parameterized graphs to enhance development efficiency and reduce redundancy.
• Optimized graph performance, resulting in a 25% reduction in execution time.
• Collaborated with upstream and downstream teams to define data mappings and requirements.
• Monitored and resolved ETL job failures, ensuring data availability for business-critical operations.
• Managed Documentum Environments: Administered Documentum content management systems, including installation, configuration, and maintenance of Documentum servers. Ensured high availability and performance of ECM solutions
• Linux/Unix System Administration: Oversaw Linux/Unix servers used in Documentum environments, performing routine updates, patches, and performance tuning to maintain system stability and security
• SQL Database Management: Managed SQL databases associated with Documentum, including writing and optimizing SQL queries, performing database backups, and ensuring data integrity and availability
• Control-M Scheduling: Configured and maintained Control-M job scheduling to automate and monitor batch processing tasks and workflows, reducing manual intervention and improving operational efficiency
• Troubleshooting and Support: Provided expert-level troubleshooting for Documentum-related issues, collaborating with development and support teams to resolve problems swiftly and effectively
• Performance Optimization: Conducted performance tuning of Documentum systems, including system resource allocation, load balancing, and database optimization, to enhance overall system efficiency and user experience
• Documentation and Reporting: Created and maintained detailed documentation for system configurations, processes, and procedures. Generated regular reports on system performance, job statuses, and incident resolutions
• Automated Scripting: Developed and implemented automated scripts for auto-start and shutdown of Documentum services, streamlining the monthly patching process and minimizing system downtime.This included creating shell scripts to handle service restarts, backups, and error logging during maintenance windows
• Technical Support: Provided day-to-day support for Documentum users, addressing system-related issues and facilitating user training to maximize the effectiveness of the ECM system
• Deployed, upgraded and tested all the applications on various platforms
• ETL Tools: Ab Initio, AWS Glue
• Programming Languages: Python, SQL, Unix Shell Scripting
• Databases: Oracle, MySQL
• Cloud Platforms: AWS (EC2, S3, RDS, Lambda)
• Other Tools: Control-M, Documentum, Git, Autosys
• Operating Systems: Linux, Unix, Windows
• Data Modeling: Star Schema, Snowflake Schema, ER Modeling
• Watching Animated series • Solo Traveling • Exploring New Places • MMA/Boxing/Working out • Futures and
Options (Share Market).