Requirement Gathering: Analysis of functional and core technical requirements for evaluating design, software specification and project estimations.Design Documentation: Assisting and preparing high level design documents for implementation of software solutions.Core expertise in developing ETL code in Informatica (Power center & BDE) & SSIS, well versed with all ETL and data warehousing concepts and principlesConcrete familiarity with building and deploying a SQL Server 2008 R2 Analysis Services (SSAS)cube end to end for analyzing high volume dataExperience in Reporting Services, Power BI (dashboard reports), SSRS using MS SQL server and in supporting services MDX technology of the analysis servicesInvolved in migrating intricate ETL application and Database objects through various environments such as Development, Testing, UAT and Production environmentsHave been part of complete end to end testing of the solution which includes Unit testing, System integration testing ,Performance and User accepting testingDomain knowledge : Good functional knowledge about Banking & Insurance

Analyzing & Understanding the various verticals of sales Dashboard, and contemplating sales data trends and inclinations.Expertise on Oracle Business Intelligence Enterprise Edition (11g) and SQL Server Analysis Service.Concrete familiarity with building and deploying a SQL Server 2008 R2 Analysis Services cube for analyzing sales data and enabling fast ad-hoc queries of pre-aggregated data in a Microsoft BI solution.Appreciable experience in Repository Configuration/using Transformations, creating Informatica Mappings, Sessions, Workflows. Designed and documented validation rules, error handling and test strategy of ETL process.• Developed expertise over Informatica and MSBI Stack including Cube Development & Reporting.• Proficient in Data extraction, transformation and loading along with Databases and DW/BI concepts.• Developing reports on SSRS on SQL Server (2000/2005/2008). Good experience in creating pivot tables and charts in Excel using data sources (SQL Server, SSAS cubes,SharePoint Lists, Access,embedded VBA code) and power pivot.• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional , Table, Matrix, Chart,Maps and Sub Reports.• Substantial understanding of Analysis services in SQL Server related to business intelligence and data warehousing.• Appreciable knowledge of SharePoint – Assisted in maintaining and updating Sharepoint platform internally and externally.• Created Complex Supply/Sales Report Subscriptions with Daily/ Weekly/ Monthly automated E-mail delivery of specific reports to target audience. • Preparation of list of Deployment Artifacts in the form of TFS Team Query before Release.• Considerable knowledge of TFS: Strong experience in application management and troubleshooting skills. Expertise in Team Foundation Server (TFS) 2012/2010 for history and versioning control, Permissions and Security management etc.