SUMMARY

• Over 8 years of experience as a MS SQL Server Developer working on large - scale enterprise and performance critical applications. Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server 2008. Experienced with VB6, VB.NET 1.1, 3.0 3.5 and ADO.NET 2003.
• Extensively worked on Change Data Capture. Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger coding, testing, debugging and installing to support client server and software applications.
• Expert in using BI tools SSIS, SSRS and SSAS in MS SQL server 2005 and 2008; MS Access. Involved in the Logical Design of the Database transforming it into a Physical Design. Performed Data Modeling using Erwin. Experienced in supporting a team of application developers for their .NET database application.
• Transformed data from various data sources using OLE DB and ODBC connections.
• Experienced in SQL Development in the .NET environment especially with CLR Stored Procedures. Well experienced with DTS, BCP and Jobs for MS SQL SERVER.
• Experience with batch, database, real-time, flat-file, Oracle, XML files, CSV files data load and dynamic data migration methodologies.
• Expert in the Installation of Analysis Services in MS SQL SERVER 2000.
• Exceptional Computer Science background with programming skills in VB6 VB.NET as a Junior Programmer. Excellent knowledge of development in OLTP and OLAP environment, dynamic OLAP, multi-dimensional data structures MOLAP and HOLAP.
• Expert in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes.
• Worked extensively on system analysis, design, development, testing and implementation of various projects. Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation.
• Self-Motivated and possess the ability for critical thinking, analysis, good interpersonal and communications skills. Technically motivated and creative.
• User oriented with a desire to learn client's business requirements.
• Excellent knowledge of health care, finance, manufacturing, sales and insurance industry applications. Ability to work excellently as an individual and also as a proactive team member with minimum amount of supervision.

TECHNICAL SKILLS

• MS SQL Server 6.5 2008
• SSIS
• SSAS
• SSRS
• MS Access
• DOS
• Windows NT 98 ME 2000 XP Vista
• Advanced Server 2003 My-SQL
• VB 6
• VB.NET
• ADO.NET
• MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Radnor, PA

Sr. MS SQL Server / BI Developer

Responsibilities:

• Worked with business users to understand their business processes, gathered and documented project requirements and translated them into functional and non-functional specifications for BI reports and applications.
• Provided leadership and technical guidance to identify system deficiencies, analyzed problems and solutions to conclude and implement corrective action.
• Designed and optimized dimensional data models for data marts to support reporting infrastructure.
• Identified data quality issues and supported the data governance initiative by participating in necessary activities including data profiling.
• Identified project risks and impediments, notified management, and proactively worked with other members of the team to complete assigned tasks as defined by project scope and timelines.
• Worked with developers to provide support for development related issues that came up during implementation.
• Developed complex joins to implement data manipulation tasks and data selection from database.
• Participated in evaluating and analyzing the relational database management systems, utilities and tools offered by BI applications and tools vendors.
• Involved in the development of custom SQL, T-SQL, custom stored procedures, functions and triggers.
• Worked on the analysis and implementation of new functionalities that can be brought into the Target from other source systems.
• Worked on Data Transformation Activities using SSIS Import/ Export for transferring data between different Data Sources to SQL Server 2008 using ETL Concepts.
• Created and maintained accurate and complete documentation for all tasks performed.
• Identified the database tables for defining the queries and datasets for report generation.
• Worked on Source to Target Mappings (STM) for creating the successful ETL logic rule for transforming data from various sources.
• Used ERWIN for designing database models and system analysis.
• Analyzed various source systems for transferring data and to maintain the data compatibility.

Environment: Visual Studio 2008,Microsoft Visual Studio Team Explorer 2008, Windows 2005 Server, MS-SQL 2008/2005, Enterprise Manager, SQL Integration Services, SQL Reporting Services, Erwin Data Modeler 4.1/4.0.

Confidential, Hartford, CT

Sr. MS SQL Server SSRS SSIS Developer

Responsibilities:

• Gathered user requirements for analysis and design of software solution and database.
• Involved in gathering database objects using JavaScript.
• Involved in designing an OLAP with the help of Erwin to visualize data structure.
• Extracted and reviewed data from heterogeneous sources (Oracle Database, text files, Excel and Access Files) from OLTP to OLAP using SQL Server Integration Services (SSIS) 2005.
• Created SQL Server Analysis Projects and created Multi-Dimensional databases, OLAP cubes and dimensions for the analysis of sales using SSAS.
• Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Involved in development of T-SQL statements using dynamically generated SQL.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Created and modified cube partitions to optimize the query performance of the cubes.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS 2005.
• Involved in development of MDX expressions for cube calculations and KPIs(Key Performance Indicators)
• Used Visual Source Safe to provide locking and sharing support for files to be shared among multi users.
• Generated daily, weekly and monthly reports using SSRS 2005.
• Defined d relationships with the measure groups and fact tables.
• Implemented the calculations to aggregate physical measures using management studio.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Extensively used Profiler to identify and repair database lockups, deadlocks.
• Established a sound backup and recovery policies and procedures.
• Updated functional specification and technical design documents.
• Configured oracle applications to meet client business process requirements, created custom oracle documentation.
• Involved in data retrieval from oracle database using PL/SQL.

Environment: MS SQL Server 2005 Enterprise Edition, SSAS, SSRS, SSIS, DTS, T-SQL,PL/SQL, JavaScript, VB Script, MS Visual Source Safe, Oracle, Windows Server 2003, Erwin 4.0, Excel, MS Access.

Confidential, Hayward, CA

MS SQL Server SSRS SSIS Developer

Responsibilities:

• Extensively involved in the full lifecycle of ETL software development-analysis, design, building, documentation and testing for the project using SQL Server Integration services.
• Designed and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server integration services (SSIS).
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence container and Conditional split, Data conversion, Derived column and Multi casting.
• Scheduled the jobs to streamline and automate cumbersome repeated tasks using SSIS.
• Involved in all phases of System Development Life Cycle (SDLC).
• Developed, executed and maintained SQL queries scripts and to validate completeness, integrity and accuracy of data.
• Extensively wrote and edited existing Stored Procedures, User Defined Functions and Triggers using T-SQL. Created the Best Coding Practices Document for stored procedures functions for the developers.
• Created new database files and database file groups in SQL Server 2008 using SSMS and T-SQL.
• Configured report server in development and production and also created SQL Server Reports using SSRS 2008 from initial stage.
• Created Sub Reports and Drill down Reports as per the client requirements using SSRS.
• Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Responsible for deploying reports to Report Manager and Troubleshooting for errors occurring in execution. Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing of the reports.
• Transferred data from various OLTP data sources, such as Oracle, Teradata, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008.
• Created and rebuilt multi-dimensional cubes using SSAS to support business reporting and forecasting process. Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Optimized queries by getting insight from Execution Plan for better performance of the database

Environment: MS SQL Server 2008, MS SQL Server Reporting Services 2008, MS SQL Server Integration Services 2008, DTS, SQL Profiler, MS Office, Windows Server 2003

Confidential, Exton, PA

MS SQL Server Developer

Responsibilities:

• Upgraded the server from SQL Server 2000 to SQL Server 2005.
• Migrated databases from MS SQL Server 2000 to MS SQL Server 2005 using Backup and Restore method.
• Created and managed schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions by writing complex Queries and Joins.
• Developed and delivered dynamic reporting solutions using Crystal Reports 4.0.
• Tuned SQL queries using execution plans for better performance.
• Remediated database objects including triggers, stored procedures, functions, user-defined functions,
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes, views and user security management.
• Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation
• Created reports like tabular, matrix, ad-hoc, drill down and drill through reports using SSRS.
• Extensively used Database Tuning Advisor to improve the performance of Query
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: MS SQL Server 2000 Enterprise Edition, SQL Server 2005 Enterprise Edition, Crystal Reports 4.0, ODBC, VBScript, Windows 2000/2003 Server

Confidential, Irving, TX

MS SQL Developer/BI developer

Responsibilities:

• Created Logical and Physical data models using Erwin 4.0 data modeling tool.
• Developed complex Stored Procedures, Functions, DTS (Data Transformation Service) packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Migrated the data from various sources using DTS.
• Scheduled and performed data transfers using DTS including filtering appropriate to the data mart for data analysis.
• Compressed data files by removing empty database pages and updating index statistics.
• Developed and edited many complex reports with Crystal Reports 9.0.
• Designed and implemented user log in and security.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan and worked in Enterprise Manager for job scheduling and batch queries.
• Planned the complete back-up of databases for disaster recovery scenarios.
• Reorganized database structures as needed, automated procedures at regular intervals.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Involved in project planning, scheduling for database module with project managers.

Environment: MS SQL Server 2000 Enterprise Edition, MS Access 2000, DTS, T-SQL, Query Analyzer, BCP, SQL Profiler, Windows 2000 Server, Crystal Reports 9.0