Suhasini Akula

About Suhasini Akula

Decisive, Results-Focused Software Developer offering an experience of over 13+power bi years in Information Technology. Possessing excellent analytical skills summed up with strong knowledge in writing SQL queries, Stored Procedures / Functions/ Packages / Triggers, Shell Scripting, Troubleshooting, Debug Coding, Analysis and Unit testing”.Extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources. Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging. Prepared the complete data mapping for all the migrated jobs using SSIS. Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers. Expertise in creating/modifying Tables, Views, Stored Procedures, Functions and Triggers and in depth knowledge in query optimization & performance tuning. Interacted with various upstream and downstream customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs. Designed & developed ETL procedures, Data dictionaries, data mappings involving data analysis, data validations and data migrations.

Experience

1. Software Product Mgmt Specialist Lead

   Accenture

   Jul 2021 — Present · IN

   Working with Accenture since 4 + yearsDesigned and implemented complex ETL pipelines using Databricks (Python, PySpark, Spark SQL) and AzureData Factory to efficiently ingest and transform data from multiple sources into a Data Lake and Azure SQLDatabase. Developed and maintained a highly scalable Big Data application using Python, Spark SQL, PySpark, anddeployed it on Azure Kubernetes Service with Spark pods implementation, handling 100 million records perprocessing. Built and managed Data Pipelines and Jobs with Databricks (Delta Live Tables, PySpark, Python, SQL) andAzure Data Factory to streamline data processing.Developed Complex SSRS reports and Migrated 100+ OBI reports to Power BI paginated reports Mentored more than 20 people while migrating OBI reports to Power BI reports Trained new ASE\'s on SQL and Power BI reports Prepared Coding standards for SQL server queries Handled daily client calls and Teams discussions Gathered Status from all team members and shared with clientLearn Google Big Query in less span of time and written complex stored procedures

Education

• Prathiba Degree College

  Bachelor of Science (BSc), Mathematics

  2005 — 2008

• Mathrusri institute of p.g. studies, Hyderabad

  Master of Computer Applications (MCA), Computer Programming, Specific Applications

  2008 — 2011

Skills

• Business Intelligence
• Wcf
• Html5
• Ibi Webfocus
• Etl
• Sql Server Integration Services (Ssis)
• Visual Studio
• C++
• Java
• Data Warehousing
• Core Java
• Javascript
• Html 5
• Agile Methodologies
• Ssrs
• Sql
• .net Framework
• Asp.net
• C#
• .net
• Asp.net Ajax
• Microsoft Sql Server
• Windows Communication Foundation (Wcf)
• Sql Server Reporting Services (Ssrs)
• Ssis
• C++ Language
• Databases
• Extract, Transform, Load (Etl)