SUMMARY

• Total 10+ years of experience working as .NET Consultant/Tech Lead in IT industry. Successfully led and managed teams in both development & maintenance support projects across full software development life cycle (SDLC) phases with emphasis on Object oriented & Client/Server technologies.
• Extensive experience working in an agile environment utilizing a test driven development approach.
• Solid understanding of system configurations, software architectures, and deployment processes followed in Enterprise DEV / TEST / STAGE / PROD environments.
• Been Subject Matter Expert (SME) and supported Helpdesk tickets by resolving critical incidents, service requests, and RFCs raised by business users on Citrix hosted applications & SharePoint portals.
• Proven hands - on experience in design and development of C# windows applications, ASP.NET web applications, WCF, Web Services, Web APIs, SharePoint team sites, InfoPath forms, Workflows, BCS, Dashboards, Site brandings, Surveys, Wikis, Blogs, Newsfeeds, and Fast-search services.
• Extensively experience on SQL Server database design, database development & maintenance involving data modeling, ER diagrams, database backup/restores, performance monitoring, develop TSQL queries, stored procedures, triggers, cursors, SQL Jobs, SSIS packages, SSRS reports, SSAS cubes, etc. which are used in BI analytics/reporting.
• Good experience in discussing project plan, coordinate client calls/meetings, gather requirements, determine tasks, baseline schedules, identify resources, brainstorm design ideas, implement tasks, prepare test cases, perform testing, defect fixing, deliver results, and document solutions.
• Self-learner with excellent interpersonal and communication skills necessary to build connections.
• Always ready to explore new things & take up challenges with “can do” attitude.

TECHNICAL SKILLS

Programming Languages: Visual Studio 2010/2013, Eclipse IDE, C#/VB.NET, ASP.NET, ADO.NET, WCF, Web services, Restful Web APIs, Rally SDK, SOAP, JSON, XML, XSD, JQuery, AJAX, Angular JS, Node.JS, Bootstrap, HTML5, JavaScript, CSS, Delphi, C, C++, LINQ, PowerShell, T-SQL

Design Framework: MVC, Design Patterns, Enterprise Library, EF/ORM, NuGet Packages, Infragistics, Telerik, DevExpress, UITK toolkits

SharePoint Platform: SharePoint 2010/2013, SharePoint Designer, InfoPath, DocAve, BrightWork Project Management, PerformancePoint, Bamboo Solutions, Yammer

Database Systems: SQL Server 2008/2012, Oracle, DB2, Mongo DB, Excel, Access, etc

BI Analytics: SSIS, SSRS, SSAS, OBIEE, QlikView, Crystal Reports

Operating Systems: Windows 7/8, Linux, Mac OSX

Virtualization: VMWare Workstation, Citrix App-V

Miscellaneous: Microsoft Project Professional, Office Suite, WebEx, Lync, Visio, Erwin, ER Studio, UML, Toad, IIS, Active Directory, Tortoise SVN, TFS, VSS, GitHub, Resharper, LeanKit, Documentum, Gnosis, TeamForge, Jenkins, TDWS Scheduler, Rally, Anthill, SonarQube, SurveyGizmo

Testing/Other Services: HP Service Manager, HP ALM, HP Quality Center, Selenium, NUnit

PROFESSIONAL EXPERIENCE

Confidential, Waltham, MA

Senior Consultant (.NET, SharePoint, SQL Server, and DW/BI)

Responsibilities:

