Vijender Reddy Mucha

• Implemented machine learning algorithms for predictive analytics, improving decision-making processes within the company.
• .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
• Gathered, defined and refined requirements, led project design and oversaw implementation.
• Documented and communicated database schemas using accepted notations.
• Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
• Planned and installed upgrades of database management system software to enhance database performance.
• Developed and delivered business information solutions.
• Managed identification, protection and use of data assets.
• Established and secured enterprise-wide data analytics structures.
• Designed data models for complex analysis needs.
• Collaborated with system architects, design analysts and others to understand business and industry requirements.
• Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.
• Contributed to internal activities for overall process improvements, efficiencies and innovation.
• Designed and developed analytical data structures.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Evaluated various tools, technologies, and best practices for potential adoption in the company''s data engineering processes.
• Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements.
• Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
• Collaborated with cross-functional teams for seamless integration of data sources into the company''s data ecosystem.
• Conducted extensive troubleshooting to identify root causes of issues and implement effective resolutions in a timely manner.
• Developed custom algorithms for advanced analytics, driving actionable insights from large datasets.
• Designed scalable and maintainable data models to support business intelligence initiatives and reporting needs.
• Led end-to-end implementation of multiple high-impact projects from requirements gathering through deployment and post-launch support stages.
• Provided technical guidance and mentorship to junior team members, fostering a collaborative learning environment within the organization.
• Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
• Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.
• Collaborated with data scientists to develop machine learning models by providing the necessary data infrastructure and preprocessing tools.

• Design and implement data storage solutions using Azure services such as Azure SQL Database, Azure Cosmos DB, and Azure Data Lake Storage
• Develop and maintain data pipelines using Azure Data Factory and Azure Databricks
• Create and manage data processing jobs using Azure HDInsight and Azure Stream Analytics
• Perform data modeling and schema design for efficient data storage and retrieval
• Optimize data processing and storage for performance and cost efficiency
• Implement security and compliance measures for data storage and processing
• Collaborate with data scientists and analysts to provide data insights and support data-driven decision making
• Troubleshoot and resolve data processing and storage issues
• Develop and maintain documentation for data storage and processing solutions
• Stay up-to-date with new Azure services and technologies and evaluate their potential for improving data storage and processing solutions.

• Design and implement data storage solutions using Azure services such as Azure SQL Database, Azure Cosmos DB, and Azure Data Lake Storage
• Develop and maintain data pipelines using Azure Data Factory and Azure Databricks
• Create and manage data processing jobs using Azure HDInsight and Azure Stream Analytics
• Perform data modeling and schema design for efficient data storage and retrieval
• Optimize data processing and storage for performance and cost efficiency
• Implement security and compliance measures for data storage and processing
• Collaborate with data scientists and analysts to provide data insights and support data-driven decision making
• Troubleshoot and resolve data processing and storage issues
• Develop and maintain documentation for data storage and processing solutions
• Stay up-to-date with new Azure services and technologies and evaluate their potential for improving data storage and processing solutions.

• Designed and developed standalone data migration applications to retrieve and populate data from Azure Table / BLOB storage to on premise SQL Server instances.
• Served as process owner under Agile Scrum project implementation, leading session for sprint planning, sprint review and sprint retrospective meetings.
• Understand the Requirements and Functionality of the application from specifications.
• · Having Good experience in writing SQL queries using concepts like Indexes, Joins, Sub-queries, Views, Stored procedures, Triggers, Functions, Group By, and Constraints etc.
• · Extensively used ETL methodology for Data Migration from various sources into Data Warehouse using SQL Server Integration Services (SSIS).
• · Good Working Experience in creating packages for implementing ETL Methodology by using various Control Flow Tasks, Containers, and Data Flow transformations while migrate the data from source to destination.
• · Hands on Experience implementing Check points and Configurations.
• Expert in implementation of Event Handling, Maintaining the Log and Audit information in the SQL tables.
• Extensively involved in T-SQL Stored Procedures, Functions, Views, Indexes, Triggers, Sub-queries implement Best practices.
• Having good experience in developing various reports like Drill Downs, Drill Through, Sub-Reports, Parameterized reports, and Linked reports using SSRS.
• Scheduling the Reports weekly and monthly basis as per the Client Requirements.
• Responsible for Deployment and Schedule of the SSIS Packages and SSRS Reports in to Production Server with the help of DBA team.
• Develop and publish of POWER BI reports and DAX query’s on different visualizations.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Converted existing BO reports to tableau dashboards
• Created different KPI using calculated key figures and parameters
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

