SUMMARY:

• Highly skilled SQL BI developer with over 9 years of experience in analysis, design, development, and implementation of database systems using MS SQL 2012/2008/R2/2005.
• Experience within multiple industries to include finance, healthcare, insurance, banking, and technology.

TECHNICAL SKILLS:

• MS - SQL Server 2005, 2008, 2008 R2, 2012
• Business Intelligence Tools: Power BI, Tableau
• Development Tools: SSMS, BIDS, SSDT
• Design Tools: ER-win, MS Visio
• SDLC: Agile, Scrum, Waterfall, and Spiral
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• Source Control: SharePoint, Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix AZ

MSBI Developer

Responsibilities:

• Communicated and coordinated with clients to understand business needs and expectations from the ETL Process.
• Collaborated with project manager, data architect and DBA to design data migration and conversion strategies.
• Wrote complex stored procedures for operations such as data conversion, incremental load, and index maintenance.
• Optimized the performance of queries and procedures utilizing different approaches such as indexing, table partitioning, CTEs, and followed Microsoft best practices for writing complex queries.
• Created staging database to perform various data migration operations such as data profiling, data conversion and verification.
• Examined and evaluated data structures of the source/legacy systems, analyzed data quality and performed data cleanups.
• Developed SSIS packages with variety of transformations such as look up, derived column, conditional split, fuzzy lookup, multicast and data conversion to filter out bad data.
• Utilized event handlers, custom logging and error row redirect to handle run time errors in SSIS packages.
• Configured SSIS packages with parameters and deployed in the SSISDB catalog utilizing project deployment model.
• Coordinated with the testing team for data validation and trial conversion activities and load data for testing and live conversion into applicable databases.
• Created various SSRS reports such as drill down, drill through, cascaded parameterized, multivalued and cross tab reports per business requirements.
• Designed various dashboards and score cards along to support analysis utilizing Power BI.
• Optimized SSRS report data sets to reduce the report generation and rendering time.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
• Subscribed SSRS reports utilizing standard and data driven subscription with a multitude of rendering formats such as pdf and excel for better content visualization.
• Collaborated with the Team Foundation Server to update project documents, scripts, and packages.

Tools: and EnvironmentSQL Server 2012, T-SQL, MS Excel, Erwin, SSDT, SSIS, SSRS, SQL Profiler, DTA, EDI, TFS, SharePoint, Power BI

Confidential, Dayton, OH

BI/Reports Developer

Responsibilities:

• Participated in JAD sessions to understand the scope of requirements and drafted functional requirement documents.
• Implemented database integrity per business requirement utilizing database constraints and triggers.
• Involved in normalization and de-normalization of test tables in both database and data warehouse environment for faster query retrieval.
• Incorporated database objects with T-SQL such as stored procedures, UDFs, triggers, and Indexes to create complex scripts and batches.
• Implemented error handing techniques such as 'Try Catch' to create robust T-SQL code.
• Improved performance with index analyses on tables and clustered and non-clustered indexes.
• Optimized queries with execution plan analyses, DMV queries, SQL debugger, SQL Profiler, and DTA.
• Designed and optimized complex stored procedures to perform data profiling and auditing in the pre-staging database.
• Designed mappings between sources and operational staging targets utilizing star schema.
• Successfully migrated data from different heterogeneous sources such as flat file, Excel and SQL Server utilizing SSIS, BCP and bulk insert in SSIS.
• Performed data profiling, cleansing, validation, and verification with SSIS tasks and SQL stored procedures in pre-staging and staging environment.
• Implemented master-child package models to improve the performance of the complex ETL strategy.
• Implemented SSIS packages utilizing checkpoint, logging, breakpoint, and transaction options.
• Deployed SSIS packages to multiple environments utilizing project deployment model.
• Created drill-down, drill-through, cascaded, sub, and parameterized reports in SSRS.
• Implemented an interface to organize reports, sort data sources, schedule report executions, and track report history.
• Created report snapshots and caches to improve performance, deployment, scheduling of reports.
• Deployed multiple types of reports in native and share point mode and utilized dashboards.

Tools: and EnvironmentSQL Server 2012, T-SQL, MS Excel, Erwin, SSDT, SSIS, SSRS, SQL Profiler, DTA, EDI, TFS

Confidential, Santa Ana, CA

ETL/SSRS Developer

Responsibilities:

• Used various approaches to collect the business requirements and worked with the business users and SMEs for ETL application enhancements by conducting various JAD sessions.
• Created stored procedures, triggers, and user-defined functions to implement complex business logic and functionality of various modules using T-SQL.
• Created complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data marts and reporting database.
• Worked on the optimization and restructuring of stored procedures for the application by evaluating indexing and partitioning large tables.
• Implemented transactions with multiple isolation levels and locks technique to avoid dirty reads and deadlocks.
• Analyzed existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Enhanced the existing data warehouse utilizing star schema and Inmon methodologies.
• Created and formatted ad-hoc, parameterized, drill down, and drill through reports with parameters.
• Rendered reports to several file formats such as PDF, Image, and Excel according to the needs of management.
• Designed and created report templates, bar graphs, and pie charts based on financial data.
• Implemented report deliveries and backup schedules with subscription configurations and snapshots.
• Worked on Team Foundation Server (TFS) to synchronize the data with different-2 sources and for version control.

