SEARCH

Sr. Business Intelligence Engineer Resume Example

Resume Score: 100%

Love this resume?Build Your Own Now
SR. BUSINESS INTELLIGENCE ENGINEER
Summary
  • Self-motivated and driven Software Engineer with a passion for technology and skilled with expertise in Data Warehousing, Data Analysis, Data Modeling, Advanced Reporting, Analytics, Databases and OLAP based technologies 
  • Over Seven years of experience in analysis, design, development, testing and implementation of Business Intelligence solutions and in all phases of Software Development Life Cycle
  • A self-starter willing to tackle new and challenging problems and possess excellent analytical, logical, interpersonal, communication and organizational skills combined with the ability to work in a fast-paced environment as an individual and as a team member
  • Worked extensively on Data warehousing, Data modeling, BI Reporting. Strong understanding of relational database design concepts and in-depth knowledge of Business Intelligence solutions, OLAP and ROLAP solutions
  • Experienced in Cloud Computing. Built an entirely new system which orchestrates data movement from local to AWS and back for Science Processor to work on the cloud and on-demand (Elastic Cloud Computing)
  • Worked on several R&D projects trying to improve performance and scalability of current products using Big Data technologies like HDFS, Apache Spark, Pig, Cassandra etc
  • Designed and developed BI platform to help explain complex Forecast and Optimization results Science engine generates for a Multi-Tenant SaaS Company from ground zero which is now licensed as a premium feature of the product
  • Built several Data warehouses to fit the reporting needs
  • Designed and developed many complex Multi-Tenant reports and dashboards
  • Expertise in Performance tuning of ETL workflows
  • Thorough knowledge of Ralph Kimball's Data Modeling concepts including Dimensional Modeling, Star and Snowflake schema, Slowly Changing Dimensions and Surrogate keys
  • Experienced in using modeling tools such as ERwin, and system specifications
  • Developed many complex, Ad-hoc, Active, Drill-through, Drill-down, Master-Detail, Burst and dashboard reports for various teams within the organization like Enterprise Planning, Clinical Trials and IT
  • Scrum development process, Agile and Waterfall methodologies
  • Good Exposure to interaction with the customer and clear understanding of business requirements and applications
  • Managed the delivery of data services for the 24x7 operational databases and enterprise data warehouse and managed global team in US, India and China on multiple implementation projects
  • Extensive experience writing SQL, T-SQL, PL-SQL
  • queries, Perl, Unix Shell scripting and Scala
Summary of Skills
  • ETL tools: Informatica, Data Manager
  • Reporting tools: Tableau, Microstrategy, IBM Cognos BI, Scientific Analytics
  • Languages: SQL, PL/SQL, VB Script, T-SQL, PLSQL, CGI-Perl, Unix Shell Scripting, Scala, R
  • RDBMS: MySQL, MS SQL server, Oracle, DB2, Teradata, and MS Access
  • NoSQL databases: Cassandra
  • Big Data Technologies: Pig, HDFS, Apache Spark
  • OLAP: SSAS
  • Data Modeling: Erwin, and Visio
  • Working knowledge on SAS and Matlab
  • Agile development methodologies
Experience
Sr. Business Intelligence Engineer
June 2011 to CurrentCompany Name - City, State
  • As a Sr. Business Intelligence Engineer, I work in a fast-paced start-up environment to ensure SignalDemand (Now PROS Inc.) continues to be mission critical and contributes quantifiable value to our customers' businesses
  • Designed and developed BI platform in a Multi-Tenant SaaS environment which is now licensed as a premium feature of the product
  • Designed and built a data model and complex ETL workflows which orchestrates and automates the entire movement and transformation of data. Where both Market data from external sources and Customer data are fed into Science Engine to generate Forecast and Optimized output. Then load data into Data Warehouse that fits the reporting needs to feed the Analytics
  • Designed and built a Data warehouse and Data Marts to fit the Analytics/Reporting needs and built over hundred complex Multi-Tenant Dashboards, charts and other reports
  • Maintain detailed documentation for ongoing knowledge management
  • Built a feature to track usage stats by implementation, by customer
  • Worked with the Science team to develop processes and tools to analyze, monitor and maintain the quality of the content in SignalDemand's applications
  • Designed and developed a smart and cost-efficient ETL process (Elastic Cloud Computing) which instantiates EC2 and RDS instances on AWS, extracts input data for Science Engine from PROS, deploys Science Code to EC2, kicks off the Science Forecast/Optimization jobs on EC2, loads data back into PROS database on-demand
  • Worked on building new generation of products to improve performance, scalability and ease of implementation using Big Data technologies like HDFS, Apache Spark, Pig, Cassandra etc
