Post Job Free

Resume

Sign in

Manager Sql Server

Location:
Malvern, PA, 19355
Posted:
March 04, 2017

Contact this candidate

Resume:

Sri Surapaneni Phone# 920-***-****

Email: acy4j1@r.postjobfree.com

Summary:

15+ years of extensive experience with managing, leading, analyzing, designing, development, and maintenance of web/business applications. Exposure to a wide range of platforms and software systems. Well versed with full SDLC

Highlights of Expertise: Software Engineering, Business Requirements, Project Management, Technical Development, Quality Assurance, Cross-Collaboration, Team Leadership, and Business Solutions

Expertise in full software development lifecycle, software development methodologies (Agile Scrum), application testing (TDD), and process re-engineering.

Core Qualifications:

8+ years high knowledge of .NET and Microsoft-based portal frameworks ASP.NET, C#, VB.NET, MVC, Entity Framework, WCF, Web API, Windows Applications, SQL Server, SSIS, SSRS and Console Applications.

Have strong experience in developing and deploying web applications using ASP.NET,

MVC and C#.

Extensive experience in Sitecore Content Management System (CMS) and integrated with .Net applications with MVC.

Very good knowledge and experience in Object Oriented Programming.

Experience in developing and deploying services using ASMX, WCF and Web API (REST).

Have good experience in Object Relational Mapping (ORM) using Microsoft Entity Framework.

Have strong experience in integrating with external applications like Salesforce, Eloqua and DocuSign.

Extensive experience in Web development using HTML, CSS, JavaScript, Ajax, JQuery, and Bootstrap UI framework.

Strong experience in developing and scheduling SQL Server Integration Services (SSIS) packages and SQL Server Reporting Services (SSRS) reports.

Expertise in Relational Database Design, developing and creating data base objects (Stored Procedures, Tables, Triggers, Views, Indexes and Functions).

Experienced in Test Driven Development (TDD), Mocking Frameworks (Moq) and Dependency Injection (Unity, Ninject).

Experience in using Team Development for Sitecore (TDS) and Sitecore Rocks to integrate Sitecore into Visual Studio

Experience in Software Configuration Management (Daily Build, Release and Versioning methodology) using tools like Team Foundation Server (TFS), Microsoft Visual Source Safe (VSS), Sub Version (SVN), TeamCity and Octopus deployment.

Have good experience in Agile life cycle management tools like Rally and Version One.

Certified developer in MongoDB.

Technical Skills:

Operating System : Windows

CMS : Sitecore

Databases : SQL Server, MS-Access, DB2

Framework : .NET Framework

Development : Visual Studio, ASP.NET, C#, VB.Net, C, C++, VB, VC++, MVC, Win Forms, WPF, Entity Framework, Enterprise Library, ADO.NET, WCF, WPF,

Web Services, Web API (REST), JavaScript, AJAX, JQuery, JQuery Data Tables, Knockout, Angular, Bootstrap, VBScript, ASP, HTML, CSS, DHTML, XML, XSLT, Infragistics, AJAX Control Toolkit, SQL, T- SQL, Unity, Ninject

Web Server : IIS

Business Intelligence : SQL Server Reporting Services (SSRS) and Integration Services (SSIS)

Tools : Microsoft Office Visio, Rally, Version One, Octopus, TeamCity, TDS

Version Control : Visual SourceSafe (VSS), Team Foundation Server (TFS),

Subversion (SVN) and GitHub

Bug Tracking Tools : TFS, Test Director, Quality Center, Rally

External Systems : Salesforce, Eloqua and DocuSign

Content Management

FileNet P8 suite 3.5/4.0, Content Manager, Process Manager, FileNet Capture Desktop/Capture Professional 3.1/4.0/4/1, Panagon Content Services 5.2, FileNet Visual Workflow, Panagon Image Services 3.6/4.0,eProcess 4.2/5.0/5.1, FileNet IDM Desktop 3.1/3.2/3.3, IDM Desktop web programming, Panagon Report Manager 4.0

