PROFESSIONAL SUMMARY:

• 7 years of strong experience Confidential Information technology industry covering all stages of development life cycle including business process analysis, requirements gathering and analysis, high level design, detailed design, development, testing, QA and post implementation support.
• Excellent experience Confidential design, development, implementation and administration of database systems using MS - SQL Server 2008/2005/2000 for both OLTP & Data Warehousing Systems applications Confidential Financial, Wireless and Health industries.
• Extensively experienced Confidential database activities like Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.
• Extensive knowledge Confidential design of logical and physical data modeling using Erwin tool and consistency check using DBCC utilities.
• Adept Confidential RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Stored Procedures, Views, Cursors and Triggers.
• Extensive experience Confidential Data Extraction and Transforming and Loading (ETL) using DTS package Confidential MS SQL Server 2000 and SQL Server Integration Services (SSIS) Confidential MS SQL Server 2008/2005 with .NET, Import/Export data, Bulk insert and BCP.
• Expert Confidential SSIS script transformations using C# Script and scheduling complex SSIS Packages for transferring data automatically from multiple data sources to SQL server.
• Expert Confidential Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Strong experience Confidential creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).
• Experienced Confidential report generation using, XML, MS Access and Excel spreadsheet.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Experienced with aggregation using OLAP analysis services cube.
• Proficient Confidential implementing surrogate key generation strategy Confidential the Data warehouse.
• Experienced Confidential creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
• Organized professional with excellent oral and written communication skills, excellent presentation, interpersonal skills, problem solving skills, fast learner and also adept quickly new technology with ability to take new roles Confidential minimum time and little training.

TECHNICAL SKILLS

Business/Technical Skill: MS SQL Server 2008/2005/2000, T-SQL, SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Agent, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Erwin Data Modeler, MS Visio, SQL Profiler, Bulk Insert, Visual Source Safe Code management tools 6.0., PL/SQL,HTML.

PROFESSIONAL EXPERIENCE

Confidential, IL

Responsibilities:

• Responsible for Deployed the SSIS packages and scheduled the package through Jobs Confidential all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done Confidential the specified tables and created technical specs documents for all the enhancements.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling Confidential SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Imported data from text files and excel spread sheets intoSQL Server2008 database using SSIS package.
• Expertise Confidential Data modeling By Using Erwin.
• Worked with T-SQL to create Tables, Views, and triggers
• Used Script task for Data Flow and Error Handling Confidential SSIS.
• Created/Updated database objects like tables, views, stored procedures, function, packages,
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Involved Confidential table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Involved Confidential setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Designed and developed monthly, quarterly and yearly reports
• Built the SSRS reports from Different Databases like SQL Server.Configured and deployed SSRS reports.

Tools & Technologies: - Microsoft SQL Server 2008R2, T-SQL, SSIS, SSRS, Erwin.

Confidential, Carlstadt, NJ

SQL Server Developer/BI Developer

Responsibilities:

• Responsible for Deployed the SSIS packages and scheduled the package through Jobs Confidential all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done Confidential the specified tables and created technical specs documents for all the enhancements.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling Confidential SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Imported data from text files and excel spread sheets intoSQL Server2008 database using SSIS package.
• Expertise Confidential Data modeling By Using Erwin.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures
• Used Script task for Data Flow and Error Handling Confidential SSIS.
• Created/Updated database objects like tables, views, stored procedures, function, packages,
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports .
• Involved Confidential table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Monitored the overall performance of the database to recommend and initiate actions to
• Improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Involved Confidential setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Involved with .NET as a Front and Developer and Form Designing.
• Report Deploy At SharePoint.

Tools & Technologies: Microsoft SQL Server 2008, T-SQL, SSIS, SSRS,MS-Share Point, Erwin, Windows server 2008, SQL Profiler, Visual Studio 2008

Confidential, Bristol, CT

SQL/ SSRS/SSAS Developer

Responsibilities:

• Involved Confidential creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports usingSQL ServerReporting Services 2005.
• Created ad-hoc reports Using Report Builder 1.0.
• Interacted with the Business Admin and gather the requirements and analyzed.
• Guided with the Project Managers and the Field Managers who would be using the application the most.
• Created and updated complex Stored Procedures, Triggers and User Defined Functions for logical T-SQL implementation.
• designed Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Built the SSRS reports from Different Databases like SQL Server.Configured and deployed SSRS reports.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects
• Involved Confidential Analyzing, designing, building &, testing of OLAP cubes withSSAS2005 and Confidential adding calculations using MDX.
• Created advanced objects like KPI’s and Perspectives.
• UsedSQL ServerAnalysis Services 2005 for interaction between client application and instance of Analysis Services.
• Involved inSSASstorage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Involved Confidential Planning and Monitoring reports Confidential Performance Point Server.
• I Have Worked Closely with My colleagues from India and Lead as off shore team.
• Design And Implement Store Procedure and trigger For automating Task at the same time was coordinating with my team leader closely Confidential order to report the team progress on their following task.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Involved Confidential writing MDX queries for cubes and Performance optimization of MDX queries.
• Actively participated Confidential review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Documented the development work.

