PROFESSIONAL SUMMARY:

• Total 7+ years of design and development experience in the software industry
• 1.5+ years of C# and T - SQL development experience at Confidential, a cloud- Confidential
• 4+ years of .NET and T-SQL development experience working at Microsoft for following teams: ADO.NET Entity Framework, MSN editorial web services and Manageability Services Group
• 2 years of C and T-SQL development experience working at Confidential on their flagship RDMS product - Adaptive Server Enterprise
• Understanding of internals of ADO.NET Entity Framework and database internals of Confidential Adaptive Server Enterprise 15.1, the cluster edition of the relational database ASE
• Extensive databases background and proficient in C#, C and T-SQL
• Attention to detail and passion for quality displayed in the thoroughness of test coverage

TECHNICAL SKILLS:

Technologies: .NET Framework 4.5.1, 4.0, C#, ASP.NET Web API 2, ADO.NET Entity Framework, VB.NET, WCF,C++, JAVA, Perl, C, Assembly language (8086)Testing Frameworks: Visual Studio Unit Testing Framework, Moq mocking framework

Databases: MS-SQL Server 2014, T - SQL, Confidential Adaptive Server

Enterprise 12.5.3/15.0/15.0.1/15.1

Development Environment: Visual Studio 2013 Ultimate, Eclipse, VIM

Modeling: Visio 2007, Entity Framework designer, Rational Rose

Version Control: Visual Studio Team Foundation Server, Subversion, ClearCase

Operating System: Windows XP /7/8, Linux, Solaris, HP UX, IBM AIX

Tools: New Relic, PowerShell, Shell scripting, Microsoft Build Engine, Ant, WiX

PROFESSIONAL EXPERIENCE:

Confidential

Software Engineer

Responsibilities:

• For employment status history epic in Q2 2017 release, helped design approach to create employment status history rows from current data -
• Migrate only good data and provide fix-up wizard to fix bad data in production
• Wrote T-SQL queries to gain good understanding of bad data scenarios in production for status information
• Wrote T-SQL data conversion scripts to migrate good status information from current employee data in other tables.
• Do performance tuning on the scripts since script would work on converting millions of employees.
• Worked on place on leave, return from leave and ownership features for employee status information
• Designed and developed birthday and work anniversary API in Employee Domain project.
• Collaborated with Portal team to get requirements for this feature to display upcoming employee events on manager home page
• Implemented the change to make summary page visible to all Perform clients and make it the default landing page
• Implement new privilege to restrict Manager’s view of rmation of his reports in Perform and Employee API
• Added workflows for position, performance review, goals, assets, safety incidents and s changes
• Designed and developed rolling back of workflow process when it was required for multi-rater performance review workflow
• Designed and developed reopening performance review feature for an employee
• Added workflow enhancement to display friendly values for system lookup type fields on the change request modal
• Developed SSN masking and auditing functionality
• Developed tasks and notification API in the Notification Domain project
• Developed Discipline/Coaching API in the HrCore Domain project
• Created New Relic dashboard for APIs owned by team to monitor errors and proactively analyze the endpoints usage

Technologies: C#, Visual Studio 2015, ASP.NET Web API 2, Visual Studio Team Foundation Server, SQL Server 2014, Javascript, New Relic monitoring

Confidential

Consultant

Responsibilities:

• Designed and developed a monitoring service from scratch to monitor temperature, pressure and humidity aspects of a data center. It pushes the pulled data to Azure EventHub service.
• Designed and developed component for polling device event log from power meters and other electrical devices using Modbus function code 3 (Read holding registers) and 20 (Read file records). Optimized event polling so that only new events are polled in each cycle, thus reducing communication load on the devices.
• Designed and developed an event-based performance monitoring component of the service. Work consisted of instrumenting code with performance counters, defining component health metrics, evaluating health rules and displaying results on an HTML web page. The page HTTP status code indicates whether service is healthy/unhealthy and can be used to setup auto-monitoring of the service after deployment.
• Learnt Modbus protocol that is used to communicate with the real devices - power meters (Modbus TCP and Modbus RTU protocols) and wireless sensors that are connected to Modbus gateways.
• Learnt Task Parallel Library (TPL), feature in C# 4.5 for making an application concurrent.
• Learnt Unity Framework used for dependency injection into the application.
• Learnt the observer design pattern and used it to make it very easy to plug in new consumer components in the system.
• Thorough unit tests for all features using SpecFlow, a Behavior Driven Development solution for .NET to describe the user scenarios and expected results.

