SUMMARY

Over 5+ years of experience in SQL server database development.

• Over 5+ years of experience in generating reports using SSRS.
• Experience data warehousing for building various software applications with emphasis on building data warehouse/data marts for DSS models.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Strong experience in supporting large volume DB2 Databases.
• Experience with SQL Server 2000 and MS SQL Server 2005 and worked extensively on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
• Strong in db2 udb physical design.
• Experience in Implementation and supported of VLDB.
• Setup and maintained db2 udb data replication.
• Expertise and Interest include Administration, Database Design, Performance Analysis and Production Support for Large (VLDB) and Complex Databases.
• Experience in developing the applications using T-SQL programming.
• Migrating SQL Server 2000 databases to SQL Server 2005.
• Hands on experience with SQL cluster real-time open source transactional database designed for fast, always-on access to data under high throughput conditions.
• Developed financial data reconciliation tools in MS Access and Excel 2003 VBA as part of a database migration project.
• Maintaining databases in 24X7 production environment.
• Hands on experience on splitting data across different geographical location using the MySQL cluster carrier grade edition.
• Exposure with Data warehousing tools like Informatica power center and Ab-initio.
• Extensive experience in installation and configuration of MS SQL Server 7.0/2000/2005 versions and SQL SERVER 2005 cluster
• Experience in data warehouse development environment using Microsoft DTS, SSIS, SSAS.
• Extensively worked on 32bit and 64 bit clustered and standalone server environments.
• Proficient on providing the high data availability without additional infrastructure using the MySQL cluster architecture.
• Expertise in planning and implementing MySQL server security and database permissions.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Hands on experience in trouble shooting database issues.
• Experience in writing and debugging stored procedures and triggers.
• Experience administering Apache and MySQL servers.
• Experience in implementing different types of Replication models like Snapshot and transactional.
• Specific hands on experience include Administering large and complex Databases, Normalization, Replication, Log shipping, Full-text indexing.
• Extensively used SQL Server tools like Query Analyzer, Enterprise manager, profiler and management studio
• Hot and Cold Backups, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, Stored Procedures, Functions and Cursors and Triggers etc.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Experience in Batch processes, SSIS, DTS, BCP, Import, Export, Backup, Database Monitoring tools and Application support.
• Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Good working experience on UNIX operating system with different flavors like Sun Solaris and Fedora.
• Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services and MDX technology of the analysis services.
• Installed, customized and maintained Lawson Software application modules (G/L, A/P, Payroll), and CommercialWare Wholesale modules (Inventory Control, Sales Analysis).
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Experience in creating, processing and partitioning of cubes Using Tools such as SSIS, SSAS and management studio.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Expertise with Table Design, Index Design and Performance Tuning.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Extensive knowledge on of the Software Development Life Cycle (SDLC) with the vision of Verifications & Validations and develop Test Plans, Test Cases and Test Scripts to validate all user-interfacing components of application
• Experience working with production and 24 x 7 on call environments.
• Good experience in Dimensional modeling using Star Schema/Snowflake modeling concepts and Kimball/Inman strategies. Experience with Physical & logical data modeling using All-Fusion Erwin Data Modeler4.1.2
• Hands on experience on working with different versions of MySQL cluster.
• Worked with the team in building the daily dollar, summary, funnel genie, objective and adjustments reports.
• Hands on experience with Testing Life Cycle (Component testing, Unit testing, and System/Integration testing, User acceptance testing etc.)
• Worked with writing the complex stored procedure, functions, in-line view, and cursors on T-SQL
• Worked with improving the performance on SQL, TSQL and SSRS procedures and provided the recommendation on server related tuning issues

TECHNICAL SKILLS

MS SQL Server 2005/2000/7.0, ORACLE 7.x/8i/9i, DB2, MS-Access, Essbase, SQL Profiler, SQL Query Analyzer, DTS Import/Export,MySQL, Backup Server and Replication Server, Enterprise Manager, Query Analyzer, SQL Profiler

Database/ETL Tools:

• SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor,MySQL Cluster carrier Grade Edition,SSIS, SSRS, Business Intelligence Development Studio, DTS, Abinitio.

Data Modeling Tools:

Erwin v 4.0, Visio 5.0,ER Studio