Education:

Masters in Business Administration from Jawaharlal Nehru Technological University (JNTU), INDIA. Specialization in Systems.

Post Graduate diploma in Management Information Systems and Computer Applications.

Professional Experience:

Project: Business Service E-Commerce Experience August 2014 – Till Date

Client: Comcast.com, PA

Employer: Visual Consultants Inc

Role: Senior Software Engineer

Description: Buyflow is an ecommerce project for better and full order processing experience, eliminating the need to go to chat to complete order. Integration with ESP/SCMS services to further enhance the customer experience, improve processing efficiencies and reduce manual processing cost.

Responsibilities:

Analysis, design, development, testing, troubleshooting, deployment and support of software systems that meet the business requirements.

Perform software construction, unit testing and debugging. Software construction may include the preparation of new software, reuse of existing code, modification of existing program, or integration of purchased solutions.

Perform full SDLC in design and development of web and windows based solutions using technologies/tools like ASP.NET, C#, Web Service, WCF, XML, AJAX, .NET Framework, SQL Server, T-SQL, CSS, JQuery, Visual Studio, SSMS. Responsible for Database analysis, design and development.

Work with Business Analysts, Solution Designer, and Technical Architects to review the business requirements and prepare detailed technical design documents.

Perform different kind of tests on components, module or systems from unit tests to regression testing and integration testing. Develop testing plans, cases and automation plans for unit and regression testing.

Work with Business Analysts, QA Team and other IT professionals to identify and resolve issues in QA, Stage and Production environments. Worked on production support and bug fixing

Environment: ASP.NET, C#, .Net Framework 3.5/4.0, WCF, Web API (REST), .NET Class Libraries, Visual Studio.NET 2013/2015, SQL Server 2008/2012, SSRS, TFS, Entity Framework, IIS, Windows 2008, Site Core, JQuery, AJAX, Java Script, CSS and HTML.

Project: Integrated Client Information Systems (iCIS) June 2012 – July 2014

Client: Deloitte Consulting LLP, PA

Employer: Visual Consultants Inc

Role: Senior .Net developer

Description: iCIS suite is a set of tools which supports case processing, determines eligibility, authorizes services and distributes benefits. iCIS provides County Assistance Office (CAO) workers ability to enter new applications received in CAO and view or modify existing applications already in the system. iCis allows users to perform a variety of necessary functions including recording applicant demographic data, performing clearance on individuals, recording categories for which the applicant(s) is potentially eligible, evaluating the client for expedited food stamp entitlement

Responsibilities:

Interact and coordinate with Eligibility team members to develop detailed software that will drive the design, implementation and testing of consolidated application.

Implemented AJAX methods to validate on server side using JQuery and JavaScript.

Integrated case processing and eligibility rules engine to determine the eligibility

Wrote database packages, stored procedures and queries in Oracle 11g.

Environment: .NET framework 3.5, Visual studio 2008/2010, ASP.Net, IIS, TFS, Oracle 11g, XML, WCF, Web services, AJAX, Java Script, JQuery, HTML and CSS, FXCop, Corticon Rules Engine.

Project: SURE System, Department of State, PA July 5th 2011 – May 2012

Employer: Acclaim Systems

Role: Senior .Net developer

Description:

Statewide Uniform Registry of Electors application automates the registration process of a citizen to vote. The Department of State migrated their existing Election Systems Manager (ESM) – MS Access application to .Net with Sqlserver 2005, in addition to set up the Reporting / Data warehousing Model for their MIS needs.

Responsibilities:

Involved in enhancing the Voter, Security and registration modules in ASP.NET

Supporting Sure VR system through Tickets on daily basis.

Designed the reports for sure VR.

Involved in Performance Tuning of existing Stored Procedures

