Post Job Free

Resume

Sign in

Sql Server Manager

Location:
Simi Valley, CA
Posted:
May 25, 2017

Contact this candidate

Resume:

Venu Ryali ac0hos@r.postjobfree.com

Simi Valley,CA 805-***-****

Technical Skills:

Web Technologies

C#, ASP.Net, VB.Net, ADO.Net, Web Services, Reporting Services, Classic ASP, VB, Java Script, AJAX, HTML, XML, CSS, Web Server IIS 7.0

Databases

SQL Server, Oracle

Tools & Utilities

Visual Studio, VSS, TFS, GIT, Infragistics, Encompass, Applinx

Domain Knowledge

Finance, Trading, Insurance & Banking

Education

Degree

University

Year of Graduation

MCA

Osmania University

(May/1997)

BSc Computers

Osmania University

(May/1994)

Professional Summary

Seeking position in systems development.

19 Years of solid experience in developing and leading enterprise application development.

Hands on experience in all phases of Software Development Life Cycle (SDLC).

Working experience in ASP.Net,AJAX,WCF,WPF,LINQ,SQL Server,IIS, Visual Studio, Visual Source Safe, TFS and GIT.

Worked on MVC 4.0 and ADO.Net Entity Model

Knowledge in writing SQL Queries and T-SQL using MS-SQL Server.

Flexible and versatile to adapt to any new environment, work on any project

Experienced with OOP, Win Forms UI design understanding and experience.

Implemented SSO Authentication, SQL Injection to comply with Bank Standards.

Implemented critical reports using reporting services SQL 2005.

Exposure to BI tools SSIS and SSRS

Good knowledge of Database Management, programming and Web Application.

Good experience in coordinating and working with developers in Team based environment.

Always worked closely with Client team and have helped in giving Technical inputs and assisted them in system development and testing.

Flexible and versatile to new environments, self-motivated a good team player and have worked in multicultural environment.

Professional Experience:

PennyMac Role: Sr Developer Duration: Nov/2014 – Nov/2016

Polaris is end to end Mortgage web application which has modules of Account Setup/Login, Loan Terms, Loan Activity, Statements & Documents, eSign and Amortization Calculator

File Assignment Automates the loan assignment process

Responsibilities:

Hands on Coding for Web Applications using ASP.Net, C# and SQL Server.

Extensively Involved in SDLC phases

Developed Web API to pull Loan Terms

Developed eSign Feature

Developed File Assignment web Service

Involved in writing Stored Procedures for performing optimization and other database operations such as complex SQL queries, views and triggers etc.

Working on Deployment to QA with Configuration settings. Experience with IIS. Got an opportunity to work closely with QA for bug fixes to ensure the efficiency and accuracy of the code.

Build Internal web Site for File Assignment using MVC

Application hosted in AWS Cloud

Universal Music Group, USA Role: Sr Developer Duration: Mar/2014 – Nov 2014

TRACS GUI Universal Music Group is an Entertainment Domain deals with artists and comes up with new music Albums by paying royalty. TRACS GUI Manages metadata associated with the music such as Artists, Albums and Songs. Manages comments, ratings on the music submitted by users. Provides features like Playlists and search engine. Responsibilities:

Hands on Coding for Web Applications using ASP.Net, C# and SQL Server.

Extensively Involved in SDLC phases

Developed Admin interface to manage metadata associated with the music such as title, album, artist

Implemented music upload feature

Developed Search Engine

Involved in the Database design, wrote stored procedures, database views for the underlying SQL Server Database.

Coordinate design and implementation of applications, collaborating with project managers, development team and client representatives to ensure on time completion of project deliverables

Bank of America, Hyderabad, India Role: Sr Manager Duration: Jun/2008 - Jan/2014

Description:

FACTS the Fraud Activity and Case Tracking System (FACTS) Application is used for the Home

Mortgage sector. FACTS is a web-based system application used by Fraud Investigations group in

Managing, monitoring and tracking possible fraud activities within Bank of America mortgage loan

Portfolio.

Environment:

.Net Framework, C# with Visual Studio Tools for Office, ASP.Net, VB.Net, VB Scripting, AJAX, ADO.Net, .NET Frame work 2.0/3.0, Visual Studio Debugger, Windows XP, SQL Server, Windows Servers.

Responsibilities:

Hands on Coding for Web Applications using ASP.Net, C# and SQL Server.

Extensively Involved in SDLC phases

Involved in Technical design documentation and Created Opportunities in HLD/LLD Phase

Within Bank always made sure application is compliant by Implementing SQL Injection, by Executing code scanners and by SIAI findings.

Implemented SSO for Application

As part of Innovation Implemented .Net windows, Web, DB based Tools which where shared across the other projects extensively.

Contributed extensively towards saving efforts, and improved customer experience through implementation of Development tools: Schema Diff Extractor, Job Monitor, Application Object Finder and Release Verification Tool.

Implemented 4.0 .Net Graphs/Charts for legacy ASP application.

Efficiently handled various projects, managed offshore and coordinated with onshore teams.

Interaction with users/client.

Built SME knowledge within team.

Countrywide, CA, USA Role: Sr Developer Duration: Aug/2006 - Oct/2007

Loan Search Refresh aimed at loading the monthly and daily CHL feeds to production database on monthly and daily basis. Preprocess validates the txt feed files and reports the errors with each txt file it found and finally creates correct version of TXT file which can be used for Loading data into tables.

Opt In The purpose of the opt-in project is to provide an automatic notification method by which the customer is kept informed of their account activity. Customers will initially have to opt-in to enable this notification process for their account and can call in to disable this feature at any time.

Responsibilities:

Involved in SDLC phases.

Involved in Technical design documentation.

Hands on Coding for Web Applications, Windows Applications, Windows Services using ASP.Net, C# and SQL Server.

Efficiently handled various .net projects, managed onsite and offshore teams.

Interaction with users/client.

Responsible for Overseeing the Quality Procedures related to the projects.

Multiple threading Implementations.

Implementation of Interaction with MSMQ (For Read/ Write response to and from AS 400)

Provided business analysis, gathered requirements, designed and developed integrated IT solutions and business processes to meet client and internal user requirements.

Created technical, functional and business specifications

Met regularly with Boeing User Groups to determine software solutions to make the tool run overall more efficiently.

Consulted with teams to determine the technical feasibility of client requests and provided time estimates.

Worked with high level business managers to effectively prioritize activities and achieve defined objectives.

Monitored progress on tasks and status of deliverables

Was responsible for obtaining acceptance on coding standards and deliverables.

Participated in all status review meetings.

Environment:

Microsoft .Net 2.0, .NET Framework, C#, Visual Studio 2005,SQL Server 2005,Sharepoint 2007, Oracle,ADO.NET

Satyam Computers Services Ltd Role: Senior Systems Analyst Mar/2005 - Aug/2006

Client: State Farm Insurance, IL, USA

Auto Commercial Rate Quote (ACRQ) This application wizard aims to calculate Quote results, print Results, Quote Side by Side Results for all the different defined coverage for all the states of USA

Had been to Bloomington, IL, USA for Knowledge Transfer

Used Customization Techniques to develop tools like Exception Merger and Spec Reports.

Client: Microsoft, WA, USA

PAG Web Development Have two different modules. The first one is Page Planner Tool, which can be used to develop web pages for PAG group. The Second one is Customizing the Pagportal Site on Share Point Portal Server.

Had been to Microsoft, Redmond, WA, USA for Knowledge Transfer

Worked on Share Point Portal Server 2003

Used Customization Techniques and created several Web parts & Deployed on SPPS.

Worked on Whidbey and Yukon features.

Worked Extensively on Grid view, Web Parts etc.

Used SQL Imail, Notification Services and Reporting Services.

UNX Inc., CA, USA Role: Advanced Tech Developer (Dec/2002 - Jan/2004)

Account Setup: Account Setup Wizard for easy to use for clients which includes functionality of Add/View/Edit Wizard to set up their accounts. The Sections included in the Account Setup Wizard are Account Base Info, Commission Setup, Clearing and Partners, Account Preferences.

Payment Service System has modules Customer, Partner, Trading, Brokerage, Reports, Accounting, Admin., Developed Add/View/Edit Customer, Contacts, Partner, Vendor, Also Responsible in developing various Back Office and Front Office Reports like Gross Margin, Income, Activity, Trade Activity,

Design and Coding.

Developed middle tier

Implemented Send Email, Export data grid to Excel features in Reports.

Developed User controls and Custom Controls to be used in the Application.

Testing - unit testing & integration testing

Responsible for overseeing the Quality procedures related to the project.

Responsible for designing and maintaining the UNX Public website

Contribution/Responsibilities

Provided IT design, implementation and support services to clients.

Exposure towards industry-leading practices in software development, management and client relations. Served as Architecture Team Lead for Major client.

Built several web/windows applications and windows services

@Business Inc., CA, USA Role: Sr Web Developer Dec/2001 - Nov/2002

Client: Southern California Edison, CA, USA

Software Inventory Keeps track of Servers Software and Hardware information connected to the different domains, dynamically from the windows Registry of Southern California Edison Company, USA.

Used VB API programming to get the software and hardware information from Windows Registry.

Developed Business objects using VB.NET (This COM aims to know the information about the new, modified and deleted dlls or exes from any server by Compares the Latest Version to the Database Version. If there is any change, this let concerned people know by an Email.)

Used ADO.NET for accessing data from the SQL Server 2000 database.

Used ASP.NET to display information about all the domains, servers, workstations, and all SQL servers and created a User Interface for the manual entry also.

Created stored procedures and accessed them in creating business objects

Designed the system and involved in the creation of GUI Interfaces and Database.

Involved in coding, deployment and testing of entire Application in all phases.

Developed EDI programming in VB COM to put latest data onto FTP (used X12 format).

Vibex Inc, CA, USA Role: Web Developer Nov/1999 - Nov/2001

Web Tools Has aimed at creating generic tools like Search Manager, Promotion Manager, Auction Manager, and Catalog Manager for customizing the websites. With minimal changes in code these tools will be suitable for any customer requirements.

Developed ASP page to generate XML documents to transfer the Meta data between business applications of servers.

Implemented Site Server Functions like Adding to Basket.

User interface was designed to add, edit and deletion.

Implemented credit card validations and subsequent transactions.

Used CDONTS as mailing Component to automatically respond upon special promotions.

Developed error routines to check for user data entry in JavaScript.

Extensive use of file system object.

Folder options like new, rename & delete were implemented online.

The VB COM methods are helpful to create new database and populates the database from XMl.

Windows Scripting Host (WSH) was used to run a vbscript page at regular intervals to send email

reminders.

Digital Rights Management: This project concept is to provide facility to download the music files from the web site. The downloading module contains License agreement part, small search part. Has three modules. Membership, Approval, Download.

Developed a routine to handle user data entry errors.

Developed a VBscript file – searches the database based on the criteria provided using ASP.

Responsible for performance tuning of the application.

CompUSA Ltd, Hyderabad, India Role: Software Engineer Jun 1997-Jun 1999

Aimed at creating following modules and wanted to sell them in the market for general purpose.

Integrated Financial Accounting System computerizes the day-to-day activities of the accounting department of a company, which includes Accounts Receivable, Accounts Payable, Inventory Control, Cash & Bank transactions and Sales Invoicing. Generates all the account books, Trail Balance, Profit & Loss statement and Balance Sheet.

Resume Data Banking is developed to maintain the Personal details of candidates and their resumes. Facilitates searching for resumes by candidate reference number, experience, platform or qualification. User will have the facility to view, Modify or delete candidate records from database. At the same time the user can perform the same operations for existing resumes, which are in MS Word.

Developed Web-interface using ASP, HTML.

Involved in writing stored procedures using Oracle.

Involved in Creating VB COM and Created Web Reports using Crystal Reports.

Involved in using VB5 application and Crystal Reports 4.6 for Report Generation.



Contact this candidate