We provide IT Staff Augmentation Services!

Sr.software Engineer   Resume

Westwood, MA

SUMMARY/EXPERIENCE:

  • Has thirteen years of overall experience in IT industry in Tiered Application Development.
  • Strong in architecture, design and development of applications using MS SQL Server.
  • Excellent hands on experience in developing SSIS packages.
  • Expert in MS SQL Server 2008/2005 Database Development in writing Store Procedures, Cursors, Triggers, Views, Indexes and Constraints.
  • Broad knowledge of all stages of software development, including design, architecture, programming, testing, implementation and support of distributed applications.
  • Great team player, highly motivated, adaptive and quick learner with excellent interpersonal, technical and communication skills.
  • Good knowledge of finance industry and worked on equities, funds, loans and deposits.
  • Experience with CRM and ERP applications.
  • Experience with SSAS, SSIS and MDX cubes.

TECHNICAL SKILLS:

Development Tools/Language: ASP.Net, Web Services, Visual C#, VB.Net, XML, VB 6.0, T – SQL, PL/SQL, VB Script and Java Script

Windows Server System: SharePoint Portal Server, IIS 6.0.

RDBMS: MS SQL Server 2008/2005, Oracle 9i, MS Access

.Net Technologies: CLR, CTS, ADO.Net, Code Access Security, Serialization, Multithreading, Caching, ASP.Net Security, State Management, Master Pages

Scripting & Markup Languages: javaScript, HTML, DHTML, VBScript, XML (DOM)

Operating Systems: Windows 9x - Server 2003

Middleware/Libraries: Web Services, COM, COM+

Tools: Visual Studio .NET 2005, Product Studio, Source Depot, MsInsight, Changepoint, Crystal Reports 9.0, ER Win, Visual Source Safe, Visio 2003, TOAD 7.3.

PROJECT DETAILS:

Confidential , Westwood MA

Sr.Software Engineer

Responsibilities:

  • Writing stored procedures and views.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Provide database coding to support business applications using SQL server T-SQL.
  • Perform quality assurance and testing of SQL server environment.
  • Develop new processes to facilitate import and normalization, including data file for counterparties.
  • Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
  • Completed database modeling, designing and development using Erwin and wrote Stored Procedures in T-SQL.
  • Created SQL server jobs and SSIS packages.

Technologies Used: C#, ASP.NET 2.0, Visual Studio 2005, SQL Server 2008, JavaScript, VBScript, Microsoft Visio, XML, TFS.

Confidential, NH

Sr.Software Engineer

Responsibilities:

  • Plan, design, and implement application database code objects, such as stored procedures and views.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Provide database coding to support business applications using SQL server T-SQL.
  • Perform quality assurance and testing of SQL server environment.
  • Develop new processes to facilitate import and normalization, including data file for counterparties.
  • Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
  • Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
  • Completed database modeling, designing and development using Erwin and wrote Stored Procedures in T-SQL.
  • Created SQL server jobs and SSIS packages.
  • Used TFS for file maintenance.

Confidential Southborough, MA

Senior Database Developer

Responsibilities:

  • Plan, design, and implement application database code objects, such as stored procedures and views.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Provide database coding to support business applications using SQL server T-SQL.
  • Perform quality assurance and testing of SQL server environment.
  • Develop new processes to facilitate import and normalization, including data file for counterparties.
  • Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
  • Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
  • Completed database modeling, designing and development using Erwin and wrote Stored Procedures in T-SQL.
  • Created SQL server jobs and SSIS packages.
  • Used TFS for file maintenance.

Technologies Used: C#, ASP.NET 2.0, Visual Studio 2005, SQL Server 2008, JavaScript, VBScript, Visual SourceSafe 6.0, Microsoft Visio, XML, TFS.

IkaCRMPortal
This CRM product covers entire commercial groups Sales Force Automation, Underwriting, Medical Questionnaire, Employer, Member and Account Management, Product maintenance, 834 files and Interface are included.

Responsibilities:

  • Plan, design, and implement application database code objects, such as stored procedures and views.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Provide database coding to support business applications using SQL server T-SQL.
  • Perform quality assurance and testing of SQL server environment.
  • Develop new processes to facilitate import and normalization, including data file for counterparties.
  • Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
  • Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
  • Completed database modeling, designing and development using Erwin and wrote Stored Procedures in T-SQL.
  • Created SQL server jobs and SSIS packages.
  • Used TFS for file maintenance.

Technologies Used: C#, ASP.NET 2.0, Visual Studio 2005, SQL Server 2008, JavaScript, VBScript, Visual SourceSafe 6.0, Microsoft Visio, XML, TFS.

Confidential, New York, NY

Senior Database Developer

Responsibilities:

  • Gathered Requirements from functional experts and worked on Functional Specifications till first sign-off.
  • Prepared Technical Specifications.
  • Designed the common framework using VB.NET Created user/custom Win forms controls.
  • Performed event handling in .NET.
  • Developing reusable VB.NET components that can be reused by the organization across applications
  • Performed code reviews to implement performance and coding conventions guidelines used by Microsoft.
  • Completed database modeling, designing and development using Erwin and wrote Stored Procedures in T-SQL.

