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