Pushpanjale Pujar - 732-***-****

adiqt1@r.postjobfree.com

SUMMARY

Over 14 years of IT experience with expertise in the areas of Analysis, Design, Development, Testing and Maintenance of multitude of diverse business applications using N-tier architecture using Scrum Methodology

Strong experience in developing Enterprise, Distributed and Web applications using MS- SQL Server, MDX, DAX, Power BI, SQL BI, T-SQL, Dashboard, Azure Data Bricks, Azure data Lake, Azure Data Factory.

Writing data structures such as string manipulation, two-dimensional array, String reverse, Array count

Clients that have worked with such as Microsoft, Wells Fargo, Energy and Utilities, Bank of New York and Farmers Insurance Group

Strong experience in designing and developing relational data models on MS SQL Server2000/2005, Oracle 8i and MySQL.

Developed UI Designing using themes and skins tools and using set of validations and JavaScript

Worked on designing the Architecture of the project in N-Tier Architecture as well as Model View Controller

Followed N-Tier Architecture development which involves Presentation Tier, Data Access Tier, Business Tier, Database Tier which developed in visual studio 2003,visual studio 2005,visual studio 2008,HPQC

Sound understanding of Service-Oriented Architecture, Software Development Methodologies and Software Development Life Cycle (SLDC).

Experience in developing report such SQL Server Reporting Services(SSRS), SSAS, MDX, Power BI, CUBES, Azure Analysis Services, SQL Server Integration Services(SSIS),DTS Packages and Performance tuning

Strong enthusiasm for hard work, ability to work under pressure, quickly adaptable to new. A strong team member with good communication skills.

Technical Skills:

Power BI,Power Apps, Kusto, R-Language, SQL BI,CUBES,COSMOS,.net and I have worked on Scrum & Agile.

Programming Languages

C#, ASP, ASP.NET, VB.NET, JavaScript,scala,python,R

Databases

MS- SQL Server2000/2005,MDX,DAX,CUBES,SSRS and SSIS, DTS Packages, COSMOS, Azure, T-SQL, Azure Data Lake, Azure Data Factory, Azure Analysis Services,DataBricks.

Platforms and server:

IIS (Internet Information Server), Windows 2003/XP/2000/NT

Web Technologies

HTML, XML, XSL, XSLT, XSD, ASP, JavaScript, CSS,JSP

Web Designing Tools

TOAD, VSS, Team Foundation Server, Mercury Quality Center, MS VISIO

CERTIFICATIONS

MCSD : Microsoft Certified Solution Developer (.Net)

MCAD : Microsoft Certified Application Developer

EDUCATION

Masters of Science in Computer Science (MSC Computer Science).-2003

Bachelor of Science in Computer Science (BSC Computer Science).-2000

EXPERIENCE

Role : BI Lead Feb 2020 – Till Now

Client: Mindtree

IDEATenantCXP : IDEATenantCXP project contains Tenants availability from IDEA Team who are Subscribed to Azure .This CXP Team has SnapShotDate,TenantId,TenantName,PaidAvailableUNits,P2PaidAvailableUNits.

Every Month we run Cosmos Job to retrieve Tenant from Cosmos from IDEATenantProfile link. Check PaidAvailableUNits & P2PaidAvaialbleUnits and Created Databricks Code to retrieve data from Cosmos, Kusto& Sql.

Create Azure Data Factory Pipeline to run on Daily Basis.

Create a Databricks Code which is written in Scala,Sql,Python and get output of data from

Multiple sources.

Create a Pipeline which takes Snapshot Date and date, Check Cosmos Stream, Databricks

Code,Validation and gives alert message to customer.

Create Data Analysis retrieve data in Kusto Database

Retrieve Data in Power BI report to run monthly Reports.

Environment: Power BI Gateway, Power BI, Azure Databricks, Azure Data Factory, Blob Storage,Cosmos,Kusto, VSO, Team Foundation Server, SqlServer 2018,Python,Scala.

Microsoft, Bellevue, WA Feb 2018 – Feb2020

Role : SQL BI & Power BI Lead

Skype Bus Core Engineering Team: Skype Team contains PSTN data & 0R data . PSTN data contains Call Duration, Call breakdown, Total Attempts of Call, Total Call Counts & Call Minutes, DAU & MAU,Provision Users & Enabled Users. Provision Users which is subset of Enabled Users. Every Provision User is assigned with PolicyId, TN,

Creating Power BI Dashboard with count of Database Collection, Regions, Customers, Request Units (RU's) and Visuals Displaying, BillingType- External, Internal.

Creating PowerBI dashboard with Call Duration, Call Count, Call Count in Minutes as a KPI.

Max TotalDataUsed by BillingType, Sum Total Request By BillingType, MAX RU's (Throughput) .

Created Azure Data Lake -> Azure Analytics,Azure Storage. Writing the U -Script.

Created Azure Data Factory .Creating a pipeline to transfer data from source to destination.

Gathering Client Requirement and creating MOM Notes.

Creating a Kusto Query for Power BI Report and Importing it back to PowerBI.

Creating Database Document which includes all the Databases, Clusters and Tables used in Azure Cosmos DB

Writing the Cosmos Script in Data Studio which includes the backfill job for Kusto Tables.

Environment: Power BI Gateway, Kusto, Azure Analysis Services, Azure CosmosDB, Data Studio, Cosmos, Sql Server 2016/2017/2018,Microsoft Team,,AZURE,CUBES,DAX, MDX, OLAP CUBE, Measurements & Dimension’s, Power BI Desktop & Power BI Service,Python,Scala, Power Query, Azure Data Factory & Azure Data Lake, Dashboard reports, SSRS, SSIS and SSAS, Creating Custom Visuals in Power BI.

Microsoft, Bellevue, WA October 2015 – Dec 2017

Power BI

DATA & ANALYTICS : Am working with Data & Analytics Team with Microsoft…We are working on Edge Browser and Cortana Search ….This application we are showing the Graphical Representation of EDGE Browser usage on Daily & Weekly Basis on Power BI Graph...Edge Browser usage is done with some Filter’s such as Country, Different Browser Names, Customer Group etc..We calculate the Edge Share Daily and Edge Share Weekly with different other browser’s such as Chrome,Firefox,Internet Explorer etc…

• Requirement gathering from the End Client.

• Writing a Technical Document for Client Requirement’s.

• Arranging meeting and weekly status reports .

• Off Shore and Onsite Co ordination …

• Running the COSMOS jobs converting unstructured streams to Structured Stream into

CSV,TXT,XLS and to run

Daily and Weekly Egde usage data…

• Every scope script is assigned with the Max Tokens for the complex script which has complex

manipulations and searching.

• Designing and Developing the Power BI Reports using DAX..

I have worked in multi-dimensional (MOLAP) & deployment…

Maintaining the data on ON-PREMIS & CLOUD and Deploying the CUBE in Azure Analysis Services.

Developing the reports using POWER BI, Power Pivot and SSRS and SSIS, SSAS and COSMOS.

• Adding the feeds and Scheduling the jobs in Geneva Analytics.

• Implementing the CustomExtractors and DefaultExctractors to read the .CSV files. In COSMOS

• Worked on c#, Asp.net, JavaScript and Kendo UI.

• Experience in building reporting dashboards.

• Data modelling, data pipeline optimization.

Environment: COSMOS, Power Apps, CUBES, Azure Creating Custom Visuals in Power BI.DAX, Amazon RedShift, MDX, Measurements & Dimension’s, Azure Analysis Services.VizFx Reports, Power BI, multi-dimensional (MOLAP),Power Query. Dashboard reports, SSRS, SSIS and SSAS.

VISA, Denver, CO Jan 2015– October2015

SQL BI Lead

PROJECT DESCRIPTION: Prepaid project contains Amazon and Bank of America as a customer who provide their credit card to setup their validations which needs to be performed. There is App config team which either validate the manually or automate. There is background process in the web service which will validate the all the attribute for different locations and branches with different validations performed on it.

Gathering Business Requirement from the End User.

Developing Power BI Application into Interactive Dashboards.

Worked on SQL Server2010 & 2012 as backend server.

I have worked on SSRS Report to Run Yearly data for VISA transactions.

Worked on SSIS to perform ETL operation to import/export data into Database.

Worked on SSAS to developed Multidimensional OLAP CUBES in Fact & Dimension Tables and automate it.

Schedule a refresh program to refresh he cube and reports.

Developed Power BI dashboard with Complex DAX expression.

Written the Test Cases, Documentation and Testing of the Application.

Followed the Agile / Scrum Methodology.

Responsible for different Software Development Life Cycle (SDLC) processes of the project using MVC4

Used windows Forms and set up an inheritance chain of Forms based on OOP’s Principles.

Followed N-Tier Architecture and Scrum Methodology development which involves Presentation Tier, Data Access Tier

Writing Stored Procedure, Scripts, SQL Queries.

Made regular code review to ensure that all the Processes and Standards are being adhered i.e. ensuring correct Implementation of requirements, coding standard, project architecture, efficient code writing techniques etc.

Environment: Power BI, SQL BI,SSAS,SSRS,SSIS,CUBES,DAX,MDX,Fact & Dimesnion tables.

Multi-dimensional (MOLAP), Power Query.

Company Name: Nevada Health Care Association Jan 2014 – Dec 2014

Role : SQL BI & Power BI Dev

Location Orange County, California Area

PROJECT DESCRIPTION: HIX is a web portal for shopping online health insurance. It is a part of Obama Health Care for the State of Nevada. Individuals and employers can buy health insurance from this web site. The buyers would be able to compare, select and buy a health insurance plan by paying online payment.

Gathering Business Requirement from the End Client.

Daily sprint task is assigned to fix the production issues.

Developing Power BI Dashboard Reports.

Developing SSRS, SSIS, SSAS and OLAP Cubes.

There will some set of work items created for the production issues

Worked on Agile/Scrum methodology.

Worked on writing stored procedure in SQL Server 2014.

Worked on writing developer’s test cases for the web services.

Environment: SSAS, OLAP CUBE, SSRS, SSIS perform ETL, Power BI, DAX, MDX.

Microsoft, Seattle, WA (Online Services Team (Bing Ads) Jan 2013 – Jan2014

Software Engineer

PROJECT DESCRIPTION: APD (Advertiser Performance Diagnostic): APD project is based on Bing Ad’s.This Application is based on Accounts, Campaigns, Ad Groups, Ads and Keywords etc. Advertiser will pay on bidding of the keyword to get the impression on Mainline or Sidebar’s in Bings Ad’s. There is Auction takes place in order get the impression’s in the Bing Ad’s. There are several reason’s impressions may not show up in the Bing Ad’s, It may be due to Budget, Rank, Bid, and NegatievKeyword, added etc. Reports it contains are Campaign’s Report, Ad group Report, Ad Report, Keyword Report, Change History Report, Negative Keyword Conflict Report, MetroTargetting etc.

Responsibilities:

Designing and development of APD application in .Net 4.5,Linq queries, RESTAPI with SQL Server 2010

Generates the Excel output file which will give Which Campaigns’ are responsible dips in impressions.

Production support and Bug Fixing for any production issues using Sprint Task

Algorithms on Palindrome, Linked List, Queues etc.

Worked on SSAS,SSRS and SSIS and Cubes and Power BI for reports development

Writing data structures such as string manipulation, two dimensional array, String reverse, Array count etc.

Written the Test Cases, Documentation and Testing of the Application.

Responsible for different Software Development Life Cycle (SDLC) processes of the project using MVC4

Used windows Forms and set up an inheritance chain of Forms based on OOP’s Principles.

Worked on SSAS and Dash board reporting and cubes with VizFx Reports

Writing Stored Procedures, Scripts, SQL Queries.

Used complete LINQ blog to retrieve calculated data from Report’s.

Environment: SSAS, SSRS, SSIS, OLAP CUBES, Power BI, SQL BI, SQL Script, DAX, MDX,

Power BI Dashboard's, KPI.

Deloitte - Govt of California at EDD, Sacramento, California Mar 2011 – Dec 2012

SQL BI Developer & Production Support

PROJECT DESCRIPTION: UIMOD is California based government project. UIMOD is based on Unemployment Insurance. Citizens of US when they are unemployed they can take up benefits from Unemployment Insurance which pays them bi-weekly They can Apply for unemployment insurance if the eligible for it, If the person loses the job for any health reason or he is in training period etc. he can apply for unemployment Insurance.

Responsibilities:

Designing and development of EIP application in .Net 2008 with SQL Server 2008

Production support and Bug Fixing for any production issues using Sprint Task

Developing web Application on ASP.net with C#, SilverLight, Agile Methodology

Testing the Same application using QA/UAT experience and fixing the production issues

Involved in developing various kinds of Reports related to SSRS and SSIS

Worked one Defect Fixing in HPQC with High Priority defects to Medium to Low Priority Defects.

Written the Test Cases,Documentation and Testing of the Application

Fine Tuned the SQL queries for maximum efficiency and performance.

Responsible for different Software Development Life Cycle (SDLC) processes of the project using MVC

Used Web Forms and set up an inheritance chain of Forms based on OOP’s Principles.

Followed N-Tier Architecture and Scrum Methodology development which involves Presentation Tier, Data Access Tier

Writing Stored Procedure, Scripts, SQL Queries

Site Core CMS is working with all of your digital marketing channels to increase conversions, drive revenue, and meet real business objectives

E-Commerce solution that maximizes your success in attracting and converting visitors throughout your customer lifecycle

Created and deployed dot net application by web service using SOAP in C#, WCF, asp.net with SOA architecture.

Design and develop screens for capturing, retrieving and manipulating data using ASP.NET and ADO.NET

Use a comprehensive SSRS design environment, T-SQL, Create reports from a wide range of data sources, Enable report authoring for business users.

SSRS reports are generated from Business Intelligence Projects and create shared data source by adding new data source, on report layout select the dataset to extract information on layout and customize the layout and switch to dataset screen and drag the columns.

The presentation part retrieves data from a data source and formats the data for display. When the user performs an action based on the data, the update part passes control back to the business logic to update the data.

Environment: Microsoft Visual Studio 2008, .NET Framework 3.5, Silverlight, TFS(Team foundation Server), ASP.NET 4.0, C#, .Net Framework 4.0, SQL Server 2008 Database, Pitney Bowes, Site core 6.0, MS Test Scripts, SSRS, MSMQ,SSIS,WCF,Win2000, IIS, and Visual Source Safe 2010, HTML 5.0,, T-SQL, CSS,User Control, ASP, Scrum Methodology, HPQC, SQL Query, Stored Procedure, SQL Scripts AJAX, MS VISIO, Web Services.

Wells Fargo, Charlotte, NC Jan 2010 – Mar 2011

SQL BI Developer

PROJECT DESCRIPTIONS: SEAMS (Service Engagement and Management Site): SEAMS is the Intranet based application which is used within WellsFargo.SEAMS contains Sizing, Request, Reports, Forecast Hours, Milestone and Actual Hours .An Sysadmin logins into the Application and Create request and Modify and View the Request for the New Projects in Wells Fargo. Sysadmin can enter the Sizing Hours of the Resources involved in the project such as Billing hours. He can even enter the Forecasted Hours and Actual Hours. It contains Sizing Version for every Request.

Responsibilities:

Designing and development of SEAMS application in .Net 2008 with Sql Server 2008, T-SQL,MS CRM

Developing web Application on ASP.net with C# with .net 1.1,.net 3.5 with WPF

Testing the Same application using Mercury Quality Center and QA/UAT experience and fixing the production issues

Involved in developing various kinds of Reports related in SSRS and SSIS

Written the Test Cases,Documentation and Testing of the Application

Fine Tuned the SQL queries for maximum efficiency and performance.

Responsible for different Software Development Life Cycle (SDLC) processes of the project

Used Web Forms and set up an inheritance chain of Forms based on OOP’s Principles.

MS Dynamic CRM where all the contact can be imported from the database by doing ORM Object Relational Mapping

Microsoft Message Queuing (MSMQ) is a component of the Windows operating system that allows cooperating applications to send and receive messages to each other

Created and deployed dot net application by web service using SOAP in C#, asp.net with Jquery.

Creating E-mail Notifications for Sizing Completion, to Approve, Decline the Sizing, Phase completion Notification for each project Milestone.

Design and develop screens for capturing, retrieving and manipulating data using ASP.NET and ADO.NET

Use a comprehensive SSRS design environment, Create reports from a wide range of data sources, Enable report authoring for business users.

SSRS reports are generated from Business Intelligence Projects and create shared data source by adding new data source, on report layout select the dataset to extract information on layout and customize the layout and switch to dataset screen and drag the columns.

The presentation part retrieves data from a data source and formats the data for display. When the user performs an action based on the data, the update part passes control back to the business logic to update the data.

Environment: Microsoft Visual Studio 2008, .NET Framework 3.5,, T-SQL, ASP.NET 3.5, C#, .Net Framework 3.5, SQL Server 2008 Database, VSS, SSRS, SSIS, JQuery, Win2000, IIS and Visual Source Safe 2010, HTML 4.0,MS CRM, CSS, MQ Series, Linq, User Control, Master Pages Classic ASP, Scrum Methodology, Query, AJAX, MS VISIO, Dev Express, Web Services.

Farmers Insurance Group, Simi Valley, CA Apr 2008 – Dec 2009

Senior .Net developer and Onsite coordinator

Employer: Wipro technologies

PROJECT DESCRIPTIONS: The project is on Help Point Business Systems which is related to Claims in the Insurance Company. Major Modules such as CASH Receipts, FNOL (First Notice of Loss), Document center, OLEM.HPBS involves receiving the claims from different part of the United States which involves property loss and damage due to floods and tornados. Cash receipts are the module where customer will give Money in terms of e-Transfer or Check. BATCHES (collection of all the Check) and Items (Checks). User will take the saln code and it will search in legacy system for its claim number then it will allocate batch number to the cheese and get the receipt. FNOL (First Notice of Loss) is been is to Claim only for property Loss.

Modules: FNOL (First Notice of Loss), Cash Receipt, Total Loss, OLEM (Online Employee Manager), Document Center Others

Responsibilities:

Understanding and analyzing the client’s requirement

Involved in the Transition of the HPBS (Help Point Business Systems) Application with the critical modules such as FNOL (First notice of Loss), CASH Receipts, OLEM (Online Employee Manager) and Document center.

Written technical and Design documents for the HPBS project which involves Architecture, Screen Shots,WebServices,Flow Charts

Involved in solving production issues and enhancement of the Application with adding additional features.

Involved in Solving the issues related to DB (TOAD ), T-SQL

Responsible for different Software Development Life Cycle (SDLC) processes and Scrum Methodology of the project.

Scrum Methodology is an iterative,incremental Framework for project management and Agile Software Development

Generation of Reports in Modules in SSRS

Followed N-Tier Architecture, Scrum Methodology and development which involves Presentation Tier, Data Access Tier, Business Tier, Database Tier

Closely interacted with QA team and updated Rational Clear Quest system after resolving the bugs

Worked on the testing phase with QA/UAT and gone through Acceptance Testing

Used ADO connection, Record set, command objects and run the stored procedures

Worked as Onsite Co coordinator supporting off shore team in project Release, Documentation

After all, one of the advantages of a Web-based thin-client application is the fact that you can change the user interface at any time without having to redistribute the application. If presentation code and business logic are combined in a single object, you have to modify an object containing business logic every time you change the user interface

Developing and Documenting UML design Document with Sequence Diagram, Flow Chart,

Database Design, ER Diagram, Tables and Relationships, Attributes, Screenshots of the Flow

Environment: Microsoft Visual Studio 2005 and Visual Studio 2008, .NET Framework 2.0, ASP.NET 2.0, ASP.net 3.5, .Net Framework 3.5 and WPF, WCF,Linq,C#.Net, and worked Oracle 10g with PL/SQL,, T-SQL,XML, XSLT, TOAD, IIS and Harvest, Peregene Service center,SSRS, JQuery, HTML, DHTML,COM,CSS, OOAD,Classic ASP, Site Core 6.0, Crystal Reports MQ series, Scrum Methodology,Silver light, Query, AJAX,MS VISIO, Dev Express,Web Services.

Bank of New York, NY Aug 2007 - Apr 2008

Senior .Net Developer

Employer: Wipro technologies

Description: EPIC is the project in which we collect the New York Stock exchange data by the end of the day in the Basket we have to store the updated data into the database with which we can generate the reports for the particular sponsor.. EPIC project contains Sponsors, Fund, Trusts, Broker profiles there are list of sponsor who want who will provided funds by the trust .broker is the person who will provide the Fund to the sponsor

Responsibilities:

Designing and development of EPIC application in .Net 2005 with SqlServer 2005

Developing web Application on ASP.net with C#

Testing the Same application using Mercury Quality Center and QA/UAT experience and fixing the production issues

Involved in developing various kinds of Reports related to New York Stock Exchange in SSRS and SSIS

Written the Test Cases,Documentation and Testing of the Application

Developed a tool in windows service which records and stores the New York Stock exchange data

Fine Tuned the SQL queries for maximum efficiency and performance.

Used Team Foundation Server (TFS) is a very fine, modern source control system (and a lot more) that we use very successfully on our own internal projects

SSRS reports are generated from Business Intelligence Projects and create shared data source by adding new data source, on report layout select the dataset to extract information on layout and customize the layout and switch to dataset screen and drag the columns.

Worked as Onsite Coordinator and managing team at offshore

Developing and Documenting UML design Document with Sequence Diagram, Flow Chart,

Database Design, ER Diagram, Tables and Relationships, Attributes, Screenshots of the Flow

Environment: Microsoft Visual Studios 2005, Team Foundation Server(TFS), SOA,QA/UAT,ASP.NET 2.0,CRM Dynamic, VB.net and C#, T-SQL, SQL Server 2000/2005, Windows Server 2000/2003, W3C,Scrum Methodology, IIS 5.0/6.0, Win Forms, SSRS and SSIS, CSS, HTML, Java Script, AJAX, Web Service, MS VISIO, PL/SQL,TFS.

Med scribe Communication (Health Care Industry), Van Nuys, CA Jan 2006 – Jul 2007

Senior .Net Developer

Electronic Prescription (e – prescription)

Employer: Wipro technologies

Description: A prescribe ability to electronically send an accurate, error-free and understandable prescription directly to a pharmacy from the point-of-care - is an important element in improving the quality of patient care The inclusion of electronic prescribing in the Medicare Modernization Act (MMA). Transactions between prescribes (who write prescriptions) and dispensers (who fill prescriptions) for new prescriptions; refill requests and responses; prescription change requests and responses; prescription cancellation, request and response; and related messaging and administrative transactions. Eligibility and benefits queries and responses between prescribes and Part D sponsors. Eligibility queries between dispensers and Part D sponsors.

Responsibilities

Understanding and analyzing the client’s requirement

Design and Developing UI look and feel of the Application in windows application

Developed Design document using VISIO, Designing web pages with Tools of .Net 1.1 by using C# language writing SQL queries and stored procedures

Generation of Reports of every Module using SSRS

Worked on UAT and Testing Team i.e. QA and Writing test cases and Test Plans

Written Unit Test Cases for the eMedscribe and involved in Unit Testing

Supported the different project which involves transferring data from SQL Server 2000 to MS Access

Worked as Onsite Co coordinator supporting off shore team

Environment:.Net 2.0 with SQL Server 2005 with ASP.net with C# and HTML, UAT, HL7,HIPPA,CSS, Mercury Quality Center, AJAX, SSRS, Winforms, Dev Express, T-SQL.

Contact this candidate