Technologies Used: VB.NET, MS Insight, SQL Server 2005, Visual Studio 2005, IIS 6.0, Visual Source Safe, Smart Client, ETL.

Confidential , WA

Senior Database Developer

Responsibilities:

  • Gathered Requirements from functional experts and worked on Functional Specifications till first sign-off.
  • Completed estimations of the Quarterly release (QR) for the launch preparation of TSP/PSP.
  • LOC estimates and Task/resource wise schedule for the entire QR has been created.
  • Load balance of task for each resource has been done.
  • Prepared Technical Specifications for three Change Request (CR) and reviewed the same for other four.
  • Designed the common framework using VB.NET. Created user/custom ASP.Net controls.
  • Performed event handling in .NET using VB.NET delegates.
  • Developing reusable VB.NET components that can be reused by the organization across applications
  • Used ASP.Net Web Server controls like Data Grid, Repeater to display the records in Multicolumn grid. Customized the data grid column by implementing Hyperlink Column to pass multiple queries to new page
  • Completed all the QR’s successfully in a role of module lead.
  • Performed code reviews to implement performance and coding conventions guidelines used by Microsoft.
  • Completed database modeling, designing and development using Erwin and wrote Stored Procedures in T-SQL.
  • Worked closely with Microsoft Security specialist to overcome security vulnerabilities and successfully completed Code Acceptance by Microsoft.
  • Extensively worked on integration with other Microsoft systems like Changepoint, RPM and SAAM.

Technologies Used: VB.NET, Win forms, MS Insight, SQL Server 2005/2000, Visual Studio 2005/2003, IIS 6.0, Source Depot, SharePoint Portal Server, Product Studio, Changepoint, RPM, SAAM, .Net Remoting.

Confidential, RA

Resposibilities:

  • Designed Data warehouse model, database objects Packages, Stored Procedures, Triggers and Functions using PL/SQL.
  • Performed event handling in .NET.
  • Developing reusable VB.NET components that can be reused by the organization across applications
  • Designed the system common framework and multiple user and custom ASP.NET controls.
  • Used ASP.Net Web Server controls like Data Grid, Repeater to display the records in Multicolumn grid. Customized the data grid column by implementing Hyperlink Column to pass multiple queries to new page
  • Was involved in Performance Analysis and Tuning.
  • Completed the tasks of developing reports with Unit Testing.
  • Developed the report rendering process and designed reports with Excel 2003.
  • Uploaded the developed reports to MSInsight tool to used access the reports.
  • Generated MDX code to improve performance of the reports.
  • Tried Reporting services as an option to performance of the reports.

Technologies Used: ASP .NET, MS Insight, VB.NET, SQL Server 2000, Visual Studio 2003, IIS 6.0, Source Depot, Product Studio, Changepoint, RPM, SIR, .Net Remoting.

Confidential , India

Database Developer

Resposibilities:
  • Kick started the project right from working on requirement gathering from client.
  • Performed event handling in .NET.
  • Developing reusable VB.NET components that can be reused by the organization across applications
  • Designed the system common framework and multiple user and custom ASP.Net controls.
  • Designed database schema to support new functionalities. Coded very complex SQL queries and Stored Procedures.
  • Designed and coded the data access block using ADO.Net to communicate to database from business layer.
  • Designed the reporting mechanism to render the reports as PDF documents and completed multiple reports using Crystal Reports 9.0.
  • Completed web page development with Unit Testing.
  • Lead the team for technical design and issues faced while development.
  • Completed the packaging and deployment process using Visual Studio.Net.
  • Implemented the SAS module and custom reports required for the Textile Ministry.

Technologies Used: ASP.NET, VB.NET, Crystal Reports 9, HTML, DHTL, Java Script, VB Script, SQL Server 2000, Visual Studio 2003, IIS 6.0, VSS, .Net Remoting.

Confidential , UK

Database Developer

Resposibilities:
  • Designed and developed Windows forms with unit testing.
  • Created composite Grid control using Windows Controls like Grid, Calendar and Drop Down box.
  • Generated reports using Crystal Reports 8.0 for Crystal Report.
  • Was part of UAT phase and designed the complete implementation schedule at client site.
  • Packaged and deployed application using Deployment wizard.

Technologies Used: VB6, SQL Server 7, VSS.

Confidential , India

Database Developer

Resposibilities:
  • Was responsible for designing and coding windows forms.
  • Developed .Net controls to use across the project.
  • Completed the common module which takes care of user management, master data for company, financial years, data lookup tables, employees, suppliers, customers and Item Control.
  • Was responsible for Database programming in conjunction with .Net development.
  • Involved in Database Modeling and Designing.
  • Involved in Coding and designing of Complex Reports using Crystal Reports 6.
  • Implemented multithreaded printing solution.

Technologies Used: VB6, Crystal Reports 6, SQL Server 7

Confidential

Database Developer

Resposibilities:
  • Was responsible for designing and coding unit tested forms.
  • Developed ActiveX controls to use across the project.
  • Generated reports using Crystal Reports 6.
  • Designed and developed database objects i.e. Tables, Views, Triggers and Stored Procedures.
  • Packaged and deployed the application using Installshield.

Technologies Used: Visual Basic 6.0, Crystal Reports 6, COM, Oracle 8i.

Hire Now