LOKESH DUVVURU

Handled database and data warehouse development

• Proficient in working with widely used DBMS platforms like Azure SQL, PostgreSQL, or CosmosDB, including Advanced knowledge of SQL Server Engine architecture and SQL Server Integration Services

• Had an extensive Cloud experience and experience with Azure Logic Apps and Azure Functions

• Proven Strong SQL skills for writing and optimizingin queries to ensure efficient data retrieval and manipulation. Expertise in:

o Tables and Views

o Indexing (including column store indexes), query execution plans, performance tuning and troubleshooting

o Relation data modeling (ERD)

o PL-SQL and T-SQL development

o Stored procedures

o Triggers

o performance tuning

o Query execution plan analysis

o Statistics IO

• Designed and implemented OLTP database schemas, considering data normalization, de-normalization, and best practices for relational and NoSQL databases.

• Skilled in logical and physical database design and Relation data modeling (ERD)

• Proficient in scripting languages to automate routine tasks, such as backups, data migrations, and monitoring

• Skilled in monitoring database performance and able to diagnose and resolve performance bottlenecks

• Familier with version control systems (e.g., Git) to track changes to database schemas, scripts, and configurations

• provided production support and responded quickly

• Resolved production incidents with SME level of knowledge

• Comfortable to use Jira, Confluence, Zeplin and InVision tools in day-to-day activities

• Able to work in Agile methodology

• Strong analytical data-driven thinking skills

• Analyzed existing SQL queries to identify opportunities for improvements
• Designed and implemented TSQL queries for reporting and complex solution development
• Developed, implemented and optimized stored procedures and functions using T-SQL
• Documented analysis results and provided performance improvement feedback
• Proficient in working with popular DBMS platforms like PostgreSQL, or CosmosDB
• Advanced knowledge of SQL Server Engine architecture and SQL Server Integration Services
• Cloud experience preferred, particularly with Azure Logic Apps and Azure Functions
• Strong SQL skills optimizing queries for efficient data retrieval and manipulation
• Tables, Views, Stored Procedures, Triggers, and Query execution plan analysis
• Expertise in Indexing (including column store indexes) and performance tuning
• Proficiency in designing and implementing OLTP database schemas, considering normalization and de-normalization
• Skills in logical and physical database design, ERD, and NoSQL databases' best practices
• Ability to script languages to automate tasks like backups, data migrations, and monitoring
• Skilled in monitoring and diagnosing database performance bottlenecks
• Experience with version control systems like confluence and Git for tracking changes in schemas, scripts, and configurations
• Experience in developing complex SQL queries, Understanding in Database Administration, Database monitoring and tuning procedures
• Partnering with teams such as developers, vendors, analysts and project Managers.

• Proficient in designing, creating, and maintaining SQL/SAS databases
• Skilled in developing database schemas, tables, views, and stored procedures
• Strong expertise in writing complex SQL/SAS queries to extract and manipulate data effectively
• Experience in data selection, updating, deletion, and insertion operations
• Demonstrated ability to analyze extensive datasets using SQL/SAS for insightful reports
• Experience in generating routine and ad-hoc reports using tools like SAS Visual Analytics
• Experience with data visualization tools such as Power BI, or SAS Analytics for creating insightful reports and dashboards
• Optimizing database performance by resolving bottlenecks and fine-tuning SQL queries
• Proficiency in implementing indexing strategies for improved efficiency
• Skilled in designing and implementing ETL processes for data movement and transformation
• Experience in data cleansing, validation, and transformation
• Collaborative team player with the ability to work alongside data analysts, scientists, and stakeholders
• Commitment to staying updated with the latest SQL/SAS technologies and best practices
• Strong troubleshooting and debugging skills to identify and resolve database-related issues
• Experience in project planning, task estimation, and meeting deadlines
• Adherence to coding standards and best practices throughout project execution.