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.
• 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)
• 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 .

TECHNICAL SKILLS

Databases: MSSQL Server 2000/2005/2008/2012 , MS ACCESS.

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development studio, visual studio, Configuration Manager, SQL Server Profiler, SQL Query analyzer, SQL Refractor, SQL Server Agent.

ETL Tools: Data Transformation Services (DTS), SSIS, Pervasive Data Integrator, Import/ export wizard, Bulk Insert, BCP

BI Tools: SSIS, SSRS, SSAS, Crystal Reports, BIRT, Plateau Report Designer.

Modeling Tools: FACT and Dimension table modeling

Management Tool: SharePoint, Team Foundation Suite (TFS), Microsoft Office

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

Web Technologies: HTML, Share point, Visual studio, XML.

O/S: Windows 2008/2007/2003/2000/ NT Servers, XP, Vista, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

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
• Dealing with large data movements and Guard clauses which stops making changes to the migration script if it doesn't need to run.
• 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, Minneapolis, MN

MS SQL Server / SSIS/SSAS/SSRS 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.
• 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.
• 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.
• Documented different stages of data transformation, procedures and scripts.
• 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, 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.