SUMMARY

• 7+ years of experience in analyzing, designing, and developing Client/Server, Business Intelligence (BI) database applications using MS SQL Server 2012/2008/2005 , SQL Server Integration, Reporting & Analysis Services. (SSIS, SSRS & SSAS)
• Generating complex Transact SQL (T - SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using the stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs)
• Strong background in a disciplined software development life cycle (SDLC) process and agile methodology with excellent analytical, programming and problem solving skills.
• Extensive expertise in Insurance, Healthcare, Finance, Automobile sectors.
• Tuning the performance of stored procedures and large T-SQL Queries using Clustered indexes, efficient coding standards
• Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Creating SSIS Packages and involved in Package configurations and deployments between Development and Production servers.
• Extensive experience in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2008/2005 with .NET, Import/Export data, Bulk insert and BCP.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MSExcel spreadsheets and Power Pivot.
• Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experienced with aggregation using OLAP analysis services cube.
• Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow changing dimensions (SCD) etc and created various user roles (SSAS).
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Trouble shooting, and Database Objects authorization.
• 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
• Proficient in implementing surrogate key generation strategy in the Data warehouse.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Extensively experienced in database activities like Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.
• Organized professional with excellent oral and written communication skills, excellent presentation, interpersonal skills, problem solving skills, quick learner and also adept quickly new technology with ability to take new roles in minimum time and little training.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008 R2, MS Access

Languages: T-SQL, SQL, C,C#, XML, HTML, ASP.NET,XSLT

Web Servers: IIS,MS Office SharePoint Server

Tools: /Utilities: SQL Server Management Studio(SSMS), Query Analyzer, SQL Profiler, Business Intelligence Development studio BIDS, DTS, Analysis Manager, SSIS, SSRS, SSAS, Visual Studio 2008/2010, Report Builder, Web Services

Reporting Services: SQL Server Reporting Services 2010, Crystal Reports

Data Modeling Tools: MS Visio 2007/2003

Version Control Tools: Team Foundation Server(TFS), Visual Source Safe(VSS)

ETL Tools: SSIS, Pervasive Data Integrator, Import/export wizard, Bulk insert, BCP

PROFESSIONAL EXPERIENCE

Confidential, Framingham, MA

MS SQL Server/SSRS/SSAS/SSIS Developer

Responsibilities:

• Worked on full life cycle development (SDLC) involving in all stages of development.
• Created database objects including Schemas, complex stored procedures, User defined functions, Tables, Views, Indexes, SQL joins, Constrains and SSIS packages.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Tuning the Store Procedures when needed, creating indexes, Hash Join, etc. so that the report execution time is minimized.
• Created Dynamic ETL SSIS Packages to validate, extract, transform and load data from different sources like Data Secured layer (DSL), Web Services, Flat Files to SQL Database.
• Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
• Created Parameterized reports, Cross-Tab reports, Drill down & Summary reports by Using SSRS.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Integrated SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS).
• Worked on Huge Data Transfers from & to SQL Server Databases using SSIS, and also used configuration files for production deployment.
• Used SSIS event handles for exception handling and Send mail tasks to send alert notifications.
• Worked on creating and scheduling SQL agent jobs.
• Created SSIS packages which incrementally load data into data warehouse fact, dimension tables.
• Created procedures to build fact & dimension tables in data mart for multidimensional analysis services
• Designed, tested (unit testing and integration testing) and implemented stored procedures and functions for data processing of huge volume of data.
• Experience in using Visual Studio Team Foundation Server (VSTF) including creating deployment builds.
• Involved in designingParameterized Reportsfor generatingAd-Hocreports as per the client requirements.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2008 Analysis Services(SSAS)

Environment: SQL Server 2012/2008 R2, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), T-SQL, XML, VSTF, MS Excel, MS Access, SharePoint 2010, Visual Studio 2013.

Confidential, Long Beach, CA

MS SQL BI/ETL Developer

Responsibilities:

• Scheduled the packages to run automatically for incremental data and deploy them to their destination servers
• Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
• Understanding the OLAP processing for changing and maintaining the data warehouse, optimizing dimensions, hierarchies and adding aggregations to the cube.
• Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent.
• Developed SQL scripts to insert, update and delete data in MSSQL database tables in OLTP environment.
• Worked in extracting transforming and loading (ETL) data across multiple databases using SSIS packages.
• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Improved data load performance by analyzing database design and query plans.
• Deployedanduploaded the SSRS reportstoReport Manager & SharePoint serverfor the end users and involved in enhancements and modifications.
• Performed changes in the schema of the proposed database as required and informed those changes to the application development team.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Created and Configured OLAP cubes (star schema and Snow flake schema) using SQL Server 2008 Analysis Services (SSAS).
• Used Change Data Capture (CDC) to simplify ETL in data warehouse applications.
• Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful clustered index and non-clustered indexes.

Environment: SQL Server 2005(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), Crystal Reports 8.0, XML, ASP.Net, VB Script.

Confidential, Detroit, MI

MS SQL/ BI Developer

Responsibilities:

• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Responsible for Migration of SQL server 2005 to SQL server 2012 by writing migration scripts and a clause that checks whether the migration script is valid for the version of the target database.
• Created and optimized database objects such as views, functions and stored procedures as per requirement.
• Experience in Creating and Updating Clustered and Non Clustered Indexes to keep up the SQL Server Performance
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Using transformations like Derived Column, Conditional Split, Aggregate, Row Count, Lookup, sort and Data Conversion to load data into Data Warehouse.
• Created and deployed new SSIS packages to extract data from legacy to SQL Server Objects. Implemented BCP for bulk inserts.
• Transferred data from various data sources systems including MS Excel, MS Access, flat files to SQL Server using SSIS. Created SSIS packages and scheduled the jobs to run automatically.
• Table renaming, splitting or merging columns and changing the data type or size of the column
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Designed ETL package, with ETL Import/Export wizard for transferring data.
• Data migration (Import & Export - BCP) from text to SQL Server.
• Created complex stored procedures with parameters and generated multi parameterized SSRS reports from them, where the user has a choice to select the parameters.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Converted existing excels based reports and crystal reports to SSRS reports.
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Deployedanduploaded the SSRS reportstoReport Managerfor the end users and involved in enhancements and modifications.
• Improved existing reports performance by using execution log2 and optimized the underlying procedure and queries.

Environment: MS SQL Server 2012/2008/2005 , Visual Studio2012/2010, Windows 7, SSIS, SSRS, Report Builder 3.0, Talend, SQL Profiler, SQL Server Agent, MS Excel, Power Pivot.

Confidential, Columbia, MD

SQL Server SSIS / SSRS Developer

Responsibilities:

• Involved in supporting more than 80 Users for various Reporting and Analytics requirements across multiple Business Units and departments.
• Created Databases, Schemas, Tables, Cluster/Non-Cluster Indexes and various other database objects Wrote Efficient Stored Procedures for the optimal performance of the system
• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data
• Debugging / Troubleshooting Stored Procedures, upgrading existing ones.
• Involved in writing multiple reports incorporating business logic and user requirement.
• Developed Complex SSRS Reports involving Sub Reports
• Created large enterprise reports for various Business functionalities assigning report parameters.
• Good Hand on Resolving complex issues and Error Handling in SSIS.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File etc and vice versa.
• Used various control flow tasks like for Loop, execute package/SQL tasks, Script task, send mail task etc and different data flow tasks.
• Worked on SSIS script task, look up transformations, persistent lookups and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints
• Wrote stored procedures for all the Database Interfaces, created user defined functions, constructed triggers, tables, views, indexes and user profiles.
• Involved in Installation, configuration and setting of Database servers for various test and development environments including SSRS Installation configuration and administration
• Involved in Security administration, granting permissions, roles and maintain various AD Permissions at database and report levels.
• Interacted with end users and customers and act as functional analyst /development member with various cross functional teams
• Well versed in doing remote support for various levels of customers across different geographical locations.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables

Environment: SQL Server 2005/2008/2012 , Windows Server 2000/2003/2008 , SSRS, SSIS, Excel, Word.

Confidential, Bloomington, IL

MS SQL/BI Developer

Responsibilities:

• Created and updated database objects like Complex stored procedures, joins, tables, User Defined functions (UDF’s) for business logic.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Experience in Creating and Updating Clustered and Non Clustered Indexes to keep up the SQL Server Performance.
• Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, term extraction and data conversion of SQL Server Integration Services (SSIS).
• Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.
• Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
• Used Script task for Data Flow and Error Handling in SSIS.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance in SSRS-2008.
• Used Reporting objects like Tabular, Matrix, Sub Reports, Parameterized reports using SSRS 2008.
• Designed and developed monthly, Bi- Weekly, Tax Reports for our Clients
• Extensively worked in migrating office writer reports to SSRS-2008.
• Participated in Databases Architecture and data modeling design.
• Interacted with the Business Admin and gather the requirements and analyzed them.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

Environment: Microsoft SQL Server 2008 R2, T-SQL, SSIS, SSRS, Visual Source Safe, MS Excel, Performance Point Server 2007.

Confidential

Jr. SQL Server Developer

Responsibilities:

• Interacted with Team and 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
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Tuned and Optimized SQL Queries using Execution Plan and SQL 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.