Worked on SQL Server Reporting Services (SSRS), Crystal Reports and developed reports depending on the needs and the scope of the application.Used XML configuration files mapping through environment variables to test and run the SSIS packages manually in the case of job failure.Created Master File, Access File, Business Views for the reporting, isolating from the database avoiding changes unless it is needed for the reports.Scheduled jobs to run the reports on a specified date time and distribution of information to users using Report Caster.

Created adhoc, drilldown, drillthrough, tabular, excel etc reports using SQL pass through keeping the complexity in SQL Server stored procedures improving the performance and even developed SSRS reports using these procs.Created reports, graphs under both MRE ( Managed Reporting Environment) as Dashboard reports and under SELFSERV providing report as url accessing from.Extensive Experience with IBI tools Webfocus 7.6.X/7.5.X used to develop and maintain reports using Developer Studio an d IWAY a n XM L basedtool to perform the ETL operations and running SSIS packages on demand setting th e IWAY Listener.Creating and monitoring the batch jobs using SQL Server Agent and third part tools like Global Event Control Scheduler (GECS) etc.Created packages using SQL Server Integration Services (SSIS) for data Extraction from/Load to Flat Files, Excel File MS Access, DB2, Oracle etc.Extensive experience developing and implementing Microsoft SQL Server integration services (SSIS), Reporting Services (SSRS), Anaysis Services (SSAS) and MDX for data warehousing and data mart solutions.Working experience with MS SQL Server (2008/2005/2000/7.0) and Visual Studio (2008/2005/2003) usedto generate reports, integration, developing custom utilities and applications using.Over 8 years of IT experience in all the aspects of Software Development Life Cycle (SDLC) whichincludesAnalysis , Design, Development, Testing of applications using Data Warehousingconcepts and Business Intelligence tools.

Powershell roles ssas visual total amo