SUMMARY

• Over 6 years of MS SQL Server Development experience in Finance, Manufacturing & Distribution, Telecommunications and Health Insurance domains with expertise in MS SQL Server 2000 and MS SQL Server 2008/2005 and Microsoft’s suite of products like SSIS, SSAS, and SSRS.
• Experienced in Creating, Configuring and Fine - tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008 and MS SQL Server 2005 respectively.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
• Experienced in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2005/2008 (SSRS).
• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008/2005.
• Strong experience in Stored Procedure, Formulated Stored Procedure/TSQL coding, Performance Tuning and Query Optimization.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
• Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).
• Extensive knowledge in developing and implementing Disaster Recovery Model, and Replication Models.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2008, 2005, 2000, 7.0, Oracle9i/10g, MS Access 2007,2010,2013

Business Intelligence: SSIS, SSRS, SSAS

Operating Systems: Windows Server 2008/2003/2000 , Windows Vista, Windows XP, Windows 7.0

Other Tools: SQL Litespeed, Database Tuning Advisor (DTA), MS Visio, Business Intelligence Development Studio (BIDS), SQL Server Profiler, MS Outlook 2007,2010

Languages: C, T-SQL, SQL, PL/SQL, VB.NET, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, ANDOVER, MA

SQL BI Developer

Responsibilities:

• Created stored procedures, cursors, functions and triggers. Testing the application for development, functional and behavior testing. Involved in Creating, evaluating, implementing and maintaining application databases.
• Worked on creating batch files and also worked with Tivoli Job(Tasks) scheduler Citrix to schedule Jobs using the batch files.
• Created Numerous SSIS packages for business Interfaces and Applications. Used various Transformations like Derived Columns, Conditional Split, Data type Transformations, File System Tasks, For Loop Containers etc.
• Created Batch Files, Log files and Configuration files to run SSIS Packages. Worked on Event handling In SSIS Packages.
• Used Expressions and Package configurations, Variables and also parameter mapping in SSIS Execute tasks. Worked with Excel files, Flat files, csv files with SSIS to Import and Export the data into SQLSERVER 2008R2.
• Used Import and Export Wizard Worked with SQL Server 2008 new MERGE statement.
• Created Documentation for steps need to be taken while upgrading the SSIS Packages from SQL server 2005 to SQL server 2008/2012
• Created Design Specification Documentation after Interacting with the Business Users.
• Worked extensively in Query analyzer and profiler for tuning queries using variables for characteristics and query costs.
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
• Involved in SQL Server Reporting Services to support daily operations and managing Web-based Reports, Managing SQL server user’s /NT users.
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked with project manager and technical leads for resolution of technical issues.

Confidential, ANDOVER, MA

BI SQL Developer

Responsibilities:

• Designed SSIS packages to extract data from different sources like SQL server 2008, MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS.
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Data Migration from Flat files, CSV, MS-Access, Excel and OLE DB to SQL Database.
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
• Worked with project manager and technical leads for resolution of technical issues.
• Involved in Query optimization, performance tuning, index creation, Database Backup and restoring the database.
• Worked in Database Security, Replication, and Log shipping activities.
• Validating and Testing of the Database data, SQL codes and application (White box and Black box).
• Created ad Hoc and parameterized various reports using SQL server 2005 reporting Services.
• Created Tabular and Matrix Reports with all aggregate functions and expressions.
• Utilized SSRS reports from different source formats and satisfying clients by representing reports and presentations.
• Created dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.

Environment: MS SQL Server 2005/2008, SQL server reporting Services 2008 R2, SQL Server Integration Services 2008 R2, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, ERWIN, SharePoint.

Confidential, GRAPEVINE, TX

MS SQL Developer/BI Developer

Responsibilities:

• Created Star schema dimension modeling for the data mart using Visio and created dimension and fact tables based on the business requirement.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel table
• Designed SSIS packages to Extract data from different sources like SQL server 2008,MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table
• Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, dashboard and matrix reports.
• Wrote complex SQL queries and stored procedure to create reports using SSRS 2008 from the relational database and OLAP as SSAS 2008 source
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
• Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2008
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports
• Configured the report server and generated the report models for user interactions
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked with project manager and technical leads for resolution of technical issues.

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Confidential, NYC

MS SQL BI Developer

Responsibilities:

• Worked on the complete life cycle of the project from design to implementation
• Translated user requirements into functional and technical requirements in coordination with the Sr. Business Analyst
• Analyzed the business requirement and functional specifications provided by the data specialist
• Responsible for designing and maintaining a wide variety of daily, weekly, and monthly financial and analytical reports used by different departments within the company.
• Responsible for making sure reports are scheduled and delivered in a timely manner
• Designed reports using proper text formatting, report headers and footers, and page size to allow for printable reports.
• Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.
• Created adHoc and parameterized various reports using SQL server 2005 reporting Services with data from SQL Server and MS Access as data sources
• Cleaned the data and created fact and dimension tables, performed calculations required for the reports using SQL Server 2005 environment and accomplished data modeling.
• Involved in Designing and architecture of cubes for building reports using SQL Server Business Intelligence Development Studio to support business reporting and forecasting processes
• Documented the complete data warehouse environment, including all dimension and fact tables, the relationship between SSIS packages and the target tables, which packages were valid and in use, the relationship between the jobs and SSIS packages, and the relationship between the source tables and the OLAP tables used in the SSAS Cube
• Created ad hoc SSRS reports in the test environment for data validation
• Created dynamic Reports from the cube using SSRS 2005, and stored procedures.
• Troubleshoot the deployment of reports in the test and production environment using SSRS

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration Services 2008, SQL Analysis Services 2008,Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN