Sr. Technical Lead (Msbi)
Current- Experienced working directly with clients, on-site team and business analysts to gather logics and requirements for the projects.- Experienced end to end MS BI implementation using SSIS, SSRS and SSAS from requirement gathering, DW design, ETL dev, Report dev, Cube dev, Deployments and client demo.- Provided analytics on different sources to create and design Data warehouses.- Proficient in designing/creating SSIS packages and experienced in most of the tasks available.- Optimizing SSIS for fast package execution.- Conceptualizes/visualizes dashboards and reports based on project requirements.- Proficient in SSRS, creating and designing professional graphical dashboards with trends, KPI, actions, drilldown, drill through, parameterized, filters and charts.- Optimizing SSRS reports to achieve fast acceptable response time.- Knowledgeable in creating SSAS for cube analytics.- Knowledgeable in Database Administration.- Handled and lead 12 resources to deliver multiple projects.- Most of the projects have been worked on as a DW designer, SSIS dev, and SSRS dev.- Provide mentoring and assistance for team members in their technical concerns regarding SQL, SSIS, SSRS, and SSAS.