SUMMARY

• Over EIGHT years compound experience in Finance, IT and Banking environments; Over SEVEN years SQL Server database development experience using SQL Server 2008r 2 / 2008 / 2005 / 2000
• Hands - on experience in, managing, monitoring and troubleshooting SQL Server 2000, SQL Server 2005 and SQL Server 2008 and 2008r2. Experience in Database Design and Database Normalization activity with Data Modeling using tools like ERWIN and Microsoft Visio
• Hands on experience with scripting in T-SQL in constructing Tables, Store Procedure, User Define Functions,Cursors, Views, Indexes, Triggers, User Profiles, Data Integrity to implement Business Logic and Data Protection Expert in Query Tuning and Database Maintenance activities including Backup\Restore, Updating Statistics, Re-building and Re-organizing Indexes
• Hands on Experience in ETL (Extracting, Transforming and Loading) development using DTS and SSIS Worked closely with different departments in the design and implementation process for developing, deploying, upgrading, managing, archiving and extracting data for reports using SSRS
• Experience in data mining and analysis, design and construction of data marts, OLAP Cubes, data views and creating data warehouse models using SSAS Experience in creating partition functions, patrician schemas, partition tables and partition views
• Up to par with performance of the Queries and Indexes, scalability, high availability, security and compliance best practice guidelines in database design, performance tuning, implementation, and maintenance in a SQL Server 2008r2 environment using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor and DBCC commands and Dynamic Management Views
• Highly skilled in implementing different types of Replication Models, database mirroring and log shipping. Experienced in Very large database(VLDB) and high transaction volume experience, storage arrays, and fast growth databases
• Experience in generating ad-hoc T-SQL scripts and creating Batch files for development support Experience in migration of data using BCP Utility, Bulk Insert command, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
• Creation of Jobs, Schedules, Alerts using SQL Server Agent, Notifications using SQL Mail and Database Mail and command prompt utility like SQLCMD, ISQL, OSQL
• Experience in implementing Database security integrity controls (logins/roles), Requirements Analysis, Application Support and Development, Testing, Implementation and Deployments
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Implemented a well-planned backup and restore strategy protects databases against data loss due to damage caused by a variety of failures.
• Worked with Popular Third Party monitoring solutions like NETIQ Appmanager, Idera Diagnostic Manager, Spotlight and Lumigent Log Explorer, Red gate tools, Apex Tools.
• Flexible, enthusiastic, strong troubleshooter, project oriented team player with solid communication skills combined with self-motivation, initiative, the ability to think outside the box and leadership skills to develop creative solution for challenging client needs.
• Microsoft SQL Server 2005 - Implementation and Maintenance

TECHNICAL SKILLS:

DBMS & RDBMS: Ms SQL Server 2008 and 2008r2/ 2005 /2000, Oracle 8i, Ms Access 2000.

Analysis and OLAP Tools: SSAS,MS OLAP Services Manager.

Backup/Restore Tools: Quest litespeed, Idera SQLsafe, Veritas backup solution.

Log Tools: Lumigent Log Explorer, Apex SQLlog, Apex SQLrecover, Red gate SQLlog rescue.

ETL Tools: SSIS,DTS,Informatica.

Reporting Tools: SSRS, Crystal Reports, Microsoft Reporting services 2005 / 2000.

Data Modeling Tools: ERWIN, Microsoft Visio.

Performance Tools: NetIQ SQL server suite, Quest Spotlight, Idera Diagnostic Manager.

Schedulers: Enterprice Autosys,Cisco Tidal,Vinzant

Other Tools: Jira,Confluence,Eclipse,SVN, DTSXchange, BPA, BSA.

Hardware: Compaq Proliants 8000, 6500, 6000, 5000 Servers.

Operating Systems: Windows 7, Windows 2000/2003 Advanced Server, Windows Exchange Server 2003, Windows NT 4.0/3.5, Windows9.x, Windows XP, UNIX, Linux.

Language: T-SQL, Turbo C (4.0), C++, PL/SQL, C#, Java

Client Software: VB 6.0, VB.Net.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte NC

SQL Server Developer/BI Developer

Responsibilities:

• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures in T-SQL.
• Installing SQL Server 2008 R2/2005 on Windows Server 2008 R2/2003 on Clustered environments (Active/Active and Active/Passive) and on standalone also installing services packs and aggregate updates.
• Responsible for Backup and restoring databases from Prod to Dev/UAT/SIT environments and scripting out all the users, their permissions, and role memberships to fulfill application team requests.
• SQL query tuning, optimization, DB schema design, analysis Troubleshoot and supported applications
• Migrated SQL Server 2000 DTS packages to SQL Server 2005 SSIS Packages and have deployed packages on different servers by configuring it.
• Developed Complex Reports Using Drill down, Drillthrough Groupby reports and sub-reports based on client/business requirements and scheduled for distribution to senior managers/Groups.
• Experience in Code Optimization and Improving Efficiency in Databases including Re-Indexing, Updating Statistics, Recompiling Stored Procedures and performing other Maintenance Tasks.
• Upgraded the existing database to SQL Server 2008/2005 from SQL Server 2005/2000.
• Experience in migration of large value Data from Excel, Flat file to MS SQL Server by using DTS Import/Export wizard, BCP (Bulk Copy Program), DTS (Data Transformation Services) and SSIS Packages into SQL Server.
• Supported fixed income trading systems including coding, testing, debugging, documenting and project management
• Worked closely with BSC Team, Fix Income management Group, applications development staff, and users on database solutions to complex financial business problems.
• Support and actively involved in bulk load data, ETL process and validation for financial institution like Bloomberg, Barclays, Merrill lynch, Axiom,JP Morgan, Credit suisse,FIA,Clearwater,3c Fund, Montgomery, Everstage(APX,Satuit,Odyssey,APX Restates), Yield Book, Bond Edge, Perform etc..
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources
• Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, and Index Tuning Wizard, Spotlight to achieve better performance, accessibility and efficiency
• Upgrading/Migrating and Consolidating databases from different DBMS and versions to current version of SQL Server
• Rebuild the indexes at regular intervals for better performance also Run DBCC statements to check physical and logical consistency of the database.

Environment: SQL Server Management Studio 2008r2,2008,2005,2000, T-SQL, Windows 2003, DTS, SSIS, SSRS, Tidal, Autosys, jira, Confluence, Eclipse

Confidential,NY

SQL Server Developer/BI Developer

Responsibilities:

• Done initial Analysis and Planning for database structure under guidance of Data Architect while creating new database based on old system Developed ER diagrams (Physical and Logical using ERWIN) and mapping the data into database objects.
• Actively involved in Normalization (3NF) & Demoralization of database. Involved in Database creation; database tuning, performance planning, backup planning and database administration.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Capacity planning in estimating and sizing of tables. Materialized views, dimensions and stored outlines for optimal performance.
• Wrote Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis Designed and implemented Dimensions and Measures according to business requirement.
• Migrated data from text files and Excel spreadsheets to SQL Server databases using Integration Services (SSIS). Involved ETL process of the company to provide better business model and structure of database system in SSIS.
• Created and scheduled SSIS packages which monitors the jobs and sends the notification when the job fails. write complex formulas and to query the database to fulfill different types of business requirement and customer requirement
• Schedule and Deploy schema changes, data conversion, data fixes and data movement through packages using SSIS
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance(Used MDX Queries)
• Developed several detail and summary reports including Drill down, Drillthrough Groupby reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Supporting to the .Net team with expert needs of creating and maintained company wide reporting structure in SSRS Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and other evens using Performance Monitor and SQL Profiler.
• Configured Transaction Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server. Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created SSIS packages to automate database back up, update statistics, re-build the index as well as create error log for every event during data load.
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Administration, Backup & Restore, Procedures, Database Security, SQL Database Development and Access database upgrades across the enterprise.

Environment: SQL Server Management Studio 2008r2, T-SQL, Windows 2003, SQL Server 2008, SSIS, SSRS, SSAS.

Confidential, NY

SQL Server Developer

Responsibilities:

• Actively involved in Migration of SQL Server and related applications from SQL Server 2005 to SQL Server 2008. Migrated Stored Procedures from 2005 to SQL Server 2008 to refer to Dynamic Management Views
• Wrote complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements. Involved in initial analysis of existing database and Planning for new database structure.
• Designed Database Structure, generated Logical and Physical Data Models using Erwin also did Capacity Planning to estimate the required Disk Space. Designing and developing the Stored Procedures to process the rules coded in the business logic table
• Created Triggers for Auditing the Data and System changes and also prevent Ad-hoc and restricted changes to the system. Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Technical Requirements.
• Create complex scripts to do checking and massaging of legacy data in staging area of SSIS package. Good experience and knowledge of working with Report Manager, Report Builder, Reporting Security and Reporting Services Configuration manager using Crystal Reports
• Creation and Deployment of Ad-hoc and Customized Reports to satisfy business and managerial needs Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS Created SSIS Packages to Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly
• Experienced in SSRS for report generation using XML and Excel spreadsheet. Transferred the MS Excel Sheet Reports into SSRS based reports by migrating the data using SSIS packages and then use views and tables and stored procedures to develop new reports.
• Deployed the SSIS Packages to the MSDB as well as File System depending on the requirements Monitor and fine tuned the poorly performing Queries and Stored Procedures by implementing the Coding and Design Standards.
• Monitored the Server as well Database activities using various tools like SQL Profiler, Performance Monitor and Dynamic Management Views. Monitored Indexes, File Growths and analyzed Blocking & Locking issues to remove the performance bottlenecks.
• Design OLAP Cubes and Data Mart using SSAS. Improved Database and SQL Server Security by creating appropriate application roles and user-defined roles

Environment: SQL Server 2008,SQL Server 2005, SSIS, SSRS ER-Win, windows 2003 platform, T-SQL, Excel, Access, Crystal Reports 9.0 and Windows NT.

Confidential, MD

SQL Server Administrator/Developer

Responsibilities:

• Supported business functions through use of internally-developed and third-party software solutions. Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and also Partitioned data onto multiple Files and File groups
• Developed complex SQL queries, stored procedures, and SSIS packages Leading team member of database developers in the extraction, transformation, and load process from of a different file base system to SQL base such as Access, Oracle, Excel, and flat files
• The reporting was created with SSRS and utilized the cube and MDX to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports
• Create SSIS Packages to move the data from MySQL into SQL database. Before loading the data into the server, using various tasks, transformations and variables, made dynamic SSIS packages which did data scrubbing, including data validation checks.
• Defined and developed a data migration strategy between different products and platforms Data conversion from Text File into SQL Server Table using SSIS.
• Hand on Data Integrity Validation Designed and implemented data access stored procedures and triggers for automating tasks. Created scripts and SQL jobs to facilitate database backup and recovery, server and data processing monitoring and alerting.
• Worked on optimization and tuning of SQL queries and indexes Assisted in the application development, debugging, configuration, and optimization from database perspective Performed database design by analyzing business requirements.
• Reviewed applications and database design for compliance with best practices standards assisted in troubleshooting and resolution of database issues.

Environment: SQL Server 2008 Enterprise, Windows Enterprise Server 2003, Microsoft Visio, SQL Profiler, Query Analyzer, SSIS,SSRS, SQL Lite.

Confidential

SQL Server Developer

Responsibilities:

• Created Stored Procedures, User-Defined Functions, Ad-hoc Scripts, complex views, Indexes and Cursors on Development and Test servers for pre-deployment testing in SQL Server 2005. Created Scripts to monitor Backups, Drive Space, Log Size, Database Size and Service Status monitoring.
• Implemented Transactional Replication to create and maintain reporting server Transformed data using DTS packages, BCP utility and Bulk Insert statement as and when necessary.
• Ensured Server & Application performance tuning and optimization Creation and Management of Jobs, Schedules and Sending Alerts using SQL Mail Gained expertise in Security Issues by creating Users and granting Permissions on various Objects.
• Performed all aspects of database administration, including data modeling, backups and recovery Monitored server critical issues including Response Delay, Locking/Blocking and Server Downtime Improved Performance of databases by analyzing Indexes, Fill Factor and Fragmentation issues.

Environment: MS SQL Server 2005 Enterprise Manager, Windows 2000 server,DTS.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Successfully upgraded from SQL Server 2000 to SQL Server 2005 Creation of Triggers to perform Data validations as well as Server level and Database level monitoring and Alert the users with the field status changes.
• Created complex Stored Procedures and Cursors to support applications. Prepared Estimates for Database Files and Table size growth.
• Generated Reports for the day-to-day as well as weekly/monthly purposes. Created Distributed views Created complex Stored Procedures, Indexes, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Maintain Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server Derived and documented the root cause analysis for issues in production
• Prepared a Disaster Recovery Plan for the database in a scenario wherein the Master Database File is lost/corrupted Successfully loaded data from an Oracle file, Flat File(.txt), Excel file (.xls) into a SQL Server database Table using DTS
• Created various reports using Crystal Reports after performing Data Analysis on the various Views of Business Intelligence Created complex packages using DTS for moving data from different data sources

Environment: SQL Server 2005, SQL Server 2000, Windows 2000 Server Platform, Crystal Reports, DTS.