Experience Summary

• About eleven 11 years of professional experience in analysis, design, development and implementation in Microsoft technologies like SharePoint Portal Server, Microsoft Office 2013/2010/2007/Office 365, Windows Azure, SQL Azure, Visual Studio .Net, VB.Net, ASP.Net, C, MVC, Silverlight, JQuery, HTML, ADO.Net, ASP, VB 6.0, SQL Server etc.
• About 7 years of experience with SharePoint 2013/2010/2007/Office 365, Windows SharePoint Services WSS 2.0/3.0 installation, configuration development with a good understanding of the architectural and infrastructure aspects of SharePoint platform.
• 10 years in Database Design, Data Manipulation Querying and Reporting on Relational as well as multidimensional databases, Data Integration and Database Administration.
• Experience in delivering Microsoft Office SharePoint Server 2013/2010/2007 and Windows SharePoint Services 3.0 WSS enterprise solutions including: Collaboration, Portal, Search, Content Management, and Business Processes features.
• Experience with SharePoint WebPart Development using .Net technologies: ASP.NET, C .
• Experience in office tools Windows Server components such as SharePoint Designer 2013/2010/2007, Infopath 2013/2010/2007, Active Directory and Microsoft Exchange.
• Substantial experience in developing several dashboards using SharePoint 2013/2010/2007/Office 365.
• Substantial experience in migration from SharePoint 2007 to SharePoint 2010, from SharePoint 2010 to SharePoint Online Office 365.
• Experience in Design and Implementation of WCF services layer hosted on Windows Azure.
• Strong Understanding of N - Tier Web Architecture, Microsoft .NET Architecture and ASP.NET Platform
• Expertise in managing projects from inception stage, implementing project specific processes to quality standards.
• Architecture and design review, review of all system design documents, technical manuals, reference manuals.
• Excellent written, oral communication and inter-personal skills. Ability to address, analyse and resolve diverse and complex issues pertaining to development team. Fast learning curve on new domain and business processes.
• Substantial experience in various industry verticals such as Finance, Healthcare, Insurance, Pharmaceutical, Information Technology, etc

Summary of Technical Skills

• Application Languages Visual Studio .Net, ASP.NET, C, VB.NET, ADO.NET, MVC, VBA.
• Web Technology Web Services, Remoting, HTML, VB Script, JavaScript, ASP, CAML, AJAX, JQuery.
• Server Microsoft Office Sharepoint Server 2013/2010/2007/Office 365, Microsoft Office SharePoint Designer 2010/2007, Internet Information Server IIS, Windows Server 2008 Enterprise
• Office Tools Microsoft Office InfoPath 2010/2007
• Database SQL Server 2012/2008/2005/2000, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services , Oracle, MS-Access, SQL Azure

PROFESSIONAL EXPERIENCE

Confidential

Senior SharePoint BI Technical Architect Developer

Environment: Microsoft SharePoint 2013/2010, Microsoft Project Server 2013/2010, Visual Studio 2013/2012, SQL Server 2014/2012, SQL Server Analysis Services 2014/2012, SQL Server Reporting Services 2014/2012, SQL Server Integration Services2014/2012, SQL Server Master Data Services 2012, Performance Point, Power View, PowerPivot, SharePoint Designer, Microsoft Silverlight 4 5, Windows Server 2008 R2, Windows 2012 Server, FusionCharts, HTML5

Responsibilities

• Migration of SharePoint Farm including Content Databases, Service Applications Excel Services, Visio Services, PowerPivot, PowerView, Reporting Services, Project Server and custom user solutions from SharePoint 2010 to SharePoint 2013.
• Install Configure SharePoint Larger Farm 16 Servers, Microsoft BI Stack Environment including SSRS for SharePoint, SSAS PowerPivot, SSAS. Tabular, Quest Webparts and Fusion Charts used for CISS.
• Install Configure SharePoint FAST Search Topology based on Microsoft Best Practices for medium Farm.
• Install Configure Microsoft Project Server to be used for managing Technical Business team tasks.
• Install Configure Team Foundation Server to host source code for CISS and Information Exchanges Framework.
• Install Configure Project Server extensions for Team Foundation Server.
• Develop websites using C SharePoint Project to display data from Project Server Reporting Database in user friendly manner such as Gantt Charts for Program Projects Timeline, Resource Capacity Reports with custom KPIs.
• Create PowerPivot Gallery and develop Excel Templates using Excel Services and PowerView.
• Create a Map Control web-part using two approaches: Silverlight Bing Map Control, HTML5 Google Map Control. This control is used to show the number of incidents arrest in different towns in Connecticut.
• Create Site Collections to be used by Technical Team Members for different purposes, help in decision making architecture of SharePoint Applications.
• Design Implement a Data-warehouse and an Analysis Services Cube to host Criminal Records Statistics for Analysis.
• Provide Guidance to Project Managers on building Project Plans and add custom fields in Project Server to aid creations of high-level reports.
• Provide Guidance to Technical Team on development of SharePoint based Applications and help in making decision of which tools to be used to minimize development efforts.
• Administer SharePoint Farm s including Backups, Restores, Maintenance Tasks, High Availability and Help Desk 3rd level Support.

Confidential

Senior SharePoint BI Technical Architect Developer

• Environment: Microsoft SharePoint 2013/2010, Microsoft Project Server 2010, Visual Studio 2012, SQL Server 2012, SQL Server Analysis Services 2012, SQL Server Reporting Services 2012, SQL Server Integration Services 2012, SQL Server Master Data Services 2012, Performance Point, Power View, PowerPivot, SharePoint Designer, Microsoft Silverlight 4 5, Windows Server 2008 R2
• Project: Merck Business Intelligence Solutions: During this role, I worked in Merck Customer Services Group which provides BI solutions for Merck Manufacturing Group, Human Resources and Merck Finance. These solutions projects include:
• Merck IT Generic Scorecard System: Build a generic scorecard system that can be used by Merck IT to measure KPIs across generic time dimension Yearly, Quarterly, Monthly, etc for various business needs. The database model is generic to build multiple scorecards, define KPIs, rollup function for scores, measures, dimensions, generic security roles, groups and users for data entry and reporting. Data Model is implemented using SQL Server 2012, SQL Server Master Data Services 2012 and SQL Server Analysis Services 2012. Data entry screens are implemented using .NET SharePoint Custom Web-parts. Administration of master data is implemented using a Master Data Services Website. Reports are implemented using SQL Server Reporting Services 2012, Performance Point and .NET SharePoint Custom Web-parts. Reports retrieve data from an Analysis services Cube.
• Merck Expense Dashboard: This dashboard provides Merck Finance team with reports, graphs and KPIs that compare forecast spend versus actual spend for projects within all Merck sites world-wide. The forecast spend data is extracted from Microsoft Project Server 2010. The actual spend data is extracted from Merck SAP, excel sheets exported monthly to ftp server and other legacy data sources. The data is extracted and transformed using SQL Server Integration Services SSIS . During SSIS package, a multi-dimensional cube is generated for reporting purposes. Dashboards Reports are presented to users using Performance Point, SSRS, PowerView and hosted on SharePoint site.
• PowerPivot Gallery for HR SharePoint site: This gallery library is used by Merck Customer Services Group to create excel templates using PowerPivot and excel services. These templates are saved to PowerPivot Gallery on HR SharePoint site to be used by Power Users from Merck Human Resources as an example to create their own reports and graphs. These excel templates calculate Headcount, population, diversity distribution, hiring attritions using PowerPivot capabilities.
• Migration of Microsoft Access Databases to SharePoint: The goal of this project is to migrate tables stored on local Access files used by Merck Manufacturing group to SharePoint lists. Migrate access queries and macros to SharePoint solution packages hosted on SharePoint site. Data migrated to SharePoint can be easily used by manufacturing group to create dashboard reports and host them on SharePoint to be consumed by business users.
• Merck Inventory Tracking Dashboard: This dashboard provides Manufacturing group with KPIs to track Merck's inventory as well as its suppliers' inventories. The data is extracted from XML files and csv files saved on ftp sites using SSIS Package. The data is transformed and a multi-dimensional Inventory cube is built during SSIS package. The Inventory cube is used to create KPIs to track inventory using Performance Point and hosted on SharePoint site.

Responsibilities:

• Install SharePoint, Microsoft Stack Environment including SSRS for SharePoint, PowerPivot and Quest Webparts used for Merck BI Solutions.
• Requirements Analysis for Merck Expense Dashboard Project.
• Development of SSIS Package, dashboards and reports for Merck Expense Dashboard Project.
• Install PowerPivot for SharePoint and activate PowerPivot service application for HR SharePoint site.
• Create PowerPivot Gallery and develop Excel Templates using Excel Services and PowerView to be used by HR group.
• Create Data Connections library to host connections to different data sources like SQL Server, Oracle, Files stored on shared Drive and DB2. The connection library is shared for all power users to create reports using PowerPivot.
• Build Sharepoint custom web-parts to implement migrate business logic of MS Access Queries and Macros to SharePoint.
• Requirements Analysis for Merck Inventory Tracking Dashboard.
• Development of SSIS Package, dashboards and reports for Merck Inventory Tracking Dashboard.
• Requirements Analysis, Design, Implementation, Testing and Deployment of Merck IT Generic Scorecard System.

Confidential

SharePoint and Cloud Developer Windows Azure

• Environment: Microsoft SharePoint 2010, Microsoft SharePoint Online Office 365, SharePoint Designer,
• Windows Azure, SQL Azure, Microsoft Silverlight 4 5, Visual Studio 2010, SQL Server 2012,
• SQL Agent to sync data from SQL Server 2012 to SQL Azure.

Confidential

Education Dashboard is a website hosted on SharePoint Online Office 365 environment that provides high level reporting to School Directors to report on data related to School Productivity. It is a potential product that can be fully developed and customized upon need by Board of Education for different school districts. The data used is based on Top 10 Schools in each state of top 10 states in Race to Top States .

Confidential

• The scope of this project is to migrate CLG Connected Learning Gateway, a product developed by ITWorx Offshore team, from local environment Windows 2008 Server, SharePoint 2010, SQL Server 2010 to Cloud environment Windows Azure, SQL Azure, SharePoint Online Office 365 .
• CLG Connected Learning Gateway provides public and private K-12 education institutions with the latest teaching and learning tools, mobility tools and content-integration capabilities to create a unique and modern education experience for teachers, students and parents.

Responsibilities:

• Build a fully functional website for Education Analytics Product using SharePoint Online, Windows Azure, SQL Azure, Silverlight technologies.
• Collect data related to schools locations and productivity metrics for the schools that participated in Race to Top States in USA.
• Design and Implement Database Schema, Import Schools' data and build stored procedures on SQL Azure.
• Build DataSync job on Windows Azure to synchronize schools data from SQL 2012 databases to SQL Azure.
• Design and Implement WCF services layer hosted on Windows Azure. This layer is the middle tier between SQL Azure and SharePoint online external content.
• Create Cache Memory on Windows Azure to improve the performance of data transfer between SQL Azure and WCF services.
• Build Sharepoint web-parts and silverlight components for different dashboards. This includes: 1 Tabs Sub-Tabs for navigation through different school metrics. 2 Interactive Bing Map for schools with zooming drilling down functionalities. 3 Fish-bone diagram of pie charts with drill-down and drill up functionalities. 4 3D Charts that represent various school metrics with ability to drill down to detailed KPIs. 5 Hierarchical Tree Control to filter on State District School.
• Build InfoPath forms to administer schools hierarchy States District Schools and to manage data for Learning Productivity KPI's.
• Wrote documentation for the design of system architecture, security model, user guide, licensing, copyrights on cloud.
• Create Virtual Machines for Front-End Servers hosting SharePoint and Application, Backend Servers for Data Storage in SQL Server and Domain Controller Server.
• Create Images of Front-End Servers.
• Build scripts that automatically create a Front-End Server from desired Image and joining it to domain.
• Auto-Scaling Feature: Build scripts to Observe Performance Counters on Front-End Servers and trigger Server Creation Scripts based on work load Number of concurrent users .
• Create a Virtual Network on Windows Azure to connect all the servers.
• Migrate CLG from SharePoint 2010 to SharePoint Online Office 365.
• Build a presentation to present the design of hosting architecture on Windows Azure.

Confidential

Senior SharePoint Developer and Microsoft BI Developer

• Environment: Microsoft SharePoint 2007/2010, Metalogix Migration Manager for SharePoint, SharePoint
• Designer, SQL Server Reporting Services 2008, SQL Server Business Intelligence 2008,
• SQL Server Analysis services 2008 SSAS, SQL Server Integration services 2008 SSIS, ProClarity Analytics Server 6.3, Microsoft Performance Point 2007, ASP.Net, Windows Services, SQL Server 2000/2005/ 2008, BizTalk Server, Classic ASP, IPlanet workflow tools, Oracle 10G, Console Applications, ASP.Net 1.1 2.0 3.5 4.0, SQL Server, MVC, nHibernate, JQuery and JSON

Project-I: Otis Portal Redesign

The scope of this project focuses on two main goals. First goal is to migrate Otis Portal from SharePoint 2007 environment to SharePoint 2010 environment. The second goal is to build wireframes and web-parts to enhance the user experience for current Otis Portal hosted on SharePoint 2010. The wireframes target eliminating scroll bars and building personalized menus for users to navigate easily through Otis links by providing frequently accessed links on top of menu with ability to show all links.

Project-II: HR Legal Treasury Onsite Development and Infrastructure Support

UTC HR Legal BI Dashboards are presented through two SharePoint sites. Each site consists of multiple dashboards that read from a data-ware house database. Each data-ware house gets synchronized from source database using a SQL Server Integration Services package that runs overnight. Data and charts are hosted on ProClarity Analytics Server. The users can drill down from the charts on dashboards to detailed reports developed using SQL Server Reporting Services in Native Mode or maps developed using Dundas Maps. Treasury website is a SharePoint site that manages the content for UTC Treasury. Treasury reports are developed by Treasury IT using SQL Server Reporting Services in SharePoint Integrated Mode

Project: TripleA Support

The main objective of this project is to manage an offshore support team that supports multiple applications used across the different business units of UTC. The support help desk provides assistance to around 100,000 UTC employees all over the world. Supported projects are eCAR Electronic Capital Appropriation Request, SWFT Security Workflow Tool, Sabrix and Group Audit Tool

Project: Sarbanes Oxley Assessment Tools

The main objective is to implement web projects onsite to automate several processes related to the Sarbanes-Oxley Workflow. The application stores the information related to the workflow of assessing the financial, operational and compliance controls across almost all the business units of UTC and used by nearly 20,000 users overseas.

Confidential

Role: ASP.NET and SQL Server Developer

SOXA Reporting Module provides users with a wide variety of reports static reports, ad-hoc reports and dashboard and export files to excel, PDF related to the Sarbanes-Oxley Assessment Process. Reporting Data is extracted daily from the SOXA Accelerator Application using Data Transformation Package.

Key Responsibilities:

• Install frameworks, tools, application servers and database servers on all environments Development, Staging, and Production .
• Support the whole system by monitoring both the hardware and software performance alerts like: CPU Utilization, Memory Utilization, Disk Space, Services Running Status, Transactions Execution Time, etc.
• Develop alerting system for availability of Production Servers.
• Administer the Database Servers, handle backups, restores and performance tuning activities.
• Manage the resources that support the whole system and troubleshoot any bugs or issues related to the applications on production servers.
• Publish dashboards to SharePoint Site on Development, Staging and Production environments.
• Develop dashboards using Performance Point that display SSRS ProClarity reports.
• Develop reports using ProClarity and SSRS that queries data from cube.
• Build SSIS Package to fetch data from Oracle database, ftp site into SQL Server Database. Build data warehouse star schema on SQL Server. Process Multi-dimensional Cube on SSAS 2008.
• Build a presentation to present the wire-frames to Otis Communications department.
• Write documentation for the design of UI and web-parts.
• Build a web-part that displays news stories as thumb-nails which show a more zoomed detailed view of each news story by hovering mouse on thumb-nails. This web-part helps to get rid of scrolling that annoy the users in current Otis Portal.
• Build personalized cascaded menu web-part that memories the frequently accessed links by each user and displays them on load of menu. Menu has two modes: View Most Frequent Links and View All Links. In View All mode, deep levels in menu are organized in categories grouped in tabular panels, sorted alphabetically to help the users find the links easily.
• Present sketches to Otis Communications department to get their feedback approval on enhancements
• Manage Offshore Graphics team to build sketches that enhance user experience for current Otis Portal
• Analyze current Otis Portal and find drawbacks in user interface too much scrolling, inconsistency in navigation technique: Drop-downs vs. Cascaded Menus, difficulty to find desired menu items within long menus
• Migrate and modify a SharePoint Workflow used by Otis Employees to reserve laptops prior to their international travels.
• Migrate Otis site from SharePoint 2007 to SharePoint 2010 using Metalogix Migration Manager for SharePoint.
• Enterprise content management for news, announcements, documents, calendars, blogs, surveys, lists, videos.
• Setting expiration date for news stories on publishing becomes no longer available after 3 months and moves to archived news list .
• Security management: Creation and maintenance of SharePoint groups and Users. Assigning privileges to groups and ensuring that appropriate groups have access to various content Web Pages, Documents, Blogs, Surveys, Discussion boards, Calendars
• Deployment of SharePoint Packages Solutions. Activation of site collection features.
• Adding custom webParts to webpages.
• Installing SQL Server Reporting Services in SharePoint Integrated Mode and configuring SharePoint to connect to Report Server.
• Creation of SQL Server Reporting Services reports hosted on SharePoint.
• Manage developers that support these projects and troubleshoot any bugs related to the applications on production servers.
• Design better algorithms to enhance the performance of the data import jobs.
• Perform Database Performance Tuning Tasks.
• Schedule meetings with UTC business unit leads to gather their requirements business needs.
• Design Prototypes Proposals for new web projects to automate several work processes related to the Sarbanes-Oxley Workflow.
• Prepare the estimates time and cost and project plan timeline schedules, deliverables
• Create the requirements, design and test cases documents for the proposed web projects.
• Develop the whole web projects for Projects 2, 3, 4, 5, 7, 8, 9 mentioned above .
• Send the requirements documents to an offshore team for development for Projects 1, 6 mentioned above and follow-up with the offshore Project Leader to monitor the progress of the project.
• Administer SourceSafe, Database Servers, handle backups and restores.
• Perform Unit Testing on each component Load Stress Testing Integration Testing between different modules.
• Package the software projects after being developed tested.
• Deploy the builds of the application on the Testing, Staging, and Production Database Web Servers.
• Support the whole system by monitoring both the hardware and software performance alerts like: CPU Utilization, Memory Utilization, Disk Space, Services Running Status, Transactions Execution Time, etc.
• Track any bugs or issues related to the application through help desk software.
• Perform Database Performance Tuning Tasks and Database Migration from SQL Server 2000 to 2005 to 2008.
• Application Migration from .NET Framework 1.0 to 2.0 to 3.0 to 3.5 to 4.0.
• Create the design and deployment documents.
• Design and implement several modules such as: static reports, custom ad-hoc reports, Data Transformation Services Package, Dashboard, Administration, Export and logging.
• Package and Deploy the application to the Configuration Management Officer.
• Administer SourceSafe, Database Servers and handle backups and restores.

Confidential

Software Engineer

Environment: Java, JSP, Beans, ANT, Oracle, ASP.Net, Element tool.

Responsibilities:

• Update the searching functionality and Article Management Module used to add the articles into a publication.
• Package the Java Class files using ANT technology to create JAR files.
• Design and implement the QSR, Workers' Compensation, endorsements and cancellation processes of the workflow.
• Develop the commission and location reports.
• Export the insurance application form into PDF format.
• Update the notification engine, workflow engine and existing User Interface screens.