Sravya Ankishetty Email & Phone Number

Tempe, Arizona, United States

Designed, implemented, and maintained scalable data pipelines to collect, process, and transform structured and unstructured data from various sources.Worked on modifications of the SQL code as per the requirement to build the pipeline.Monitoring of the Jobs scheduled in Control M.Successfully ingested the job end-to-end using microservices.Changes performed on the jobs in both Control M and the Registration portal as per the requirement.Implemented data transformations and aggregations using SQL.Investigating the cause of the job failure and fixing the issues.Performed data ingestion.Performed history load of the data in EDH and validated.Changes performed both on data and metadata of the objects.Worked on creating the feeds for FISERV data ingestion.Worked on databricks and Azure services.Deployed and managed data processing systems using CI/CD pipelines in Azure Devops.Implemented the changes in the microservices while transitioning to the Unity catalog.Created and managed clusters in databricks, installation of necessary libraries on the cluster, declaring the global parameters and modifying the changes accordingly in the required microservices.Interacted with databricks team on a regular basis.Well-versed with Confluence, JIRA and Linux commands.Mentored and guided team members and new joiners.Unit testing has been performed on every modification to the code.Maintained documentation and Issue trackers.Conducted data analysis on data marts utilizing SQL, providing valuable insights to the data modeling team.Responsible for Data Modelling and Data Mapping.Gather metadata information for the necessary data tables.Performed Data profiling and provided valuable inputs by identifying data redundancies, spelling mistakes across different layers.Collected business names and definitions for all column-table pairs through collaboration with clients and utilization of internal tools.Validated reports to ensure accuracy and consistency.

Tempe, Arizona, United States

For a given requirement of a data set, developed SQL code to draw some conclusions based on specifications.Also, developed a logical data model for the dataset which shows how the different tables can be connected.Developed an informative Tableau Dashboard, highlighting significant insights about the data.Presented the Tableau dashboard to the organization leads, explaining different visualizations, attributes used and the insights drawn by those visualizations and analysis behind it.

Hyderabad Area, India

Worked on tuning the existing database objects to ensure better performance of Application.Analyzing the Job timings to reduce the time taken for the job to complete.Deploying the modified changes from development to other required environments.Creation of design document.Performing Unit Test on the Application.Responsible for creating and resolving service based requests through service now.Analyzing the statistics of the database server.

Hyderabad Area, India

Generates, process, evaluates and manipulates Mortgage Back Securities (MBS) data associated with Clients’ request in order to access its accuracy, validity and completeness using MS Access, SQL ServerSupport End user Computing (EUC) tools to enable client’s team to meet contractual and customer service obligationEnhance investors’ reporting and ensure that it remains in compliance with the requirement indenture and investors-defined guidelinesActively participate and assist the system support group with design, programming, analysis and User Acceptance testing (UAT) of Business rules to ensure expected outcomesWork with internal/external clients in resolving issues on new and existing loan transactionsResponsible for prompt payment and reporting task associated with Asset Back Securities (ABO), debt Obligation (CBO) and Loan finance facilities and Commercial loan obligation (CLO)administrationLiaise with Technology to create technical requirement, adopt data coding standards and ensure that existing technology support the clients’ data management Objectives

Kolkata Metropolitan Area, West Bengal, India

Installation and Configuration of SQL server.Installation and Configuration of IIS.Performing some of the SQL Admin tasks.Application Configuration.Automating the Database Maintenance tasks by creating Jobs and Alerts.preparation of technical documents for ensuring maintainability, consistency and coding standard.Troubleshooting problems with the help of SQL Server Profiler and T-SQL debugger.Checking the compatibility issues with Upgrade advisor tool in new SQL server and solving them.Communicating with the on-shore team manager on daily basisPerformed Unit TestingMaintenance and Tracking of Status Reports and Issue logs.

Bachelor'S Degree, Computer Science

Ssc