PROFESSIONAL SUMMARY:

• Over 8+years of experience in IT field, with comprehensive hands - on expertise as a MS SQL Developer.
• Expert in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server 2000/2005/2008 .
• Experienced in creating Tables, Views, Indexes and other SQL joins and query writing.
• Extensive experience with SQL Server and T-SQL in constructing triggers, Stored Procedures, user functions, user profiles, and relational database models.
• Expert in Cube designer in Business Intelligence Development Studio (BIDS) to edit various properties of a cube, including the measure groups, cube dimensions and dimension relationships, calculations.
• Proficient in implementing security and managing partitions in Analysis Services (SSAS).
• Expert in Developing cubes using Partitions, KPI’s, and Perspectives and created various user roles.
• Created SQL Server Reports using SSRS and published them using various reporting tools like Pro-clarity & SSRS.
• Experience with Report Builder which is fully integrated with SQL Server Reporting Services (SSRS)and delivers ad hoc reporting support.
• Expert in defining Query for generating drill down reports in SSRS 2005/2008.
• Proficient in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Proficient in using tools like Bulk Copy (BCP) and Data Transformation Services (DTS) and SSIS with MS SQL Server 2000/2005/2008 .
• Experienced in SQL Enterprises Manager, SQL Server Agent for creating and scheduling jobs, alert and operators, SQL Profiler, restoring database (full, differential, and log backups), Import / Export and Copy Database.
• Involved in database restore requests and refresh the database between productions, test servers.
• Experienced in trouble shooting database issues and maintains the SQL Server to provide maximum availability.
• Knowledge in creating and scheduling SSIS/DTS packages in Business Intelligence Studio (BIDS) to transfer data in various databases.
• Expert in working with trace files and execution logs.
• Good Business and System Analysis skills to understand the requirements and design application to accomplish the business needs.
• Team player and self-starter with excellent communication skills, ability to work independently or as a part of team and capable of picking up new skills quickly.

TECHNICAL SKILLS:

Languages: C, C++, SQL, T-SQL,PL/SQL

SQL Server Tools/Packages: SQL Server Management Studio, Enterprise Manager, Business Intelligent Studio, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent, Crystal Reports, ETL

Databases: SQL Server 2000/2005/2008, MS Access 97/2003/2005/2008, Oracle

Operating Systems: Windows Server 2000/2003/2008, Windows Vista/XP/2003/2000 UNIX, Linux, DOS

BI Tools: SSRS, SSIS, SSAS, Erwin Data modeler

Web Technologies: HTML, DHTML, XML, Visual Studio, MS Front page

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Successfully migrated content from Microsoft SQL Server 2000 (DTS) to Microsoft SQL Server 2008 (SSIS).
• Performed Server installation and configuration using SQL Server2008.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL Statements.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSIS.
• Automate tasks using active x script (similar to VB script). Be able to implement failure alerts using sent email task in SSIS.
• Snapshot Replication was been used to synchronize the data between their different stores.
• Scheduled Database and Transactional log backups using the Database maintenance Plan Wizard in SSIS
• 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).
• Created the automated processes for the activities such as database backup processes and SSAS, SSRS packages run sequentially using SQL Server Agent Job.
• Performed Server installation and configuration using SQL Server 2008.

Environment: SQL Server 2000, SQL Server 2008,SSIS,SSRS, Excel, Windows Server 2008, IIS, VB.Net.

