SUMMARY

• 8 + years of IT experience in MS SQL Server Database Developer with SQL Server 2012/2008R /2000.
• Experience in Insurance, Healthcare, Financialenvironments with primary skills on the Analysis, Design, Development, Implementing and testing client and server application using Microsoft SQL Server and BI suite.
• Strong experience in SSAS, MDX and MDX calculations.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SQL Server SSIS 2008.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008.
• Good experience in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQLServerReporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
• Creating the Cubes and Dimensions building, deploying, processing and maintaining Cubes using SQL Server Analysis Services (SSAS).
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional Tables and Operational Data Store (ODS).
• Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environments.
• Extensive experience in working with large Databases like DB2,Oracle,SQL and Teradata
• Expert in analysis, modeling, design and development of Tableau reports and Data modeling.
• Extensive experience in Tableau desktop, Tableau server and Tableau reader in various versions of Tableau.
• Hands on experience in building SSRS reports using ASP.NET from SSAS OLAP cubes.
• Expert in designing scripts using frame works and display to users through web pages using ASP.NET.

TECHNICAL SKILLS

SQL Server Tools: SQL2012/2008R 2/2008/2005/2000, SSIS, SSRS, SSAS

Reporting Tools: Report Builder 3.0, SSRS

ETL Tools: SSIS(SQL Server Integration Services), Data Stage, Bulk Copy Program (BCP), Import Export Data, DTS(Data Transformation Services)

RDBMS: MS Access, Oracle 11g/10g

Languages: SQL, T-SQL (Transact SQL), PL/SQL, C, C++, C#, ASP.NET, Java, Visual Basic 6.0, HTML, CSS.

Operating Systems: Windows 8/7/vista/XP

Other tools: Microsoft Visual Studio 2005, ProClarity ODBC, MS Office

PROFESSIONAL EXPERIENCE

Confidential

Senior MSBI Developer

Responsibilities:

• Gathering Business requirements and designing them as a Model and made them easy to analyze using Excel spread sheets and Pivot Tables.
• Designed and developed SSAS Tabular Models according to the business requirements.
• Written Complex Queries and Calculations for the derived Columns.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Wrote stored procedures and sub queries and used various event handlers, lookups for acquiring the required logs.
• Designed script tasks and components to filter the unwanted data and gather the required data in useful format.
• Designed detailed design document of the complete implementation of the model and shared across the team and acted as a mentor.
• Building up Script tasks using VB scripts and filtering data.
• Reviewed existing Tabular models and enhanced them for a better experience.
• Involved in creating new tabular models and loading the data from the data lab and monthly refresh of data into the model.
• Scheduling and monitoring monthly jobs and automating the monthly proceedings using SSIS packages and Script Components.
• Designed various SSIS packages that automatically collects raw data from various external DB and load the required data into data lab using transformations.
• Automating Monthly flow of data into data lab from multiple sources like SharePoint, Excel, DB2, SQL, Mainframe Flat files.
• Logging the information that is loaded into the data lab using Various SSIS Transformations.

Environment: SQLServer 2008 R2/ 2012, Report Builder 3.0, Business Intelligence Studio (SSAS, SSRS), Rapid SQL, SharePoint 2010, ASP.NET,DB2, T SQL, MS Excel.

Confidential, Webster, MA

MSBI 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.
• Designed and developed Cubes.
• Written MDX queries and MDX calculations.
• Implemented Cell security using MDX scripts.
• Reviewed logical and physical data models for new requirements after discussion with technical team and application users as per agile methodology.
• Designed and developed SSIS packages to move data from staging environment to Repository environments within the organization.
• 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 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, Store Procedures and used them to build packages. Used various event handlers to log process information into SQL tables.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2008.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Involved into creating detail design documents, traceability matrix, detail unit testing documents and shared with the business.
• Served as a mentor and advisor to other Software Analysts/Programmers on our support and development team.
• Developed Scripts using ASP.NET in the report design through scripting components.
• Building reports using ASP.NET from the developed cubes from the design.

Environment: SQLServer 2008 R2/ 2012, Report Builder 3.0, Business Intelligence Studio (SSAS, SSRS), SharePoint 2010, ASP.NET, T SQL, MDX, MS Excel.

Confidential, Boston, MA

SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Involved in SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to DW systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column Using SSIS 2008 for ETL Processes.
• Involved in providing logging, auditing and package configurations for make the packages more flexible by using SSIS 2008R2. Used different techniques of performance tuning in SSIS as well as involved in handling the errors.
• Wrote T-SQL queries, Store Procedures and used them to build packages and handled Change Data Capture (CDC) to maintain the history of the data.
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints and also performed Table Partitioning on very large scale databases.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software and improve the performance tuning of queries.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008R2.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Performed daily tasks including backup and restore by using SQL Server 2008R2 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Used Visual Source Safe (VSS) for version control.

Environment: MS SQL Server 2008R2/2005, SSIS, SSRS, SSAS, Windows 7/XP.

Confidential, Atlanta

SSIS/SSRS Developer

Responsibilities:

• Gathered user requirements, draft specifications design and create Database objects for performance tuning.
• Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages
• Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert)
• Worked on Error Handling and Logging inSSIS packages.
• Created configuration table to set the properties of the objects ofSSIS packagesat runtime.
• Implemented best practices for performance tuning of SSIS packages
• Involved in error handling of SSIS packages by evaluating error logs
• Successfully extracted transformed and load data into data warehouse.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created tabular, matrix, chart, drill down reports, parametric, cascaded reports and dashboards and score cards reports (SSRS) according to business requirement.
• Created reports by dragging data from cube and wrote mdx scripts.
• Used SSIS 2008 to create ETL packages to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Improved the performance of long running views and stored procedures.
• Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.
• Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
• Tuned the queries using Execution plan, to get index seek from table scan and index scan.
• Improved the performance of many queries by 90%.
• Worked with Erwin data modeling tool.
• Created Database objects including Tables, Views, Stored Procedures and UDF.
• Developed User defined functions, stored procedures, and indexes.
• Extensively involved in writing database scripts.

Environment: SQL Server 2008, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), MS Excel, XML, SQL Profiler.

Confidential

SSIS/SSRS Developer

Responsibilities:

• Interacted with the various teams and understood the various reports that are supposed to be generated.
• Coordinated with customer, vendor and onsite/offshore folks.
• Used complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
• Used SQL profiler and Execution Plan to view index performance and thereby eliminate table scan.
• Assisted project manager in project planning schedule for database module.
• Involved in upgrading the instance of development environment of SQL Server 2000 service to SQL Server 2005 with latest service pack.
• Extracted data from OLTP to OLAP using SSIS using complex data transformations.
• Developed packages for getting data from SQL Server, Flat files and MS Access data of Sales, Returns and Employee.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL Server 2005 as well as created interface stored procedures used in SSIS to load/transform data to the database.
• Successfully created Snapshots Report, Report Subscription, Data Driven Subscription and Report caching using Report Manager
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business.
• Worked with Dynamic SQL and developed procedures utilizing the functionality.

Environment: MS SQL Server 2000/2005, DTS, MS Access, SQL Query Analyzer, MS SQL Server Integrated Services and MS SQL Server Reporting Services, TSQL, PL/SQL,SQL Profiler, Windows 2003, Microsoft Excel.

Confidential

SQL Server Developer

Responsibilities:

• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for the system.
• Created Snapshot Replication for the Development and Testing Databases across different Servers.
• Created and scheduled jobs and alerts, studied the existing environments and accumulated the requirements by interaction with various aspects.
• Developed & executed several optimized queries, written several stored procedures to achieve various functionalities of the system.
• Worked with DML, DDL, DCL and TCL in process of develop and manage the Databases.

Environment: SQL Server, Windows NT, T- SQL, EXCEL, Access.