SUMMARY

• 7+ years of experience in Data modeling, database design, Programming, Development and Implementation of Client - Server Applications & Database systems using MS SQL Server 2012/2008/2005.
• Extensive experience in Using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading
• Expert in data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles
• Using Normalization and De-Normalization techniques
• 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)
• Writing heavy stored procedures, Audit triggers views, creating SQL scripts for data loads and Upgrades for data migrations and data validations
• Proficient in Performance Tuning/Query optimization using indexes
• Assisted with automation of manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.
• Tuning the performance of stored procedures and large T-SQL Queries using Clustered indexes, efficient coding standards
• Involved in Backing up databases and refreshing Data across environments
• Huge Data transfers from & to SQL Server Databases using utilities/ tools like DTS, SSIS, BCP, Bulk Insert
• Experienced in whole cycle of DTS/SQL Server Integration services Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL purposes across different servers.
• Involved in usage of various SSIS components like For loop, For-each loop, Fuzzy lookup, Variables, and Error Handling etc.
• Experience in creating master and child packages, package configurations and logging Using SSIS.
• Excellent knowledge of using variables and expressions in packages of SSIS.
• Worked with Flat file, Excel file, and SQL server OLEDB destinations for loading data.
• Involved in handling Enterprise wide reporting needs using SQL Reporting Services, Crystal Reports.
• Creating large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2008/2000/2005.
• Expert in designing reports using SQL Server Reporting Services (SSRS2000/2005), operating and troubleshooting with data sources.
• Expert in developing and deploying cascading parameterized, Drilldown, Adhoc reports with linking sub reports in various file formats with respect to client requirement.
• Experience in writing Queries using SQL Server Analysis Services (SSAS).
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions.
• Vital Knowledge in OLAP Storage modes likes Rolap/ Molap/ Holap.
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• A well-organized, goal-oriented, highly motivated and effective team player with excellent analytical, troubleshooting, and problem solving Skills.
• Excellent Verbal & Written Communication skills and strong in Documentation.
• Flexible, enthusiastic and project oriented with excellent communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

RDBMS: 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: SSRS, SSAS, Crystal Reports, BIRT, Plateau Report Designer.

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook

Management Tools: SharePoint, Team Foundation Suite (TFS), Microsoft Office Communicator.

Languages: T-SQL, MS SQL, MDX, C/C++, Java, VB, VBA, HTML, XML.

Web Technologies: HTML, DHTML, XML.

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

PROFESSIONAL EXPERIENCE

Confidential, Columbia, MD

Report Developer/Conversion Specialist

Responsibilities:

• Analysis, design, development and deployment of about 90+ reports using SSRS, Crystal reports and visual studio 2003 for various modules involved in CRM for members package.
• Converting client’s legacy databases to CRM4M using Scribe, SSIS and Crystal reports.
• Analysis and design of data conversion processes for several clients.
• Developed Reports for Membership dues, Committee, Accounting, subscription, Fund Raising, Product sales, Advertising module and etc.
• Created Tabular, Matrix/Cross-Tab, Sub-Reports, Chart, Mailing Labels and Badges/Multi-Column Reports
• Used File DSN, System DSN to access data from SQL Server database
• Used SQL Expressions in Crystal Developer 9/10, and visual basic script in SQL reporting Service
• Deployed Reports into Crystal Enterprise Server, Crystal Enterprise Embedded Server and SQL Server Reporting Services
• Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.
• Developed SSIS packages for extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Created Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Configured Reporting Services in SQL Server 2008.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Creating temporary Cubes using SSAS to translate legacy systems data per client’s requirement.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Created Views to reduce database complexities for the end users.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Created checks and constraints to maintain data integrity.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment: Windows2003 Advanced Server, MS SQL Server 2005/2008, TSQL, Visual Studio 2008,Oracle, SSRS, SSIS, Erwin.

Confidential

SQL Server/BI Developer

Responsibilities:

• Created new tables, wrote stored procedures and user defined functions for application developers.
• Created Triggers to enforce data and referential integrity and defined Check constraints, Business Rules, Indexes, and Views.
• Implemented transactions and roll back operations in stored procedures.
• Performed data conversion from flat file into a normalized database structure.
• Created and deployed new SSIS packages to extract data from legacy to SQL Server Objects. Implemented BCP for bulk inserts.
• Created various connection managers (OLE DB connection, flat file connection, ADO.NET connection, Analysis Services connection, Excel connection) available in SSIS to collect data from heterogeneous sources such as Oracle, SQL Server, flat files, excel.
• Developed SSIS Packages using fuzzy lookup transformation, file system task, for each loop container.
• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Created ETL packages (dtsx files) to validate, extract, transform and load data to OLTP databases.
• Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
• Prepared and implemented data verification for ETL routines to make sure that they don't break on heavy loads.
• Designed ETL package, with ETL Import/Export wizard for transferring data.
• Data migration (Import & Export - BCP) from text to SQL Server.
• Used Fuzzy Lookup and Fuzzy Grouping transformations to achieve higher degree ofcontrol over the data cleansing process such as standardizing data, correcting data, and providing missing values.
• Created Xml Configuration file.
• Deployed Packages in the file System.

Environment: T-SQL, MS SQL Server Management Studio 2008/2005, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).

Confidential, TX

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Understanding the report design Requirements and Constraints.
• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Performing query plans and making sure each and every query is using appropriate useful Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).
• Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role membership.
• Created scorecards with executive summary dashboards using MS Office Performance point server 2007 Dashboard designer that display performance monitoring measures.
• Designed and developed Datamart using SSAS.
• Build Cubes on Enterprise Date Warehouse (EDW).
• Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
• Performed DBCC checks and fixing data corruption in Application databases.
• Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe.

Confidential

SQL server Developer/SSIS/SSRS/DBA

Responsibilities:

• Wrote complex stored procedures, User Defined Functions, Triggers using T-SQL.
• Created DTS packages for data transfer between the two environments.
• Security issues related to logins, database users, and application roles and linked servers.
• Performance tuning of SQL queries and stored procedures using SQL profiler and Index tuning advisor.
• Administered of all SQL server database objects, logins, users and permissions in each registered server.
• Resolved any deadlocks issues with Databases/Servers on a real-time basis.
• Wrote scripts for generating Daily Backup Report, verifying completion of all routine backups, log space utilization monitoring etc.
• Generated reports in SQL Server Reporting Services (SSRS) using table control, matrix control for cross tab reports.
• Developed Tabular, Drilldown, Parameterized, Charts, Sub-Reports using SSRS.
• Defined Report Layouts for the report design as per the need.
• Installed SSRS, Configured the Report Server and Deployed Reports.

Environment: MS SQL Server 2005, MS SQL Server 2000, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS Access, SQL Server Configuration Utility, SQL Query Manager, MS Visual SourceSafe, Windows XP, Query Analyzer.

Confidential

Jr.SQL Server Developer

Responsibilities:

• Upgraded the SQL Server 2000 databases to SQL Server 2005.
• Developed T-SQL Queries, Triggers, Functions and Stored Procedures.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Used SQL Analyzer and Profiler analyzing the SQL statements and procedures.
• Created Schema Objects such as tables, views, maintained referential integrity and granted roles to the Users.
• Developed internal reports using SSRS.
• Created different Data sources and Datasets for the reports.
• Created views to restrict access to data in a table for security.
• Trained a team of junior developers.
• Created detailed technical documentation.

Environment: SQL Server 2000/2005 Enterprise Manager, SSMS, Windows Enterprise Server 2003, SQL Query Analyzer, IIS 6.0 OLAP, VB.NET, .NET, HTML, Erwin.