Senior Software Engineer 6+ Years Exp in IT

• 6+ years of Experience in MS SQL Server/MSBI Development, T-SQL, Oracle PLSQL, Crystal Report Development and activities and Software Development and Application Maintenance and Supporting

• Working experience in SQL Server 2008 R2/2012/2014/2016, Oracle 9i/10g/11g, Ms Access Strong SQL knowledge and ability to write most complex queries.

• Working experience in SSRS (Reporting Services), MIS Report, Crystal Report

• Proficient in performing data analysis, querying data bases, and utilizing SQL query tools Creating end user training material and operational documentation.

• Working experience in (C,C++,VB6.0.,VBA/Macros and Ms Access/Excel and VB Script, JavaScript, HTML5,VB.Net, XML)

• Working Experience in VB6.0.,VBA/Macros Ms Access/Excel (User defined functions, Automation Macros Advanced Excel Function and written code both procedural and class oriented, bug fixing, Error Handling, Process Validation Forms and Reports)

• Unit testing of modules and creation of unit test document and Data verification with form Validations and designed tables and queries for information updates.

• Excellent knowledge of database design structures and requirement analysis. Principles, theories and practices, Performance Tuned SQL queries and performed code debugging using SQL Loader and TOAD 9.1.

• Writing Stored Procedures, Triggers, Functions, Views, Indexes, Query optimization

• Creation, Backup, and Maintenance of Database and Import Bulk Data from Text/Excel file to MS-Access and SQL Server/ TOAD.9.1

• Developed several reports using crystal reports as per the client requirements.

• Parameterized reports, Drill down, Charts and Graphs and Custom functions.

• Experience of working in the complete Software Development Life Cycle involving development, debugging, Automation report process, maintenance, Unit Testing, and Performance Testing/Tuning and documentation, deployment of projects.

Work Terms

Roles and Responsibilities Program enhancement process, Unit Test and Code/Report
Development and bug fixing and Application supporting
Identified and solved major critical problems in SQL and Performance tuning Writing stored procedures and cursors and Trigger.