We provide IT Staff Augmentation Services!

Msbi Developer Resume

Minneapolis, MN

SUMMARY:

  • Highly - motivated BI developer with over 8 years of experience in development of Business Intelligence applications.
  • Extensive experience in building OLTP and data warehouse applications using SQL Server and MS BI stack.
  • Comprehensive knowledge within multiple industries such as finance, Education, Insurance, healthcare, and banking.

TECHNICAL SKILLS:

MS SQL: Server 2005, 2008, 2008 R2, 2012, 2014

Business Intelligence Tools: SSIS/SSAS/SSRS, Power BI

Development Tools: SSMS, BIDS, SSDT

Design Tools: ERwin, MS Visio

SDLC: Agile, Scrum, Waterfall, and Spiral

Language: ASP.Net, ADO.Net, C#.Net, VB.Net, Classical ASP, HTML, Java Script, MVC, LINQ

Source Control: SharePoint, Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

MSBI Developer

Responsibilities:

  • Collaborated with Project Managers, Business Analysts, Developers and testers to discuss on project next steps and update within the team.
  • Converted business requirements into logic for query/script creation.
  • Dived into the initial set up for a new project within the company.
  • Translated business logics into entity relationship/data models per ETL specifications.
  • Created scripts within SSMS to look through, analyze and validate the data.
  • Designed CTEs for code management and for querying hierarchal data structures.
  • Designed ETL mapping document for business requirement using FRD documents.
  • Improved query performance by redesigning, managing indexing strategies and understanding execution plans.
  • Designed SSIS Packages to transfer data between servers and load data into OLAP database.
  • Created complex packages utilizing different transformations such as conditional splits and multicast.
  • Implemented script task and components in checking flat files inconsistencies using C# scripts.
  • Adapted advanced SSIS features such as event handlers, loggings, breakpoints, and data viewers for debugging
  • Implemented parameters in the SSIS packages to configure properties.
  • Managed reporting server, created ad-hoc, and designing reports from OLAP.
  • Deployed SSRS reports to the report server in native mode.
  • Managed security at server and report level in report manager.
  • Discovered bugs within the front-end application using different browsers and versions.
  • Completed tasks given little to no information/requirements based on the project needs.
  • Contributed during scrum meetings and sprint status’ about Jira stories, and bugs.

Technical Environment: SQL Server 2014, SSDT, Erwin, SSIS, SSAS, SSRS, .Net, Excel, Erwin, SQL Profiler, DTA

Confidential, Minneapolis, MN

SQL BI Developer

Responsibilities:

  • Participated in meetings with project managers, team leads, and analysts to gather business requirements.
  • Validated the system end-to-end testing to meet the approved functional requirements.
  • Prioritized requirements to be developed according to Agile methodology.
  • Provided IT support to the health systems and program administration division.
  • Assisted in the maintenance support of legacy programs and systems as determined by the IT manager.
  • Improved query processing with normalization and de-Normalization of existing tables as needed.
  • Developed stored procedures for .Net applications and SSDT (SQL Server Data Tools).
  • Performed dimensional modeling with ER-win; designed and built relational data mart utilizing Kimball approach.
  • Designed the ETL process to pull and populate data from OLTP sources to the data mart.
  • Created and deployed SSIS packages with different transformations such as fuzzy lookup, fuzzy grouping, and data conversion.
  • Designed and developed SSAS cubes with KPIs, aggregation, calculated members, and partitions for reporting.
  • Created sub, drill-down, summary, and matrix reports in SSRS.
  • Generated reports utilizing SSRS and Excel with power pivots.

Technical Environment: SQL Server 2014/2012, SSDT, Erwin, SSIS, SSAS, SSRS, .Net, Excel, Power Pivot

Confidential, Irvine, CA

SQL/ETL Developer

Responsibilities:

  • Analyzed and interpreted business requirements and specifications through all phases of the project development life cycle utilizing agile methodology.
  • Involved in the data movement between systems and validated the business requirements.
  • Created databases, tables, views, stored procedures, functions, and triggers.
  • Implemented joins and sub-queries which retrieve data from multiple tables.
  • Wrote CTEs and ranked functions to remove duplicate records in OLTP tables.
  • Managed consistent layout and interface in ASP.net web page utilizing master page concepts.
  • Implemented client-side scripting for autocomplete, tabs, validation, date picking, sorting, auto-submit, and other functions utilizing JavaScript.
  • Successfully managed the extraction transformation and loading (ETL) process by pulling large volumes of data from various data sources in SSIS.
  • Created different control flow elements (such as data flow task, bulk insert task, execute SQL task, script task, send mail task, and XML task).
  • Wrote VB.Net scripts for a custom logging for ETL packages.
  • Creating ad-hoc and parameterized reports in SQL server 2008 R2 / 2012 / 2014 Reporting Services.
  • Created various ad-hoc SQL queries for customer, executive management, and other reports (such as tables, matrix, and sub reports).
  • Formatted reports for various visual representations utilizing conditional formatting, report expression, and templates.
  • Collaborated with Microsoft Team Foundation Server and SharePoint to collaborate and publish.

Technical Environment: SQL Server 2014/2012/2008 R2, SSDT, Erwin, SSIS, SSAS, SSRS, TFS, SharePoint, ASP.Net, VB.Net.

Confidential, San Diego, CA

BI/Reports Developer

Responsibilities:

  • Assisted health services staff and business analysts to gather requirements, analyze the business, test, acquire metrics, and coordinate the project.
  • Implemented agile/scrum methodology to complete tasks, based on complexity levels.
  • Enhanced the functionality and performance of various SQL scripts and stored procedures utilizing UDFs, CTEs, and system stored procedures.
  • Optimized and restructured stored procedures for the application by evaluating execution plans, indexing, and partitioning large tables.
  • Implemented transactions with the appropriate isolation level for maximum resource utilization.
  • Created SSIS Packages for ETL process to load and transform data from flat files to the data warehouse.
  • Designed, created, and implemented complex ETL Strategies via SSIS Packages which extract data from multiple heterogeneous sources (such as flat files, Excel files).
  • Created package configurations to deploy in multiple environments such as development, testing, and production.
  • Created SSAS cubes by selecting proper user defined hierarchies, dimensions and aggregations.
  • Extended reports through invoking embedded functions and integrated assemblies with expressions.
  • Created report models from cubes and the data warehouse to create ad-hoc reports and chart reports with report builder.
  • Created analytical reports/dashboards from multidimensional models to identify critical KPIs utilizing Power Pivot.
  • Created drill down, drill through, sub, and linked reports in SSRS.
  • Managed subscriptions and authentication of reports.
  • Implemented security to manage user access to reports based on clearance level.

Technical Environment: MS SQL Server 2012, SSDT, SSIS, SSAS, SSRS, ER-win, VB.Net, HTML, Java Script, TFS, SharePoint 2010.

Confidential, San Diego, CA

SQL/SSIS Developer

Responsibilities:

  • Planned, coordinated, and monitored project levels of performance and activities to ensure project completion in time.
  • Designed conceptual, logical, and physical database models.
  • Wrote SQL queries to create tables, stored procedures, and triggers.
  • Implemented error handling in TSQL code using try-catch and error handling functions.
  • Monitored and tuned the performance of complex T-SQL queries and stored procedures; analyzed the execution plan.
  • Designed and developed ETL processes and SSIS packages for the entire project.
  • Developed SSIS packages to extract data from sources such as SQL Server OLTP, Excel, and Flat Files.
  • Created packages with multiple transformations such as data conversion, derived column, fuzzy lookup and fuzzy grouping to cleanse data and apply business rules
  • Managed and migrated SSIS packages in staging and pre-production environments.
  • Managed large reports which return a large quantity of records; optimized report performance utilizing techniques such as cascading parameters and filters.
  • Scheduled report deliveries in different formats such as PDF and Excel utilizing standard and data driven subscriptions in SSRS.
  • Utilized report manager to administer roles and security on reports.

Technical Environment: SQL Server 2008R2/2012, SSIS, SSRS, SQL Profiler, DTA, JavaScript, Share Point, ER-win.

Confidential, San Diego, CA

MSBI Developer

Responsibilities:

  • Analyzed business requirements to facilitate planning and implementation phases of the data mart.
  • Created stored procedures, triggers, user define functions, indexes, and views to support front-end applications.
  • Optimized T-SQL scripts, stored procedures, and ETL logic to improve loading and processing.
  • Optimized existing queries to improve performance utilizing profiler and execution plans.
  • Implemented SQL Profiler and Database Engine Tuning Advisor (DTA) to analyze and optimize the performance of workloads.
  • Created fact tables with multiple granularity levels and maintained fact table relations with alternate keys.
  • Extracted and loaded data from multiple sources (Excel, CSV, flat files, SQL Server, Oracle) to the staging area.
  • Performed data profiling, cleansing, validation, and verification with SSIS tasks and SQL stored procedures.
  • Developed new and modified existing SSIS packages, implementing auditing and error handling functions.
  • Created multiple layouts (such as matrix, tabular, chart, and Tablix) to display data in a grid format.
  • Developed multiple schedules to deliver reports to e-mails and shared directories; enabled snapshots, subscriptions, and caches to improve response times and reduce traffic to the report server.
  • Installed, configured, and managed report server; scheduled report deliveries via data-driven subscriptions in SSRS.

Technical Environment: SQL Server 2008/R2, SSIS, SSAS, SSRS, DTA, SQL Profiler, ER-win.

Confidential, San Diego, CA

SQL BI Developer

Responsibilities:

  • Gathered system requirements through end-user collaboration sessions.
  • Designed, developed, and implemented an ETL framework with SSIS, stored procedures, and functions to extract into SQL Server 2005.
  • Implemented the newly developed database into SQL Server 2008.
  • Facilitated data retrieval and manipulation by implementing views, procedures, triggers, and cursors.
  • Analyzed and tuned complex queries/stored procedures in SQL Server 2005 to improve execution and developed database structures.
  • Imported data from MS Access, MS Excel, and text files; consolidated data with SQL server 2005 in SSIS.
  • Provided back-end support for functional and performance testing.
  • Drafted all system documents with a user manual, flowcharts, and source code.
  • Performed data migration with MS Access, Excel, and text files; scheduled tasks in SSIS.

Technical Environment: SQL Server 2008/ R2, SSIS, SSRS, BIDS, ER-Win, SQL Profiler.

Confidential, San Diego, CA

SQL Developer

Responsibilities:

  • Designed stored procedures and complex queries to acquire the business logic and reporting standards.
  • Analyzed historical data and extracted required data to support managerial decisions.
  • Created various DB objects (to include: views, UDFs, stored procedures, cursors, and indexes) to meet functionality and performance standards.
  • Developed ETL data mapping documents and data dictionaries.
  • Designed cubes from relational data warehouses; created the KPI for the front-end team.
  • Created linked, sub, and parameterized reports in SQL Server Reporting Services (SSRS).
  • Implemented report models from cubes and the data warehouse to create ad-hoc reports with Report Builder.
  • Optimized report performance by modifying stored procedures, creating report snapshots, and caching reports.

Technical Environment: SQL Server 2005/2008, BIDS, MS Visio, ER-win

Hire Now