SUMMARY

• Around 8 years of IT experience in Database Design, Development, Implementation and Administration in SQL Server 2008/2005/2000 and providing ETL/Business Intelligence solutions using Microsoft components.
• Experience using highly complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
• Strong technical knowledge in MS SQL Server development including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Supported team in resolving SQL Reporting services and T - SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Strong understanding of RDBMS concepts and Data Modeling Concepts.
• Experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data management, data dictionaries, and data integrity.
• Experience with production, development, and test databases including access controlling, performance monitoring and tuning, capacity planning.
• Extensive experience in ETL design/development using MS DTS and SSIS including data extraction and transformation between multiple data sources (Oracle, MS Access, and MS Excel).
• Experience in Creating and Deployment and Administration of SSIS and SSRS packages.
• Experienced in report generation using SQL Server Reporting Services (SSRS) and Excel spreadsheet.
• Experience in generating drill down Reports, handling parameterized Reports in SSRS 2005.
• SQL Server 2005 OLAP Database Development including KPIs, Data mining, working with changing dimensions.
• Experience of Bulk Insert, BCP utilities and scripts for data transforming and loading.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience with software development life cycle (SDLC) and project management methodologies.
• Excellent communication and interpersonal skills, self motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL,.Net(C#,VB)

SQL Server Tools: BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS, SSAS, Index Analyzer

Databases: SQL Server 2008R 2/2008/2005/2000, MS Access

Operating Systems: Windows Server 2008/2003/2000

ETL Tools: DTS, SSIS, BCP, Import/Export Wizard, BI Studio

OLAP Tools: SSAS, MS Excel

Reporting Tools: SSRS, MS Excel

Business Tools: Word, Excel, PowerPoint, Access, Outlook.

PROFESSIONAL EXPERIENCE

Confidential, Montvale, NJ

SQL Server SSIS/SSRS Developer

Responsibilities:

• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Access, MS Excel and Flat Files and Oracle databases.
• Designed and developed Complex SSIS packages for auditing using SQL SERVER 2008 Integration Services (SSIS).
• Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Conversion etc.
• Worked with different Control Flow elements like For Loop Container, For each Loop Container etc.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Involved in Maintenance and Deployment of SSIS Packages.
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
• Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2008
• Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
• Used Query Analyzer, Index Wizard, DB Engine Tuning and SQL Profiler for performance tuning.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Created Complex Stored Procedures and automated them using SQL Server Agent.
• Created Triggers (Instead Of and After) for Auditing Purpose.
• Created Views and Indexed Views for the Performance Tuning.
• Created automated T-SQL scripts to process summary database transactions that run off-hours.
• Created Linked Servers to retrieve data from other databases.
• Monitored and modified Performance using execution plans and Index Tuning.
• Involved in preparing detailed technical documents.
• Involved in code review and preparing unit test cases.

Environment: MS SQL Server Management Studio 2005/2008, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS),MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe, SharePoint MOSS, Oracle9i, XML, ASP.Net, Windows 2003/2000.

Confidential, Charlotte, North Carolina

SQL Server SSRS/SSIS Developer

Responsibilities:

• Developed indexed views, complex stored procedures, CTE’s, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Monitoring execution plans to enhance the performance of the queries.
• Created complex SQL codes using Views, temporary tables, triggers and stored Procedures.
• Performed tuning of T-SQL procedures, triggers and other database objects.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2005 and develops unit test SSIS load processes for performance check.
• Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005)
• Involved in migration and Conversion of Reports from SSRS .
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL BI Suite (SSIS, SSAS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Business Objects, SharePoint, MOSS 2007

Confidential, Atlanta, GA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Used highly complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
• Used SQL profiler and Execution Plan to view index performance and thereby eliminate table scan.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business.
• Assisted project manager in project planning schedule for database module.
• Involved in upgrading the instance of development environment of SQL Server 2000 service to SQL Server 2005 with latest service pack.
• Extracted data fromOLTPtoOLAPusingSSISusing complex data transformations.
• Developed packages for getting data from SQL Server, Flat files and MS Access data of Sales, Returns and Employee.
• Developed the SQL Server Integration Services (SSIS) packages to transform data fromSQL 2000toMS SQL Server 2005as well as created interface stored procedures used inSSISto load/transform data to the database.
• Successfully created Snapshots Report, Report Subscription, Data Driven Subscription and Report caching using Report Manager
• DTS used to load data from extracts coming from Mainframe systems
• Worked with Dynamic SQL, and developed procedures utilizing the functionality.

Environment: MS SQL Server 2000/2005, DTS, MS Access, SQL Query Analyzer, MS SQL ServerIntegrated Services and MS SQL Server Reporting Services, TSQL, PL/SQL,SQL Profiler, Windows XP/ NT / 2000/2003, Microsoft Excel.

Confidential, San Antonio, TX

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008
• Involved in Performance tuning of ETL transformations, data validations and stored procedures
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
• Scheduled tasks to run every day to update changes in the base tables
• Designed and developed various types of reports using SSRS
• Worked on formatting SSRS reports using the Global variables and expressions
• Created parameterized reports, Drill down and Drill through reports using SSRS
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications
• Published reports on to Share-Pointandcreated Web Parts in Share-Pointto show various reports generated fromExcel andSSRSin one Page.

Environment: Microsoft SQL Server 2005/2008, Windows Server 2003, Windows XP, Microsoft Visio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS).

Confidential, Chicago, IL

Database Developer

Responsibilities:

• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Migration of databases from MS SQL Server 7.0 to MS SQL Server 2000.
• Involved in Data modeling to develop the database design using Erwin 4.0
• Installation and configuration of MS SQL Server on Windows 2000/2003 Server.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Scheduling transfer of backups and log files to different servers.
• Creation of schema objects, rules and granting of roles to the users.
• Testing and implementing Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans.

Environment: SQL Server 2000/2005, Oracle 9i, Query Analyzer, SQL Profiler, DTS, HTML, T-SQL, PL/SQL, Erwin 4.0, Windows Server 2000/2003, UNIX.