SUMMARY:

• Highly skilled Microsoft SQL Business Intelligence developer with close to 10 years of experience in providing business intelligence, database, and data warehousing solutions with Microsoft SQL Server within multiple industries such as banking, Insurance, and HRM
• SDLC: Agile, Scrum, Waterfall, and Spiral
• Databases: MS - SQL Server 2005, 2008R2, 2012, Oracle
• T-SQL Programming, Dynamic SQL, R language
• Data Modeling: ER-win, MS Visio
• Business Intelligence Tools: Power BI
• Collaboration Tools: SharePoint
• Programming Language: C#, VB.Net
• Integration Services (SSIS)
• Analysis Services (SSAS, OLAP Cubes)
• Reporting Services (SSRS, Report Builder)
• Development Tools: BIDS, SSDT, SSMS
• Source Control: Team Foundation Server (TFS), Rally, GIT

PROFESSIONAL EXPERIENCE:

Confidential

SQL/ETL/DW Developer

Responsibilities:

• Participated in gathering and analyzing requirement from end users and wrote the design documents.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Created and modified stored-procedures, triggers, cursors, and views.
• Modified index definition and implemented lookup techniques to optimize stored procedures and batches.
• Created stored procedures and SSIS packages to extract data from source and loaded into dimension and fact tables.
• Involved in the designing of OLAP system using star-schema methodology and converted data from various sources to SQL server tables.
• Created complex views on top of dimension and fact tables to provide access of data to business analysts.
• Created SSIS packages utilizing various transformations such as fuzzy lookup, fuzzy grouping, slowly changing dimension, aggregate and derived column transformations.
• Utilize Route data mart and vehicle data mart to analyze route and drivers schedule for BI activities.
• Repaired SSIS packages with checkpoints, breakpoints, and data viewers.
• Monitored and configured SSIS packages for dynamic execution; deployed packages to the testing environment.
• Scheduled SQL Server agent job files to initiate SSIS package execution.

Tools: and Environment: SQL Server 2012/2016, T-SQL, SSMS, Erwin, SSIS, SharePoint, TFS, DTA, SQL Profiler

Confidential, NJ

SQL/SSIS Developer

Responsibilities:

• Collaborated with different business users to capture information, documented the BRD and transformed the relevant /approved BRD into SRS and FRS.
• Involved in designing logical model with all relationships for database; forward engineered it to SQL Server with ER-Win.
• Involved in auditing database changes such as creating, altering, dropping of database objects with triggers
• Evaluated existing stored procedures for performance issues and modified them as needed.
• Implemented error-handling options in procedures and scripts utilizing try-catch blocks, throw, and raiserror.
• Analyzed frequently executed queries and designed covering indexes to avoid bookmark, key, and RID lookups.
• Developed complex database objects such as stored procedures, functions, packages and triggers.
• Designed and developed SSIS packages to import and export data from MS Excel, SQL Server and flat files.
• Utilize FTP task in SSIS to load to move files from one server to another server as per requirement.
• Implemented file system task in SSIS to move files from source folder to archive folder after loading data into tables.
• Wrote C# code in SSIS script task to check the existence of CSV and flat files before loading data into staging area.
• Debugged packages with breakpoints, event-handlers, data viewers, and custom loggings.
• Managed and deployed SSIS packages to the SSISDB catalog in SSIS 2012; automated package execution cycles.
• Created dynamic packages with configuration parameters, secured with passwords and encryption methods.
• Checked in changes in SSIS packages, reports, cubes and database objects utilizing Team Foundation Server (TFS).

Tools: and Environment: SQL Server 2012, T-SQL, SSMS, MS Excel, Erwin, SSIS, SharePoint, TFS, DTA, SQL Profiler

Confidential, Buffalo, NY

SQL/SSIS Developer

Responsibilities:

• Collaborated with business users for requirements and translating the business requirements into technical specifications.
• Analyzed data flow and business requirements to create high level design document.
• Completed the business needs of the client by creating tables, procedures, functions, and triggers.
• Implemented procedures with multiple temporary objects such as temporary tables, CTEs, and table variables.
• Implemented data transfer between SQL Server and flat files utilizing BCP utility and bulk insert.
• Wrote complex stored procedures for data profiling and data scrubbing techniques.
• Created and maintained schema architecture following the best design practices to assure the effectiveness and consistency of the design for data mart.
• Created staging database to perform various ETL operations (data profiling, data cleansing, and data verification).
• Developed ETL process to extract data from OLTP sources into the data mart utilizing SSIS packages with checksum and timestamp as incremental load technique.
• Extended the functionality of new and existing SSIS packages by implementing appropriate error handling at control flow/data flow level, checkpoints, and loggings.
• Modified package properties such as delay validation, transactions to meet the business needs of data in data mart.
• Managed multiple versions of code and distributed them across team utilizing Team Foundation Server.

