Summary:

• Over 10 years of experience in IT industry, involved in the analysis, design, development and implementation of various Database driven .Net projects as a SQL Server/Oracle Developer/DBA
• Extensive expertise in Architecting databases and ER Data modeling tools such as ERStudio, MS Visio, Erwin, SQL Server Database Diagrams
• Expertise in MS SQL Server 2000/2005/2008 Installation, Configuration, Design physical/ logical , Production and Application Support, Performance Tuning/ Optimization, User/Security Administration, Backup/Recovery, Data/Network Administration and Maintenance, Linked servers
• Proficient in T-SQL programming, coding SQL Queries, Stored Procedures, SQL XML, Views, Triggers, Cursors, user defined functions, Distributed queries
• Extensive knowledge in Tuning T-SQL and PL/SQL queries improving the performance of the Database
• Experience in Batch Processes, SSIS, DTS, BCP, Import, Export, DBCC commands, Backup Restore, Database monitoring tools and Application support.
• Experience in SQL Server concepts like online indexing, Data partitioning, Database mirroring, DB Snapshot, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA, SQLCMD and dedicated admin connection
• Expertise in using SQL Server profiler and trace, knowledge of XML support in SQL server
• SQL Server Business Intelligence Development Studio expertise to create SSRS reports, SSIS packages and SSAS projects
• Experience in software installations, Database Migrations and Database Capacity Planning
• Strong exposure in creating ad-hoc/drill down/parameterized reports using SSRS 2005 and Crystal Reports
• Extensively worked in SSAS to create Cubes and Data Mining Queries using MDX
• Exposure to SQL Server High availability technologies such as Failover Clustering, Mirroring, Log shipping, Replication
• Developed and implemented SSAS Cubes with calculations, Aggregations, Hierarchies for Business intelligence BI reporting.
• Exposure in handling IBM DB2 UDB

• Expertise in debugging, troubleshooting converting .net and java codes

• Experience in Web deployment on IIS server using Visual Studio 2005, ASP.Net C
• Experience in programming with .NET, C , ASP.NET, ADO.NET, XML and Web Services

TECHNICAL SKILLS:

Programming Languages: C , Java, SQL, T-SQL, PL/SQL, VB.net

Scripting Languages: Java Script, VB Script

Databases Data Access: SQL Server 2008/2005/2000, Oracle8i-9i-10g, IBM DB2,

Sybase IQ Adaptive server 12.5

Packages/Tools: SSIS, SSRS, SSAS, DTS, VS.NET, Crystal Reports, Visual Basic 6.0, Microsoft Visio, MS Project, InstallShield, Windows SharePoint Services WSS 3.0 , IBM iSeries Navigator, AQT, MS Interdev, MS VSTS 2008

Version Control: Visual SourceSafe VSS , Team Foundation Server TFS

.NET Technologies: ASP.NET, ADO.NET, XML, HTML, WSDL, SOAP, XSL, WCF, Windows Services, Web Services

Java Technologies: Applets, Servlets, JSP, RMI, JDBC

Operating Systems: Windows NT/2000/2003/2008, UNIX

Application Web Servers: IIS, Tomcat

Professional Experience:

Confidential

Sr. SQL Server Developer/DBA

Responsibilities:

• Involved in designing the new SQL SERVER 2012 tables
• Created new tables and stored procedures in T-SQL
• Refactored and fine-tuned the queries and stored procedures in T-SQL
• Used TFS for version control
• Created release database scripts
• SSIS for EDI generation
• Coordinated with offshore team for performance tuning
• Worked with SQL Server 2012 CDC functionalities.

Environment:

Windows 7, 2008 Enterprise, SQL Server 2012, C , VSTS 2012, TFS, SSIS

Confidential

Sr. SQL Server Developer/DBA

Responsibilities:

• Analysis of code from previous version and current version
• Involved in designing the new SQL SERVER 2008 tables
• Refactored and fine-tuned the queries and stored procedures in T-SQL
• Created new tables and stored procedures in T-SQL
• Analyzed C code using VSTS 2008
• Used TFS for version control
• Created release database scripts
• Worked with VMware Lab Manager for testing and troubleshooting
• Generated modified reports in SSRS using BIDS Business Intelligence Development Studio
• SSIS for data purging

