SUMMARY

• Around 7 years of IT experience in the use and development,design,support and migrate of Microsoft SQL Server 2008/2005/2000 database.
• Extensive experience as SQL Server Developer in utilizing triggers, cursors, functions and stored procedures.
• Versatile in working with SQL Server Enterprise Manager, Query Analyzer, Profiler, SQL Server Management Studio, SQL server Integration Services& SQL Server Reporting Services(SSRS).
• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
• Expert in extracting and transforming data using DTSImport Export Data, DTS Packages, SSIS and experience in using BCP for Bulk copy operation and Bulk Insert
• Exposure to T - SQL programming and Architecture, and translated complex legacy process with T-SQL procedure, functions and package.
• Expert in creating complex Stored Procedures, User Defined Functions, andeffective Triggers to facilitate efficient data manipulation and data integrity.
• Extensively worked on developing reports and deploying applications using: SQL Server 2008/2005/2000 , Microsoft office, VBA and macros.
• Experience in designinglogicalandphysicaldata modelsusing ERWIN and ER/Studio tools.
• Expertise in developing reports using SQL Server 2008/2005 Reporting Services (SSRS).
• Experienced in sorting the data, defining subtotals for reports and designing report layout.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008/2005
• Hands on experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Hands on experience in creating ETL packages using SQL Server 2008/2005 Integration Services (SSIS).
• Worked with OLAP and Data warehouse application and worked with star schema dimensions and SSRS tosupport large Reporting needs.
• A Team-Player with motivation and ability to work independently, Worked closely with the Case Teams, Business Analysts and Data Analysts and Functional Design Teams.
• Good communication and written skills and can handle multiple projects simultaneously.
• Seeking a challenging position that can impact the company’s growth and where abilities, experience and al background can be valuable.
• Worked with performance tune the complex queries using the Microsoft Query analyzer and used to support batch process
• Performed complex SQL and MDX Queries and generate reports .
• Built MDX (Multi Dimensional Expressions) and Data Mining Extensions (DMX)

TECHNICAL SKILLS

Programming Languages: T-SQL, ASP.Net,Oracle(Pl/SQL),Shell scripts and Java

Database Application Software: SQL Server 2000/2005/2008 , DB 2,MS Access(2000/2003)UML.

DB Utilities: SQL Server Management Utilities, Query Analyzer.

GUI: DTS Import/Export, SQL Server Integration Services.

Reporting: MS Access, Excel, MS SQL Server Reporting Services 2000/2005/2008 SSIS,SSAS and Share Point.

Operating Systems: Windows 7/Vista/XP/NT/ 2000/2003/2008.

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL BI Developer

Responsibilities:

• Developed T-SQL scripts to create 3NF database and the respective 3NF tables in the system and added appropriate clustered and non-clustered indexes on those tables.
• Designed generic stored procedures, user defined functions and T-SQL queries to pull the data from de-normalized legacy database to 3NF database.
• Responsible for designing and developing schemas using Entity Relationships, Data Modeling, normalizing relations, creating tables, Views, Indexes, Sequences and coding.
• Created complex StoredProcedures, Functions, Triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Monitoring the identifiedETLprocesses, restarting theETLprocesses that aborted
• Rescheduling specificETLprocesses when there is one such requirement, Work with System Administrationonbackups/image copies.
• The above listed maintenance tasks for the other environments where the similarETLprocess runs.
• Monitoring the Data Quality, Generating weekly/monthly/yearly statistics reportsonproduction processes - success / failure rates for causal analysis as maintenance part and Enhancing exiting productionETLscripts.
• Modified ExistingETLscripts to fix defects at the root cause as enhancement part of project
• Designed and developed SSIS packages using stored procedures, configuration files, tables, views, and functions and implemented best practices to maintain optimal performance.
• Extensively used SSIS for migrating data from DTS packages to SSIS packages using SSIS 2005.
• Configure the SSIS Package for run time Parameters and Configuration file
• Used SSIS packages to roll our data to Live Tables and to Claim Processing Database.
• Designed and created MDX queries to retrieve data from cubes using SSIS
• Improved automation of existing processes of SQL using stored procedures and SSIS packages.
• Responsible for the design of the SSIS package for updating the data mart from OLTPdatabase and validation of the aggregate data from the ODS and the OLTP Database.
• Created SSIS Packages for migration of data between SQL Server database and other databases like MS Access, MS Excel and Flat Files
• Generated reportsusing Global Variables, Expressions and Functions based on the requirements using SSRS.
• Performed Data partitioning to improve the performance, reduce contention and increase availability of data.
• Created Parameterized reports and Linked reports through knowledge of report serving architecture using SSRS.
• Designed and deployed sub-reports, parameterized reports, linked reports, Matrix Reports, charts, and Drill through/down reports, using SSRS and maintained various reports in SQL Server 2005.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL ServerReporing Services(SSRS)
• Experienced in sorting the data, defining data source and subtotals for the reports and using global variables, expressions and functions for the reports using SSRS.
• Developed Tabular, Drill Down, Parameterized, cascaded and sub-reports using SSRS.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using SSRS 2008.
• Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler.
• Responsible for monitoring, truncating and shrinking the log spaces and files used on the database level in SQL SERVER 2008.
• Created SSIS Packages for migration of data between SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Involved in administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users.
• Prepared the Unit Test Plan (UTP), Unit test cases (UTC) based on each module changes.
• Performed daily database backup & restoration and monitored the performance of Database Server.
• Experience in SSAS (SQL Server Analysis Services) in SQL 2005 and SQL Server 2008
• Used SSIS 2008 to create ETL packages (.dtsx files) to validate, extract, transform and load data to Data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Dimensional Modeling using SSAS packages for End-User.
• Created Hierarchies in Dimensional Modeling
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Created partitions and designed various storage modes to increase the performance of cubes using SSAS.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services.
• Implemented cell level security in cubes to restrict users of one region viewing data of another region using SSAS.

ENVINORMENT:MS SQL Server 2008, Visual Studio 2005, Windows 2000, Windows XP, T-SQL, ASP.NET, XML, SSRS, SSIS,SSAS, ERWIN,VISIO.

Confidential, AZ

SQL BI Developer

Responsibilities:

• Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
• Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005.
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Designed and implemented Disaster Recovery Procedures like Log Shipping and mirroring between production and DR servers.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
• Migrated legacy database and spreadsheets (Access/Excel) to SQL Server 2000 using Data Transformation Services (DTS) and T-SQL scripts.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, <>, statement & using the TOP operator to limit the Select statement in certain queries.
• Created views to restrict access to data in a table for security.
• Developed computer information resources, providing for data security and control, strategic computing, and disaster recovery.
• Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
• Designed SQLSSISPackages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQLServer 2005 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Supported Application Development team with any database issues, updates or new releases. and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Designed, Built the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Identified and defined Fact relationships in SSAS, Created cubes, dimensions, KPI, Measures and calculations

ENVIRONMENT: S: MS SQL Server 2005/2008,SSIS, SSRS,SSAS,T-SQL, OLAP Services, ASP.NET, XML, Windows 2003 Server, MS VISIO,ERWIN.

Confidential, Richardson, TX

Database Developer

Responsibilities:

• Created Stored Procedures, Triggers, Views and Functions for the Application. Provided extensive testing on the Performance of the Stored Procedures.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and IndexTuning Wizard.
• Improved the performance by reducing the usage of the cursors.
• Using the Update Statistics in the case of change in Indexed Columns for optimized performance.
• Followed the Microsoft recommended best practices in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Migrated Organization, Orders, Adjustments, Objectives and data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server DTS.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk.
• Responsible for creating reports based on the requirements using SSRS 2005.
• Deployed the generated reports on the server.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Migrated data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server databases using DTS, SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Migrated data from SQL server 2000 to SQL server 2005 and worked with implementing data mapping, cap analysis to migrate hybrid environment.
• Worked with migrating data from flat files, mainframe data, Oracle, Db2 data to SQL server 2005 using DTS services.
• Generated various reports using reporting services.
• As a technical specialist assisted in solving technical and non technical issues.

ENVINORMENT:Windows XP, Windows 2003, Terminal Server, T-SQL, ADO.NET, SQL Profiler, SQL Jobs, SQL Server Management studio, SQL Server 2005,ERWIN.

Confidential, Harford, MD

SQL Developer

Responsibilities:

• Involved in designing the physical databases model on SQL Server 2000 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for personal banking system.
• Performed database Tuning, monitoring, and Scalability Testing.
• Creating Data modeling, schema design using Erwin.
• Evolved in the creation and maintenance of indexusing Index Tuning Advisor wizard, Query optimizer, and selected the best indexing plan to be deployed.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Using Dynamic Sql statements constructed and executed dynamically during run time, based on supplied users
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Installed SQL Server 2005 with latest Service pack and established connectivity with the database created, configured and maintained database maintenance plans and also database backup and recovery.
• Debugging of Reports and Deploying of Reports
• After installing the SQLserver 2005, migrated the existing DTS packages into SSIS packages using SSIS services provided by SQL Server 2005 Manager studio.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Migrated SQL server 2000 DTS packages to SQL Server 2005 SSIS packages using SQL Server 2005 Upgrade Advisor.
• Worked on other packages of the SQL server 2005 Edition SSRS (SLQ Server Reporting Services), SSAS (SQL Server Analysis Services).
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• 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.
• Performed performance tuning by studying execution plan, analyzing indexes and using SQL Profiler.

ENVINORMENT: DB2, SQL Server 2000 Enterprise, Windows Enterprise Server 2003, IIS 6.0, .NET framework, Microsoft Reporting Service (SSRS).

Confidential

Database Developer

Responsibilities:

• Created and maintained database objects, complex Stored Procedures, Triggers, Cursors, and Tables, Views and SQL Joins and other statements for various applications.
• 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.
• Used Performance Monitor and SQL Profiler to find long running queries and then optimize the queries to enhance the performance of database server.
• Created ETL in DTS packages by using Data Transform task, VBScript task, SQL task and send Email task to migrate data from different functional databases into SQL Server 2000, which hosts the ERP system by using DTS Packages.
• Used SQL Server Reporting services for creating, editing and scheduling various reports.

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