.Net Web Developer

Ajay Singh

.Net Developer / Architect - C*C

Fort Worth, TX

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

Ph. 817-***-****

SUMMARY

I have more than 10 years of IT experience as Sr. Application and Reporting Expert, which includes Development, Administration and Project Analysis and more than 5 years in Web site / Portal development using .Net Framework. Proficient at managing and leading team for running successful projects and experience of developing procedures and modules. Devise and implement distribution and quality plans resulting in enhancement of project accuracy.

SKILLS

Knowledge on ASP.NET MVC (Design Pattern), Razor View engine, Entity Framework (Object-Relational Mapping), JQuery, Web Services (SOAP, XML), WCF, LINQ.

Hands on experience on developing web application using ASP.NET, C#, ADO.NET, HTML, CSS, SQL Server.

C#, ASP.net / Oracle, SQL Server – Worked on several internal and external portals for client, such as Merck Grants(Enhancement on sever modules), EMS (Employee management System), ITRS (IT ticket requesting system) etc.

Experience in Multi-Tier web development using agile methodologies.

SQL Server Management Studio – Used Query Optimization for better performance. Also used as a backend for most of the portals.

Hands on experience on Team Foundation Server, Visual Source Safe.

SharePoint 2013 – BI Services, Stretched Farm, Administration. Server migration SharePoint 2010 to 2013.

Crystal Reports Enterprise XI R2 – Involved in administration and Crystal Enterprise Server management. Also used InfoView, Central Management Console, Business View Manager, Central Configuration Manager and Instance Manager.

Manage company analysis in both quantitative and qualitative forms such as databases, models and presentations, reports and taking responsibility for their production to publishable standards.

Liaising with the Clients / OPs Team to manage the development of the reports delivery.

Utilizing strong overview knowledge of the process in order to guide the Team’s output and knowledge development.

Using Microsoft Office Tools including Excel, Word, and PowerPoint in order to prepare presentations for training / team utilization / higher management.

Leading the teams’ interactions with both internal and external clients.

ACCOLADES

Received Appreciation for successfully completion of assigned module of a client project named “Merck Grants”.

Received several appreciations for successful implementation and migration of Sharepoint 2013 Portal for the company. (learnt and implemented everything during migration)

Received first “Employee of the Month” for outstanding performance for the month of April 2005, C3i Support Services.

Received “Employee of the Month” for outstanding performance for the month of June 2005.

Due to consistent performance, was recognized with “Presidents Award” in C3i for 2nd Quarter 2005.

EDUCATION

MCA From Vinayak Mission Research Foundation Deemed University, Chennai, India.

Bachelor of Commerce from Tilka Manjhi Bhagalpur University, Bhagalpur, India.

EXPERIENCE

Sr. Application and Reporting Expert (various positions held)

C3i HealthCare Connections

January 2005 – March 2016

WORK HISTORY

C3i HealthCare Connections May 2013 – March 2016

Sr. Application and Reporting Expert / Architect

May 2013 – March 2016

