Post Job Free

Resume

Sign in

Sql Server .Net Developer

Location:
Houston, TX
Posted:
October 04, 2016

Contact this candidate

Resume:

SIDDHARTH C

.Net Developer/Full Stack

PROFESSIONAL SUMMARY:

* ***** ** ********** ** a Developer and diverse facets of .NET development, encompassing Analysis, Design, Development, and Execution of business applications.

Experience in all phases of Software Development Lifecycle (SDLC)

Expertise in technologies like C#, ASP 4.5, ADO, HTML, CSS, XAML, XML, JavaScript, AJAX, Angular.js, JQuery, KNOCKOUT JS

Experience in object oriented programming techniques and Microsoft design patterns like MVC 5, Service Oriented Architecture (SOA), WCF, WPF and Web Services

Experience in using of SQL, Query Analyzer, and Execution Plan to optimize SQL Queries.

Extensive programming experience using ASP.NET 4.5, VB.NET, HTML, XML/JSON.

Excellent working Knowledge of Backend programming, RDBMS, SQL Server 2012, SQL, T-SQL, Stored Procedures, Functions and Triggers

Experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Excellent skills in developing code for the database applications to interact with the databases, using ADO.NET

Consumed various ADO.NET components like Data Adapter, Dataset to perform data operations

Extensively used ADO.NET to implement the data layer to communicate with different databases.

Developed complex graphs using various AB-INITO components like Join, Reformat, Rollup, Sort, Partition by key, Merge, Gather etc.

Knowledge in the ETL data into a data ware house/date mart and BI tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).

Worked on various SDLC methodologies including Waterfall and Agile.

Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems.

Worked on Various Object Oriented Analysis and Design (OOA/D).

Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.

Worked with Team Foundation Server (TFS), Visual Source Safe and CVS

TECHNICAL SKILLS:

Programming: C, C++, C#.NET (Lambda, LINQ), VB.NET, SQL, ADO.NET, MVC 5, WCF, WPF

Basic Programming: Java, VB (6), Basic, LINQ (.NET)

Web Development / Scripts: HTML, Shell Script, ASP.NET 4.5, CSS, AJAX, XML, Angular, Knockout, JSON.

Database/Data warehousing Tools: SQL Developer, Oracle 11g, SSAS, MS SQL Server 2008/2010/2012/2014/2016

Worked with ETL tools, including Data Transformation Services (DTS), AB-Initio

Utility Tools: MS Visual Studio (2010,2012,2013,2015), MS Office Suite, MS Project, Adobe Photoshop, Adobe Illustrator

Web Server: IIS 7.0, TFS 2010, 12, 15, GitHub

EDUCATION & CERTIFICATIONS:

Bachelor of Technology in Computer Science, JAYPEE Institute of Information Technology University, India 2009

Oracle Certified Associate (OCA).

Oracle Database 11g Administrator Certified Associate. (OCA DBA)

Oracle PL/SQL Certified.

Windows Application Development with .NET 4(MCPD).

PROFESSIONAL EXPERIENCE:

Stone Bond Technologies, Houston, TX Aug 2014 – Till Date

.Net Developer Project: Enterprise Enabler (EE)

Responsibilities:

Responsible for Developing, Maintenance and Installation of in house product called Enterprise Enabler.

Developed .NET Connectors like SAP, Excel (using EPPLUS), JSON, Salesforce, etc. for data integration and logical data warehousing.

Developed Business Web Services (REST and SOAP) using EE for data integration and performance enhancement.

Reverse Engineering redesign from ASP.NET web site to ASP.NET MVC with Razor.

Redesigned classic ASP.NET web pages to ASP.NET MVC using Angular JS and Knockout JS for a Utility company client.

Developed reusable controls and DataGrid using Telerik controls.

Researched and implemented integration techniques for Master Data Management (MDM) using BI tools like Tableau, MS Power BI, QLIKVIEW

Achieved In-Memory caching and clustered caching using AppFabric and SQL Server 2016 IMOLTP.

Lead Offshore team members to assign tasks and responsible for task review.

Environment: ASP.Net 4.5, MVC 5, Angular JS, Knockout JS, SQL Server 2016, MDM, JSON, Telerik Controls, FxCop, WPF, WCF

Harris County Sheriff's Office, Houston, TX Jul 2013 – Jul 2014

.Net Developer Project 1: Extra Employment Permits

Responsibilities:

Researched, recommended and implemented technologies, software development architecture and design patterns, and information systems to meet organization goals.

Work closely with clients to gather project requirements, define deadlines and deliverables.

Created Complex Programming codes using java scripts, Ajax Control Extenders in .NET, SQL, T-SQL.

Researched and implemented web strategies to enhance web application/website usability and end user effectiveness.

Deploying the code both to the staging and the production Environment.

Resolving the issues in the code and Publishing the Solution on the Server

Used Angular.js to bind the values of HTML controls.

Used Angular.js to create the data in the table using ng-repeat attributes.

Used Angular.js and bootstrap to style the pages.

Environment: Windows 8.1, C# 4.0, ASP.NET 4.0, SQL Server 2012, HTML, JavaScript (AJAX & jQuery), CSS3, Angular.js, Bootstrap.js

Project 2: Sheriff's Information Resource System (SIRS)

.Net Developer

Responsibilities:

Designed and developed multi-tier data driven web application in support of Sheriff Information Systems such as HR performance, Payrolls, Inventory Issue, etc...

Researched, recommended and implemented .Net technologies such as C#, ASP.NET, SQL Server, HTML, JavaScript (AJAX & jQuery), CSS and web services.

Worked directly with clients and project manager to define requirements.

Worked on the razor to create the view in the MVC pattern.

Worked with the Entity Framework to create the update model from database approach.

Created Stored Procedure, Triggers, Constraints, Joins, Indexes, SQL Profile to test traces.

Designed and coded SSRS and added into the existing echo system.

Environment: C#, ASP.NET 4.5, SQL Server 2012, HTML, JavaScript (AJAX & jQuery), CSS and web services, ADO.NET, Entity framework 6.0.

Infosys Technologies Ltd., Hyderabad, India Jun 2009 – Jun 2013

Systems Engineer

End Client - Capital One Bank

Project 1: Early Account Management

Responsibilities:

Worked as developer, responsible for design, development and testing of applications for capital one credit cards fraud detection.

Created various generic shell scripts for the support of development.

Developed complex graphs using various AB-INITO components like Join, Reformat, Rollup, Sort, Partition by key, Merge, Gather etc.

Highly involved in all the stages of SDLC during the projects. Analyzed, designed and tested the new system for performance, efficiency and maintenance using ETL tool AB INITIO.

Extensively worked in Production Support and business analysis for the project.

Used Toad to verify the counts and results of the graphs.

Environment: AB Initio (Co.Op 2.15, GDE 1.15.9.2), Unix, Team Foundation Server (TFS), Control-M, DB2, Oracle 10G

Project 2: Secured Card Clip

Responsibilities:

Involved in complete data analysis for the secured credit card regulations and developing the application for performing regulatory acts using ETL tool AB INITIO.

Presented and trained capital one officials regarding the usability, importance and technical aspects of the application.

Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.

Created various wrapper shell scripts to execute the Ab-Initio Objects.

Developed CONTROL-M scheduler scripts to schedule a process for business flow.

Environment: AB Initio (Co.Op 2.15, GDE 1.15.9.2), Unix, Team Foundation Server (TFS) 2010, Control-M, DB2, Oracle 10G



Contact this candidate