Project Sql Server

Venkat Gummalla

+1-205-***-**** **********@*****.***

Summary

12+ years of software development & consulting experience

Experience in designing and developing web-based solutions for clients that address critical business needs.

Strong in SharePoint 2010/2013, InfoPath form design and customizations and .Net technologies and Knowledge on SharePoint Online.

Hands on experience using K2 blackpearl and K2 smartforms.

Good in R&D and POC implementation for business requirements

Received prestigious “Hitachi ITSC Annual Award for Technical Excellence”-2015 for "Enterprise Solutions Accelerators for Technology Consulting" contributions

Strong technical skills in using C#, ASP.NET, ADO.NET, MVC 5.0, Angular JS, JQuery, Web Services, Entity Framework, WCF Services, JavaScript (ECMAScript),TFS, VSS among other technologies.

Exposure to Xamarin, Android development, ReactJS, Amazon Web Services (AWS) and NoSQL Database (MongoDB) and GitHub Source control repository.

Experience on Single Page App (SPA) development.

Extensive experience in implementation of Web Application, Web services and WCF Services using .Net framework. Strong knowledge in Database Programming with RDBMS databases like PostgreSQL 9.6.2, SQL Server 2005/2008/2012, Oracle and MS Access.

Excellent in writing PL/SQL Queries, Stored Procedures, Triggers and Cursors.

Strong Knowledge of SQL Reporting services (SSRS). Conceptual understanding and implementation experience of using N-Tier and Client/Server Architecture.

Experience on unit testing frameworks MOQ and Jasmine/Karma

Familiar with Bootstrap framework, CSS (Less) for responsive web development.

Experience in working with short sprints in an Agile SCRUM software development model, good understanding of Scrum process.

Experience on task management tool (JIRA).

Ability to work in fast paced co-development client teams and our teams which are often diverse and cross cultural

Exposure on Jenkins for Continuous Integration (CI)/Continuous Delivery(CD)

Good in leading team with mentoring and coaching abilities.

Knowledge

Languages: C#, VB.Net, VB6.0

Technologies: ASP.Net, ASP3.0, MVC5.0, Web services, WCF Services, AJAX, SQL, IIS 6.0/7.0, VSS 6.0, UML

Database Connectivity: ADO.Net, ADODC, ODBC, Entity framework

MS Office Servers: SharePoint Server 2013, SharePoint Online, SharePoint Server 2010, Office SharePoint Server (MOSS) 2007, Project Server 2007 (Enterprise Project Management)

Reporting Tools: SSRS 2005, Crystal Reports, MS Access 2003 reports

Workflow Product Suites: K2 Workflows, Nintex Workflows

Markup languages: XML, CAML, HTML

Databases: PostgreSQL 9.6.2, MS SQL Server 2000/2005/2008/2012, Oracle 9i/10g, MS Access 2003/2007, NoSQL Database (MongoDB)

Configuration Management: TFS, Visual Source Safe, CVS, SVN, GitHub

Scripting Languages: VB Script, JavaScript, JQuery, Angular JS, ReactJS, Knockout JS, kendoUI

Operating Systems (OS): Windows 2000, WinNT, Windows 95/98, Windows Server 2003/2008

Design Tools: Microsoft Visio

IDEs: Visual Studio 2003/2005/2008/2010/2012, Visual Studio 6.0, Xamarin Studio

Testing Framework: MOQ, Jasmine/Karma

Project Experience

Jack Henry & Associates Inc.

ERMS Due Diligence Questionnaire Application Feb 2017 – till date

As part of the Bank Secrecy Act (BSA) financial institutions (FIs) who are regulated by the United States government are required to research every customer and account held at their institution for possible suspicious behavior. They are required to report this suspicious behavior to FinCEN, the United States Financial Crimes Enforcement Network. To comply with this regulation, the FI is required to understand what “normal” behavior should be for each customer and account and use this as a baseline for identifying “suspicious” behavior. The process for doing this is commonly referred to as Customer Due Diligence (CDD) for customers and Account Due Diligence (ADD) for individual accounts. Additionally, the FI is required to perform supplemental research on any customer or account that that presents a higher risk for money laundering or terrorist financing. This is commonly referred to as Enhanced Due Diligence (EDD).

To assist FIs in fulfilling CDD, ADD and EDD requirements, Jack Henry is developing a “Due Diligence Questionnaire Application” (DDQA). The DDQA is responsible for allowing the FI to create questionnaires for CDD, ADD and EDD that can be completed, stored, and sent to the back-end for scoring.

