Shiva Reddy Mandadi

SSIS/DW Developer with Azure/Snowflake at AIM Specialty Health
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Learning Python
    LinkedIn
    Oct, 2020
    - Nov, 2024

Experience

  • AIM Specialty Health
    • United States
    • Hospitals and Health Care
    • 500 - 600 Employee
    • SSIS/DW Developer with Azure/Snowflake
      • Jun 2020 - Present

       Provide feasible and effective solution to Client’s requirement.  Create database objects like tables, views, stored procedures and user defined functions using SQL Server Management Studio 2016.  Migrate SSIS packages from 2008 to 2016. Convert SSIS packages from Package to Project Deployment model.  Migrate Datamart and Cube packages from 2008 to 2016 Server.  Fix Data conversion errors and SSIS package errors while upgrading SSIS packages from 2008 to 2016.  Develop new T-SQL Scripts and SSIS packages to load data from source Sybase to SQL Server Data Warehouse. Worked with Azure Storage Explore, Azure Data Factory and Azure Synapse.  Built data pipelines using Azure Data Factory.  Built ADF pipelines to export data from SQL Server Management Studio and generate Azure ADLS files.  Built ADF pipelines to Import data from Azure ADLS files to the Dim and Fact tables in Snowflake.  Implemented complex and dynamic logic in ADF pipelines while moving data from ADLS files to final destination tables in Snowflake.  Implemented Type 1 and Type 2 Slowly Changing Dimensions.  Used Microsoft Visio for Data Model Changes.  Used Microsoft Visual Studio code for Code Repository.  Used Azure DevOps to track the work, create branches and pull request.  Pushed Code using Git bash.  Used Anconda3/Python for count validation in Tables during testing.  Use PowerShell Script to deploy SSIS packages and create Jobs on Server.  Performance tuning of Stored Procs and SSIS Packages.  Use SVN (1.10.1)& GIT (2.17.0) for version control and maintaining of SQL Scripts and SSIS Packages scripts. Environment: SQL Server Management Studio (2016/2017), Visual Studio (2008/2017), SQL Server Data Tools (2016), SQL Server Integration Services, Azure Storage Explorer, Azure Data Factory, Azure Synapse, Snowflake, AWS, Sybase ASE, Data Flux Management Studio, Rapid SQL, GIT (2.17.0), SVN (1.10.1), PowerShell Script, Anconda3, Python 3.8. Show less

  • Sally Beauty
    • United States
    • Retail
    • 700 & Above Employee
    • Senior Database/Business Intelligence Developer
      • Jan 2020 - Jun 2020

       Full cycle project Implementation, Scoping, Planning, Design, and Implementation Methodology, Migration and production support.  Create database schema and number of database objects like tables, views, stored procedures and user defined functions using SQL Server Management Studio.  Write complex T-SQL Scripts to extract data from database as per business requirements.  Create Clustered, non-clustered indexes and indexed views to optimize the queries performance.  Analyze the defects along with the testing team and perform code updates to resolve the defects.  Worked on extracting data from JSON and XML file formats and importing into SQL Server and worked on exporting data to JSON and XML formats from SQL Server  Worked on importing and exporting data to Azure SQL Server.  Created DIM and FACT tables. Implemented Type 1 and Type 2 SCD’s.  Developed complex SSIS packages to load DIM and Fact Tables in Datawarehouse and worked on deploying the projects/packages to production and creating and scheduling the jobs. Used BIML FLEX Components.  Developed SSIS packages with logging features to log the errors into table on failure.  Generate Tableau Reports.  Worked with Web/.Net team to import and export data.  Loading data into Salesforce and loading data from Salesforce to SQL Server database tables using SSIS and third-party tool Kingswaysoft.  Worked on trouble shooting and resolving network connectivity issues and TCP/IP traffic flow control and security issues.  Worked with TFS (2017), GIT (2.17.0) for maintaining SQL Code and SSIS packages.  Apart from development activities, worked as onsite lead and acted as a bridge between onsite team and offshore team and was responsible for getting work done by offshore team and meeting deliverables. Show less

  • YRC Freight
    • United States
    • Truck Transportation
    • 700 & Above Employee
    • Senior Database Developer
      • Feb 2017 - Dec 2019

       Database designing, modeling and reporting.  Develop tables, views, stored procedures, scalar valued functions, tabular valued functions and Triggers.  Use Service Broker to send Real Time Messages and to move data from one database to another.  Performance Tuning of T-SQL Scripts, Stored Procedures and SSIS packages.  Use advanced features in SQL Server like exception handling (try, catch) extensively for the ease of debugging and displaying the error messages in the application. Peer review and validate the SQL Scripts written for SAS to SQL Server Database Migration.  Analyze the defects along with the testing team and perform code updates to resolve the defects.  Create complex ETL packages using heterogeneous data sources (SQL Server, Oracle Server, Flat Files, Excel Source files, XML files etc.) and then load the data into destination tables by performing various kinds of transformations using SSIS.  Use of different transformations like Look ups, Derived Column, Merge Join, Fuzzy look up, For Loop, For Each Loop, Conditional Split, Union All, Script Component etc. in the package development.  Work extensively on C# script development for transforming business logic into SSIS business code.  Create new SSRS reports and Modify existing reports. Pull the Data for SSRS reports using SSAS Tabular Model as source.  Migrate SSRS reports to Power BI server, develop new reports using Power BI.  Used TFS (2015,2017) and GIT (2.17.0) for maintaining SQL Code and SSIS packages.  Do On-Call rotations and provide production support during the week and on the weekend. Environment: SQL Server Management Studio (2012/2014/2016/2017), Visual Studio (2012/2015/2017), SQL Server Data Tools (2012/2015), SQL Server Integration Services, Service Broker, Red Gate SQL Source Control and SQL Compare, Main frames, TFS(2017), GIT (2.17.0), JIRA, Agile methodology, Service Broker, Power BI. Show less

  • Lockton
    • United States
    • Insurance
    • 700 & Above Employee
    • Database Developer
      • Nov 2015 - Jan 2017

       Actively involved in interacting with front end users, project lead and business analyst to gather user requirements and online system specifications.  Gather requirements and design of data warehouse and data mart entities.  Generated assessment reports to analyze the scope and complexity of the migration projects.  Involved in writing complex SQL scripts which includes transact statements, database object validation and exception handling to facilitate functionality in different modules.  Handled errors using exception handling (try, catch) extensively for the ease of debugging and displaying the error messages in the application.  Created audit tables and implemented complex business logic using triggers.  Created clustered, non-clustered indexes and indexed views to optimize the queries performance.  Involved in conversion of DTS to SSIS packages and troubleshooting the Migration issues.  Worked extensively on C# script development/Modification for transforming business logic into SSIS business code.  Created Configuration files to deploy the SSIS packages across all environments.  Created complex ETL packages using heterogeneous data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.  Used different transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc.  Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded into the audit table.  Monitor the production cycle and resolve the failures within limited amount of time.  Used SQLCMD commands to backup and restore database.  Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes. Show less

  • SE2, LLC
    • United States
    • IT Services and IT Consulting
    • 300 - 400 Employee
    • Programmer Analyst
      • Jun 2014 - Oct 2015

       Dynamically supported business users & Customers for given requirements and developed reports accordingly.  Co-Ordinate with offshore team on report requirements and development.  Developed various complex T-SQL/PL-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.  Use Toad to develop PL/SQL scripts.  Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.  Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).  Refreshing the cube to get the latest information updated and deployment of Cubes to the production server  Generated various reports with drilldowns, drill through, calculated members and dropdowns from the cubes by connecting to analysis server from SSRS (2005/2008).  Created data sources, connection strings and defined the datasets for generating the report.  Created and worked with drill down reports and identified the report parameters.  Created Cascaded and Cascaded Parameterized reports.  Used various report items like tables, sub report and charts to develop the reports in SSRS.  Deployed and generated reports on to the server using the Reporting Services Report Manager.  Built and deployed Report Models using Report Builder 2.0 to facilitate ad-hoc reporting for end users.  Worked with various Delivery mechanisms of Reports including Email/Windows File Share /PDF/Excel etc.  Created subscriptions to provide a daily/Weekly/Monthly/Annual basis reports.  Managed and troubleshoot the report server related issues. Migrate Crystal reports to SSRS reports.  Provide weekly production support to all the jobs in production Show less

  • Phillips 66
    • United States
    • Oil and Gas
    • 700 & Above Employee
    • SQL Data Migration Analyst
      • Oct 2013 - May 2014

       Responsible for creating mapping documents according to business requirements.  Translating business requirements into implementation with SQL Queries.  Modelling Data, objects, table structures, wrote stored procedures, functions, views and triggers (Transact - SQL Procedural Languages) in Sybase ASE.  Involved in writing queries with join conditions, correlated sub queries, and nested queries for the business application development.  Developed procedures and database triggers for the validation of input data and to implement business rules.  Involved in various data transformation and cleaning techniques like cast, convert, trim etc.  Tuning and enhancing performance Improvement of all backend database objects in Transact-SQL both in Sybase and Salesforce SOQL.  Source control, development, management and deployment of database objects that are developed for data migration.  Read existing SQL/Procedural code and reverse engineer SQL Logic and re-implement it.  Developed batch scripts for scheduling data migration scripts. Writing unit tests for Transact-SQL Scripts that are developed. Production support for the modules developed and pushed up. Environment: Windows Server 2008, SAP Sybase ASE 11, Microsoft SharePoint, DB Visualizer, SQL Profiler/Query Analyzer Show less

Education

  • Harrisburg University of Science and Technology
    Master's degree, Information Systems and Engineering Management
    2016 - 2018
  • New Mexico State University
    Master's degree, Industrial Engineering
    2012 - 2013
  • Jawaharlal Nehru Technological University
    Bachelor's degree, Electronics and Instrumentation Engineering
    2008 - 2012

Community

You need to have a working account to view this content. Click here to join now