PROFILE

Assistant Director of IT / Enterprise Architect with 19 years of extensive experience in professional services and IT industries with strengths include research, analysis, problem solving, planning, leadership and innovation resulting in highly efficient and cost cutting programs. Possess a clear sense of purpose and urgency when faced with diverse situational challenges during periods of both expansion consolidation. Skilled in all phases of the project life cycle, from initial feasibility analysis and conceptual design through implementation, enhancement and ongoing operations. Effective at building diverse, high energy teams, with excellent business, process strategic skill sets. Proven ability to drive enterprise - wide IT initiatives that streamline operations, capture savings, increase capability, improve service quality, and accelerate growth

TECHNICAL SKILLS

Languages: ASP.Net, AJAX, C .Net, Visual Basic.Net, C/C, Visual Basic 5 / 6, Com, Com, ASP, HTML, DHTML, XML, XSL, XSLT, PL/SQL, Assembly, Flash 5/ MX, Action Script, UML., Cisco CCSP, WCF, WPF, WWF.

Databases: MS SQL Server 7, MS SQL Server 2000-2014 all versions, MS Access, Oracle 9i.

Scripts: Visual Basic Script, Java Script, JQuery

Tools: MS Office 97/98, MS Office 2000/2003, MS Office 2007, 2010, 2013 MS Visual Studio 6, MS Visual Studio.Net, Visual Studio 2008 / 2010/ 2012/ 2013/ 2015 CTP, Macromedia Studio MX, Dream weaver, Ultradev, Visual Studio.Net Architect 2003/ 2005/2008. ChartFX from Software FX, Dundas Charts, Visio 2003/2007. CRM 3.0/4.0, SharePoint2003/2007/2010/2013, VM Ware, Virtual PC

Reports: Crystal Reports 7/8/9/10, Architect version of Visual Studio.Net, Business Objects, SQL Server Reporting Services.

Operating

Systems: Windows 95/98, Windows NT 4, NT 5, 2000, ME, XP/Vista and DOS.

Servers: Windows 2000-2012 R2 Server Regular / Advance, Windows.Net Enterprise Servers, IIS, MTS, Flash Communication Server, Windows Server 2003 Family.

Hardware: Intel IBM Based PC's, Cisco Firewalls, Cisco Routers

PROFESSIONAL EXPERIENCE

Confidential

SharePoint / Enterprise Architect

• Introduced and standardized development flows and introduced different environments form development teams and help architected the integrate business critical applications like Service-Now, Project Server, TFS Server, Pharmacy transactional based systems like Omni DX, Oasis and OmniView.
• Helped teams in developing mobile based solutions for the pharmacy rep teams and Worked directly with Microsoft and distributed Surface devices to rep in order to efficiently achieve tasks.
• Architected, build and maintained SharePoint, SQL Server, OWA and Server environments
• Selected Idera, MetaVisTech and Metalogix tools to streamline migrations
• Advised senior business leaders on emerging technologies, ensuring Omnicare is equipped with best-in-class technical capabilities while maintaining cost efficiency.
• Developed, implemented, and governed IT architectures including applications, systems, and databases, overseeing health and functionality of critical IT assets
• Worked directly with Microsoft on Microsoft Enterprise EA
• Created a highly efficient team for the project
• Managed onshore and offshore teams of developers and tech leads.
• Designed and developed different workflows to help business automate their processes through SharePoint, SharePoint 2013 high trust apps etc.
• Integrated business processes with Service-Now to centralize ticketing system across enterprise.
• Initiated enterprise wide mobile solutions and mentor teams.
• Speaker at several roadmap seminars.
• Couch teams and held learn and lunch meetings to transfer knowledge and to bring the team on one page.
• Configure Project Server 2013 as part of Enterprise SharePoint 2013 rollout and helped PMO's configure cost centers, resource management, security, timesheets and custom report building and other Business Intelligence custom reports based on Project Server 2013 data.
• Managed Projects at different levels and made sure Project Server 2013 is customized to business needs.
• Worked on Office 365, configured and setup Office 365 for two departments, configured Lync 2013 for that department along with SharePoint site and other SharePoint enhancements.
• Developed multithreaded windows forms application for the claims department in C using .Net Framework 4.5, Custom and third party controls.
• Architected and designed different databases in SQL Server for pharmacy applications.
• Architected and helped Developed Windows 8.1 native application for Sales team using C
• Developed high trusted Apps for SharePoint like Statboard for pharmacies using ASP.Net, JQuery, .Net Framework 4.5.1, WCF, SQL Server, TIBCO and Oracle using Materialize 2D design.
• Architected and developed SOAP, TIBCO, Rest and WCF Services to connect to different pharmacy systems like Oracle EBS, Omni DX, OASIS and Point of Delivery POD
• Designed and architected standard framework for development among teams which used Microsoft Application Blocks, SQL Server, XML, Service-Now, SharePoint 2013, TFS Server 2013 and Project Server 2013.