Environment: .Net3.5, Visual studio 2010, VB.net, ADO.net, Win forms, ASP.NET3.5, WCF, Web Services, AJAX, SQL Server 2005/2008, SSRS, SSIS, XML, T-SQL, JQuery, MS Access 2000, MS Excel

Project: Account Manager System, Humana Insurance, WI Jan’ 2010 – Jun 2011

Employer: Syntel Inc.

Role: Project Lead, System Analyst

Humana acquired KMG America which offers life and health insurance products and services.

Current process – medical, dental, vision and Humana group basic life and voluntary life are renewed on Account Manager. STD/LTD and KIC Life are renewed on KMG systems.

Proposed Process - All lines are renewed through Account Manager.

Responsibilities:

Involved in Analysis, Design and development of the application

Played a role of Project Lead for the team eight and coordinated with the Humana Insurance in understanding the existing system and business

Responsible of handling and delivering all the tasks end to end and on required basis, created Technical specifications and is shipped to offshore for development and testing

Environment:. NET3.5, C#, ASP.NET 3.5, .NET Class Libraries, Visual Studio.NET 2008, Team Foundation Server, XML, JavaScript, ADO.NET, WCF, Web Services, AJAX, MS Enterprise Library, IIS, CSS, Windows 2003, SQL Server 2008, DB2 and ASP.NET AJAX Toolkit

Project: RQUW System, Humana Insurance, WI Sep’ 08 – Dec’ 10

Employer: Syntel Inc.

Role: Project Lead, System Analyst

Rating Quoting Under Writing (RQUW) - All the Small & Large Group Rating for Medical, Dental, Vision & Life Plans is done through RQUW. RQUW contains different subsystems which include Quoting, Enrolment, Renewals, and Benefit Maintenance.

Responsibilities:

Played a role of Project Lead for the team eight and coordinated with the Humana Insurance in understanding the existing system and business.

Responsible of handling and delivering all the tasks end to end and on required basis, created Technical specifications and is shipped to offshore for development and testing.

Acted as a liaison for Humana and to the team members in terms of all the security issues, Weekly meetings, Product Releases, Timesheets of all the team.

Responsible to see that the Customers which encompass Under Writers, Brokers, and Groups who access RQUW system do not face a down time.

Environment: .NET 2.0, ASP.NET, C#, Visual Basic 6.0, ASP, Main Frame, SQL 2005, SSIS, TFS, UIP Application Block, Visual Source Safe, Document Direct, MTV (Metavance)

Project: CoFEE (Converged Front End Engine), Verizon, TX Jul’ 08 – Aug’ 08

Employer: WIPRO Technologies

Role: Project Lead, System Analyst

CoFEE is a high-performance, windows-based system used for placing orders related to installing, changing, moving, or disconnecting Telephone Service, Data Internet Services and FIOS TV.

Responsibilities:

Worked as a support lead for production support team for fixing IR's/REDLIGHTS all related to GUI.

Responsible for all Presentation GUI related enhancements.

Environment: Visual Basic 6.0, Visual C++, UNIX

Project: DOMTAR Image Migration, Weyerhaeuser, WA Mar’ 08 – Jul’ 08

Role: System Analyst

Migration of IS documents: DOMTAR is one of the sister concern to WY (Weyerhaeuser). Developed utility for Import / Export of documents to/from IS (Image services). Import: Extracted the images and as well as Report Manager Documents as a whole or as a chunk. This utility is a dual mode application which has a rich user interface as well as Command line mode. The extracted documents can be saved in various file formats like text and pdf. With this tool, documents can be imported as a bulk which is not possible out-of-box. Export: The same utility can be used to export the documents in IS as well.

Responsibilities:

Played a role of Team Lead and coordinated with the DOMTAR business.

Analyzed the collected data and converted the data into Use Case diagram, Sequence Diagram, Data Flow for the proposed utility in Visio.

Developed the tool as a dual mode application which has a rich user interface using FileNet APIs as well as Command line mode.

Developed the logic to split the Report Manger text documents into chunks.

