About Me

Hi 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

• Currently working in Microsoft projects with The Most Group in Pune as Microsoft Business Intelligence Solution Architect from last three year.
• 8 + years of experience in Microsoft SQL & BI Stack
• Consulting Architect for Right Click Info
• MS BI Solution architect in Mentalist Network
• Navi Mumbai User Group – NMUG Community President, Leader, Speaker
• SQL PASS Chapter Lead for Mumbai & Navi Mumbai
• Professional teaching consultant for Surya InfoEdge
• Experience in Microsoft projects with Tata Consultancy Services in location Mumbai, Kolkata and Gujarat as Systems Engineer on MSBI(SSIS , SSRS and SSAS).
• Experience in various Google Search Analysis and  Microsoft  development projects with Right Click Enterprises, Mumbai as Website Developer and Company Representative  as Sr. Ex. Officer. For Search Engine optimization
• Worked in lots of Big scaled Business Intelligence Project consisting of All MS Technologies like SSIS,SSRS,SSAS,MSBI,SQL Server 2008 R2,WCF,MVC,ASP.Net,SGMP,AD,WPF,Pivot,SQL Azure, many more..
• Frequently Blogging on SQL Server on blog SQL Server Mentalist around 200 + SQL script are for all MSBI and SQL User
• monthly posting 50 post having Current and latest update plus various interesting link on Link resource website on Dactylolomy of Web Resource / Link Mentalist
• Currently also blogging on (B)usiness (I)ntelligence Mentalist
• Started LinkedIn Indian MS BI Group now (India – Microsoft Business Intelligence Professional (SSIS ,…)
• Created and Shared all post on Facebook page (Mentalist Networks)
• Also Providing Training in BI and SQL Server.
• Done BE in CS from D.Y.Patil ,Nerul,RAIT Some more Details of My Various Blog as follows
• PASS Blog directory listing for SQL Server click here to see !
• SQL People community blogger list
• NMUG event history by Vishal Pawar

Tool Developments (Codeplex )

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

• URL – https://sqlprarup.codeplex.com/
• Auto Format/Indent all SQL Server Objects at ones
• Custom & Multiple Stored Procedure Formatting/Indenting

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

• https://sqlsvachalit.codeplex.com/
• Auto Sticker to all Sps and function

Microsoft Power BI Video

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

• Topic – Power of Power BI in 10 different analysis with conclusions
• URL – https://fb-3785439.strutta.com/entry/5466279

  Session and Presentation Details

• Business Analytics to solve your Business Problems
• Introduction To SQL Server 2014
• Learn Power BI with Power Pivot, Power Query, Power View, Power Map and Q&A
• URL for all – http://www.slideshare.net/VishalPawar_BI

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 URL: http://bimentalist.com
• This blog has 150 + Post all related to MS BI(Microsoft Business Intelligence) World where we will get lot of updates, Knowledge, Tutorials series of article related to MSBI on day to day basis through year.
• SSIS : 40 Post (https://bimentalist.com/ssis/)
• SSRS : 20 Post (https://bimentalist.com/ssrs/)
• SSAS : 25 Post (https://bimentalist.com/ssas/)
• BI (In General):150+ (https://bimentalist.com/bi-3/)

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 .

My Blogs:

• Business Intelligence Mentalist >> MS BI World
• Link Resource Blog >> Daily Interesting links
• SQL Server Mentalist >> SQL Learning Blog

Connect With me on

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