• Participated in PEAR All-hands meets, Red/Blue team sprint review, sprint planning & commitment, and backlog refinement meetings conducted between teams. Completed all ALM and OSAM sprinting trainings from LearnSource system.
• Followed agile processes with rally dashboard - review backlogs, sprint planning, sizing of defects and user stories, adding tasks with estimates, status reporting, and track closures.
• Performed technical code analysis on Project tracker, Program tracker, and Product line modules within S&T Report Portal application and promptly fixed L3/L2 escalated support logs, service requests, and rally defects. Status reported to scrum managers during Maint defect triage calls & discussed blocking issues during Tech calls for team assistance.
• Debugged rally ETL source codes written as C# console application whenever failure notifications are sent to perform either full drop and load (or) delta load for specific project tracker ids failed. Likewise debugged & fixed Test Automation & Sonar ETL codes for few OCD dashboard related defects.
• Closely worked with Solution Architect for technical touch base. Modified daily-run SSIS packages which loads dimension & fact tables with data from PEARlive to PEARmart databases. Also some MBO reports, program reports, project reports, and leadership dashboard reports built in SSRS.
• Uploaded PLM monthly report data received into Prod databases and emailed output excel generated to Reporting Services. Followed same process for ODM ALM feed files data upload.
• Monitored change & incident management queues in HP Service Manager to acknowledge critical tickets before any escalations. Also submitted new CI tickets to DBAs for deploying DB scripts.
• Supported all sprint milestone/release deployment activities. Coordinated with scrum masters, managers, developers, and QAs from Red/Blue/Maintenance teams to setup calendar appointments.
• Suggested automation intake ideas on Product line & Program tracker modules for QA testing.
• Used SVN for efficiently managing trunk & branch source code versions with the Dev team.

Environment: Visual Studio 2012/2010, .NET Framework 4.5, C#, ASP.NET MVC, Enterprise Library, Web APIs, Web Services, UITK 3.6, Angular JS, Rally, Rally APIs, Rally SDK, Highcharts, Java Eclipse, Node.JS, JSON, HTML, JavaScript, AJAX, CSS, DOM, LINQ, EF/ORM, SQL Server 2012, SSMS, SSIS, SSRS, SSAS, TWS Scheduler, Tortoise SVN, GitHub, Anthill, SonarQube, SurveyGizmo, HP Service Manager, HP ALM

Confidential, Groton, CT

Technology Lead (.NET, Java, SharePoint, and SQL Server)

Responsibilities:

• Gathered & analyzed on PUP module requirements from AELN team. Interacted directly to Confidential CRD research scientists in lab environments. Completed all prerequisite trainings from Power2Learn to obtain access to AELN user interfaces.
• Did code analysis of AELN features & PUP forms built with C# and Python languages. Rewritten database call routines with minimal connections for performance tuning. Documented design changes implemented and shared with Confidential senior manager.
• Built common search utility control that will query vault workspace based upon filter inputs and retrieve user profiles metadata faster for binding to listing grid. Implemented auto filter feature on grid header columns and status strip with Reload & Show All links on bottom.
• Prototyped new UI design layouts for PUP module screens and tested all functional implementations. Built group edit feature for user profiles and metadata by means of popup dialog containing cascaded dropdowns dynamically loaded based on XML data hierarchies.
• Created right click menu on listing grid with Edit User(s) and Export to Excel option functionalities.
• Attended status calls & meetings with Confidential senior manager to discuss ongoing tasks, pending items, and baseline schedules. Used WebEx to present work deliverables to AELN team.
• Prepared test cases for all functional modules and updated with obtained actuals Vs expected results.

Environment: Visual Studio 2013, .NET Framework 4.5, C#, CSS, XML, IronPython2.7.4, Python for VS2013, Reflector, SQL Server 2008, Accelyrs ELNV6.9, Pipeline PilotV6.63

Confidential

Responsibilities:

• Discuss & understand ANPD business user requirements. Worked with Confidential manager to translate business requirements into development tasks/activities managed within TeamForge system.
• Attended calls & meetings to discuss project plan, clarify doubts, allocate tasks, schedule timelines, track progress, and status report to Confidential manager.
• Brainstormed UI design layouts and created prototypes for ANPD webpages. Used WebEx meetings to present UI prototypes with product owners for any comments or suggestions.
• Following design document steps, developed PD Trends review module functionalities using ASP.NET language. Used AJAX and JQuery controls to asynchronously perform review confirmation, log issues/actions in studies, and add/remove comparison studies.
• Integrated TIBCO API reports inside iframes for displaying/refreshing comparison reports.
• Created new stored procedures, tables, and views. Worked on migrating Clinical Data Trials (data structures) from disparate sources such as Icon, Parexel, and Oracle into ANPD tables.
• Performed SharePoint document management by moving contents across site libraries.
• Closed all system testing defects raised by QA team in HP Quality Center.

