SUMMARY

• Over 7 years of IT experience in Database Development of MS SQL Servers 2000/2005/2008 , in Production, QA, and Development environments Extensive IT Professional experience with expertise in Database Development, Modelling, Data Warehousing, Design and Technical management.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Sound knowledge of software development life cycle (SDLC) with solid experience along with object oriented analysis and design methodologies
• Experience in writing complex SQL queries involving multiple tables inner and outer joins.
• Experience in developing, monitoring, extracting and transforming data using SSIS, Import Export Wizard, and Bulk Insert.
• Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Worked Extensively on ETL process using SSIS packages.
• Involved in designing DTS/SSIS Packages to extract, load data into database, archive data file from different legacy systems and Data Mining in SSIS.
• Experience in writing reports using SQL Server Reporting Services (SSRS).
• Extensive experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008.
• Experience in creating Ad - hoc reports, data driven subscription reports by using Report Builder in SSRS and ability to export reports and query results to Excel or PDF.
• Hands on experience in installing, configuring, managing and troubleshooting SQL Server.
• Experience in database development, for creating complex database queries, Indexes, Views, Stored Procedures and Triggers in SQL Server.
• Experience in using T-SQL with good knowledge on Performance Tuning and Query Optimization techniques.
• Strong Communication & Management skills with Excellent Role playing capabilities.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Ability to handle projects independently and able to work proactively within team environment
• Exceptional ability to quickly master new technologies and capable of working in-group as well as independently
• Strong analytical skills and ability to create and maintain a database environment to support business requirements.

TECHNICAL SKILLS

Databases: MS-SQL Server 2000/2005/2008 /2012

Operating Systems: Windows 2008/2007/2000/ NT/ XP/ Vista/98/ 95, DOS, Windows 2003/2008 server.

Technologies: Object-Oriented Design/Development, ADO.Net, NET Framework 2.0, 3.0, 3.5

Development Tools: Visual Studio 2005/2008, MS SQL Server 2000/2003/2005/2008 , MDS, MS Visio, Microsoft SQL Server Integration Services 2008(SSIS)

ETL tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Reporting Tools: Microsoft SQL Server Reporting Services 2005/2008/2012

Version Control: MS-Visual Source Safe, Team Foundation Server.

PROFESSIONAL EXPERIENCE

Confidential, AZ

SQL/BI Developer

Responsibilities:

• Understanding and converting business requirements into functional requirements doc, review and sign off with the customer.
• Extensively involved in designing the SSIS packages to export data of flat file, MS Access sources to SQL Server database
• Developed and Optimized Stored Procedures, Views and User-Defined Functions for the Application.
• Created packages using SSIS to migrate data from different data sources to data warehouse.
• Perform Impact analysis and provide optimal solutions to the Client, Business users.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, execute package task, Transfer database task, for loop & foreach loop containers.
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data.
• Conducting User Acceptance Testing, bug triages, Signoff meetings.
• Developing performance tuning and enhancement approaches to improve overall system performance and provide value add to the customer.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized Reports.
• Created well-formed reports and web-based reports for financial applications.

Environment: SSIS, SSRS, SQL Server 2008/2012, T-SQL, Windows XP, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Server Profiler, XML.

Confidential, San Diego, CA

SSRS/ SSIS Developer

Responsibilities:

• Installation and configuration of SQL Server 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports,
• Drilled through Reports using stored procedures using Sql Server Reporting Services 2008.
• Experience in creating Adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Involved in scheduling, creating snapshots and subscriptions for the reports. (SSRS 2005/2008).
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience in using C#.Net in script Task while creating SSIS Packages.
• 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 in 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 into SQL Server 2005 database using SSIS package.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003.

Confidential, Stamford, CT

SQL Server/MS BI Developer

Responsibilities:

• Responsible for providing 24x7 Production support, Database and Log Backups & restoration, Backup strategies and scheduling Backups.
• Gathered functional requirements, analyzing and writing the technical specifications.
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Fine tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2000/2005 Analysis Services (SSAS) and Reporting service (SSRS
• Experience in debugging Stored Procedures using Visual Studio Tool by setting break points.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers (DDL & DML), User Defined Data types and Functions (UDF
• Expertise in Troubleshooting Locking, Blocking, Deadlocking and performance issues with very good understanding in SDLC (Software Development Life Cycle
• Work with App Teams on creating a productive Development, Test and Production environment for App Databases.
• Make recommendations for File group Creation and Placement, Right Data types for the Structures created.
• Developed SSIS Packages for Snapshot, Incremental, Historical Changes (SCD Type 2) Data Loads.
• Experience in query optimization & performance tuning using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Provided back-end support for performance testing and functional testing using use case testing methodologies.

Environment: SQL Server 2005/2008, T-SQL, Windows XP, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Server Profiler, SSRS, SSIS, XML.

Confidential, Riverside, CA

SSIS/SSRS/SSAS/SQL Developer

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages to load data into Sql Server using various transformations in SSIS.
• Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs & deployed cubes.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports.
• Created report snapshots to improve the performance of SSRS.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2005 database and performed tuning on it.

Environment: SQL Server 2005, Windows 2000/2003,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, Visual Studio 2005, Visual Team Foundation Server, Crystal Reports.

Confidential

SQL/BI Developer

Responsibilities:

• Involved in planning, defining and designing data and provided documentation
• Upgraded MS SQL Server 2000 databases to 2005, using detach/attach, backup and recovery and by replication.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs
• Used various SSIS tasks such as conditional split, derived column, which did data scrubbing, including data validation checks during staging, before loading the data into the data warehouse
• Created error and performance reports on SSIS packages, Jobs, stored procedures and triggers.
• Created sub-reports, drilldown-reports, summary reports, and parameterized reports in SSRS
• Generated ad hoc reports using Reporting services and crystal reports
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in SQL Server 2005
• Generated reports using SSRS that could be used to send information to different primary vendors, clients, and managers
• Involved in documentation for all kinds of reports, DTS and SSIS packages
• Designed and implemented stored procedures and triggers for automating tasks
• Maintained the table performance by following the tuning tips like normalization, creating Index and ensured best practices are applied and integrity of data is maintained through security and documentation

Technology: SQL Server 2000/2005, T-SQL, SSRS, SSIS, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio, MS Office.