Srikanth Devarakonda Email & Phone Number

Toronto, ON, CA

Phoenix, Arizona, United States

• Designed, developed and implemented various ETL pipelines/processes using SSIS packages for integration with various data sources.
• Automation of scheduled jobs and integration objects using SQL Agent and Control-M.
• Created, automated(subscriptions), and customized various SSRS reports based on client requests
• Created Power BI reports on user request, for Data trends, Predictive Forecasting of data trends, Key influencers and Paginated reports.
• Performance tuning and Optimization of T-SQL queries using Execution plans, SQL Profiler, Event logs. Perform Normalization/Schema refinement as applicable.
• Performed C#.net code changes to implement new functionalities/features within the application.

New Jersey, United States

• Designed, developed and implemented various ETL pipelines/processes using SSIS packages for integration with various data sources using Agile (Scrum) project management.
• Automation of scheduled jobs and integration objects using SQL Agent.
• Database tuning and data load performance improvement.
• Created SSRS reports to display trends in data and raw data to end users (as applicable).
• Created jobs to handle the archival of historical data and data purging based on the defined retention period as part of Data Management lifecycle.
• Monitored Daily data Loads along with MS SQL Server administration activities.

Webster, New York, United States

• Designed, developed and implemented various ETL pipelines/processes using SSIS packages for integration with various data sources.
• Creation/Automation/Customization of data reports (SSRS reports) based on client requests.
• Database tuning and data load performance improvement related to linked servers.
• Monitor Daily data Loads along with MS SQL Server administration activities.
• Creating OLAP cubes using SSAS and MDX queries for analysing multi-dimensional data and creating KPIs.
• Customize RSAM (now Diligent) applications according to Xerox processes and workflows to handle security, governance, risk and compliance of Xerox’s assets.

Hyderabad, Telangana, India

• Designed, developed and implemented various ETL pipelines/processes using SSIS packages for integration with various data sources.
• Created data loads/SQL jobs, scheduled them on SQL Agent and monitored the jobs using Job Activity Monitor and automated notifications.
• Performed various MS SQL Server administration activities, with planned outages, including DB migrations and MS MDS upgrades with the help of DBAs.
• Created various custom reports using SSRS, as per client requirements.
• Created and managed various Models, Entities, Groups, Hierarchies etc. in MS MDS dealing with the employee and organization data of Xerox corporation.
• Creating OLAP cubes using SSAS for analyzing Multi-dimensional data.

Hyderabad, Telangana, India

• Designed and developed new applications/utilities that aid GSA processes using Java, JSP, Servlets, Struts2.0.
• Rewrote legacy applications using HTML5/CSS3, Struts2.0.
• Analyzed and remediated the code breakage for issues.
• Developed and monitored SQL/T-SQL scripts/Stored Procedures to load the source data and to perform ETL using DB links/Linked Servers.
• Developed jobs/batch jobs and scheduled them in SQL agent/Windows Scheduler/Crontab to load data from external databases.
• Worked on database migrations as part of Windows Server upgrade.