Sql Server Project

VENKATA RAMACHANDRA RAO ADDALA

Sr.Net Developer

+1-703-***-**** • ***********.******@*****.*** • Fairfax, VA, USA

Selling Points:

10+ years of Software Development Experience in analysis, design, development, testing and Deployment of software applications which includes Windows, Web based and Client server applications. I acted as a technical lead for development and integration of .Microsoft applications using technologies like Visual studio .NET, C#, VB, Asp.Net, WCF, WPF, ADO.NET, and SQL Server, Oracle, Microsoft Biztalk Server, Web Services, IIS etc. I also very good in implementing design pattern practice like Factory, Repository using with EF and other libraries, RIP, Lazy Loading and many more into my project based on the need and necessary of the system required. Used Dependency Injection using MS Unity Application block. Adopted latest approaches to achieve Single Page Application (SPA) using AngularJS, JQuery and other Javascript Libraries. Build many interfaces which complies Responsive web site using bootstrap, CSS3 and HTML to render to variety of devises. 5+ experiences in the area of Technical Presentations, Managed 5-10 technical team, Data Center Creating/Migration, Software Migration/Upgradation, architect, design, analysis, modify, development, testing and implement high quality and complex software applications. Lead design and coordinates offshore team, design reviews and code reviews. Strong knowledge of physical web infrastructure and web application architecture with exposure to various domains (e-Governance, Finance, Manufacturing, HealthCare, e-Commerce (B2B, B2C), Media & Entertainment), and has worked closely with business users and development teams in successfully translating process requirements into specifications and deliverables. I’m dedicated and sincere in my work and won reputation and recognition from all previous clients.

Skills:

Head Skilss

Skills

DOMAIN EXPERTISE

e-Governance, Finance, Banking, HealthCare, e-Commerce (B2B, B2C), Technology Service

LANGUAGES & TECHNOLOGIES

ASP.Net, C#.Net, VB.Net, VB, ASP, JQuery, VBScript, JavaScript, HTML 5/ DHTML, CSS 3.0, XML/ XSL, DOM/ COM+, Active-X, SOAP-XML Web Services, NUNIT, MVC, AJAX, WCF, WPF, Silverlight, UML, C, C++, JSON, SOA, SPA, RESTful Web Site, Web APIs, AngulaJS, KnockoutJS:

DBMS & RDBMS

SQL Server 6.5/ 2000/ 2005 / 2008/ 2012, T-SQL, Access '97/ 2000, Oracle 9i/ 10g/ 11g PL/SQL, MySQL

SERVERS

IIS 4.0/ 5.0/ 6.0/ 7.0 /8.0 / MTS 2.0/ Component Services, MS BizTalk Server 2006 R2, MS SharePoint Portal Server 2007/ 2010, MS Azure

DEVELOPMENT TOOLS

Microsoft Visual Studio .NET 2003/ 2005/ 2008/ 2010/ 2012, MS Visual InterDev 6.0, Macromedia Dreamweaver 4.0, Adobe Photoshop 9.0, CSS3, Crystal Reports 7.0/ 8.0, MS Visio, SharePoint Designer2007/ 2010, RAZOR View Engine, Kendo UI:

VERSION CONTROL TOOLS

MS Visual Source Safe, Build Professional, MS Team Explorer / Team Foundation Server 2005/ 2008/ 2010/ 2012

ORM & OTHER TOOLS

Entity Framework, LINQ, NHibernate

OPERATING SYSTEMS

MS Windows 9x/ NT/ XP/ 2000/ 2003/ 2008 / 7/ 8/ Vista, Linux, Unix, MS DOS

SCRIPTING SKILLS

Javascript, VBScript, AngularJS, NodeJS, JQery, PowerShell

MANAGERIAL SKILLS

Being involved in a complex programs from evaluation, conception and completion., Proven ability to achieve results in very high-pressure environments and to keep teams motivated. Ability to facilitate both business and technical discussions. Strong understanding of Agile software development, SDLC, and Business Analysis practices. Project Management, Architect, Leading, Analysis, Design, Development, Construction, Documentation, Unit and System Testing. Quality Assurance, Resource Management, Effort Management, Client interface, Budgeting, Administration

Education:

Degree

(AA/AS, BA/BS, MA/MS/MBA, PhD, JD)

Area of Study

School/College/University

Location

Was the degree awarded? (Yes/No)

OPTIONAL: Date (MM/YY)

MBA

Information and Systems

Karnataka State Open University

Bangalore, India

YES

B.Sc.

Bachelor of Science

Andhra University

Visakhapatnam, India

YES

Certifications and Certificates:

Certification

Issued By

Date Obtained

(MM/YY)

Certification Number

(If Applicable)

Expiration Date

(If Applicable)

Diploma in Hardware and Network

Growth Computers

04/20/2003

N/A

N/A

Oracle DBA

Wilshire

03/11/2003

1872

N/A

MS.net

Trendz

03/08/2003

15998

N/A

MCP in SQL

Microsoft

03/10/1999

D1BY0H3835

N/A

MCP in VB

Microsoft

03/09/1999

D1AY0H3784

N/A

PGDCA

JNNYC

02/29/1999

70/KOTHI/941

N/A

Diploma in PC applications

TATA-TULEC

02/18/1999

N/A

N/A

Foundation is Computer Concepts

Setwin (Govt. of AP)

06/13/1993

41293

N/A

Awards:

Received “Web Ratna” award from Government of India for crucial involvement in the software development and maintenance for the project BangaloreOne in 2010: Best Employee Award for 3 years from my previous employer RAM INFORMATICS LIMITED

Employment History:.

DOYEN Business Solutions Inc.

DASCADE/TETRODAS, ATec Wireless, New Jersey

Sr. Developer Aug 2015 – Present

Serves as technical specialist on complex development and maintenance projects involving Internet & Server technologies. Analyzes project requirements and recommends techniques, tools, and methodologies to achieve project goals.

Designs objects, modules and components to meet business requirements. Development environment is the .Net Framework and C# as primary development language, utilizing SQL Server database and web services (SOAP and XML) technology.

Prepares functional specification documents, workflow models, class, interaction, components, deployment diagrams and other system documentations. Participates in the design of file layouts and database structures as well as hardware and software configurations to support internet application. Utilizes Systems Development Life Cycle tool set to automate design and development activities.

Programs, tests and debugs especially complex Internet-based applications and documents actions. Reviews Internet-based systems for systems enhancement and efficiency of machine and software resource utilization; assists users in resolving problems.

Used Entity Framewok using Schema and Model approaches. Used NHibernate in creating Domain, Models, Mapping, Repositories for perform CRUD operations and also used NHybernate Helper.

Involved in designing of UI with CSS, HTML, Angular JS and DHTML.

Consults with technical support, network administration, and database administration area to ensure coherent total design of the systems and to resolve any technology issues.

Coding, debugging, bug fixing, testing on Windows and Web (intranet) application (above mentioned) modules. Application Support on the Triage - Daily Production Logs preparation, Batch running files update, Data Fixes by using MS SQL Server, C#, IIS and Web Services.

Developed RESTFul Web API using MVC framework for all business logic and exposed to the front-end interfaces

Created Razor view engine, consumed Web APIs through Asynchronous Java script calls.

Created many Web Forms and written code behind logic for business logic

Created plenty of SSIS packages to upload various type of files into database

Worked on financial transactions on returns and payments in windows and web applications using .NET Framework 4.5, Enterprise Library 5.0, C#, SQL Server, COM+ etc.

Web pages designing using with Bootstrap, WPF and Photoshop

Front-end designing using with Silverlight, Telerik and Helix took kit for visual effects and consistent look & feel.

Trains less experienced staff members in procedures, practices and standards necessary for the development of Internet-based application systems; job enrichment through training and exposure to challenging work situations.

Prepares progress reports and keeps managements and users informed.

Key Technologies/Skills: NET Framework 4.5, MVC 5.0, Enterprise Library 5.0, C#, ASP.NET, COM+, MSMQ/MQ, XML/ XSL, HTML/ CSS, Web Services, AngularJS, Web API, JavaScript, PowerShell, Pyth, SQL Server 2014, WCF, WPF, Silverlight, MVC, TFS 2012, IIS 8.0, MS Crystal Reports, Telerik, Entity Framework, NHibernate, LINQ, Helix Tool Kit

Modernization Framwork -DOYEN, Mannassas, VA

Sr.Developer May 2013 – 12th Aug 2015

Created plenty of SSIS packages to upload various type of files into database

Web pages designing using with Bootstrap, WPC and Photoshop

Developed Services using SOA architectures on MVC framework

Involved in designing of UI with CSS3, HTML5, Angular JS, Bootstrap, JQery and DHTML.

Developed Web API using MVC framework for all business logic and exposed to the front-end interfaces

Created Razor view engine, consumed Web APIs through Asynchronous Java script calls.

Created many Web Forms and written code behind logic for business logic

Front-end designing using with Silverlight and WPF for visual effects and for rich user experience

Deploy in Microsoft Azure Cloud environment

Trains less experienced staff members in procedures, practices and standards necessary for the development of Internet-based application systems; job enrichment through training and exposure to challenging work situations.

Key Technologies/Skills: .NET Framework 1.1/2.0/3.0/4.0/4.5, Enterprise Library 5.0, C#, ASP.NET, ADO.NET, COM+,MSMQ/MQ, XML/ XSL, HTML/ CSS, Web Services, AngularJS, PowerShell, Pyth, CSS3, HTML5, Bootstrap, Web API, JavaScript, SQL Server 2012, WCF, WPF, Silverlight, MVC 4.0, TFS 2012, IIS 8.0, Microsoft Azure

KarnatakaOne, Electronic Delivery & Citizen Services, Govt. of Karnataka, India

Lead / Sr. Developer May 2010 - Apr 2013

Objectives of KarnatakaOne

Initially, to provide G2C services in a convenient and efficient manner through the Integrated Citizen Service Centers being set up in five municipal corporations of the State.

To scale up the operations to cover eventually all the G2C services throughout the five municipal corporations.

To become a single interface for all Government to citizen transactions.

To enhance the accountability, transparency and responsiveness to citizen’s needs.

To provide cost-effective methods of service provision to the departments and agencies.

Responsibilities

As part of the development, I was associated with the full life cycle of the project (Architect, analysis, design, development, testing, and implementation) under agile and scrum methodologies.

Worked immensely on different environments like development, testing, staging and production.

Hands on experience in developing, debugging n-tier applications using ASP.NET, VB.NET, ADO.NET, SQL Server.

Immensely developed and debugged the System (BO) Components for enhancements/ maintenance for Authentication, LDAP, Mail, Registration, Transaction, Access rights, Payments, Collections, General Ledger, Reports, Cubes, User Access Point (UAP), Work Items, Data Mart, Case, data changes in many tables using Customized Application and MS Visual Studio 2010.

Immensely developed pages and worked on HTML 5, XML Schemas, XML Documents, and XSL Style Sheets, Java Script for "KarnatakaOne" Web Based module.

Used Team Explorer in TFS 2010 for version Controlling and source code sharing and also used MS Build.

Was in-charge for carryout datacenter migration from Khanija Bhavan, Bangalore to State Data Center

Created/ modified stored procedures, triggers, and views in SQL Server 2008 for data manipulation and retrieval using T-SQL and generated the reports using SQL Server Report Services (SSRS).

Performed performance tuning on analyzed existing code for better outcome.

Involved in analyzing and preparing Unit Test cases for various scenarios.

Performed End-to-End Testing, troubleshooting, debugging, integration testing, regression testing and performance testing and analyzed the results to justify validation.

Key Technologies/Skills: C# 4.0, VB.NET, ASP.NET 4.0, Web API, MVC 3.0, WCF, SoapUI, FireBug, ADO.NET, LINQ, AJAX, Entity Framework, JQuery, ODBC, Agile, T-SQL, SQL Server 2003, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014, Window Server 2003,Window Server 2008, Window Server 2012, IIS 8.1/8.0/7.0/6.0, Windows XP, HTML, CSS, JavaScript, Visio 2007 pro, Visual Studio.NET 2005/2010/2013, Web Services, flat files, CSV files, Excel 2007, MS VSS, MS TFS etc

Unified Billing System (UBS), Addis Ababa, Ethiopia, Africa

IT Consultant Jan 2010 - Apr 2010

The Ethiopian Information Communication Technology Development Agency (EICTDA) has embarked on an initiative to provide integrated services to the citizens deploying the tools of Information and Communication Technology (ICT). Integrated service delivery to the citizens is expected to enhance speed, convenience, certainty and accountability. The project to rollout citizen services to the Addis Ababa in Eithopia will be called as “Unified Billing System” or UBS.

Helped local agency to participate in the bid

Knowledge Transfer to the local agency

Mentored Local agency to win tender

Unique Identity (UID), EDCS, Govt. of Karnataka, India

IT Consultant May 2009 - Dec 2009

The widespread implementation of the UID project needs the reach and flexibility to enroll residents across the country. Along with the KYR (Know Your Resident) data specified by the UIDAI, the KYR+ data specified by the GoK will also be collected during enrolment as per procedure prescribed by GoK. In order to collect the additional information during enrolment and scanning of all documents related to enrolment, CeG will provide required application (KYR+ software) to the selected Enrolment Agencies.

Helped Govt to conceptualize entire Unique Identification of the cizen of Karnataka state in India.

Understand the entire scope of work. Defined data and the flow of the functionalities.

Defined Integration modalities with Central Govt of India application to implement at the state level.

Prepared Survey and Gap Analysis report and submitted to the Govt. Of Karnataka

Participated with the core team who is responsible for preparing Request for Proposal for UID for Karnataka State.

Created road map to successful implementation of the UID in Karnataka state and submitted to Govt.

Involved various brain storming sessions with Secretearies

Prepared presentations and presentated to the Govt. office nodals.

Citzen Service Centers (CSC), EDCS, Govt. of Karnataka, India

IT Consultant Feb 2008 - Apr 2009

The Common Service Centres (CSC) that are proposed to set up are envisioned as the front-end delivery points for Government, private and social sector services to rural citizens of India. CSC Project is part of NeGP (National eGovernance Plan) initiatives consist of 27 central, state and integrated Mission Mode Projects (MMPs). The idea is that to develop a platform which enables Government, private and social sector organizations to integrate their social and commercial goals for the benefit of rural populations in the remotest corners of the state through Information Technology.

Studied current trend of all CSC projects up and running in the county of India

Prepared Survey and Gap Analysis report and submitted to the Govt. Of Karnataka

Participated with the core team who is responsible for preparing Request for Proposal for CSCs for Karnataka State.

Created road map to successful implementation of the CSCs in Karnataka state and submitted to Govt.

Involved various brain storming sessions with Secretearies

Prepared presentations and presentated to the Govt. office nodals.

BangaloreOne, Electronic Delivery & Citizen Services, Govt. of Karnataka, India

Developer Jan 2005 - Jan 2008

Architected, Designed & Developed ASP.NET VB/ C# N-tier Web Platform application where all stake holders of this project view their hundreds of customized reports.

Used ADO.NET to retrieve data from database for many independent applications.

Created hundreds of SSIS packages to upload various type of files (csv,txt, xlsetc) into database and to make files downloadable in CSV format from website and Window’s application.

Accomplished significant achievements in BI, data warehousing, analysis, and problem-solving, cost-reduction by centralizations, research and development.

Designed & Developed (from scratch) Complex Risk Analysis Algorithm to detect best points to invest in for Virtual and Spreads points for BangaloreOne and used Agile methodologies for throughout product development.

Developed Services using SOA architectures (WSDL, SOAP, XML, and XSD) to facilitate communication between servers which were located two different cities.

Retrieved files every five minutes real-time, hourly real-time, and daily day -head data automatically and stored the data into normalized database using SSIS.

Designed and developed many (about 150 different) independent C#,VB, Batch files, Schedule Jobs (SQL Server), SSIS Package programs to insert various type of data into database automatically.

Normalized, optimized, Architected, designed and developed 250 GB database (tables, stored procedures, jobs, triggers, and functions) to store and manipulate the data from various sources.

Developed hundreds of database tables, stored procedures, jobs, and functions.

Installed and Configured Window Server 2008 R2/R1 and SQL Server 2008 R2/R1 and completed many SQL Server DBA/System Admin activities.

Created Complex features to administrate the Window Server 2008 from the website.

Used Microsoft Speech technologies to tell the traders when something happened abnormally.

Regular liaison with the client on all project-related matters.

Ensuring the effective preparation and delivery of all project events and meetings and production of all necessary documentation.

Taking responsibility for the effective flow of information between team members, participants in project activities, and the Client

Was in-charge for carryout datacenter migration from Richmund Circle, Bangalore to CMS datacenter.

Was in-charge for upgrade 5 major modules from dot.net framework version 1.1 to 4.0

Ongoing evaluation of project activity and reporting on project progress to the Client.

Submission of the final results of the project to the Client.

Participation at meetings for better coordination.

Responsible in Training & Documentation of Architecture, Implementation.

Responsible to manage a project comprising of 25 developers / testers

Responsible in Project details and Standard Operation Procedures of Software and databases.

Responsible for entire life cycle of the project includes Requirement gathering by communicating with business team, preparing Technical documents, development and testing.

Participate in all stages of the software development life cycle including coding, designing and documentation.

Preparing technical document to the technical proposal for the software project tender.

Coordinate with various departments/users and analyze requirements of architectural team to meet business needs.

Develop support processes to integrate.NET applications into in-house and third party applications.

Responsible in Technical presentation to the clients and partners.

Responsible in understanding clients request, identify appropriate methodology, design, development and implementation of any change requested.

Used Biztalk 2004 as integration server where I have created many Orchastrations, send ports, received ports.

Build reusable component APIs and endorse reusability at design and application development levels

Work independently and promote team productivity ensuring team delivers high quality components

Having technical exposure in integrating various frameworks using different technologies.

Evaluate user requests to determine budget, time, feasibility and compatibility of the new or modified program.

Analyze technical architecture and provide recommendations.

Experience in functional and technical system analysis & Design, System Architectural design, Presentation, process data flow design, system impact analysis, Gap analysis and documentation.

Work as lead in the design and development of dashboards and reports.

Managed several multi-million dollar software development programs.

Developed and maintained vital relationships across multiple internal and external departments with stakeholders, partners, and customers.

Key Technologies/Skills: C# 4.0, VB.NET, ASP.NET 4.0, WCF, SoapUI, FireBug, ADO.NET, LINQ, AJAX, Entity Framework, JQuery, ODBC, Agile, T-SQL, SQL Server 2003, Biztalk 2004, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014, Window Server 2003,Window Server 2008, Window Server 2012, IIS 8.1/8.0/7.0/6.0, Windows XP, HTML, CSS, JavaScript, Visio 2007 pro, Visual Studio.NET 2005/2010/2013, Web Services, flat files, CSV files, Excel 2007, MS VSS, MS TFS etc.

Contact this candidate