Business Intelligence consultant
January 2009 to June 2011Company Name - City, State
  • Gilead Sciences has worked to discover, develop and commercialize medications to advance the care of patients suffering from life-threatening diseases in areas of unmet medical need.
  • Gilead has about 3500 Finance BI power users all over the world who depend on their reports (Daily, Weekly and Monthly) which are generated from the BI data mart for the business analysis.
  • As the Business Intelligence Lead/Developer for Operations and Support at Gilead, I played a key role in handling the deliverables related to the ETL workflows, Reports and OLAP data cubes for various departments of the company like Finance, Sales Channel, Clinical Trials etc
  • Worked on various other independent development projects in Sales Channel, Commercial and Finance departments designing, developing data marts, complex reports, charts, scorecards and dashboards
  • Designed and developed complex multi-query, drill-thru, prompted, burst, union query, SQL joins, and tabular SQL reports using IBM Cognos
  • Responsible for the gap/data analysis, technical design, implementation and deliverables
  • Designed and developed various Power play transformer models and OLAP Cubes design with single and multiple data sources Responsible for server administration, performance tuning, deployment and report administration
  • Designed, developed and maintained the security, scheduling and deployment of the enterprise reports, charts and dashboards
  • Designed and developed various Metadata models using Framework Manager to fit in business needs for different departments within the company
  • Developed ETL builds, job streams using Data manager Played a key role in production issue resolution and helped users with missing data in the sales reports.
  • Also helped build key Sales reports for Enterprise Planning customers which help them make key business decisions during critical planning cycles
  • Provided user training on how to access, use and build their own adhoc BI reports using various tools like Query Studio etc
  • Responsible for the delivery of data services for the 24x7 operational databases and enterprise data warehouse.
  • Managed global team in US, China and India on multiple implementation projects
Intern
July 2007 to August 2007Company Name - City, State
  • Worked on a critical project, 'Downtime analysis' to analyze down times of an asphalt plant at Black lease, Abilene
  • Worked on designing an Analytics platform to help business users understand and analyze Production constraints, performance etc at various plants
  • Used PeopleSoft for Business Analysis purposes, built various BI reports as POC to present the data according to the business requirements
  • Worked as a crucial member of the team implementing BI enterprise solution for Vulcan Worked in the Quality Control and Testing Laboratory of the Vulcan Materials Company, testing the quality of various classes of the Asphalt mixes supplied for different companies Performed various tests like the Impact testing, the Dewalt test, Granularity test and also, percentage of asphalt test to determine the strength and its impact strength
  • Worked on the Design of various classes of Asphalt mixes.
Teaching Assistant
September 2006 to January 2007Company Name - City, State
  • Tutor for Engineering Drawing, Material Science and Crystal Reports classes
Education
Bachelor of Technology : Production Engineering, May 2006Kakatiya University - City, State, India
Master of Science : Mechanical Engineering, December 2008Texas Tech University - City, State, USA
Other interests
  • A Sports Fanatic. Love playing/watching Cricket, Tennis, Table Tennis, Volleyball etc
  • Love Adventure sports and also a Motorcycle hobbyist
Build Your Own Now

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.

Resume Overview

School Attended

  • Kakatiya University
  • Texas Tech University

Job Titles Held:

  • Sr. Business Intelligence Engineer
  • Business Intelligence consultant
  • Intern
  • Teaching Assistant

Degrees

  • Bachelor of Technology : Production Engineering , May 2006
    Master of Science : Mechanical Engineering , December 2008

Similar Resumes

View All
Sr.-Business-Intelligence-Manager-resume-sample

Sr. Business Intelligence Manager

Kirkland, Washington