Lalitha Velagala Email & Phone Number

United States

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.• Managing historical data from various heterogeneous data sources.• Write complex functions and conditional statements to interpret raw data in useful business information. Creating Pivot Tables, using lookups.• 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.• Experience in Error handling and debugging coding issues and troubleshoot production problems.• Created views to facilitate easy interface implementation and enforce security on critical customer information.• Created stored procedures and triggers to facilitate consistent data entry into the database.• Created Database Triggers for audit and validationCreated and manipulated stored procedures functions, packages and triggers.• Wrote complex stored procedures using dynamic Sql to populate data into temp tables from fact and dimensional tables for reporting purpose.• Extensively used materialized views, dynamic sql, cursors, bulk collections.• Developed backend interfaces using PL/SQL stored packages, procedures, functions, collections and triggers.• Created integrity constraints and Database Triggers for the data validations.

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.• Worked extensively to Extract Transform and Load (ETL) using Azure Data Factory,SSIS.• Experience in Error handling and debugging coding issues and troubleshoot production problems.• Created views to facilitate easy interface implementation and enforce security on critical customer 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.• Created & modified tables and table indexes.• Required to communicate effectively to clarify/define requirements to developers and business.• Used Atlassian product JIRA to receive requests and view issues with reports, packages or business rules.• Worked with a team of application developers and business analysts to document processes and procedures.• Required to work through the life cycle of a request from beginning to end without direct Supervision.

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.• Involved in testing, bug fixing and documentation for the project .• Trouble shoot any application, network and security related problems, investigate and report my finding with possible solution and/or recommendation.• Discuss issues with program managers, developers and test leads so that we can come up with the solutions.

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.• Optimized query performance by creating indexes. • Enhancing and deploying the SSIS packages from development server to production server and scheduled jobs for executing the stored SSIS packages which were developed to update the database on Daily/Weekly/Monthly basis. • Worked with various SSIS packages which involve Transactions, restart ability and roll back techniques. • Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.