SUMMARY:

• 8+ years of IT professional experience in analysis, design, implementation & administration of business intelligence solutions with 2005/2008/2008 R2/2012/2014, SSIS/SSRS/SSAS in development, testing & production environment.
• Skilled in writing and reviewing T - SQL code and maintaining coding standards.
• Experienced in writing and dealing with Relational Database Management Systems including complex SQL Queries, Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors, Views, and User Defined Functions to implement business logic.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation, and loading.
• Experienced in upgrading SQL Server 2005/2008 to 2008/2012 and data migration among versions.
• Excellent T-SQL development skills to query complex relational databases with the development of Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers and user created data types to provide flexible and reusable modules to be used in WEB technology and client-server Windows technology.
• Merged and manipulated Medicare & Medicaid data sets to create new tables, graphs and other tools.
• Experience in different phase of Software Development Life Cycle (SDLC) of development of applications.
• Experience in creating Jobs, Alerts, SQL Mail Agent and Scheduled SSIS Packages.
• Expertise in genera ting Crystal reports, Ad hoc reports, tabular reports, Matrix reports, Drill-down reports, Cascaded reports, List reports, Parameterized reports, Sub reports and mentoring end user report writers using SSRS.
• Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies, and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.
• Expertise in creating indexed tables with primary key, foreign key, and composite key constraints to maintain referential integrity and to maintain performance
• Hands on experience in the ETL processes using SQL Server Integration Services (SSIS) Bulk Copy Program (BCP) and Data Transformation Services (DTS)
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, and Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Extensive experience in power pivot modelling, building. and maintaining power views.
• Experienced in developing user reports, management reports along with Report Authoring, Report management, Report delivery and Report security using SQL Server Reporting Services from MS Excel and flat files.
• Worked on Multidimensional Expressions (MDX) queries on Cubes.
• Created calculated measures, dimension members using MDX, mathematical formulas and user defined functions, named calculations using SSAS for generation of cubes.
• Extensively involved in SQL Tuning using SQL Server Profiler, SQL TKPROF, Explain Plan, Optimizer Hints to enhance the performance of the complex queries for OLTP Transactions and Decision Support System
• Integrator of relational databases like SQL Server, ORACLE, Microsoft Access, and Excel spreadsheets.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting, and organizational skills.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project

TECHNICAL SKILLS:

ETL: DTS, SSISSQL

Server Tools: SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), SQL Server Query Analyzer, SQL Server Agent, SQL Jobs, SQL Alerts & SQLMail, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), DBCC, BCP, SQL Server Profiler.

Reporting Tool: SSRS, Crystal Reports, Business Objects

Programming Languages: T-SQL, PLSQL, C#.

Databases: MS SQL Server 2005/2008 R2/2012/2014, Oracle 9i/10g/11g, SQL & MS Access

Data Modeling Tool: Erwin, Microsoft Visio, performance point server, Power Pivot.

Operating System: Microsoft Windows 95/98/2000/2002/ Vista/Windows7/Windows 8/10, Mac OS X

PROFESSIONAL EXPERIENCE:

Confidential, Wisconsin

SQL BI Developer

Responsibilities:

• Responsible for gathering project requirements from the users for designing and developing data warehouse as needed.
• Responsible for managing BI environment which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Used various SSIS tasks such as Conditional Split, Derived Column etc. which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.
• Responsible for creating Databases, Tables, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Responsible for Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Created Alerts to report successful or unsuccessful completion of Jobs.
• Performed backup/restore database objects such as tables, procedures, triggers, constraints, indexes and views.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, and charts and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2/2012.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling equipment in the company, top sales based on region and sales based on season.
• Wrote queries for Drilldown reports to get the complete details of the sales sold in particular region.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS
• Responsible for creating and executing Test cases, performing UAT and documenting the results.
• Integrating and managing SSRS reports in SharePoint environment.
• Responsible to create and deploy Data sources, data sets, reports to the SharePoint document library.
• Performance tuning the existing reports.
• Created script tasks and components with C# in SSIS as part of ETL load.
• Worked in an Agile Scrum model and collaborating with Scrum Master, QA, Product, and Development Teams.

Environment: SQL Server 2014/2012/2008 R2, SSIS, SSAS, SSRS, SharePoint, C#, Tableau 9.0/8.3, Business Intelligence Development Studio (BIDS), Visual Studio 2015/2013/2012, MS Visio 2013/2010.

Confidential, MN

SSIS Developer

Responsibilities:

• Involved in all the phases of SDLC including Requirements collection, Design and Analysis of the customer specifications, Development and Customization of the application.
• Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
• Implemented Complex business logic with User-Defined-Functions, Indexed Views and created User Defined Data type, Clustered & Non-clustered Indexes.
• Created maintenance plan for reorganizing Indexes and scheduling jobs.
• MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans, and Database Consistency Checking DBCC commands.
• Experienced in Extracting, Transforming, and Loading (ETL) of data from Heterogeneous data sources to MS SQL Server by using SSIS.
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Created packages in SSIS with error handling and Worked with different methods of logging in SSIS.
• Developed, monitored, and deployed SSIS packages.
• Experience in Developing and Extending OLAP Cubes, Dimensions, and data source view.
• 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.
• Create and edit alerts on Reports as per User request.
• Export reports in various formats like MS Excel, PDF, MS Word, Text, and CSV, generate reports with parameters, sub reports, charts using SSRS.
• Used SSRS to create customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created SSRS Report Model Projects in BI studio and created, modified, and managed various report models with multiple model objects, source fields and expressions.
• Provided critical Production support when needed.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes.

Environment: MS SQL Server 2008/2012, T-SQL, ETL, SSRS, SSIS, SSAS, .NET Framework, C#, ASP.NET, Windows 2003/2008/2008 R2, HTML, XML, JAVA Script, MS Excel, MS Access, TFS, Remedy.

Confidential, NY

SQL BI developer

Responsibilities:

• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Performed cost benefit analysis of different ETL packages (SSIS) to determine the optimal Process.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Developed an automated report subscription process using SSRS.
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Used Report Builder to do Ad-hoc Reporting.
• Created report links to refer other reports in a report.
• Created various database objects including databases, tables, indexes, stored procedures, triggers, and user defined functions.
• Worked on DTS to SSIS migration.
• Used SQL server profiler and database index tuning advisor to increase the performance of existing SQL queries.
• Resolved any deadlocks issues with the Databases/Servers on a timely basis.
• In-Depth working knowledge of ODBC.
• Handled Underwriting and pricing of renewal accounts within underwriting authority for
• Property Casualty, General Liability, Business Automobile, Umbrella Liability, Crime, and Workers
• Compensation. Assisted (via remote) with payroll, tax, and account processing.
• Imported and exported data into MS Access databases and Debugged VBA scripts linked to said databases.
• Worked on macros to convert EXCEL file into XML.
• Created multiple hierarchical aggregates for faster performance.
• Created database objects like tables, users, roles, stored procedures, triggers.
• Worked on solving issues by doing data recovery in existing database.
• Used various formatting techniques like interactive sorting, grouping to created user friendly reports.

Environment: SQL Server 2000/2005/2008 R2/2012 Enterprise Edition, SSIS, T-SQL, SSRS, Windows Server 2003/2008R2/2012, TFS, VB.Net, C#.

Confidential, West Des Moines, IA

SQL BI Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Involved in development of multiple reports incorporating business logic and user requirement.
• Designed ad-hoc reports, grouping and sorting using SSRS.
• Involved in designing sub reports and linked reports depending on the user requirement and to limit the number of Data Sources.
• Developed Complex SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts, and Graphs).
• Deployed SSRS reports to SharePoint Server for the end users to look at them.
• Helped the users to test the reports created and optimized the performance of the end reports getting data from SQL server Databases and SQL server analysis services.
• Involved in migrating SQL Server 2005 to 2008 R2.
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.
• Written SSIS packages in 2012/2008 R2/2008
• Good Hand on Resolving complex issues and Error Handling in SSIS.
• Created SSIS packages to transfer data from various sources like Teradata, Excel, flat files into SQL server using different SSIS components and used dynamic configuration files and variables for production deployment.
• Created the derived columns from the present columns for the given requirements.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints
• Developing OLAP cubes using SSAS 2008R2 and 2008 and calculates the metrics that were revealed in the functional analysis.
• Involved in Dimensional modeling by identifying the fact and dimension tables and design start/snow flake schemas for the SS Analysis services.
• Worked on creating calculated measures that fits business logic, using MDX queries.
• Worked on Key Performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS)
• Involved in designing Data Marts, Data Warehouse.
• Wrote stored procedures for all the Database Interfaces, created user defined functions, constructed triggers, tables, views, indexes, and user profiles.
• Used Grid Controls, Checked List Box Control and Panel controls to display and manipulate data in win Forms.
• Developed Windows User Controls using Win forms controls and custom controls using c#.
• Designed and Developed Web Pages using ASP.Net Framework4.0
• Used Data Adapters, Datasets, and Command & Connection Objects of ADO.NET to Manipulate Data in the SQL Server Database.

Environment: MS SQL Server 2012/2008, T-SQL, SSRS, SSAS, SSIS Packages, SSRS, MDX, ETL, ASP.Net 3.0, Ado.Net 4.0, C#.Net, Excel, MDX, OLAP, OLTP, Access, Windows 2003 Server, Change Control, APE (Automated Process Environment).

Confidential

SQL Developer

Responsibilities:

• Gathered requirements to identify and create database objects such as tables, views, triggers, and indexes.
• Involved in Normalization of the database and bringing it to 3NF.
• Involved in creating the constraints, rules, defaults, and triggers to maintain the data and referential integrity.
• Created ER diagrams using Visio.
• Created Views to enforce security and data customization.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Involved in the performance tuning and optimization of T-SQL queries.
• Responsible for Data migration from SQL Server 2005 to SQL Server 2008 Databases.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Developed user requested reports using Crystal Reports and Excel.
• Created Drill down and Drill through reports using Crystal Reports.

Environment: MS SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS and Windows Server 2008, MS Access.