About Me

1Hi this is Vishal Pawar.

I am SQL Server & Microsoft Business Intelligence Technology Enthusiastic.

My Certification

  • “MCTS: Microsoft® Certified Technology Specialist (MCTS):SQL Server 2008,Business Intelligence Development and Maintenance”
  • “MCSA: Microsoft® Certified Solutions Associate (MCSA):SQL Server 2012 – Querying Microsoft SQL Server 2012”
  • “MCSA: Microsoft® Certified Solutions Associate (MCSA) : SQL Server 2012 – Administering Microsoft SQL Server 2012 Databases”
  • “MCSA: Microsoft® Certified Solutions Associate (MCSA) : SQL Server 2012 – Implementing a Data Warehouse with Microsoft SQL Server 2012”
  • “CSM: Certified Scrum Master (CSM) from Scrum  Alliance”

Work history

Tool Developments (Codeplex )

1-SQL PraRup – Free Tool for Auto Formatting/Indenting SQL Server Database Objects

2-SQL NirYat – Free Tool for Exporting Data from SQL Database to Excel

  • URL – https://sqltoexcelexportbysqlniryat.codeplex.com/
  • Auto transform all SQL Query Data into Excel at ones
  • Each SQL Query can be stored in each sheet of Excel with Multiple sheet support
  • Excel Output will be formatted with heading, Freeze Pane  and proper indentation

3-Dr.XL DBA Dashboard -One stop Solution for SQL Server Database Analysis in Excel

  • URL – https://drdba.codeplex.com/
  • Write your own query in Query Writing Execution Sheet
  • Get Stored Procedure information in Procedure analysis Sheet

4-SQL Svachalit – SQL Svachalit Free tool for Sticker -Header – Commenter

Microsoft Power BI Video

Microsoft Power Business Intelligence technology – Power BI Show case video , Stood 16th at world level competition in December 2013

Technical Environment

Current Technical Expertise

SQL Server 2008 R2, 2012,2014, SSIS, SSRS, SSAS, ASP.NET, T-SQL, MDX, SPs

Project Management Tools

Microsoft Project Management Platform, Kanban, Scrum with Excel, Wiki

Business Intelligence Technology

SSIS, SSRS, SSAS, MDS, DQS & SharePoint BI

Power (BI) Business Intelligence

Power Pivot, Power Query, Power Map, Power View, Power Q&A

Development Tools

BIDS, VSDE, Red Gate, SSMS 2008 R2, TFS, SSMS 2012, SSDT, SSMS 2014

Analytics Tools

Power View, Tabular Model, MS Excel 2013, Office 365

Database Language

T-SQL, DAX, MDX, SSRS Expression, SSIS Expression

Programming Language

C#, C, C++, JAVA, VB, Turbo Prolog, Core JAVA, SGMP

Latest Technology

BIG Data, Data Scientist, SQL Azure, Hadoop with SSIS

Web Designing

HTML, CSS, Flash, Dream-viewer

Database Server

SQL Server 2008 and 2008 R2, SQL server 2012, SQL Server 2014

Testing Tools

SQL test trikes, Jira

Operating System

Windows XP, Windows 7, Windows Server 2008

Miscellaneous

SharePoint 2010, SharePoint 2013, MOSS, Active Directory Concepts

ROLES AND RESPOSIBLITY

General Development

  • Delivered complex enterprise applications using Microsoft Technologies
  • Derived complex design from scratch for large enterprise scale applications
  • Bring technical expertise based on development experience, and make sound technical decisions to deliver high quality projects
  • Convert complex design into solid implementations that scale and perform
  • Architecting and Implementing Complete Automation by saving time in Design, Development, Coding, Testing, Analysis and Maintenance phase
  • Database Data Modeling, table design and implementation for Database and related ETL processes.
  • ETL architecture, design & patterns and framework
  • Analysis, design, development, and implementation of Database ETL, client/server, and mainframe transactional applications
  • Ensure solution delivered adheres to the technological standards established in the organization
  • Experience with data visualization tools
  • Participate in requirements gathering sessions with the business and BI Analysts to understand business analysis requirements
  • Assistance in preparation of project proposals, including client and vendor meetings
  • Designs and implement a proof of concept or prototype as needed for solutions as an individual contributor
  • Data analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business report owners

SQL Server (2008 R2, 2012 & 2014)

  • Experience with very large databases and/or data warehousing, Good knowledge of SQL
  • Understanding and Requirement Gathering – ER Diagram, Object and Class Diagram
  • Database Designing and Architecting
  • Stored Procedure & Function writing
  • Optimization and parallel Processing
  • Auto Data generation for testing
  • Design Authority for all company databases
  • Adherence / Enforcement of company Quality procedures
  • Experience as an MS SQL Server DBA
  • Data management, versioning of data, backups
  • Create, maintain and develop documentation
  • Diagnose and correct programming errors
  • Identify and write best possible code in case of new deployments or when rewriting code when migrating to a newer version of SQL Server.
  • Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
  • Be aware of potential blocking, deadlocking and write code to avoid those situations.
  • Ensure that the code is written keeping in mind any security issues such as SQL Injection.
  • SQL tuning, query and index optimization
  • Management and monitoring of database security and audit logs in accordance with PCI/DSS.
  • Collaboration with application architects, developers, product managers, business analysts and technical management team to design, develop and document databases, schemas, tables, functions, triggers, procedures and other necessary aspects of the database.
  • Understanding, Developing and managing CDC (Change Data Capture)
  • Follow established SQL Server standards for design, development and migrations
  • Stored Procedure Test Script writing

