SUMMARY

• 8 years of strong experience with demonstrated success in the Database Design, development of SQL Server 2000/20 R2/2012.
• Designing and implement SQL Server Data Marts and Data Warehouses using best practices in accordance with Microsoft guidance.
• Extensive experience in Database and Business Intelligence technologies with expertise in Installing, Upgrading, Troubleshooting and Configuring MS SQL Server Database, SSIS, SSRS, SSAS.
• Experienced in SDLC (Software Development Life Cycle) involving System analysis, Design Development & Implementation using Waterfall methodology and Agile methodology.
• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Experience in Data Modelling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Extensive experience in administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems
• Excellent understanding of data mining algorithms, high performance and optimal algorithms.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experience in implementing MDM (Master Data Management) using SQL Server 2012
• Experience in implementing DQS(Data Quality Services) using SQL Server 2012
• Good understanding and Designing of Star and Snow Flake data models Schema used in Relational, Dimensional and Multidimensional data modelling.
• Strong experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard.
• Exhaustive experience in Data Extraction and Transforming and Loading (ETL) using SQL Server Integration Services (SSIS) in MS SQL Server to import/Export data, Bulk insert and BCP.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, and Fuzzy lookup, Fuzzy Grouping, Pivot and Un - Pivot).
• Migrated data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Experience in providing Logging, Error handling by using Event Handler, Query Optimization and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached, Ad-hoc reports and rendered them to HTML, XML, PDF and Excel formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Strong experience in creating dashboards, KPI’s and scorecards using gauges and charts for analysis using SSRS 2012/2008 R2 and SharePoint 2010.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Experience in Dimensional modeling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse using tools like Erwin and E-R Studio.
• Experienced in working with Star Schema modeling to develop ROLAP/MOLAP Cubes using SQL Server 2005/2008 Analysis Services.

TECHNICAL SKILLS

RDBMS: SQLSERVER 2012/2008R 2/2008/2005/2000 , Oracle 10G/9i, Teradata, MySQL

Database Tools: BIDS, SS Management Studio, Query Analyzer, System Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Databases Maintenance Plan Wizard, Data Transformation Services (DTS), MSCS, Bulk Insert and BCP, Business Intelligence Development Studio, SQL CMD, SQL Server DBA Dashboard, Toad for SQL, Data Quality Services(DQS), Master Data Services(MDS).

ETL & Reporting Tools: SSIS, SSRS, SSAS, Excel 2010, Cognos 8..3/8.4, Power View

Programming Languages: SQL,T-SQL,ANSI SQL, PL/SQL,C,C++,JAVA,C#,VB 6.0

Operating System: Windows 95/98,NT,Windows XP/2003/2000,Unix,Linux,MS-DOS

Web technologies: HTML, XML, VBScript, SharePoint 2010,C#,ASP.NET,ADO.NET,VB.NET

Tools: Erwin 7.2, Visual Studio 2010/2008/2005 , Visio,Visual Source Safe

PROFESSIONAL EXPERIENCE

Confidential, Denver CO

Sr. MSBI SSIS/SSRS

Responsibilities:

• Involved in Designing the ETL for incremental load to keep old and new applications in sync.
• Worked with Change Data Capture (CDC) tasks in SSIS packages to achieve incremental loads.
• Design and implement staging, landing and archive layers to bridge the gap between applications and improve performance for incremental load.
• Developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views to implement the business rules and transformations.
• Involved in writing complex SQL queries and stored procedures to perform data transformations as per mapping documentation.
• Involved in creating complex stored procedures, nested stored procedures, triggers, views, indexes and functions.
• Performed regular backups and restores of databases to refresh seed data in other environments.
• Extensively worked on SSIS packages design for data migration from scratch including package configurations and error handling.
• Created SSIS packages from scratch to transfer data from source to destination using all required transformations applied.
• Extensively used various SSIS control flow tasks like Loop Containers, SQL Server Agent jobs, Script, FTP, Web service task, Bulk insert task, Transfer job task, etc. and different data flow tasks like Conditional split, Derived Column, Fuzzy lookup, merge join, Multicast, Union all, data conversion etc.
• Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.NET,VB.NET,ADO.NETand PL/SQL. The middle tier contained all the business logic.
• Created reports which need an ability to be run on schedules, via command line parameters via front end modules, to generate PDF output.
• Created parameterized reports using charts and sub reports.
• Involved withQuery Optimizationto increase the performance of the Report.
• Designed and Developed excel Model, Reports in EXCEL, Power Query and Power Pivot.
• Worked on SSRS for various reports including tabular, drilldown, drill through, matrix, parameterized, graphical reports, sub reports and metadata reports

Environment: MS SQL Server 2012/2008R2/2008, Teradata, Oracle 10G, SQL Server Data Tools (SSDT), SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Integration Services, Data Quality Services, JIRA, PowerPivot 2013, Power Query, VB.NET, ER/Studio, Visual Studio 2013/2012, Team Foundation Server (TFS)

Confidential, Jackson MI

Sr. MSBI SSIS/SSRSSSAS

Responsibilities:

• Worked with the end users to gather the requirements to build datamart for inventory management and also MDS user interface.
• Created SSIS packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Created Source to target mappings, Technical design documents and Conceptual and Physical Models for MDS.
• Worked on Master Data Management: Business process design for managing Master Data throughout the lifecycle, including data quality, metadata and workflow technologies.
• Implementation experience on SQL Server 2012 Master Data Services and Data Quality Services.
• Created business rules and workflows in MDS to maintain quality and accuracy of master data.
• Deployment of SSIS packages using visual studio 2012.
• Involved in designing, developing, debugging and testing of reports inSQLServer Reporting Services (SSRS).
• Designed various operational, drill-through, drill-down, subreports and parameterized reports and developed these reports using the Global variables, Functions and expressions.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Design and Develop new SSAS Tabular models and provide operational support to existing SSAS Tabular models to satisfy business requirements.
• Involved in Technical Design Specification Documentations and Data Dictionaries for the related work for each SSAS models.
• Developed MDX queries against SSAS Cubes to generate reports for analysis.
• Built MOLAP cubes for fast data retrieval and complex calculations.
• Designed SSAS Cube and developed MDX queries for Analysis.

Environment: SQL Server 2012 and 2008R2 Enterprise Edition, Teradata, Oracle10G/9i, VB.NET, T-SQL, MDS 2012, MS Access, MS Excel, & Windows 2003 server, Linux, Business Intelligent technologies like SSIS, SSRS, SSAS, Data Quality Services.

Confidential, Minneapolis MN

SQL Server BI Developer

Responsibilities:

• Developed complex programs in VB Script, which connects to SFTP server to get the initial data which is in CSV Format, with best execution plan.
• Performed data conversions from flat files into a normalized database structure.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Created packages to convert flat file to XML file.
• Created cubes and dimensions (SSAS) for the analysis of sales in specific areas.
• Good understanding of SSRS with Report authoring, created weekly and monthly reports as per requirement using SSRS.
• Developed Report Models for building Adhoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.
• Used the SSIS Import/Export, migrated the Database such as Oracle and Access database, flat files to SQL server 2008.
• Configured mail tasks to know the job status of SSIS packages.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
• Extensively usedASP.NETDataGrid, DataList and Repeater controls for displaying the datain a clear format.
• UsedADO.NETobjects such as Data Reader, Dataset and Data Adapter, for consistent access to Oracle data sources.

Environment: SQL server 2000/2005/2008 , SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle 9i,Enterprise Manager, ERWIN Data Modeller, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2008, MS Access, Crystal Reports.

Confidential, Colorado Springs, CO

SQL BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Installation and configuration of SQL Server 2008.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Designed ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Experience in developing Database Schemas / Stored Procedures / Data Dictionary.
• Experience and knowledge in designing and developing data visualization strategies.
• Experience and advanced knowledge of Kimball Methodology for Data Warehousing.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Demonstrated experience in utilizing design tools, development tools, code management, regression testing and performance tuning.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Production.
• Fundamental knowledge of .NET and application architecture and development principals.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• Experience in using XMLA protocol for SQL Server Analysis Services 2005 for interaction between client application and instance of Analysis Services.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Sub Reports using Sql Server Reporting Services 2008.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.

Environment: MS SQL Server 2000/2005/2008 , Linux, MS Access, Oracle 9i, Windows 2000/2003, VB.NET, ERWIN, XML, SQL Profiler, UNIX and Crystal reports.

Confidential

Jr. SQL Server Developer

Responsibilities:

• Analysis, Design and Development.
• Database Administration, Production and Development Support.
• Created report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.
• Created and developed the stored procedures, functions and triggers to handle complex business rules, history data and audit analysis.
• Created and maintained Roles and Database users.
• Provided assistance for development teams on tuning data, indexes and queries
• Automated and enhanced daily administrative tasks, including space management, backup & recovery and performance monitoring, block, and dead lock
• Configured securities and accesses for production databases and database servers
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Environment: SQL Server 2000/2005, SSRS, SSIS, T-SQL, Script, JavaScript, ASP, Microsoft Office, Windows 2003/XP.