SUMMARY:

• Over 7 years of professional IT experience in designing, developing and maintaining Database using MS - SQL server 2005/2008/R2/2012
• Expertise in conceptual, logical and physical designing and development of Data Models, Data Normalization, OLTP and OLAP Database and Data Warehouse
• Experience in coding, testing, deployment, support and maintenance of business applications using MS-SQL Server 2005/2008/R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
• Expertise in T-SQL in creating and using Views, User Defined Functions, Triggers, Indexes, Stored procedures involving joins, sub-queries from multiple tables and established relationships between the tables using primary and foreign key constraints
• Proven ability in performance tuning and query optimization using indexes, SQL profiler and SQL Enterprise Manager
• Expert in ETL tools like Import/Export wizard and SSIS for transferring Data from different sources to a centralized SQL server
• Excellent in High Level Designing of SSIS Packages to perform ETL from heterogeneous sources such as Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations provided by SSIS to generate underlying data for the reports and to export cleansed data.
• Expertise in solving run time issues using SSIS error and event handler, precedence constrain, breakpoint, check point and loggings
• Well experienced in using global variables, expressions and functions for reports using SSRS
• Hands on Experience in creating various types of dynamic reports like Tabular, Matrix, Drill-Down, Cascaded parameterized, Chart reports, Sub reports, Ad-Hoc Reports, Cross Tab Reports and Distributed Reports in multiple formats using SSRS based on client requirements
• Proficient in implementing dimensions and fact tables for star /snowflake schemas to process cubes in SSAS 2008/R2/2012
• Have good experience in implementing MDX queries to design OLAP architecture, MOLAP, ROLAP and HOLAP
• Experienced in developing Dashboards, Scorecards using multiple KPI’s by using Microsoft Share point
• Good experience in utilizing Microsoft Power BI tools such as Power View, Power Pivot, Power Query and Power Map to retrieve, analyze and present data in well-designed visualizations
• An Enthusiastic and goal oriented team player with excellent analytical, communication and interpersonal skills and proficient in technical writing and presentations
• Ability to work independently or part of a team to accomplish critical business objectives

TECHNICAL SKILLS:

• MS-SQL SERVER 2005/2008/R2/2012
• SQL Server Data Tools, MS SQL Server Management Studio
• Business Intelligence Development Studio, Visual Studio
• SQL Server Enterprise Manager, Oracle, DB2, C++
• Math Lab, SQL, T-SQL, MS Excel, MS Access, DTS
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• ERWIN, TFS, SQL Profiler, MS Visio
• Windows 2007/2000/XP, ASP.net, VB.net, Java

PROFESSIONAL EXPERIENCE:

Confidential - Omaha, NE

Microsoft BI Developer

Responsibilities:

• Created Data Mapping Documents to develop ETL packages and translate business requirements into data analysis
• Implemented naming convention for the warehouse objects given by the project manager
• Optimized and used stored procedures to improve data retrieve performance
• Developed SSIS packages to transfer data from different sources to a staging database
• Developed SSIS packages to load data to a warehouse from a staging database by using different SSIS Data Flow transformations, like Lookup, Fuzzy Lookup, etc. to perform data cleansing
• Configured Send Mail Task on Event Handler to send emails upon the tasks in the package succeed or failed
• Configured and used checkpoints and break points to solve runtime issues
• Developed OLAP cubes using star as well as snowflake schemas to fulfill business requirements using SSAS 2012
• Generated multidimensional tabular, crosstab and drilldown insurance claim reports to management and analysis people
• Created multidimensional PivotTable, PivotChart and Power View reports on Excel 2013 by extracting data from the cubes
• Created ad-hoc reports using Report Builder 3.0 for client’s management people
• Published reports generated on SSRS 2012 to SharePoint 2013

