SUMMARY:

• 8+ years of IT experience in System Analysis and Design, Development & Support of MSBI (Microsoft Business Intelligence) and MS SQL Servers 2008 R2 and 2012 in Production, QA and Development Environments.
• Extensive experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Expertise in SQL Server 2008R2/2012 Reporting Services (SSRS), SQL Server 2008R2/2012 Integration Services (SSIS) and in SQL Server 2008R2/2012 Analysis Services (SSAS) in Business Intelligence (BI)
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Experience in developing Dashboard, Ad - hoc and Parameterized Reports, create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Skilled troubleshooter with the proven ability to provide creative and effective solutions through the application of highly developed technical and problem -solving skills.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Experience in managing large data sets on MS Excel 2013
• Worked with version control software like Team Foundation Server(TFS)
• Worked on Resource Management tool - Plan view.
• Expert in creating OLAP CUBES using SSAS.
• Expert in migration of data from one database to another using exports and import utility.
• Strong knowledge of Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling.
• Excellent skills in Database backup, Replication, recovery, restoration, DTS and Linked servers.
• Experience in translation business goals and requirements into the realization of planning solutions.

TECHNICAL SKILLS:

Tools: &Packages

SQL Server Management studio, SQL Profiler, SQL Server Business Intelligent studio (BIDS), Team Foundation Server, Power BI

BI Tools: SSIS, SSAS, SSRS

Databases: MS SQL Server 2008, 2012,2014,2016

T: SQL, MDX,C, VB.net, C# (.NET)

Operating Systems: Windows Desktop / Windows Server

Application Packages: MS Office Suite, MS Outlook

Data Modeling Tools: MS Visio, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Albuquerque, NM

Sr MSBI Developer

Responsibilities:

• Extensive experience in analyzing, designing and developing Client/Server, Business Intelligence (BI) applications and various segments of software development life cycle (SDLC) involving business process analysis, requirement gathering and development.
• Expertise in Microsoft Suite of products like SSIS, SSRS, SSAS. Also as part of the team, extensively involved in developing and implementing end to end BI solutions.
• Great experience in Developing and Deploying SSIS packages, job scheduling, dataflow and control flow components, SQL mail Alerts using SQL Server Agent.
• Using SSIS worked extensively on various data sources (Excel, XML, Flat file etc.) and different transformations like lookup, merge join, derived column, aggregate, conditional split etc.
• Expert in designing ETL data flows using SSIS, creating mappings/workflows to extract data from SQL Server, Data Migration and Transformation from Excel using SQL Server SSIS.
• Proficient in DTS Migration and Metadata Management: Migrating DTS packages to SSIS.
• Experience in error and event handling, Precedence constraints, breakpoints, checkpoints, and logging.
• Created various reports like tabular, matrix, list, parameterized, and other reports using SSRS Working with Fee Schedules and provide data validation through SSRS reports. They have customized reports like tabular, matrix, drill down, drill through and deliver reports to end-users on a monthly/Adhoc basis.
• Using SSIS packages to load and manipulate into the QNXT claim processing system.
• Integrated TFS with SQL data tools to manage MSBI stack packages properly in DEV, QA, and PROD environments using check-in and checkout and have maintained history for every minor change.
• Optimized the performance of complex source queries and stored procs with the help of execution plan and Database Engine Tuning Advisor to fetch data fast from source systems.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2012.
• Responsible for creating database objects like table, views, store procedures, triggers, etc.) to provide structure to store data and to maintain the database efficiently.
• Perform T-SQL tuning and optimizing queries using SQL server 2008/2012.
• Developed a large-number of standard and customized reports using SSRS for data feeds and for Reports on the server.
• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
• Created useful user-defined functions and multifaceted stored procedures for reporting purposes.

Environment: MS SQL Server 2008R2/12, SSRS, SSIS, SSAS, MS Visio, MS Excel 2010, SQL Management Studio, SQL Profiler and SSRS, Microsoft Visual studio 2012, Team foundation server.

C confidential, Cleveland, OH

Sr. MSBI developer

Responsibilities:

• Creating and analyzing existing high level ETL design documents and data mapping documents.
• Involved in Agile Process, Part of Sprint Meeting and Scrum Calls.
• Created SSIS packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task and Execute Package Task.
• Imported data, built scheduling packages, defined integration flow and log data error exceptions using SSIS.
• Migrated data from different sources (text based files, Excel spreadsheets) to SQL Server databases using SQL Server Integration Services (SSIS).
• Developed Package configurations for Integration, Test and Production environments and execution of SSIS packages automatically.
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2012) which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamics reports and other features of Reporting service.
• Hands on experience on SSAS tabular model.
• Worked on Power Pivot to Generate repots and create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and Pivot Charts etc.
• Created sub-reports, drill down reports, drill through reports, summary reports, parameterized reports, and ad-hoc reports using SSRS.
• Optimized existing reports and process new changes as per business requirements.
• Assisted in building a company-specific Data Mart for the Claims-related data.
• Optimized the performance of queries with modification in T-SQL queries, removed the unnecessary columns and redundant data, normalized tables, established joins and created index.
• Used Execution Plan, SQL Profiler, and database engine tuning advisor to optimize queries and enhance the performance of databases.
• T-SQL used for creating various complex objects like Tables, views, functions, store procedures for storing and processing data in the required form.

Environment: MS SQL Server 2012 SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Agile, Multi Dimension, Cubes, Tabular Modeling, Management Studio, Data Transformation Services, SQL Server Agent, SQL Profiler, Export/Import Wizard, Visual Studio, MS Access, T-SQL, Power Pivot, Query Analyzer, MS-Excel, MS Access 2010, SQL Server Agent.

Confidential, Chicago, IL

MS SQL / BI Developer

Responsibilities:

• Gathered requirements from business users and developed SQL stored procedures and SSRS Reports.
• Created several SSRS reports like drill down, drill through and subreports.
• Imported and created relationships between different data sources and between multiple tables using Pivot table.
• Performed Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems as well as managed the subscription of the reports.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2012
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different Databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes. Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Involved in creation of fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services (SSAS).
• Created calculated measures and dimension using Multi-Dimensional Expressions (MDX) and extract data from data mart.
• Identified and modified the Key Performance Indicators (KPIs), measures in co-ordinance with the requirement and created calculate member in MOLAP cube using MDX in Business Intelligence Studio using SSAS
• Extensively used SQL Server Reporting Services 2008 with relational and multidimensional data.
• Worked on forward engineering to enhance the data structures of the existing database and creating new schemas.
• Generated reports using report Builder3.0 that could be used to send information to diverse group of users, clients, and managers.
• Generated power reports in Excel 2013 for the users to as per user requirements along with BA.

Environment : SSIS/SQL 2005/2008 R2, ERWIN 8 Data Modeling tool, XML Schema, FTP, BIDS, Visual Studio2010.