SUMMARY

• Over 8 years of strong experience with demonstrated success in the Database design, development and deployment of large - scale enterprise applications.
• Expert in MS SQL Server 2012/2008R 2/2008/2005/2000 suite of products like SSRS, SSAS, and SSIS.
• Good knowledge in Data integration using ETL tools like SSIS (Microsoft BIDS) and Informatica.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, Flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union
• Extensive knowledge in T-SQL queries (DDL and DML).
• Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using MSSQL Server 2000/ 2005/2008/2008 R2/2012.
• Experience in Creating Jobs, Alerts, SQL Server Agent, and Scheduled SSIS Packages.
• Experience with Ad-Hoc reporting using Report Builder in SSRS for daily Reports
• Good knowledge in healthcare domain claim adjudication rules and provider matching and member matching rules.
• Experience in healthcare applications like FACETS data model and FACETS online claim processing.
• Expertise in using Team Foundation Server (TFS) and Visual Source Safe (VSS) as a tool for repository of codes and version control, branching and merging into productionOLTP Experience
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization and Data Modeling.
• Worked with DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.
• Extensive knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities
• Created and managed Indexes and optimized queries using query execution plan.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.Stored Procedures, Functions, Views and Cursors
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in using T-SQL in SQL Server 2000/ 2005/2008/2008 R2 platform
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins.
• Experience in using Try Catch block for error handling in SQL introduced in SQL Server 2005.BI (OLAP) ExperienceReporting Services (SSRS 2005/2008/2008 R2)
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports, Matrix reports and Charts.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Experienceingenerating on-demand and scheduledreportsfor business analysis or management decision using SQL Server Reporting Services.
• Experience in Integrating SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS).
• Integration of SSRS Reports using various web parts into SharePoint and various delivery mechanismsIntegration Services (DTS/ETL/SSIS 2005/2008/2008 R2/2012)
• Extensive knowledge in ETL Process &Progressive knowledge in using DTS/ETL/SSIS utilities
• Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
• Involved in migration of DTS/ETL Packages (2000) to SSIS (2005/2008) and troubleshoot migration issues.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle to MS SQL Server by using Import Export Wizard, DTS/ETL SSIS, BCP & Bulk Insert utilities
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.Analysis Services (SSAS 2005/2008/2008 R2)
• Good Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc. and created various user roles.
• Created simple SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created Dashboard pages in Performance Point Server that use different types of web parts and excel services for reports.

TECHNICAL SKILLS

SQL Server/BI Tools: SQL Profiler, Query Analyzer, BIDS, Export & Import (DTS), SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS), DTSX, TFS (Team Foundation Server)

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

Languages: C, T-SQL, Visual Basic 6.0, HTML, XML

Tools: Visual Studio 2005/2008/2010 , Erwin 7.2

Application Packages: MS Office, MOSS 2007, PPS 2007

Operating Systems: Windows 2000/NT/XP, UNIX, Windows Server 2003Architecture RDBMS, OLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential, OR

SQL Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS) and Crystal Report.
• Developed various types of reports like Drill Down, Drill through, Crystal Report.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers and functions
• Involved in using Team Foundation Server (TFS) to check in and check out SSRS reports and SSIS packages.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Conducted data import and export operations using the DTS wizard.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Views, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Database and Transaction log backups & restoration, backing up user databases and restoring them whenever necessary.
• Developed T-SQL Queries and Stored Procedures, Triggers, Views and Adding/Changing Tables for data load and transformation, and data extraction for processing business logic in the database
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible

Environment: MS SQL Server 2012/2008R2, MS Visual Studio 2012, MS Azure, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), XML, T SQL, SQL *Profiler, XML, Erwin r7, DTS and Team Foundation Server (TFS), Windows.

Confidential, Glen Burnie, Maryland

Sr. SQL Server BI Developer

Responsibilities:

• Developed stored procedures and adding/changing tables for data load and transformation and data extraction.
• Performed performance tuning to optimize SQL queries using query analyzer.
• Implemented custom error handling in SQL stored procedures using Try catch block, transactions and RAISERROR.
• Developed SSIS packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to users.
• Worked in data extraction, transformation and loading into staging tables validate the records on staging tables and load into data mart.
• Implemented different types of constraints on tables.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Performed Unit Testing and system integration testing on the completion of development and deploying into production environment.
• Documented of all processes involved in maintaining the database for future .

