SUMMARY

• Over Seven years of IT Experience in System Design, Development and Support of Microsoft SQL Server in Development.
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Strong experience in MS SQL Server with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) and T - SQL.
• Reporting Services, Notification Services, Indexing and Full-Text Search.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Experience in creating master and child packages, package configurations and logging.
• Migrated DTS packages to SSIS and modified using DTS editor wizard.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, and XML).
• Experience in writing distributed queries.
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility.
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• Experience in Microsoft SQL Server Database Administration including planning, backup, and recovery strategies.
• Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.
• Experience in failover clustering.
• Experience in implementing Disaster Recovery for minimal downtime using different types of database backups, restore, and replication.
• Experience in implementing log shipping and mirroring.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Extensive experience in database tuning, server logins and database permissions.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Experience in Dimensional Modeling.
• Experience working with XML documents.
• Develop and Maintenance Web application, Custom Application, Windows Service and Web Service in .NET environment.
• Excellent verbal and written communication skills combined with strong interpersonal and conflict resolution skills and possess strong analytical skills.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server BusinessIntelligence Development Studio

Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS), Crystal Reports.

Databases: SQL SERVER, MS-Access, MY SQL, Oracle and DB2

Languages: C, C++, T-SQL, .Net, C#, Java, Java Script, CSS.

Development skills: T-SQL, SSIS/SSRS/SSAS, PLSQL

Operating Systems: Windows NT, Windows XP, UNIX, Windows 7, LINUX.

Technologies: .NET, ASP.NET, ADO.NET, SQL, JAVA.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

SSIS/SSRS Developer

Responsibilities:

• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server.
• Installed and configured SQL Server successfully.
• Performance testing on stored procedures, Indexes.
• Analyzed the existing data and performed the migration steps from SQL Server 2005 to SQL Server 2008.
• Used different tasks, transformations, containers and source/destination components to create SSIS packages.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy Lookups, Lookups.
• Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Look Ups, Aggregations, and Multicasting.
• Extract data from access, excel, flat file, and different data base and load in SQL data base Using SSIS packages.
• Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using Control Flow Tools and Data Flow Tools and then verify it.
• Verified different packages using Views using SSIS.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Involved in generating summary reports like Tabular, Matrix using SSRS.

Environment: Windows, IIS, MS SQL Server, Office, Visual Studio, Database Engine Tuning Advisor, SQL Server Management Studio, SSIS, SSRS.

Confidential, Westlake, TX

MS SQL Server SSRS/SSIS/SSAS Developer

Responsibilities:

• Created SQL Server Reports using SSRS.
• Identified the Data Sources and defined them to build the Data Source Views.
• Developed Query for generating drill down/drill through reports in SSRS.
• Used SSAS data mining wizard to do the market timing.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance
• Identified and worked with Parameters (e.g. cascading parameters) for parameterized reports in SSRS.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Developed, monitored and deployed SSIS packages.
• Used most of the controls and features in SSIS for transforming data from different sources.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Identified and defined Key Performance Indicators (KPIs) in SSAS.
• Used MS Excel (Pivot Table), Reporting Services as Front Viewer and OLAP cubes as backend and provided integration between MS Excel/SSRS and SSAS.
• Extensively involved in the SSAS storage and partitions, Aggregations, calculation of queries with SQL in SSAS.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created various types of reports like Dashboard, Variance, Forecast and client active reports.
• Enhanced reports by using a series of features like Highlighting report values using conditional styles, applying a report template, format report objects, focus the scope of a report using filters for accuracy of the equity rewards and Incentive grants.
• Created Scorecards, Calculated, Analytical reports for sales and Metrics using Metric studio.
• Implemented different types of constraints on the tables.
• Designed and applied entity and attributes description and definition for the models.

Environment: MS SQL Server, BIDS, SSRS, SSIS, SSAS, Windows XP.

Confidential, Minneapolis, MN

SSIS/SSAS/SSRS Developer

Responsibilities:

• Worked as part of a team for gathering and analyzing Business Requirements
• Participated actively in designing the system database structure
• Performed performance tuning of stored procedures using SQL Server Profiler
• Involved in the development of custom stored procedures, functions.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes
• Designed Data-Mart for Prescription using Relational Model and wrote SSIS Packages to extract data from the old PDX system and load it into the new data mart of SQL Server.
• Designed SSIS packages to migrate the data from PDX files to the Staging Area in SQL server.
• Developed SSIS Packages for migrating data from Staging Area of SQL Server 2005 to SQL Server 2008.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages
• Installed and administered Microsoft SQL Server, SQL Server Integration Services, SQL Server Reporting Services, and Team Foundation Server .
• Built Reports in SSRS for errors generated in SSIS Packages.
• Saved the SSIS Packages and Reports in SourceSafe
• Designed, coded and implemented ad hoc reports using existing report models in SSRS
• Generated Reports using Data Source Views in Report Builder.
• Developed Reports Using SSRS on statistical data during migration of data.
• Created Drill Down, Drill through, linked and sub reports using SSRS.
• Responsible for the creation and the maintenance of Analysis Services objects such as cubes, dimensions and MDX queries.
• Used MDX queries for pre calculated measures.
• Created report Model onSSASCubes as well as changing default configuration on existing Cubes.
• Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.
• Used UML for Design and Documentation.

Environment: SQL Server, T-SQL, Windows XP, Visual Studio, Report Builder, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, Share-Point.

Confidential

MS SQL Server Developer

Responsibilities:

• Created databases for MS SQL Server, MS Access.
• Designed and implemented processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Planned, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers.
• Created Stored Procedures, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Worked with DTS packages.
• Installed and maintained MS SQL Server 2000.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Managed and monitored the use of disk space.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Managed the consistency of the client’s Database using DBCC.
• Planned Backup strategy based on projects requirements.

Environment: MS SQL Server, Excel reports, Windows, Crystal reports, T-SQL.

Confidential

MS SQL Server Developer

Responsibilities:

• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Developed various T-SQL stored procedures, triggers based on the requirement.
• Defined Check constraints, Business Rules, Indexes and Views.
• Involved in tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Imposed Referential Integrity of data by creating different constraints.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS various features like multi tasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion etc.
• Created derived columns from the present columns for the given requirements.
• Performed development support, document reviews, test plan, integration of the system.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).

Environment: T-SQL, SSMS, SSIS, SQL Server, Microsoft Visual Studio, XML, MS Access.