SUMMARY

• Seven Years of extensive IT experience as a Microsoft SQL Server /2008/2008 R2/2012 Developer in creating Business Intelligence Solutions like SSIS, SSAS, SSRS and expertise in designing and implementing Relational Database model as per business needs.
• IT experience in Database Development, Design, Analysis, Support of MS SQL Servers 2008, 2005, 2000 in Development, Testing and Production Environments with various business domains.
• Hands on experience with features and functions of Microsoft SQL Server 2012.
• Experience on data migration from SQL Server .
• Very good working experience of T - SQL.
• Expertise in scripting T-SQL queries, Complex Stored Procedures, User Defined Functions (UDF), Database Triggers, using tools like SQL Profiler and Database Tuning Advisor (DTA).
• Used Sub-Queries and Joins to simplify complex queries involving multiple tables.
• Expertise in creating, maintaining database objects like Indexes, Functions, views, Triggers, UDF’s, constraints.
• Hands on experience in Performance tuning and query optimization including updating statistics, rebuilding and re-organizing indexes.
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Experience in bulk importing CSV, XML and Flat files data using Bulk copy program BCP.
• Experienced in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Very Strong skill in building and using CTE’s (Common table Expressions) for building recursive queries.
• Experience in Monitoring, Job Scheduling, Troubleshooting, Back Up, recovery and system upgrading.
• Very strong implementation of Microsoft Business Intelligence(BI) platforms including SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS) and Microsoft office SharePoint Server 8 in SQL Server 2005/2008.
• VB.Net and C# used for scripting in Script Tasking in SSIS to control the flow of SSIS package.
• Experience in designing, configuring, deploying SSIS packages and providing security for packages.
• Implemented incremental Load for many SSIS packages.
• Experience in Error handling, Debugging, error logging for production support in SSIS.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• SQL Server 2008/2005/2000 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Performed Logging and Deployment of various packages in SSIS.
• Experienced in enhancing and deploying the SSIS Packages from development server to production server.
• ETL implementation using SQL Server Integration Services (SSIS), Reporting Services (SSRS).
• Strong ASP.NET, VB.NET knowledge.
• Developing reports on SSRS on SQL Server (2000/2005/2008 ).
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Implemented parameterized, cascading parameterized, drill-down, drill-through and sub-reports using SSRS.
• Experienced in administrating the created reports and assigning permission to the valid users for executing the reports.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Logical Data Modeling, Data warehouse design concepts, Dimensional Modeling using Star, Snowflake, Normalized and De-normalized Schemas with respect to query and analysis requirements.
• Experienced in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
• Experienced in Creating and Updating Statistics to improve the SQL Server Performance.
• Good knowledge Database Console Commands (DBCC).
• Experienced in managing Data and Transaction log files, Files Groups.
• Experienced in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Experienced in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Good knowledge of System Development Life Cycle (SDLC).
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

TECHNICAL SKILLS

Operating Systems: Windows NT 4.0, Windows 2000 Server, Windows 2000 Advanced Server, Windows 2003 Server, Windows XP, Windows Vista, 7.

Programming Lang: SQL, SQL*Plus, HTML, XML,C,C++, DS, Visual Studio 2005, MDX

Software: MS Office 2010/2007

RDBMS: MS SQL Server 2008/2005/2000 , SQL Server Management Studio(SSMS), SSAS, Oracle 9i, MS Access

ETL Tools: DTS, SQL Server Integration Services(SSIS)

Reporting Tools: SQL Server Reporting Services(SSRS), Crystal Reports 8.0/9.0, SharePoint 2007

Database Query Tools: MS SQL Server Query Analyzer, SQL Profiler

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

MSBI/ETL Developer (SSIS,SSAS,SSRS)

Responsibilities:

• Involved in gathering, understanding and validating the project specifications.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for generating reports using SSRS.
• Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
• Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using T-SQL.
• Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services-2008.
• Developed complex T-SQL queries for the ETL packages.
• Experienced in administrating the created reports and assigning permission to the valid users for executing the reports.
• Designed packages in SSIS 2008 with various complex transformations such as derived column, conditional split, lookup, aggregation, execute SQL task.
• Good understanding and experience in SQL 2008 new features like Change Data Capture (CDC), Transparent Data Encryption (TDE) and Policy based Management.
• Built Synchronous and Asynchronous scripting component for different modes of output.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history
• Developed transact-SQL commands including complex queries, views, functions, stored procedures, cursors and triggers on SQL server 2008 R2/ 2008/2005/2000 .
• Created packages with Ragged Right data mapping.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Created user variables, property expressions, script task in SSIS.
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Responsible for integrating data into a centralized database with dynamic design and user friendly web application, to keep track of Direct Bill Payments and Commissions from various Clients across the nation.
• Modeled and designed the architecture of the SQL Server 2005 database.
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Designed Cascading (Collapsed), Printable, interacted reports (drill-down and sorting functionality).
• Responsible for deploying reports to report manager and troubleshooting for any error occurs in execution.

Environment: MS SQL Server 2008 R2, T-SQL, MS SQL Integration Services 2008, MS SQL reporting Services2008,Microsoft Visual Studio 2010, SharePoint Designer, SQL Server Management Studio.

Confidential, San Jose, CA

SQL BI/ETL Developer

Responsibilities:

• Installation of MS SQL enterprise servers on test and development boxes.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Created groups, roles, users and assigning access privileges to users.
• Optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data and normalized tables.
• Established Joins and created Clustered/Non-clustered Indexes wherever necessary.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history
• Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history
• Monitored and scheduled existing/new jobs on production environment.
• Optimizing Database Queries for performance enhancements and Writing T-SQL Views and triggers.
• Involved in Migration of SQL 2005 to SQL server 2008 R2
• Worked to tune the SQL queries using SQL Profiler.
• Tested backup and recovery strategies in a test environment before and after moved to production environment.
• Extensive use of Stored Procedures by creating new stored procedures and modifying existing ones.
• Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS).
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Involved in migration and Conversion of Reports from SSRS .
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Played a Content Manager role on report server.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Designed SSAS cube to hold summary data for Target dashboards.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: MS SQL Server 2005/2000, DTS, T-SQL, XML, Flat File, SQL Server SSIS, SSRS, SSAS, Visio, IIS, Windows XP/2000

Confidential, Bedford, MA

SSIS/SSAS/SSRS/SQL Server/ETL Developer

Responsibilities:

• Work closely with management and end-users to create and evaluate business requirements.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using SSIS.
• Used differentControl Flow Tasks and Data flow Tasksfor creating SSIS Packages.
• Designed packages using different types ofTransformationsfor Data Conversion, Derived Columns with Multiple Data Flow tasks
• Experience inError handlinganddebuggingcoding issues andtroubleshootproduction problems.
• Involved in migration and conversion of Reports from Crystal Reports to SSRS 2008R2.
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drill down Reports.
• Experience in writing custom code expressions in SSRS.
• Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level
• Created Report Models for Business Users to create their own reports.
• Designed & created OLAP Cubes with Star schema using SSAS 2008 R2.
• Database Administrator, Database Programming.
• Created Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS).
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Managed security and user access to Analysis Services cubes using creation of Groups and Roles by creating windows AD and also Perspectives within the OLAP cube.
• Monitoring nightly ETL process from various highly different source systems.
• Sources included SQL based databases and Excel Files.
• Also ensured that nightly backup jobs or cube processing or other ETL jobs didn’t interfere with each other.
• Managed SQL 2005 and 2008 R2 databases and nightly SSIS Processes.
• Involved in Monitoringand troubleshooting complex packages by using Data Viewers Grids.
• Monitoring the scheduled SSRS and Crystal reports. Re-running the reports in case of any failures or data mismatches.
• Involved in deploying the changes to QA, Staging and Prod environments.
• Managed off shore team in Report migration project.
• Followed agile methodology and coordinated daily scrum meetings.
• Involved in Product Releases and support calls.

Environment: SQL Server 2005/2008R2, Windows Server 2003/2008R2, T-SQL, SSIS, SSRS, SSAS, Crystal Reports, Share Point 2010, BIDS

Confidential, MN

SSIS/SSRS/SSAS/SQL Developer

Responsibilities:

• Developed optimized stored procedures, T-SQL queries, User Defined Functions (UDF), Cursors, Views and Triggers, SQL Joins and other statements for benesmart reporting Application, maintained referential integrity and implemented complex logic .
• Enhancing the layouts available for the reports in the BeneSmart application
• Designed and created Report templates, Bar graphs and Pie charts based on the financial data.
• Dealt with huge amount of data and used SSAS in order to retrieve the data
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Gather requirements from business user and modify the stored procedures, codes to provide functionality as required.
• Troubleshooting and fixing Bugs/issues in the enterprise level web application using C#.NET, ADO.NET, ASP.NET.
• Perform including filters to the reports and make it parameter-driven
• Perform including SQL Agent jobs to update source of data by use of SSIS package.
• Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).
• Deploying the reports to staging server prior to business user acceptance testing.
• Perform including security to the reports and data in the application
• Implement updates of reports in BeneSmart application to recognize same-day data updates/changes.
• Doing release builds and fixing issues related to reports in staging environment of BeneSmart application.
• Created data driven subscriptions for different users using Report Manager.
• Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET and LINQ (Language Integrated Query) to access and update database
• Expert in debugging an application using debugging tools provided by the Visual Studio.Net IDE.
• Sound Knowledge in ADO.NET to communicate with database for retrieving, accessing, and updating data.
• Proficient withDynamic HTML, XML, CSS, for building a dynamic flexible and highly interactive Real-Time User Interface.

Environment: SQL Server 2008 Enterprise Edition, MS SQL 2008 r2, SQL Server BI Suite(SSRS, SSIS and SSAS), Microsoft Visual Stuidio.NET 2010, Microsoft Visio 2003, ASP.NET 3.5, ADO.NET, C#.NET, MS EXCEL 2007.

Confidential, Tampa, FL

SQL Server Developer/DBA

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Creating the complex stored procedures, user defined functions to meet the business rules.
• Associated closely with the team of Business Analysts to gather requirements for Reporting.
• Worked with Business Analysts to do mapping and to alter stored procedures.
• Responsible for creating the reports using the SQL server reporting services and maintained them. Used the various parameter passing techniques to create input for reporting parameters.
• Wrote the ETL scripts to load the data into database from various source files.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Developed User Interactive Sheets & Reports as per business needs in SSRS.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the front end.
• Improved the performance of SQL Queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
• Developed and maintained maintenance plans, evaluated scheduled jobs and monitored performance during various job runs.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Experienced in development of Test Cases in various scenarios around the SQL Code and SSIS Packages in Dev., QA and UAT environments.
• Actively participated in gathering and analyzing Business Requirements, Creating Directives, Data Analysis, Design, Development, Conversion, System Testing, Operational Readiness, Documentation, Production support issues.

Environment: Server 2000 Enterprise Edition, T-SQL, Enterprise manager, MS Office and Windows 2000.