SUMMARY

• Highly motivated SQL server Developer with Six Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2008/2005, SSIS and SSRS.
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2008/2005/2000.
• Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000, DTS, SSIS, SSAS and SSRS 2005/2008.
• Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T - SQL Scripts and Batches.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins.
• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
• Worked Extensively on ETL process using SSIS package.
• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS).
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Excellent in creating SSIS Packages for integrating data

PROFESSIONAL EXPERIENCE

Confidential GA

ETL Developer work with MS SQL/SSIS/SSRS

Responsibilities:

• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning andptimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, datavalidation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulkinsert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu optionusing SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customerrepresentatives for various categories and regions based on business needs using SQL Server Reporting services(SSRS).
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database EngineTuning Wizards.

Environment: SSIS, SSRS, MS SQL Server 2008/2005, Visual studio 2008, MS Access, MS Excel, MS Office Access

Confidential

ETL Developer work with MS SQL Server/SSIS/SSAS

Duties & Responsibilities:

• Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs
• Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.
• Experience with the Share point 2007 to upload the SSIS packages in to Web portal.
• Participated in requirement gathering, cube design, application design, SSAS development, training operational users.
• Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Creating complex cubes for seeing business data from different perspectives by slicing and dicing the data
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Designing and building data load procedures using MS SQL Server.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Configured product meta-data tables to support client data reporting needs.
• Incremental and full database recovery with experience of complex recovery scenarios.
• Performance: Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries.

Confidential

SQL Developer

Duties & Responsibilities:

• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
• Configured and monitored database application.
• Created tables, indexes and constraints.
• Defined stored procedures for module integrity and application.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Managed the use of disk space, memory and connections.
• Designed and implemented several complex reports and administration modules.
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.
• Involved in performance tuning of the database and T-SQL queries using Explain Plan.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
• Prepared of project documentation.
• Prepared test plans for assembly testing & System Integration testing

Confidential

SQL Developer 2010

Duties & Responsibilities:

• Analyzing different user requirements and coming up with specifications for the various database applications
• Developing database applications which are automated
• Planning and implementing capacity expansion in order to ensure that the company’s databases are scalable
• Identifying issues with the database and resolving them
• Installing and configuring the necessary components so as to ensure that the database is accessible
• Diagnosing and resolving database access and checking on performance issues.