Tools: and EnvironmentSQL Server 2012, T-SQL, MS Excel, Erwin, SSDT, SSIS, SSRS, SQL Profiler, DTA, EDI, TFS, SharePoint

Confidential, Irvine, CA

DWH/Reports Developer

Responsibilities:

• Gathered business requirements to facilitate planning and implementation phases of the data mart.
• Developed database objects like tables, stored procedures, indexes, functions in SQL Server 2012.
• Created stored procedures to perform index maintenance and data profiling for loading data marts.
• Optimized existing queries with stored procedures, parameter sniffing, execution plans and statistics.
• Analyzed source OLTP systems and created data mapping documents for the ETL process.
• Designed an ETL architecture for data migration from the OLTP to OLAP with the help of SSIS.
• Implemented an incremental load strategy with checksum and CDC techniques.
• Created SSIS packages for data scrubbing, aggregating, and cleansing with multiple tasks/transformations.
• Developed ad-hoc, parameterized, drill-down, and drill-through reports with parameters in SSRS.
• Automated report deliveries to multiple recipients with subscriptions in SSRS.
• Developed complex reports with multiple datasets and sources in SSRS.
• Formatted reports with parameters and embedded functions with expressions.
• Worked on Team Foundation Server to synchronize the data with different-2 sources as well.

Tools: and EnvironmentSQL Server 2012, T-SQL, MS Excel, Erwin, BIDS, SSIS, SSRS, SharePoint, EDI, SQL Profiler, TFS.

Confidential, Franklin Lakes, NJ

SQL/Reports Developer

Responsibilities:

• Enhanced and implemented pre-existing logical and physical database.
• Created tables, views, stored procedures and indexes in support of various databases and ETL applications.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Identified all conformed dimensions and facts to be included within the target OLAP system
• Developed SSIS packages to migrate data between OLTP servers and the data mart.
• Improved the performance of SSIS packages with non-blocking transformations and multiple properties.
• Generated reports utilizing relational databases and OLAP cubes.
• Created various reports (such as drilldown, drill through, chart, and freeform) with reporting services.
• Delivered reports with standard and data-driven subscriptions.
• Optimized SSRS reports with snapshots, caches, execution log views, embedded queries, and stored procedures.
• Used TFS for version control for updating in database in a Team.

Tools: and EnvironmentSQL Server 2008 R2/2012, T-SQL, MS Excel, Erwin, BIDS, SSIS, SSRS, SharePoint, Power Pivot.

Confidential, Philadelphia, PA

ETL/DW Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis.
• Prepared business requirement documents and converted business requirements into technical requirement specifications.
• Worked in conjunction with the data warehouse architect on the development of logical data models.
• Extensively used System as well as User-Defined functions to enhance the functionality of T-SQL code.
• Wrote complex stored procedures for Data Profiling, Backup the databases as well as handling the index fragmentation.
• Implemented error handling techniques like try catch blocks, error functions in T-SQL scripts and stored procedures to support the applications.
• Implemented Type 1 and Type 2 Slowly Changing Dimensions for Incremental load.
• Provided inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Developed SSIS packages for performing data cleansing operations with various transformations such as derived column, data conversion and fuzzy lookup.
• Involved in the troubleshooting of SSIS Packages, managing their configurations to transfer data from production to other databases.
• Optimized the performance of slow executing SSIS packages by making changes in control flow and data flow such as avoiding blocking transformations and increasing buffer size.

Tools: and EnvironmentSQL Server 2008 R2, T-SQL, MS Excel, Erwin, BIDS, SSIS, SSRS, SharePoint, Power Pivot.

Confidential, Mclean, Virginia

SQL Database Developer

Responsibilities:

• Interacted with business users for business requirements enhancement through JAD sessions.
• Created all data base objects like tables, views, stored procedures and indexes with optimization in point of view in support of the databases.
• Captured and documented data business rules and definitions.
• Involved in designing and developing efficient ETL strategy to integrate existing and new data into newly created Data Warehouse.
• Involved in designing and applying constraints and rules for data integrity.
• Created Indexes and Views on various entities of the databases.
• Optimized procedures and functions utilized by ETL Packages to reduce ETL Process time.
• Created cover indexes and applied various work around methods to help improve processing time of ETL.
• Involved in debugging of packages with help of breakpoints, checkpoints, event handlers and loggings.
• Involved in developing package configurations to test packages on different servers.

Tools: and EnvironmentSQL Server 2008 R2/2008, T-SQL, MS Excel, Erwin, BIDS, SSIS, SSRS, SharePoint, Power Pivot.

Confidential, Reinbeck, IA

SQL Developer

Responsibilities:

• Created SQL automation scripts for multiple database objects including tables, functions, procedures, PKs, FKs, triggers, and indexes.
• Created High level Normalized Database and Detail Design using Erwin.
• Wrote stored procedures, tables, triggers, indexes and views using Detailed Design Specifications.
• Fine-tuned queries, assigned proper Indexes for better performance.
• Used BCP and SSIS utility for Meta data transfer across servers.
• Implementation of MS SQL database Replications methodologies.
• Configuration of client workstation with client operating system.
• Prepared trace files using SQL profiler to fine tune the application
• Used visual source safe as configuration management tool.
• Provided training sessions to the SQL developers to maintain the application integrity

Tools: and EnvironmentSQL Server 2008/2005, T-SQL, MS Excel, Erwin, BIDS, SSIS, SSRS, SharePoint, Power Pivot.