Resume

Sign in

Sql Server Data

Location:
Chicago, Illinois, United States
Posted:
January 29, 2018

Contact this candidate

Resume:

Akhila

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

Email ID: ac38s1@r.postjobfree.com

Summary:

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

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

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.

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

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

Provide support to development teams when they have to troubleshoot the entire application stack

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

Excellent understanding of JIRA workflows, permission schemes, notification schemes, screens schemes, etc.

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:

Framework : NET Framework 4.5/4.0/ 3.5.

.Net technologies : ASP.NET, Visio, Web Services,

Framework, AJAX, WCF, Entity Framework

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

Databases / Big Data : SQL Server 2014

Architectures : 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: Health Resources & Service Administration (HRSA), Chantilly, VA

Title: Application Developer

Duration: Sep 2016 – Till Date

Description: Bureau of Primary Health Care (BPHC) is a part of Health Resources and Services Administration of the United States Department of Health and Human Services. HRSA helps fund, staff and support a national network of health clinics for people. HRSA-supported clinics provide comprehensive, culturally competent, quality primary health care to a broadly diverse patient base that includes increasing numbers of veterans.

Responsibilities:

Responsible for monitoring production metrics and submitting a summary report to management once each month.

Asked to take part in a task force designed to bring efficiency to several business methods within the company.

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

Used Asp.net validations Controls for side validations.

Used Java Script validations for Compare Validation, Regular Expression validation.

Worked with production management to identify issues and create a summary issues report each week.

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

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

Used SVN for version control.

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

Develop, maintains and support object oriented application programs for administrative, Web and mobile systems using Java and related tools.

Participate on production support rotation coverage.

Experience in resolving urgent and immediate requests by various users in the demanding environment.

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

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

Maintaining the applications and managing their portfolios.

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

Worked on JIRA for internal ticketing system.

Participating in the unit and integration testing.

Used Agile methodology for the development with daily SCRUM meetings.

Actively participated in setting up retrospectives, sprint reviews or sprint planning sessions.

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

Environment: SQL Server, ASP.NET, C#.NET, Visual Studio 2015, SVN, Team Foundation Server(TFS), MS SQL Server, Agile Scrum Methodology, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), Java Script, Angular JS, JIRA.

Client Name: Pennsylvania State Police (Computer Aid, Inc) Harrisburg, PA

Title: Application Developer

Duration: Feb 2015 – August 2016

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.

Participate on production support rotation coverage.

Experience in database tuning and project support.

Experience in resolving urgent and immediate requests by various users in the demanding environment.

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.

Maintaining the applications and managing their portfolios.

Fixing the application and system problems

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.

Worked on JIRA for internal ticketing system.

Participating in the unit and integration testing.

Programmed, tested, and implemented a user login, product registration, order placing & tracking, and statistics reporting system in ten months.

Used Agile methodology for the development with daily SCRUM meetings.

Actively participated in setting up retrospectives, sprint reviews or sprint planning sessions.

Removing obstacles that affect the team as a scrum master.

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

Implementing the Business Logic in C#.

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

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



Contact this candidate