SUMMARY:

• A SQL Developer wif 8+ years of IT experience in database design, development, and administration wif MSSQL Server 2017/ 2016/2 /2005/2000 using SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS) in Healthcare, Insurance and Banking industries.
• Conversant wif all phase of Software Development Life Cycle (SDLC) involving System Requirements, Analysis, Design, Development, Implementation, Integration, Testing, Deployment and Maintenance.
• Extensive noledge and experience in dealing wif Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Triggers, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Experienced in ETL processes, Data warehousing methodologies and concepts including Star schemas, Snowflake schemas, Dimensional modeling, Reporting tools, Operations Data Store Concepts, Data Marts and OLAP technologies
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Copy Program (BCP)
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from teh OLTP to OLAP wif teh halp of SSIS.
• Worked on Scrum Methodology as well as on SDLC procedures in teh implementation of Tableau and Spotfire.
• Highly proficient in teh use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models, data integrity, SQL joins and query writing.
• Efficient in up-gradation and migration from MS SQL Server 2005,2008/2008R2 to MS SQL Server 2014/2016.
• Experience in developing Custom Report, Tabular Reports, Matrix Reports, Ad hoc reports, and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column and Data Conversion Transformations.
• Experience in using Audit functions and extensively used Exception Handling for catching and reporting errors.
• Proficient at data transformations like lookups, Derived Column, Conditional Splits, Sort, Data Conversation, Multicast and Derived columns, Union All, Merge Joins, Merge, Fuzzy Lookup, Fuzzy Grouping, Pivot, Un-pivot and SCD to load data in SQL SERVER destination.
• High degree of proficiency in gathering user specifications from business users and preparing detailed Business Requirement Documents (BRD’s).
• Experience in creating simple and parameterized reports and complex reports involving Sub Reports, Matrix Reports, Tabular Reports, and Charts/Graphs using SSRS in Busines Intelligence development studio (BIDS)
• Scheduled Automatic refresh and scheduling refresh in Power BI service.

TECHNICAL SKILLS:

LANGUAGES: T-SQL, PL/SQL, Java, HTML5/CSS/Java Script, XML, C++, C#, PowerShell

DATABASES: SQL Server 2016/2014/2012, MS Access, MySQL, DB2, Oracle 9/10g/11g

Operating Systems: Windows NT/2000/XP Pro/VISTA, Windows Server 2003/2008, Linux, Unix

Microsoft Business Intelligence Stack: SSRS/SSIS/SSAS, Crystal reports

ETL Tools: DTS, SSIS, Business Intelligence Development Studio (BIDS)

Data Modeling Tools: Erwin, Microsoft Visio

Data Tools: SQL Query Analyzer, SQL Enterprise Manager, SQL Server Management Studio (SSMS), SQL Server Query Editor, Solution Explorer, Analysis Manager, Reporting Server, SQL developer, SQL profiler, Query Analyzer, SQL Sever data tools (SSDT)

Version Control/Utilities: Centralized Version Control System (CVCS), SVN, Agile/Scrum, JIRA, GIT/GIT Hub

WORK EXPERIENCE:

Confidential, Bowie, MD

SQL SERVER/MS BI Developer

Responsibilities:

• Responsible for technical design, development, coding, testing, debugging and documentation of databases and database applications to satisfy requirements of one or more user areas.
• Responsible for creation of data services and integrating teh data service components.
• Collaborate wif other developers in creating optimal, maintainable, and scalable architecture and design and actively promote quality in coding and other project activities.
• Create high quality, detailed technical documentation on teh whole database for teh Current Project.
• Responsible for teh database for teh current project, where data is dumped into teh database and scrubbed into teh correct format per teh requirement given by teh client.
• Extensively used Joins and sub Queries to simplify complex queries involving multiple tables.
• Responsible for enterprise level solutions development including data warehousing, data marts and/or software applications.
• Responsible for high performance of data architecture and design including Star Schemas, Snowflake Schemas, and Dimensional Modeling.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task.
• Developing complex SSIS packages using different data transformations like Aggregate Conditional Splits, Lookup, Sort, Merge Join, Data Conversions, Derived Columns, Multicasting, Slowly Changing Dimensions, Scripting, OLEDB Command wif SQL etc.
• Developed CTE's, Constraints, and Complex queries to fetch teh data from different servers.
• Actively involved in writing SQL Stored Procedures, functions, and triggers for updating customer usage information in teh database.
• Developed several behavioral reports and data points creating complex SQL queries and stored procedures using SSRS and Excel.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement teh business logic and created clustered and non-clustered indexes.
• Implemented teh changes/modification like iterative/incremental development and used .NET Framework and Object-Oriented Methodologies for application development by using agile scrum methodology.
• Developing SSIS packages that upload multiple flat files using for each Loop Container and uses other control flow tasks like File System task, FTP task, Send Mail Task, Script Task etc.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and implemented stored procedures and triggers for automating tasks.
• Built ETL workflows using SSIS tools to extract teh data from feed files (wif teh formats like XML, TXT, DAT, XLS, Message Queues, etc.,) and load them into staging area and then to Data Warehouse.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created a tree view application to view teh recent reports generated and a scheduler to schedule a selected report to be run on a date.
• Generated reports using SSRS, Power Pivot, and Power BI that could be used to send information to a diverse group of users, clients, and managers.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Generated reports using SSRS, Power Pivot, and Power BI that could be used to send information to a diverse group of users, clients, and managers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Scheduling Daily, Weekly and Monthly SSIS package execution process using SQL Server Agent jobs.

