We provide IT Staff Augmentation Services!

Msbi Lead Developer Resume

SUMMARY

  • Having 15+ years of total IT experience involving in Analysis, Design, Development and Implementation using Microsoft Technologies
  • 10+ years of comprehensive experience encompassing Microsoft SQL Server 2008/2012/2014/2016 , MS BI suite of products (SSIS, SSRS, SSAS) as SQL Developer and Business Intelligence Developer using OLTP/OLAP/BI environments along with experience on data visualization using Tableau.
  • Significant leadership experience: As a lead technical consultant, gained valuable experience in Full Software Development LifeCycle (SDLC) in implementation and supporting projects for many multinational technology, telecommunications, and pharmaceutical/healthcare and insurance brokerage industries.
  • 6+ Years full lifecycle experience in scoping, designing, developing, deploying, and supporting enterprise - scale business applications and significant experience working on Microsoft Business Intelligence Tools (SSIS, SSRS, and SSAS)
  • Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and slowly changing dimension.
  • Formulated and documented ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations and expressions.
  • Proficient in creating and configuring ETL workflows designed in SQL Server Integration Services (SSIS) and Informatica
  • Experienced in creating Parameterized, Cascaded, Drill-through, and Drill-Down reports using SQL Server Reporting Services (SSRS)
  • Dashboard development experience with the help of Tableau and Power BI
  • Extensively working in designing, creating, processing of cubes using SQL Server Analysis Services (SSAS)
  • Extensively working on Data Profiling, Data Mining and Analytics
  • Strong knowledge of Data warehousing methodologies and concepts, including Star schemas, Snowflake schemas, ETL processes, Dimensional modeling, Tabular modeling and Reporting tools
  • Extensively working on SQL Server 2012 and SQL Server 2008 R2 databases. Executed MSBI projects in Agile/Scrum Methodology and Waterfall Model
  • Worked extensively on MS.Net projects using C#.NET, VB.NET, and ASP.NET. Worked on Windows 7, Windows XP platforms for t he development of all applications
  • Strong analytical knowledge coupled with excellent communication and interpersonal skills. Proficient in developing clear and concise documentation of all work performed.

TECHNICAL SKILLS

  • SSIS, SSRS, SSAS, Informatica, Tableau, Power BI
  • SQL Server 2012/2008/2005/2000 , Oracle, MS Access
  • T-SQL, MDX, C#, VB.Net, ASP.Net, SharePoint, HTML, XML, C++, C
  • VS 2010/2008/2005/2003 , TFS, VSS, Clear Case, Lotus Notes
  • MS Windows/98/NT/2000/2003/XP, Windows 10
  • Insurance, Telecom, Finance, Healthcare, Retail

PROFESSIONAL EXPERIENCE

Confidential

MSBI Lead Developer

Responsibilities:

  • Anchored the requirement discussion workshops with business and suggested metrics and reporting framework which are critical to business needs.
  • Analysis of the specifications provided by the Legacy System.
  • Created various mappings for populating the data into star schema.
  • Developed stored procedures, functions, views, triggers, constraints
  • Implemented best practices, query optimization and performance tuning.
  • Building of ETL packages using different transformations and tasks in SSIS.
  • Providing unit test case documents for BI solutions for unit testing.
  • Support in deploying and scheduling the BI solutions.
  • Major and Minor Enhancements, Bug Fixes and production support.
  • Attending the client calls on daily basis
  • Code Reviews of team

Environment: SSIS, Power BI, Tableau, Azure SQL Server 2016, C#.Net, VS.Net, Excel, Flat Files, CSV, Windows 10, AWS API, SFTPs

Confidential

MSBI Team Lead

Responsibilities:

  • Anchored the requirement discussion workshops with business and suggested metrics and reporting framework which are critical to business needs.
  • Analysis of the specifications provided by the Legacy System.
  • Created various mappings for populating the data into star schema.
  • Developed stored procedures, functions, views, triggers, constraints
  • Implemented best practices, query optimization and performance tuning.
  • Building of ETL packages using different transformations and tasks in SSIS.
  • Providing unit test case documents for BI solutions for unit testing.
  • Support in deploying and scheduling the BI solutions.
  • Major and Minor Enhancements, Bug Fixes and production support.
  • Attending the client calls on daily basis
  • Code Reviews of team

Environment: SSIS, SSRS, Qlikview, SQL Server 2017, C#.Net, TFS, VS.Net, Excel, Flat Files, Windows 10

Confidential

MSBI Team Lead

Responsibilities:

  • Anchored the requirement discussion workshops with business and suggested metrics and reporting framework which are critical to business needs.
  • Analysis of the specifications provided by the Legacy System.
  • Performed automated data profiling for source systems.
  • Created various mappings for populating the data into star schema.
  • Developed stored procedures, functions, views, triggers, constraints
  • Implemented best practices, query optimization and performance tuning.
  • Building of ETL packages using different transformations and tasks in SSIS, Informatica.
  • Created reports using data visualization tools like SSRS and publish them in SharePoint
  • Developed dashboards using Tableau and Power BI
  • Providing unit test case documents for BI solutions for unit testing
  • Support in deploying and Scheduling the BI solutions
  • Major and Minor Enhancements, Bug Fixes and production support.
  • Coordinating with Onsite/Offshore team and get it approved by the client.
  • Conducting the daily meeting with offshore/onsite team for task sharing.
  • Attending the client calls on daily basis
  • Daily interactions with Team in assisting and clarifying their queries
  • Code Reviews of team

Environment: SSIS, SSRS, SSAS, SQL Server 2012, Parallel Data Warehouse (APS), Power BI, Tandem, Attunity, SharePoint, C#.Net, TFS, VS.Net, Excel, Flat Files, Windows 7

Confidential

MSBI Team Lead

Responsibilities:

  • Understanding and Analyzing the Functional Specification
  • Creating Technical design document based on the functional specification
  • Building of ETL packages using different transformations and tasks in SSIS
  • Creating reports in SSRS using SQL Server and SSAS cubes as source
  • Providing unit test case documents for BI solutions for unit testing
  • Support in deploying and Scheduling the BI solutions
  • Leading and managing the team
  • Task scheduling and status update on daily basis
  • Attending the client calls on daily basis
  • Daily interactions with Team in assisting and clarifying their queries
  • Code Reviews of team

Environment: SSIS, SSRS, SSAS, Informatica 8.6, SQL Server 2008, C#.Net, SVN, VS.Net, Excel, Flat Files, Windows XP Professional

Confidential

MSBI Team Lead

Responsibilities:

  • Understanding and Analyzing the Functional Specification
  • Creating Technical design document based on the functional specification
  • Building of ETL packages using different transformations and tasks in SSIS
  • Development of tabular modeling with SSAS and data visualization with Power Pivot using DAX
  • Development of cubes using SSAS and MDX query language
  • Creating reports in SSRS and publish them in SharePoint
  • Providing unit test case documents for BI solutions for unit testing
  • Support in deploying and Scheduling the BI solutions
  • Leading and managing the team
  • Task scheduling and status update on daily basis
  • Attending the client calls on daily basis
  • Daily interactions with Team in assisting and clarifying their queries
  • Code Reviews of team

Environment: SSIS, SSRS, SSAS, SQL Server 2012, C#.Net, TFS, VS.Net, Excel, Power Pivot, Windows 7

Hire Now