Environment: Visual Studio 2010, .NET Framework 4.0, ASP.NET, IIS, JavaScript, JQuery, CSS, AJAX, SharePoint 2010, SQL Server 2008, Oracle, Toad, TIBCO APIs, HP QualityCenter, TeamForge, VSS

Confidential

Responsibilities:

• Meet with Confidential manager to discuss and understand this project requirements.
• Followed the product installation guide step-by-step to trial hosting AspenTech products into Citrix environment using App-V5 imaging, configure network licenses, and register/restore remote databases with Aspen Properties Database Manager.
• Interacted closely with Confidential DBAs & APP-V specialists to perform database backup/restore activities, reset server account passwords, and host product files into Citrix App-V farm environment.
• Raised incident tickets to AspenTech Support Center for technical assistance on installation problems. Did follow-up calls to ensure tickets get closed with appropriate resolution.
• Prepared test cases for above installation steps and uploaded into MySignatureBook system for approval.

Environment: SQL Server 2008, CitrixV6.5, App-V5, AspenV8.7, Sentinel RMS License Management Software V8.5.5, Sentinel HASP/LDK License Management Software V6.63, Gnosis, MySignatureBook

Confidential

Responsibilities:

• Attended EASA KT sessions from Dev team and completed prerequisite trainings from Power2Learn to obtain access to DEV, TEST, and PROD environments.
• Prepared the list of 40+ EASA applications to be modified for CPPD usage metrics addition and documented the steps after trialing the implementation in DEV and TEST environments.
• Implemented database log routines for all above listed applications so that user activities can be audited from backend tables by querying or reporting. Used WebEx to demo changes to Dev team.
• Prepared test cases for the above implementation. Ran system test scripts to verify that code changes are working as expected post deployment.
• Reviewed and digitally approved project documents in MySignatureBook system.

Environment: EASA Client 4.3.2, EASA Builder, Gnosis, MySignatureBook

Confidential, Mansfield, MA

Principal Consultant (SharePoint, SQL Server, and DW/BI)

Responsibilities:

• Gathered & documented SharePoint team site requirements from Business Intelligence COE team.
• Performed site branding activities to create new theme, custom page layouts, master page, CSS, and images using SharePoint Designer & Photoshop.
• Consulted with Solutions Architect for design suggestions & status reported on an ongoing basis.
• Created EIM SharePoint team site which encompasses MDM, Data Warehousing, ETL, and Enterprise BI Analytics groups and their roadmap activities planned for business transformation.
• Renewed MDM system diagrams using MS Visio and included in SharePoint team site.

Environment: SharePoint 2010, SharePoint Designer 2010, InfoPath 2010, Visual Studio 2010, .NET Framework 4.0, SQL Server 2008, BI tools, Tableau, Cognos, OBIEE, Access, Visio, Photoshop, Prezi

Confidential, Gaithersburg, MD

Technology Specialist (SharePoint, InfoPath, SQL Server, and Oracle)

Responsibilities:

• Been onsite technical lead for SharePoint intranet portal used by Confidential employees worldwide.
• Handled Confidential Helpdesk support activities for SharePoint portal involving critical incidents, service requests, and RFCs raised by user groups. Also managed dev team of 4+ people to work on application enhancements.
• Responsible for doing call follow-ups to better understand ticket needs and provide resolutions promptly before escalations or SLA violations. Interacted with IT Director for critical incident tickets.
• Gathered the requirements & created SharePoint team sites for two departments (R&D and COE) with custom site themes, master page, page layouts, yammer newsfeeds, etc.
• Managed ACL access permissions for several departmental sites, configure alert notifications for SharePoint lists/libraries events, and assisted users in setting up SharePoint Workspace for offline editing and sync up later.
• Coordinated on automating paper-based approval processes (On-boarding, Glossary terms, etc) using InfoPath designer forms attached with workflow logics.
• Administered SharePoint User Profile crawl services for incremental active directory sync ups.
• Monitored SharePoint Health Analyzer & event logs to debug and resolve critical system issues faced in DEV, QAS, and PROD environments. Did backup/restore of SharePoint content databases.
• Wrote PowerShell scripts for migrating SharePoint lists & libraries contents across deep dive archives.

