We provide IT Staff Augmentation Services!

Sql/bi Developer Resume

Scottsdale, AZ

SUMMARY:

  • Over 7 years of experience in SQL Development, BI Development (SSIS, SSAS, SSRS) involving the Design, Development & Support of MS SQL Server 2008/2008R2/2012 in production, staging and development environments. Experience within multiple industries such as finance, mortgage, and healthcare.

TECHNICAL SKILLS:

Database: MS - SQL Server 2012/2008R2/2008/Azure SQL

T-SQL: Programming, Dynamic SQL

Data Modeling: Erwin

BI Tools: Power BI, Power Pivot, Tableau

Integration Services: (SSIS)

Analysis Services: (SSAS, OLAP Cubes)

Reporting Services: (SSRS, Report Builder)

Development Tools: BIDS, SSDT, SSMS

Source Control: Team Foundation Server (TFS)

SharePoint: 2013/2010, PerformancePoint Services

Microsoft Azure: Cloud Services (PaaS & IaaS)

PowerShell: Azure SQL Database (PaaS)

Azure Storages: (Blobs, Tables, Queues)

Backup/Recovery: Azure Data Factory Azure Data Warehouse

SDLC: Agile, Scrum, Waterfall, and Spiral

Programming Language: C#.Net, ASP.Net with MVC, HTML, CSS, JavaScript

PROFESSIONAL EXPERIENCE:

Confidential, Scottsdale, AZ

SQL/BI Developer

Technical Environment: MS SQL Server 2012, TSQL, SSIS, SSRS, SSAS, Erwin, SQL Profiler, Power BI, Azure, Excel, Tableau, Share Point

Responsibilities:

  • Collaborated in creation/modification/ review of functional requirement specifications and supporting documents during data modeling phase utilizing Agile methodology.
  • Implemented bottom up approach for dimension modeling during the DWH modeling.
  • Collaborated with business analyst and SMEs during the conceptual and logical modeling.
  • Wrote and redesigned stored procedures for existing OLTP and target DataMart during the data profiling and cleansing phase in staging and prestaging area.
  • Created complex stored procedures with proper error handling, transactions and performance tuning features.
  • Redesigned indexes to speed up query performance and utilized database engine tuning advisor for further suggestions.
  • Created Triggers to enforce user defined integrity as per the business logic.
  • Managed (enable/ disable/ fragmentation) Indexes during DataMart incremental load from staging area.
  • Wrote various TSQL scripts utilizing stored procedures, views, Temp objects (Temp table, Table variables, CTE, and UDFs) per business needs.
  • Created new and simplified existing SSIS packages for their performance tuning utilizing master-child environment, checkpoint, avoiding blocking transformation, containers, expressions, custom logging, and event handlers
  • Implemented Project deployment model utilizing parameter and integration service catalog mapping with different environments.
  • Designed SSAS cubes and created attribute relationships for optimal MDX query performance of Hierarchies and fact dimensions
  • Designed drill through, drill down, linked, sub reports and parameterized reports utilizing SSRS.
  • Designed various graphical dashboards with map, slicer, bar chart, line/area chart and various filter utilizing Power BI.
  • Wrote various calculated measures and columns per business logic for the reports utilizing Power BI.
  • Scheduled the automatic data refresh from data source utilizing Power BI Gateway.
  • Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
  • Formatted the reports by applying parameters, assigned parameter defaults and data types and extended reports.
  • Collaborated with Team foundation server for source control and version control within the team.

Confidential, Los Angeles area, CA

SQL/BI Developer

Technical Environment: MS SQL Server 2012, TSQL, SSIS, SSAS, SSRS, Erwin, SQL Profiler, Excel, Tableau, Share Point

