We provide IT Staff Augmentation Services!

Bi Developer Resume

Dallas, TX

SUMMARY:

  • Competitive and versatile consultant with over 6 years of experience in designing and development of database/BI application using MS SQL Server, MS BI Stack, Power BI, and Tableau.
  • Experience within multiple industries such as banking, pharmaceutical, technology, and hospitality.

TECHNICAL SKILLS:

Databases: MS SQL Server 2008, 2008R2, 2012T - SQL Programming, Dynamic SQL

Data Modeling: Erwin, MS Visio

Development Tools: BIDS, SSDT, SSMS

Integration: Services (SSIS)

Analysis Services: (SSAS, OLAP Cubes, Tabular Model)

Reporting Services: (SSRS, Report Builder)

BI Tools: Power BI, Tableau

Source Control: Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

BI Developer

Tools: and Environment: SQL Server 2012, T-SQL, SSMS, SSDT, Erwin, SSIS, SSAS, SSRS, SharePoint, Power BI, TFS, MS Azure, Data Factory

Responsibilities:

  • Gathered requirements and specifications via JRD sessions.
  • Created design document for the entire project; included table structures and design logics.
  • Created tables, views, stored procedures, functions, CTEs and indexes to support database and ETL applications.
  • Incorporated suggestions from DTA by running the trace from SQL profiler on indexing and partitions.
  • Created dimensional model using multiple facts and dimensions with star schema.
  • Created strategies for data validation and data verification in staging databases.
  • Mapped data from various source systems into target staging database.
  • Utilized SSIS transformations such as conditional split, derived column, fuzzy grouping, fuzzy lookup to validate data.
  • Maintained historical data in newly populated data mart utilizing slowly changing dimensions.
  • Designed multi-dimensional cubes by building attribute relationships and dimension hierarchies.
  • Created KPI’s, calculated measures and named sets utilizing Multi-dimensional expressions (MDX).
  • Built Tabular cubes for minimal data analysis.
  • Customized calculations and KPI’s utilizing data analysis expressions (DAX).
  • Optimized Multi-dimensional cubes by assigning appropriate storage modes to partitions and usage based optimizations.
  • Created sub, drill-down, drill through, parameterized, summary, and matrix reports in SSRS.
  • Checked for rendering issues when a report is exported in Excel, CSV and PDF formats.
  • Improved response time on report server by enabling snapshots, subscriptions, and report caching.
  • Developed dashboards with Power BI which display key KPIs for business analysis and decision making.
  • Created database on cloud for required users as per business requirement utilizing MS Azure.
  • Managed different versions of code, reports, packages, cubes and distribute them to different teams in the organization utilizing TFS.
Confidential, Richmond, VA

BI Developer

Tools: and Environment: Microsoft SQL Server 2012, SSDT, SSMS, T-SQL, SSIS, SSAS, SSRS, Power BI, Erwin, TFS, DAX, MDX, Excel, SQL Profiler, DTA

Responsibilities:

  • Collaborated with multiple teams to gather requirements via JRD meetings.
  • Removed redundant data from tables utilizing Normalization.
  • Created stored procedures and complex queries to implement the business logic.
  • Implemented error handling on database utilizing try catch blocks, @@error, THROW () and Raiserror ().
  • Improved query performance by eliminating key and RID look up operators from the execution plan.
  • Avoided locking and blocking queries by utilizing appropriate locks and isolation levels.
  • Performed data profiling and data cleansing on OLTP database systems and loaded data in prestaging DB.
  • Handled SSIS package errors utilizing error logs, breakpoints, checkpoints, and data viewers.
  • Enhanced existing SSAS multidimensional cubes by adding new hierarchies, KPI’s and calculations.
  • Created cube actions (drill through and reporting actions) utilizing multi-dimensional expressions (MDX).
  • Customized aggregations, added new columns to existing tables utilizing DAX.
  • Created various SSRS reports such as drill down, drill through, and cascaded parameterized.
  • Modified MDX scripts in report datasets to add query parameters.
  • Scheduled reports for daily, weekly, and monthly basis utilizing standard and data driven subscriptions.
  • Created rich visualized dashboards utilizing Power BI desktop.
  • Handled inactive relationships and many-to-many relationships utilizing bidirectional filters.
  • Modified m-code in Power query to populate new data tables and customized columns.
  • Employed bar charts, bubble charts, and Power map to answer business questions with Power BI.
  • Collaborated with Team Foundation Server to update project documents, scripts, packages and reports.
Confidential, Saint Louis, MO

SQL BI Developer

Tools: and Environment: SQL Server 2012, SSDT, SSIS, SSAS, SSRS, Erwin, SharePoint, TFS, Performance Point Services, SQL Profiler, DTA

Responsibilities:

  • Gathered business requirements of BI application via JRD meetings.
  • Yielded conceptual design of the OLAP database from functional requirement document via JAD sessions.
  • Implemented integrity constraints (such as referential integrity using primary and foreign key relationships).
  • Created various database objects such as Sprocs, UDF’s, Views based on the requirements.
  • Modified existing codes to add new columns, parameters as per requirements.
  • Created indexes on poorly running queries by checking execution plans.
  • Designed an efficient ETL strategy to load data from various sources (Flat File, Excel, SQL) to populate data mart.
  • Created packages utilizing merge, union all, conditional split, lookup and multicast transformations.
  • Implemented master-child package model for improved maintenance and performance of ETL strategy.
  • Handled runtime errors with event handlers, row redirects, check points, and loggings (SSIS and custom).
  • Optimized ETL packages by increasing the memory buffer size, fast load option and non-blocking transformations.
  • Deployed SSIS packages on different servers (Test, pre-prod, prod).
  • Built SSAS cubes to store aggregated data which is utilized for reporting applications.
  • Created user defined hierarchies, named queries, named calculations in SSAS.
  • Generated various types of reports such as drill down, drill through and reports with bookmarks and document map.
  • Created report level parameters to manage large volumes of data in SSRS.
  • Created shortcuts (Linked reports) on report manager for easy access to users.
  • Designed score cards with executive summary dashboards utilizing Performance Point Server Dashboard Designer.
  • Implemented TFS for version control and code distribution.
Confidential, IA

SQL/SSIS Developer

Tools: and Environment: MS SQL Server 2008/R2, SSMS, BIDS, SSIS, SSAS, SSRS, T-SQL, Excel, Erwin, Excel, TFS, DTA

Responsibilities:

  • Interacted with team members in weekly status and scrum meetings.
  • Transformed business requirements into technical requirement specifications.
  • Designed prototypes of the project with data flow diagrams and ER diagrams.
  • Created database objects such as UDFs, indexed views, clustered and non-clustered indexes.
  • Created constraints and triggers to ensure database consistency.
  • Optimized queries by modifying T-SQL queries and eliminate redundant data.
  • Transferred data from heterogeneous data sources (flat file, excel) to SQL Server with SSIS packages.
  • Utilized for loop containers to loop through different set of files from source server.
  • Designed SSIS packages utilizing union all, lookup, fuzzy grouping and fuzzy look up transformations.
  • Handled errors utilizing event handlers, redirecting rows and checkpoints.
  • Optimized cubes utilizing aggregations, user defined hierarchies and choosing appropriate storage mode (MOLAP).
  • Generated various reports such as drill down, drill through, cascading parameterized reports in SSRS.
  • Utilized expressions to handle conditional formatting in SSRS.
  • Optimized reports utilizing caching and snapshots based on frequency of usage in SSRS.
  • Scheduled report deliveries to multiple users utilizing subscriptions (standard/data driven).
Confidential, Englewood, CO

SQL Developer

Tools: and Environment:SQL Server 2008/R2, SSMS, T-SQL, SQL Profiler, DTA, Erwin, TFS

Responsibilities:

  • Converted business requirements into functional and non-functional requirements.
  • Followed design standards while creating database table, column, procedures and views.
  • Created logical and physical data models utilizing Erwin.
  • Reverse engineered existing database structures to add new tables in data models.
  • Created complex stored procedures and functions to support complex business and mathematical logics.
  • Fine-tuned stored procedures and scripts to improve performance.
  • Tracked deadlocks, stored procedure performance in SQL profiler events.
  • Maintained project related documents and scripts on TFS.

Hire Now