Application Management Resume Profile
UsA
Objective:
Opportunity that utilizes my experience in software design, development and project//team management
Skill Set
Management | Business Process Management, Strong Leadership skills, Scrum, Agile Software Development, Resource Allocations, Project Management, Project Deployment, Efficiency Analysis. |
Enterprise Data | MS SQL Server 2012, 2008 R2 , IBM DB2, Oracle 11i, SQLBase, ESSBASE Warehouse Design, End-to-end ETL, Reporting, OLAP, Power Pivot, Power View |
Technologies | SiteCore 7 , .NET 4.5, MOSS2007, SharePoint 2010, SharePoint 2013, MDX, DMX, SSRS, SSAS, SSIS, WCF, WF, SOAP, REST, XSLT, MVC 4, Blackberry, Android, AZURE Microsoft , AWS Amazon |
Certified SiteCore Developer.
Summary
I have over 20 years of Software development experience utilizing mostly Microsoft product line. During last 10 years I provided architectural services to number of companies and helped them delivering software on time and within budget.
Cloud solutions | Developed and migrated several MVC application from on-prem to hybrid cloud environment Azure and Amazon AWS Developed several SharePoint apps for Office 365 SharePoint hosted and Cloud Hosted Developed custom BI solutions using Amazon RedShift and oData. |
SiteCore | Developed custom reporting based on Engagement Analytics API. Led implementation of the Site Core based MVC E-commerce site for a Fortune client. |
Combining BI and SharePoint | Prototyped and implemented different options of using BI with SharePoint portal: straight SSRS, Excel Services Power Pivot and Performance Point. Helped the client to make informative decision. |
SharePoint Infrastructure | Designed and managed infrastructure implementation of several medium size farms. Developed and implemented performance testing and testing results analyses. In all cases following SharePoint solution turned out to be more scalable then was estimates. |
SharePoint High Availability and Disaster Recovery | Designed solutions for synchronizing SharePoint farms solution deployment, 12-hive, web.config and IIS settings . |
SharePoint Web Content Management | Designed and implemented few web content management system. The largest one currently contains 197 sites with 300,000 unique visits per day. Designed and developed automated provisioning and deployment system. Using this system none technical administrator can provision the site and deploy content in few minutes. In comparison 3-d party product that manages content deployment would've cost over 50K. |
Multiple SharePoint solutions | Custom Form Application. Designed data form generation and capturing application using SharePoint native facilities and custom Workflow. Application supported Green initiative and saved over 500K comparing to the option of using InfoPath. Designed and developed Document Management system for Board of directors. Application allowed handling sensitive materials and is currently being used by not very technical users. It significantly helped the company in maintaining image of being innovative and high tech. Designed Document Management system for paperless office. The system managed document routing custom workflows , security trimmed UI and search capabilities of SharePoint. |
Confidential Solution Architect
Architected a system with Mobile components for tracking activities in the ski resort. Participated in building a system prototype. Software used: WebStorm, Angular JS, Xamarin Studio, Web API 2.0 and Azure Mobile Services.
Presently prototyping a layer for integration with wearables Google Ware and Microsoft Band .
Confidential Team Lead/Manager
Lead the development of the Universal Agent Application. The site and item catalog, which were implemented in SiteCore 7.5. The shopping card was created as an Angular component, which supported disconnected mode IndexDB .
Confidential BI/SharePoint architect
Building SharePoint based BI portal and providing technical mentoring services to the off-shore team.
Implemented single SSN and integration between on-premises and Office 365 farms initially using PingFederate. Later switched to ADFS.
Built reports publishing infrastructure for PowerBI objects. Prototypes Office 365 portal UI by adopting Bootstrap templates to SharePoint 2013 environment and directed off-shore team during the implementation. Established environment for Workflow development and mentored offshore team during the implementation.
Architected self-serviced BI system Power BI and SharePoint that aggregates data from SAP BW and Oracle ERP repositories and facilitates cross-department collaboration. SAP business logic was already implemented in BEx queries and I was able to construct a solution that reused this logic. The portal was started as Office 365 application and then was upsized into full-fledged MVC application and published on Azure.
Confidential, Engagement Architect
The engagement was to evaluate the processes on the client's SharePoint farms, to implement some governance, to migrate the content to SharePoint 2013 and to improve processes and code.
Following Microsoft best practices for SharePoint 2013 My focus was on implementing SharePoint No Code strategy, which in this case is:
Implementing Taxonomy based UI, Redesigning search by taking advantage of the Results Sources, Result Types and Javascript based presentation templates. Using BCS with search and replacing several ASPX based forms client was not able to find the source code with InfoPath.
The other part of the engagement was technical supervision of the front end of the FlexiTerm MVC application for payment terms negotiation. The UI has been implemented using Angular JS.
Confidential Cloud Architect
The client requested to build a calculation cluster and report system on top of it. Also one of the main requirements was to make the resources available on demand. Initially the development started on Azure and then was partially migrated to AWS due to some deficiencies in the implementation of the Azure APIs.
Developing hybrid cloud application where UI and billing data reside on Azure and worker roles and BI is served from Amazon AWS. Prototyed using Office 365 SharePoint Excel Services and Semantic Model for serving Power View via oData connected to AWS RedShift.
Developing SharePoint App for customer portal. The app allows customers to design forms and to drive them via Office 365 SharePoint workflow.
Confidential Delivery Manager
Developing data synchronization solution between iOS clients and legacy application WCF, MVC Web-API .
Implementing custom document management subsystem based on SharePoint 2010 CSOM.
Designed and developed SharePoint form generator App Knockout JS, CSOM for creating custom forms, associating them with SharePoint Workflow and integrated app into client's case management system.
Provided technical supervision and architectural solutions for the core business application Medicare/medicate fraud prevention system. The system was done in .NET MVC with heavy use of Telerik.
Confidential Solution Architect
Provisioning large SharePoint 2010 farm and migrating 3 medium size MOSS2007 farms. Handling migration of the custom solutions, MOSS 2007 templates and meta information into SharePoint 2010.
Developing SharePoint application for bridging NextDoc workflow package with BAAN/Oracle ERP system:
Modifying existing and developing new event driven sub-workflows
Writing custom authentication provider for BAAN based on SharePoint groups exposed via vti bin services
Writing custom applications pages for augmenting missing functionality in the NextDoc implementation.
Confidential Enterprise Architect
Migrating SharePoint 2007 WCM solution to SharePoint 2013 pre-beta. This engagement was a proof of concept and comparison of new SharePoint WCM with SiteCore
- Migrated content to intermediate 2013 farm
- Separated HTML from code in Master Pages and handed HTML to designers
- Implemented snippets for new master pages
- Migrated page layouts
- Replaced several layouts with content aggregation web part pages
- Introduced Device Channel for serving mobile content.
- On a SiteCore side prototyped custom search
Confidential, IN SharePoint/BI Architect partially telecommuting
Provisioned medium size SharePoint 2010 farm with maximum virtualization. Deployed SSRS in dual mode.
Built data warehouse and ETL SSIS packages for loading sales and inventory data from SAP. Built several reporting models and SSRS sales and inventory reports. Presently building and securing sales cube, developing KPIs and Excel reports for deployment into the Excel Service.
Developed and customized External Content types and built management pages for configuring budget targets and access rights based on those types.
Migrated existing MOSS 2007 farm into SharePoint 2010 and helping decommissioning MOSS 2007.
Confidential, SharePoint Architect/Delivery Manager
Designed and implemented SharePoint 2010 Aggregation Solution for presenting content from several internal farms to the Internet users. The aggregator solution crawled documents with specific content type and presenting them through the Internet farm. Document links on that farm were dynamically replaced with calls to the SOAP services which resided on the internal farms . The UI was enhanced by the dynamic menu custom menu provider driven by the content type meta information. The site was designed with Safari and IE friendly CSS. The main customers were accessing it from iPad.
2/2011-7/211 Atlanta Housing Authority, Confidential Responsibilities: MOSS2007 migration to SharePoint 2010, Infrastructure and capacity planning, farms consolidation and data recovery.
Developed several custom solutions including
TheInsider Publishing Portal,
HR Portal with custom forms, workflows and the client for the HR-XML web services,
Dashboard SSRS and application for managing employees and clients training
Architected several .NET web applications and services in order to support data exchange with partners.
Confidential, Phoenix, AZ
Prototyped solution for editing Excel Workbook, hosted in SharePoint 2010 Excel services.
Migrated MOSS2007 farm to SharePoint 2010 including my sites, taxonomy, analytics and security
Designed High Availability and Backup solutions combination of Microsoft DPM and custom scripts
Company had WCM application for hosting Internet sites. That application was tightly coupled with branding templates and was based on incorrectly written site definition, which tampered application scaling. My role was to:
1. Rewrite site definition and package it properly
2. Re-design automated site provisioning
3. Add plumbing for custom menu implementations Wrote custom navigation provider for connecting to several LOB applications.
4. Convert provisioning and site definition into SharePoint 2010 environment
5. Establish best practices for solution development and deployment specifically for SharePoint 2010.
6. Architected integration with company e-commerce Customized and configured Form Authentication provider for Internet sites, Designed and prototyped number of Power Shell scripts for initial sites set up .
Confidential, Norcross, GA
Designed and developed Vendor Portal application, which is a set of connected custom and standard web parts. SharePoint 2010, VS 2010, WSPBuilder
Custom web parts are consuming data from Lawson Accounting System assisted in the design and development of the Lawson SOAP services
Confidential VIA Telecommuting
Developed proof of concept for simulation results visualization. The company runs a number of forecasting simulations until results of these simulations converge. There is a need to validate results quickly before using them in the conversion process. My role is to evaluate several technologies and to present a road map for developing solution to the problem.
Designed data structure for capturing results, by mapping subject area to star schema and designing appropriate dimensions and measures.
Designed visualization with TreeMap Control using JavaScript.
Integrated Silverlight solution see above into SharePoint 2010 portal.
Prototyped visualizations based on SSRS ad-hoc reporting using Report builder 3.0 and SQL server 2008 R2 . Configured SharePoint 2010 farm and SSRS in the integration mode in order to support SSRS development environment, including data visualizations with Bing maps. Built custom web part for hosting SSRS reports there was a need for custom processing of the report parameters
Evaluated Excel 2010 BI capabilities and SharePoint 2010 Excel Calculation Services for ad-hoc analyses.
Prototyped validation procedures and implemented several custom Visual Studio workflow solutions.
Confidential telecommuting . Principal Solution Architect.
Architected custom WCM solution for the company. Company is a conglomerate of more than 500 divisions, each of which has to have a controlled web presence. The decision was made to use MOSS2007 WCM. My responsibilities included:
1. Sizing publishing and presentation farms for projected traffic
2. Recommend hardware implementation virtual vs. physical
3. Build custom publishing templates
4. Build provisioning service and application for automated provisioning and deployment management.
5. Design number of custom solutions:
a. Contact us solution and web part
b. Quick push granular content deployment for the corporate announcements
c. Sub-sites web part
d. Meta information web part
e. Modified by solution for approval workflow.
f. Custom output caching
6. Designed and implemented Backup/Recovery solution based on DPM
7. Evaluated AvePoint suite Backup/Recovery, HA and replicator and found it not adequate for managing medium size farm.
8. Implemented custom search scoping and relevance tuning.
9. Designed DR solution using combination of SQL log shipping for application content synchronization and special feature receiver for solution synchronization.
10. Implemented CardioLog reporting on the farm using custom provider so that data processing does not affect presentation farm.
Currently Presentation farm caries 197 site collections and 260,000 average unique users per day.
Designed and implemented Intranet farm. This farm hosts 250 sites built on branded Publishing and team site templates.
Portal/BI Architect, Confidential
My responsibility was to provide technical mentoring while helping transitioning from Business Objects to Microsoft Analytics. Specifically:
Re architected MOSS 2007 deployment medium farm
Configured Reporting Services in Integration Mode SQL 2005 and then re-installed SQL2008
Configured PreformancePoint, developed several scorecards and hosted them in SharePoint.
Set up SSIS templates logging, auditing and configuration for type 2 dimensions.
Introduced SQL 2008 server MERGE for processing large type 2 dimensions over 10 mil rows .
Prototyped the process for converting Business Objects Universes into SSAS Cubes.
Built proof of concept for the Claims cube with over 300 million rows in the fact table and achieve acceptable cube processing and reports generation timing.
Designed reports and KPIs with SSAS/MDX sources.
1/2007 12/2008 BI Architect Confidential
Major brokerage wanted to reconcile trades orders and to audit fees, paid to different ECNs. Each ECN supplied structured file daily. The company also supplied daily file. The issue was that there was no consistent linkage between request/result files.
Designed data warehouse and data acquisition processes.
Designed and developed Windows Service for dispatching proper SSIS package based on the data source signatures. Implemented extensive error processing.
Designed cube and custom aggregations.
Developed Reporting Model s and templates for ad-hoc reports.
Provisioned medium size SharePoint farm for report and analytics delivery.
Set-up Performance Point Monitoring and MOSS 2007 , developed scorecards, dashboard and analytical reports.
Set-up Excel services, designed several Excel based reports and hosted them in Excel service
Configured Forms Authentication Provider for broker's level access.
6/2005 1/2007 Architect, Ista, Atlanta GA
Company had BI portal, implemented with Crystal Enterprise 9.0, which hosted about 130 reports with data sources located in more than 20 databases. Ista wanted to improve the stability of this portal and to expand services by offering clients a new set of energy trending and financial reports.
Implemented SharePoint and configured reporting in SharePoint mode so that thus providing source repository for those reports.
Designed the solution, which allowed ista to keep 75 of the reports in Crystal and developed specialized data warehouse for accelerating 25 of the existing and most of the new reports.
Managed new reports development using SSRS.
Developed Report Delivery Portal which hosted SSRS and Business Objects Crystal related functionality.
Styled User Interface of the Crystal and Microsoft Report Viewers so that they become visually indistinguishable.
Developed tools for report subscriptions management and monitoring The system had originally over 3000 subscriptions .
Designed Data warehouse for Energy Management System with the goal of providing forecasts for energy cost, consumption and demand.
Experimented with SSAS mining models forecasting and determined that client's goals will be better served with custom forecasting implementation.
Implemented ARIMA forecasting model and delivered energy trending reports.
Designed Data Warehouse, implemented SSAS cubes and decision support reports based on the deregulated energy markets NY, TX data
Helped with Architecture, design and implementation of some of the modules of the billing system Rate Engine , Hierarchy Management sub-system and Authentication/Authorization sub-system.
10/2004 5/2005 Solutions Architect, Confidential
The company specialized on background checking. Operations were centered around ancient system, built on Microsoft Access. Company wanted to scale up their operations.
Started by upsizing MDB database into SQL 2000, and then optimized MS-Access queries, implemented proper indexing, tuned the database and implemented archiving solution.
Developed Client/Vendor Portal for manual order submission and acceptance, developed and supported different methods of integration with clients and vendors SOAP based web services, XML entry points, structured files entry points .
Integrated with number of external web services, running on .NET, Java and Cold Fusion.
When the volume reached 20 transactions/min upgraded system infrastructure and transitioned data store to SQL 2005. Tools and technologies: C , SSIS, SSRS, WCF.
Lead the team of 2 developers at different stages of the project.
During last 15 months the company was able to increase business 8 fold only doubling its personnel.
2/2003 9/2004 Consultant, Confidential
Company manufactured heavy equipment and wanted to manage operations more efficiently. The ERP system was Visual Manufacturing from INFOR and it was three releases behind.
Upgraded Visual Manufacturing and Visual Financing to the current version and replaced SQLBase with SQL server 2000.
Prototyped equipment orders pricing module and integration with Visual Manufacturing
Performed load test and determined that COM based Integrator SDK does not support necessary performance.
Set up beta testing agreement with INFOR and received bets .NET SDK and improved support
Developed Quoting and scheduling sub-systems and integrated with Visual.
Developed company internet, company dashboard and BI solution
Built production status tracking system by acquiring data from each station PLC Windows CE .
Confidential Director of Software Development
Company was a developer and operator of technology to provide digital television interactive and complementary data services web, mobile device for pan-European Weather and Traffic news and information. A startup company that failed in 2003 lack of continued funding , but that had revenue generating operations Germany, UK, Holland, Switzerland and owned the IP/patents to the advanced distribution, player and content management systems that were developed. Initial rounds of funding totaled 25m, ultimate round was to be 45M Blackstone Partners 60 employees with 10 in pure product development.
Full responsibility for Technical Development, Deployment and Operations for an advanced digital cable television channel store and forward, computer-generated content and WEB/mobile device information portal for Weather and Traffic information for European countries.
Deployed the network in Germany, UK and The Netherlands.
Performed project support with all levels of management, marketing personnel and staff.
Based in Frankfurt, Germany, managed relationships and contracts with our European partner organizations to co-ordinate channel operation projects, resolve problems, and communicate project status.
In conjunction with the Chairman of the company, closed several major 'carriage'/distribution partnerships and several co-branding/content relationships with major European brands.