SUMMARY:

• Microsoft Certified Business Intelligence Developer with 8 years of work experience in developing Business Intelligence applications and enterprise Data Warehouses at various phases of SDLC.
• Extensive experience on developing Business Intelligence applications with SSIS and SSRS.
• Created OLAP applications with OLAP services in SQL Server and builtmulti - dimensional cubes.
• Led teams on software development and best practices for developing BI applications.
• Highly motivated, self-starter that is also passionate about technology. Assesses and addresses a client's business needs and use right tools and frameworks to build effective solutions.
• Used various SSIS Transformations such as conditional split, derived column etc. on thedataretrieved, performeddata validation checks during staging and then loaded the data.
• Involved in XML Development and XML File Parsing in SSIS.
• Developed, tested and deployed SSIS packages in different environments for various projects.
• Implemented failure alerts using Send Mail Task in SSIS.
• Provided logging, error handling by using custom logging for SSIS Packages.
• Created SQL server configurations for SSIS packages and XML & Windows event logs.
• Using MS Visio 2010 created and implemented the logical and physical models of the database.
• Designed and developed SSIS Packages to extract data from variety of sources like XML, CSV, Excel and OLEDB.
• Used Different Packages like For Each Loop, Sequence Container, Execute SQL Task, Script Task, File System Task and Data Flow Task.
• Used SSIS features like package event handlers, property expressions, and package configurations, transactions in packages, checkpoints and protection levels.
• Experience in creating SSIS packages using different type's task such as bulk insert, web services, XML, script, send mail and FTP and with error handling.
• Worked on data flow transformations like XML source, multicast, merge Join, lookup, and data Conversion.
• Deployed with SSIS configurations and schedulingwith SQL agent.
• Heavily used functionalities for organizing error and event handling by giving precedence constraints, break points, check points, logging and data viewers.
• SSRS
• Proven ability and extensive experience in creatingactionable dashboards and reports.
• Extensively experience in developing reports with drill down reports, drill through reports, parameterized reports, table reports, chart reports, matrix andsub reports.
• Designed and implemented trending reports.
• Created interactive reports with SSRS, using the report parameters, query parameters, filters and expressions.
• Created SSRS reports with complex calculation fields.
• Excellent experience in performance tuning and optimization of SSRS Reports
• Implementation of security in SSRS report at item level and group level with SSRS roles.
• End-to-end development experience from gather requirements to deployment of SSRS reports
• Implemented and configured subscriptions(both data driven, normal subscriptions) to deliver reports.
• Extensive experience in using T-SQL creating tables,stored procedures, views, indexes, cursors, triggers, user defined functions, database models and data Integrity in SQL Server 2012/ 2008/2005 platforms.
• Designed and developed databases with the best practices of data modeling and data normalization(Kimbal).
• Extensive experience in performance optimization of SQL queries and stored procedures using execution plan, tuning advisor and profiling.
• Knowledge in Power Query, Power Pivot, Power View working with PowerPivot,Power View creating visuals, building dashboards, and customization to meet needs of the end-user generated interactive dashboards in Power View

TECHNICAL SKILLS:

DBMS/RDBMS: MS-SQL 2012,2008R2, 2005

ETL: SQL Server Integration Services(SSIS),SQL Server Import/Export wizard

Report Tools: SQL Server Reporting Services (SSRS), PowerBI

Data Modeling: SQL Server Analysis Services (SSAS)

Languages: T-SQL,C#

Operating System s: Windows server 2008/2003/XP/Vista, Windows 7/8

BI Tools: SQL Server Management Studio (SSMS), Data Tools (previously BIDS)

Office Tools: MS Word, PowerPoint,Excel

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

SQL Server BI/SSIS Lead

Responsibilities:

• Developed and maintained T-SQL Stored Procedures, Data Models with Primary Keys and Unique Keys according to the business requirements.
• Implemented complex SQL queries using joins, Try-Catch Blocks, and T-SQL Stored Procedures with Parameters, User Defined Functions.
• Implemented logging to enforce SSIS Package integrity for auditing purpose.
• Created packages using Integration Services (SSIS) for extracting data from XML, Excel files, OLEDB to SQL Server staging tables before loading into final destination.
• Responsible for creating Parent and Child packages with email notifications on success.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Assisted other developers with package creation and error handling.
• Addressed data quality by using Conditional Split, Fuzzy Look-Up, Derived Column
• Modifying,Enhancing, Performace tuning past SSIS packages to new standards
• Worked with off shore team to create solutions for enhancing SSIS packages.
• Help to create Business Requirement Document based on the needs of the end users.
• Hosted several meeting with end users to create user stories and BRD
• Ability to communicate with Supervisors, Executives,BA’s,DBA’s,Developers
• Optimized Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Created SSIS packages from an XML source combined with left joins stored procedures to capture the Incremental changes for the data warehouse.

Environment: SQL Server 2012/SSIS, SharePoint SQL Server

Confidential, Addison, TX

Server BI/SSIS/PowerBI ETL Developer

Responsibilities:

• Have developed and maintained T-SQL Stored Procedures, Data Models with Primary Keys and Unique Keys according to the business requirements.
• Implemented complex SQL queries using joins, CTE’s, and T-SQL Stored Procedures with Parameters.
• Define reporting needs and implement Power Pivot/ Power View reports to satisfy needs
• Implemented company custom logging to enforce SSIS Package integrity for auditing purpose.
• Created packages using Integration Services (SSIS) for extracting data from XML, Excel files, OLEDB to SQL Server staging tables before loading into final destination.
• Responsible for loading the data using SSIS packages to fact and dimensional tables.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, DataMart databases.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using PowerBI
• Identified and defined the datasets for the report generation.
• Developed complex Stored Procedures and views to generate various reports using slicers and line graphs.
• Created Business Requirement Document based on the needs of the end users after one on one interviews and project meetings.
• Hosted several meeting with end users to create user stories and BRD
• Ability to communicate with Supervisors, Executives,BA’s,DBA’s,Developers
• Optimized Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Created SSIS packages from an XML source combined with left joins stored procedures to capture the Incremental changes for the data warehouse.

Environment: SQL Server 2012/SSIS/PowerBI, SharePoint SQL Server

Confidential, Dallas, TX

SQL Server BI/SSIS/SSRS ETL Developer

Responsibilities:

• Have developed and maintained T-SQLStored Procedures, User Defined Functions and Data Models according to the business requirements.
• Implemented complex SQL queries using joins, sub queries and correlated sub queries.
• Define reporting needs and implement SSRS reports to satisfy needs
• Developed database triggers to enforce data integrity, dependent tasks and for auditing purpose.
• Created packages using Integration Services (SSIS) for extracting data from XML Files, Excel files, OLEDB to SQL Server.
• Responsible for loading the data using SSIS packages to fact and dimensional tables(Kimbal data modeling).
• Generated reports based on the analysis of the data from various time frame and division using SQL Server Reporting Services (SQL)
• Identified and defined the datasets for the report generation.
• Generated SSRS dashboards for sales with reference lines
• Developed complex Stored Procedures and views to generate various Drill-down/Drill-through reports.
• Createdcheck constraints, business rules, indexes, and views.
• Optimized Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Created SSIS packages to capture the Incremental changes for the data warehouse.

Environment: SQL Server 2012/2008R2/SSIS/SSRS

Confidential, Dallas, TX

SQL Server BI/SSIS/SSRS ETL Developer

Responsibilities:

• Supported efficient data insertion, manipulation and retrieval using various joins, indexed views, stored procedures and functions.
• Created SSIS packages to capture the incremental changes for the data warehouse.
• Developed SSIS packages using for each loop in control flow to process all flat files within folder, File System Task to move file into archive after processing and execute SQL task to insert transaction log data into the SQL table.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Responsible for creating database objects like table, views, storedprocedures, triggers, functions using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS packages to capture the Incremental changes for the data warehouse.
• Developed various operational drill-through and drill-down reports using SSRS.
• Identified and added the report parameters.
• Implemented data conversion from text file into SQL server tables.
• Implemented complex business requirements in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.

Environment: MS SQL Server 2000/2005/2008 R2, SSIS, SSRS

Confidential, Dallas, TX

SQL Server BI/SSIS/SSRS ETL Developer

Responsibilities:

• Worked on agile sprint based development process and successfully delivered various reports.
• Developed various operational drill-through and drill-down reports using SSRS
• Developed different kind of reports such assub reports, charts, matrix reports and inked reports.
• Developed reports using complex formulas and to queries to generate different types of ad-hoc reports using SSRS.
• Implemented stored procedures for report generation in SQL Server2008.
• Creating index, views, and complexstored procedures, triggers, cursors andappropriate user defined functions to implement the business logic.
• Built efficient SSIS packages for processing fact and dimension tables with complex transformations and Type I and Type II changes.
• Created mappings for conditional split, merge, merge join, export column, import column, audit and SCD transformations.
• Created Data Conversion package which converts columns to different types and adds columns to datasets.
• Supported the team through the entire Business Intelligence project life cycle
• Developed parameterized reports using SQL Server Reporting Services SSRS.
• Developed Reports with different styles of visualization techniquesliketables, charts and graphs.

Environment: MS SQL Server 2000/2005/2008 R2, SSIS, SSRS

Confidential, Houston, TX

SQL Server BI/SSIS/SSRS ETL Developer

Responsibilities:

• Developed T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex join and sub queries in SQL Server Management studio (SSMS) 2005.
• Designed and developed ETL packages with various data sources and destinations using SSIS 2005.
• Designed and developed reports, sub reports, data driven subscriptions, drill down reports and drill through reports using various features like Charts, graphs, filters etc.
• Used SSIS transformation for data cleansing to remove unnecessary columns, eliminated redundant and inconsistent data.
• Configured SQL mail agent for sending automatic emails when SSIS packages are failed or succeeded.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler.
• Developed and created new database objects including tables, views, indexes, triggers, stored procedures and functions.
• Wrote and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.

Environment: MS SQL Server 2000/2005/ SSIS, SSRS