SUMMARY

• Around 8+ years of experience in IT, as MS SQL Server Developer in Windows environment.
• Extensive experience with SQL Server 2012, 2008, 2005 and worked extensively on BI Tools like Integration services (SSIS), Reporting services (SSRS) and Analysis Services (SSAS).
• Expertise in Database design, Entity Normalization & Database Creation, Maintenance, Monitoring.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2012/2008/2005/2000 /7/6.5.
• Expert in using tools like SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Extensive experience in T - SQL (DDL, DML, DCL), Views, Stored Procedures, Cursors and Triggers.
• Experienced in Extraction, Transformation and Loading (ETL) process using Data Transformation Services (DTS), MS-SSIS application tools.
• Experience in creating Configuration files to deploy the SSIS packages across all environments.
• Wide experience in Creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS).
• Expertise in creating OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS.
• Experience in developing management reports using SSRS (SQL Server Reporting Services).
• Strong experience in creating Ad Hoc Reports, Parameterized Reports, Linked Reports, Snapshot Reports, Drilldown and Drill through reports using SQL SSRS.
• Experience in Microsoft SQL 2008/2005 Server migration from SQL Server 2000, Integration Service (SSIS), Reporting Service (SSRS).
• Developed mappings using connected/unconnected lookup, router, joiner, expression, filter, sequence generator transformations.
• Developed packages using lookup, aggregator, Derived Column, Sort and Conditional Split transformations.
• Developed and migrated informatica XML objects across environment
• Excellent understanding and implementation knowledge of Software Development Life Cycle.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.

TECHNICAL SKILLS:

ETL (Extract Transform Load) Tools: SSIS, SQL Server Management studio, SQL Server Business Intelligence development studio (BIDS), Informatica Power Center 9.5/9.1, DTS

Reporting Tools: SSRS, SSAS, Crystal Reports XI, Windows SharePoint Services

Data Modeling: Erwin Tool, MS Excel, MS Visio

Databases: SQL Server 2012/2008/2005/2000 , Oracle 11g\10g\9i.

Tools: & Scheduler’s TOAD, SQL Developer, Informatica Scheduler, Unix Cron Job, Control M Scheduler, Serena Team Track, Quality Center, Rally, Jira (Agile Tools).

Programming: SQL, T-SQL, PL/SQL, Unix Shell Scripting, C, C#, VB

Operating System: Windows 2003/XP/Vista/7, Unix

PROFESSIONAL EXPERIENCE

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.
• 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.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• 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 2008 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.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Data migration (import & export/BCP) from different sources to SQL Server.
• Coordinating post-implementation events such as testing.

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

Confidential

Sr. ETL Developer

Responsibilities:

• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), MS Excel Spreadsheet to SQL Server 2008.
• Designed ETL packages for different data sources (XML, SQL Server, Flat Files).
• Scheduled the DTS package for data migration from legacy system to MS SQL 2005.
• Designed dynamic DTS Packages to transfer data between servers, load data into database, and archived data file from different DBMS.
• Experience in designing and developing Business Intelligence solutions on Operational Data Store (ODS), Global Data Warehouse (EDW), Data Marts / Decision Support Systems
• Converted existing SSIS packages into informatica mapping/Sessions/Workflow.
• Extensively worked on Power Center client tools: Repository Manager, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor to extract, transform and load data.
• Developed mappings using connected/unconnected lookup, router, joiner, expression, filter, sequence generator transformations.
• Developed packages using lookup, aggregator, Derived Column, Sort and Conditional Split transformations.
• Developed and migrated informatica XML objects across environment.
• Performed unit testing during the migration process between SSIS and informatica.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Created Linked-Servers among different operational systems.
• Copied large amounts of data across servers using BCP and DTS.
• Used DTS packages to schedule batch processing of jobs.
• Developed tables, stored procedures, triggers, cursors, views and indexes for the design specifications
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Created Views and Index Views to reduce database complexities for the end users.
• Experience in designing ER diagrams and mapping the data into database objects.
• Using Erwin, Prepared logical data models in support of integrated financial management and reporting requirements.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services (SSAS).
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed Dimensions, Data source views, SSAS Cubes, deployed and processed SSAS objects, created SSAS storage and partitions and aggregations.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
• Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS 2008.
• Created dashboards using Performance Point Server, combining scorecards and reports generated in SSRS, PPS, and Excel Services.
• Published dashboards on an intranet site using SharePoint Server.
• Configured Report Model for developing ad-hoc reports by the end-users.
• Uploaded reports on to the report manager and organized them into folders.

Environment: SQL Server 2000/2005/2008 , DTS, MS SQL Server Reporting Services, MS SQL Integration Services, MS SQL Analysis Services, T-SQL, MS Excel, MS Access, Visual Studio 2008, Informatica 9.5.

Confidential, NV

Sr. SQL BI Developer/ Sr. SQL Server Developer

Responsibilities:

• Dynamically supported business users for given requirements and developed the reports accordingly.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• Created various database objects such as tables, indexes and views based on the requirement.
• Designed and developed SSIS Packages to pull data from Access, Excel and Flat files to SQL server 2008.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in and support and also have experience in incremental data loading.
• Developed ETL mappings to transfer data from some of the Access, Flat files.
• Developed, deployed and monitored SSIS Packages.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created data sources, connection strings and defined the datasets for generating the report.
• Designed and written the queries in the query builder for retrieving the data.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Created subscriptions to provide a daily basis reports.
• Managed and troubleshoot report server related issues.
• Migrated some Crystal reports to SSRS reports.

Environment: SQL Server 2005/2008, SSIS,SSAS, SSRS, VSS, VBScript, XHTML, XML, Windows 2000/2003 Server, IIS5.0, 6.0, 7.0, Crystal Reports.

Confidential, Michigan

SQL Server Developer

Responsibilities:

• Closely worked with end-users to analyze, understand and gather report requirements.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Developed and created the new database objects like tables, views, index, stored procedures and functions, advanced queries and also updated statistics using query Analyzer and Enterprise Manager on the existing servers.
• Migrated all DTS packages to SL Server Integration Services (SSIS) and modified the package according to the advanced features of SQL Server Integration Services.
• Converted logical database design into physical schema using the balanced normalization in 2nd and 3rd Normal forms for highest performance.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Worked effectively on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries.
• Developed reports using SSRS, used table control, matrix control for cross tab reports.
• Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source and SQL server using SSIS.
• Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Developed the front end screens in C# .Net using Visual Studio.
• Worked on ADO.Net to access data from database.
• Developed reports using SSRS.
• Wrote queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Extensively used SQL Server Reporting Services and Report Builder Model to generate custom reports.
• Wrote and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Handled issues like data correction and resolved error handling.

Environment: SQL Server 2005, SSIS, SSRS, VSS, VBScript, XHTML, XML,C# .Net,ASP.Net, Windows 2000/2003 Server, IIS5.0, 6.0, 7.0.