C# Sql Server
Resume:
Srinivasulu N Thirumalasetty
Phone: 469-***-****
Email: *******@*****.***
Objective:
18+ years of IT professional seeking a challenging career in Software Development with latest technologies that utilizes my skills in my area of competence and enriches my knowledge and gives me a chance to be part of a team that contributes towards the growth of the organization, thereby yielding the twin benefits of job satisfaction and professional growth.
Key Strengths:
Good in C#, Go and programming
Good in MVC Web development
Good in Web API development
Good in Data Quality, Analysis and Data Engineering
Very strong in Agile development
Very good in Team Management
Strong in Delivery management
Go/ GCP /C#.NET / Cypress/ Big Query / SQL Server
Summary:
Nineteen years of extensive experience in leading projects from planning to execution in Microsoft technologies like VB6, ASP.NET, VB.NET, C#, ADO.NET, MVC, Web API, WCF, Azure, SQL Server, Oracle, Python, Go Lang, GCP.
Strong in Data Quality, Data Engineering and Process implementation.
Good in using GCP tools, implementing Data migration projects and Quality checks.
Conversant with Object Oriented Programming with C#. Knowledgeable on Service Oriented Architecture (SOA), web services, and messaging transports / technologies.
Possesses detailed working knowledge of .NET Framework and Visual Studio. Has detailed experience gathering and analyzing the requirements and articulating these into an accurate development, and management teams as well as operations stakeholders.
Experienced in relational database with SQL Server, Sybase and DB2. Knowledgeable in writing complex queries, performance tuning and writing Stored Procedures.
Well-rounded mentoring, team skills and leadership abilities. Demonstrated strong communication and articulation skills in the professional assignments.
Expert in dealing with direct customers in gathering requirements, recommending optimized solutions as per the requirements.
Highly motivated individual who enjoys working on new technologies and recognizes rapid learn ability.
Have good knowledge on Point of sale applications. Career started with Pharma Billing application for both retail and wholesale customers.
Responsible for Coding and the code review written by team members and deploy the Build to Dev, QA, and Production server.
Involved in code reviews and give proper directions to the team in Java and other languages like PHP, Shell scripting.
Experienced in Agile or Scrum environments, working in Iteration based development projects and well experienced across all phases of Agile development.
Experienced in leading development teams, conducting Code Review and constructively advising the team on changes to adhere to good coding standards and practices.
Experienced in Test Driven Development tools like Nunit and Moq.
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.
Experienced in Multi Threading application development using C#.
Got good exposure to Microsoft Azure Service Bus to store and retrieve the messages as part of outlook integration.
Got good experience on storing and retrieving large sized images and emails on Microsoft Azure to provide high availability and better performance.
Well experienced in Co-ordination between the teams and also have experience in working Onsite-offshore model with different geographical regions.
Technical Skills:
.NET Technologies / Frameworks
.Net 1.1 – 4.5, ASP.Net, ADO.Net, XML Web Services, WCF, WebAPI, Multi Threading, Enterprise Application Blocks, IIS Web Server, MVC 5.0, AngularJS, Azure Service Bus, SSRS, SSIS, Data Factory, Google Analytics
Operating system
Windows 2003, 2005, 2008 R2
Languages
Go, Microsoft Visual Basic .Net, ASP.Net, C#, Go Lang, AJAX, JQuery, Microsoft Visual Basic 6.0, Visual Basic Applications, XML, CSS 3, DHTML, HTML 5, BootStrap 3, PL/SQL, T-SQL
Databases
MS SQL Server, Access, DB2, Sybase, Oracle, PostgreSQL
Methodologies
Agile, Water fall,
Domain
Telecom, E-Commerce, Tax & Accounting, Banking, Financial Services, Medical
Cloud
Google Cloud
Tools & Utilities
nUnit, FxCop, Moq, GoDog, Go-Test-Report, Cypress, JIRA
Education & Awards
Masters of Science in Information Technology.
Best Performance award from Moody’s CEO.
Best coder award from Thomson Reuters.
Professional Summary:
Client:
Optimum, Plano, TX
#1
Duration:
Feb 2024 – Till date
Role as:
Sr. Data Analyst/ Data Engineer/ Lead
Create Apache Airflow DAGs to migrate data from Oracle database to Cloud SQL.
Monitoring the performance of ETL jobs and optimizing them.
Developed Automation scripts to validate the data loaded into Cloud SQL against UI.
Developing K6 scripts to evaluate the performance and stress testing.
Writing test results to Grafana to monitor the performance and failures.
Developed an automation system for testing the critical application in Optimum.
Involved in Test Driven Development using Go Test to cover Golang API code.
Running the automation scripts daily and fixing all the issues in the scripts using Cypress.
Supporting .NET applications developed by me and my team earlier and enhancing the features.
Involved in writing backend gRPC microservices using Go Lang.
Working on performance tuning the stored procedures.
Involving in all the meetings with POs, QA Team and Developers to make sure the requirements are gathered properly so that the deliverables will be smooth.
Monitoring and coordinating the teams on the jobs running on GCP
Trouble shooting the applications developed in .NET and C#.
Document all the issues and submit the RCAs on critical issues raised and providing solutions to fix them.
Managing the teams at different time zones and assigning the tasks using jira.
Monitoring the day-to-day development activities and making sure the applications are delivered ontime.
Prioritizing the tasks and interaction with offshore teams at different time zones.
Environment: Python, Oracle, Cloud SQL (Postgres) .NET, C#, Web API, Go Lang, gRPC, GCP, GIT, Bitbucket, K6, Godog. Cucumber, Cypress, Jira.
Client:
Altice USA, Plano, TX
#2
Duration:
Sep 2023 – Jan 2024
Role as:
Sr. .NET / GO Lang Developer / Data Analyst
Build the system to fetch data from upstream databases and load into lower level.
Move the system from legacy Java to .net and Go lang to improve the performance.
Replace the sql statements to fetch the data by stored procedures in SQL Server that is consumed by .NET and other applications.
Migrate stored procedures from Oracle to BigQuery on GCP.
Involved in building APIs in Go using Protocol Buffers and gRPC.
Worked on performance tuning the stored procedures.
Monitoring and coordinating the teams on the jobs running on GCP
Developed many applications to perform nightly jobs using .NET and C#.
Managing the teams at different time zones and assigning the tasks using jira.
Monitoring the day to day development activities and making sure the applications are delivered ontime.
Prioritizing the tasks and interaction with offshore teams at different time zones.
Environment: .NET, C#, Web API, GCP, Python, GIT, Bitbucket, K6, Godog. Jira.
Client:
Altice USA, Plano, TX
#3
Duration:
Oct 2017 – Sep 2023
Role as:
Sr. .NET Developer / Data Analyst
Involved in Analysis of Requirements.
Developing POCs to migrate the data from one system to other.
Wrote many stored procedures in SQL Server that is consumed by .NET and other applications.
Worked on performance tuning the stored procedures.
Monitoring and coordinating the teams on the jobs running on GCP
Developed many applications to perform nightly jobs using .NET and C#.
Develop automation scripts using Go Test and Go Dog and K6 for performance and regression tests.
Develop code for Go Test to do regression testing.
Managing the teams at different time zones and assigning the tasks using jira.
Monitoring the day to day development activities and making sure the applications are delivered ontime.
Escalating key issues to the senior management upfront.
Prioritizing the tasks and interaction with offshore teams at different time zones.
Environment: .NET, C#, Web API, GCP, Python, GIT, Bitbucket, K6, Godog. Jira.
Client:
LSI, Plano, TX
#4
Duration:
Jan 2016 – Sep 2017
Role as:
Sr. .NET developer
Involved in Analysis of Requirements.
Preparation of functional / technical specs.
Performance tuning of Stored Procedures.
Writing Stored Procedures in SQL Server 2016
Developed Multi Threading console application to process the request and responses from Oracle Fusion services in C#.
Created multiple console applications using C# to monitor the integration processes.
Created SSRS reports to generate Invoice and other complex reports
Data migration from MYSQL to SQL Server with the help of SSIS and Data Factory
Integrated Paypal and Credit Card payments into .NET through the WebAPIs provided by the vendors.
This project, works like Amazon or EBay, where the customers can place their orders, buy online pay the payments through Credit cards and Paypal from throughout the world, I involved in payment processing, invoice report generation, etc.
Created rich, flexible, standards-compliant screens using MVC hand-coded HTML5, CSS3, Bootstrap 3 and Jquery.
Worked on WCF services to process the requests and responses from Oracle Fusion.
Creating single page applications to view the products in tablets and mobiles using AngularJs.
Identifying bottlenecks in the process and improved a lot for the better results.
As part of Test Driven Development, involved in writing Unit Testing with NUnit & Bug fixing.
Involved in code reviews of other developers.
Minimizing the cost/Time by automating the manual process.
Conducting Daily scrum meetings.
Developed many Integration services in C# to integrate Oracle Fusion with .NET.
Involved in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
In Outlook integration and other image processing, used Azure Services to store and retrieve the data.
Being an experience guy in NHibernate usage in .NET, demonstrated the pros and cons and finally went with ADO.net instead of ORM.
All the product related images are stored and retrieved from Azure, this way we can save the storage space on db and improve the performance.
Used Data Factory on Azure to load data from Sales Force to SQL Server.
Escalating key issues to the senior management upfront.
Created multiple stored procedures in Oracle to handle invoice process.
Prioritizing the tasks and interaction with offshore teams at different time zones.
Environment: ASP.NET, WebAPI, MVC 5.0, C# 4.5, VS 2015, NUnit, Moq, Windows 10, HTML 5, BootStrap 3, JQuery, CSS 3, IIS7,Jenkins, SQL Server 2016, Oracle 10g, Azure Service Bus, Team Foundation Service and GIT hub for source control.
#5
Client:
Thomson Reuters, Carrollton, TX
Duration:
March 2013 – December 2015
Role as:
S r. .NET developer
Involved in Analysis of Requirements.
Preparation of functional / technical specs.
Performance tuning of Stored Procedures.
Created rich, flexible, standards-compliant screens using MVC hand-coded HTML5, CSS3, Bootstrap 3 and Angular.
Identifying bottlenecks in the process and improved a lot for the better results.
As part of Test Driven Development, involved in writing Unit Testing with NUnit & Bug fixing.
Involved in code reviews of other developers.
Hands of experience in Web application deployment.
Minimizing the cost/Time by automating the manual process.
Conducting Daily scrum meetings.
Worked on migrating the data from Oracle to SQL Server.
Written multiple stored procedures, functions to manage the tax and accounting data.
Implemented WCF and WebAPI services.
Involved in Bug-fixes and enhancements in the existing applications.
Involved in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
Tried NHibernate to perform database operations instead of ADO.NET. Later switched to Entity Framework.
Escalating key issues to the senior management upfront.
Prioritizing the tasks and interaction with offshore teams at different time zones.
Environment: ASP.NET, WebAPI, MVC 4.0, C# 4.0, WCF, Restful Services, Component One Controls, VS 2013, NUnit, Moq, Windows 7, HTML 5, BootStrap 3, AngularJs, JQuery, CSS 3, IIS7, Google Analytics, SQL Server 2000, Oracle 10g Jenkins, Team Foundation Service and GIT hub for source control.
#6
Client:
Moody’s Investor Services, NY
Duration:
Nov 2010 – Feb 2013
Role as:
Project Lead
Developed the project using traditional 3-tier architecture with presentation tier, Business Tier and backend database tier DB2.
Developed various user controls in WPF which were reused in lot many UI interfaces throughout the application.
Applied different styles to the WPF controls at runtime, to give a rich UI look to the application.
Implemented various Custom Generic Classes using C#. Used LINQ Expressions to query the data from different object collections using C#.
Provided business users with an option to export the data into .xls and pdf snapshot format. Used ADO.NET in the database tier to communicate between database and business layer.
Implemented SQL Queries and Stored Procedures using Rapid SQL component for accessing DB2 database.
Used Clear Case as the source control software to maintain different versions of the project.
Worked with the business analysts closely to gather the requirements and convert them into the technical level details for developing the application.
Coordinating with the QA and DEV team to set up the testing environment.
Extensively involved in requirement gathering, analysis, and design solution for the application.
Responsible for review and approval of critical tasks and functions associated with project planning, development, and implementation.
Interact with the Client and provide feedback on design modules.
Responsible for Coding and the code review by team members and deploy the code to the Staging and Live server.
Developed WCF services to get the latest financial data from different sources.
Coordinate and prioritize application modifications and bug fixes.
Used MS-Project for project planning.
Improved the quality of code by writing Unit Test cases with NUnit.
Used MSMQ for email service.
Tested, Maintained, Documented, and Deployed application on Production Server.
Environment: .NET, Visual Basic, VBA, DB2, T-SQL, MS Excel, Clear Case, NUnit, WCF, Remedy User
#7
Client:
Moody’s Investor Services, NY
Duration:
Apr 2009 – Oct 2010
Role as:
.NET Team Lead
Developed code using Visual Studio 2005 in Dot NET Framework 2.0 with an emphasis on both front-end methodologies including HTML, XML, XSLT, AJAX, JavaScript and server-side programming C#.
Extensively involved in requirement gathering, analysis, and design solution for the application.
Developed Program to send auto generated mails and messages to Communities if there is some important news or information to be delivered.
Responsible for review and approval of critical tasks and functions associated with project planning, development, and implementation.
Interact with the Client and provide feedback on design modules.
Analyzed the applications architecture and implemented enhancements.
Created Custom Controls such as application wide message boxes, error handlers, authentications which were embedded in Business Applications.
Created rules in NUnit to do the unit testing.
Developed various Web Services using WCF hosted them and used in the application.
Responsible for Coding and the code review by team members and deploy the code to the Staging and Live server.
Developed and implemented Relational Database, and Stored Procedures, Functions, Designed Tables, Views, and Trigger for the backend database.
Developed stored procedures in Sybase to provide data to reports.
Developed an MSMQ based distributed job scheduler for Windows Services.
Tested, Maintained, Documented, and Deployed application on Production Server.
Environment: C#.NET, Visual Basic, VBA, Sybase, T-SQL, MS Excel, MKS Integrity, Remedy User
#8
Client:
Moody’s Investor Services, NY
Duration:
Jun 2008 – Mar 2009
Role as:
Team Lead
Discussions with client based on the System Requirements.
Document to cover the functionality, design and analysis issues and scope of work.
Worked on ASP to ASP.Net migration.
Developing code behind by using C#.
Developed code using Visual Studio 2005 in Dot NET Framework 2.0 with an emphasis on both front-end methodologies including HTML, XML, XSLT, AJAX, JavaScript and server-side programming C#.
Extensively involved in requirement gathering, analysis, and design solution for the application.
Developed Program to send auto generated mails and messages to Communities if there is some important news or information to be delivered.
Responsible for review and approval of critical tasks and functions associated with project planning, development, and implementation.
Interact with the Client and provide feedback on design modules.
Analyzed the applications architecture and implemented enhancements.
Created Custom Controls such as application wide message boxes, error handlers, authentications which were embedded in Business Applications.
Created rules in NUnit to do the unit testing.
Developed various Web Services using WCF hosted them and used in the application.
Responsible for Coding and the code review by team members and deploy the code to the Staging and Live server.
Developed and implemented Relational Database, and Stored Procedures, Functions, Designed Tables, Views, and Trigger for the backend database.
Created stored procedures in Sybase to provide data to reports.
Tested, Maintained, Documented, and Deployed application on Production Server.
Environment: C#.NET, ASP.NET, Java Script, XML, XSLT, Sybase, T-SQL, MKS Integrity, Remedy User
#9
Client:
NCR Corporation, India
Duration:
Apr 2007 - May 2008
Role as:
.NET Developer
Developed code using Visual Studio 2005 in Dot NET Framework 2.0 with an emphasis on both front-end methodologies including XML using C#.
Extensively involved in requirement gathering, analysis, and design solution for the application.
Developed Program to send auto generated mails and messages to Communities if there is some important news or information to be delivered.
Responsible for review and approval of critical tasks and functions associated with project planning, development, and implementation.
Interact with the Client and provide feedback on design modules.
Analyzed the applications architecture and implemented enhancements.
Created Custom Controls such as application wide message boxes, error handlers, authentications which were embedded in Business Applications.
Created rules in NUnit to do the unit testing.
Developed various Web Services using WCF hosted them and used in the application.
Responsible for Coding and the code review by team members and deploy the code to the Staging and Live server.
Environment: C#, NUnit 2.2.6, FxCop, MKS Source Integrity.
#10
Client:
Motorola, U.S
Duration:
May 2006 - Mar 2007
Role as:
.NET Developer
Developed code using Visual Studio 2005 in Dot NET Framework 2.0 with an emphasis on both front-end methodologies including XML using C#.
Extensively involved in requirement gathering, analysis, and design solution for the application.
Developed Program to send auto generated mails and messages to Communities if there is some important news or information to be delivered.
Responsible for review and approval of critical tasks and functions associated with project planning, development, and implementation.
Interact with the Client and provide feedback on design modules.
Analyzed the applications architecture and implemented enhancements.
Created Custom Controls such as application wide message boxes, error handlers, authentications which were embedded in Business Applications.
Created rules in NUnit to do the unit testing.
Developed various Web Services using WCF hosted them and used in the application.
Responsible for Coding and the code review by team members and deploy the code to the Staging and Live server.
Environment: .Net framework 2.0, ASP.Net, C#, SQL Server 2000, NUnit, FxCop, ClearCase.
#11
Client:
Bravera, U.S
Duration:
Jan 2006 - Apr 2006
Role as:
.NET Developer
Developed code using Visual Studio 2003 in .NET Framework 1.1 using C#.
Responsible for review and approval of critical tasks and functions associated with development, and implementation.
Interact with the Client and provide feedback on design modules.
Used Pure Coverage tool for analyzing the percentage of product code covered in UnitTest cases.
Involved in Peer reviews.
Involved in Screen Design and modifying the existing screens as per the requirements.
Involved in developing a tool to provide drag and drop the files from the desk top to webpage using Visual Basic 6 ActiveX.
Written JavaScript functions to change the existing functionalities.
Environment: ASP.Net, C#, SQL Server, Visual Basic, Bugzilla, MKS Integrity.
Sr. Data Engineer/Analyst/ Lead
Contact this candidate