SUMMARY

• Seasoned database consultant, with total 7+ years of experience in IT and 5+ years of experience in SQL Server 2000,2005,2008,2008R2,2012
• Experience in Database Analysis, Design, Development, Testing, Implementation and production, support (SDLC) of Client/Server, N - Tier and Web based applications.
• Worked On 2 Full Life cycles(SDLC)
• Expertise in database activities like Data Modeling, Data Staging, Data Mapping.
• Expertise in Database design, Entity Normalization& Database Creation, Maintenance, Monitoring, Performance Tuning and Troubleshooting
• Extensive expertise in Migration, Replication, DTS, and Documentation.
• Worked extensively on Optimization and Tuning for increasing Query and Database performance.
• Expert in using tools like SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Extensive experience in T-SQL (DDL, DML, DCL), Views, Stored Procedures,Cursors and Triggers.
• Experience in data migrating (using tools like DTS, BULK INSERT, BCP, Log Shipping and Replication) between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Experienced on Extraction, Transformation and Loading (ETL) process using DTS, MS-SSIS application tools.
• Expert in Reports Creation using Report Services (MS-SSRS), Crystal Reports, MS ACCESS Report.
• Excellent as a Database developer for web based applications using SQL Server 2000, MS Access, MS FrontPage, Macro Media (Flash, Fireworks, and Dreamweaver), ASP, XML, Java/VB Script, HTML, DHTML, CSS, Erwin, and IIS.
• Highly motivated and a conceptually strong individual with Exceptional Analytical and Design Skills
• Strong Communication & user interaction skills, ability to work as an individual with minimum direction or structure as well as member of a team and has highest level of professionalism, good managerial skills, committed to excellence and willing to learn.

TECHNICAL SKILLS

Operating System: Windows 95/98/ME/NT/2000/2003/XP, 7, 8.

Databases: MS SQL Server 2012, 2008R2, 2008, 2005/2000.

Programming Languages: T-SQL, C, C++, Java, SQL, PL/SQL, Assembly Language, Pascal, FORTRAN, COBOL, HTML, Java Script, XML, HTML, T-SQL, VB &. . NET

Business Tools: Word, Excel, PowerPoint, Access, Visio, Outlook.

Database Tools: SQL Query Analyzer, SQL Profiler, SQL Alerts, SQL Jobs, SQL. Agents, Index Analyzer, SQL Client Utility, SQL Mail

Reporting Tools: Reporting Service (SSRS) 2000/2005

ETL Tools: DTS, SSIS.

MS Tools: Erwin, Visio.

PROFESSIONAL EXPERIENCE

Confidential, MA

SQL Server Developer

Responsibilities:

• Designed and facilitated the Implementation of Data warehouses required by application systems with coding, design and performance tuning.
• Designed Data Warehouse and Data Mart with Star/Snowflake Schema .
• Analyzed existing Stored Procedures & Triggers. And took actions to increase the performance in modularization.
• Modified database structures as directed by developers for test/develop environments and assist.
• Developed and maintained data methodologies, procedures, and standards. Performed Data Impact Analysis. Properly maintained core or control application tables.
• Wrote optimized SQL queries to access source data from RDBMS, and provided reports.
• Use DTS/SSIS and T-SQL stored procedures data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Designed and architected of OLAP cubes to support business reporting and forecasting processes.
• Assisted production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008Analysis Services (SSAS) and Reporting service (SSRSand dimensional databases as well).
• Regular responsibilities for updating staging as rebuild the Dimensions and cubes in Analysis Services and finally to Reporting service.
• Creation of OLAP cubes, DTS script and used these in Integration Services (SSIS).
• Monitor and troubleshoot SQL agent jobs.
• Deployed the databases from old servers to new servers using Replication, based on the business goal.
• Assisted with various ad hoc query requests and Crystal Reports.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Assisted actions on Log Shipping and Clustering.

Environment: SQL Server 2008, 7.0, VSS, VBScript, XHTML, Windows 2000/2003, IIS5.0

Confidential, CT

Database Developer

Responsibilities:

• Participated in gathering user requirement and online system specification.
• Modified and redesigned existing database by adding tables and relationships to support online system in the development database.
• Created triggers for efficient data manipulation, audit trails on policies, vehicles, coverage, violations and achieve tables for future references.
• Wrote stored procedures, views, and functions manipulating XML documents, table’s data for premium rating engines to calculate different premium, generating premium, and quotes.
• Implemented database consistency and security creating roles, users, and triggers views.
• Applied schema change scripts to existing objects to synchronize with changing business rules by adding or enhancing relevant entities/tables, columns etc.
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes again with respect to the I/O.
• Assisted in designing and creating website for the system using XHTML, XML, ADO in designing form, validating inputs, connecting to backend database.
• Performed system testing and debugging, creating test case and reporting the bugs.

Environment: SQL Server 2008, 7.0, VSS, VBScript, XHTML, Windows 2000/2003, IIS5.0

Confidential, Hartford, CT

SQL Developer

Responsibilities:

• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Logical Data Modeling using ER-Win to fit business requirement.
• Physical Implementation of database into SQL Server 2000 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Data migration (import & export/BCP) from Text to SQL Server.
• Configured Replication Server.
• Worked on a Terabytes of Data.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Generating ad-hoc reports using MS-Excel and Crystal Reports.
• Coordinating post-implementation events such as testing.

Environment: SQL Server 2005/2008, ER-Win, T-SQL, Excel, Access, Crystal Reports 9.0 and Windows NT

Confidential, Minneapolis, MN

SQL Server Developer

Responsibilities:

• Actively involved in creation of database, modified tables, triggers, procedures to clean and validate the data about the cable layout, so as to meet the company specifications.
• Data transformation activities using DTS Import/Export for transferring data between different Databases like Oracle, Sybase. Design new DTS Packages as per needs, resolve problems with existing DTS packages etc.
• Incorporating business logic in DTS while converting from Oracle, MS Access and Text to SQL Server. Creating new database/tables to put in the extracted data and rebuilding the relationship.
• Written stored procedures for Automatic Scripting to backup transaction logs, flush/grow/shrink log files, maintain archive of objects and so on
• Ensured constraints and writing triggers to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
• Created different user level groups, and assigned appropriate permission level to the database. This made sure that only the right person with enough authority would be able to see the Customer Information.
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.

Environment: MS SQL Server 2000/2005/2008 , Windows 7/XP, Oracle, Visual Basic 6.0, MS Reporting Services.

Confidential

SQL Developer

Responsibilities:

• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Involved in ER diagrams and mapping the data into database objects.
• Installed and Configured SQL Server 2000 successfully.
• Design of the database and the tables.
• Build table relationships and wrote stored procedure to clean the existing data.
• Coordinated with the front-end developer to put in the business rules. Wrote procedure to check some of the rules at the backend at the time of entering data.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Developed the project using iterative approach.
• Managed database changes based on feedback.

Environment: MS SQL Server 2000/2005/2008 , Windows 7/XP, Oracle, Visual Basic 6.0, MS Reporting Services.