Lalitha Velagala Email & Phone Number

Old Bridge Township, NJ, US

New York, United States

• Involved in Assessing requirements for completeness and accuracy.
• Understanding Oracle DB schemas and SQL Server DB schemas to write and tune complex SQL queries
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
• Worked on Full life cycle development (SDLC) involving all stages of Analysis, Design, Coding and Testing.
• Created tables, indexes, synonyms, triggers, functions, procedures, cursors and packages using T-SQL.
• Used SSIS, created packages to import data and clean the Data and Store them in Datawarehouse for reporting purposes.

Weehawken, NJ

• Involved in gathering requirements from end users.
• Worked on Full life cycle development (SDLC) involving all stages of Analysis, Design, Coding and Testing.
• Created tables, indexes, synonyms, triggers, functions, procedures, cursors and packages using T-SQL.
• Used SSIS, created packages to import data and clean the Data and Store them in Datawarehouse for reporting purposes.
• Developed SSIS packages to load large set of data from flat files to SQL tables with various data validations to load the data correctly.
• Applied complex MS Excel functions, conditional statements and v-lookup to convert raw data in useful business information.

Cotiviti USA LLC

• Created & modified SSIS packages for ETL processes to reading data from flat files, database tables, XML & other sources.
• Configured and deployed SSIS Packages across development to test and production environments.
• Automated process using SSIS jobs and SQL Agent Jobs.
• Data manipulation through conversion, calculation, aggregation, etc.
• Wrote data to flat files, database tables, XML & other destinations.
• Scripted using T-SQL for DML operations used temp tables.

Boston, MA

• Experience in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
• Configured data partitioning/table partitioning on large tables containing millions of rows in Data warehouse databases for better performance and performed Data Compression on large tables to reduce the Database size.
• Configured and deployed SSIS Packages from Development to Production Environments.
• Automated manual processes by creating SQL scripts, tables, indexes, views, and constraints.
• Monitoring of database size, disk space in all (Production, Model & Development) the environments.
• Set priorities on tasks that are available on my plate and perform as per their priority.

Bangalore, India

• Involved in analysis, design and development of large databases to solve complex business problems.
• Design of the Database and the Tables and built table relationships.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Wrote complex SQL statements using joins, sub queries and correlated sub queries.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL Joins for applications.
• Developed SQL procedures, functions, packages and triggers for building customized code.