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.• Monitored daily data load jobs automated in Control-M and SQL agent along with MS SQL Server administration activities.• Research and analysis of deviations in the data trends compared to the predicted forecasts.• Collaborative team player, worked with other teams as part of successful major implementations.• Lead/work with onshore/offshore teams in development and support of PowerBills (client’s in-house application) application.• Perform changes to the customer site load calculations by XML mapping using XBL (Extensible Billing Language) and XBRL (Extensible Business Reporting Language).• Troubleshooting and resolving data issues, related to invoices/usage/site load based on ad-hoc requests. • Documentation of implementations/changes performed and KEDB (Known Error Database) to update new findings and errors along with the root cause and resolution/workaround.• Conducted thorough testing and validation of solutions, ensuring robustness and seamless integration within the existing infrastructure and architecture.

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.• Enhanced and implemented additional functionalities in IBM Tririga.• Creating OLAP cubes using SSAS and MDX queries for analysing multi-dimensional data and creating KPIs.• Resolved data issues based on ad-hoc requests. • Automated/Customized data reports based on client requests.• Lead/work with offshore team in development and support of IBM Tririga applications.

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.• Upgraded RSAM (now Diligent) code from version 9.1XX to 9.2XX to enable multi-lingual functionalities and translations.• Create import profiles/data mappings to import data to be consumed by RSAM (now Diligent) and Tenable.• Perform compliance/vulnerability validations on all of Xerox’s applications, databases and servers.• Provided application teams with possible fixes on the vulnerabilities identified.• UI customizations using HTML5 to customize RSAM tool based on Xerox requirements.• Extensive experience working on DR drills and helping with Business continuity plans (BCP).• Researched, analyzed and resolved user issues and create customized views based on ad-hoc requests. • Automation/Customization of data reports based on client requests.• Lead/work with offshore team in development and support of RSAM applications.

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. • Developed hierarchical queries to deal with the hierarchies related to employees/organizations and to deal with orphaned records, duplicate/inactive data and handling real time exceptions.• Database tuning and data load performance improvement related to linked servers.• Resolved user issues, exceptions and create customized views based on ad-hoc requests. • Automated data reports based on client requests.• Lead/worked with team members in implementation of tasks assigned.

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.• Create custom reports using SSRS as per client requirements.• Performed changes using C#, VB, asp.net, ado.net and hosting new websites on IIS.• Handled migration of Linux servers as part of upgrades.• Implemented changes using Java, JSP, Servlets, Struts 2.0 and deploying changes using FTP tools such as FileZilla, WinSCP.• Facilitated deployments, unit testing, and integration testing for defect fixtures, change controls and enhancements.• Performed RCA (Root Causal Analysis) for incidents/issues identified and maintain a KEDB (Known Error Database) describing the problem, findings from analysis, resolution/workaround. • Minor changes in VB macros (MS Excel) to generate the corresponding letters and forms as part of voluntary/involuntary reduction in force (IRIF).• Worked on production support activities complying to the SLA (Service Level Agreement) defined.