Responsibilities:

  • Designed logical and physical model of the database utilizing Erwin.
  • Created complex SQL Stored Procedures, triggers and user defined functions to manage incoming data as well as to support existing applications.
  • Supported advanced efficient data retrieval and manipulation by creating indexed view with triggers.
  • Successfully implemented indexes on tables and views for optimum performance tuning.
  • Implemented error handling on existing queries and stored procedures to enhance debugging.
  • Supported some business specific relationships, and advance constraints by embedding triggers on tables.
  • Executed test cases that were used for validating the converted system.
  • Wrote, revised, and verified test cases that were used for future testing of the software, ensuring that future releases maintained the same level of quality, and ensuring quality consistency.
  • Created jobs and alters to execute SSIS packages automatically as well for reporting services.
  • Created different roles and users for reporting services; created jobs for subscriptions to deliver reports to higher authorities.
  • Interacted with business users and managers and gathered the database needs of the various business groups for reporting purposes.
  • Redesigned various reports, chart reports (line and column), parameterized reports for performance analysis.

Confidential, Plantation, FL

SQL/Report Developer

Technical Environment: MS SQL Server 2012, Erwin, TSQL, SSDT (SSIS, SSAS, SSRS), Tableau, TFS

Responsibilities:

  • Interpreted technical and function specifications based on the project requirements in JRD meetings.
  • Developed/modified T-SQL queries utilizing stored procedures, function, CTE, Indexes and views.
  • Developed queries on the data mart for reporting needs.
  • Implemented master-child package environment to manage large ETL projects.
  • Organized and tuned the SSIS packages utilizing event handlers, loggings, and row redirect to resolve errors.
  • Optimized SSIS packages utilizing parallelisms, fast load options, buffer sizes, and checkpoints.
  • Incorporated package configurations such as XML files and environment variables to improve compatibility.
  • Created SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies.
  • Generated Tableau dashboards with forecast and reference lines.
  • Generated tableau dashboards with combination charts for clear understanding.
  • Generated dashboards with groups and sets to handle views more efficiently.
  • Designed ad-hoc SSRS reports in the test environment for data validation utilizing SSRS.

Confidential, New Bedford, MA

SQL Developer

Technical Environment: MS SQL Server 2008/2008 R2, Erwin, TSQL, BIDS (SSIS, SSAS, SSRS), TFS

Responsibilities:

  • Designed ETL mappings documents for newly introduced services for DataMart between sources, staging, and targets with star schema.
  • Converted existing sql scripts into stored procedures to make efficient and implemented with compile option to avoid parameter sniffing situation.
  • Developed and optimized T-SQL code, including database scripts, triggers and stored procedures for multiple applications.
  • Developed Microsoft SQL Server SSIS packages to implement ETL requirements.
  • Developed, enforced and maintained database standards per business requirements.
  • Created SSIS packages utilizing various task and transformations, optimized existing packages utilizing checkpoint, custom logging and event handlers.
  • Defined the referenced relationships with the measure groups and fact tables at data source view level.
  • Created measures groups, aggregation, named set, named calculation, KPIs and multiple dimension hierarchies for existing and newly created SSAS cube.
  • Implemented report delivery utilizing report subscription such as data driven and standard through email and windows folder.
  • Collaborated in report generation utilized SSRS and Excel services and deployed them on report server.

Confidential, Emeryville, CA

Database Developer

Technical Environment: SQL Server 2008/2008 R2, BIDS, SSIS, SSRS, TSQL, Erwin

Responsibilities:

  • Analysed business and user needs with business analyst, documentation of requirements, and translated into system and functional requirement specifications.
  • Collaborated with team lead in providing product training to internal IT/dev/QA teams.
  • Wrote different sql scripts to implement the business logic utilizing joins, sub queries, stored procedures and UDFs.
  • Modified existing SSIS packages utilizing checkpoint, logging, breakpoint, and error handling options.
  • Designed and modified dataset for reports utilized MS SQL Server Reporting Services (SSRS).
  • Developed complex reports such as drill capabilities, master detail, and cross tab.

Confidential, Franklin, TN

BI Developer

Technical Environment: SQL Server 2008, BIDS, TSQL, Erwin

Responsibilities:

  • Created various SQL scripts for existing OLTP system.
  • Developed processes to manage database DDL & DML changes.
  • Reviewed database changes requested by development and operational staff.
  • Provided support in resolving database issues in production environment.
  • Collaborated with QA testers and cross-functional teams to build robust database changes.
  • Identified and determined solutions to obstacles during the major release or patch deployments.
  • Participated in the research and evaluation of new/additional software tools to assist database development.

Hire Now