SQL development professional with strong verbal and written communication skills and solid analytical skills for writing relational database solutions for businesses. A self-starter who can work independently with 5.5 +years of experience.
Experienced in Client Requirement Analysis, Physical, Logical design, Development, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2016/2014/2012/2008R2/2005.
Worked on all phases of Data Warehouse development life cycle, from gathering requirements to testing, implementation and support.
Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.
Working knowledge in SQL Server Analysis Services (OLAP).
Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.
Worked with end users/business analysts to understand business requirements, recommended technical solutions and documented functional requirements
Worked with T- SQL, DDL, and DML Scripts and established relationships between tables using Primary Keys and Foreign Keys.
Proven ability in Performance Tuning, Query Optimization.
Well-versed in usage of SSIS Control Flow items (For Loop, Execute SQL task, Script Task, Send Mail Task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services(SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS)
Experience in Database Development, modeling, Data Warehousing, Design and Technical Management
Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedures consumed at various stages of migration/cleansing process, reports or data validation
Transformed data from one server to other server using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
Knowledge in Job Scheduling, Performance tuning, Normalization and De-normalization concepts.
Proficient in High Level Design of ETL Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
Expertise in developing various static, dynamic, drill- through, drill- down, matrix and sub-reports using SSRS.
Role:SQL Server SSRS /Power BI Developer Duration:Dec 2017- Present
Client:Vanguard Group - Malvern, PA
Experience in writing complex T- SQL queries and Stored Procedures for generating reports.
Successfully worked with Report Server and configured into SQL Server 2017
Create reports and dashboards for varying levels of an organization such as operational through executive management.
Responsible to monitor performance and optimize SQL queries for maximum efficiency.
Proficiently scheduled the Subscription Reports with the Subscription Report wizard.
Involved in the analysis, design, development, testing, deployment and user training of analytical and transactional reporting system.
Developed SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI reports.
Wrote complex T- SQL queries and created Stored Procedures, Triggers, Functions and Views.
Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV
Worked on production support team to resolve critical tickets.
Design and develop solutions that identify data issues and report errors for further analysis.
Extensive knowledge in tuning T- SQL (DDL and DML) queries to improve the database performance and availability.
Excellent report creation skills using Microsoft SQL Server 2014 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder
Created T- SQL queries, complex Stored Procedures, User-defined Functions, designing and implementing of Database Triggers (DDL, DML), Views and designing and implementing Indexes.
Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization.
Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
Collaborated with Business Analysts, SMEs and other BI developers across departments to identify existing report needs, new reporting requirements and translated them into deliverable solutions.
Role – ETL Developer Duration:Dec 2016 – Nov 2017
Client:UPS - Baltimore, MD
Designed Extraction Transformation and Loading (ETL) process using SSIS to extract data from flat files, excel files and SQL server database
Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Validation and Master Data Management in SSIS.
Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T- SQL code and SQL joins for applications.
Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T- SQL statements using SQL profiler.
Extracted data using SSIS packages (ETL) from different server locations and data sources.
Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse. Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
Extracting business data from different OLTP systems and loads into data warehouse using SQL server Integration Services (SSIS)
Role: SQL SSRS Developer Duration:July 2014- Nov 2016
Client:State Street - Boston, MA
Involved in Daily, Weekly Status Meetings with the team Members, PM and the Leads.
Based on business requirement, developed the Complex SQL queries with Joins and T- SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
Wrote SQL scripts, built reports and created dashboards with functionalities like drill down, drill through, cascading, conditional formatting etc. in SSRS.
Utilized derived tables, temporary tables and Common table Expressions in SQL.
Developed complex reports with multiple datasets and heterogeneous sources and created the automation process of report generation and distribution in SSRS.
Exported data from SSRS report to several file formats likes PDF and Excel according to the needs of management.