Resume

Sign in

Sql Server Data

Location:
Naperville, Illinois, United States
Posted:
March 14, 2018

Contact this candidate

Krishna Katta

224-***-****

ac4s34@r.postjobfree.com

SUMMARY

Over 2 years of IT Experience in Systems Design,Development and Support of Microsoft SQL server in Development

Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2005/2008 R2/2012/2014.

Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).

Experience in SSIS tools like import and export wizard, Package installation, and SSIS Package designer.

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.

Experience in Microsoft Visual C# in script component of SSIS.

Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.

Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.

Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.

Great ability to create and manage various database objects like tables, views.

Worked Extensively on ETL process using SSIS package.

Experience in Performance Tuning and Query Optimization.

Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.

Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)

Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.

Expert in creating Parameterized Reports.

Hands on experience in Creating Star Schema and Snow Flake Schemas.

Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

EDUCATION

University of Illinois at Springfield

M.S. in Computer Science

01/2015-05/2016

GPA: 3.87/4

Courses: Web development and programming, Web design, Virtualization, Storage area networks. San Essentials, DBMS, Incidence response

G. Pulla Reddy Engineering College

Bachelor of Technology in Engineering

07/2010-05/2014

GPA: 3.0/4

TECHNICAL SKILLS

Languages

C#, SQL, T-SQL, PL/SQL, XML, HTML.

.Net Framework

.Net Framework 4.5,4.0

Enterprise Services

IIS Server, Content Management Server,Tibco EMS

Database

SQL Server 2014,2012, 2008/2005, MS Access

ETL Tool

Technologies

SSIS

ASP.Net, MVC.

Reporting Tool

Operating Systems

SSRS, Tibco Spot Fire, Crystal Reports

Windows Server 2008, Mac and Linux

Testing Tools

Microsoft Test management

Debugging Tools

Firebug Lite, Google Chrome Web Debugger & SVN.

Software Engineering

Agile(Scrum)

WORK EXPERIENCE

.Net Developer 06/2016- Present

Victor O. Schinnerer & Company, Inc., Chevy Chase,MD

Victor O. Schinnerer & Company, Inc. operates as an underwriting management company of professional liability and specialty insurance programs. It focuses on evaluating risks, implementing program marketing, developing and executing risk management activities, and servicing accounts on behalf of insurance company partners. The company offers various programs, including business-to-business consultants, design firms and consultants, contractors, insurance agents and broker’s errors and omissions, and environmental consultants programs.

Responsible for designing the ASP.NET application authentication using ASP.NET MVC Authorization filters.

Used ASP.NET MVC framework to support the use of Dependency Injection to inject objects into a class, instead of relying on the class to create the object itself.

Extensive Writing and modifying Stored-Procedures and user defined functions in SQL Server and T-SQL to carry out database operations.

Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.

Created SSIS Package for File Transfer from one location to another using FTP task.

Design, develop ETL packages, tables, stored procedures, indexes, views, and functions etc. to implement best practices and to maintain optimal performances.

Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).

Created complex SSIS packages using proper Control and Data flow elements

Created tibco EMS services in the application.

Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.

Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert

Worked On Insurance, Policy and Commodity data

Responsible for developing the reusable Components on UI(Views) by developing the Partial Views, View starts, and reusable components for implementing the business rules with C# and OOPS Concepts.

Created various Single Page Applications for business using MVC 5 and Razor Engine

Automated various Daily activities using SSRS.

Expert in creating Parameterized SSRS Reports

Created complex Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements to maintained referential integrity and implemented complex business logic.

Developed complex T-SQL queries, User Defined Functions, Stored Procedures and Triggers in SQL Server2012 followed by analysis and testing of those database objects before deployment to the production server

Created multiple stored procedures, views and ad-hoc reports to generate usage reports.

Performed data conversion from flat file into a normalized database structure.

Resolved any deadlocks issues with the Databases/Servers on a timely basis.

Designed and created the table schema and stored procedures that will be used in Data QC.

Used SSRS Reporting services (SSRS) to write complex formulas and to query database to generate different types of reports (Drill Down, Drill Through, Linked, Sub-reports, and Parameterized) for Business Intelligence

Developed solutions for diverse programming scenarios in C#.Net, employing Object Oriented Programming (OOP) concepts.

Creating applications using C#.Net and enhancing projects for .Net applications.

Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility.

Involved in migrating tibco spot fire reports into SSRS Reports.

Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database.

Optimized various Stored Procedures by using Recursive CTE’s, Temp Tables and Sub Queries.

Used SVN extensively for version control of the source code along with the maintenance of the builds and the relevant documents of the same.

Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).

Used (SVN) for source control and documented the entire application.

Created test plans and performed unit and regression testing on the application.

Experience in coordinating with on site and offshore team members in daily status meeting to resolve issues related to project Activities.

Skills: MVC5, MVVM, C#, CSS, HTML, ASP.NET, ADO.NET, .Net Framework 4.5, LINQ, N-Hibernate, Visual Studio 2010,, JQuery, JavaScript, AngularJS, Web Services, JavaScript, JQUERY, SQL Server Integration Services (SSIS), T-SQL (SQL Server 2008), XML.

Jr .Net Developer 05/2014- 12/2014

Sero Group, Hyderabad, India

Developed UI page and development using ASP.NET, HTML, Telerik Ajax RadControls, AJAX, User Controls and Web Forms with C# using N-tier architecture.

Utilized ADO.Net Entity Framework Database First technology extensively for data retrieving, querying, storage and manipulation using LINQ to Entities.

Utilized ADO.Net Entity Framework Database First technology extensively for data retrieving, querying, storage and manipulation using LINQ to Entities.

Written Queries using T-SQL Statements, Views, Stored Procedures, Triggers, Cursors and User Defined Functions in SQL Server 2008 for inserting/Updating/Deleting the data into the relational tables.

Developed web presentation layer using HTML and CSS according with internal standards and guidelines.

Created test plans and performed unit and regression testing on the application.

Created SSIS Package to Load XML files and Load into SQL tables.

Skills: SQL Server 2012, SSIS, SSRS, HTML 4.x, CSS2.x, JavaScript, JQUERY, XML.



Contact this candidate