SUMMARY:

• Over 7 years of IT experience in analysis, design, implementation & administration of Business intelligence solutions with Microsoft SQL server 2008 R2/2008/2005/2000 in development, Testing & production environment
• Strong experience with T - SQL(DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands
• Ability to work in all stages of System Development Life Cycle (SDLC)
• Experience in Error handling and debugging coding issues andtroubleshoot production problems. Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys
• Experience in datawarehouse development with Integration Services and Report Development
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures
• Expertise in SQL Server 2005 Reporting Services (SSRS), SQL Server 2005 Integration Services (SSIS) and in SQL Server 2005 Analysis Services (SSAS) in Business Intelligence (BI)
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, ErrorHandlers etc.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005/2008 R2)
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent
• Hands on experience in installing, configuring, managing, upgrading and migrating,Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2005
• Experience in Managing Security of SQL Server 2005/2008 R2 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements
• Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS
• Experience in .NET/C# application development environment to use SQL Server Databases
• Well-versed in usage of SSIS Control Flow items and SSIS Data Flow items
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security
• Experience in developing Custom Reports and different types of Tabular, Matrix, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS)
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
• Integration of SSRS Reports using various web parts intoSharePoint (MOSS 2007) and various delivery mechanisms
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables
• Strong analytical, problem-solving and communication skills, with particular emphasis on clear, detailed Business Requirements and Functional Specifications, as well as reports for management
• Extensive experience with process modeling using UML, Flow charts, sequence diagrams, activity diagrams and Use Cases
• A strong team player with ability to learn new skills and adapt quickly, highly motivated with excellent interpersonal, communication

TECHNICAL SKILLS:

Tools &Packages: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS), DTS, Report Builder 9.0, ProClarity 6.2,SharePoint 2007, Crystal Reports

BI Tools: SSIS, SSAS, SSRS

Databases: MSSQLServer2008R2/2008/2005/2000,MSAccess97/2003/2005/2008, MYSQL, Teradata, Oracle

Language: T-SQL, PL/SQL, MDX,C, VB.net, C# (.NET)

Operating Systems: Windows vista/XP/2003/2000, Windows Server 2000/2003/2008, UNIX

Application Packages: MS Office Suite, MS Outlook, Windows SharePoint Services

IDE Tools: Eclipse 2.0, Net beans

Data Modeling Tools: MS Visio/ERWin/ERStudio

PROFESSIONAL EXPERIENCE:

Confidential, Carlsbad, CA

Responsibilities:

• Involved in database Schema design and development.
• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams
• Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
• Creation of user Databases and installation of MS SQL Server 2008
• Created and maintained various databases for development and testing environment using SQL Server 2008
• Participated in converting DTS packages to SSIS package.
• Involved in Database testing by writing & executing SQL queries to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.
• Checked for the consistency of data in database with SQL queries.
• Involved in the troubleshooting of Database performance issues and implementing necessary DB changes.
• Responsible for developing stored procedures and ad hoc reports using SSRS Reports.
• Developed, tested and implemented robust Disaster Recovery Plan.
• Planning and scheduling backup strategy to ensure reliable backup.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.

Environment: SQL Server 2005/2008/2008R2, Windows XP/Vista.SQL Server 2005/2008/2008R2 Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Visual Studio 2008 & 2005,MS Visio 2007, .NET, UNIX.

Confidential, Milwaukee, WI

SQL Server / SSIS / SSRS Developer

Responsibilities:

• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Writing the stored procedures, checking the code for efficiency using T-SQL.
• Creation of user Databases and installation of MS SQL Server 2008.
• Created and maintained various databases for development and testing environment using SQL Server 2008.
• Created joins and sub-queries for complex queries involving multiple tables.
• Created and managed database objects such as tables, views, indexes, stored procedures and Triggers.
• Defining and creating indexes for Query Optimization and Revising Scripts for optimal performance.
• Worked on preparing the different sections of the Business Requirement document.
• Using SQL Server Integration Services (SSIS) to populate data from various data
• Participated in converting DTS packages to SSIS package.
• Worked on building the mockup reports using SSRS and Excel for prototype.
• Create reports in SQL server using SSRS as per the requirements provided by the Front End users.
• Used Notification services to generate error messages and send them to the user.
• Used MS Excel for exporting the reports (Pivot Reports).
• Testing the Stored Procedures performance and its path of execution by using SQL Profile.
• Recovering the Backups of SQL Server production databases in test servers as part of regularMaintenance activities.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• To ensure the physical consistency of the database and objects.

Environment: SQL Server 2008, Windows 2003/2007 server, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS), SQL Profiler,, Microsoft clustering Services, ADO.NET

Confidential, Overland, KS

SQL Server Developer

Responsibilities:

• Developed, modified, and optimized complex queries to retrieval and modification.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Developed stored procedures, advanced queries, trigger, views, and indexes by using T-SQL.
• Administers, maintains, develops and implements policies and procedures for ensuring the availability and integrity of the database systems used by the development team.
• Implements data models and database designs,data access and table maintenance codes.
• Resolves database performance issues, database capacity issues, and other distributed data issues.
• Created different stored procedures for performance enhancement.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Assisted users in modifying Store Procedures and over performance issues.
• Increased the size of the database, transaction logs and database devices.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Performed update on table with new columns and populated data using Joins.
• Created DTS Packages to reload tables from Excel data files.
• Identified existing Server and Database Architecture environment and analyzed for server migration, including all documentation process to support SQL Server 2005.
• Writes store procedures for database maintenance, sets up and manages the jobs to correspond the user’s needs.
• Optimizing and Tuning of SQL Queries.

Environment:SQL Server 2005/2008, SSIS, SSRS, SQL Profiler, DTS, Query Analyzer, Index Tuning Wizard, Enterprise Manager

Confidential, Arlington, VA

SQL Server Developer

Responsibilities:

• Created New Databases and maintained existing User / System Databases.
• Extensive experiencein writing queries by using joins, Indexes, views, Stored Procedures and Triggers in SQL Server Management studio (SSMS).
• Expert in calculating measures and dimension members using multi-dimensionalexpression (MDX), mathematical formulas, and user-defined functions.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links andformatted the results into reports and kept logs.
• Responsible for Design and Normalization of the database tables.
• Created database triggers to implement complex business rules and processes.
• Created different stored procedures for performance enhancement.
• Assisted users in modifying Store Procedures and over performance issues.
• Increased the size of the database, transactionlogs and database devices.
• Used T-SQL for programming for stored procedures and queries
• Created and maintained scheduled jobs and checked consistency of databases.
• Handled issues with server logins, database roles.
• Looked after the backupjobs across different servers.

Environment: MS SQL Server 2000/2005, Windows 2000 Advance Server, Visual Studio 2005, VB.net 2005,Oracle, PL/SQL, MS Office

Confidential

Data Analyst

Responsibilities:

• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Managed indexes, statistics and tunedqueries by using execution plan for optimizing the performanceof the databases.
• Installation, configuration of MS SQL Server 2000/2005
• SQL server Upgrade from 2000 to SQL 2005
• Extensively involved in designing (Logical and Physical) of customer database
• Creating and managing schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables, triggers and maintained Referential Integrity.
• Developed Query for generating drill down reports in SSRS 2005.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created SQL Server Reports using SSRS 2005.
• Eased administrative work through automatic script performing daily/weekly backups.

Environment: MS SQL Server 2000/2005, Windows 2000 Advance Server, Visual Studio 2005, VB.net 2005,Oracle, PL/SQL, MS Office