Environment: MS SQL Server 2012, SQL Server Reporting Services 2012, SQL Server Integration Services 2012, SQL Server Analysis Services 2012, Microsoft Visual Studio 2010, Oracle, SQL Server Management Studio, MS-Excel, MS-Access, SharePoint 2013, Report Builder 3.0, Oracle, C# 4.0

Confidential, Des Moines, Iowa

MS-SQL Server, SSIS, SSRS developer

Responsibilities:

• Developed and deployed SSIS 2008R2 packages to transfer data from various sources to a ODS database
• Created package configurations in SSIS 2008R2 to make movement of packages easier from development server to production server by updating the path of a source file and/or changing the name of a database or server whenever necessary
• Configured Checkpoints for long-running packages to restart a package if it fails at the point of failure
• Generated reports using recent data for management people, explicitly for the purpose of meetings and presentations by caching temporary copy of reports
• Managed snapshot reports for different kinds of reports by using Report Manger
• Scheduled, maintained and supported report subscriptions using SSRS 2008R2 on TFS 2012
• Generated datasets on SSRS by using Query Designer to join multiple tables by understanding the ER diagram
• Generated drilldown and crosstab reports using multidimensional data for management people working at different branches of the client using SSRS 2008R2
• Created and used stored procedure to generate reports on SSRS 2008R2
• Used parameters and expressions to group and filter data to make reports more efficient and department specific

Environment: MS-SQL Server 2008 R2, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Visual Studio 2010, MS Access, MS Excel and Oracle, Windows Server 2008 R2, TFS 2012

Confidential, Hoffman Estates, IL

MS SQL Server, SSIS, SSRS Developer

Responsibilities:

• Worked with business analysts to design and implement solutions for generation of data and reports to fulfill the business requirement
• Developed SSIS packages with various control flow and data flow transformations to perform ETL
• Used SSIS 2008R2 transformations like fuzzy lookup, conditional split, derived column transformations to perform data cleansing and data scrubbing in the staging area, before loading the data into the data warehouse
• Configured SSIS Send Mail Task on multiple Control Flow tasks to send email during failure using SMTP Connection manager
• Used Breakpoints extensively to debug packages step by step to find logical error
• Extensively used Control flow tasks and Containers, and data flow Transformations,
• Created XML Package configuration files to update database connectivity information
• Managed and configured Data-driven Subscriptions reports to be scheduled on a daily and monthly basis for targeted people in the company
• Generated reports related with inventory using features like drilldown, drill through reports using SSRS 2008R2 for management and analysis people
• Generated summarized drilldown tabular reports by creating stored procedures on
• SSMS and later used as embedded Dataset on SSRS 2008R2
• Involved in performance tuning and query optimization by using tuning advisor and indexing strategies

Environment: MS-SQL Server 2008 R2, SQL Server Management Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Visual Studio 2008, SQL profiler, Excel, Oracle

Confidential, Denver, CO

MS SQL Server, SSIS, SSRS Developer

Responsibilities:

• Developed ETL packages using SQL Server Integration Services by moving the static data from various SQL server database
• Worked with T-SQL to create tables, views, triggers and stored procedures
• Involved in query optimization to increase the performance of reports
• Developed reports using SSRS using various features like cross tab, parameterized reports as per client requirements
• Created tabular reports by cascading parameters into reports depending on the requirements by using SSRS
• Generated reports on the fly using Report Manager

Environment: SQL Server 2005/2008, Excel 2007, SSIS 2005, T-SQL, Visual Studio 2005, Windows 2000/XP.

Confidential, Cheyenne, WY

MS SQL Server Developer

Responsibilities:

• Gathered requirements to identify and use database object like tables, views, triggers and indexes
• Prepared reports for management people by exporting reports generated on SSRS 2005 into excel 2003 files
• Created stored procedures for commonly used complex queries involving joins and union of multiple tables
• Created views for security and reporting purposes
• Created store procedures and triggers for automation tasks
• Involved in query optimization

Environment: MS SQL Server 2005, T-SQL, Excel 2003, MS Access, Microsoft Visio, Windows 2000/2003.