Tools: and Environment: Microsoft SQL Server 2008R2, BIDS, SSMS, T-SQL, SSIS, ER-Win, SharePoint, TFS, DTA

Confidential, Austin, TX

ETL/SSIS Developer

Responsibilities:

• Involved in gathering business requirements from clients through JRD sessions for functional and nonfunctional requirements
• Involved in supporting application team by creating views, procedures and functions.
• Analyzed and improved the efficiency of the queries by analyzing the execution plan.
• Retrieved hierarchical data from database utilizing recursive CTEs
• Created procedures, scripts with set based operations and row by row operations.
• Utilized multiple transformations such as lookup, fuzzy lookup for implementing the transformation logic in the packages.
• Implemented slowly changing dimension (SCD) type 2 to maintain historical data.
• Implemented error handling in SSIS packages utilizing event handlers, and utilized loggings to monitor execution.
• Involved in debugging of packages with help of breakpoints, checkpoints, event handlers, data viewers and loggings.
• Maintained different versions of code being delivered by check-in and check-out in TFS

Tools: and Environment: MS SQL Server, BIDS, SSIS, Erwin, SQL Profiler, SQL Debugger, SharePoint, GIT, Excel

Confidential, Philadelphia, PA

BI/ETL Developer

Responsibilities:

• Generated T-SQL script to create all database objects and relationships.
• Identified and wrote code to prepare for newer SQL Server version migrations.
• Created stored procedures and functions for data storage and manipulation.
• Utilized different types of isolation level by help of different lock mechanism to avoid deadlock.
• Created packages with multiple transformations to cleanse data and apply business rules.
• Implemented master child package technique to manage big ETL projects efficiently utilizing Execute package task in SSIS.
• Incorporated error redirection during ETL Load in SSIS Packages. Involved in unit testing and system testing of ETL process.
• Promoted SSIS Packages from test environment to production environment by maintaining multiple package configurations in SSIS.
• Scheduled jobs for database backups and restores utilizing SQL Server Job Agent.

Tools: and Environment: SQL Server 2008 Enterprise Edition, SSIS, SSRS, Query Analyzer, T-SQL, Excel, Visio, DTA, SQL Profiler

Confidential, Harleysville, PA

BI Developer

Responsibilities:

• Created use cases, use case diagrams, activity diagrams and gathered requirements with Erwin.
• Involved in normalization of existing ER diagrams for data quality improvement.
• Created multiple check constraints to maintain data integrity.
• Wrote complex queries, stored procedures, UDFs to support OLTP database.
• Involved in data analysis for the existing data warehouse and changed the internal schema for performance.
• Implemented indexes on tables and views for optimum query performance upon DBAs recommendations.
• Scheduled SQL jobs and alerts for SSIS packages and procedures.
• Created drill down reports for users to access summary as well as detailed data
• Reduced report lag by optimizing the embedded data set.

Tools: and Environment: SQL Server 2008/05, SSIS, SSRS, SSMS, T-SQL, Windows Server, SQL Profiler, DTA

Confidential, Newtown, PA

SQL Developer

Responsibilities:

• Created multiple database objects such as tables, views, indexes, indexed views, stored procedures, and UDFs.
• Involved in gathering and analyzing the end user requirement and system specification
• Involved in the preparation of scripts, documentation for design and user maintenance
• Created constraints, triggers to ensure database consistency and enforce business rules.
• Created clustered and non-clustered indexes on tables ensuring the efficiency and latency of queries
• Designed complex views and scripts to convert business logic for different reports
• Moved logic from reporting services into stored procedure to improve performance
• Created ad hoc reports to validate the information inserted to the warehouse after refreshing it with SSRS

Tools: and Environment: SQL Server 2008/05, SSIS, SSRS, SSMS, T-SQL, Windows Server, SQL Profiler, DTA