SUMMARY

• 10 years of experience in Microsoft business intelligence Development under SQL Server environment, with thorough knowledge of SQL Server 2008/2008R2/2012 databases. Experienced in Insurance, Financial, Health Care and banking services.
• Experienced in upgrading SQL Server 2005/2008 to 2008/2012 and data migration among versions.
• Extensive experience in developing and implementing Microsoft SQL Server Integration Services (SSIS), Reporting Services (SSRS), SSAS (analysis services).
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experienced in the complete life cycle of DTS/SQL Server Integration services (SSIS) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL jobs across different servers.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Generating complex Transact SQL (T - SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report designer, report manager and report server.
• Experience in developing reports using Report Builder and used Metadata to define Fact & Dimension tables.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS) generated drill down reports, drill through reports, parameterized reports, Cascaded reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS.
• Working experience of designing Ad-hoc reports for higher managers using report model, providing them flexibility to create reports using drag and drop functionality.
• Developed Cubes using SQL server Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Created Dimensions with the cube wizard and generated named calculations and named queries.
• Microsoft Certified Technology Specialist in SQL Server 2005 and SQL Server 2008.
• Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services (2008/2005/2000 ), MS Access, MS Excel, Crystal Reports, Business Objects4.0

Database: MS SQL Server 2012/2008/2005/2000 , MS Access, Oracle 9i/8i

Programming Languages: T-SQL, PL-SQL, C

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS

Operating Systems: Windows (95/98/2000), Windows 2003/2008 Server, Windows XP, Windows Vista

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash.

PROFESSIONAL EXPERIENCE

Confidential, Mclean, VA

Data Engineer / SQL Developer

Responsibilities:

• Involved in gathering Business Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Installed, configured and maintained SQL Fail over clustering for 2 production environments.
• Involved in Deployment, scheduling and Running SSIS packages on SQL server.
• Experienced in creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in creating database objects including tables, triggers, views, stored procedures, Indexes and Functions.
• Experienced in Build the SSAS Cube and OLAP Data modeling.
• Experienced in working with Dynamic SQL queries at Store procedure.
• Good understanding in Dynamic SQL queries performance Optimization.
• Experienced in using SQL data, SQL Data Generator and schema comparison by using Red gate software.
• Experienced in using SQL ignite to monitor the SQL Database Server Query execution plan and related activities.
• Involved in Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages.
• Involved in Deployment, scheduling and Running SSIS packages on SQL server.
• Involved in writing T-SQL script for databases and tables.
• Involved in Error Handling, Package Logging and Configuration of packages.
• Created database objects including tables, triggers, views, stored procedures, Indexes, and Functions.
• Experienced in creating SSIS packages to import & export data from text files MS SQL Server databases.
• Involved in Deployment, scheduling and Running SSIS packages on SQL server.
• Experienced in database design and implementation. Created and maintain databases after logical and physical database design through Erwin tool.
• Involved in creating package for incremental loading of data from source to destination tables.
• Experienced in working with Report Builder 3.0.and also worked in Linked Reports, sub reports and dynamic Report delivery by using Visual studio Shell 2013- SQL server Data Tool (SSDT BI).
• Involved in upgrading from SQL Server 2000 to SQL Servers 2005 and SQL Server 2008 R2 and test the SQL Server after the upgrade, make sure everything is working fine.
• Experienced in creating Custom and Matrix reports as well Pie charts by SSRS.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Involved in creating database objects including tables, triggers, views, stored procedures, Indexes and Functions.
• Experience in installing SQL Server 2005 and SQL Server 2008 R2 with Applied service packs.
• Installed, configured and maintained Active/ Passive SQL Fail over clustering for production environments.
• Experienced in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.

Environment: MS SQL Server Management Studio 2008 R2, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Microsoft Visual Source Safe.

Confidential, Richmond, VA

Sr. SQL Developer (SSIS/SSRS)

Responsibilities:

• Work closely with business users to congregate and comprehend requirements.
• Preparation of documentation for all the requirements and enhancements to reports.
• Design and develop SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.
• Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source, Oracle and SQL server using SSIS.
• Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Developed SSIS Templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Created cross validation rules to ensure mapping accuracy.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Designing, Creating & maintenance of Reports in SSRS.
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created different chart reports helped in analyzing perform counters using SSRS.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Logical Data Modeling using ER-Win to fit business requirement.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Server 2012 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Coordinating post-implementation events such as testing.

Environment: SQL Server 2008R2/2012, SSIS, SSRS, SSAS, DTS, VSS, VBScript, XHTML, XML, MS Access, Windows 2005/2008 Server, Oracle 11g, IIS5.0, 6.0, 7.0.

Confidential, Washington DC

SQL BI Developer (T-Sql/SSRS/SSIS)

Responsibilities:

• Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development and testing.
• Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Worked extensively on SSIS packages to implement the data load strategy
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Identified the dimension, fact tables and designed the Data-Mart using Star schema.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2012 Analysis Services.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Responsible for Import and export data from various data sources like SQL Server Databases, Flat Files, MS Access, MS Excel and other OLE DB providers achieved through Importing and Export Wizard in SSIS.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012
• Created and Maintained various database in MS Access to track activities and progress.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
• Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus, making them user friendly.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Created and Maintained various database in MS Access to track activities and progress.
• Worked on several complex drilldowns, parameterized reports and on reports that call sub reports using SSRS.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs.
• Optimized the queries by creating various clustered, non-clustered indexes and indexed views
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Provided daily support to the user team as well as technical team for system wide tasks including monitoring, alerting and problem resolution
• Involved in testing, bug fixing and documenting the work for the project at each and every phase

Environment: MS SQL Server 2012/2008/R2, DTS, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), T-SQL, MS-Access, SQL Server Query Analyzer, ETL, Erwin, Red Gate SQL Source Control.

Confidential, Salem NH

MS SQL Server Developer/BI Developer

Responsibilities:

• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, CTE, user profiles, relational database models and data integrity, SQL joins and query writing.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Used MDX (Multi-dimensional Expressions) for the calculated members and the KPI (Key Performance Indicators).
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues. Expert in generating drill down Reports in SSRS 2005/2008/2012.
• Expert in Created/Updated database objects like tables, views, stored procedures, function, packages,
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008R2 Reporting Services (SSRS).
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using MS SQL Server Integration Services (SSIS).
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Adhoc, Matrix Reports, parameterized reports using SSRS.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Leading offshore team in India and client facing skills.

Environment: MS SQL Server 2008R2, T-SQL, Teradata, SQL SSIS, SSRS, SSAS, Windows server 2003 Visual Source Safe, SQL Profiler, Visual Studio 2008, XML, Informatica, Oracle 10g, VB.Net

Confidential

SQL SERVER BI Developer

Responsibilities:

• Highly responsible for development of SSAS Project.
• Developed cubes using SQL Analysis Services 2008 (SSAS) according to the requirements of business users.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Designed custom MDX queries as desired by the end users to make the reports simpler.
• Generated reports from the cubes in MS Excel 2007 & SQL Reporting Services 2008(SSRS).
• Created SSIS Packages using Lookup, Merge, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task and expressions etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file and MS Access, Oracle Servers to different data Marts.
• Involved in pulling out reports using Crystal Reports.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
• Responsible for Process CUBE Partitions and Dimensions.
• Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL.
• Schedule SSIS package for weekly cube refresh.
• Provided Production Support for the cubes moved to production.
• Setup cube security for multiple user, created language translation for
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: MS SQL Server-2008R2 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, SharePoint 2010, Office-2007, MS Excel, MS-Access

Confidential, Glen Allen, VA

Sr. SQL Server BI/ETL Developer

Responsibilities:

• Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.
• Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# and VB code as required
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Experienced in slowly changing dimension in SSIS packages.
• Performed incremental data load packages in SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Identified and Defined Fact relationships in SSAS.
• Created OLAP models based on dimension and facts for efficient loads of data based on star and snowflake schema structures.

Environment: MS SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.