Power Bi C#

NEHA SINGHAL

SharePoint (office***)/Power App/Power BI Developer

***********@*****.***

Mobile: 973-***-****

PROFESSIONAL SUMMARY

•Over 10+ years Professional IT experience in design, development, Unit testing and implementing application software and most importantly, optimizing software solutions catering to the business requirements using Microsoft Office 365 (SharePoint Online), SharePoint 2019/2016/2013/2010, MOSS 2007, SharePoint 2003, WSS 3.0 and .NET technologies on windows and web environments.

•Experienced in using SQL queries for data extraction and back-end testing.

•Extensive experience in developing applications using ASP.NET, C#, ADO.NET, SPFX with Fluent UI, Microsoft Visual Code 2017 and various .NET Framework

•Having Hands on SQL Query, Sub Query, Views, Trigger, Cluster, Indexing, Store procedure, Functions, create table, drop table, alter table, Define Primary key, foreign key.

•Database Normalization (1NF,2NF,3NF, BCNF,4NF,5FN), Create Database, Drop Database, Alter Database, Data Base Backup, Restore Backup.

•Experienced in creating Unit Test Cases and Test Data. Performed User Acceptance Testing (UAT) working and Gap Analysis with team members.

•Experience developer in designing and implementing Webpages using Visual Studio in XML, ASP.NET, REST API Services, SQL, Html5, CSS3, jQuery, Bootstrap, SPFx (Webparts, Extensions)

•Having Hands on C# Programing (OOPS) class, Interface, Abstract class, Partial class, Sealed class, Static class, generic-type, Array List, Method, Property, Anonymous type, Error Handling.

•Good exposure in design, development and deploy custom web parts, .NET user controls, Master Pages, page layouts, custom Event Handlers, content types, features, solutions and templates to be used in a SharePoint environment.

•Expertise in migration process from MOSS 2013 to SP 2016 using database attach and detach process like moving content DB from old SQL Server to New SQL Server.

•Experience in Configure Search Services for SharePoint 2010.

•Experience in performing backup and restore MOSS 2007 and SP 2010,2013,2016 and have granular backup and restore like site collections and sites, list and libraries.

•Extensively Designed, Developed and Tested WSS Site Templates, Custom Web Parts, Custom Templates, Deploy BDC Web Part and Chat Web Part, Easy Tabs.

•Experience in SharePoint Server Object Model, Client Object Model (CSOM).JSON,REST Api

•Extensively worked on Site Definitions, Site Template and List Definitions, List Templates, Audiences, Security, CAML, and Search &SSO for MOSS 2007 and SharePoint 2010,2013,2016.

•Power Apps forms & Microsoft Flows,,Spfx.

•Have good practice with bootstrap, Style Sheet, CAML, XML, JavaScript, jQuery, SharePoint Designer 2010/2013/Office 365 and InfoPath 2007/2010/2013/2016.

•Expertise in design, development and Strong programming experience with key skills in ASP.NET, C#.NET, ADO.NET, JavaScript, XML, CSS, kendo grid, Web Services and SQL Server.

•In Office365 worked as Site Collection Administrator and Code review. Manager User Permission, Coding in .net and Deploy App by the help of Azure. Maintain the log files, Document Library App, Lists app, Out-off-Box workflow. Site Customization by help of HTML, CSS, Java script, End User Training

•Nintex Workflow Task lists and Nintex Workflow History, SharePoint security, SharePoint List sizing and work on Nintex Workflow Log file. Import and Export Nintex workflow, according to the requirement modify in workflow and forms.

•Design Nintex Forms core design, layout, controls, control settings, variables, CSS classes, rules, computed fields

•Hands-on Experience in MDX Expressions, DAX Expressions, Power BI Power Pivot, Power integrated with Share Point and in creating dashboards in Power BI and Tableau visualization tools.

•Azure Logic Apps, Azure functions,Azure blob storage, Azure SQL data

•Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).

