N Nagendra Email & Phone Number

· Understanding the business process/requirement and translate them into technical requirements and collaboratively working with team· Prepared Functional Specifications Documents for each & every module with the reference of Business Requirement Document.· Created SQL server objects like Stored Procedures, views, functions according to business requirement· Created packages to load the data from heterogeneous sources like Excel, Text files, CSVs into target database by applying different kinds of transformations to cleanse the data· Worked on generating the Extracts by using SSIS packages.· Extensively worked with containers like For Each Loop, For Loop and Sequence since to load all the files data on a File System· Creating and modifying SQL server Agent scheduled jobs· Performed the code review for all type of objects.· Performed data changes suitable for better modelling and visualizations.· Generated different Power BI reports and dashboards for data showing business of different line of business across different geographical locations for client.· Used analytics protocols and time intelligence functions [last year, two years back, current year etc… Created calculated columns and measures using DAX based on business need.· Created different filters like visual level filters and page level filters and report level filters as per reporting needs.· Involved in sprint planning and set the priority for the sprint items based on the client requirement.

· Primary responsibility of analyzing the requirements and understanding the functionality, interactively and collaboratively working with Application team.· Prepared Functional Specifications Documents for each & every module with the reference of Business Requirement Document.· Designed the Database as per the Functional Specifications.· Created Stored Procedures, Functions, CTE, Temp Tables, Derived Tables, Views, Indexes, Joins, and Cursors & Triggers for Audit & Log Purpose.· Created On Dynamic Queries mainly implemented them in Stored Procedures. Worked on Performance Tuning & Profilers in SQL.

· Guiding care is a product which is used to provide guiding to the patients, providers and payers information maintenance. It is used to maintain the patient information available to the providers as well as payers. And it will provide security to the patient’s information. It is used to take decisions and approvals based on the treatment.· Primary responsibility of analyzing the requirements and understanding the functionality.· Actively participated in SCRUM Calls along with BA to understand the client requirements.· Interactively and collaboratively working with Application team.· Creating and managing schema objects such as tables, views. Also writing stored procedures, functions· Writing Complex SQL Queries, Creation of Tables, Stored Procedures, User Defined Functions (UDF), Views, Triggers.· Creating clustered, non-clustered indexes to improve the performance as needed.· Developing SSIS Packages and SSRS Reports as per the requirement.· Involved in unit testing, integration testing.· Deploying the code and give commit in Bit bucket.

The main objective of the project was to design and build a Data Warehouse for Mattress Firm. Data was extracted from SQL Server and loaded in a separate data base using SSIS, which fast & efficient reports were generated using SSRS. This report gives an insight into the various business trends. This architecture follows dimensional warehouse methodology on Kimball model.· Primary responsibility of analyzing the requirements and understanding the functionality of both sources and target systems· Designing SSIS Packages and loading data into data warehouse (ETL)· Creating staging database for temporary processing of data, consolidating data and loading into target database using integration services (SSIS)· Responsible to load the data from external and internal sources like flat files, excel sheets and different data bases into a SQL server using integration services tool· To control the packages and execute daily for loading the data from source to staging· To look after event handlers to handling error and debugging for the packages· To identify performance bottlenecks and performance tuning of packages· Capturing error data in flat file using flat file destination, sending the error data in the flat file attached to the corresponding mail ids using send mail task and correcting error data· Creating jobs for scheduling the SSIS Packages· Designing reports using SSRS, with Drill Down and drill through menu option· Involve in writing expressions using SSRS for dynamic behavior of the reports, and develop the parameterized reports including multi parameter according to the client specifications

· Asurion is an Insurance based company in US. The objective of this project is to build a robust and intelligent system that will help business people to strategize based on analysis. Designing and implementing the ETL processes which involves collection of data from heterogeneous sources.· Responsible for getting and understanding the business specs· Designed SSIS Packages and loading data into data warehouse (ETL)· To be Designed and developed SSIS Packages using different transformations like Conditional Split, Derived Column, Lookup and OLEDB command· Designed ETL Packages using by Control Flow Items like Containers, Execute SQL Task, Send mail Task, File System Task· Identified the bottlenecks (in sources, targets, and packages) and tuning it· Implemented logging for the SSIS Package for auditable purpose· Designed reports using SSRS, with Drill Down, Drill Through and Dropdown menu option· Involved in writing expressions using SSRS for dynamic behavior of the reports, and develop the parameterized reports including multi parameter according to the client specifications

· Analyzed the requirements and understanding the functionality of both sources and target systems· Designed SSIS Packages and loading data into data warehouse (ETL)· Designed SSIS packages to transfer the data between servers and loaded the data into database· Wrote SQL queries or stored procedures to extract the data from the source database and implemented those queries on the SSIS package· Implemented dynamic configurations for the SSIS Packages and scheduling the packages.