SUMMARY:

• Eight plus years of IT Experience in Business intelligence Development and Database Design, Development & administration in Microsoft SQL Server 2005/2008/2012 mostly in business domains Logistics and manufacturing.
• Experience in Creating Packages using MS BIDS 2008/2012 and SQL Server Data Tools to Extract data from various sources and apply Transformation and load data to destination.
• Specialized in working with Source Code Version Controls such as Team Foundation Server 2008(TFS)/2013
• Hands on experience with Tableau in designing reports and dashboards
• Experienced in designing Performance Point Dashboard, Reports, and KPI.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) and knowledge in SQL Server Reporting Services SSRS.
• Excellent in High Level Design of ETL SSIS Packages for integrating data using OLE DB/Oracle Attunity/DB2/FTP/MFGPRO Progress/ODBC connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Derived Column, Row Count, Merge and union all etc.
• Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experienced in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T - SQL.
• Experience in Data Conversion and Data Migration using SSIS across different databases like Oracle, MS access and flat files.
• Experience in Performance Tuning and Query Optimization.
• Well versed in Designing Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, and SQL Mail Agent.
• Good in Designing SSIS Framework for different Integration service Projects.
• Hands on experience in Creating Star Schema Schemas.
• Experience in writing efficient multi-dimensional expression (MDX) as per the design requirements
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS:

• SSAS/SSRS/SSIS
• Microsoft SharePoint Services
• Master Data Services (MDS) and DQS
• Tableau Software
• Performance Point Report Designer
• SQL, T-SQL, MS Report Builder 3.0
• SQL Server 2012, SQL Server 2008
• Power Pivot, Power View
• BIDS/SQL Server Data Tools
• HTML/DHTML
• MS Visio 2007/2010
• Windows Enterprise 2003/2000 Advanced Server/2000 Server/Windows 2000 Professional/Windows XP Professional, Vista, Windows 7, Linux Erwin 4.0
• ER Studio
• MS Office 2007/2010, MS Office Excel, MS Power Point XML
• SharePoint 2007/2010
• SQL Profiler
• Advanced C#(Sharp)
• Advanced ASP.Net
• Tableau
• Erwin Data Modeler
• SQL Developer
• Toad

PROFESSIONAL EXPERIENCE:

Confidential - Troy, MI

MS BI Developer / Solutions Lead

Responsibilities:

• Design table structures and data warehouse architecture for purchasing solution.
• Design and develop SSIS packages to Load the data from multiple sources to staging environment.
• USE DQS to cleanse and match the data, and create master data tables using MDS.
• Design and develop SSIS packages to Load Dimensions and Fact tables of Data warehouse.
• Design and Develop multidimensional cube using SSAS, the cube contained many calculations and dimensional hierarchy
• Design Reporting Dashboard and reports using Performance Point and SSRS for business users
• Set up SQL Agent jobs for weekly and daily scheduled run.
• Performance monitoring and Maintenance of solution.
• Post Production support and ticket resolution and bug fixes.
• Lead a team of five offshore developers assisting product development.

Confidential - Dublin, OH

BI Lead /SSAS/SSIS Analyst & Developer

Responsibilities:

• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Development of SSIS packages, which loads data from different, source system into a staging environment and then performed transformations on data for cleansing and modification.
• Development and Extending of Existing OLAP Cubes, Dimensions and data source view.
• Involved in production of data source and data set for new OLAP cubes, wrote calculations based on measures in cube.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX.
• Designed and implemented facts, dimensions for OLAP cubes using dimensional modeling standards in SQL Server 2008/2012 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Involved in designing, developing, debugging and testing of reports in Power Pivot Excel from SSAS Cubes.
• Created reports from power Pivot Excel, SSRS and Performance Point Reporting. (Table, chart and matrix report).
• Created Star schema cubes using SSAS.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Designed and created the table schema and stored procedures that will be used in Data QC.
• Used Joins and sub-queries involving multiple tables from different databases
• Responsible for documentation of system related activities.
• Provides technical documentation of the system
• Actively participated in interacted with users, DBAs and technical manager to fully understand the requirements of the system.
• Used TFS (Team Foundation Server) for project management and source control.

Environment: SQL Server 2012, SSIS (SQL server Integration Services), SSAS (SQL server Analysis Services), Microsoft Business Intelligence Studio, TFS.

Confidential - Dublin, OH

Senior SQL/SSAS/SSIS/ Developer

Responsibilities:

• Created ETL using SSIS 2008. Identified the data source and applied transformation on data to populate into various SQL server tables
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2008(SSAS)
• Used scripts and variables, email notifications for ETL process.
• Designed Data flows, Workflows and jobs to load data from source to target in SSIS.
• Enhancing and deploying the SSIS packages from development server to production server.
• Designed and built OLAP cubes to meet reporting needs.
• Performed Documentation for all data mapping for SSIS packages.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2008 Analysis Services (SSAS).
• Understood OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Used ETL tools like SSIS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• Created Time Dimensions on OLAP Cubes using SSAS.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.
• Involved in migration from SQL Server 2008 to SQL Server 2012.
• Deploying the code on to servers in all the environments whenever changes are required.
• Used TFS (Team Foundation Server) for project management and source control.
• Merging and Branching the code for every Production release and New developments in TFS

Environment: SQL Server 2008, SSIS (SQL server Integration Services), SSAS (SQL server Analysis Services), Microsoft Business Intelligence Studio, TFS.

Confidential

BI Lead /SSAS-SSIS Developer

Responsibilities:

• Created a SSIS Framework for logging of execution log data and error log in SQL Server database.
• Moved the SSIS Package from SQL server 2008 to SQL Server 2012 Environment.
• Ran Packages parallel in SQL server 2008 and 2012 to check for any variation or breaks.
• Fixed the breaks which happened while moving packages in different environment.
• Recreated the production database in the development Environment for testing of Movement of packages in SQL environments.
• Generated variance report of data in two environments and resolved the data ambiguity.

Environment: SQL Server 2008/2005, SSIS (SQL server Integration Services), SSAS (SQL server Analysis Services), SSRS, Microsoft Business Intelligence Studio, TFS

Confidential

Senior SQL Server Developer/ SSAS-SSIS 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 SQL tables and load data from different system 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.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs & deployed cubes.
• Responsible for helping manage the daily operation of the company, meeting with clients
• Created T-SQL Functions, Cursors, views, indexes, stored procedures and triggers.
• Migrated database from SQL server 2000 to SQL server 2005
• Trouble shooting the critical issues and maintenance of all the latest versions of the packages in harvest client, shared paths and share point.
• Scheduling jobs for all the packages in all environments

Environment: SQL Server 2005, Windows 2000/2003, Microsoft office 2003,XML,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, Visual Studio 2005,SharePoint 2007

Confidential

SQL Developer

Responsibilities:

• Worked in BGOS Cluster as an L3 analyst, providing support for Order Management application
• Troubleshooting of issues faced by users while interacting with the order management system
• Help core team in providing information on issues faced by customers and test the solution before releasing it to customer.
• Monitor Server Alerts and services running on the servers.
• Responsible for timely updating alert configuration and analyzing conditions for throwing the alert and troubleshooting appropriately
• Actively participates in discussion for proposing enhancements and improvements in the application as per customer requirements.

Environment: SQL Server 2005, Windows 2000/2003, Microsoft office 2003,XML,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, Visual Studio 2005,SharePoint 2007