Environment: MS SQL Server 2008/2008 R2, OLTP, Visual Studio 2008/2010, Windows 2007, T-SQL, SSIS

Confidential, Denver, Colorado

Sr. SQL Server BI Developer

Responsibilities:

• Worked extensively on FACETS 5.01 data base and gained good knowledge on FACETS data model.
• Created data mappings to load and transform the data from XML, Flat files, and CSV files. Extracted data into delimited files and fixed width files.
• Developed ETL packages using multiple data sources and data destinations (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS transformations.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Worked on EDI 837 and 835 files.
• Worked on custom claim table’s data modeling.
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Extensively worked with SVN tortoise and TFS to keep track of all changes made in the project.
• Provided documentation about database/data warehouse structures and Updated functional specification, technical design documents and Unit test cases.
• Created and deployed reports using SQL Server Reporting Services 2008R2 (SSRS).
• Created Parameterized, Ad hoc and drill down reports using Report Designer.
• Used various report items like tables, sub report and charts to develop the reports in SSRS 2008R2.

Environment: FACETS 5.01, MS SQL Server 2008/2008 R2, OLAP, ROLAP, Visual Studio 2008/2010, Windows 2007, T-SQL, XML, SSRS, SSIS

Confidential, Topeka, Kansas

Sr. SQL Server BI Developer

Responsibilities:

• Created and maintained database objects, complex Stored Procedures, Triggers, Cursors, and Tables, Views and SQL joins and other statements for various applications.
• Performance tuning of the stored procedures, User defined functions and long running queries.
• Automated the ETL to import and export data form text/ Excel file, in different format, to SQL Server and vice versa using SSIS.
• Analyzed and designed business processes as per the business requirements with SSRS reports
• Created various dynamic reports using SSRS and Crystal reports.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis(SSAS) and used the SSAS as source for generating parameterized reports in SSRS.
• Used ROLAP tools to access the data in arelational database and generateSQLqueries to calculate information at the appropriate level when an end user requests it.
• Created reports and Data access from MDX and OLAP.
• Created SSIS Packages to pull data from Online Database Server to Data-warehouse Server.
• Performed administration tasks of Database Mirroring, database backups and restore servers in SQL Server 2005.

Environment: MS SQL Server 2005/2008, OLAP, ROLAP, Visual Studio 2005/2008, Windows 2007, Windows XP, T-SQL, XML, Crystal Reports, SSAS, SSRS, SSIS.

Confidential, Mt. Laurel, NJ

MS SQL / BI Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
• Created linked, unlinked and on-demand sub Reports.
• Understood the various complex reporting requirements of company and created web reports using Reporting Services.
• Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Modified report content and exported reports in multiple formats based on user input.
• Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
• Created User Defined functions for sharing formulas across multiple reports.
• Modified existing reports according to requirements of the end users.
• Gathered business requirements from customers and created status reports.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL.

Confidential, OH

SQL Server BI Developer

Responsibilities:

• Determined the MS SQL Server 2008 installation options. Installed SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server and implemented different security modes.
• Installed and maintained database applications to improve processing performance including applying upgrades, patches, and bug fixes in all database instances
• Analyzed and designed new business processes.
• Implemented a successful security plan by creating statement permissions, linked servers and encryption of connections by creating s.
• Assisted in generating business process flows, functional design documents and test plans.
• Developed ETL Packages in SSIS to transform data to MS SQL Server from Excel for further analysis.
• Configured Database Mail, created operators, jobs and alerts for automating databases.
• Designed ETL package, with ETL Import/Export wizard for transferring data using Informatica
• Data migration (Import & Export - BCP) from text to SQL Server.
• Applied schema change scripts to existing objects to synchronize with changing business rules by adding or enhancing relevant entities/tables, columns etc.
• Implemented database consistency and security by creating groups, roles, users, and triggers on views

Environment: T-SQL, MS SQL Server 2008, MS Access 2008 MS-BI 2008, Data Warehouse (OLAP, ROLAP, MOLAP), Reporting Services, Crystal Report 8.0, ETL (SSIS, Informatica).

Confidential

SQL Server Developer

Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram, involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.