SUMMARY:

• Over 12 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 .NET 4.5(ASP.NET, C#.NET, ADO.Net), MS- SQL Server, MDX, DAX, Power BI,SQL BI, T-SQL, Dashboard.
• Writing data structures such as string manipulation, two dimensional array, String reverse, Array count
• Clients that have worked with such as Confidential.
• Having good experience in developing Win Forms, Web Services (SOAP, WSDL).Net 2.0 and .Net 3.5,.Net4.5 with, REST API, Web API,WCF, JQuery, Kendo UI.
• Strong experience in designing and developing relational data models on MS SQL Server 2000/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, 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:

. NET Technologies: Power BI, SQL BI,ASP.NET, ADO.NET, C#.NET, Web Forms, Restful Services Web Services,.NET Framework 1.1/2.0/3.5/4.5, WCF, WebAPI and I have worked on CLSA Framework, Agile.

Programming Languages: C#, ASP, ASP.NET, VB.NET, JavaScript

Databases: MS- SQL Server 2000/2005,MDX,DAX,CUBES,SSRS and SSIS, DTS Packages, COSMOS, Azure, T-SQL

Platforms and Servers: 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

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Power BI & SQL BI Developer

Responsibilities:

• Designing and Developing the Dashboard Reports in power BI using DAX.
• Migration of the project from Microstratergy to Power BI.
• Implementing Agile methodology.
• Developing the reports using POWER BI, Power Pivot and SSRS.
• Implementing Drill Through & Hyperlinks in Power BI report.
• Adding the feeds and Scheduling the jobs
• Experience in building reporting dashboards SSRS.
• Create FACT & DIMENSION table.
• Data modelling, data pipeline optimization.

Environment: Microstratergy,ASP.Net, C#, AZURE,CUBES, DAX, MDX, Measurements & Dimension’s, Power BI, Power Query, Dashboard reports, SSRS, SSIS and SSAS.

COSMOS & SQL BI Developer

Responsibilities:

• Requirement gathering from the End Client.
• Designing and Developing the Dashboard Reports using MDX and Insights and VizFX Reports.
• Dashboard displays KPI values and other Major Transactions in Power BI.
• Developing the reports using POWER BI, Power Pivot and SSRS and SSIS, SSAS and COSMOS.
• Connecting the CUBES and calculate the numbers from Excel - Add In.
• Writing complex MDX & DAX formula Develop the complex Dashboard by showing %age values…
• Adding the feeds and Scheduling the jobs in COSMOS in Geneva Analytcis & Sql Server Jobs & Power BI Gateway
• Worked on C#, Asp.net, JavaScript and Kendo UI.
• Experience in building reporting dashboards, Data modelling, data pipeline optimization.

Environment: ASP.Net, C#,Kendo UI, COSMOS,CUBES, DAX, Amazon RedShift, MDX, Measurements & Dimension’s, VizFx Reports, Power BI, Power Query. Dashboad reports, SSRS, SSIS and SSAS.

Sr. .Net developer

Responsibilities:

• Designed and Implemented interfaces and classes using Object Oriented Programming features
• Gathering Business Requirement from the End User.
• Developing web Application on ASP.net 4.5 with C#, HTML5, WCF, Agile Methodology.
• Used Linq, MVC framework with SQL Server 2010 & 2012 as backend server.
• I have worked on SSRS Report to Run Yearly data for VISA transactions.
• 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.
• Followed N-Tier Architecture and Scrum Methodology development which involves Presentation Tier, Data Access Tier
• Writing Stored Procedure, Scripts, SQL Queries.
• Used complete LINQ blog to retrieve calculated data from Report’s.
• Created and deployed dot net application by web service using SOAP in C#, WCF, MVC, asp.net with SOA architecture.
• 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: ASP.Net MVC 4.0,Linq,MVC,JQuery, WCF Service,ViewBags,ViewData,TempData,C#.Net, VS 2012, HTTPSQL Server 2012, Win 7, TFS, IIS 7.0/6.0, Entity Framework.

Responsibilities:

• Gathering Business Requirement from the End Client.
• Daily sprint task is assigned to fix the production issues.
• Project architecture is made of MVC with Razor Views and Asp.net HTML Pages.
• There will some set of work items created for the production issues
• Worked on the TFS work items assigned to us on ASP.net MVC and C# .
• Worked on writing stored procedure in SQL Server 2014 .
• Worked on writing developer’s test cases for the web services .

Environment: ASP.Net MVC 4.0, WCF Service, C#.Net, VS 2012, HTTPSQL Server 2012, Win 7, TFS, IIS 7.0/6.0, Entity Framework .

Software Engineer

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.
• Developing web Application on ASP.net 4.5 with C#, HTML5, Azure, Agile Methodology.
• Have Developed Different types of report through API call in Asp.net 4.5 and Visual Studio 2012.
• 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.
• Created and deployed dot net application by web service using SOAP in C#, COSMOS, WCF, asp.net with SOA architecture.
• Design and develop screens for capturing, retrieving and manipulating data using ASP.NET and ADO.NET

Environment: ASP.Net4.5, MVC 4.0,Linq,RAZOR View, Azure,WCF Service, Azure,REST API,C#.Net, VS 2012,HTTPSQL Server 2012, Win 7, TFS, IIS 7.0/6.0, Entity Framework.

Sr. .Net Developer & Production Support

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: Confidential 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.

Sr. .Net Developer

Responsibilities:

• Designing and development of SEAMS application in .Net 2008 with SqlServer 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
• Confidential 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: Confidential 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.

Senior .Net developer and Onsite coordinator

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
• Site Core CMS for the Commercial website
• Developed Data model using ER Diagrams in MS-Visio 2003.
• Responsible for different Software Development Life Cycle (SDLC) processes and Scrum Methodology of the project.
• To create & manage messages, nice client side GUI tool similar to Word 2000 editor is developed using JavaScript
• HPBS Application is a Conversion from Classic ASP to ASP.net 2.0 and Asp.net 3.5 with WPF with C# with Oracle 9i with SOA architecture
• Worked on Production Support for Classic ASP version of HPBS as well as .Net version of HPBS
• Worked with Java Script, HTML 4.0, CSS, JQuery, MQ series, OOAD and other GUI Tools.
• Sitecore’s Web Content Management System (CMS) puts the power of personalization and conversation management right in the hands of your marketers and business users
• Message Queuing (MSMQ) technology enables applications messages to communicate between network, Applications send messages to queues and read messages from queues. Even if the intended recipient application is not running or the computer on which the sender or recipient application is running is disconnected from the network. Message Queuing provides built-in enhanced security, transaction support
• Couple of Pages in HPBS is in Classic ASP and .Net 2.0 with C # and .Net 3.5
• 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
• And conducting weekly status meeting
• Worked on the Design the architecture in n-tier as well as Model View Controller
• User interface logic tends to change more frequently than business logic, especially in Web-based applications
• 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: Confidential 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.

Senior .Net Developer

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
• Responsible for different Software Development Life Cycle (SDLC) processes of the project with SOA
• 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
• Worked on the Mortgage as well as on stock exchange data Business Tier, Database Tier
• Created and deployed dot net application by web service using SOAP in C#, asp.net
• Worked in CRM Dynamics which is a multi-lingual Customer Relationship Management software package developed by Confidential
• 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.
• 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: Confidential 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.

Senior .Net Developer

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, CSS, Mercury Quality Center, AJAX, SSRS, Winforms, Dev Express, T-SQL.