SUMMARY

• 8 Years of extensive IT experience as DB Developer in Microsoft SQL Server /2008/2008 R2 Technologies.
• Experience in creating BI Solutions using SSIS, SSAS, SSRS and expertise in designing and implementing Relational Database model as per business needs across different domains like Insurance, Banking, Telecomm, Finance and HealthCare.
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/ 2005/2008/2008 R2.
• Experience with all phases of software development life cycle (SDLC) and project methodologies.
• Excellent skills in implementing ETL Packages using Data Transformation Services (DTS) and SSIS 2005/ 2008/2008 R2.
• Migrated DTS packages to SSIS and modified using DTS editor wizard.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Experience in Importing/Exporting Data from various data sources like SQL Server, Excel, DB2 and Flat file using DTS utility.
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Good experience in Designing Aggregations and pre - calculating the same in SSAS 2005/2008/2008 R2.
• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, and Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Proficient in creating Standard Subscriptions and Data driven subscriptions for delivering reports to people internally within the project.
• Expert in deploying the SSRS reports using Report manager.
• Strong Data Mapping Experience.
• Data modeling experience using Erwin Data Modeler and MS Visio.
• Expertise in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views.
• Expert in Complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Table Variables and Views.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor (DTA), DBCC Commands and Query Execution Plans.
• Designed and DevelopedKPIs, Aggregations and Cube Partitions.
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

TECHNICAL SKILLS

Programming Languages: C, Java, VB 6.0,T-SQL,PL-SQL,VBScript,JavaScript,HTML

Databases: MS SQL 2005, 2008R2, 2012, Oracle and Teradata.

BI Tools: SSIS, SSAS, SSRS

Tools: & Utilities: DBArtisan 5.0, ERStudio (ERWIN,), Rapid SQL, Red gate SQL Compare, SQL Litespeed

Operating Systems: Windows 98/NT/XP Windows 2000 Advanced Server, W2K3 server, UNIX, MS-DOS.

Miscellaneous: Cognos, Informatica, OBIEE.

PROFESSIONAL EXPERIENCE

Confidential, CA

SQL Server BI Developer

Responsibilities:

• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Incorporated the DTS Packages into MS SQL Server 2005 Integration Services by using Package Migration Wizard and Execute DTS 2000 Package task.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Developed SSIS packages for File Transfer from one location to the other using FTP task
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule DTS/SSIS Packages.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis services (SSAS).

Environment: Windows 2003 Server/XP, SQL Server 2008/2005, SQL Integration Services(SSIS), SQL Reporting(SSRS), Business Intelligence Studio, Visual Studio 2008/2005, OLE DB, DTS Package, SharePoint MOSS 2007, Crystal Reports, Erwin 4.0, VB.Net, HTML.

Confidential, NY

SQL Server BI Developer

Responsibilities:

• Conducted Data Migration processes in the SQL Server environment using SQL Server Integration Services 2005.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, and data integrity.
• Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, Fuzzy Grouping etc. for creating many SSIS packages.
• Created many Variables that were used to pass parameterized values into the package which makes the package Dynamic.
• Designed many Configuration files that were used to pass parameters from outside the Business Intelligence Development Studio (BIDS) into the packages using XML files.
• Designed Incremental Load Packages which were used to load the updated and new data into the Enterprise Data Warehouse without removing the existing data.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions Worked with different methods of logging in SSIS.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.
• Created packages in SSIS with error handling.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Migrated all the packages to Test Environment and finally deployed from Test Environment.
• Designed reports using SQL Server Reporting Services (SSRS).
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2005
• 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 and deployed SSRS reports.

Environment: SQL Server 2005, Windows 2000/2003, MS Access 2000/2003,T-SQL, Windows 2000 Advanced Server, SQL Server Integration Services(SSIS), SSRS, Crystal Reports, SharePoint (MOSS) 2007, Erwin 4.0.

Confidential, Tx

SQL Server BI Developer

Responsibilities:

• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008
• Involved in development and implementation of SSIS, and SSRS application solutions for various business units across the organization.
• Wrote T-SQL queries and T-SQL stored procedures in SQL SERVER 2000.
• Created SSIS packages to clean and load data to data warehouse.
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, 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.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Configured complex SQL queries to meet customer requirements as needed.
• Worked on Complex SSRS Reports, Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Reports Design.
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications.
• Created Crystal Reports using Crystal Reports formulae, Grouping, Parameters, Selection criteria.
• Experienced in creating SSAS OLAP Cubes and Partitioning Cubes.
• Experienced in using Dimension Usage, Aggregations, Calculation and Perspective on a Cube.
• Experience in SQL joins, sub queries, tracing, usage of Table Variables, Temp tables etc.
• Involved in optimization of queries, improving the performance by using various approaches from execution plans, Index optimization, and DMV’s.
• Carry out creation of SDLC documentation for existing applications
• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Created checks and constraints to maintain data integrity and created Complex Stored Procedures.

Environment: MS SQL Server 2005/2008, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), BIDS and Windows 2003, SharePoint (MOSS) 2007.

Confidential, CA

SQL Server BI Developer

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages to load data into Sql Server using various transformations in SSIS.
• Analyzed the existing tool and participated in meetings with the business users to gather
• Requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• DefinedCalculated members,named sets, and executed other script commandsusingMDXexpressions. Deployedand processedOLAP Cubes.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs & deployed cubes.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports.
• Created report snapshots to improve the performance of SSRS.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2005 database and performed tuning on it.
• Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures.

Environment: SQL Server 2005, Windows 2000/2003,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, MSIIS, Visual Studio 2005, Visual Team Foundation Server, Crystal Reports

Confidential

SQL Server Developer

Responsibilities:

• Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.).
• Managed Database files, transaction log and estimated space requirements.
• Monitored database application.
• Responsible for developing automation of maintenance jobs, tuning SQL Server locks and indexes configurations, administering SQL Server security.
• Experience in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Designed and implemented several complex reports and administration modules.
• Designed stored procedures for module integrity and application.
• Involved in installation, upgrade and configuration of Microsoft SQL Server and databases.
• Involved in Microsoft SQL Server Database Administration including planning, backup, and recovery strategies.
• Implemented High availability concepts, Data base Mirroring, Replication and log shipping.
• Involved in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.
• Involved implementing Disaster Recovery for minimal downtime using different types of database backups, restore, and replication.

Environment: SQL Server v2000, T-SQL, Win NT v4, Win 2000, MS Excel