Senior Systems Analyst Resume
Orlando, FL
SUMMARY
- Microsoft Certified Technology Specialist in Share point Development
- Over 9yrs of experience in Design, Development, Testing and Implementation of Software Applications
- Over 5yrs of experience with Sharepoint Technologies including sharepoint 2010, MOSS 2007 and SQL Server database Design, Development and Testing
- Successfully led development effort in numerous projects
- Actively involved in all the stages of Software Development Life Cycle including analysis, design, coding, testing and implementation
- Expertise in Object Oriented Analysis, Design and Programming using C#.Net and ASP .Net
- Expertise in installation, design and development using SharePoint Server, Windows Sharepoint service, configuring Search, User Profile services
- Expertise in customizing the portal using Sharepoint Object Model, C#.Net
- Experience in all aspects of database design and programming with SQL Server.
- Experience in design and development of Reports using Reporting Services
- Experience in Data Warehouse planning, designing (Star and Snowflake schemas), and implementation using SQL Server Analysis Services (SSAS) 2005, ETL process using SSIS and MDX
- Experience in software tools like Visual Source Safe, Rational Rose, Erwin, Clear Case and Clear Quest
TECHNICAL SKILLS
Operating Systems: MS WINDOWS 7/ XP Pro/ 2003/ 2000/ 98/ 95 , WINDOWS server 2003/ 2008
Databases: SQL SERVER 2008/ 2005/ 2000 , ORACLE, MS ACCESS, DB2
Web technologies: Sharepoint 2010, MOSS 2007,IIS, ASP.Net, WSS 3.0, HTML, DHTML, XML, AJAX, CAML, JQUERY, Java script, Powershell
OLAP Systems: SQL Server Analysis Services 2005, Integration Services 2005
Development tools: Visual Studio 2010/ 2008/ 2005/ 6.0 , Business Intelligence Development Studio
Reporting Tools: SQL Server Reporting Services 2000/ 2005, Crystal Reports
Languages: C#.Net, VB.Net, VB6.0, VC++, C, TSQL, PL/SQL, Java script, VB script
Tools: Utilities MS Visio, MS Project, MS Office, Info path, Visual Source Safe, Rational Rose, Erwin, Clear Case, Clear Quest
PROFESSIONAL EXPERIENCE
Confidential, Orlando, FL
Senior Systems Analyst
Environment: Sharepoint 2010, MOSS 2007, SQL Server 2008/ 2005, Visual Studio 2010, Infopath 2010/ 2007, Sharepoint Designer 2010/ 2007, Java script, CSS, JQUERY, CAML, Powershell script
Responsibilities:
- Responsible for developing custom Sharepoint solutions, administering portals, managing user permissions for Confidential ’s QCA division
- Developed custom features, Event Handlers, Web Parts, Workflows, configured search center using Sharepoint 2010/MOSS, Visual Studio, Sharepoint Designer, Infopath
- Played a major role in upgrading the portal from MOSS 2007 to Sharepoint 2010.
- Resolved post migration issues related to the third party webparts, navigation issues and other related issues
- Developed Document Control System involving custom features, Event Handlers, custom webparts and workflows.
- Performed migration from MOSS 2007 to Sharepoint 2010. Built custom web pages using CSS, Javascript. Provided extensive support and training to the users
- Configured and defined Taxonomy and managed metadata services to categorize content across the portal to help business process workflow, navigation and search
- Developed solutions to integrate external data source with Sharepoint list using Web Services.
- Built and configured Sharepoint Development environment using the Production system backup.
- Provided support, training and subject matter expertise related to the custom solutions
Confidential, Orlando FL
Consultant
Environment: MOSS 2007, Infopath, SLAM, Visual Studio 2005, SQL Server 2005, SSAS, SSRS.
Responsibilities:
- Involved in the Design and Development of the WCF Reporting Portal Microsoft Office Share point Services (MOSS) 2007.
- Involved in designing the database schema for the reports using SQL Server 2005. Created ERD and data flow diagram.
- Worked on creating Complex reports involving charts using SSRS and SQL Server 2005 and deployed the reports on Sharepoint.
- Worked on displaying the dashboard on the Portal and setting up the parameters for the dashboard.
- Involved in creating Infopath forms for user data entry.
- Used 3rd party tool called SLAM to enter Sharepoint list data into SQL Server 2005 for reporting.
- Involved in testing and user training.
Confidential, Orlando FL
Consultant
Environment: MOSS 2007, Project Server 2007, HTML, XML, Visual Studio 2008, SQL Server 2005, SSAS, SSRS.
Responsibilities:
- Involved in the Development of the Project Management portal using Microsoft Office Share point Services (MOSS) 2007 and Project Server 2007.
- Worked on editing the Master page and the CSS file using Sharepoint designer to customize the navigation and appearance of the site.
- Worked on developing custom Web parts using Sharepoint object model and deploying them on the portal.
- Worked on creating project status dashboard on the PMOIT site. This involved deploying reports created using SSRS and displaying the reports on Sharepoint.
- Worked on creating image using Adobe Photoshop and developed HTML to link the diagram to text.
- Involved in installing SSAS on Project server. Also setting up of the project server cube for analysis of the underlying project server data.
- Added measures to the Project Server cube using MDX.
- Worked on creating Infopath form template for project status reporting and associating it with the sharepoint form library.
- Provided administration support like resolving user permission issue, content management and other related issues.
Confidential
Environment: C#.Net, ASP .Net, Visual Studio 2008, SQL Server 2005, Visual SourceSafe.
Responsibilities:
- Involved in the Design and Development of the Merchandise Revenue Planning system using ASP.Net C#.Net, VS2008 and SQL Server 2005. Used SOA principles to design the system.
- Designed and developed Web Forms using ASP.Net which involved complex functionality and logic.
- Developed Code behind using C#.Net and performing script validation using JavaScript.
- Used AJAX enabled controls for better rendering of the UI.
- Worked on creating and deploying complex web controls and Custom controls used on the Forms.
- Developed Web services and used them in the application
- Worked on developing backend SQL procedures for fetching data.
- Used Visual SourceSafe for versioning and source control.
Confidential
Environment: MOSS 2007, Office 2007, Sharepoint designer, C#.Net, Visual Studio 2005, Workshare professional.
Responsibilities:
- Involved in the Design and Development of the Legal Contract Management system using Microsoft Office Share point Services (MOSS) 2007 and Office 2007.
- Extensively interacted with the users to understand the existing process and provide best solution for automating the process cost effectively.
- Worked on creating document templates using word 2007 features like content controls, document information panel and associating the templates with document library.
- Worked on customizing the document information panel of Word document using Infopath.
- Developed site feature for auto incrementing contract numbers using Visual Studio 2005. Used stsadm utility to deploy and install the feature on the site collection.
- Developed workflows like approval workflow, tracking workflow and escalation workflow using Sharepoint designer and deployed them on the site collection.
- Involved in integrating document comparison tool Workshare professional with MOSS for the document comparison functionality.
- Involved in providing user training of the system and creating user manual.
Confidential, Orlando FL
Consultant
Environment: SharePoint Server 2007, MS Visio, Visual Studio 2005, C# .Net, SQL Server 2005, Integration Services, Reporting Services, Visual SourceSafe 2005.
Responsibilities:
- Involved in the Design and Development of the Medicare Application using SQL Server 2005 Database and C# .Net.
- Involved in the development of WinForms, user controls, composite controls, business layer and data layer of the application.
- Also created stored procs and used them in the data layer of the application.
- Created SSIS packages to transfer data. Also worked on optimizing existing stored procedures.
- Worked with the client to provide solution for their Sharepoint portal architecture and custom solutions
- Involved in the Design and Development of a complete Team and Project Site using Microsoft Office Sharepoint Services (MOSS) 2007 with features like document management, defect tracking and dash board.
- Developed Defect Tracking system with custom list on the Sharepoint portal.
Confidential, Atlanta GA
Consultant
Environment: SQL Server 2005, MOSS (sharepoint) 2007, Business Intelligence Development Studio (BIDS), MS Project, MS Visio, SSAS, SSRS, SSIS, C#.Net, ASP .Net, MDX, WSS3.0.
Responsibilities:
- Involved in the Design and Development of the Data Warehouse and Sharepoint portal using SQL Server 2005 and MOSS 2007.
- Extensively involved in interacting with the business users and gathering the requirements for the data warehouse and the share point portal.
- Created project plan, business requirement, design document and presented it to the business for their review.
- Followed Agile methodology and held sprint meetings.
- Involved in the development of the Star, Snowflake and Hybrid Schemas to Model the Data warehouse.
- Designed and developed a dimensional model for the OLAP Cube, by an in depth study of the user requirements and the existing database schema. Created KPI’s using MDX.
- Developed SSIS packages to move the data from SQL Server 2000 to SQL Server 2005 for the initial load and the deltas.
- Also involved in the development of stored procedures to format the data according to SQL Server requirements.
- Involved in the Designing the Business Intelligence Reports using SSRS and SQL Server 2005 Database.
- Involved in the development of Web Portal using Windows Share point services for project tracking dashboard, document management and hosting the BI reports.
- Integrated the OLAP cube with the sharepoint to create a dashboard for the management.
- Configured document management, Project tracking sites to manage the project documents with versioning capability and approval workflows for the document approval process.
Confidential, Atlanta, GA
Consultant
Environment: C#.Net, Visual Studio .Net, XML, Oracle, MS Visio, MS Project, Visual Source safe, Documentum, AS/400, Windows XP Professional.
Responsibilities:
- Involved in the design, development and implementation of the new modules to the billing system.
- Coordinated with the business group by holding requirements walkthrough meetings.
- Involved in solution design and design reviews with the business. Held design walkthroughs with the developers.
- Involved in the development of the front end application using C# .Net.
- Built complex WinForms, business layer of the application and also the data layer. Used ADO .Net for interacting with the database.
- Involved in the Design and development of the tables, keys, stored procedures, functions and triggers on Oracle database as per the design.
- Collaborated with the QA testers during testing and also during the implementation phase.
- Used Visual Source Safe for versioning and source control. Used Documentum for document control.
Confidential
Environment: C#.Net, Visual Studio .Net, ASP.Net, XML, SQL Server
Responsibilities:
- Involved in the design and development of the Project Management Website using ASP.Net, C# and SQL Server 2000.
- Interacted with the business for requirements gathering and design reviews.
- Created Web Forms using ASP.Net, C#.Net and Visual Studio.
- Worked on creating Web User controls, Custom controls and deployed them in the GAC for reuse.
- Created stored procedures using SQL Server to be used in the Data Access layer of the application. Used ADO.Net for Database operations.
Confidential
Software Engineer
Environment: Visual C++ 6.0, VB 6.0, Oracle 8.0, Windows 2000, Rational Rose, Visual Source Safe.
Responsibilities:
- Involved in Requirements gathering, analysis, design and development of the systems using VC++.
- Programmed multithreading, serial communication, LAN communication protocols and DLL’s.
- Involved in documentation and testing of the system.
- Involved in providing user training and post go live support of the systems.