SUMMARY OF QUALIFICATIONS:

• Over 6 years of experience working with SQL, PL/SQL,SSRS, SSAS and SSIS.
• Experience as .net developer over VB.NET, ASP.NET, C , .NET Framework with back ends Oracle and SQL Server.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL.
• Oracle Certified Associate.
• Strong knowledge and experience in the practical use of the agile methodology in the software development lifecycle.
• Experience in Oracle Supplied packages, Dynamic SQL, Records and PL/SQL tables.
• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions. Expertise with DDL and DML statements, RDBMS's, data dictionaries and normal forms.
• Experienced in developing stored packages, procedures, functions, Partitions, triggers, and views.
• Export, transform and loading ETL data using SQL Server Business Intelligence Development Studio from a variety of data sources SQL, Oracle, Excel, Access, flat files .
• Excellent knowledge and concepts in Object Oriented Programming OOP Concepts.
• Well versed with complete Software Development Life Cycle SDLC process including Designing, Developing, Testing and Implementation.
• Implemented ADO.Net data access techniques i.e. SQL Connection Objects, SQL Command Objects, Dataset Objects, Data Reader Objects and Data Adapter Objects using Data Grid, Data List and Repeater controls.
• Expert in querying databases using SQL, PL/SQL, writing stored procedures, views, database triggers, cursors, transaction management, design and modeling.
• Perform detailed data exploration.
• Good team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE:

Confidential

Database Programmer SQL Developer

• Design the Requirements Document for Smart Meter Database System. Develop the various functional modules of hardware and firmware versions of Smart Meters in SQL Server 2008.
• Design the schema and database in SQL Server 2008 for the functionality of Smart Grid Technology.
• Developed a dashboard to visualize for overall consumption of smart meter grid meters.
• Developed a windows application using .Net framework 4.0 with MS SQL Server 2008 back end for meter test devices.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Created Data flow diagram, Entity relationship diagram using Microsoft Visio Project.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using Sybase 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.
• Physical design and implementation SQL Server databases.
• MS SQL Server database administration, including configure Scheduled Tasks for regular Database Backup and Maintenance Activities, create and modify tables, stored procedures, various clustered and non-clustered indexes, triggers, check constraints and functions.
• Create triggers to keep track of changes to the fields of tables when changes are made.
• Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures. Configure and maintain Report Manager and Report Server for SSRS.
• Access and Update to the database with the connection and command objects and fetching and manipulation of the data was done with ADO.Net objects as data reader, data set and data adapter.
• Worked intensely on the User Interface.
• Developed SRS and functional specification documents.
• Used various visual studio's controls like List, data grid view etc.
• Involved in customizing, testing, debugging, application evaluation and implementation.
• Developed functions to generate reports with different criteria using Microsoft report viewer.

Environment: MS SQL Server, C , Visual Studio, Microsoft report viewer

Confidential

Database Analyst BI Developer

• Successfully, Implemented ETL Packages to load Data in Data warehouse and optimized OLTP database.
• Actively involved in the development/deployment of ETL packages in MSSQL 2012/2008 to load OLTP Data.
• Involved in formulated queries in T-SQL in meeting reporting needs.
• Formulate Implementation Design/technical document, and mapping document base on business logic.
• Benefitted handling brainstorming discussions design, development process and deployment of SSIS projects.
• Integrated SSRS reports to SharePoint portal using Report Viewer Web Part.
• Supporting multiple projects, assigning the tasks to team and being responsible for coordinating with offshore.

Confidential

.NET Developer

• Spare management system for Automobile Industry Spare Module of Automobile Industry's ERP system In VB.NET 3.5 framework Backend: SQL 2005
• Developed ERP system module windows-based .NET application for automobile industry.
• Served as developer of user interface design, database, coder and tester of system.
• Worked with Oracle databases and designed stored procedures.
• Implemented error handling using exception blocks.
• Involved in customizing List View using Data Template, Triggers and Styles to Display data in Data grid style.
• Completed project using .NETFramework3.5, VB.NET2008, VB, SQL Server 2008, MS Visio and MS Office.