SUMMARY

• Over 6+ years of experience as a SQL server Developer and BI Developer (SSRS/SSIS/SSAS). Worked in various business domains like Automotive, Banking, e - commerce and Insurance.
• Hands on experience on T-SQL, PL SQL, SSIS, SSAS, SSRS, MDX, DAX, Power Pivot and Power View reports.
• Experienced with full life Cycle phase of SDLC involving Systems Analysis, Design, Development and Implementation.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Experience in OLTP and OLAP design, development, testing, implementation and support of enterprise data warehouse.
• Experience in Designing Business Intelligence Solutions with Microsoft SQL Server 2008 and 2012 using MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Excellent skills in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase, excel sheets, Flat Files and MS Access.
• Experience in developing custom reports and creating various types of reports like On demand, drill down, Drill-through, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Sub Reports, Ad hoc Reports, dynamic grouping, Cross-Tab, graphical, distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) and Business Intelligence Development Studio (BIDS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and Created analytical reports and visualizations with Microsoft Excel 2013 Power BI tools (Power View, Power pivot and Mapping) for exploratory analysis by data analysts.
• Proficient in tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Hands on experience in installing, configuring, managing, upgrading and migrating Backup/Restore, monitoring and troubleshooting SQL Server 2008
• Experience in using SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases
• Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
• Possess excellent oral / written communication and interpersonal skills.
• Good ability to quickly grasp and master new concepts and technologies.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.
• Worked in both OLTP and Data Warehouse Environments. Proficient inUnix shellscripting.
• Good expertise in all the stages of Fullsoftware development life cycle implementation (SDLC)
• Good working experience inReports, PL/SQL, Oracle Databases 8i/9i/10gandRDBMSConcepts.
• Good interpersonal, Analytical and communication skills.

TECHNICAL SKILLS

Languages: T-SQL, MS SQL, MDX, DAX, C, C++, VB, HTML, DHTML, HTTP, Java, Shell Scripting

Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, Profiler Database Engine Tuning Advisor (DTA). MS SQL Server, RDBMS SQL Server, MS Visual Studio, SQL Server Management, MS-Office.

BI Tools: SSAS, SSIS, SSRS, BIDS, Informatica Power Center, OBIEE, Crystal Reports.

Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, data modeling and De-normalization techniques

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Power, ProClarity, Microsoft Office.

Operating Systems: Windows, LINUX, UNIX

PROFESSIONAL EXPERIENCE

Confidential

SQL Server/MSBI Developer

Responsibilities:

• Build a data cube around the existing offer click, impression and revenue statistics from redirectors
• Construct different hierarchical dimensions suitable for offer analyst to use.
• Build a set of reports which includes historical same-period comparisons.
• Enhance and build selected redirect reports with the flexibility of an OLAP service
• Created SSIS packages to load data into staging table and data mart and Performed logging in SSIS packages to capture error data and for error handling.
• Used the SSIS to migrate Databases such as Access database, flat files to centralized IT destination.
• Performing T-SQL tuning and optimizing queries for reports that take longer execution time.
• Extract data from flat files which comprised of header and input files to SQL server 2012 and Created Testing scripts for staging validation, generated the Map Force file for mapping between flat file and database.
• Developed Logical and Physical models based on the business requirements. Created ER Diagrams using Visio.
• Created MOLAP Cubes and automated the Processing options on different servers. Optimizes the processing time by tuning the DSV queries and created SSIS Packages eliminating complex syntax in Data Source View.
• Created the Partitions, Aggregations and various custom Member calculations in the Cube. And also, developed drill through actions which would navigate to SSRS reports deployed to Report manager.
• Defined Attribute relationship, created hierarchies and for ease of use grouped the attributes to folder structure within the dimension structure as Attributes, Hierarchies.
• Created different kind of reports like cascading reports, Drilldown reports, Drill through Reports, Parameterized reports, Sub reports and charts in SSRS 2008R2.
• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
• Working on Creating partitions and Designing various storage modes to increase the performance of a cube using SSAS.

Environment: SQL Server 2008, SSIS, SSAS, SSRS, MS SQL Server 2012/2008/2005 , Tableau 7.0/8.1 Server and Desktop, Eclipse, Windows Server/professional, Oracle 12c, C#, VISIO, ERWIN.

Confidential, Duluth, GA

MSBI Developer

Responsibilities:

• Prepared Business Model and technical documents for the existing applications and Customer Requirements.
• Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Worked on migration to SSIS packages across instance; also, tuning of SSIS packages and T-SQL queries.
• Implemented various SSIS Transformations like Slowly Changing Dimension- SCDs type 2, Data Conversion, Derived Column, Lookup, Fuzzy Group, Multicast, etc.
• Fields are updated on time basis like day, month, quarter, year using SSIS packages.
• Created cubes in SSAS using multi-dimensional model based on business requirements.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using SSAS and produced ad-hoc, standard and super user reports using SSRS.
• Understood and modified the data as per the requirement using the Query Editor and Data view in Power BI desktop.
• Handled transformations on the data using Power Query in Power BI.
• Performed Analysis using Power Pivot in Excel and data taken from Power BI cloud.
• Created Role based Security levels to access data in Power BI and capable of using new features like Q & A.
• Experience with SQL Server Reporting Services (SSRS) and Power BI to author, manage and deliver paper-based, Web-based reports and Interactive Dashboards.
• Migrated different kinds of records using Reporting Services Migration Tool by performing necessary steps to prevent loss of reports.
• Involved in the preparation of the unit test case documents and unit testing of the enhanced macro codes, T-SQL queries.
• Implemented SSAS cubes, facts and dimension tables to perform analysis.
• Created Partitions in the cubes for incremental processing.
• Designed the Usage based Aggregation based on the query logs on Analysis Server.
• Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Created Virtual Cubes using linked measure groups from multiple cubes.
• Generated dynamic reports from cubes (SSAS) using Excel pivot and gave the access for ad-hoc and COGNOS reporting.

Environment: Windows server 2012, SQL Server 2012, Microsoft BI Suite 2012, Microsoft Visio, Power BI.

Confidential, Manhattan, NY

ETL MSBI developer

Responsibilities:

• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
• Design and tune ETL process.
• Creating large number of stored procedures and created parameterized SSIS Packages to move data from different sources to target. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
• 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. Configured and maintained Report Manager and Report Server for SSRS.

Environment: MS SQL Server 2008/2012, Red Gate tools, Power Pivot, TFS 2013, MS SSRS/SSIS 2012, T-SQL, Visual studio 2013, MS Visio.

SQL Server/MSBI Developer

Confidential

Responsibilities:

• Created and managed stored procedures, indexed views, user-defined functions, triggers, and database constraints to meet business requirements and policies.
• Created complex queries for database auditing purposes.
• Used DTS/SSIS for ETL processes, SSRS for reporting needs, and SSAS for analytics reporting including SharePoint integration.
• Created highly complex SSIS packages using various data transformations like conditional splitting, fuzzy lookup, multi-cast, column conversion, fuzzy grouping, script components, and error handling.
• Generated custom ETL scripts using SSIS 2005 and unit tested load processes for performance check.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Gained understanding of OLAP processing for changing and maintaining warehousing optimizing dimensions and hierarchies and adding aggregations to cube.
• Involved in writing MDX queries and performance optimization of SSAS cubes for calculated members and measure groups.
• Created various complex reports and managed them using SSRS 2008/2005 according to ERLC.
• Involved in migration and conversion of reports from SSRS 2005 to 2008.
• Created tabular reports, matrix reports, list and chart reports, parameterized reports, sub reports, ad hoc reports, drill-down reports and interactive reports according to business requirements in time-restricted environment.
• Created SSRS report model projects in BI studio and created, modified, and managed various report models with multiple model objects, source fields, and expressions.

Environment: SQL Server 2005/2008/2008 R2 Enterprise Edition, .NET 3.5, SQL BI Suite 2008 (SSAS, SSIS, SSRS), Enterprise Manager, PPS, XML, PowerPoint, Project, Access 2003, Windows Server 2003, Oracle, Crystal Reports, Business Objects, SharePoint, MOSS 2007.