Avinash Reddy Email & Phone Number

Over 4 years of experience in BI development in SQL Server, SSIS, SSRS & Power BI Excellent working knowledge on Power BIGood exposure on Translating business requirements into high-level design specificationExpertise in Relational ModelingExperience in Package Deployment & Power BI work booksImplemented security in Power BIExperience in requirements definition, design, analysis, development of technical specifications, Business Intelligence reports, Estimation and Project Planning, implementations, integration, retrofitting of modifications, documentation, testing, post-production support in different environmentsExperienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverableEnsured periodical reporting with quality management systemWell developed interpersonal and communication skills, having dealt with diverse professionals, clients & team members at global locationsHighly self-motivated and able to set effective priorities to achieve immediate & long-term goals and meet project & operational deadlinesVibrant team player with belief in taking positive approach towards issue resolution

• 

  Business Intelligence Developer

  Zensar Technologies

  May 2014 - Dec 2019 - Hyderabad, Telangana

  Involved in designing of initial package, keeping in view implementing appropriate SSIS controls.Creating SSIS packages to generate daily reports (.xlsx and .pipe).Importing data from different source like SQL Server, Teradata and .csv files.Created Event Handlers for the Packages to send error email nortifications to the usersCreated Power BI reports & Deployed in Power BI ServiceConfiguration of Power BI dashboards for Desktop & MobileImplementation of data security in Power BIUsed Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute Task, Sendmail Task and Data Flow Task.Creating and Maintaining scheduled jobs and implementing automation for other tasks.Scheduling the stored procedures from sql server agent jobs.Used different debugging tools like data viewers and break points to debug the Data Flow tasks and Controls Flow tasks.Implemented Package Parameters, Logging information for dynamically pass the values to packagesScheduled the ETL Packages Using SQL Server Management Studio.Involved in unit testing and creation of test cases and ETL Specification Documents.