Confidential, Eden Prairie, MN

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Designed and developedSSIS Packages (.dtsx files)to import and export data fromMS Excel, SQL Server 2008 and Flat files.
• SSIS packages to transform raw data into useful information being stored in tables.
• SSIS packages to update tables with monthly data and automated it through scheduled jobs for the beginning of every month.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2008).
• Involved in creating report models and applying row level security filters for report model.
• Involved in various data loadings to cubes for reporting and analysis purpose
• Implemented Constraints on tables for maintaining Data Integrity
• Installation and configuration of SQL Server Reporting Services (SSRS) 2008
• Designed and developed various complex reports such asDrill down, Drill Through, Cross TabbedusingMS Reporting Services.
• Involved in designingParameterized Reportsand alsocascaded Parameterized Reports.
• CreatedReport SubscriptionusingSSRS 2008.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube
• Experience in building Reports on Analysis Services cubes.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Developed functions based on BCP to import data from flat files into SQL server tables and export into XLS files.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Created Clustered and Non-clustered Indexes for Query Optimization and also involved in Database Tuning.
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Involved in DBA activities such as backups, restores, replication etc. Performs database tuning and troubleshooting. Install and troubleshoot replication, performs production migrations, backups, and database recovery.
• Developed and implemented Backup and Recovery strategies. Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per the business needs.

Environment: MS SQL Server 2008R2, T-SQL, SSIS, SSRS, MS Excel, Business Intelligence Development Studio 2008, Visual Studio 2008,VB.Net, DTS to Import & Export Data, SQL Profiler, Windows XP,TFS.

Confidential, Los Angeles, CA

MS SQL Server SSIS/SSRS Developer/Architect

Responsibilities:

• Designed the architects of relational and multidimensional databases based on business requirements on SQL Server2008R2.
• Installed SQL Server 2008 and Configured.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Monitor database status including CPU, Memory, me/O, Space and dead lock using SQL Server Utilities
• Worked as an SQL Database Architect, designed the database, developed and deployed dtsx packages in SSIS and reports in SSRS.
• Worked on Excels to upload the data from excels to database.
• Involved in writing T-SQL stored procedures and user-defined functions and perform daily account screening. Implemented database maintenance procedures: hourly/daily/weekly backup schedule.
• Reviewed and modified database structures, stored procedures to convert database tables into XML format and display via web, views, triggers, user-defined functions
• Enhanced performance by reviewing disk configuration and storage allocation. Generated test data and test database to meet the functionalities deliverables.
• Planned database security measures and Created and updated database document. Supported development effort by providing T-SQL statement tuning and optimized data loading processes
• Provided back-end support for functional testing and performance testing. Developed scripts to migrate data from multiple sources to desired destination using ETL tools.
• Scheduled and monitored all maintenance activities of SQL Server including database consistency checking, and index defragmentation.
• Created SSIS Package for uploads and schedule them as SQL Server Agent. Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Created reports to retrieve data usingStored Proceduresthat accept parameters.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Worked on designing frontend screens using VB.NET application.
• Worked on MINITAB for Forecasting .
• Experience in usingSQL Server 2008tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Agent

Environment: MS SQL Server 2008R2, MS Excel, Business Intelligence Development Studio 2008, SQL Profiler, MINITAB,VB.NET,SSIS,SSRS,T-SQL, Windows Server 2003/2008.

Confidential, Plano, TX

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Worked with Data Analysts and end users to understand the business and dataflow.
• Played a lead role on ETL development using SSIS.
• Analyzed the Functional Specs provided as per business requirement and created Technical Specs documents for all the mappings.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Wrote user requirement documents based on functional specification.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Used multiple join statements to retrieve data from multiple several tables.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Created the ETL (SSIS) packages and scheduled them.
• Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using (SSIS).
• Played a major role in production support of SSAS (cube refresh), SSIS jobs.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.
• Scheduling and maintaining SSIS Packages and batch jobs thru SQL Server Agent
• Created ETL, SSIS packages both design and code to process data to target databases.
• Configured packages event logs.
• Created SQL Server Reports using SSRS 2005.
• Identified the Data Source and defined them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2005.
• Involved in implementing add-in services (e.g. Reporting, Integration). Migrated objects from SQL Server 2005 to SQL Server 2008.
• Migrated Crystal Reports to SQL Server Reporting services for easily migration between databases using phased approach.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: MS SQL Server 2005, SQL Server2008, T-SQL, SSIS, SSRS, Crystal Reports, MS Access, DTS, SQL Profiler,VB.Net, MS Excel, ASP.Net.

