Suri Vinta

• Improved Business Owners satisfaction by effectively managing multiple projects and consistently meeting deadlines.
• My day to day work includes leading the projects, developer work assignments, code reviews and development.
• Executed complex SQL queries in Snowflake to retrieve and manipulate data for reporting purposes. Utilized Snowflake's data warehousing capabilities to streamline data processing, resulting in improved efficiency.
• Collaborated with business leaders to identify key metrics and translated business requirements into actionable insights through ThoughtSpot.
• Developed and implemented ThoughtSpot dashboards to facilitate real-time analysis and reporting, improving data accessibility for stakeholders.
• Utilized Tableau Prep for efficient data cleansing, transformation, and preparation, ensuring high-quality datasets for analysis.
• Successfully exported cleaned and transformed data from Tableau Prep to various formats, facilitating seamless integration with downstream analytics tools.
• Implemented Tableau Conductor to schedule and automate Tableau Prep workflows, optimizing data processing and ensuring timely updates.
• Developed innovative strategies for Business Owners, resulting in increased revenue and business growth.
• Generated reports detailing findings and recommendations.
• Extensively used Bitbucket, Git, Sourcetree for source code repository.
• Optimized SQL queries for improved performance and availability.
• Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as SSIS, Bulk Insert, BCP.
• Created sub reports, drill down reports as part of the project according to business requirements using Reporting Services (SSRS)
• Extensively used Joins, CTE and sub-Queries to simplify complex queries involving multiple tables.
• Extensively used Tidal to monitor & scheduler Jobs and fix the jobs on failure

• Worked with project managers, developers, quality assurance and customers to resolve technical issues
• Experience working with Docker Images
• Experience working with Bitbucket along with Bamboo CI pipeline configuration and also worked on Jenkins Pipelines.
• Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, Informatica, Bulk Insert.
• Optimized SQL queries for improved performance and availability.

Environment: SQL Server 2012/2014 & 2016, SSRS, SSIS, Tidal, MSSQL, Tortoise SVN, Bitbucket, GitHub, Excel, Jenkins, Docker, Git, Azure, AWS.

• Worked with project managers, developers, quality assurance and customers to resolve technical issues
• Experience working with Bitbucket along with Bamboo CI pipeline configuration for Insights Agent Project and also worked on Jenkins Pipelines for Remediation Client Project
• Experience working with Docker Images
• Knowledge of Kubernetes concepts and containerization
• Experience working with container orchestration systems such as Kubernetes
• Experience working with Java and .net-based applications
• Enabled KEDA for autoscaling pods based on CPU metrics
• Setup and configured Azure CDN
• Configured and managed Azure infrastructure trough terraform
• Enabled CICD Pipelines through Gitlab for Remediation Server Project
• Enabled SonarQube, Unit Tests, BlackDuck, Checkmarx scans in Gitlab CICD stages
• Security scanning integration experience in CI/CD pipeline
• Worked on ELK through helm charts
• Experience with Kubectl and HELM chart-based deployments
• Also used dashboards like Grafana and Power BI to pull the Code Coverage and KPI metrics
• Enabled Ingress and nginx on AKS Clusters
• Worked with cross-functional design teams to create software solutions that improved overall functionality and performance
• Worked in 'Infrastructure as Code', automation and best practices using Terraform, AWS Cloud Formation
• Created EC2 instances with appropriate tags and configured auto-scaling groups based on the app owner's requirement
• Experience deploying and supporting core AWS services like IAM, EC2, RDS, as well as networking and storage technologies
• Collaborated closely with product development teams and other stakeholders.

Environment: Jenkins, Docker, Git, Bitbucket, Bamboo, VS Studio, Gitlab, Kubernetes, Bash, Jira, Shell Scripts, SonarQube, Checkmarx, Blackduck, Linux, Azure, AWS, CDN, Artifactory, MSSQL Server, Integration Services (SSIS), Informatica, Java, PostgreSQL

