Sr. Business Intelligence Engineer Resume Example PROS Inc (Previously Signaldemand Inc)

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 CurrentPROS Inc (Previously SignalDemand Inc) - San Francisco, California

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 2011Gilead Sciences - Foster City, California

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 2007Vulcan Materials - Abilene, Texas

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 2007Texas Tech University - Lubbock, Texas

Tutor for Engineering Drawing, Material Science and Crystal Reports classes

Education

Bachelor of Technology : Production Engineering, May 2006Kakatiya University - Warangal, Telangana, India

Master of Science : Mechanical Engineering, December 2008Texas Tech University - Lubbock, Texas, USA

Other interests

A Sports Fanatic. Love playing/watching Cricket, Tennis, Table Tennis, Volleyball etc
Love Adventure sports and also a Motorcycle hobbyist

Resume Overview

Companies Worked For:

PROS Inc (Previously SignalDemand Inc)
Gilead Sciences
Vulcan Materials
Texas Tech University

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

Sr. Business Intelligence Engineer Resume Example

Resume Score: 100%

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes