Sql Server Project
Resume:
Sreerama C Desaty Ph: 614-***-****
Email:*******@*******.***
Visa Status: Green Card
Skill Experience Last Used
Total IT 8+ years 2010
SharePoint 2010, 3+ years 2010
SharePoint Designer
****,**sual studio 2010,
Business Connectivity
Services, SharePoint/
MOSS 2007, integration
Data Source into MOSS,
Web Parts, InfoPath,
SharePoint Designer,
Work Flow, Dashboard,
Report Center,
SharePoint
Administration.
ASP.NET, VB.NET, C#, 4+ years 2010
Visual Studio, ADO.NET,
SOAP, Web Service, Java
Script, CSS,
SQL Server, SQL Stored 4+ Years 2010
Procedures, SQL
Reporting
PROFESSIONAL SUMMARY:
Over Eight years of IT years of experience in gathering requirements,
design, development, testing and implementation of Web and Legacy System
Applications.
3+ years SharePoint experience in designing and implementing Customer
Intranet Portal solutions using MOSS 2007.
3+ years of WSS 2003 and Administration including IIS.
Strong experience in designing and implementing various SharePoint Site,
Portals, SharePoint Web Parts, Web Part Pages, Workflows, Content Types and
various custom Document Libraries and Lists and worked in different areas
including Collaboration, Document Management, Portal and Web Content
Management, Enterprise Search Master Pages, Business Catalog, Adobe, WSE,
WCF, K2 Black Pearl, Report Center, Dashboard, Score Cards, InfoPath
Forms, Visual Studio, SharePoint Designer, Microsoft Office Forms Server,
Microsoft Excel, Macros, SAN and NAS storage systems.
Expert Knowledge on SharePoint, SharePoint Portal Sever, .Net,
EIP(Enterprise Information Portal) Active Directory, AJAX, ASP, Java,
JavaScript, XSLT, HTML, DHTML, CGI, FTP, UNIX, DB2, Microsoft Office
Products, Lotus Notes, MS Access, SQL Server 2005, Linux, C, C++, RPG,
COBOL.
Knowledgeable consultant with a Well-rounded SharePoint background ranging
from custom development, requirements gathering, layout and design, and
installation.
3+ years of solid experience in developing various applications using
MS.NET Technologies like ASP.NET, ADO.NET,.Net Frames, VB.NET,C#.NET, XML,
Web Services, Win Forms, Web Forms, Web Parts, Visual Studio.NET 2005, CSS,
BIZ Talk, IIS 6.0/5.0, MS Visual SourceSafe, SQL Server 2005 and SQL Server
2008, SQL Server Report Service(SSRS), SQL Server Analysis Service(SSAS),
InfoPath, JQUERY. 22 CFR Part 11, Silver light and Performance Point,
Web Part Development. Site Definitions and Taxonomy Design and co-ordinate
other resources such as web developers.
Worked on Manufacturing, Warehouse Management, Telecommunications and
Financial Area
PROFESSIONAL EXPERIENCE:
Bank of America Merrill lynch - Chicago - IL Sr. SharePoint
Developer 07/09 to till date
Bank of America - Merrill lynch Chicago IT Division is
responsible for SharePoint 2010 application development, web application
maintenance. Supporting Online Options Trades Teams day to date meetings,
InfoPath forms creations, SharePoint Web application, Divisional sites.
Content management, InfoPath Forms development, Excel Integration with
SharePoint, daily meeting, announcement, Project sites,
Responsibilities:
. Created Business Connectivity Services to extract external data
into SharePoint 2010.
. Excel Services implementation in MOSS, Report Center, Dashboards
and Score cards on Trading Stocks
. Created SharePoint Dashboard for on-Going Project
. Experience Microsoft Excel Macros for BI Reports, Dashboards and
Custom Score Cards.
. Lead Developer in SharePoint 2010 and Portal migration.
. Created Custom site Definition and features for new MOSS 2007
Portals.
. Configured WSS 3.0 Team sites, Document Libraries and Lists.
. Data Migration to MS Access and MS Excel
. Developed Custom Pages, workflows, Web-Parts using SharePoint
Portal Server 2007.
. Performed problem resolution procedures in regards to functionality
issues, calendar maintenance.
New Edge Financial Group - Chicago - IL Sr. SharePoint Developer
06/08 to 07/09
New Edge Financial Group has been dedicated for meeting the
Financial and Trading Customers needs of people in the United States
and around the world. I am responsible for the design, development,
integration, deployment, and support for their IT Project Development
Team
Responsibilities:
. Implemented Business Data Catalogs with data from external source
of Data Access from DB2 into MOSS 2007
. Created Search Criteria and indexing
. Maintaining the SharePoint Content Management, synchronize contacts
info with ASP.Net Applications
. Responsible for the adoption of SharePoint 2007 which involved
gathering the business needs for every department.
. Created Microsoft SharePoint sites in order to provide the
organization with tools to improve business process, develop
forms and workflows, manage documents versions and improve
communications.
. Created InfoPath Online Document such as List. Issues, Help Desk
Issues, HR Leave Application, Expensive Report, Purchase Order,
Product Defective Issues,
. Created Links on websites to access documents
. Created Business Data catalog(BDC) and accessed other sources data
thru XML File
. Excel Services implementation in MOSS 2007, Report Center,
Dashboards and Score cards on Trading Stocks
. Created SharePoint Dashboard for on-Going Project
. Experience Microsoft Excel Macros for BI Reports, Dashboards and
Custom Score Cards.
. Lead Developers in SharePoint Portal Sever 2003 environment to MOSS
2007 Portal migration.
. Created Custom site Definition and features for new MOSS 2007
Portals.
. Configured WSS 3.0 Team sites, Document Libraries and Lists.
. Data Migration to MS Access and MS Excel
. Developed Custom Pages, workflows, WebParts using SharePoint Portal
Server 2007.
. Performed problem resolution procedures in regards to functionality
issues, calendar maintenance.
Roles and Responsibilities:
. Create Access to Audience to Departmental sites and Create user Access
Capabilities based on user class.
. Application Page Design, Multi Versioning Workflow 2007. Look and feel
customization Active Directory and SharePoint Console Application
Development Custom
. Administration on SharePoint Portal Server, Windows, SQL Server 2005
installation Configuration including Deployment along with Change
Management. System and Backup/Restore.
. Configuring Sites and Site Collections and search facility
. Designed and developed Global meeting approval form using InfoPath
2007, Develop custom workflow using SharePoint designer 2007 for the
meeting approval form.
. Content Management Maintenance, Create Info Path. Work Flow and Access
the outside Database like DB2
. Development of .Net, ASPX and DLL
. Created Search center site and custom site scopes
. Migrated existing InfoPath documents with workflows to new site
collections.
Environment : MOSS 2007,Sharepoint Designer2007,MS-Office,MS-VisualStudio
2005,C#, ASP.NET, MS-SQL Server 2005, Windows Server 2003, DB2
Honda Express - East Liberty - OH SharePoint Developer
06/06 to 05/08
Honda Express is Warehouse Management Facility to Honda Motors
Plant and has been dedicated for meeting with Warehouse Management
Team, Production and its IT Development Project. I am responsible for
the design, development, integration, deployment, and support for
their IT Project Development.
. Meetings/interview customer to capture specific requirements in
concise format
. Worked with customer staff personnel to support technical
strategy and control objectives
. Responsible for the adoption of SharePoint which involved gathering
the business needs for every department.
. Data Migration to MS Access and MS Excel
. Created SharePoint Dashboard for on Going Project
. Experience Microsoft Excel Macros for BI Reports
. Integrate SHAREPOINT with other tools and applications
. Develop collaboration, workflow, and InfoPath forms in SharePoint
. Created Microsoft SharePoint sites in order to provide the
organization with tools to improve business process, develop
forms and workflows, manage documents versions and improve
communications.
. Integrate SHAREPOINT with Microsoft Active Directory
. Configured WSS 2003 Team sites, Document Libraries and Lists.
. Performed problem resolution procedures in regards to functionality
issues, calendar Maintenance.
Roles and Responsibilities:
. Designed and Developed Estimation Tool using MOSS 2007, Create Access
to Audience to Departmental sites and Create user Access Capabilities
based on user class.
. Created various Custom lists to accept and store the user input.
. Application Page Design, Multi Versioning Workflow 2007. Look and feel
customization Active Directory and SharePoint Console Application
Development Custom
. Extensively used Visual Studio 2005 to build custom web parts and
Writing Event handlers and Custom Workflows
. Created Custom workflows using Sharepoint Designer 2007 to do the
complex calculations and sending e-mails.
. Created Site Columns for reusing the columns in different lists.
. Designed and developed Custom master pages for branding the
Application using Sharepoint Designer 2007.
. Used Agile development methods through out the project life cycle.
Environment: MOSS 2007,Sharepoint Designer 2007,MS-Office,MS-Visual Studio
2005,C#, ASP.NET, MS-SQL Server 2005, Windows Server 2003
Time Warner Cable - Charlotte- NC SharePoint
Consultant 06/05 to 05/06
Roles and Responsibilities:
. Responsible for the adoption of WSS 2003, which involved gathering
the business needs for every department.
. Created Microsoft SharePoint sites in order to provide the
organization with tools to improve business process, develop
forms and workflows, manage documents versions and improve
communications.
. Lead Developers in SharePoint Portal Sever 2003 environment
. Configured WSS 2003 Team sites, Document Libraries and Lists.
. Performed problem resolution procedures in regards to functionality
issues, calendar maintenance.
DHL Financial System - Scottsdale - AZ Consultant
01/05 to 05/05
The CREST (Common Reporting System) project was designed to deliver a
single group-wide tool based on SAP for group consolidation and reporting
requirements. Entities from DPWN's corporate divisions across the world
are required to provide data in a prescribed format to CREST at month-end
Currently this process is done manually for Canada; the objective of this
exercise was to develop automated interfaces for the Canadian entities to
provide accruals data to CREST
Financial balance sheet information, Profit & Loss by Partner by Asset
Type, Revenue / Cost information, Shipments/Quantities by Product by
Billing type, Corporate Notes(Accounting,, Controlling, Finance, Taxes)
by Asset type, Maturity, Leasing, Regions) needed to be extracted from
the AS400 system and mapped to the format specified by CREST. The data
files had to be in the prescribed formats and had to cater to CREST's
data validity requirements.
Roles & Responsibilities:
Facilitated and drove business and data issues, ownership, and subsequent
closure
Developed system requirements and user acceptance test cases and scripts
Mapped legacy interfaces for inbound and outbound CREST Systems
Identified collectable and renewal accounts to interface with an automated
calling system for customer service representative and tracking customers
Extracted legacy data from AS/400 files and legacy order management
systems.
Environment: Iseries, OS/400, RPGILE, SEU, FTP, ETL Tool, DB2
Interstate Paper Company - Riceboro - GA Consultant
01/00 to 12/04
Web Order Tracking System Project
The purpose of the Web Order Tracking System was to keep track of the
Customers Order Status and Order Shipping Status through the internet.
This application was developed using CGIDEV2 Tool, RPG and IBM API
applications
Warehouse Bar-coding / RF Terminal Project
This is a replacement module to an existing manual warehouse movement of
the MOVEX ERP System With new functionality shippers have the ability to
move the ROLLS or Transfer ROLLS from one location to another location
without errors.
Electronic Data Interchange Project
The EDI Shipping Manifesto Module was enhancement to the existing MOVEX
ERP System
EDI 856 Transaction Shipping Details will be retrieved as per 856
Standard Segment with trading -partners and ship-to-location details in
ASCI File Converted text data will be sent through FTP to the corporate
office where Gentran software will translate data and send to the Trading
Partner
Transmitting shipping information from MOVEX to Gentran is automatic;
setting up trading partner, ship-to-location is done at the Gentran
System.
Environment: AS/400, OS/400, MOVEX, EDI Gentran, RPG, SEU, DB2/400
Education: B.com
Post Graduate Diploma in computer Applications
Contact this candidate