Ram Sanepalli

COLUMBUS, OH *****

E-mail: adgxif@r.postjobfree.com

Phone: 216-***-****

Work Status: US Citizen

PROFESSIONAL SUMMARY

I am a Software development professional with 17+ years of custom web and client/server development experience in a variety of business sectors, including aviation, transportation, wireless, finance and insurance. Solid understanding of software development life cycle processes including requirements gathering, analysis and design, development tools and technologies, release and version control, contemporary testing methodologies and deployment management.

12 + Years of experience in USA, creating and customizing Client/Server and Web based applications using .Net, ASP.Net, WebAPI, RESTFUL Services, Fiddler, C#, VB.Net, ADO.Net, XML, XSL, COM/COM+, Web Services and Crystal Reports.

Excellent knowledge and experience designing websites using MVC, Bootstrap, Jquery, angularJS, HTML5, CSS 3.0.

Utilized VB.NET, ASP.NET, C# and created web forms, win forms, user controls, custom controls, web services. Strong knowledge of OO programming

Designed and Developed n-tier (including business and data tier) applications. Well versed with Back end, Middle tier, front end and GUI Development.

Strong object oriented concepts and application using C#, VB.Net

Experience in Migration of the applications from VB to VB.net & ASP to ASP.net.

Led the team of 4 members.

Solid skills with VS.NET to develop custom web parts / User controls for the business needs.

Hands on experience with database design, entity relationship, database analysis and programming. Experienced in writing SQL Queries, Stored Procedures, SSIS, DTS Packages and Triggers in SQL Server.

Very well experience with oracle and PL / SQL.

Good knowledge and experience in Oracle financials systems like General Ledger, AP, AR, PO modules

Have a good knowledge and experience on estimating projects.

Adept at learning new technologies and ability to work under pressure individually and/or in team.

EDUCATION

Bachelor of Engineering from Nagarjuna University, India (June’1994 – April’1998)

STRENGTH:

Exceptionally good understanding and analytical power

Strong ability to interface with management and the users

Very strong communication skills

Self motivated, full of energy with the leadership qualities

Certifications:

70-565: Pro: Designing and Developing Enterprise Applications Using the Microsoft .NET Framework 3.5 (Microsoft Certified Professional)

70:431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance (Microsoft Certified Technology Specialist)

TECHNICAL SUMMARY

Languages: C#, VB.NET, ASP.NET 2.0/3.5/4.0/4.5/4.6.2, ADO. Net, Win forms, XML,XSLT,XSL, Web Services, HTML, DHTML, UML, WCF,WPF, JAVA, JDE, Black Berry Development, WebAPI, RESTFUL Services, Fiddler

Frameworks: Microsoft .Net framework 2.0/3.5/4.0/4.5,J2EE, SharePoint Development.

Tools: Microsoft Visual Studio 2017/2015/2013/2010/2008/2005, VSS, Visual Interdev, Web parts, Smart parts, Windows SharePoint Services 3.0, LINQ, Active Directory Services, IIS 5/6/8. SQL Server reporting services, Integration services, Crystal reports.

Scripting Languages: JavaScript, VBScript, JQuery, Angular JS/2/4/5

Databases: MS SQL Server 6.5/7.0/2000/2005/2008/2014, Oracle 8, 9i, 11i,12i, DB2, Sybase 11.5

Operating Systems: Windows 98/2000/2003/NT/XP/Vista/7, UNIX, Linux

Others: AJAX, ASP.NET Controls, Agile methodologies, Waterfall, Telerik, DTS Packages

PROFESSIONAL EXPERIENCE

BMW Financial, Dublin OH Apr’18 to Current

Project: DFE 3.0 (Dealer front end tool)

Role: Technical Lead

Dealer Front End system is being used by BMW outlet dealers across in USA, Canada, Brazil and Mexico countries. This is sytem is being used for four features “Desking,Credit Application Processing,Contract Prep,Funding”.

Desking is the initial deal building process – normally between a dealer sales associate and a customer