Merck Grants - Worked on enhancement of several modules, such as - LOA (Letter of Agreement) to be signed by the end user electronically with DocuSign (Using ASP.net, C#, JQuery, Oracle, Toad)

oChanges were to add a form to 1. Collect the “Authorized Approver” information during RFA submission and then 2. Displaying “Authorized Approve” on RFA Details page.

oAllow for TOV (Transfer of Value) data to be captured before and during the grant process. Process starts with sending an automated email to Grant Contact with direct link to auto login and allow data entry for TOV.

ITRS (Ticketing Requesting System) web portal – Maintenance and enhancement as and when request comes (Using ASP.net, C#, JQuery, SQL Server).

oThis is an internal ticket requesting system, where all employees has access to and submit an ITRS selecting appropriate Category, which triggers an email to the concern team and then they act accordingly.

Worked as a Architect and involved in design / development / Maintenance for Employee management System (web portal) (using ASP.net, C#, JQuery, SQL Server). I was involved in gathering information, designing and development, preparing HLD for users, LLD for documenting changed to the application, and UTP documents for test cases. Below are the modules with descriptions.

oEMS – Module includes.

Administration – this contains, Environmental Rules for leave combination restriction through application. Employee Profiler for Inserting and maintaining employee details. Carry Balances is for pushing all the leave balances for next year. Holiday Balancing, balance off for Indian Leaves with US lease. Announcement for making an announcement for all the application users. Access, User details those who have access to EMS.

AMS – E-Roster, is the section where attendance are marked for each department. And the report links are for provided different HR specific reports.

PMS – Section is for department wise Performance management which helps manager to filter out good performers and for grading them for their bonus calculations.

Working on several Client web portals (such as, XBiotech, Merck, Novonordisk etc.) as per the requirement (Using ASP.net, C#, JQuery, SQL Server, Web Services, WCF).

SharePoint Related Projects –

oMigrated SharePoint 2010 (existing portal) to SharePoint 2013

oConfiguration and Administration for Company portal.

oStretched Farm Installation and Configuration.

This includes two app, web and DB servers.

Web server – the server that serves web pages to end users.

App server - the server that runs SharePoint services

DB Server - the server that runs SQL Server

oWorkflow Configuration.

oBI (Business Intelligence) Environment setup which includes

Configuring Unattended Account.

Excel services

Visio Services

Performance Point

Installation and configuration Reporting Services

Installation and configuration PowerPivot.

oTransition on Internal SharePoint servers and client portal for new hires

Sr. Client Reporting Data Expert

May 2012 – May 2013

Manage report requests assigned Via internal “IT Request System”.

Maintain documentation library of the code used to develop Crystal Reports

Provide ongoing support, training and mentorship to back office report development team on Crystal Reports and SQL programming.

Gather requirements from Ops and Client teams for enhancing applications.

Analyst - Development and Analytics

June 2011 – May 2012

Manage report requests assigned Via internal “IT Request System”.

Responsible for the development of all new Clinical, Horizon Call Center, Service Ware and Aporopos Crystal Reports.

Maintain documentation library of the code used to develop Crystal reports.

Gather requirements from Ops and Client teams for enhancing applications.

Participate in identifying new ways to automate reporting processes for time saving, accuracy, and cost reductions.

Analyst - Development and Analytics

June 2008 – June 2011

Manage report requests created in Lotus Notes ticket application.

Point of contact for C3i’s Operations Teams for the development and documentation of end user report requirements (both new and existing).

Develop and troubleshoot macros, coding and automating report templates requested by C3i clients or internal Operations (Crystal Reports, SQL Server, MS Access).

Maintain and enhance custom tools (eHOC application and back end database, QC Tool)

Provide ongoing support, training and mentorship to Back Office report development team on Crystal Reports and SQL programming.

Gather requirements from Ops and Client teams for enhancing applications (Grant Training Tracker)

Participate in identifying new ways to automate reporting processes for time saving, accuracy and cost reductions.

Sr. Developer Analytics

January 2006 – June 2008

Develop, implement, troubleshoot, enhance and provide post-production support on applications, packages, report templates, Excel Macros & MS Access programming.

Create all process/ systems and technical documentation for in-house/ third party tools and packages being used.

Provide solutions on scalability, concurrency and availability challenges.

Develop and troubleshoot macros, coding and automating report templates, maintaining a documentation library of the code/ logic used, maintaining and enhancing custom tools (eHOC application, SQL Server and MS Access back end database, QC Tool etc).

Administration of SQL Server, MS Access, Crystal Reports, in-house applications

Provide support on AMS, Tech Scorecard, Grading Tool, Bonus Payout Tool, solve issues related to scalability, concurrency and availability.

Provide training to the user base on functionality of these tools – technician specs documentation.

Gather requirements from Ops and Client teams for enhancing applications

Crystal Report Specialist

January 2005 – January 2006

Build dynamic crystal reports report prototypes from client business and functional requirements, sample design templates, and QA MS Access database data sets.

Maintain and/or troubleshoot existing reports.

Build ad-hoc queries from client business requirements.

Build ad-hoc internal support queries to record report generation timing, duration, and frequency statistics.

Build front-end Crystal Lite Web-page reports dashboard to allow the user to:

Select a report from among cmsholding extract, horizonP, or ServicewareP database report list.

PHP Programmer

Net Solutions India March 2004 – January 2005

Gather requirements from clients for given module.

Maintain existing WebPages as requests comes from the Project manager.

Create/Add CMS (Content Management System) into the admin section for the websites. (Using PHP, MySQL, JavaScript, PostgreSQL).

Worked on several client websites (Using PHP, JavaScript, AdobePhotoshop, Postgre)

owebdesigners.net.au - This was for Resellers & Affiliates for their dedicated hosting services, provides domains, and Find the designer to suit for company requirements needs. Used pgAdmin for postgre database maintenance, this includes function, tables etc.

Add Payment Gateway systems to the websites.

Contact this candidate