SUMMARY

• Around 8 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 Subqueries, 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 and 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.
• Experience in Data Warehousing methodologies and concepts, including Star Schemas, Snowflake Schemas, ETL processes, dimensional modeling and reporting tools.
• Strong relational database background in SQL Server with extensive knowledge in writing the T-SQL scripts, Stored procedure, Triggers, Views, Database designing and Maintenance.
• Proficient in creating Jobs, Alerts, SQL Mail Agent, and scheduling SSIS packages using SQL server agent.
• Experience in Extraction, Transformation and Loading (ETL) of data flows using SSIS with complex integration of SQL Server Tables, flat files, Excel files and comma separated file (.CSV) Sources and Experienced in using multiple control flow and Dataflow Tasks.
• Strong experiences to Design, deploy, and maintain various SSRS Reports in SQL Server 2012.
• A team as well as independent, 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 queries in Power BI desktop to show good data analysis techniques.
• Experience in creating visualizations using Power BI and proficiency in various chart types like Bar, Line, Tree maps, Matrix and KPI's on graphs.
• Experience in Power BI to create various analytical dashboards and reports with various visuals and experienced in on-premises gateway setup.
• 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

ETL Developer

Responsibilities:

• Involved in business requirements mapping to the data model.
• Gathered and studied system requirements by analyzing real time business needs.
• Developed Stored procedures to do the data load to target systems.
• Created Index to optimize performance of T-SQL queries and created Views to reduce complexity of end users.
• Developed T-SQL Stored Procedures and packages to perform ETL
• Created SQL Jobs to schedule SSIS Packages
• Used indexes to enhance the performance of individual queries and enhance the Stored Procedures.
• Developed multistage ETL packages using For-each-loop, Execute Package Task, Data Flow task, Execute SQL task, Custom Script Task, Derived Column, Data Conversion, Conditional Split and Multicast.
• Create technical artifacts needed for project implementation.

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

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 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 processes, data transformation processes and loading processes.

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