SUMMARY

• Enthusiastic IT professional having over 8+ years of software services experience in Database Design Development, ETL Implementation and support of OLAP/OLTP/Data warehouse systems using Microsoft SQL Server 2016/2012/2008/2005 across various SDLC environments. I have worked in industries including Manufacturing.
• Extensive experience in BI suite - using integration services (SSIS) for ETL (Extraction, Transformation and Loading), reporting services (SSRS) and Power BI tools for creating different types of reports and analysis services (SSAS) for design and developing complex cubes.
• Experience in extraction, transformation and loading (ETL) of data flows using SSIS with complex integration of SQL Server, oracle, flat file sources.
• Expert in writing T-SQL, working with DTS (Data transformation services) data cleansing, data scrubbing and data migration.
• Expertise in creating indexed views, complex stored procedures using execution plan, tuning advisor and profiling, effective functions, and appropriate triggers to facilitate efficient data manipulation to maintain data consistency.
• Sound knowledge of SQL server administrative skills including, backups, disaster recovery, database maintenance, user authorizations and database creation.
• Used various SSISTransformations such as conditional split, derived column etc. on the data retrieved, performed datavalidation checks during staging and then loaded the data.
• Involved in XML Development and XML File Parsing in SSIS.
• Developed, tested and deployed SSISpackages in different environments for various projects.
• Implemented failure alerts using Send Mail Taskin SSIS.
• Created SQL server configurations for SSISpackages and XML & Windows event logs.
• Using MS Visio 2010 created and implemented the logical and physical models of the database.
• Designed and developed SSISPackages to extract datafrom 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 Taskand Data Flow Task.
• Used SSISfeatures like package event handlers, property expressions, and package configurations, transactions in packages, checkpoints and protection levels.
• Experience in creating SSISpackages 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 packages with SSIS configurations and scheduled jobs with SQL Server agent.
• Heavily used functionalities for organizing error and event handling by giving precedence constraints, break points, check points, logging and data viewers.
• Created & formatted cross-tab, conditional, drill-down, top n, summary, form, sub reports, Ad hoc reports, parameterized reports, interactive reports & custom reports.
• Experience in providing SSRS server level, item level security & accessibility to various reports in multi-user environment.
• Proven ability and extensive experience in creating actionable dashboards and reports..
• Designed and implemented trending reports.
• Created interactive reports with SSRS, using the report parameters, query parameters, filters and expressions.
• Created SSRSreports 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 report.
• Working with Power Pivot, Power View creating visuals, building dashboards, and customization to meet the needs of end-user.
• Generated interactive dashboards in Power View using Power BI.
• I have always maintained positive communications and working relationship at all levels.
• An enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills with good work ethics.

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), Power BI

Data Modeling: SQL Server Analysis Services (SSAS)

Languages: T-SQL, C#

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

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

Office Tools: MS Word, Power Point, Excel, Access

PROFESSIONAL EXPERIENCE

Confidential, Franklin Park, IL

SQL Server/SSIS/SSRS/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 Viewreports 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 SQLServer staging tables before loading into final destination.
• Responsible for loading the data using SSISpackages to fact and dimensional tables.
• Used SSISto 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 Power BI.
• Worked on sharing the dashboards, data refresh, building data models and created high density reports using Power BI.
• 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 meetings with end users to create user stories and BRD.
• Ability to communicate with Supervisors, Executives, BA’s, DBA’s and Developers
• Optimized Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• CreatedSSISpackages from an XML source combined with left joins stored procedures to capture the Incremental changes for the data warehouse.

Environment: SQL Server 2012/SSIS/Power BI

Confidential, Wheeling, Illinois

SQL Server Business Intelligence Developer

Responsibilities:

• Have developed and maintained T-SQL Stored 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 SSRSreports 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 SQLServer.
• Responsible for loading the data using SSISpackages to fact and dimensional tables (Kimball data modeling).
• Identified and defined the datasets for the report generation.
• Generated SSRSdashboards.
• Developed complex Stored Procedures and views to generate various Drill-down/Drill-through reports.
• Created check constraints, business rules, indexes, and views.
• Optimized Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• CreatedSSISpackages to capture the Incremental changes for the data warehouse.

Environment: SQL Server 2012/2008R2/SSIS

Confidential, Elk Grove Village, IL

SQL Server/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 usingSSRS.
• Developed different kind of reports such as sub reports, charts, matrix reports and linked reports.
• Developed reports using complex formulas and to queries to generate different types of ad-hoc reports usingSSRS.
• Implemented stored procedures for report generation inSQLServer2008.
• Creating index, views, and complex stored procedures, triggers, cursors and appropriate user defined functions to implement the business logic.
• Built efficientSSISpackages 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 usingSQLServer Reporting ServicesSSRS.
• Developed Reports with different styles of visualization techniques like tables, charts and graphs.

Environment: MSSQLServer 2000/2005/2008 R2,SSIS,SSRS