SUMMARY:

• Over 9 years of experience as Sr. Analyst and Programmer in the areas of Design, Analysis, Development, Documentation, Administration and Maintenance of various .Net, BI and SharePoint Projects using Agile and Scrum methodologies.
• Expertise in developing web applications using ASP.NET/Core MVC Patterns with .Net/ Core Framework and worked on O/RM tools like Entity Framework for developing Data Access Context Layers.
• Worked with Client - Side UI provisioning tools such as JavaScript Framework based Angular 6.
• Proficiency in design and formatting the same using HTML5 and CSS3.
• Knowledge in working with RxJS Observables and operators to perform synchronous and asynchronous programming.
• Knowledge in provisioning of NodeJS based WebAPI services.
• Experience in working with JavaScript libraries like jQuery for DOM manipulation tasks.
• Experience in SOA application (distributed) development using XML based WCF (HTTP/TCP Channels) and JSON based HTTP RESTFul Web APIs.
• Experience in JWT configuration to support claims-based token model for authentication and authorization.
• Knowledge in MEAN stack apps development and basic knowledge in NoSQL MongoDB.
• Experience in deploying applications with Cloud Services by creating a simple Cloud Service with Visual Studio, testing it locally, deploying to a live Microsoft Azure Cloud environment and Amazon Web Services (AWS) .
• Proficiency in using C# for web App Development that includes working with LINQ, Lambda Expressions, Collections, Anonymous function, and some other advanced features.
• Worked extensively on SQL Server 2008/2012 and expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Access/Excel Sheets using SQL Server SSIS.
• Experience in creating KPIs, Dashboards, Reports and Scorecards using PerformancePoint Tools and services that aggregates data from multiple sources such as RDBMS, SharePoint Lists, OLAP cubes created using SSAS and data published to Excel Services.
• Expertise in MOSS 2007, SharePoint 2010/2013 & SharePoint Online Development and Administration like Installation, configuration, Maintenance, Upgrade, Troubleshoot and managing SharePoint Farm through Central Administrator as well as using Windows PowerShell 2.0/3.0 and O365 administration using SharePoint online management shell.
• Experience in building web parts, custom list and Custom Content type using Visual Studio 2015 for SharePoint sites.
• Experience in developing and management of InfoPath/Nintex Forms as well as workflows.
• Expertise in ECM through cross-site collection publishing in SharePoint 2013.
• Expertise in SharePoint 2010/2013 Farm Set-Up configuration and maintain service applications like Excel, SSO, Search service, User profile Synchronization services etc. Monitoring SharePoint disk space usage through the built-in SharePoint reports for each site collection.
• Managing SharePoint permissions, Analyzing and reporting upon SharePoint usage and activity, Moving/copying sites.
• Expertise in User Access Control through security management.
• Expertise in developing Provider-hosted/On-Premises Apps using VS 2013/2012.
• Experience in BI framework components for SharePoint includes SSRS, PowerBI and PerformancePoint Services.

TECHNICAL SKILLS:

Microsoft SharePoint: MOSS, SharePoint 2013/2010/2007 , SP Designer 2013/2010/2007 Office 365, NET Framework, Visual Studio 2017/2015/2012/2005 InfoPath 2013/2010/2007 , PowerShell, Ms-Office2013/2010

Web Technologies: ASP.NET/Core MVC, C#, Rest API, HTML5, CSS3, XMLSSOM & CSOM/JSOM

ClientSide Technologies: Angular, Java Script/ jQuery

Data Access Technologies: EF Core, ADO.NET, LINQ

Databases: SQL Server

BI Tools: SSRS, SSIS & SSAS

Source Control: TFS /GitHub

Web Servers: IIS 7.5+

Operating Systems: Windows 7 /XP/, Windows Server / 2003

Identity Provider: AD DS/AD FS

Methodologies: Agile/Scrum

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

Sr. .Net Analyst Programmer

Responsibilities:

• Created domain models and implemented business rules along with bindings that allow data transfer between views and models through .Net Core controller action methods.
• Perform multiple sprints as part of agile development.
• Involved in initial analysis, Design, Development, and deployment of multiple modules of the system.
• Implemented EF O/RM concepts for data context layers.
• Design and develop rich user interactive UI pages using Angular 6 and implemented routing, Services, HTML Templates, and custom directives.
• Designed and developed integration layer using Restful HTTP services which acts as a communication layer between our own domain application and LOB systems like SharePoint.
• Developed ETL packages using SSIS tool for loading data from heterogenous sources.
• Implemented validation rules through attribute filters.
• Implemented Conventional and Attribute Routings for Angular 7 UI.
• Configure and implemented Jason Web Tokens (JWT) for authentication and authorization.

Environment: .Net Core MVC, C# .Net, Angular 7, Sql server 2008R2/2012, SSIS, EF, VS 2017 & WebAPI

