Vishnu Vardhan Reddy Boda

Senior Software Engineer

• Responsible for overall planning, designing of architecture, development of functional work flow and development of modules for release wise deployment. Responsible for the day to day operations of the entire SSIS and Qlikview environments. Managed infrastructure and software deployment from Dev server to Test, Stage and Prod servers for both SSIS and Qlikview environments. Administrating, Monitoring and troubleshooting SSIS Jobs on Trivoli Workload scheduler (TWS). Responsible for creating system and architectural diagrams and SDLC documentation for SSIS and Qlikview. Responsible for POCs like SSISDB Catalog for SSIS modernization and Team foundation server for source control like Git-hub Co-ordinate with onsite/offshore team member to keep track for the design discussions, updates and deliverables. Participate in daily status meeting with client providing them daily updates. Work on reviews of technical deliverables during the project verification phase and quality Control phase. Engage in code development and code reviews with peers. All support activities including higher and lower priority issues. Identify the root cause of the issues and providing a permanent solution. Created automated reports as per customer requirements. Performed Database maintenance activities like Backups, Restoring, and indexing etc. Part of the DBA team providing 24x7 production support to the clients. Developed Packages to Load data from MS SQL server to Oracle Destinations and in the flow created new SSIS packages according to the requirement for the fields. Troubleshooting the issues on the SSIS packages. Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server Created reconciliation SSRS reports for database maintenance like backups, re-index, update stats and check DB. Created table partitioning from daily partitions to monthly partitions and truncate and merge the old partition and create a new partition accordingly and load the logs to tables. To analyze long running slow queries and tune the same to optimize application and system Performance Involved in SQL Server Technologies like Replication and High Availability. Worked on disk space alerts, Job failure alerts. Daily Log checking for errors on Production Server. Rebuilding the indexes at regular intervals for better performance. Monitored the Scheduled jobs. Worked with the application development teams for fine tuning of queries. Migration of databases from one Server to Other Server. Ensured high availability of the database using the concepts of mirroring, replication, Log shipping etc. Analyzed data requirements, application and processing architectures, data dictionaries, and database schemas. Monitored the Disk spaces on all the servers. Created SQL Users and providing required permissions. Created maintenance jobs on the production Servers. Analyzed, Identified and Resolved performance issues of the Prod server.