Vishnu Kappera Email & Phone Number

Phoenix, Arizona, United States

Arizona, United States

I had the opportunity to contribute to a variety of impactful projects, including:• Migration Strategies: I developed and executed comprehensive plans for transitioning data from multiple SQL Server databases to Snowflake, ensuring minimal downtime and maintaining data integrity throughout the process.• Automated Pipelines: I designed and implemented automated data pipelines using PowerShell and T-SQL, streamlining data transfer operations and improving efficiency.• Data Transformation: I created and optimized algorithms to clean, standardize, and prepare data for analysis in Snowflake, enabling accurate and reliable insights.• ETL Process Management: I managed end-to-end ETL processes, from data extraction in SQL Server to loading it into Snowflake, ensuring consistency and accuracy at every stage.• Operational Insights: I developed and deployed algorithms that generated daily operational insights, empowering stakeholders to make informed decisions.• Collaborative Solutions: I worked closely with data engineers, analysts, and business stakeholders to gather requirements and deliver scalable and tailored data solutions.• Technical Support: I provided technical guidance and support throughout the migration journey and during ongoing Snowflake operations.• Documentation: I maintained detailed documentation of processes, configurations, and best practices for data migration and Snowflake maintenance, ensuring knowledge retention and continuity.• Training: I led training sessions to upskill team members and stakeholders on Snowflake usage and the management of newly implemented data pipelines.• Process Optimization: I proactively identified opportunities to optimize processes, implementing enhancements to improve system performance and reliability.These experiences equipped me with the technical expertise, problem-solving skills, and collaborative mindset.

Phoenix, Arizona Area

• Spearheaded the development and automation of stand-alone processes, generating daily operational production data. This data played a crucial role in offering insights and recommendations to optimize operational performance and reduce production costs effectively.• Crafted various project tracking reports, dashboards, and SLA measurement views/reports, aligning with client success metrics. These reports provided leadership with a clear understanding of the organization's performance across all projects.• Collaborated closely with enterprise data warehouse, data governance, and business teams to address data quality issues, resulting in the creation of an efficient data repository.• Leveraged advanced analytical techniques, including Actions, Calculations, Parameters, Background images, Maps, Trend Lines, and Statistics, to enhance business analytics and facilitate more effective operational planning.• Developed data visualization reports using Tableau, incorporating charts, drill-down capabilities, and parameterized controls to underscore the value of analytics in executive decision support control.• Managed complex SQL scripts, indexes, Common Table Expressions (CTEs), and data-driven tables for data analysis and SLA reporting using Microsoft SQL Server Management Studio (SSMS) 2017/2019.• Proficiently configured and scheduled SQL Agent jobs for SSIS packages, implementing checkpoints, package logging, error handling, and event-based error redirection and resolution.• Collaborated with a variety of data sources, including SQL Server, Oracle, Redshift, MS Access, and MS Excel, to create ETL processes for diverse reporting solutions using SSIS and Python.• Extensively utilized the SSIS tool suite to design and implement mappings, employing transformations such as OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast, and Lookup.

Phoenix, Arizona, United States

• Demonstrated proficiency in creating and developing dashboards, ad-hoc reports with a product and customer-centric focus, and various data flow processes. Provided strategic leadership and guidance in all aspects related to business analysis.• Analyzed and visualized a substantial volume of data, delivering end-to-end reporting solutions to support operational initiatives and inform strategic decision-making.• Leveraged data mining techniques to drive operational improvements and enhance visibility into strategic executional opportunities.• Collaborated in gathering business requirements, conducting stakeholder interactions, and subsequently creating production databases to support business needs.• Designed and implemented incremental data load tasks, data integrations, data tracking, and workflow solutions for data warehousing using SQL Server Integration Services (SSIS).• Created and maintained Tableau reports utilizing Tableau Desktop, specializing in advanced chart visualizations such as Dual Axis charts, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Waterfall charts, and funnel charts, facilitating complex problem-solving for business users.• Established a unified monitoring dashboard in Tableau Server for tracking daily performance of all automated ETL processes and scheduled jobs from SQL Servers.• Conducted efficient tuning of SQL source queries to optimize data load and enhanced performance, utilizing software products including Microsoft SQL Server 2008/2012/2016/2019 and query analyzer.• Implemented user security and roles in reporting services at both the parent and report levels to ensure secure and controlled access to critical data.• Pioneered SSRS report email subscriptions using data-driven report subscription methods to enhance communication and reporting efficiency.

Greensboro/Winston-Salem, North Carolina Area

• Designed and performed standard integration, analysis and reporting standard and ad-hoc reports utilizing SQL Server, Analysis, and Reporting Services. • Created ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.• Developed, implemented, administered, and supported ETL processes for large-scale Data Warehouses using SSIS and DTS. Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.• Engaged in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis. Build the SSRS environment for both Dev and test servers based on the client needs.• Created Datasets in T-SQL, stored procedures for Reports in SSRS with different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Phoenix, Arizona Area

• Performed logical and physical database design to support existing and new applications.• Prepared and updated current database structure and configuration for high-performance through analysis and optimization.• Maintained and developed the logical data access layer by utilizing all supporting business applications.• Handled the development escalations that require data manipulation on high volume production servers.• Automated Credit card reconciliation process for more than 10 different credit cards over One million of monthly transactions for each system processor to eliminate the Fraud transactions.• Handled discrepancies in different credit card transactions by developing a single standard report to calculate the Gain/Loss for each process for Monthly, Quarterly, Yearly audits.• Performed Vendor data integration to import data from Secured File transfer protocol to existing data bases.• Extensively used advance chart visualizations like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.• Created new reports and updated existing reports for all reconciliation process using SSRS reporting Service.• Responsible for Deploying SQL Scripts, Stored procedures, SSRS reports to the production Servers.• Monitoring the Scheduled SQL jobs, Windows jobs for the credit card and banking processors.

Greater Detroit Area

• Created reports in Tableau, analyze metrics, implement verification procedures, and fulfill business requests for information. • Developed SSIS Templates that can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.• Worked on development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.• Created Tabular Matrix reports, Charts, and graphs as per customer requirements Using SSRS.• Good understanding of SSRS with Report authoring, Report management, Report delivery and Report security and Created reports with Analysis Services Cube as the data source using SSRS 2005/2008.• Utilized SQL profiler to view indexes performance to mostly eliminate table scan and filtered inaccurate data from legacy system using complex T-SQL statements and implemented various constraints and triggers for data consistency.• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.• Created new tables, stored procedures for Application Developers and some user defined functions.• Performed data conversions from flat files into a normalized database structure.• Managing of databases objects like Tables, views, indexes, functions, and procedures.• Extensively used joins and sub queries to simplify complex queries involving multiple tables.• Installed and configured SQL Server 2005 on windows 2003 Server OS.• Created and managed users, roles and groups and handled database security.• Created Triggers to enforce data and referential integrity also defined Check constraints, Business Rules, Indexes, and Views.• Created DTS Packages for extracting data from Flat Files, Excel, MS Access, Oracle, and MS SQL Server 2005.