Environment: SharePoint 2010, SharePoint Designer 2010, InfoPath 2010, BrightWork Project Management, KnowledgeLake ECM, AvePoint DocAve V6, Visual Studio 2010, .NET Framework 4.0, SQL Server 2008, Access 2010, PowerShell, TFS, ServiceNow

Confidential, Shelton, CT

Technology Lead (SharePoint, .NET, SQL Server, and DW/BI)

Responsibilities:

• Been subject matter expert (SME) for all in-house billing applications used by Confidential business. And onsite lead/coordinator for a Dev team of 4+ developers.
• Independently handled IT Helpdesk support activities of billing operations happening for customer accounts across North-East (NE) service regions during monthly, weekly, and daily billing cycles. Status reported directly to Confidential billing managers and attended calls with Dev team.
• Participated in Confidential IT meetings conducted to brainstorm value-add ideas. Volunteered to integrate Google Analytics web tool inside Confidential ’s public facing website & iRecycle SharePoint portal thereby enabling Confidential IT managers to perform their traffic and Adword analysis. Implemented search engine optimization techniques to improve Google ranks of Confidential website.
• Coordinated for iRecycle SharePoint portal migration activities from . Helped hosting several service applications (user management, e-invoices, pickup requests, barcode authorization/de-authorization requests, etc.) as sub sites within iRecycle dashboard portal.
• Implemented C# code-behinds to automate rendering of E-billing reports to shared paths as PDF files. Code reviewed and tested Confidential mobile app features to find functional bugs.
• Performed database backup, database restore, table schema design, configure linked servers, configure database replication, alter SQL Jobs, and T-SQL queries. Created SSIS packages for integrating data from different Confidential billing systems. Custom built SSRS reports to help billing supervisors.
• Did thorough system testing before application enhancement rollouts. Performed code analysis and debugging to provide quick fix resolutions for urgent tickets raised by billing supervisors.

Environment: SharePoint 2010, SharePoint Designer 2010, Bamboo Solutions, Visual Studio 2008, .NET Framework 3.5, C#, Delphi, ASP.NET MVC, WPF, ADO.NET, EF/ORM, WCF, Web Services, Windows Services, JavaScript, JQuery, CSS, XML, Java Eclipse, Android SDK, Enterprise Library, Infragistics, SQL Server 2008, SSMS, SSIS, SSRS, SSAS, TFS, VSS, ServiceNow

Confidential

Responsibilities:

• Analyzed & understood SharePoint portal requirement specifications shared by client manager.
• Been technical lead for a team of 4 developers. Status reported directly to project manager.
• Attended SharePoint trainings and setup development environment. Worked with SharePoint technical architect to prepare detailed design of sites, features, page layouts, UML diagrams, etc.
• Successfully created SharePoint iRecycle portal with FBA login authentication using ASP.NET membership provider and hosted in DMZ environment.
• Helped Dev team in the creation of custom master page, page layouts, CSS themes, site branding, and template deployment. Used SharePoint Designer for making layout changes and email workflow notifications for SharePoint lists and libraries events.
• Implemented Manage Users module that allows creating, editing, and viewing list of users. Worked on SharePoint web parts, features, ACL permissions of lists & libraries, target audiences to control visibility settings, user profile replication between SSPs, and deployment solution packaging.
• Helped in system testing & deploying SharePoint solutions built into PROD environment.

Environment: SharePoint 2007, SharePoint Designer 2007, Bamboo Solutions, InfoPath 2007, CAML Query Builder, Visual Studio 2008, .NET Framework 3.5, C#, ASP.NET, ADO.NET, WCF, JavaScript, JQuery, CSS, XML, SQL Server 2008, SSMS, VSS

Confidential

Responsibilities:

• Involved in requirement analysis & design of UI prototypes using Infragistics toolkits.
• Prepared detailed design document for user interfaces and databases of MIBS application. Created class diagrams, use case diagrams, activity flow diagrams, and ER diagrams with UML modeling.
• Built 3-tier .NET windows application framework for doing development. Used MVC pattern for GUI navigation, Enterprise library for custom error handling in try-catch, and WCF interfaces to make distributed service calls with backend tables.
• Implemented the core functionality of uploading billing data from machine files and validating them before invoicing process in C#. Used asynchronous method calls for this.
• Wrote stored procedures to load those machine files data in XML format into database tables. Utilized SQL Jobs to automate validation steps for exception generation and schedule to run daily midnight.
• Created SSIS package that archives invoicing data into data mart for cube analytics and reporting.
• Helped team in creating SSRS custom reports that display credits billed and remaining for several combinations of account, branch, business region, etc.
• Performed code review and ensured .NET best practice & standards are adhered.
• Conducted CC audits to verify that functionalities are consistent with the requirement specifications.

Environment: Visual Studio 2008, .NET Framework 3.5, C#, ADO.NET, EF/ORM, WCF, Web Services, XML, CSS, Enterprise Library, Infragistics, SQL Server 2008, SSIS, SSRS, VSS

Confidential

Responsibilities:

• Did requirement analysis to ensure end-to-end field level traceability exists for each requirement item.
• Coordinated with technical architects & prepared datamart design for fact and dimension tables using star schema approach.
• Created SSIS packages to incrementally load TPI purchase & billing data into fact and dimension tables using Slowly Changing Dimension (SCD) components.
• Assisted onsite lead in modifying existing SSAS multi-dimensional cubes to in corporate new measures, dimension hierarchies, KPIs, partitions, perspectives, translations, and so on.
• Configured SSIS packages to use xml config files for storing connection strings & variables.
• Implemented custom error handling mechanism to log inconsistent data errors & ease troubleshooting.
• Conducted CC audits for compliance & SSIS training sessions (with demos) for knowledge sharing.

Environment: SQL Server 2005, SSIS, SSRS, SSAS, DTS

Confidential

Responsibilities:

• Analyzed the requirement specifications and prepared the database design document for BAM project.
• Separated all master data screens from E-Billing and built as Master Data Management (MDM) system using .NET framework with Delphi UI components.
• Wrote C# code-behinds to perform both authorization and de-authorization functionality of barcodes. Implemented all layers from backend stored procedures, data access layers, business façade layers, web service methods, till presentation layer screens of BAM application designed using .NET MVC framework & Infragistics components. Used C# delegates to make seamless asynchronous calls.
• Helped in developing windows services that will upload RVM machine files data into SQL tables for validation job.
• Worked on SQL Jobs, stored procedures, functions, table schemas, synonyms, indexes, triggers, SQL scripts, XML data, XSD schemas, etc. Modified dynamic queries used in stored procedures to create SQL Job steps on-the-fly and perform barcode validations before bridging them for invoicing.
• Configured transactional replication from MDM to BAM system databases. Used Service Broker feature to enable distributed 2-way messaging between SQL databases.
• Created SSIS packages to bridge barcode authorization data from legacy AS400 to new BAM system.
• Created SSRS reports to compare validated and missed units across Confidential branches & billing cycles.
• Played CC role and conducted configuration compliance audits.

Environment: Visual Studio 2005, .NET Framework 2.0, C#, Delphi MVC, ADO.NET, EF/ORM, Web services, XML, XSD, CSS, Enterprise Library, Infragistics, AS400, SQL Server 2005, SSIS, SSRS, VSS

Confidential

Responsibilities:

• Attended client calls to discuss business requirements and clarify doubts.
• Did requirement analysis. Prepared high level design and detailed level design documents.
• Created prototypes of user interface screens in Delphi for client demo and approval.
• Re-engineered the existing 3-tier E-Billing .NET application source codes written in Delphi MVC framework model to support Confidential conventional branches and services. This involved making changes to existing user interfaces, web services, database calls, exception loggings, backend tables, views, triggers, cursors, stored procedures, and functions.
• Maintained the source codes for Confidential Security framework application which controls the role permissions assigned to all in-house application users.
• Modified Account Receivables - Account Payables (ARAP) batch creation stored procedures to support Confidential conventional branches and verified that invoice totals match between expected Vs actuals. Used SQL Profiler to trace database calls made.
• Created SSIS package to migrate material handling pickup data from MHS to E-Billing system tables.

Environment: Visual Studio 2005, .NET Framework 2.0, C#, Delphi MVC, ADO.NET, EF/ORM, Web services, XML, CSS, Enterprise library, Infragistics, SQL Server 2005, SQL Profiler, SSIS, SSRS, VSS