Technologies: C# 4.5.1, Visual Studio 2013, log4net, The Unity Application Block, Windows PowerShell, SpecFlow

Confidential

Lead Engineer

Responsibilities:

• Fixed bugs in editorial web services (WCF and ASMX services) in following areas - metadata inheritance in web pages, adding/removing content to web page slots, language locale for web pages
• Investigate and resolve production issue related to templates reported on the US datacenter
• Facilitate URL redirection records entry into the backend database required by France living website team and streamlined the process for future requests of this kind for Classic to TMX (Windows 8-touch optimized format) migration of msn sites
• Responsible for DRI duty which rotates in the team - wason call for any live site issues and investigated and resolved issues when they occurred
• Deploy EWS on all the MSN data centers using Autopilot deployment tools for a new pre-production environment set up by the team
• Wrote documentation on friendly URLs and URL redirects in MSN
• Improve the new developer hire wiki instructions in the team to make the process smooth for new developers

Technologies: C#, ASMX, WCF, HTTP, AutoPilot, SQL Server 2012, Visual Studio 2012, Visual Studio Team Foundation Server.

Confidential

Software Design Engineer

Responsibilities:

• Designed and developed Mapping API for Code-First that enables users to map object-oriented type hierarchies and relationships in the database.
• Developed T4 templates using C# and VB.NET for auto-generating POCO classes viz. persistence ignorant domain classes from the Entity Data Model, released on the Visual Studio Gallery
• Designed and implemented the enabling of complex data types as parameters and return types in model-defined functions, shipped as part of LINQ to Entities in .NET Framework 4.0
• Developed a code-generation tool used for exposing EF canonical functions through LINQ to Entities
• Developed feature improvements for SQL Generator in Entity Framework to increase the efficiency of LINQ to Entities queries over non-Unicode data
• Designed and developed a separate ETW provider for Entity Framework to enable collection of focused diagnostic information from deployed applications
• Developed relationship API improvements in Code-First, a popular EF feature
• Created WiX-based installers for out-of-band Community Technology Preview releases, CTP1 to CTP5
• Wrote thorough unit, functional and regression tests with high code coverage for all features
• Fixed bugs for the Entity Framework v2 release. Drove sustained engineering readiness efforts for data framework teams
• Participated in community engagement efforts by answering customer questions. Authored blog post describing feature ideas for future releases of the POCO template to gather customer feedback

Technologies: C#, .NET 4.0, Google Moq, .NET Code Contracts, Entity Framework, SQL Server 2008, LINQ, Visual Studio 2008/2010, Visual Studio Team Foundation Server.

Confidential

Software Development Engineer

Responsibilities:

• Designed and implemented Post-commit Processing phase of database recovery for ASE 15.1, which is the cluster edition of ASE
• Developed features for T-SQL and Database Consistency Checker commands for targeting a clustered database server
• Developed new features and fixed bugs for ASE 12.5.3, 15.0 and 15.0.1 releases
• Created detailed functional specification documents and user documentation for my features
• Actively participated in new hire on-boarding process by conducting on Logging and Recovery in ASE, my area of expertise
• Reviewed test plans and work closely with test team in the testing phase.

Technologies: C, T-SQL, ASE 12.5.3/15/15.0.1/15.1, VIM, GDB debugger, Solaris, IBM AIX, Linux, HP UX.

Confidential

Developer Intern

Responsibilities:

• Designed and developed a tool that converts the business object model designs from Visio to XML format, which is used to generate source code, hibernate mapping files and database schema creation SQL scripts
• Tool was used to validate existing business models and helped surface model bugs
• Conducted a session for the team on how to use the tool

Technologies: Java, Eclipse, Visio, Perl, Ant, Subversion

Confidential

Developer Intern

Responsibilities:

• Designed and developed a code scheduler for the optimization phase for CLASM, aC-like assembly language compiler
• The feature performed code analysis and used that information to do code scheduling
• Achieved an improvement of 4.3% in processor performance

Technologies: C, C++, Windows.