• Migrated on-premises workloads to Azure cloud based on the requirements.
• Design and deploy Azure Backup and other Confidential backup solutions for Azure
• Strong design and live migration experience from on-premises to Azure IaaS & PaaS
• Creating and Managing Virtual Machines in Windows Azure and setting up communication with help of Endpoints and VM Migrations from on-premises Design and Implement Database Schema, import data and build stored procedures on SQL Azure.
• Build Data Sync job on Windows Azure to synchronize data from SQL 2012 databases to SQL Azure.
• Design and Implement WCF services layer hosted on Windows Azure. This layer is the middle tier between SQL Azure and SharePoint online external content.
• Manage and Administer SQL Server 2005, 2008, R2, 2012 ,2014 & 2016 versions of database.
• Developed intricate algorithms based on deep-dive statistical analysis and predictive data modeling that were used to deepen relationships, strengthen longevity and personalize interactions with customers.
• Analyzed and processed complex data sets using advanced querying, visualization and analytics tools.
• Identified, measured and recommended improvement strategies for KPIs across all business areas.
• Installed SQL server 2005, 2008 ,2012 and 2014 on Development, Test, QA and Production environment
• Worked on new features in SQL Server 2012 like Column stored indexes, User-Defined Server roles and Contained Databases.
• Worked on over 200+ database migrations from 2005/2008 to later versions of SQL on both Physical & Virtual environments
• Data migrations using BI tools like SSIS
• Building reports using SSRS
• Monitor and troubleshoot critical issues with Replication.
• Running SQL Server jobs and Maintenance plans in Windows batch files as Scheduled Tasks.
• Troubleshooting queries and stored procedures which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Work with tools like SQL Server Dashboard, SQL Profiler and Activity Monitor for event monitoring and performance monitoring and make recommendations based on results.
• Using and implementing DMV’s, DMF’s for identifying index fragmentation.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Recovering databases from backup in disasters, implementing point in time recovery solutions.

·

• Installed, Configured, and Maintained SQL Server 2012, and 2008 R2 in development, test, and production environment
• Configured and Maintained Fail-Over Clustering using SQL Server 2012
• Experience in AlwaysOn environment
• Maintained server and database security including database encryption (TDE)
• Installed and Configured SQL Server Reporting Services (SSRS)
• Developed and deployed different types of Reports using different data sources like SQL Server, Oracle, Excel, CSV files
• Delivered reports to users in variety of formats like Report Server (Web based), excel, pdf, html, excel and CSV formats
• Configured and Maintained Replications, Log Shipping, and Mirroring for High Availability.
• Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2000/2005 to 2008 R2 and 2008 R2 to 2012
• Migrated MS Access Databases into MS SQL Server 2008 R2, and 2012
• Migrated Oracle 10gR2/11gR2 and MySQL 5.1.23 databases to SQL Server 2008 R2/2012
• Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues
• Performed database and SQL/TSQL Performance Tuning
• Wrote SQL/T-SQL queries, Stored-Procedures, functions, and Triggers
• Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Developed Different Maintenance Plans for database monitoring
• Setup Jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alert, notifications
• Create and managed different types of Indexes (Cluster/Non-Cluster), Constraints (Unique/Check)
• Worked on Data Modeling projects, Backward Engineering, Developed E-R Diagram and used multiple tools like ERWin, Toad Data Modeler, and SQL Server Data Diagram
• Developed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
• Deployed SSIS packages to move data across server, move logins, load data from different data sources
• Setup jobs from SSIS Packages
• Used Imp/Exp. Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
• Manual, on Demand and setup jobs for Database Backup, and design backup strategy
• Deployed and Restored database including Point in Time Recovery
• Monitor Server Activity, Error Log, space usage and solving problem as needed

• Migrated and Upgraded from SQL Server 2005 to 2008/2008 R2
• Configured database software, associated database tools and performance monitoring software.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Customized support for Client’s Applications and provided client will won the responsibility of creating and maintaining database objects and structures such as tables, indexes, views, triggers, Functions, Procedures.
• Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
• Implemented & managed database clustering, failover and load balance technologies as per client requirement.
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions.
• Suggested Application level tuning changes for code, queries, SQL objects that may not be performing up to optimum database performance standards.
• Adhered to Change Control Procedures and developed & executed scripted changes requests in accordance with change control procedures.
• Set up security and access profiles and procedures for database system administrators.
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node.
• Handled Logical Data and Index partitioning for large tables in SQL Server 2005, 2008 & 2008 R2.
• Created, administered & maintained SQL Server Databases to Production, Development, Test and Staging Environment for various groups such as Developer, QA, BA, and User.