OLAP/Reporting Tools:

SQL server Reporting services (SSRS), Hyperion (BRIO), Micro strategy,MOSS 2007,MS Acess

Operating Systems:

• Windows 95/98, Windows 2000/NT, UNIX.

Programming Languages:

• T-SQL * PLUS 3.1, PL/SQL, C, C++, Java

Internet Technologies:

PHP, ASP, JSP, XML, UML, JavaScript, HTML,Cold Fusion

Testing Tools:

Win Runner, Load Runner, Test Director, and Quick Test Pro, Abinitio Testing

PROFESSIONAL EXPERIENCE:

Confidential,Austin TX July’07-present SQL Server Developer

Responsibilities:

• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Implemented CTP applications of SQL Server 2008 to enhance the performance of the server using 64-bit,32-bit platforms.
• Developed a web based application that queries meta-data from OLAP cubes; dynamically generates MDX and the returns data from the MDX query.
• Proficient in writing complex MDX queries in analyzing OLAP cubes and building reports.
• Managed the migration of SQL Server 2005 databases to SQL Server 2008.
• Written automated stored procedures in order to build PDE warehouse to store data from datamarts.
• Experience on working with management using CTP SQL Server 2008 platforms.Wrote the packages using SSIS in SQL2005.
• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
• Interconnected SCI with SQL cluster in order to achieve higher level of performance.
• Proficient in working with Query Analyzer and on the platform of MS Enterprise Manager.
• Expertise with database administration, tuning, security, and Replication Server implementation.
• Unit Testing the SSIS packages with respect to its flow and performance issues.
• Performance tuning specialist in Sybase 12.0,12.5 database administration. Proficient in writing complex queries in SQR query manager.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Expertise in Oracle 9i/8i, Developers Suite (Forms 6i/4i, Reports 10g/9i/6i/2.5), SQL*Plus 9.0, PL/SQL and Discoverer 10g/4i.
• Responsible for the front-end design, analysis, development and testing of BCAS in Visual Basic 6.0, with reporting in Crystal Reports, data retrieval using stored procedures in Transact SQL on a Sybase 12.5 database.
• Worked on Client/Server tools like SQL Server Management Studio to administer SQL Server.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements.
• Performed performance tuning of queries in PDE databases.
• Did trouble shooting of Client connections, viewing error log and applications.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Expert in implementing the snapshot isolation and DDL triggers.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed various sites using application developer server technologies like PHP,Cold Fusion.
• Developed reports using SSRS 2005 and Crystal reports, used table control, matrix control for cross tab reports.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.

Environment: SQL Server Management Studio, Stored Procedures, SQL Server reporting services (SSRS), SQL Server Integration Services (SSIS), Informatica,SQL Server Analysis Services(SSAS), Composer, IEF, Crystal Reports, Office, Excel.

Confidential,Stamford, CT Aug’06 –Jun’07
SQL Developer/ DBA

Responsibilities:

• Set up Database Maintenance Plan using SQL Server Enterprise to update the statistics.
• Developed web-based system used several OLAP cubes to deliver hundreds of metrics by time, location, and technology. The data mart portion of the application contained six databases ranging in size from 10GB to 300GB.
• Experience in working creating Multidimensional cubes using SSAS.
• Expertise in creating OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Created complex stored procedures to make the report processing faster.
• Hands on experience in giving the throughput of 10,000+ replicated transactions per sec on a 2 Node Cluster with 1 CPU Per Node using the SQL clustering.
• Conversion of remotely called stored procedures into UDB DB2 remote stored procedures using NFS mounted file systems.
• Installed SQL Server 2005 and created Development Database for testing, upgrades and development.
• Wrote MS Access VBA applications to manage test results data.
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets and/or ASCII files by using Set and Merge for generating Reports and Graphs.
• Experience in building Forms 6i, generating Reports and registering them as concurrent programs in Oracle applications using AOL
• Developed a VBA/Access application for downloading DB3files, imports into Access, processes and prints direct mail documents in Word.
• Proficient in writing and building parametrized reports through SQR. Used log shipping for synchronization of database.
• Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings.
• Performed daily backup and created named backup devices to backup the servers regularly.
• To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment using high availability solutions such as HPPolyserve.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Ran SQL Profiler periodically to see the performance of the database; used the results of the profiler in the Index Tuning to see the suggestions of the SQL Server.
• Implementing and administering database replication between SQL Server databases as well as dissimilar databases.
• Performed optimization of query, triggers, and stored procedures, their testing focusing on stability and execution plan which has resulted up to 45% increase in performance of numerous modules.
• Designed new dynamic DTS Packages to transfer data between servers, load data into database and tuned the existing packages.
• Worked in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications. Developed complex TSQL code for the application.
• After installing the SQL server 2005, migrated the existing DTS packages into SSIS packages using SSIS services provided by SQL Server 2005 Manager studio.
• Import/Export and successfully migrated the Databases such as DB2 to SQL Server 2005 using DTS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