Confidential, NJ

MS SQL Server SSIS/SSAS/SSRS Developer

Responsibilities:

• Planned, defined and designed data based on the business requirement.
• Worked closely with Business Analysts to produce all required documentation.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Created and maintained databases for Dealers, Vehicle Driver, and Vehicle information.
• Developed complex stored procedures and triggers in T-SQL.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Used SSRS to create various ad-hoc, parameterized, drill-down and drill-through reports weekly and monthly showing detailed information of the Vendors information, Titles Information.
• Installed and configured SQL Server 2005 successfully on Windows Server 2003.
• Reviewed and fine tuned stored procedures and triggers before production migration.
• Fine tuned database objects and server to ensure efficient data retrieval.
• Assisted the front end application developers with their queries.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2005, MS Access 2000, Business Intelligence Development Studio 2005, MS SQL Analysis Services 2005, MS Excel, Windows Server 2003/2008, ERWIN.

Confidential, Prattville, AL

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Installed SQL Server 2005 and Configured to the database.
• Wrote stored procedures, triggers, and constraints to ensure data integrity, data consistency and to meet the business rules. Tuned SQL statements and Stored procedures.
• Converted various SQL statements into stored procedures thereby reducing the number of database accesses.
• Performed data validation and aggregation.
• Performed query optimization and checked performance tuning.
• Used query analyzer to optimize queries.
• Created the Cubes and Dimensions.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Responsible for gathering/refining requirements from the customer for developing reports.
• Created SQL Server Reports using SSRS 2005.
• Identified the Data Source and defining them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2005.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Defined d Relationships with the measure groups and fact tables.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Defined Dimension Granularity with in a measure group and drill through actions.
• Identified and defined the Key Performance Indicators.
• Deployed SQL server Analysis Projects using MS SQL Server 2005.
• Created SSIS packages for transferring the data from different systems.
• Performed database consistency checks using DBCC utilities.
• Created linked servers for data retrieval using OLEDB data source and providers.

Environment: SQL Server 2005/2000, SSIS, SSRS, SSAS, Query Analyzer, Enterprise Manager, C# .net, Windows 2000/2003, SQL Profiler, DTS, T-SQL, BCP, OLE DB, XML, MS Access

Confidential, Minneapolis, MN

SQL Server Developer/DBA

Responsibilities:

• Actively involved in creation of database, modified tables, triggers, procedures to clean and validate the data about the cable layout, so as to meet the company specifications.
• Data transformation activities using DTS Import/Export for transferring data between different Databases like Oracle, Sybase. Design new DTS Packages as per needs, resolve problems with existing DTS packages etc.
• Monitored database status including CPU, memory, me/O, space, and dead locks using SQL Server Utilities.
• Developed and managed DTS Packages and scheduled jobs for periodic and nightly batch processes. 24x7 Production support
• Involved in writing T-SQL stored procedures and user-defined functions and perform daily account screening. Implemented database maintenance procedures: hourly/daily/weekly backup schedule.
• Incorporating business logic in DTS while converting from Oracle, MS Access and Text to SQL Server. Creating new database/tables to put in the extracted data and rebuilding the relationship.
• Written stored procedures for Automatic Scripting to backup transaction logs, flush/grow/shrink log files, maintain archive of objects and so on
• Ensured constraints and writing triggers to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
• Created different user level groups, and assigned appropriate permission level to the database. This made sure that only the right person with enough authority would be able to see the Customer Information
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.

Environment: MS SQL Server 2000, Windows 2000/XP, SQL, Oracle, Visual Basic 6.0, MS Reporting Services., .Net, ASP, Excel, Visio, VB script, MS Access, Erwin.

Confidential

SQL Server Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user .
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.

Environment: SQL Server 2000, T-SQL, PL/SQL