Sriram Yerroju

Business Intelligence Developer @Cognizant

CA

Involved in gathering requirements from Business Users, Analysts by scheduling meeting on a regular basis.•Experience in creating complex SSIS packages using proper control and data flow elements with error handling.• Created/Updated Views, Stored Procedure, Triggers, User Defined Functions (UDF) using SQL.• Generated parameterized reports, sub reports, tabular reports using SSRS.• Generated Sub-Reports, Crosstab, Conditional, drill down reports, Drill through reports and parameterized reports using SSRS.• Experience in moving the data from heterogeneous data sources like oracle, XML etc. to SQL using SSIS.• Expertise in using different transformations like fuzzy lookup & derived column transformation etc. using SSIS.• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS. Responsible for identifying and defining Data Source and Data Source views.• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy in SSAS.• Extensively used SSIS Import/Export Wizard, for performing the ETL Operations.• Used Performance Point Server to create interactive reports with an ability to drill down into details.• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.• Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic.• Created SSIS packages to migrate data from SQL Server 2016 to SAP BW HANA.• Involved in Data migration (Import & Export using BCP) from text to SQL Server2010.• Involved in Creating Stored Procedures for Reports generation.• Performed Documentation for all kinds of reports, DTS and SSIS packages.• Designed and implemented stored procedures and triggers for automating tasks.