PROFESSIONAL SUMMARY:

• Experience in Database design, development and excellent experience in installing and designing, maintaining various RDBMS like T - SQL Server.
• Excellent skills in Transact-SQL of DDL and DML developing tables, joins, indexes, views, triggers, stored procedures, functions, Complex Queries, T-SQL Programming, query optimization and performance tuning in working with large databases.
• Knowledge on RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE's, Table Variables and Stored Procedures.
• Strong experienced in SSIS. Extract Transform Load (ETL) process tools to deploy packages with different data sources and various transformations.
• Defined data warehouse (star and snow flake schema), fact tables, cubes, dimensions, measures using SQL Server Analysis Services (SSAS).
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Generated Drill-down, Drill-through, cascading report
• Qlik Sense Developers/Admin

SKILLS / TOOLS:

Operating Systems: Windows 2000/XP/Vista, Windows Server 2008/2008 R2/2012

Databases: MS SQL Server 2008/2008 R2/2012

Database Tools: SSMS, SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, SQL Client Configuration utility, Redgate, Idera, SpotLite

ETL Tools: DTS, SSIS

Development skills: Transact SQL (T-SQL), Power Shell

Reporting Tools: SSRS, Power BI, Crystal Report

MICROSOFT BI SKILLS:

• SQL Server 2016, 2014, 2008R2, 2008
• SQL Server Reporting Service (SSRS)
• Crystal Report (CR)
• SQL Server Integration Service (SSIS)
• ETL
• Business Intelligence Development Studio (BIDS)
• Data Source (DS)
• SQL Profiler
• SQL Server Management Studio (SSMS)
• Qlik Sense Developers/Admin
• T-SQL
• Linked Server
• Open Query

PROFESSIONAL EXPERIENCE:

Confidential, CHICAGO, IL

SSIS /SQL Developer

Responsibilities:

• Developed and maintain SQL queries from multiple data sources to support the business.
• Updated reports based on new requirements and system changes, capture report requirements from end-users, and documenting requirements.
• Worked closely with team members to develop graphs, matrix reports, drilldown, drill through, sub reports, dashboards and presentations for quality activities, patterns or trends and operational metrics.
• Worked with Business Analyst, Data architect and business users to understand business requirements and translate them into functional and non-functional specifications for BI reports and applications processes, document project.
• Modified existing reports in SSRS using charts, graphs, tables and matrices.
• Used SQL to analyze, query, sort and manipulate data according to defined business rules and procedures using data manipulation and data definition languages.
• Worked with sources including Flat Files, Excel, and SQL , to perform the ETL (Extract Transform Load) process in SSIS.
• Migrated data from various sources into SQL Server 2016 and Archives using ETL tool in SSIS.
• Used various data transformations in SSIS like, conditional Split, derived column transformations to move data to/from various sources to different destinations.
• Used Joins to combine multiple tables and use as dataset to create reports in SSRS.
• Gathered and analyzed data, develop and build SSRS reports in support of the business.
• Assisted with Monitoring and performing daily maintenance including monitoring backups, managing disk space, and maintaining database objects
• Complete on Power BI (Desktop and Service) along with SSAS Tabular Model and DAX.

Environment: SQL Server 2016(SSMS), SQL Server Business Intelligent Development Studio 2012(BIDS), T-SQL, DTS, SSIS, MS Excel 2016.

Confidential, McKinney, TX

SQL developer/ SSRS Report Writer

Responsibilities:

• Utilizing SSRS to develop and maintain reports in accordance with style, functional, and technical guidelines established.
• Assembling and converting user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.
• Designing and deploying parameterized, matrix, drilldown, drill through, and sub reports.
• Used Joins to combine multiple tables and use as dataset to create reports in SSRS.
• Creating chart reports in excel for ad-hoc reporting using pivot tables.
• Creating SSRS report model projects in BI/Visual studio and creating, modifying and managing various report models with multiple model objects, source fields and expressions.
• Rendering reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and manage subscriptions.
• Writing and maintaining T-SQL queries including all SQL Server objects such as tables, views, stored procedures, user defined functions, etc., according to business requirements.
• Analyze data, discuss findings, and provide recommendations for new reports/dashboards.
• Deploying reports and creating email subscriptions, caches, snapshots and security on report manager for end users.
• Optimizing queries and stored procedures to improve performance.
• Involved in Ross ERP customizations
• Expand reporting functionality using Crystal Reports or SQL Server reporting services (SSRS)
• Streamline functionality to improve user productivity and data accuracy
• Interface Ross ERP to suppliers and customers using EDI
• Data importing / exporting / conversions
• Customized reports and Crystal Reports forms
• Integration with legacy systems external databases

Environment: Server 2014/2012, Windows 10, SQL Server Management Studio, Visual Studio, T-SQL, MS Excel 201

Confidential, Coppell, TX

SQL /BI Developer

Responsibilities:

• Responsible for ensuring a stable production environment using change management systems.
• Extensively Wrote and Edited Store Procedure. User Defined Functions and Triggers in T-SQL
• Participated in the data warehousing of major deployment and Migration projects.
• Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
• Developed tune queries, assigned proper indexes, and aided by developers in the creation of triggers and stored procedures.
• Monitored log space of all the instances with generation of reports.
• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Involved in complete SQL 2008 to SQL 2016 SSIS migration and SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.

Confidential, Dallas, TX

SQL/BI Developer

Responsibilities:

• Created T-SQL queries for data retrieval and created other database objects like tables, views, Stored Procedures, Functions, Triggers and indexes.
• Installed and configured SQL Server successfully.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Import & Export of data from one server to other servers using SQL Server Integration Services (SSIS).
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational, drill-through and drill-down reports using SSRS.

Environment: SQL Server 2012/2008 R2, SSRS, SSIS, XML, MS Excel, Access).