Confidential

Technical Lead / Senior SharePoint Developer

• Heavily involved in gather information from the business and from the end client
• heavily involved in documenting, architecting and implementing the design of hardware and software
• Architected, Designed and implemented SharePoint 2007 environment brand the site
• Heavily involved in development and administration of SharePoint.
• Heavily involved in designing and implementing web parts using C, Visual Studio 2007, 2010
• Created new environment for SharePoint 2010 for pilot projects
• Developed web parts, web services to read data from external databases
• Architected and developed intranet portal with customized team sites for the company
• Heavily involved in designing databases and architecting reporting in SSRS
• Heavily involved in architecture of multiple scalable solutions by implementing layers.
• Created the architecture in SOA model using Stateless web services
• Help West Pharmaceuticals to migrate Lotus notes databases over to SharePoint 2007 database.
• Used Quest and AvePoint to migrate Lotus Notes databases to SharePoint databases.
• Tools used Visual Studio 2008, SQL Server 2008, MS Project, MS Visio with framework 3.5, c 3.5 and AJAX
• Working on framework 4.0 to explore additional features which can enhance the current projects.
• Customized team and client sites for SharePoint 2010 using Visual Studio 2010
• Worked on Endo Pharmaceuticals for their intranet portal with branding and lot of custom development for their SharePoint 2007 and 2010 sites.
• Created, customized and maintained team sites for SharePoint 2007 and SharePoint 2010
• Heavily involved in integrated other software with SharePoint included OnBase workflows
• Heavily involved in creating customized workflows for SharePoint using Visual Studio 2008 / 2010 and SharePoint Designer
• Architected, design and lead the offshore / onshore team for the project
• Manage budgets, budgeted Vs actual.
• Manage project plans and meet the deadlines
• Involved in performing performance analysis
• Developed workflows using windows workflow foundation WWF .
• Developed data layers, middle tier and Service layers using WCF and WebServices
• Used LINQ queries to query data tables and xml.
• Wrote complex stored procedures, functions and triggers to automate the workflow.
• Used WPF for silverlight page.
• Created and manage Virtual Machines VM in VM Ware and Microsoft Virtual PC
• Designed and Architected database for these complex applications in Oracle and SQL Server 2005.
• Designed web applications in SharePoint 2007 and also regular ASP.NET web applications in framework 3.5 using VB.Net, C .Net, XML
• Used AJAX functionality in order to make websites more user interactive and user friendly
• Designed complex web services to get volumes for the compounds and same service is currently being used by more than 12 departments to get volume for the compounds in a particular assay
• Active Directory security was used for client server application as they are for internal use only
• Designed and help team to design complete wireframes for the applications Web/Client Server
• Worked on SharePoint 2007 for their intranet portal. Architected, designed and developed SharePoint intranet portal sites for Merck users.
• Maintained sites with almost 7500 users on SharePoint 2007
• Involved in developing Web Parts, workflows and customizing the portal sites

Confidential

Technical Lead.

• Architected and lead the offshore / onshore team for the project
• designed the security for SharePoint and guardian CMS application including ASP.Net membership providers and custom security with ASP.Net 3.5
• Wrote WebServices and Created middle tier for the application using patterns like factory, smart and singleton.
• Created and manage Virtual Machines VM in VM Ware and Microsoft Virtual PC
• Used WCF messaging layer to interact with the database.
• Managed team in wire framing the whole application in MS Visio 2007.
• Designed single sign on with SharePoint with Custom web ASP.Net 3.5 application using C .Net, SQL Server 2005.
• Designed the complete database for the project in SQL Server 2005. Database is broken into small diagrams for ease of understanding.
• Application is architected in modular approach SOA model which makes application flexible and secure as far as extensibility and security is concerned.
• Application have complete calendar control Infragistics which can be sync with Outlook calendar for doctors, Sales rep, MSL, VP etc.
• Host application off of SharePoint 2007 using web parts using SharePoint extensions for Visual Studio 2008
• Used SQL Server Reporting Services 2005 for reporting purpose and display that from SharePoint 2007 using report viewing web part.
• Application gives different dashboards for different hierarchy within the sales force e.g. Vice president, regional manager, district manager, sales rep etc.
• Application contains complete and extended profile for Health care provider HCP, speakers, MSL etc.
• Developed collaboration sites on SharePoint 2007 for document sharing, task list, bug list, several thread lists for better communication between offshore and onshore.
• Application uses AJAX, XML, and Message Queue for Tasks and Alert generation.
• Used Google API's for finding directions to Doctor's or HCP's office.

Confidential

Systems Architect Project / Team Lead

• Architected and lead the team in developing the security system which can be implemented on any system and can be easily managed through the web pages. Technologies used are Microsoft .Net framework 3.5, SQL Server, AJAX, Visual Studio 2008.
• Made strong decisions in selecting the technology for the systems considering future and flexibility in the mind.
• Developed Web Services to interact with ERP systems. Wrote complex middle tier to support interaction between front and backend. Middle tier also support interaction with great plain version 9, 10.
• Architected and managed team and developed screens for data entry which includes data for Bad Debts, KOPIS, Fixed Assets, Intercompany and Branch locations.
• Used Google services to integrate Google Maps into the system for branch locations which tell the turn by turn directions to the user on demand which are integrated to the public website.
• Customized Great Plains to get the real time data from Microsoft Great Plains GP for Intercompany Transactions to get the correct general ledger and trial balance.

Confidential

Internal Systems Architect Team Lead

• Architected and lead the team in designing the Renewal System which automates the renewals for the customer who holds the current key for the software. SQL Server Reporting Services was used in order to show renewals as a report.
• Designed and Involved in the development of Customized Analysis Cubes for Great Plains GP . SQL Server Analysis Services were used to accomplish the task and MS Excel was used as a front end to show Pivot tables.
• Involved in Architected, Design and Customization of Microsoft CRM. Different entities were created to manage the renewals of the Keys.
• Architected and developed two legacy applications from VB6 to .Net using Orcas. Which enable sales team to find different cases and bugs posted by users from the website. The applications were integrated with MS CRM and SQL Server 2005.
• Using SharePoint to create different Dashboards using Web Parts which include customized solution for the management team to see their part of information.
• Involved in the designing e-commerce application for Europe and Japan offices which includes separate CRM for each company due to language customizations.

Confidential

Systems Architect Project Manager

• Designed and developed User Management System in such a way that it can be used with any application. Web or Win forms and give user ability to track logins, audit logs, security layer for the whole application and also enable user to track and set security for the application as well as setting parameters globally for the application. Used Visual Basic .Net 2005, C .Net, Visual studio .Net 2005, SQL Server 2005, Visio 2003, XML, AJAX, ASP .Net etc.
• Designed and developed database. Developed scripts which create tables and procedures dynamically for the system. Developed complex middle-tier for the application.
• Designed and developed Dynamic Reporting Module in such a way that the module can be implemented or can be attached with any application Web or Win forms . The system is designed for administrators and developers who create the reports and DRM enable administrator to create parameters for the report dynamically which creates user interface based on the parameters dynamically and displays the report according to the information provided by the end user.
• Designed the architecture in SOA model to support integrations. Created complex WebServices for Claims department of re-insurance business.
• Designed and developed complete application few parts still under development for insurance industry containing modules like Claims, Underwriting, Premium, Billing, IT, Accounting, Profit Sharing, No Claim Bonus, Reconciliation with Freedom application etc.
• Designed and Developed Inventory System which track inventory of all the departments and is going to be a shelf product in about 2 months for insurance industry.
• Designed and Developed Map Point Analysis Tools using Map Point 2006 from Microsoft and Visual Studio .Net 2005 which displays policy risk data on the map geographically and data can be exported to MS Excel

Confidential

Senior Developer and Architect

• Developed different reports for Novartis Pharmaceutical and Harte Hanks which gives different information about the patients involved in the program e.g. how many patients got vouchers, how many patients are using what kind of drug, how many patients are of a particular age and have a particular disease, how many people are of what ethnicity etc.
• Developed application PC Based in VB.Net and ASP.Net using VB.Net which automates the reporting process and creates dynamic reporting by creating search engine from which data can be exported to MS Excel for further manipulation.
• Designed database for the whole program which includes checking random patients in Shopping Malls all across the country and then that data was scan into the system using Scantrons and stored in the database for reporting purpose.
• Design the application structure design using UML in MS Visio 2003.
• Developed application which XP visual styles using custom developed flat controls using c and VB.Net. Application provides different modules including importing data from Scantrons and putting that data into normalized database, batch processing of data, individual Mall data, aggregate Mall data reporting and searching utilities.
• Developed different stored procedures, triggers and wrote cursors to automate the system.
• Wrote different middle tier components to automate the system so that data can be exported to MS Excel for further manipulation
• Verified all the addresses data with ZP4 address solution with custom made dlls.

Confidential

Lead Developer and Architect

• Defined and developed structure of the application as the requirement was to import/export the data from Excel Sheets, do calculations on the run and show it on the ChartFX graph. Manipulate duplicates while importing into SQL Server and do different kind of analysis on the screens and export that data back to excel with additional data.
• Duties included breaking down application into small components and assigning them to developers.
• Architected and developed the application in COM environment which uses UML, VB.Net, C .Net, XML for the front end and uses MS SQL Server at the back end.
• Wrote stored procedures to automate the system.
• The application has different XML palettes to apply e.g. changing the color of the user interface, font size of the labels, heading etc.
• Developed custom flat controls in VB.Net and C .Net to give application a flatter look.
• Used third party controls like Office 2003 Menus control and Whidbey Dock controls to give application a richer look.
• ChartFX was used to display different kinds of graphs on the run and data from these graphs can be exported to excel sheets for later review. The application also allows you to save the parameters to run the analysis on different prices and costs on different Equities, Bonds and other shares on a given date.
• Designed user interface by using custom developed user controls which gives flat look.
• Developed fully functional prototype for Goddard School systems in ASP.Net uses MS SQL Server as back end. This customized prototype application was mimic of CRM application which allows users to keep themselves updated with the calendar, meetings, their schedule etc. VB.Net was used as a language in ASP.Net.
• Application also allow users to enter child data with their other information like their physician's information, parents information, child is allow to do what type of activities, what kind of food school is authorized to give to the child, their medical history etc.
• Application has 9 different modules like Child management, Parent management, Client management, Finance, Cash Flow etc.
• Worked on Graham Company insurance company website and added the feature of reading the data from PDF files and store it as a BLOB in MS SQL Server and then retrieve the file from the SQL Server and also email the file to the end user to keep a copy. ASP.Net with VB.Net was used for front end language.
• Cute PDF was used to achieve the functionality of reading the PDF file to HTML and stores it as FDF file.
• Worked on Quanta Holdings website, added features and maintain their website. C .Net and Biz talk server were used for the purpose