•Expertise on Business Process Modeling Notations with excellent Sequence, Data-Flow diagrams using Unified Modeling Language (UML), in MS Visio.

•Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams and Business Process using MS Visio or Rational Rose Modeler

•Develops SharePoint solutions in accordance with company policy and security settings

•Involved in Six Sigma Training and document Review and Six Sigma Certified.

•Worked in Agile, Scrum/ Stand up meetings, and sprint environment in order to change the requirements and discuss any roadblocks.

•Data Migration SharePoint 2016 to Office 365 SP using Sharegate, Convert Workflow to Power Automate, Info path to Power app.

•Maintain modern site web parts, Power BI report.

•Proficient in JIRA and Project server

TECHNICAL SKILLS

Programming:

C#, T-SQL, .Net Framework 2.0/3.0/3.5/4.0,4.5 ADO.Net, ASP.Net.

Methodologies:

OOD, TDD, Agile, Scrum

Web Technologies:

HTML, HTML5, DHTML, CSS, CSS3, ASP.NET, AngularJS, Web services,WCF

Scripting Languages/Libraries

JavaScript, jQuery, Shell Script Basic.

SharePoint Technologies

Microsoft Office 365, SharePoint 2013, SharePoint 2010, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft SharePoint Portal Server (SPS) 2003, Microsoft Windows SharePoint Services (WSS) 3.0, SharePoint Object Model, SharePoint Designer 2007/2010/2013/2016, Microsoft InfoPath Designer 2007/2010/2013 SharePoint Central Administration, Web Parts, Report Viewer Webpart, Web Part Pages, Document Management, Records Management, Web Content Management, Windows Communication Foundation (WCF), Lotus Notes, Nintex,”Metalogix “ Quest and Share gate tools.

IDE /Graphical Editors:

Visual Studio .Net/2005/2008/2010/2013/2016/2019, Microsoft office, PowerShell, Dreamweaver, FrontPage.

XML Technologies

XML, XSL, XSLT, Web Services, WCF, REST API, SOAP, WSDL.

Servers

BizTalk 2010/2013/2016, SharePoint, SSIS, IIS 5.0/6.0.

Operating Systems:

UNIX/AIX 5L, Windows Server 2000/2003, Windows 2000/XP/Vista/7/8/8.1

Database

SQL Server 2000/2005/2008, MS Access, SSIS, SSRS.

Skills

Provider Hosted Apps, SharePoint Hosted Apps

Reporting Services

Crystal Reports, Active Report, Excel, Power pivot Report SQL Server reporting services.

Azure Cloud:

Azure SQL Database, Azure Data Lake, Azure Data Factory (ADF), Azure SQL Data Warehouse, Azure Service Bus, Azure Analysis Service (AAS), Azure Blob Storage. Cache using Pipeline and SSIS, Data Migration Service (DMS), Azure SQL Data.

Version Maintain tool

SVN or TFS

EDUCATION

MCA from M.D University in 2006, 70.8%.

CERTIFICATION

OCP certification from Oracle 9i 2005.

PROFESSIONAL EXPERIENCE

Wells Fargo, NJ

Aug 2022 to Dec 2024

