Chenna Akuri, Developer in Northampton, United Kingdom
Chenna is available for hire
Hire Chenna

Chenna Akuri

Verified Expert  in Engineering

Database Developer

Location
Northampton, United Kingdom
Toptal Member Since
May 18, 2021

Chenna is a skilled IT professional with 14+ years of diverse experience in applications, databases, data warehousing, business intelligence, and data visualization and analysis. He developed a loan origination system that processes around 40,000 applications per month with a loan value of over $10 million used in multiple industries. Chenna enjoys designing low-cost, stable solutions in data-oriented and analytical environments.

Availability

Full-time

Preferred Environment

Windows, Git, Azure, Visual Studio Code (VS Code), Visual Studio, SQL Server BI, SQL Server 2014

The most amazing...

...product I've created is a loan origination system (Decision Station) that processes nearly 40,000 applications per month with a loan value of over $10 million.

Work Experience

Software and Data Analyst

2017 - 2023
Confidential
  • Translated requirements and generated and developed a roadmap utilizing the best technologies for the project with comprehensive and obtainable milestones.
  • Developed and deployed dashboards, visualizations, and autonomous and dynamic reporting interfaces to be distributed to stakeholders via a business intelligence (BI) reporting platform, web portal, mobile, tablet devices, widgets, and email.
  • Consumed messages from Azure service bus within C#. Processed and pushed acknowledgment (ACK) or negative acknowledgment (NACK) messages.
  • Optimized report distribution, execution, and scalability of all reporting solutions to be autonomous and dynamic.
  • Assisted the data management team in providing input on logical and physical database design, data modeling, and mapping.
  • Created stored procedures, user-defined functions, views for handling business logic, and functionality such as email alerts and data extracts built in Excel.
  • Assisted team members, internal departments, and 3rd-party agencies in reporting business requirements, documentation, timelines, testing, and technical delivery.
  • Used Azure Data Factory for ETL and ELT processes. Developed 100+ packages.
Technologies: SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), ASP.NET, C#, Database Design, Data Engineering, Data Analysis, Data Modeling, ETL, Data Visualization, Data Architecture, SSRS Reports, Dashboards, JavaScript, SQL Server 2012, CI/CD Pipelines, Windows PowerShell

Data Engineer

2022 - 2022
GeneDx
  • Installed, configured, and managed SQL Server 2019 in the development, test, and production environment.
  • Programmed database, including writing T-SQL, trigger, and stored procedures. Assisted database developers in optimizing SQL queries and stored procedures and managed deadlock, block, and lock.
  • Installed, configured, and managed database mirroring, replication, and log shipping. Optimized SQL queries, stored procedures, and functions.
  • Contributed to database backup, disaster recovery, and point-in-time recovery and restored database from backup.
  • Monitored database and performance tuning, scheduled jobs to automate database-related activities, including backup, and monitored database health, disk space, and backup verification.
  • Used ETL tools such as Data Transformation Services (DTS), SQL Server Integration Services (SSIS), import and export, and bulk copy (BCP) to import and export data from flat files and Excel to Microsoft SQL Server databases.
  • Installed and configured SolarWinds Database Performance Analyzer (DPA) for monitoring and alerting purposes.
  • Migrated SQL Server and database from on-premise to cloud instance. Installed and configured Datadog for database monitoring and alerting purposes.
Technologies: SQL, SQL Stored Procedures, Stored Procedure, Azure, Site Reliability Engineering (SRE), T-SQL (Transact-SQL), C#, JSON, APIs, Amazon Web Services (AWS), Datadog, Database Performance, CI/CD Pipelines

Power BI Developer

2022 - 2022
RCM Industries, Inc.
  • Redefined and made technical and strategic changes to enhance existing Business Intelligence systems. Converted business requirements into technical specifications and decided on a timeline.
  • Understood business requirements in the BI context and designed data models to transform raw data into meaningful insights. Created dashboards and interactive visual reports using Power BI. Performed DAX queries and functions in Power BI.
  • Created customized charts and custom calculations as per requirements. Worked with users and team members at all levels for performance improvement and suggestions.
  • Gained experience in building, deploying, and troubleshooting data extraction for huge amounts of records using Azure Data Factory (ADF).
  • Created Azure DevOps and released build pipelines for continuous auto deployments.
  • Designed, developed, tested, deployed Power BI scripts, and performed detailed analytics. Analyzed the current ETL process and defined and designed new systems. Performed data warehouse development and worked with SSAS, SSIS, and SSRS.
  • Created Azure functions for processing organization-wise automatic emails.
Technologies: Microsoft Power BI, Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), C#, Azure, Azure SQL, Data Engineering, Data Analysis, SSRS Reports, Dashboards, CI/CD Pipelines

Freelancer Developer

2016 - 2021
Creative Business Decisions
  • Achieved a 99% client satisfaction score for ten new and maintenance projects completed on various .NET websites by utilizing ASP.NET MVC, jQuery, HTML, and CSS.
  • Utilized loan origination software called DecisionStationTM, which is an application processing and credit evaluation and credit scoring system software used mainly by BHPH Auto clients and furniture retail clients.
  • Developed steps to recover applications from business critical failures to 24x7 manual support.
  • Linked up with legacy databases and accounting systems and with credit bureau agencies to speed up the lending process and give the client complete control over the progress of their applications.
  • Managed data evaluation, scoring, and rule processing based on customer choice, provision of looking at various ratios like debt-to-income, disposable income, the provision of flags, and indicators to aid the evaluation of bureau reports.
  • Maintained coding standard practices, high quality .NET code, and normalization techniques with SQL and T-SQL.