Tools & Technologies: - SQL Server2005 Enterprise Edition,SSAS, SSIS, Erwin, T-SQL, SSRS, Windows Server 2003,Performance Point Server 2007, Microsoft .NET framework 3.5.ITS

Confidential, Dallas, TX

SQL Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Developed logical and physical data models for schemas using MS Visio.
• Involved Confidential Planning, Defining and Designing database based on business requirements and provided documentation.
• Installed SQL Server 2005 and Management tools using SQL Server Setup Program.
• Coordinated with DBA Confidential creating and managing tables, indexes, triggers, db links and privileges.
• Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Created SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Handled slowly changing dimensions to maintain the history of the data.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed, Developed and Deployed reports Confidential MS SQL Server environment using SSRS-2005.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored Confidential script.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Involved Confidential preparing training document for application development and QA/UAT teams.
• Involved with .NET as a Front and Developer and Form Designing.

Tools & Technologies: MS SQL Server 2005, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), BIDS, Visual Studio 2005, MS Visio 11.0, Windows NT/2003, Microsoft .NET framework 3.5.

Confidential, Newburgh, NY

MS SQL Server/SSIS Developer

Responsibilities:

• Determined the SQL Server 2005 Installation. Installed SQL Server Management tools using SQL Server 2005 setup program.
• Designing standards for the database table, column, procedure and views.
• Created junked and conformed, degenerative dimension Confidential Data Warehouse environment.
• Generated complex stored procedures and functions to support efficient data storage and manipulation.
• Created Database, creating tables, views, indexes, stored procedures, triggers and constraints.
• Analyzed the requirements and fine tune the stored procedures to improve performance.
• Data transferred between various servers using BCP and Data Transformation Services Confidential SQL Server Integration Services.
• Implemented Data Transformation Services Packages Confidential SQL Server Integration Services (SSIS) for transferring data and Data Loads.
• Involved Confidential writing T-SQL programming for implanting stored procedures and functions for different tasks.
• Involved Confidential Query Optimization using extensive use of Index implementation and Index Tuning Wizard SQL Server 2005.
• Used profiler to find badly performing queries and deadlocks.
• Tuned SQL queries using show plans and execution plans for better performance.
• Resolved various performance issues and running DBCC command.
• Used SSRS to write complex formulas and to query the database different to generate different types of ad-hoc reports.
• Worked on Client/Server tools like SQL Server 2005 Enterprise Manager and Query Analyzer to administer SQL Server 2005.
• Created Database Maintenance Planner for the performance of SQL Server 2005, which covers Database Integrity checks, Database Statistics update.
• Successfully views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Worked on DTS Package Confidential SQL Server Integration Services (SSIS), DTS Import/Export for transferring data from heterogeneous database.
• Generated ad-hoc reports using MS-Access and.

Tools & Technologies: MS SQL Server 2005, T-SQL, MS Excel, MS Access,10.0 and Windows NT, ASP.Net, Visual Basic, SQL Server Integration Services, SQL Server Reporting Services

Confidential, Woodridge, IL

MS SQL Server Developer

Responsibilities:

• Designed, developed, and tested stored procedures, views and complex queries for Reports distribution.
• Developed database triggers and stored procedures using T-SQL cursors and tables.
• Managed all indexing, debugging, optimization and performance tuning using SQL Profiler and SQL Server Agent.
• Created stored procedures for the business logic using T-SQL.
• Performed coding of several database triggers and stored procedures and maintained integrity constraints.
• Designed and developed Data Transformation Process.
• Successfully performed DTS packages and scheduled them.
• Used advanced features of T-SQL Confidential order to design and tune T-SQL to interface with the database and other applications Confidential the most efficient manner.
• Effectively used views to prevent unauthorized access.
• Created numbers of complex formula Confidential sub report using different type of variables likes shared variable and retrieved them from master report.
• Installed and maintained MS SQL Server 2000.
• Built and performed user acceptance testing on new and modified reports.

Tools & Technologies: - MS SQL Server 2000, DTS, T-SQL, Office 2003, SQL Server Query Analyzer

Confidential, Alexandria, VA

MS SQL Server Developer

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• Involved Confidential the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped Confidential integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS).
• Write T-SQL statements for retrieval of data and involved Confidential performance tuning of TSQL queries.
• Managed rollback segments, and table spaces to ensure less space used by the database.
• Created documentation on the all the tables, stored procedures, views and user defined functions.

Tools & Technologies: MS SQL Server 2000, Windows 2000, Erwin, VSS, 8.0