Description
Professional Summary MSBI Developer with Business Systems Analysis experience and progressive levels of responsibility with different skill set involved and large project. Experienced in projects from requirements through stabilization, following Software Development Lifecycle (SDLC). Huge experience using SharePoint for project related interaction, Microsoft outlook, Active Batch for Automation. Versed with scrum meetings and arrangements to get periodic updates on different projects and their difficulties to seek solutions to move forward. Highly motivated, self-starter that is also passionate about technology. Assesses and addresses a client's business needs and use right tools and frameworks to build effective solutions. Proven ability to act as liaison between business partners/client and IT team. Experienced in communicating with both Technical and non-Technical audiences and to all level of management. Talents related to problem solving, and analysis of efficient and cost-effective efforts. Microsoft Business Intelligence Developer with experience in developing Business Intelligence applications, Data Warehouse applications at various phases of SDLC. Extensive experience in developing Business Intelligence applications with SSIS and SSRS, Tableau and wide knowledge of EXCEL to cleanse data from various sources, using proper naming convention and saving files in created Shared Location before using SSIS to load into the database. Good communication and interpersonal skills. SQL Server . * Good in creating, optimizing and troubleshooting store procedures, Views, Triggers, tables, set jobs. * Experience in creating constraints, relationships, tables, updates, inserts and deleting duplicates. * Extensive experience in using T-SQL creating tables, queries, stored procedures and optimizing, views and constraints for data Integrity in SQL Server 2012 / 2008 platforms. SSIS * Extensive experience in building, maintain/optimizing and running SSIS Packages to load data into databases. * Used various SSIS Transformations and tasks such as Conditional split, Data Conversion, Derived column on the data retrieved, performed data validation checks during staging and then loaded the data. Used Conditional Split, Sequence container, Execute SQL Task, Control Flow and Data Flow Tasks, Multicast, Send Email Task, Union and Union All, Script Task, * Developed, tested and deployed SSIS packages in different environments for various projects. * Designed and developed SSIS Packages to load data from variety of sources like XML, Excel, .CSV and OLEDB. * Worked on data flow transformations like XML source, multicast, merge Join, lookup, and data Conversion. * Wide EXCEL knowledge. I use Excel to cleanse flat files and save files in shared location where package will read these files and load into specified locations SSRS/Tableau * Proficient in building SSRS reports that have Drilldown and Drill Through capabilities, parameterized reports using tables, charts, matrix and sub reports * Good experience in conditional formatting using colors, spark lines, gauges etc. * Proven ability and extensive experience in creating actionable dashboards and reports. * Extensive experience updating datasets based on requirements. * Implementation of security in SSRS report at item level and group level with SSRS roles. * End-to-end development experience from requirements gathering to deployment of SSRS reports * Versed in deploying Reports to specific locations like the SharePoint location, TFS, emails, where users can easily access for decision making.
Accomplishments
Highlights:
Keywords
