Sql Server Data

Akhila Kistampally

Contact : 510-***-****

Email ID: *****************@*****.***

Summary:

* ***** ** ********* ********** as professional programmer. Thorough understanding of the SDLC process encompassing requirement analysis, design, development, testing, change request management, maintenance / enhancement and production support.

DOTNET professional with experience in web and windows development using ASP.NET, ADO.NET, MVC.NET, Web Services, Entity Framework and WCF.

Strong SQL and RDBMS programming (Stored procedures, CTE, Complex Queries, Views etc) with hands on experience on SQL Server 2014.

Proficient in developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data Warehouse from Heterogeneous data sources such as DB2, Excel and flat file.

Proficient in writing parameterized queries for generating reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.

Experience in designing complex reports using SQL Server Reporting Services (SSRS).

Wrote the store procedures, Functions, views in SQL server according to the requirements

Created packages for data load process using containers as For-Each Loop, Sequence & controlling flow of data using tasks as Script, Data Flow, File System, and Execute Package.

Used transformations in SSIS for merging the data from different source into one

Experience in developing network-distributed services in .NET using WCF & Web API.

Created windows services to generate automated reports & monitoring server logs.

Worked on .NET Security features such as Windows, Forms-based Authentication & Role-based Authorization.

Good understanding of OOPS concepts with hands-on experience in implementing concepts such as Polymorphism, Inheritance, Encapsulation, Abstract classes and Interface etc.

Hands on development/ deployment experience of client/server, intranet, and internet based applications.

In-depth knowledge of SDLC and project methodologies including Agile (Scrum) and Waterfall.

Experience with version control tools such as Team Foundation Server (TFS).

Constantly involved in the maintenance of database, application design, business rules and validations.

Excellent interpersonal, leadership and negotiation skills.

Committed team player and able to work across teams.

TECHNICAL SKILLS:

Languages : C, C#, VB.Net

Framework : NET Framework 4.5/4.0/ 3.5.

.Net technologies : ASP.NET, ADO.NET, Web Services, LINQ to SQL,

Framework, AJAX, WCF,

HTML 4/5, ADO.net Entity Framework

Development Environment : Visual Studio.NET (2012, 2015)

Databases / Big Data : SQL Server 2014

Architectures : 3-tier, MVVM

BI Tools : SSIS, SSRS and SSAS

Platforms : Windows 2008/2005 server Version Control

Team Foundation Server (TFS)

Project Methodologies : Waterfall, Agile

Office Tools : Microsoft Excel, Word, PowerPoint.

EDUCATION:

Degree

Area of Study

Location

Was the degree awarded? (Yes/No)

OPTIONAL: Date (MM/YYYY)

Bachelors

Electronic Communication Engineering

Hyderabad

Yes

05/2013

Masters

Electrical Engineering

California

Yes

12/2014

EMPLOYMENT HISTORY:

Client Name: Computer Aid, Inc., Harrisburg, PA

Title: .NET Developer

Duration: Feb 2015 – Till Date

Description: CAI is currently managing with 1000 companies and government agencies; it specifies APPLICATION DEVELOPMENT and MANAGED STAFFING SERVICES. It includes the application integration using service oriented architecture. These services include mentoring of development staff in iterative and incremental software development methodologies like Agile and in business intelligence systems

Responsibilities:

Extensively involving in using MVVM pattern (AngularJS) for the UI development.

Using following technologies in development – User Controls, Master Pages, Java Script, AngularJS.

Creates and manages multiple development databases.

Involving in creating the packages and control flow using SQL Server Integration Services (SSIS).

Creates and manages SSIS packages to perform Extract, Transform, and Load (ETL), data cleansing, and data export operations.

Familiarity with developing an ETL lifecycle to support enterprise-wide data processing projects (i.e., Enterprise Data Warehouse).

Involved in UAT and Deployment stages of SSIS Packages and SSRS reports.

Worked on creating the user interface (UI) using Java scripts and HTML and to deploy the reports on web application.

Develops T-SQL script deployment packages to deploy all database structure, T-SQL code, and static data changes from development to test and production database environments.

Monitors database query/write performance and creates and maintains appropriate indexes.

Design, develop, implement, and validate report solutions in SSRS.

Create and execute unit test plans based on system and validation requirements.

Document all report or dashboard related work per client’s SDLC/RDLC methodology.

Using TFS for Source control, Data Collection and for tracking the project.

Maintain existing code and fix bugs whenever needed including ad hoc data analysis

Working on MVVM design pattern for this application.

Participating in the unit and integration testing.

Used Agile methodology for the development with daily SCRUM meetings.

Using Java Script, and CSS to build User Interface pages.

Implementing the Business Logic in C#.

Involving in SDLC process encompassing requirement analysis, design, and development.

MTM

Environment: HTML5, SQL Server, ASP.NET, C#.NET, Visual Studio.NET, Team Foundation Server(TFS), MS SQL Server, XML, Agile Scrum Methodology, CSS, XSL, VB.NET, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), HTML5, Java Script, Angular JS

Client Name: CMC, India

Title: Jr.Net Developer

Duration: Nov 2012 – Dec 2013

Description: Customer onboarding accelerator involves creating the working concept for the sales team to project singularity’s understanding and expertise in Customer Onboarding. Customer onboarding is implemented in the context of financial institutions where a customer is allowed to transact with the institution only after certain formalities and processes. Customer onboarding process involves Compliance, credit, Technical, legal, presales & post sales steps. Each step involves a check or collection of information about customer. All the task screens were implemented using SPP Forms. The report screens were implemented using ASP.Net. Integration of them is done to give same look & feel. This project was developed in .NET technologies and having both Windows and Web based applications.

Responsibilities:

Managed SSIS packages to perform Extract, Transform, and Load (ETL), data cleansing, and data export operations.

Managed multiple development databases.

Participate in requirements gathering sessions

Implemented Object-Oriented Programming concepts of interfaces, inheritance, abstraction and polymorphism.

Managed the database backup and recovery routines for all development databases.

Implemented mailing system (Send mail) with attachments.

Developed and Implemented SSRS Reports.

Designed and developed Web-services using C#, ADO.net, and XML to handle online transactions with central database, which reduces the time, required performing data entry and generating reports.

Monitored database input/output data feeds and interfaces using SQL Server replication and other technologies.

Developed test cases Microsoft Test Manager (MTM) for new functionality based on business requirements

Implemented role based security for the user groups.

Technologies/Skills: ASP.NET, SSIS, SSRS, SSAS, C#, VB.NET, Web Services, HTML, SQL Server, XSL

Contact this candidate