Role: Lead Technical Analyst
- Working closely with the business, attending Agile-Scrum calls and discuss about various stories, issues , bugs and defects
- Designing the data models for data transfer between source and destination using ETL tools like SSIS, Talend
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Designed a File watcher process to process Flat files data into system without any manual intervention
- Designed an Automation process for business to update values in their report and eliminated 40 hours of team efforts
- Providing subject matter expertise on various issues to the team members
- New or customize existing SQL Scripts using MS SQL Server, Snowflake
- Design, develop and deploy dashboards using Outsystem platform
- Creating change requests, pushing code through CI/CD pipelines and Attending CAB meeting as part of change management process
- Fixing performance issues and monitoring the application and suggesting continuous improvements to the business