SUMMARY:

• Over 8 years of experience in MS SQL Server 2000/2005/2008 and hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005/2008.
• Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS )
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in Logical and Physical Database design, development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager
• Expert in monitoring SQL Server Performance, troubleshooting using SQL Profiler, Index Tuning Wizard (DTA), Windows Performance Monitor and Maintenance plan
• Experience in extracting and transforming (ETL process) data using DTS/SSIS Import Export Data from various sources, Bulk Insert, Log Shipping, BCP and DTS/SSIS Packages.
• Extensive experience in the development of Reports using SQL Server 2000/2005 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, drilldown reports and score cards in multiple formats using multi - dimensional objects.
• Expert in designing and scheduling complexSSISPackages for transferring data manually from multiple data sources like MSSQL Server2000, Oracle Database, Excel and Flat file to MicrosoftSQL Serverby usingSSISand DTS utility ofSQL server2005/2008
• Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP.
• Experience with all phases of software development life cycle (SDLC) and project methodologies.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries
• Created and Designed a Multi Dimensional Analysis (Configured OLAP Cubes, Dimensions, Measures, MDX Queries, Data mining, Data Source and Data Source Views and Star and Snow Flake schema) using SQL Server 2005 Analysis Services (SSAS).
• Knowledge in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Hands on Experience in using tools like Dynamic Management Views, Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance.
• Experience working in a clustered OLTP environment with Very Large Databases (VLDB) and having version control (Visual SourceSafe and Team Foundation Server).
• Expert in multi-terabyte databases/ data-warehouses, web applications in Finance & CRM domains
• Good SQL Server Administration skills using various backup recovery, replication, restoration and DTS servers, Model (simple, Bulk and full), database maintenance plan.
• Efficient in up gradation and migration from SQL Server 2000 to SQL Server 2005/2008.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools
• Experience in migration of data from Excel, DB2, Teradata, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and Extracting, Transforming and Loading of data using SQL Server DTS/SSIS
• Experience in maintaining SQL Server security by assigning logins, server, database roles and server permissions.
• Experienced in manual, automation, integration and performance testing
• Knowledge on Web Programming using JavaScript, VBScript, HTML, XML and CSS
• Experience in working on administration tasks such as data loading, batch jobs, data unloading, user and application table management, upgrades, creating databases/ file groups/ files/ transaction logs
• Software development experience using Visual Studio 2005/2008, ASP.NET, ADO.NET, ASP, and .NET Framework 3.5.
• Creates back-up, replication, and recovery plans. Performs quality control and auditing of databases to ensure accurate and appropriate use of data.
• Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling.
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

Software/Hardware: SQL Server 2000/2005, Oracle 9i/10g/11i, MS Access, My Sql, DB2, SQL Plus, Sybase, SQL *Loader, Excel, SQL Server Management Studio, DTS, SSIS, SSAS, SSRS, Profiler, Enterprise Manager, BIDS, Database Tuning Advisor, SQL CMD, Query Analyzer, Service Broker, C, C++, T-SQL, PL/SQL, VB, C#.NET, ADO.NET, JAVA, J2EE, familiar with UNIX Shell scripts, HTML, JavaScript, PHP, XML, XHTML, MS Visual Source Safe(VSS), Microsoft team foundation server (TFS), Windows XP/2003/2000/NT/98/95, MS DOS, UNIX, Linux, Sun Solaris, ER Win, Microsoft Visio, Performance point server COGNOS 8 BI studio, Toad, MS Office, Proclarity, Clarify CRM,, Share point server 2007(MOSS).

PROFESSIONAL EXPERIENCE

Confidential, FL

Sr. SQL Server Developer Sybase/SSIS/SSAS

Responsibilities:

• Installation and configuration ofSQL Server2005
• Design and develop SSIS packages, store procedures, configuration files, tables, views, Indexes and functions implemented best practices to maintain optimal performance
• Used multiple transformations in SSIS to meet the business requirements by pulling data from ftp server loading into the Staging Data base, processing into main database.
• Existing data from diverse sources were consolidated into uniform Sql Server 2005 database. SSIS was used to define imports of data, build scheduling packages to define integration flow, log data error exceptions, orphaned data and sending mails
• Created a number of cubes, fact tables, dimensions, measure groups using Sql server Analysis Services representing aggregations in several different ways .
• Working knowledge in creating star and snowflake schemas in SSAS
• Created calculations, KPI, designed attribute hierarchies, added new named queries in DSV .
• Experience in testing cube in different environment by using xmla scripts and by creating new dimensions, linked dimension, new data source, new data source view’s.
• Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for processing cube dynamically after extracting, transforming, loading data into database
• Created master jobs for monitoring the jobs that depend on daily loads and Scheduled Cube Processing from Staging Database Tables usingSQLServerAgent.
• Implement data cleaning, incremental data loading, event handling and error handling.
• Created and scheduled SSIS packages for running data feeds from various departments and multiple servers and resources to Development Server
• Used Sybase Interactive Sql Java tool for querying Sybase
• Created tables, procedures in Sybase according to business requirement.
• Responsible for data retrieval by extensive use of multiple joins normalization and view
• Resolved various performance issues by running Database Consistency Checks DBCC command, adding Try catch blocks and creating Indexes.
• UsedSVN (Source Version Control) for version control
• Used SQL Server Profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc
• Experience in performance tuning, query optimization, using hints, Database Maintenance plans
• Deployed different SSIS packages on development and test environments
• Developed scripts to migrate data and the database objects to/from multiple sources.
• Involved in Unit Test cases preparation and performed Unit testing
• Enhanced performance using optimization techniques such as Normalization, Indexing and Transaction Isolation levels.
• Developed SSIS Packages not only for particular table’s fields and required data types for lookup tables in Staging but also for data Warehouse requirements
• Experienced in using tools like Import Export Data, Bulk Copy (BCP) and Data Transformation Services (DTS) andSSISwith MSSQL Server2000/2005/2008
• Experiences in developing Normalization, Stored Procedures, Views, Triggers, ETL processes, relational database theory, N-Tier development. and Complex Queries onSQL Server2000/2005/2008
• Implemented best practices in structuring SQL queries, Debugging Unexpected SQL Results etc, Supporting Large Databases, Troubleshooting and documenting root cause analysis
• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency
• Developed a thorough knowledge by working on Full Life Cycle of the Software Development Life Cycle (SDLC) phases namely Analysis, Design, Coding and Testing
• Frequently commended by clients in appreciation of timely deliveries and quality work.

Environment:SQL Server 2005/2008,ETLTool DTS, SSIS, SSAS, SSRS, Erwin, .Net Frame Work, XML, MS Access, Excel, C#, ASP .Net, Crystal Reports, ER Studio, Performance point Server.

Confidential . Fort Lauderdale, FL

Sr. SQL Server Developer/BI

Responsibilities:

• Installation and configuration ofSQL Server2008
• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin
• StrongSQL ServerDevelopment skills including writing Transact-SQL (T-SQL) Queries, Stored Procedures, Triggers, User Defined Functions (UDF), Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains, Rules and Default
• Extensive experiences in developing Normalization, Stored Procedures, Views, Triggers, ETL processes, relational database theory, N-Tier development. and Complex Queries onSQL Server2000/2005/2008
• Experienced in using tools like Import Export Data, Bulk Copy (BCP) and Data Transformation Services (DTS) andSSISwith MSSQL Server2000/2005/2008
• Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base
• Extensively worked in ETL and data integration in developing ETL mappings and scripts usingSSIS, Worked on Data transfer from a Text file toSQL Serverby using bulk insert task inSSIS.
• Created Packages that Transfers Databases from OneSQL Serverinstance to Another Instance and Scheduled the SSIS packagefor migration of data from old system to MS SQL 2008
• UsingSSIS, loaded XML data to the Database tables and Extracting Data usingSSISinto Excel Files for Marketing purpose
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files, Excels to and from SQL Server 2008with high volume data.
• Developed SSIS packages for File Transfer from one location to the other using FTP task
• Worked in designing Cubes in OLAP and identifying the Fact and Dimension tables.
• Working knowledge in Data modeling, creating star and snowflake schemas in SSAS
• Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements
• Developing calculated measures and assigning these aggregation levels based on dimension hierarchies
• Excellent in creating reports withSQL ServerReporting Services (SSRS)
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS
• Responsible for data retrieval by extensive use of multiple joins normalization and view
• Resolved various performance issues by running Database Consistency Checks DBCC command
• Performed data cleansing by creating tables to eliminate the dirty data using SSIS
• UsedVisual Source Safe(VSS) for version control
• Used SQL Server Profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc
• Experience in performance tuning, query optimization, Database Maintenance plans
• Managed the ETL processes between various environments through scripts utilizinglinked servers, DTS packages and SSIS
• Involved in Unit Test cases preparation and performed Unit testing
• Responsible for developing processes automation of maintenance jobs, tuningSQL Server, locks and indexes configurations
• Involved in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication
• Supporting Large Databases, Troubleshooting and documenting root cause analysis
• Developed a thorough knowledge by working on Full Life Cycle of the Software Development Life Cycle (SDLC) phases namely Analysis, Design, Coding and Testing
• Frequently commended by clients in appreciation of timely deliveries and quality work.

Environment: SQL Server 2005/2008, SSIS, SSAS, SSRS, Erwin, .Net Frame Work, XML, MS Access, Excel, C#, ASP .Net, Crystal Reports, ER Studio, Performance point Server.

