PROFESSIONAL SUMMARY:

Experienced professional with over 8 years of experience providing proven solutions in banking, healthcare, and technology industries using SQL Server and BI Stack. Proficient with developing well - designed technical solutions including experience within multiple phases of the project life cycle.

TECHNICAL SKILLS:

• SDLC: Agile, Scrum, Waterfall, and Spiral
• Databases: MS-SQL Server 2005, 2008, 2008R2, 2012, 2016
• T-SQL Programming, Dynamic SQL, C#
• Data Modeling: ER-win, MS Visio
• Business Intelligence Tools: Power BI
• Collaboration Tools: SharePoint
• Integration Services (SSIS)
• Analysis Services (SSAS, OLAP Cubes)
• Reporting Services (SSRS, Report Builder)
• Development Tools: BIDS, SSDT, SSMS
• Source Control: Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN / Dallas, TX

SQL/SSIS Developer

Responsibilities:

• Coordinated with the business analysts via JRD sessions to gather business requirements.
• Collaborated with reporting team to provide views best suitable for Tableau.
• Created automated SQL scripts to create database, import new client data from the master DB, normalize it and create views within a few minutes.
• Wrote SQL procedures and functions to provide custom functionalities per requirements.
• Created and maintained SQL databases for various clients with desirable structure and schemas for reporting.
• Created numerous SQL stored procedures to cleanse the incoming data.
• Optimized SQL stored procedures utilizing execution plan and creating indexes for better performance.
• Designed and developed new dimension data model by adding required dimensions and facts using star schema.
• Maintained Data import APIs for updates in client data or API itself on C#.
• Created staging databases for ETL process to perform data scrubbing operations before loading data into the destination.
• Developed SSIS packages to load data from various sources such as XML files, SQL databases, Web Service APIs.
• Employed BCP in packages for some clients for daily data pull.
• Created packages to room for decrypting client data files.
• Created SSIS packages for incremental loads utilizing checksum.
• Utilized event handlers (script task with C#.Net) and redirect error output in the ETL process to handle runtime errors.
• Configured SSIS packages using parameters and deployed them to Integration Services using push deployment.
• Monitored and debugged SSIS packages using log details, checkpoints, breakpoints, and data viewers.
• Helped reporting team to learn using simple packages for table updates and data input.
• Developed various types of complex SSRS reports such as Drill Down, Drill through, and Cross tab reports.
• Designed and created report templates, bar graphs and pie charts based on the OLAP data with SSRS.
• Designed SSRS reports with features such as document maps, actions, conditional formatting.
• Scheduled delivery of SSRS reports to multiple users through data driven subscription.
• Designed multiple dashboards with rich visualizations and slicers for data analysis utilizing Excel Power BI.
• Maintained version history of BI solutions using TFS.

Technical Environment: SQL Server 2008/2016, SSIS, SSMS, SSDT, Visual Studio 2017, Er-win, T-SQL, SQL Profiler, DTA, C#.

Confidential, Minneapolis, MN

ETL/SSIS Developer

Responsibilities:

• Took part in continues daily discussion with the business to capture the requirements.
• Collaborated with team members and manages to conclude the best way to tackle the requirement.
• Identified relative sources and relationships between the databases and tables to create the most efficient query.
• Created SQL stored procedures and functions to fetch the data for reporting purposes.
• Identified slow running SQL queries and tuned them utilizing join statements, index maintenance and replace by stored procedures.
• Optimized SQL stored procedures utilizing execution plan, parameter sniffing, and creating indexes for better performance.
• Implemented error handling and debugging process utilizing @@error, try-catch statement, and if-else statements in SQL.
• Created SSIS packages to import data files and create automated reports utilizing SQL agent.
• Optimized SSIS packages utilizing best guidelines, check points, and event handlers.
• Implemented custom logging on SSIS packages utilizing event handlers and script task for better error handling.
• Handled faulty data from vendors utilizing SSIS error handling and redirected rows and sent them back to vendors.
• Created multiple parameterized reports including the drill through feature.
• Scheduled SSRS reports utilizing subscription (such as standard and data driven).
• Optimized SSRS reports by optimizing data set, changing shared data set to embedded data set, caching, and snapshot.
• Designed strategies for securing SSRS reports depending upon the level of sensitivity of information that the report contained.
• Communicated the reports and packages with colleagues and business using TFS and deploying reports to SharePoint.
• Collaborated with team members utilizing TFS.

Technical Environment: SQL Server 2008/2012, Teradata, SSIS, SSRS, SSMS, SSDT, TFS.

Confidential, San Diego, CA

SQL/MSBI Developer

Responsibilities:

• Analyzed business requirements to document functional requirements.
• Assisted project manager in projecting time estimates for development phases.
• Created logical and physical data models using the ERwin data modeler tool.
• Responsible for identifying sources, creating a staging database, and data warehouse dimensional modeling.
• Implemented normalization and de-normalization of existing tables wherever needed for faster query processing.
• Created multiple database objects such as procedures, functions, and triggers.
• Wrote SQL scripts to perform data validation post data load process.
• Implemented SQL queries into stored procedures utilizing execution plan and indexes for better performance.
• Identified types of slowly changing dimensions required for the data mart.
• Generated scripts for fact and dimension tables to deploy in the production environment.
• Maintained data integrity by creating various integrity constraints.
• Managed ETL for extraction, transformation, and loading of data to the destination database.
• Developed mappings utilizing SSIS to transform data from multiple sources: Excel, Flat File, and SQL Server OLTP.
• Implemented SSIS packages with loggings and event handlers for error handling.
• Restructured ETL packages with optimized queries and proper transformations for faster data loading.
• Generated parameterized, cascading parameterized, drill down, and drill through reports using SSRS.
• Delivered on-demand SSRS reports in different rendering formats with standard and data driven subscriptions.
• Optimized embedded queries or stored procedures that generate SSRS reports.
• Created analytical reports and dashboards using Power View for managers to identify critical KPIs.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.

Technical Environment: SQL Server 2012, SSIS, SSRS, Power View, Power Pivot, SSMS, SSDT, ER-Win, TFS.

Confidential, San Diego, CA

BI Reports Developer

Responsibilities:

• Gathered requirements and specifications for data migration from existing system to OLAP database.
• Generated T SQL scripts for tables and relationships based on approved ER diagram.
• Developed stored procedures for performing various tasks on databases.
• Implemented execution plan, indexes and dynamic sql to optimize sql queries such as stored procedures and UDFs.
• Created scalar user defined functions to handle data issues in string fields.
• Implemented error handling in procedures utilizing try-catch block, and raiserror and throw functions.
• Created complex ETL packages to pull data from Oracle and MS Access into SQL server.
• Implemented event handlers, logging and error row redirect to handle run time errors on production server.
• Maintained master/child package model for flexible execution.
• Deployed SSIS packages to the production server utilizing project deployment model with parameter configuration.
• Adopted drill down, drill through, and parameter functionality for SSRS reports with multiple pages.
• Identified table columns required for report generation and created SQL scripts for SSRS report dataset.
• Developed best suitable user interface for management dashboards with Power Pivot.
• Implemented interactive sorting, document map, and bookmark features to enhance interactivity in SSRS reports.
• Scheduled the delivery of SSRS reports in different formats such as pdf and excel utilizing standard and data driven subscriptions in SSRS.
• Managed development work on Team Foundation Server (TFS).

Technical Environment: SQL Server 2012, SSDT, SSIS, SSRS, ERwin, MS Excel, Power Pivot, Power View, TFS

Confidential, Austin, TX

BI Developer

Responsibilities:

• Evaluated data in the source databases and mapped with OLAP destination.
• Analyzed the historical data and extracted required data to support the management decisions.
• Maintained required business logic with stored procedures, user defined functions, CTE and dynamic SQL.
• Optimized Sql queries utilizing execution plan, indexes and batch processing.
• Implemented incremental load utilizing CDC and checksum/timestamp.
• Designed SSIS packages to process SSAS cubes in differed processing modes.
• Deployed SSIS packages from development server to production server utilizing package deployment model.
• Created test cases for conducting unit tests on database objects and ETL packages.
• Created and deployed cubes depending on business needs for slicing and dicing of data.
• Allocated storage modes such as MOLAP, HOLAP and ROLAP based on data usage.
• Created report data models with Report builder for ad-hoc reporting.
• Created reports with filters, interactive sorting, and parameters.

Technical Environment: SQL Server 2008R2, SSIS, SSRS, BIDS, SQL Profiler, ERwin

Confidential, Richardson, TX

DWH Developer

Responsibilities:

• Interacted with business users to meet needs of both compliance regulations and business requirements.
• Encapsulated frequently used SQL queries into stored procedures or UDFs.
• Created multiple SSIS packages to migrate data from Excel and SQL Server sources.
• Designed several SSIS packages; included proper error handling, optimization, and configuration techniques.
• Migrated SSIS packages from staging to production environment.
• Automated ETL process with SQL Server Agent to execute packages during off hours.
• Deployed SSIS packages to multiple environments utilizing the functionality of package configurations.
• Created multiple reports for differing departments utilizing SQL scripts and stored procedures as data sets.
• Exported business data to Excel for further analysis utilizing Power Pivot.

Technical Environment: SQL Server 2008 R2, SSIS, SSRS, BIDS, SQL Profiler, MS Visual Studio, MS Excel

Confidential, San Ramon, CA

SQL Developer

Responsibilities:

• Documented database objects and SSIS packages.
• Created database objects such as procedures, functions, and views.
• Supported front end applications; created stored procedures and user defined functions to facilitate data entry.
• Implemented indexes on tables and views for optimum performance.
• Altered existing procedural objects to implement changed business logic.
• Maintained performance of SQL Server; including integrity checks, database statistics, and re-indexing.

Technical Environment: SQL Server 2008, SSMS, BIDS, SQL Profiler, MS Excel