Engineer Sql Server

SURENDRA CHANDALURI

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

Phone: +1-903-***-****

Summary

Experienced developer with over 5+ years of experience, working with most of the .net technologies such as C#, SSIS, SQLSERVER with a degree in Management to achieve technology in Industrial Standards.

Management Skills

Lean Management Six Sigma Implementation MS Office

Operations Management Total Productive Maintenance Design Optimization

Technical Skills

Operating System: Windows 10/8.1/8/7/XP/NT, MAC OSX10, LINUX

Programming: C, C++, C#, VB.net, ASP.net, ADO.net

Database Technologies: SQL Server 2014/2012/2008 R2/2008/2005/7.0, SSIS

Web Technologies: HTML, CSS, JavaScript

Configuration Tools: MS Visual Source Safe, MS Team Foundation Server,

Framework: Microsoft.NET Framework4.0/3.5/3.0/2.0

Work Experience

Zurich (SOGETI): App System Engineer (May 2016- Present)

Harrisburg PA

Design, develop, implement and support highly complex WinForms applications using advanced knowledge of technologies including VB.Net, Infragistics Controls, Windows Presentation Foundation and associated technologies.

●Design Develop, Implement a highly complex Webforms using Angular JS, Node JS, HTML

●Solve technical problems around application system design, performance, scalability and system/product stability.

●Evaluates systems specifications for desktop application requirements and determines/implements the most efficient and cost effective software solutions.

●Researches and tracks new technologies, develops service applications, and analyzes business requirements for Crop Insurance agents and other internal business groups.

●Responsible for system quality assurance and consistency with installation and security policy and standards.

●Provide direction and guidance to less experienced staff.

●Provides application support and attends to application and server related issues.

●Work in Agile Methodology

Student Engineer: Ingenuity center, University of Texas, Tyler (Jan2015 – May 2016)

TYLER TX

●Involved in requirement analysis, designing, development and Testing

●Major role in the development of the web application using ASP.NET4.0, C#, Java script, Angular JS, Bootstrap, ADO.NET and AJAX. Primarily assigned for developing SSIS packages using C#.

●Used HTML, CSS, JavaScript for the front-end web development. Used agile methodology to implement the application. Participated in all the phases of Software development life cycle (SDLC);

●Gathering requirements.

●Designed and developed views as responsive components using HTML and CSS. Extensively used JavaScript, JQuery for client side validations in the views.

●Provided Knowledge transfer sessions to juniors.

Project Engineer(Developer): Wipro Technologies, Hyderabad, India (May 2012 - Dec 2014)

KONE HYD

NATIONAL GRID HYD

●Created Packages successfully and deployed the packages to different environments like UAT Server, Production Server by Using Deployment Manifest file.

●Developed Packages using different tasks like Dataflow Task, Script task, XML Task, Execute SQl Task, Execute Package task and File System Task.

●Used different transformations like derived column, conditional Split, Data conversion, Row Count, Export Column, Import Column, Merge, Lookup and Script Component.

●Loading data from various sources like OLEDB Source, Flat File Source and XML Source to different destinations like Flat File Destination, OLE DB Destination, XML Destination and Record Set Destination

●Using SSIS Packages and created data mappings to load the data from source to destination.

●Used Script Component in Dataflow task in different ways like Source, Transformation and Destination

●Created Custom Scripts in Script tasks using VB.NET language and has done validations

●Worked on Expressions and Constraints in the Control Flow Level to separate the Flow of execution of the Packages.

●Have written Custom Scripts in Script tasks and connected to SQL Server in the scripts using ADO.NET concepts Connection String, Data Reader, Data Adapter etc.

●Created Stored Procedures and also used these stored procedures in different ways like to call SSIS Packages or to use in SSIS Script task etc.

●Good Experience in dealing with SSIS Variables like Creating Variables, passing data to the variables and also make them as Global Variables between the packages and also from Stored Procedures.

●Created Jobs using SQL Server Agent and also scheduled those jobs to automate the system based on requirement.

●Shared the developed packages to the team lead or other developers using centralized server i.e. Team Foundation Server (TFS) by Creating Package Configuration File for each Package to run on others Developers System.

●Developed Test cases to fix the Bugs (BUG FIXING) Used HP QC for building and testing, the test cases.

Education

M.S. in Engineering Industrial Management-2016 with a GPA: 3.6/4.0

University of Texas at Tyler, Tyler, TX

BS in Electronics and Communications Engineering-2012 with a CGPA: 6.6/10

VIT University, Vellore, India

Contact this candidate