Environment: SQL Server 2016/2014/2012, Clustering, SSIS, SSRS, T- SQL, Visual BasicsVisual Studio 2012/2015, Indexes, Cluster, .Net Framework 3.5, MS Office suite 2011

Confidential, Silver Spring, Maryland

MS SQL Server/ SSIS Developer

Responsibilities:

• Involved in Gathering end user requirements, developed applications and different audit functionalities depending on teh requirement acting for both system analysts and application developer.
• Composed user requirement documents, created technical specs and design documents for various projects.
• Extensive experience in designing teh Data models for OLTP & OLAP database system.
• Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, using industry leading Data Modeling tools like ERWIN.
• Generated complex T-SQL queries, sub-queries, co-related sub queries, dynamic SQL queries.
• Programming in SQL server using stored procedures, triggers, views, user-defined functions.
• Involved in database design, normalization, de-normalization in building data warehouse and reporting systems.
• Involved in query tuning by creating cluster and non-cluster indexes on tables, and used index tuning wizard.
• Worked wif several control flow tasks, data flow tasks, transformations (derived column, lookup, merge join, conditional split, slowly changing dimensions, data conversion etc.) in SSIS packages.
• Used event handlers for event handling which includes on pre execute, post execute and error.
• Involved in package logging in both standards (SQL server and file based) and custom logging using customer stored procedure and tables.
• Involved in monitoring and deployment of SSIS packages across dev., uat, and production environments using command prompt wif .bat files etc.
• Involved in installation, configuration, maintenance, deployment and troubleshooting SSRS reports.
• Created complex reports like table report, matrix report, cascading report, sub reports, drill down, drill through and chart reports using complex data set queries, stored procedures, views in SSRS 2005/2008.
• Created ad hoc reports more often based on end user requirements.
• Performed daily DBA activities, security assignment, user setup, backup, restore and job monitoring on MS SQL Server
• Generated and formatted reports using global variables, expressions, and functions.
• Involved in developing parameterized reports using single values, multi values and cascading parameters.
• Built TEMPeffective queries for high performance reporting and rendered them to html, xml, pdf, MS word and excel formats using SSRS (2005/2008).

Environment: SQL server 2000/2005/2008, SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle 9i, Enterprise Manager, ERWIN Data Modeler, SSIS, SSRS, SSAS, Windows Server 2003/2008, OLTP, OLAP, DTS, HTML, XML, Visual Studio 2008, ETL, MS Access

Confidential, PA

SQL Server/MS BI Developer (SSIS/SSRS)

Responsibilities:

• Worked wif Client/Business Analysts to define data requirements for reporting warehouse.
• Designing and developing SQL Server 2008 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Created and developed teh stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks wif ETL Tool.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.
• Designed and developed ETL process wif SCD (slowly changing dimensions) wif T-SQL, SSIS and VBScript
• Migrate teh data from an Access database to SQL Server 2008.
• Fetch teh data from Oracle 10g by creating a linked server and use SQL Server to query Oracle database.
• Designed teh packages in order to extract data from SQL DB, flat files and loaded into Oracle database.
• Wrote and maintained database documentation, including data standards, procedures, definitions for teh data dictionary and logical and physical models of teh databases.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Designed best practices document for ETL and Reporting Systems using Data Warehouse concepts.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Design, deploy, and maintain various SSRS Reports in SQL Server 2008.
• Involved in teh preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports using SSRS.
• Reports in both SQL and reporting tools such as Crystal Reports and Business Objects
• Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Used SQL Server Profiler to trace teh slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: SQL Server 2014/2012/2008/2005/2000 R2, T-SQL, SSRS, SSIS, SSAS, Visual Studio 2008, MS Office 2007/2003, XML

Confidential

SQL Developer

Responsibilities:

• Installation of SQL Server 2005/2008 on production, development, and testing environments.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, and Constraints.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Implemented database management techniques that include backup/restore, import/export and generated scripts.
• Involved in Query Optimization, Performance Tuning and rebuilding teh indexes at regular intervals for better performance.
• Implemented Error handling in several existing Stored Procedures using Try Catch blocks.
• Worked in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing Cubes using MDX.
• Implementing Backup and recovery process and Replication process.
• Developed many small and complex packages to perform ETL Operations.
• Worked on Deploying Packages and providing security while deploying.
• Helped designing and implementing processes for deploying, upgrading, managing, archiving, and extracting data for reporting.
• Transferred data (ETL) to Data warehouse environment using SSIS.
• Created indexes on teh database tables and generated trace events to improve teh query performance and optimize data access.
• Designed and Implemented teh Stored Procedures for automating tasks.

Tools: and Technologies: SQL Server 2000/2005/2008, SSIS, Oracle, JAVA, Enterprise Manager, Windows 2000/2003, SQL Profiler, T-SQL.