SUMMARY:

• Over 8 years of experience in Database Design, BI - Development of Microsoft SQL Serve 2014/2012/2008 R2/2008 various development, test and production environments with various business domains like Financial, Insurance and Manufacturing
• Experience in Installation, Configuration, Management and Troubleshooting SQL Server.
• Expertise in Business Intelligence Development Studio (BIDS), which includes SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Implemented complete BI solutions using conventional SDLC and Agile methodologies.
• Proficient in writing and tuning SQL queries and improving the query performance, working on DTS, Data Cleansing and Data Migration.
• Expertise in creating/modifying Tables, Views, Triggers, Joins, cursors, User Functions, Indexes, user profiles, relational database models, data dictionaries, Stored Procedures and in depth knowledge in query optimization & performance tuning.
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
• Experience in T-SQL programming skills like creating Stored Procedures, Functions, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, and Cursors.
• Used SSIS Import/Export Wizard for performing the ETL operations.
• Experience in SQL Server Analysis Services (SSAS 2008/2012) OLAP Cubes.
• Expertise in creating Configurations to make package portable and Event handlers for handling package error.
• Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension (SCD), Merge Join and Union
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Expertise in creating and Configuring Data Source & Data Source Views, Dimensions, Cubes, Measures using SQL Server Analysis Services.
• Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security and has an ability to define and develop Report Structure with data definition, report layout and report definition language.
• Developed BI data mapping and BI objects (dashboards, reports, analyses, visualizations, metrics, security) design documents using Power BI.
• Expert in calculating measures, mathematical formulas and user-defined functions (DAX) in Power pivot reports.
• Expertise in creating InfoPath solutions and publish into SharePoint form Libraries for sharing information, implementation of Out-of-box workflows designed using SharePoint designer 2013.
• Experienced in Upgrading and Migrating sites and site collections implementation to SharePoint 2013 environment.
• Proficient in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
• Worked with SharePoint designer workflow for updating team work progress on project day to day development.
• Experienced in organizing and customizing SharePoint Sites, Web Parts, Connectable Web Parts and deployment of Web Parts with SharePoint Server.
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 20012/2008.
• Proficient in creating Data Mapping Document for providing source and destination mappings. Deployed reports on report server.
• Experience in SQL database design, architecture, data modeling using Erwin; Data Warehousing and analysis skills: ETL tools, MDX, OLAP (MOLAP, HOLAP, and ROLAP), dimensional modeling, star schema and snowflake schema.
• Proficient in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
• SQL Server OLAP Database Development including KPIs, Data mining, working with changing dimensions.

TECHNICAL SKILLS:

RDBM/Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000, Oracle 8i & 9i, 10g, 11g, Sybase, MS Access 97/2000/2003/2007, MYSQL

Programming, Scripting & Web Languages: C, C++, T-SQL, PL/SQL, MDX, Dynamic SQL, HTML, DHTML, XML, Shell Scripting, Visual Basic 6.0

Data Modeling: MS Visio, ERWIN 4.5/4.0, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-Normalization Techniques

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS), Data Transformation Services (DTS), Business Intelligence Development Studio (BIDS), Power Pivot, Power View, Power BI, Tableau

Tools: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, SQL Server Analyzer, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console,, Visual Studio Team Foundation Server (TFS), ERWIN 7.3/7.2

Application Packages: MS Office, Microsoft SharePoint Server (MOSS) 2007/2010/2013

PROFESSIONAL EXPERIENCE:

Confidential, Eden Prairie, MN

Sr. SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Responsible for gathering/refining requirements from the customer for developing reports.
• Worked on Software life cycle development (SDLC) involving in all stages of development.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created Grouping, Sorting columns and writing expressions per the business requirements.
• Transferred the data using SSIS packages.
• Worked on Views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
• Worked in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSIS 2012.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Worked with EDI transactions like 270, 271, 276, 277, 835 and 837I/P/D.
• Created Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps) and integrated them to share point.
• DAX operations were used to create custom calculations in Power Pivot for Microsoft Excel workbooks and Analysis Services Tabular data warehousing.
• Used star and snowflake schema in designing cubes for creating SSAS packages.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Involved in Tabular Dataware house and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI’s on a cube.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Supported development of Access applications for product management group, involving analysis, design, coding, and testing of components.
• Migrated old data from MS Access and Excel into SQL Server 2014 using SSIS Packages in Business Intelligence Development Studio.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Used SSIS 2012 to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Implemented and enhanced existing reports like Group By, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.

Environment: s: MS SQL Server 2012/2014 Enterprise Edition, MS SQL Server Reporting Services 2012/2014, SSIS 2010/2012, SSAS, Power BI, Tableau, Pervasive, Windows Server 2008.

Sr. SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Analyzed the Reports, Tables and ETL process, Various ETL Transformation tools were used for Control Flow and Data Flow tasks.
• Created SSIS packages for Uploading of different formats of files (Excel, Access) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Created packages using SSIS Designer for exporting heterogeneous data from OLE DB Source.
• Configured Server for sending automatic mails to the respective people when a SSIS package fails.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Extensively worked on Data Flow transformations like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Customized roles and KPIs using multi-dimensional expressions ( MDX ).
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Created SSRS reports using Report, Drop-Down, Multi-Valued Parameters and Debugging Parameter Issues in Matrix Reports and Charts.
• Generated reports that can handle dynamic grouping and dynamic sorting.
• Created drill down, drill through, sub reports and many more complex reports.
• Permitted access to the reports based on designation of the viewer like store manager or district manager or associate extra.
• Modified data on Azure SQL database through SQL Server Management studio.
• Migrated data from on premises databases to SQL database on Azure cloud .
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Designed rich dashboards with Power BI and prepared user stories to create compelling dashboards to deliver actionable insights.
• Involved in creating report models and applying row level security filters for report model.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services ( SSAS ) and Reporting service ( SSRS ).
• Created reports from cubes by writing MDX queries.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
• Used Pivot table to provide structure to Reports in proper manner like months etc.
• Designed different kinds of reports like Linked, cascaded and parameterized reports.
• Deployment of the developed reports on to the server for the end users.
• Deployed the developed reports and upgraded the system.
• Responsible for creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports, Linked Reports, and Reports using stored procedures using SQL Server Reporting Services 2012.
• Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau.
• Developed dashboard reports on the Tableau Server so that the end users having access to the server can view the data.
• Used SQL Server Agent for scheduling jobs and alerts.
• Written several SQL Scripts such as finding tables with Identity Columns, tables that do not have primary key to streamline the process of replication.

Environment: s: Windows server 2000/2003, MS SQL Server 2014/2012/2008 R2, T-SQL, SQL Server Analysis Services, Report Builder 3.0, DTS, VMware, SSIS, SSRS, Power BI, Performance Point Dashboard Designer, MS SharePoint Server 2010

Sr. SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked with Client/Business Analysts to define data requirements for reporting warehouse.
• Designing and developing SQL Server 2012 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and un-pivot Control Flow Transformations.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.
• Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript.
• Loaded data from heterogeneous sources to databases using various tasks and transformations using SSIS.
• Migrate the data from an Access database to SQL Server 2012.
• Proficient in creating and validating the Power BI reports.
• Fetch the data from Oracle 11g by creating a linked server and use SQL Server to query Oracle database.
• Designed the packages in order to extract data from SQL DB, flat files and loaded into Oracle database.
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Designed best practices document for ETL and Reporting Systems using Data Warehouse concepts.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Design, deploy and maintain various SSRS Reports in SQL Server 2012.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Involved in the preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports using SSRS.
• Created Add-ins, macros, templates, customized Ribbons and write VBA code for all suite applications, especially MS Access, PowerPoint and Excel 2013.
• Automated the conversion and loading of data from Excel based source files using VBA.
• Designed/redesigned Access databases tables, queries, forms and reports using designer and VBA.
• Experience with creating VBA excel forms and spreadsheets.
• Developed the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Developed many MDX queries for creating measures that fits business logic
• Used ProClarity for accessing and analyzing cubes and dimensions and worked on integration of SharePoint with SSRS.
• Worked on Key Performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Created tabular model in SSAS and developed data model in power pivot for excel by using the existing Report.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Created custom calculation in power pivot by using DAX formula
• Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
• Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2012/2008, Visual Studio 2008, Oracle, MS SQL Server Management Studio, SSIS, SSRS, SSAS, MS Excel, Cognos, Teradata, Power Pivot, Power BI

SQL Server SSIS/SSRS Developer

Responsibilities:

• Worked on Data Transformation Activities using SSIS Import/ Export for transferring data between Oracles to SQL Server.
• Moving data to staging tables using SSIS.
• Wrote T-SQL code for creating cursor and handling the data validations.
• Writing complex stored procedures and User defined functions and enforced business rules via Checks and Constraints.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and
• Materialized views for remote instances.
• Created joins and sub-queries for complex queries involving multiple tables.
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created tables, views, clustered & non-clustered indexes, user defined data types, user defined functions and CTE's.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Migrated packages to SSIS and modified the packages accordingly using the advanced features of Integration Service.
• Configured Server for sending automatic mails to the respective people when a SSIS package fails.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS.
• Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Performed data transfers using BCP and BULK INSERT utilities.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Handling the orphan rows in Dimension and Fact tables.
• Develop the Documents for Logging/Error Handling for SSIS Packages.
• Involve in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
• Participated in daily standup, scrum sessions, team retrospective sessions. Participated in a small, experienced, energetic team on a rapid, agile development schedule.
• Generated different types of Reports (Tabular/Matrix) using MS SQL Server Reporting Service (SSRS).
• Created Technical Documentation for reports and maintenance/enhancements of existing Reports.
• Actively participated in User Acceptance Testing and Debugging of the system.
• Extensively worked with Team Foundation Server (TFS) 2012.

Environment: MS SQL Server 2000/2005/2008 (SSRS/SSIS/SSAS), MS SQL Server BIDS, MS Visual Studio 2005, Microsoft Office Suite, XML, Crystal Reports XI, Windows XP, Windows 2003 Server.

SQL Server Developer SSIS/SSRS

Responsibilities:

• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• 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 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.
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Designed and developed various types of reports using SSRS
• Worked on formatting SSRS reports using the Global variables and expressions
• Created parameterized reports, Drill down and Drill through reports using SSRS
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications
• Published reports on to Share-Point and created Web Parts in Share-Point to show various reports generated from Excel and SSRS in one Page.

Environment: MS SQL Server 2008/2005, MS SQL Server Reporting service 2008, MS SSIS, T-SQL, Oracle 9i/10g, Windows, VB Script

SQL Server/BI Developer

Responsibilities:

• Interfaced with the client as part of the Requirements engineering team to finalize the project scope.
• Developed Functional Specification and Requirement analysis Document.
• Used SQL Profiler & Query Analyzer to optimize T-SQL queries and stored procedures.
• Worked on SQL Server Management Studio for Database Creation, Operations and Maintenance.
• Established the Connection between Excel and Database to pull data from Tables to Excel Sheets from the Database to consolidate the data for Validation.
• Created several Complex Views in T-SQL according to the Client Requirements whenever needed.
• Extensively used Inner Joins, Outer Joins and Self Joins in T-SQL Stored process.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the Insurance Data from various source systems feeds using SSIS.
• Experience in Error Handling using TRY & CATCH blocks and performance tuning using counters in SSIS.
• Worked on SSIS for transferring data from Heterogeneous Database (Access database, Oracle, Excel, and Flat Files) to SQL Server.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Developed OLAP CUBES using SSAS and calculate the metrics that were revealed in the functional analysis.
• Defined Data Source Views, Dimensions, Hierarchies, and Cubes, prospective for cubes using SSAS.
• Retrieved data from OLAP cubes through MDX Script for Reporting Services.
• Installed and configured the Report Server for SSRS.
• Used SSRS to create Standard Reports, Matrix Reports, Ad-hoc reports and Parameterized Reports. Involved in analyzing multi-dimensional reports in SSRS.
• Used Reporting Services (SSRS) to schedule reports to be run on predetermined time.
• Deployed Reports to Report Manager.
• Used Try Catch Finally exception handling extensively to avoid circumstances leading to abnormal program termination.
• Migrated SQL Server 2000 database to test server running on Windows 2000 Server.
• Involved in Query Optimizations & Performance Tuning for the T-SQL Stored Procedures & Functions.
• Developed Custom Selection of reports ordering using SQL Server Reporting Services.
• Source Code Management and Version Control using Team Foundation Server (TFS).
• Involved in 24 X 7 Production support.

Environment: MS SQL Server 2000/2005 (SSRS/SSIS/SSAS), SQL Server BIDS, Microsoft Visual Studio 2005, Java, Crystal Reports XI, Java-Script, Query Builder, Microsoft Office 2003, Windows XP.