Technologies: SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), C#, ASP.NET, HTML5, T-SQL (Transact-SQL), Data Engineering, Data Analysis, Data Visualization, ETL, JavaScript, SQL Server 2012

IT Consultant

2014 - 2016
L2S2
  • Implemented n-tier architectural design - Presentation Layer (GUI), Business Access Layer (BAL), Data Access Layer (DAL) and Service Layer.
  • Implemented a Prism MVVM design pattern for developing a WPF application.
  • Developed a GUI using WPF controls, Windows controls in .NET 4.0/4.5, VS.NET2015, C# and XAML, and Telerik WPF controls.
  • Trouble shot SQL performance issues, maintained DB schemas, and wrote complex stored procedures.
  • Responsible for bugs and tickets for future enhancements and worked in production support.
  • Created complex stored procedures, triggers, views, and a CTE for retrieving the data from the SQL Server database to fill the business objects.
  • Developed User Controls and a Custom Controls Standard Library for the client control repository.
  • Performed NUnit testing for different modules in the application to ensure a bug-free code in to production.
Technologies: C#, JavaScript, SQL Server 2012

Analyst Programmer

2010 - 2014
Confidential
  • Generated views, reports, and dashboards, including tiles from multiple reports, using Power BI with dimensional modeling techniques to identify parameters necessary to create dimensions, facts, and aggregate tables.
  • Collaborated with business users and a business analyst for requirements gathering and business analysis. Converted business requirements into detailed designs.
  • Created a staging database for temporary data processing, consolidating data, and loading into the target database using SSIS.
  • Developed SSIS packages using different data transformations such as derived column, lookup, a conditional split, merge join, union all, sort and execute SQL, and task to load data into the database.
  • Developed data modeling and visualization using tools such as Power BI.
  • Built ad-hoc reports such as an analysis grid that could drill down at a hierarchical level with functions such as print and download.
  • Developed and maintained technical documentation for all designed solutions.
Technologies: ASP.NET MVC 4, C#, SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server 2014, JSON, Data Engineering, Data Analysis, Data Visualization, ETL, JavaScript

IT Consultant

2007 - 2010
ITC Infotech USA
  • Collaborated with an agile team of .NET developers for a fast-paced software development firm.
  • Oversaw requirements gathering, conceptual design, analysis, and detail design, development and system testing.
  • Created use cases, flow diagrams, and activity and state diagrams using MS Visio.
  • Assisted in the writing of unit test cases on business and service classes using NUnit. Involved in various phases of system testing such as unit, integration, and regression testing.
  • Involved in developing Web Services (WCF) and invoking them by using XML SOAP and WSDL tools for creating proxy classes.
  • Developed complex database objects such as stored procedures, functions, packages, and triggers using SQL Server.
Technologies: ASP.NET, ASP.NET MVC 4, C#, SQL, SQL Server Integration Services (SSIS), JavaScript

Check Clearing Process Migration

The process of check clearing in the UK had undergone an important and necessary change. The main difference was that instead of exchanging physical paper checks, UK banks had begun to exchange digital images of these checks.

I was a part of the team that designed a solution to process these images and data at the same speed. Introducing the concept of Microsoft SQL Server in-memory OLTP, I helped the organizations load and process the images and data of around two million checks with very high throughput.
Serving as the organization-wide data warehouse architect, I helped the senior management in the decision-making and creating the most useful Power BI-based dashboards.

DecisionStation (LOS)

Loan origination software called DecisionStationTM, an application processing, credit evaluation, and credit scoring system software used mainly by BHPH auto clients and retail furniture clients. The process goes through a full cycle of capturing, evaluating, decisioning, and closing of a loan application. It produces letters, closing documents, and user-defined reports

I designed and developed the application from start to end. I gathered requirements and translated them into technical specifications and wrote code out of them. I created an automation unit testing framework to execute 10,000 regression steps and Power BI dashboard reports with periodic emailing of reports.
2001 - 2005

Bachelor's Degree in Computer Science and Information Technology

Jawaharlal Nehru Technological University - Hyderabad, India

SEPTEMBER 2021 - PRESENT

Azure Developer Associate (AZ-400)

Microsoft

MARCH 2021 - PRESENT

Azure Cloud Fundamentals (AZ-900)

Microsoft

Tools

Microsoft Power BI, Visual Studio 2015, Git, Visual Studio

Languages

C#, SQL, Stored Procedure, JavaScript, T-SQL (Transact-SQL), HTML5

Paradigms

Database Design, ETL

Storage

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), JSON, SQL Stored Procedures, SQL Server 2014, SQL Server 2012, Database Architecture, Azure SQL, Azure Queue Storage, Azure Blobs, Microsoft SQL Server, Datadog, Database Performance

Frameworks

ASP.NET, ASP.NET MVC 4, ASP.NET MVC, Windows PowerShell

Platforms

Azure, Azure PaaS, Azure IaaS, Visual Studio Code (VS Code), Amazon Web Services (AWS)

Other

SSRS Reports, Internet Information Services (IIS), DAX, Data Engineering, Data Analysis, Data Visualization, Data Modeling, Dashboards, CI/CD Pipelines, Azure Data Lake, Algorithms, Information Systems, Azure Data Factory, Data Architecture, Site Reliability Engineering (SRE), APIs

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring