BI and DA Professional
Microsoft
Total years of experience :21 years, 11 Months
• Working with ITRD (Information technology Research and Development) Group
• Recognized as Most Valuable player and awarded Employee of the year for outstanding performance
• Spearheading efforts across leading a 25 member team, understanding and analyzing the requirements, providing resolution to queries. Mentor Developers
• Software design and development using Microsoft technologies and SharePoint application development and maintenance. MIS reporting solutions implemented on SharePoint technologies
• Working knowledge of ERP solutions
• Implemented DR sites for database sites between Santa Ana and Dallas data centers.
• Implemented database and server architecture design for software solutions.
• Handling SQL Programming, query optimization, performance tuning, SQL Server Profiler, Execution Plan & Performance Monitor
• Excellent backend skills in creating database objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, user defined data types and functions
• Experience in installation, upgrade and configuration of MS SQL Server and databases in clustered environments
• Creating and maintaining various databases on production/development servers and provide 24 x7 support
• Experience with HA/DR SAN Production environment - AlwaysOn, Mirrored Cluster, Log Shipping & Replication.
• Scheduled database backups and restored the Database from DR.
• Experience in creating packages, Scheduling Jobs, Sending Alerts using Database Mail
• Experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Experience in MDS (Master Data Services) and DQS (Data Quality Services).
• Extensive experience in Capacity planning, Performance Tuning, Disaster Recovery, Troubles shooting, backup and restore procedures
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Periodically hold review meetings to monitor progress of project as per schedule / budget and ensuring timely completion and delivery of the project to the client
• Managing smooth implementation and testing of the application at client location
• Coordinating with team members for requirement mapping, system design, integration, implementation etc
• Presenting periodic Dashboard reports on the current program, project road map and status reports.
• Tracked software customization, defects and issues via the use of SDLC.
• Played Database architect role and DBA in most of the R&D projects.
• Worked with GE-GDC department of GE - AVIATION business unit
• Involved in requirement analysis, database design, coding, testing, implementation and maintenance of several software applications.
• Handled various technical aspects like software design, coding of modules, monitoring critical paths & taking appropriate actions
• Participated in smooth implementation of the project and extending post-implementation, application maintenance and technical support. Offshore In charge of a team of 4 members.
• Member of technical training team.
• Part of TMS Image™ (Transaction Management System with Image Processing) for Citi Bank team
• Gained exposure in end-to-end development of database. Involved in preparing Project Design Document (Low Level Design) and UTC
• Worked on successful enhancements and received considerable admiration for the coding standards adopted.
• Played a role of database developer and report writer
• Involved in various Projects undertaken by the organization performing different functions including Designing & Development.
• Played both application and database developer role.