Confidential

.Net Analyst Programmer

Responsibilities:

• Provides technical expertise and does system analysis to identify areas where it needs to be optimized for better system performance.
• Design and develop database schemas and objects.
• Front-End Design and development using Angular 6 components and routing.
• Design and develop .Net Core WebAPI Restful HTTP services and configure endpoints to perform CRUD operations with back-end database.
• Created domain models and implemented business rules along with bindings that allow data transfer between views and models through controller action methods.
• Implemented validation rules through attribute filters.
• Implemented Authentication and Authorization.

Environment: .Net Core2.2, Sql server 2008R2/2012, VS 2015, RESTFul WebAPI, Asp.Net & C#.Net, WPF, Angular 6 and HTML5

Confidential

.Net Analyst Programmer

Responsibilities:

• Lead and provide technical expertise to internal project team on Front-End Design and setting up Database environment including technical assistance on SharePoint content database detach and attach process.
• Design, develop and deploy Visual Webpart based Initiation and Submission forms for Audit Initiation and Submission processes.
• Provisioned Nintex Based Virtual DocSet Creation and Submission Workflows.
• Created design, develop and deploy General, Linked and Sub-Reports to SSRS server as per user requirements.
• Wrote Stored Procedures, UDF, Views, and TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Migrated some part of UI into component based Angular 5/6 and configured routing for the same.

Environment: Sql server 2008R2/2012, SSIS, SSRS, SharePoint 2010/2013, VS 2015, Asp.Net & C#.Net, Angular 5, RESTful WebAPI and HTML5

Confidential.Net Consultant

Responsibilities:

• Lead and provide technical expertise to internal project team on setting up MOSS 2007, SharePoint 2010/2013 Farm environment and technical assistance on database detach and attach.
• Site and content provisioning on SharePoint point online and tenancy administration.
• Install and Configure SharePoint Technology tools on all servers.
• Provision Web Applications and configure IIS 7.5.
• Create and configuration SharePoint 2010/2013 Service Applications and Application proxies.
• Create and Configure PerformancePoint, Excel Services, Reporting Services and E - mail notifications in the new SharePoint 2010 Production and Development environments.
• Configure and setup Index server on Application Server and Query Server on both WFE Servers.
• Plan and configure SharePoint security modal that includes authentication and authorization.
• Plan and configure permission inheritance and anonymous site access.
• Develop and maintain new Business processes using Nintex Workflow and Nintex Forms.

Environment: SP 2010/2013, VS 2013, InfoPath, Nintex, Sql server 2008/2012, SP Designer, jQuery, Wcf, C-sharp.Net, HTML5 and CSS3.

Confidential

.Net Developer

Responsibilities:

• Convert business requirements into a user scalable system by providing technical design, based on which robust solutions had been developed, tested and deployed into production farm.
• Build Custom solutions using VS 2012 and setup business process with SharePoint designer workflow interface.

Environment: SP 2010, VS 2013, InfoPath, Sql server 2008/2012, SP Designer, JS/jQuery, WebAPI, C-sharp.Net, HTML5 and CSS3.

Confidential

BI/.Net Analyst Programmer

Responsibilities:

• Designed logical and physical database structure to facilitate analysis of data from both operational and Business perspectives.
• Wrote Stored Procedures and triggers to capture inserted, deleted and updated data from OLTP systems.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files.
• Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Involved in automation of Monthly reports through SSIS.
• Written Stored Procedures, Functions, Indexes, Triggers, Views, Sub-Queries, cursors, Joins (equi-join, non-equi join) and Worked with Reporting services like SSRS.

Environment: SQL Server 2008 R2, VS 2012, Wcf and BI Suite

Confidential

.Net Analyst Programmer

Responsibilities:

• Responsible for Analysis, Documentation, Design, Development, QA Deployment and Support
• Responsible for Production implementations and overall business support.
• Data entry, data auditing, creating reports & monitoring all data for accuracy.
• Write T - SQL scripts to manipulate data for data loads and extracts.
• Written Stored Procedures, Functions, Indexes, Triggers, Views, Sub-Queries, cursors, and Joins (equi-join, non-equi join).
• Worked with Reporting services like SSRS and produced different models of Crystal Reports.
• Used integration services like SSIS that can be used to perform a broad range of data migration tasks.
• Managed State Management that involve storing information either in the page or on the client computer and maintaining security features like Authentication and Authorization.
• Involved in designing, developing, and hosting of HLS (Home Loan System) web service using WCF which interact with multiple systems in Banking Domain.
• Involved in modification and extension of complete FraudBD system that designed using Spring/MVC Framework.

Environment: Visual Studio 2005, Asp.Net, Asp.Net MVC, Sql Server, WF, XML Web Services, HTML&Javascript