• Lead developer in designing and development of complex projects and reports
• Promoted best coding practices and software development standard
• My day to day work includes leading the projects, developer work assignments, code reviews and development
• Worked on Teradata to pull data from source databases like Edward etc.
• Experience working with Claims, Member, Provider, Utilization, Appeals and Grievances data
• Worked on GEO Access and Quest to generate GEO coding reports
• Developed complex T-SQL queries using Joins, Sub Queries, Stored Procedures, ranking functions and PIVOT
• Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, Informatica, Bulk Insert, BCP.
• Created sub reports, drill down reports as part of the project according to business requirements using Reporting Services (SSRS)
• Extensively used Joins, CTE and sub-Queries to simplify complex queries involving multiple tables
• Extensively used Tidal to monitor & scheduler Jobs and fix the jobs on failure
• Extensively used Bitbucket, Git, Sourcetree for source code repository
• Optimized SQL queries for improved performance and availability
• Experience working on department SharePoint development and Departmental Projects, Market Stats, Date Calendar, SQL BRD validation and De-identification
• Worked on Intake tool modification, where I had to work on C# and MVC .Net 5.0 modifications
• Created S3 buckets in AWS and loaded the report output files into S3 buckets using CLI Scripting
• Created EC2 Instances as part of a POC
• Willingness to learn new technologies

Environment: SQL Server 2012/2014 & 2016, SSRS, SSIS, Tidal, Tortoise SVN, Bitbucket, GitHub, Excel, T-SQL, Windows 10, Visual studio2014, JIRA, Teradata, GEO Access, Quest, CTU, AWS, S3, CLI Scripting

• Developed complex T-SQL queries using Joins, Sub Queries, Stored Procedures, ranking functions and PIVOT
• Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert, BCP
• Involved in requirement gathering, analysis, design, development and deployment
• Developed different types of standard and ad-hoc Tabular, Matrix, Drill-Down reports, Drill through reports, Sub reports, Parameterized reports using SSRS as per requirement
• Created sub reports, drill down reports as part of the project according to business requirements using Reporting Services (SSRS)
• Extensively worked on several complex projects such as TN APCD, WA APCD, ClaimsXten
• Developed several reports for various markets such as VA, WNY, GA rebid, VACC Plus, IOWA and WA
• Created sub reports, drill down reports as part of the project according to business requirements using Reporting Services (SSRS)
• Created various data driven subscriptions to pass custom dates for SSRS reports deployed on Production report server for automatic file generation as per report due dates
• Experience working with Claims, Member, Provider, Utilization, Appeals and Grievances data
• Extensively used Joins, CTE and sub-Queries to simplify complex queries involving multiple tables and optimized SQL queries for improved performance and availability
• Worked closely with clients to establish specifications and system designs

Environment: SQL Server 2008/2012 & 2014, SSRS, SSIS, Tidal, Tortoise SVN, Excel, T-SQL, Windows 7, Visual studio2005, JIRA

• Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements
• Created optimal technical solutions to user needs through research and in-depth system analysis
• Designed and implemented TSQL queries for reporting and complex solution development
• Extensively used SSIS, SSRS, Bulk Insert and BCP as per report needs
• Consulted regularly with internal customers on application development project status, new project proposals and software-related technical issues
• Worked closely with other business analysts, development teams and infrastructure specialists to deliver high availability solutions for mission-critical applications

Environment: SQL Server 2008/2012, SSRS, SSIS, Tidal, Tortoise SVN, Excel, T-SQL, Windows XP/7, Visual studio2005, JIRA

• Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing
• Analyzed existing SQL queries to identify opportunities for improvements
• Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements
• Developed & documented test strategy, test plans & test cases for Web application testing
• Monitored emerging test automation frameworks, technologies and best practices for useful developments
• Designed standardized processes and protocols to continuously improve operational efficiency through positive iteration

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services 2005/2008, SSIS, QF-Test, QA Planner, Jira, Windows XP/2007, MS Office 2003/2007.

• Created test cases and test scripts to maintain cohesive team approach to product development
• Created stored procedures and triggers using T-SQL in Query Analyzer
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins
• Determined test requirements and built jobs to meet quality requirements and benchmarks in support of internal software developers
• Conducted regression testing, analyzed results and submitted observations to development team

Environment: MS SQL Server 7.0/2000, Windows 2000/NT/XP, T-SQL, Query Analyzer.