Credit application processing is where we bring in credit applications from the customers – through the direct or indirect channels.

Price and product selection,Document Generation,Document Receipt and Reconciliation,Customer Communications

Contract review and validation - All of the information that’s been gathered about the deal comes together. A funder has to review all of the credit, contract, price and product data to make a decision about whether BMWFS should approve the funding of this deal.

Dealer Accounting - The funds dispersal process is responsible for moving monies between the various parties involved in a deal.

Responsibilities:

Participate in requirements gathering, analyze them, create user stories and decomposes to software solutions by collaborating with internal teams.

Participate in code reviews to ensure coding standards are met, Code cleanup, Iterative review with defect fixing.

Participate application Architecture design discussions.

Develop Server-side functionality, create & expose Web services encapsulating the business logic using C#, WEB API, WCF services in .Net 4.5.

Implement the best UI experience and client-side functionality using html5, CSS3, Bootstrap 3/4, Type Script and Angular 4/5.

Utilized core Angular 4/5 features such as HTTP, Data Binding, Forms, Services and Dependency Injection.

Strong Hands-on experience in Angular 4/5 directives, components, services, routings.

Experienced using TypeScript to program Angular 4/5 and develop web applications.

Good experience working on Responsive UI using HTML, CSS, and Bootstrap.

Develop the Entity Framework Code First Approach to interact with Database and also implemented Mappings, Model Changes, Migrations, CRUD operations and dealt with performance issues.

Develop, maintain and optimize complex stored procedures, triggers, tables, views, and table valued functions, relational database models, SQL joins and Queries using SQL Server.

Write and execute test cases using NUnit, Rhino Mocks, C# to verify correctness of code and more code coverage.

Raising and prioritizing tickets related to project Issues, Bugs, Enhancements and Features in JIRA.

Investigate and identify the root cause for bugs, automatically capture bugs using Test & Feedback extension tool and fix to meet the required functionality.

Environment: Technologies .Net 4.5.2/4.5, Angular 2/4/5, WCF Services, WEB API, C#.Net, SSIS Packages, MSSQL Server 2016, IIS, SQL Server Management Studio, Visual Studio 2015/2017, TFS 2012, Entity Framework 6.1/6.0, LinqPad, LINQ

Verizonwireless, COLUMBUS OH Aug’17 to Mar’18

Project: Verizon Cloud platform (VCP) systems / Network infrastructure planning

Role: Senior Technical Consultant

The Verizon Cloud Platform (VCP) is a private cloud designed to support the virtualization of network functions across all of the Verizon business units. The design emphasis for VCP has been to build a telecommunications grade virtualization environment while realizing a significant cost reduction over traditional purpose built hardware. This vision is realized by combining open source software (OpenStack) and commodity hardware with the virtualization expertise of trusted business partners.

Initially VCP has been brought into service as two distinct platforms (VCP-Core & VCP-Edge) with a common orchestration platform. These two platforms share a similar software stack but utilize a slightly different hardware profile based on where the service is being deployed. The objective is to start bringing VCP-Core and VCP-Edge together under a common physical framework starting in 2017 in order to better leverage it's combined scale and footprint.

Responsibilities:

Responsible for pulling data from external sites like redhat using webApi.

Written console app to pull Jira tasks / issues / projects.

Provided user interface to filter data for the planning groups.

Implemented security based modules on user groups

Implemented intranet sites to see Verizon cloud platform requests( all users are internal)

Generated automated emails based on groups / users.

Created and maintained multiple Oracle tables using PL/SQL Developer.

Worked on Agile methodology

Comfortable with user stories

Involved in business users meetings, QA meetings

Environment: Visual Studio 2015, Windows 10, C#, Console App, XML, Oracle 12i, GitFlow, Team Foundation Server, Batch Scheduled Jobs, Jquery, Bootstrap, JSON, AngularJS, MVC 5.0,Angular2.RESTFul Services, WebApi.

DataVerify Inc, COLUMBUS OH JULY’16 to July’17

Project : DataVerify-4506/SSN Verify

Role: Senior Technical Consultant

DataVerify offers a single-source platform for data verification, fraud prevention, and compliance assistance. With clients that include top lenders and government agencies, DataVerify assists in the real estate loan origination process to:

Identify and authenticate the borrower, and all participants to the loan transaction

Verify the information supplied by borrowers in their loan application

Assess the value of the property to be purchased or refinanced

Streamline the loan review process by incorporating multiple tasks into one state-of-the-art system

Environment: Visual Studio 2015, Windows 10, Web forms, C#, XML, SQL Server 2014, GitFlow, Team Foundation Server, Batch Scheduled Jobs, Jquery, Bootstrap, JSON, AngularJS,WCF, MVC 5.0,Angular2,

WebAPI, RESTFUL Services,.

Responsibilities:

Analysis, estimation, design, Coding & development

Resolved Client issues

Supported and troubled shouted software issues.

Worked on Agile methodology

Comfortable with user stories

Involved in business users meetings, QA meetings

Conducted training sessions and seminars

Prepared technical reports based on the data gathered from different sources

Made improvements/enhancements to existing systems

(HLD) and Low Level Design(LLD) reviews

Fully responsible for release and production deployment

JPMorgan Chase, COLUMBUS OH March'15 to JUNE’16

Project : Suspicious Activity Database - Data migration and web site maintenance

Role: Consultant

SAD- Formerly know as FDB (Fraud Database) is now called suspicious activity DB

SAD application is used to detect any risk in post Funded loans, Loans that flow

into SAD are mainly those which have missed their first payments or one of the

payments. ( this is the starting point of suspicion).

Environment: Visual Studio 2010, Windows 7, Web forms, C#, XML, SQL Server 2008, Subversion, Share Point Services,Crystal reports, Javascript, Java, AngularJS, Oracle 11i, FCIP ( Financial Crime Investigation Portal)

Responsibilities:

Worked on Agile methodology

Comfortable with user stories

Involved in business users meetings, QA meetings

(HLD) and Low Level Design(LLD) reviews

Analysis, estimation, design & development

Data migration from SQL server to Oracle

Developed windows app to migrate data

Developed windows app tool to validate migrated data.

Fully responsible for release and production deployment

Verizon Wireless, COLUMBUS OH Jul'14 to March'15

Project : Solutions Portal

Role: Sr. .Net Consultant

The Solutions Portal (SP) project is part of a Tech Transformation initiative which looks to successfully transform tech support across all channels & create a consistent customer experience. Employees & customers will use the same tools & content management system to resolve issues. Available data from all our systems will be used to proactively and reactively identify root issues. Solutions Portal is the cornerstone of Tech Transformation providing

• Single cross functional user interface (Care, web, handset & stores)

• Diagnostics – pull data into decision engine for review & relative correlation

• Auto-validation for CLNR and transfer transactions

• Symptom-based ranked solutions and steps, by resolution relevancy

• Basic troubleshooting on all products

• Providing intelligence around drivers and resolution rates

Responsibilities:

(HLD) and Low Level Design(LLD) reviews

Analysis, estimation, design & development

Involved in code reviews and design patterns for the entire project

Developed Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules

Worked closely with customers and manager to understand business requirements.

Environment: Visual Studio 2013, Windows 7, MVC5, Scaffolding, C#, XML, Oracle 11g, Subversion, Share Point Services,SOAP, WCF, REST web services, BootStrap, JQuery, AngularJS, JSON

AFFINION GROUP, COLUMBUS OH FEB’12 to Jun'14

Project : privacyguard.com / identitysecure.com / freescoresandmore.com

Role: Tech Lead

Affinion Group has entered into an agreement with ECD to replace CoreLogic in providing online and offline credit benefits for members of Affinion’s Protection Products. The changing credit content landscape has provided Affinion with the impetus to undertake this endeavor to gain significant cost savings.

Responsibilities:

Created Visio diagrams for project designing

Involved in High Level Design(HLD) and Low Level Design(LLD) reviews

Analysis, estimation & development

Managed 3 contractors for the entire project

Involved in code reviews and design patterns for the entire project

Coding, testing & migration to production

Called Middle tier WSDLs in our frame work

Developed Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules

Develop the project plan and documented the coding standards for .NET.

Worked closely with customers and manager to understand business requirements.

Environment: Visual Studio 2008, Windows 7, MVVM,V2E framework, WCF, WEB API, C#, XML, Oracle 11g, Subversion, Share Point Services

Flight Options LLC, CLEVELAND OH Apr ’05 to JAN ‘12

Role: Sr .Net Developer

Project: Crew Assignment Breakdown

The objective of the crew assignment breakdown project is to separate the daily crew duty time into distinct categories like Flight Time, Travel Time, Inactive Standby and Reserve at Residence or Hotel.

Responsibilities:

Analysis, estimation & development

Develop the project plan and documented the coding standards for .NET.

Worked closely with customers and manager to understand business requirements.

Followed MVC design pattern

Designed system using VB.net and Telerik controls

Developed custom user controls for better reusability

Written business logic in stored procedure and business layer

Developed audit reports for users based on historical data

Created tables, written stored procedures and triggers

And also responsible for testing and integration of entire project.

Environment: Visual Studio 2010, Windows XP, C#, Win forms, ASP.Net, XML, SQL Server 2008, MVC Pattern, MS Visual SourceSafe, Share Point Services, SSIS Packages, Reporting Services.

Project: Airport Atlas

This application is used for to create new airport, edit & update. The following new features have been incorporated to Airport atlas.

Responsibilities:

Managed a team of 4 who work under my guidance.

Successfully manage multiple projects and work effectively with internal and external clients.

Developed the system architecture and reusable components for the websites.

Database design and written complicated stored procedures.

Tuning SQL objects including indexes, stored procedures and triggers.

Environment: Windows XP, C#.Net, ASP.Net, JavaScript, XML, SQL Server 2005, CSS, AJAX, HTML, MVC Pattern, NUnit, Test Driven Development (TDD), DHTML, IIS 6.0, MVC Pattern, MS Visual SourceSafe, Share Point Services, SSIS Packages, Reporting Services.

Project: External websites ( http://Owners.flightopitons.com, http://Charter.flightoptions.com)

Project Description: The above two websites designed to use flight options owners. The owners can login to the website can book the trip, modify the trip, calculate the trip estimate and generate trip invoice etc.

Responsibilities:

Developed the project plan and documented the coding standards for .NET.

Designed the database with normalization techniques and all the relationships between the tables.

AJAX used for better utilization of client server communication

Implemented role based security in the database

Involved in Analysis of the system requirements and Created detailed functional specifications

Written complex SQL stored procedures to get trip estimate.

Environment: Windows XP, C#, NUnit, Test Driven Development (TDD), ASP.Net, JavaScript, XML, SQL Server 2005, CSS, AJAX, HTML, DHTML, IIS 6.0, MS Visual SourceSafe, Share Point Services, SSIS Packages, Reporting Services.

Project: New Operations – Crew Activity

Environment: Windows XP, C#, Win forms, ASP.Net, XML, SQL Server 2005, MS Visual SourceSafe, Share Point Services, SSIS Packages, Reporting Services.

Project: No Fly program

Environment: Windows XP, C#.Net, Console App, SQL Server 2005, MS Visual SourceSafe, NUnit, Test Driven Development (TDD), Team Share.

Project: Aviation Services Network (ASN)

Environment: Windows XP, C#, ASP.Net,WinForms, XML, SQL Server 2000,Oracle 9i, CSS,, HTML, DHTML, IIS 6.0, MS Visual SourceSafe, Crystal reports.

American International ASSURANCE, Singapore Jul’03 to Mar ‘05

Role: Software Analyst

Equinix – (Singapore Technologies Telemedia), Singapore Aug’00 to Jun ‘03

Role: Software Engineer

Contact this candidate