-Gathered requirements and analyzed them to ensure the successful implementation of project objectives.-Identified data sources and created necessary new SQL objects or utilized existing SQL objects to meet project requirements.-Worked with new/existing SSIS projects and developed new packages as required for data integration and transformation.-Configured connection managers and ensuring the proper flow of data between different systems and sources.-Created new stored… Show more -Gathered requirements and analyzed them to ensure the successful implementation of project objectives.-Identified data sources and created necessary new SQL objects or utilized existing SQL objects to meet project requirements.-Worked with new/existing SSIS projects and developed new packages as required for data integration and transformation.-Configured connection managers and ensuring the proper flow of data between different systems and sources.-Created new stored procedures for various types of data loads to support business operations and reporting needs.-Set up SQL jobs and modified existing jobs based on requirements to automate data processing tasks and ensure timely execution of ETL processes.-Participated in unit testing and user acceptance testing (UAT) to validate the accuracy and functionality of the implemented solutions.-Provided final views on which reports would be generated to ensure they meet the stakeholders' requirements.-Worked on database migration from SQL Server 2012 to 2016, ensuring a seamless transition with minimal downtime.-Attended Change Approval Board meetings to explain release details and obtain necessary approvals.-Collaborated with the DBA team for production deployment to ensure smooth and efficientimplementation of new solutions.-Monitored SQL jobs to ensure they ran as expected and addressed any issues that arose.-Responded to reported incidents promptly and addressed production issues to minimize downtimeand impact on operations.-Worked on Data loading from stage to ODS system. Show less

-Actively participated in troubleshooting and resolving issues related to data loading delays anddatabase server outages, ensuring minimal disruption to data flow and system operations.- Engaged in periodic reviews of job logs and performance metrics to identify trends, proactivelyaddressing potential issues.-Contributed to the development and maintenance of documentation for troubleshooting procedures,best practices, and system configurations, facilitating knowledge sharing… Show more -Actively participated in troubleshooting and resolving issues related to data loading delays anddatabase server outages, ensuring minimal disruption to data flow and system operations.- Engaged in periodic reviews of job logs and performance metrics to identify trends, proactivelyaddressing potential issues.-Contributed to the development and maintenance of documentation for troubleshooting procedures,best practices, and system configurations, facilitating knowledge sharing within the team.-Working on ETL server for inbound and outbound file delivery.-Installed, configured, and maintained Control-M and Jenkins environments to ensure smoothoperation and optimal performance.-Troubleshot issues related to job scheduling, execution, and performance in Control-M, identifyingroot causes, and implementing solutions to minimize downtime.-Scheduled and managed jobs in Control-M to automate batch processing and job execution accordingto predefined schedules and dependencies.- Configured and managed projects in Jenkins, including creating and configuring pipelines, jobs, andbuilds to support continuous integration and deployment processes.-Updated and maintained plugins in Jenkins to ensure compatibility, security, and functionality with thelatest versions of Jenkins and other integrated tools.- Patched Control-M and Jenkins environments regularly to apply security updates, bug fixes, andperformance enhancements, following best practices and change management procedures.-Set up alerts and monitoring for applications like JBoss, Control-M, and Jenkins in CloudWatch bycreating log groups and metrics.-Configured CloudWatch Alarms to trigger notifications based on predefined thresholds for applicationhealth, performance, and availability.-Documented installation procedures, troubleshooting steps, and maintenance tasks for Control-M,Jenkins, and CloudWatch environments, ensuring knowledge transfer and compliance with standards and policies. Show less