Business Intelligence Engineer Resume Example
Love this resume?Build Your Own Now
BUSINESS INTELLIGENCE ENGINEER
Summary
Data Enthusiast with over 8 years of experience in Business Intelligence and Software Development focusing in Data conversion, ETL, Report, Data Analysis and dashboard development by providing custom data solutions utilizing Microsoft stack of ETL, programming and Business Intelligence tools.
Skills
|
|
Professional Overview
- Developed and Maintained Interactive Power BI dashboards and SSRS reports to showcase KPI's and performance metrics to clients and executive team
- Extensive experience in building End to End ETL pipelines utilizing SSIS, SQLServer
- Experience building processes to consume data from various sources, transform and load it into central data warehouses and databases.
- Developed Bulk load BCP processes utilizing data dictionaries to load data into databases from various file sources.
- Involved in requirement meetings with Business Analysts and stakeholders for OLTP and OLAP system design and development.
- Develop processes to load and refresh data into SSAS cubes.
- Developed OLAP data models utilizing Dimensional Modelling, Star and Snowflake Schema.
- Developed and tested stored procedures, function, CTE's, Views, Table Relationships.
- Experience in writing T-SQL stored procedures, Triggers, Constraints and Indexes using various DDL and DML statements.
- Experience in developing and maintaining workflows in SSIS for data transformations.
- Developed Application in C# to utilize API's and communicate with applications in AWS and Mainframe from relational database systems.
- Setup data refreshes for power BI dashboards utilizing gateway ways
- Setup T-SQL scripts to perform Automation tasks. Fine-tuned Queries, Stored Procedures and User Defined Functions
- Expertise in Extract, Transform and Load processes from various data sources to Microsoft Sql Server.
- Analyze and improve performance of ETL processes by utilizing query execution plans, setup tracing and logging.
- Communication with Business analysts and clients to implement new features and develop process to test the same.
- Constant communication with executive team and stakeholders to provide custom analytics dashboards and insights on the data.
- Engage in design meetings to get client requirements and develop the desired data models, dashboards and reports.
- Enhance existing business logic based on client specifications to transform data.
- Develop ETL processes to address new and changing requirements.
Experience
Business Intelligence Engineer | 02/2015 - CurrentAmazon.Com, Inc. - Shawnee , KS
- Provide Business insights and data analysis to the leadership team and Clients leveraging the data from multiple sources and utilizing the Business Intelligence tools such as Excel, Power BI dashboards and SSRS reports.
- Enhanced and maintained existing reports and dashboards using DAX, M Query and SQL
- Worked With Power BI REST API's to perform management tasks on Power BI objects like reports, datasets, and workspaces.
- Conversion/Migration of over 20 Million Subscribers from various billing systems to In house Billing System using ETL processes developed utilizing Microsoft SQL server(T-SQL) and SSIS.
- Develop and showcase the trends, performance metrics and KPI's to clients and executive team leveraging the transformed data.
- Optimized data gathering processes, analysis procedures and visualization strategies.
- Improved performance by optimizing stored procedures and table relationships utilizing execution plans.
- Developed and maintained data warehouse/data marts for various clients data by scheduling data refreshes periodically.
- Partnered with Business Analysis teams on understand and implement new specifications in data transformation and analysis.
- Data profiling and data cleaning using ETL processes to transform data from various formats and sources to a centralized location.
- Developed and Maintained SSAS cubes and Data marts(facts and dimensions) by following Kimball's dimensional modeling methodology(star and snowflake schema).
- Created Aggregates for faster query performance of the data cubes.
- Develop scripts in python to consume and clean data from html/xml documents.
- Help business analysts to develop complex procedures and queries for testing and validating the implemented features.
- Collaborated with quality, risk management and other teams to identify process improvement opportunities based on in-depth BI reviews.
- Educated users on correct interpretation of financial, statistical and qualitative data.
Business Intelligence Developer | 06/2014 - 02/2015Sequoia Benefits - San Mateo Or San Francisco , CA
- Developed dashboards and reports to visualize and showcase IVR call volume and trends in MS-Excel and SSRS.
- Developed and maintained sql server Data marts and data refreshes for analysis and visualization.
- Communication with Business Analysts and the leadership team to discuss new requirements and enhance existing SSRS reports.
- Created processes data cleansing, transformation and loading into relational databases.
- Design and develop relational and dimensional database models for building OLTP and OLAP systems.
- Created automated data refreshes in datamarts using Slowly Changing Dimension(SCD).
- Participate in design meetings for Business Intelligence Solutions.
- Improved query performances by utilizing execution plans and building indexes on tables and views.
- Conceived, developed and implemented wide range of BI solutions per requirement.
- Automate and Schedule data refreshes to load data marts using Autosys.
- Formulate adhoc-queries in T-SQL to help business analysts validate data.
- Collaborate with PM to develop new pricing recommendations for pricing and packaging services
- Updated tracking documents, generated different reports and gave presentations on findings.
- Collaborated with support team to assist client stakeholders with emergent technical issues and develop effective solutions.
- Used Git and SVN for source control
- Experience using Atlassian took kit for documentation, ticketing (Confluence, Jira) in Agile environment.
- Delivered software solutions consistent with product roadmap, release plan milestones and key performance indicators.
- Leveraged Agile methodologies to move development lifecycle rapidly through initial prototyping to enterprise-quality testing and final implementation.
ETL Developer | 08/2012 - 06/2014Abt Associates - Durham , NC
- Worked with Business teams to build reports and establish automated processes for large-scale data analysis utilizing SSRS.
- Collaborated with Business teams to define data extraction methodologies and data source tracking protocols.
- Utilized DDL and DML statements for creating and manipulating database objects and perform updates and retrieval tasks on the data.
- Developed stored procedures, cte's, user defined functions to implement business logic on incoming data and transform and load it to destination tables.
- Utilized analytical functions and window functions to derive financial calculations over time.
- Worked as part of project teams to coordinate database development and determine project scopes and limitations.
- Wrote and coded logical and physical database descriptions, specifying identifiers of database to management systems.
- Summarized conclusions of business intelligence analyses and presented findings at executive meetings.
- Educated users on correct interpretation of financial, statistical and qualitative data in SQL Server environment.
- Generated daily, monthly and annual reports to address short and long-term business intelligence questions.
- Show case KPI's and Metrics in reports and visualize performance over time.
- Assessed customer needs and goals through communication and system evaluations to modify existing databases for personalized customization.
- Contributed to development, planning and completion of project initiatives.
- Developed and updated all documentation related to database technologies for department.
- Wrote scripts and processes for data integration and bug fixes.
- Improved operations by working with team members and customers to find workable solutions.
Education
Jawaharlal Nehru Technological University - City | Bachelor of TechnologyInformation Technology, 05/2012
DISCLAIMER
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
Resume Strength
- Word choice
- Length
- Typos
Resume Overview
School Attended
- Jawaharlal Nehru Technological University
Job Titles Held:
- Business Intelligence Engineer
- Business Intelligence Developer
- ETL Developer
Degrees
- Jawaharlal Nehru Technological University - City | Bachelor of Technology
Similar Resumes