Environment: Visual Basic 6.0, Panagon Image Services 4.0, Report Manager Desktop 5.0.2.013, Panagon IDM Desktop 4.0, SQL Server 2005, Visio Professional, Visual Source Safe

Project: FileNet BPM Consulting, Weyerhaeuser, WA Sep’ 07 – Feb’ 08

Employer: WIPRO Technologies

Role: Senior .Net developer, FileNet Consultant

This project was to build the BPM solutions for Weyerhaeuser Company across the departments. The departments to which we provided the solutions are, Master Data Management (MDM), Document Management Group (DMG), and IT Security (ITSP). The solution included FileNet workflows for driving the processes, eForms as user interface and integration with existing systems.

Responsibilities:

Acted as a technical cum Business consultant.

Interviewed different stakeholders for gathering the business requirements.

Designed the FileNet Workflows using FileNet Process Designer.

Designed the forms using FileNet eForms designer.

Environment: SQL Server 2000, SQL Server 2005, FileNet P8, WebLogic, Business Process Management, Content Management, VMware, Citrix Web Interface

Project: BPM Consulting, Nintendo of America, WA Jun’ 07 – Aug’ 07

Employer: WIPRO Technologies

Role: FileNet Consultant

Consulting engagement to evaluate five Business Process management suites and provide recommendation for selecting one suite, after considering stated and implicit needs of the customer and an architectural assessment of the as is state and understanding of future IT road map. BPM Tools:

BPM products IBM Web sphere Process server, Web method, JBoss BPM, Aqualogic BPM, Fujitsu BPM.

Responsibilities:

Responsible for analyzing the technical feasibility against the business requirements.

Analyzed various BPM tool features against the requirements and rated them.

Project: GLOBAL IMAGE, Franklin Templeton Investments Oct’ 04 - May’ 07

Employer: Innova Solutions

Role: Senior .Net developer

This project provides facility for FTI (Franklin Templeton Investments) employees, to store and access documents related to transfer agencies. The process automation is done for these documents flow in the organization. Global IMAGE is a suite of applications (Capture, Document Inquiry, and Workflow) that turns scanned documents into electronic images and work items and the GIUI provides access to all Global IMAGE web based applications. The application is built on FileNet Image Server and eProcess suite of products using Microsoft technologies.

Responsibilities:

Involved in Analysis, Design and Development.

Documented Technical Specs and provided the solutions to improve the performance of accessing the imaging and workflow applications.

Prepared Unit Test cases and participated in Implementation for all rollouts across the Globe, which works in different Time Zones.

On-call support for the existing application monitoring, analysis and problem resolution.

Environment: Visual Basic 6.0, ASP, .NET, FileNet Panagon Capture 4.0, Panagon IDM Desktop 3.2, Panagon Image Services 3.5, Content Services 5.2, eProcess 5.0 IIS 5.0, ORACLE 9i, XML, Crystal Enterprise Server, Crystal Reports

Project: BIRDS (Bank Wide Interactive Remote Depository Services) Nov’ 99 – Oct’04

Employer: Oriental Bank of Commerce (erstwhile Global Trust Bank), INDIA

Role: Developer

GTB is one of the leading Depository Participant (DP) trading with NSDL and CDSL with a customer Base of more than 0.25 million and 4 DP licenses serving the needs of client throughout India. In Depository Systems, securities are held in depository accounts, which is more or less similar to holding funds in bank accounts.

Responsibilities:

Involved in all versions of requirement analysis, design, development

Developed stored procedures, functions, triggers in T-SQL and created Crystal reports.

Involved in writing Test Cases, Testing Application and Implementation plan.

Maintained System documentation and User Manual for the product.

Environment: Visual Basic 6.0, ASP, .Net, ASP.Net, COM, ActiveX, HTML, DHTML, JavaScript, VBScript, CSS, SQL Server 2000, Crystal Reports and WinNT



Contact this candidate