resume

Not in love with this template? Browse our full library of resume templates

boy

Build your resume in 15 minutes

Use professional field-tested resume templates that follow the exact resume rules employers look for.
6

bi developer

  • Involved in Daily, Weekly Status Meetings with the team Members, PM and the Leads.
  • Wrote Complex SSRS Expressions and built the reports in Adhoc Tool called Report Builder.
  • Wrote SQL scripts and built reports in SSRS
  • Utilized derived tables, temporary tables and Common Table Expressions in SQL.
  • Developed complex reports with multiple datasets and heterogeneous sources and created the automation process of report generation and distribution in SSRS.
  • Exported data from SSRS report to several file formats likes PDF and Excel according to the needs of management.
  • Enhanced the Reports by updating the embedded Scripts in SSRS to the Stored Procedures.
7

bi developer

  • Improved data gathering, analysis and visualization procedures with strategic optimizations.
  • Responding to specific BI requests from Business Analyst personnel, creating data packets with requested information in easily understandable formats.
  • Participated in designing and implementing ETL/data pipeline on AWS platform using managed services
  • Writing scripts in Ruby/Python to collect data from various APIs 
8

senior bi developer

  • Design, develop and implement a Metadata Driven ETL Framework.
  • Extensive documentation of the end-to-end ETL processes, and technical “How-To” guides to assist in development resource induction.
  • Design and implement code management processes (including branching strategies) and build protocols.
  • Mentoring in-house development resources on the importance and benefits of ETL best-practices using TAFE’s chosen technologies (SSIS and T-SQL).
  • Support the solution architect in the design and implementation of an enterprise Data Warehouse.
  • Design and develop testing strategies for automated unit test of the ETL processes
  • Review physical infrastructure design, and sign-off of provisioning by IT services.
9

senior bi developer

  • Performance enhancements and re-engineering of existing ETL processing, including optimisation of TSQL views and stored procedures, as well as existing SSIS packages.
  • Design and optimisation of multidimensional OLAP cubes using SSAS.
  • Assistance in the review and documentation of the existing ETL framework.
  • Mentoring in-house BI development resources on the importance and benefits of sound ETL using technologies such as SSIS
  • Hosting data modelling workshops with technical resources and key business users to facilitate new data models.
  • Extensive documentation of end-to-end ETL processes and Technical Specifications, as well as design specifications through reverse engineering.
  • Assist in the technical Proof of Concept review of Microsoft APS as an alternative technology to the standard MS SQL relational database engine.
10

bi developer

  •  Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequence Container, Execute SQL Task, File System Task and Data Flow Task in Designing packages. 
  •  Involved in Transformations like Lookup, Derived Column, Conditional Split, Sort, Data Conversion, Union All, Merge Join and OLEDB Command while loading data into SQL Server destination. 
  •  Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers. 
  •  Monitored performance and optimized SQL queries for maximum efficiency 
  •   Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data. 
  •   Created indexed views and appropriate indexes to reduce the running time for complex queries. 
  •   In SSRS -Implemented drill through, sub reports, drill down, linked reports, main reports which links to all child reports, row by row colors, display values based on dynamic selection of  Parameters, cascading parameters, dynamic selection of monthly data, Lookup functions, shared data sets, subscriptions, etc.