Environment:

Windows 7, 2008 Enterprise, SQL Server 2008, C , SSRS, VSTS 2008, TFS, VMware Lab Manager, SSIS

Confidential

Sr. SQL Server Developer/DBA

Responsibilities:

• Generated reports in SSRS using BIDS Business Intelligence Development Studio
• Rebuilding indexes with different fill factors and update statistics manually
• Created baseline and sampling intervals in the perfmon considering threshold values of the counters
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis
• Refactored and fine tuned the queries and stored procedures in tsql
• Created new tables, stored procedures and triggers in T-SQL
• Utilized the new features of 2008 like MERGE STATEMENT and Compressed Backups.
• Involved in designing the new SQL SERVER 2008 Database
• Performed backup and restoration tasks
• Created release database scripts
• Created and configured SSIS packages for updating reporting databases
• Modified the existing SSRS reports to reflect the data from the new database

Environment:

Windows 2008 Datacenter, SQL Server 2008, C , SSIS, SSRS, VISUAL STUDIO, VB.NET, TFS

Confidential

Sr. SQL Server Developer/DBA

Responsibilities:

• Involved in analyzing the performance issues caused in SQL SERVER
• Involved in configuring and administering SAP Business Objects 2008 server
• Configured AD authentication for Crystal Reports 2008 server
• Created migration scripts from existing application to the new application
• Created and configured SSIS packages for updating reporting databases
• Designed and generated reports in Crystal Reports 2008
• Troubleshooted database application problems
• Performed database maintenance tasks such as fixing corruption issues in production database
• Interacted with the operations team to convert the business requirements into reports
• Performed backup and restoration tasks.

Environment:

Windows 2003 Advance Server, SQL Server 2008, ASP.NET, ADO.NET, XML, SSIS, SSRS, JSP, SAP BO Enterprise XI Crystal Reports 2008 server

Confidential

Sr. SQL Server Developer/DBA

Responsibilities:

• Involved in analyzing the performance issues caused due to Linked Server and Sybase IQ Adaptive Server.

• Involved in developing the front end using VB and VBA
• Involved in analyzing the functional specifications and converting it into business logic.
• Maintained several instances of SQL server 2005.
• Installed and maintained active passive SQL 2005 clusters.
• Troubleshooted database application problems.
• Ran various SQL scripts to update the production databases.
• Responsible for monitoring and tuning MS SQL server performance and ensuring data integrity.
• Created SSIS Packages Data Loading and scheduled them.
• Performed backup and restoration tasks.

• Identifying and working with parameters for parameterized reports in SSRS 2005.

Environment:

SQL Server 2005, Sybase IQ Adaptive Server 12.5, Oracle 10g, SSIS, SSRS, SSAS, Windows SharePoint Services WSS 3.0 , VBA, Microsoft Excel.

Confidential

Sr. Oracle Developer/DBA

Responsibilities:

• Performed Database Design, Coding, and Reporting.
• Built MIS reports using tools such as Crystal Reports.
• Implemented the business rules by writing Oracle PL/SQL Functions and Procedures.

• Worked with the users to identify the business requirements and integrated them into the Oracle Applications.
• Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, procedures and packages.
• Written complex SQLs using joins, sub queries and correlated sub queries.

• Involved in the design, development, testing and maintenance of the application.

Environment:

Windows 2000 Advance Server, SQL Server 2000, Oracle 10g, Visual Basic 6, Visual FoxPro, Crystal Report 8/9, Visio 2003

Confidential

Oracle Developer/DBA

Responsibilities:

• Implementation of Software, Performance Tuning, Data Migration and Backup.
• Migrated Data from legacy system to ERP system.
• Worked for ERP Created Finance Related Reports and Documents i.e. Profit Loss, Trial Balance, Balance Sheet, Bank Reconciliation etc , MIS Reports.
• Developed custom reports, PLSQL procedures, functions and packages for Oracle Applications production instance.
• Assisted in business analysis, application setup, data conversion, custom interfacing, and reporting.
• Implemented data extraction/Transformation/Cleaning/Loading from flat files has been using SQL Loader and PL/SQL.
• Utilized programmatic structures such as PL/SQL block, tables, triggers, and stored procedures.

Environment:

Windows 2000 Advance Server, Linux, Oracle 9i, Visual Basic 6, Developer 2000 Report , Visual FoxPro, Crystal Report 8/9, Visio 2003, Pro C, Toad, Power Builder 7, Remote Desktop, Oracle Enterprise Manager, Datastage

Confidential

MS SQL Server Developer/DBA

Responsibilities:

• Installation, configuration, and maintenance of MS SQL Server 2000.
• Created managed the Database Users, Login Ids and Security.
• Involved in Logical and physical Data Modeling
• Created database objects like tables, views, indexes etc.
• Checked Performance Tuning, Indexing, Query Optimization.
• Used database consistency checks using DBCC utilities.
• Developed web pages using asp.net
• Wrote DTS scripts for data transfer and data loading
• Created DTS packages for the extracting, transforming and loading the data
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Implemented distributed queries for Linked Servers.

Environment:

MS SQL Server 2000 and Windows NT/XP, ASP, IIS 5.0, VB 6.0, VB, JavaScript, MS Access, Windows 2000 Server

Confidential

MS SQL Server Developer/DBA

Responsibilities:

• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Installed and Configure SQL Server 2000 successfully.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages Data Loading .
• Login and User Management: Adding logins, roles, groups to the Windows NT and MS SQL Server and maintaining proper security procedures.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Involved in ER diagrams Physical and Logical using ERWIN, Data Modeling and mapping the data into database objects.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Developed a data layer using ADO.NET.
• Scrum methodology Agile development methodology was followed for feature enhancement of the project
• Designed and implemented core architectural components.
• Prepared test plans and did unit testing of the programs using NUnit.
• Gathered and documented requirements specifications using UML use-case methodology.

Environment:

SQL Server 2000, ErWin, ASP.NET, ADO.NET, XML, UML, Web Services, JavaScript

Confidential

MS SQL Server Developer/DBA

Responsibilities:

• Created logical schema Data Modeling using ERWIN 4.1.
• Created the physical databases.
• Installed and Configured SQL Server 2000 successfully.
• Login and User Management: Adding logins, roles, groups to the Windows NT and MS SQL Server and maintaining proper security procedures.
• Database creation database tuning, performance planning, backup planning and database administration.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Created tables, views and indexes. Wrote Triggers and Stored Procedures.
• Generated XML Files using MS SQL Server 2000
• Supported in building and maintaining Data marts, Fact Tables, Dimensions and joined them to extract meaningful data. Supported in creating Cubes.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• As a Database Developer interacted with the front-end developers at various phases of the project, since we were following Scrum methodology Agile development methodology
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Monitoring Performance during Beta Testing phase of the application.
• Used Crystal Reports to generate different types of ad-hoc reports.
• Developed data layer using ADO.NET.

Environment:

SQL Server 2000, ERWIN 4.1, MS-Access, VB 6.0, ASP.NET, ADO.NET, XML, Crystal Reports, Windows 2000, Visio, Oracle 8i, Java, Tomcat, VC , SOAP, Installshield, XML, Wise

Confidential

MS SQL Server Developer/DBA

Responsibilities:

• Gathered user requirements.
• Designed database objects, normalize data base objects.
• Developed stored procedures, functions and triggers.
• Created DTS package to export and import data from SQL Server to text files.
• Created reports as per the requirement needs using Crystal reports.
• Created views as per design needs.
• Supported the front-end application developers with their queries.
• Tuned procedure and database objects.

Environment:

MS SQL Server 2000, MS Access, SQL Query Analyzer, Enterprise Manager, DTS, SQL Developer, Visual Basic 6.0, Crystal Reports 8.5

Confidential

SQL Server Developer/DBA

Responsibilities:

• Logical and Physical design of database for projects on basis of user requirements using ERWIN.
• Implemented various Stored procedures for the purpose of application development
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Performed Database backups operating system, flat file backups export/import .
• Checked Performance Tuning, Indexing, Query Optimization.
• Developed standards and guidelines to maintain develop and administer the SQL Server database.
• Worked closely with developers, end users and Administrator in designing database and creating.
• Successfully loaded data from an EXCEL, Access into a SQL Server database Table.

Environment:

SQL Server 2000, ERWIN, MS-Access, ASP.NET, C , ADO.NET, XML, Windows 2000