We provide IT Staff Augmentation Services!

Msbi Architect Resume

0/5 (Submit Your Rating)

SUMMARY

  • Dynamic & proactiveInformation Technology Professionalwith 11years of experiencein the field of data warehousing, data modeling and data analytics using Microsoft Technologies.
  • Deep passion for driving technology vision/strategy and delivering tangible, high value business solutions.
  • Deep technical experience with architecture, design and hands - on programming on diverse technology platforms including RDBMS, OLAP engines including Cube design & development, ETL and SSRS.
  • More than 9 years of hands on experience in SSIS, SSRS and SSAS.
  • Working on Power BI and SharePoint BI for implementing SSBI.
  • Involved in Data Reconciliation to improve data quality for Confidential Project.
  • Attended Hadoop training and have basic idea of Hadoop framework and implementation.
  • Worked as a Business Analyst at client side (UK) to gather the requirement for Business Intelligence project D2C (Direct to Consumer).
  • Extensive experience in using T-SQL (DML, DDL) in SQL Server 2012, 2008/20005/2000 platforms.
  • Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.
  • Ability to define and develop Report Structure with data definition, report layout and report definition language.
  • Extensive experience in creating several reports such as drill down reports, parameterized reports, sub reports, Matrix Reports and Chart reports using SQL Server Reporting Services.
  • Proven abilities in planning, implementing and executing development functions using BI as a tool.
  • Expertise in providing direct support & development of the software applications, involving all phases of the software development life cycle (SDLC) for development functions related to large complex applications & software programs.
  • Experience consists of understanding the requirements and changes in applications and implementing them as per the business needs.
  • Performed periodic reviews within the team & with the Customer and acting as the single point of contact for the day-to-day functioning of Software Development.
  • Quick adaptability to changing technologies to meet new requirements successfully with a systematic and organized approach for increased efficiency and competence.

TECHNICAL SKILLS

Business Intelligence Tool: SSIS 2005, 2008 R2 2012, SSAS 2008 R2, SQL 2012 Tabular Model, SSAS 2012, Power BI, PowerView, Power PivotReporting Tools SQL Server Reporting Services (SSRS), Power Pivot, Power View, XLcubed, Aspose (Reporting Tool), SQL OLE Automation

RDBMS: SQL Server (2005 & 2008)

.NET Technologies: ASP.Net, C#, Web Services, Enterprise Library 3.5, Windows Communication Foundation (WCF)

Languages: T-SQL, VB.Net, C#, XML, HTML

IDE & BI Tools: Visual Studio (2003, 2005 & 2008 Team Suite, 2012), SQL Server BI Development Studio

Version Mgmt. Tools: Visual Source Safe (6.0 & 2005), TFS

PROFESSIONAL EXPERIENCE

Confidential

MSBI Architect

Responsibilities:

  • Interacts with Business Users and provides Solution Clarity on an as need basis
  • Builds the High Level Design for each work stream area - Migration / Conversion, Integration etc.
  • Designed Error recovery and error handling framework for Global Data Warehouse
  • Provide Technical guidance and resolve team member’s issues on daily basis
  • Participates in Code Review
  • Participates in Testing (QA, UAT and Mock Runs) and approves deliverables
  • Coordinates with off-shore Team
  • Requirement Analysis and review requirement documents.
  • Maintained the database schema in source code control (MS Team Foundation Server).

Confidential

MSBI Architect

Responsibilities:

  • Interacts with Business Users and provides Solution Clarity on an as need basis
  • Builds the High Level Design for each work stream area - Migration / Conversion, Integration etc.
  • Designed reporting framework to fulfill reporting requirment
  • Provide Technical guidance and resolve team member’s issues
  • Participates and approves the LLD
  • Participates in Code Review
  • Participates in Testing (QA, UAT and Mock Runs) and approves deliverables
  • Coordinates with off-shore Team
  • Requirement Analysis and review requirement documents.
  • Designed, Implemented Database Schema, Data modeling, Tabular Model and Multi Dimension Model
  • Maintained the database schema in source code control (MS Team Foundation Server).

Confidential

MSBI Architect

Responsibilities:

  • Designed MR (Management Reporting) deck for Confidential Finance Team using Power BI & MSBI
  • Requirement Analysis and preparation of requirement documents.
  • Designed, Implemented Database Schema, Data modeling, Tabular Model and Multi Dimension Model
  • Maintained the database schema in source code control (MS Team Foundation Server).
  • Implement Row level security in Tabular Model for SharePoint BI.
  • Involved in building different environment (Dev, UAT, Production)
  • Involved in configuring\installing SharePoint 2013, PowerPivot Gallery, Power BI site and SQL Server 2012.
  • Resolve team member’s issues
  • Production deployment

Confidential

Solution Architect

Responsibilities:

  • The tasks during Analysis and design phase would include finalizing the move groups along with Infra team as well as continuous knowledge transfer to the Operations teams.
  • Help infra team with any BI specific issues that may arise during migration.
  • Help the infra team with any additional validation exercise required for the BI technologies.
  • Play the role of a technology SME for BI application migration and make sure the migrations happen smoothly.
  • Investigate issues or bugs and get them fixed during UT (excluding any changes under a CR).

Confidential

Technical Architect\Lead

Responsibilities:

  • Requirement Analysis and preparation of various design documents.
  • Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views.
  • Maintained the database schema in source code control (MS Team Foundation Server).
  • Developed the T-SQL procedures, Functions, Views and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS
  • Development, Integration and Testing.
  • Build cubes using SSAS.
  • Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
  • Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
  • Developed Query for generating drill down reports in SSRS 2008. Prepared AD HOC reports through report builders.
  • Production deployment

Confidential

Responsibilities:

  • Analysis of the existing legacy reports, which need to be replaced with the new technologies & framework.
  • Requirement Analysis and preparation of various design documents.
  • Development, Integration and Testing.
  • Build SSIS and cubes using SSAS 2008
  • Database\data mart Designing
  • Production deployment

Confidential

Responsibilities:

  • Project Design, Design reviews with Project Stakeholders
  • Involved in requirement gathering with client at London (UK)
  • Development, Integration and Testing
  • Requirement Analysis and preparation of various design documents
  • Database Designing
  • Production deployment.
  • Co-ordination with team members at onsite for any change requests for the application
  • Trouble shooting, Technical implementation, mentoring team members
  • Developed and delivered dynamic reporting solutions (excel and pdf reports) Server 2005

Confidential

Responsibilities:

  • Collection of applications’ data including hardware details, resource and support costs.
  • Creation of Analysis report based on collected data which included Functional, Technical, Management, Business and Resource analysis.
  • Creation of recommendation report which included the solutions of key pain areas in the
  • Applications, resource, license and infrastructure optimization.

We'd love your feedback!