SUMMARY

• 6 years of Professional experience in the IT industry as a MS SQL Server Developer using Microsoft SQL server 2012/2008R2/2008/2005 in Banking, Finance, Insurance, and Health Care Domains.
• Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like MS Excel and Microsoft Office.
• Highly proficient in the use of T - SQLfor developing complex Stored Procedures, Triggers, Tables, User-Defined Functions, Views, Indexes, Relational Database models, Data integrity, Query writing andSQLjoins.
• Hands on experience with performing various SSIS data transformations & data flow tasks like Look-ups, Merge, Merge Join, Sort, Derived Column, Union-All, Conditional Splits and Event Handlers, For Each Loop containers, Control Flow Task, Execute SQL Task, Script Task, Send Mail Task, File System Task etc.
• Experienced at generating reports with SSRS in SQL Server 2012/2008/2008 R2/2005 on SQL Server Data Tools and Business Intelligence Development Studio (BIDS).
• Expertise in Data Warehouse Modeling, creation and deployment of dimensions, partitions, aggregation and cubes with SSAS.
• Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional data modeling and reporting tools.
• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports usingSSRS.
• Created reports such as Tabular, Cross-reports, Drilldown, Drill Through, Snapshot, Cached reports and Charts using SSRS.
• Expert in T-SQL (DDL&DML), RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Good SQL Server Administration skills including, Backups, Restore, database maintenance, user authorizations and Database creation.
• Ability to work in-groups as well as independently with minimal supervision.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative, ability to learn new concepts and the ability to think outside the box.

TECHNICAL SKILLS

Database: MS SQL Server 2012/2008/2005 , Oracle 11g/10g/9i, MS Access

Operating System: Windows XP/NT/Vista/2007/8/10, UNIX, Macintosh OS

SQL Server Technologies: SQL Server Management Studio, Business Intelligence Development Studio (BIDS), Visual Studio 2010, SQL Profiler, Performance Monitor, SQL, T-SQL, DDL, DML, Stored Procedures, UDF, Triggers, DTS, Log Shipping, Index Tuning Wizard, SSIS, SSAS, SSRS

ETL Tools: MS-DTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export.

Reporting Tools: SSRS, SSAS, Crystal Reports, MS Access, MS Excel

Programming Languages: T-SQL, PL/SQL, C#, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. SQL Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Reviewed logical and physical data models for new requirements after discussion with technical team and application users as per agile methodology.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extensively used SSIS for transferring data by utilizing various control flow and data flow elements and also involved in end to end unit testing.
• Wrote T-SQL queries, common table expressions, Stored Procedures and used them to build packages.
• Used various event handlers to log process information into SQL tables.
• Expertise in Data Warehouse Modeling, creation and deployment of dimensions, partitions, aggregation and cubes with SQL Server Analysis Services (SSAS).
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS and Calculated measures and dimension member in MOLAP cube using MDX in SSAS. Wrote MDX queries to access data from OLAP cubes.
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional data Modeling principles in SSAS.
• Generated reports using Global Variables, Expressions and Functions using SSRS.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Involved in unit testing procedure and code reviewing for entire application and identified bugs as well as resolved them.
• Tested the reports and fixed bugs in the stored procedures. Managed the Metadata associated with the ETL (SSIS) processes used to populate the Data Warehouse.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.

Environment: MS SQL Server 2012, SSAS, SSRS, SSIS, T-SQL, Visual Studio 2012, Oracle 10g/9i, DTS, Data Analyzer, MS Access, Excel, SQL Profiler, Windows 7, Erwin 4.2, TFS, Subversion.

Confidential, San Francisco, CA

Sr. SQL Server/SSIS/SSRS Developer

Responsibilities:

• Developed physical data models and created DDL scripts to create database schema and database objects.
• Designed data models using Erwin.
• Created indexes, constraints and rules on database objects for optimization.
• Designedand developed SSIS ETL/SSIS packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart usingLookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Data Staging to SQL server.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Developed Multi-dimensional Objects Cubes, Dimensions using SSAS.
• Experienced in implementing Key Performance Indicator (KPI) Objects in SSAS.
• Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
• Designed, deployed, and maintained various SSRS Reports in SQL Server 2012.
• Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, using SSRS.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Developed Report Models using report builder and distributed reports in multiple formats using SSRS in Business intelligence development studio (BIDS).
• Created alerts for successful or unsuccessful completion of Scheduled Jobs.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions using T-SQL to provide structure to store data and to maintain database efficiently.

Environment: MS SQL Server 2012, SSIS, SSRS, SSAS, VB.Net, C#, SQL profiler, EDI, Pro clarity, T-SQL, Erwin tool 7.2, Windows 2008

Confidential, New York, NY

MSBI Developer

Responsibilities:

• Requirement gathering and understanding the trends that is to be shown in the reports.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle usingSSIS.
• Written complex stored procedures and SQL queries.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Worked on tuning the queries and fixing the stored procedures to get the data consistency.
• Used various SSIS data transformation tasks like SCD, Look-ups, Fuzzy Look-ups, Merge Union-All, Conditional Splits, Multi cast, Derived column etc.
• Used various SSIS components like Conditional split, derived column, multicast, OLEDB sources, OLEDB destinations, control flow components, data flow components, Aggregates, Execute SQL task, Send mail task, for each loop, row count, union all, merge, data conversion etc.
• Involved in design of SSIS Package configuration, logging, deployment & job scheduling.
• Created Tabular, Drill down, and Parameter reports using SSRS and configured Report snapshots, Report caching for reporting performance.
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used MDX to access them.
• Created business critical KPIs using SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Developed SSRS reports which include dynamic grouping fields, drilldown and dashboard report and Export reports into various formats such as PDF, HTML, EXCEL, and WORD.
• Created indexes on selective columns to speed up efficiency of queries and analysis in SQL Server Management Studio.

Environment: SQL Server 2012/2008R2, T-SQL, SSIS, SSRS, Visual Studio.Net 2012 (C#.NET), Web service.

Confidential, Irving, TX

SSIS/SSRS Developer

Responsibilities:

• Involved in gathering the report specifications by interacting with the business users.
• Responsible for Data Modeling based on the client requirements, data analysis loading data from Data feed to Data Warehouse tables.
• Redesigning the ETL/SSIS process from the existing legacy DTS packages into SSIS Packages.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SSIS.
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Modified stored procedures to meet current design and used them in SQL Server.
• Created various Database Objects - Tables, Indexes, Views, and Roles, complex Stored Procedures, Datasets, Object Data Sources, and SQL Data Sources.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created ad-hoc reports using SQL Server 2008 Reporting Services (SSRS).
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.

Environment: MS SQL Server 2008R2/2008, Enterprise Edition, MS SSAS 2008, MS SSRS 2008, MS SSIS 2008,T-SQL, VB Script, Windows Server 2007, Erwin.

Confidential

Jr. SQLServerDBA/Developer

Responsibilities:

• Created SSIS Data Migration Template using SQL Server.
• Actively involved in Normalization of database.
• Designed DDL and DML for MSSQL Server2008.
• Involved in planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Created rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimized query performance by creating indexes.
• Created reports for users in different departments in different states using SSRS.
• Worked on Queries and Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Performed daily database backup & restoration and monitor the performance of Database server.

Environment: MSSQL Server 2008/2005, T-SQL, DTS,SQL ServerEnterprise Manager,SQLProfiler.