SSIS – SQL Server integration Service

  • Package designs and Development.
  • Analyzing Source, Destination and Transformation
  • Analyzing Data flow, Control Flow task and Event Handler
  • Provide technical expertise to functional and detailed designs.
  • Package configuration – Custom, File, XML and Environment Variable
  • Package Logging – Custom, Standard, Text, XML and SQL Server logging
  • Engage with business users, analysts, technical staff, and project team members to design, develop, implement, and enhance applications.
  • Package Deployment and Maintenance – MSDB and File System
  • Ensure proper data transformation and migration between disparate systems
  • SSIS Package Security and transaction option
  • Ensure the integrity and reliability of data feeding systems
  • Package Execution – Runtime, Scheduling, BAT file and Stored Procedure
  • Package, Parallel Processing with Continuous multithreading
  • Reviewed existing processes to identify areas for improvement and opportunities for additional savings
  • Check the accuracy of test results using current, valid and reliable data
  • Participates in the development and maintenance of corporate data architecture, data management standards and conventions, data dictionaries and data element naming standards.
  • Package Error handling and Troubleshooting
  • Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions
  • SSISDB catalogue, Analysis with Data Taps and using build on the report

SSAS – SQL Server Analysis Service

  • Analysis of Dimension, Measure and keys
  • Design and Develop cubes and sub cubes
  • Tabular and Multidimensional Model
  • Carrying out routine administrative tasks in all areas of SSAS as required
  • Research and help implement new tools and technologies for satisfying analysis needs
  • Used in complex expressions to calculate, group, filter, parameterize, and format the contents of a report
  • UDM/DSV
  • Cubes, facts, dimensions
  • Dimension Attributes, Levels and hierarchies
  • Calculated measures, KPI’s
  • MDX, MDX functions
  • Administering and configuring.
  • Security, Row and Column level
  • Storage and Aggregations
  • Deployment, processing and implementation
  • Tracking and monitoring

SSRS – SQL Server Reporting Service

  • Expertise on report server model design
  • Develop new capabilities and architectures of client portal, ad-hoc BI capabilities
  • Analysis of Reporting artifacts and need
  • Optimization of Data Source and Report View
  • Develop Reporting framework
  • Report Scheduling and formatting
  • Report Authoring and Security

Power BI

  • Data Mining and PowerPivot
  • Understanding Corporate and Self-Service BI (PowerPivot)
  • Power Map Development and Requirement Gathering
  • Auto Tour functionality, 3D and 2D Maps in Power Map
  • Mashup of Different Data Sources With Power Query
  • Developing Filter and Slicer effective in Power View
  • Developing Q&A, Power BI Portal for one stop solution
  • Power Pivot – Data Modeling, Relationship, Cleaning data, Create a PivotTable and PivotChart Report
  • Power Pivot Data Mashup with SQL Server 2008 R2, 2012 & 2014, SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS), Text Files, Data Feeds, Oracle Server, Sybase Server, Excel, Market plus Database, Wikipedia Database, HTML Page as Data Source
  • Using DAX for Calculated Columns and Measures
  • PowerPivot Infrastructure Overview and Capacity Planning
  • SharePoint Server 2010 Topologies PowerPivot Departmental Topology
  • BI Semantic Model and Data mining architecture
  • Excel 2010 BI Architecture & Latest Excel BI Architecture with PowerPivot
  • Integration, Microsoft Power BI for Office 365

Key Skills

Database Architecture FSD / TDR / TDD / VSD ’s Deployment Plan Configuring & Authoring
SSIS Integration Optimization Define scope of Work Parallel Processing
SSIS Package Architecting Scrum Master SSRS Report Architecting Logging & Security
Analysis & Analytics HLD and LLD Design Stored Procedures Team Management
SQL Job Scheduling Migrating & Rode map Training / Mentoring SSAA Cube Development
Testing / Test Case Design Implementation Plan Development & Relation TSQL Coding

Blog : (B)usiness (I)ntelligence Mentalist

Blog : SQL Server Mentalist

  • Blog URL: http://sqlmentalist.com
  • This blog has 200 + Post all related to Microsoft SQL Server Scripting, DBA, tips, and optimization for SQL server 2005 to 2012 year
  • Have covered different series on this blog some of key points are as follows:
  • SQL script post (180 + post) ( http://sqlmentalist.com/sql/)
  • This scripts is really useful to DBA, SQL User, BI Developer to do various actions, very fast and at single place .

image

MCSA Logo 2012MCSA goodMCSA Logo Big

imageimageimage

imageimage

imageimageCSMCricular

My Blogs:

Connect With me on

| Facebook| Twitter | LinkedIn| Google+ | Word Press | RSS |Find us on Google+|

  1. satvinder
    March 15, 2015 at 11:11 PM

    sir,can u provide a training in msbi,
    thanks
    satvinder

  2. satvinder singh
    July 26, 2014 at 12:08 AM

    Hi Vishal,
    can u provide the training in msbi,thanks

  3. March 11, 2014 at 2:35 PM

    Really thanks Vikram for training interest !
    But i really running out of time now a days..
    Will help you if needed for any specific topic.
    Thanks

  4. vikram jain
    March 9, 2014 at 9:25 PM

    can u provide me training for SQL Server BI tools, my email address is jainvikram83@gmail.com.

  5. venkat
    January 17, 2014 at 3:02 AM

    Can u provide me training on BI Tools & T-sql. My email id is rvp.polasa@gmail.com

  6. manishrao18
    December 31, 2013 at 4:23 PM

    Very interesting profile that too on to the BI stack!! In fact I’m targeting my guns on this arena.
    Best Regards,
    Manish Patil

  7. Shumail
    October 30, 2013 at 10:26 AM

    can u provide me training for SQL Server BI tools, my email address is shumail.plsql@gmail.com.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,480 other followers

%d bloggers like this: