PROFESSIONAL SUMMARY:

• 5+ Years of experience in SQL Programming, T - SQL Programing, Data Integration, ETL, Data Analysis.
• Extensive experience in SQL server 2008 R2, 2012, T-SQL, SSIS
• Experienced in developing data integration applications involving file operations over secure FTP server.
• Developed complex SQL code using complex joins, Group By, Having, sub queries, correlated sub queries, Functions, User Defined Functions
• Developed Functions, Stored Procedures using Temp tables, cursors, table type variables.
• Developed SSIS packages with various tasks like - FTP, File System, E-mail, For-each-loop, Execute Package, Data Flow task, Execute SQL task.
• Sourced data from various types of relational databases, flat files, excel files.
• Developed Transformations using Data Conversion, Audit, Derived Columns, Lookups, Merge, Merge Joins.
• In-depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.
• Developed technical documentation for existing Database systems as well as for newly developed systems.
• Strong experiences to Design, deploy, and maintain various SSRS Reports in SQL Server 2012
• A team as well as independent worker experienced in working on strict project management guidelines and time deadlines, providing estimates as well as timely project status.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Wrote calculated columns, Measures query’s in Power BI desktop to show good data analysis techniques.
• Worked on all types of transformations that are available in Power bi query editor

TECHNICAL SKILLS:

DBMS: SQL Server 2016,2014,2012, 2008 R2

ETL Tools: SQL Server Integration Services 2008R2, 2012,2017

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio

Web development: HTML, .Net 3.5, 4.5, SharePoint 2010

Reporting Tools: SSRS, Tableau,Power BI, MS Access 2010 Excel 2007, 2010, Report Builder 3.0

Operating systems: Win 2003/2008/XP, Windows 7/10, Win NT 4.0, Vista, 7

Other Tools: SVN, TFS, MS Office

PROFESSIONAL EXPERIENCE:

Confidential, Orlando,FL

ETL Developer

Responsibilities:

• Involved in business requirements mapping to the data model.
• Developed Stored procedures to do the data load to target systems.
• Research, analyze and report data patterns.
• Performed Logging and Deployment of various packages in SSIS
• Involved in Creating Complex ad-hoc Reports , Sub Reports, Linked Reports, Charts, Drill through and Drill down Reports.
• Designed, deployed, and maintained of various SSRS Reports.
• Experience in writing custom code expressions in SSRS .
• Created SQL Jobs to schedule SSIS Packages
• Wrote stored procedures to get the fields required for the reports.
• Worked with data extraction using SSIS and Data Warehouse staging, and loading.
• Implemented user based security in SSRS reports to limit the access of reports .
• Effectively used views to prevent unauthorized access.
• Used indexes to enhance the performance of individual queries and enhance the Stored Procedures.
• Identify issues in forming process, data transformation process and loading processes.

Environment: SQL Server 2016, SSDT 2017, T-SQL, TFS, MS-Excel

Confidential, Tampa

SQL Developer

Responsibilities:

• Developed Oracle and SQL server stored procedures, data mappings for data importing, exporting and parsing etc.
• Developed data quality scripts to validate, monitor and alert on invalid, bad or no data.
• Maintained and enhanced data mappings.
• Modified and recreated various packages for business needs and also added more alerts in case of package failure.
• Created Index to optimize performance of T-SQL queries and created Views to reduce complexity of end user.
• Created and modified various Stored Procedures using T-SQL.
• Scheduled packages to run daily and monthly using SQL Server Agent Jobs.
• Created documents for all SSIS Packages that I developed.
• Reverse-engineered database linkage to provide database version compatibility.
• Developed Tableau reports according to the BRD’s
• Designed data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line for better business analysis.
• Developed Excel PowerView, PowerQuery and PowerPivot dashboards for data analysis
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Environment: SQL Server 2012, Transact-SQL, MS-Excel, MS Access,SSIS, Tableau,PowerBI

Confidential

SQL Developer

Responsibilities:

• Designed data extraction, transformation and load processes
• Developed T-SQL Stored Procedures and packages to perform ETL
• Extracted .BAK, CSV and TXT files from secure FTP site
• Automated Database Restore processes and data warehouse processes to processes complete data warehouse
• Designed and developed stage data model and dimensional data model for data warehouse.
• Mapped disparate data sources - relational DBs and text files onto target schema.
• Developed multistage ETL packages using For-each-loop, Execute Package, Data Flow task, Execute SQL task, Custom Script Task, Analysis Services Task and Data Mining Task.
• Developed Transformations using Data Conversion, Audit, Derived Columns, Lookups, Merge, Merge Joins, Slowly Changing Dimension transformation
• Wrote complex T-SQL statements to ensure data consistency by filtering corrupt data and implemented various constraints and triggers to preserve data integrity.
• Developed SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2.
• Performed SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

Environment: SQL Server 2008, T-SQL, MS-Excel, MS Access