The DDQA is being designed for use within the Company’s Financial Crime Risk Mitigation (FCRM) product. FCRM is currently in development and will be developed in parallel with the DDQA. FCRM is a joint development effort between company and its vendor.

Development Features:

Single Page App design & development with UI in consistent with existing SAS modules

Login integration with SAS Application(hosted on PCF)

Questionnaire View, Setup, answers

oCDD / ADD / EDD

Integrations with other JHA products

oBranch Anywhere

oPlatform Services products

oStreamline

Data Migration from existing system

Technical contribution:

Questionnaire Tree building component with branching of questions to any level

Components building for answering to questions in questionnaire

Data Migration Package development

Writing Unit Test cases

Assisting to QA team in automation of test cases

Technologies: .NET Core, Angular JS 1.5 with Typed Script, Bootstrap 3, Jasmine Karma for Unit Testing, MOQ testing framework, Enterprise Library, Visual Studio Unit Testing, Rest APIs, Microsoft.log.Extensions.logging for logging, PostgreSQL 9.6, GIT for source control, JSON, Visual Studio 15, JIRA Confluence for Project/Task Management

Hitachi Consulting Inc.

Hitachi-Sales Web Portal Mar 2015 – Jan 2017

Sales Web Portal is designed as one stop portal application to address one of the key issues faced by the GTM Teams (this term is intended to incorporate Technology, OS, and MC&I Sales Teams across the globe) to discover and assemble the required information from various data sources and put together the marketing and project proposal response collateral. Multiple locations of data sources multiplied with lack of authoritative information at any point of time makes the process of putting a proposal and estimate together a laborious, manual and time consuming process which puts the company at risk of losing opportunities due to missing tonight deadlines.

Analysis of business requirements

Design for implementation

Coordination / Liaison

Project Management activities

Business sales processes work flow implementation using K2 Black Pearl

Execution, Tracking and Technical Support

POC for Mobile App using Xamarin Studio for Android and MongoDB for Android

POC Amazon Web Services configuration and consuming

Stage refreshing with PROD databases

Technical contribution:

oCustomizations, Custom web parts design & development

oBuilding pages

oDesign and implement sales process work flows using K2 blackpearl 4.6.11

oExploring K2 connect and POC for integrating SharePoint with SAP

oUsed Angular JS in user interfaces development

Technologies: Visual Studio 2012/2015, MS SharePoint Server 2013, K2 blackpearl 4.6.11, JQuery, ASP.Net, C#.Net, Angular JS, SQL Server 2008/2012, SQL Server Reporting Services, XML, XAML, REST Services, Xamarin Studio and TFS.

Daniel J. Edelman Inc.

Team member, SharePoint Applications Migration to SP2013 Apr 2013 – Feb 2015

Edelman Learning Institute (ELI) is an intranet application to take online Edelman courses; Client Budgeting Tool (CBT) is budget capturing tool and Hunter is a tracking tool to track complete information related to Edelman’s new business opportunities. These applications are developed using SharePoint 2010 and C#. As part of upgrading these applications need to migrate from SharePoint 2010 to SharePoint 2013.

Pre-Migration analysis methodology definitions

Migrating/upgrading sites

Coordination / Liaison

Production Support

Technical contribution:

oSharePoint Learning Kit (SLK) installation and configuration

oSharePoint Learning Kit (SLK) related issues resolving

oProviding specifications for SLK supporting on-line modules built

oSharePoint Custom work flows for alerts

oCustom reports generation based on SLK scores and admin site configurations

oScores migration from legacy system to new ELI migrated system without impacting scores and module status

oCBT, Hunter and remaining Edelman applications migration and issues addressing

oUsed JQuery and Angular JS in user interfaces development

oM&A Dashboard building with JQuery

oBuilding custom web part with the functionality built using InfoPath form

oUsed JQuery and Angular JS in user interfaces development

oReporting data migration

Technologies: Visual Studio 2012, MS SharePoint Server 2010/2013, JQuery, WCF Services, REST Services, SharePoint Learning Kit, SSRS 2008/2012,MVC, ASP.Net, C#.Net, Angular JS, JQuery, SQL Server 2012, Entity Frame work, JQuery, SharePoint Learning Kit and TFS

Daniel J Edelman

Team member, Hunter & Hammer

The Hunter on Fusion will function as the one-stop shop for all tracking related to Edelman’s new business opportunities. This is addressing the challenge of CRM licenses cost by developing a .Net websites as interface for users to store and manage data in CRM entities. This tool will encompass the following stages of a new business opportunity:

Pipeline management

System alerts/ Workflow

Opportunity management & Proposal debrief

Asset sharing & Searching assets and related opportunity

Reporting and analysis

Design and implementation of Technical solutions

CRM Customizations/ Workflow activities creation

The user interface is spread sheet on webpage

Production Support

Technical contribution:

oJQuery functionality implementation,

oServices implementation and consuming

oFactory design pattern used to connect to DB server & Singleton pattern for logging

oMaster pages designed to maintain standard look and feel

oUsed Office excel component for spreadsheet user interface to edit the data by user

oXSD is used for data validation

oCRM customizations and work flows building

Technologies: MS SharePoint Server 2010, JQuery, WCF Service, JSON, MS CRM 2011

Daniel J Edelman Inc.

Team member, Client Budget Tool (CBT)

Client Budgeting Tool (CBT) is budget capturing tool that helps the Project managers / business managers in Edelman to log and capture the budget information of various ongoing and new business projects that they are involved with. This is developed to replace the existing excel based application to overcome its drawbacks. There are four major modules in the CBT application

Rate master – This captures all the required information for the CBT application which is available in PeopleSoft.

CBT Application – The actual application which will help in creating projects / activities / revenue schedules / resource information, displays the activity summary report and manages the approval workflow along with creation of the interface file

Approval Workflows – The approval / rejection workflow logic for the budgets approval

Submit to GFS– The approved project information will be updated to People soft (GFS).

This tool has many specific features like creating budget as copy of existing budget, creating activity in project as a copy of other activity in same project, viewing all versions of budget which are submitted to GFS (Global Finance systems) etc.

Responsible for technical solutions implementation and delivery on SharePoint Server 2010.

Technical contribution:

oChanges implementation in InfoPath form

oImplemented proposed technical solutions

oCustom web parts development & InfoPath customizations

Technologies: MS SharePoint Server 2010, InfoPath 2010, Workflows, VS 2010, REST Service

Sony Software Center Ltd.

Technical Project Leader, PMO Application

PMO App is an application used by Project Management Office (PMO) in Sony Latin America (SOLA) to track the projects in terms of schedule and cost. PMO is responsible to initiate the project with process model and life cycle of project in PMO App then Project Manager (PM) is responsible to update the information periodically in tool. PM has option to upload the deliverables of each phase of project into tool. The PM can specify his comments whether project is on schedule & on budget. There are reports like “Project Snapshot”, “Project Summary by Project Managers”. These reports are used by PMO to know the status of each project in SOLA region.

Responsible for understanding the Business requirements and plan for technical solutions.

Responsible for the delivery of the solution on MOSS 2007 Server and SharePoint 2010.

Involved in Co-ordination between development team and the SharePoint Admin team.

Work breakdown, deciding on Timelines, Estimations and Tracking.

Assisted the team in understanding the Requirements, design of various algorithms and the Performance requirements of the system

Conducted training sessions for the team to understand the Requirements and Performance requirements of the system.

Involved in code reviews, standard performance and functional reviews.

Involved in Test cases reviews

Technical contribution:

oDesigning the application after requirement analysis

oCustom web parts development using VS2005& VS2008

oInfoPath forms development

oDeploying InfoPath forms as content types on SharePoint Server

oDeveloping work flows to meet requirements

oBranding the site using SharePoint designer

oResolving technical queries of supporting team

oExcel as data source to KPI using excel services

oLDAP access for user profile reading

oMigrated this site to SharePoint 2010 (Jun 2010-Aug 2010)

oMacros writing for custom functionality

oSQL Server Reporting Services (SSRS) reports development using Dundas charting

oConnecting SharePoint lists to Access 2007 to use for custom queries for excel repots

Technologies: .Net framework 3.0, MS Office SharePoint 2007, InfoPath 2007, VS 2005

Education and Certifications

Bachelor of Technology Degree in Computer Science and Engineering from Jawaharlal Nehru Technological University, Hyderabad

Attended Reporting and SQL Server Reporting services (SQL Server 2005) in Microsoft Development Center, Bangalore

Attended Enterprise Project Management (Project Server 2007) in Microsoft Development Center, Bangalore

Microsoft Certified Technology Specialist “Office Project Server 2003, Business Planning Design Toolkit”

Microsoft Certified Technology Specialist “SQL Server 2005”

Microsoft Certified Technology Specialist “.Net Framework 2.0, Web Applications”

Contact this candidate