Environment: DB2, SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003, BizTalk Server 2004, IIS 6.0, .NET, Advantage Gen, Informatica,COOL Gen, Composer, IEF Erwin, Microsoft Visio 2003, SFTP, Microsoft Reporting Service

Confidential,Framingham, MA May’04-June’06
SQL Developer

Responsibilities:

• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Rectifying and performance tune the diamond data feed process. Debug, Performance tune and enable the DTS packages for error logging. After tuning the DTS packages now take minutes rather than hours load the same amount of data.
• Created Tabular and Matrix reports using SSRS.
• Backing up system & other databases and restoring them as per requirements.
• Database Administrator, Database Programming.Involved in data analysis.
• Involved in Normalization Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Created datasets and generating reports using PROC Tabulate, PROC Report, SAS arrays, PROC SQL and MACROS.
• Developed SAS MACROS for data cleaning and Reporting and to support routing processing
• Responsible for data mining and multivariable statistical analysis for leading online trading website (Base SAS/STAT)
• Create Statistical reports based on historical price movements vs. current options straddle cost (SAS, Excel)
• Analyze volatility changes before and after earnings (SAS)
• Analyzed datasets for integration into centralized SQL Server 2000 database
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Monitoring the servers using spot light third party Quest software.
• Extracting the fixed length format files from DB2 databases.
• Export or Import data from other data sources like flat files using Import/Export of DTS.Recovering the databases from backup in disasters
• Organized data from a data warehouse into multidimensional cubes with MS Analysis Services to allow the execution of sophisticated reports and complex queries.
• Maintaining the database consistency with DBCC at regular intervals.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings.Monitoring the clustering environment.
• 24 X 7 Production Database on Call Support.Created various dynamic reports using MS Reporting Services, Crystal reports.
• Analyzed the existing application programs and tuned SQL queries using Execution plan, SQL performance Monitor, SQL Profiler.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing
• Prepared documentation for the SQL Server 2005 Replication.Created backups and restore of database and schedule to run.

Environment: SQL Server 2005 / 2000(2003 ,64 bit edition of sql server 2000), DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, SSAS, ERWIN.

Confidential,India jan 03- Feb 04
Database Developer

Responsibilities:

• Administered various applications like Maintenance Management and Financial Account System.
• Maintained the client\'s Sales and Customer Databases and tuning of the database instances.
• Administered all database objects, including tables, clusters, indexes, views, Sequences packages, and procedures.
• Troubleshoot problems concerned with the Databases, Applications, and Development tools.
• Created new databases for users as required. Checking the alert logs daily for oracle errors.
• Tuning of I/O to reduce disk contention by distributing I/O.
• Data Modeling, normalization, de-normalization, physical database design, and relational models.
• Enforced security for all of the Oracle Databases. Data loading using SQL*Loader. Manage sharing of resources amongst applications.
• Creating and maintaining Triggers, Packages, Functions, and Procedures.
• Creating and maintaining roles and profiles for security and limited access of data.
• Design and implementation of Backup & Recovery strategies.
• Creation of logins and user ids and setting up privileges and procedures for protection of data.
• Designed screens and reports layout.
• Used PL/SQL to write the Stored Procedures /triggers and data validation routines.

Environment: Windows NT 4.0, IIS 3.0,Visual Basic 5.0,Java Script, VB Script, ActiveX, ASP, Oracle 8, Crystal Reports 5.0, HTML, DHTML.