SharePoint(Office 365/ Power Developer

Converted SSRS report to Power BI, queries using DAX in Power BI desktop, Paginated Reports, Azure Data Lake, and Azure Data Factory.

Maintained and improved existing ETL processes to accommodate changing business needs and data quality standards.

Managed User Permission, Site Customization, Content Type, Document Management, SharePoint List and Document Library .

Support SharePoint 0ffice 365 and maintain modern site web parts, Graph API, JavaScript,HTM,CSS, jQuery,JSON Azure Data Lake,Azure Data Factory, SharePoint Designer, Azure Logic Apps, Azure SQL data

Power Apps ( Canvas App & Model driven app), Power Automate(Automated flows, Instant flows, Scheduled flows), Power BI report,React, SPFx Pnp Core, SPFx Field Customizer extension.

Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data and security and permissions.

Designed and implemented data models and reports in Power BI to help clients analyze data to identify market trends, competition and customer behavior.

Worked on Microsoft Fabric (Data lake, Data factory, SQL) with Office 365.

Data Migration SharePoint 2016 to Office 365 SP using Sharegate, Convert SharePoint Workflow, Nintex workflow to Power Automate, Info path and Nintex Forms to Power apps.

Developed and optimized complex SQL queries and Python scripts to extract, transform, and load data from multiple sources into a SQL Server Data Warehouse.

Data Migration of SharePoint 2016 to Office 365 SP using Sharegate, Convert Workflow to Power Automate, Info path to Power app.

Support SharePoint Office 365 and maintain modern site web parts, Graph Api,Power Apps, Power Pages, Power Automate(Automated flows, Instant flows, Scheduled flows), Power BI report, SPFx Pnp Core, SPFx Field Customizer extension.

Support SharePoint 2013/2016 and Script Editor web part / workflow.

Client: Boeing, Seattle (TCS)

Role: Power App Developer August 2021 to Feb 2022

Responsibilities:

•The Boeing Company is an American multinational corporation that designs, manufactures, and sells airplanes, rotorcraft, rockets, satellites, telecommunications equipment, and missiles worldwide.

•Support SharePoint 0ffice 365 and maintain modern site web parts, Graph API, JavaScript,HTM,CSS, jQuery,JSON Azure Data Lake,Azure Data Factory, SharePoint Designer, Azure Logic Apps, Azure SQL data

•Power Apps, Power Pages, Power Automate(Automated flows, Instant flows, Scheduled flows), Power BI report,React, SPFx Pnp Core, SPFx Field Customizer extension.

•Designed and implemented data models and reports in Power BI to help clients analyze data to identify market trends, competition and customer behavior.

•Data Migration SharePoint 2016 to Office 365 SP using Sharegate, Convert SharePoint Workflow, Nintex workflow to Power Automate, Info path and Nintex Forms to Power apps.

•Updating user stories in JIRA . Deployment

•Configure CI/CD Pipeline in DevOps.

Client: Frost Bank (HCL America) San Antonio,Tx

Role: SharePoint Developer Jan2020 to Jan2021

Responsibilities:

•Frost is providing banking service to their customers since 1868, Understanding customer’s value, their needs and providing best to their customer is the core value of Frost. Frost provides full range of banking, investment and insurance products to their customers.

•Nintex workflow and Nintex Form in SharePoint 2013

•Support SharePoint Office 365 and maintain modern site web parts, Graph Api,Power Apps, Power Pages, Power Automate(Automated flows, Instant flows, Scheduled flows), Power BI report, SPFx Pnp Core, SPFx Field Customizer extension.

•Support SharePoint 2013/2016 and Nintex form/ workflow.

•The project – Re-arc aims to provide a new look at online banking that will help customer to stay connected. It provides more user-friendly experience, easy to use and increased security.

•Defect tracking and monitoring using JIRA.

•Updating user stories in JIRA if required with the discussion with Product Owner.

•Developed custom calculated measures using DAX in Power BI to compare the company’s industry wide.

•Site Customization by help of HTML, CSS, Java script, Unit testing, Master Page customized

•Developed dashboards including various charts- bar charts, pie charts, scatter charts, bubble charts and shape maps, Power Shell Script.

Client: Wells Fargo, Charlotte NC

Role: SharePoint July2018 to 2019 Dec

Responsibilities:

•Manager User Permission, Coding in .net and Deploy App by the help of Azure. Maintain the log files, Document Library App, Lists app, Visual webpart, Out-off-Box workflow. Site Customization by help of HTML, CSS, Java script, Unit testing, Master Page customized

•Develop (using .net, html, CSS, java script) the Visual webparts, (CSON) provided hosted App, (JSON)SharePoint hosted App, using JSON script Editor Webpart, Content Editor web part.

•Migrations to SP 2013 from SharePoint 2016 by “Share-gate” Migration tools.

•Migrations to SP 2016 from SharePoint Online by “Share-gate” Migration tools.

•Solving Ticket or issue from the current sites

•Migrations with content DB.

•Experience developer in designing and implementing Webpages using Visual Studio in XML, ASP.NET, REST API Services, SQL, Html5, CSS3, jQuery.

•Work on Out of the Box workflows (Approval, Collect Feedback, Collect Signatures, Disposition Approval, Three-State (track an issue, project, or task through three states or phases)

Developed Workflows using the SharePoint designer to automate common business activities such as document review and approval.

•Work on permission, Site/Library/List/Custom field creation and deployment.

•Customize a SharePoint list,Site governance, permission, and sharing for site owners

Description

Wells Fargo internal site.

Environment:

Project Online, SharePoint Online, Office 365, Visual Studio 2017 .NET Framework 4.6, C#, ASP.NET, SharePoint Designer 2013, Windows PowerShell 5.0, CAML U2U, HTML, XML, CSS, JavaScript,MS SQL Server 2016, Visio

Client: Iyogi Delhi (India)

Role:(Inficare) SharePoint Developer (SMB Marketing) Mar-2011 to 2014

Responsibilities:

•Designed and developed Visual webparts, Master Page and Page layouts using Design manager, HTML, JavaScript, and CSS.

•Customized sites and created workflows with SharePoint designer 2010 and out of box workflows to aid users in automated processes and approvals and maintain system documentation.

•Website customization using SharePoint Designer.

•SharePoint’s application services framework including implementation, configuration, and usages of Search, Managed Metadata, and User Profile Services.

•Develop Web parts ((using .net, html, CSS, Angular JS, java scripts, ADO .net, CAML, SQL,)

•Designing and developing customizations that include web parts, custom forms, workflows, timer jobs, web templates, and user interface.

•InfoPath forms design with Visual studio Workflows.

Description

India SMB Marketing is the Sales Marketing project where sales Person Register Client to sale a product. One workflow implemented with different stages on product sales process go with Contact verification, payment verification process. Approval and rejection stages.

Vertex. Hyderabad, INDIA Feb 2009– Aug 2011

SharePoint Developer

Responsibilities:

•Collected requirements from the integrators (users) and developed use cases.

•Created lists, list templates and site templates and attached them to the Designers Workflows

•Created Views, webparts, Alerts and Custom Lists and Libraries.

•Created administrator web parts in ASP.NET for administrative tasks like creating rules and configuring user profiles

•Involved in setting up a staging environment to test the overall upgrade process from MOSS 2007 to SP 2010

•Wrote custom codes to copy the attachments from one list to another on different site

•Created custom workflows and event handlers using VS 2010, SP Designer 2010

•Developed design documents for application and reports.

•Created lists, list templates and site templates and attached them to the Designers Workflows.

•SharePoint Designer, InfoPath, Web Parts, SharePoint add-ins and workflow creation

•Designed the database architecture.

•Developed applications with the Denmark specifications using C#.NET and ASP.NET.

•As per the requirement interfaces are designed using C#.NET.

•Involved in writing local business rules for Denmark using C#.NET.

•Several existing Components are modified as per the requirement.

•Actively involved in testing the applications on different operating systems like Windows NT.

•XSLT was used for the transformation of data from XML to HTML

•XML was used for the transportation of data.

•Lead for Business process redesign and documentation (Business Requirements Documents, Technical & Functional Specifications, Design Documents, etc..).

• Prepared Business Requirement Documents (BRD) as well as USE Case Documents to manage, analyze, and convert business requirements.

• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams and Business Process using MS Visio or Rational Rose Modeler

•InfoPath forms design with Visual studio Workflows.

Environment:

C#.NET, ASP.NET, ASP, IIS, XML, Crystal Reports, PL/SQL, SQL, Windows XP

Client: INGC, Ebix Software, Noida (India)

Role: Program Analyst Document Management System Sep 2007 to Jan 2009

Responsibilities:

•Developing Component for Data Access, Reusable Component.

•Involved in Creation/Customization of Share Point Sites and Integration with Custom Modules.

•Backup of the Data Base time to time.

•Write some store procedure.

•Design the flowchart

•Design the Database

•Write some SQL Store Procedure

•Testing the Data by SQL Query

•Coding and Unit Testing of Modules

•HLD (High Level Designing)

•LLD (Low Level Designing)

•SRS (System Requirement Specification)

•Experienced in design and implementation of Database Connectivity with SQL Server which includes Connected and Disconnected level Using ADO.NET.

•Lead for Business process redesign and documentation (Business Requirements Documents, Technical & Functional Specifications, Design Documents, etc..).

• Prepared Business Requirement Documents (BRD) as well as USE Case Documents to manage, analyze, and convert business requirements.

• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams and Business Process using MS Visio or Rational Rose Modeler

Environment

ASP.NET with C# and SQL Server 2000, Java script, CSS, HTML, Web Services

Description

Ebix, Inc. is a leading international supplier of software and e-commerce solutions to the insurance industry. Ebix provides a series of application software products for the insurance industry ranging from carrier systems, agency systems and exchanges to custom software development for all entities involved in the insurance and financial services industries. With bases in Singapore, Australia, the US, New Zealand, India and Canada, Ebix employs insurance and technology professionals who provide products, support and consultancy to more than 3,000 customers on six continents. Ebix Life is the division of Ebix, Inc. that focuses on research, illustration, transaction processing, and compliance automation for the life insurance and annuity industry.

Products are given below

Vital Term – For a term cover. Gives you comparison for various products and surrender value also

VitalUL – Universal Life for whole life cover. Has a premium option for fixed or varying premiums.

VitalLTC – is long term care. It provides comparison information, of various products.

VitalAnnuity: Annuity is a type of insurance with a return. You are paid a minimum interest amount on your premiums.

VitalSigns: Shows the financial details of the carriers and it’s ratings as given by various rating agencies. We also have an Ebix Life rating called Comdex for all Insurance Carriers.

VitalForms: Calls a third party Form Repository. It provides you all the required PDF Forms for insurance applications.

•Lead for Business process redesign and documentation (Business Requirements Documents, Technical & Functional Specifications, Design Documents, etc..).

• Prepared Business Requirement Documents (BRD) as well as USE Case Documents to manage, analyze, and convert business requirements.

• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams and Business Process using MS Visio or Rational Rose Modeler

Client: Humanitics Dimensions Software Pvt. Ltd Noida (India)

Role: Teacher Student Portal Sept-2005 to Aug 2007

Responsibilities:

•Involved in Complete Life Cycle of TSP Project i.e. CSS, SRS, HLD, LLD, Coding, Unit Testing and Pilot Implementation.

•Developing Component for Data Access, Reusable Component.

•Coding and Unit Testing of Modules.

•Involved in Creation/Customization of SharePoint Sites

•Development / Deployment and Unit Testing of Web Parts.

•Version Controlling via Visual Source Safe (VSS)6.0

Environment

•ASP.Net 2.0 (C#), ADO.Net, SQL Server 2005, Share Point server 2003, MS Class Server 4.0, Active Directory 5.0

Description

The creation of a Teacher Student Portal provides an environment to enhance the usage experience and harness the benefits of a connected network for education. The portal is envisioned to be the first destination for Teachers and Students in creating an interesting and more effective learning environment.

It has got 13 custom processes (Child Census, Student Enrollment School Creation, Teacher Profile, Student Examination, Student Evaluation, Students Attendance, Maintain Annual Budget, School Inspection and Grading. Student Transfer, Teacher Transfer, Fee Collection) which is developed using .Net 2005 and rest of the functionality was provided by Share Point Server 2003 and Class Server some of these include personalized sites for each school. Student Assignment creation by Teacher, Assignment Submission by Student, grading, school time table, content uploading, Professional Development.

The Portal works on single sign on process using the Active Directory.

Contact this candidate