Confidential, Boston, MA

Sr. SQL Server Developer/BI

Responsibilities:

• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Designed DTS Packages to transfer data between servers, load data into database, archive data file from different DBMS using SQL Enterprise Manager on SQL Server 2000 environment, and deploy the data, scheduled the jobs to do these tasks periodically.
• Analyzed database performance with SQL Profiler and Optimized indexes to improve query performance.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Scheduled tasks to run every day to update changes in the base tables
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
• Extracted the data from Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2005)
• Involved in the Migration of Databases from SQL Server 2000 to SQL Server 2008.
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Customized the CRM application for the business by adding custom tables, scripting,.
• Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel and .net.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files).
• Designed various MDX queries and multi dimensional OLAP cubes using SQL Server Analysis services (SSAS).
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2008 database
• Resolved various performance issues by running DBCC command
• Performed data cleansing by creating tables to eliminate the dirty data using SSIS
• Performed daily tasks including backup and restore from disaster recovery by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2005 Reporting Services (SSRS) and Crystal reports.
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Experience in performance tuning, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC
• Involved in Unit test cases preparation and performed Unit testing, functional testing and Integration testing
• Created many rich and highly interactive Web forms for user management module using ASP.Net 2.0, VB and DHTML.

Environment: SQL Server 2005/2008, SSIS, SSAS, SSRS, Erwin, .Net Frame Work, XML, MS Access, Excel, Share point (MOSS), C#, ASP .Net, Crystal Reports, ER Studio, Performance point Server.

Confidential, Tarry Town NY

Sr. SQL Server Developer / ETL / SSRS

Responsibilities:

• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Performed forward and reverse engineering for database development and design using Erwin.
• Created new database objects like stored procedures, Functions, Triggers, Indexes, cursors and Views using T-SQL in Development and Production environment for SQL Server 2005 and 2008
• Created MDX queries to access the OLAP cube information.
• Designed and implemented reports with different layouts using SSRS 2005 and Crystal Reports and exported them into Excel, PDF and HTML.
• Wrote stored procedures, Triggers, Cursors to implement business logic
• Created SSIS packages and DTS to transfer data from DB2 to SQL server using different SSIS components and used configuration files and variables for production deployment.
• Performed performance tuning by analyzing indexes, queries, table sizes, etc and heavy utilization of SQL Profiler, Database Engine tuning advisor and query execution plan tools.
• Actively involved in transactional and snapshot replication for test and EDW environments. Prepared scripts and monitored replication.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Worked with Shell scripting in Unix platform for performing data flow tasks.
• Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle. Design new SSIS packages as per needs, Resolve the problems.
• Created package configuration in XML and used them to deploy packages into various servers.
• Developed and maintained different SSIS packages to integrate data from different servers to main production server.
• Worked in Database Security, Replication, Log shipping activities
• Created and configured OLAP cubes using SQL Server 2005 analysis services.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time frame.
• Involved in testing the reports and fixing the bugs in the stored procedures
• Developed various templates for different modules in VB and ASP.NET.
• Setting up database backup and recovery procedures for quality and development servers.

Environment: MS SQL Server 2005, Windows Server 2003, SSIS, Erwin, SSAS, MS access, Excel, Oracle, C# .Net, ASP .Net, ADO .Net, Crystal Reports, ER Studio, SSRS, ER Studio.

Confidential, Mahwah, NJ

SQL Server Developer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model using Erwin and ER Studio.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Proficient in T-SQL queries DDL/DML
• Developed and maintained various cubes using MDX complex queries using SSAS.
• Designed and deployed various reports using SSRS.
• Used Microsoft service broker for messaging purposes between various applications.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Managed the entire ETL process, involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area using SSIS.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Worked closely with business users in defining and documenting reporting requirements in order to design, develop and maintain SQL Server 2005 reporting services.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Used CVS for version control and configuration management.

Environment: SQL Server 2000, DTS, T-SQL, C/C++MS OLAP, CVS, Windows 2000, Sybase, Crystal Reports, C# .Net, ASP .Net, ADO .Net, ER Studio, SSIS, SSAS, SSRS, Erwin, Team Foundation Server.

Confidential

SQL Developer

Responsibilities:

• Installation, configuration of MS SQL Server 7.0 for development and testing purpose
• Implemented the database for production and marketing purpose.
• Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures
• Managed Database files, transaction log and estimated space requirements.
• Monitored database application.
• Responsible for developing automation of maintenance jobs, tuning SQL Server locks and indexes configurations, administering SQL Server security.
• Designed and implemented several complex reports and administration modules.
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.
• Designed stored procedures for module integrity and application.

Environment: SQL Server v2000, T-SQL, Win NT v4, Win 2000, MS Access, Oracle.