SUMMARY

• Over 7+ years of working experience in MS SQL Server in various domains like Finance, HealthCare, Retail and Insurance with expertise in MS SQL Server … SSIS, and SSRS.
• Experienced in handling multiple tasks under strict deadline and capable of handling responsibilities independently as well as a proactive team member.
• Highly proficient in using T - SQL, writing Stored Procedures, Triggers, Functions, XML and Cursors in SQL Server.
• Expert in Data conversion, Data modelling, Normalization and SQL Server Enterprise manager.
• Involved creating ETL process, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies, MOLAP cubes, Including Star and Snowflake schema.
• Expert in Creating, maintaining and Configuring SSIS packages.
• Involved working with heterogeneous data source like Excel, Flat file and SQL Server.
• Expert in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Involved creating operational reports in SSRS … i.e. Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports for various domains.
• Expert in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks
• Involved in Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.
• Experience in scripting languages like VBA and utilizing them on designing and developing.
• Defined and administered database standards, controls, procedures and documented them
• Experienced in creating report by using Power BI Desktop.
• Expertise in Microsoft SQL Server BI reporting applications and tools (Management Studio, Reporting Services, Visual Studio/SSDT, Integration Services)

TECHNICAL SKILLS

Databases: SQL Server 2008/2, Azure (Cloud Server), Access, MySQL Oracle

Programming Languages: T-SQL, HTML, XML, PowerShell, VB.NET, ASP.NET

BI Tools: SSIS, SSRS, Power BI

Operating Systems: Windows Server 2007, 2010, 2013, Windows 8/10/NT/XP/Professional, MS-DOS, Red Hat Linux

Version Control: TFS/GIT/SVN

Languages: T-SQL,PL/SQL, C/C++, HTML, XML, VBScript, C#.Net, VB.Net, ASP.Net, ADO.Net, ActiveX, XML, MS Access, HTML, DHTML, Shell Scripting

PROFESSIONAL EXPERIENCE

Sr. SQL/SSIS/SSRS Developer

Confidential - Fairfax, VA

Responsibilities:

• Participated in daily agile scrum meetings to understand business logic and requirements of the company.
• Involving in complete software development life cycle (SDLC) like Requirement Analysis and Specification, technical design and Implementation.
• Writing Joins and sub-queries for complex queries involving multiple tables from different database.
• Wrote different Validation Scripts to check the accuracy of data.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Created complex Views, Stored Procedures, Triggers, Functions, Indexes, Tables, SQL joins and other T-SQL code to implement business rules for SSRS reports. Implemented different types of constraints on tables for consistency.
• Generated SSIS Packages using Fuzzy Lookup, Derived Columns, Conditional Splits, Aggregate, Execute SQL Task, Data Flow Task, and 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.
• Creating reports subscriptions using SSRS to send data in PDF, Word and Excel format on Daily, weekly, monthly and yearly basis via emails and sending to shared folders.
• Involved in designing and deploying Tabular, Matrix, List and Chart reports with Drill Down, Drop down menu option, Parameterized and Sub reports.
• Responsible for designing, developing and deploying Drill through, conditional and dynamic reports.
• Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Lookups, Aggregations, and Multitasking.
• Designing, deploying, scheduling and maintaining various SSRS Reports in SQL Server in test, staging and production environments.

Environment: Windows2003 Advanced Server, ASP.Net, MS SQL Server 2008/2012/2014, TSQL, Pl/SQL, Visual Studio 2008, Oracle 11g, Cognos, Qlikview, Lotus Notes, SSRS, SSIS, OBIEE, Informatica, Erwin.

SQL/SSIS/SSRS Developer

Confidential - Detroit, MI

Responsibilities:

• Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Migrated SSIS packages from SQL Server 2008 to SQL Server 2012 as SSIS Project Packages.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Worked in the entire phase from requirements gathering to post-deployment support in an agile environment.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Followed the Agile methodology and maintained the backlog.
• Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Handled Tableau admin activities granting access, managing extracts and Installations
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases extensively
• Worked on Database Compression for different databases to save space across different environments.

Environment: Windows 2008 Advanced Server, ODBC, MS SQL Server 2008/2012, TSQL, PL/SQL 11g, Informatica, Visual Studio 2008/2010, SharePoint 2007/2010, Lotus Notes, Oracle, SSRS, SSIS, Erwin, Agile.

SQL/SSIS Developer

Confidential - Jersey City, NJ

Responsibilities:

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Worked on T-SQL Queries, Stored procedures to fetch complex data from different tables.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created logical and physical database design, data structures and maintained it by writing user defined functions, views, T-SQL scripts.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Worked with DBA team on Database Compression for different databases to save space across different environments.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Environment: SQL Server 2008/2012 Enterprise Edition, ODBC, BIDS, Crystal Reports 8.0, XML, ASP.Net, Visual Basic 6